<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Business_report  extends Action_controller{	
	public function __construct(){
		parent::__construct('business_report');
		$this->collect_base_info();
	}
	
	public function index(){
		$channel_info   = $this->db->query("CALL sp_a_run ('SELECT','SELECT * FROM `cw_channel` where trans_status = 1')");
		$channel_result = $channel_info->result();
		$channel_info->next_result();
		$channel_list[""] = "<button id='select_all'>---- Channel ----<button>";
		foreach($channel_result as $for){
			$channel_id   = $for->prime_channel_id;
			$channel_name = $for->channel_name;
			$channel_list[$channel_id] = $channel_name;
		}
		$data['channel_list']  = $channel_list;

		$designation_info   = $this->db->query("CALL sp_a_run ('SELECT','SELECT * FROM `cw_designation` where trans_status = 1')");
		$designation_result = $designation_info->result();
		$designation_info->next_result();
		$designation_list[""] = "---- Designation ----";
		foreach($designation_result as $des_for){
			$designation_id   = $des_for->prime_designation_id;
			$designation_name = $des_for->designation_name;
			$designation_list[$designation_id] = $designation_name;
		}
		$data['designation_list']  = $designation_list;

		$this->load->view("$this->control_name/manage",$data);
	}
	
	public function get_business(){
		$channel      = $this->input->post('channel');
		$designation  = $this->input->post('designation');
		$login_month  = $this->input->post('login_month');
		//$log_month    = "01-".$this->input->post('login_month');

		$login_code_qry = 'select GROUP_CONCAT(login_code) as login_code from cw_employees where channel = "'.$channel.'" and designation = "'.$designation.'"';
		$login_code_info    = $this->db->query("CALL sp_a_run ('SELECT','$login_code_qry')");
		$login_code_result  = $login_code_info->result();
		$login_code_info->next_result();
		$login_code = $login_code_result[0]->login_code;

		$business_qry = 'SELECT pickup_date,login_code,IFNULL(SUM(cw_portfolio.total_net_premium),0) as life_business, SUM(CASE WHEN cw_portfolio.login_status = 1 THEN cw_portfolio.total_net_premium ELSE 0 END) pdc,SUM(CASE WHEN cw_portfolio.login_status = 5 THEN cw_portfolio.total_net_premium ELSE 0 END) login from cw_portfolio where cw_portfolio.pickup_date >= "'.$from_date.'" and cw_portfolio.pickup_date <= "'.$to_date.'" and cw_portfolio.trans_status = 1 and login_code in ("'.$login_code.'") and cw_portfolio.login_status != 6 GROUP BY cw_portfolio.login_code';
		$business_info    = $this->db->query("CALL sp_a_run ('SELECT','$business_qry')");
		$business_result  = $business_info->result();
		$business_info->next_result();

		$health_qry = 'SELECT login_date,login_code,IFNULL(SUM(cw_health.net_premium),0) as health_business from cw_health where cw_health.login_date >= "'.$from_date.'" and cw_health.login_date <= "'.$to_date.'" and cw_health.trans_status = 1 and login_code in ("'.$login_code.'") and cw_health.login_status != 6 GROUP BY cw_health.login_code';
		$health_info    = $this->db->query("CALL sp_a_run ('SELECT','$health_qry')");
		$health_result  = $health_info->result();
		$health_info->next_result();

		$life_array    = array_reduce($life_rslt, function ($result, $arr) {
		    $result[$arr['login_code']] = $arr;
		    return $result;
		}, array());

		$health_array  = array_reduce($health_rslt, function ($result, $arr) {
		    $result[$arr['login_code']] = $arr;
		    return $result;
		}, array());

		$replace_array = array_replace_recursive($life_array,$health_array);
		$final_array = array();
		/*foreach ($replace_array as $key => $values){
			//$pickup_date = $values->pickup_date;
			foreach ($values as $code_key => $value) {
				$final_array[$key][$code_key]['buiz']['life']   = $value['life_business'];
				$final_array[$key][$code_key]['buiz']['health'] = $value['health_business'];
				$final_array[$key][$code_key]['life']['login']  = $value['login'];
				$final_array[$key][$code_key]['life']['pdc']    = $value['pdc'];
			}
		}*/


		
		echo "<pre>";
		print_r($business_result);
		die;




		//




	}	
}
?>