multi-system/src/main/java/com/gkhy/exam/system/domain/QualityInformationInside.java
@@ -55,7 +55,7 @@ @ApiModelProperty(value = "责任单位") @TableField("duty_unit_id") private Integer dutyUnitId; private String dutyUnitId; @TableField(exist = false) private String dutyUnitName; @@ -66,14 +66,14 @@ @ApiModelProperty(value = "反馈单位") @TableField("feed_unit_id") private Integer feedUnitId; private String feedUnitId; @TableField(exist = false) private String feedUnitName; @ApiModelProperty(value = "反馈人") @TableField("feed_user_id") private Integer feedUserId; private String feedUserId; @TableField(exist = false) private String feedUserName; multi-system/src/main/resources/mapper/system/QualityInformationInsideMapper.xml
@@ -14,12 +14,9 @@ qi.`product_model`, qi.`product_number`, qi.`duty_unit_id`, sd1.`dept_name` as duty_unit_name, qi.`part_num`, qi.`feed_unit_id`, sd2.`dept_name` as feed_unit_name, qi.`feed_user_id`, su1.`name` as feed_user_name, qi.`feed_time`, qi.`feed_question`, qi.`dispose`, @@ -49,15 +46,12 @@ qi.`update_time` FROM `quality_information_inside` qi LEFT JOIN sys_user su1 ON qi.feed_user_id = su1.id LEFT JOIN sys_user su2 ON qi.dispose_id = su2.id LEFT JOIN sys_user su3 ON qi.check_out_id = su3.id LEFT JOIN sys_user su4 ON qi.review_id = su4.id LEFT JOIN sys_user su5 ON qi.team_id = su5.id LEFT JOIN sys_user su6 ON qi.duty_leader_id = su6.id LEFT JOIN sys_company sc ON qi.company_id = sc.id LEFT JOIN sys_dept sd1 ON qi.duty_unit_id = sd1.dept_id LEFT JOIN sys_dept sd2 ON qi.feed_unit_id = sd2.dept_id WHERE qi.del_flag = 0 <if test="companyId!=null">