public function onlyOneRole($id, $roleId) { $this->query('UPDATE user_role_access SET deleted_time = "' . date('Y-m-d H:i:s') . '" WHERE user_id = "' . $id . '"'); $this->query('UPDATE user_role_access SET deleted_time = NULL WHERE user_id = "' . $id . '" AND role_id = "' . $roleId . '"'); $userRoleAccess = new UserRoleAccess(); $userAccess = $userRoleAccess->find('first', array('conditions' => array('UserRoleAccess.role_id' => $roleId, 'UserRoleAccess.user_id' => $id))); if (empty($userAccess)) { $userRoleAccess->save(array('role_id' => $roleId, 'user_id' => $id)); } }