Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/medad.corals.io/Corals/modules/Medad/DataTables/Scopes/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\Modules\Medad\DataTables\Scopes;

use Corals\Modules\Medad\Facades\Medad;
use Corals\Modules\Medad\Models\QuotationRequest;
use Illuminate\Database\Eloquent\Builder;

class CompanyListingScope
{
    public function apply(Builder $query, $params)
    {
        if (user()->can('Administrations::admin.medad')) {
            return;
        }

        $userCompany = Medad::getUserCompany();

        if (!$userCompany) {
            abort(403);
        }

        if ($query->getModel() instanceof QuotationRequest) {
            $query->where(function ($queryBy) use ($userCompany) {
                $queryBy->where('customer_company_id', $userCompany->id)
                    ->orWhereHas('suppliers', function ($suppliersQB) use ($userCompany) {
                        $suppliersQB->where('medad_quotation_request_suppliers.company_id', $userCompany->id);
                    });
            });
        } else {
            $query->where('customer_company_id', $userCompany->id)->orWhere('supplier_company_id', $userCompany->id);
        }
    }
}