/**
* 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;
}
}
}