按时间段查询走航车轨迹

lizijie

2022-09-06 7e1423190ac72539d3f731b79f5c2ae4a18f58d5

按时间段查询走航车轨迹

 screen-api/src/main/java/com/moral/api/controller/CruiserController.java

@@ -73,7 +73,7 @@
    })
    public ResultMessage carTrajectory(HttpServletRequest request) {
        Map<String, Object> params = WebUtils.getParametersStartingWith(request, null);
        if (!params.containsKey("mac") || !params.containsKey("time")) {
        if (!params.containsKey("mac") || !params.containsKey("time1")|| !params.containsKey("time2")) {
            return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
        }
        List<Map<String, Object>> response = specialDeviceService.carTrajectory(params);

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

@@ -26,7 +26,8 @@
        `value`
        FROM `history_second_cruiser`
        WHERE mac = #{mac}
        AND `time` LIKE #{time}"%"
        AND `time` <![CDATA[>=]]> #{time1}
        AND `time` <![CDATA[<=]]> #{time2}
        AND organization_id = #{orgId}
    </select>