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(); }