From bee9e18c3af284ff432a4472f1d409f5a6dc09a7 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期二, 06 十月 2026 16:59:15 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/main'
---
traffic-audit-server/src/main/java/com/trafficaudit/observation/mapper/ObservationStationFlowMapper.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git a/traffic-audit-server/src/main/java/com/trafficaudit/observation/mapper/ObservationStationFlowMapper.java b/traffic-audit-server/src/main/java/com/trafficaudit/observation/mapper/ObservationStationFlowMapper.java
new file mode 100644
index 0000000..c8055d5
--- /dev/null
+++ b/traffic-audit-server/src/main/java/com/trafficaudit/observation/mapper/ObservationStationFlowMapper.java
@@ -0,0 +1,31 @@
+package com.trafficaudit.observation.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.trafficaudit.observation.dto.ObservationDateSummary;
+import com.trafficaudit.observation.dto.ObservationDailyOperation;
+import com.trafficaudit.observation.entity.ObservationStationFlow;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
+import java.time.LocalDate;
+
+@Mapper
+public interface ObservationStationFlowMapper extends BaseMapper<ObservationStationFlow> {
+
+ @Select("SELECT obs_date, COUNT(*) AS station_count, "
+ + "SUM(small_medium_passenger) AS small_medium_passenger_total, "
+ + "MAX(updated_at) AS imported_at "
+ + "FROM observation_station_flow GROUP BY obs_date ORDER BY obs_date ASC")
+ List<ObservationDateSummary> selectDateSummary();
+
+ @Select("SELECT obs_date, COUNT(*) AS station_count, "
+ + "AVG(vehicle_speed) AS average_speed, "
+ + "AVG(congestion_degree) AS average_congestion "
+ + "FROM observation_station_flow "
+ + "WHERE obs_date BETWEEN #{startDate} AND #{endDate} "
+ + "GROUP BY obs_date ORDER BY obs_date ASC")
+ List<ObservationDailyOperation> selectDailyOperations(@Param("startDate") LocalDate startDate,
+ @Param("endDate") LocalDate endDate);
+}
--
Gitblit v1.9.1