<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Manual_shift_update  extends Action_controller{	
	public function __construct(){
		parent::__construct('manual_shift_update');
	}
	
	public function index(){
		//Employee code picklist conditions
		$employee_info_query = 'SELECT employee_code,emp_name FROM `cw_employees` where trans_status = 1 and termination_status = 0 and prime_employees_id != 1';
		$employee_info   = $this->db->query("CALL sp_a_run ('SELECT','$employee_info_query')");
		$employee_result = $employee_info->result();
		$employee_info->next_result();
		$employee_list[""] = "---- Select Employee ----";
		foreach($employee_result as $for){
			$emp_code    = $for->employee_code;
			$emp_name    = $for->emp_name;
			$employee_list[$emp_code] = $emp_code." - ".$emp_name;
		}
		$data['employee_list'] = $employee_list;
		//Get Category
		$category_query = 'SELECT prime_category_id,category_name FROM `cw_category` where trans_status = 1';
		$category_info   = $this->db->query("CALL sp_a_run ('SELECT','$category_query')");
		$category_result = $category_info->result();
		$category_info->next_result();
		$category_list[""] = "---- Select Category ----";
		foreach($category_result as $for){
			$category_id = $for->prime_category_id;
			$category    = $for->category_name;
			$category_list[$category_id] = $category;
		}
		$data['category_list'] = $category_list;
		$data['key']     = $this->generateKey();
		$this->load->view("$this->control_name/manage",$data);
	}

    public function get_manual_shift_data(){
		$encString                 = file_get_contents('php://input');
		$_POST                     = $this->cryptoDecrypt($encString);
		if(!$_POST){
			echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
			exit(0);
		}
   	    $post_url                   = base_url()."app/api_controller.php";
    	$post_data['frm']           = "update_defaults";
		$post_data['process_month'] = $this->input->post("process_month");
		$post_data['employee_code'] = implode('","',(array_filter($this->input->post("employee_code"))));
		$post_data['category']      = implode('","',(array_filter($this->input->post("category"))));
		$post_data['select_type']	= $this->input->post("select_type");
		echo $this->curl($post_url,$post_data);
    }	

    public function get_created_data(){
    	//Get Existing Shifts
		$n_shift_import_exist_qry  = 'select tbl_shift_imp_temp.employee_code,tbl_shift_imp_temp.shift_date,cw_employees.emp_name,IF(tbl_shift_imp_temp.type = "weekoff",type,"Shift") as type from tbl_shift_imp_temp inner join cw_employees on cw_employees.employee_code = tbl_shift_imp_temp.employee_code';
		$n_shift_info   = $this->db->query("CALL sp_a_run ('SELECT','$n_shift_import_exist_qry')");
		$n_shift_result = $n_shift_info->result_array();
		$n_shift_info->next_result();
		$drop_qry  = 'TRUNCATE TABLE tbl_shift_imp_temp';
		$drop_info = $this->db->query("CALL sp_a_run ('RUN','$drop_qry')");
		echo json_encode(array('success'=>true,'shift_data'=>$n_shift_result));
    }
    public function get_weekoff_exist_data(){
		$encString      = file_get_contents('php://input');
		$_POST          = $this->cryptoDecrypt($encString);
		if(!$_POST){
			echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
			exit(0);
		}
    	$select_type	= $this->input->post("select_type");
    	$process_month	= $this->input->post("process_month");
    	$process_mode	= $this->input->post("process_mode");
    	$employee_code  = implode('","',array_filter($this->input->post("employee_code")));
    	$select_emp = "";
    	if((int)$select_type === 2 && (int)$process_mode === 1){
    		$select_emp = ' and cw_weekoff_import.employee_code in("'.$employee_code.'")';
    	}
		$wk_exist_qry  = 'select cw_weekoff_import.employee_code,cw_employees.emp_name as employee_name,"weekoff" as weekoff_type,weekoff_date from cw_weekoff_import inner join cw_employees on cw_employees.employee_code = cw_weekoff_import.employee_code where cw_weekoff_import.trans_status = 1 and date_format(str_to_date(weekoff_date, "%Y-%m-%d") , "%m-%Y") = "'.$process_month.'" '.$select_emp.'';
		$wk_exist_info = $this->db->query("CALL sp_a_run ('SELECT','$wk_exist_qry')");
		$wk_exist_rslt = $wk_exist_info->result_array();
		$wk_exist_info->next_result();
		echo json_encode(array('success'=>true,'wk_exist_data'=>$wk_exist_rslt));
    	// }
    }

}
?>