EVOLUTION-NINJA
Edit File: 1504533537feeds.txt
------------------------------------------------------------replace controller function--------------------------------------------------------------- //lead_feeds view public function lead_feeds() { $admin_id = $this->session->userdata('admin_id'); if($admin_id) { $result['udata']=$this->yaskawa_model->get_all_users(); // $result['send_data']=$this->yaskawa_model->feed_sender($admin_id); $result['receive_data']=$this->yaskawa_model->feed_receiver($admin_id); $this->load->view('admin/lead_feeds',$result); } else { redirect('/'); } } public function feeds_data_filter(){ $feeds_date=$this->input->post('feeds_filter'); $result=$this->yaskawa_model->feeds_filter($feeds_date); if($result) { echo json_encode(array('date_result'=>$result,'result'=>1)); } } ---------------------------------------------------------------replace model function----------------------------------------------------------- public function feeds_filter($feeds_date){ $this->db->select('*'); $this->db->from('feeds'); $this->db->join('users','feeds.receiver_id=users.user_id'); $this->db->join('leads','leads.lead_id=feeds.receiver_id'); $this->db->join('lead_profile_pic',' lead_profile_pic.lead_id=leads.lead_id'); $this->db->order_by('date','DESC'); $this->db->where('date',$feeds_date); $query=$this->db->get(); return $query->result(); } public function feed_receiver($admin_id){ $this->db->select('*'); $this->db->from('feeds'); $this->db->join('users','feeds.receiver_id=users.user_id'); $this->db->join('leads','leads.lead_id=feeds.receiver_id'); $this->db->join('lead_profile_pic',' lead_profile_pic.lead_id=leads.lead_id'); $this->db->order_by('send_date_time','DESC'); $this->db->where('receiver_id',$admin_id); $ijoin=$this->db->get(); return $ijoin->result(); }