/**
* Initiate grid
*/
protected static function setGrid()
{
parent::$grid = ['grid' => ['id' => ['title' => 'Id', 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'int', 'style' => 'width: 60px;']], 'title' => ['title' => t('Title'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'type' => ['title' => t('Type'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'numberViews' => ['title' => t('Number Views'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'sticked' => ['title' => t('Sticked'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'null' => ['title' => t('Actions')]]];
}
/**
* Initiate grid
*/
protected static function setGrid()
{
parent::$grid = ['grid' => ['id' => ['title' => 'Id', 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'int', 'style' => 'width: 60px;']], 'name' => ['title' => t('Name'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'key' => ['title' => t('Key'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'subject' => ['title' => t('Subject'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'null' => ['title' => t('Actions')]]];
}
/**
* Initiate grid
*/
protected static function setGrid()
{
parent::$grid = ['grid' => ['name' => ['title' => t('Name'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'username' => ['title' => t('Username'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'email' => ['title' => t('Email'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'moderator' => ['title' => t('Moderator'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => 'width:100px']], 'admin' => ['title' => t('Admin'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => 'width:100px']], 'karma' => ['title' => t('Karma'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => 'width:100px']], 'status' => ['title' => t('Status'), 'order' => true, 'filter' => ['type' => 'select', 'sanitize' => 'int', 'using' => null, 'values' => Users::getStatusesWithLabels(), 'style' => 'width: 100px;']], 'null' => ['title' => t('Actions')]], 'query' => ['columns' => ['a.id', "CONCAT(a.firstname, ' ', a.lastname) as name ", 'a.username', 'a.gender', 'a.email', 'a.status', 'a.admin', 'a.moderator', 'a.karma'], 'joins' => [], 'groupBy' => 'a.id']];
}
protected static function setGrid()
{
parent::$grid = ['grid' => ['id' => ['title' => 'Id', 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'int', 'style' => 'width: 60px;']], 'name' => ['title' => t('Name'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'slug' => ['title' => t('Slug'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'description' => ['title' => t('Description'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'numberPosts' => ['title' => t('Number posts'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'null' => ['title' => t('Actions')]]];
}
/**
* Initiate grid
*/
protected static function setGrid()
{
parent::$grid = ['grid' => ['title' => ['title' => t('Title'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'username' => ['title' => t('Users'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'null' => ['title' => t('Actions')]], 'query' => ['columns' => ['a.id', 'a.title', 'a.sticked', 'u.username'], 'joins' => [['type' => 'join', 'model' => 'Phanbook\\Models\\Users', 'on' => 'a.usersId = u.id', 'alias' => 'u']], 'where' => 'a.type = "pages"']];
}
/**
* Initiate grid
*/
protected static function setGrid()
{
parent::$grid = ['grid' => ['id' => ['title' => t('Id'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'int', 'style' => 'width: 60px;']], 'key' => ['title' => t('Key'), 'order' => true, 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => '']], 'type' => ['title' => t('Type'), 'order' => true, 'filter' => ['type' => 'select', 'sanitize' => 'int', 'using' => null, 'values' => Configuration::getTypesWithLabels(), 'style' => 'width: 100px;']], 'value' => ['title' => t('Value'), 'filter' => ['type' => 'input', 'sanitize' => 'number', 'style' => 'width : 90px;']], 'caption' => ['title' => t('Caption'), 'filter' => ['type' => 'input', 'sanitize' => 'string', 'style' => ''], 'display_filter' => 'truncate'], 'null' => ['title' => t('Actions')]], 'actions' => ['delete' => ['title' => t('Delete selected'), 'class' => 'btn btn-sm btn-danger']]];
}
