Breaking News: Grepper is joining You.com. Read the official announcement!

Automatically update all row's status column when time has exceeded from stored time Laravel (Task Scheduling)

Tough Tapir answered on February 24, 2023 Popularity 1/10 Helpfulness 1/10

answer Automatically update all row's status column when time has exceeded from stored time Laravel (Task Scheduling)

Automatically update all row's status column when time has exceeded from stored time Laravel (Task Scheduling)

Comment

To build on the above answers into something more comprehensive :

Make sure cron is executing Laravel's scheduler every minute :

php8.0 /home/yourdomain.com/artisan schedule:run
Make a new Laravel command to execute the relevant logic :

php artisan create:command CloseJobs
Write the necessary code in that class - in this case, retrieve all the relevant open jobs which need to be closed and close them, which we can do through mass assignment in one easy line (make sure your 'status' is added to the $fillable array on your model) :

protected $signature = 'close:jobs';

....

$jobs = Job::where('status', 'open')->where('close_at', '<', now())->update(['status' => 'closed']);
Tell Laravel to execute that task every minute, in App\Console\Kernel.php :

$schedule->command('close:jobs')->everyMinute();

Popularity 1/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: laravel php status time update-all when

Link to this answer
Share Copy Link