/******************************************************************************
|
* All Rights Reserved.
|
* 本软件为深圳市企鹅网络科技有限公司开发研制。未经本公司正式书面同意，其他任何个人、团体
|
* 不得使用、复制、修改或发布本软件.
|
*****************************************************************************/
|
|
package com.qxueyou.scc.school.dao;
|
|
import java.text.ParseException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
import org.hibernate.transform.Transformers;
|
import org.springframework.stereotype.Repository;
|
|
import com.qxueyou.scc.base.dao.BaseDAO;
|
import com.qxueyou.scc.base.model.Pager;
|
import com.qxueyou.scc.base.util.CollectionUtils;
|
import com.qxueyou.scc.school.model.SchClassSchedule;
|
|
|
@Repository(value="lessonDAO")
|
/**
|
* 自动注入sessionFactory
|
*
|
* @author ody.yuan
|
* @since JDK1.6
|
* @history 2015-04-23
|
*/
|
public class LessonDAO extends BaseDAO {
|
|
/**
|
* 查询课程列表明细
|
* @param sql
|
* @param args
|
* @return
|
* @throws ParseException
|
*/
|
public List<SchClassSchedule> queryLessonList(String sql,List<Object> args) {
|
// 查询结果
|
Session session = this.getSessionFactory().getCurrentSession();
|
SQLQuery query = session.createSQLQuery(sql);
|
query.setResultTransformer(Transformers.aliasToBean(SchClassSchedule.class));
|
for(int i = 0;args !=null && i < args.size() ; i++ ){
|
query.setParameter(i, args.get(i));
|
}
|
@SuppressWarnings("unchecked")
|
List<SchClassSchedule> lstItems = query.list();
|
|
return lstItems;
|
}
|
|
/**
|
* 组装查询练习题目 顺序、随机练习
|
* @return
|
*/
|
public List<SchClassSchedule> queryAppLessonList(final String hql, final Pager page,
|
final List<Object> args) {
|
List<SchClassSchedule> lstitems = new ArrayList<SchClassSchedule>();
|
SchClassSchedule item;
|
List<Object[]> lst = this.findList(hql, page, args, Object[].class);
|
|
for (Object[] obj : lst) {
|
item = (SchClassSchedule) obj[0];
|
item.setTeacherImg(String.valueOf(obj[1]));
|
lstitems.add(item);
|
}
|
return lstitems;
|
}
|
|
/**
|
* 根据讲师id查询班级
|
* @param orgTeacherId
|
* @return
|
*/
|
public List<String> queryClassesByTeacher(String orgTeacherId) {
|
String hql = "select s.classId from SchClassSchedule s where s.teacherId=:teacherId and EXISTS (select 1 from ClsClass c where c.classId = s.classId and c.deleteFlag is FALSE) GROUP BY s.classId";
|
|
return findByComplexHql(hql, CollectionUtils.newObjectMap("teacherId",orgTeacherId), String.class);
|
}
|
|
/**
|
* 查询讲师关联的直播
|
*
|
* @param orgTeacherId
|
* @return
|
*/
|
public List<String> queryClassesByLive(String orgTeacherId) {
|
|
String hql = "select s.classId from MediaVideoLive s where s.anchorId=:teacherId and EXISTS (select 1 from ClsClass c where c.classId = s.classId and c.deleteFlag is FALSE) GROUP BY s.classId";
|
|
return findByComplexHql(hql, CollectionUtils.newObjectMap("teacherId",orgTeacherId), String.class);
|
}
|
}
|
