use Carrooi\NoGrid\DataSource\ArrayDataSource;
use Nette\Application\UI\Presenter;

class BooksPresenter extends Presenter
{

	/** @var \Carrooi\NoGrid\INoGridFactory @inject */
	public $gridFactory;
	
	protected function createComponentBooksGrid()
	{
		$dataSource = new ArrayDataSource([			// Read more about data sources below
			['title' => 'Lord of the Rings'],
			['title' => 'Harry Potter'],
			['title' => 'Narnia'],
		]);
	
		$grid = $this->gridFactory->create($dataSource);
		
		return $grid;
	}

}

$grid->transformData(function($line) {
	return [
		'id' => $line->getId(),
		'title' => $line->getTitle(),
	];
});

protected function createComponentBooksGrid()
{
	$dataSource = new ArrayDataSource([			// Read more about data sources below
		[
			'title' => 'Lord of the Rings,
			'sold' => true,
		'],
		[
			'title' => 'Harry Potter,
			'sold' => false,
		'],
		[
			'title' => 'Narnia,
			'sold' => false,
		'],
	]);

	$grid = $this->gridFactory($dataSource);
	
	$grid->addView('active', 'Active', function(array &$data) {
		$data = array_filter($data, function($book) {
			return !$book['sold'];
		});
	});
	
	$grid->addView('sold', 'Sold out', function(array &$data) {
		$data = array_filter($data, function($book) {
			return $book['sold'];
		});
	});
	
	return $grid;
}

$form = new Form;
$form->addText('name');
$form->addSubmit('search', 'Search!');

$grid->setFilteringForm($form);

// NoGrid will automatically create Condition::SAME for matching fileds and values provided from form.
// You can override this funcionality this way:
$grid->addFilter('name', Condition::LIKE, [
	Condition::CASE_INSENSITIVE => true,
], function($name) {

	// update value before sending query to database
	return '%'. $name. '%';
});

$dataSource = new ArrayDataSource([
	['name' => 'awesome', 'surname' => 'hypercat'],
	['name' => 'john', 'surname' => 'doe'],
	['name' => 'lorem', 'surname' => 'ipsum'],
]);

$grid = $noGridFactory->create($dataSource);

// prepare filter form
$form = new \Nette\Application\UI\Form;

$form->addText('fullname');
$form->addSubmit('search', 'Search');

$grid->setFilteringForm($form);

// define custom filter
// you will get whole array as first parameter and value from form input as second parameter
$grid->addFilter('fullname', Condition::CALLBACK, [], function (array $data, $value) { 
	return array_filter($data, function($row) use($value) {
		return (\Nette\Utils\Strings::contains($row['name'] . ' ' . $row['surname'], $value));
	});
});

return $grid;

$queryBuilder = $this->entityManager->getRepository(\Libs\Entity\Person::class)->createQueryBuilder('p');

$dataSource = new DoctrineDataSource($queryBuilder);

$form = new \Nette\Application\UI\Form;

$form->addText('fullname');
$form->addSubmit('search', 'Search');

$grid->setFilteringForm($form);

$grid->addFilter('person', Condition::CALLBACK, [], function (QueryBuilder $queryBuilder, $value) {
	$queryBuilder->andWhere("CONCAT(p.givenName,' ',p.familyName) LIKE :fullname")->setParameter('fullname', "%{$value}%");
});