Beispiel #1
0
 public function selectcategories()
 {
     $json = Input::get('data.cat_id');
     $sub_cat = Input::get('data.sub_cat');
     $country_id = Input::get('data.country_id');
     $sub_cat_search = array();
     if (isset($sub_cat)) {
         $sub_cat_search['sub_cat'] = $sub_cat;
     }
     if (empty($json) || is_null($json)) {
         $categories = categories::where($sub_cat_search)->where('country_id', '=', $country_id)->orderby('name', 'ASC')->get(array('cat_id', 'name'));
         return $categories;
     } else {
         $values = explode(',', $json);
         $categories = categories::whereIn('cat_id', $values)->where($sub_cat_search)->where('country_id', '=', $country_id)->orderby('name', 'ASC')->get(array('cat_id', 'name'));
         return $categories;
     }
 }