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;
}
