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