1. 增加精细化巡检分组业务。

Xiajijian

2026-01-15 8880fdbc3a4f66837e43eacbcef1ca55845c5e64

1. 增加精细化巡检分组业务。

 ard-admin/pom.xml

@@ -80,6 +80,12 @@
            <groupId>de.codecentric</groupId>
            <artifactId>spring-boot-admin-starter-client</artifactId>
        </dependency>
        <dependency>
            <groupId>com.ard</groupId>
            <artifactId>ard-inspection</artifactId>
            <version>3.8.8</version>
            <scope>compile</scope>
        </dependency>
    </dependencies>

    <build>

 ard-admin/src/main/java/com/ard/web/controller/inspection/ArdInspectionGroupController.java

New file
@@ -0,0 +1,129 @@
package com.ard.web.controller.inspection;

import java.util.List;
import javax.servlet.http.HttpServletResponse;

import com.ard.common.annotation.Log;
import com.ard.common.core.controller.BaseController;
import com.ard.common.core.domain.AjaxResult;
import com.ard.common.core.page.TableDataInfo;
import com.ard.common.enums.BusinessType;
import com.ard.common.utils.poi.ExcelUtil;
import com.ard.inspection.domain.ArdInspectionGroup;
import com.ard.inspection.service.IArdInspectionGroupService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * 精细化巡检分组Controller
 * 
 * @author xia
 * @date 2026-01-15
 */
@Api(tags = "精细化巡检分组")
@RestController
@RequestMapping("/inspection/group")
public class ArdInspectionGroupController extends BaseController {

    @Autowired
    private IArdInspectionGroupService ardInspectionGroupService;

    /**
     * 查询精细化巡检分组列表
     */
    @ApiOperation("查询精细化巡检分组列表")
    @PreAuthorize("@ss.hasPermi('inspection:group:list')")
    @GetMapping("/list")
    public TableDataInfo list(ArdInspectionGroup ardInspectionGroup) {
        startPage();
        List<ArdInspectionGroup> list = ardInspectionGroupService.selectArdInspectionGroupList(ardInspectionGroup);
        return getDataTable(list);
    }

    /**
     * 导出精细化巡检分组列表
     */
    @ApiOperation("导出精细化巡检分组列表")
    @PreAuthorize("@ss.hasPermi('inspection:group:export')")
    @Log(title = "精细化巡检分组", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ArdInspectionGroup ardInspectionGroup) {
        List<ArdInspectionGroup> list = ardInspectionGroupService.selectArdInspectionGroupList(ardInspectionGroup);
        ExcelUtil<ArdInspectionGroup> util = new ExcelUtil<ArdInspectionGroup>(ArdInspectionGroup.class);
        util.exportExcel(response, list, "精细化巡检分组数据");
    }

    /**
     * 获取精细化巡检分组详细信息
     */
    @ApiOperation("获取精细化巡检分组详细信息")
    @PreAuthorize("@ss.hasPermi('inspection:group:query')")
    @GetMapping(value = "/{groupId}")
    public AjaxResult getInfo(@PathVariable("groupId") Long groupId) {
        ardInspectionGroupService.checkInspectionGroupDataScope(groupId);
        return success(ardInspectionGroupService.selectArdInspectionGroupByGroupId(groupId));
    }

    /**
     * 新增精细化巡检分组
     */
    @ApiOperation("新增精细化巡检分组")
    @PreAuthorize("@ss.hasPermi('inspection:group:add')")
    @Log(title = "精细化巡检分组", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ArdInspectionGroup ardInspectionGroup) {
        if (ardInspectionGroupService.checkInspectionGroupNameUnique(ardInspectionGroup)){
            return error("新增分组'" + ardInspectionGroup.getGroupName() + "'失败，分组名称已存在");
        }
        ardInspectionGroup.setCreateBy(getUsername());
        return toAjax(ardInspectionGroupService.insertArdInspectionGroup(ardInspectionGroup));
    }

    /**
     * 修改精细化巡检分组
     */
    @ApiOperation("修改精细化巡检分组")
    @PreAuthorize("@ss.hasPermi('inspection:group:edit')")
    @Log(title = "精细化巡检分组", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ArdInspectionGroup ardInspectionGroup) {
        Long groupId = ardInspectionGroup.getGroupId();
        ardInspectionGroupService.checkInspectionGroupDataScope(groupId);
        if (!ardInspectionGroupService.checkInspectionGroupNameUnique(ardInspectionGroup)){
            return error("修改分组'" + ardInspectionGroup.getGroupName() + "'失败，分组名称已存在");
        } else if (ardInspectionGroup.getGroupParentId().equals(groupId)) {
            return error("修改分组'" + ardInspectionGroup.getGroupName() + "'失败，上级分组不能是自己");
        }
        ardInspectionGroup.setUpdateBy(getUsername());
        return toAjax(ardInspectionGroupService.updateArdInspectionGroup(ardInspectionGroup));
    }

    /**
     * 删除精细化巡检分组
     */
    @ApiOperation("删除精细化巡检分组")
    @PreAuthorize("@ss.hasPermi('inspection:group:remove')")
    @Log(title = "精细化巡检分组", businessType = BusinessType.DELETE)
    @DeleteMapping("/{groupId}")
    public AjaxResult remove(@PathVariable Long groupId) {
        if (ardInspectionGroupService.hasChildByInspectionGroupId(groupId)){
            return warn("存在下级分组,不允许删除");
        }
        if (ardInspectionGroupService.checkInspectionGroupExistUser(groupId)){
            return warn("分组存在用户,不允许删除");
        }
        ardInspectionGroupService.checkInspectionGroupDataScope(groupId);
        return toAjax(ardInspectionGroupService.deleteArdInspectionGroupByGroupId(groupId));
    }

}

 ard-admin/src/main/java/com/ard/web/core/config/ApiGroup.java

@@ -12,7 +12,8 @@
    DEVICE("设备接口", "com.ard.web.controller.device", "设备管理接口"),
    DATA("数据接口", "com.ard.web.controller.data", "数据管理接口"),
    STORAGE("存储接口", "com.ard.web.controller.storage", "存储管理接口"),
    ROUTE("航线接口", "com.ard.web.controller.route", "航线管理接口");
    ROUTE("航线接口", "com.ard.web.controller.route", "航线管理接口"),
    INSPECTION("巡检接口", "com.ard.web.controller.inspection", "巡检管理接口");

    // 分组名
    private final String groupName;

 ard-admin/src/main/java/com/ard/web/core/config/SwaggerConfig.java

@@ -40,9 +40,11 @@
                .apiInfo(apiInfo(apiGroup.getTitle()))
                .select()
                .apis(requestHandler ->
                        requestHandler.declaringClass().getPackage().getName()
                                .startsWith(apiGroup.getPackagePath()) &&
                                requestHandler.isAnnotatedWith(io.swagger.annotations.ApiOperation.class)
                        requestHandler
                                .declaringClass()
                                .getPackage()
                                .getName()
                                .startsWith(apiGroup.getPackagePath()) && requestHandler.isAnnotatedWith(io.swagger.annotations.ApiOperation.class)
                )
                .paths(PathSelectors.any())
                .build()
@@ -90,6 +92,11 @@
        return createApiDocket(ApiGroup.ROUTE);
    }

    @Bean
    public Docket inspectionApi() {
        return createApiDocket(ApiGroup.INSPECTION);
    }

    /**
     * 安全模式，这里指定token通过Authorization头请求头传递
     */

 ard-inspection/pom.xml

New file
@@ -0,0 +1,32 @@
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>ard</artifactId>
        <groupId>com.ard</groupId>
        <version>3.8.8</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>ard-inspection</artifactId>

    <description>
        inspection精细巡检
    </description>

    <dependencies>

        <dependency>
            <groupId>com.ard</groupId>
            <artifactId>ard-common</artifactId>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

    </dependencies>

</project>

 ard-inspection/src/main/java/com/ard/inspection/domain/ArdInspectionGroup.java

New file
@@ -0,0 +1,37 @@
package com.ard.inspection.domain;

import com.ard.common.annotation.Excel;
import com.ard.common.core.domain.BaseEntity;
import lombok.Data;

/**
 * 精细化巡检分组对象 ard_inspection_group
 * 
 * @author xia
 * @date 2026-01-15
 */
@Data
public class ArdInspectionGroup extends BaseEntity {

    private static final long serialVersionUID = 1L;

    /** 分组id */
    private Long groupId;

    /** 分组父部门id */
    @Excel(name = "分组父部门id")
    private Long groupParentId;

    /** 祖级列表 */
    @Excel(name = "祖级列表")
    private String ancestors;

    /** 分组名称 */
    @Excel(name = "分组名称")
    private String groupName;

    /** 显示顺序 */
    @Excel(name = "显示顺序")
    private Long orderNum;

}

 ard-inspection/src/main/java/com/ard/inspection/mapper/ArdInspectionGroupMapper.java

New file
@@ -0,0 +1,106 @@
package com.ard.inspection.mapper;

import com.ard.common.core.domain.entity.SysDept;
import com.ard.inspection.domain.ArdInspectionGroup;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 精细化巡检分组Mapper接口
 * 
 * @author xia
 * @date 2026-01-15
 */
public interface ArdInspectionGroupMapper {

    /**
     * 查询精细化巡检分组
     * 
     * @param groupId 精细化巡检分组主键
     * @return 精细化巡检分组
     */
    public ArdInspectionGroup selectArdInspectionGroupByGroupId(Long groupId);

    /**
     * 查询精细化巡检分组列表
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 精细化巡检分组集合
     */
    public List<ArdInspectionGroup> selectArdInspectionGroupList(ArdInspectionGroup ardInspectionGroup);

    /**
     * 新增精细化巡检分组
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    public int insertArdInspectionGroup(ArdInspectionGroup ardInspectionGroup);

    /**
     * 修改精细化巡检分组
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    public int updateArdInspectionGroup(ArdInspectionGroup ardInspectionGroup);

    /**
     * 删除精细化巡检分组
     * 
     * @param groupId 精细化巡检分组主键
     * @return 结果
     */
    public int deleteArdInspectionGroupByGroupId(Long groupId);

    /**
     * 批量删除精细化巡检分组
     * 
     * @param groupIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteArdInspectionGroupByGroupIds(Long[] groupIds);

    /**
     * 校验分组名称是否唯一
     *
     * @param groupName 分组名称
     * @param groupParentId 分组父部门ID
     * @return 结果
     */
    public ArdInspectionGroup checkInspectionGroupNameUnique(@Param("groupName") String groupName,
                                                             @Param("groupParentId") Long groupParentId);

    /**
     * 根据ID查询所有子分组
     *
     * @param groupId 分组ID
     * @return 部门列表
     */
    public List<ArdInspectionGroup> selectChildrenInspectionGroupById(Long groupId);

    /**
     * 修改子元素关系
     *
     * @param inspectionGroups 子元素
     * @return 结果
     */
    public int updateInspectionGroupChildren(@Param("inspectionGroups") List<ArdInspectionGroup> inspectionGroups);

    /**
     * 是否存在分组子节点
     *
     * @param groupId 分组ID
     * @return 结果
     */
    public int hasChildByInspectionGroupId(Long groupId);

    /**
     * 查询分组是否存在用户
     *
     * @param groupId 分组ID
     * @return 结果 true 存在 false 不存在
     */
    public int checkInspectionGroupExistUser(Long groupId);
}

 ard-inspection/src/main/java/com/ard/inspection/service/IArdInspectionGroupService.java

New file
@@ -0,0 +1,86 @@
package com.ard.inspection.service;

import com.ard.inspection.domain.ArdInspectionGroup;

import java.util.List;

/**
 * 精细化巡检分组Service接口
 * 
 * @author xia
 * @date 2026-01-15
 */
public interface IArdInspectionGroupService {

    /**
     * 查询精细化巡检分组
     * 
     * @param groupId 精细化巡检分组主键
     * @return 精细化巡检分组
     */
    public ArdInspectionGroup selectArdInspectionGroupByGroupId(Long groupId);

    /**
     * 查询精细化巡检分组列表
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 精细化巡检分组集合
     */
    public List<ArdInspectionGroup> selectArdInspectionGroupList(ArdInspectionGroup ardInspectionGroup);

    /**
     * 新增精细化巡检分组
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    public int insertArdInspectionGroup(ArdInspectionGroup ardInspectionGroup);

    /**
     * 修改精细化巡检分组
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    public int updateArdInspectionGroup(ArdInspectionGroup ardInspectionGroup);

    /**
     * 删除精细化巡检分组信息
     * 
     * @param groupId 精细化巡检分组主键
     * @return 结果
     */
    public int deleteArdInspectionGroupByGroupId(Long groupId);

    /**
     * 校验分组名称是否唯一
     *
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    public boolean checkInspectionGroupNameUnique(ArdInspectionGroup ardInspectionGroup);

    /**
     * 校验分组是否有数据权限
     *
     * @param groupId 精细化巡检分组主键
     */
    public void checkInspectionGroupDataScope(Long groupId);

    /**
     * 是否存在分组子节点
     *
     * @param groupId 分组ID
     * @return 结果
     */
    public boolean hasChildByInspectionGroupId(Long groupId);

    /**
     * 查询分组是否存在用户
     *
     * @param groupId 分组ID
     * @return 结果 true 存在 false 不存在
     */
    public boolean checkInspectionGroupExistUser(Long groupId);

}

 ard-inspection/src/main/java/com/ard/inspection/service/impl/ArdInspectionGroupServiceImpl.java

New file
@@ -0,0 +1,173 @@
package com.ard.inspection.service.impl;

import java.util.List;

import com.ard.common.annotation.DataScope;
import com.ard.common.constant.UserConstants;
import com.ard.common.core.domain.entity.SysUser;
import com.ard.common.exception.ServiceException;
import com.ard.common.utils.DateUtils;
import com.ard.common.utils.SecurityUtils;
import com.ard.common.utils.StringUtils;
import com.ard.common.utils.spring.SpringUtils;
import com.ard.inspection.domain.ArdInspectionGroup;
import com.ard.inspection.mapper.ArdInspectionGroupMapper;
import com.ard.inspection.service.IArdInspectionGroupService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * 精细化巡检分组Service业务层处理
 * 
 * @author xia
 * @date 2026-01-15
 */
@Service
public class ArdInspectionGroupServiceImpl implements IArdInspectionGroupService {

    @Autowired
    private ArdInspectionGroupMapper ardInspectionGroupMapper;

    /**
     * 查询精细化巡检分组
     * 
     * @param groupId 精细化巡检分组主键
     * @return 精细化巡检分组
     */
    @Override
    public ArdInspectionGroup selectArdInspectionGroupByGroupId(Long groupId) {
        return ardInspectionGroupMapper.selectArdInspectionGroupByGroupId(groupId);
    }

    /**
     * 查询精细化巡检分组列表
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 精细化巡检分组
     */
    @Override
    @DataScope(deptAlias = "d")
    public List<ArdInspectionGroup> selectArdInspectionGroupList(ArdInspectionGroup ardInspectionGroup) {
        return ardInspectionGroupMapper.selectArdInspectionGroupList(ardInspectionGroup);
    }

    /**
     * 新增精细化巡检分组
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    @Override
    public int insertArdInspectionGroup(ArdInspectionGroup ardInspectionGroup) {
        ardInspectionGroup.setCreateTime(DateUtils.getNowDate());
        return ardInspectionGroupMapper.insertArdInspectionGroup(ardInspectionGroup);
    }

    /**
     * 修改精细化巡检分组
     * 
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    @Override
    public int updateArdInspectionGroup(ArdInspectionGroup ardInspectionGroup) {

        ArdInspectionGroup newGroup = ardInspectionGroupMapper.selectArdInspectionGroupByGroupId(ardInspectionGroup.getGroupParentId());
        ArdInspectionGroup oldGroup = ardInspectionGroupMapper.selectArdInspectionGroupByGroupId(ardInspectionGroup.getGroupId());
        if(StringUtils.isNotNull(newGroup) && StringUtils.isNotNull(oldGroup)){
            String newAncestors = newGroup.getAncestors() + "," + newGroup.getGroupId();
            String oldAncestors = oldGroup.getAncestors();
            ardInspectionGroup.setAncestors(newAncestors);
            updateInspectionGroupChildren(ardInspectionGroup.getGroupId(), newAncestors, oldAncestors);
        }
        ardInspectionGroup.setUpdateTime(DateUtils.getNowDate());
        return ardInspectionGroupMapper.updateArdInspectionGroup(ardInspectionGroup);
    }

    /**
     * 修改子元素关系
     *
     * @param groupId 被修改的分组ID
     * @param newAncestors 新的父ID集合
     * @param oldAncestors 旧的父ID集合
     */
    public void updateInspectionGroupChildren(Long groupId, String newAncestors, String oldAncestors){
        List<ArdInspectionGroup> children = ardInspectionGroupMapper.selectChildrenInspectionGroupById(groupId);
        for (ArdInspectionGroup child : children) {
            child.setAncestors(child.getAncestors().replaceFirst(oldAncestors, newAncestors));
        }
        if (!children.isEmpty()){
            ardInspectionGroupMapper.updateInspectionGroupChildren(children);
        }
    }

    /**
     * 删除精细化巡检分组信息
     * 
     * @param groupId 精细化巡检分组主键
     * @return 结果
     */
    @Override
    public int deleteArdInspectionGroupByGroupId(Long groupId) {
        return ardInspectionGroupMapper.deleteArdInspectionGroupByGroupId(groupId);
    }

    /**
     * 校验分组名称是否唯一
     *
     * @param ardInspectionGroup 精细化巡检分组
     * @return 结果
     */
    @Override
    public boolean checkInspectionGroupNameUnique(ArdInspectionGroup ardInspectionGroup) {
        Long groupId = StringUtils.isNull(ardInspectionGroup.getGroupId()) ? -1L : ardInspectionGroup.getGroupId();
        ArdInspectionGroup info = ardInspectionGroupMapper.checkInspectionGroupNameUnique(ardInspectionGroup.getGroupName(),ardInspectionGroup.getGroupParentId());
        if (StringUtils.isNotNull(info) && info.getGroupId().longValue() != groupId.longValue())
        {
            return UserConstants.NOT_UNIQUE;
        }
        return UserConstants.UNIQUE;
    }

    /**
     * 校验分组是否有数据权限
     *
     * @param groupId 精细化巡检分组主键
     */
    @Override
    public void checkInspectionGroupDataScope(Long groupId) {
        if (!SysUser.isAdmin(SecurityUtils.getUserId()) && StringUtils.isNotNull(groupId)){
            ArdInspectionGroup group = new ArdInspectionGroup();
            group.setGroupId(groupId);
            List<ArdInspectionGroup> groups = SpringUtils.getAopProxy(this).selectArdInspectionGroupList(group);
            if (StringUtils.isEmpty(groups)){
                throw new ServiceException("没有权限访问分组数据！");
            }
        }
    }

    /**
     * 是否存在分组子节点
     *
     * @param groupId 分组ID
     * @return 结果
     */
    @Override
    public boolean hasChildByInspectionGroupId(Long groupId) {
        int result = ardInspectionGroupMapper.hasChildByInspectionGroupId(groupId);
        return result > 0;
    }

    /**
     * 查询分组是否存在用户
     *
     * @param groupId 分组ID
     * @return 结果 true 存在 false 不存在
     */
    @Override
    public boolean checkInspectionGroupExistUser(Long groupId) {
        int result = ardInspectionGroupMapper.checkInspectionGroupExistUser(groupId);
        return result > 0;
    }

}

 ard-inspection/src/main/resources/mapper/ArdInspectionGroupMapper.xml

New file
@@ -0,0 +1,130 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ard.inspection.mapper.ArdInspectionGroupMapper">
    
    <resultMap type="ArdInspectionGroup" id="ArdInspectionGroupResult">
        <result property="groupId"    column="group_id"    />
        <result property="groupParentId"    column="group_parent_id"    />
        <result property="ancestors"    column="ancestors"    />
        <result property="groupName"    column="group_name"    />
        <result property="orderNum"    column="order_num"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectArdInspectionGroupVo">
        select group_id,
               group_parent_id,
               ancestors,
               group_name,
               order_num,
               create_by,
               create_time,
               update_by,
               update_time
        from ard_inspection_group
    </sql>

    <select id="selectArdInspectionGroupList" parameterType="ArdInspectionGroup" resultMap="ArdInspectionGroupResult">
        <include refid="selectArdInspectionGroupVo"/>
        <where>  
            <if test="groupParentId != null "> and group_parent_id = #{groupParentId}</if>
            <if test="ancestors != null  and ancestors != ''"> and ancestors = #{ancestors}</if>
            <if test="groupName != null  and groupName != ''"> and group_name like concat('%', #{groupName}, '%')</if>
            <if test="orderNum != null "> and order_num = #{orderNum}</if>
        </where>
    </select>
    
    <select id="selectArdInspectionGroupByGroupId" parameterType="Long" resultMap="ArdInspectionGroupResult">
        <include refid="selectArdInspectionGroupVo"/>
        where group_id = #{groupId}
    </select>

    <insert id="insertArdInspectionGroup" parameterType="ArdInspectionGroup" useGeneratedKeys="true" keyProperty="groupId">
        insert into ard_inspection_group
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="groupParentId != null">group_parent_id,</if>
            <if test="ancestors != null">ancestors,</if>
            <if test="groupName != null">group_name,</if>
            <if test="orderNum != null">order_num,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="groupParentId != null">#{groupParentId},</if>
            <if test="ancestors != null">#{ancestors},</if>
            <if test="groupName != null">#{groupName},</if>
            <if test="orderNum != null">#{orderNum},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
         </trim>
    </insert>

    <update id="updateArdInspectionGroup" parameterType="ArdInspectionGroup">
        update ard_inspection_group
        <trim prefix="SET" suffixOverrides=",">
            <if test="groupParentId != null">group_parent_id = #{groupParentId},</if>
            <if test="ancestors != null">ancestors = #{ancestors},</if>
            <if test="groupName != null">group_name = #{groupName},</if>
            <if test="orderNum != null">order_num = #{orderNum},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
        </trim>
        where group_id = #{groupId}
    </update>

    <delete id="deleteArdInspectionGroupByGroupId" parameterType="Long">
        delete from ard_inspection_group where group_id = #{groupId}
    </delete>

    <delete id="deleteArdInspectionGroupByGroupIds" parameterType="String">
        delete from ard_inspection_group where group_id in 
        <foreach item="groupId" collection="array" open="(" separator="," close=")">
            #{groupId}
        </foreach>
    </delete>

    <select id="checkInspectionGroupNameUnique" resultMap="ArdInspectionGroupResult">
        <include refid="selectArdInspectionGroupVo"/>
        where group_name=#{groupName}
        and group_parent_id = #{groupParentId}
        and del_flag = '0' limit 1
    </select>

    <select id="selectChildrenInspectionGroupById" parameterType="Long" resultMap="ArdInspectionGroupResult">
        select * from ard_inspection_group where find_in_set(#{groupId}, ancestors)
    </select>

    <update id="updateInspectionGroupChildren" parameterType="java.util.List">
        update ard_inspection_group set ancestors =
        <foreach collection="inspectionGroups" item="item" index="index"
                 separator=" " open="case group_id" close="end">
            when #{item.groupId} then #{item.ancestors}
        </foreach>
        where group_id in
        <foreach collection="inspectionGroups" item="item" index="index"
                 separator="," open="(" close=")">
            #{item.groupId}
        </foreach>
    </update>

    <select id="hasChildByInspectionGroupId" parameterType="Long" resultType="int">
        select count(1) from ard_inspection_group
        where group_parent_id = #{groupId} limit 1
    </select>

    <select id="checkInspectionGroupExistUser" parameterType="Long" resultType="int">
        select count(1) from sys_user where group_id = #{groupId} and del_flag = '0'
    </select>

</mapper>