Dynamos data with filters

[daniieljc]

Hi, I have a view in the header of the table where I do some calculations, I want to know if it is possible to get the value of the filters to also change the header data.

The totals function is where I want to obtain the value of the filters.

public function setUp(): array
    {
        return [
            PowerGrid::header()->includeViewOnTop('components.sms-totals')->showToggleColumns(),
            PowerGrid::footer()
                ->showPerPage(25)
                ->showRecordCount(),
        ];
    }

protected function totals(): array
    {
        $totals = $this->datasource()
            ->select('currency')
            ->selectRaw('SUM(payout) as total_payout')
            ->selectRaw('SUM(revenue) as total_revenue')
            ->groupBy('currency')
            ->get();

        return $totals->mapWithKeys(function ($result) {
            return [$result->currency => [
                'payout' => number_format($result->total_payout, 3, '.', ''),
                'revenue' => number_format($result->total_revenue, 3, '.', ''),
                'profit' => number_format($result->total_revenue - $result->total_payout, 3, '.', '')
            ]];
        })->toArray();
    }

[eafarooqi]

You can add a public property to your component and assign your results to it in the totals function. Should be available in the view.