File manager

File manager - Edit - /home/autoph/home4/autoph/PRF_procurement_page.php

Back
<?php ob_start(); include 'core/init.php'; protected_page(); $ADMAccess = $user_data['CL_ADM']; $PAYADM = $user_data['PAY_ADM']; $HRDADM = $user_data['HRD_ADM']; $CHKADM = $user_data['CHK_ADM']; $TREADM = $user_data['TRE_ADM']; $LEGADM = $user_data['LEG_ADM']; $RESADM = $user_data['RES_ADM']; $CHKCRE = $user_data['CHK_CRE']; $OBLADM = $user_data['OBL_ADM']; $PRFPRO = $user_data['PRFPRO']; $PRFPUR = $user_data['PRFPUR']; $PRFSET = $user_data['PRFSET']; $MATRIX = $user_data['MATRIX']; $ITMASTER= $user_data['ITMASTER']; $MyDeptID=$user_data['dept_id']; $userID=$user_data['u_id']; $chkIfMemberofExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$userID' AND `deleted`=0 AND `authority`=3"),0); echo "<input type='hidden' id='isEXECOM' value='".$chkIfMemberofExecom."'>"; $comID=$user_data['company']; echo "<input type='hidden' id='passCompID' value='".$comID."'>"; ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="css/styleP.css"> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="js/jquery-1.11.0.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function () { yourFunction(); }); function yourFunction(){ //alert('test'); //$("#PageSixbox").slideToggle(); $("#PageFivebox").slideToggle(); $("#PageFourbox").slideToggle(); $("#PageThreebox").slideToggle(); //$("#PageTwobox").slideToggle(); $("#PageOnebox").slideToggle(); } </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <?php include_once 'css/styleP.css';?> <!--<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!--- 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="https://code.jquery.com/jquery-1.9.1.js"></script> --> <!-- add jquery https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script type="text/javascript"> $(document).ready(function(){ //======================================================================================================================================= //======================================================================================================================================= $("#goSearch").click(function(){ var searchString = $("#searchString").val(); //var searchValue= $("input:radio[name=searchValue] :checked").val(); var radioValue = $("input[name='searchValue']:checked").val(); //alert(radioValue); if(searchString==""){ Swal.fire('Invalid Entry. Please try again') exit; } //$("#PageOnebox").slideToggle(); // $("#PageTwobox").slideToggle(); //$("#PageThreebox").slideToggle(); // $("#PageFourbox").slideToggle(); //fVEND $("#PageFivebox").slideToggle(); ShowUploadBar(); $.ajax({ url: "PRF_SearchResults.php", type: "POST", async: false, data: { "radioValue": radioValue, "searchString": searchString, "done": 1 }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showPRFDashboard").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_DASHBOARD_001.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#ReportList").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_PRF_ReportLists.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#dataAnalytics").click(function(){ ShowUploadBar(); $.ajax({ url: "prf_dataAnalytics.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#forMyApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_NewPRFMyForApproval.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showMyPurchaseRequest").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_OpenPurchaseRequest.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showCreateNewPRF").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_CreateNewPRF.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#showDepatPRF").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_DEPTprf.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#procIncomingInfo").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_procIncomingInfo.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#ahgAdminApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ahgPRFApproval.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#MyForCanvassPRF").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_FORCanvass.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#MyProposals").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_UploadedCanvass.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#CanvassSheet").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_CanvassSheetPreparation.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#forExecomApproval").click(function(){ var chkIfExecom = $("#isEXECOM").val(); //alert(chkIfExecom); if(chkIfExecom == 0) { Swal.fire({ icon: 'error', title: 'Access Denied', text: 'Only the EXECOM members can access this page!' //footer: '<a href="">Why do I have this issue?</a>' }) exit; }else{ ShowUploadBar(); $.ajax({ url: "PRF_EXECOM_APPROVAL.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); //======================================================================================================================================= //======================================================================================================================================= $("#MyUnReadMessage").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_UnreadMessages.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#setupAuthorizingOfficer").click(function(){ ShowUploadBar(); $.ajax({ //url: "PRF_SETUP_AssetValidator.php", PRF_SETUPAssetValidatorV2.php url: "PRF_SETUPAssetValidatorV2.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#setupGMOfficer").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SETUPGMBYCompany.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#setupEXECOMOfficerS").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SETUP_EXECOM.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#readyForPOCreation").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ReadyForPO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#activePO").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ACTIVE_PO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#readyForPOApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_POFORAPPROVAL.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#readyForPOSubmission").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_POFORSUBMISSIONTOVENDOR.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#suppliersUpdate").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ACTIVESUPPLIERSPO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= //======================================================================================================================================= $("#forPayment").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_FORPAYMENT.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#poApprover").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SETUPPOApprover.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#itemMasterFile").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_SetupItemClass.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#UpdateMatrix").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_updateMatrixTable.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#vendorManagement").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_Vendors.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#usrCanvassApproval").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_CANVASSFORUSRAPPROVAL.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //======================================================================================================================================= $("#MatrixONButton").click(function(){ var update ='OFF'; //alert(update); Swal.fire({ title: 'Do you want to save the changes?', showDenyButton: false, showCancelButton: true, confirmButtonText: 'DeActivate', denyButtonText: `Don't Activate`, }).then((result) => { /* Read more about isConfirmed, isDenied below / if (result.isConfirmed) { Swal.fire('Saved!', '', 'success') //if(confirm("CONFIRM ACTION: \n\nAre you sure you want to route ALL CANVASS APPROVAL TO EXEOM ONLY. If you proceed, the APPROVAL MATRIX TABLE will NOT be used. \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_updateMatrixKey.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { "udpate": update, "done": 1 }, success: function(d){ ShowUploadBar(); $("#MatrixONButton").fadeOut(100); $("#MatrixOFFButton").fadeIn(100); $("#mLabelA").html(d); $("#mLabelB").html(d); } }) //} } else if (result.isDenied) { Swal.fire('Changes are not saved', '', 'info') } }) }); //======================================================================================================================================= $("#MatrixOFFButton").click(function(){ var update ='ON'; //alert(update); Swal.fire({ title: 'Do you want to save the changes?', showDenyButton: false, showCancelButton: true, confirmButtonText: 'Activate', denyButtonText: `Don't Activate`, }).then((result) => { / Read more about isConfirmed, isDenied below / if (result.isConfirmed) { Swal.fire('Saved!', '', 'success') //if(confirm("CONFIRM ACTION: \n\nAre you sure you want to route ALL CANVASS APPROVAL TO EXEOM ONLY. If you proceed, the APPROVAL MATRIX TABLE will NOT be used. \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_updateMatrixKey.php", //PRF_CANVASS_FOR_USR_APPROVAL usrCanvassApproval type: "POST", async: false, data: { "udpate": update, "done": 1 }, success: function(d){ ShowUploadBar(); $("#MatrixONButton").fadeIn(100); $("#MatrixOFFButton").fadeOut(100); $("#mLabelA").html(d); $("#mLabelB").html(d); } }) //} } else if (result.isDenied) { Swal.fire('Changes are not saved', '', 'info') } }) }); }); //================== // $("#HideShowMenu").click(function(){ // $("#displayMenu").animate({width: 'toggle'}); //}); //==================== //var isOn = true; //$(function(){ // $("#HideShowMenu").click(function(){ // console.log(isOn); // if ( isOn ){ // isOn = false; // $('.BodyArea').css("width", '100%'); // // } else { // isOn = true; // $('.BodyArea').css("width", '80%'); // // } // return false; // }); //}); </script> <!-- MENU SLIDING SCRIPT --> <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script> <script> $(document).ready(function(){ $("#PageOne").click(function(){ $("#PageOnebox").slideToggle(); }); }); $(document).ready(function(){ $("#PageTwo").click(function(){ $("#PageTwobox").slideToggle(); }); }); $(document).ready(function(){ $("#PageThree").click(function(){ $("#PageThreebox").slideToggle(); }); }); $(document).ready(function(){ $("#PageFour").click(function(){ $("#PageFourbox").slideToggle(); }); }); $(document).ready(function(){ $("#PageTwoB").click(function(){ $("#PageTwoBbox").slideToggle(); }); }); $(document).ready(function(){ $("#PageFive").click(function(){ $("#PageFivebox").slideToggle(); }); }); $(document).ready(function(){ $("#PageSix").click(function(){ $("#PageSixbox").slideToggle(); }); }); function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> </head> <body style="font-family:Verdana;color:#aaaaaa;background:white"> <!--#########################################################################--> <!--#########################################################################--> <input type="hidden" id="passCompID" value="<?php echo $comID;?>"> <input type="hidden" id="passUID" value="<?php echo $userID;?>"> <!--<div style="width:100%;height:50px;padding:8px;border-bottom:1px solid #2c3e29" class="grayBG"> <div id='myDashboard'style='float:left;margin:4px;margin-left:0px;left:-20px;position:relative'><a href="connect.php" class="active" style="font-family:Calibri;font-size:18px;padding:12px;color:white;font-weight:bold;padding-right:30px;padding-right:80px;margin-left:0px;margin:2px">⇚     🌐HOME</a> </div> <div style='width:500px;float:left;margin:5px;background:transparent;margin-top:0px'><a href="#" style="float:left;font-family:Calibri;font-size:24px;font-weight:bold;color: #02133d;margin-top:0px">PROCUREMENT MANAGEMENT SYSTEM:</a></div> </div> --> <a href='#' id='HideShowMenu' style='display:none;float:left;font-family:Calibri;font-size:24px;font-weight:bold;color: #02133d;margin-top:0px'><div style='float:left;width:40px;height:40px;z-index:99999;position:absolute;margin-top:0px;margin-left:0px;border:1px solid black;border-radius:0px 10px 10px 0px;background:black;font-family:Calibri;color:white'> ◀ </div></a> <div id="displayMenu" class="subMenu" style='background:#fbfbf9'> <?php $unPostedPRFRequest = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `current_status`= '100' AND `deleted`=0 \|\| `request_by` ='$userID' AND `current_status`= '0' AND `deleted`=0"),0); $PostedPRFRequest = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `current_status` > 0 AND `current_status` < 13 AND `deleted` = 0"),0); //$userCanvassApproval= mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `request_by` ='$userID' AND `current_status`=5 AND `deleted` = 0"),0); 1024008751 $getItemUsrApproval = mysql_query("SELECT FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `deleted` = 0 AND `current_status` = 5 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemUsrApproval)){ $chkIfForUSRApproval=$row['user_canvass_approval']; $hdrRefCode = $row['reference_code']; $getMyuserApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `header_ref_code`='$hdrRefCode' AND `user_canvass_approval`= 1 AND `user_approval_ts`='' AND `create_canvass_sheet`= '0' AND `deleted`=0"),0); $userCanvassApproval = $userCanvassApproval + $getMyuserApproval; } //echo $userCanvassApproval; if($userCanvassApproval == ''){ $userCanvassApproval = '0'; } $PostedForDeptApprovalGM = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_GM_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `admin_approval_date`!=''"),0); $PostedForDeptApprovalHead = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_head_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `dept_approval_date`='' "),0); $PostedForDeptApprovalAdmin = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_admin_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `admin_approval_date`='' AND `dept_approval_date`!='' AND `gm_approval_date`!=''"),0); $PostedForDeptApproval = $PostedForDeptApprovalHead + $PostedForDeptApprovalGM + $PostedForDeptApprovalAdmin; $ActiveProposal = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_uploadedcanvass` WHERE `deleted`= 0 AND `validity_date` > '$toDate'"),0); $procIncomingView = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `current_status` < 4 AND `deleted`=0"),0); $deptPRFCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_id` '$MyDeptID' AND `deleted`=0"),0); /* $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `for_execom_canvass_approval`=0 AND `for_canvass` = 1 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $itemRefCode=$row['header_ref_code']; $getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0); if($getPRFApprovalCode == 4){ $forCanvassCount = $forCanvassCount + 1; } } / $ahgAdminApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `deleted`=0 AND `ahg_admin_id`=0 AND `ahg_admin_date`='' AND `gm_approval_date`!='' AND `dept_approval_date`!='' AND `admin_approval_date`!=''"),0); $forCanvassCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' ORDER BY id DESC"),0); if($forCanvassCount == ''){ $forCanvassCount = 0; } $MyCanvassSheet = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `create_canvass_sheet`= 1 AND `deleted`=0 AND `awarded`='0' AND `create_canvass_sheet`= 1 AND `for_execom_canvass_approval`=0 AND `canvass_sheet_creation_ts`=''"),0); $chkMyOpenMessage = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_ff_message` WHERE `read`= 1 AND `deleted`=0 AND `send_to`='$userID'"),0); $PostedExeComApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `for_execom_canvass_approval`=1 AND `canvass_sheet_creation_ts`!='' AND `execom_approval_ts`='' AND `awarded`=0"),0); $ReadyForPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`=''"),0); $POApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status` = 2"),0); $ActivePO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1"),0); $forPaymentPO = mysql_result(mysql_query("SELECT COUNT(1) FROM (SELECT FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number`) t1 "),0); $ReadySubmission = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 3"),0); $vendorsUpdate = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 4"),0); echo "<button type='button' id='PageSix' class='menuTitle' >🔎    SEARCH</button> <div id='PageSixbox' style='border:0px;margin:0px;padding:0px'>"; echo "<div class='menuItem' style='height:200px'>"; echo "<input type='text' id='searchString' style='font-size:18px;text-align:center;border-radius:5px;border:1px solid gray;padding:10px;font-family:Calibri;font-size:16px;color:black;width:100%'>"; echo "<input type='radio' id='PRFNumber' name='searchValue' value='PRFNumber' checked> <label for='PRFNumber' style='margin:10px;font-family:Calibri;font-size:16px;color:gray;font-weight:normal'>PRF Number</label><br><br> <input type='radio' id='PONumber' name='searchValue' value='PONumber'> <label for='PONumber' style='margin:10px;font-family:Calibri;font-size:16px;color:gray;font-weight:normal'>PO Number</label><br><br>"; echo "<div style='padding:15px;width:100%;'> <button id='goSearch' class='PopUpLowerButtonR' style='width:100%;border-radius:10px'>SEARCH</button> </div>"; echo "</div> "; echo "</div>"; echo "<button type='button' id='PageOne' class='menuTitle' >📊     DASHBOARD</button> <div id='PageOnebox' style='border:0px;margin:0px;padding:0px'> <div id='dataAnalytics' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>💹</div> <div class='pageMenuItemB'>DASHBOARD 1</div> <div class='pagemenuitemC'></div> </div> <div id='showPRFDashboard' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📉</div> <div class='pageMenuItemB'>DASHBOARD 2</div> <div class='pagemenuitemC'></div> </div> <div id='ReportList' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📂</div> <div class='pageMenuItemB'>GENERATE REPORTS</div> <div class='pagemenuitemC'></div> </div> </div>"; echo "<button type='button' id='PageTwo' class='menuTitle' >🙎     NAVIGATION MENU</button> <div id='PageTwobox' style='border:0px;margin:0px;padding:0px'> <div id='showCreateNewPRF' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>CREATE NEW PRF</div> <div class='pagemenuitemC' id='unPostedPRFRequestCount'>".$unPostedPRFRequest."</div> </div> <div id='showMyPurchaseRequest' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>MY ACTIVE REQUEST</div> <div class='pagemenuitemC' id='PostedPRFRequestCount'>".$PostedPRFRequest."</div> </div> <div id='usrCanvassApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>👷</div> <div class='pageMenuItemB'>USER APPROVAL</div> <div class='pagemenuitemC' id='canvassForUserApprovalCount'>".$userCanvassApproval."</div> </div> <div id='forMyApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🖌</div> <div class='pageMenuItemB'>FOR MY APPROVAL</div> <div class='pagemenuitemC' id='forMyApprovalCount'>".$PostedForDeptApproval."</div> </div> <div id='forExecomApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🤵</div> <div class='pageMenuItemB'>EXECOM APPROVAL</div> <div class='pagemenuitemC' id='forExecomApprovalCount'>".$PostedExeComApproval."</div> </div> <div id='MyUnReadMessage' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📩</div> <div class='pageMenuItemB'>MESSAGE / NOTIFICATION</div> <div class='pagemenuitemC' id='myOpenMessage'>".$chkMyOpenMessage."</div> </div> <div id='showDepatPRF' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>DEPARTMENT PRF</div> <div class='pagemenuitemC' id='unPostedPRFRequestCount'>".$deptPRFCount."</div> </div> </div>"; //######################################################################################################################################### if($PRFPRO ==1){ echo "<button type='button' id='PageThree' class='menuTitle' >📆     PROCUREMENT MONITORING</button> <div id='PageThreebox' style='border:0px;margin:0px;padding:0px'> <div id='procIncomingInfo' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📮</div> <div class='pageMenuItemB'>INCOMING REQUEST</div> <div class='pagemenuitemC' id='procIncomingCount'>".$procIncomingView."</div> </div> <div id='ahgAdminApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>AUTOHUB ADMIN APPROVAL</div> <div class='pagemenuitemC' id='AHGadminApprovalCount'>".$ahgAdminApproval."</div> </div> <div id='MyForCanvassPRF' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📝</div> <div class='pageMenuItemB'>FOR CANVASS / SOURCING</div> <div class='pagemenuitemC' id='canvassCount'>".$forCanvassCount."</div> </div> <div id='MyProposals' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🗓</div> <div class='pageMenuItemB'>UPLOAD PROPOSAL</div> <div class='pagemenuitemC' id='ProposalCount'>".$ActiveProposal."</div> </div> <div id='CanvassSheet' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🗂</div> <div class='pageMenuItemB'>CANVASS SHEET PREPARATION</div> <div class='pagemenuitemC' id='userApprovalCanvassCount'>".$MyCanvassSheet."</div> </div> </div>"; }else{ echo "<button type='button' id='PageThree' class='menuTitle' >📆     PROCUREMENT MONITORING</button> <div id='PageThreebox' style='border:0px;margin:0px;padding:0px'> <div id='procIncomingInfoXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📮</div> <div class='pageMenuItemBXXX'>INCOMING REQUEST</div> <div class='pagemenuitemCXXX' id='procIncomingCount'>".$procIncomingView."</div> </div> <div id='ahgAdminApprovalXXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📝</div> <div class='pageMenuItemBXXX'>AUTOHUB ADMIN APPROVAL</div> <div class='pagemenuitemCXXX' id='AHGadminApprovalCount'>".$ahgAdminApproval."</div> </div> <div id='MyForCanvassPRFXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📝</div> <div class='pageMenuItemBXXX'>FOR CANVASS / SOURCING</div> <div class='pagemenuitemCXXX' id='canvassCount'>".$forCanvassCount."</div> </div> <div id='MyProposalsXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🗓</div> <div class='pageMenuItemBXXX'>UPLOAD PROPOSAL</div> <div class='pagemenuitemCXXX' id='ProposalCount'>".$ActiveProposal."</div> </div> <div id='CanvassSheetXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🗂</div> <div class='pageMenuItemBXXX'>CANVASS SHEET PREPARATION</div> <div class='pagemenuitemCXXX' id='userApprovalCanvassCount'>".$MyCanvassSheet."</div> </div> </div>"; } //######################################################################################################################################### //######################################################################################################################################### if($PRFPUR ==1){ echo "<button type='button' id='PageFive' class='menuTitle' >📆     PURCHASE ORDER</button> <div id='PageFivebox' style='border:0px;margin:0px;padding:0px'> <div id='readyForPOCreation' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🗒</div> <div class='pageMenuItemB'>FOR P.O CREATION</div> <div class='pagemenuitemC' id='forPOCreation'>".$ReadyForPO."</div> </div> <div id='activePO' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🔄</div> <div class='pageMenuItemB'> P.O VALIDATION</div> <div class='pagemenuitemC' id='forPOValidation'>".$ActivePO."</div> </div> <div id='readyForPOApproval' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>⚠</div> <div class='pageMenuItemB'>FOR P.O APPROVAL</div> <div class='pagemenuitemC' id='forPOApproval'>".$POApproval."</div> </div> <div id='readyForPOSubmission' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>✅</div> <div class='pageMenuItemB'>FOR SUBMISSION TO VENDOR</div> <div class='pagemenuitemC' id='forPOSubmission'>".$ReadySubmission."</div> </div> <div id='suppliersUpdate' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>♻</div> <div class='pageMenuItemB'>ACTIVE PO (SUPPLIER)</div> <div class='pagemenuitemC' id='POSupplierCount'>".$vendorsUpdate."</div> </div> <div id='forPayment' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🚚</div> <div class='pageMenuItemB'>FOR PAYMENT</div> <div class='pagemenuitemC'id='POForPayment'>".$forPaymentPO."</div> </div> </div>"; }else{ echo "<button type='button' id='PageFive' class='menuTitle' >📆     PURCHASE ORDER</button> <div id='PageFivebox' style='border:0px;margin:0px;padding:0px'> <div id='readyForPOCreationXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🗒</div> <div class='pageMenuItemBXXX'>FOR P.O CREATION</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$ReadyForPO."</div> </div> <div id='activePOXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🔄</div> <div class='pageMenuItemBXXX'> P.O VALIDATION</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$ActivePO."</div> </div> <div id='readyForPOApprovalXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>⚠</div> <div class='pageMenuItemBXXX'>FOR P.O APPROVAL</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$POApproval."</div> </div> <div id='readyForPOSubmissionXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>✅</div> <div class='pageMenuItemBXXX'>FOR SUBMISSION TO VENDOR</div> <div class='pagemenuitemCXXX' id='forPOCreation'>".$ReadySubmission."</div> </div> <div id='suppliersUpdateXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>♻</div> <div class='pageMenuItemBXXX'>ACTIVE PO (SUPPLIER)</div> <div class='pagemenuitemCXXX' id='POSupplierCount'>".$vendorsUpdate."</div> </div> <div id='forPaymentXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🚚</div> <div class='pageMenuItemBXXX'>FOR PAYMENT</div> <div class='pagemenuitemCXXX'id='POForPayment'>".$forPaymentPO."</div> </div> </div>"; } //######################################################################################################################################### $getMatrixSetup = mysql_result(mysql_query("SELECT `matrix_on_off` FROM `asa_versioning_db` WHERE 1 "),0); if($getMatrixSetup ==='OFF'){ $matrixOn ='none'; $matrixOff ='block'; $mColor='red'; } else{ $matrixOn ='block'; $matrixOff ='none'; $mColor='green'; } //######################################################################################################################################### if($PRFSET ==1){ echo "<button type='button' id='PageFour' class='menuTitle' >⚙     SETUP</button> <div id='PageFourbox' style='border:0px;margin:0px;padding:0px'>"; if($ITMASTER ==1){ echo "<div id='itemMasterFile' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📦</div> <div class='pageMenuItemB'>ITEM MASTERFILE</div> <div class='pagemenuitemC'>"; echo "</div> </div> "; echo "<div id='setupAuthorizingOfficer' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🪤</div> <div class='pageMenuItemB'>ASSET VALIDATOR</div> <div class='pagemenuitemC'> </div> </div> <div id='setupGMOfficer' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🤵</div> <div class='pageMenuItemB'>COMPANY GEN. MANAGER</div> <div class='pagemenuitemC'> </div> </div> <div id='setupEXECOMOfficerS' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🤴</div> <div class='pageMenuItemB'>EXECOM/AVP/SVP APPROVER</div> <div class='pagemenuitemC'></div> </div> <div id='poApprover' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📜</div> <div class='pageMenuItemB'>P.O APPROVER</div> <div class='pagemenuitemC'></div> </div>"; }else{ echo "<div id='UpdateMatrixXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🏷</div> <div class='pageMenuItemBXXX'>ITEM MASTERFILE</div> <div class='pagemenuitemCXXX'>"; echo "</div> </div> "; echo "<div id='setupAuthorizingOfficerXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🪤</div> <div class='pageMenuItemBXXX'>ASSET VALIDATOR</div> <div class='pagemenuitemCXXX'> </div> </div> <div id='setupGMOfficerXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🤵</div> <div class='pageMenuItemBXXX'>COMPANY GEN. MANAGER</div> <div class='pagemenuitemCXXX'> </div> </div> <div id='setupEXECOMOfficerSXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🤴</div> <div class='pageMenuItemBXXX'>EXECOM/AVP/SVP APPROVER</div> <div class='pagemenuitemCXXX'></div> </div> <div id='poApproverXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>📜</div> <div class='pageMenuItemBXXX'>P.O APPROVER</div> <div class='pagemenuitemCXXX'></div> </div>"; } echo "<div id='vendorManagement' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>📠</div> <div class='pageMenuItemB'>MANAGE VENDORS/SUPPLIERS</div> <div class='pagemenuitemC'></div> </div>"; if($MATRIX ==1){ echo "<div id='UpdateMatrix' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>🏷</div> <div class='pageMenuItemB'>UPDATE APPROVAL MATRIX </div> <div class='pagemenuitemC'>"; echo "</div> </div> "; }else{ echo "<div id='UpdateMatrixXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>🏷</div> <div class='pageMenuItemBXXX'>UPDATE APPROVAL MATRIX </div> <div class='pagemenuitemCXXX'>"; echo "</div> </div> "; } if($MATRIX ==1){ echo "<div id='setMatrixOnOff' class='menuItem' style='height:30px'> <div class='pageMenuItemA'>☎</div> <div class='pageMenuItemB' id='mLabelA'>APPROVAL MATRIX ( <b style='font-weight:bold;color:$mColor'>".$getMatrixSetup."</b> )</div> <div class='pagemenuitemC'>"; echo "<div style='width:100%;border:1px solid #3e3d3d ;background: #dbd5d4 ;height:16px;border-radius:10px;'> <button id='MatrixOFFButton' style='cursor:pointer;width:40%;height:12px;margin:1px;background:red;float:left;display:$matrixOff;border-radius:5px;'></button> <button id='MatrixONButton'style='cursor:pointer;width:40%;height:12px;margin:1px;background:green;float:right;display:$matrixOn;border-radius:5px;'></button> </div>"; echo "</div> </div> "; }else{ echo "<div id='setMatrixOnOffXXX' class='menuItem' style='height:30px'> <div class='pageMenuItemAXXX'>☎</div> <div class='pageMenuItemBXXX' id='mLabelB'>APPROVAL MATRIX ( <b style='font-weight:bold;color:$mColor'>".$getMatrixSetup."</b> )</div> <div class='pagemenuitemCXXX'>"; echo "<div style='width:100%;border:1px solid #3e3d3d ;background: #dbd5d4 ;height:16px;border-radius:10px;'> <button id='MatrixOFFButtonXXX' style='cursor:pointer;width:45%;height:12px;margin:1px;background: #afaead;float:left;display:$matrixOff;border-radius:5px;'></button> <button id='MatrixONButtonXXX'style='cursor:pointer;width:45%;height:12px;margin:1px;background:gray;float:right;display:$matrixOn;border-radius:5px;'></button> </div>"; echo "</div> </div> "; } echo "</div>"; } //######################################################################################################################################### ?> </div> <div id="cleranceTemplateView" class="bodyArea"> <?php include_once 'PRF_DASHBOARD_001.php';?> </div> <!--<div style="text-align:center;float:left;width:100%;height:auto;margin:0px;border:0px solid red;padding:0px;background:black"> <?php //include 'footer.php';?> </div> --> </body> </html> <!--https://unicode-table.com/en/emoji/#link-objects-->

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