大屏网格员运动轨迹接口开发

huanghongfa

2021-10-13 5012de14808b5930a0c338a4ad2bf16fc4ed5151

大屏网格员运动轨迹接口开发

 springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventGridMemberRelationMapper.xml

@@ -644,7 +644,7 @@

    <select id="getGridsMemberTrajectory" resultType="String">
        select lng_lat from event_grid_member_gps_log
        where grid_member_id = #{userId} and create_at > DATE_SUB(DATE_FORMAT(CURDATE(),'%Y-%m-%d %H:%i:%s'),INTERVAL 0 DAY)
        where grid_member_id = #{userId} and create_at > DATE_SUB(DATE_FORMAT(CURDATE(),'%Y-%m-%d 09:00:00'),INTERVAL 0 DAY)
    </select>

</mapper>