ColumnsPresenter.php

<?php declare(strict_types = 1);

namespace App\Presenters;

use App\Model\Utils\DateTime;
use App\Model\Utils\Types;
use App\UI\TEmptyLayoutView;
use Dibi\Fluent;
use Dibi\Row;
use Ublaboo\DataGrid\AggregationFunction\IAggregationFunction;
use Ublaboo\DataGrid\AggregationFunction\IMultipleAggregationFunction;
use Ublaboo\DataGrid\Column\ColumnLink;
use Ublaboo\DataGrid\Column\ColumnStatus;
use Ublaboo\DataGrid\DataGrid;
use UnexpectedValueException;

final class ColumnsPresenter extends AbstractPresenter
{

	use TEmptyLayoutView;

	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/Columns/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;
	}

}