protected function load()
{
//@TODO cache
if (!($dataItems = (new Query())->from($this->itemsTable)->orderBy(['order_index' => SORT_DESC])->indexBy('name')->all($this->connection))) {
throw new RBACException('Items is empty.');
}
static::$items = $dataItems;
$alias = Query::alias($this->rolesTable, $this->rolesTable);
//@TODO cache
if (!($dataRolesItems = (new Query())->select(SelectBuilder::selects([['roles' => ['name', 'type', 'description', 'data']], ['access_items' => ['name', 'type', 'description', 'data'], 'items']]))->from($this->rolesItemsTable)->innerJoin($this->itemsTable, "{$this->rolesItemsTable}.item = {$this->itemsTable}.name")->innerJoin($this->rolesTable, "{$this->rolesItemsTable}.role = {$alias}.name")->andWhere(["{$alias}.[[type]]" => RBACInterface::TYPE_ROLE])->orderBy(["{$alias}.[[order_index]]" => SORT_DESC])->asSubattributes()->all($this->connection))) {
return;
}
$result = [];
foreach ($dataRolesItems as $value) {
if (isset($result[$value['name']])) {
$result[$value['name']]['items'] = array_merge($result[$value['name']]['items'], (array) $value['items']['name']);
continue;
}
$value['items'] = [$value['items']['name']];
$result[$value['name']] = $value;
}
static::$items = ArrayHelper::toType(ArrayHelper::filterRecursive($result + static::$items, function ($value, $key) {
return !in_array($key, ['name'], true);
}));
}
