function Create()
{
$this->content = utf8_decode($this->_ParseHTML($this->content));
$pdf = new HTML2FPDF();
$pdf->ShowNOIMG_GIF();
$pdf->DisplayPreferences('HideWindowUI');
$pdf->AddPage();
$pdf->WriteHTML($this->content);
$pdf->Output(\Cx\Lib\FileSystem\FileSystem::replaceCharacters($this->title));
}
}
$plink = '<a href="' . $PHP_SELF . "?id=" . $_SESSION['id_ff_anp'][$i] . "&pga=" . $cPga . '">' . $cPgan . '</a>' . "\n";
echo " " . $plink;
}
echo " >>";
}
}
//pdf
?>
</td>
</tr>
</table>
</body>
</html>
<?php
if ($_GET[pdf] == 'ok') {
$htmlbuffer = ob_get_contents();
ob_end_clean();
header("Content-type: application/pdf");
$pdf = new HTML2FPDF();
$pdf->ubic_css = "../../style.css";
//agreg mio
$pdf->DisplayPreferences('HideWindowUI');
//$pdf->SetAutoPageBreak(false);
//$pdf->usetableheader=true; $pdf->Header('Objetivos Estrategicos'); //titulo
$pdf->AddPage();
//$pdf->SetFont('Arial','',12);
// $pdf->setBasePath("../../../");
$pdf->WriteHTML($htmlbuffer);
$pdf->Output('ficha_subactividad.pdf', 'D');
}
function DisplayPDF($smarty, $invoicetype, $template)
{
require_once 'pdf-invoices/html2pdf/html2fpdf.php';
$pdf = new HTML2FPDF();
$pdf->DisplayPreferences('HideWindowUI');
$pdf->AddPage();
$pdf->WriteHTML($this->GetHTML($smarty, $invoicetype, $template));
// TODO: find a better name
return $pdf->Output('Invoice_' . date("d/m/Y-H:i") . '.pdf', 'I');
}
function _print_pdf($file, $data)
{
require_once 'h2p/html2fpdf.php';
// agar dapat menggunakan fungsi-fungsi html2pdf
ob_start();
// memulai buffer
error_reporting(1);
// turn off warning for deprecated functions
$pdf = new HTML2FPDF();
// membuat objek HTML2PDF
$pdf->DisplayPreferences('Fullscreen');
$html = $data;
// mengambil data dengan format html, dan disimpan di variabel
ob_end_clean();
// mengakhiri buffer dan tidak menampilkan data dalam format html
$pdf->addPage();
// menambah halaman di file pdf
$pdf->WriteHTML($html);
// menuliskan data dengan format html ke file pdf
return $pdf->Output($file, 'D');
}
function EmailInvoice($id, $invoice_type = 1)
{
//getpost_ifset(array('customer', 'posted', 'Period', 'cardid','exporttype','choose_billperiod','id','invoice_type'));
if ($invoice_type == "") {
$invoice_type = 1;
}
if ($invoice_type == 1) {
$cardid = $id;
if ($cardid == "") {
exit("Invalid ID");
}
}
if ($invoice_type == 2) {
if ($id == "" || !is_numeric($id)) {
exit(gettext("Invalid ID"));
}
}
if ($invoice_type == 1) {
$invoice_heading = gettext("Unbilled Details");
$invocie_top_heading = gettext("Unbilled Invoice Details for Card Number");
} else {
$invoice_heading = gettext("Billed Details");
$invocie_top_heading = gettext("Billed Invoice Details for Card Number");
}
$DBHandle = DbConnect();
$num = 0;
if ($invoice_type == 1) {
$QUERY = "Select username, vat, t1.id from cc_card t1 where t1.id = {$cardid}";
} else {
$QUERY = "Select username, vat, t1.id from cc_card t1, cc_invoices t2 where t1.id = t2.cardid and t2.id = {$id}";
}
$res_user = $DBHandle->Execute($QUERY);
if ($res_user) {
$num = $res_user->RecordCount();
}
if ($num > 0) {
$userRecord = $res_user->fetchRow();
$customer = $userRecord[0];
$vat = $userRecord[1];
$customerID = $userRecord[2];
} else {
exit(gettext("No User found"));
}
if (!isset($current_page) || $current_page == "") {
$current_page = 0;
}
// this variable specifie the debug type (0 => nothing, 1 => sql result, 2 => boucle checking, 3 other value checking)
$FG_DEBUG = 0;
// The variable FG_TABLE_NAME define the table name to use
$FG_TABLE_NAME = "cc_call t1";
// The variable Var_col would define the col that we want show in your table
// First Name of the column in the html page, second name of the field
$FG_TABLE_COL = array();
$FG_TABLE_COL[] = array(gettext("Calldate"), "starttime", "18%", "center", "SORT", "19", "", "", "", "", "", "display_dateformat");
$FG_TABLE_COL[] = array(gettext("Source"), "src", "10%", "center", "SORT", "30");
$FG_TABLE_COL[] = array(gettext("Callednumber"), "calledstation", "18%", "right", "SORT", "30", "", "", "", "", "", "");
$FG_TABLE_COL[] = array(gettext("Destination"), "destination", "18%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix");
$FG_TABLE_COL[] = array(gettext("Duration"), "sessiontime", "8%", "center", "SORT", "30", "", "", "", "", "", "display_minute");
if (!(isset($customer) && $customer > 0) && !(isset($entercustomer) && $entercustomer > 0)) {
$FG_TABLE_COL[] = array(gettext("Cardused"), "username", "11%", "center", "SORT", "30");
}
$FG_TABLE_COL[] = array(gettext("Cost"), "sessionbill", "9%", "center", "SORT", "30", "", "", "", "", "", "display_2bill");
$FG_TABLE_DEFAULT_ORDER = "t1.starttime";
$FG_TABLE_DEFAULT_SENS = "DESC";
// This Variable store the argument for the SQL query
$FG_COL_QUERY = 't1.starttime, t1.src, t1.calledstation, t1.destination, t1.sessiontime ';
if (!(isset($customer) && $customer > 0) && !(isset($entercustomer) && $entercustomer > 0)) {
$FG_COL_QUERY .= ', t1.username';
}
$FG_COL_QUERY .= ', t1.sessionbill';
if (LINK_AUDIO_FILE == 'YES') {
$FG_COL_QUERY .= ', t1.uniqueid';
}
$FG_COL_QUERY_GRAPH = 't1.callstart, t1.duration';
// The variable LIMITE_DISPLAY define the limit of record to display by page
$FG_LIMITE_DISPLAY = 500;
// Number of column in the html table
$FG_NB_TABLE_COL = count($FG_TABLE_COL);
//This variable will store the total number of column
$FG_TOTAL_TABLE_COL = $FG_NB_TABLE_COL;
if ($FG_DELETION || $FG_EDITION) {
$FG_TOTAL_TABLE_COL++;
}
if ($FG_DEBUG == 3) {
echo "<br>Table : {$FG_TABLE_NAME} \t- \tCol_query : {$FG_COL_QUERY}";
}
$instance_table = new Table($FG_TABLE_NAME, $FG_COL_QUERY);
$instance_table_graph = new Table($FG_TABLE_NAME, $FG_COL_QUERY_GRAPH);
if (is_null($order) || is_null($sens)) {
$order = $FG_TABLE_DEFAULT_ORDER;
$sens = $FG_TABLE_DEFAULT_SENS;
}
if ($posted == 1) {
$SQLcmd = '';
$SQLcmd = do_field($SQLcmd, 'src', 'src');
$SQLcmd = do_field($SQLcmd, 'dst', 'calledstation');
}
$date_clause = '';
// Period (Month-Day)
if (DB_TYPE == "postgres") {
$UNIX_TIMESTAMP = "";
} else {
$UNIX_TIMESTAMP = "UNIX_TIMESTAMP";
}
$lastdayofmonth = date("t", strtotime($tostatsmonth . '-01'));
if ($Period == "Month") {
if ($frommonth && isset($fromstatsmonth)) {
$date_clause .= " AND {$UNIX_TIMESTAMP}(t1.starttime) >= {$UNIX_TIMESTAMP}('{$fromstatsmonth}-01')";
}
if ($tomonth && isset($tostatsmonth)) {
$date_clause .= " AND {$UNIX_TIMESTAMP}(t1.starttime) <= {$UNIX_TIMESTAMP}('" . $tostatsmonth . "-{$lastdayofmonth} 23:59:59')";
}
} else {
if ($fromday && isset($fromstatsday_sday) && isset($fromstatsmonth_sday) && isset($fromstatsmonth_shour) && isset($fromstatsmonth_smin)) {
$date_clause .= " AND {$UNIX_TIMESTAMP}(t1.starttime) >= {$UNIX_TIMESTAMP}('{$fromstatsmonth_sday}-{$fromstatsday_sday} {$fromstatsmonth_shour}:{$fromstatsmonth_smin}')";
}
if ($today && isset($tostatsday_sday) && isset($tostatsmonth_sday) && isset($tostatsmonth_shour) && isset($tostatsmonth_smin)) {
$date_clause .= " AND {$UNIX_TIMESTAMP}(t1.starttime) <= {$UNIX_TIMESTAMP}('{$tostatsmonth_sday}-" . sprintf("%02d", intval($tostatsday_sday)) . " {$tostatsmonth_shour}:{$tostatsmonth_smin}')";
}
}
if (strpos($SQLcmd, 'WHERE') > 0) {
$FG_TABLE_CLAUSE = substr($SQLcmd, 6) . $date_clause;
} elseif (strpos($date_clause, 'AND') > 0) {
$FG_TABLE_CLAUSE = substr($date_clause, 5);
}
if (isset($customer) && $customer > 0) {
if (strlen($FG_TABLE_CLAUSE) > 0) {
$FG_TABLE_CLAUSE .= " AND ";
}
$FG_TABLE_CLAUSE .= "t1.username='******'";
} else {
if (isset($entercustomer) && $entercustomer > 0) {
if (strlen($FG_TABLE_CLAUSE) > 0) {
$FG_TABLE_CLAUSE .= " AND ";
}
$FG_TABLE_CLAUSE .= "t1.username='******'";
}
}
if (strlen($FG_TABLE_CLAUSE) > 0) {
$FG_TABLE_CLAUSE .= " AND ";
}
if ($invoice_type == 1) {
$FG_TABLE_CLAUSE .= "t1.starttime >(Select CASE WHEN max(cover_enddate) IS NULL THEN '0001-01-01 01:00:00' ELSE max(cover_enddate) END from cc_invoices WHERE cardid = '{$cardid}')";
} else {
$FG_TABLE_CLAUSE .= "t1.starttime >(Select cover_startdate from cc_invoices where id ='{$id}') AND t1.stoptime <(Select cover_enddate from cc_invoices where id ='{$id}') ";
}
if (!$nodisplay) {
$list = $instance_table->Get_list($DBHandle, $FG_TABLE_CLAUSE, $order, $sens, null, null, $FG_LIMITE_DISPLAY, $current_page * $FG_LIMITE_DISPLAY);
}
$_SESSION["pr_sql_export"] = "SELECT {$FG_COL_QUERY} FROM {$FG_TABLE_NAME} WHERE {$FG_TABLE_CLAUSE}";
/************************/
$QUERY = "SELECT substring(t1.starttime,1,10) AS day, sum(t1.sessiontime) AS calltime, sum(t1.sessionbill) AS cost, count(*) as nbcall FROM {$FG_TABLE_NAME} WHERE " . $FG_TABLE_CLAUSE . " GROUP BY substring(t1.starttime,1,10) ORDER BY day";
//extract(DAY from calldate)
if (!$nodisplay) {
$list_total_day = $instance_table->SQLExec($DBHandle, $QUERY);
$nb_record = $instance_table->Table_count($DBHandle, $FG_TABLE_CLAUSE);
}
// GROUP BY DESTINATION FOR THE INVOICE
$QUERY = "SELECT destination, sum(t1.sessiontime) AS calltime, \n\tsum(t1.sessionbill) AS cost, count(*) as nbcall FROM {$FG_TABLE_NAME} WHERE " . $FG_TABLE_CLAUSE . " GROUP BY destination";
if (!$nodisplay) {
$list_total_destination = $instance_table->SQLExec($DBHandle, $QUERY);
}
//end IF nodisplay
/************************************************ DID Billing Section *********************************************/
// Fixed + Dial = 0 ; Fixed = 1 ; Dail = 2 ; Free = 3
// 1. Billing Type:: All DID Calls that have DID Type 0 and 2
if ($invoice_type == 1) {
$QUERY = "SELECT t1.amount, t1.creationdate, t1.description, t3.countryname, t2.did, t1.currency " . " FROM cc_charge t1 LEFT JOIN (cc_did t2, cc_country t3 ) ON ( t1.id_cc_did = t2.id AND t2.id_cc_country = t3.id ) " . " WHERE (t1.chargetype = 1 OR t1.chargetype = 2) AND t1.id_cc_card = " . $cardid . " AND t1.creationdate >(Select CASE WHEN max(cover_enddate) IS NULL THEN '0001-01-01 01:00:00' ELSE max(cover_enddate) END from cc_invoices)";
} else {
$QUERY = "SELECT t1.amount, t1.creationdate, t1.description, t3.countryname, t2.did, t1.currency " . " FROM cc_charge t1 LEFT JOIN (cc_did t2, cc_country t3 ) ON ( t1.id_cc_did = t2.id AND t2.id_cc_country = t3.id ) " . " WHERE (t1.chargetype = 2 OR t1.chargetype = 1) AND t1.id_cc_card = " . $customerID . " AND t1.creationdate > (Select cover_startdate from cc_invoices where id ='{$id}') AND t1.creationdate <(Select cover_enddate from cc_invoices where id ='{$id}')";
}
if (!$nodisplay) {
$list_total_did = $instance_table->SQLExec($DBHandle, $QUERY);
}
/*************************************************CHARGES SECTION START ************************************************/
// Charge Types
// Connection charge for DID setup = 1
// Monthly Charge for DID use = 2
// Subscription fee = 3
// Extra charge = 4
if ($invoice_type == 1) {
$QUERY = "SELECT t1.id_cc_card, t1.iduser, t1.creationdate, t1.amount, t1.chargetype, t1.id_cc_did, t1.currency, t1.description" . " FROM cc_charge t1, cc_card t2 WHERE (t1.chargetype <> 1 AND t1.chargetype <> 2) " . " AND t2.username = '******' AND t1.id_cc_card = t2.id AND t1.creationdate >= (Select CASE WHEN max(cover_enddate) is NULL " . " THEN '0001-01-01 01:00:00' ELSE max(cover_enddate) END from cc_invoices) Order by t1.creationdate";
} else {
$QUERY = "SELECT t1.id_cc_card, t1.iduser, t1.creationdate, t1.amount, t1.chargetype, t1.id_cc_did, t1.currency, t1.description" . " FROM cc_charge t1, cc_card t2 WHERE (t1.chargetype <> 2 AND t1.chargetype <> 1)" . " AND t2.username = '******' AND t1.id_cc_card = t2.id AND " . " t1.creationdate >(Select cover_startdate from cc_invoices where id ='{$id}') " . " AND t1.creationdate <(Select cover_enddate from cc_invoices where id ='{$id}')";
}
if (!$nodisplay) {
$list_total_charges = $instance_table->SQLExec($DBHandle, $QUERY);
}
/*************************************************CHARGES SECTION END ************************************************/
if ($nb_record <= $FG_LIMITE_DISPLAY) {
$nb_record_max = 1;
} else {
if ($nb_record % $FG_LIMITE_DISPLAY == 0) {
$nb_record_max = intval($nb_record / $FG_LIMITE_DISPLAY);
} else {
$nb_record_max = intval($nb_record / $FG_LIMITE_DISPLAY) + 1;
}
}
/*************************************************************/
if (isset($customer) && $customer > 0 || isset($entercustomer) && $entercustomer > 0) {
$FG_TABLE_CLAUSE = "";
if (isset($customer) && $customer > 0) {
$FG_TABLE_CLAUSE = " username='******' ";
} elseif (isset($entercustomer) && $entercustomer > 0) {
$FG_TABLE_CLAUSE = " username='******' ";
}
$instance_table_customer = new Table("cc_card", "id, username, lastname, firstname, address, city, state, country, zipcode, phone, email, fax, activated, creationdate");
$info_customer = $instance_table_customer->Get_list($DBHandle, $FG_TABLE_CLAUSE, "id", "ASC", null, null, null, null);
}
if ($invoice_type == 1) {
$QUERY = "Select CASE WHEN max(cover_enddate) is NULL THEN '0001-01-01 01:00:00' ELSE max(cover_enddate) END from cc_invoices WHERE cardid = " . $cardid;
} else {
$QUERY = "Select cover_enddate,cover_startdate from cc_invoices where id ='{$id}'";
}
if (!$nodisplay) {
$invoice_dates = $instance_table->SQLExec($DBHandle, $QUERY);
if ($invoice_dates[0][0] == '0001-01-01 01:00:00') {
$invoice_dates[0][0] = $info_customer[0][13];
}
}
require '../Public/pdf-invoices/html2pdf/html2fpdf.php';
ob_start();
$currencies_list = get_currencies();
//For DID DIAL & Fixed + Dial
$totalcost = 0;
if (is_array($list_total_destination) && count($list_total_destination) > 0) {
$mmax = 0;
$totalcall = 0;
$totalminutes = 0;
foreach ($list_total_destination as $data) {
if ($mmax < $data[1]) {
$mmax = $data[1];
}
$totalcall += $data[3];
$totalminutes += $data[1];
$totalcost += $data[2];
}
}
?>
<table cellpadding="0" align="center">
<tr>
<td align="center">
<img src="<?php
echo Images_Path;
?>
/asterisk01.jpg" align="middle">
</td>
</tr>
</table>
<br>
<center><h4><font color="#FF0000"><?php
echo $invocie_top_heading;
?>
<?php
echo $info_customer[0][1];
?>
</font></h4></center>
<br>
<br>
<table cellspacing="0" cellpadding="2" align="center" width="80%" >
<tr>
<td colspan="2" bgcolor="#FFFFCC"><font size="5" color="#FF0000"><?php
echo $invoice_heading;
?>
</font></td>
</tr>
<tr>
<td valign="top" colspan="2"></td>
</tr>
<tr>
<td width="35%"> </td>
<td > </td>
</tr>
<tr>
<td width="35%" ><font color="#003399"><?php
echo gettext("Name");
?>
:</font> </td>
<td ><font color="#003399"><?php
echo $info_customer[0][3] . " " . $info_customer[0][2];
?>
</font></td>
</tr>
<tr>
<td width="35%" ><font color="#003399"><?php
echo gettext("Card Number");
?>
:</font></td>
<td ><font color="#003399"><?php
echo $info_customer[0][1];
?>
</font> </td>
</tr>
<?php
if ($invoice_type == 1) {
?>
<tr>
<td width="35%" ><font color="#003399"><?php
echo gettext("From Date");
?>
:</font></td>
<td><font color="#003399"><?php
echo display_dateonly($invoice_dates[0][0]);
?>
</font></td>
</tr>
<?php
} else {
?>
<tr>
<td width="35%" ><font color="#003399"><?php
echo gettext("From Date");
?>
:</font></td>
<td ><font color="#003399"><?php
echo display_dateonly($invoice_dates[0][1]);
?>
</font></td>
</tr>
<tr>
<td width="35%" ><font color="#003399"><?php
echo gettext("To Date");
?>
:</font></td>
<td><font color="#003399"><?php
echo display_dateonly($invoice_dates[0][0]);
?>
</font></td>
</tr>
<?php
}
?>
</table>
<table align="center" width="80%">
<?php
if (is_array($list_total_destination) && count($list_total_destination) > 0) {
?>
<tr>
<td colspan="4" align="center"><font> <b><?php
echo gettext("By Destination");
?>
</b></font> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="29%"><font color="#003399"><b><?php
echo gettext("Destination");
?>
</b></font></td>
<td width="38%" ><font color="#003399"><b><?php
echo gettext("Duration");
?>
</b></font> </td>
<td width="12%" align="center" ><font color="#003399"><b><?php
echo gettext("Calls");
?>
</b></font></td>
<td align="right"><font color="#003399"><b><?php
echo gettext("Amount") . " (" . BASE_CURRENCY . ")";
?>
</b></font></td>
</tr>
<?php
$i = 0;
foreach ($list_total_destination as $data) {
$i = ($i + 1) % 2;
$tmc = $data[1] / $data[3];
if (!isset($resulttype) || $resulttype == "min") {
$tmc = sprintf("%02d", intval($tmc / 60)) . ":" . sprintf("%02d", intval($tmc % 60));
} else {
$tmc = intval($tmc);
}
if (!isset($resulttype) || $resulttype == "min") {
$minutes = sprintf("%02d", intval($data[1] / 60)) . ":" . sprintf("%02d", intval($data[1] % 60));
} else {
$minutes = $data[1];
}
if ($mmax > 0) {
$widthbar = intval($data[1] / $mmax * 200);
}
?>
<tr class="invoice_rows">
<td width="29%" ><font color="#003399"><?php
echo $data[0];
?>
</font></td>
<td width="38%" ><font color="#003399"><?php
echo $minutes;
?>
</font></td>
<td width="12%" align="right" ><font color="#003399"><?php
echo $data[3];
?>
</font> </td>
<td align="right" ><font color="#003399"><?php
display_2bill($data[2]);
?>
</font></td>
</tr>
<?php
}
if (!isset($resulttype) || $resulttype == "min") {
$total_tmc = sprintf("%02d", intval($totalminutes / $totalcall / 60)) . ":" . sprintf("%02d", intval($totalminutes / $totalcall % 60));
$totalminutes = sprintf("%02d", intval($totalminutes / 60)) . ":" . sprintf("%02d", intval($totalminutes % 60));
} else {
$total_tmc = intval($totalminutes / $totalcall);
}
?>
<tr >
<td width="29%" > </td>
<td width="38%" > </td>
<td width="12%" > </td>
<td > </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="29%" ><font color="#003399"><?php
echo gettext("TOTAL");
?>
</font></td>
<td width="38%" ><font color="#003399"><?php
echo $totalminutes;
?>
</font></td>
<td width="12%" align="right"><font color="#003399"><?php
echo $totalcall;
?>
</font></td>
<td align="right" ><font color="#003399"><?php
display_2bill($totalcost - $totalcost_did);
?>
</font> </td>
</tr>
<tr >
<td width="29%"> </td>
<td width="38%"> </td>
<td width="12%"> </td>
<td > </td>
</tr>
<?php
}
?>
</table>
<table align="center" width="80%">
<!-- Start Here ****************************************-->
<?php
$mmax = 0;
$totalcall = 0;
$totalminutes = 0;
$totalcost_day = 0;
if (is_array($list_total_day) && count($list_total_day) > 0) {
foreach ($list_total_day as $data) {
if ($mmax < $data[1]) {
$mmax = $data[1];
}
$totalcall += $data[3];
$totalminutes += $data[1];
$totalcost_day += $data[2];
}
?>
<tr>
<td colspan="4" align="center"><b><?php
echo gettext("By Date");
?>
</b> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="29%"><font color="#003399"><b><?php
echo gettext("Date");
?>
</b> </font></td>
<td width="38%" ><font color="#003399"><b><?php
echo gettext("Duration");
?>
</b> </font></td>
<td width="12%" align="center" ><font color="#003399"><b><?php
echo gettext("Calls");
?>
</b> </font></td>
<td width="21%" align="right"><font color="#003399"><b><?php
echo gettext("Amount") . " (" . BASE_CURRENCY . ")";
?>
</b> </font></td>
</tr>
<?php
$i = 0;
foreach ($list_total_day as $data) {
$i = ($i + 1) % 2;
$tmc = $data[1] / $data[3];
if (!isset($resulttype) || $resulttype == "min") {
$tmc = sprintf("%02d", intval($tmc / 60)) . ":" . sprintf("%02d", intval($tmc % 60));
} else {
$tmc = intval($tmc);
}
if (!isset($resulttype) || $resulttype == "min") {
$minutes = sprintf("%02d", intval($data[1] / 60)) . ":" . sprintf("%02d", intval($data[1] % 60));
} else {
$minutes = $data[1];
}
if ($mmax > 0) {
$widthbar = intval($data[1] / $mmax * 200);
}
?>
<tr class="invoice_rows">
<td width="29%" ><font color="#003399"><?php
echo $data[0];
?>
</font></td>
<td width="38%" ><font color="#003399"><?php
echo $minutes;
?>
</font></td>
<td width="12%" align="right"><font color="#003399"><?php
echo $data[3];
?>
</font></td>
<td width="21%" align="right" ><font color="#003399"><?php
display_2bill($data[2]);
?>
</font></td>
</tr>
<?php
}
if (!isset($resulttype) || $resulttype == "min") {
$total_tmc = sprintf("%02d", intval($totalminutes / $totalcall / 60)) . ":" . sprintf("%02d", intval($totalminutes / $totalcall % 60));
$totalminutes = sprintf("%02d", intval($totalminutes / 60)) . ":" . sprintf("%02d", intval($totalminutes % 60));
} else {
$total_tmc = intval($totalminutes / $totalcall);
}
?>
<tr >
<td width="29%" > </td>
<td width="38%" > </td>
<td width="12%" > </td>
<td width="21%" > </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="29%" ><font color="#003399"><?php
echo gettext("TOTAL");
?>
</font></td>
<td width="38%" ><font color="#003399"><?php
echo $totalminutes;
?>
</font></td>
<td width="12%" align="right" ><font color="#003399"><?php
echo $totalcall;
?>
</font> </td>
<td width="21%" align="right" ><font color="#003399"><?php
display_2bill($totalcost_day);
?>
</font></td>
</tr>
<tr >
<td width="29%"> </td>
<td width="38%"> </td>
<td width="12%"> </td>
<td width="21%"> </td>
</tr>
<?php
}
?>
<!-- END HERE ******************************************-->
</table>
<table align="center" width="80%">
<?php
if (is_array($list_total_did) && count($list_total_did) > 0) {
?>
<tr>
<td>
<table width="100%" align="left" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" align="center"><font><b><?php
echo gettext("DID Billing");
?>
</b></font> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="20%"> <font color="#003399"><b><?php
echo gettext("Charge Date");
?>
</b></font></td>
<td width="13%" ><font color="#003399"><b><?php
echo gettext("DID");
?>
</b></font></td>
<td width="14%" ><font color="#003399"><b><?php
echo gettext("Country");
?>
</b></font> </td>
<td width="41%" ><font color="#003399"><b><?php
echo gettext("Description");
?>
</b></font></td>
<td width="12%" align="right"><font color="#003399"><b><?php
echo gettext("Amount") . " (" . BASE_CURRENCY . ")";
?>
</b></font> </td>
</tr>
<?php
$i = 0;
$totaldidcost = 0;
foreach ($list_total_did as $data) {
$totaldidcost = $totaldidcost + convert_currency($currencies_list, $data[0], $data[5], BASE_CURRENCY);
?>
<tr class="invoice_rows">
<td width="20%" ><font color="#003399"><?php
echo $data[1];
?>
</font></td>
<td width="13%" ><font color="#003399"> <?php
echo $data[4];
?>
</font> </td>
<td width="14%" ><font color="#003399"> <?php
echo $data[3];
?>
</font></td>
<td width="41%" ><font color="#003399"><?php
echo $data[2];
?>
</font> </td>
<td width="12%" align="right" ><font color="#003399"><?php
convert_currency($currencies_list, $data[0], $data[5], BASE_CURRENCY) . " " . BASE_CURRENCY;
?>
</font></td>
</tr>
<?php
}
$totalcost = $totalcost + $totaldidcost;
?>
<tr >
<td width="20%" > </td>
<td width="13%" > </td>
<td width="14%" > </td>
<td width="41%" > </td>
<td width="12%" > </td>
</tr>
<tr bgcolor="#CCCCCC" >
<td width="20%" ><font color="#003399"><?php
echo gettext("TOTAL");
?>
</font></td>
<td ><font color="#003399"> </font></td>
<td width="14%" ><font color="#003399"> </font> </td>
<td width="41%" ><font color="#003399"> </font> </td>
<td width="12%" align="right" ><font color="#003399"><?php
display_2bill($totaldidcost);
?>
</font> </td>
</tr>
<tr>
<td width="20%"> </td>
<td width="13%"> </td>
<td width="14%"> </td>
<td width="41%"> </td>
<td width="12%"> </td>
</tr>
</table>
</td>
</tr>
<?php
}
?>
<tr>
<td>
<!-------------------------EXTRA CHARGE START HERE ---------------------------------->
<?php
$i = 0;
$extracharge_total = 0;
if (is_array($list_total_charges) && count($list_total_charges) > 0) {
?>
<table width="100%" align="left" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4" align="center"><font><b><?php
echo gettext("Extra Charges");
?>
</b></font> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="20%"> <font color="#003399"><b><?php
echo gettext("Date");
?>
</b></font></td>
<td width="19%" ><font color="#003399"><b><?php
echo gettext("Type");
?>
</b></font></td>
<td width="43%" ><font color="#003399"><b><?php
echo gettext("Description");
?>
</b></font> </td>
<td width="18%" align="right"><font color="#003399"><b><?php
echo gettext("Amount") . " (" . BASE_CURRENCY . ")";
?>
</b></font> </td>
</tr>
<?php
foreach ($list_total_charges as $data) {
$extracharge_total = $extracharge_total + convert_currency($currencies_list, $data[3], $data[6], BASE_CURRENCY);
?>
<tr class="invoice_rows">
<td width="20%" ><font color="#003399"><?php
echo $data[2];
?>
</font></td>
<td width="19%" ><font color="#003399">
<?php
if ($data[4] == 1) {
echo gettext("Setup Charges");
}
if ($data[4] == 2) {
echo gettext("DID Montly Use");
}
if ($data[4] == 3) {
echo gettext("Subscription Fee");
}
if ($data[4] == 4) {
echo gettext("Extra Charges");
}
?>
</font> </td>
<td width="43%" ><font color="#003399"><?php
echo $data[7];
?>
</font></td>
<td width="18%" align="right" ><font color="#003399"><?php
echo convert_currency($currencies_list, $data[3], $data[6], BASE_CURRENCY) . " " . BASE_CURRENCY;
?>
</font></td>
</tr>
<?php
}
//for loop end here
?>
<tr >
<td width="20%" > </td>
<td width="19%" > </td>
<td width="43%" > </td>
<td width="18%" > </td>
</tr>
<tr bgcolor="#CCCCCC" >
<td width="20%" ><font color="#003399"><?php
echo gettext("TOTAL");
?>
</font></td>
<td ><font color="#003399"> </font></td>
<td width="43%" ><font color="#003399"> </font> </td>
<td width="18%" align="right" ><font color="#003399"><?php
echo display_2bill($extracharge_total);
?>
</font> </td>
</tr>
<tr >
<td width="20%"> </td>
<td width="19%"> </td>
<td width="43%"> </td>
<td width="18%"> </td>
</tr>
</table>
<?php
}
//if check end here
$totalcost = $totalcost + $extracharge_total;
?>
<!-----------------------------EXTRA CHARGE END HERE ------------------------------->
</td>
</tr>
<tr>
<td><img src="<?php
echo Images_Path;
?>
/spacer.jpg" align="middle" height="30px"></td>
</tr>
<tr bgcolor="#CCCCCC" >
<td align="right" width="100%"><font color="#003399"><b><?php
echo gettext("Total");
?>
= <?php
display_2bill($totalcost);
?>
</b></font></td>
</tr>
<tr bgcolor="#CCCCCC" >
<td align="right" width="100%"><font color="#003399"><b><?php
echo gettext("VAT");
?>
= <?php
$prvat = $vat / 100 * $totalcost;
display_2bill($prvat);
?>
</b></font></td>
</tr>
<tr>
<td><img src="<?php
echo Images_Path;
?>
/spacer.jpg" align="middle" height="30px"></td>
</tr>
<tr bgcolor="#CCCCCC" >
<td align="right" width="100%"><font color="#003399"><b><?php
echo gettext("Grand Total");
?>
= <?php
echo display_2bill($totalcost + $prvat);
?>
</b></font></td>
</tr>
<tr>
<td><img src="<?php
echo Images_Path;
?>
/spacer.jpg" align="middle" height="30px"></td>
</tr>
</table>
<table cellspacing="0" cellpadding="2" width="80%" align="center">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td align="left">Status : <?php
if ($info_customer[0][12] == 't') {
?>
<img src="<?php
echo Images_Path;
?>
/connected.jpg">
<?php
} else {
?>
<img src="<?php
echo Images_Path;
?>
/terminated.jpg">
<?php
}
?>
</td>
</tr>
<tr>
<td align="left"> <img src="<?php
echo Images_Path;
?>
/connected.jpg"> <?php
echo gettext("Connected");
?>
<img src="<?php
echo Images_Path;
?>
/terminated.jpg"> <?php
echo gettext("Disconnected");
?>
</td>
</table>
<?php
$html = ob_get_contents();
// delete output-Buffer
ob_end_clean();
$pdf = new HTML2FPDF();
$pdf->DisplayPreferences('HideWindowUI');
$pdf->AddPage();
$pdf->WriteHTML($html);
$stream = $pdf->Output('UnBilledDetails_' . date("d/m/Y-H:i") . '.pdf', 'S');
//================================Email Template Retrival Code ===================================
$QUERY = "SELECT mailtype, fromemail, fromname, subject, messagetext, messagehtml FROM cc_templatemail WHERE mailtype='invoice' ";
$res = $DBHandle->Execute($QUERY);
$num = 0;
if ($res) {
$num = $res->RecordCount();
}
if (!$num) {
echo "<br>Error : No email Template Found";
exit;
}
for ($i = 0; $i < $num; $i++) {
$listtemplate[] = $res->fetchRow();
}
list($mailtype, $from, $fromname, $subject, $messagetext, $messagehtml) = $listtemplate[0];
if ($FG_DEBUG == 1) {
echo "<br><b>mailtype : </b>{$mailtype}</br><b>from:</b> {$from}</br><b>fromname :</b> {$fromname}</br><b>subject</b> : {$subject}</br><b>ContentTemplate:</b></br><pre>{$messagetext}</pre></br><hr>";
}
//================================================================================================
$ok = send_email_attachment($from, $info_customer[0][10], $subject, $messagetext, 'UnBilledDetails_' . date("d/m/Y-H:i") . '.pdf', $stream);
return $ok;
}
<?php
require_once dirname(__FILE__) . '/../../includes/global.inc.php';
// pdf was breaking
define(RELATIVE_PATH, '');
switch ($_GET['action']) {
case 'word':
require_once dirname(__FILE__) . '/HTML2Doc.php';
$doc = new HTML_TO_DOC();
$doc->setTitle(iBeginShare::quoteSmart($_GET['title']));
$doc->createDoc($raw_content, (strlen(iBeginShare::quoteSmart($_GET['title'])) > 0 ? str_replace(' ', '-', strip_tags($_GET['title'])) : 'Document-' . date('Y-m-d')) . '.doc');
break;
case 'pdf':
require_once dirname(__FILE__) . '/html2fpdf/html2fpdf.php';
$pdf = new HTML2FPDF();
$pdf->DisplayPreferences($_GET['title']);
$pdf->AddPage();
$pdf->WriteHTML(html_entity_decode($raw_content));
$pdf->Output((strlen(iBeginShare::quoteSmart($_GET['title'])) > 0 ? str_replace(' ', '-', strip_tags($_GET['title'])) : 'Document-' . date('Y-m-d')) . '.pdf', 'D');
break;
}
static function html2pdf($html, $encode = "SJIS")
{
//echo 1;exit;
//$html=self::pdf_change_encode($html,$encode);
define('FPDF_FONTPATH', ROOT . 'lib/html2fpdf/font/');
include ROOT . 'lib/html2fpdf/jphtml2fpdf.php';
$pdf = new HTML2FPDF("l", "mm", "A4");
$pdf->Open();
$pdf->SetCompression(false);
$pdf->SetDisplayMode("real");
$pdf->UseCSS();
$pdf->UsePRE();
$pdf->AddSJISFont();
$pdf->setBasePath("");
$pdf->AddPage();
//ファイル情報
$pdf->SetAuthor("HPX");
$pdf->Bookmark("HPX");
$pdf->SetTitle("HPX");
$pdf->SetCreator("HPX");
// 本文
$pdf->SetMargins(10, 10);
$pdf->DisplayPreferences('HideWindowUI');
//$pdf->SetFont( HideWindowUI,"",8);
$pdf->WriteHTML($html);
// 出力
$pdf->Output('doc.pdf', 'D');
exit;
}
function createPDF()
{
global $smarty;
$smarty = new Smarty();
templateAssignInvoice('smarty', $this);
templateAssignSystemvars('smarty');
$smarty->assign('invoice_heading', 'Faktura');
$pdf = new HTML2FPDF();
$pdf->DisplayPreferences('HideWindowUI');
$pdf->AddPage();
$pdf->WriteHTML($smarty->fetch('file:invoice.tpl'));
$pdf->Output('invoice/invoice' . $this->invoice_id . '.pdf');
$smarty->assign('invoice_heading', 'Fakturakopi');
$pdf = new HTML2FPDF();
$pdf->DisplayPreferences('HideWindowUI');
$pdf->AddPage();
$pdf->WriteHTML($smarty->fetch('file:invoice.tpl'));
$pdf->Output('invoice/invoice' . $this->invoice_id . '_copy.pdf');
}