PHP AuthItem::model方法代码示例

 public function actionDelete($authItemName)
 {
     $authItemName = trim($authItemName);
     if ($authItemName == '') {
         return $this->result = errorHandler()->logException(null, -1, 'XUSER_ERR_ROLE_NAME_EMPTY', array('message' => 'Role name is empty'));
     }
     $authItem = AuthItem::model()->find('name=:name', array(':name' => $authItemName));
     if (!is_object($authItem)) {
         return $this->result = errorHandler()->logException(null, -1, 'XUSER_ERR_ROLE_NOT_FOUND', array('message' => 'Role is not found'));
     }
     // check if this role is system role
     if ($authItem->is_system == true) {
         return $this->result = errorHandler()->logException(null, -1, 'XUSER_ERR_ROLE_CANNOT_DELETE_BECAUSE_SYSTEM', array('message' => 'Cannot delete this role as it is a system role'));
     }
     // check if this role is assigned to any user
     $sql = 'SELECT COUNT(userid) FROM "' . SITE_ID . '_authassignment" WHERE itemname = \'' . $authItem->name . '\'';
     $count = app()->db->createCommand($sql)->queryScalar();
     if ($count > 0) {
         return $this->result = errorHandler()->logException(null, -1, 'XUSER_ERR_ROLE_CANNOT_DELETE_BECAUSE_ASSIGNED', array('message' => "Cannot delete this role as it's assigned to users"));
     }
     // delete the role
     if (!$authItem->delete()) {
         return $this->result = errorHandler()->logException(null, -1, 'XUSER_ERR_ROLE_DELETE_FAILED', array('message' => 'Deleting the role has been failed'));
     }
     return $this->result = array('result' => null, 'returnCode' => 1);
 }

 public function checkAccess($item_name)
 {
     //Если суперпользователь, то разрешено все
     if (isset(Yii::app()->user->role) && Yii::app()->user->role == AuthItem::ROLE_ROOT) {
         return true;
     }
     $auth_item = AuthItem::model()->findByPk($item_name);
     if (!$auth_item) {
         Yii::log('Задача $item_name не найдена!');
         return false;
     }
     if ($auth_item->allow_for_all) {
         return true;
     }
     if ($auth_item->task) {
         if ($auth_item->task->allow_for_all) {
             return true;
         } elseif (Yii::app()->user->checkAccess($auth_item->task->name)) {
             return true;
         }
     } else {
         if (Yii::app()->user->checkAccess($auth_item->name)) {
             return true;
         }
     }
     return false;
 }

 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param integer $id the ID of the model to be loaded
  * @return AuthItem the loaded model
  * @throws CHttpException
  */
 public function loadModel($id)
 {
     $model = AuthItem::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }

 public static function newRoleId()
 {
     $rows = AuthItem::model()->FindBySql('select CAST(SUBSTRING(name,11) as SIGNED INTEGER) + 1 AS name from AuthItem where name like "rolebyuser%" order by CAST(SUBSTRING(name,11) as SIGNED INTEGER) desc limit 1');
     $result = '1';
     if (count((array) $rows) > 0) {
         $result = $rows['name'];
     }
     return $result;
 }

 public function actionIndex()
 {
     $moduleId = $this->get('id', '');
     $model = Module::model()->find('name = :name', array(':name' => $moduleId));
     if ($model && $this->generateRoutes($moduleId)) {
         $features = $this->getFeatures($moduleId);
     }
     $roles = AuthItem::model()->findAll('type = 2');
     $this->render('index', array('model' => $model, 'features' => $features, 'roles' => $roles));
 }

 public function checkAccess($auth_item_name, $params = array(), $allow_caching = true)
 {
     return true;
     if (Yii::app()->user->isRootRole()) {
         return true;
     }
     $auth_item = AuthItem::model()->findByPk($auth_item_name);
     if ($auth_item && $auth_item['allow_for_all']) {
         return true;
     }
     return parent::checkAccess($auth_item_name, $params, $allow_caching);
 }

 public function checkName()
 {
     if ($this->isNewRecord) {
         if (AuthItem::model()->exists('name=LOWER(:name)', array(':name' => strtolower($this->name)))) {
             $this->addError('name', at('Sorry, That name is already in use.'));
         }
     } else {
         if (AuthItem::model()->exists('name=LOWER(:name) AND id!=:id', array(':id' => $this->id, ':name' => strtolower($this->name)))) {
             $this->addError('name', at('Sorry, That name is already in use.'));
         }
     }
 }

    public function loadModel($name)
    {
        $model = AuthItem::model()->findByAttributes(array(
            'name' => $name,
            'type' => CAuthItem::TYPE_ROLE
        ));

        if (!$model)
        {
            $this->pageNotFound();
        }

        return $model;
    }

 public function actionAssignment()
 {
     $model = new Authassignment();
     if (isset($_POST['Authassignment'])) {
         $model->attributes = $_POST['Authassignment'];
         if ($model->validate()) {
             //$this->saveModel($model);
             //$this->redirect(array('view','itemname'=>$model->itemname, 'userid'=>$model->userid));
             $auth = Yii::app()->authManager;
             $auth->assign($model->itemname, $model->userid, $model->bizrule, $model->data);
         }
     }
     $user = User::model()->findAll();
     $item = AuthItem::model()->findAll(array('condition' => 'type=2'));
     $this->render('assignment', array('model' => $model, 'user' => $user, 'item' => $item));
 }

 /**
  * 删除所有的action操作
  * 写着玩的，不可随意执行，会把所有的operation删掉，并且删除这么operation和用户、角色之间的所有关系
  * 但是也可以随便执行，因为AR模式在这里执行不了，提供个思路，哈哈。
  */
 public function clearOpers()
 {
     $criteria = new CDbCriteria();
     $criteria->condition = "type = 0";
     $actions = AuthItem::model()->findAll($criteria);
     foreach ($actions as $key => $action) {
         $criteria_child = new CDbCriteria();
         $criteria_child->condition = "child = '{$action->name}'";
         $flag = ItemChildren::model()->deleteAll($criteria_child);
         if ($flag > 0) {
             if ($action->delete()) {
                 echo "{$action->name} delete success\n";
             } else {
                 echo "{$action->name} delete failed\n";
             }
         }
     }
 }

 /**
  * Загрузка данных из бд и распределение их по спискам
  */
 private function getData()
 {
     $userAssign = CHtml::listData(AuthAssignment::model()->findAllByAttributes(['userid' => $this->user->id]), 'itemname', 'userid');
     $authItems = AuthItem::model()->findAll(['order' => 'type DESC, description ASC']);
     foreach ((array) $authItems as $item) {
         $this->itemsGroupedByTypes[$item->type][$item->name] = $item;
         $this->itemsList[$item->name] = $item;
         // если проверять каждый элемент, то генерируется огромное количество запросов, но получается правильное дерево с отмеченными дочерними элементами
         // созможно стоит при сохранении ролей что-то придумать
         $this->permissionList[$item->name] = isset($userAssign[$item->name]);
         //Yii::app()->authManager->checkAccess($item->name, $this->user->id);
     }
     $authItemsChild = AuthItemChild::model()->findAll();
     foreach ((array) $authItemsChild as $item) {
         $this->hierarchy[$item->parent][] = $item->child;
         $this->wereChildren[] = $item->child;
     }
 }

 /**
  * Check if we have the access keys in the db
  *
  */
 public function checkAccess($operation, $params = array())
 {
     // First make sure we haven't already added it
     // without looking in the db
     $missingRoles = array();
     if (Yii::app()->cache) {
         $missingRoles = Yii::app()->cache->get('missing_roles');
         if ($missingRoles === false) {
             $missingRoles = array();
         }
     }
     // Do we have that roles in the array
     if (!in_array($operation, $missingRoles)) {
         // We don't so look up the db
         $roleExists = AuthItem::model()->find('name=:name', array(':name' => $operation));
         if (!$roleExists) {
             // Figure out the type first
             if (strpos($operation, 'op_') !== false) {
                 $type = CAuthItem::TYPE_OPERATION;
             } elseif (strpos($operation, 'task_') !== false) {
                 $type = CAuthItem::TYPE_TASK;
             } else {
                 $type = CAuthItem::TYPE_ROLE;
             }
             // Create new auth item
             Yii::app()->authManager->createAuthItem($operation, $type, $operation, null, null);
         }
         $missingRoles[$operation] = $operation;
         // Save
         if (Yii::app()->cache) {
             Yii::app()->cache->set('missing_roles', $missingRoles);
         }
     }
     // In case we are in debug mode then return true all the time
     if (YII_DEBUG) {
         return true;
     }
     // Return parent check access
     return parent::checkAccess($operation, $params);
 }

 protected function getModulesTasks()
 {
     $tasks = array();
     $modules = AppManager::getModulesNames();
     foreach ($modules as $module_name => $module_desc) {
         $operations = array();
         $module_actions = AppManager::getModuleActions(ucfirst($module_name) . 'Module');
         foreach ($module_actions as $controller => $actions) {
             $prefix = str_replace('Controller', '', $controller);
             foreach ($actions as $name => $description) {
                 $name = $prefix . '_' . $name;
                 $exists = AuthItem::model()->exists(" name = '{$name}' AND type = '" . CAuthItem::TYPE_OPERATION . "'");
                 $operations[] = array('name' => $name, 'description' => $description, 'exists' => $exists);
             }
         }
         $exists = AuthItem::model()->exists(" name = '{$module_name}' AND type = '" . CAuthItem::TYPE_TASK . "'");
         $tasks[] = array('exists' => $exists, 'name' => $module_name, 'description' => $module_desc, 'operations' => $operations);
     }
     return $tasks;
 }

    function actionTest1()
    {
        $criteria = new CDbCriteria();
        $criteria->select = array('name', 'description');
        $criteria->with = array('authassignments' => array('select' => array('itemname', 'IF(name = itemname,true,false) AS Checked'), 'joinType' => 'LEFT JOIN', 'on' => 'itemname = name and userid = :userid', 'params' => array(':userid' => '1')));
        $criteria->condition = 'type = 2';
        //  $rows = AuthItem::model()->with(array('authassignments'=>array('together'=>false)))->FindAll();
        //  $rows = AuthAssignment::model()->with('users','authitems','authitems.authitemchildren')->FindAll();
        //  $rows  = User::model()->with('authitems')->FindAll();
        $rows = AuthItem::model()->with('authassignments')->FindAll();
        //  var_dump($rows[1]['authassignments']);
        $connection = Yii::app()->db;
        $sql = 'SELECT ai.NAME,
ai.description,
itemname,
IF (ai.NAME = itemname,true,false) AS Checked
FROM AuthItemChild RIGHT JOIN AuthItem ai ON parent = NAME LEFT JOIN AuthAssignment ON itemname = ai.NAME AND userid = 1 WHERE (
NOT parent IN (
SELECT b.child
FROM AuthItemChild b
)
OR (parent IS NULL)
)
AND ai.type = 2
GROUP BY ai.NAME
ORDER BY ai.NAME';
        $command = $connection->createCommand();
        $command->select(['NAME', 'description', 'itemname', 'IF (NAME = itemname,true,false) AS Checked'])->from(['AuthItem'])->leftJoin('AuthItemChild', 'parent = NAME')->leftJoin('AuthAssignment', ['and', 'itemname = NAME', 'userid = :userid'], [':userid' => '1'])->andWhere('not parent in (SELECT b.child FROM AuthItemChild b ) OR (parent IS NULL)')->andWhere('type=:type', [':type' => '2'])->group(['NAME'])->order(['NAME']);
        var_dump($command->join);
        var_dump($command->params);
        //var_dump($command->pdoStatement->getColumnMeta(0));
        $rows = [];
        $rows = $command->queryAll();
        var_dump($command->pdoStatement);
        //  var_dump($rows);
        // Print Rows
        if (count((array) $rows) > 0) {
            echo '<table style="border-collapse: collapse;"><tbody>';
            echo '<tr>';
            foreach (array_keys($rows[0]) as $field) {
                echo '<th style="padding: 5px; border: 1px solid black; min-width: 50px;">' . $field . '</th>';
            }
            echo '</tr>';
            foreach ($rows as $row) {
                echo '<tr>';
                foreach ($row as $cell) {
                    echo '<td style="padding: 5px; border: 1px solid black; min-width: 50px;">' . $cell . '</td>';
                }
                echo '</tr>';
            }
            echo '</tbody></table>';
        } else {
            echo 'empty rows';
        }
        /*     if (count((array) $rows) > 0) {
               echo '<table style="border-collapse: collapse;"><tbody>';
               echo '<tr>';
               foreach (array_keys($rows[0]->attributes) as $field)
               echo '<th style="padding: 5px; border: 1px solid black; min-width: 50px;">' . $field . '</th>';
               echo '</tr>';
               foreach ($rows as $row) {
               echo '<tr>';
               foreach ($row->attributes as $cell)
               echo '<td style="padding: 5px; border: 1px solid black; min-width: 50px;">' . $cell . '</td>';
               echo '</tr>';
               }
               echo '</tbody></table>';
               } else
               echo 'empty rows'; */
    }

 public function actionListAuthItem($userid)
 {
     $this->renderPartial('../item/_authitem_opt', array('authItem' => AuthItem::model()->listNotAssignedItem($userid)));
 }