Index: lams_central/src/java/org/lamsfoundation/lams/webservice/xml/LessonJoinServlet.java =================================================================== diff -u -r5026f52ee7319416d69e0ac42fa99e80e0df7251 -r6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1 --- lams_central/src/java/org/lamsfoundation/lams/webservice/xml/LessonJoinServlet.java (.../LessonJoinServlet.java) (revision 5026f52ee7319416d69e0ac42fa99e80e0df7251) +++ lams_central/src/java/org/lamsfoundation/lams/webservice/xml/LessonJoinServlet.java (.../LessonJoinServlet.java) (revision 6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1) @@ -155,7 +155,7 @@ addUserToOrg(user, Integer.valueOf(orgId)); // get list of lessons based on ldId - List lessons = lessonService.getLessonsByOriginalLearningDesign(Long.valueOf(ldId)); + List lessons = lessonService.getLessonsByOriginalLearningDesign(Long.valueOf(ldId), Integer.valueOf(orgId)); if (lessons != null && lessons.size() > 0) { // add to first lesson where lesson size < learnerSize Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/ILessonDAO.java =================================================================== diff -u -rfdca3605f0b782b19e214abbe94df6f4a457b88e -r6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1 --- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/ILessonDAO.java (.../ILessonDAO.java) (revision fdca3605f0b782b19e214abbe94df6f4a457b88e) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/ILessonDAO.java (.../ILessonDAO.java) (revision 6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1) @@ -151,7 +151,8 @@ /** * Get lessons based on learning designs where the original learning design has the given id. * @param ldId + * @param orgId * @return list of lessons */ - public List getLessonsByOriginalLearningDesign(final Long ldId); + public List getLessonsByOriginalLearningDesign(final Long ldId, final Integer orgId); } Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java =================================================================== diff -u -rfdca3605f0b782b19e214abbe94df6f4a457b88e -r6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1 --- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision fdca3605f0b782b19e214abbe94df6f4a457b88e) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision 6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1) @@ -66,7 +66,8 @@ + Lesson.class.getName() + " l " + "where l.learningDesign.originalLearningDesign.learningDesignId = ? " + "and l.learningDesign.copyTypeID != " + LearningDesign.COPY_TYPE_PREVIEW + " " - + "and l.lessonStateId = " + Lesson.STARTED_STATE + + "and l.lessonStateId = " + Lesson.STARTED_STATE + " " + + "and l.organisation.organisationId = ? " + " order by l.lessonName"; /** @@ -332,9 +333,10 @@ /** * @see org.lamsfoundation.lams.lesson.dao.ILessonDAO#getLessonsByOriginalLearningDesign(Integer) */ - public List getLessonsByOriginalLearningDesign(final Long ldId) + public List getLessonsByOriginalLearningDesign(final Long ldId, final Integer orgId) { - List lessons = this.getHibernateTemplate().find(LESSONS_WITH_ORIGINAL_LEARNING_DESIGN, ldId.longValue()); + Object[] args = {ldId.longValue(), orgId.intValue()}; + List lessons = this.getHibernateTemplate().find(LESSONS_WITH_ORIGINAL_LEARNING_DESIGN, args); return lessons; } Index: lams_common/src/java/org/lamsfoundation/lams/lesson/service/ILessonService.java =================================================================== diff -u -rfdca3605f0b782b19e214abbe94df6f4a457b88e -r6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1 --- lams_common/src/java/org/lamsfoundation/lams/lesson/service/ILessonService.java (.../ILessonService.java) (revision fdca3605f0b782b19e214abbe94df6f4a457b88e) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/service/ILessonService.java (.../ILessonService.java) (revision 6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1) @@ -285,7 +285,8 @@ /** * Gets list of lessons which are originally based on the given learning design id. * @param ldId + * @param orgId * @return list of lessons */ - public List getLessonsByOriginalLearningDesign(Long ldId); + public List getLessonsByOriginalLearningDesign(Long ldId, Integer orgId); } \ No newline at end of file Index: lams_common/src/java/org/lamsfoundation/lams/lesson/service/LessonService.java =================================================================== diff -u -r8bc8d173f84ddf9333719585a3ddfd7a676f28be -r6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1 --- lams_common/src/java/org/lamsfoundation/lams/lesson/service/LessonService.java (.../LessonService.java) (revision 8bc8d173f84ddf9333719585a3ddfd7a676f28be) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/service/LessonService.java (.../LessonService.java) (revision 6008e13a4cc3e08a3350be02c35a22eb6ee5a9c1) @@ -685,7 +685,7 @@ /** * Gets list of lessons which are originally based on the given learning design id. */ - public List getLessonsByOriginalLearningDesign(Long ldId) { - return this.lessonDAO.getLessonsByOriginalLearningDesign(ldId); + public List getLessonsByOriginalLearningDesign(Long ldId, Integer orgId) { + return this.lessonDAO.getLessonsByOriginalLearningDesign(ldId, orgId); } }