<?php defined('BASEPATH') OR exit('No direct script access allowed');

class Patient_model extends CI_model {

/*
|------------------------------------------------
|   chack user exist or not
|------------------------------------------------
*/
public function exists_user($patient_phone,$birth_date)
{
    return $this->db->where('patient_phone',$patient_phone)
    ->where('birth_date',$birth_date)
    ->get('patient_tbl')
    ->num_rows();
}   

/*
|------------------------------------------------
|  save patient to patient_tbl
|------------------------------------------------
*/
public function save_patient($savedata)
{
      $this->db->insert('patient_tbl', $savedata);
}

/*
|------------------------------------------------
|  get_all_patient form patient_tbl
|------------------------------------------------
*/
 public function get_all_patient()
 {
      $query = $this->db->select('*')
      ->from("patient_tbl")
      ->get();
      $result = $query->result();
      return $result;
 }



/*
|------------------------------------------------
|  get_patient_indevidual_info form patient_tbl
|------------------------------------------------
*/
public function get_patient_inde_info($patient_id=NULL)
{
  
        return $result = $query = $this->db->select("*")
       ->from("patient_tbl")
       ->where("patient_id",$patient_id)
       ->get()->row();
        
 }

 public function get_patient_madical_info($patient_id=NULL){
        return $result = $query = $this->db->select("*")
       ->from("patient_medical_info")
       ->where("patient_id",$patient_id)
       ->get()->row(); 
 }

/*
|------------------------------------------------
|  save_edit_patient to patient_tbl
|------------------------------------------------
*/
 public function save_edit_patient($savedata,$patient_id)
 {
      $this->db->where('patient_id',$patient_id);
      $this->db->update('patient_tbl',$savedata);
 }

 public function save_edit_patient_madical_info($madical,$patient_id){
     $this->db->where('patient_id',$patient_id);
     $this->db->update('patient_medical_info',$madical);
 }
 

}     