fix:补充提交

swb

2024-09-10 b17623bfee65c5b67894abe7f071c46732b20108

fix:补充提交

 screen-api/src/main/resources/mapper/SecondCruiserSortMapper.xml

@@ -14,8 +14,8 @@
    <select id="getSort" resultType="com.moral.api.entity.SecondCruiserSort">
        select road,avg(value) as "avg",time,mac from second_cruiser_sort
        where mac =#{mac}
        AND `time` <![CDATA[>]]> #{startTime}
        AND `time` <![CDATA[<=]]> #{endTime}
        AND `time` <![CDATA[>=]]> #{startTime}
        AND `time` <![CDATA[<]]> #{endTime}
        GROUP BY road ORDER BY avg DESC

    </select>