/**
* @param group
* @return
* @throws Exception
*/
@Override
public String createGroup(Group group) throws Exception {
Group specificGroup = new Group(group);
try {
// Set supergroup specific Id
if (StringUtil.isDefined(group.getSuperGroupId())) {
// Get the user information
GroupRow gr = getOrganization().group.getGroup(idAsInt(group.getSuperGroupId()));
if (gr == null) {
throw new AdminException(
"DomainDriverManager.createGroup",
SilverpeasException.ERROR,
"admin.EX_ERR_GROUP_NOT_FOUND",
"group Id: '" + group.getSuperGroupId() + "'");
}
specificGroup.setSuperGroupId(gr.specificId);
}
// Set subUsers specific Id
specificGroup.setUserIds(
translateUserIdsToSpecificIds(idAsInt(group.getDomainId()), group.getUserIds()));
// Get a DomainDriver instance
DomainDriver domainDriver = this.getDomainDriver(idAsInt(group.getDomainId()));
// Update Group in specific domain
return domainDriver.createGroup(specificGroup);
} catch (AdminException e) {
throw new AdminException(
"DomainDriverManager.createGroup",
SilverpeasException.ERROR,
"admin.EX_ERR_UPDATE_GROUP",
"group Id: '" + group.getId() + "'",
e);
}
}
/** Get the list of children groups of the given group */
private ArrayList<AdminGroupInst> getChildrenGroupInst(
DomainDriverManager ddManager, String sFatherGroupId, Group[] aGroup) {
ArrayList<AdminGroupInst> alChildrenGroupInst = new ArrayList<AdminGroupInst>();
// Search the children group
for (Group anAGroup : aGroup) {
if (anAGroup.getSuperGroupId() != null && anAGroup.getSuperGroupId().equals(sFatherGroupId)) {
AdminGroupInst adminGroupInst = new AdminGroupInst();
adminGroupInst.setGroup(anAGroup);
adminGroupInst.setChildrenAdminGroupInst(
this.getChildrenGroupInst(ddManager, adminGroupInst.getGroup().getId(), aGroup));
alChildrenGroupInst.add(adminGroupInst);
}
}
return alChildrenGroupInst;
}
/** Convert Group to GroupRow */
private GroupRow group2GroupRow(Group group) {
GroupRow gr = new GroupRow();
gr.id = idAsInt(group.getId());
gr.specificId = group.getSpecificId();
gr.domainId = idAsInt(group.getDomainId());
gr.superGroupId = idAsInt(group.getSuperGroupId());
gr.name = group.getName();
gr.description = group.getDescription();
gr.rule = group.getRule();
return gr;
}
public String[] searchGroupsIds(
DomainDriverManager ddManager,
boolean isRootGroup,
String componentId,
String[] aProfileId,
Group modelGroup)
throws AdminException {
try {
// Get organization
ddManager.getOrganizationSchema();
GroupRow model = group2GroupRow(modelGroup);
// The Ids could be equal to -1 !!!! Put it to -2 if null
if (!StringUtil.isDefined(modelGroup.getId())) {
model.id = -2;
}
if (!StringUtil.isDefined(modelGroup.getDomainId())) {
model.domainId = -2;
}
if (!StringUtil.isDefined(modelGroup.getSuperGroupId())) {
model.superGroupId = -2;
}
int[] aRoleId = null;
if (aProfileId != null) {
aRoleId = new int[aProfileId.length];
for (int i = 0; i < aProfileId.length; i++) {
aRoleId[i] = idAsInt(aProfileId[i]);
}
}
// Get groups
return ddManager
.getOrganization()
.group
.searchGroupsIds(isRootGroup, idAsInt(componentId), aRoleId, model);
} catch (Exception e) {
throw new AdminException(
"GroupManager.searchGroupsIdsInGroup",
SilverpeasException.ERROR,
"admin.EX_ERR_GET_GROUPS_OF_DOMAIN",
e);
} finally {
ddManager.releaseOrganizationSchema();
}
}
/** Inserts in the database a new Group row. */
public int createGroup(Connection c, Group group) throws AdminException {
PreparedStatement statement = null;
int nextId = 0;
String theQuery =
"insert into "
+ drvSettings.getGroupTableName()
+ "("
+ getColumns()
+ ") values (?,?,?,?)";
try {
SilverTrace.debug("admin", "SQLGroupTable.createGroup", "root.MSG_QUERY", theQuery);
statement = c.prepareStatement(theQuery);
nextId =
DBUtil.getNextId(
drvSettings.getGroupTableName(), drvSettings.getGroupSpecificIdColumnName());
statement.setInt(1, nextId);
String gid = group.getSuperGroupId();
if ((gid == null) || (gid.length() <= 0) || (gid.equals("-1")))
statement.setNull(2, Types.INTEGER);
else statement.setInt(2, Integer.parseInt(gid));
statement.setString(3, drvSettings.trunc(group.getName(), 100));
statement.setString(4, drvSettings.trunc(group.getDescription(), 400));
statement.executeUpdate();
} catch (Exception e) {
throw new AdminException(
"SQLGroupTable.createGroup",
SilverpeasException.ERROR,
"root.EX_SQL_QUERY_FAILED",
"Query = " + theQuery,
e);
} finally {
DBUtil.close(statement);
}
return nextId;
}
/**
* @param ddManager
* @param modelGroup
* @param isAnd
* @return
* @throws AdminException
*/
public Group[] searchGroups(DomainDriverManager ddManager, Group modelGroup, boolean isAnd)
throws AdminException {
try {
// Get organization
ddManager.getOrganizationSchema();
GroupRow model = group2GroupRow(modelGroup);
// The Ids could be equal to -1 !!!! Put it to -2 if null
if (!StringUtil.isDefined((modelGroup.getId()))) {
model.id = -2;
}
if (!StringUtil.isDefined(modelGroup.getDomainId())) {
model.domainId = -2;
}
if (!StringUtil.isDefined(modelGroup.getSuperGroupId())) {
model.superGroupId = -2;
}
// Get groups
GroupRow[] grs = ddManager.getOrganization().group.searchGroups(model, isAnd);
// Convert GroupRow objects in Group Object
Group[] groups = new Group[grs.length];
for (int nI = 0; nI < grs.length; nI++) {
groups[nI] = groupRow2Group(grs[nI]);
// Get the selected users for this group
setDirectUsersOfGroup(ddManager, groups[nI]);
}
return groups;
} catch (Exception e) {
throw new AdminException(
"GroupManager.searchGroups",
SilverpeasException.ERROR,
"admin.EX_ERR_GET_GROUPS_OF_DOMAIN",
e);
} finally {
ddManager.releaseOrganizationSchema();
}
}
/**
* Update the given group
*
* @param ddManager
* @param group
* @param onlyInSilverpeas
* @return
* @throws AdminException
*/
public String updateGroup(DomainDriverManager ddManager, Group group, boolean onlyInSilverpeas)
throws AdminException {
ArrayList<String> alRemUsers = new ArrayList<String>();
ArrayList<String> alAddUsers = new ArrayList<String>();
if (group == null
|| !StringUtil.isDefined(group.getName())
|| !StringUtil.isDefined(group.getId())) {
if (group != null) {
SynchroReport.error(
"GroupManager.updateGroup()",
"Problème lors de maj du groupe "
+ group.getSpecificId()
+ " dans la base, ce groupe n'a pas de nom",
null);
}
return "";
}
try {
ddManager.getOrganizationSchema();
if (group.getDomainId() != null && !onlyInSilverpeas) {
ddManager.updateGroup(group);
}
// Get the group id
String sGroupId = group.getId();
String strInfoSycnhro;
if (group.getSuperGroupId() != null) {
strInfoSycnhro =
"Maj du groupe "
+ group.getName()
+ " (père="
+ getGroup(ddManager, group.getSuperGroupId()).getSpecificId()
+ ") dans la base (table ST_Group)...";
} else {
strInfoSycnhro =
"Maj du groupe "
+ group.getName()
+ " (groupe racine) dans la base (table ST_Group)...";
}
SynchroReport.info("GroupManager.updateGroup()", strInfoSycnhro, null);
// Update the group node
GroupRow gr = group2GroupRow(group);
ddManager.getOrganization().group.updateGroup(gr);
// index group information
ddManager.indexGroup(gr);
// Update the users if necessary
SynchroReport.info(
"GroupManager.updateGroup()",
"Maj éventuelle des relations du groupe "
+ group.getName()
+ " avec les utilisateurs qui y sont directement inclus (tables ST_Group_User_Rel)",
null);
String[] asOldUsersId =
ddManager.getOrganization().user.getDirectUserIdsOfGroup(idAsInt(sGroupId));
// Compute the remove users list
String[] asNewUsersId = group.getUserIds();
for (String anAsOldUsersId : asOldUsersId) {
boolean bFound = false;
for (String anAsNewUsersId : asNewUsersId) {
if (anAsOldUsersId.equals(anAsNewUsersId)) {
bFound = true;
}
}
if (!bFound) {
alRemUsers.add(anAsOldUsersId);
}
}
// Compute the add users list
for (String anAsNewUsersId : asNewUsersId) {
boolean bFound = false;
for (String anAsOldUsersId : asOldUsersId) {
if (anAsNewUsersId.equals(anAsOldUsersId)) {
bFound = true;
}
}
if (!bFound) {
alAddUsers.add(anAsNewUsersId);
}
}
// Remove the users that are not in this group anymore
for (String alRemUser : alRemUsers) {
ddManager
.getOrganization()
.group
.removeUserFromGroup(idAsInt(alRemUser), idAsInt(sGroupId));
}
// Add the new users of the group
for (String alAddUser : alAddUsers) {
ddManager.getOrganization().group.addUserInGroup(idAsInt(alAddUser), idAsInt(sGroupId));
}
SynchroReport.info(
"GroupManager.updateGroup()",
"Groupe : "
+ group.getName()
+ ", ajout de "
+ alAddUsers.size()
+ " nouveaux utilisateurs, suppression de "
+ alRemUsers.size()
+ " utilisateurs",
null);
return sGroupId;
} catch (Exception e) {
SynchroReport.error(
"GroupManager.updateGroup()",
"problème lors de la maj du groupe " + group.getName() + " - " + e.getMessage(),
null);
throw new AdminException(
"GroupManager.updateGroup",
SilverpeasException.ERROR,
"admin.EX_ERR_UPDATE_GROUP",
"group Id: '" + group.getId() + "'",
e);
} finally {
ddManager.releaseOrganizationSchema();
}
}
/**
* Add the given group in Silverpeas
*
* @param ddManager
* @param group
* @param onlyInSilverpeas
* @return
* @throws AdminException
*/
public String addGroup(DomainDriverManager ddManager, Group group, boolean onlyInSilverpeas)
throws AdminException {
if (group == null || !StringUtil.isDefined(group.getName())) {
if (group != null) {
SynchroReport.error(
"GroupManager.addGroup()",
"Problème lors de l'ajout du groupe "
+ group.getSpecificId()
+ " dans la base, ce groupe n'a pas de nom",
null);
}
return "";
}
try {
ddManager.getOrganizationSchema();
// Create group in specific domain (if onlyInSilverpeas is not true)
// if domainId=-1 then group is a silverpeas organization
if (!onlyInSilverpeas) {
String specificId;
if (group.getDomainId() != null) {
specificId = ddManager.createGroup(group);
group.setSpecificId(specificId);
}
}
// Create the group node in Silverpeas
GroupRow gr = group2GroupRow(group);
if (gr.superGroupId != -1) {
SynchroReport.info(
"GroupManager.addGroup()",
"Ajout du groupe "
+ group.getName()
+ " (père="
+ getGroup(ddManager, group.getSuperGroupId()).getSpecificId()
+ ") dans la table ST_Group",
null);
} else { // pas de père
SynchroReport.info(
"GroupManager.addGroup()",
"Ajout du groupe " + group.getName() + " (groupe racine) dans la table ST_Group...",
null);
}
ddManager.getOrganization().group.createGroup(gr);
String sGroupId = idAsString(gr.id);
// index group information
ddManager.indexGroup(gr);
// Create the links group_user in Silverpeas
SynchroReport.info(
"GroupManager.addGroup()",
"Inclusion des utilisateurs directement associés au groupe "
+ group.getName()
+ " (table ST_Group_User_Rel)",
null);
String[] asUserIds = group.getUserIds();
int nUserAdded = 0;
for (String asUserId : asUserIds) {
if (StringUtil.isDefined(asUserId)) {
ddManager.getOrganization().group.addUserInGroup(idAsInt(asUserId), idAsInt(sGroupId));
nUserAdded++;
}
}
SynchroReport.info(
"GroupManager.addGroup()",
nUserAdded + " utilisateurs ajoutés au groupe " + group.getName() + " dans la base",
null);
return sGroupId;
} catch (Exception e) {
SynchroReport.error(
"GroupManager.addGroup()",
"problème lors de l'ajout du groupe " + group.getName() + " - " + e.getMessage(),
null);
throw new AdminException(
"GroupManager.addGroup",
SilverpeasException.ERROR,
"admin.EX_ERR_ADD_GROUP",
"group name: '" + group.getName() + "'",
e);
} finally {
ddManager.releaseOrganizationSchema();
}
}