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.AssetStatDao; import java.math.BigDecimal; import java.math.RoundingMode; import java.time.LocalDate; import java.time.format.DateTimeFormatter; import java.util.ArrayList; import java.util.Arrays; import java.util.Collections; import java.util.HashMap; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; /** * 资产统计分析:总量与原值、状态/类别/部门分布、近12个月业务量与采购入库、到期统计 * @author ycq * @date 2026-10-16 */ @Service public class AssetStatService { public static final int TOP_DEPT_COUNT = 10; public static final int MONTHS = 12; /** 流转记录的 11 种变动类型折叠为 6 组,保证图表系列数不超过调色板的有序槽位 */ public static final List CHANGE_GROUPS = Collections.unmodifiableList(Arrays.asList("入库", "借用归还", "调配", "维修", "报废", "其他")); public static final List STATE_ORDER = Collections.unmodifiableList(Arrays.asList("在用", "闲置", "借用", "封存", "维修", "报废")); private static final String[][] DUE_COLUMNS = { {"质保到期", "WARRANTY_EXPIRE_DATE", "0"}, {"维保到期", "NEXT_MAINTAIN_DATE", "0"}, {"检定/年检到期", "VERIFY_EXPIRE_DATE", "0"}, {"借用到期", "BORROW_EXPIRE_DATE", "1"}}; private static final DateTimeFormatter MONTH = DateTimeFormatter.ofPattern("yyyy-MM"); @Autowired private AssetStatDao statDao; @Autowired private RemindService remindService; /** * 统计页全部数据 * @param today 今天 * @param includeScrapped 分布统计是否包含报废资产 * @return kpi、byState、byCategory、byDept、monthly、receipts、expire、daysAhead */ public Map dashboard(LocalDate today, boolean includeScrapped) { Map data = new LinkedHashMap<>(); List> byState = byState(); int daysAhead = remindService.daysAhead(); List> expire = expireStats(today, daysAhead); data.put("kpi", kpi(byState, expire, includeScrapped)); data.put("byState", byState); data.put("byCategory", rows(statDao.countByTopCategory(includeScrapped))); data.put("byDept", rows(statDao.countByDept(includeScrapped, TOP_DEPT_COUNT))); data.put("monthly", monthlyChanges(today)); data.put("receipts", monthlyReceipts(today)); data.put("expire", expire); data.put("daysAhead", daysAhead); data.put("includeScrapped", includeScrapped); return data; } private List> byState() { Map> found = new HashMap<>(); for (Map row : statDao.countByState()) { found.put(FormDataUtils.toText(row.get("ASSET_STATE")), row); } List> result = new ArrayList<>(); for (String state : STATE_ORDER) { Map row = found.remove(state); result.add(item(state, row == null ? 0L : count(row), row == null ? BigDecimal.ZERO : amount(row))); } for (Map.Entry> rest : found.entrySet()) { result.add(item(rest.getKey(), count(rest.getValue()), amount(rest.getValue()))); } return result; } private static Map kpi(List> byState, List> expire, boolean includeScrapped) { long total = 0; BigDecimal value = BigDecimal.ZERO; Map counts = new HashMap<>(); for (Map row : byState) { String name = (String) row.get("name"); long cnt = (Long) row.get("count"); counts.put(name, cnt); if (includeScrapped || !"报废".equals(name)) { total += cnt; value = value.add((BigDecimal) row.get("amount")); } } long overdue = 0; long soon = 0; for (Map row : expire) { overdue += (Long) row.get("overdue"); soon += (Long) row.get("soon"); } Map kpi = new LinkedHashMap<>(); kpi.put("total", total); kpi.put("value", value.setScale(2, RoundingMode.HALF_UP)); kpi.put("inUse", counts.getOrDefault("在用", 0L)); kpi.put("idle", counts.getOrDefault("闲置", 0L)); kpi.put("borrowed", counts.getOrDefault("借用", 0L)); kpi.put("sealed", counts.getOrDefault("封存", 0L)); kpi.put("repair", counts.getOrDefault("维修", 0L)); kpi.put("scrapped", counts.getOrDefault("报废", 0L)); kpi.put("overdue", overdue); kpi.put("dueSoon", soon); return kpi; } /** * 近12个月(含本月)各变动分组的流转记录数,缺月补0 * @param today 今天 * @return months、series[{name, data}] */ public Map monthlyChanges(LocalDate today) { List months = months(today); Map groups = new LinkedHashMap<>(); for (String group : CHANGE_GROUPS) { groups.put(group, new long[MONTHS]); } for (Map row : statDao.countChangesByMonth(firstMonth(today))) { int index = months.indexOf(FormDataUtils.toText(row.get("MONTH"))); if (index >= 0) { groups.get(changeGroup(FormDataUtils.toText(row.get("CHANGE_TYPE"))))[index] += count(row); } } List> series = new ArrayList<>(); for (Map.Entry entry : groups.entrySet()) { List data = new ArrayList<>(); for (long value : entry.getValue()) { data.add(value); } Map s = new LinkedHashMap<>(); s.put("name", entry.getKey()); s.put("data", data); series.add(s); } Map result = new LinkedHashMap<>(); result.put("months", months); result.put("series", series); return result; } private Map monthlyReceipts(LocalDate today) { List months = months(today); List counts = new ArrayList<>(Collections.nCopies(MONTHS, 0L)); List amounts = new ArrayList<>(Collections.nCopies(MONTHS, BigDecimal.ZERO.setScale(2))); for (Map row : statDao.sumReceiptsByMonth(firstMonth(today))) { int index = months.indexOf(FormDataUtils.toText(row.get("MONTH"))); if (index >= 0) { counts.set(index, count(row)); amounts.set(index, amount(row).setScale(2, RoundingMode.HALF_UP)); } } Map result = new LinkedHashMap<>(); result.put("months", months); result.put("counts", counts); result.put("amounts", amounts); return result; } private List> expireStats(LocalDate today, int daysAhead) { List> result = new ArrayList<>(); for (String[] due : DUE_COLUMNS) { boolean borrowOnly = "1".equals(due[2]); Map row = new LinkedHashMap<>(); row.put("type", due[0]); row.put("overdue", statDao.countDue(due[1], borrowOnly, null, today.minusDays(1))); row.put("soon", statDao.countDue(due[1], borrowOnly, today, today.plusDays(daysAhead))); result.add(row); } return result; } /** * 变动类型归入统计分组 * @param changeType 流转记录的变动类型 * @return 分组名 */ public static String changeGroup(String changeType) { switch (changeType) { case "入库": return "入库"; case "借用": case "归还": return "借用归还"; case "调配": return "调配"; case "报修": case "维修完成": return "维修"; case "报废": return "报废"; default: return "其他"; } } private static List months(LocalDate today) { List months = new ArrayList<>(); LocalDate first = firstMonth(today); for (int i = 0; i < MONTHS; i++) { months.add(first.plusMonths(i).format(MONTH)); } return months; } private static LocalDate firstMonth(LocalDate today) { return today.withDayOfMonth(1).minusMonths(MONTHS - 1); } private static List> rows(List> raw) { List> result = new ArrayList<>(); for (Map row : raw) { result.add(item(FormDataUtils.toText(row.get("NAME")), count(row), amount(row))); } return result; } private static Map item(String name, long count, BigDecimal amount) { Map item = new LinkedHashMap<>(); item.put("name", name); item.put("count", count); item.put("amount", amount.setScale(2, RoundingMode.HALF_UP)); return item; } private static long count(Map row) { Long value = FormDataUtils.toLong(row.get("CNT")); return value == null ? 0 : value; } private static BigDecimal amount(Map row) { Object value = row.get("AMOUNT"); return value == null ? BigDecimal.ZERO : new BigDecimal(String.valueOf(value)); } }