| | |
| | | import com.ycl.jxkg.domain.base.AbsEntity; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * 班级 |
| | | * |
| | |
| | | |
| | | @TableField("start_time") |
| | | /** 开始时间 */ |
| | | private String startTime; |
| | | private Date startTime; |
| | | |
| | | @TableField("end_time") |
| | | /** 结束时间 */ |
| | | private String endTime; |
| | | private Date endTime; |
| | | |
| | | @TableField("remark") |
| | | /** 备注 */ |
| | | private String remark; |
| | | |
| | | |
| | | @TableField("create_time") |
| | | private Date createTime; |
| | | } |
| | |
| | | package com.ycl.jxkg.domain.vo; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ycl.jxkg.domain.base.AbsVo; |
| | | import com.ycl.jxkg.domain.entity.Classes; |
| | | |
| | |
| | | |
| | | /** 创建人 */ |
| | | private Integer createUser; |
| | | private String createUserName; |
| | | private String teacherPhone; |
| | | |
| | | /** 创建时间 */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date createTime; |
| | | |
| | | /** 班级人数 */ |
| | |
| | | private String verifyStatus; |
| | | |
| | | /** 开始时间 */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date startTime; |
| | | |
| | | /** 结束时间 */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date endTime; |
| | | |
| | | /** 备注 */ |
| | |
| | | <resultMap id="BaseResultMap" type="com.ycl.jxkg.domain.vo.ClassesVO"> |
| | | <result column="class_name" property="className" /> |
| | | <result column="create_user" property="createUser" /> |
| | | <result column="real_name" property="createUserName" /> |
| | | <result column="phone" property="teacherPhone" /> |
| | | <result column="create_time" property="createTime" /> |
| | | <result column="classes_number" property="classesNumber" /> |
| | | <result column="status" property="status" /> |
| | |
| | | <result column="start_time" property="startTime" /> |
| | | <result column="end_time" property="endTime" /> |
| | | <result column="remark" property="remark" /> |
| | | <result column="create_time" property="createTime" /> |
| | | </resultMap> |
| | | |
| | | |
| | |
| | | TC.start_time, |
| | | TC.end_time, |
| | | TC.remark, |
| | | TC.create_time, |
| | | TC.id |
| | | FROM |
| | | t_classes TC |
| | |
| | | TC.create_time, |
| | | TC.classes_number, |
| | | TC.status, |
| | | TC.create_time, |
| | | TC.verify_status, |
| | | TC.start_time, |
| | | TC.end_time, |
| | | TC.remark, |
| | | TC.id |
| | | TC.id, |
| | | TU.real_name, |
| | | TU.phone |
| | | FROM |
| | | t_classes TC |
| | | LEFT JOIN t_user TU ON TU.id = TC.create_user AND TU.deleted = 0 |
| | | WHERE |
| | | TC.deleted = 0 |
| | | </select> |