format("Y-m-d"); $rcvTime =date('H:i:s'); $myUID = $user_data['u_id']; $prfDateTime = $prfDate .' '.$rcvTime; if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); $itemRefCode = mysql_escape_string($_POST['itemRefCode']); $myPONumber = mysql_escape_string($_POST['myPONumber']); $dQTY = mysql_escape_string($_POST['receivedQTY']); $iAmount = mysql_escape_string($_POST['unitPrice']); $invAmount = str_replace(',', '', $iAmount); $invoiceNo = mysql_escape_string($_POST['invoiceNo']); $drNo = mysql_escape_string($_POST['drNo']); $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $chkQTY = mysql_result(mysql_query("SELECT SUM(delivered_qty) FROM `prf_delivery_receiving_logs` WHERE `item_id`='$itemID' AND `deleted`='no'"),0); $newProsQty = $dQTY + $chkQTY; $chkPOQty = mysql_result(mysql_query("SELECT `approved_qty` FROM `prf_request_detl` WHERE `id`='$itemID' AND `deleted`='0' AND `po_code`='$myPONumber'"),0); if($newProsQty > $chkPOQty){ $message ="ERROR: You are receiving quantity higher than what is purchased. Transaction is terminated."; $color = 'red'; } else{ $vendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_purchase_order` WHERE `po_number` = '$myPONumber'"),0); $prevReceiving = mysql_result(mysql_query("SELECT `delivered_qty` FROM `prf_request_detl` WHERE `id`='$itemID' AND `deleted`='0' AND `po_code`='$myPONumber'"),0); $newReceivedQty = $prevReceiving + $dQTY; $newInvoiceNumber = "INV#" .$vendorID ."_".$invoiceNo; $newDRNumber = "DR#" .$vendorID ."_".$drNo; mysql_query("UPDATE `prf_request_detl` SET `delivered_qty`='$newReceivedQty',`invoice_amount`='$invAmount' WHERE `id`='$itemID'"); mysql_query("INSERT INTO prf_delivery_receiving_logs(item_id,po_number,delivered_qty,date_delivered,time_delivered,received_by,dr_amount,vendor_id,inv_number,dr_number,comp_id) VALUES('{$itemID}','{$myPONumber}','{$dQTY}','{$prfDate}','{$rcvTime}','{$myUID}','{$invAmount}','{$vendorID}','{$newInvoiceNumber}','{$newDRNumber}','{$companyID}')"); $message ="Transaction has been processed."; $color = 'blue'; $chkAPRQty = mysql_result(mysql_query("SELECT SUM(approved_qty) FROM `prf_request_detl` WHERE `po_code`='$myPONumber'"),0); $chkRCVQty = mysql_result(mysql_query("SELECT SUM(delivered_qty) FROM `prf_request_detl` WHERE `po_code`='$myPONumber'"),0); $myRefCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); if($chkAPRQty == $chkRCVQty){ mysql_query("UPDATE `prf_purchase_order` SET `delivery_note`='Full Delivery', `po_vendor_status`='Delivered', `po_status`='6',`delivered_date`='$prfDateTime',`delivery_received_by`='$myUID' WHERE `po_number`='$myPONumber'"); mysql_query("UPDATE `prf_request_detl` SET `current_status`='10' WHERE `reference_code`='$myRefCode'"); mysql_query("UPDATE `prf_request_detl` SET `item_status`='10' WHERE `po_code`='$myPONumber'"); $pdColor ='#ddfc9f'; $approvedQTY = mysql_result(mysql_query("SELECT SUM(approved_qty) FROM `prf_request_detl` WHERE `header_ref_code`='$myRefCode'"),0); $deliveredQTY = mysql_result(mysql_query("SELECT SUM(delivered_qty) FROM `prf_request_detl` WHERE `header_ref_code`='$myRefCode'"),0); if($approvedQTY == $deliveredQTY){ mysql_query("UPDATE `prf_request_hdr` SET `current_status`='10' WHERE `reference_code`='$myRefCode'"); } }else{ mysql_query("UPDATE `prf_purchase_order` SET `delivery_note`='Partial Delivery',`delivered_date`='$prfDateTime',`delivery_received_by`='$myUID' WHERE `po_number`='$myPONumber'"); $pdColor ='#fccaba'; //mysql_query("UPDATE `prf_request_hdr` SET `rf_request_hdr`='10' WHERE `reference_code`='$myRefCode'"); } } ?> ".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $poAmount = $poAmount + ($row['approved_amount'] * $row['approved_qty']); $invAmount = $invAmount + ($row['approved_amount'] * $row['delivered_qty']); } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

".$row['header_ref_code']."	".$row['item_description']."	".$row['uom']."	".number_format($row['approved_amount'],2,'.',',')."	".$row['approved_qty']."	".number_format(($row['approved_amount']*$row['approved_qty']),2,'.',',')."	".$row['delivered_qty']."	".number_format(($row['approved_amount']*$row['delivered_qty']),2,'.',',')."
TOTAL AMOUNT:					".number_format($poAmount,2,'.',',')."		INV. AMOUNT	".number_format($invAmount,2,'.',',')."
"; echo $message ."-". $chkAPRQty ."-". $chkRCVQty; echo"