洪城义警-正式版后台
zengh
2021-07-20 2cc61edcd7ad2f61308f10c7b40cc44d43dbc530
巡逻路线绑定修改
2 files modified
6 ■■■■■ changed files
src/main/java/org/springblade/modules/alarm/mapper/AlarmMapper.xml 4 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/routeIn/mapper/RouteinMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/alarm/mapper/AlarmMapper.xml
@@ -41,6 +41,7 @@
        <result column="baphone" property="baphone"/>
        <result column="deviceName" property="deviceName"/>
        <result column="manufacturers" property="manufacturers"/>
        <result column="xllx" property="xllx"/>
    </resultMap>
    <!-- 通用查询映射结果 -->
@@ -219,7 +220,8 @@
        e.manufacturers,
        a.place as place,
        e.channelNumber,
        u.name as baname,
        a.xllx,
        u.real_name as baname,
        u.id as baid,
        u.phone as baphone
        from sys_alarm a
src/main/java/org/springblade/modules/routeIn/mapper/RouteinMapper.xml
@@ -65,7 +65,7 @@
            and r.routeName  like '%${routeName}%'
        </if>
        <if test="id!=null and id!=''">
            AND d.snumber = #{id}
            AND r.id = #{id}
        </if>
    </select>