<?php
class Homemodel extends CI_Model{
	public function today_lead(){
	  $this->db->from('lead_info');
	  $this->db->where('lead_info.status', 1); 
	  return $this->db->get();
	}
	public function open_lead(){
	  $this->db->from('lead_info');
	  $this->db->where('lead_info.status', 1); 
	  return $this->db->get();
	}	
	public function get_allowed_modules($logged_id){
		if((int)$this->session->userdata('logged_role') === 12){
			$this->db->from('modules');
			$this->db->join('permissions', 'permissions.permission_id = modules.module_id');
			$this->db->join('grants_customer', 'permissions.permission_id = grants_customer.permission_id');
			$this->db->where('prime_customer_id', $logged_id);
			$this->db->where('menu_type', 1);
			$this->db->order_by('sort', 'asc');
			return $this->db->get();
		}else{
			$this->db->from('modules');
			$this->db->join('permissions', 'permissions.permission_id = modules.module_id');
			$this->db->join('grants', 'permissions.permission_id = grants.permission_id');
			$this->db->where('prime_employees_id', $logged_id);
			$this->db->where('modules.menu_type', 1);
			$this->db->order_by('sort', 'asc');
			return $this->db->get();
		}		
	}
	public function get_header_menu($logged_id){
		if((int)$this->session->userdata('logged_role') === 12){
			$this->db->select('main_menu.menu_name,modules.module_id,module_name,sub_menu_name,modules.menu_icon');
			$this->db->from('modules');
			$this->db->join('permissions', 'permissions.permission_id = modules.module_id');
			$this->db->join('grants_customer', 'permissions.permission_id = grants_customer.permission_id');
			$this->db->join('main_menu', 'main_menu.prime_menu_id = modules.menu_id');
			$this->db->join('sub_menu', 'sub_menu.prime_sub_menu_id = modules.sub_menu_id','left');
			$this->db->where('prime_customer_id', $logged_id);
			$this->db->where('modules.trans_status',1);
			$this->db->where('modules.show_module',1);
			$this->db->where('main_menu.trans_status',1);
			$this->db->where('main_menu.menu_status',1);
			$this->db->where('modules.menu_type', 1);
			// $this->db->order_by('menu_sort', 'asc');
			// $this->db->order_by('sub_menu_sort', 'asc');
			$this->db->order_by('sort', 'asc');
			$query =  $this->db->get();
			return $query->result();
		}else{
			$this->db->select('main_menu.menu_name,modules.module_id,module_name,sub_menu_name,modules.menu_icon');
			$this->db->from('modules');
			$this->db->join('permissions', 'permissions.permission_id = modules.module_id');
			$this->db->join('grants', 'permissions.permission_id = grants.permission_id');
			$this->db->join('main_menu', 'main_menu.prime_menu_id = modules.menu_id');
			$this->db->join('sub_menu', 'cw_sub_menu.prime_sub_menu_id = modules.sub_menu_id','left');
			$this->db->where('prime_employees_id', $logged_id);
			$this->db->where('modules.trans_status',1);
			$this->db->where('modules.show_module',1);
			$this->db->where('main_menu.menu_status',1);
			$this->db->where('main_menu.trans_status',1);
			$this->db->where('modules.menu_type', 1);
			// $this->db->order_by('menu_sort', 'asc');
			// $this->db->order_by('sub_menu_sort', 'asc');
			$this->db->order_by('sort', 'asc');
			$query =  $this->db->get();
			return $query->result();
		}
	}
	
	//GET REPORT DETAILS FOR ROLE BASED HEADER -- 13MARCH2019
	public function get_report_menu($logged_user_role){
		$this->db->select('prime_report_setting_id,report_name,menu_name,menu_icon');
		$this->db->from('report_setting');
		$this->db->join('main_menu', 'main_menu.prime_menu_id = report_setting.report_menu');
		$this->db->where('report_setting.trans_status',1);
		//$this->db->where("report_for LIKE '%".$logged_user_role."%'");
		$this->db->where('report_setting.menu_type', 1);
		$this->db->where('main_menu.menu_status',1);
		//$this->db->where("report_for IN (".$logged_role.")",NULL, false);
		$this->db->where("FIND_IN_SET('".$logged_user_role."',report_for)!=",0);
		$this->db->order_by('menu_sort', 'asc');
		// $this->db->order_by('report_name', 'asc');
		// $this->db->order_by('prime_report_setting_id', 'asc');
		$query =  $this->db->get();
		//echo $this->db->last_query();
		$report_result = $query->result_array();

		$report_result = array_reduce($report_result, function($result, $arr){            
            $result[$arr['menu_name']][] = $arr;
            return $result;
        }, array());
        return $report_result;
	}	
}
?>