Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java =================================================================== diff -u -r234d7ab100d056b8846c5b8ba00706a4b434accf -r480f0e0b4d9a7338a3cde5ab84712a399d3ac3a1 --- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision 234d7ab100d056b8846c5b8ba00706a4b434accf) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision 480f0e0b4d9a7338a3cde5ab84712a399d3ac3a1) @@ -23,15 +23,6 @@ package org.lamsfoundation.lams.lesson.dao.hibernate; -import java.math.BigInteger; -import java.time.ZoneId; -import java.util.Arrays; -import java.util.Date; -import java.util.LinkedHashMap; -import java.util.LinkedList; -import java.util.List; -import java.util.Map; - import org.apache.commons.lang.StringEscapeUtils; import org.apache.commons.lang.StringUtils; import org.hibernate.FetchMode; @@ -51,6 +42,10 @@ import org.lamsfoundation.lams.util.CommonConstants; import org.springframework.stereotype.Repository; +import java.math.BigInteger; +import java.time.ZoneId; +import java.util.*; + /** * Hibernate implementation of ILessonDAO * @@ -105,8 +100,8 @@ + " AS lesson WHERE lesson.organisation.organisationId = :organisationId"; private final static String FIND_ABSOLUTE_TIME_LIMITS = "SELECT a.tool_content_id AS toolContentId, a.title AS activityTitle, " - + "(SELECT absolute_time_limit FROM tl_lascrt11_scratchie WHERE content_id = tool_content_id UNION " - + " SELECT absolute_time_limit FROM tl_laasse10_assessment WHERE content_id = tool_content_id " + + "(SELECT absolute_time_limit_finish FROM tl_lascrt11_scratchie WHERE content_id = tool_content_id UNION " + + " SELECT absolute_time_limit_finish FROM tl_laasse10_assessment WHERE content_id = tool_content_id " + ") AS absolute_time_limit " + "FROM lams_lesson AS l JOIN lams_learning_activity AS a USING (learning_design_id) " + "WHERE l.lesson_id = :lessonId AND a.tool_content_id IS NOT NULL " @@ -456,14 +451,14 @@ .isEmpty(); if (toolAvailable) { additionalToolsBuilder.append( - "UNION SELECT absolute_time_limit FROM tl_ladoku11_dokumaran WHERE content_id = tool_content_id "); + "UNION SELECT absolute_time_limit_finish FROM tl_ladoku11_dokumaran WHERE content_id = tool_content_id "); } toolAvailable = !findByProperty(Tool.class, "toolSignature", CommonConstants.TOOL_SIGNATURE_WHITEBOARD, true) .isEmpty(); if (toolAvailable) { additionalToolsBuilder.append( - "UNION SELECT absolute_time_limit FROM tl_lawhiteboard11_whiteboard WHERE content_id = tool_content_id"); + "UNION SELECT absolute_time_limit_finish FROM tl_lawhiteboard11_whiteboard WHERE content_id = tool_content_id"); } String queryText = FIND_ABSOLUTE_TIME_LIMITS.replace("", additionalToolsBuilder);