public function __construct($parentPresenter) { parent::__construct($parentPresenter); $treeNodeId = $parentPresenter->getParam('id'); $identifier = $parentPresenter->getParam('identifier'); $defaultLang = $parentPresenter->langManagerService->getDefaultLanguage(); $where = array('tree_node_id' => $treeNodeId, 'identifier' => $identifier, 'lang' => $defaultLang); // dump($defaultLang); // die(); //$actualPage = $parentPresenter->pageManagerService->getLabel($labelId); // Create a query $ds = $this->connection->dataSource("SELECT \n [t].[ext_tree_node_id],\n [t].[identifier],\n [t].[tree_node_id],\n [p].[param_name]\n FROM \n [:core:ext_tree] [t]\n JOIN\n [:core:ext_params] [p]\n USING\n ([ext_tree_node_id])\n WHERE \n %and\n ", $where); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('param_name', 'Parametr [' . $defaultLang . ']'); $this->addColumn('identifier', 'Identifikátor'); // $this->addColumn('created', 'Datum vytvoření'); // $this->addColumn('login', 'Autor'); $this->keyName = 'ext_tree_node_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Editovat', 'ExtParam:editParam', clone $icon->class('icon icon-edit')->setText('Editovat')); $this->addAction('Delete', 'extParamConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat parametr'), TRUE); }
public function __construct($parentPresenter) { parent::__construct($parentPresenter); // Create a query $ds = $this->connection->dataSource("SELECT \n *\n FROM\n [:core:pages_autosave]\n WHERE\n [editor_id] = %i\n AND \n [tree_node_id] IS NULL\n ", $parentPresenter->userId); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('autosave_id', 'ID'); $this->addDateColumn('saved', 'Datum', '%H:%M %d.%m.%Y'); $this->keyName = 'autosave_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Pokračovat v práci', 'add', clone $icon->class('icon icon-pencil')->setText('Pokračovat v práci')); $this->addAction('Delete', 'conceptConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat koncept'), TRUE); }
public function __construct($parentPresenter) { parent::__construct($parentPresenter); // Create a query $ds = $this->connection->dataSource("SELECT \n *\n FROM\n [:core:users]\n "); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('user_id', 'ID'); $this->addColumn('login', 'Login'); $this->addColumn('email', 'E-mail'); $this->keyName = 'user_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Nastavit přístupy', 'setAcl', clone $icon->class('icon icon-key')->setText('Nastavit přístupy')); $this->addAction('Upravit uživatele', 'edit', clone $icon->class('icon icon-edit')->setText('Upravit uživatele')); //$this->addAction('Delete', 'conceptConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat koncept'), TRUE); }
public function __construct($parentPresenter) { parent::__construct($parentPresenter); // Create a query $ds = $this->connection->dataSource("SELECT \n * \n FROM \n [:core:languages] \n "); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('name', 'Jazyk'); $this->addColumn('code', 'Kód'); $this->addColumn('enabled', 'Povolen'); $this->keyName = 'language_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Nainstalovat', 'languageConfirmDialog:confirmInstall!', clone $icon->class('icon icon-install')->setText('Nainstalovat'), TRUE); $this->addAction('Odinstalovat', 'languageConfirmDialog:confirmUninstall!', clone $icon->class('icon icon-uninstall')->setText('Odinstalovat'), TRUE); //$this->addAction('Delete', 'movieConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat video'), TRUE); }
public function __construct($parentPresenter) { parent::__construct($parentPresenter); // Create a query $ds = $this->connection->dataSource('SELECT p.* FROM ( SELECT tree_node_id, MAX(version) version FROM cms_pages GROUP BY tree_node_id ) m INNER JOIN cms_pages p ON p.tree_node_id = m.tree_node_id AND p.version=m.version AND status = %s ', 'trashed'); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('page_id', 'ID'); $this->addColumn('name', 'Název'); $this->addDateColumn('created', 'Datum', '%H:%M %d.%m.%Y'); $this->keyName = 'page_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Obnovit', 'trashConfirmDialog:confirmRestore!', clone $icon->class('icon icon-reload-from-backup')->setText('Obnovit'), TRUE); $this->addAction('Delete', 'trashConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat stránku'), TRUE); }
public function __construct($parentPresenter) { parent::__construct($parentPresenter); $treeNodeId = $parentPresenter->getParam('id'); $actualPage = $parentPresenter->getModelPage()->getActualPage($treeNodeId); // Create a query $ds = $this->connection->dataSource("SELECT \n * \n FROM \n [:core:pages] \n JOIN\n [:core:users]\n USING \n ([user_id])\n WHERE \n [tree_node_id] = %i \n ORDER BY \n [created] DESC \n ", $treeNodeId); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('version', 'Číslo verze'); $this->addColumn('status', 'Status'); $this->addColumn('created', 'Datum vytvoření'); $this->addColumn('login', 'Autor'); $this->keyName = 'page_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Vrátit ze zálohy', 'backupConfirmDialog:confirmBackup!', clone $icon->class('icon icon-reload-from-backup')->setText('Vrátit ze zálohy'), TRUE); //$this->addAction('Delete', 'movieConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat video'), TRUE); }
public function __construct($parentPresenter) { parent::__construct($parentPresenter); $labelId = $parentPresenter->labelId; //$actualPage = $parentPresenter->pageManagerService->getLabel($labelId); // Create a query $ds = $this->connection->dataSource("SELECT \n * \n FROM \n [:core:label_ext_definitions] \n WHERE \n [label_id] = %i \n ", $labelId); // Create a data source $dataSource = new \DataGrid\DataSources\Dibi\DataSource($ds); // Configure data grid $this->setDataSource($dataSource); // Configure columns //$this->addNumericColumn('id', 'ID')->getHeaderPrototype()->style('width: 50px'); $this->addColumn('title', 'Titulek'); $this->addColumn('identifier', 'Identifikátor'); $this->addColumn('name', 'Jméno (konfigurační)'); // $this->addColumn('created', 'Datum vytvoření'); // $this->addColumn('login', 'Autor'); $this->keyName = 'ext_id'; $this->addActionColumn('Actions'); $icon = \Nette\Utils\Html::el('span'); $this->addAction('Editovat', 'Label:editExt', clone $icon->class('icon icon-edit')->setText('Editovat')); $this->addAction('Delete', 'extConfirmDialog:confirmDelete!', clone $icon->class('icon icon-del')->setText('Smazat rozšíření'), TRUE); }