public function getNonMappedRegimens($param = '0') { $data = array(); $query = $this->db->query("SELECT s.id,s.code,s.name,sr.Name as category_name,s.category_id\n FROM sync_regimen s \n LEFT JOIN sync_regimen_category sr ON sr.id = s.category_id\n WHERE s.id NOT IN(SELECT r.map\n FROM regimen r\n WHERE r.map !='0')\n OR s.name LIKE '%other%'\n ORDER BY s.category_id,s.code asc"); $data['sync_regimen'] = $query->result_array(); if ($param == 1) { echo json_encode($data['sync_regimen']); die; } $data['non_mapped_regimen'] = Regimen::getNonMappedRegimens(); //Not mapped regimens echo json_encode($data); }