/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $bed = Bed::findOrFail($id); $vacant = Visit::select('id')->where('bed_id', '>', $id)->exists(); if ($vacant) { $vacant = 'available'; } else { $vacant = 'occupied'; } return view('pages.beds.show', compact('bed', 'vacant')); }
private function visitorDiagramInfo(Article $article) { $chartDatas = Visit::select([DB::raw('DATE(created_at) AS date'), DB::raw('COUNT(id) AS count')])->whereBetween('created_at', [Carbon::now()->subDays(30), Carbon::now()])->where('visitable_id', $article->id)->where('visitable_type', 'App\\Article')->groupBy('date')->orderBy('date', 'ASC')->get(); $chartDataByDay = []; $chartDataByDayShamsi = []; foreach ($chartDatas as $data) { $chartDataByDay[$data->date] = $data->count; } $date = new Carbon(); for ($i = 0; $i < 30; $i++) { $dateString = $date->format('Y-m-d'); if (!isset($chartDataByDay[$dateString])) { $chartDataByDay[$dateString] = 0; } $date->subDay(); } // foreach($chartDataByDay as $date=>$value){ // $chartDataByDayShamsi[jDate::forge($date)->format('date')] = $value; // } return $chartDataByDay; }
public function getVisitsOfLastWeek() { $visits = Visit::select(DB::raw("DATE_FORMAT(created_at, '%w') as week"), DB::raw('count(*) as value'))->whereBetween('created_at', [Carbon::parse('last monday')->startOfDay(), Carbon::parse('next sunday')->endOfDay()])->groupBy(DB::raw("DAYOFWEEK((created_at))"))->get()->toArray(); //dd($visits); return Response::json($visits); }