protected function createComponentGrid($name)
{
$grid = new Gridito\Grid($this, $name);
// model
$model = $this->context->doctrineUsersModel;
$model->addColumnAliases('username', 'credentials.username', 'c.username');
$grid->setModel($model);
$grid->setItemsPerPage(5);
// columns
$grid->addColumn('id', 'ID')->setSortable(true);
$grid->addColumn('username', 'Username')->setSortable(true);
$grid->addColumn('name', 'Name')->setSortable(true);
$grid->addColumn('surname', 'Surname')->setSortable(true);
$grid->addColumn('mail', 'E-mail', array('sortable' => true, 'renderer' => function ($row) {
echo Nette\Utils\Html::el('a')->href("mailto:{$row->mail}")->setText($row->mail);
}));
$grid->addColumn('active', 'Active')->setSortable(true);
}
protected function createComponentGrid($name)
{
$grid = new Gridito\Grid($this, $name);
$db = $this->context->dibiConnection;
$grid->setModel(new Gridito\DibiFluentModel($db->select('*')->from('users')));
$grid->setItemsPerPage(5);
// columns
$grid->addColumn('id', 'ID')->setSortable(true);
$grid->addColumn('name', 'Name')->setSortable(true);
$grid->addColumn('surname', 'Surname')->setSortable(true);
$grid->addColumn('mail', 'E-mail', array('renderer' => function ($row) {
echo Nette\Utils\Html::el('a')->href("mailto:{$row->mail}")->setText($row->mail);
}, 'sortable' => true));
$grid->addColumn('active', 'Active', array('renderer' => function ($row) {
Gridito\Column::renderBoolean($row->active);
}, 'sortable' => true));
}
protected function createComponentGrid($name)
{
$grid = new Gridito\Grid($this, $name);
$db = $this->context->dibiConnection;
$model = new Model\UsersGriditoDibiModel($db);
if ($this->getParam('activeOnly')) {
$model->filterActiveOnly();
}
$search = $this->getParam('search', false);
if ($search) {
$model->filterSearch($search);
}
$grid->setModel($model);
// columns
$grid->addColumn('id', 'ID')->setSortable(true);
$grid->addColumn('name', 'Name')->setSortable(true);
$grid->addColumn('surname', 'Surname')->setSortable(true);
$grid->addColumn('mail', 'E-mail', array('renderer' => function ($row) {
echo Nette\Utils\Html::el('a')->href("mailto:{$row->mail}")->setText($row->mail);
}, 'sortable' => true));
$grid->addColumn('active', 'Active', array('renderer' => function ($row) {
Gridito\Column::renderBoolean($row->active);
}, 'sortable' => true));
}
protected function createComponentGrid($name)
{
$grid = new Gridito\Grid($this, $name);
$model = $this->context->doctrineUsersModel;
$model->addColumnAliases('username', 'credentials.username', 'c.username');
$grid->setModel($model);
$grid->setHighlightOrderedColumn(FALSE);
$grid->setRowClass(function ($iterator, $row) {
$classes = array();
$classes[] = $iterator->isOdd() ? 'odd' : 'even';
if (!$row->active) {
$classes[] = 'inactive';
}
return empty($classes) ? null : implode(' ', $classes);
});
// columns
$grid->addColumn('id', 'ID')->setSortable(true);
$grid->addColumn('username', 'Username')->setSortable(true)->setCellClass('important');
$grid->addColumn('name', 'Name')->setSortable(true);
$grid->addColumn('surname', 'Surname')->setSortable(true);
$grid->addColumn('mail', 'E-mail', array('renderer' => function ($row) {
echo Nette\Utils\Html::el('a')->href("mailto:{$row->mail}")->setText($row->mail);
}, 'sortable' => true));
$grid->addColumn('active', 'Active')->setSortable(true);
// buttons
$grid->addButton('button', 'Button', array('icon' => 'icon-tick', 'handler' => function ($row) use($grid) {
$grid->flashMessage("Button {$row->name} {$row->surname} pressed.");
$grid->redirect('this');
}));
$grid->addWindowButton('winbtn', 'Window', array('handler' => function ($row) {
echo "{$row->name} {$row->surname}<br>({$row->mail})";
}, 'icon' => 'icon-window'));
}
protected function createComponentGrid($name)
{
$grid = new Gridito\Grid($this, $name);
$model = $this->context->doctrineUsersModel;
$model->addColumnAliases('username', 'credentials.username', 'c.username');
$grid->setModel($model);
// columns
$grid->addColumn('id', 'ID')->setSortable(true);
$grid->addColumn('username', 'Username')->setSortable(true);
$grid->addColumn('name', 'Name')->setSortable(true);
$grid->addColumn('surname', 'Surname')->setSortable(true);
$grid->addColumn('mail', 'E-mail')->setSortable(true);
$grid->addColumn('active', 'Active')->setSortable(true);
$grid->setItemsPerPage(5);
// buttons
$grid->addButton('button', 'Button', array('icon' => 'ui-icon-plusthick', 'handler' => function ($row) use($grid) {
$grid->flashMessage("Button {$row->name} {$row->surname} pressed.");
$grid->redirect('this');
}));
$grid->getTemplate()->setFile(__DIR__ . '/../templates/DoctrineCustomTemplate/@grid.phtml');
}
protected function createComponentGrid($name)
{
$grid = new Gridito\Grid($this, $name);
$grid->setDefaultSorting('id', 'asc');
// model
$model = $this->context->doctrineUsersModel;
$model->addColumnAliases('username', 'credentials.username', 'c.username');
$grid->setModel($model);
// columns
$grid->addColumn('id', 'ID')->setSortable(true);
$grid->addColumn('username', 'Username')->setSortable(true);
$grid->addColumn('name', 'Name')->setSortable(true);
$grid->addColumn('surname', 'Surname')->setSortable(true);
$grid->addColumn('mail', 'E-mail', array('sortable' => true, 'renderer' => function ($row) {
echo Nette\Utils\Html::el('a')->href("mailto:{$row->mail}")->setText($row->mail);
}));
$grid->addColumn('active', 'Active')->setSortable(true);
// toolbar buttons
$grid->addToolbarButton('create', 'Create new user', array('handler' => function () use($grid) {
$grid->flashMessage('Unable to create user.', 'error');
$grid->redirect('this');
}, 'icon' => 'ui-icon-plusthick'));
$grid->addToolbarWindowButton('hello', 'New window')->setHandler(function () {
echo 'Hello!';
})->setIcon('ui-icon-newwin');
$grid->addToolbarButton('back', 'Go back to examples', array('link' => $this->link('Homepage:'), 'icon' => 'ui-icon-home'));
$grid->addWindowButton('detail', 'Detail', array('handler' => function ($user) {
// todo fix XSS
echo '<p><strong>' . $user->name . ' ' . $user->surname . '</strong></p>';
echo '<table>';
echo '<tr><th>ID</th><td>' . $user->id . '</td></tr>';
echo '<tr><th>Username</th><td>' . $user->credentials->username . '</td></tr>';
echo '<tr><th>E-mail</th><td>' . $user->mail . '</td></tr>';
echo '<tr><th>Active</th><td>' . ($user->active ? 'yes' : 'no') . '</td></tr>';
echo '</table>';
}, 'icon' => 'ui-icon-search'));
// action buttons
$grid->addButton('delete', 'Delete', array('handler' => function ($user) use($grid) {
$grid->flashMessage("Unable to delete user {$user->name} {$user->surname}.", 'error');
$grid->redirect('this');
}, 'icon' => 'ui-icon-closethick', 'confirmationQuestion' => function ($user) {
if ($user->active) {
return "Really delete use {$user->name} {$user->surname}?";
} else {
return null;
}
}, 'showText' => false, 'visible' => function ($user) {
return !$user->isActive();
}));
}