Application\Roles\Table

Complexity

Total Complexity

6

Size/Duplication

Total Lines	94
Duplicated Lines	15.96 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getRoles()	0	4	1
A	getBasicRoles()	0	4	1
A	getUserRoles()	0	10	1
A	init()	0	5	1
A	getUserRolesIdentity()	15	15	2

<?php
/**
 * @copyright Bluz PHP Team
 * @link https://github.com/bluzphp/skeleton
 */

/**
 * @namespace
 */
namespace Application\Roles;

use Bluz\Proxy\Cache;
use Bluz\Proxy\Db;

/**
 * Class Table
 *
 * @package  Application\Roles
 *
 *
 * @method   static Row findRow($primaryKey)
 * @method   static Row findRowWhere($whereList)
 */
class Table extends \Bluz\Db\Table
{
    const BASIC_ADMIN = 'admin';
    const BASIC_GUEST = 'guest';
    const BASIC_MEMBER = 'member';
    const BASIC_SYSTEM = 'system';

    /**
     * Table
     *
     * @var string
     */
    protected $name = 'acl_roles';

    /**
     * Primary key(s)
     * @var array
     */
    protected $primary = array('id');

    /**
     * @var array
     */
    protected $basicRoles = ['admin', 'guest', 'member', 'system'];

    /**
     * Init table relations
     * @return void
     */
    public function init()
    {
        $this->linkTo('id', 'UsersRoles', 'roleId');
        $this->linkToMany('Users', 'UsersRoles');
    }

    /**
     * Get all roles in system
     *
     * @return array
     */
    public function getRoles()
    {
        return self::fetch("SELECT * FROM acl_roles ORDER BY id");
    }

    /**
     * Get all basic roles
     *
     * @return array
     */
    public function getBasicRoles()
    {
        return $this->basicRoles;
    }

    /**
     * Get all user roles in system
     *
     * @param integer $userId
     * @return array of rows
     */
    public function getUserRoles($userId)
    {
        $data = self::fetch(
            "SELECT r.*
            FROM acl_roles AS r, acl_users_roles AS u2r
            WHERE r.id = u2r.roleId AND u2r.userId = ?",
            array($userId)
        );
        return $data;
    }

    /**
     * Get all user roles in system
     *
     * @param integer $userId
     * @return array of identity
     */
    public function getUserRolesIdentity($userId)

This method seems to be duplicated in your project.

    {
        $cacheKey = 'users.roles.'.$userId;
        if (!$data = Cache::get($cacheKey)) {
            $data = Db::fetchColumn(
                "SELECT r.id
                FROM acl_roles AS r, acl_users_roles AS u2r
                WHERE r.id = u2r.roleId AND u2r.userId = ?
                ORDER BY r.id ASC",
                array($userId)
            );
            Cache::set($cacheKey, $data, Cache::TTL_NO_EXPIRY, ['system', 'users', 'roles']);
        }
        return $data;
    }
}