public function listDay($day, $room, $page)
{
$pagelen = 20;
$day = Carbon::parse($day)->format('Y-m-d');
$startDate = date("Y-m-d H:i:s", strtotime($day));
$stopDate = date("Y-m-d H:i:s", strtotime($day . " 23:59:59"));
$total_row = Logs::select(DB::raw('COUNT(*) as count'))->where('room_id', '=', $room)->whereBetween('access', array($startDate, $stopDate))->get();
$total_page = ceil((int) $total_row[0]->count / $pagelen);
$start = ($page - 1) * $pagelen;
$shows = Logs::with(array("card", "room"))->where('room_id', '=', $room)->whereBetween('access', array($startDate, $stopDate))->orderBy('access')->skip($start)->take($pagelen)->get();
$status = true;
return compact("shows", "day", "total_page", "status");
}
