File manager

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

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['id'])){ $poNumber=$_GET['id']; $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyAddress = mysql_result(mysql_query("SELECT `comp_address` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyFax = mysql_result(mysql_query("SELECT `comp_fax` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyTel = mysql_result(mysql_query("SELECT `comp_tel` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyEmail = mysql_result(mysql_query("SELECT `comp_email` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $PODate = mysql_result(mysql_query("SELECT `date_posted` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $POTerms = mysql_result(mysql_query("SELECT `terms` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $POInstructions = mysql_result(mysql_query("SELECT `remarks` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $deliverDate = mysql_result(mysql_query("SELECT `delivery_date` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $supplierID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $SupplierName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $getPRFNumberFromDetl = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `po_code`='$poNumber'"),0); $getPRFDealerID = mysql_result(mysql_query("SELECT `deal_id` FROM `prf_request_hdr` WHERE `reference_code`='$getPRFNumberFromDetl'"),0); $companyTIN = mysql_result(mysql_query("SELECT `comp_tin` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $dealerTIN = mysql_result(mysql_query("SELECT `deal_tin` FROM `vts_dealerships` WHERE `deal_id`='$getPRFDealerID'"),0); if($dealerTIN == ''){ $poTINNumber = $companyTIN; }else{ $poTINNumber = $dealerTIN; } $SupplierTIN = mysql_result(mysql_query("SELECT `tin_number` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierAddress = mysql_result(mysql_query("SELECT `address` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierContact = mysql_result(mysql_query("SELECT `contact_person` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierTel = mysql_result(mysql_query("SELECT `landline` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierContactMobile = mysql_result(mysql_query("SELECT `contact_person_mobile` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $ckhToken = $_GET['token']; $liveToken = mysql_result(mysql_query("SELECT `token` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); if($liveToken != $ckhToken){ echo "<center><p style='font-family:Yu Gothic Light;font-size:1.5vw;color:red;padding-top:100px'>This record does not exist. Reason: Invalid Token ID<br><br>Please contact your system administrator for assistance. Thank you <br><br> Date: ".date("m/d/Y")." \| ".date("h:m:s AM/PM")."</p></center>"; exit; } ?><center> <?php $poStatus = mysql_result(mysql_query("SELECT `po_status` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); if($poStatus == 9){ echo "<div style='display:block;position:absolute;top:45%;left:0%;width:100%;height:35%;border:0px solid red;background:transparent;-webkit-transform: rotate(-30deg); -moz-transform: rotate(-30deg); '> <p style='font-family:Tamoma;font-size:100px;color:red;padding:5px;margin:0px;opacity:9;text-shadow:1px 1px black'>Cancelled P.O</p> </div>"; } ?> <div style='padding:10px;margin:0%;width:60%;min-width:750px;border:0px solid gray;min-height:1100px;background:white'> <div style='float:left;width:100%;height:auto;background:white;border:0px solid gray;margin-bottom:2px'> <div style='width:40%;min-width:200px;height:80px;float:left;border:0px solid gray;padding:5px;text-align;left'> <img src='images/autohub_logo_2016.png' width="auto" height="auto" style='float:left' /> <p style='float:left;width:100%; text-align:left;margin-top:5px;font-family:Yu Gothic Light;font-size:10px'>Website: https://www.autohubgroup.com</p> </div> <div style='width:55%;min-width:400px;height:100px;float:right;border:0px solid gray;padding:0px;text-align;right'> <div style='background:white;width:50%;height:100px;float:right;border:0px solid gray;padding:10px;text-align;left'> <?php echo "<b style='font-family:Yu Gothic Light;font-size:12px;font-weight:normal;float:left;text-align:left'>".$companyAddress."</b>"; echo "<b style='font-family:Yu Gothic Light;font-size:12px;font-weight:normal;float:left;text-align:left'>Tel. No.".$companyTel." Fax." .$companyFax."</b>"; echo "<b style='font-family:Yu Gothic Light;font-size:12px;font-weight:normal;float:left;text-align:left'>E-mail: ".$companyEmail."</b>"; ?> </div> </div> </div> <div style='float:left;width:100%;height:auto;background:white;border:0px solid gray;margin-bottom:5px'> <div style='width:99.2%;padding:3px;font-family:Yu Gothic Bold;font-size:18px;font-weight:bold;color:black;border:1px solid gray'> PURCHASE ORDER </div> <div style='width:99.2%;padding:3px;font-family:Yu Gothic Bold;font-size:1.5vw;font-weight:bold;color:black;border:0px solid gray'> <table style='width:100%;border-collapse:collapse'> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Supplier Name:</td> <td style='width:50%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $SupplierName;?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>PO Number:</td> <td style='width:20%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $poNumber;?></td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Address:</td> <td style='width:50%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $SupplierAddress;?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>PO Date:</td> <td style='width:20%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $PODate;?></td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Contact Person:</td> <td style='width:50%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $SupplierContact;?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>Terms:</td> <td style='width:20%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $POTerms." Days";?> </td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Tel. Number:</td> <td style='width:50%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $PODate;?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>Contact Mobile#:</td> <td style='width:20%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $SupplierContactMobile;?></td> </tr> </table> </div> </div> <div style='float:left;width:99.8%;height:110px;background:white;border:1px solid gray;margin-bottom:2px'> <table style='width:100%;border-collapse:collapse'> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Please Invoice To:</td> <td style='width:70%;border:1px solid gray;border-top:0px;padding:1px;font-family:Yu Gothic Light;font-size:16px;font-weight:bold;text-align:center'><?php echo $companyName;?></td> <td style='width:15%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;'></td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>TIN Number:</td> <td style='width:70%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $poTINNumber;?></td> <td style='width:15%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;padding-left:10px'></td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Delivery Date:</td> <td style='width:70%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $deliverDate;?></td> <td style='width:15%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;padding-left:10px'> </td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Look For:</td> <td colspan=2 style='width:85%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px'><?php echo $POInstructions;?></td> </tr> </table> </div> <div style='float:left;width:100%;height:485px;background:white;border:0px solid gray;margin-bottom:2px'> <div style='width:100%;padding:0px;font-family:Yu Gothic Bold;font-size:0.8vw;font-weight:bold;color:black;border:0px solid gray;height:25px;background:lightgray'> <table style='width:100%;border-collapse:collapse'> <tr> <td style='width:8%;border:1px solid gray;padding:2px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>QTY</td> <td style='width:8%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>UNIT</td> <td style='width:60%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>DESCRIPTION</td> <td style='width:10%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>UNIT COST</td> <td style='width:14%;border:1px solid gray; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>AMOUNT</td> </tr> </table> </div> <div style='float:left;width:99.8%;margin-bottom:2px;padding:0px;font-family:Yu Gothic Bold;font-size:1.5vw;font-weight:bold;color:black;border:1px solid gray;height:430px'> <table style='width:100%;border-collapse:collapse'> <?php $getPOItems = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`='$poNumber' AND `deleted`=0 AND `po_code_posted`=1"); while($row=mysql_fetch_array($getPOItems)){ echo "<tr>"; echo "<td style='width:8%;border:0px solid gray;border-right:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center;border-bottom:1px solid gray;'>".$row['approved_qty']."</td>"; echo "<td style='width:8%;border:0px solid gray;border-right:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:center;border-bottom:1px solid gray;'>".$row['uom']."</td>"; echo "<td style='width:60%;border:0px solid gray;border-right:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:left;border-bottom:1px solid gray;padding-left:5px'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:10%;border:0px solid gray;border-right:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:right;padding-right:5px;border-bottom:1px solid gray;'>".number_format($row['approved_amount'],2,'.',',')."</td>"; echo "<td style='width:14%;border:0px solid gray;border-right:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:11px;font-weight:normal;text-align:right;padding-right:5px;border-bottom:1px solid gray;'>".number_format(($row['approved_amount'] * $row['approved_qty']),2,'.',',') ."</td>"; echo "</tr>"; $CostPrice = $row['approved_amount']* $row['approved_qty']; $totalAmount = $totalAmount + $CostPrice; } ?> </table> <p style='text-align:center;font-family:Yu Gothic Light;font-size:11px;padding:0px;margin-bottom:5px;margin-top:0px'>* * * NOTHING FOLLOWS * * </p> </div> <div style='float:left;width:100%;padding:0px;font-family:Yu Gothic Bold;font-size:0.8vw;font-weight:bold;color:black;border:0px solid gray;height:25px;background:lightgray;margin-bottom:0px'> <table style='width:100%;border-collapse:collapse'> <tr> <td style='width:8%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'></td> <td style='width:8%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;'></td> <td style='width:60%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;'></td> <td style='width:10%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:14px;font-weight:bold;text-align:center'>TOTAL</td> <td style='width:14%;border:1px solid gray; padding:1px;font-family:Yu Gothic Light;font-size:14px;font-weight:bold;text-align:right;padding-right:10px'><?php echo number_format($totalAmount,2,'.',',');?></td> </tr> </table> </div> </div> <div style='float:right;width:25%;height:100px;background:white;border:0px solid gray;margin-bottom:2px;margin-top:0px;padding:1px;'> <?php $getPRFNumber=mysql_query("SELECT FROM `prf_request_detl` WHERE `po_code`='$poNumber' GROUP BY `header_ref_code`"); echo "<p style='font-family:Yu Gothic Light;font-size:12px;color:gray;padding:10px;padding-bottom:0px;text-align:right;margin:2px;float:left;margin-right:30px;font-weight:bold;width:95%'>P.O INFORMATION:</p>"; while($prf = mysql_fetch_array($getPRFNumber)){ $refCode= $prf['header_ref_code']; $reqID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $reqFName =mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqID'"),0); $reqLName =mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqID'"),0); $dealID = mysql_result(mysql_query("SELECT `deal_id` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); echo "<div style='width:95%;float:left;padding:0px;border:0px solid gray;margin-left:2%'>"; echo "<p style='width:100%;text-align:right;font-family:Yu Gothic Light;font-size:9px;color:#464140;padding:0px;padding-top:0px;margin:1px;float:left;margin-left:10px;font-weight:normal'>PRF NUMBER: ".$refCode."</p>"; echo "<p style='width:100%;text-align:right;font-family:Yu Gothic Light;font-size:9px;color:#464140;padding:0px;padding-top:0px;margin:1px;float:left;margin-left:10px;font-weight:normal'>DEALERSHIP: ".strtoupper($dealName)."</p>"; echo "<p style='width:100%;text-align:right;font-family:Yu Gothic Light;font-size:9px;color:#464140 ;padding:0px;padding-top:0px;margin:1px;float:left;margin-left:10px;font-weight:normal'>REQUESTOR: ".strtoupper($reqFName)." ".strtoupper($reqLName)."</p>"; echo "</div>"; } $purposeOfRequest = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); echo "<p style='width:100%;text-align:right;font-family:Yu Gothic Light;font-size:9px;color:#464140 ;padding:0px;padding-top:0px;margin:1px;float:right;margin-left:0px;font-weight:normal'>PURPOSE : ".strtoupper($purposeOfRequest)."</p>"; ?> </div> <div style='float:left;width:70%;height:100px;background:white;border:0px solid gray;margin-bottom:2px;margin-top:0px;padding:1px'> <p style='font-family:Yu Gothic Light;font-size:10px;padding:1px;margin:0px;float:left;width:100%;text-align:left;font-weight:bold'>CONDITIONS:</p> <p style='font-family:Yu Gothic Light;font-size:10px;padding:1px;margin:0px;float:left;width:100%;text-align:left;padding-left:20px;'>1) All items and/or services shall b e in accordance with specifications stated and/or qouted.</p> <p style='font-family:Yu Gothic Light;font-size:10px;padding:1px;margin:0px;float:left;width:100%;text-align:left;padding-left:20px;'>2) All prices stated are protected from any increase and advice us immediately of any shortage or delay in delivery.</p> <p style='font-family:Yu Gothic Light;font-size:10px;padding:1px;margin:0px;float:left;width:100%;text-align:left;padding-left:20px;'>3) We reserve the right to return any goods or reject any service upon discovery of defects not apparent at time of receipt</p> <p style='font-family:Yu Gothic Light;font-size:10px;padding:1px;margin:0px;float:left;width:100%;text-align:left;padding-left:20px;'>4) To ensure payment according to above terms, submit a duplicate of the original invoice immediately upon delivery and acceptance.</p> <p style='font-family:Yu Gothic Light;font-size:9px;padding:1px;margin:0px;float:left;width:100%;text-align:left;padding-left:20px;'>5) Terms of payment shall commence from date order has been fully delivered.</p> </div> <div style='float:left;width:100%;height:100px;background:white;border:0px solid gray;margin-bottom:2px'> <div style='float:left;width:27%;height:90px;background:white;border:0px solid gray;margin:5px;margin-right:15px'> <div style='font-family:Yu Gothic Light;font-size:12px;text-align:left;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-bottom:0px;margin-top:15px'> Prepared By: </div> <div style='font-family:Yu Gothic Light;font-size:13px;text-align:center;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-top:0px;border-bottom:1px solid gray;;margin-top:10px '> <?php $datePosted = mysql_result(mysql_query("SELECT `date_posted` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $timePosted = mysql_result(mysql_query("SELECT `time_created` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); echo "Signed on ".$datePosted." @ ".$timePosted; ?> </div> <div style='font-family:Yu Gothic Light;font-size:13px;text-align:center;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-top:0px'> <?php $getPreparedPOBy = mysql_result(mysql_query("SELECT `created_by` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $getPreparedByFNAme =mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getPreparedPOBy'"),0); $getPreparedByLNAme =mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getPreparedPOBy'"),0); echo strtoupper($getPreparedByLNAme).", ".strtoupper($getPreparedByFNAme); ?> </div> </div> <div style='float:left;width:27%;height:90px;background:white;border:0px solid gray;margin:5px;margin-right:15px'> <div style='font-family:Yu Gothic Light;font-size:12px;text-align:left;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-bottom:0px;margin-top:15px'> Checked By: </div> <div style='font-family:Yu Gothic Light;font-size:13px;text-align:center;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-top:0px;border-bottom:1px solid gray;;margin-top:10px'> <?php $dateChecked = mysql_result(mysql_query("SELECT `date_checked` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $timeChecked = mysql_result(mysql_query("SELECT `time_checked` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); echo "Signed on ".$dateChecked." @ ".$timeChecked; ?> </div> <div style='font-family:Yu Gothic Light;font-size:12px;text-align:center;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-top:0px'> <?php $getCheckedBy = mysql_result(mysql_query("SELECT `checked_by` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $getPreparedByFNAme =mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getCheckedBy'"),0); $getPreparedByLNAme =mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getCheckedBy'"),0); echo strtoupper($getPreparedByLNAme).", ".strtoupper($getPreparedByFNAme); ?> </div> </div> <div style='float:left;width:27%;height:90px;background:white;border:0px solid gray;margin:5px'> <div style='font-family:Yu Gothic Light;font-size:12px;text-align:left;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-bottom:0px;margin-top:15px'> Approved By: </div> <div style='font-family:Yu Gothic Light;font-size:13px;text-align:center;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-top:0px;border-bottom:1px solid gray;;margin-top:10px'> <?php $dateApproved = mysql_result(mysql_query("SELECT `date_Approved` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $timeApproved = mysql_result(mysql_query("SELECT `time_Approved` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); echo "Signed on ".$dateApproved." @ ".$timeApproved; ?> </div> <div style='font-family:Yu Gothic Light;font-size:12px;text-align:center;float:left;width:95%;height:20px;background:white;border:0px solid gray;margin:1px;margin-top:0px'> <?php $getApprovedBy = mysql_result(mysql_query("SELECT `Approved_by` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $getPreparedByFNAme =mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getApprovedBy'"),0); $getPreparedByLNAme =mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getApprovedBy'"),0); echo strtoupper($getPreparedByLNAme).", ".strtoupper($getPreparedByFNAme); ?> </div> </div> </div> <p style='float:left;width:100%;font-family:Yu Gothic Light;font-size:10px;'>* This is a System Generated Purchase Order, physical signature might not be required * </div> </center> <?php } ?>

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