任务，报汛列表添加经纬度

guoshilong

2024-04-16 64aa4a10453865d1abb67f14698fe95e1614dfe2

任务，报汛列表添加经纬度

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolTaskMapper.xml

@@ -25,7 +25,9 @@
        spt2.name as patrolTypeName,
        u.real_name toUserName,
        u2.real_name createUserName,
        arb."res_loc"  regionName
        arb."res_loc"  regionName,
        arb."center_long" lon,
        arb."center_lat" lat
        FROM sm_patrol_task spt
        left join sm_patrol_type spt2 on spt.task_type = spt2.id
        LEFT JOIN blade_user u ON u.id = spt.to_user_id

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml

@@ -37,6 +37,8 @@

        <result property="engScal" column="engScal"/>
        <result property="resRegCode" column="resRegCode"/>
        <result property="lon" column="lon"/>
        <result property="lat" column="lat"/>

    </resultMap>

@@ -47,6 +49,8 @@

        arb."res_reg_code" as resRegCode,
        arb."eng_scal" as engScal,
        arb."center_long" lon,
        arb."center_lat" lat,

        case when town."ad_grad" = 4 THEN town."ad_code" ELSE NULL END AS townCode,
        case when town."ad_grad" = 4 THEN town."ad_name" ELSE NULL END AS townName,

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/vo/ReportFloodRecordVO.java

@@ -34,5 +34,6 @@
    //工程规模
    private String engScal;


    private String lon;
    private String lat;
}