Sets default sorting.
|
public setDefaultSort ( array $sort ) : |
||
| $sort | array | |
| Résultat | ||
/**
* Builds listing grid
*
* @param string|null $name
* @return Grid
* @throws \Grido\Exception
*/
public function createComponentDataGrid($name = NULL)
{
$data = $this->generateDataForGrid();
$dataGrid = new Grid($this, $name);
$dataGrid->setRowCallback(function ($row, $tr) {
/** @var Nette\Utils\Html $tr */
if (empty($row['translation'])) {
$tr->attrs['class'][] = 'untranslated';
}
return $tr;
});
$dataGrid->setFilterRenderType(Filter::RENDER_INNER);
$dataGrid->setModel(new ArraySource($data));
$dataGrid->addActionHref('remove', 'Remove', 'remove');
$dataGrid->setDefaultSort(array('translation' => 'ASC'));
// Columns
$catalogueColumn = $dataGrid->addColumnText('catalogue', 'Catalogue');
$catalogueColumn->setCustomRender(function ($values) {
return ucfirst($values['catalogue']);
});
$catalogueColumn->setFilterSelect($this->getCataloguesInModel($data));
$catalogueColumn->setSortable();
$dataGrid->addColumnText('id', 'Code')->setSortable()->setFilterText();
$translationColumn = $dataGrid->addColumnText('translation', 'Translation');
$translationColumn->setFilterText();
$translationColumn->setCustomRender(function ($values) {
$el = Nette\Utils\Html::el('textarea');
$el->addAttributes(array('type' => 'text', 'class' => 'text', 'rows' => 1, 'data-translation-control-change-url' => $this->link('saveTranslation!', array('catalogue' => $values['catalogue'], 'code' => $values['id'], 'language' => $this->locale))));
$el->add(str_replace('|', "|\n", $values['translation']));
return $el;
});
return $dataGrid;
}
protected function createComponentSongList($name)
{
$grid = new Grido\Grid($this, $name);
$grid->setModel($this->songy);
$grid->addColumnDate("datum", "Datum", "d.m.y")->setSortable();
$grid->addColumnText("interpret_name", "Interpret")->setCustomRender(function ($item) {
$template = $this->createTemplate();
$template->setFile(__DIR__ . "/../templates/components/Grid/interpret.latte");
$template->song = $item;
return $template;
})->setSortable()->setFilterText()->setSuggestion();
$grid->addColumnText("name", "Song")->setCustomRender(function ($item) {
$template = $this->createTemplate();
$template->setFile(__DIR__ . "/../templates/components/Grid/song.latte");
$template->song = $item;
return $template;
})->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)")->setCustomRender(function ($item) {
$template = $this->createTemplate();
$template->setFile(__DIR__ . "/../templates/components/Grid/zadatel.latte");
$template->song = $item;
return $template;
})->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("vzkaz", "Vzkaz DJovi")->setCustomRender(function ($item) {
$elm = Html::el("span");
if ($item->private_vzkaz) {
if (!$this->user->isAllowed("privateMsg", "view") && $this->user->id != $item->user_id) {
$elm->addAttributes(array("class" => "msg-hidden", "title" => "Tento vzkaz je určen pouze pro DJe"));
$elm->setText("Soukromý vzkaz");
return $elm;
}
$elm->addAttributes(array("class" => "msg-private", "title" => "Tento vzkaz je určen pouze pro DJe"));
$elm->setText($item->vzkaz);
} else {
return $item->vzkaz;
}
return $elm;
});
$myLikes = $this->songList->getMyLikes($this->user);
$grid->addColumnText("likes", "")->setCustomRender(function ($item) use($myLikes) {
$likes = count($item->related('song_likes'));
$isLiked = isset($myLikes[$item->id]) ?: false;
$el = Html::el('a')->addAttributes(['class' => 'like' . ($isLiked ? ' liked' : '')]);
$el->add(Html::el('i')->addAttributes(['class' => 'glyphicon glyphicon-heart']));
$el->add(Html::el()->setText(' ' . $likes));
$el->href($this->link('like!', ['id' => $item->id]));
return $el;
});
if ($this->user->isAllowed("song", "approve")) {
$grid->addActionHref("approve", "")->setIcon("ok")->setElementPrototype(Html::el("a", array("class" => "btn btn-success", "data-toggle" => "modal", "data-target" => ".modal")));
}
if ($this->user->isAllowed("song", "reject")) {
$grid->addActionHref("reject", "")->setIcon("remove")->setElementPrototype(Html::el("a", array("class" => "btn btn-danger", "data-toggle" => "modal", "data-target" => ".modal")));
}
if ($this->user->isAllowed("song", "play")) {
$grid->addActionHref("play", "")->setDisable(function ($item) {
if ($item->link) {
return false;
}
return true;
})->setIcon("play")->setElementPrototype(Html::el("a", array("class" => "btn btn-info", "data-toggle" => "modal", "data-target" => ".modal")));
}
if ($this->user->isAllowed("song", "edit")) {
$grid->addActionHref("edit", "", "admin:song:editor")->setIcon("pencil")->setElementPrototype(Html::el("a", array("class" => "btn btn-default", "target" => "_blank")));
}
$grid->setFilterRenderType(\Grido\Components\Filters\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;
}
/**
* @param $name
* @return Grid
* @throws \Grido\Exception
*/
protected function createComponentGrid($name)
{
$grid = new Grid($this, $name);
$grid->translator->lang = 'cs';
$fluent = $this->newsRepository->getAll();
$grid->model = $fluent;
$grid->addColumnText('title', 'Titulek')->setSortable()->setFilterText();
$grid->getColumn('title')->headerPrototype->style['width'] = '65%';
$grid->addColumnDate('dateAdd', 'Datum')->setSortable()->setFilterText();
$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->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'])->href($this->presenter->link("delete!", $item->id))->setHtml($i);
return $el;
});
$grid->addActionHref('edit', '')->setIcon('pencil');
$grid->setDefaultSort(['dateAdd' => 'DESC']);
$grid->setDefaultPerPage(50);
$grid->filterRenderType = $this->filterRenderType;
$grid->setExport();
return $grid;
}
/**
* @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;
}
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;
}
/**
* @param $name
* @return Grid
* @throws \Grido\Exception
*/
protected function createComponentGrid($name)
{
$grid = new Grid($this, $name);
$grid->translator->lang = 'cs';
$fluent = $this->commentsRepository->getAll();
$grid->model = $fluent;
$grid->addColumnText('author', 'Autor')->setSortable()->setFilterText();
$grid->addColumnDate('date', 'Datum')->setSortable()->setFilterText();
$grid->addColumnText('allowed', 'Schváleno')->setCustomRender(function ($item) {
if ($item['allowed'] === 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("allowed!", $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("allowed!", $item['id']))->setHtml($i);
}
return $el;
})->cellPrototype->class[] = 'center';
$grid->addColumnText('text', 'Text')->setCustomRender(function ($item) {
$el = Html::el('span')->setText(Strings::substring($item['text'], 0, 80));
return $el;
});
$grid->getColumn('text')->headerPrototype->style['width'] = '90%';
$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'])->href($this->presenter->link("delete!", $item['id']))->setHtml($i);
return $el;
});
$grid->setDefaultSort(['date' => 'DESC']);
$grid->setDefaultPerPage(50);
$grid->filterRenderType = $this->filterRenderType;
$grid->setExport();
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;
}
