Nextras\Datagrid – datagrid se vsim jak ma byt

{extends none}

{define global-actions}
<a href="{plink print}" target="_blank">Tisk</a>
{/define}

function handlePrint() {
	$this->presenter->setView('print');
    }

/** @persistent */
    public $pag = 10;

public function createComponentUsers() {

	$grid = new \Nextras\Datagrid\Datagrid;
	.....
	$grid->setPagination($this->pag, $this->getDataSourceSum);
	...
}

public function handlePag($show) {

	$this->pag = $show;
	$this->invalidateControl('grid');
}

<br />
Zobrazit:
<a href="{plink pag!, 'show' => 1}" class="ajax">1</a>
<a href="{plink pag!, 'show' => 5}" class="ajax">5</a>
<a href="{plink pag!, 'show' => 10}" class="ajax">10</a>
na stránku.

$grid->setDatasourceCallback(function($filter, $order) {
    $filters = array();
    foreach ($filter as $k => $v) {
        if ($k == 'id' || is_array($v))
            $filters[$k] = $v;
        else
            $filters[$k. ' LIKE ?'] = "%$v%";
    }

    $selection = $this->connection->table('user')->where($filters);
    if ($order[0])
        $selection->order(implode(' ', $order));

    return $selection;
});

SELECT `id`, `nazevdilu`, `provozovna_id`, `uzivatelzavedl_id`, `uzivatelzadal_id`,...,
FROM `zakazka`
ORDER BY `id` DESC
LIMIT 30

SELECT `id`, `nazevdilu`, `provozovna_id`, `uzivatelzavedl_id`, `uzivatelzadal_id`,...,
FROM `zakazka`
LIMIT 30

<?php
use Nette\Application\UI\Form;
class ZakazkaVypisPresenter extends BasePresenter
{
	private $connection;
	public function injectConnection(Nette\Database\Connection $connection)
	{
		$this->connection = $connection;
	}


	public function createComponentDatagrid()
	{
		$grid = new Nextras\Datagrid\Datagrid;
		$grid->addColumn('provozovna_id', 'Provozovna')->enableSort();
		$grid->setDataSourceCallback($this->getData);
		$grid->setFilterFormFactory(function() {
			$form = new Nette\Forms\Container;
			$form->addSelect('provozovna_id', NULL, array($this->connection->table('provozovna')->fetchPairs('id', 'mesto')))->setPrompt('-- zvolte --');
			return $form;
		});
		return $grid;
	}
}

$form->addSelect('provozovna_id', NULL, array(

array('1' => 'Plzeň', '2' => 'Praha',

array($this->connection->table('provozovna')->fetchPairs('id', 'mesto'))

$this->context->invoicesModel->getDataSource

public function createComponentHistory() {

	$grid = new \Nextras\Datagrid\Datagrid ();
	$grid->addColumn('id');
	$grid->addColumn('name')->enableSort();
	$grid->addColumn('branches_id', 'Provozovna')->enableSort();
	$grid->addColumn('leden', 'Leden');
	$grid->addColumn('unor', 'Únor');

	$grid->setDatasourceCallback($this->context->invoicesModel->getDataSource);
	$grid->setPagination($this->pag, $this->context->invoicesModel->getDataSourceSum);

	$this_ = $this;
	$grid->setFilterFormFactory(function() use ($this_) {
		    $form = new Nette\Forms\Container;
		    $form->addText('name');
		    $form->addSelect('branches_id', 'Provozovna', $this_->context->printersModel->getBranches()->fetchPairs('id', 'name'))->setPrompt('Zvolte');
		    $form->addSubmit('filter', 'Filtrovat')->getControlPrototype()->class = 'btn btn-primary';
		    $form->addSubmit('cancel', 'Zrušit filtr')->getControlPrototype()->class = 'btn';

		    return $form;
		});


	$grid->addCellsTemplate(LIBS_DIR . '/Addons/Nextras-datagrid/Lattes/history.latte');
	return $grid;
    }

/** @persistent */
    public $year;

public function getData() {
	return $this->database->table('contracts')->SELECT('id, name, branches_id,
				       (SELECT SUM(sum) FROM mrp WHERE MONTH(datzdanpln) = 1 AND YEAR(datzdanpln) = 2013 AND mrp_cislo = cislo_zak) AS leden,
				       (SELECT SUM(sum) FROM mrp WHERE MONTH(datzdanpln) = 2 AND YEAR(datzdanpln) = 2013 AND mrp_cislo = cislo_zak) AS unor

					');
    }

    public function prepareDataSource($filter, $order) {

	$filters = array();
	foreach ($filter as $k => $v) {
	    if ($k == 'id' || is_array($v))
		$filters[$k] = $v;
	    else
		$filters[$k . ' LIKE ?'] = "%$v%";
	}

	$selection = $this->getData()->where($filters);
	if ($order[0])
	    $selection->order(implode(' ', $order));

	return $selection;
    }

    public function getDataSource($filter, $order, Paginator $paginator = NULL) {
	$selection = $this->prepareDataSource($filter, $order);
	if ($paginator) {
	    $selection->limit($paginator->getItemsPerPage(), $paginator->getOffset());
	}
	return $selection;
    }

    public function getDataSourceSum($filter, $order) {
	return $this->prepareDataSource($filter, $order)->count('*');
    }

$grid->setDatasourceCallback($this->context->invoicesModel->getDataSource($this->year));

$grid->setPagination....

if ($paginator) {
        $selection->limit($paginator->getItemsPerPage(), $paginator->getOffset());
    }

    public function createComponentHistory() {

	$grid = new \Nextras\Datagrid\Datagrid ();
	$grid->addColumn('id');
	$grid->addColumn('name')->enableSort();
	$grid->addColumn('branches_id', 'Provozovna')->enableSort();
	$grid->addColumn('leden', 'Leden');
	$grid->addColumn('unor', 'Únor');
	...


	$_this = $this;
	$grid->setDatasourceCallback(function($filter, $order) use ($_this) {
	return $_this->context->invoicesModel->getDataSource($filter, $order, $_this->year);
	});

	$grid->setPagination($_this->pag, function($filter, $order) use ($_this) {
	return $_this->context->invoicesModel->getDataSourceSum($filter, $order, $_this->year);
	});

	$grid->setFilterFormFactory(function() use ($_this) {
		    $form = new Nette\Forms\Container;
		    $form->addText('name');
		    $form->addSelect('branches_id', 'Provozovna', $_this->context->printersModel->getBranches()->fetchPairs('id', 'name'))->setPrompt('Zvolte');
		    $form->addSubmit('filter', 'Filtrovat')->getControlPrototype()->class = 'btn btn-primary';
		    $form->addSubmit('cancel', 'Zrušit filtr')->getControlPrototype()->class = 'btn';

		    return $form;
		});


	$grid->addCellsTemplate(LIBS_DIR . '/Addons/Nextras-datagrid/Lattes/history.latte');
	return $grid;
    }

public function getData($year) {

	return $this->database->table('contracts')->SELECT('id, name, branches_id,
				       (SELECT SUM(sum) FROM mrp WHERE MONTH(datzdanpln) = 1 AND YEAR(datzdanpln) = '.$year.' AND mrp_cislo = cislo_zak) AS leden,
				       (SELECT SUM(sum) FROM mrp WHERE MONTH(datzdanpln) = 2 AND YEAR(datzdanpln) = '.$year.' AND mrp_cislo = cislo_zak) AS unor, ....


					');
    }

    public function prepareDataSource($filter, $order, $year) {

	$filters = array();
	foreach ($filter as $k => $v) {
	    if ($k == 'id' || is_array($v))
		$filters[$k] = $v;
	    else
		$filters[$k . ' LIKE ?'] = "%$v%";
	}

	$selection = $this->getData($year)->where($filters);
	if ($order[0])
	    $selection->order(implode(' ', $order));

	return $selection;
    }

    public function getDataSource($filter, $order, $year, Paginator $paginator = NULL) {
	$selection = $this->prepareDataSource($filter, $order, $year);
	if ($paginator) {
	    $selection->limit($paginator->getItemsPerPage(), $paginator->getOffset());
	}
	return $selection;
    }

    public function getDataSourceSum($filter, $order, $year) {
	return $this->prepareDataSource($filter, $order, $year)->count('*');
    }