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;
            }
        }
    }
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;
            }
        }
    }
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 ; } } }
Load all grids from the database.

@param GetGridsEvent $event The subscribed event.

@return void
Load all grids from the database .