<?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']));
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 ORDER BY name ASC ";
    // echo sprintf($role_query,$fields,$search)." $offset_limit";return;
    $role_list_query =  $db -> sql_query(sprintf($role_query,$fields,$search)." $offset_limit"); 
  
    $role_list_query_count = $db -> select(sprintf($role_query,$count,$search));
 
    $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(*) FROM `settings_side_menu_sub` WHERE `side_menu_id` = '".$data['id']."' and status = 1");
        $role_count = $db -> select("SELECT count(*) FROM `employee_access_side_menu` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_id` = '".$data['id']."'");    
        $menu_arr = array_merge(  $menu_arr , array($data['id'].'-'.$data['name'] =>  '{"role_id": "'.$data['id'].'","role_name": "'.$data['name'].'","current_role": "'.$role_count.'","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(*) FROM `employee_access_side_menu_sub` WHERE `employee_role_id` = '".$row['id']."' AND `side_menu_sub_id` = '".$data2['id']."'");
                    $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.'","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['rows1'] =  array('name'=>$row['name']);
        // $json_arr['rows1'] =    array_merge($json_arr['rows1'],array('name1'=>$row['name']));

        $json_arr['rows'] = array_merge($json_arr['rows'] , array(   
            $final_row_array
         ));

        // $json_arr['rows'] = array_merge($json_arr['rows'] , array(   
        //     $menu_arr
        //  ));

        //  $json_arr['rows'] = array_merge($json_arr['rows'] , array(   
        //     $sub_menu_arr
        //  ));
    }
  
 
    $json_arr['total'] =   $role_list_query_count; //total number of result  


echo json_encode($json_arr);
 
function isNotEmpty($data){
	return preg_match('/\S/', $data);
}

?>