File manager

File manager - Edit - /home/autoph/public_html/connect/home/forPaymentPOList.php

Back
<?php include 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['getData'])){ $start = mysql_real_escape_string($_POST['start']); $limit = mysql_real_escape_string($_POST['limit']); $infCanvass = mysql_real_escape_string($_POST['infCanvass']); if($infCanvass=='' \|\| $infCanvass == null){ $getItemHdr = mysql_query("SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number` DESC LIMIT $start,$limit"); }else{ $getItemHdr = mysql_query("SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' AND `po_number`= '$infCanvass' GROUP BY `inv_number` DESC"); } while($row=mysql_fetch_array($getItemHdr)){ $myPONumber=$row['po_number']; $myVendorID=$row['vendor_id']; $myINVNo=$row['inv_number']; $myTokenID = mysql_result(mysql_query("SELECT `token` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0);; $totalInvoiceAmount = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `inv_number`='$myINVNo'"),0); $totalPOAmount = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `po_code`=$myPONumber AND `deleted`=0"),0); $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$myVendorID'"),0); $getCompID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_purchase_order` WHERE `po_number`=$myPONumber"),0); $poDate = mysql_result(mysql_query("SELECT `date_forwarded_to_vendor` FROM `prf_purchase_order` WHERE `po_number`=$myPONumber"),0); $terms = mysql_result(mysql_query("SELECT `terms` FROM `prf_purchase_order` WHERE `po_number`=$myPONumber"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$getCompID'"),0); $chkStatus = mysql_result(mysql_query("SELECT `inv_status` FROM `prf_delivery_receiving_logs` WHERE `inv_number`='$myINVNo'"),0); $date=date_create("".$row['date_delivered'].""); date_add($date,date_interval_create_from_date_string("".$terms." days")); $dueDate = date_format($date,"Y-m-d"); $date1=date_create("".$prfDate.""); $date2=date_create("".$dueDate.""); $diff=date_diff($date1,$date2); $overDue = $diff->format("%R%a days"); if($overDue < 10){$txtColor='red';}else{$txtColor='black';} ?><tr onclick="javasctipt:getInfo(this);" ><?php echo "<td style='width:5%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$row['id']."</td>"; echo "<td style='width:7%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$poDate."</td>"; echo "<td style='width:7%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$row['date_delivered']."</td>"; echo "<td style='width:7%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$row['inv_number']."</td>"; echo "<td style='width:7%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$row['dr_number']."</td>"; echo "<td style='width:7%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$row['po_number']."</td>"; echo "<td style='width:10%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$reqCompName."</td>"; echo "<td style='width:16%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$vendorName."</td>"; echo "<td style='width:5%;text-align:center;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>".$terms."</td>"; echo "<td style='width:8%;text-align:right;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>"; echo number_format($totalPOAmount,2,'.',','); echo"</td>"; echo "<td style='width:8%;text-align:right;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>"; echo number_format($totalInvoiceAmount,2,'.',','); echo"</td>"; echo "<td style='width:8%;text-align:center;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>"; if($chkStatus === "Paid"){ echo "Paid"; }else{ echo $dueDate; } echo"</td>"; echo "<td style='width:5%;font-family:Yu Gothic Light;color:$txtColor;font-size:12px'>"; if($chkStatus === "Paid"){ echo "Paid"; }else{ echo $overDue; } echo"</td>"; echo "<td style='width:7%;background:transaparent;text-align:center;'> <a href='poapr.php?id=".$row['po_number']."&uid=".$uniqueRefID."&token=".$myTokenID."' target='_Blank' styl='font-family:Yu Gothic Light;font-size:14px;font-weight:normal;color:red;'>📑</a></td>"; echo "</tr>"; } } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings