<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Life_report  extends Action_controller{	
	public function __construct(){
		parent::__construct('life_report');
		$this->collect_base_info();
	}
	
	// LOAD PAGE QUICK LINK,FILTERS AND TABLE HEADERS
	public function index(){
		$data['quick_link']    = $this->quick_link;
		$data['table_head']    = $this->table_head;
		$data['master_pick']   = $this->master_pick;
		$data['fliter_list']   = $this->fliter_list;
		//select query for get a form view setting tab result
		$select_columns            = 'cw_employees.employee_code,cw_employees.login_code,cw_employees.employee_name';
		$table_name                = 'cw_employees';
		$table_join                = '';
		$table_where               = 'cw_employees.trans_status = 1';
		//FUNCTION USED FOR CREATE A QRY 
		$emp_rslt                  = $this->query_build_function($select_columns,$table_name,$table_join,$table_where);

		//level1 employees picklist
		$level1_list[""] = "---- select Level1 ----";
		foreach($emp_rslt as $for){
			$employee_code            = $for['employee_code'];
			$login_code               = $for['login_code'];
			$employee_name            = $for['employee_name'];
			$level1_list[$employee_code] = $login_code.' - '.$employee_name;
		}
		$data['level1_list']  = $level1_list;

		//level2 employees picklist
		$level2_list[""] = "---- select Level1 ----";
		foreach($emp_rslt as $for){
			$employee_code               = $for['employee_code'];
			$login_code                  = $for['login_code'];
			$employee_name               = $for['employee_name'];
			$level2_list[$employee_code] = $login_code.' - '.$employee_name;
		}
		$data['level2_list']  = $level2_list;

		$this->load->view("$this->control_name/manage",$data);
	}
	
	public function in_active_login_detail(){
		$level1       = $this->input->post('level1');
		$level2       = $this->input->post('level2');

		$in_active_login_qry    = 'SELECT CONCAT_WS(" - ",cw_portfolio.login_code,cw_employees.employee_name) as login_code,CONCAT_WS(" - ",level1.login_code,level1.employee_name) as level1_code,CONCAT_WS(" - ",level2.login_code,level2.employee_name) as level2_code,cw_portfolio.proposer_name,cw_portfolio.proposer_mobile_no as contact_number,cw_product_name.product_name,cw_portfolio.policy_number,login_date,login_month,login_year,cw_issuance_details.issuance_status,total_net_premium from cw_portfolio inner join cw_employees on cw_employees.login_code = cw_portfolio.login_code inner join cw_employees level1 on level1.employee_code = cw_portfolio.actual_level_1 inner join cw_employees level2 on cw_portfolio.actual_level_2 = level2.employee_code inner join cw_product_name on cw_product_name.prime_product_name_id = cw_portfolio.product_name inner join cw_issuance_details on cw_issuance_details.prime_issuance_details_id = cw_portfolio.issuance_status where cw_portfolio.trans_status = 1 and cw_employees.employee_status = 2 and cw_portfolio.issuance_status = 2 and cw_portfolio.actual_level_1 = "'.$level1.'" and cw_portfolio.actual_level_2 = "'.$level2.'" ORDER BY cw_portfolio.login_date ASC';

		$in_active_login_info   = $this->db->query("CALL sp_a_run ('SELECT','$in_active_login_qry')");
		$in_active_login_rslt   = $in_active_login_info->result_array();
		$in_active_login_info->next_result();
		// ,CONCAT_WS(" - ",level1.login_code,level1.employee_name) as level1_code,CONCAT_WS(" - ",level2.login_code,level2.employee_name) as level2_code
		// inner join cw_employees level1 on level1.employee_code = cw_portfolio.actual_level_1 inner join cw_employees level2 on cw_portfolio.actual_level_2 = level2.employee_code
		if($in_active_login_rslt){
			echo json_encode(array('success' => TRUE,'in_active_login_report' => $in_active_login_rslt));
		}else{
			echo json_encode(array('success' => FALSE,'message' => "No Data Available"));
		}
	}
	
	//SELECT QUERY BUILD FUNCTION
	public function query_build_function($select_columns,$table_name,$table_join,$table_where){
		$table_qry_detail  = 'select '.$select_columns.' from '.$table_name.' '.$table_join.' where '.$table_where.'';
		$table_qry_info    = $this->db->query("CALL sp_a_run ('SELECT','$table_qry_detail')");
		$table_qry_rslt    = $table_qry_info->result_array();
		$table_qry_info->next_result();
		return $table_qry_rslt;
	}			
}
?>