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';} ?>".$row['id'].""; echo "".$poDate.""; echo "".$row['date_delivered'].""; echo "".$row['inv_number'].""; echo "".$row['dr_number'].""; echo "".$row['po_number'].""; echo "".$reqCompName.""; echo "".$vendorName.""; echo "".$terms.""; echo ""; echo number_format($totalPOAmount,2,'.',','); echo""; echo ""; echo number_format($totalInvoiceAmount,2,'.',','); echo""; echo ""; if($chkStatus === "Paid"){ echo "Paid"; }else{ echo $dueDate; } echo""; echo ""; if($chkStatus === "Paid"){ echo "Paid"; }else{ echo $overDue; } echo""; echo " 📑"; echo ""; } } ?>