public function index(Request $request)
{
if ($request->get('startDate') && $request->get('endDate')) {
$start = $request->get('startDate');
$end = $request->get('endDate');
$visitor = Visitor::select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as total'))->whereBetween(DB::raw('DATE(created_at)'), [$start, $end])->groupby(DB::raw('DATE(created_at)'))->get();
} else {
$visitor = Visitor::select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as total'))->where("created_at", "like", $this->year . "%")->groupby(DB::raw('DATE(created_at)'))->get();
}
//dd(date('Y-m-d', strtotime($user->created_at)));
return view('admin.dashboard.index', compact(['visitor', 'count_visitor']));
}
public function show()
{
$chartDatas = Visitor::select([DB::raw('DATE(created_at) AS date'), DB::raw('COUNT(id) AS count')])->whereBetween('created_at', [Carbon::now()->subDays(30), Carbon::now()])->groupBy('date')->orderBy('date', 'ASC')->get()->toArray();
return view('admin.visitors.show', compact('chartDatas'))->with(['title' => 'visitors Diagram']);
}
