/** * Display a listing of the resource. * GET /destination * * @return Response */ public function index() { $destination = Destination::join('destination_pic', 'destination.ID_Destination', '=', 'destination_pic.ID_Destination')->where('destination_pic.Main_Pic', '=', 'YES')->where('destination.Status', '=', 'Active')->paginate(5, ['destination.Name', 'destination_pic.Picture', DB::raw("CONCAT(SUBSTRING(destination.Description, 1, 100), '...') as IsiDest"), 'destination.ID_Destination']); $data['about'] = About::get()->all(); return View::make('Destinations.index', compact('destination'))->with('data', $data); }