Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class SetStatus extends Command
- {
- protected $signature = 'SetStatus:cron';
- public function handle()
- {
- //o código ta uma zona apenas pra teste...
- $sql = 'select id from promotions where dt_end < NOW()';
- $dados = DB::select($sql);
- foreach($dados as $i)
- {
- $updateStatus = 'update promotions set status = "inativo" where id IN ('.$i->id.')';
- $return = DB::update($updateStatus);
- }
- var_dump($return);
- }
- protected $commands = [
- CommandsSetStatus::class,
- ];
- protected function schedule(Schedule $schedule)
- {
- $schedule->command('SetStatus:cron')->everyMinute();
- }
- php artisan SetStatus:cron
- php c:/projetos/marcelo/painel/artisan schedule:run
- # crontab -e 00 * * * * /usr/local/bin/php /home/pedrodelfino/meu-script.php
- * * * * * php /path-to-your-project/artisan schedule:run >> /dev/null 2>&1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement