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();
}
public function singleAction($id)
{
if ($entry = Entry::findOrFail($id)) {
if ($postData = $this->getPostData()) {
$postData['entry_id'] = $id;
Comment::create($postData);
return $this->redirect('singleEntry', array('id' => $id));
}
$entry['username'] = User::where('id', strval($entry['user_id']))->first()['name'];
$data['entry'] = $entry;
$data['comments'] = Comment::where('entry_id', $id)->get();
} else {
$data['error'] = 'Không tìm thấy bài viết';
}
return $this->render('entry/single.html.twig', $data);
}
public static function getCountBy($field, $value)
{
$entrys = Entry::where($field, $value);
return $entrys->count();
}
