"; 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 "); $getItemHdr = mysql_query("SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_number`='$searchPONumber' || `dr_number`='$searchPONumber' || `po_number`='$searchPONumber' ORDER BY `po_number` ASC"); 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"); $chkStatus = mysql_result(mysql_query("SELECT `inv_status` FROM `prf_delivery_receiving_logs` WHERE `inv_number`='$myINVNo'"),0); $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"

"; if($chkStatus === "Paid"){ echo "Paid"; }else{ echo $dueDate; } echo"

"; if($chkStatus === "Paid"){ echo "Paid"; }else{ echo $overDue; } echo"