© 2026 Hedgehog Software, LLC
public function table(Table $table): Table { return $table ->query($this->getTableQuery()) ->columns([ TableComponents::itemNameColumn()->searchable(), // other columns ]) ->actions([ TableActions::batchOutAction(), Action::make('test')->action(fn(Model $record) => dd($record)), ]); } public function getTableQuery() { return TableQueries::outgoingQuery(); }
TableQueries::outgoingQuery()
public static function outgoingQuery() { return Transaction::query() ->selectRaw('min(id) as id, item_id, category_id, subcategory_id, exp_date, batch, donor_id, project_id, SUM(amount) as amount, warehouse_id') ->groupBy('item_id', 'category_id', 'subcategory_id', 'exp_date', 'batch', 'donor_id', 'project_id', 'warehouse_id') ->havingRaw('SUM(amount) > 0'); }