One Hat Cyber Team

Your IP: 216.73.216.142
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder

Dir : ~/www/wwwroot/gsm.com.ng/app/Console/Commands/

View File Name : PlanExpiryCron.php

<?php

namespace App\Console\Commands;

use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Mail;

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

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Command description';

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

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        // Dates
        $currentDate = Carbon::now();
        $expiryDate = Carbon::now()->addDays(7);

        // Get expiry customers
        $users = DB::table('users')->where('status', 1)->whereBetween('plan_validity', [$currentDate, $expiryDate])->get();

        // Check customers
        if ($users != null) {
            for ($i = 0; $i < count($users); $i++) {

                // Email message
                $details = [
                    'name' => $users[$i]->name,
                    'email' => $users[$i]->email,
                ];

                // Send email
                $mail = false;
                try {
                    Mail::to($users[$i]->email)->send(new \App\Mail\ExpiryPlanMail($details));
                    $mail = true;
                } catch (\Exception $e) {
                }

                $this->info('Email sent to All Users');
            }
        }
    }
}