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; } }