File manager - Edit - /home/autoph/public_html/connectv1/app/employee/update_role.php
Back
<?php include_once("../../cfg/db.php"); $role_id = (trim($_POST['role_id'])); $current_role =(trim($_POST['role_status'])); $menu_id = (trim($_POST['menu_id'])); $menu_name = (trim($_POST['menu_name'])); $type = (trim($_POST['type'])); if($current_role > 0){ if($type == '1'){ // echo "DELETE FROM `employee_access_side_menu` WHERE `employee_role_id` = '$role_id' AND `side_menu_id` = '$menu_id'";return; $db -> sql_query("DELETE FROM `employee_access_side_menu` WHERE `employee_role_id` = '$role_id' AND `side_menu_id` = '$menu_id'"); $sub_menu_list = $db -> return_result("SELECT id FROM `settings_side_menu_sub` WHERE `side_menu_id` = '$menu_id' "); foreach($sub_menu_list as $data){ $sub_menu_id_data = $data['id']; $db -> sql_query("DELETE FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '$role_id' AND `side_menu_sub_id` = '$sub_menu_id_data'"); } }else if($type == '2'){ // echo "DELETE FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '$role_id' AND `side_menu_sub_id` = '$menu_id'";return; $db -> sql_query("DELETE FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '$role_id' AND `side_menu_sub_id` = '$menu_id'"); } }else{ if($type == '1'){ // echo "INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`) VALUES ('$role_id','$menu_id')";return; $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`) VALUES ('$role_id','$menu_id')"); }else if($type == '2'){ // echo "INSERT INTO `employee_access_side_menu_sub`(`employee_role_id`, `side_menu_sub_id`) VALUES ('$role_id','$menu_id')";return; $db -> sql_query("INSERT INTO `employee_access_side_menu_sub`(`employee_role_id`, `side_menu_sub_id`) VALUES ('$role_id','$menu_id')"); $sub_menu_owner = $db -> select("SELECT side_menu_id FROM settings_side_menu_sub WHERE id = '$menu_id' "); if(intval($db -> select("SELECT COUNT(1) FROM employee_access_side_menu WHERE side_menu_id = '$sub_menu_owner' AND employee_role_id = '$role_id' ")) < 1){ $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`) VALUES ('$role_id','$sub_menu_owner')"); } } } echo $menu_id; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings