99 lines
3 KiB
PHP
99 lines
3 KiB
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\Database\Eloquent\Builder;
|
|
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 \App\Models\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::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $this->brand->id);
|
|
})->whereDate('last_connection', '<', Carbon::now()->subMonths(6))->count(),
|
|
'inactive' => CustomerLogin::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $this->brand->id);
|
|
})
|
|
->whereDate('last_connection', '>', Carbon::now()->subMonths(6))->count(),
|
|
'new_accounts' => CustomerLogin::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $this->brand->id);
|
|
})
|
|
->whereDate('created_at', '<', Carbon::now()->subMonths(6))->count(),
|
|
'old_accounts' => CustomerLogin::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $this->brand->id);
|
|
})
|
|
->whereDate('created_at', '>', Carbon::now()->subMonths(6))->count(),
|
|
'total_accounts' => CustomerLogin::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $this->brand->id);
|
|
})->count(),
|
|
'total_opt_in' => CustomerInfo::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $this->brand->id);
|
|
})->whereOptIn(true)->count() + SingleOptin::query()->whereHas('brand', function (Builder $q) {
|
|
$q->where('id', $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))];
|
|
}
|
|
}
|