Delete data after expired date?

Create a task that runs once a day. Just have a basic query to delete all expired sales (where expiration date <= today).

https://laravel.com/docs/5.8/scheduling

I've done with schedule. This works only when I execute command php artisan schedule:run. Is there any other solution to run this task automatically, without typing command?

Yeah, that command is supposed to be run every minute by a cron job... not run manually! See "Starting the Scheduler" section: https://laravel.com/docs/5.8/scheduling#introduction

It's not working.

Here's my code.

My Commands file (DeleteOldSales.php)

                use Illuminate\Console\Command;
                use Illuminate\Support\Facades\DB;
                use Carbon\Carbon;
                use App\Sale;


                class DeleteOldSales extends Command
              {

                 protected $signature = 'command:deleteoldsales';


                protected $description = 'Command description';

                public function __construct()
                {
                 parent::__construct();
                }

                public function handle()
               {
                 $sales = DB::table('sale_product')
                       ->join('sales', 'sales.id', '=', 'sale_product.sale_id')
                       ->where('sales.date_sale','<', Carbon::now()->subMinutes(10))->delete();
                       echo "DeleteOldSales has been send successfully";
               }
              }

My Kernel.php

                 class Kernel extends ConsoleKernel
                 {

                     protected $commands = [
                              Commands\DeleteOldSales::class
                              ];


                     protected function schedule(Schedule $schedule)
                       {
                        $schedule->command('command:deleteoldsales')
                                              ->hourly();
 
                      }
                       protected function commands()
                      {
                      $this->load(__DIR__.'/Commands');

                      require base_path('routes/console.php');
                   }

Did you set the cron job up, and are you sure it's running?

The cron job isn't something you can set via laravel. The scheduled jobs/tasks to be run are, but the cron job itself that runs every minute is set at the server level.

https://en.wikipedia.org/wiki/Cron

So, I must pay for that in https://forge.laravel.com/auth/register?

Maybe because I use win 10, I couldn't do that. Even if I did all things correctly.

Yes, you'll have to use Windows Task Scheduler in win10. I don't use windows so can't really help there, but after a quick google: https://quantizd.com/how-to-use-laravel-task-scheduler-on-windows-10/

Are you in development. If later your actual site will be on Linux, I would consider setting up a Linux development environment. Just a 2 cents.

I've solved.

The bottom line, when we are using win10 for task scheduling, we should guide to https://quantizd.com/how-to-use-laravel-task-scheduler-on-windows-10/.

But, I've had my command. So, in Add Arguments field I have to fill e.g. C:\xampp\htdocs\blogbits\artisan command:name instead, not schedule:run.

Note*** This is only when we previously create command which we later call in Kernel.php.

Otherwise, when we don't have our command. This link is appropriate.