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);
}
