[eluser]hrg.vincent[/eluser]
//View
Code:
<input type="input" id="tcs_fname" name="tcs_fname" />
<input type="input" id="tcs_passport" name="tcs_passport" />
//Controller
Code:
public function getVisaStatus()
{
$this->load->helper('form');
$data = array(
'family_name' => $this->input->post("tcs_fname"),
'passport_no' => $this->input->post("tcs_passport")
);
$this->load->model('Data_m');
$data['visa_status'] = $this->Data_m->getVisaStatus($data);
$this->load->view('ajax/home', $data);
}
//Model
Code:
function getVisaStatus($data)
{
$this->db->select('(CASE WHEN (AP.status = "AP") THEN "Approved" WHEN (AP.status = "RJ") THEN "Rejected" ELSE "Pending" END) as visa_status, VE.embassy_name');
$this->db->from(VISA_APPLICATION. ' as AP');
$this->db->join(EMBASSY_TABLE. ' as VE', 'VE.embassy_id = AP.embassy', 'left');
$this->db->where('AP.status !=', 'CC');
$this->db->like('passport_no', $data["passport_no"]);
$this->db->like('family_name', $data["family_name"]);
$result = $this->db->get();
$return = array();
if($result->num_rows() > 0) {
return $result->result_array();
}
}
Anyone can help on how to pass data from View to Model as I need to get the where condition, data is from view input text.