Changeset 6744 for trunk/www/views/itemlists/members/index.jsp

Timestamp:

Feb 18, 2015, 9:56:25 AM (8 years ago)

Author:

Nicklas Nordborg

Message:

References #1325: Lists of items (similar funcion as biomaterial lists)

Adding functionality for manually adding/removing members to a list.

File:

• trunk/www/views/itemlists/members/index.jsp (modified) (5 diffs)

trunk/www/views/itemlists/members/index.jsp

@@ -23 +23 @@
   @version 2.10
 --%>
-<%@page import="net.sf.basedb.core.Listable"%>
 <%@ page pageEncoding="UTF-8" session="false"
   import="net.sf.basedb.core.SessionControl"
@@ -31 +30 @@
   import="net.sf.basedb.core.Type"
   import="net.sf.basedb.core.ItemQuery"
-  import="net.sf.basedb.core.ItemResultIterator"
   import="net.sf.basedb.core.ItemList"
   import="net.sf.basedb.core.BasicItem"
-  import="net.sf.basedb.core.Sample"
-  import="net.sf.basedb.core.Extract"
-  import="net.sf.basedb.core.PhysicalBioAssay"
-  import="net.sf.basedb.core.BioPlateEventType"
-  import="net.sf.basedb.core.OwnedItem"
+  import="net.sf.basedb.core.Listable"
   import="net.sf.basedb.core.query.Restrictions"
   import="net.sf.basedb.core.query.Expressions"
@@ -54 +48 @@
   import="net.sf.basedb.core.plugin.GuiContext"
   import="net.sf.basedb.util.extensions.ExtensionsInvoker"
-  import="net.sf.basedb.util.formatter.NameableFormatter"
-  import="net.sf.basedb.util.formatter.WellCoordinateFormatter"
-  import="net.sf.basedb.util.formatter.ItemTypeFormatter"
-  import="net.sf.basedb.clients.web.plugins.BioMaterialEventSourceFormatter"
-  import="net.sf.basedb.clients.web.plugins.ItemQueryLoader"
-  import="net.sf.basedb.clients.web.plugins.ParentBioMaterialEventSourceLoader"
   import="net.sf.basedb.clients.web.extensions.ExtensionsControl"
   import="net.sf.basedb.clients.web.extensions.JspContext"
@@ -76 +64 @@
   {
     Item memberType = cc.getItemType();
-    if (memberType == Item.BIOSOURCE)
-    {
-      // Register formatters
-      cc.setObject("export.formatter.&children(name)", new NameableFormatter());
-          
-      // Register dataloaders
-      String bioSourceParameter = "bioSource";
-      final ItemQuery<Sample> sampleQuery = Sample.getQuery();
-      sampleQuery.include(cc.getInclude());
-      sampleQuery.restrict(Restrictions.eq(Hql.property("parent"), Expressions.parameter(bioSourceParameter)));
-      sampleQuery.order(Orders.asc(Hql.property("name")));
-      cc.setObject("export.dataloader.&children(name)", new ItemQueryLoader(sampleQuery, bioSourceParameter));
-    }
-    else if (memberType == Item.SAMPLE)
-    {
-      // Register formatters
-      cc.setObject("export.formatter.bioWell.row", new WellCoordinateFormatter(true));
-      cc.setObject("export.formatter.bioWell.column", new WellCoordinateFormatter(false));
-      cc.setObject("export.formatter.&creationEvent.sources(bioMaterial.name)", new BioMaterialEventSourceFormatter());
-      cc.setObject("export.formatter.&childCreationEvents(event.bioMaterial.name)", new NameableFormatter());
-      cc.setObject("export.formatter.&children(name)", new NameableFormatter());
-      cc.setObject("export.formatter.parentType", new ItemTypeFormatter());
-      
-      // Register dataloaders
-      String sampleParameter = "sample";
-
-      // Child extracts
-      ItemQuery<Extract> extractQuery = Extract.getQuery();
-      extractQuery.include(cc.getInclude());
-      extractQuery.restrict(Restrictions.eq(Hql.property("parent"), Expressions.parameter(sampleParameter)));
-      extractQuery.order(Orders.asc(Hql.property("name")));
-      cc.setObject("export.dataloader.&children(name)", new ItemQueryLoader(extractQuery, sampleParameter));
-
-      // Child samples
-      ItemQuery<Sample> childSamplesQuery = Sample.getQuery();
-      childSamplesQuery.join(Hql.innerJoin("creationEvent", "ce"));
-      childSamplesQuery.join(Hql.innerJoin("ce", "sources", "src"));
-      childSamplesQuery.restrict(Restrictions.eq(Hql.property("src", "bioMaterial"), Expressions.parameter(sampleParameter)));
-      childSamplesQuery.order(Orders.asc(Hql.property("name")));
-      childSamplesQuery.include(cc.getInclude());
-      cc.setObject("export.dataloader.&childCreationEvents(event.bioMaterial.name)", new ItemQueryLoader(childSamplesQuery, sampleParameter));
-      
-      // Parent samples
-      cc.setObject("export.dataloader.&creationEvent.sources(bioMaterial.name)", new ParentBioMaterialEventSourceLoader());
-    }
-    else if (memberType == Item.EXTRACT)
-    {
-      cc.setObject("export.formatter.bioWell.row", new WellCoordinateFormatter(true));
-      cc.setObject("export.formatter.bioWell.column", new WellCoordinateFormatter(false));
-      cc.setObject("export.formatter.&children(name)", new NameableFormatter());
-      cc.setObject("export.formatter.&creationEvent.sources(bioMaterial.name)", new BioMaterialEventSourceFormatter());
-      cc.setObject("export.formatter.&childCreationEvents(event.physicalBioAssay.name)", new NameableFormatter());
-      cc.setObject("export.formatter.&childCreationEvents(event.bioMaterial.name)", new NameableFormatter());
-      cc.setObject("export.formatter.parentType", new ItemTypeFormatter());
-      
-      String restrictionParameter = "extract";
-
-      // Physical bioassays
-      ItemQuery<PhysicalBioAssay> bioAssayQuery = PhysicalBioAssay.getQuery();
-      bioAssayQuery.join(Hql.innerJoin("creationEvent", "ce"));
-      bioAssayQuery.join(Hql.innerJoin("ce", "sources", "src"));
-      bioAssayQuery.restrict(Restrictions.eq(Hql.property("src", "bioMaterial"), Expressions.parameter(restrictionParameter)));
-      bioAssayQuery.order(Orders.asc(Hql.property("name")));
-      bioAssayQuery.include(cc.getInclude());
-      cc.setObject("export.dataloader.&childCreationEvents(event.physicalBioAssay.name)", new ItemQueryLoader(bioAssayQuery, restrictionParameter));
-
-      // Child extracts
-      ItemQuery<Extract> childExtractsQuery = Extract.getQuery();
-      childExtractsQuery.join(Hql.innerJoin("creationEvent", "ce"));
-      childExtractsQuery.join(Hql.innerJoin("ce", "sources", "src"));
-      childExtractsQuery.restrict(Restrictions.eq(Hql.property("src", "bioMaterial"), Expressions.parameter(restrictionParameter)));
-      childExtractsQuery.order(Orders.asc(Hql.property("name")));
-      childExtractsQuery.include(cc.getInclude());
-      cc.setObject("export.dataloader.&childCreationEvents(event.bioMaterial.name)", new ItemQueryLoader(childExtractsQuery, restrictionParameter));
-      
-      // Parent items
-      cc.setObject("export.dataloader.&creationEvent.sources(bioMaterial.name)", new ParentBioMaterialEventSourceLoader());
-    }
   }
 %>
@@ -235 +145 @@
     redirect = "../../../common/plugin/index.jsp?ID="+ID+"&cmd=SelectPlugin&item_type="+itemType.name()+"&context_type=LIST&subcontext="+subContext+"&main_type=OTHER&title=Run+plugin";
   }
+  else if ("AddMembers".equals(cmd))
+  {
+    ItemContext memberContext = sc.getCurrentContext(itemType);
+    final ItemQuery<? extends Listable> query = list.getAllItems();
+    memberContext.configureQuery(dc, query, true);
+    String which = request.getParameter("which");
+    if ("selected".equals(which))
+    {
+      query.setFirstResult(0);
+      query.setMaxResults(-1);
+      Integer[] itemIds = Values.getInt(request.getParameter("items").split(","));
+      query.restrict(
+        Restrictions.in(
+          Hql.property("id"),
+          Expressions.parameter("selectedItems")
+        )
+      );
+      query.setParameter("selectedItems", Arrays.asList(itemIds), Type.INT);      
+    }
+    else if ("all".equals(which))
+    {
+      query.setFirstResult(0);
+      query.setMaxResults(-1);
+    }
+    int count = list.add(query.iterate(dc));
+    dc.commit();
+    message = count + " members added to list";
+  }
+  else if ("RemoveMembers".equals(cmd))
+  {
+    // Delete all selected items on the list page
+    ItemContext cc = Base.getAndSetCurrentContext(sc, itemType, subContext, pageContext, defaultContext);
+    for (int itemId : cc.getSelected())
+    {
+      list.remove((Listable)itemType.getById(dc, itemId));
+    }
+    dc.commit();
+    redirect = listPage;
+  }
+
   else
   {