File manager

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

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; $ITADM = $user_data['IT_ADM']; $PRFPUR = $user_data['PRFPUR']; //echo $uniqueRefID; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> <link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> </head> <body> <div class='NewPRFHeader' style='width:100%;background:black'> <p class='PRFBodyTitle' style='width:60%;float:left'>📝  EXECOM approval</p> <?php if($ITADM == 1){ ?> <!-- <button class='PRFBodyTitle' onclick="javascript:showSMSFollowup(this);" style='float:right;padding:1px;width:250px; text=align:right;background:red'>Send SMS Follow-up</button> --> <?php } ?> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div id="sendSMSFF" class="usrCanvassApprovalForm" style='width:650px;height:280px;background:white;top:80px;left:80px'> <div class='PopUpWindowTitle'> 🪧 SEND SMS Follow up <div class='PopUpWindowClose'> <b onclick="javascript:hideSMSFollowup(this);" style='font-weight:bold'> ✕ </b> </div> </div> <input type='hidden' id='SeletedPRFItemID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <!--###################################################################################################################################--> <div id='loadEndorsedCanvass' style='padding:10px;width:100%;height:130px;background:white;'> <div style='background:lightgray;float:left;width:100%;padding:5px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemDesc'><b style='font-size:14px;color:black'>SENDING SMS ALERT TO ALL EXECOM MEMBERS: <div style='padding:20px;width:100%;height:100px;background:white;font-weight:normal;font-size:16px'> By clicking the SEND button below, you confirm to send SMS follow up to all EXECOM Members reminding them to process all pending Purchase Request </div> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div style='float:right;width:100%;height:60px;background:white;padding:15px'> <button id='sendSMSFFtoEXECOM' class='PopUpLowerButtonR' style='width:30%;float:right;padding-left:20px'>📩   SEND SMS</button> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <!--########################## MAIN TABLE WINDOW ############################################--> <!--########################################################################################################--> <div class='NewPRFBody'> <input type='hidden' id='userActiveID' value='<?php echo $uniqueRefID;?>'> <input type='hidden' id='requestorID'> <input type='hidden' id='matrixLabe'> <input type='hidden' id='matrixLabeName'> <!--<div class='NewPRFBodyMenu'> <div class='searchDIVA'> <b class='BodyTopMenu' id='LoadNewPRFForm' onclick='showActionSlipForm()'>➕ New Purchase </b> <b class='BodyTopMenu'>📠 Print </b> <b class='BodyTopMenu' onclick="javascript:getInfoCode(this);">⬇ Export</b> </div <div class='searchDIVB'> <input type='text' id='SearchCanvass' placeholder='Search Record.' class='textSearch' style='width:70%;margin:0px;border:1px solid lightgray;'> <button id='goSearchCanvass' class='searchButton' style='width:25%'> 🔍       Search</button> </div> </div>>--> <div id='msgHandler'></div> <div id='mainTable' class='PRFTableBody' style='overflow:auto'> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:5%;font-size:11px'>REC.#</th> <th style='width:7%;font-size:11px'>COMPANY</th> <th style='width:15%;font-size:11px'>REQUESTOR</th> <th style='width:30%;font-size:11px'>ITEM DESCRIPTION</th> <th style='width:14%;font-size:11px'>CATEGORY</th> <th style='width:4%;font-size:11px'>QTY</th> <th style='width:8%;font-size:11px'>DATE NEEDEd</th> <th style='width:13%;font-size:11px'>REQ. OFFICERS</th> <th style='width:4%;font-size:11px'>LEVEL</th> </thead> </table> </div> <div class='PRFTableItems'> <table id='LoadUserApprovedCanvassItem'> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `for_execom_canvass_approval`= 1 AND `deleted`=0 AND `awarded`='0' AND `execom_approval_ts`='' AND `item_status`!=99"); while($row=mysql_fetch_array($getItemHdr)){ $chkIfAlreadySigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$uniqueRefID'"),0); if($chkIfAlreadySigned == 0){ $activeItemID =$row['id']; $regHDRcode=$row['header_ref_code']; $regCat=$row['category_id']; $regCatName =mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$regCat'"),0); $reqByID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompID=$row['comp_id']; $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqByID'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqByID'"),0); $getCompanyGMID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM prf_request_hdr WHERE `reference_code`='$regHDRcode'"),0); $getGMIDFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$getCompanyGMID'"),0); $getGMIDLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$getCompanyGMID'"),0); $getDeptID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); //echo $getDeptID; $getDeptIDFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$getDeptID'"),0); $getDeptIDLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$getDeptID'"),0); $getEndorsedAmountFromCanvassSheet = mysql_result(mysql_query("SELECT `amount` FROM `prf_canvass_sheet` WHERE `item_id`='".$row['id']."' AND `user_feedback` = 1 AND `user_feedback` != 0"),0); $getRequiredApprover = mysql_result(mysql_query("SELECT `requiredApproverID` FROM `prf_approval_matrix` WHERE '$getEndorsedAmountFromCanvassSheet' BETWEEN `min_amount` AND `max_amount`"),0); $getRAFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getRequiredApprover'"),0); $getRALName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getRequiredApprover'"),0); $chkIfRAOSigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$getRequiredApprover'"),0); $getMatrixLevel = mysql_result(mysql_query("SELECT `level` FROM `prf_approval_matrix` WHERE '$getEndorsedAmountFromCanvassSheet' BETWEEN `min_amount` AND `max_amount`"),0); if($getMatrixLevel == 5){ $pendingApproval ="Dept. Head: <br><b style='padding:2px;margin:0px;font-family:Yu Gothic Light;font-size:9px;color:blue;font-weight:normal'>(".$getDeptIDFName." ".$getDeptIDLName.")</b>"; $pendingDeptName = "Waiting for ". $getDeptIDFName . " " . $getDeptIDLName. " Approval"; if($getDeptID == $uniqueRefID){ $bgColor='#d1faa0'; $view='True'; }else{ $bgColor='#eef0eb'; $view='False'; } } if($getMatrixLevel == 4){ $chkIfGMSigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$getCompanyGMID'"),0); if($chkIfRAOSigned == 1){ $rSign = '✅'; }else{ $rSign = '❌'; } if($chkIfGMSigned == 1){ $gSign = '✅'; }else{ $gSign = '❌'; } $pendingApproval ="GM/SVP/AVP <b style='padding:2px;margin:0px;font-family:Yu Gothic Light;font-size:9px;color:blue;font-weight:normal'> <br>(".$gSign.") ".$getGMIDFName." ".$getGMIDLName." <br>(".$rSign.") ".$getRAFName." ".$getRALName." </b>"; $pendingDeptName = "Waiting for approval..."; if($getCompanyGMID == $uniqueRefID \|\| $getRequiredApprover==$uniqueRefID){ $bgColor='#ff8480 '; $view='True'; }else{ $bgColor='#eef0eb'; $view='False'; } } if($getMatrixLevel < 4){ $chkIfImExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$uniqueRefID' AND `authority` < 4 AND `comp_id`='$reqCompID'"),0); //echo "Im EXE". $chkIfImExecom . "comp: " .$reqCompID; $ExecomCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."'"),0); if($chkIfRAOSigned == 1){ $rSign = '✅'; }else{ $rSign = '❌'; } $pendingApproval ="EXECOM:<b style='padding:2px;margin:0px;font-family:Yu Gothic Light;font-size:9px;color:blue;font-weight:normal'>(Any of EXECOM Members)</b>"; $pendingApproval ="ANY EXECOM MEMBERS: <b style='padding:2px;margin:0px;font-family:Yu Gothic Light;font-size:9px;color:blue;font-weight:normal'> <br>".$ExecomCount." out of 3 has been signed <br>(".$rSign.") ".$getRAFName." ".$getRALName." </b>"; $pendingDeptName = "Waiting for ". $getGMIDFName . " " . $getGMIDLName. " Approval"; $pendingDeptName = "Waiting for EXECOM Approval"; if($chkIfImExecom > 0){ $bgColor='#ff8480 '; $view='True'; }else{ $bgColor='#eef0eb'; $view='False'; } } if($PRFPUR==1){ ?><tr onclick="javascript:getInfoB(this);" title="<?php echo strtoupper($pendingDeptName); ?>"><?php echo "<td style='width:5%;background:$bgColor'>".$row['id']."</td>"; echo "<td style='width:7%;background:$bgColor;'>".strtoupper($reqCompName); echo "<br><i style='font-family:Calibri;font-size:10px;color:#f74f06'>PRF.#: ".$regHDRcode ."</i>"; echo "</td>"; echo "<td style='width:15%;background:$bgColor;'>".strtoupper($reqByLName).", ".strtoupper($reqByFName); $chkIfWithComment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomnotes` WHERE `item_id`='$activeItemID'"),0); if($chkIfWithComment > 0){ echo "<br> 🚩"; } echo"</td>"; echo "<td style='width:30%;background:$bgColor;text-align:left;'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:15%;background:$bgColor;text-align:left;'>".$regCatName."</td>"; echo "<td style='width:4%;background:$bgColor;text-align:left;'>".strtoupper($row['quantity'])."</td>"; echo "<td style='width:8%;background:$bgColor;'>".strtoupper($dateNeeded)."</td>"; echo "<td style='width:13%;background:$bgColor;'>".strtoupper($pendingApproval)."</td>"; echo "<td style='width:3%;background:$bgColor;'>".strtoupper($getMatrixLevel)."</td>"; echo "</tr>"; }else{ if($view === 'True'){ ?><tr onclick="javascript:getInfoB(this);" title="<?php echo strtoupper($pendingDeptName); ?>"><?php echo "<td style='width:5%;'>".$row['id']."</td>"; echo "<td style='width:7%;'>".strtoupper($reqCompName)."</td>"; echo "<td style='width:15%;'>".strtoupper($reqByLName).", ".strtoupper($reqByFName); $chkIfWithComment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomnotes` WHERE `item_id`='$activeItemID'"),0); if($chkIfWithComment > 0){ echo "<br> 🚩"; } echo "</td>"; echo "<td style='width:30%;text-align:left;'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:15%;text-align:left;'>".$regCatName."</td>"; echo "<td style='width:4%;text-align:left'>".strtoupper($row['quantity'])."</td>"; echo "<td style='width:8%;'>".strtoupper($dateNeeded)."</td>"; echo "<td style='width:13%;'>".strtoupper($pendingApproval)."</td>"; echo "<td style='width:3%;'>".strtoupper($getMatrixLevel)."</td>"; echo "</tr>"; } } } } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='2' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:normal'>Selected Record:</td> <td colspan='7' style='background:white;'> <input type='hidden' id='selectedPRFHeaderID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> </td> </tr> </table> </div> </div> </div> <!--###################################################################################################################################--> <div id='overrideForm' style='display:none;position:fixed; height:445px;width:500px;background:#ffffff;top:140px;left:20%;z-index:999999999;border:1px solid black'> <div class='PopUpWindowTitle'> 🪧 REQUEST OVERRIDE APPROVAL: <div class='PopUpWindowClose'> <b onclick="javascript:hideoverrideForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div id='SendoverrideForm' style='width:100%;overflow:auto;height:90%;padding:10px'> <b style='padding-top:10px;float:left;width:100%;;font-family:Calibri;font-size:12px;'>NOTES / INSTRUCTIONS:</b><br> <textarea id='myoverrideNotes' rows="3"style='width:100%;padding:10px;border:1px solid lightgray;'></textarea> <p id='fname' style='font-weight:normal;margin-bottom:2px;font-size:12px;'>NAME OF BACK UP APPROVER: </p> <?php $bckID = mysql_result(mysql_query("SELECT `override_id` FROM `vts_users` WHERE `u_id`=1101"),0); $backupApproverFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$bckID'"),0); $backupApproverLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$bckID'"),0); $backupApproverMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$bckID'"),0); $backupApproverName =$backupApproverFName ." " .$backupApproverLName; echo "<input type='hidden' id='overEMPID' value='$bckID'>"; echo "<input type='hidden' id='overEMPMobile' value='$backupApproverMobile'>"; echo "<input type='hidden' id='overEMPExecutiveID' value='1101'>"; ?> <div style='background:lightgray;float:left;width:98.5%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> <input type='text' id='overrideName' value='<?php echo "Name: ". strtoupper($backupApproverName) . " \| Mobile: ".$backupApproverMobile;?>' disabled style='float:left;width:95%%;margin:0px'> </div> <p id='fname' style='font-weight:normal;margin-bottom:2px;font-size:12px;'>ITEM TO BE APPROVED: </p> <div style='background:lightgray;float:left;width:98.5%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> <input type='text' id='overrideItemDesc' disabled style='float:left;width:95%%;margin:0px'> </div> <p id='fname' style='font-weight:normal;margin-bottom:2px;font-size:12px;'>ITEM NUMBER: </p> <div style='background:lightgray;float:left;width:98.5%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> <input type='text' id='overrideItemprf' disabled style='float:left;width:95%%;margin:0px'> </div> <center><br><br><button id='sendMyoverride' class='PopUpLowerButtonR' style='width:40%;float:right;padding-left:20px;margin-top:20px'>📩   SEND REQUEST</button> <p id='overrideMsg'></p> <center> </div> </div> <!--###################################################################################################################################--> <div id='SendmycommentBox' style='display:none;position:fixed; height:445px;width:500px;background:#ffffff;top:140px;left:20%;z-index:999999999;border:1px solid black'> <div class='PopUpWindowTitle'> 🪧 SEND COMMENT: <div class='PopUpWindowClose'> <b onclick="javascript:hideSendConfirmedItem(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div id='SendcommentContent' style='width:100%;overflow:auto;height:90%;padding:10px'> <b style='padding-top:10px;float:left;width:100%;;font-family:Calibri;font-size:12px;'>TYPE YOUR COMMENT:</b><br> <textarea id='myCommentNotes' rows="5"style='width:100%;height:70%;padding:10px;border:1px solid lightgray;'></textarea> <center><br><br><button id='sendMyComment' class='PopUpLowerButtonR' style='width:40%;float:right;padding-left:20px'>📩   SEND COMMENT</button><center> </div> </div> <!--###################################################################################################################################--> <div id='mycommentBox' style='display:none;position:fixed; height:545px;width:500px;background:#fef8c1;top:80px;left:1%;z-index:9999999;border:1px solid black;border-right:1px solid #fef8c1;'> <div class='PopUpWindowTitle'> 🪧 NOTES FROM APPROVING OFFICERS: <div class='PopUpWindowClose'> <b onclick="javascript:hideConfirmedItem(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div id='commentContent' style='width:100%;overflow:auto;height:90%;'> </div> </div> <!--###################################################################################################################################--> <div id="showGenCanvassForm" class="usrCanvassApprovalForm" style='position:fixed;height:545px;background:#ffffff;top:80px;left:510px'> <div class='PopUpWindowTitle'> 🪧 EXECOM: APPROVAL OF CANVASS <div class='PopUpWindowClose'> <b onclick="javascript:hideConfirmedItem(this);" style='font-weight:bold'> ✕ </b> </div> </div> <input type='hidden' id='SeletedPRFItemID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <!--###################################################################################################################################--> <div id='loadEndorsedCanvass' style='padding:10px;width:100%;height:250px;background:white;'> <div style='background:lightgray;float:left;width:100%;padding:5px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemDesc'><b style='font-size:14px;color:black'>USER APPROVED PROPOSAL / SPECS: <div id='loadCanvassItem' style='padding:0px;width:100%;height:200px;background:white;overflow:auto'> </div> </div> </div> <!--###################################################################################################################################--> <div id='xxxx' style='padding:10px;width:100%;height:150px;background:white;'> <div style='background:#3c6681;float:left;width:100%;padding:5px;font-family:Yu Gothic Light;color:white;font-size:14px;color:blue' id='userItemDesc'> <b style='font-size:14px;color:white'>EXECOM FINAL APPROVAL (PO will be created base on EXECOM Final Approval): </b> <div id='awardItemInfo' style='background:lightgray;padding:5px;width:100%;height:140px;margin-top:5px'> <div style='background:lightgray;float:left;width:98.5%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> Item Description: <input type='text' id='AwardItemDesc' disabled style='float:left;width:95%%;margin:0px'> </div> <div style='background:lightgray;float:left;width:62%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> Supplier Name: <input type='text' disabled id='AwardToVendorName' style='float:left;width:100%%;margin:0px'> </div> <div style='background:lightgray;float:left;width:15%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> Quantity: <input type='text' id='AwardItemQty' style='float:left;width:100%;margin:0px'> </div> <div style='background:lightgray;float:left;width:20%;padding:3px;margin:3px;font-family:Yu Gothic;color:black'> Amount: <input type='text' disabled id='AwardItemAmount' style='float:left;width:100%%;margin:0px'> </div> <input type='hidden' id='AwardItemID' style='float:left;width:10%'> <input type='hidden' id='canvassID' style='float:left;width:10%'> </div> </div> </div> <!--###################################################################################################################################--> <div style='float:right;width:100%;height:60px;background:#ffffff;;padding:15px'> <button id='AwardToVendo' class='PopUpLowerButtonR' style='width:25%;float:right;padding-left:20px'>📩   AWARD TO VENDOR</button> <button id='returnToProcurement' class='PopUpLowerButtonR' style='width:21%;float:right;padding-left:20px'>📩  RE-CANVASS</button> <button onclick="javascript:showSendConfirmedItem(this);" class='PopUpLowerButtonR' style='width:21%;float:right;padding-left:20px'>📩 &nbsp COMMENT BOX</button> <button onclick="javascript:showoverrideForm(this);" class='PopUpLowerButtonR' style='width:21%;float:right;padding-left:20px'>📩 &nbsp OVERRIDE</button> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div id="showSMSForm" class="usrCanvassApprovalForm" style='width:350px;height:180px;background:white;top:50px;left:50px;z-index:999999999999999'> <div class='PopUpWindowTitle'> 🪧 SMS FOLLOW UP <div class='PopUpWindowClose'> <b onclick="javascript:hideEXECOMSMS();" style='font-weight:bold'> ✕ </b> </div> </div> <input type='hidden' id='itemID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <input type='hidden' id='userID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <p style='margin:15px;margin-left:25px;margin-bottom:0px;font-weight:normal'>Send approval link to: </p> <input type='text' id='ApprovingOfficeName' class='TableBottomLabel' style='margin-left:20px;padding:5px;font-family:Calibri;font-size:14px;font-weight:bold;color:black;border:0px;text-align:left;margin-top:2px;' disabled> <div style='float:right;width:100%;height:60px;background:white;padding:15px;padding-bottom:3px'> <button id='sendExecomSMSXXXX' class='PopUpLowerButtonR' style='width:100%;float:right;padding-left:20px;margin-bottom:0px'>📩   SMS SMS FOLLOW UP</button> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> </body> </html> <!--- 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(){ $("#sendExecomSMSXXXX").click(function(){ var userID = $("#userID").val(); var itemID = $("#itemID").val(); //alert(userID); //alert(itemID); if(confirm("CONFIRM ACTION: \n\n Send Approval link via SMS. Click OK to confirm")){ ShowUploadBar(); $.ajax({ url: "prf_sendLinkToEXECOM.php", type: "POST", async: true, data: { "userID": userID, "itemID": itemID, "done": 1 }, success: function(d){ $("#msgHandler").html(d); hideEXECOMSMS(); ShowUploadBar(); hideConfirmedItem(); } }) } }); //====================================================================================================== $("#sendSMSFFtoEXECOM").click(function(){ if(confirm("CONFIRM ACTION: \n\n Are you sure you want to send SMS follow up to all EXECOM Members?")){ ShowUploadBar(); $.ajax({ url: "prf_sendEXECOMSMSFF.php", type: "POST", async: true, data: { "done": 1 }, success: function(d){ $("#mainTable").html(d); hideSMSFollowup(); ShowUploadBar(); } }) } }); //====================================================================================================== $("#AwardToVendo").click(function(){ var AwardItemID = $("#AwardItemID").val(); var canvassID = $("#canvassID").val(); var AwardItemAmount = $("#AwardItemAmount").val(); var AwardItemQty = $("#AwardItemQty").val(); //alert(AwardItemID); //alert(canvassID); //exit; if(AwardItemID==''){ alert('ERROR: No item was selected'); return false; } if(canvassID==''){ alert('ERROR: Please select proposal to continue...'); return false; } if(AwardItemQty==''){ alert('ERROR: Invalid Quantity'); return false; } if(AwardItemAmount==''){ alert('ERROR: Invalid Amount'); return false; } ShowUploadBar(); $.ajax({ //url: "PRF_EXECOM_AwardToVendor.php", url: "PRF_EXECOMAwardToVendorV2.php", type: "POST", async: true, data: { "AwardItemID": AwardItemID, "canvassID": canvassID, "AwardItemAmount": AwardItemAmount, "AwardItemQty": AwardItemQty, "done": 1 }, success: function(d){ $("#LoadUserApprovedCanvassItem").html(d); hideConfirmedItem(); $('#AwardItemAmount').val(''); ShowUploadBar(); UpdateExecomForApprovalCount(); } }) }); //====================================================================================================== $("#goSearchCanvass").click(function(){ var SearchCanvass = $("#SearchCanvass").val(); ShowUploadBar(); $.ajax({ url: "PRF_Search_CanvassFile.php", type: "POST", async: true, data: { "SearchCanvass": SearchCanvass, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTable").html(d); } }) }); //====================================================================================================== $("#returnToProcurement").click(function(){ var AwardItemID = $("#AwardItemID").val(); var canvassID = $("#canvassID").val(); var AwardItemAmount = $("#AwardItemAmount").val(); var AwardItemQty = $("#AwardItemQty").val(); var matrixLabe = $("#matrixLabe").val(); var matrixLabeName = $("#matrixLabeName").val(); //alert(canvassID); //exit; if(confirm("CONFIRM ACTION: \n\n Return to procurement for re-canvass. \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_RETURN_TO_PROCUREMENT_for_ReCanvass.php", type: "POST", async: true, data: { "AwardItemID": AwardItemID, "canvassID": canvassID, "AwardItemAmount": AwardItemAmount, "AwardItemQty": AwardItemQty, "matrixLabe": matrixLabe, "matrixLabeName": matrixLabeName, "done": 1 }, success: function(d){ $("#mainTable").html(d); hideConfirmedItem(); ShowUploadBar(); UpdateExecomForApprovalCount(); updateCanvassSheetCount(); } }) } }); //====================================================================================================== //====================================================================================================== $("#LoadUserApprovedCanvassItem").click(function(){ var SeletedPRFItemID = $("#SeletedPRFItemID").val(); var matrixLabe = $("#matrixLabe").val(); var matrixLabeName = $("#matrixLabeName").val(); var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); ShowUploadBar(); //alert(SeletedPRFItemID); $.ajax({ url: "PRF_LOADUserApprovedCanvass.php", type: "POST", async: false, data: { "selectedPRFHeaderID": selectedPRFHeaderID, "SeletedPRFItemID": SeletedPRFItemID, "matrixLabe": matrixLabe, "matrixLabeName": matrixLabeName, "done": 1 }, success: function(d){ ShowUploadBar(); $("#loadCanvassItem").html(d); loadExecomComments(); } }) }); //====================================================================================================== $("#sendMyoverride").click(function(){ var itemID = $("#SeletedPRFItemID").val(); var myoverrideNotes = $("#myoverrideNotes").val(); var senderID = $("#userActiveID").val(); var overEMPID = $("#overEMPID").val(); var overEMPMobile = $("#overEMPMobile").val(); var overEMPExecutiveID = $("#overEMPExecutiveID").val(); if(myoverrideNotes ===""){ alert('Please add your notes or instructions.'); return false; } // alert(overEMPID); // alert(overEMPMobile); // alert(overEMPExecutiveID); // return false; ShowUploadBar(); //alert(SeletedPRFItemID); $.ajax({ url: "prf_saveOverrideApproval.php", type: "POST", async: true, data: { "myoverrideNotes": myoverrideNotes, "senderID": senderID, "overEMPExecutiveID": overEMPExecutiveID, "overEMPMobile": overEMPMobile, "overEMPID": overEMPID, "itemID": itemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#overrideMsg").html(d); hideoverrideForm(); $('#myoverrideNotes').val(''); } }) }); //====================================================================================================== $("#sendMyComment").click(function(){ var itemID = $("#SeletedPRFItemID").val(); var myComment = $("#myCommentNotes").val(); var requestorID = $("#requestorID").val(); var senderID = $("#userActiveID").val(); ShowUploadBar(); //alert(SeletedPRFItemID); $.ajax({ url: "prf_saveExecomComment.php", type: "POST", async: true, data: { "myComment": myComment, "senderID": senderID, "requestorID": requestorID, "itemID": itemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#commentContent").html(d); loadExecomComments(); hideSendConfirmedItem(); $('#myCommentNotes').val(''); } }) }); //====================================================================================================== function updateCanvassSheetCount(){ $.ajax({ url: "PRF_UpdateCanvassSheetCount.php", type: "POST", async: true, data: { "trans":1 }, success: function(d){ $("#userApprovalCanvassCount").html(d); } }) } //====================================================================================================== function loadExecomComments(){ var itemID = $("#SeletedPRFItemID").val(); ShowUploadBar(); $.ajax({ url: "prf_PortalCommentLoadData.php", type: "POST", async: true, data: { "itemID": itemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#commentContent").html(d); } }) } //====================================================================================================== function UpdateExecomForApprovalCount(){ $.ajax({ url: "PRF_UpdateExecomForApprovalCount.php", type: "POST", async: true, data: { "trans":2 }, success: function(d){ $("#forExecomApprovalCount").html(d); } }) } //====================================================================================================== function updateApprovalPRF(){ $.ajax({ url: "PRF_procIncomingInfo.php", type: "POST", async: true, data: { "trans":2 }, success: function(d){ $("#forMyApprovalCount").html(d); } }) } //====================================================================================================== function refreshMainTable(){ $.ajax({ url: "PRF_MainTableHeaderDisplay.php", type: "POST", async: true, data: { }, success: function(d){ //invShowAssignMsg(); $("#mainTable").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> function showSMSFollowup(){ $("#sendSMSFF").fadeIn(500); }; function hideSMSFollowup(){ $("#sendSMSFF").fadeOut(500); }; function hideConfirmedItem(){ $("#showGenCanvassForm").fadeOut(500); $("#mycommentBox").fadeOut(500); }; function showConfirmedItem(){ $("#showGenCanvassForm").fadeIn(500); $("#mycommentBox").fadeIn(500); }; function hideoverrideForm(){ $("#overrideForm").fadeOut(500); }; function showoverrideForm(){ $("#overrideForm").fadeIn(500); }; function hideSendConfirmedItem(){ $("#SendmycommentBox").fadeOut(500); }; function showSendConfirmedItem(){ $("#SendmycommentBox").fadeIn(500); }; function hideUploadForm(){ $("#MyUploadForm").fadeOut(500); }; function showUploadForm(){ $("#MyUploadForm").fadeIn(500); }; function hideUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeOut(500); }; function showUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeIn(500); $("#showActionViewDelete").fadeOut(500); }; function showEXECOMSMS(){ $("#showSMSForm").fadeIn(500); }; function hideEXECOMSMS(){ $("#showSMSForm").fadeOut(500); }; function getInfoBXXX(row) { var x=row.cells; document.getElementById("userID").value = x[0].innerHTML; document.getElementById("itemID").value = x[1].innerHTML; document.getElementById("ApprovingOfficeName").value = x[3].innerHTML; showEXECOMSMS(); } function getInfoB(row) { var x=row.cells; document.getElementById("AwardItemID").value = x[0].innerHTML; document.getElementById("SeletedPRFItemID").value = x[0].innerHTML; document.getElementById("overrideItemprf").value = x[0].innerHTML; document.getElementById("AwardItemDesc").value = x[3].innerHTML; document.getElementById("overrideItemDesc").value = x[3].innerHTML; document.getElementById("matrixLabe").value = x[8].innerHTML; document.getElementById("matrixLabeName").value = x[7].innerHTML; document.getElementById("selectedPRFHeaderID").value = x[0].innerHTML; showConfirmedItem(); } function getInfoCode(row) { var x=row.cells; var canvassCodeID = <?php echo $NewRefCode;?> +""+ Math.floor(Math.random() * 888) + <?php echo $uniqueRefID;?>; document.getElementById("canvassCode").value= canvassCodeID;//<?php echo $NewRefCode;?> +""+ Math.floor(Math.random() * 888) + <?php echo $uniqueRefID;?>; showUploadForm(); } function getSelectedCanvassInfo(row) { var x=row.cells; document.getElementById("AwardToVendorName").value = x[2].innerHTML; document.getElementById("AwardItemQty").value = x[3].innerHTML; document.getElementById("AwardItemAmount").value = x[4].innerHTML; document.getElementById("canvassID").value = x[0].innerHTML; } </script>

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