strprfcrm/app/Http/Controllers/ProductSKUController.php

<?php

namespace App\Http\Controllers;

use App\Helpers\DateHelper;
use App\Models\ProductSKU;
use Illuminate\Http\Request;
use Illuminate\Support\Str;

// Склад - Заказы МАФ
class ProductSKUController extends Controller
{
    protected array $data = [
        'active'    => 'product_sku',
        'title'     => 'Заказы МАФ',
        'id'        => 'product_sku',
        'header'    => [
            'id'                                => 'ID',

            'order-id'                          => 'ID площадки',

            'status'                            => 'Статус',
            'rfid'                              => 'RFID',
            'factory_number'                    => 'Номер фабрики',
            'manufacture_date'                  => 'Дата производства',
            'service_life'                      => 'Срок службы',
            'certificate_number'                => 'Номер сертификата',
            'certificate_date'                  => 'Дата сертификата',
            'certificate_issuer'                => 'Орган сертификации',
            'certificate_type'                  => 'Вид сертификации',

            'product-nomenclature_number'       => 'Номер номенклатуры',
            'product-article'                   => 'Артикул',
            'product-name_tz'                   => 'Наименование ТЗ',
            'product-type_tz'                   => 'Тип по ТЗ',
            'product-type'                      => 'Тип',
            'product-manufacturer_name'         => 'Наименование производителя',

        ],
        'searchFields' =>  [
            'rfid',
            'factory_number',
            'certificate_number',
            'product-nomenclature_number',
            'product-article',
        ],
    ];
    public function index(Request $request)
    {
        $model = new ProductSKU;

        $this->createFilters($model, 'status');
        $this->createDateFilters($model, 'certificate_date', 'manufacture_date');
        $this->data['ranges'] = [];

        $q = $model::query();

        $this->acceptFilters($q, $request);
        $this->acceptSearch($q, $request);
        $this->setSortAndOrderBy($model, $request);

        $q->orderBy($this->data['sortBy'], $this->data['orderBy']);

//        dump($q->toRawSql());
        $this->data['products_sku'] = $q->paginate()->withQueryString();
        return view('products_sku.index', $this->data);
    }
}