File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/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); $companyTIN = mysql_result(mysql_query("SELECT `comp_tin` 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); $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> <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:100px;float:left;border:0px solid gray;padding:10px;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 $companyTIN;?></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 style='width:70%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $POInstructions;?></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> </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:5px;font-family:Yu Gothic Light;font-size:12px;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:12px;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:12px;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:12px;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:12px;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:12px'>* * * NOTHING FOLLOWS * * </p> <?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;margin:2px;float:left;margin-right:20px;font-weight:bold;width:100%;text-align:left'>PRF NUMBER:</p>"; while($prf = mysql_fetch_array($getPRFNumber)){ $refCode= $prf['header_ref_code']; echo "<p style='font-family:Yu Gothic Light;font-size:12px;color:gray;padding:10px;padding-top:0px;margin:2px;float:left;margin-right:20px;font-weight:normal'>#".$refCode.",</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:left;width:97.8%;height:100px;background:white;border:0px solid gray;margin-bottom:2px;margin-top:0px;padding:10px'> <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 origanal invoice immediately upon delivery and acceptance.</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;'>5) Terms of payment shall commence from date order has been fully delivered.</p> <i style='font-family:Yu Gothic Light;font-size:9px;padding:1px;margin:0px;float:left;width:100%;text-align:left;padding-left:0px;'>The Seller/Provider unconditionally warrants that the provision of service and /or products is made in good faith and in full compliance with existing laws. The Seller / Provider shall be solely liable for, indemnity and hold Autohub Group Holdings, Inc. and its affiliates free and harmless from any and all liability, claim, causes of action, less and or damage arising from any provisions of service.</i> </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='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