| | |
| | | |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | import java.util.List; |
| | | |
| | | @Getter |
| | | @Setter |
| | |
| | | @TableField("update_time") |
| | | private LocalDateTime updateTime; |
| | | |
| | | private List<QualityTargetMess> qualityTargetMesses; |
| | | |
| | | |
| | | } |
对比新文件 |
| | |
| | | package com.gkhy.exam.system.domain; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | @Data |
| | | public class QualityTargetMess { |
| | | @ApiModelProperty("主键") |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Integer id; |
| | | |
| | | @TableField("quality_target_id") |
| | | private Integer qualityTargetId; |
| | | |
| | | @ApiModelProperty(value = "目标值") |
| | | @TableField("num") |
| | | private String num; |
| | | |
| | | @ApiModelProperty(value = "实时措施") |
| | | @TableField("method") |
| | | private String method; |
| | | |
| | | @ApiModelProperty(value = "计算方法") |
| | | @TableField("calculate") |
| | | private String calculate; |
| | | |
| | | @ApiModelProperty(value = "数据源") |
| | | @TableField("data_source") |
| | | private String dataSource; |
| | | |
| | | @ApiModelProperty(value = "部门名称") |
| | | @TableField("depart_name") |
| | | private String departName; |
| | | |
| | | @ApiModelProperty(value = "考核时机") |
| | | @TableField("frequency") |
| | | private String frequency; |
| | | |
| | | @ApiModelProperty(value = "负责人") |
| | | @TableField("duty_name") |
| | | private String dutyName; |
| | | |
| | | @ApiModelProperty(value = "备注") |
| | | @TableField("remark") |
| | | private String remark; |
| | | } |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.gkhy.exam.system.domain.QualityTarget; |
| | | import com.gkhy.exam.system.domain.QualityTargetMess; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.mapstruct.Mapper; |
| | | |
| | |
| | | List<QualityTarget> selectByQualityId(Integer qualityId); |
| | | |
| | | void deleteByQualityIds(@Param("qualityId") Integer qualityId); |
| | | |
| | | List<QualityTargetMess> selectBYQualityTargetId(@Param("id") Integer id); |
| | | |
| | | void insertQualityTargetMess(@Param("qualityTargetMesses") List<QualityTargetMess> qualityTargetMesses); |
| | | |
| | | void deletedByQualityTargetId(@Param("qualityTargetId") Integer id); |
| | | } |
| | |
| | | import com.gkhy.exam.system.domain.Quality; |
| | | import com.gkhy.exam.system.domain.QualityDecompose; |
| | | import com.gkhy.exam.system.domain.QualityTarget; |
| | | import com.gkhy.exam.system.domain.QualityTargetMess; |
| | | import com.gkhy.exam.system.domain.req.DecomposeTargetReq; |
| | | import com.gkhy.exam.system.domain.req.QualityReq; |
| | | import com.gkhy.exam.system.domain.vo.QualityDecomposeVo; |
| | |
| | | List<QualityDecomposeVo> qualityDecomposeVos = qualityDecomposeMapper.selectDecomposeList(qualityReq); |
| | | for (QualityDecomposeVo qualityDecomposeVo : qualityDecomposeVos) { |
| | | List<QualityTarget> qualityTargets = qualityTargetMapper.selectByQualityId(qualityDecomposeVo.getQualityId()); |
| | | for (QualityTarget qualityTarget : qualityTargets) { |
| | | List<QualityTargetMess> qualityTargetMesses = qualityTargetMapper.selectBYQualityTargetId(qualityTarget.getId()); |
| | | qualityTarget.setQualityTargetMesses(qualityTargetMesses); |
| | | } |
| | | qualityDecomposeVo.setQualityTargets(qualityTargets); |
| | | } |
| | | return CommonPage.restPage(qualityDecomposeVos); |
| | |
| | | for (QualityTarget qualityTarget : qualityTargets) { |
| | | qualityTarget.setCreateTime(LocalDateTime.now()); |
| | | qualityTarget.setCreateBy(loginUser.getUsername()); |
| | | qualityTargetMapper.insertQualityTargetMess(qualityTarget.getQualityTargetMesses()); |
| | | } |
| | | qualityTargetMapper.updateQualityTargetById(qualityTargets); |
| | | // qualityTargetMapper.updateQualityTargetById(qualityTargets); |
| | | return CommonResult.success(); |
| | | } |
| | | |
| | |
| | | BeanUtils.copyProperties(decomposeTargetReq,qualityDecompose); |
| | | qualityDecomposeMapper.updateById(qualityDecompose); |
| | | List<QualityTarget> qualityTargets = decomposeTargetReq.getQualityTargets(); |
| | | qualityTargetMapper.updateQualityTargetById(qualityTargets); |
| | | for (QualityTarget qualityTarget : qualityTargets) { |
| | | qualityTargetMapper.deletedByQualityTargetId(qualityTarget.getId()); |
| | | qualityTargetMapper.insertQualityTargetMess(qualityTarget.getQualityTargetMesses()); |
| | | } |
| | | // qualityTargetMapper.updateQualityTargetById(qualityTargets); |
| | | return CommonResult.success(); |
| | | } |
| | | |
| | |
| | | List<QualityTargetVo> qualityTargetVos = qualityMapper.selectQualityTarget(quality); |
| | | for (QualityTargetVo qualityTargetVo : qualityTargetVos) { |
| | | List<QualityTarget> qualityTargets = qualityTargetMapper.selectByQualityId(qualityTargetVo.getId()); |
| | | for (QualityTarget qualityTarget : qualityTargets) { |
| | | List<QualityTargetMess> qualityTargetMesses = qualityTargetMapper.selectBYQualityTargetId(qualityTarget.getId()); |
| | | qualityTarget.setQualityTargetMesses(qualityTargetMesses); |
| | | } |
| | | qualityTargetVo.setQualityTargets(qualityTargets); |
| | | } |
| | | return CommonPage.restPage(qualityTargetVos); |
| | |
| | | List<QualityTargetVo> qualityTargetVos = qualityMapper.selectQualityTarget(quality); |
| | | for (QualityTargetVo qualityTargetVo : qualityTargetVos) { |
| | | List<QualityTarget> qualityTargets = qualityTargetMapper.selectByQualityId(qualityTargetVo.getId()); |
| | | for (QualityTarget qualityTarget : qualityTargets) { |
| | | List<QualityTargetMess> qualityTargetMesses = qualityTargetMapper.selectBYQualityTargetId(qualityTarget.getId()); |
| | | qualityTarget.setQualityTargetMesses(qualityTargetMesses); |
| | | } |
| | | qualityTargetVo.setQualityTargets(qualityTargets); |
| | | } |
| | | return CommonResult.success(qualityTargetVos); |
| | |
| | | #{item.createBy},#{item.createTime}) |
| | | </foreach> |
| | | </insert> |
| | | <insert id="insertQualityTargetMess"> |
| | | INSERT INTO `quality_target_mess` |
| | | ( `quality_target_id`, `num`, `method`, `calculate`, `data_source`, `depart_name`, `frequency`, `duty_name`, `remark` ) |
| | | VALUES |
| | | <foreach collection="qualityTargetMesses" separator="," item="item"> |
| | | ( #{item.qualityTargetId}, #{item.num}, #{item.method}, #{item.calculate}, #{item.dataSource}, #{item.departName}, #{item.frequency}, #{item.dutyName}, #{item.remark} ) |
| | | </foreach> |
| | | </insert> |
| | | |
| | | <update id="updateQualityTargetById"> |
| | | <foreach collection="qualityTargets" item="item" index="index" separator=";"> |
| | |
| | | <update id="deleteByQualityIds"> |
| | | UPDATE quality_target set del_flag =2 where quality_id = #{qualityId} |
| | | </update> |
| | | <delete id="deletedByQualityTargetId"> |
| | | DELETE FROM quality_target_mess |
| | | WHERE quality_target_id = #{qualityTargetId}; |
| | | </delete> |
| | | |
| | | <select id="selectByQualityId" resultType="com.gkhy.exam.system.domain.QualityTarget"> |
| | | select `id`,`company_id`,`quality_id`,`message`,`num`,`method`,`calculate`,`data_source`,`depart_name`, |
| | |
| | | and quality_id = #{qualityId} |
| | | </if> |
| | | </select> |
| | | <select id="selectBYQualityTargetId" resultType="com.gkhy.exam.system.domain.QualityTargetMess"> |
| | | SELECT |
| | | `id`, |
| | | `quality_target_id`, |
| | | `num`, |
| | | `method`, |
| | | `calculate`, |
| | | `data_source`, |
| | | `depart_name`, |
| | | `frequency`, |
| | | `duty_name`, |
| | | `remark` |
| | | FROM |
| | | `quality_target_mess` |
| | | where quality_target_id = #{id} |
| | | </select> |
| | | </mapper> |