php - I want a notification that date is going to expire next week using laravel

i am using Task Scheduling for notification Now I am getting all notification from work permit table but I want a notification that date is going to expire next week please help me how can i do that ? thanks.

work permit table

id | name | permit_code | date

notification table

id | permit_id

app/console/commands/CreatePermitWork

class CreatePermitWork extends Command
{
  /**
   * The name and signature of the console command.
   *
   * @var string
   */
  protected $signature = 'notifications:create';

  /**
   * The console command description.
   *
   * @var string
   */
  protected $description = 'Permit work notification added !';

  /**
   * Create a new command instance.
   *
   * @return void
   */
  public function __construct()
  {
    parent::__construct();
  }

  /**
   * Execute the console command.
   *
   * @return int
   */
  public function handle()
  {
    $workpermits = WorkPermit::all();
        
    foreach ($workpermits as  $permit) {
      $ids =  array(['permit_id' => $permit->id]);
      $this->info("inserting data ".$permit->name);
      FacadesDB::table('work_permit_notifications')->insert($ids);
    }
  }
}
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.