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);
 }
Example #2
0
 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);
 }
Example #3
0
 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);
 }
Example #5
0
 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);
 }
Example #7
0
 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);
 }