MOON
Server: Apache
System: Linux server.royaltuning.hu 4.18.0-425.13.1.el8_7.x86_64 #1 SMP Tue Feb 21 04:20:52 EST 2023 x86_64
User: royaltuning (1001)
PHP: 8.2.32
Disabled: exec,passthru,shell_exec,system
Upload Files
File: //var/www/html/Modules/Report/TaxedProductsReport.php
<?php

namespace Modules\Report;

use Modules\Tax\Entities\TaxClass;
use Illuminate\Database\Eloquent\Builder;

class TaxedProductsReport extends Report
{
    protected $filters = [];

    protected function view()
    {
        return 'report::admin.reports.taxed_products_report.index';
    }

    protected function data()
    {
        return ['taxClasses' => TaxClass::list()];
    }

    protected function query()
    {
        return TaxClass::select('id')
            ->when(request()->has('tax_class'), function (Builder $query) {
                $query->where('id', request('tax_class'));
            })
            ->withCount('products')
            ->orderByDesc('products_count');
    }
}