public function getMobile($location_id = null) { $mobiles = array('') + Location::whereIn('location_type_id', array(3))->lists('code', 'id'); $donors = [''] + Donor::all()->lists('name_with_blood_group', 'id'); $products = ['']; foreach (Category::all() as $cat) { $cat_products = $cat->products->lists('name', 'id'); $products[$cat->name] = $cat_products; } $locations = [''] + Location::all()->lists('name_with_parent', 'id'); if ($location_id) { $donations = Donation::where('location_id', '=', $location_id)->orderBy('donations.created_at', 'desc')->paginate(15); } else { $donations = Donation::mobileCampaigns()->orderBy('donations.created_at', 'desc')->paginate(15); } // $donations = Donation::orderBy('created_at', 'desc') // ->paginate($this->perPage); if (Request::ajax()) { return View::make('mobiles.mdonations-table', array('donations' => $donations)); } return View::make('mobiles.mdonations', array('mobiles' => $mobiles, 'donors' => $donors, 'products' => $products, 'locations' => $locations, 'donations' => $donations, 'today' => Carbon\Carbon::now())); }