| Server IP : 104.21.37.246 / Your IP : 104.23.243.32 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home2/cp648411/public_html/ilawasia.onnud20.com/Report/ |
Upload File : |
<?php
$ck='not';
$path = '../';
//putenv("NLS_LANG=AMERICAN_AMERICA.TH8TISASCII");
include("../include/class.php");
include("../include/table_name.php");
$request = array(
'StartDate' => @$_REQUEST['StartDate'],
'EndDate' => @$_REQUEST['EndDate'],
'CustomerId' => @$_REQUEST['CustomerId']
);
$data = $report_db->AgedDebtExcelandPdf($request);
$arrayData = $data;
$totalRow = count($data);
echo "<pre>";
print_r($data);
echo "</pre>";
exit();
$columnName = ["No.","Name","Task Date","Task Descripton","Case Number","Customer","Duration"];
$CaseId='';
$ct = 0;
$mms = "StartDate: ".@$_REQUEST['StartDate']." , EndDate: ".@$_REQUEST['EndDate']." , Customer: ".(@$_REQUEST['CustomerId']=='')?'':@$_REQUEST['CustomerId'];
?>
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title></title>
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" crossorigin="anonymous">
</head>
<body>
<center style="font-size: 25px; font-weight: bold;"> Aged Debtor by Client </center>
<center style="font-size: 16px; text-align: center;"> Country: TH , Case Type: Corporate Registration , Case Number: - , Customer: - , Status: Opening , Quotation Type: One Time only </center>
<table class="table table-bordered">
<tbody>
<?php
$lastCustomerCode='';
$netDays=0;$netOutStanding=0;$net1=0;$net2=0;$net3=0;$net4=0;$net5=0;$net6=0;
$sumDays=0;$sumOutStanding=0;$sum1=0;$sum2=0;$sum3=0;$sum4=0;$sum5=0;$sum6=0;
foreach ($arrayData as $key => $value) {
if(@$lastCustomerCode!=$value['CustomerCode'])
{
if(@$sumOutStanding > 0)
{
?>
<tr style="border: 1px solid #000;">
<td scope="row" style="border: 1px solid #000;text-align:right; padding: 0 5px;"><strong>Total:</strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sumOutStanding; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sumDays; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sum1; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sum2; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sum3; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sum4; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sum5; ?></strong></td>
<td style="border: 1px solid #000;padding: 0 5px;text-align:right;"><strong><?php echo @$sum6; ?></strong></td>
</tr>
<?php
$netDays = floatval($netDays) + floatval($sumDays);
$netOutStanding = floatval($netOutStanding) + floatval($sumOutStanding);
$net1 = floatval($net1) + floatval($sum1);
$net2 = floatval($net2) + floatval($sum2);
$net3 = floatval($net3) + floatval($sum3);
$net4 = floatval($net4) + floatval($sum4);
$net5 = floatval($net5) + floatval($sum5);
$net6 = floatval($net6) + floatval($sum6);
$sumDays = 0;
$sumOutStanding = 0;
$sum1 = 0;
$sum2 = 0;
$sum3 = 0;
$sum4 = 0;
$sum5 = 0;
$sum6 = 0;
} ?>
<tr>
<td colspan="10"><strong><?php echo $value['CustomerName']; ?></strong></td>
</tr>
<?php
$lastCustomerCode = $value['CustomerCode'];
}
?>
<tr>
<td><?php echo $value['CreateDateTime'] ?></td>
<td><?php echo $value['InvoiceNo'] ?></td>
<td style="text-align:right;"><strong><?php echo $value['OutStanding'] ?></strong></td>
<td style="text-align:right;"><?php echo $value['DiffDays'] ?></td>
<td style="text-align:right;"><?php echo ($value['DiffDays'] >= 0 && $value['DiffDays'] <= 30)? $value['OutStanding']:"0.00"; ?></td>
<td style="text-align:right;"><?php echo ($value['DiffDays'] >= 31 && $value['DiffDays'] <= 60)? $value['OutStanding']:"0.00"; ?></td>
<td style="text-align:right;"><?php echo ($value['DiffDays'] >= 61 && $value['DiffDays'] <= 90)? $value['OutStanding']:"0.00"; ?></td>
<td style="text-align:right;"><?php echo ($value['DiffDays'] >= 91 && $value['DiffDays'] <= 120)? $value['OutStanding']:"0.00"; ?></td>
<td style="text-align:right;"><?php echo ($value['DiffDays'] >= 121 && $value['DiffDays'] <= 180)? $value['OutStanding']:"0.00"; ?></td>
<td style="text-align:right;"><?php echo ($value['DiffDays'] >180 )? $value['OutStanding']:"0.00"; ?></td>
</tr>
<?php
$sumDays = floatval($sumDays) + floatval($value['DiffDays']);
$sumOutStanding = floatval($sumOutStanding) + floatval($value['OutStanding']);
$sum1 = (floatval($value['DiffDays']) >= 0 && floatval($value['DiffDays']) <= 30) ? floatval($value['OutStanding']) : 0;
$sum2 = (floatval($value['DiffDays']) >= 31 && floatval($value['DiffDays']) <= 60) ? floatval($value['OutStanding']) : 0;
$sum3 = (floatval($value['DiffDays']) >= 61 && floatval($value['DiffDays']) <= 90) ? floatval($value['OutStanding']) : 0;
$sum4 = (floatval($value['DiffDays']) >= 91 && floatval($value['DiffDays']) <= 120) ? floatval($value['OutStanding']) : 0;
$sum5 = (floatval($value['DiffDays']) >= 121 && floatval($value['DiffDays']) <= 180) ? floatval($value['OutStanding']) : 0;
$sum6 = (floatval($value['DiffDays']) > 180) ? floatval($value['OutStanding']) : 0;
} ?>
<?php if($sumOutStanding > 0){ ?>
<tr>
<td colspan="2" style="text-align:right;"> <strong>Total:</strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sumOutStanding,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sumDays,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum1,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum2,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum3,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum4,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum5,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum6,2); ?></strong> </td>
</tr>
<?php
$netDays = floatval($netDays) + floatval($sumDays);
$sumOutStanding = floatval($sumOutStanding) + floatval($value['OutStanding']);
$net1 = floatval($net1) + floatval($sum1);
$net2 = floatval($net2) + floatval($sum2);
$net3 = floatval($net3) + floatval($sum3);
$net4 = floatval($net4) + floatval($sum4);
$net5 = floatval($net5) + floatval($sum5);
$net6 = floatval($net6) + floatval($sum6);
?>
<tr>
<td colspan="2" style="text-align:right;"> <strong>Total:</strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sumOutStanding,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sumDays,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum1,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum2,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum3,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum4,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum5,2); ?></strong> </td>
<td colspan="2" style="text-align:right;"> <strong><?php echo number_format($sum6,2); ?></strong> </td>
</tr>
<?php } ?>
</tbody>
</table>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js" crossorigin="anonymous"></script>
</body>
</html>