php - Laravel Livewire 组件偏移

我试图通过在 Livewire 组件内部调用的 Laravel Controller 获取一些技术人员数据。在某些情况下， Controller 返回 null 因为没有相关的技术人员。

这是我的 livewire 组件渲染 View :

class TechniciansAssociated extends Component
{
    public function render()
    {
        $technicians = (new HomeController())->getTechnicians();

        return view('livewire.dashboard.technicians-associated', [
            'technicians' => $technicians,
        ]);
    }
}

这里从家庭 Controller 调用的函数:

public function getTechnicians()
{
    $customer_ids = json_decode(User::find(Auth::id())->userCustomers->customer_id,true);

    $technicians_data = DB::connection('mysql')
        -> select('SELECT distinct users.id, users.name, users.surname, users.lastname, users.email, users.cargo, users.photo
           FROM users
           INNER JOIN contractsproductsmulti AS cpm ON users.id = cpm.userId
           INNER JOIN contractsproducts AS cp ON cp.id = cpm.contractproduct_id
           INNER JOIN contracts AS cont ON cont.id = cp.idcontract
           WHERE users.isActive = 1 AND cont.idCustomer IN (?)', $customer_ids
        );

    if (count($technicians_data) > 0){
        return $technicians_data;
    }

    return null;
}

最后，当试图获取渲染 livewire View 的主 View 时，我遇到了错误

@section('content')

<section id="dash-cust-info">
    <div class="row p-t-30 p-b-30">
        <div class="col-md-6">
            <h4>Customer info</h4>
        </div>
        <div class="col-md-3">
            <h4>Comm_1</h4>
            <div class="card no-border no-margin">
                @livewire('dashboard.commercials-associated')
            </div>
        </div>
        <div class="col-md-3">
            <h4>Comm_2</h4>
            <div class="card no-border no-margin">
                @livewire('dashboard.technicians-associated')
            </div>
        </div>
    </div>
....

错误:

Undefined offset: 1 (View: /......../resources/views/home.blade.php)

最佳答案

我猜 this answer 为 livewire 中的此类问题提供了很好的解释。把它留在这里，以便将来遇到此类问题的任何人都可以获得帮助。不客气

关于php - Laravel Livewire 组件偏移，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/60522871/