瑞利声电固定资产管理系统
ycq
2026-10-16 dbbadb021c2fc171466cc82bd9a7a82cc47165f5
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
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
package zbooksoft.fams.service;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import zbooksoft.fams.common.FormDataUtils;
import zbooksoft.fams.dao.RemindDao;
 
import java.sql.Timestamp;
import java.time.LocalDate;
import java.time.temporal.ChronoUnit;
import java.util.HashMap;
import java.util.HashSet;
import java.util.LinkedHashMap;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
 
/**
 * 资产到期提醒:每日扫描质保、维保、检定/年检、借用到期,维护提醒记录并发送系统消息
 * @author ycq
 * @date 2026-10-16
 */
@Service
public class RemindService {
 
    public static final int DEFAULT_DAYS_AHEAD = 30;
    public static final String[] REMIND_TYPES = {"质保到期", "维保到期", "检定/年检到期", "借用到期"};
    public static final String STATE_PENDING = "待处理";
    public static final String STATE_HANDLED = "已处理";
    public static final String STATE_EXPIRED = "已失效";
 
    private static final int MAX_DAYS_AHEAD = 365;
    private static final int DATE_TEXT_LENGTH = 10;
 
    @Autowired
    private RemindDao remindDao;
 
    /**
     * 提前多少天提醒:关键字「到期提醒设置 / 提前天数」,未配置或非法时取默认30天
     * @return 天数
     */
    public int daysAhead() {
        String value = remindDao.findDaysAhead();
        if (value != null && value.trim().matches("\\d{1,3}")) {
            int days = Integer.parseInt(value.trim());
            if (days > 0 && days <= MAX_DAYS_AHEAD) {
                return days;
            }
        }
        return DEFAULT_DAYS_AHEAD;
    }
 
    /**
     * 扫描到期资产:新到期项生成提醒并通知使用人和资产管理员;已有的刷新剩余天数;到期日已顺延或资产已不在清单的提醒置为已失效
     * @param today 今天
     * @param daysAhead 提前天数
     * @return created/updated/expired/notified 计数
     */
    public Map<String, Integer> scan(LocalDate today, int daysAhead) {
        Map<String, Map<String, Object>> pendingByKey = new HashMap<>();
        Set<String> handledKeys = new HashSet<>();
        for (Map<String, Object> remind : remindDao.findActiveReminds()) {
            String key = key(remind.get("ASSET_ID"), remind.get("REMIND_TYPE"), remind.get("DUE_DATE"));
            if (STATE_PENDING.equals(FormDataUtils.toText(remind.get("REMIND_STATE")))) {
                pendingByKey.put(key, remind);
            } else {
                handledKeys.add(key);
            }
        }
        int created = 0;
        int updated = 0;
        int notified = 0;
        Set<String> dueKeys = new HashSet<>();
        List<Long> admins = null;
        Long cardFormId = null;
        for (Map<String, Object> item : remindDao.findDueItems(today.plusDays(daysAhead))) {
            String dueDate = dateText(item.get("DUE_DATE"));
            String key = key(item.get("ASSET_ID"), item.get("REMIND_TYPE"), dueDate);
            dueKeys.add(key);
            if (handledKeys.contains(key)) {
                continue;
            }
            int daysLeft = (int) ChronoUnit.DAYS.between(today, LocalDate.parse(dueDate));
            Map<String, Object> pending = pendingByKey.get(key);
            if (pending != null) {
                Map<String, Object> values = new HashMap<>();
                values.put("DAYS_LEFT", daysLeft);
                values.put("USER_NAME", FormDataUtils.toText(item.get("USER_NAME")));
                values.put("USE_DEPT_NAME", FormDataUtils.toText(item.get("USE_DEPT_NAME")));
                values.put("LOCATION_NAME", FormDataUtils.toText(item.get("LOCATION_NAME")));
                remindDao.updateRemind(FormDataUtils.toLong(pending.get("ID")), values);
                updated++;
                continue;
            }
            remindDao.insertRemind(newRemind(item, dueDate, daysLeft));
            created++;
            if (admins == null) {
                admins = remindDao.findAdminUserIds();
                cardFormId = remindDao.findCardFormId();
            }
            notified += notify(item, dueDate, daysLeft, admins, cardFormId);
        }
        int expired = 0;
        for (Map.Entry<String, Map<String, Object>> entry : pendingByKey.entrySet()) {
            if (!dueKeys.contains(entry.getKey())) {
                Map<String, Object> values = new HashMap<>();
                values.put("REMIND_STATE", STATE_EXPIRED);
                remindDao.updateRemind(FormDataUtils.toLong(entry.getValue().get("ID")), values);
                expired++;
            }
        }
        Map<String, Integer> result = new LinkedHashMap<>();
        result.put("created", created);
        result.put("updated", updated);
        result.put("expired", expired);
        result.put("notified", notified);
        return result;
    }
 
    private static Map<String, Object> newRemind(Map<String, Object> item, String dueDate, int daysLeft) {
        Map<String, Object> row = new LinkedHashMap<>();
        row.put("ASSET_ID", FormDataUtils.toLong(item.get("ASSET_ID")));
        row.put("ASSET_NO", FormDataUtils.toText(item.get("ASSET_NO")));
        row.put("ASSET_NAME", FormDataUtils.toText(item.get("ASSET_NAME")));
        row.put("REMIND_TYPE", FormDataUtils.toText(item.get("REMIND_TYPE")));
        row.put("DUE_DATE", dueDate);
        row.put("DAYS_LEFT", daysLeft);
        row.put("USER_ID", FormDataUtils.toLong(item.get("USER_ID")));
        row.put("USER_NAME", FormDataUtils.toText(item.get("USER_NAME")));
        row.put("USE_DEPT_NAME", FormDataUtils.toText(item.get("USE_DEPT_NAME")));
        row.put("LOCATION_NAME", FormDataUtils.toText(item.get("LOCATION_NAME")));
        row.put("REMIND_STATE", STATE_PENDING);
        row.put("NOTIFY_TIME", new Timestamp(System.currentTimeMillis()));
        return row;
    }
 
    private int notify(Map<String, Object> item, String dueDate, int daysLeft, List<Long> admins, Long cardFormId) {
        String content = "资产【" + FormDataUtils.toText(item.get("ASSET_NO")) + " " + FormDataUtils.toText(item.get("ASSET_NAME")) + "】"
                + FormDataUtils.toText(item.get("REMIND_TYPE")).replace("到期", "") + "到期日为 " + dueDate + ","
                + (daysLeft < 0 ? "已过期 " + (-daysLeft) + " 天" : "还剩 " + daysLeft + " 天") + ",请及时处理。";
        String url = cardFormId == null ? "" : "general/editFormData?formId=" + cardFormId + "&keyId=" + FormDataUtils.toLong(item.get("ASSET_ID")) + "&openUrlType=0";
        Map<Long, String> receivers = new LinkedHashMap<>();
        Long userId = FormDataUtils.toLong(item.get("USER_ID"));
        if (userId != null) {
            receivers.put(userId, FormDataUtils.toText(item.get("USER_NAME")));
        }
        for (Long admin : admins) {
            receivers.putIfAbsent(admin, "");
        }
        for (Map.Entry<Long, String> receiver : receivers.entrySet()) {
            remindDao.insertMessage(receiver.getKey(), receiver.getValue(), content, url);
        }
        return receivers.size();
    }
 
    /**
     * 把待处理的提醒标记为已处理(如已安排检定、已续保)
     * @param ids 提醒ID
     * @param operatorName 处理人
     * @return 标记的条数
     */
    public int handle(List<Long> ids, String operatorName) {
        int count = 0;
        for (Long id : new LinkedHashSet<>(ids)) {
            Map<String, Object> remind = remindDao.findRemind(id);
            if (remind == null || !STATE_PENDING.equals(FormDataUtils.toText(remind.get("REMIND_STATE")))) {
                continue;
            }
            Map<String, Object> values = new HashMap<>();
            values.put("REMIND_STATE", STATE_HANDLED);
            values.put("HANDLE_TIME", new Timestamp(System.currentTimeMillis()));
            values.put("HANDLE_USER_NAME", operatorName);
            remindDao.updateRemind(id, values);
            count++;
        }
        return count;
    }
 
    private static String key(Object assetId, Object type, Object dueDate) {
        return FormDataUtils.toLong(assetId) + "|" + FormDataUtils.toText(type) + "|" + dateText(dueDate);
    }
 
    private static String dateText(Object value) {
        String text = FormDataUtils.toText(value);
        return text.length() >= DATE_TEXT_LENGTH ? text.substring(0, DATE_TEXT_LENGTH) : text;
    }
}