/** * Get grids from the database. * * @param GetGridsEvent $event The subscribed event. * * @return void * * @SuppressWarnings(PHPMD.Superglobals) */ public static function getGrids(GetGridsEvent $event) { $model = $event->getModel(); $grids = $event->getGrids(); if ($model->type == 'semantic_html5') { $query = 'SELECT * FROM tl_columnset WHERE published=1 ORDER BY title'; $result = \Database::getInstance()->query($query); while ($result->next()) { $key = sprintf($GLOBALS['TL_LANG']['tl_content']['bootstrap_columns'], $result->columns); $grids[$key][$result->id] = $result->title; } } }
/** * Load all grids from the database. * * @param GetGridsEvent $event The subscribed event. * * @return void */ public static function getGrids(GetGridsEvent $event) { $model = $event->getModel(); $grids = $event->getGrids(); if ($model->type == 'colsetStart' || $model->type == 'subcolumns') { $query = 'SELECT * FROM tl_columnset WHERE published=1 AND columns=? ORDER BY title'; $columns = $model->sc_type; $result = \Database::getInstance()->prepare($query)->execute($columns); while ($result->next()) { $grids[$result->id] = $result->title; } } elseif ($model->type == 'formcolstart') { $query = 'SELECT * FROM tl_columnset WHERE published=1 AND columns=? ORDER BY title'; $columns = $model->fsc_type; $result = \Database::getInstance()->prepare($query)->execute($columns); while ($result->next()) { $grids[$result->id] = $result->title; } } }