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