fix: flowerCategory

cloudroam

2024-12-25 c4a9df30886cf5efc674c317a2889d201ed92d8b

fix: flowerCategory

 src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml

@@ -69,7 +69,9 @@
            AND oi.station_id = #{dto.stationId}
        </if>
        <if test="dto.flowerCategory != null">
            AND f.category = #{dto.flowerCategory}
            AND ( f.category = #{dto.flowerCategory} or f.category in (
            select id from t_flower_category where parent_id = #{dto.flowerCategory}
            ))
        </if>
        <if test="dto.flowerLevel != null and dto.flowerLevel != ''">
            AND oi.flower_level = #{dto.flowerLevel}