ldc-crm/app/Jobs/StatJob.php

<?php

namespace App\Jobs;

use App\Models\Brand;
use App\Models\BrandStat;
use App\Models\CustomerInfo;
use App\Models\CustomerLogin;
use App\Models\SingleOptin;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\Middleware\WithoutOverlapping;
use Illuminate\Queue\SerializesModels;
use Illuminate\Support\Carbon;

/**
 * @codeCoverageIgnore
 */
class StatJob implements ShouldQueue
{
    use Dispatchable;
    use InteractsWithQueue;
    use Queueable;
    use SerializesModels;

    /**
     * Set high max tries as using prevent overlap
     *
     * @var integer
     */
    public $tries = 10;

    /** Used to prevent overlaping */
    private const JOBKEY = 32644296;

    /** @var \App\Models\Brand */
    private $brand;

    /**
     * Create a new job instance.
     *
     * @param Brand $brand
     * @return void
     */
    public function __construct(Brand $brand)
    {
        $this->brand = $brand;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        $stats = new BrandStat([
            'active' => CustomerLogin::whereBrandId($this->brand->id)
                ->whereDate('last_connection', '<', Carbon::now()->subMonths(6))->count(),
            'inactive' => CustomerLogin::whereBrandId($this->brand->id)
                ->whereDate('last_connection', '>', Carbon::now()->subMonths(6))->count(),
            'new_accounts' => CustomerLogin::whereBrandId($this->brand->id)
                ->whereDate('created_at', '<', Carbon::now()->subMonths(6))->count(),
            'old_accounts' => CustomerLogin::whereBrandId($this->brand->id)
                ->whereDate('created_at', '>', Carbon::now()->subMonths(6))->count(),
            'total_accounts' => CustomerLogin::whereBrandId($this->brand->id)->count(),
            'total_opt_in' => CustomerInfo::whereBrandId($this->brand->id)
                ->whereOptIn(true)->count() + SingleOptin::whereBrandId($this->brand->id)->count()
        ]);
        $stats->brand()->associate($this->brand);
        $stats->saveOrFail();
    }

    /**
     * Get the middleware the job should pass through.
     *
     * @return array
     */
    public function middleware()
    {
        // * Dispatch randomly overlaping jobs if overlapping.
        return [(new WithoutOverlapping(self::JOBKEY))->releaseAfter(rand(20, 90))];
    }
}