unset($_POST); } } else { Message::register(new Message(Message::SUCCESS, i18n(array('en' => 'User updated successfully', 'zh' => '用户更新成功')))); } // update user-role if (is_backend()) { if (!empty($roles)) { // delete existing relationships for user - role if update if (!empty($uid)) { $urs = SiteUserRole::findByUid($uid); foreach ($urs as $ur) { $ur->delete(); } } // create new relationships for user - role foreach ($roles as $rid => $val) { if ($val) { $ur = new SiteUserRole(); $ur->setRoleId($rid); $ur->setUserId($user->getId()); $ur->save(); } } } } } else { Message::register(new Message(Message::DANGER, i18n(array('en' => 'Sorry, there is a system error when processing your request', 'zh' => '抱歉,系统出错了')))); } } }
if ($command == "import" && $arg1 == "db" && (is_null($arg2) || $arg2 == "site_role")) { //- create tables if not exits echo " - Create table 'site_role' "; echo SiteRole::createTableIfNotExist() ? "success\n" : "fail\n"; } //-- SitePermissionRole:Clear cache if ($command == "cc") { if ($arg1 == "all" || $arg1 == "siteuser") { echo " - Drop table 'site_permission_role' "; echo SitePermissionRole::dropTable() ? "success\n" : "fail\n"; } } //-- SitePermissionRole:Import DB if ($command == "import" && $arg1 == "db" && (is_null($arg2) || $arg2 == "site_permission_role")) { //- create tables if not exits echo " - Create table 'site_permission_role' "; echo SitePermissionRole::createTableIfNotExist() ? "success\n" : "fail\n"; } //-- SiteUserRole:Clear cache if ($command == "cc") { if ($arg1 == "all" || $arg1 == "siteuser") { echo " - Drop table 'site_user_role' "; echo SiteUserRole::dropTable() ? "success\n" : "fail\n"; } } //-- SiteUserRole:Import DB if ($command == "import" && $arg1 == "db" && (is_null($arg2) || $arg2 == "site_user_role")) { //- create tables if not exits echo " - Create table 'site_user_role' "; echo SiteUserRole::createTableIfNotExist() ? "success\n" : "fail\n"; }
public function getRoles() { $urs = SiteUserRole::findByUid($this->getId()); $role_ids = array(); foreach ($urs as $ur) { $role_ids[] = $ur->getRoleId(); } global $mysqli; $query = "SELECT * FROM site_role WHERE id IN (" . implode(',', $role_ids) . ")"; $result = $mysqli->query($query); $rtn = array(); while ($result && ($b = $result->fetch_object())) { $obj = new SiteRole(); DBObject::importQueryResultToDbObject($b, $obj); $rtn[] = $obj; } return $rtn; }