Changeset 405 for ether_ndacc/trunk/persistence/implementation/com/ether/dao/plot/PlotDAOImpl.java

Timestamp:

03/09/12 13:18:57 (12 years ago)

Author:

rboipsl

Message:

ajout realtime ecc ohp

File:

• ether_ndacc/trunk/persistence/implementation/com/ether/dao/plot/PlotDAOImpl.java (modified) (2 diffs)

ether_ndacc/trunk/persistence/implementation/com/ether/dao/plot/PlotDAOImpl.java

@@ -41 +41 @@
                 return selectAllByCriteria(String.class, criteria);
         }
+
+    @Nullable
+    public List<String> getPlotsByDateByInstrumentByStationByType(@NotNull final String instrument, @NotNull final Date pFormatDate_deb, @NotNull final Date pFormatDate_fin, @NotNull final String station, @NotNull final String type)
+            throws PersistenceException
+        {
+            String vtype = type;
+
+            final DetachedCriteria criteria = DetachedCriteria.forClass(Plot.class,"plot")
+                .addOrder(Order.asc("plot.name"))
+                .add(Restrictions.ge("datedeb", pFormatDate_deb))
+                .add(Restrictions.lt("datedeb", pFormatDate_fin))
+                .createCriteria("instrument","instrument").add(Restrictions.ilike("instrument.name",instrument,MatchMode.ANYWHERE))
+                .createCriteria("station","station").add(Restrictions.ilike("station.name",station,MatchMode.ANYWHERE))
+                .add(Restrictions.ilike("plot.name",vtype,MatchMode.ANYWHERE));
+
+
+            //select pl_name de nd_plot
+            criteria.setProjection(Projections.property("plot.name"));
+
+            return selectAllByCriteria(String.class, criteria);
+        }
 
         @Nullable
@@ -86 +107 @@
         }
 
-        @Nullable
+
+    @Nullable
         public List<Date> getListeDistinctDates() 
                 throws PersistenceException