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 Yajra\DataTables\Contracts\DataTableScope;

class BranchItemsScope implements DataTableScope
{
    protected $branch;

    public function __construct($branch)
    {
        $this->branch = $branch;
    }

    public function apply($query)
    {
        $query->where(function ($showQuery) {
            $showQuery->where(function ($branchQuery) {
                $branchQuery->where('customer_branch_id', $this->branch->id)
                    ->orWhere('supplier_branch_id', $this->branch->id);
            })->orWhere(function ($customerQuery) {
                $customerQuery->whereNull('customer_branch_id')
                    ->where('customer_company_id', $this->branch->parent_id);
            })->orWhere(function ($supplierQuery) {
                $supplierQuery->whereNull('supplier_branch_id')
                    ->where('supplier_company_id', $this->branch->parent_id);
            });
        });
    }
}