File manager

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

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->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'"); } } ?> <table> <?php $invAmount=0; $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`= '$myPONumber' ORDER BY `id`"); while($row=mysql_fetch_array($getItemHdr)){ $vendorID = $row['award_to_vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $reqCompID=$row['comp_id']; $reqDealID=$row['dealer_id']; $refCode=$row['header_ref_code']; $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqDealName = mysql_result(mysql_query("SELECT `deal_code` FROM vts_dealerships WHERE deal_id='$reqDealID'"),0); $reqDate = mysql_result(mysql_query("SELECT `posted_date` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); //$exeDate= mysql_result(mysql_query("SELECT `date_approved` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $poDate = mysql_result(mysql_query("SELECT `date_approved` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $venDate = mysql_result(mysql_query("SELECT `vendor_confirm_ts` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); ?><tr onDblClick="javasctipt:showConfirmationBox();" onclick="javascript:getInformationData(this);"><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:8%'>".$row['header_ref_code']."</td>"; echo "<td style='width:35%'>".$row['item_description']."</td>"; echo "<td style='width:5%'>".$row['uom']."</td>"; echo "<td style='width:9%;text-align:right'>".number_format($row['approved_amount'],2,'.',',')."</td>"; echo "<td style='width:9%;text-align:center'>".$row['approved_qty']."</td>"; echo "<td style='width:9%;text-align:right;border-right:1px solid gray'>".number_format(($row['approved_amount']$row['approved_qty']),2,'.',',')."</td>"; echo "<td style='width:11%;text-align:center;background:#efff7d;border:1px solid gray'>".$row['delivered_qty']."</td>"; echo "<td style='width:9%;text-align:right;background:#efff7d;border:1px solid gray'>".number_format(($row['approved_amount']$row['delivered_qty']),2,'.',',')."</td>"; echo "</tr>"; $poAmount = $poAmount + ($row['approved_amount'] * $row['approved_qty']); $invAmount = $invAmount + ($row['approved_amount'] * $row['delivered_qty']); } echo "<tr>"; echo "<td colspan='5' style='width:5%;text-align:right;font-size:12px;font-weight:bold;'>TOTAL AMOUNT:</td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:bold;border-right:1px solid gray'>".number_format($poAmount,2,'.',',')."</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#e5f573;border:1px solid gray'>INV. AMOUNT</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#e5f573;border:1px solid gray'>".number_format($invAmount,2,'.',',')."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='5' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:white'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='5' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:white'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='5' style='width:5%;text-align:right;font-size:12px;font-weight:bold;font-family:Yu Gothic Light;font-weight:normal;font-size:14px;color:$color'>"; echo $message ."-". $chkAPRQty ."-". $chkRCVQty; echo"</td>"; echo "</tr>"; ?> </table> <?php }?>

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