地图相关资源

fengxiang

2018-05-22 6006fe5d31237a7b45214b81069c17c2d155e9fb

地图相关资源

 src/main/resources/mapper/DeviceMapper.xml

@@ -175,17 +175,17 @@
            mpt.organization_id =  #{orgId}
        </if>
            and dev.is_delete = 0
            and (
            <![CDATA[
             1 <> 1
            ]]>
            <if test="devState!=null">
                and dev.state = #{devState}
            </if>
            <if test="name!=null and ''!=name">
                or dev.name like CONCAT('%',#{name},'%')
                and
                (
                dev.name like CONCAT('%',#{name},'%')
                or dev.mac like CONCAT('%',#{name},'%')
                or mpt.name like CONCAT('%',#{name},'%')
                )
            </if>
            )

        </where>
    </select>
    <select id="selectByOrgIdAndMpId" resultMap="BaseResultMap">

 src/main/resources/mapper/MonitorPointMapper.xml

@@ -121,4 +121,10 @@
    <select id="selectOrganizationIds" parameterType="integer" resultType="integer">
                call proc_organizationIds_GetByMonitorPointId(#{id,jdbcType=NUMERIC})
    </select>
    <select id="selectVersionsById" parameterType="integer" resultType="integer">
            select version from device_version dve
            right join device dev  on dve.id = dev.device_version_id
            right join monitor_point mpt on mpt.id = dev.monitor_point_id
            where mpt.id = #{id}  ORDER BY version DESC
    </select>
</mapper>