SELECT a.*,b.course,b.total_nodes,d.teacher_name FROM tp_student_course a JOIN tp_..._mybatisplus if标签">
赞
踩
- <select id="findStudentCoursePageBy" resultType="org.jeecg.modules.course.vo.TpStudentCoursePageVO" >
- SELECT a.*,b.course,b.total_nodes,d.teacher_name
- FROM tp_student_course a JOIN tp_course_info b ON a.course_id=b.id
- JOIN tp_teacher_info d ON b.lecturer_id=d.id
- WHERE a.create_by = #{queryName}
- <if test="map.isOver!= null and map.isOver!='' or map.isOver==0">
- and a.is_over = #{map.isOver}
- <if test="map.isOver != 1 and map.learnType != null and map.learnType!=''">
- <choose>
- <when test="map.learnType =='1' ">
- and a.course_id in( SELECT c.course_id
- from tp_course_record c
- WHERE c.create_by = #{queryName}
- group by c.course_id
- HAVING max(c.learn_time)!=0 )
- </

赞
踩
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。