From 5b34a1458e74f8902d01ebd844c2954f554c9e74 Mon Sep 17 00:00:00 2001
From: xiazhengtongxue <133085197+xiazhengtongxue@users.noreply.github.com>
Date: 星期四, 30 四月 2026 11:05:37 +0800
Subject: [PATCH] 1
---
Code/WMS/WIDESEA_WMSServer/WIDESEA_WMSServer/Controllers/Dashboard/DashboardController.cs | 118 ++++++++++++++++++++++++++++++++++++++++------------------
1 files changed, 81 insertions(+), 37 deletions(-)
diff --git a/Code/WMS/WIDESEA_WMSServer/WIDESEA_WMSServer/Controllers/Dashboard/DashboardController.cs b/Code/WMS/WIDESEA_WMSServer/WIDESEA_WMSServer/Controllers/Dashboard/DashboardController.cs
index 3384bde..da08436 100644
--- a/Code/WMS/WIDESEA_WMSServer/WIDESEA_WMSServer/Controllers/Dashboard/DashboardController.cs
+++ b/Code/WMS/WIDESEA_WMSServer/WIDESEA_WMSServer/Controllers/Dashboard/DashboardController.cs
@@ -71,10 +71,10 @@
}
/// <summary>
- /// 姣忔棩缁熻
+ /// 姣忔棩缁熻锛堟寜宸烽亾鍙峰垎缁勶紝鎸囧畾浠撳簱锛�
/// </summary>
[HttpGet("DailyStats"), AllowAnonymous]
- public async Task<WebResponseContent> DailyStats([FromQuery] int days = 30)
+ public async Task<WebResponseContent> DailyStats([FromQuery] int days = 10)
{
try
{
@@ -84,9 +84,16 @@
var startDate = DateTime.Today.AddDays(-days + 1);
var endDate = DateTime.Today; // 鍖呭惈浠婂ぉ
+ // 鎸囧畾瑕佺粺璁＄殑浠撳簱锛堝贩閬撳彿锛�
+ var specifiedRoadways = new List<string>
+ {
+ "GWSC1", "CWSC1", "HCSC1", "ZJSC1", "FJSC1"
+ };
+
var query = await _db.Queryable<Dt_Task_Hty>()
.Where(t => t.InsertTime >= startDate && t.InsertTime <= endDate)
- .Select(t => new { t.InsertTime, t.TaskType })
+ .Where(t => specifiedRoadways.Contains(t.Roadway)) // 鍙煡璇㈡寚瀹氬贩閬撳彿鐨勬暟鎹�
+ .Select(t => new { t.InsertTime, t.TaskType, t.Roadway })
.ToListAsync();
// 鐢熸垚鏃ユ湡鑼冨洿
@@ -96,40 +103,57 @@
allDates.Add(date);
}
- // 鎸夋棩鏈熷垎缁勭粺璁�
+ // 鎸夊贩閬撳彿鍜屾棩鏈熷垎缁勭粺璁�
var groupedData = query
- .GroupBy(t => t.InsertTime.Date)
+ .GroupBy(t => new { t.Roadway, Date = t.InsertTime.Date })
.Select(g => new
{
- Date = g.Key,
+ Roadway = g.Key.Roadway,
+ Date = g.Key.Date,
Inbound = g.Count(t => t.TaskType >= 200 && t.TaskType < 300),
Outbound = g.Count(t => t.TaskType >= 100 && t.TaskType < 200)
})
- .ToDictionary(x => x.Date, x => x);
+ .ToList();
- // 琛ュ叏缂哄け鏃ユ湡
- var result = allDates.Select(date =>
+ // 鏋勫缓缁撴灉锛氭瘡涓寚瀹氫粨搴撳搴斾竴涓棩鏈熷垪琛�
+ var result = specifiedRoadways.Select(roadway =>
{
- if (groupedData.TryGetValue(date, out var data))
+ // 鑾峰彇璇ュ贩閬撳彿鐨勫垎缁勬暟鎹瓧鍏�
+ var roadwayData = groupedData
+ .Where(g => g.Roadway == roadway)
+ .ToDictionary(x => x.Date, x => x);
+
+ // 琛ュ叏缂哄け鏃ユ湡锛岀‘淇濇瘡澶╅兘鏈夋暟鎹紙榛樿涓�0锛�
+ var dailyStats = allDates.Select(date =>
{
- return new
+ if (roadwayData.TryGetValue(date, out var data))
{
- Date = date.ToString("MM-dd"),
- Inbound = data.Inbound,
- Outbound = data.Outbound
- };
- }
- else
+ return new
+ {
+ Date = date.ToString("MM-dd"),
+ Inbound = data.Inbound,
+ Outbound = data.Outbound
+ };
+ }
+ else
+ {
+ return new
+ {
+ Date = date.ToString("MM-dd"),
+ Inbound = 0,
+ Outbound = 0
+ };
+ }
+ })
+ .OrderBy(x => x.Date)
+ .ToList();
+
+ return new
{
- return new
- {
- Date = date.ToString("MM-dd"),
- Inbound = 0,
- Outbound = 0
- };
- }
+ Roadway = roadway,
+ DailyStats = dailyStats
+ };
})
- .OrderBy(x => x.Date)
.ToList();
return WebResponseContent.Instance.OK(null, result);
@@ -190,14 +214,11 @@
return $"{monday.Year}-W{weekNum:D2}";
}
- /// <summary>
- /// 姣忔湀缁熻
- /// </summary>
/// <remarks>
/// 鎸夊勾鏈堢粺璁″叆绔欏拰鍑虹珯浠诲姟鏁伴噺
/// </remarks>
[HttpGet("MonthlyStats"), AllowAnonymous]
- public async Task<WebResponseContent> MonthlyStats([FromQuery] int months = 12)
+ public async Task<WebResponseContent> MonthlyStats([FromQuery] int months = 12, string Roadway = null)
{
try
{
@@ -206,8 +227,27 @@
var startDate = DateTime.Today.AddMonths(-months + 1);
startDate = new DateTime(startDate.Year, startDate.Month, 1);
- var monthlyStats = await _db.Queryable<Dt_Task_Hty>()
- .Where(t => t.InsertTime >= startDate)
+ // 浠撳簱鍚嶇О鏄犲皠
+ var roadwayNames = new Dictionary<string, string>
+ {
+ { "FJSC1", "璐熸瀬鍗�1鍙蜂粨搴�" },
+ { "ZJSC1", "姝ｆ瀬鍗�1鍙蜂粨搴�" },
+ { "GWSC1", "楂樻俯1鍙蜂粨搴�" },
+ { "CWSC1", "甯告俯1鍙蜂粨搴�" },
+ { "HCSC1", "鍒嗗1鍙蜂粨搴�" }
+ };
+
+ // 鏋勫缓鏌ヨ
+ var query = _db.Queryable<Dt_Task_Hty>()
+ .Where(t => t.InsertTime >= startDate);
+
+ // 濡傛灉鎸囧畾浜嗛亾璺紝娣诲姞閬撹矾杩囨护鏉′欢
+ if (!string.IsNullOrEmpty(Roadway))
+ {
+ query = query.Where(t => t.Roadway == Roadway);
+ }
+
+ var monthlyStats = await query
.GroupBy(t => new { t.InsertTime.Year, t.InsertTime.Month })
.Select(t => new
{
@@ -253,7 +293,11 @@
{
Month = monthKey,
Inbound = stat.Inbound,
- Outbound = stat.Outbound
+ Outbound = stat.Outbound,
+ Roadway = Roadway,
+ RoadwayName = !string.IsNullOrEmpty(Roadway) && roadwayNames.ContainsKey(Roadway)
+ ? roadwayNames[Roadway]
+ : null
});
}
else
@@ -262,7 +306,11 @@
{
Month = monthKey,
Inbound = 0,
- Outbound = 0
+ Outbound = 0,
+ Roadway = Roadway,
+ RoadwayName = !string.IsNullOrEmpty(Roadway) && roadwayNames.ContainsKey(Roadway)
+ ? roadwayNames[Roadway]
+ : null
});
}
}
@@ -271,13 +319,9 @@
}
catch (Exception ex)
{
- // 璁板綍寮傚父鏃ュ織锛堝疄闄呴」鐩腑寤鸿浣跨敤鏃ュ織妗嗘灦锛�
- // _logger.LogError(ex, "姣忔湀缁熻鑾峰彇澶辫触");
-
return WebResponseContent.Instance.Error($"姣忔湀缁熻鑾峰彇澶辫触: {ex.Message}");
}
}
-
/// <summary>
/// 搴撳瓨搴撻緞鍒嗗竷
/// </summary>
--
Gitblit v1.9.3