| | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.io.Serializable; |
| | | import java.sql.Time; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.time.LocalTime; |
| | | |
| | | @Data |
| | | @TableName("internal_audit_carry_dept") |
| | |
| | | |
| | | @ApiModelProperty(value = "日期") |
| | | @TableField("date") |
| | | private String date; |
| | | private LocalDate date; |
| | | |
| | | @ApiModelProperty(value = "时间") |
| | | @TableField("time") |
| | | private String time; |
| | | @ApiModelProperty(value = "开始时间") |
| | | @TableField("start_time") |
| | | @JsonFormat(pattern = "HH:mm") |
| | | private LocalTime startTime; |
| | | |
| | | @ApiModelProperty(value = "结束时间") |
| | | @TableField("end_time") |
| | | @JsonFormat(pattern = "HH:mm") |
| | | private LocalTime endTime; |
| | | |
| | | @ApiModelProperty("审核员id") |
| | | @TableField("check_id") |
| | |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.gkhy.exam.system.mapper.InternalAuditCarryMapper"> |
| | | <insert id="insertCarryDept"> |
| | | INSERT INTO`internal_audit_carry_dept` (`carry_id`, `dept_id`, `date`, `time`, `check_id` ) |
| | | INSERT INTO`internal_audit_carry_dept` (`carry_id`, `dept_id`,`date`, `start_time`, `end_time`, `check_id` ) |
| | | VALUES |
| | | <foreach collection="deptList" separator="," item="item"> |
| | | ( #{item.carryId}, #{item.deptId}, #{item.date}, #{item.time}, #{item.checkId} ) |
| | | ( #{item.carryId}, #{item.deptId},#{item.date}, #{item.startTime}, #{item.endTime}, #{item.checkId} ) |
| | | </foreach> |
| | | </insert> |
| | | <delete id="deletedCarryDeptByCarryId"> |
| | |
| | | iacd.`dept_id`, |
| | | sd.dept_name, |
| | | iacd.`date`, |
| | | iacd.`time`, |
| | | iacd.`start_time`, |
| | | iacd.`end_time`, |
| | | iacd.`check_id` , |
| | | su.`name` as check_name |
| | | FROM |