See the code below 👇 or see GitHub
public function createComponentGrid(): DataGrid
{
$grid = new DataGrid();
$grid->setDefaultSort(['id' => 'ASC']);
$grid->setDataSource($this->dibiConnection->select('*')->from('users'));
$grid->setItemsPerPageList([20, 50, 100], true);
$grid->addColumnText('id', 'Id')
->setReplacement([
1 => 'One',
2 => 'Two',
3 => 'Trhee',
])
->setSortable();
$grid->addColumnLink('email', 'E-mail', 'this')
->setSortable();
$columnStatus = $grid->addColumnStatus('status', 'Status');
$columnStatus
->addOption('active', 'Active')
->endOption()
->addOption('inactive', 'Inactive')
->setClass('btn-warning')
->endOption()
->addOption('deleted', 'Deleted')
->setClass('btn-danger')
->endOption()
->setSortable();
$columnStatus->onChange[] = [$this, 'changeStatus'];
$grid->addColumnText('emojis', 'Emojis (template)')
->setTemplate(__DIR__ . '/Templates/grid/columnsEmojis.latte');
$grid->addColumnDateTime('birth_date', 'Birthday')
->setFormat('j. n. Y')
->setSortable();
$grid->addColumnNumber('age', 'Age')
->setRenderer(fn (Row $row): ?int => DateTime::fromSafe($row->asDateTime('birth_date'))?->diff(new DateTime())->y);
$grid->setColumnsHideable();
/*$grid->setColumnsSummary(['id'])
->setRenderer(function(int $summary, string $column): string {
return 'Summary renderer: ' . $summary . ' $';
});*/
$grid->addColumnCallback('status', function (ColumnStatus $column, Row $row): void {
if ($row['id'] === 3) {
$column->removeOption('active');
}
});
$grid->addColumnCallback('email', function (ColumnLink $column, Row $row): void {
if ($row['id'] === 3) {
$column->setRenderer(fn (): string => '');
}
});
// $grid->addAggregationFunction('status', new FunctionSum('id'));
$grid->setMultipleAggregationFunction(
new class implements IMultipleAggregationFunction
{
private int $idsSum = 0;
private float $avgAge = 0.0;
public function getFilterDataType(): string
{
return IAggregationFunction::DATA_TYPE_PAGINATED;
}
public function processDataSource(mixed $dataSource): void
{
if (!$dataSource instanceof Fluent) {
throw new UnexpectedValueException();
}
$this->idsSum = Types::forceInt($dataSource->getConnection()
->select('SUM([id])')
->from($dataSource, '_')
->fetchSingle());
$this->avgAge = round(Types::forceNumber($dataSource->getConnection()
->select('AVG(YEAR([birth_date]))')
->from($dataSource, '_')
->fetchSingle()));
}
public function renderResult(string $key): string
{
if ($key === 'id') {
return 'Ids sum: ' . $this->idsSum;
}
if ($key === 'age') {
return 'Avg Age: ' . ((int) date('Y') - $this->avgAge);
}
return '';
}
}
);
return $grid;
}