<?php

namespace App\Http\Controllers;

use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class AnalyticsLogsController
{
    public function index(Request $request)
    {
        $query = DB::connection('analytics')->table('logs')->orderBy('id', 'DESC');
        if ($request->has('created_at')){
            $date = Carbon::parse($request->created_at)->toDateString();
            $query->whereRaw("DATE(`created_at`) = '{$date}'");
        }

        return $query->paginate(50);
    }
}