File manager

File manager - Edit - /home/autoph/public_html/pms_v1/pages/pmsGroup.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['sgrp'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($uID); $moduleID = 14; $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-2" style="padding:0px;" > <div class="pageSearchHeader bg-white p-1 pt-1" > <h4 class="ml-3 mt-1"><i class="fa fa-globe" style='font-size:20px;color:#0471AC'> Setup Group </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='groupKRAid'> <input type='hidden' id='userID' value="<?php echo $uID;?>" > <input type='hidden' id='groupKRAid'> <!--SELECTED KRA ID --> <input type='hidden' id='kpiActiveID'> <!--SELECTED KPI ID --> <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">   Support</i></button> <div class="dropdown pageUpperRightMenu float-right"> <button <?php echo $downloadButton;?> type="button" class="btn btn-warning dropdown-toggle" data-toggle="dropdown"> <i class="fa fa-download"> Download</i> </button> <div class="dropdown-menu"> <a class="dropdown-item" href="#" onClick="window.open('xlsFiles/xlsSubGroup_list.php')" style='padding:10px;margin:5px;width:100px;font-size:12px;color:#002244'><i class="fa fa-file-excel-o">   Excel Format</i></a> <a class="dropdown-item" href="#" onClick="window.open('xlsFiles/csvSubGroup_list.php')"style='padding:10px;margin:5px;width:100px;font-size:12px;color:#002244'><i class="fa fa-file-text-o">   CSV Format</i></a> </div> </div> <button <?php echo $printButton;?> class="btn btn-danger pageUpperRightMenu" onClick="window.open('./pdfViewer/RPTSubGroup_list.php?id=<?php echo $uID;?>')"><span class="btn-label"><i class="fa fa-print">   Print</i></button> <button <?php echo $addButton;?> class="btn btn-success pageUpperRightMenu " data-toggle="modal" data-target="#myModal"><span class="btn-label"><i class="fa fa-plus">   Add</i></button> <!--<button class="btn btn-warning pageUpperRightMenu"><span class="btn-label"><i class="fa fa-download">   Download</i></button>--> </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 id='pmsPageTable' style='width:100%;border-collapse:collapse'> </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 FOR ADD NEW AREA--> <!-- The Modal --> <div class="modal fade " id="myModal"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">ADD NEW SUB-GROUP</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="companyID">SELECT COMPANY:</label> <select name='companyID' id='companyID' onchange="javascript:loadGroupKRA()" class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="">-- SELECT --</option> <?php $sql = "SELECT * FROM vts_company WHERE comp_status=1 ORDER BY comp_code ASC"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ echo "<option value='".$row['comp_id']."'>".$row['comp_code']." - ".$row['comp_name']."</option>"; } } ?> </select> </div> <div class="form-group"> <label for="usr">GROUP CODE:</label> <input type="text" class="form-control" id="grpCode"> </div> <div class="form-group"> <label for="usr">GROUP NAME:</label> <input type="text" class="form-control" id="grpName"> </div> <div class="form-group"> <label for="usr">GROUP DESCRIPTION:</label> <input type="text" class="form-control" id="grpDescription"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="saveNewGroup"> <span class="btn-label"><i class="fa fa-save">   Save</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!--END OF MODAL FORM FOR ADD NEW AREA--> <!--MODAL FORM VIEWING OF KRA--> <!-- The Modal --> <div class="modal fade " id="kraModal"> <div class="modal-dialog modal-xl"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='kraTitle' class="modal-title">ACTIVE KRA's</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:5%;'>NO</th> <th style='width:10%'>WEIGHT</th> <th style='width:11%'>CODE</th> <th style='width:65%'>KRA NAME</th> <th style='width:2%'></th> <th style='width:2%'></th> <th style='width:2%'></th> <tr> <td colspan='7' style="padding:0px;margin:0px;background:white"> <div style='height:400px;border:0px solid red;overflow:auto'> <table id='kraList' 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-success pl-4 pr-4" id="addNewKRA" data-toggle="modal" data-target="#AddKRAModal"> <span class="btn-label"><i class="fa fa-plus">   Add New</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!--MODAL FORM FOR ADDING NEW KRA WITHIN SELECTED AREA--> <!-- 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='addKRATitle' class="modal-title">ADD NEW KRA</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="branchID">SELECT BRANCH:</label> <select name='branchID' id='branchID' onchange="javascript:loadGroupKRA()" class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="">-- SELECT --</option> <?php $sql = "SELECT * FROM vts_dealerships WHERE deal_status=1 ORDER BY deal_code ASC"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ echo "<option value='".$row['deal_id']."'>".$row['deal_code']." - ".$row['deal_name']."</option>"; } } ?> </select> </div> <div class="form-group"> <label for="selectedKRAID">BRANCH KRA:</label> <select name='selectedKRAID' id='selectedKRAID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> </select> </div> <!-- <div class="form-group"> <label for="kraTAG">TAG:</label> <select name='kraTAG' id='kraTAG'class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="MAIN">MAIN KRA</option> <option selected value="SUB">SUB KRA</option> </select> </div> --> <div class="form-group"> <label for="AddKRACode">KRA CODE:</label> <input type="text" class="form-control" id="AddKRACode" name="AddKRACode"> </div> <div class="form-group"> <label for="AddKRAWeight">WEIGHT:</label> <input type="text" class="form-control" id="AddKRAWeight" name="AddKRAWeight"> </div> <div class="form-group"> <label for="AddKRAName">KRA NAME:</label> <input type="text" class="form-control" id="AddKRAName" name="AddKRAName"> </div> <div class="form-group"> <label for="AddKRADescription">KRA DESCRIPTION:</label> <input type="text" class="form-control" id="AddKRADescription" name="AddKRADescription"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" id="saveNewKRA" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-save">   Save</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!--MODAL FORM EDITING KRA--> <!-- The Modal --> <div class="modal fade " id="editKRA"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">EDIT KRA</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <!-- <div class="form-group"> <label for="EditkraTAG">TAG:</label> <select name='EditkraTAG' id='EditkraTAG'class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="MAIN">MAIN KRA</option> <option selected value="SUB">SUB KRA</option> </select> </div> --> <div class="form-group"> <label for="EditKRACode">KRA CODE:</label> <input type="text" class="form-control" id="EditKRACode" name="EditKRACode"> </div> <div class="form-group"> <label for="EditKRAWeight">KRA WEIGHT:</label> <input type="text" class="form-control" id="EditKRAWeight" name="EditKRAWeight"> </div> <div class="form-group"> <label for="EditKRAName">KRA NAME:</label> <textarea type="text" class="form-control h-25" id="EditKRAName" name="EditKRAName" rows=3></textarea> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $editButton;?> type="button" class="btn btn-info pl-4 pr-4" id="updateNewKRA" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-save">   UPDATE</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   CLOSE</i></button> </div> </div> </div> </div> <!--MODAL EDITING MAIN ENTRY--> <!-- The Modal --> <div class="modal fade " id="editPMSModal"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">EDIT MAIN DIVISION</h4> <button type="button" class="close">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="EditPMSCode">CODE:</label> <input type="text" class="form-control" id="EditPMSCode" name="EditPMSCode"> </div> <div class="form-group"> <label for="EditPMSName">GROUP NAME:</label> <textarea type="text" class="form-control h-25" id="EditPMSName" name="EditPMSName" rows=3></textarea> </div> <div class="form-group"> <label for="EditPMSDescription">REMARKS:</label> <textarea type="text" class="form-control h-25" id="EditPMSDescription" name="EditPMSDescription" rows=3></textarea> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $editButton;?> type="button" class="btn btn-info pl-4 pr-4" id="updateNewPMS" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-save">   UPDATE</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   CLOSE</i></button> </div> </div> </div> </div> <!--MODAL FORM VIEWING OF KPI--> <!-- The Modal --> <div class="modal fade " id="kpiModal"> <div class="modal-dialog modal-xl"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='kpiTitle' class="modal-title">ASSIGNED KPI</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:5%;min-width:10px'>NO</th> <th style='width:10%;min-width:30px'>WEIGHT</th> <th style='width:13%;min-width:30px'>TARGET</th> <th style='width:65%;min-width:100px'>KPI NAME</th> <th style='width:2%'></th> <th style='width:2%'></th> <tr> <td colspan='6' style="padding:0px;margin:0px;background:white"> <div style='height:400px;border:0px solid red;overflow:auto'> <table id='kpiList' 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-success pl-4 pr-4" data-toggle="modal" data-target="#addKPI" onclick="javascript:loadBranchKPI();"> <span class="btn-label" ><i class="fa fa-plus">   ADD KPI</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   CLOSE</i></button> </div> </div> </div> </div> <!--MODAL FORM FOR ADDING NEW KPI WITHIN SELECTED KRA--> <!-- The Modal --> <div class="modal fade " id="addKPI"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">ADD NEW KPI</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="topKPIID">MAIN KPI:</label> <select name='topKPIID' id='topKPIID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> </select> </div> <div class="form-group"> <label for="AddKPIWeight">KPI WEIGHT:</label> <input type="text" class="form-control" id="AddKPIWeight" name="AddKPIWeight"> </div> <div class="form-group"> <label for="AddKPITarget">TARGET:</label> <input type="text" class="form-control" id="AddKPITarget" name="AddKPITarget"> </div> <div class="form-group"> <label for="AddKPIName">KPI NAME:</label> <input type="text" class="form-control" id="AddKPIName" name="AddKPIName"> </div> <div class="form-group"> <label for="AddKPIDescription">KPI DESCRIPTION:</label> <input type="text" class="form-control" id="AddKPIDescription" name="AddKPIDescription"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="saveNewKPIEntry"> <span class="btn-label"><i class="fa fa-save">   SAVE</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   CLOSE</i></button> </div> </div> </div> </div> <!--MODAL FORM EDITING KPI--> <!-- The Modal --> <div class="modal fade " id="editKPI"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">EDIT KPI</h4> <button type="button" class="close" data-dismiss="modal" >×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="EdittopKPIID">MAIN KPI:</label> <select name='EdittopKPIID' id='EdittopKPIID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> </select> </div> <div class="form-group"> <label for="EditKPIWeight">KPI WEIGHT:</label> <input type="text" class="form-control" id="EditKPIWeight" name="EditKPIWeight"> </div> <div class="form-group"> <label for="EditKPITarget">TARGET:</label> <input type="text" class="form-control" id="EditKPITarget" name="EditKPITarget"> </div> <div class="form-group"> <label for="EditKPIName">KPI NAME:</label> <textarea type="text" class="form-control h-25" id="EditKPIName" name="EditKPIName" rows=3></textarea> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $editButton;?> type="button" class="btn btn-info pl-4 pr-4" id="updateNewKPI" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-save">   UPDATE</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close">   CLOSE</i></button> </div> </div> </div> </div> <script type="text/javascript"> $(document).ready(function(){ //============================================================================================================================================ //============================================================================================================================================ $("#saveNewGroup").click(function(){ var grpCode = $("#grpCode").val(); //endaya var grpName = $("#grpName").val(); //endaya var grpDescription = $("#grpDescription").val(); //endaya var companyID = $("#companyID").val(); //endaya if(companyID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type company to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(grpCode===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type group code to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(grpName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type group name to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(grpDescription===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type group description to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); // return false; $.ajax({ url: "./ajaxSave/saveNewSubGroup.php", type: "POST", async: true, data: { "grpCode":grpCode, "companyID":companyID, "grpName":grpName, "grpDescription":grpDescription, "pmsAction":1 }, success: function(dx){ ShowUploadBar(); $("#pmsPageTable").html(dx); $('#grpCode').val(''); $('#grpName').val(''); $('#grpDescription').val(''); Swal.fire('Transaction complete', '', 'info'); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#saveNewKRA").click(function(){ var kraTAG = "MAIN"; var branchID = $("#branchID").val(); var selectedKRAID = $("#selectedKRAID").val(); var AddKRACode = $("#AddKRACode").val(); var AddKRAWeight = $("#AddKRAWeight").val(); var AddKRAName = $("#AddKRAName").val(); var AddKRADescription = $("#AddKRADescription").val(); var SelectedRecordID = $("#SelectedRecordID").val(); var userID = $("#userID").val(); //alert(groupID); //alert(groupKRAID); //return false; if(branchID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'No Branch name has been selected...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(AddKRAWeight===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA WEIGHT to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(AddKRACode===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA CODE to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(AddKRAName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA NAME to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); $.ajax({ url: "./ajaxSave/saveNewMainDivisionKRA.php", type: "POST", async: true, data: { "branchID":branchID, "kraTAG":kraTAG, "userID":userID, "AddKRACode":AddKRACode, "selectedKRAID":selectedKRAID, "AddKRAWeight":AddKRAWeight, "AddKRAName":AddKRAName, "AddKRADescription":AddKRADescription, "SelectedRecordID":SelectedRecordID, "pmsAction":1 }, success: function(dx){ $("#kraList").html(dx); $('#AddKRACode').val(''); $('#AddKRAWeight').val(''); $('#AddKRAName').val(''); $('#AddKRADescription').val(''); ShowUploadBar(); Swal.fire('Transaction complete', '', 'info'); } }) }); $("#updateNewKRA").click(function(){ var groupKRAid = $("#groupKRAid").val(); var EditkraTAG ="MAIN"; var SelectedRecordID = $("#SelectedRecordID").val(); var EditKRACode = $("#EditKRACode").val(); var EditKRAWeight = $("#EditKRAWeight").val(); var EditKRAName = $("#EditKRAName").val(); ///var AddKRADescription = $("#AddKRADescription").val(); //alert(groupID); //alert(groupKRAid); //return false; if(groupKRAid===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Unable to proceed. Record ID is missing...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditKRAWeight===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA WEIGHT to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditKRACode===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA CODE to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditKRAName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA NAME to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); $.ajax({ url: "./ajaxUpdate/updateSubGroupKRA.php", type: "POST", async: true, data: { "groupKRAid":groupKRAid, "EditkraTAG":EditkraTAG, "EditKRACode":EditKRACode, "EditKRAWeight":EditKRAWeight, "EditKRAName":EditKRAName, "SelectedRecordID":SelectedRecordID, "updateKRA":1 }, success: function(ud){ $("#kraList").html(ud); $('#EditKRACode').val(''); $('#EditKRAWeight').val(''); $('#EditKRAName').val(''); ShowUploadBar(); } }) }); $("#updateNewPMS").click(function(){ var SelectedRecordID = $("#SelectedRecordID").val(); var EditPMSCode = $("#EditPMSCode").val(); var EditPMSDescription = $("#EditPMSDescription").val(); var EditPMSName = $("#EditPMSName").val(); var start = 0; var limit = 50; var infCanvass = ''; var reachedMax = false; if(EditPMSCode===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA CODE to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditPMSName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KRA NAME to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); $.ajax({ url: "./ajaxUpdate/updatePMSSubGroupEntry.php", type: "POST", async: true, data: { "EditPMSName":EditPMSName, "EditPMSDescription":EditPMSDescription, "EditPMSCode":EditPMSCode, "SelectedRecordID":SelectedRecordID, "updatePMS":1 }, success: function(ud){ $("#pmsPageTable").html(ud); $('#EditPMSName').val(''); $('#EditPMSDescription').val(''); $('#EditPMSCode').val(''); ShowUploadBar(); } }) }); $("#updateNewKPI").click(function(){ var groupKRAid = $("#groupKRAid").val(); var kpiActiveID = $("#kpiActiveID").val(); var EditKPIName = $("#EditKPIName").val(); var EditKPIWeight = $("#EditKPIWeight").val(); var EditKPITarget = $("#EditKPITarget").val(); var EdittopKPIID = $("#EdittopKPIID").val(); var EditKPIDescription = "NA"; //alert(kpiActiveID); if(EdittopKPIID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select MAIN KPI NAME to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditKPITarget===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input valid target to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditKPIName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type KPI NAME to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditKPIWeight===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input valid weight to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); $.ajax({ url: "./ajaxUpdate/KPI_updateMainDivisionKPI.php", type: "POST", async: true, data: { "kpiActiveID":kpiActiveID, "EditKPIName":EditKPIName, "EditKPIWeight":EditKPIWeight, "EditKPITarget":EditKPITarget, "groupKRAid":groupKRAid, "EdittopKPIID":EdittopKPIID, "EditKPIDescription":EditKPIDescription, "updateKPI":1 }, success: function(ud){ $("#kpiList").html(ud); $('#EditKPIName').val(''); $('#EditKPIWeight').val(''); $('#EditKPITarget').val(''); ShowUploadBar(); } }) }); $("#saveNewKPIEntry").click(function(){ var AddKPITarget = $("#AddKPITarget").val(); var AddKPIWeight = $("#AddKPIWeight").val(); var AddKPIName= $("#AddKPIName").val(); var AddKPIDescription = $("#AddKPIDescription").val(); var groupKRAid = $("#groupKRAid").val(); var topKPIID = $("#topKPIID").val(); if(AddKPITarget===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input valid KPI target to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(AddKPIWeight===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input KPI WEIGHT to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(AddKPIName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input KPI NAME to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); //topKPIID AddKPIName AddKPIWeight AddKPITarget AddKPIDescription $.ajax({ url: "./ajaxSave/KPI_SaveMainDivisionKPI.php", type: "POST", async: true, data: { "groupKRAid":groupKRAid, "AddKPITarget":AddKPITarget, "AddKPIWeight":AddKPIWeight, "AddKPIName":AddKPIName, "topKPIID":topKPIID, "AddKPIDescription":AddKPIDescription, "addKPI":1 }, success: function(dx){ $("#kpiList").html(dx); $('#AddKPITarget').val(''); $('#AddKPIWeight').val(''); $('#AddKPIName').val(''); $('#AddKPIDescription').val(''); ShowUploadBar(); Swal.fire('Transaction complete', '', 'info'); } }) }); }); </script> <!--########################## ############################################--> <!-- <script src="http://code.jquery.com/jquery-3.2.1.min.js" integrity="sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4=" crossorigin="anonymous"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></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'); return false; }else{ start=0; $limit = 50; getData(); } }); $(document).ready(function () { countRow(); getData(); }); function getData() { var recordCount = $("#recordCount").html(); //alert(start); //alert(recordCount); //return false; if(start >= recordCount){ $("#currentCount").html(recordCount); return false; } ShowUploadBar(); if (reachedMax) return; $.ajax({ url: "./ajaxCall/loadPMSSubGroup_data.php", method: 'POST', dataType: 'text', async:true, data: { pmsAction: 1, infCanvass: infCanvass, start: start, limit: limit }, success: function(response) { if (response == "reachedMax") reachedMax = true; else { if(infCanvass!=''){ $("#pmsPageTable").html(response); start = 0; limit = 50; }else{ start += limit; $("#pmsPageTable").append(response); $("#currentCount").html(start); if(start >= recordCount){ $("#currentCount").html(recordCount); $("#viewMore").fadeOut(100); } } //$("#searchText").val(''); } ShowUploadBar(); } }); } function loadGroupKRA(){ var branchID = $("#branchID").val(); //alert(companyID); ShowUploadBar(); $.ajax({ url: "./ajaxCall/onchangeLoadBranchKRA.php", method: 'POST', dataType: 'text', async:true, data: { loadKRA: 1, branchID: branchID }, success: function(d){ $("#selectedKRAID").html(d); ShowUploadBar(); } }); } function countRow(){ $.ajax({ url: "./ajaxCall/loadSubGroup_countRow.php", type: "POST", async: false, data: { "pmsSubGroup":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 + " ASSIGNED KRA'S "; 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("groupKRAid").value = x[0].innerHTML; document.getElementById("EditKRACode").value = x[2].innerHTML; document.getElementById("EditKRAWeight").value = x[1].innerHTML; document.getElementById("EditKRAName").value = x[3].innerHTML; document.getElementById("kpiTitle").innerHTML = " KPI:" + x[3].innerHTML; } function getKPIinfo(row) { var x=row.cells; // alert(x[0].innerHTML); document.getElementById("kpiActiveID").value = x[0].innerHTML; document.getElementById("EditKPITarget").value = x[2].innerHTML; document.getElementById("EditKPIWeight").value = x[1].innerHTML; document.getElementById("EditKPIName").value = x[3].innerHTML; } $('#kraList').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 groupKRAid = $("#groupKRAid").val(); //alert(groupKRAid); //return false; ShowUploadBar(); $.ajax({ url: "./kpiBasket/viewMainDivisionKPI.php", method: 'POST', dataType: 'text', async:true, data: { kraView: 1, "groupKRAid": groupKRAid }, success: function(d){ $("#kpiList").html(d); //countRow(); ShowUploadBar(); } }); } if(dCell ==5){ //alert('Editing Data'); } if(dCell ==6){ 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; } Swal.fire({ title: 'Are you sure you want delete this KRA?', 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) { deleteKRA(); } }) } }); $('#kpiList').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){ loadCompanyKPIEdit(); } if(dCell ==5){ 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; } 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) { deleteMainDivisioniKPI(); } }) } }); function deleteMainDivisioniKPI(){ var groupKRAid = $("#groupKRAid").val(); var kpiActiveID = $("#kpiActiveID").val(); //alert(kpiActiveID); ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteMainDivisionKPI.php", method: 'POST', dataType: 'text', async:true, data: { AreaKPIDelete: 1, kpiActiveID: kpiActiveID, groupKRAid: groupKRAid }, success: function(d){ $("#kpiList").html(d); countRow(); ShowUploadBar(); } }); } function loadBranchKPI(){ var groupKRAid = $("#groupKRAid").val(); //alert(groupKRAid); ShowUploadBar(); $.ajax({ url: "./ajaxCall/onChangeLoadBranchKPI.php", // get KPI list based on selected KRA in the table method: 'POST', dataType: 'text', async:true, data: { loadKPI: 1, groupKRAid: groupKRAid }, success: function(d){ $("#topKPIID").html(d); countRow(); ShowUploadBar(); } }); } function loadCompanyKPIEdit(){ var groupKRAid = $("#groupKRAid").val(); //alert(groupKRAid); ShowUploadBar(); $.ajax({ url: "./ajaxCall/onChangeLoadBranchKPI.php", method: 'POST', dataType: 'text', async:true, data: { loadKPI: 1, groupKRAid: groupKRAid }, success: function(d){ $("#EdittopKPIID").html(d); countRow(); ShowUploadBar(); } }); } function deleteKRA(){ var groupKRAid = $("#groupKRAid").val(); var SelectedRecordID = $("#SelectedRecordID").val(); //alert(groupKRAid); //return false; ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteSubGroupoKRA.php", method: 'POST', dataType: 'text', async:true, data: { kraDelete: 1, SelectedRecordID: SelectedRecordID, groupKRAid: groupKRAid }, success: function(d){ $("#kraList").html(d); countRow(); ShowUploadBar(); } }); } $('#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 SelectedRecordID = $("#SelectedRecordID").val(); //alert(SelectedRecordID); //return false; ShowUploadBar(); $.ajax({ url: "./ajaxCall/viewSubGroupKRA.php", method: 'POST', dataType: 'text', async:true, data: { kraView: 1, SelectedRecordID: SelectedRecordID }, success: function(d){ $("#kraList").html(d); //countRow(); ShowUploadBar(); } }); } if(dCell ==5){ //alert('Editing Data'); } if(dCell ==6){ 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; } Swal.fire({ title: 'Are you sure?', 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) { deleteSubGroup(); } }) } }); function deleteSubGroup(){ var companySelectedID = $("#SelectedRecordID").val(); //alert(companySelectedID); ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteSubGroupRecord.php", method: 'POST', dataType: 'text', async:true, data: { subGrpDelete: 1, companySelectedID: companySelectedID }, success: function(d){ $("#pmsPageTable").html(d); countRow(); ShowUploadBar(); } }); } </script> <!--########################################################################################################--> <?php } ?>

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