File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/prfgmApproval.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['id'])){ $prfNumber=$_GET['id']; echo "<input type='hidden' id='prfNumber' value='".$prfNumber."'>"; $myToken=$_GET['token']; $myKey=$_GET['key']; $userID = $_GET['uid']; $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`='$reqBy'"),0); $aprByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqBy'"),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); $chkIfPosted = mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber' AND `current_status`=2"),0); if($chkIfPosted == ''){ echo "<div id='OTPStatus' style='position:fixed;top: 50%;left: 50%;-webkit-transform: translate(-50%, -50%);transform: translate(-50%, -50%);width:100%;height:20px;float:left;text-align:center;padding:5px;font-family:Yu Gothic Light;font-size:14px;background:yellow;padding:20px;font-weight:bold;color:red'> ERROR: Purchase Request is no longer exist. </div>"; exit; } ?><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 $reqByFName.",". $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 $aprByFName.",". $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." Days";?> </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 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> <?php $getPRFNumber=mysql_query("SELECT FROM `prf_request_detl` WHERE `po_code`='$prfNumber' 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 id='deptHeadAction' style='float:left;width:100%;height:100px;background:white;border:0px solid gray;margin-bottom:2px'> <div style='float:left;width:100%;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'> Action: </div> <div style='font-family:Yu Gothic Light;font-size:13px;text-align:center;float:left;width:95%;height:35px;background:white;border:0px solid gray;margin:1px;margin-top:0px;border-bottom:0px solid gray;;margin-top:10px;padding:5px;margin-left:20%'> <?php $dateChecked = mysql_result(mysql_query("SELECT `date_checked` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $timeChecked = mysql_result(mysql_query("SELECT `time_checked` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $chkKey=mysql_result(mysql_query("SELECT `code` FROM `prf_validate_links` WHERE `po_code`='$prfNumber'"),0); $myToken=mysql_result(mysql_query("SELECT `token` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $chkIfValid = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_validate_links` WHERE `uid`='$userID' AND `code`='$myKey' AND `po_code`='$prfNumber'"),0); ?> <button id='checkButtonApproved' class='buttonOTP' style='width:25%;float:left;padding:10px;margin:15px;font-weight:bold;font-size:16px'>APPROVE</button> <button id='checkButtonDisApproved' class='buttonOTP' style='width:25%;float:left;padding:10px;margin:15px;font-weight:bold;font-size:16px'>DIS-APPROVE</button> <?php ?> </div> </div> </div> </div> </center> <div id='smsOTP' class='popup'> <div style='width:100%;height:20%;float:left;padding:5px;padding-top:0px'> <button id='sendOTPXXX' onclick="javascript:hidesmsOTP();" class='buttonOTPX'>❌</button> </div> <div style='width:100%;height:50%;float:left;padding:5px'> <input type='text' id='MyTOPCode' style='margin-left:30px;margin-right:30px;padding:8px;font-family:Yu Gothic Light;font-weight:bold;font-size:18px;color:blue;border:1px solid gray;width:80%;text-align:center'> <p style='font-family:Yu Gothic Light;font-size:14px;color:black;font-weight:normal;width:80%;margin-right:30px;margin-left:30px;padding-top:0px;margin-top:0px'>Type the OTP Code sent to your registered Mobile Number.    <b id='resendOTP' style='padding:2px;margin:2px;cursor:pointer'>♻ Resend OTP</b></p> </div> <div style='width:100%;height:30%;float:left;padding:5px'> <button id='sendOTP' class='buttonOTP'>SUBMIT</button> </div> </div> <?php } ?> <!--#########################################################################--> <div id="loadBaraData" style="display:none;position:absolute;top:40%;left:45%;width:50px;padding:5px;padding-left:2px;padding-right:2px;height:50px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="font-family:Calibri;font-size:14px;color:gray;text-align:center;margin-top:0px;background:white;display:block;width:100px;height:95px;border-radius:10px;position:relative;left:5px;padding:8px;z-index:999999999999999999;border:1px solid lightgray"> <img src='images/ajaxLoader2.gif' width="auto" height="auto" /><br><br><center>Please wait<center></div> </div> </div> <!--#########################################################################--> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== //====================================================================================================== $("#checkButtonApproved").click(function(){ var UpdateReferenceHeaderCode = $("#prfNumber").val(); var myApprovalCode = 3; //alert(UpdateReferenceHeaderCode); //exit; if(confirm("CONFIRM ACTION: \n\nAre you sure you want to APPROVE this request? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_PostNewPRF.php", type: "POST", async: false, data: { "UpdateReferenceHeaderCode": UpdateReferenceHeaderCode, "myApprovalCode": myApprovalCode, "done": 1 }, success: function(d){ ShowUploadBar(); $("#deptHeadAction").fadeOut(500); } }) } }); //====================================================================================================== //====================================================================================================== $("#checkButtonDisApproved").click(function(){ var UpdateReferenceHeaderCode = $("#prfNumber").val(); var DisApprovalCode = 93; //alert(DisApprovalCode); //exit; if(confirm("CONFIRM ACTION: \n\nAre you sure you want to DIS-APPROVE this request? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_PostNewDISAPPROVED.php", type: "POST", async: false, data: { "UpdateReferenceHeaderCode": UpdateReferenceHeaderCode, "DisApprovalCode": DisApprovalCode, "done": 1 }, success: function(d){ ShowUploadBar(); $("#deptHeadAction").fadeOut(500); } }) } }); //====================================================================================================== //====================================================================================================== }); function msgFadeOut(){ $("#OTPStatus").fadeOut(15000); } function hidesmsOTP(){ $("#smsOTP").fadeOut(500); } function showsmsOTP(){ $("#smsOTP").fadeIn(500); } function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script>

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