format("Y-m-d"); $myUID = $user_data['u_id']; $prfTime = date('H:i:s'); if(isset($_POST['done'])){ $collectionStatus = mysql_escape_string($_POST['collectionStatus']); $checkNumber = mysql_escape_string($_POST['checkNumber']); $invoiceNumber = mysql_escape_string($_POST['invoiceNumber']); $drNumber = mysql_escape_string($_POST['drNumber']); $myPONumber = mysql_escape_string($_POST['myPONumber']); if($collectionStatus ==='Paid'){ mysql_query("UPDATE `prf_delivery_receiving_logs` SET `date_paid`='$prfDate',`time_paid`='$prfTime',`check_no`='$checkNumber',`inv_status`='$collectionStatus',`paid_by`='$myUID' WHERE `dr_number`='$drNumber' AND `inv_number`='$invoiceNumber'"); } ?>
REC.# PO DATE INV. DATE INVOICE # DR NUMBER PO NUMBER COMPANY VENDOR TERMS PO AMOUNT INV. AMOUNT DUE DATE OVERDUE
"; echo ""; echo ""; echo ""; //####################################################################################################### //####################################################################################################### //SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1 $getItemHdr = mysql_query("SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number` DESC LIMIT $offSet, $noOfRecordPerPage "); while($row=mysql_fetch_array($getItemHdr)){ $myPONumber=$row['po_number']; $myVendorID=$row['vendor_id']; $myINVNo=$row['inv_number']; $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); $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 ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
".$poDate."".$row['date_delivered']."".$row['inv_number']."".$row['dr_number']."".$row['po_number']."".$reqCompName."".$vendorName."".$terms.""; echo number_format($totalPOAmount,2,'.',','); echo""; echo number_format($totalInvoiceAmount,2,'.',','); echo""; echo $dueDate; echo""; echo $overDue; echo"