1.修改表名。

Xiajijian

2025-11-13 d779caf4b08cf06945fc74495c75d42a6466b20b

1.修改表名。

 ard-route/src/main/java/com/ard/route/domain/route/ArdRouteInfo.java

@@ -6,7 +6,7 @@
import lombok.Data;

/**
 * 航线(kmz)对象 ard_route_infor
 * 航线(kmz)对象 ard_route_info
 * 
 * @author xia
 * @date 2025-10-23

 ard-route/src/main/resources/mapper/ArdRouteInfoMapper.xml

@@ -34,7 +34,7 @@
               create_time,
               update_by,
               update_time
        from ard_route_infor
        from ard_route_info
    </sql>

    <select id="selectArdRouteInfoList" parameterType="ArdRouteInfo" resultMap="ArdRouteInfoResult">
@@ -54,7 +54,7 @@
    </select>

    <insert id="insertArdRouteInfo" parameterType="ArdRouteInfo">
        insert into ard_route_infor
        insert into ard_route_info
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="name != null">name,</if>
@@ -88,7 +88,7 @@
    </insert>

    <update id="updateArdRouteInfo" parameterType="ArdRouteInfo">
        update ard_route_infor
        update ard_route_info
        <trim prefix="SET" suffixOverrides=",">
            <if test="name != null">name = #{name},</if>
            <if test="upPath != null">up_path = #{upPath},</if>
@@ -106,11 +106,11 @@
    </update>

    <delete id="deleteArdRouteInfoById" parameterType="String">
        delete from ard_route_infor where id = #{id}
        delete from ard_route_info where id = #{id}
    </delete>

    <delete id="deleteArdRouteInfoByIds" parameterType="String">
        delete from ard_route_infor where id in
        delete from ard_route_info where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
@@ -122,21 +122,21 @@
    </select>

    <delete id="deleteRouteInforByGroupingIds" parameterType="String">
        delete from ard_route_infor where grouping_id in
        delete from ard_route_info where grouping_id in
        <foreach item="groupingIId" collection="array" open="(" separator="," close=")">
            #{groupingIId}
        </foreach>
    </delete>

    <select id="selectArdRouteInfoByGroupingId" parameterType="String" resultMap="ArdRouteInfoResult">
        select id,name,up_path,grouping_id,type,aircraft,payload,is_import,create_by,create_time,update_by,update_time from ard_route_infor
        select id,name,up_path,grouping_id,type,aircraft,payload,is_import,create_by,create_time,update_by,update_time from ard_route_info
        <where>
            <if test="groupingId != null "> and grouping_id = #{groupingId}</if>
        </where>
    </select>

    <update id="updateRouteInforGroupingId">
        update ard_route_infor
        update ard_route_info
        <trim prefix="SET" suffixOverrides=",">
            <if test="groupingId != null">grouping_id = #{groupingId},</if>
        </trim>

 ard-sample/src/main/java/com/ard/sample/wayline/service/impl/WaylineJobServiceImpl.java

@@ -506,7 +506,7 @@
//            messageSender.publish(topic, builder.build());
//            return;
//        }
        // 修改航线文件名称，从ard_route_information航线表中取;
        // 修改航线文件名称，从ard_route_info航线表中取;
        // 换航线表
        ArdRouteInfo ardRouteOpt = _ardRouteInfoService.selectArdRouteInfoById(waylineJob.getFileId());
        if (ardRouteOpt == null) {
@@ -628,7 +628,7 @@
        if (entity == null) {
            return null;
        }
        // 修改航线文件名称，从ard_route_information航线表中取;
        // 修改航线文件名称，从ard_route_info航线表中取;
        WaylineJobDTO.WaylineJobDTOBuilder builder = WaylineJobDTO.builder()
                .jobId(entity.getJobId())
                .jobName(entity.getName())