File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/employee/update_role1.php

Back
<?php include_once("../../cfg/db.php"); $role_id = (trim($_POST['role_id'])); $current_role =(trim($_POST['role_status'])); //access $current_role_view_own =(trim($_POST['role_status_view_own'])); //view_own $current_role_create =(trim($_POST['role_status_create'])); //create $current_role_edit =(trim($_POST['role_status_edit'])); //edit $current_role_delete =(trim($_POST['role_status_delete'])); //remove $role_type =(trim($_POST['role_type'])); //remove $menu_id = (trim($_POST['menu_id'])); $menu_name = (trim($_POST['menu_name'])); $type = (trim($_POST['type'])); if($role_type =='access'){ 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' AND `employee_role_type_id` = '1' "); $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' AND `employee_role_type_id` = '1' "); } }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' AND `employee_role_type_id` = '1' "); } }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','1')"); }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','1')"); $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' AND employee_role_type_id = '1' ")) < 1){ $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`,`employee_role_type_id`) VALUES ('$role_id','$sub_menu_owner','1')"); } } } } if($role_type == 'view_own'){ if($current_role_view_own > 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' AND `employee_role_type_id` = '3' "); $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' AND `employee_role_type_id` = '3' "); } }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' AND `employee_role_type_id` = '3' "); } }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','3')"); }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','3')"); $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' AND employee_role_type_id = '3' ")) < 1){ $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`,`employee_role_type_id`) VALUES ('$role_id','$sub_menu_owner','3')"); } } } } if($role_type == 'create'){ if($current_role_create > 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' AND `employee_role_type_id` = '4' "); $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' AND `employee_role_type_id` = '4' "); } }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' AND `employee_role_type_id` = '4' "); } }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','4')"); }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','4')"); $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' AND employee_role_type_id = '4' ")) < 1){ $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`,`employee_role_type_id`) VALUES ('$role_id','$sub_menu_owner','4')"); } } } } if($role_type == 'edit'){ if($current_role_edit > 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' AND `employee_role_type_id` = '5' "); $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' AND `employee_role_type_id` = '5' "); } }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' AND `employee_role_type_id` = '5' "); } }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','5')"); }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','5')"); $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' AND employee_role_type_id = '5' ")) < 1){ $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`,`employee_role_type_id`) VALUES ('$role_id','$sub_menu_owner','5')"); } } } } if($role_type == 'delete'){ if($current_role_delete > 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' AND `employee_role_type_id` = '6' "); $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' AND `employee_role_type_id` = '6' "); } }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' AND `employee_role_type_id` = '6' "); } }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','6')"); }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`,`employee_role_type_id`) VALUES ('$role_id','$menu_id','6')"); $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' AND employee_role_type_id = '6' ")) < 1){ $db -> sql_query("INSERT INTO `employee_access_side_menu`(`employee_role_id`, `side_menu_id`,`employee_role_type_id`) VALUES ('$role_id','$sub_menu_owner','6')"); } } } } echo $menu_id; ?>

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