<?php
	$frm = "";
	if(isset($_REQUEST['frm'])){
		$frm = $_REQUEST['frm'];
		require("./bank_model.php");
		$api_model            = new bank_model;
		$controller_name      = 'bank_details';
		$form_view            = $api_model->get_page_info($controller_name);
		$form_info            = $form_view['field_info'];
	}
	if($frm === "exit_number"){
		$mobile_number      = $_POST['mobile_number'];
		$prime_table        = "cw_employees";
		$exit_qry           = 'select count(*) as rslt,cw_employees.prime_employees_id,cw_employees.employee_code,cw_employees.emp_name,cw_employees.designation,cw_employees.department,cw_employees.branch,cw_bank_details.bank_name,cw_bank_details.bank_branch,cw_bank_details.prime_bank_details_id,cw_bank_details.account_number,cw_bank_details.ifsc_code,cw_bank_details.bank_proof from cw_employees join cw_branch on cw_branch.prime_branch_id = cw_employees.branch left join cw_bank_details on cw_bank_details.employee_name = cw_employees.employee_code and cw_bank_details.trans_status = 1 where mobile_number = "'.$mobile_number.'" GROUP BY cw_employees.employee_code';
		$employee_data      = $api_model->is_employee_exit($exit_qry);
		$rslt_count         = $employee_data[0]->rslt;
		if((int)$rslt_count === 1){
			$employee_code  = $employee_data[0]->employee_code;
			$bank_info_qry  = 'select count(*) as rslt from cw_bank_details where employee_name = "'.$employee_code.'" and cw_bank_details.trans_status = "1" and cw_bank_details.hr_status = "1"';
			$bank_info_result = (int)$api_model->is_exit_bank_info($bank_info_qry);
			if($bank_info_result === 0){
				echo json_encode(array('success' => TRUE, 'message' => "Employee Exists",'emp_info'=>$employee_data[0]));
			}else{
				echo json_encode(array('success' => FALSE, 'message' => "Bank Details Already Approved"));
			}
		}else{
			echo json_encode(array('success' => FALSE, 'message' => "Mobile number does not exits"));
		}
	}else
	if($frm === "save"){
		$prime_qry_key   = "";
		$prime_qry_value = "";
		$prime_upd_query = "";
		foreach($form_view['field_info'] as $setting){
			$field_type      = $setting->field_type;
			$input_view_type = (int)$setting->input_view_type;
			$label_id        = strtolower(str_replace(" ","_",$setting->label_name));
			$field_isdefault = $setting->field_isdefault;
			$unique_field    = (int)$setting->unique_field;
			$view_name       = $setting->view_name;
			$date_type       = $setting->date_type;
			if((int)$field_type === 7){
				$multi_name = $label_id."[]";
				$value = trim(implode(",",$_POST[$multi_name]));
			}else{
				$value = str_replace("  "," ",trim($_POST[$label_id]));
			}
			if((int)$field_type === 4){
				$value = date('Y-m-d',strtotime($value));
			}
			if(($input_view_type === 1) || ($input_view_type === 2)){
				$prime_qry_key    .= $label_id.",";
				$prime_qry_value  .= '"'.$value.'",';
				$prime_upd_query  .= $label_id.' = "'.$value.'",';
			}
			if($label_id === 'employee_name'){
				$employee_name        = str_replace("  "," ",trim($_POST[$label_id]));
			}
		}
		$created_on = date("Y-m-d h:i:s");
		$logged_id  = 1;
		if($api_model->check_bank_details_exists($employee_name)){
			$prime_qry_key     .= "hr_status,trans_created_by,trans_created_date";
			$prime_qry_value   .= '"3","'.$logged_id.'",'.'"'.$created_on.'"';
			$prime_insert_query = "insert into cw_bank_details ($prime_qry_key) values ($prime_qry_value)";
			$insert_info = $api_model->get_save($prime_insert_query);			
			echo json_encode(array('success' => TRUE, 'message' => "Bank Details added Successfully", 'insert_id' => $insert_info));
		}else
		if($api_model->check_bank_details_update_exists($employee_name)){
			$prime_upd_query    .= 'hr_status = "3",trans_updated_by = "'. $logged_id .'",trans_updated_date = "'.$created_on.'"';
			$prime_update_query  = 'UPDATE cw_bank_details SET '. $prime_upd_query .' WHERE employee_name = "'. $employee_name .'"';
			$update_info = $api_model->get_update($prime_update_query);
			echo json_encode(array('success' => TRUE, 'message' => "Bank Details updated Successfully"));
		}else{
			echo json_encode(array('success' => FALSE, 'message' => "You Bank Details Already Approved"));
		}
	}else
	if($frm === "remove_file"){
		$prime_id_val  = $_POST['prime_id_val'];
		$is_defult     = (int)$_POST['is_defult'];
		$input_name     = $_POST['input_name'];
		$table_name    = 'cw_bank_details';
		if($table_name){
			$logged_id     = 1;
			$created_on    = date("Y-m-d h:i:s");
			$set_query     = $input_name .' = "" ,trans_updated_by = "'. $logged_id .'",trans_updated_date = "'.$created_on.'"';
			$update_query  = 'UPDATE '.$table_name .' SET '. $set_query .' WHERE prime_bank_details_id = "'. $prime_id_val .'"';
			$api_model->get_update($update_query);
			echo json_encode(array('success' => TRUE, 'message' => "Successfully updated"));
		}else{
			echo json_encode(array('success' => FALSE, 'message' => "Unable to process your request"));
		}
	}
?>