<?php
class client_model extends CI_Model
{

		public function regi_insert($data)
		{
			$insert=$this->db->insert('user_regi',$data); //user_regi db na table nu name jema insert karavani hoi a...
			return $insert;
		}


		public function ckeckemail($email)
		{
			$this->db->where('email_id',$email);
			$this->db->select('*');
			return $this->db->get('user_regi')->result();
		}

		public function client_login($email_id,$password)
	{
		$this->db->where('email_id',$email_id);  //user_name a db ni field name 6..and $user_name a parameter pass karavaya anu name 6...
		$this->db->where('password',$password);
		$this->db->select('*');
		$select=$this->db->get('user_regi');
		return $select->result();
	}

	public function client_detail($data2)
		{
			$insert=$this->db->insert('user_detail',$data2);
			return $insert;
		}

		public function quick_search($looking_for,$religion,$height,$marital_status)
		{
			$this->db->where('looking_for',$looking_for);  //user_name a db ni field name 6..and $user_name a parameter pass karavaya anu name 6...
			$this->db->or_where('religion',$religion);
			$this->db->or_where('marital_status',$marital_status);
			$this->db->or_where('height',$height);
			$this->db->where('looking_for',$looking_for);
			$this->db->select('*');
			$select=$this->db->get('user_detail');
			return $select->result();
		 //user_name a db ni field name 6..and $user_name a parameter pass karavaya anu name 6...
		// $this->db->where('religion',$array['religion']);
		// $this->db->where('marital_status',$array['marital_status']);
		// $this->db->select('marital_status','looking_for','');
		// $select=$this->db->get('user_detail');
		// return $select->result();

// 		$select=$this->db->select('marital_status','looking_for','religion')

//     ->from('user_detail')
//     ->group_start() //this will start grouping
//     ->where('looking_for',$looking_for)
//     ->or_where('religion',$religion)
//     ->or_where('marital_status',$marital_status)
//     ->group_end() //this will end grouping
// return $select->result();
		}

		public function friend_request($id)
		{

			// $this->db->select('*');
			$select=$this->db->query("select * from user_detail where regi_id not in (select frnd_req_from FROM friend_request where frnd_req_to=$id and frnd_req_from in(select frnd_req_to from friend_request))");
			return $select->result(); //all friend dekhai tena mate


		}

		public function send($data) //send karva mate..total frnd mathi je fnd ne send karvu 6 anu send btn...send karva
		{
			$insert=$this->db->insert('friend_request',$data); //friend_request db na table nu name jema insert karavani hoi a...
			return $insert;
		}


		public function Req($id)
		{
			$select=$this->db->query("SELECT friend_request.*, user_detail.firstname, user_detail.photo FROM friend_request INNER JOIN user_detail ON friend_request.frnd_req_to=user_detail.regi_id where frnd_req_status=0 AND frnd_req_from=$id");// req pending ma dekhai ana mate

			return $select->result();
		}


		public function Req_accept($id)
		{
			$select=$this->db->query("SELECT friend_request.*, user_detail.firstname, user_detail.photo FROM friend_request INNER JOIN user_detail ON friend_request.frnd_req_from=user_detail.regi_id where frnd_req_status=0 AND frnd_req_to=$id");// same wala ne dekhai notification dekhai ana mate k ane mane mokli 6

			return $select->result();

		}


		public function frnd($id)
		{
			$select=$this->db->query("SELECT * FROM user_detail WHERE regi_id in (SELECT frnd_req_from FROM friend_request WHERE frnd_req_status=2 AND frnd_req_to=$id) or regi_id in (SELECT frnd_req_to FROM friend_request WHERE frnd_req_status=2 AND frnd_req_from=$id)");// req accept karya pa6i je frnd bane te my frnd ma batave te....

			return $select->result();

		}


		public function accept($id,$data)
		{
			$this->db->where('frnd_req_id',$id);
			return $this->db->update("friend_request",$data);// a notification ma avi and accept kari and update thau status and aa maro frnd.. my frd ma batavse...
		}


		public function detail($id)
		{
			$this->db->where('regi_id',$id);
			return $this->db->get("user_detail")->result();
		}


		public function send_msg($data2)
		{
			$insert=$this->db->insert('message',$data2);
			return $insert;
		}


		public function readMsg($to,$id,$data)
    {
        $this->db->where('msg_from',$to);
        $this->db->where('msg_to',$id);
        $this->db->where('msg_status',0);
        return $this->db->update('message',$data);
    }


    public function display($to,$from){
      $query=$this->db->query("SELECT * FROM `message` WHERE `msg_from`=$from AND `msg_to`=$to OR `msg_to`=$from AND `msg_from`=$to");
   	#$query=$this->db->get('tbl_conv');
        $result=$query->result();
	return $result;
   }


}

?>