public function storeVideo(ShameRequest $request) { $reg = $this->parseReg($request->input('reg')); $numberPlate = NumberPlate::firstOrCreate(['reg' => $reg]); $shame = new Shame(); $shame->number_plate_id = $numberPlate->id; $shame->link = 'https://www.youtube.com/embed/' . $request->input('video_id'); $shame->reason_id = $request->input('reason'); $shame->taken_at = empty($request->input('taken_at_date')) ? null : $request->input('taken_at_date'); $shame->save(); return redirect('/plate/' . $reg); }
/** * Show homepage view * * @return \Illuminate\View\View */ public function index() { $worst = Shame::orderBy(DB::raw('COUNT("id")'), 'DESC')->groupBy('number_plate_id')->take(3)->lists('number_plate_id')->toArray(); $plates = NumberPlate::whereIn('id', $worst)->lists('reg')->toArray(); return view('home')->withPlates($plates); }