File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_POViewingOfItemsOnly.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><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10%'>".$row['header_ref_code']."</td>"; echo "<td style='width:10%'>".$reqCompName."</td>"; echo "<td style='width:20%'>".$vendorName."</td>"; echo "<td style='width:25%'>".$row['item_description']."</td>"; echo "<td style='width:5%'>".$row['uom']."</td>"; echo "<td style='width:10%;text-align:right'>".number_format($row['approved_amount'],2,'.',',')."</td>"; echo "<td style='width:5%;text-align:center'>".$row['approved_qty']."</td>"; echo "<td style='width:10%;text-align:right'>".number_format(($row['approved_amount']*$row['approved_qty']),2,'.',',')."</td>"; echo "</tr>"; $poAmount = $poAmount + ($row['approved_amount'] * $row['approved_qty']); } echo "<tr>"; echo "<td colspan='7' style='width:5%;text-align:right;font-size:14px;font-weight:bold;'>TOTAL AMOUNT:</td>"; echo "<td colspan='7' style='width:5%;text-align:right;font-size:14px;font-weight:bold;'>".number_format($poAmount,2,'.',',')."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='9' style='text-align:right;width:5%;text-align:right;font-size:11px;font-weight:normal;background:white;height:40px'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='7' style='text-align:right;width:5%;text-align:right;font-size:11px;font-weight:normal;background:white;'>Request Date:</td>"; echo "<td colspan='2' style='text-align:right;width:5%;text-align:left;font-size:11px;font-weight:normal;background:white;'>".$reqDate."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='7' style='text-align:right;width:5%;text-align:right;font-size:11px;font-weight:normal;background:white;'>PO Approval Date:</td>"; echo "<td colspan='2' style='text-align:right;width:5%;text-align:left;font-size:11px;font-weight:normal;background:white;'>".$poDate."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='7' style='text-align:right;width:5%;text-align:right;font-size:10px;font-weight:normal;background:white;'>Vendor Cofirmation Date:</td>"; echo "<td colspan='2' style='text-align:right;width:5%;text-align:left;font-size:10px;font-weight:normal;background:white;'>".$venDate."</td>"; echo "</tr>"; ?> </table> <?php }?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings