File manager

File manager - Edit - /home/autoph/public_html/pms_v1/pages/pmsBranch.php

Back
<?php session_start(); include_once("../../../cfg/conn.php"); include ("../functions/users.php"); if(isset($_SESSION['userID'])) { // echo "Session ID is '" . $_SESSION['userID']; // echo "<br>PMS Name id " . $_SESSION['userID']; $uID = $_SESSION['userID']; $branchID = getEmployeeEmpInformationB($uID)[4]; $brandID = getBrandID($branchID)[0]; //echo "Arnel ". $branchID; //============================================================================================================== } //error_reporting(0); if(isset($_POST['cmp'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); $roleID = userProfileID($uID); $moduleID = 12; $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-building" style='font-size:20px;color:#0471AC'> Branch/Dealer Setup </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'> <!--SELECTED BRAND ID --> <input type='hidden' id='SelectedCompanyID'> <!--SELECTED KPI ID --> <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">   Help</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/xlsBranch_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/csvBranch_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 class="btn btn-danger pageUpperRightMenu" onClick="window.open('./pdfViewer/RPTBranch_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 BRANCH / DEALER</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="compNameID">SELECT COMPANY:</label> <br> <select name='compNameID' id='compNameID' class="form-select form-select-lg p-2 w-75 rounded-sm selectBG"> <option selected value="">-- SELECT --</option> <?php $sql = "SELECT * FROM vts_company WHERE comp_status=1"; $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="dealCode">BRANCH CODE:</label> <input type="text" class="form-control w-75" id="dealCode" name="dealCode"> </div> <div class="form-group"> <label for="dealName">BRANCH NAME:</label> <input type="text" class="form-control radius-sm" id="dealName" name="dealName"> </div> <div class="form-group"> <label for="dealAddress">BRANCH ADDRESS:</label> <input type="text" class="form-control" id="dealAddress" name="dealAddress"> </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="saveNewBranch"> <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" data-dismiss="modal" class="close" >×</button> </div> <!-- Modal body --> <div class="modal-body p-1" style='height:700px;overflow:auto'> <table id='kraList' class='w-100' style='border-collapse:collapse'> </table> </div> <!-- Modal footer --> <div class="modal-footer"> <div class="form-group float-left text-left col-lg-6 col-md-8 col-md-10 col-sm-12"> <select name='activeBrand' id='activeBrand' onchange='javascript:updateDealerBrand(this.value);' class="form-select form-select-lg p-1 w-50 rounded-md float-left" style='font-family:Calibri;font-size:12px;float:left'> <option selected value=""><?php echo getBrandName($brandID)[0];?></option> <?php $sql = "SELECT * FROM pms_brand WHERE deleted=0 ORDER BY brand_name ASC"; $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['code']." - ".$row['brand_name']."</option>"; } } ?> </select> </div> <div class="form-group w-25 text-right float-left"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" id="addNewKRA" data-toggle="modal" data-target="#AddKRAModal" onclick="javascript:loadGroupKRA()" > <span class="btn-label"><i class="fa fa-plus">   NEW KRA</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> </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="selectedKRAID">COMPANY 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> <input type='hidden' id='groupKRAid'> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="selectedKRAIDEdit">COMPANY KRA:</label> <select name='selectedKRAIDEdit' id='selectedKRAIDEdit' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> </select> </div> <!-- <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 BRANCH:</h4> <button type="button" class="close" data-dismiss="modal">×</button> <input type='hidden' id='groupKRAid'> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="editCompany">COMPANY:</label> <select name='editCompany' id='editCompany'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"; $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="editDealerCode">DEALER CODE:</label> <input type="text" class="form-control" id="editDealerCode" name="editDealerCode"> </div> <div class="form-group"> <label for="EditPMSName">BRANCH NAME:</label> <input type="text" class="form-control" id="EditPMSName" name="EditPMSName"> </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:loadCompanyKPI();"> <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 class="form-group"> <label for="EditKPIDescription">DESCRIPTION:</label> <textarea type="text" class="form-control h-25" id="EditKPIDescription" name="EditKPIDescription" 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"> //============================================================================================================================================ //============================================================================================================================================ $("#saveNewBranch").click(function(){ var dealAddress = $("#dealAddress").val(); var dealName = $("#dealName").val(); var dealCode = $("#dealCode").val(); var compNameID = $("#compNameID").val(); if(dealName===''){ 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(compNameID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select company to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(dealCode===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please type branch code 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/saveNewBranch.php", type: "POST", async: true, data: { "dealCode":dealCode, "compNameID":compNameID, "dealName":dealName, "dealAddress":dealAddress, "pmsAction":1 }, success: function(dx){ $("#pmsPageTable").html(dx); $('#dealCode').val(''); $('#dealName').val(''); $('#dealAddress').val(''); ShowUploadBar(); Swal.fire('Transaction complete', '', 'info'); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#saveNewKRA").click(function(){ var kraTAG = "MAIN"; var companyID = $("#SelectedCompanyID").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(companyID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'No Company 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/saveNewBranchKRA.php", type: "POST", async: true, data: { "kraTAG":kraTAG, "companyID":companyID, "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 SelectedRecordID = $("#SelectedRecordID").val(); var EditKRACode = $("#EditKRACode").val(); var EditKRAWeight = $("#EditKRAWeight").val(); var EditKRAName = $("#EditKRAName").val(); var EditkraTAG = "MAIN"; var selectedKRAIDEdit = $("#selectedKRAIDEdit").val(); ///var AddKRADescription = $("#AddKRADescription").val(); //alert(groupID); //alert(groupKRAid); //return false; if(selectedKRAIDEdit===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select MAIN KRA to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) 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/updateBranchKRA.php", type: "POST", async: true, data: { "EditkraTAG":EditkraTAG, "selectedKRAIDEdit":selectedKRAIDEdit, "groupKRAid":groupKRAid, "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 editDealerCode = $("#editDealerCode").val(); var editCompany = $("#editCompany").val(); var EditPMSName = $("#EditPMSName").val(); var start = 0; var limit = 50; var infCanvass = ''; var reachedMax = false; if(editDealerCode===''){ 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/updatePMSBranchEntry.php", type: "POST", async: true, data: { "EditPMSName":EditPMSName, "editCompany":editCompany, "editDealerCode":editDealerCode, "SelectedRecordID":SelectedRecordID, "updatePMS":1 }, success: function(ud){ $("#pmsPageTable").html(ud); $('#EditPMSName').val(''); $('#editCompany').val(''); $('#editDealerCode').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 = $("#EditKPIDescription").val(); //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_updateBranchKPI.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(''); $('#EditKPIDescriptiond').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_SaveNewBranchKPI.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'); } }) }); 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 = 50; getData(); } }); $(document).ready(function () { countRow(); getData(); }); function getData() { var recordCount = $("#recordCount").html(); //alert(infCanvass); //alert(limit); //return false; if(start >= recordCount){ $("#currentCount").html(recordCount); return false; } ShowUploadBar(); if (reachedMax) return; $.ajax({ url: "./ajaxCall/loadBranch_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 companyID = $("#SelectedCompanyID").val(); //alert(companyID); ShowUploadBar(); $.ajax({ url: "./ajaxCall/onchangeLoadCompKRA.php", method: 'POST', dataType: 'text', async:true, data: { loadCompanyKRA: 1, companyID: companyID }, success: function(d){ $("#selectedKRAID").html(d); ShowUploadBar(); } }); } function loadGroupKRAEdit(){ var companyID = $("#SelectedCompanyID").val(); //alert(companyID); ShowUploadBar(); $.ajax({ url: "./ajaxCall/onchangeLoadCompKRA.php", method: 'POST', dataType: 'text', async:true, data: { loadCompanyKRA: 1, companyID: companyID }, success: function(d){ $("#selectedKRAIDEdit").html(d); ShowUploadBar(); } }); } function countRow(){ //alert('test'); $.ajax({ url: "./ajaxCall/loadBranch_countRow.php", type: "POST", async: false, data: { "branchRow":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("SelectedCompanyID").value = x[1].innerHTML; document.getElementById("kraTitle").innerHTML = "BRANCH: " + x[3].innerHTML; document.getElementById("editDealerCode").value = x[2].innerHTML; document.getElementById("EditPMSName").value = x[3].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 = "KRA: "+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/viewBranchKPI.php", method: 'POST', dataType: 'text', async:true, data: { kraView: 1, "groupKRAid": groupKRAid }, success: function(d){ $("#kpiList").html(d); //countRow(); ShowUploadBar(); } }); } if(dCell ==5){ loadGroupKRAEdit(); } 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) { deleteBranchKPI(); } }) } }); function deleteKRA(){ var groupKRAid = $("#groupKRAid").val(); var SelectedRecordID = $("#SelectedRecordID").val(); //alert(groupKRAid); //return false; ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteBranchKRA.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 ==5){ //call function to load all KRA's based on selected group var SelectedRecordID = $("#SelectedRecordID").val(); //alert(SelectedRecordID); //return false; ShowUploadBar(); $.ajax({ url: "./ajaxCall/viewBranchKRA.php", method: 'POST', dataType: 'text', async:true, data: { kraView: 1, SelectedRecordID: SelectedRecordID }, success: function(d){ $("#kraList").html(d); //countRow(); ShowUploadBar(); } }); } if(dCell ==6){ } if(dCell ==7){ 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) { deleteBranch(); } }) } }); function deleteBranch(){ var branchID = $("#SelectedRecordID").val(); //alert(branchID); //return false; ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteBranchRecord.php", method: 'POST', dataType: 'text', async:true, data: { deleteBranch: 1, branchID: branchID }, success: function(d){ $("#pmsPageTable").html(d); countRow(); ShowUploadBar(); } }); } function loadCompanyKPI(){ var groupKRAid = $("#groupKRAid").val(); //alert(groupKRAid); ShowUploadBar(); $.ajax({ url: "./ajaxCall/onChangeLoadCompanyKPI.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/onChangeLoadCompanyKPI.php", method: 'POST', dataType: 'text', async:true, data: { loadKPI: 1, groupKRAid: groupKRAid }, success: function(d){ $("#EdittopKPIID").html(d); countRow(); ShowUploadBar(); } }); } function deleteBranchKPI(){ var groupKRAid = $("#groupKRAid").val(); var kpiActiveID = $("#kpiActiveID").val(); //alert(kpiActiveID); ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteBranchKPI.php", method: 'POST', dataType: 'text', async:true, data: { AreaKPIDelete: 1, kpiActiveID: kpiActiveID, groupKRAid: groupKRAid }, success: function(d){ $("#kpiList").html(d); countRow(); ShowUploadBar(); } }); } function updateDealerBrand(){ var SelectedRecordID = $("#SelectedRecordID").val(); var activeBrand = $("#activeBrand").val(); ShowUploadBar(); $.ajax({ url: "./ajaxUpdate/updateDealerBrandAssignment.php", method: 'POST', dataType: 'text', async:true, data: { brand: 1, SelectedRecordID: SelectedRecordID, activeBrand: activeBrand }, success: function(d){ $("#pmsPageTable").html(d); countRow(); ShowUploadBar(); } }); } </script> <!--########################################################################################################--> <?php } ?>

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