<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Life_renewals_report  extends Action_controller{	
	public function __construct(){
		parent::__construct('life_renewals_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;
		
		$this->load->view("$this->control_name/manage",$data);
	}
	
	public function check_renewals_details(){
		// $emp_code    = $this->input->post('emp_code');
		// $from_month  = $this->input->post('from_month');
		// $to_month    = $this->input->post('to_month');
		$start_date = date('Y-m-d', strtotime($this->input->post('start_date')));
		$end_date   = date('Y-m-d', strtotime($this->input->post('end_date')));
		// echo "$start_date::$end_date";die;
		// $start      = strtotime($start_date);
		// $month      = strtotime($start_date);
		// $end        = strtotime($end_date);
		$tble_line    = "";
		if($start_date && $end_date){
			$renewal_query    = 'select *,cw_life_renewals.client_name,cw_life_renewals.login_code,cw_company_name.company_name,cw_product_name.product_name,concat(cw_employees.employee_code," - ",cw_employees.employee_name) as employee_code,cw_life_renewals_log.trans_created_date,cw_life_renewals.policy_number,cw_life_renewals.grace_period_date from cw_life_renewals_log inner join cw_life_renewals on cw_life_renewals.prime_life_renewals_id = cw_life_renewals_log.prime_life_renewals_id inner join cw_company_name on cw_company_name.prime_company_name_id = cw_life_renewals.product_company_name inner join cw_product_name on cw_product_name.prime_product_name_id = cw_life_renewals.product_name inner join cw_employees on cw_employees.prime_employees_id = cw_life_renewals_log.trans_created_by where cw_life_renewals_log.trans_created_date BETWEEN "'.$start_date.'" AND "'.$end_date.'" and cw_life_renewals_log.trans_status = 1';
			$renewal_info     = $this->db->query("CALL sp_a_run ('SELECT','$renewal_query')");
			$renewal_result   = $renewal_info->result_array();
			$renewal_info->next_result();
			// echo $renewal_query;die;
			// $health_renewals_qry  = "select *,cw_health_company.company_name,cw_health_product.product_name,cw_life_mode.mode_value from $this->prime_table   inner join cw_life_mode on cw_life_mode.prime_life_mode_id = $this->prime_table.payment_mode where $this->prime_table.$this->prime_id = $policy_id and $this->prime_table.trans_status = 1";

			// inner join cw_status_mode on cw_status_mode.prime_status_mode_id = cw_life_renewals_log.renewal_status

			if($renewal_result){
				echo json_encode(array('success' => TRUE,'renewal_report' => $renewal_result));
			}else{
				echo json_encode(array('success' => FALSE,'message' => "No Data Available"));
			}

		}
	}		
}
?>