| | |
| | | and d.course_uuid = #{query.courseUuid} |
| | | </if> |
| | | <if test="query.startTime != null"><!-- 开始时间检索 --> |
| | | and date_format(d.create_time,'%y-%m-%d') >= date_format(#{query.startTime},'%y-%m-%d') |
| | | and date_format(d.start_time,'%y-%m-%d %H:%i:%s') >= date_format(#{query.startTime},'%y-%m-%d %H:%i:%s') |
| | | </if> |
| | | <if test="query.endTime != null"><!-- 结束时间检索 --> |
| | | and date_format(d.create_time,'%y-%m-%d') <= date_format(#{query.endTime},'%y-%m-%d') |
| | | and date_format(d.start_time,'%y-%m-%d %H:%i:%s') <= date_format(#{query.endTime},'%y-%m-%d %H:%i:%s') |
| | | </if> |
| | | <if test="query.status == 0"></if> |
| | | <if test="query.status == 1"> |
| | |
| | | <if test="query.status == 2"> |
| | | and (d.duration-TIMESTAMPDIFF(SECOND, start_time, finish_time)) > 30 |
| | | </if> |
| | | <if test="query.institutionId !=null"> |
| | | and institution_id = #{query.institutionId} |
| | | </if> |
| | | ORDER BY |
| | | d.id DESC |
| | | |