source: trunk/www/admin/groups/index.jsp @ 5077

<%-- $Id: index.jsp 5077 2009-08-26 12:03:37Z nicklas $
  ------------------------------------------------------------------
  Copyright (C) 2005 Nicklas Nordborg
  Copyright (C) 2006 Jari Häkkinen, Nicklas Nordborg, Martin Svensson
  Copyright (C) 2007 Nicklas Nordborg

  This file is part of BASE - BioArray Software Environment.
  Available at http://base.thep.lu.se/

  BASE is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  as published by the Free Software Foundation; either version 3
  of the License, or (at your option) any later version.

  BASE is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with BASE. If not, see <http://www.gnu.org/licenses/>.
  ------------------------------------------------------------------

  @author Nicklas
  @version 2.0
--%>
<%@ page session="false"
  import="net.sf.basedb.core.SessionControl"
  import="net.sf.basedb.core.DbControl"
  import="net.sf.basedb.core.Item"
  import="net.sf.basedb.core.Include"
  import="net.sf.basedb.core.Group"
  import="net.sf.basedb.core.User"
  import="net.sf.basedb.core.Quota"
  import="net.sf.basedb.core.ItemQuery"
  import="net.sf.basedb.core.Permission"
  import="net.sf.basedb.core.ItemContext"
  import="net.sf.basedb.core.MultiPermissions"
  import="net.sf.basedb.core.PermissionDeniedException"
  import="net.sf.basedb.core.ItemAlreadyExistsException"
  import="net.sf.basedb.core.query.Expressions"
  import="net.sf.basedb.core.query.Hql"
  import="net.sf.basedb.core.query.Orders"
  import="net.sf.basedb.core.query.Restrictions"
  import="net.sf.basedb.util.RemovableUtil"
  import="net.sf.basedb.clients.web.Base"
  import="net.sf.basedb.clients.web.WebException"
  import="net.sf.basedb.util.Values"
  import="net.sf.basedb.util.formatter.NameableFormatter"
  import="net.sf.basedb.clients.web.util.HTML"
  import="net.sf.basedb.clients.web.plugins.ItemQueryLoader"
  import="java.util.Enumeration"
  import="java.util.Set"
  import="java.util.HashSet"
  import="java.util.List"
  import="java.util.ArrayList"
  import="java.util.Collections"
%>
<%@ taglib prefix="base" uri="/WEB-INF/base.tld" %>
<%!
  private static final ItemContext defaultContext = Base.createDefaultContext("name", "name,isDefault,description");
  private static final Item itemType = Item.GROUP;
  
  private static void registerExportUtils(ItemContext cc)
  {
    // Register formatters
    cc.setObject("export.formatter.&children(name)", new NameableFormatter());
    cc.setObject("export.formatter.&users(name)", new NameableFormatter());
    
    
    // Register dataloaders
    String groupParameter = "group";
    // Groups
    ItemQuery<Group> groupQuery = Group.getQuery();
    groupQuery.include(cc.getInclude());
    groupQuery.join(Hql.innerJoin("parents", "p"));
    groupQuery.restrict(Restrictions.eq(Hql.alias("p"), Expressions.parameter(groupParameter)));
    groupQuery.order(Orders.asc(Hql.property("name")));
    cc.setObject("export.dataloader.&children(name)", new ItemQueryLoader(groupQuery, groupParameter));

    // Users
    ItemQuery<User> userQuery = User.getQuery();
    userQuery.include(cc.getInclude());
    userQuery.join(Hql.innerJoin("groups", "grp"));
    userQuery.restrict(Restrictions.eq(Hql.alias("grp"), Expressions.parameter(groupParameter)));
    userQuery.order(Orders.asc(Hql.property("name"))); 
    cc.setObject("export.dataloader.&users(name)", new ItemQueryLoader(userQuery, groupParameter));
  }
%>
<%
final SessionControl sc = Base.getExistingSessionControl(pageContext, true);
final String ID = sc.getId();
final String cmd = request.getParameter("cmd");
final String root = request.getContextPath()+"/";
final String mode = request.getParameter("mode");
final String callback = request.getParameter("callback");
final String itemId = request.getParameter("item_id");
final String listPage = "list_groups.jsp?ID="+ID
  +(mode == null ? "" : "&mode="+mode)
  +(callback == null ? "" : "&callback="+callback)
  +(itemId == null ? "" : "&item_id="+itemId);
final String viewPage = "view_group.jsp?ID="+ID;
final String editPage = "edit_group.jsp?ID="+ID;

String forward = null;
String redirect = null;
String message = null;
DbControl dc = null;

try
{
  if (cmd == null || "List".equals(cmd))
  {
    // Display the list page without updatinging the current context
    Base.getAndSetCurrentContext(sc, itemType, null, defaultContext, true);
    redirect = listPage;
  }
  else if ("UpdateContext".equals(cmd))
  {
    // Display the list page after updating the current context from the request parameters
    Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    redirect = listPage;
  }
  else if ("LoadContext".equals(cmd))
  {
    // Display the list page after loading a saved context
    int contextId = Values.getInt(request.getParameter("context"));
    Base.loadContext(sc, contextId, defaultContext);
    redirect = listPage;
  }

  else if ("ViewItem".equals(cmd))
  {
    // Display the view page for a single item 
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    forward = viewPage;
  }
  else if ("EditItem".equals(cmd))
  {
    // Display the edit page for a single item (should be opened in a popup)
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    redirect = editPage;
  }
  else if ("NewItem".equals(cmd))
  {
    // Display the edit page for a new item (should be opened in a popup)
    if (!sc.hasPermission(Permission.CREATE, itemType))
    {
      throw new PermissionDeniedException(Permission.CREATE, itemType.toString());
    }
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    cc.setId(0);
    forward = editPage;
  }
  else if ("UpdateItem".equals(cmd))
  {
    // Update the properties on an item (will close the popup)
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, null, defaultContext);
    dc = sc.newDbControl();
    Group group = (Group)cc.getObject("item");
    if (group == null)
    {
      group = Group.getNew(dc);
      message = "Group created";
      dc.saveItem(group);
    }
    else
    {
      dc.reattachItem(group, false);
      message = "Group updated";
    }
    group.setName(Values.getStringOrNull(request.getParameter("name")));
    group.setDescription(Values.getStringOrNull(request.getParameter("description")));
    group.setDefault(Values.getBoolean(request.getParameter("is_default"), false));
    group.setHiddenMembers(Values.getBoolean(request.getParameter("hidden_members"), false));
    int quotaId = Values.getInt(request.getParameter("quota_id"), -1);
    if (quotaId >= 0) // < 0 = denied or unchanged
    {
      group.setQuota(quotaId == 0 ? null : Quota.getById(dc, quotaId));
    }
    
    String[] removeUsers = Values.getString(request.getParameter("removeUsers")).split(",");
    for (int i = 0; i < removeUsers.length; ++i)
    {
      int userId = Values.getInt(removeUsers[i], -1);
      if (userId != -1) group.removeUser(User.getById(dc, userId));
    }
    
    String[] addUsers = Values.getString(request.getParameter("addUsers")).split(",");
    for (int i = 0; i < addUsers.length; ++i)
    {
      int userId = Values.getInt(addUsers[i], -1);
      if (userId != -1) group.addUser(User.getById(dc, userId));
    }

    String[] removeGroups = Values.getString(request.getParameter("removeGroups")).split(",");
    for (int i = 0; i < removeGroups.length; ++i)
    {
      int groupId = Values.getInt(removeGroups[i], -1);
      if (groupId != -1) group.removeGroup(Group.getById(dc, groupId));
    }
    
    String[] addGroups = Values.getString(request.getParameter("addGroups")).split(",");
    for (int i = 0; i < addGroups.length; ++i)
    {
      int groupId = Values.getInt(addGroups[i], -1);
      if (groupId != -1) group.addGroup(Group.getById(dc, groupId));
    }
    dc.commit();
    cc.removeObject("item");
  }
  else if ("DeleteItem".equals(cmd))
  {
    // Delete a single item and then return to the view page
    dc = sc.newDbControl();
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    RemovableUtil.setRemoved(dc, itemType, Collections.singleton(cc.getId()), true);
    dc.commit();
    redirect = viewPage;
  }
  else if ("DeleteItems".equals(cmd))
  {
    // Delete all selected items on the list page
    dc = sc.newDbControl();
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    int numTotal = cc.getSelected().size();
    int numRemoved = RemovableUtil.setRemoved(dc, itemType, cc.getSelected(), true);
    dc.commit();
    if (numTotal != numRemoved)
    {
      message = (numRemoved == 0 ? "No" : "Only "+numRemoved+" of "+numTotal) + " items could be deleted, because you have no DELETE permission";
    }
    redirect = listPage+(message != null ? "&popmessage="+HTML.urlEncode(message) : "");
  }
  else if ("RestoreItem".equals(cmd))
  {
    // Restore a single item and then return to the view page
    dc = sc.newDbControl();
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    RemovableUtil.setRemoved(dc, itemType, Collections.singleton(cc.getId()), false);
    dc.commit();
    redirect = viewPage;
  }
  else if ("RestoreItems".equals(cmd))
  {
    // Restore all selected items on the list page
    dc = sc.newDbControl();
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    int numTotal = cc.getSelected().size();
    int numRemoved = RemovableUtil.setRemoved(dc, itemType, cc.getSelected(), false);
    dc.commit();
    if (numTotal != numRemoved)
    {
      message = (numRemoved == 0 ? "No" : "Only "+numRemoved+" of "+numTotal) + " items could be restored, because you have no WRITE permission";
    }
    redirect = listPage+(message != null ? "&popmessage="+HTML.urlEncode(message) : "");
  }
  else if ("ExportItems".equals(cmd))
  {
    // Run an export plugin in a list context
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    final ItemQuery<Group> query = Group.getQuery();
    cc.configureQuery(query, true);
    cc.setQuery(query);
    registerExportUtils(cc);
    redirect = "../../common/export/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=LIST&title=Export+groups";
  }
  else if ("ExportItem".equals(cmd))
  {
    // Run an export plugin in single-item context
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    registerExportUtils(cc);
    redirect = "../../common/export/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=ITEM&title=Export+group";
  }
  else if ("ImportItems".equals(cmd))
  {
    // Run an import plugin in a list context
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    final ItemQuery<Group> query = Group.getQuery();
    cc.configureQuery(query, true);
    cc.setQuery(query);
    redirect = "../../common/import/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=LIST&title=Import+groups";
  }
  else if ("ImportItem".equals(cmd))
  {
    // Run an import plugin in single-item context
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    redirect = "../../common/import/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=ITEM&title=Import+group";
  }
  else if ("RunListPlugin".equals(cmd))
  {
    // Run another plugin in a list context
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    final ItemQuery<Group> query = Group.getQuery();
    cc.configureQuery(query, true);
    cc.setQuery(query);
    redirect = "../../common/plugin/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=LIST&main_type=OTHER&title=Run+plugin";
  }
  else if ("RunPlugin".equals(cmd))
  {
    // Run another plugin in single-item context
    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, pageContext, defaultContext);
    redirect = "../../common/plugin/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=ITEM&main_type=OTHER&title=Run+plugin";
  }
  else
  {
    throw new WebException("popup", "Invalid command", "The command {1} is not recognised as a valid command.", cmd);
  }
}
finally
{
  if (dc != null) dc.close();
}

if (forward != null)
{
  pageContext.forward(forward);
}
else if (redirect != null)
{
  response.sendRedirect(redirect);
}
else if (message == null)
{
  response.sendRedirect(root + "common/close_popup.jsp?refresh_opener=1&wait=0");
}
else
{
  response.sendRedirect(root + "common/close_popup.jsp?refresh_opener=1&message="+HTML.urlEncode(message));
}
%>