商业街距离计算修改

puhanshu

2022-01-17 2262a63ebeaf657feff4c1284c10174867fc8df0

商业街距离计算修改

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/McsInformationMapper.xml

@@ -92,12 +92,7 @@
            ORDER BY t1.created_at DESC
        ) temp WHERE 1=1
        <if test="pageMcsInformationDTO.distance != null">
            <if test="pageMcsInformationDTO.isMore != null and pageMcsInformationDTO.isMore ==1">
                AND distance &gt; #{pageMcsInformationDTO.distance}
            </if>
            <if test="pageMcsInformationDTO.isMore == null">
                AND distance &lt;= #{pageMcsInformationDTO.distance}
            </if>
            AND distance &lt;= #{pageMcsInformationDTO.distance}
        </if>
    </select>