Application\Users\Grid::init()

Complexity

Conditions	1
Paths	1

Size

Total Lines	22
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	15
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function init()
    {
        // Create Select
        $select = new Select();
        $select->select('u.*, u.id as uid, GROUP_CONCAT( ar.`name` SEPARATOR ", " ) AS rolesList')
            ->from('users', 'u')
            ->leftJoin('u', 'acl_users_roles', 'aur', 'u.`id` = aur.`userId`')
            ->leftJoin('aur', 'acl_roles', 'ar', 'ar.`id` = aur.`roleId`')
            ->groupBy('u.id');


        // Setup adapter
        $adapter = new SelectSource();
        $adapter->setSource($select);

        $this->setAdapter($adapter);
        $this->setDefaultLimit(25);
        $this->addAlias('id', 'u.id');
        $this->setAllowOrders(['login', 'email', 'status', 'id']);
        $this->setAllowFilters(['login', 'email', 'status', 'id', 'roleId']);
        return $this;
    }
}