File manager

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

Back
<?php session_start(); include ("../functions/users.php"); 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['crd'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); $roleID = userProfileID($uID); $moduleID = 41; $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'> Car Model 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='companySelectedID'> <!--SELECTED BRAND ID --> <input type='hidden' id='groupKRAid'> <!--SELECTED KRA ID --> <input type='hidden' id='userID' value="<?php echo $uID;?>" > <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/xlsCompany_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/csvCompany_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"> <table id ='pmsPageTable' style="width:100%;border-collapse:collapse"> </table> </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 BRAND--> <!-- 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 MODEL</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="brandID">BRAND CODE:</label> <select name='brandID' id='brandID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="">-- SELECT --</option> <?php $sql = "SELECT * FROM pms_brand WHERE deleted=0 ORDER BY 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['id']."'>".$row['code']." - ".$row['brand_name']."</option>"; } } ?> </select> </div> <div class="form-group"> <label for="modelName">MODEL NAME:</label> <input type="text" class="form-control radius-sm" id="modelName" name="modelName"> </div> <div class="form-group"> <label for="description">DESCRIPTION:</label> <input type="text" class="form-control" id="description"> </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="saveNewModel"> <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 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 MODEL</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="EditbrandID">BRAND CODE:</label> <select name='EditbrandID' id='EditbrandID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="">-- SELECT --</option> <?php $sql = "SELECT * FROM pms_brand WHERE deleted=0 ORDER BY 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['id']."'>".$row['code']." - ".$row['brand_name']."</option>"; } } ?> </select> </div> <div class="form-group"> <label for="EditModelCode">MODEL NAME:</label> <input type="text" class="form-control" id="EditModelCode" name="EditModelCode"> </div> <div class="form-group"> <label for="editModelDesc">MODEL DESCRIPTION:</label> <textarea type="text" class="form-control h-25" id="editModelDesc" name="editModelDesc" 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="saveEditModel" 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(){ $("#saveEditModel").click(function(){ var userID = $("#userID").val(); var EditModelCode = $("#EditModelCode").val(); var EditbrandID = $("#EditbrandID").val(); var editModelDesc = $("#editModelDesc").val(); var companySelectedID = $("#companySelectedID").val(); if(EditbrandID == ''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select brand name to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(EditModelCode == ''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input model 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/editNewModel.php", type: "POST", async: true, data: { "EditModelCode":EditModelCode, "EditbrandID":EditbrandID, "editModelDesc":editModelDesc, "companySelectedID":companySelectedID, "userID":userID, "pmsAction":1 }, success: function(dx){ $("#pmsPageTable").html(dx); $('#compCode').val(''); $('#compName').val(''); $('#compAddress').val(''); ShowUploadBar(); Swal.fire('Transaction complete', '', 'info'); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#saveNewModel").click(function(){ var userID = $("#userID").val(); var brandID = $("#brandID").val(); var modelName = $("#modelName").val(); var description = $("#description").val(); if(brandID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select brand name to continue...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(modelName===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please input model 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/saveNewModel.php", type: "POST", async: true, data: { "brandID":brandID, "modelName":modelName, "description":description, "userID":userID, "pmsAction":1 }, success: function(dx){ $("#pmsPageTable").html(dx); $('#compCode').val(''); $('#compName').val(''); $('#compAddress').val(''); ShowUploadBar(); Swal.fire('Transaction complete', '', 'info'); } }) }); }); </script> <!--########################## ############################################--> <script type="text/javascript"> var start = 0; var limit = 15; 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: "./ajaxCall/LoadCarModels.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 = 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/countModelData.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("companySelectedID").value = x[0].innerHTML; document.getElementById("EditModelCode").value = x[2].innerHTML; document.getElementById("editModelDesc").value = x[3].innerHTML; } $('#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 //alert('table clicked'); if(dCell ==4){ } if(dCell ==5){ } 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) { deleteModel(); } }) } }); function deleteModel(){ var companySelectedID = $("#companySelectedID").val(); //alert(companySelectedID); ShowUploadBar(); $.ajax({ url: "./ajaxDelete/deleteModel.php", method: 'POST', dataType: 'text', async:true, data: { DeleteCompany: 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