/** * Show the application dashboard. * * @return Response */ public function index() { $event = DB::table('eventos')->select(DB::raw('id, fecha, lugar'))->where('fecha', '>', Carbon::now())->orderBy('fecha', 'ASC')->limit(4)->get(); $clientes = Cliente::select('id')->count(); $eventos = Evento::select('id')->count(); $filmadores = Filmador::select('id')->count(); return view('home', compact('event', 'clientes', 'eventos', 'filmadores')); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { return Cliente::select('*')->where("cedula", $id)->first(); }