<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Twenty_four_q_mapping  extends Action_controller{
	
	public function __construct(){
		parent::__construct('twenty_four_q_mapping');
		if(!$this->Appconfig->isAppvalid()){
			redirect('config');
		}
	}	
	// LOAD PAGE WITH TABLE DATA
	public function index(){
		$form_sixteen_head_qry = 'select * from  cw_form_sixteen where trans_status = 1';
		$form_sixteen_head_info   = $this->db->query("CALL sp_a_run ('SELECT','$form_sixteen_head_qry')");
		$form_sixteen_head_result = $form_sixteen_head_info->result();
		$form_sixteen_head_info->next_result();
		$data['form_sixteen_head_result'] = $form_sixteen_head_result;
		
		$tax_sec_10_qry  = 'select cw_tax_section.tax_section,tax_act_details,tax_subsection_column from cw_tax_section inner join cw_tax_sub_section on cw_tax_sub_section.tax_section =cw_tax_section.prime_tax_section_id where cw_tax_sub_section.trans_status = 1 and cw_tax_sub_section.tax_section = 1 order by subsection_order';
		$tax_sec_10_info   = $this->db->query("CALL sp_a_run ('SELECT','$tax_sec_10_qry')");
		$tax_sec_10_result = $tax_sec_10_info->result();
		$tax_sec_10_info->next_result();
		$data['tax_sec_10_result'] = $tax_sec_10_result;
		
		$tax_sec_16_qry  = 'select cw_tax_section.tax_section,tax_act_details,tax_subsection_column from cw_tax_section inner join cw_tax_sub_section on cw_tax_sub_section.tax_section =cw_tax_section.prime_tax_section_id where cw_tax_sub_section.trans_status = 1 and cw_tax_sub_section.tax_section = 2 order by subsection_order';
		$tax_sec_16_info   = $this->db->query("CALL sp_a_run ('SELECT','$tax_sec_16_qry')");
		$tax_sec_16_result = $tax_sec_16_info->result();
		$tax_sec_16_info->next_result();
		$data['tax_sec_16_result'] = $tax_sec_16_result;
		
		$tax_sec_80_qry  = 'select cw_tax_section.tax_section,tax_act_details,tax_subsection_column from cw_tax_section inner join cw_tax_sub_section on cw_tax_sub_section.tax_section =cw_tax_section.prime_tax_section_id where cw_tax_sub_section.trans_status = 1 and cw_tax_sub_section.tax_section = 3 order by subsection_order';
		$tax_sec_80_info   = $this->db->query("CALL sp_a_run ('SELECT','$tax_sec_80_qry')");
		$tax_sec_80_result = $tax_sec_80_info->result();
		$tax_sec_80_info->next_result();
		$data['tax_sec_80_result'] = $tax_sec_80_result;
		
		$tax_sec_6a_qry  = 'select cw_tax_section.tax_section,tax_act_details,tax_subsection_column from cw_tax_section inner join cw_tax_sub_section on cw_tax_sub_section.tax_section =cw_tax_section.prime_tax_section_id where cw_tax_sub_section.trans_status = 1 and cw_tax_sub_section.tax_section = 4 order by subsection_order';
		$tax_sec_6a_info   = $this->db->query("CALL sp_a_run ('SELECT','$tax_sec_6a_qry')");
		$tax_sec_6a_result = $tax_sec_6a_info->result();
		$tax_sec_6a_info->next_result();
		$data['tax_sec_6a_result'] = $tax_sec_6a_result;
		
		$oth_sec_qry  = 'select cw_income_type.income_type,income_description,other_income_column from cw_other_income inner join cw_income_type on cw_income_type.prime_income_type_id =cw_other_income.income_type where cw_other_income.trans_status = 1 and prime_income_type_id in (1,2) order by cw_income_type.income_type';
		$oth_sec_info   = $this->db->query("CALL sp_a_run ('SELECT','$oth_sec_qry')");
		$oth_sec_result = $oth_sec_info->result();
		$oth_sec_info->next_result();
		$data['oth_sec_result'] = $oth_sec_result;
		
		$fin_set_id   = $this->financial_info[0]->prime_financial_setting_id;
		$form24q_temp_qry  = 'select prime_form_sixteen_id,form24q_value,form24q_mapping from cw_form24q_template where fin_set_id ="'.$fin_set_id.'"';		
		$form24q_temp_info   = $this->db->query("CALL sp_a_run ('SELECT','$form24q_temp_qry')");
		$form24q_temp_result = $form24q_temp_info->result();
		$form24q_temp_info->next_result();
		$data['form24q_temp_result'] = $form24q_temp_result; 
		
		$this->load->view("$this->control_name/manage",$data);
	}	
	public function save_mapping_data(){
		$form_24q_data    = json_decode($this->input->post('form_24q_data'));
		$form_24q_mapping = $this->input->post('form_24q_mapping'); 
		//print_r($form_24q_data); die;
		$created_on       = date("Y-m-d H:i:s");
		$create_by        = $this->logged_id;
		$fin_set_id       = $this->financial_info[0]->prime_financial_setting_id;
		$exit_form_tmp_qry   = 'select count(*) as rslt_count from cw_form24q_template where fin_set_id ="'.$fin_set_id.'"';
		$exit_form_tmp_info   = $this->db->query("CALL sp_a_run ('SELECT','$exit_form_tmp_qry')");
		$exit_form_tmp_result = $exit_form_tmp_info->result();
		$exit_form_tmp_info->next_result();
		$form_count = $exit_form_tmp_result[0]->rslt_count;
		if((int)$form_count === 0){
			if(!empty($form_24q_data)){
				$i = 0;
				foreach($form_24q_data as $entry_data){
					$form24q_key      = $entry_data->name;
					$form24q_value    = $entry_data->value;
					$form24q_key_arr  = explode("_",$form24q_key);
					$prime_form16_id  = $form24q_key_arr[2];
					$form24q_mapping  = $form_24q_mapping[$i];
					if($form24q_key !== "form_24q_mapping[]"){
						$form_tmp_qry = 'insert into cw_form24q_template (fin_set_id,prime_form_sixteen_id,form24q_key,form24q_value,form24q_mapping,trans_created_by,trans_created_date) value ("'.$fin_set_id.'","'.$prime_form16_id.'","'.$form24q_key.'","'.$form24q_value.'","'.$form24q_mapping.'","'.$create_by.'","'.$created_on.'")';
						$form_tmp_info   = $this->db->query("CALL sp_a_run ('INSERT','$form_tmp_qry')");
						$form_tmp_result = $form_tmp_info->result();
						$form_tmp_info->next_result();
						$i++;
					}					
				}
				$msg = "Form 24Q template is Mapped successfully";
			}
		}else{
			$truncate_qry = 'TRUNCATE TABLE cw_form24q_template';
			$this->db->query("CALL sp_a_run ('RUN','$truncate_qry')");
			$i = 0;
			foreach($form_24q_data as $entry_data){
				$form24q_key     = $entry_data->name;
				$form24q_value   = $entry_data->value;
				$form24q_key_arr  = explode("_",$form24q_key);
				$prime_form16_id = $form24q_key_arr[2];
				$form24q_mapping  = $form_24q_mapping[$i];
				if($form24q_key !== "form_24q_mapping[]"){
					$form_tmp_qry = 'insert into cw_form24q_template(fin_set_id,prime_form_sixteen_id,form24q_key,form24q_value,form24q_mapping,trans_created_by,trans_created_date) value ("'.$fin_set_id.'","'.$prime_form16_id.'","'.$form24q_key.'","'.$form24q_value.'","'.$form24q_mapping.'","'.$create_by.'","'.$created_on.'")';
					$form_tmp_info   = $this->db->query("CALL sp_a_run ('INSERT','$form_tmp_qry')");
					$form_tmp_result = $form_tmp_info->result();
					$form_tmp_info->next_result();
					$i++;
				}
			}
			$msg = "Form 24Q template is Updated successfully";
		}
		echo json_encode(array('success' => TRUE,'msg'=>$msg));
	}
}
?>