<?php 
class Customer_model extends CI_Model {
	public function _consruct(){
		parent::_construct();
 	}
	 // function get_customer(){
	 // 	$query = $this->db->where('status',1); 
		//  $query = $this->db->get('users');
		//  $result = $query->result();
		//  return $result;
  //    }

      function get_customer(){
	 	 $this->db->where('users.status',1); 
	 	 $this->db->select('users.*,verification.status as verifiedstatus,verification.id as verified_id');
		 $this->db->from('verification');
         $this->db->join('users','verification.user_id=users.id','left');
         $query= $this->db->get();
         return $query->result();
     }

     function get_single_customer($id) {
		$query = $this->db->where('id', $id);
		$query = $this->db->get('users');
		$result = $query->row();
		return $result;
	                     }	




     function update_customer($data, $id) {
		
	 $this->db->where('id', $id);
	 $result = $this->db->update('users', $data); 
	 
	 if($result) {
		 return "Success";
	 }
	 else {
		 return "Error";
	 }
	}




     function view_popup_customer($id){
		
		$query = $this->db->where('id', $id);
		$query = $this->db->get('users');

		$result = $query->row();

		return $result;	    
     }




	 public function customer_delete($id){ 
		 $this->db->where('id',$id);
		 $data = array('status'=>2);
		 $result = $this->db->update('users',$data);

		 if($result) {
			return "success"; 
		 }
		 else {
			 return "error";
		 }
	 }

	/* function goverment_id_upload($data){
	 	 $data);die;
	 	$data['type']=1;
	 	$data['staus']=1;
	 	$this->db->where('user_id',$data['user_id']);
	 	$query=$this->db->get('verification')->row();
	 	if($query){
	 	   $this->db->where('user_id',$data['user_id'])
	 	   $result = $this->db->update('verification',$data);	
	 	}else{
	 	   $result = $this->db->insert('verification',$data);
	 	}

	 }*/
	  function goverment_id_upload($data){
	 	$data['type']=1;
	 	$data['status']=1;
	 	$this->db->where('user_id',$data['user_id']);
	 	$result = $this->db->update('verification',$data);
	 	return $result;	
	 	
	 }

}
?>