1 /**
2 * Copyright 2013 The Kuali Foundation Licensed under the
3 * Educational Community License, Version 2.0 (the "License"); you may
4 * not use this file except in compliance with the License. You may
5 * obtain a copy of the License at
6 *
7 * http://www.osedu.org/licenses/ECL-2.0
8 *
9 * Unless required by applicable law or agreed to in writing,
10 * software distributed under the License is distributed on an "AS IS"
11 * BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
12 * or implied. See the License for the specific language governing
13 * permissions and limitations under the License.
14 */
15 package org.kuali.student.enrollment.class2.coursewaitlist.dao;
16
17 import org.kuali.student.enrollment.class2.coursewaitlist.model.CourseWaitListEntity;
18 import org.kuali.student.r2.common.dao.GenericEntityDao;
19
20 import java.util.List;
21
22 public class CourseWaitListDao extends GenericEntityDao<CourseWaitListEntity> implements CourseWaitListDaoApi {
23 // what do we need besides basic CRUD provided by parent class?
24 /**
25 * Get list of CourseWaitlists given a course offering ID
26 * @param activityOfferingIds The id of an activity offering (which course waitlists will be fetched) -- have to put it in a list
27 * @return List of CourseWaitListEntity objects
28 */
29 public List<CourseWaitListEntity> getCourseWaitListsByActivityOfferingIds(List<String> activityOfferingIds) {
30
31 return em.createQuery("FROM CourseWaitListEntity cwl, IN(cwl.activityOfferingIds) a WHERE a IN (:activityOfferingIds)")
32 .setParameter("activityOfferingIds", activityOfferingIds).getResultList();
33 }
34 }