Level 73
Can't you just mutate it to a date in your model and then cast it to a number when retrieving it?
https://laravel.com/docs/11.x/eloquent-mutators#defining-a-mutator
Aug 10, 2024
3
Level 6
How to used toggleColumn to a timestamp data type?
I tried to used toggleColumn to block a user in the table lis, The problem is the blocked_at is timestamp.. I used hook beforeStateUpdated for now and was able to store data in the database but got some problem when I click the toggle.
I got this error
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '1' for column 'blocked_at' at row 1 (Connection: mysql, SQL: update `users` set `blocked_at` = 1, `users`.`updated_at` = 2024-08-10 07:30:10 where `id` = 4)
This is my code
Tables\Columns\ToggleColumn::make('blocked_at')
->label('Block')
->onColor('success')
->offColor('danger')
->getStateUsing(fn ($record) => !is_null($record->blocked_at))
->beforeStateUpdated(function (bool $state, $record) {
$record->blocked_at = $state ? now() : null;
$record->blocked_by = $state ? auth()->id() : null;
$record->save();
}),
Level 6
@Tray2 Toggle Column in filament is dedicated for boolean only... so I just make action instead.
Tables\Actions\Action::make('block')
->label(fn ($record) => $record->blocked_at ? 'Unblock' : 'Block')
->action(function ($record) {
$record->blocked_at = $record->blocked_at ? null : now();
$record->blocked_by = $record->blocked_at ? auth()->id() : null;
$record->save();
})
->color(fn ($record) => $record->blocked_at ? 'danger' : 'warning')
->requiresConfirmation()
->icon(fn ($record) => $record->blocked_at ? 'heroicon-o-lock-open' : 'heroicon-o-lock-closed'),
Level 73
@anonymouse703 As good a solution as any.
Please or to participate in this conversation.