public function index() { // init $data = array(); // set offset & limit $limit = 8; $page = Input::has('page') ? Input::get('page') : 1; $offset = ($page - 1) * $limit; // get all categories $data['categories'] = EventCategory::where('status', '=', 1)->get(); // get all cities $data['cities'] = City::where('status', '=', 1)->orderBy('name', 'asc')->get(); // get input $input = Input::all(); // get social actions $events = Events::with(array('city', 'category'))->where('status', '!=', 0); if (Input::has('q')) { // keyword $input['q'] = trim($input['q']); $events = $events->where('name', 'like', '%' . $input['q'] . '%'); } if (Input::has('category') and Input::get('category') != 'all') { // category $events = $events->where('event_category_id', '=', $input['category']); } if (Input::has('city') and Input::get('city') != 'all') { // city $events = $events->where('city_id', '=', $input['city']); } $data['events'] = $events->orderBy('ended_at', 'desc')->paginate($limit); // set input $data['input'] = $input; return View::make('bagikasih.event.index', $data); }
public static function getbyStatus() { $check = EventCategory::where('status', 1)->count(); if ($check < 1) { return false; } else { return EventCategory::where('status', 1)->get(); } }