Author: tchemit Date: 2013-11-05 09:30:18 +0100 (Tue, 05 Nov 2013) New Revision: 1327 Url: http://forge.codelutin.com/projects/tutti/repository/revisions/1327 Log: refs #3674: [CAMPAGNE] pouvoir ajouter plusieur engins professionnels de m?\195?\170me type ?\195?\160 une campagn Modified: trunk/tutti-persistence/src/main/resources/queries-override.hbm.xml Modified: trunk/tutti-persistence/src/main/resources/queries-override.hbm.xml =================================================================== --- trunk/tutti-persistence/src/main/resources/queries-override.hbm.xml 2013-11-05 00:53:28 UTC (rev 1326) +++ trunk/tutti-persistence/src/main/resources/queries-override.hbm.xml 2013-11-05 08:30:18 UTC (rev 1327) @@ -268,20 +268,43 @@ <query cacheable="true" name="allFishingOperationsWithGear"> <![CDATA[ SELECT - o.id AS id + g.id AS gearId, + guf.rankOrder as gufRankOrder FROM FishingOperationImpl o - LEFT OUTER JOIN o.gearUseFeatures guf + INNER JOIN o.gearUseFeatures guf LEFT OUTER JOIN guf.gear g WHERE o.fishingTrip.scientificCruise.id=:cruiseId - AND - g.id in (:gearIds) + AND g.id in (:gearIds) ]]> <query-param name="cruiseId" type="java.lang.Integer"/> <query-param name="gearIds" type="java.lang.Integer"/> </query> + <query cacheable="true" name="updateOperationsGear"> + <![CDATA[ + UPDATE GearUseFeaturesImpl guf + SET guf.rankOrder=:newRankOrder + WHERE + guf IN ( + SELECT + guf + FROM + FishingOperationImpl o + INNER JOIN o.gearUseFeatures guf + WHERE + o.fishingTrip.scientificCruise.id=:cruiseId + AND guf.rankOrder= :oldRankOrder + AND guf.gear.id= :gearId + ) + ]]> + <query-param name="cruiseId" type="java.lang.Integer"/> + <query-param name="gearId" type="java.lang.Integer"/> + <query-param name="oldRankOrder" type="java.lang.Short"/> + <query-param name="newRankOrder" type="java.lang.Short"/> + </query> + <query cacheable="true" name="fishingOperation"> <![CDATA[ SELECT