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<String> CHANGE_GROUPS = Collections.unmodifiableList(Arrays.asList("入库", "借用归还", "调配", "维修", "报废", "其他"));
|
public static final List<String> 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<String, Object> dashboard(LocalDate today, boolean includeScrapped) {
|
Map<String, Object> data = new LinkedHashMap<>();
|
List<Map<String, Object>> byState = byState();
|
int daysAhead = remindService.daysAhead();
|
List<Map<String, Object>> 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<Map<String, Object>> byState() {
|
Map<String, Map<String, Object>> found = new HashMap<>();
|
for (Map<String, Object> row : statDao.countByState()) {
|
found.put(FormDataUtils.toText(row.get("ASSET_STATE")), row);
|
}
|
List<Map<String, Object>> result = new ArrayList<>();
|
for (String state : STATE_ORDER) {
|
Map<String, Object> row = found.remove(state);
|
result.add(item(state, row == null ? 0L : count(row), row == null ? BigDecimal.ZERO : amount(row)));
|
}
|
for (Map.Entry<String, Map<String, Object>> rest : found.entrySet()) {
|
result.add(item(rest.getKey(), count(rest.getValue()), amount(rest.getValue())));
|
}
|
return result;
|
}
|
|
private static Map<String, Object> kpi(List<Map<String, Object>> byState, List<Map<String, Object>> expire, boolean includeScrapped) {
|
long total = 0;
|
BigDecimal value = BigDecimal.ZERO;
|
Map<String, Long> counts = new HashMap<>();
|
for (Map<String, Object> 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<String, Object> row : expire) {
|
overdue += (Long) row.get("overdue");
|
soon += (Long) row.get("soon");
|
}
|
Map<String, Object> 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<String, Object> monthlyChanges(LocalDate today) {
|
List<String> months = months(today);
|
Map<String, long[]> groups = new LinkedHashMap<>();
|
for (String group : CHANGE_GROUPS) {
|
groups.put(group, new long[MONTHS]);
|
}
|
for (Map<String, Object> 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<Map<String, Object>> series = new ArrayList<>();
|
for (Map.Entry<String, long[]> entry : groups.entrySet()) {
|
List<Long> data = new ArrayList<>();
|
for (long value : entry.getValue()) {
|
data.add(value);
|
}
|
Map<String, Object> s = new LinkedHashMap<>();
|
s.put("name", entry.getKey());
|
s.put("data", data);
|
series.add(s);
|
}
|
Map<String, Object> result = new LinkedHashMap<>();
|
result.put("months", months);
|
result.put("series", series);
|
return result;
|
}
|
|
private Map<String, Object> monthlyReceipts(LocalDate today) {
|
List<String> months = months(today);
|
List<Long> counts = new ArrayList<>(Collections.nCopies(MONTHS, 0L));
|
List<BigDecimal> amounts = new ArrayList<>(Collections.nCopies(MONTHS, BigDecimal.ZERO.setScale(2)));
|
for (Map<String, Object> 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<String, Object> result = new LinkedHashMap<>();
|
result.put("months", months);
|
result.put("counts", counts);
|
result.put("amounts", amounts);
|
return result;
|
}
|
|
private List<Map<String, Object>> expireStats(LocalDate today, int daysAhead) {
|
List<Map<String, Object>> result = new ArrayList<>();
|
for (String[] due : DUE_COLUMNS) {
|
boolean borrowOnly = "1".equals(due[2]);
|
Map<String, Object> 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<String> months(LocalDate today) {
|
List<String> 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<Map<String, Object>> rows(List<Map<String, Object>> raw) {
|
List<Map<String, Object>> result = new ArrayList<>();
|
for (Map<String, Object> row : raw) {
|
result.add(item(FormDataUtils.toText(row.get("NAME")), count(row), amount(row)));
|
}
|
return result;
|
}
|
|
private static Map<String, Object> item(String name, long count, BigDecimal amount) {
|
Map<String, Object> 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<String, Object> row) {
|
Long value = FormDataUtils.toLong(row.get("CNT"));
|
return value == null ? 0 : value;
|
}
|
|
private static BigDecimal amount(Map<String, Object> row) {
|
Object value = row.get("AMOUNT");
|
return value == null ? BigDecimal.ZERO : new BigDecimal(String.valueOf(value));
|
}
|
}
|