Hi-Folks/gh-actions-yaml-generator

use App\Models\Configuration;
use App\Models\LogConfiguration;
use Illuminate\Support\Facades\DB;
use Livewire\Component;
 
class Daily extends Component
{
    public $daily;
 
    public function mount(): void
    {
        $date = DB::raw('DATE(`created_at`) as `date`');
        if (config('database.default') === 'pgsql') {
            $date = DB::raw("date_trunc('day', created_at) as date");
        }
        $this->daily = LogConfiguration::select(array(
            $date,
            DB::raw('count(*) as count')
        ))
            ->groupBy('date')
            ->orderBy('date', 'DESC') // or ASC
            ->pluck('count', 'date');
    }
    //
}

// ...
 
<tbody class="bg-white divide-y divide-gray-200">
 
@foreach($daily as $date => $count)
<tr class="">
  <x-table.td>
    {{ $date }}
  </x-table.td>
  <x-table.td align="right">
    {{ $count }}
  </x-table.td>
 
</tr>
@endforeach
</tbody>
 
// ...