private void _buildParentGroupsBreadcrumb(
LayoutSet layoutSet, PortletURL portletURL, ThemeDisplay themeDisplay, StringBundler sb)
throws Exception {
Group group = layoutSet.getGroup();
if (group.isOrganization()) {
Organization organization =
OrganizationLocalServiceUtil.getOrganization(group.getOrganizationId());
Organization parentOrganization = organization.getParentOrganization();
if (parentOrganization != null) {
Group parentGroup = parentOrganization.getGroup();
LayoutSet parentLayoutSet =
LayoutSetLocalServiceUtil.getLayoutSet(
parentGroup.getGroupId(), layoutSet.isPrivateLayout());
_buildParentGroupsBreadcrumb(parentLayoutSet, portletURL, themeDisplay, sb);
}
} else if (group.isUser()) {
User groupUser = UserLocalServiceUtil.getUser(group.getClassPK());
List<Organization> organizations =
OrganizationLocalServiceUtil.getUserOrganizations(groupUser.getUserId(), true);
if (!organizations.isEmpty()) {
Organization organization = organizations.get(0);
Group parentGroup = organization.getGroup();
LayoutSet parentLayoutSet =
LayoutSetLocalServiceUtil.getLayoutSet(
parentGroup.getGroupId(), layoutSet.isPrivateLayout());
_buildParentGroupsBreadcrumb(parentLayoutSet, portletURL, themeDisplay, sb);
}
}
int layoutsPageCount = 0;
if (layoutSet.isPrivateLayout()) {
layoutsPageCount = group.getPrivateLayoutsPageCount();
} else {
layoutsPageCount = group.getPublicLayoutsPageCount();
}
if ((layoutsPageCount > 0) && !group.getName().equals(GroupConstants.GUEST)) {
String layoutSetFriendlyURL = PortalUtil.getLayoutSetFriendlyURL(layoutSet, themeDisplay);
sb.append("<li><span><a href=\"");
sb.append(layoutSetFriendlyURL);
sb.append("\">");
sb.append(HtmlUtil.escape(group.getDescriptiveName()));
sb.append("</a></span></li>");
}
}
public Collection<Student> getStudentsFromGroup(Group group, int year) throws SQLException {
Collection<Student> students = new ArrayList<Student>();
PreparedStatement stmt = null;
ResultSet rs = null;
try {
stmt =
con.prepareStatement(
"SELECT student_id, firstName, patronymic, surName, "
+ "sex, dateOfBirth, group_id, educationYear FROM students "
+ "WHERE group_id=? AND educationYear=? "
+ "ORDER BY surName, firstName, patronymic");
stmt.setInt(1, group.getGroupId());
stmt.setInt(2, year);
rs = stmt.executeQuery();
while (rs.next()) {
Student st = new Student(rs);
students.add(st);
}
} finally {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
}
return students;
}
public static Group copyGroupWithoutContacts(Group g) {
Group newGroup = new Group(g.getText());
newGroup.setGroupId(g.getGroupId());
newGroup.setMode(g.getMode());
newGroup.setExpandFlag(g.isExpanded());
return newGroup;
}
public void withRealmGroupTest() {
Group g = new Group(1L, "g1", "group description", true, "ldap", "dn=o");
assertEquals(g.getGroupId(), 1L);
assertEquals(g.getGroupName(), "g1");
assertEquals(g.getDescription(), "group description");
assertTrue(g.isNewUserDefault());
assertEquals(g.getRealm(), "ldap");
assertEquals(g.getRealmAttributes(), "dn=o");
}
public void simpleGroupTest() {
Group g = new Group(1L, "g1", null, false, null, null);
assertEquals(g.getGroupId(), 1L);
assertEquals(g.getGroupName(), "g1");
assertNull(g.getDescription());
assertFalse(g.isNewUserDefault());
assertNull(g.getRealm());
assertNull(g.getRealmAttributes());
}
public void moveStudentsToGroup(Group oldGroup, int oldYear, Group newGroup, int newYear)
throws SQLException {
PreparedStatement stmt = null;
try {
stmt =
con.prepareStatement(
"UPDATE students SET group_id=?, educationYear=? "
+ "WHERE group_id=? AND educationYear=?");
stmt.setInt(1, newGroup.getGroupId());
stmt.setInt(2, newYear);
stmt.setInt(3, oldGroup.getGroupId());
stmt.setInt(4, oldYear);
stmt.execute();
} finally {
if (stmt != null) {
stmt.close();
}
}
}
/**
* @param options see enum UnitCommandOptions
* @param timeOut At which frame the command will time-out and consequently be removed, if
* execution of it has not yet begun. Can only be set locally, is not sent over the network,
* and is used for temporary orders. default: MAX_INT (-> do not time-out) example:
* currentFrame + 15
*/
@Override
public void addToGroup(Group toGroup, short options, int timeOut) throws CallbackAIException {
int _ret_int;
int toGroupId = toGroup.getGroupId();
_ret_int = innerCallback.Unit_addToGroup(this.getUnitId(), toGroupId, options, timeOut);
if (_ret_int != 0) {
throw new CallbackAIException("addToGroup", _ret_int);
}
}
public void removeStudentsFromGroup(Group group, int year) throws SQLException {
PreparedStatement stmt = null;
try {
stmt = con.prepareStatement("DELETE FROM students WHERE group_id=? AND educationYear=?");
stmt.setInt(1, group.getGroupId());
stmt.setInt(2, year);
stmt.execute();
} finally {
if (stmt != null) {
stmt.close();
}
}
}
@Override
public void insertContractors(JTable table, Group group, User user) {
DefaultTableModel model = (DefaultTableModel) table.getModel();
String data[] = new String[6];
for (int i = 0; i < model.getRowCount(); i++) {
Boolean selected = (Boolean) model.getValueAt(i, 0);
if (selected) {
for (int j = 1; j < model.getColumnCount(); j++)
data[j - 1] = model.getValueAt(i, j).toString();
Contractor contractor =
new Contractor(
group.getGroupId(), user.getUserId(), data[0], data[1], data[2], data[3], data[4]);
insertContractor(contractor);
}
}
}
private void _buildGuestGroupBreadcrumb(ThemeDisplay themeDisplay, StringBundler sb)
throws Exception {
Group group = GroupLocalServiceUtil.getGroup(themeDisplay.getCompanyId(), GroupConstants.GUEST);
if (group.getPublicLayoutsPageCount() > 0) {
LayoutSet layoutSet = LayoutSetLocalServiceUtil.getLayoutSet(group.getGroupId(), false);
String layoutSetFriendlyURL = PortalUtil.getLayoutSetFriendlyURL(layoutSet, themeDisplay);
sb.append("<li><span><a href=\"");
sb.append(layoutSetFriendlyURL);
sb.append("\">");
sb.append(HtmlUtil.escape(themeDisplay.getAccount().getName()));
sb.append("</a></span></li>");
}
}
