<?php
include('../app/dbconnect.php');
error_reporting(0);
class bank_model extends dbconnect{
	
	public function __construct() {
		$this->open_db();
    }
	
	public function real_escape_string($value){
		$value = mysql_real_escape_string($value);
		if(empty($value)){
			$value = 0;
		}
		return $value;
	}
	
	public function get_page_info($controller_name){
		$this->control_name = $controller_name;
		$field_name_query = 'select * from cw_form_setting where cw_form_setting.prime_module_id = "'.$controller_name.'" and label_name != "hr_status" ORDER BY cw_form_setting.field_sort asc';
		$field_info = $this->runQuery("$field_name_query");
		$field_info = $this->result($field_info);
		$page_info['field_info'] = $field_info;
		$view_info  = $this->view_info($controller_name);
		$page_info['view_info']  = $view_info;
		$all_pick = $this->get_picklist_value($page_info);
		$page_info['all_pick'] = $all_pick;
		return $page_info;
	}
	
	public function view_info($controller_name){
		$view_info_query = 'select * from cw_form_view_setting where cw_form_view_setting.prime_view_module_id = "'.$controller_name.'" ORDER BY form_view_sort asc';
		$view_info_data = $this->runQuery("$view_info_query");
		$view_info_result = $this->result($view_info_data);
		return $view_info_result;
	}
	
	public function get_picklist_value($page_info){
		foreach($page_info['field_info'] as $setting){
			$prime_form_id      = (int)$setting->prime_form_id;
			$prime_module_id    = $setting->prime_module_id;
			$input_view_type    = (int)$setting->input_view_type;
			$input_for          = (int)$setting->input_for;
			$field_type         = (int)$setting->field_type;
			$label_id           = $setting->label_name;
			$label_name         = ucwords($setting->view_name);
			$field_length       = $setting->field_length;
			$field_decimals     = $setting->field_decimals;
			$pick_list_type     = (int)$setting->pick_list_type;
			$pick_list          = $setting->pick_list;
			$pick_table         = $setting->pick_table;
			$auto_prime_id      = $setting->auto_prime_id;
			$auto_dispaly_value = $setting->auto_dispaly_value;
			$field_isdefault    = (int)$setting->field_isdefault;
			$file_type          = (int)$setting->file_type;
			$mandatory_field    = (int)$setting->mandatory_field;
			$unique_field       = (int)$setting->unique_field;
			$search_show        = (int)$setting->search_show;
			$array_list = array();
			$pick_sel_table = "cw_".$prime_module_id;
			if(($field_type === 5) || ($field_type === 7)){
				if($pick_list_type === 1){
					$pick_list_val   = explode(",",$pick_list);
					$pick_list_val_1 = $pick_list_val[0];
					$pick_list_val_2 = $pick_list_val[1];
					if($pick_table == "cw_category"){
						$qry = " and prime_category_id != 1";
					}else{
						$qry = "";
					}
					$pick_query = "select $pick_list from $pick_table where trans_status = 1 $qry";
					$pick_data   = $this->runQuery("$pick_query");
					$pick_result = $this->result($pick_data);
					$array_list = array();
					foreach($pick_result as $pick){
						$pick_key = $pick->$pick_list_val_1;
						$pick_val = $pick->$pick_list_val_2;
						$array_list[$pick_key] = $pick_val;
					}
					$all_pick[$prime_form_id] = $array_list;
				}else
				if($pick_list_type === 2){ 
					$pick_list_val_1 = $pick_table."_id";
					$pick_list_val_2 = $pick_table."_value";
					$pick_list_val_3 = $pick_table."_status";
					$pick_query = "select $pick_list_val_1,$pick_list_val_2 from $pick_table where $pick_list_val_3 = 1";
					$pick_data   = $this->runQuery("$pick_query");
					$pick_result = $this->result($pick_data);
					$array_list  = array();
					foreach($pick_result as $pick){
						$pick_key = $pick->$pick_list_val_1;
						$pick_val = $pick->$pick_list_val_2;
						$array_list[$pick_key] = $pick_val;
					}
					$all_pick[$prime_form_id] = $array_list;
				}
			}
		}
		return $all_pick;
	}
	
	//rowset form details
	public function rowset_view($controller_name){
		$rowset_view_qry    = 'select * from cw_form_setting where cw_form_setting.prime_module_id="'.$controller_name.'"';
		$rowset_view_data   = $this->runQuery("$rowset_view_qry");
		$rowset_view_result = $this->result($rowset_view_data);
		$row_view_list = array();
		$prime_id  = 0;
		foreach($rowset_view_result as $view){
			$prime_form_view_id   = $view->input_for;
			$row_set_data = $this->get_row_set_data($prime_form_view_id,$controller_name,$prime_id);
			$row_view_list[$prime_form_view_id] = $row_set_data;
		}
		return $row_view_list;
	}
	
	//CHECK BANK DETAILS ALREADY EXISTS
	public function check_bank_details_exists($employee_id){
		$check_qry    = 'select count(*) as rslt_count from cw_bank_details where cw_bank_details.employee_name = "'.$employee_id.'"';
		$check_data   = $this->runQuery("$check_qry");
		$check_data   = $this->result($check_data);
		$rslt_count   = (int)$check_data[0]->rslt_count;
		if($rslt_count === 0){
			return true;
		}else{
			return false;
		}
	}
	
	//CHECK BANK DETAILS CAN UPDATE
	public function check_bank_details_update_exists($employee_id){
		$check_qry    = 'select count(*) as rslt_count from cw_bank_details where cw_bank_details.employee_name = "'.$employee_id.'" and hr_status != "1"';
		$check_data   = $this->runQuery("$check_qry");
		$check_data   = $this->result($check_data);
		$rslt_count   = (int)$check_data[0]->rslt_count;
		if($rslt_count === 1){
			return true;
		}else{
			return false;
		}
	}
	
	//save function main form
	public function get_save($prime_insert_query){
		$insert_info   = $this->runQuery_insert_id("$prime_insert_query");
		return $insert_info;
	}
	
	//update function main form
	public function get_update($prime_update_query){
		$update_info   = $this->runQuery("$prime_update_query");
		return $update_info;
	}
	
	//Already Exit or not count 
	public function is_exit_data($exit_qry){
		$exit_info       = $this->runQuery("$exit_qry");
		$exit_result     = $this->result($exit_info);
		$exit_count      = $exit_result[0]->rslt;
		$user_status     = $exit_result[0]->trans_status;
		$manager_status  = $exit_result[0]->manager_status;
		$hr_status       = $exit_result[0]->hr_status;
		$exit_rslt = array('exit_count'=>$exit_count,'user_status'=>$user_status,'manager_status'=>$manager_status,'hr_status'=>$hr_status);
		return $exit_rslt;
	}
	
	//Already exit or not count bank details master
	public function is_exit_bank_info($exit_bank_qry){
		$exit_bank_info     = $this->runQuery("$exit_bank_qry");
		$exit_bank_result   = $this->result($exit_bank_info);
		$exit_bank_count    = $exit_bank_result[0]->rslt;
		return $exit_bank_count;
	}
	
	//Already Exit or not count 
	public function is_employee_exit($exit_qry){
		$exit_offer_info   = $this->runQuery("$exit_qry");
		$exit_offer_result = $this->result($exit_offer_info);
		return $exit_offer_result;
	}
}
?>