当Products表中的user_id(外键)与USERS表中的id(主键)相同时,我想显示我的Products数据,我使用laravel livewire datatable
如何使用此功能
public function query(): Builder
{
$user_id = auth()->user()->id;
return Product::query()->where('user_id', $user_id);
}
在此函数中
public function columns(): array
{
return [
Column::make("Nama", "name")
->sortable()
->searchable(),
Column::make("Deskripsi", "description")
->sortable()
->searchable(),
Column::make("Stok", "stock")
->sortable()
->format(
fn($value, $row, Column $column) => $row->stock === 9999 ? '<span class="badge bg-label-success">INSTOCK</span>' : number_format($row->stock, 0, ',', '.')
)->html(),
];
}