public function saveMenuAndRole()
 {
     if ($this->_one[$this->_paramKey]) {
         $roleId = $this->_one[$this->_paramKey];
         $this->_one->save();
     } else {
         $this->_one->save();
         $roleId = Yii::$app->db->getLastInsertID();
     }
     $menu = CRequest::param("menu");
     $select_menus = isset($menu['select_menus']) ? $menu['select_menus'] : '';
     # 如果存在role_id 和选择的菜单
     if ($roleId && $select_menus) {
         # 得到当前选择的menu_id和相应的所有上级menu_id
         $select_menu_ids = $this->getAllParentMenuIds($select_menus);
         $select_menu_ids = array_unique($select_menu_ids);
         # AdminRole中role_id 对应的所有 menu_id
         $role_menu_ids = $this->getDbRoleMenuIds($roleId);
         # 需要插入的role_id - menu_id   数组差集
         $add_role_menu_ids = array_diff($select_menu_ids, $role_menu_ids);
         # 需要删除的role_id - menu_id   数组差集
         $remove_role_menu_ids = array_diff($role_menu_ids, $select_menu_ids);
         # 事务  插入  和  删除   role_menu 表中,当前role_id 对应的menu_id
         $table = 'admin_role_menu';
         $columnsArr = ['menu_id', 'role_id', 'created_at', 'updated_at'];
         $valueArr = [];
         $now_date = date("Y-m-d H:i:s");
         if (!empty($add_role_menu_ids)) {
             foreach ($add_role_menu_ids as $menu_id) {
                 $valueArr[] = [$menu_id, $roleId, $now_date, $now_date];
             }
         }
         $innerTransaction = Yii::$app->db->beginTransaction();
         try {
             if (!empty($add_role_menu_ids)) {
                 \fec\helpers\CDB::batchInsert($table, $columnsArr, $valueArr);
             }
             AdminRoleMenu::deleteAll(['in', 'menu_id', $remove_role_menu_ids]);
             $innerTransaction->commit();
         } catch (Exception $e) {
             $innerTransaction->rollBack();
         }
     }
 }
 public function saveUserRole($user_id)
 {
     $role = CRequest::param("role");
     $role_ids = [];
     if (!empty($role)) {
         //var_dump($role);
         $innerTransaction = Yii::$app->db->beginTransaction();
         try {
             foreach ($role as $k => $role_id) {
                 $one = AdminUserRole::findOne(['role_id' => $role_id, 'user_id' => $user_id]);
                 $role_ids[] = $role_id;
                 if (!$one['id']) {
                     $one = new AdminUserRole();
                     $one->role_id = $role_id;
                     $one->user_id = $user_id;
                     $one->save();
                 }
             }
             $table = AdminUserRole::tableName();
             if (!empty($role_ids)) {
                 $role_str = implode(",", $role_ids);
                 $sql = "delete from {$table} where user_id = {$user_id} and role_id not in ({$role_str})";
             } else {
                 $innerTransaction->rollBack();
                 echo json_encode(["statusCode" => "300", "message" => "您至少要勾选一个用户权限组"]);
                 exit;
             }
             CDB::deleteBySql($sql);
             $innerTransaction->commit();
         } catch (Exception $e) {
             $innerTransaction->rollBack();
             echo json_encode(["statusCode" => "300", "message" => 'Save User Role Fail !']);
             exit;
         }
     } else {
         echo json_encode(["statusCode" => "300", "message" => "您至少要勾选一个用户权限组"]);
         exit;
     }
 }