public function getTableQuery() {
return FeaturedProduct::query();
}
protected function getTableFilters(): array
{
return [
Tables\Filters\Filter::make('filter_sort')
->form([
Select::make('sort')
->label(__('configurator.teaser.sort'))
->reactive()
->default(3)
->helperText(__('featured.filter.sort.helptext'))
->options([
1 => __('featured.sort.price_asc'),
2 => __('featured.sort.price_desc'),
3 => __('featured.sort.default')
]),
])
->query(function (Builder $query, $data, $livewire) {
$sort = $data['sort'] ?? NULL;
switch ($sort) {
case 1:
return $query->orderBy('price_total');
break;
case 2:
return $query->orderByDesc('price_total');
break;
case 3:
return $query->orderByDesc('weight');
break;
}
return $query;
}),
];
}
public function getTableQuery() {
return FeaturedProduct::query();
}
protected function getTableFilters(): array
{
return [
Tables\Filters\Filter::make('filter_sort')
->form([
Select::make('sort')
->label(__('configurator.teaser.sort'))
->reactive()
->default(3)
->helperText(__('featured.filter.sort.helptext'))
->options([
1 => __('featured.sort.price_asc'),
2 => __('featured.sort.price_desc'),
3 => __('featured.sort.default')
]),
])
->query(function (Builder $query, $data, $livewire) {
$sort = $data['sort'] ?? NULL;
switch ($sort) {
case 1:
return $query->orderBy('price_total');
break;
case 2:
return $query->orderByDesc('price_total');
break;
case 3:
return $query->orderByDesc('weight');
break;
}
return $query;
}),
];
}