File manager

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

Back
<?php include_once 'core/init.php'; $signedDate = date_create() ->format("Y-m-d"); $signedTime =date('H:i:s'); $myUID = $user_data['u_id']; if(isset($_GET['prf'])){ $prfNumber=$_GET['prf']; $aLink = mysql_result(mysql_query("SELECT `attachment` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $attachmentLink = 'https://www.autohub.ph/connect/home/FILES/prfdoc/'.$aLink; echo "<input type='hidden' id='prfNumber' value='".$prfNumber."'>"; $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),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); $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $itemCat = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $itemCatName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$itemCat'"),0); $purposeOfReq = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $reqBy = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $reqByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqBy'"),0); $aprBy = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $aprByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprBy'"),0); $aprByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprBy'"),0); $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); ?><center> <style> .aprbutton{ float:right; width:100%; border-radius:5px; font-family:Yu Gothic Light; font-size:14px; color: #ffffff; font-weight:normal; margin:3px; cursor:pointer; background:#ef4901; padding:5px; border:2px solid white; margin-bottom:5px; } .aprbutton:hover{ float:right; width:100%; border-radius:5px; font-family:Yu Gothic Light; font-size:14px; color:#ffffff; font-weight:bold; margin:3px; margin-bottom:5px; cursor:pointer; background:#ef2901; padding:5px; border:2px solid white; } .popup { position: fixed; top: 50%; left: 50%; -webkit-transform: translate(-50%, -50%); transform: translate(-50%, -50%); height:200px; padding:10px; border-radius:10px; width:350px; background:#fff; border:1px solid red; display:none; } .buttonOTP{ padding:10px; border-radius:5px;border:1px solid #f11806;background:#f0670e;color:white;width:80%;margin-left:30px;margin-right:30px;font-size:14px } .buttonOTP:hover{ padding:10px; border-radius:5px;border:1px solid #f11806;background:#f11806;color:white;font-weight:bold;width:80%;margin-left:30px;margin-right:30px;font-size:14px; } .buttonOTPX{ float:right;padding:5px;border-radius:5px;border:1px solid #f11806;background:#fff;color:white } .buttonOTPX:hover{ float:right;padding:5px;border-radius:5px;border:1px solid #f11806;background:#fff;color:white;font-weight:bold } </style> <input type='hidden' id='myUID' value='<?php echo $myUID;?>'> <input type='hidden' id='SignedDate' value='<?php echo $signedDate;?>'> <input type='hidden' id='SignedTime' value='<?php echo $signedTime;?>'> <input type='hidden' id='tokenKey' value='<?php echo $myToken;?>'> <input type='hidden' id='myPONumber' value='<?php echo $prfNumber;?>'> <div style='padding:10px;margin:0%;width:60%;min-width:750px;border:0px solid gray;min-height:1000px;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'> PURHCASE REQUEST FOR GEN. MANAGER APPROVAL </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'>Requested By:</td> <td style='width:40%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo strtoupper($reqByLName).", ". strtoupper($reqByFName);?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>Category:</td> <td style='width:30%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $itemCatName;?></td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>PRF Number:</td> <td style='width:40%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $prfNumber;?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>Date Needed:</td> <td style='width:30%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $dateNeeded;?></td> </tr> <tr> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold'>Approving Head:</td> <td style='width:40%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'><?php echo $aprByLName.", ". $aprByFName;?></td> <td style='width:15%;border:0px;padding:1px;font-family:Yu Gothic Light;font-size:12px;text-align:right;font-weight:bold'>Purpose of Request:</td> <td style='width:30%;border:0px;border-bottom:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px;padding-left:10px'><?php echo $purposeOfReq;?> </td> </tr> </table> </div> </div> <div style='float:left;width:99.8%;height:50px;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'> </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 strtoupper($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'> </td> <td style='width:70%;border:0px;border-bottom:0px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:13px'> </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:20%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>ASSET TYPE</td> <td style='width:64%;border:1px solid gray;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>DESCRIPTION</td> </tr> </table> </div> <div id='contentTable' 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 `header_ref_code`='$prfNumber' AND `deleted`=0"); while($row=mysql_fetch_array($getPOItems)){ $itemCID = $row['item_class']; $itemCName = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='$itemCID'"),0); 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['quantity']."</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:20%;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;padding-right:5px;border-bottom:1px solid gray;'>".strtoupper($itemCName)."</td>"; echo "<td style='width:64%;border:0px solid gray;border-right:0px 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 "</tr>"; } ?> </table> <p style='text-align:center;font-family:Yu Gothic Light;font-size:12px'>* * * 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> </center> <?php } ?>

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