Timesheet Form - Weekly Overview and Week Record Edit

First, in the table, we only show the weeks. To achieve this, we must modify the table query. To show value in the tables column, we set it as a default value.

NOTICE: Syntax for the table is for MySQL.

app/Filament/Resources/TimesheetResource.php:

public static function table(Table $table): Table
{
    return $table
        ->modifyQueryUsing(function (Builder $query) {
            $query->selectRaw('id, DATE_FORMAT(date, "%Y-%m-%d") as week_start')
                ->whereRaw('DAYOFWEEK(date) = 2') // Filter for Mondays only
                ->distinct()
                ->groupBy('week_start', 'date', 'id');
        })
        ->columns([
    // ...

Next we will work on:

• Table display to display one week per row
• Custom Edit page that would edit weekly records
• Real-time calculations