修改，内审检查多选人员

“djh”

2026-02-06 88717f3e96fb853f3dbc3d6e6b3de0ba4ce1f3c5

修改，内审检查多选人员

 multi-system/src/main/java/com/gkhy/exam/system/domain/InternalAuditCarryDept.java

@@ -52,7 +52,7 @@

    @ApiModelProperty("审核员id")
    @TableField("check_id")
    private Integer checkId;
    private String checkId;

    @TableField(exist = false)
    private String  checkName;

 multi-system/src/main/java/com/gkhy/exam/system/domain/InternalAuditCheck.java

@@ -50,7 +50,7 @@

    @ApiModelProperty("审核人员")
    @TableField("person_id")
    private Integer personId;
    private String personId;

    @TableField(exist = false)
    private String personName;

 multi-system/src/main/java/com/gkhy/exam/system/service/impl/InternalAuditCarryServiceImpl.java

@@ -13,6 +13,7 @@
import com.gkhy.exam.system.mapper.InternalAuditCheckCatalogueMapper;
import com.gkhy.exam.system.mapper.InternalAuditCheckContentMapper;
import com.gkhy.exam.system.mapper.SysClauseManagementMapper;
import com.gkhy.exam.system.service.ExStudentService;
import com.gkhy.exam.system.service.InternalAuditCarryService;
import com.gkhy.exam.system.service.InternalAuditCheckService;
import org.springframework.beans.factory.annotation.Autowired;
@@ -74,7 +75,7 @@
                .eq(InternalAuditCarry::getYear, carry.getYear())
                .eq(InternalAuditCarry::getDelFlag,1));
        if (internalAuditCarries.size()>0){
            throw new ApiException("当前企业已有相关数据");
            return CommonResult.failed("当前企业已有相关数据");
        }
        carry.setCreateBy(SecurityUtils.getUsername());
        carry.setCreateTime(LocalDateTime.now());

 multi-system/src/main/resources/mapper/system/InternalAuditCarryMapper.xml

@@ -64,11 +64,12 @@
            iacd.`start_time`,
            iacd.`end_time`,
            iacd.`check_id` ,
            su.`name` as check_name
            IFNULL(GROUP_CONCAT(DISTINCT es.`name` SEPARATOR ','), '') AS check_name
        FROM
            internal_audit_carry_dept iacd
                LEFT JOIN sys_user su on iacd.check_id = su.id
        left join  sys_dept sd on iacd.dept_id = sd.dept_id
        LEFT JOIN ex_student es ON FIND_IN_SET(es.`id`, iacd.`check_id`)
        WHERE iacd.carry_id = #{carryId}
        GROUP BY iacd.`id`;
    </select>
</mapper>

 multi-system/src/main/resources/mapper/system/InternalAuditCheckMapper.xml

@@ -13,7 +13,7 @@
            iac.`dept_id`,
            sd.dept_name,
            iac.`person_id`,
            es.`name` as person_name,
            IFNULL(GROUP_CONCAT(DISTINCT es.`name` SEPARATOR ','), '') AS person_name,
            iac.`check_time`,
            iac.`start_time`,
            iac.`end_time`,
@@ -26,12 +26,13 @@
        FROM
            `internal_audit_check` iac
                LEFT JOIN sys_dept sd ON iac.dept_id = sd.dept_id
                LEFT JOIN ex_student es on iac.person_id = es.id
                LEFT JOIN ex_student es ON FIND_IN_SET(es.`id`, iac.`person_id`)
        WHERE
            iac.del_flag = 0
        <if test="companyId!=null">
            and iac.company_id = #{companyId}
        </if>
        GROUP BY iac.`id`
        ORDER BY
            iac.create_time DESC
    </select>