LabelAlertTimerWriteHelper.cs
4.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
using System.Globalization;
using FoodLabeling.Application.Services.DbModels;
using FoodLabeling.Domain.Shared.Helpers;
using SqlSugar;
namespace FoodLabeling.Application.Helpers;
/// <summary>
/// 打印成功后写入告警计时器（按 BatchId 幂等，一条批次一条计时器）。
/// </summary>
public static class LabelAlertTimerWriteHelper
{
/// <summary>
/// 根据打印批次创建告警计时器；已存在未删除记录或无有效过期时刻时直接返回。
/// </summary>
public static async Task TryCreateFromPrintBatchAsync(
ISqlSugarClient db,
string batchId,
string? createdBy,
CancellationToken ct = default)
{
var bid = batchId?.Trim();
if (string.IsNullOrWhiteSpace(bid))
{
return;
}
ct.ThrowIfCancellationRequested();
// BatchId 有唯一索引：含软删记录也不再插入，避免幂等补写撞唯一约束
var exists = await db.Queryable<FlLabelAlertTimerDbEntity>()
.AnyAsync(x => x.BatchId == bid);
if (exists)
{
return;
}
var task = (await db.Queryable<FlLabelPrintTaskDbEntity>()
.Where(x => x.BatchId == bid)
.OrderBy(x => x.CopyIndex)
.Take(1)
.ToListAsync(ct))
.FirstOrDefault();
if (task is null)
{
return;
}
var printedAt = task.PrintedAt ?? task.BaseTime ?? task.CreationTime;
if (!ReportsPrintLogExpiryHelper.TryResolveExpiryDateTime(
task.PrintInputJson,
task.RenderTemplateJson,
task.BaseTime,
printedAt,
out var expiresAt))
{
return;
}
var label = (await db.Queryable<FlLabelDbEntity>()
.Where(x => x.Id == task.LabelId)
.Select(x => new { x.LabelName, x.LabelCode })
.Take(1)
.ToListAsync(ct))
.FirstOrDefault();
var labelName = label?.LabelName?.Trim();
if (string.IsNullOrWhiteSpace(labelName))
{
labelName = FoodLabelingDisplayConsts.NotAvailable;
}
string? productName = null;
if (!string.IsNullOrWhiteSpace(task.ProductId))
{
productName = (await db.Queryable<FlProductDbEntity>()
.Where(x => x.Id == task.ProductId && !x.IsDeleted)
.Select(x => x.ProductName)
.Take(1)
.ToListAsync(ct))
.FirstOrDefault();
}
var durationSeconds = Math.Max(0, (int)(expiresAt - printedAt).TotalSeconds);
var title = BuildTitle(labelName, durationSeconds);
var subtitle = BuildSubtitle(durationSeconds, expiresAt);
var now = DateTime.Now;
var entity = new FlLabelAlertTimerDbEntity
{
Id = YitIdHelper.NextId().ToString(),
BatchId = bid,
PrintTaskId = task.Id,
LabelId = task.LabelId,
LabelCode = label?.LabelCode?.Trim(),
LabelName = labelName,
ProductId = task.ProductId,
ProductName = string.IsNullOrWhiteSpace(productName) ? null : productName.Trim(),
LocationId = task.LocationId?.Trim() ?? string.Empty,
PrintedAt = printedAt,
BaseTime = task.BaseTime,
ExpiresAt = expiresAt,
DurationSeconds = durationSeconds,
Title = title,
Subtitle = subtitle,
IsDeleted = false,
DeletionTime = null,
CreatedBy = createdBy,
CreationTime = now
};
await db.Insertable(entity).ExecuteCommandAsync();
}
private static string BuildTitle(string labelName, int durationSeconds)
{
var hoursText = FormatDurationHoursLabel(durationSeconds);
return string.IsNullOrWhiteSpace(hoursText) ? labelName : $"{labelName} ({hoursText})";
}
private static string BuildSubtitle(int durationSeconds, DateTime expiresAt)
{
var hoursText = FormatDurationHoursLabel(durationSeconds);
var timeText = expiresAt.ToString("h:mm tt", CultureInfo.CurrentCulture);
return string.IsNullOrWhiteSpace(hoursText)
? $"Completes at {timeText}"
: $"{hoursText} Completes at {timeText}";
}
private static string FormatDurationHoursLabel(int durationSeconds)
{
if (durationSeconds <= 0)
{
return string.Empty;
}
var totalHours = durationSeconds / 3600.0;
if (totalHours >= 1)
{
var rounded = (int)Math.Round(totalHours, MidpointRounding.AwayFromZero);
rounded = Math.Max(1, rounded);
return rounded == 1 ? "1 hour" : $"{rounded} hours";
}
var minutes = Math.Max(1, (int)Math.Ceiling(durationSeconds / 60.0));
return minutes == 1 ? "1 minute" : $"{minutes} minutes";
}
}