File manager

File manager - Edit - /home/autoph/public_html/connect/home/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']; $aLink = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number`='$prfNumber'"),0); $attachmentLink = 'https://www.autohub.ph/connect/home/FILES/prfdoc/'.$aLink; echo "<input type='hidden' id='prfNumber' value='".$prfNumber."'>"; $myToken=$_GET['token']; $myKey=$_GET['key']; echo "<input type='hidden' id='myKeyID' value='".$myKey."'>"; $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`='$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); $chkIfPosted = mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber' AND `current_status`=2"),0); //echo "Result:".$chkIfPosted; if($chkIfPosted != 2){ echo "<div id='OTPStatus' style='position:fixed;top: 50%;left: 50%;-webkit-transform: translate(-50%, -50%);transform: translate(-50%, -50%);width:100%;height:40px;float:left;text-align:center;padding:5px;font-family:Yu Gothic Light;font-size:4vw;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'> PURCHASE 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 $reqByLName.", ". $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 strtoupper($aprByLName).", ". strtoupper($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:auto;min-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 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: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;text-align:center'> <?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); ?><center> <button id='checkButtonApproved' class='buttonOTP' style='height:80px;width:25%;float:left;padding:10px;margin:15px;font-weight:bold;font-size:2vw'>APPROVE</button> <button id='checkButtonDisApproved' class='buttonOTP' style='height:80px;width:25%;float:left;padding:10px;margin:15px;font-weight:bold;font-size:2vw'>DISAPPROVE</button></center> <?php if($aLink!=""){?> <a href="<?php echo $attachmentLink;?>" target='_Blank'> <button id='checkButtonApprovedX' class='buttonOTP' style='height:80px;width:30%;float:left;padding:10px;margin:15px;font-weight:bold;font-size:2vw'>VIEW ATTACHMENT</button> </a> <?php }else{ ?><center> <button id='checkButtonApprovedX' class='buttonOTP' style='height:80px;width:30%;float:left;padding:10px;margin:15px;font-weight:bold;font-size:2vw;background:lightgray'>NO ATTACHMENT</button> </center> <?php } ?> <?php ?> </div> </div> </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 src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <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 myKeyID = $("#myKeyID").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, "myKeyID": myKeyID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#deptHeadAction").fadeOut(500); //$("#contentTable").html(d); } }) } }); //====================================================================================================== //====================================================================================================== $("#checkButtonDisApproved").click(function(){ var UpdateReferenceHeaderCode = $("#prfNumber").val(); var DisApprovalCode = 92; //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); // $("#contentTable").html(d); } }) } }); //====================================================================================================== //====================================================================================================== }); 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