springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ConvenientElevatingPointServiceImpl.java
@@ -153,7 +153,8 @@ .ge(ConvenientElevatingPointDO::getLat, minLng) .le(ConvenientElevatingPointDO::getLat, maxLng) .ge(ConvenientElevatingPointDO::getLon, minLat) .le(ConvenientElevatingPointDO::getLon, maxLat)); .le(ConvenientElevatingPointDO::getLon, maxLat) .eq(ConvenientElevatingPointDO::getBusinessStatus,1)); List<ConvenientElevatingPointVO> convenientElevatingPointVOS = new ArrayList<>(); convenientElevatingPointDOS.forEach(f -> { ConvenientElevatingPointVO convenientElevatingPointVO = new ConvenientElevatingPointVO(); springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComConvenientElevatingPointMapper.xml
@@ -59,7 +59,7 @@ LEFT JOIN com_shop_flower_order csfo ON ccep.id = csfo.point_id LEFT JOIN com_shop_flower_order_goods og ON og.order_id = csfo.id WHERE csfo.`status` = 1 csfo.`status` = 1 and ccep.business_status = 1 <if test="pageComFlowerOrderDeliveryDTO.storeId != null"> and csfo.store_id = #{pageComFlowerOrderDeliveryDTO.storeId} </if> @@ -73,7 +73,7 @@ LEFT JOIN com_shop_flower_order csfo ON ccep.id = csfo.point_id LEFT JOIN com_shop_flower_order_goods og ON og.order_id = csfo.id WHERE csfo.`status` = 1 csfo.`status` = 1 and ccep.business_status = 1 <if test="pageComFlowerOrderListDTO.storeId != null"> and csfo.store_id = #{pageComFlowerOrderListDTO.storeId} </if>