File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/table/role1.php

Back
<?php include_once("../../cfg/db.php"); /** picture employee id full name company position number */ $search = $db -> escape(trim($_GET['search'])); $offset = $db -> escape(trim($_GET['offset'])); $role_id = " AND id = '".$_GET['role_id']."' "; if(isset($_GET['limit'])){ $limit = $db -> escape(trim($_GET['limit'])); $offset_limit = " LIMIT ". $offset.",".$limit; }else{ $offset_limit = ""; } $json_arr['rows'] = array(); $count = " count(id) "; $fields = " id,name "; $role_query = "SELECT %s FROM `employee_role` WHERE name like '%%%s%%' and status = 1 %s ORDER BY name ASC "; // echo sprintf($role_query,$fields,$search)." $offset_limit";return; $role_list_query = $db -> sql_query(sprintf($role_query,$fields,$search,$role_id)." $offset_limit"); $role_list_query_count = $db -> select(sprintf($role_query,$count,$search,$role_id)); $menu_arr = array(); $sub_menu_arr = array(); while($row = $role_list_query->fetch_assoc()) { $sidemenu = $db -> return_result("SELECT `id`,`name`, `link`, `icon` FROM `settings_side_menu` WHERE status=1 ORDER by `order_no` ASC"); foreach($sidemenu as $data){ $sub_number = $db -> select("SELECT count(1) FROM `settings_side_menu_sub` WHERE `side_menu_id` = '".$data['id']."' and status = 1"); $role_count = $db -> select("SELECT count(1) FROM `employee_access_side_menu` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_id` = '".$data['id']."' AND `employee_role_type_id`='1' "); //access $role_count_view_own = $db -> select("SELECT count(1) FROM `employee_access_side_menu` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_id` = '".$data['id']."' AND `employee_role_type_id`='3' "); //view_own $role_count_create = $db -> select("SELECT count(1) FROM `employee_access_side_menu` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_id` = '".$data['id']."' AND `employee_role_type_id`='4' "); //create $role_count_edit = $db -> select("SELECT count(1) FROM `employee_access_side_menu` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_id` = '".$data['id']."' AND `employee_role_type_id`='5' "); //update $role_count_delete = $db -> select("SELECT count(1) FROM `employee_access_side_menu` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_id` = '".$data['id']."' AND `employee_role_type_id`='6' "); //remove $menu_arr = array_merge($menu_arr, array($data['id'].'-'.$data['name'] => '{"role_id": "'.$data['id'].'","role_name": "'.$data['name'].'","current_role": "'.$role_count.'","current_role_view_own": "'.$role_count_view_own.'","current_role_create": "'.$role_count_create.'","current_role_edit": "'.$role_count_edit.'","current_role_delete": "'.$role_count_delete.'","type": "1"}' )); if($sub_number > 0 ){ $sidemenusub = $db -> return_result("SELECT id,`name`, `link`, `icon`, `order_no` FROM `settings_side_menu_sub` WHERE `side_menu_id` = '".$data['id']."' and status = 1 ORDER BY `order_no` ASC"); foreach($sidemenusub as $data2){ $sub_role_count = $db -> select("SELECT count(1) FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_sub_id` = '".$data2['id']."' AND `employee_role_type_id`='1' "); $sub_role_count_view_own = $db -> select("SELECT count(1) FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_sub_id` = '".$data2['id']."' AND `employee_role_type_id`='3' "); $sub_role_count_create = $db -> select("SELECT count(1) FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_sub_id` = '".$data2['id']."' AND `employee_role_type_id`='4' "); $sub_role_count_edit = $db -> select("SELECT count(1) FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_sub_id` = '".$data2['id']."' AND `employee_role_type_id`='5' "); $sub_role_count_delete = $db -> select("SELECT count(1) FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_sub_id` = '".$data2['id']."' AND `employee_role_type_id`='6' "); $sub_menu_arr = array_merge($sub_menu_arr, array($data2['id'].'-'.$data2['name'] => '{"role_id": "'.$data2['id'].'","role_name": "'.$data2['name'].'","current_role": "'.$sub_role_count.'","current_role_view_own": "'.$sub_role_count_view_own.'","current_role_create": "'.$sub_role_count_create.'","current_role_edit": "'.$sub_role_count_edit.'","current_role_delete": "'.$sub_role_count_delete.'","type": "2"}' )); } } } $final_row_array = array(); $final_row_array = array_merge(array('name'=>$row['name']),array('id'=>$row['id']),$menu_arr); $final_row_array = array_merge($final_row_array,$sub_menu_arr); if($row['id'] == "1" \|\| $row['id'] == "2"){ $final_row_array = array_merge($final_row_array,array("action"=>$row['id'])); }else{ $final_row_array = array_merge($final_row_array,array("action"=>$row['id'])); } if($row['id'] == "1" \|\| $row['id'] == "2"){ $final_row_array = array_merge($final_row_array,array("edit"=>$row['id'])); }else{ $final_row_array = array_merge($final_row_array,array("edit"=>$row['id'])); } $json_arr['rows'] = array_merge($json_arr['rows'] , array( $final_row_array )); } $json_arr['total'] = $role_list_query_count; //total number of result echo json_encode($json_arr); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>

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