public function createComponentUsersGrid($name)
{
$groupId = $this->getParameter('groupId');
$grid = new Grid($this, $name);
$grid->setModel($this->userModel->findAll($groupId));
$grid->addColumnText('username', 'Užívateľ')->setSortable()->setFilterText();
$grid->addColumnText('email', 'Email-ová adresa')->setSortable()->setFilterText();
$grid->addColumnNumber('last_login', 'Posledné prihlásenie')->setSortable();
$grid->filterRenderType = $this->filterRenderType;
$grid->hasActions(false);
}
protected function createComponentSearchGrid($name)
{
if ($this->groupsOutput) {
$grid = new Grid($this, $name);
$grid->setModel($this->groupsOutput);
$grid->setPrimaryKey('id');
$grid->addColumnText('name', 'Názov')->setSortable();
$grid->addColumnText('desc', 'Popis')->setSortable();
$grid->addColumnNumber('pocet', 'Počet ľudí')->setSortable();
// $operation = array('join' => 'Pripojiť sa', 'leave' => 'Odísť');
// $grid->setOperation($operation, $this->handleOperations)
// ->setConfirm('delete', 'Are you sure you want to delete %i items?');
$grid->filterRenderType = $this->filterRenderType;
}
}
/**
* @param $name
* @return Grid
* @throws \Grido\Exception
*/
protected function createComponentGrid($name)
{
$grid = new Grid($this, $name);
$grid->translator->lang = 'cs';
$fluent = $this->searchRepository->getAll();
$grid->model = $fluent;
$grid->addColumnText('term', 'Hledaný termín')->setSortable()->setFilterText();
$grid->getColumn('term')->headerPrototype->style['width'] = '75%';
$grid->addColumnNumber('count', 'Počet hledání')->setSortable();
$grid->getColumn('term')->headerPrototype->style['width'] = '25%';
$grid->setDefaultPerPage(50);
$grid->filterRenderType = $this->filterRenderType;
$grid->setExport();
return $grid;
}
public function createComponentEntriesGrid($name)
{
$seasons = [null => null] + $this->getSelectSeasons();
$users = [null => null] + $this->getSelectUsers();
$grid = new Grid($this, $name);
$grid->setModel($this->entryService->getEntriesDataSource());
$grid->setPrimaryKey("id");
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('season', $this->tt("motivationModule.admin.grid.season"))->setSortable()->setFilterSelect($seasons);
$headerSeas = $grid->getColumn('season')->headerPrototype;
$headerSeas->class[] = 'center';
$grid->addColumnText('owner', $this->tt("motivationModule.admin.grid.owner"))->setSortable()->setFilterSelect($users);
$headerOwn = $grid->getColumn('owner')->headerPrototype;
$headerOwn->class[] = 'center';
$grid->addColumnText('amount', $this->tt("motivationModule.admin.grid.amount"))->setSortable()->setFilterText();
$headerAmnt = $grid->getColumn('amount')->headerPrototype;
$headerAmnt->class[] = 'center';
$types = MotivationEntryType::getOptions();
$grid->addColumnText('type', $this->tt("motivationModule.admin.grid.type"))->setSortable()->setReplacement($types)->setFilterSelect([null => null] + $types);
$headerT = $grid->getColumn('type')->headerPrototype;
$headerT->class[] = 'center';
$grid->addColumnText('subject', $this->tt("motivationModule.protected.grid.subject"))->setSortable()->setFilterText();
$headerSubj = $grid->getColumn('subject')->headerPrototype;
$headerSubj->class[] = 'center';
$grid->addActionHref('delete', '', "deleteEntry!")->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("motivationModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("motivationModule.admin.grid.rlyDeleteEntryId", null, ["id" => $u->getId()]);
});
$grid->addActionHref("update", "", "updateEntry")->setIcon("pencil")->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("motivationModule.admin.grid.update")]));
$operation = ['delete' => $this->tt("system.common.delete")];
$grid->setOperation($operation, $this->entryGridOpsHandler)->setConfirm('delete', $this->tt("motivationModule.admin.grid.reallyDeleteItems"));
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-motivation-entries" . date("Y-m-d H:i:s", time()));
}
public function createComponentSeasonApplicationGrid($name)
{
$grid = new Grid($this, $name);
$grid->setModel($this->getSeasonApplicationService()->getSeasonApplicationsDataSource());
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('owner', 'Člen')->setSortable();
$headerLabel = $grid->getColumn('owner')->headerPrototype;
$headerLabel->class[] = 'center';
$grid->addColumnText('season', 'Sezóna')->setSortable();
$headerLabel = $grid->getColumn('season')->headerPrototype;
$headerLabel->class[] = 'center';
$grid->addColumnText('sportGroup', 'Skupina')->setSortable();
$headerSince = $grid->getColumn('sportGroup')->headerPrototype;
$headerSince->class[] = 'center';
$grid->addColumnDate('enrolledTime', 'Podáno', self::DATETIME_FORMAT)->setSortable()->setCustomRender($this->appGridUpdatedRender);
$headerTill = $grid->getColumn('enrolledTime')->headerPrototype;
$headerTill->class[] = 'center';
$grid->addColumnDate('updated', 'Změněno')->setSortable()->setCustomRender($this->appGridUpdatedRender);
$headerTill = $grid->getColumn('updated')->headerPrototype;
$headerTill->class[] = 'center';
$grid->addColumnText('comment', 'Poznámka')->setSortable()->setTruncate(15);
$headerNote = $grid->getColumn('comment')->headerPrototype;
$headerNote->class[] = 'center';
$grid->addActionHref('delete', '', 'deleteSeasonApplication!')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("seasonsModule.admin.grid.delete")]))->setIcon('trash')->setConfirm(function ($u) {
return $this->tt("seasonsModule.admin.grid.reallyDeleteAppId", null, ["id" => $u->getId()]);
});
$grid->addActionHref('edit', '', 'updateSeasonApplication')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("seasonsModule.admin.grid.update")]))->setIcon('pencil');
$grid->setOperation(["delete" => $this->tt("seasonsModule.admin.grid.delete")], null, $this->seasonAppOperationsHandler)->setConfirm('delete', $this->tt("usersModule.admin.grid.reallyDeleteItems"));
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-season-applications " . date("Y-m-d H:i:s", time()));
}
public function createComponentWebProfilesPermitGrid($name)
{
$grid = new Grid($this, $name);
$grid->setModel($this->userService->getWebProfilesToPermitDatasource());
$grid->setTranslator($this->getTranslator());
$grid->setDefaultPerPage(30);
$grid->setPrimaryKey('id');
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText("personalLikes", "usersModule.admin.wpGrid.content.label")->setTruncate(100)->setCustomRender($this->wpDataRender)->cellPrototype->class[] = 'center';
$headerData = $grid->getColumn('personalLikes')->headerPrototype;
$headerData->class[] = 'center';
$headerData->style['width'] = '70%';
$grid->addColumnText("personalDisLikes", "usersModule.admin.wpGrid.photo.label")->setCustomRender($this->wpPhotoRender)->cellPrototype->class[] = 'center';
$headerPhoto = $grid->getColumn('personalDisLikes')->headerPrototype;
$headerPhoto->class[] = 'center';
$headerPhoto->style['width'] = '8%';
$y = $this->tt("system.common.yes");
$n = $this->tt("system.common.no");
$activeList = [null => null] + [true => $y, false => $n];
$grid->addColumnText('publish', $this->tt("systemModule.admin.grid.active"))->setSortable()->setReplacement([true => $y, null => $n])->setFilterSelect($activeList);
$headerAct = $grid->getColumn('publish')->headerPrototype;
$headerAct->class[] = 'center';
$headerAct->style['width'] = '0.1%';
$grid->addActionHref('yes', '', "permitProfile!")->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("usersModule.admin.grid.permitProfile")]))->setIcon('ok')->setConfirm(function ($u) {
return $this->tt("usersModule.admin.wpGrid.reallyPermitItem", null, ["id" => $u->getId()]);
});
$grid->addActionHref('no', '', "denyProfile!")->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("usersModule.admin.grid.denyProfile")]))->setIcon('remove')->setConfirm(function ($u) {
return $this->tt("usersModule.admin.wpGrid.reallyDenyItem", null, ["id" => $u->getId()]);
});
$operation = array('yes' => 'Permit', 'no' => 'Deny');
$grid->setOperation($operation, $this->wppGridOperationsHandler)->setConfirm("yes", $this->tt("usersModule.admin.wpGrid.reallyPermitItems"))->setConfirm("no", $this->tt("usersModule.admin.wpGrid.reallyDenyItems"));
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-users " . date("Y-m-d H:i:s", time()));
return $grid;
}
/**
* Admin articles grid factory.
* @param string $name
* @return Grid
*/
public function createComponentArticlesGrid($name)
{
$articleStates = [null => null] + ArticleStatus::getOptions();
$commentModes = [null => null] + CommentMode::getOptions();
try {
$users = [null => null] + $this->usersService->getSelectUsers();
} catch (Exceptions\DataErrorException $ex) {
$this->handleException($ex);
}
$grid = new Grid($this, $name);
$grid->setModel($this->articleService->getArticlesDataSource());
$grid->setTranslator($this->getTranslator());
$grid->setPrimaryKey("id");
$grid->addColumnNumber("id", "#")->cellPrototype->class[] = "center";
$headerId = $grid->getColumn("id")->headerPrototype;
$headerId->class[] = "center";
$headerId->rowspan = "2";
$headerId->style["width"] = '0.1%';
$grid->addColumnText('title', $this->tt("articlesModule.admin.grid.title"))->setSortable()->setCustomRender($this->titleRender)->setFilterText();
$headerTitle = $grid->getColumn('title')->headerPrototype;
$headerTitle->class[] = 'center';
$grid->addColumnText('status', $this->tt("articlesModule.admin.grid.state"))->setSortable()->setCustomRender($this->statusRender)->setFilterSelect($articleStates);
$headerStatus = $grid->getColumn('status')->headerPrototype;
$headerStatus->class[] = 'center';
$grid->addColumnText('commentMode', $this->tt("articlesModule.admin.grid.comments"))->setSortable()->setCustomRender($this->commentModeRender)->setFilterSelect($commentModes);
$headerStatus = $grid->getColumn('commentMode')->headerPrototype;
$headerStatus->class[] = 'center';
$grid->addColumnText('author', $this->tt("articlesModule.admin.grid.author"))->setSortable()->setFilterSelect($users);
$headerAuthor = $grid->getColumn('author')->headerPrototype;
$headerAuthor->class[] = 'center';
$grid->addColumnDate('updated', $this->tt("articlesModule.admin.grid.change"), self::DATETIME_FORMAT)->setSortable()->setFilterDateRange();
$headerAuthor = $grid->getColumn('updated')->headerPrototype;
$headerAuthor->class[] = 'center';
$grid->addActionHref('delete', '', 'deleteArticle!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("articlesModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("articlesModule.admin.grid.rlyDelArticle", null, ["id" => $u->getId()]);
});
$grid->addActionHref('edit', '', 'updateArticle')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("articlesModule.admin.grid.update")]));
$grid->addActionHref("goto", "", "goToArticle")->setIcon('eye-open')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("articlesModule.admin.grid.view")]));
$grid->setOperation(["delete" => $this->tt("system.common.delete")], $this->articlesGridOperationHandler);
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-articles" . date("Y-m-d H:i:s", time()));
return $grid;
}
/**
* @param $name
* @return Grid
*/
protected function createComponentGrid($name)
{
$grid = new Grid($this, $name);
$grid->translator->lang = 'cs';
$fluent = $this->articlesRepository->getAll();
$articles = [];
foreach ($fluent as $articleRow) {
$articles[$articleRow->id] = $articleRow;
}
if (isset($grid->model)) {
$grid->model = $fluent;
}
$grid->addColumnNumber('id', 'ID');
$header = $grid->getColumn('id')->headerPrototype;
$header->style['width'] = '0.5%';
$grid->addColumnText('name', 'Název')->setFilterText()->setSuggestion();
$grid->getColumn('name')->headerPrototype->style['width'] = '40%';
$grid->addColumnText('active', 'Aktivní')->setCustomRender(function ($item) {
if ($item->active == 0) {
$i = Html::el('i', ['class' => 'glyphicon glyphicon-thumbs-down']);
$el = Html::el('a', ['class' => 'btn btn-danger btn-xs btn-mini ajax'])->href($this->presenter->link("active!", $item->id))->setHtml($i);
} else {
$i = Html::el('i', ['class' => 'glyphicon glyphicon-thumbs-up']);
$el = Html::el('a', ['class' => 'btn btn-success btn-xs btn-mini ajax'])->href($this->presenter->link("active!", $item->id))->setHtml($i);
}
return $el;
})->cellPrototype->class[] = 'center';
$grid->addActionHref('edit', '')->setIcon('pencil');
$grid->addActionEvent('delete', '')->setCustomRender(function ($item) {
$i = Html::el('i', ['class' => 'fa fa-trash']);
$el = Html::el('a', ['class' => 'btn btn-default btn-xs btn-mini ajax', 'data-grido-confirm' => "Opravdu chcete tuto položku odstranit?"])->href($this->presenter->link("delete!", $item->id))->setHtml($i);
return $el;
});
$grid->setDefaultSort(['date' => 'DESC']);
$grid->setRememberState(true);
$grid->setPrimaryKey('id');
$grid->setDefaultPerPage(50);
$grid->filterRenderType = $this->filterRenderType;
$grid->setExport();
return $grid;
}
/**
* Admin payments grid control factory
* @param string $name
*/
public function createComponentPaymentsGrid($name)
{
try {
$seasons = [null => null] + $this->seasonService->getSelectSeasons();
$users = [null => null] + $this->getUsersService()->getSelectUsers();
} catch (Exceptions\DataErrorException $ex) {
$this->handleDataLoad(null, "default", $ex);
}
$grid = new Grid($this, $name);
$grid->setModel($this->getPaymentService()->getPaymentsDataSource());
$grid->setPrimaryKey("id");
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('owner', $this->tt('paymentsModule.admin.grid.user'))->setSortable()->setFilterSelect($users);
$headerLabel = $grid->getColumn('owner')->headerPrototype;
$headerLabel->class[] = 'center';
$grid->addColumnText('season', $this->tt('paymentsModule.admin.grid.season'))->setSortable()->setFilterSelect($seasons);
$headerSeas = $grid->getColumn('season')->headerPrototype;
$headerSeas->class[] = 'center';
$grid->addColumnDate('dueDate', $this->tt('paymentsModule.admin.grid.dueDate'), self::DATE_FORMAT)->setSortable()->setFilterDateRange();
$headerOrdered = $grid->getColumn('dueDate')->headerPrototype;
$headerOrdered->class[] = 'center';
$grid->addColumnNumber('amount', $this->tt('paymentsModule.admin.grid.amount'))->setSortable()->setFilterNumber();
$headerAm = $grid->getColumn('amount')->headerPrototype;
$headerAm->class[] = 'center';
$states = [null => null] + PaymentStatus::getOptions();
$grid->addColumnText('status', $this->tt('paymentsModule.admin.grid.status'))->setTruncate(9)->setSortable()->setCustomRender($this->statusRender)->setFilterSelect($states);
$headerSta = $grid->getColumn('status')->headerPrototype;
$headerSta->class[] = 'center';
$grid->addActionHref('delete', '', 'deletePayment!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("paymentsModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("paymentsModule.admin.grid.messages.rlyDelPayment", null, ["id" => $u->getId()]);
});
$grid->addActionHref('edit', '', 'updatePayment')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("paymentsModule.admin.grid.update")]));
$grid->setOperation(["delete" => $this->tt("system.common.delete"), "markCash" => $this->tt("paymentsModule.admin.grid.markDoneCash"), "markAcc" => $this->tt("paymentsModule.admin.grid.markDoneAcc"), "markSent" => $this->tt("paymentsModule.admin.grid.markSent")], $this->paymentsGridOpsHandler)->setConfirm("delete", $this->tt("paymentsModule.admin.grid.messages.rlyDelPaymentItems"));
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-payments " . date("Y-m-d H:i:s", time()));
}
public function createComponentPositionsGrid($name)
{
$grid = new Grid($this, $name);
$grid->setModel($this->positionService->getPositionsDatasource());
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('owner', 'Uživatel')->setSortable()->setFilterSelect([null => null] + $this->getSelectUsers());
$grid->addColumnText('group', 'Skupina')->setSortable()->setFilterSelect([null => null] + $this->getSelectGroups());
$grid->addColumnText('role', 'Role')->setSortable()->setFilterSelect([null => null] + $this->getSelectRoles());
$grid->addColumnText('comment', 'Komentář')->setCustomRender($this->commentGridRender)->setTruncate(20)->setSortable()->setFilterText();
$headerOwner = $grid->getColumn('owner')->headerPrototype;
$headerOwner->class[] = 'center';
$headerGroup = $grid->getColumn('group')->headerPrototype;
$headerGroup->class[] = 'center';
$headerRole = $grid->getColumn('role')->headerPrototype;
$headerRole->class[] = 'center';
$grid->addActionHref('delete', '', 'deletePosition!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("securityModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("securityModule.admin.grid.rlyDeletePosition", null, ["pos" => $u]);
});
$grid->addActionHref('edit', '', 'updatePosition')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("securityModule.admin.grid.update")]));
$grid->setOperation(["delete" => $this->tt("system.common.delete")], $this->positionGridOpsHandler);
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-positions " . date("Y-m-d H:i:s", time()));
}
/**
* Component factory for Roles administration grid
* @param string $name
*/
public function createComponentRolesGrid($name)
{
$grid = new \Grido\Grid($this, $name);
$grid->setModel($this->roleService->getRolesDatasource());
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('name', 'Jméno')->setSortable()->setFilterText();
$grid->getColumn('name')->getEditableControl()->setRequired('Name is required.');
$headerName = $grid->getColumn('name')->headerPrototype;
$headerName->class[] = 'center';
$grid->addColumnText('parents', 'Rodiče')->setSortable()->setFilterText();
$grid->getColumn('parents')->setCustomRender(callback($this, 'roleParColToString'));
$headerParent = $grid->getColumn('parents')->headerPrototype;
$headerParent->class[] = 'center';
$grid->addColumnDate('added', 'Přidáno')->setSortable();
$headerAdded = $grid->getColumn('added')->headerPrototype;
$headerAdded->class[] = 'center';
$grid->addColumnText('note', 'Poznámka')->setCustomRender($this->noteGridRender)->setSortable()->setTruncate(20)->setFilterText();
$headerNote = $grid->getColumn('note')->headerPrototype;
$headerNote->class[] = 'center';
$grid->addActionHref('delete', '', 'deleteRole!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("securityModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("securityModule.admin.grid.rlyDeleteRole", null, ["pos" => $u]);
});
$grid->addActionHref('edit', '', 'updateRole')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("securityModule.admin.grid.update")]));
$grid->setOperation(["delete" => $this->tt("system.common.delete")], $this->roleGridOpsHandler);
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-roles " . date("Y-m-d H:i:s", time()));
}
/**
* User's payments grid factory
* @param string $name
* @return Grid
*/
public function createComponentUserPaymentsGrid($name)
{
try {
$seasons = $this->seasonService->getSelectSeasons();
} catch (Exceptions\DataErrorException $ex) {
$this->handleDataLoad(null, ":System:Default:userRoot", $ex);
}
$grid = new Grid($this, $name);
$grid->setModel($this->paymentService->getPaymentsDataSource($this->getUser()->getIdentity()));
$grid->setTranslator($this->getTranslator());
$grid->setPrimaryKey("id");
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnNumber('amount', $this->tt('paymentsModule.admin.grid.amount'))->setSortable()->setFilterNumber();
$headerAm = $grid->getColumn('amount')->headerPrototype;
$headerAm->class[] = 'center';
$grid->addColumnText('subject', $this->tt('paymentsModule.admin.grid.subject'))->setCustomRender($this->subjectRender)->setSortable()->setFilterText();
$headerSeas = $grid->getColumn('subject')->headerPrototype;
$headerSeas->class[] = 'center';
$grid->addColumnDate('dueDate', $this->tt('paymentsModule.admin.grid.dueDate'), self::DATE_FORMAT)->setSortable()->setFilterDateRange();
$headerOrdered = $grid->getColumn('dueDate')->headerPrototype;
$headerOrdered->class[] = 'center';
$states = [null => null] + PaymentStatus::getOptions();
$grid->addColumnText('status', $this->tt('paymentsModule.admin.grid.status'))->setTruncate(9)->setSortable()->setCustomRender($this->statusRender)->setFilterSelect($states);
$grid->addColumnText('season', $this->tt('paymentsModule.admin.grid.season'))->setSortable()->setFilterSelect($seasons);
$headerSeas = $grid->getColumn('season')->headerPrototype;
$headerSeas->class[] = 'center';
$headerSta = $grid->getColumn('status')->headerPrototype;
$headerSta->class[] = 'center';
$grid->addActionHref("show", "", "paymentDetails")->setIcon("eye-open");
$grid->addActionHref("markAsSent", "", "markAsSent!")->setIcon("check")->setConfirm(function ($u) {
return $this->tt("paymentsModule.protected.grid.messages.rlyMarkAsSent", null, ["id" => $u->getId()]);
});
$grid->setFilterRenderType($this->filterRenderType);
return $grid;
}
public function createComponentForumThreadsGrid($name)
{
$commentModes = [null => null] + CommentMode::getOptions();
$users = [null => null] + $this->getSelectUsers();
$forums = [null => null] + (array) $this->getSelectForums();
$grid = new Grid($this, $name);
$grid->setModel($this->forumService->getForumThreadsDataSource());
$grid->setTranslator($this->getTranslator());
$grid->setPrimaryKey("id");
$grid->addColumnNumber("id", "#")->cellPrototype->class[] = "center";
$headerId = $grid->getColumn("id")->headerPrototype;
$headerId->class[] = "center";
$headerId->rowspan = "2";
$headerId->style["width"] = '0.1%';
$grid->addColumnText('title', "communicationModule.admin.grid.title")->setTruncate(20)->setSortable()->setFilterText();
$headerTitle = $grid->getColumn('title')->headerPrototype;
$headerTitle->class[] = 'center';
$grid->addColumnText('forum', "communicationModule.admin.grid.forum")->setSortable()->setFilterSelect($forums);
$headerPar = $grid->getColumn('forum')->headerPrototype;
$headerPar->class[] = 'center';
$grid->addColumnText('commentMode', "communicationModule.admin.grid.comments")->setCustomRender($this->commentModeRender)->setSortable()->setFilterSelect($commentModes);
$headerStatus = $grid->getColumn('commentMode')->headerPrototype;
$headerStatus->class[] = 'center';
$grid->addColumnText('author', "communicationModule.admin.grid.author")->setSortable()->setFilterSelect($users);
$headerAuthor = $grid->getColumn('author')->headerPrototype;
$headerAuthor->class[] = 'center';
$grid->addActionHref('delete', '', 'deleteForumThread!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("communicationModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("communicationModule.admin.grid.messages.rlyDelForumThr", null, ["id" => $u->getId()]);
});
$grid->addActionHref('edit', '', 'updateForumThread')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("communicationModule.admin.grid.update")]));
$grid->setOperation(["delete" => "communicationModule.admin.grid.delete"], $this->forumGridOpsHandler)->setConfirm("delete", "communicationModule.admin.grid.messages.rlyDelForumThrItems");
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-forum" . date("Y-m-d H:i:s", time()));
return $grid;
}
public function createComponentEventsGrid($name)
{
$eventTypes = [null => null] + EventType::getOptions();
$grid = new Grid($this, $name);
$grid->setModel($this->eventsService->getEventsDataSource());
$grid->setTranslator($this->getTranslator());
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('title', 'Titulek')->setTruncate(20)->setSortable()->setFilterText();
$headerTitle = $grid->getColumn('title')->headerPrototype;
$headerTitle->class[] = 'center';
$grid->addColumnText('eventType', 'Typ')->setCustomRender($this->typeRender)->setSortable()->setFilterSelect($eventTypes);
$headerType = $grid->getColumn('eventType')->headerPrototype;
$headerType->class[] = 'center';
$grid->addColumnDate('takePlaceSince', 'Od', self::DATETIME_FORMAT)->setSortable()->setFilterDateRange();
$headerSince = $grid->getColumn('takePlaceSince')->headerPrototype;
$headerSince->class[] = 'center';
$grid->addColumnDate('takePlaceTill', 'Do', self::DATETIME_FORMAT)->setSortable()->setFilterDateRange();
$headerTill = $grid->getColumn('takePlaceTill')->headerPrototype;
$headerTill->class[] = 'center';
$grid->addColumnDate('confirmUntil', 'Potvrdit', self::DATETIME_FORMAT)->setSortable();
$headerDead = $grid->getColumn('confirmUntil')->headerPrototype;
$headerDead->class[] = 'center';
$grid->addActionHref('delete', '', 'deleteEvent!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("eventsModule.grid.deleteEvent")]))->setConfirm(function ($u) {
return $this->tt("eventsModule.admin.grid.rlyDelEvent", null, ["id" => $u->getId()]);
});
$grid->addActionHref("participation", "", "updateParticipation")->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("eventsModule.grid.updateParticipation")]))->setIcon("list-alt");
$grid->addActionHref('edit', '', 'updateEvent')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("eventsModule.grid.updateEvent")]))->setIcon('pencil');
$grid->setOperation(["delete" => "Delete"], $this->eventsGridOperationHandler)->setConfirm('delete', 'Are you sure you want to delete %i items?');
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-events" . date("Y-m-d H:i:s", time()));
}
public function createComponentStaticPagesGrid($name)
{
try {
// $users = [null=>null] + $this->userService->getSelectUsers();
// $pages = [null=>null] + $this->staticPageService->getSelectStaticPages();
$states = [null => null] + StaticPageStatus::getOptions();
$commModes = [null => null] + CommentMode::getOptions();
} catch (Exceptions\DataErrorException $ex) {
$this->handleDataLoad(null, ":System:Default:adminRoot", $ex);
}
$grid = new Grid($this, $name);
$grid->setTranslator($this->getTranslator());
$grid->setModel($this->staticPageService->getPagesDataSource());
$grid->setPrimaryKey('id');
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('title', $this->tt("systemModule.admin.grid.title"))->setSortable();
$headerTt = $grid->getColumn('title')->headerPrototype;
$headerTt->class[] = 'center';
$grid->addColumnText('abbr', $this->tt("systemModule.admin.grid.abbr"))->setSortable()->setFilterText();
$headerAb = $grid->getColumn('abbr')->headerPrototype;
$headerAb->class[] = 'center';
// $grid->addColumnText('parent', $this->tt("systemModule.admin.grid.parent"))
// ->setSortable()
// ->setFilterSelect($pages);
// $headerParent = $grid->getColumn('parent')->headerPrototype;
// $headerParent->class[] = 'center';
$grid->addColumnText('group', $this->tt("systemModule.admin.grid.group"))->setSortable()->setFilterSelect([null => null] + $this->getSelectSportGroups());
$headerParent = $grid->getColumn('group')->headerPrototype;
$headerParent->class[] = 'center';
$grid->addColumnText('commentMode', $this->tt("systemModule.admin.grid.commMode"))->setSortable()->setCustomRender($this->spCommModeRender)->setFilterSelect($commModes);
$headerCm = $grid->getColumn('commentMode')->headerPrototype;
$headerCm->class[] = 'center';
$grid->addColumnText('status', $this->tt("systemModule.admin.grid.status"))->setSortable()->setCustomRender($this->spStatusRender)->setFilterSelect($states);
$headerSt = $grid->getColumn('status')->headerPrototype;
$headerSt->class[] = 'center';
$grid->addActionHref('delete', '', 'deleteStaticPage!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("systemModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("systemModule.admin.grid.messages.rlyDelPage", null, ["id" => $u->getId()]);
});
$grid->addActionHref('edit', '', 'updateStaticPage')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("systemModule.admin.grid.update")]));
$grid->setOperation(["delete" => $this->tt("systemModule.admin.grid.delete")], $this->staticPagesOpHandler)->setConfirm("delete", $this->tt("systemModule.admin.grid.messages.rlyDelPageItems"));
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-types " . date("Y-m-d H:i:s", time()));
}
/**
* Partners grid factory
* @param string $name
*/
public function createComponentPartnersGrid($name)
{
try {
$users = [null => null] + $this->getUsersService()->getSelectUsers();
} catch (Exceptions\DataErrorException $ex) {
$this->handleDataLoad(null, "default", $ex);
}
$grid = new Grid($this, $name);
$grid->setTranslator($this->getTranslator());
$grid->setModel($this->getPartnerService()->getPartnersDataSource());
$grid->setPrimaryKey("id");
$grid->addColumnNumber('id', '#')->cellPrototype->class[] = 'center';
$headerId = $grid->getColumn('id')->headerPrototype;
$headerId->class[] = 'center';
$headerId->rowspan = "2";
$headerId->style['width'] = '0.1%';
$grid->addColumnText('name', 'partnersModule.admin.grid.name')->setSortable()->setCustomRender($this->nameRender);
$headerName = $grid->getColumn('name')->headerPrototype;
$headerName->class[] = 'center';
// $grid->addColumnText('referrer','partnersModule.admin.grid.referrer')
// ->setSortable()
// ->setFilterSelect($users);
// $headerRef = $grid->getColumn('referrer')->headerPrototype;
// $headerRef->class[] = 'center';
$grid->addColumnDate('updated', 'partnersModule.admin.grid.updated', self::DATE_FORMAT)->setSortable()->setFilterDateRange();
$headerUpdated = $grid->getColumn('updated')->headerPrototype;
$headerUpdated->class[] = 'center';
$y = $this->tt("system.common.yes");
$n = $this->tt("system.common.no");
$activeList = [null => null, true => $y, false => $n];
$grid->addColumnNumber('active', 'partnersModule.admin.grid.active')->setReplacement([true => $y, null => $n])->setSortable()->setFilterSelect($activeList);
$headerActive = $grid->getColumn('active')->headerPrototype;
$headerActive->class[] = 'center';
$grid->addColumnText('note', 'partnersModule.admin.grid.note')->setTruncate(30)->setSortable();
$headerNote = $grid->getColumn('note')->headerPrototype;
$headerNote->class[] = 'center';
// actions
$grid->addActionHref('delete', '', 'deletePartner!')->setIcon('trash')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("partnersModule.admin.grid.delete")]))->setConfirm(function ($u) {
return $this->tt("partnersModule.admin.grid.messages.rlyDelPartner", null, ["id" => $u->getId()]);
});
$grid->addActionHref('edit', '', 'updatePartner')->setIcon('pencil')->setElementPrototype(\Nette\Utils\Html::el("a")->addAttributes(["title" => $this->tt("partnersModule.admin.grid.update")]));
$grid->setOperation(["delete" => $this->tt("system.common.delete")], $this->partnersGridOpsHandler)->setConfirm("delete", $this->tt("partnersModule.admin.grid.messages.rlyDelPartnerItems"));
$grid->setFilterRenderType($this->filterRenderType);
$grid->setExport("admin-partners " . date("Y-m-d H:i:s", time()));
}
protected function createComponentSongList($name)
{
$grid = new Grid($this, $name);
$grid->setModel($this->songy->findAll());
$grid->addColumnDate("datum", "Datum", "d.m.y")->setSortable()->setFilterDateRange();
$grid->addColumnText("interpret_name", "Interpret")->setCustomRender(function ($item) {
return $item->interpret_name . ($item->interpret ? " " . Html::el('i')->addAttributes(['class' => 'fa fa-ticket', 'title' => 'Asociován s ' . $item->interpret->nazev]) : null);
})->setSortable()->setFilterText()->setSuggestion();
$grid->addColumnText("name", "Song")->setSortable()->setFilterText()->setSuggestion();
$filter = array('' => 'Všechny');
$filter = \Nette\Utils\Arrays::mergeTree($filter, $this->zanry->getList());
$grid->addColumnText("zanr_id", "Žánr")->setCustomRender(function ($item) {
return $item->zanr ? $item->zanr->name : null;
})->setFilterSelect($filter);
$grid->addColumnText("zadatel", "Přidal(a)")->setSortable()->setFilterText()->setSuggestion();
$statuses = array('' => 'Všechny', 'approved' => 'Zařazené', 'rejected' => 'Vyřazené', 'waiting' => 'Čekající');
$grid->addColumnText("status", "Status")->setCustomRender(function ($item) {
$status = $item->status;
$revizor = $item->revisor ? $item->ref("user", "revisor")->username : "******";
switch ($status) {
case "approved":
return Html::el("span", array("class" => "label label-success", "title" => "Schválil(a) " . $revizor))->setText("Zařazen");
case "waiting":
return Html::el("span", array("class" => "label label-warning", "title" => "Čeká ve frontě ke schválení"))->setText("Čeká");
case "rejected":
return Html::el("span", array("class" => "label label-danger", "title" => "Zamítl(a) " . $revizor))->setText("Vyřazen");
default:
return Html::el("i")->setText("Neznámý");
}
})->setSortable()->setFilterSelect($statuses);
$grid->addColumnText("pecka", "Pecka")->setReplacement(array(0 => '', 1 => Html::el('i')->addAttributes(['class' => 'fa fa-check'])))->setFilterCheck()->setCondition(" = 1");
$grid->addColumnText("instro", "Instro")->setReplacement(array(0 => '', 1 => Html::el('i')->addAttributes(['class' => 'fa fa-check'])))->setFilterCheck()->setCondition(" = 1");
$grid->addColumnText("remix", "Remix")->setReplacement(array(0 => '', 1 => Html::el('i')->addAttributes(['class' => 'fa fa-check'])))->setFilterCheck()->setCondition(" = 1");
$grid->addColumnNumber("likes", Html::el('i')->addAttributes(['class' => 'fa fa-heart']))->setCustomRender(function ($item) {
return $item->related("song_likes")->count();
});
$grid->addActionHref("editor", "Editovat")->setIcon("pencil");
$grid->addActionHref('delete', 'Smazat', 'deleteSong!')->setIcon('trash')->setConfirm('Opravdu chcete smazat tento song?');
$grid->setFilterRenderType(Filter::RENDER_OUTER);
$grid->setDefaultSort(array("datum" => "DESC"));
//Set face for grid
$gridTemplate = __DIR__ . "/../templates/components/Grid.latte";
if (file_exists($gridTemplate)) {
$grid->setTemplateFile($gridTemplate);
}
return $grid;
}
protected function createComponentGrid($name)
{
$grid = new Grid($this, $name);
$grid->setModel($this->entry->listAll());
$grid->addColumnText('lname', 'Příjmení')->setSortable()->setFilterText()->setSuggestion();
$grid->addColumnText('fname', 'Jméno')->setSortable()->setFilterText()->setSuggestion();
$grid->addColumnText('nick', 'Nick')->setFilterText();
$grid->addColumnText('registration', 'Reg.')->setSortable()->setFilterText();
$grid->addColumnText('si_number', 'SI')->setSortable()->setFilterText();
$grid->addColumnText('category', 'Kat.')->setColumn(function ($i) {
return $i->category['name'];
});
$grid->addColumnNumber('start', 'Start')->setSortable();
$grid->addColumnText('start_opt', 'Volby')->setColumn(function ($i) {
return self::$start_options[$i->start_opt];
});
$cats = $this->race->listCategories()->fetchPairs('id', 'name');
$catselect = array('' => '');
foreach ($cats as $k => $v) {
$catselect[$k] = $v;
}
$grid->addFilterSelect('category', 'Kat.', $catselect)->setColumn('category_id');
$grid->filterRenderType = \Grido\Components\Filters\Filter::RENDER_INNER;
$grid->setExport();
}
/**
* @param $name
* @return Grid
*/
protected function createComponentGrid($name)
{
$grid = new Grid($this, $name);
$grid->translator->lang = 'cs';
$fluent = $this->pagesRepository->getAll();
$pages = [];
foreach ($fluent as $pageRow) {
$pages[$pageRow->id] = $pageRow;
}
if (isset($grid->model)) {
$grid->model = $fluent;
}
$grid->addColumnNumber('id', 'ID');
$header = $grid->getColumn('id')->headerPrototype;
$header->style['width'] = '0.5%';
$grid->addColumnText('name', 'Název')->setFilterText()->setSuggestion();
$grid->getColumn('name')->headerPrototype->style['width'] = '80%';
$grid->addColumnText('active', 'Aktivní')->setCustomRender(function ($item) {
if ($item->active == 0) {
$i = Html::el('i', ['class' => 'glyphicon glyphicon-thumbs-down']);
$el = Html::el('a', ['class' => 'btn btn-danger btn-xs btn-mini ajax'])->href($this->presenter->link("active!", $item->id))->setHtml($i);
} else {
$i = Html::el('i', ['class' => 'glyphicon glyphicon-thumbs-up']);
$el = Html::el('a', ['class' => 'btn btn-success btn-xs btn-mini ajax'])->href($this->presenter->link("active!", $item->id))->setHtml($i);
}
return $el;
})->cellPrototype->class[] = 'center';
$grid->addColumnText('inMenu', 'Top menu')->setCustomRender(function ($item) {
$menuItems = (array) json_decode($item->inMenu);
if (!in_array('topMenu', $menuItems)) {
$i = Html::el('i', ['class' => 'glyphicon glyphicon-thumbs-down']);
$el = Html::el('a', ['class' => 'btn btn-danger btn-xs btn-mini ajax'])->href($this->presenter->link("inTopMenu!", $item->id))->setHtml($i);
} else {
$i = Html::el('i', ['class' => 'glyphicon glyphicon-thumbs-up']);
$el = Html::el('a', ['class' => 'btn btn-success btn-xs btn-mini ajax'])->href($this->presenter->link("inTopMenu!", $item->id))->setHtml($i);
}
return $el;
})->cellPrototype->class[] = 'center';
$grid->addActionHref('edit', '')->setIcon('pencil');
$grid->addActionEvent('delete', '')->setCustomRender(function ($item) {
if ($item->parent === 0 || $item->rgt - $item->lft > 1) {
$i = Html::el('i', ['class' => 'fa']);
$el = Html::el('span', ['class' => 'btn btn-xs btn-mini'])->setHtml($i);
} else {
$i = Html::el('i', ['class' => 'fa fa-trash']);
$el = Html::el('a', ['class' => 'btn btn-default btn-xs btn-mini ajax', 'data-grido-confirm' => "Opravdu chcete tuto položku odstranit?"])->href($this->presenter->link("delete!", $item->id))->setHtml($i);
}
return $el;
});
$grid->addActionEvent('moveup', '')->setCustomRender(function ($item) use($pages) {
$first = $item->parent == 0 || $item->lft - 1 == $pages[$item->parent]['lft'];
if ($first) {
$i = Html::el('i', ['class' => 'fa']);
$el = Html::el('span', ['class' => 'btn btn-xs btn-mini'])->setHtml($i);
} else {
$i = Html::el('i', ['class' => 'fa fa-arrow-up']);
$el = Html::el('a', ['class' => 'btn btn-default btn-xs btn-mini ajax'])->href($this->presenter->link("move!", $item->id, self::UP))->setHtml($i);
}
return $el;
});
$grid->addActionEvent('movedn', '')->setCustomRender(function ($item) use($pages) {
$last = $item->parent == 0 || $item->rgt + 1 == $pages[$item->parent]['rgt'];
if ($last) {
$i = Html::el('i', ['class' => 'fa']);
$el = Html::el('span', ['class' => 'btn btn-xs btn-mini'])->setHtml($i);
} else {
$i = Html::el('i', ['class' => 'fa fa-arrow-down']);
$el = Html::el('a', ['class' => 'btn btn-default btn-xs btn-mini ajax'])->href($this->presenter->link("move!", $item->id, self::DN))->setHtml($i);
}
return $el;
});
$grid->addActionHref('add', '')->setIcon('plus');
$grid->setDefaultSort(['lft' => 'ASC']);
$grid->setRememberState(TRUE);
$grid->setPrimaryKey('id');
$grid->setDefaultPerPage(50);
$grid->setRowCallback(function ($item, $tr) {
$tr->class[] = "level_{$item->level}";
return $tr;
});
$grid->filterRenderType = $this->filterRenderType;
$grid->setExport();
return $grid;
}
