File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_loadPOItemsForyPayment.php
Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $myPONumber = mysql_escape_string($_POST['myPONumber']); ?> <table> <?php $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>"; ?> </table> <?php }?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings