File manager - Edit - /home/autoph/public_html/pms_v1/config/loadRoleInfo.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); if(isset($_POST['role'])){ $searchID = $_POST['searchID']; $myUserID = $_POST['myUserID']; //echo "Profile ID :".$searchID; echo" <input type='hidden' id='adminUserID' placeholder='adminUserID' value='$myUserID'>"; echo" <input type='hidden' id='searchID' placeholder='searchID' value='$searchID'>"; echo" <input type='hidden' id='getModuleID' placeholder='getModuleID' >"; $title =""; echo "<table id='updateAccess' class='col-lg-12 col-md-12' style='width:150%'>"; echo "<thead>"; echo "<th>ID</th>"; echo "<th>MAIN MENU</th>"; echo "<th>MODULE NAME</th>"; echo "<th class='text-center'>VIEW</th>"; echo "<th class='text-center'>ADD</th>"; echo "<th class='text-center'>EDIT</th>"; echo "<th class='text-center'>DELETE</th>"; echo "<th class='text-center'>PRINT</th>"; echo "<th class='text-center'>DOWNLOAD</th>"; echo "</thead>"; $aRole = "SELECT * FROM `user_modules` WHERE `deleted`=0 ORDER BY `title_name`, `module_name` ASC"; $qRole = mysqli_query($conn,$aRole); while($row = mysqli_fetch_array($qRole)){ $canView = 0; $canAdd = 0; $canEdit = 0; $canDelete = 0; $canPrint=0; $canDownload=0; $moduleID = $row['id']; $varView = "canView".$searchID."".$moduleID; //Profile => module $varAdd = "canAdd".$searchID."".$moduleID; $varEdit = "canEdit".$searchID."".$moduleID; $varDelete = "canDelete".$searchID."".$moduleID; $varPrint = "canDelete".$searchID."".$moduleID; $varDownload = "canDelete".$searchID."".$moduleID; $chkAccess = "SELECT * FROM `user_profile_data` WHERE `profile_id`='$searchID' AND `module_id`='$moduleID' AND `deleted`=0"; $QchkAccess = mysqli_query($conn,$chkAccess); while($qC = mysqli_fetch_array($QchkAccess)){ $canView = $qC['can_view']; $canAdd = $qC['can_add']; $canEdit = $qC['can_edit']; $canDelete = $qC['can_delete']; $canDownload = $qC['download']; $canPrint = $qC['print']; } if($canView == 1){ $viewCheck = "checked"; }else{ $viewCheck = ""; } if($canAdd == 1){ $addCheck = "checked"; }else{ $addCheck = ""; } if($canEdit == 1){ $editCheck = "checked"; }else{ $editCheck = ""; } if($canDelete == 1){ $deleteCheck = "checked"; }else{ $deleteCheck = ""; } if($canDownload == 1){ $downloadCheck = "checked"; }else{ $downloadCheck = ""; } if($canPrint == 1){ $printCheck = "checked"; }else{ $printCheck = ""; } ?><tr onclick="javascript:profileSelID(this);" style="width:100%"><?php if($title === $row['title_name']){ echo "<td>".$row['id']."</td>"; echo "<td></td>"; echo "<td>".$row['module_name']."</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varView' $viewCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varAdd' $addCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varEdit' $editCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varDelete' $deleteCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varPrint' $printCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varDownload' $downloadCheck>"; echo "</td>"; }else{ echo "<td>".$row['id']."</td>"; echo "<td>".$row['title_name']."</td>"; echo "<td>".$row['module_name']."</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varView' $viewCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varAdd' $addCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varEdit' $editCheck>"; echo "</td>"; echo "<td class='text-center align-top'>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varDelete' $deleteCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varPrint' $printCheck>"; echo "</td>"; echo "<td class='text-center align-top''>"; echo "<input class='form-check-input' type='checkbox' value='' id='$varDownload' $downloadCheck>"; echo "</td>"; } echo "</tr>"; $title = $row['title_name']; } echo "</table>"; $conn->close(); } ?> <script> function profileSelID(row) { var x=row.cells; document.getElementById("getModuleID").value = x[0].innerHTML; } $('#updateAccess').on("click","tr td",function(row){ var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value var x = row.cells; //alert(dCell); updateCanView(dCell); }); function updateCanView(dCell){ var searchID = $("#searchID").val(); // Profile ID var getModuleID = $("#getModuleID").val(); var adminUserID = $("#adminUserID").val(); var canView ="canView" + searchID + getModuleID; var canAdd ="canAdd" + searchID + getModuleID; var canEdit ="canEdit" + searchID + getModuleID; var canDelete ="canDelete" + searchID + getModuleID; var canPrint ="canPrint" + searchID + getModuleID; var canDownload ="canDownload" + searchID + getModuleID; //alert(searchID); ShowUploadBar(); $.ajax({ url: "./config/updateAccessRights.php", method: 'POST', dataType: 'text', async:true, data: { "canDownload":canDownload, "canPrint":canPrint, "adminUserID":adminUserID, "getModuleID":getModuleID, "canView":canView, "canAdd":canAdd, "canEdit":canEdit, "canDelete":canDelete, "searchID":searchID, "role": dCell }, success: function(d){ //$("#refresh").html(d); ShowUploadBar(); } }); } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings