Esempio n. 1
0
 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);
 }