File "ReportSalesComparison.php"

Full Path: /home/clickysoft/public_html/jmapi5.clickysoft.net/app/Models/ReportSalesComparison.php
File size: 570 bytes
MIME-type: text/x-php
Charset: utf-8

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class ReportSalesComparison extends Model
{
    use HasFactory;
    protected $table = 'report_sales_comparison';

    public const REPORTS_MODE = [
        'previous_year' => 'previousYear',
        'current_year' => 'currentYear',
        'custom' => 'customRange',
    ];

    public function scopeCustomRange($query, $date_range): void
    {
        $query->whereBetween('date', [$date_range['year_from'], $date_range['year_to']]);
    }
}