File manager

File manager - Edit - /home/autoph/public_html/pms_v1/opsPlan/opssubDivision.php

Back
<?php session_start(); if(isset($_SESSION['userID'])) { // echo "Session ID is '" . $_SESSION['userID']; // echo "<br>PMS Name id " . $_SESSION['userID']; $uID = $_SESSION['userID']; } include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['grp'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($uID); $moduleID = 34; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){ echo " <center><img src='./images/locked_out_icon.png' width='100' style='margin-top:100px'><img></center> "; echo "<h4 class='text-center text-danger align-middle pt-5'> Access Denied </h4>"; echo "<p class='display-5 text-center text-danger'> Sorry, you are not authorized to access this page. <br>Please contact your system support for assistance. <br><br>Thank you! <br><br> </p>"; exit(); } //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== ?> <div class="shadow-sm mb-3 pageHeaderContainer content-justify-right pt-2 pb-3" style="padding:0px;height:50px" > <div class="pageSearchHeader bg-white p-2 pt-1" > <h4 class="ml-3 mt-1"><i class="fa fa-object-group" style='font-size:20px;color:#0471AC'> Operational Plan - By Division </i></h4> </div> <div class="pageSearchHeader bg-white p-1 pt-1 "> <input class="form-control border p-3" type="search" placeholder="search" id="searchText" style="margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info" id="goSearchRecord" style="float:rigth;width:20%;margin-left:3px">Search</button> </div> </div> <input type='hidden' id='SelectedRecordID'> <input type='hidden' id='opsPlanHeaderID'> <input type='hidden' id='userID' value="<?php echo $uID;?>" > <input type='hidden' id='opsDataID'> <input type='hidden' id='opsHeaderStatus'> <div class="wrapper mt-3 p-1 shadow-sm float:left bg-white h-auto"> <div class="row fluid m-0 w-100 bg-white"> <div class="col bg-white float:right m-1 text-right col-sm-12 col-sx-12 pt-3"> <button class="btn btn-info pageUpperRightMenu"><span class="btn-label"><i class="fa fa-question">   Help</i></button> <div class="dropdown pageUpperRightMenu float-right"> </div> </div> </div> <div class="row fluid m-0 w-100 p-3 bg-white h-auto pageBodyMenu"> <div class="col bg-white float:right m-1 text-right col-sm-12 col-sx-12 p-2 border h-100"> <div id="pmsPageContainer" style="border:0px solid lightgray;width:100%"> <table style="width:100%;border-collapse:collapse"> <thead> <th style="width:10%;padding-left:2px">REC.</thd> <th style="width:15%;padding-left:2px">CODE</th> <th style="width:30%;padding-left:2px">COMPANY</th> <th style="width:39%;padding-left:2px">Description</th> <th style="width:2%;padding-left:2px"></th> </thead> <?php echo "<table id='pmsPageTable' style='width:100%;border-collapse:collapse'>"; echo "</table>"; ?> </table> </div> </div> </div> <center> <p style='margin:20px;padding:15px;font-family:Tahoma;font-size:14px;color:black;font-weight:normal;margin-bottom:5px '>Viewing <b id='currentCount'></b> out of <b id='recordCount'></b> total records</p> <p style='padding:20px; ;font-size:18px;color:blue;cursor:pointer;margin-top:0px' id='viewMore'> <br><img src='images/animatedArrowDown.gif' width="80px" height="50px"></img> </p> </center> </div> <!--MODAL FORM VIEWING OF KRA modal-fullscreen--> <!-- The Modal --> <div class="modal fade " id="opsModal"> <div class="modal-dialog modal-xl"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='kraTitle' class="modal-title">OPERATIONAL PLAN ENTRY</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body p-1"> <table style='width:100%;margin:0px'> <th style='width:10%;min-width:10px'>NO</th> <th style='width:10%;min-width:30px'>YEAR</th> <th style='width:10%;min-width:30px'>STATUS</th> <th style='width:64%;min-width:30px'>DESCRIPTION</th> <th style='width:3%;min-width:30px'></th> <th style='width:3%;min-width:30px'></th> <tr> <td colspan='6' style="padding:0px;margin:0px;background:white"> <div style='height:400px;border:0px solid red;overflow:auto'> <table id='opsPlanList' style='width:100%;border-collapse:collapse'> </table> </div> </td> </tr> </table> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-danger pl-4 pr-4 m-0" id="addNewKRA" data-toggle="modal" data-target="#AddKRAModal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-plus">   New Period</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!--MODAL FORM FOR ADDING NEW KRA WITHIN SELECTED GROUP--> <!-- The Modal --> <div class="modal fade " id="AddKRAModal"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='kraTitle' class="modal-title">NEW OPSPLAN ENTRY</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="opsName">OPSPLAN NAME/DESCRIPTION:</label> <textarea type="text" class="form-control h-25" id="opsName" name="opsName" rows=3></textarea> </div> <div class="form-group"> <label for="applyYear">APPLICABLE YEAR:</label> <input type="number" min="<?php echo $curYear;?>" value="<?php echo $curYear;?>" max="9999" class="form-control W-50" id="applyYear" name="applyYear"> </div> <div class="form-group"> <label for="opsStatus">STATUS:</label> <select name='opsStatus' id='opsStatus' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option value="CLOSED">CLOSED</option> <option selected value="OPEN">OPEN</option> </select> </div> <div class="form-group"> <label for="opsDescription">REMARKS/NOTES:</label> <input type="text" class="form-control" id="opsDescription" name="opsDescription"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4 m-0" id="saveNewOpsPlanHeader" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-save">   Save Record</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!--MODAL FORM FOR VIEWING OPERATIONAL DATA--> <!-- The Modal --> <div class="modal" data-bs-toggle="modal" data-bs-target="#staticBackdrop" id="opsData" style='margin-top:30px;width:98%;margin-left:1%'> <div class="modal-fullscreen m-md-0"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 id='opsDataTitle' class="modal-title"></h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="modal-content modal-dialog-scrollable" style='min-height:700px;min-width:800px'> <!--OPSPLAN CONTENT DATA --> <div class="modal-body p-0"> <table style='width:100%;margin:0px'> <th style='width:3%;border:0px ;border-right:1px solid gray;background:#000;color:white'>ID</th> <th style='width:15%;border:0px ;border-right:1px solid gray;background:#000;color:white'>KEY PERFORMANCE AREA (KRA)</th> <th style='width:18%;border:0px ;border-right:1px solid gray;background:#000;color:white'>KEY PERFORMANCE INDICATOR (KPI)</th> <th style='width:5%;border:0px ;border-right:1px solid gray;background:#000;color:white'>WEIGHT (%)</th> <th style='width:5%;border:0px ;border-right:1px solid gray;background:#000;color:white'>B.MARK</th> <th style='width:15%;border:0px ;border-right:1px solid gray;background:#000;color:white'>TARGET (%) / TARGET DESCRIPTION</th> <th style='width:15%;border:0px ;border-right:1px solid gray;background:#000;color:white'>STRATEGY / MAJOR ACTIVITIES</th> <th style='width:10%;border:0px ;border-right:1px solid gray;background:#000;color:white'>TIMELINE (FROM => TO</th> <th style='width:10%;border:0px ;border-right:0px solid gray;background:#000;color:white'>RESPONSIBILITY</th> <th style='width:3%;border:0px ;border-right:0px solid gray;background:#000;color:white'></th> <tr> <td colspan='10' style="padding:0px;margin:0px;background:white"> <div class='col-lg-12' style='height:400px;border:0px solid red;overflow:auto'> <table id='opsDataContent' style='width:100%;border-collapse:collapse'> </table> </div> </td> </tr> </table> <div id='opsNewForm' class="collapse" style='position:absolute;top:0px;left:0px;min-height:250px;width:99%;margin:.5%;padding:0x;background:#FAF9F9;box-shadow:5px 5px 5px gray'> <div class="modal-body" style="overflow:auto"> <h4 class='title m-2'> Operational Data Entry</h4> <table style='width:100%;margin:0px'> <th style='width:15%;border:1px solid lightgray;background:#C90704;color:white'>KEY PERFORMANCE AREA (KRA)</th> <th style='width:20%;border:1px solid lightgray;background:#C90704;color:white'>KEY PERFORMANCE INDICATOR (KPI)</th> <th style='width:5%;border:1px solid lightgray;background:#C90704;color:white'>WEIGHT (%)</th> <th style='width:5%;border:1px solid lightgray;background:#C90704;color:white'>BENCHMARK</th> <th style='width:15%;border:1px solid lightgray;background:#C90704;color:white'>TARGET (%) / TARGET DESCRIPTION</th> <th style='width:20%;border:1px solid lightgra;background:#C90704;color:white'>STRATEGY / MAJOR ACTIVITIES</th> <th style='width:10%;border:1px solid lightgray;background:#C90704;color:white'>TIMELINE (FROM => TO</th> <th style='width:10%;border:1px solid lightgray;background:#C90704;color:white'>RESPONSIBILITY</th> <tr> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <select onchange="javascript:loadAutohubKPIByKRA()" name='opsKRA' id='opsKRA' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG" style='font-size:12px'> <option selected value="">-- SELECT KRA --</option> <?php $sql = "SELECT * FROM kra_division_child_tbl WHERE deleted=0"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ echo "<option value='".$row['id']."'>".$row['kra_code']." - ".$row['kra_name']."</option>"; } } ?> </select> </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <select name='activeKPI' id='activeKPI' onchange="javascript:loadKPIWeight()" class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> </select> </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <input type="text" class="form-control" id="activeKPIWeight" name="activeKPIWeight" > </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <input type="text" class="form-control" id="kpiBenchMark" name="kpiBenchMark" > </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <input type="text" class="form-control m-1" id="kpiOpsTargetNumber" name="kpiOpsTargetNumber" placeholder="Target"> <textarea type="text" class="form-control m-1 h-50" id="kpiOpsTargetDesc" name="kpiOpsTargetDesc" rows=10 placeholder="Target Description"></textarea> </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <textarea type="text" class="form-control m-1 h-50" id="kpiOpsStrategy" name="kpiOpsStrategy" rows=12></textarea> </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <h8>Start date:</h5> <input type="date" class="form-control m-1" id="opsTimelineStart" name="opsTimelineStart" placeholder="Start Date"> <br><h8>End date:</h5> <input type="date" class="form-control m-1" id="opsTimelineEnd" name="opsTimelineEnd" placeholder="End Date"> </td> <td style='border:1px solid lightgray;background:white;vertical-align:top'> <textarea type="text" class="form-control m-1 h-50" id="opsKPIResponsibility" name="opsKPIResponsibility" rows=12></textarea> </td> </tr> </table> </div> <div class="modal-footer"> <button <?php echo $addButton;?> data-toggle="collapse" data-target="#opsNewForm" class="btn btn-success pl-2 pr-2 m-0" id="saveNewOpsData" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-save">   Save Record</i></button> <button data-toggle="collapse" data-target="#opsNewForm" class="btn btn-Secondary pl-2 pr-2 m-0" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <!--<button class="btn btn-Light pageUpperRightMenu m-0" onClick="window.open('./pdfViewer/opsPlanPrint_Autohub.php?id=<?php echo $uID;?>&periodID=<??>')" style="border-radius:0px"><span class="btn-label"><i class="fa fa-print">   Print</i></button> --> <button <?php echo $editButton;?> data-toggle="collapse" data-target="#opsPost" class="btn btn-Info pl-2 pr-2 m-0 border-radius=0" id="postOpsplanData" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-flag-checkered">   Post</i></button> <button <?php echo $addButton;?> data-toggle="collapse" data-target="#opsNewForm" class="btn btn-danger pl-2 pr-2 m-0 border-radius=0" id="newOpsPlanEntry" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-plus-circle">   New Entry</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <script type="text/javascript"> $(document).ready(function(){ //============================================================================================================================================ //============================================================================================================================================ $("#saveNewOpsPlanHeader").click(function(){ var opsDescription = $("#opsDescription").val(); //endaya var opsStatus = $("#opsStatus").val(); //endaya var applyYear = $("#applyYear").val(); //opsName var opsName = $("#opsName").val(); // var SelectedRecordID = $("#SelectedRecordID").val(); // var userID = $("#userID").val(); // if(applyYear===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input the correct year format...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(opsName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input operational name for easy identificaiton or record', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); // return false; $.ajax({ url: "./opsPlan/saveNewOpsPlanHeader_subDivision.php", type: "POST", async: true, data: { "opsDescription":opsDescription, "opsStatus":opsStatus, "applyYear":applyYear, "opsName":opsName, "SelectedRecordID":SelectedRecordID, "userID":userID, "saveOps":1 }, success: function(dx){ $("#opsPlanList").html(dx); $('#grpCode').val(''); $('#grpName').val(''); $('#grpDescription').val(''); ShowUploadBar(); Swal.fire('Transaction complete', '', 'info'); } }) }); $("#saveNewOpsData").click(function(){ var opsKRA = $("#opsKRA").val(); //endaya var activeKPI = $("#activeKPI").val(); //endaya var activeKPIWeight = $("#activeKPIWeight").val(); //endaya var kpiBenchMark = $("#kpiBenchMark").val(); var kpiOpsTargetNumber = $("#kpiOpsTargetNumber").val(); var kpiOpsTargetDesc = $("#kpiOpsTargetDesc").val(); var kpiOpsStrategy = $("#kpiOpsStrategy").val(); var opsTimelineStart = $("#opsTimelineStart").val(); var opsTimelineEnd = $("#opsTimelineEnd").val(); var opsKPIResponsibility = $("#opsKPIResponsibility").val(); var opsPlanHeaderID = $("#opsPlanHeaderID").val(); //OpsPlan Header ID var SelectedRecordID = $("#SelectedRecordID").val(); var userID = $("#userID").val(); //endaya var opsHeaderStatus = $("#opsHeaderStatus").val(); //alert(opsHeaderStatus); if(opsHeaderStatus!="OPEN"){ Swal.fire({ icon: 'error', //title: 'Oops...', text: 'Operational Plan data has been locked. Adding new record is no longer allowed. Please contact your PMS Administrator for assistance. Thank you!' }) //Swal.fire('Operational Plan data has been locked. Deleting record is no longer allowed. Thank yoU') return false; } if(opsKRA===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select KRA to continue..', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(activeKPI===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select KPI to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(kpiOpsTargetNumber===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type your target number to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(opsTimelineEnd===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'End date on the timeline area is a required field...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(opsKPIResponsibility===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Responsibility is a required field.', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); $.ajax({ url: "./opsPlan/saveNewOpsPlanEntry_subDivision.php", type: "POST", async: true, data: { "opsKRA":opsKRA, "activeKPI":activeKPI, "activeKPIWeight":activeKPIWeight, "kpiBenchMark":kpiBenchMark, "kpiOpsTargetNumber":kpiOpsTargetNumber, "kpiOpsTargetDesc":kpiOpsTargetDesc, "kpiOpsStrategy":kpiOpsStrategy, "opsTimelineStart":opsTimelineStart, "opsTimelineEnd":opsTimelineEnd, "opsKPIResponsibility":opsKPIResponsibility, "opsPlanHeaderID":opsPlanHeaderID, "SelectedRecordID":SelectedRecordID, "userID":userID, "saveOps":1 }, success: function(dx){ ShowUploadBar(); $("#opsDataContent").html(dx); $('#activeKPI').val(''); $('#activeKPIWeight').val(''); $('#kpiOpsTargetNumber').val(''); $('#kpiBenchMark').val(''); $('#kpiOpsTargetDesc').val(''); $('#kpiOpsStrategy').val(''); $('#opsTimelineStart').val(''); $('#opsTimelineEnd').val(''); $('#opsKPIResponsibility').val(''); //Swal.fire('Transaction complete', '', 'info'); } }) }); $("#postOpsplanData").click(function(){ var opsPlanHeaderID = $("#opsPlanHeaderID").val(); //OpsPlan Header ID var userID = $("#userID").val(); //endaya var opsHeaderStatus = $("#opsHeaderStatus").val(); var SelectedRecordID = $("#SelectedRecordID").val(); //alert(opsHeaderStatus); if(opsHeaderStatus!= "OPEN"){ Swal.fire({ icon: 'warning', //title: 'Oops...', text: 'The selected record has already been posted. Request has been terminated' }) return false; } Swal.fire({ title: 'Are you sure you want to POST this record?', text: "You won't be able to revert this!", icon: 'warning', showCancelButton: true, confirmButtonColor: '#3085d6', cancelButtonColor: '#d33', confirmButtonText: 'Yes, POST it!' }).then((result) => { if (result.isConfirmed) { ShowUploadBar(); $.ajax({ url: "./opsPlan/postOpsplanHeader_subDivision.php", type: "POST", async: true, data: { "opsPlanHeaderID":opsPlanHeaderID, "opsHeaderStatus":opsHeaderStatus, "SelectedRecordID":SelectedRecordID, "userID":userID, "postIt":1 }, success: function(dx){ ShowUploadBar(); $("#opsPlanList").html(dx); Swal.fire({ icon: 'success', title: 'Complete', text: 'OpsPlan has been posted, editing, deleting and adding new record is no longer allowed.' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) } }) } }) }); }); </script> <!--########################## ############################################--> <script type="text/javascript"> var start = 0; var limit = 50; var infCanvass = ''; var reachedMax = false; /* $(window).scroll(function () { if ($(window).scrollTop() == $(document).height() - $(window).height()) getData(); }); */ $("#viewMore").click(function(){ //alert('Click'); getData(); }); $("#goSearchRecord").click(function(){ infCanvass = $("#searchText").val(); if(infCanvass===''){ Swal.fire('Invalid search string', '', 'error'); }else{ start=0; $limit = 15; getData(); } }); $(document).ready(function () { countRow(); getData(); }); function getData() { var recordCount = $("#recordCount").html(); //alert(start); //alert(limit); //return false; if(start >= recordCount){ $("#currentCount").html(recordCount); return false; } ShowUploadBar(); if (reachedMax) return; $.ajax({ url: "./opsPlan/loadPMSList_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { opsAction: 1, infCanvass: infCanvass, start: start, limit: limit }, success: function(response) { if (response == "reachedMax") reachedMax = true; else { if(infCanvass!=''){ $("#pmsPageTable").html(response); start = 0; limit = 15; }else{ start += limit; $("#pmsPageTable").append(response); $("#currentCount").html(start); if(start >= recordCount){ $("#currentCount").html(recordCount); $("#viewMore").fadeOut(100); } } //$("#searchText").val(''); } ShowUploadBar(); } }); } function countRow(){ $.ajax({ url: "./ajaxCall/loadDivision_CountRow.php", type: "POST", async: false, data: { "pmsCountRow":2 }, success: function(d){ $("#recordCount").html(d); } }) } //SEARCH ENTER KEY PRESS LISTENER // Get the input field var input = document.getElementById("searchText"); // Execute a function when the user presses a key on the keyboard input.addEventListener("keypress", function(event) { // If the user presses the "Enter" key on the keyboard if (event.key === "Enter") { // Cancel the default action, if needed event.preventDefault(); // Trigger the button element with a click document.getElementById("goSearchRecord").click(); } }); </script> <script> function getInfo(row) { var x=row.cells; document.getElementById("SelectedRecordID").value = x[0].innerHTML; document.getElementById("kraTitle").innerHTML = x[2].innerHTML + " OPSPLAN SUMMARY"; document.getElementById("opsDataTitle").innerHTML = x[2].innerHTML + " OPERATIONAL PLAN"; document.getElementById("EditPMSCode").value = x[1].innerHTML; document.getElementById("EditPMSDescription").value = x[3].innerHTML; document.getElementById("EditPMSName").value = x[2].innerHTML; } function getKRAinfo(row) { var x=row.cells; // alert(x[0].innerHTML); document.getElementById("opsPlanHeaderID").value = x[0].innerHTML; document.getElementById("opsHeaderStatus").value = x[2].innerHTML; document.getElementById("EditKRACode").value = x[2].innerHTML; document.getElementById("EditKRAWeight").value = x[1].innerHTML; document.getElementById("EditKRAName").value = x[3].innerHTML; //document.getElementById("opsDataTitle").innerHTML = "KRA: "+x[4].innerHTML; } function opsDataInfo(row) { var x=row.cells; // alert(x[0].innerHTML); document.getElementById("opsDataID").value = x[0].innerHTML; } $('#opsPlanList').on("click","tr td",function(){ //var header = $('#pmsPageTable th').eq($(this).index()).text(); //to get clicked column's header // var trackid = $(this).siblings('td:nth-child(6)').text(); //get column at column 36 var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value if(dCell ==4){ //load OpsPlanData var opsPlanHeaderID = $("#opsPlanHeaderID").val(); var opsHeaderStatus = $("#opsHeaderStatus").val(); var editAccess = $("#editAccess").val(); if(editAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to access this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } //alert(opsPlanHeaderID); //return false; ShowUploadBar(); $.ajax({ url: "./opsPlan/loadOpsPlanData_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { loadOpsData: 1, "opsHeaderStatus":opsHeaderStatus, "opsPlanHeaderID": opsPlanHeaderID }, success: function(d){ $("#opsDataContent").html(d); //countRow(); ShowUploadBar(); } }); } if(dCell ==5){ var opsHeaderStatus = $("#opsHeaderStatus").val(); var deleteAccess = $("#deleteAccess").val(); if(deleteAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to delete record from this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } //alert(opsHeaderStatus); if(opsHeaderStatus!="OPEN"){ Swal.fire({ icon: 'error', //title: 'Oops...', text: 'Operational Plan data has been locked. Deleting record is no longer allowed. Thank you!' }) //Swal.fire('Operational Plan data has been locked. Deleting record is no longer allowed. Thank yoU') return false; }else{ Swal.fire({ title: 'Are you sure you want to delete this record?', text: "You won't be able to revert this!", icon: 'warning', showCancelButton: true, confirmButtonColor: '#3085d6', cancelButtonColor: '#d33', confirmButtonText: 'Yes, delete it!' }).then((result) => { if (result.isConfirmed) { deleteOpsPlanHeader(); } }) } } }); $('#opsDataContent').on("click","tr td",function(){ //var header = $('#pmsPageTable th').eq($(this).index()).text(); //to get clicked column's header // var trackid = $(this).siblings('td:nth-child(6)').text(); //get column at column 36 var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value if(dCell ==9){ var opsHeaderStatus = $("#opsHeaderStatus").val(); var deleteAccess = $("#deleteAccess").val(); if(deleteAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to delete record from this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } //alert(opsHeaderStatus); if(opsHeaderStatus!="OPEN"){ Swal.fire({ icon: 'error', //title: 'Oops...', text: 'Operational Plan data has been locked. Deleting record is no longer allowed. Thank you!' }) //Swal.fire('Operational Plan data has been locked. Deleting record is no longer allowed. Thank yoU') return false; }else{ Swal.fire({ title: 'Are you sure you want to delete this record?', text: "You won't be able to revert this!", icon: 'warning', showCancelButton: true, confirmButtonColor: '#3085d6', cancelButtonColor: '#d33', confirmButtonText: 'Yes, delete it!' }).then((result) => { if (result.isConfirmed) { deleteOpsPlanData(); } }) } } }); $('#pmsPageTable').on("click","tr td",function(){ //var header = $('#pmsPageTable th').eq($(this).index()).text(); //to get clicked column's header // var trackid = $(this).siblings('td:nth-child(6)').text(); //get column at column 36 var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value if(dCell ==4){ //call function to load all KRA's based on selected group var activeRecordID = $("#SelectedRecordID").val(); var editAccess = $("#editAccess").val(); if(editAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to access this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } //alert(activeRecordID); //return false; ShowUploadBar(); $.ajax({ url: "./opsPlan/viewOpsPlanSummary_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { opsView: 1, activeRecordID: activeRecordID }, success: function(d){ $("#opsPlanList").html(d); //countRow(); ShowUploadBar(); } }); } }); function deleteOpsPlanHeader(){ var opsPlanHeaderID = $("#opsPlanHeaderID").val(); var SelectedRecordID = $("#SelectedRecordID").val(); //alert(groupKRAid); ShowUploadBar(); $.ajax({ url: "./opsPlan/deleteOpsPlanHeader_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { opsDelete: 1, "SelectedRecordID": SelectedRecordID, "opsPlanHeaderID": opsPlanHeaderID }, success: function(x){ $("#opsPlanList").html(x); ShowUploadBar(); } }); } function deleteOpsPlanData(){ var opsDataID = $("#opsDataID").val(); var opsPlanHeaderID = $("#opsPlanHeaderID").val(); //alert(groupKRAid); ShowUploadBar(); $.ajax({ url: "./opsPlan/deleteOpsPlanData_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { opsDelete: 1, "opsDataID": opsDataID, "opsPlanHeaderID": opsPlanHeaderID }, success: function(x){ $("#opsDataContent").html(x); ShowUploadBar(); } }); } function loadAutohubKPIByKRA(){ var opsKRA = $("#opsKRA").val(); //alert(opsKRA); ShowUploadBar(); $.ajax({ url: "./opsPlan/kpiLoadOnChange_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { loadKPI: 1, opsKRA: opsKRA }, success: function(d){ $("#activeKPI").html(d); countRow(); ShowUploadBar(); } }); } function loadKPIWeight(){ var activeKPI = $("#activeKPI").val(); //alert(activeKPI); ShowUploadBar(); $.ajax({ url: "./opsPlan/getKPIWeight_subDivision.php", method: 'POST', dataType: 'text', async:true, data: { loadWeight: 1, activeKPI: activeKPI }, success: function(k){ $("#activeKPIWeight").val(k); countRow(); ShowUploadBar(); } }); } </script> <?php } ?>

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