From c3a981e80973ac52b5988aca62b87409976c6fb1 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 18 六月 2026 13:09:28 +0800
Subject: [PATCH] 1.计量器具台账上传附件报错 2.质量拉的数据不对（未明确） 3.计量器具台账逾期的做标红提醒 4.设备保养定时任务和记录要加上具体的保养内容 5.质量要区分质检规则抽检还是全检，抽检的话是抽多少百分比 6.供应商管理东西太少了，没有资质文件啊这些东西（是不是可以参考pro） 7.采购审批把人从李莹莹改成龙红星
---
src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java | 146 ++++++++++++++++++++++++------------------------
1 files changed, 72 insertions(+), 74 deletions(-)
diff --git a/src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java b/src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java
index affc030..59f244f 100644
--- a/src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java
+++ b/src/main/java/com/ruoyi/home/service/impl/HomeServiceImpl.java
@@ -1721,14 +1721,15 @@
LocalDate endDate = range[1];
String startStr = startDate.toString();
- String endStr = endDate.toString();
+ // 浣跨敤鍖洪棿鍙冲紑锛�< endDate + 1 澶╋級淇濊瘉妫�娴嬫椂闂村惈鏃跺垎绉掓椂涔熻兘瑕嗙洊鍒� endDate 褰撳ぉ
+ String endExclusiveStr = endDate.plusDays(1).toString();
List<QualityInspect> list = qualityInspectMapper.selectList(
new LambdaQueryWrapper<QualityInspect>()
.eq(QualityInspect::getInspectType, inspectType)
.eq(QualityInspect::getInspectState, 1)
.ge(QualityInspect::getCheckTime, startStr)
- .le(QualityInspect::getCheckTime, endStr));
+ .lt(QualityInspect::getCheckTime, endExclusiveStr));
return buildQualifiedAnalysis(list);
}
@@ -1767,8 +1768,8 @@
QualityQualifiedAnalysisDto dto = new QualityQualifiedAnalysisDto();
if (CollectionUtils.isEmpty(list)) {
- dto.setQualifiedCount(0);
- dto.setUnqualifiedCount(0);
+ dto.setQualifiedCount(BigDecimal.valueOf(0));
+ dto.setUnqualifiedCount(BigDecimal.valueOf(0));
dto.setQualifiedRate(BigDecimal.ZERO.setScale(2));
dto.setUnqualifiedRate(BigDecimal.ZERO.setScale(2));
return dto;
@@ -1784,8 +1785,8 @@
BigDecimal totalCount = qualifiedCount.add(unqualifiedCount);
- dto.setQualifiedCount(qualifiedCount.intValue());
- dto.setUnqualifiedCount(unqualifiedCount.intValue());
+ dto.setQualifiedCount(qualifiedCount);
+ dto.setUnqualifiedCount(unqualifiedCount);
if (totalCount.compareTo(BigDecimal.ZERO) == 0) {
dto.setQualifiedRate(BigDecimal.ZERO.setScale(2));
@@ -1808,74 +1809,64 @@
@Override
public QualityInspectionCountDto qualityInspectionCount() {
- String todayStr = LocalDate.now().toString();
- String prevDayStr = LocalDate.now().minusDays(1).toString();
- // 鏌ヨ鍑烘埅姝粖鏃ョ殑鎬绘楠屾暟
- List<QualityInspect> todayList = qualityInspectMapper.selectList(new LambdaQueryWrapper<QualityInspect>()
- .le(QualityInspect::getCheckTime, todayStr));
- // 鏌ヨ鍑烘埅姝㈠墠涓�澶╃殑鎬绘楠屾暟
- List<QualityInspect> prevList = qualityInspectMapper.selectList(new LambdaQueryWrapper<QualityInspect>()
- .le(QualityInspect::getCheckTime, prevDayStr));
- // 璁＄畻浠婃棩鐨勬�绘楠屾暟
- BigDecimal todayCount = todayList.stream()
- .map(QualityInspect::getQuantity)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
- // 璁＄畻鍓嶄竴澶╃殑鎬绘楠屾暟
- BigDecimal prevCount = prevList.stream()
- .map(QualityInspect::getQuantity)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
+ LocalDate today = LocalDate.now();
+ String todayStartStr = today.toString();
+ String tomorrowStartStr = today.plusDays(1).toString();
+ String yesterdayStartStr = today.minusDays(1).toString();
- // 璁＄畻浠婃棩鐩稿鏄ㄥぉ鐨勪竴涓�绘瘮澧為暱
- BigDecimal growthRate = calcGrowthRate(todayCount, prevCount);
+ // 绱鎬绘楠屾暟锛堟埅姝粖鏃� 24:00 涔嬪墠鐨勬墍鏈夎褰曪級
+ BigDecimal totalCount = sumInspectQuantity(null, tomorrowStartStr, null);
+ // 浠婃棩鍗曟棩妫�楠屾暟
+ BigDecimal todayCount = sumInspectQuantity(todayStartStr, tomorrowStartStr, null);
+ // 鏄ㄦ棩鍗曟棩妫�楠屾暟
+ BigDecimal yesterdayCount = sumInspectQuantity(yesterdayStartStr, todayStartStr, null);
+ // 鎬绘楠屾暟鍚屾瘮澧為暱 = (浠婃棩鍗曟棩 - 鏄ㄦ棩鍗曟棩) / 鏄ㄦ棩鍗曟棩 脳 100%
+ BigDecimal growthRate = calcGrowthRate(todayCount, yesterdayCount);
- // 璁＄畻浠婂ぉ鐨勫緟瀹屾垚鏁伴噺
- List<QualityInspect> todayPendingList = qualityInspectMapper.selectList(new LambdaQueryWrapper<QualityInspect>()
- .eq(QualityInspect::getInspectState, 0)
- .eq(QualityInspect::getCheckTime, todayStr));
+ // 浠婃棩寰呭畬鎴愶紙inspectState=0锛�
+ BigDecimal todayPendingCount = sumInspectQuantity(todayStartStr, tomorrowStartStr, 0);
+ BigDecimal yesterdayPendingCount = sumInspectQuantity(yesterdayStartStr, todayStartStr, 0);
+ BigDecimal todayPendingCountGrowthRate = calcGrowthRate(todayPendingCount, yesterdayPendingCount);
- // 璁＄畻鍓嶄竴澶╃殑寰呭畬鎴愭暟閲�
- List<QualityInspect> prevPendingList = qualityInspectMapper.selectList(new LambdaQueryWrapper<QualityInspect>()
- .eq(QualityInspect::getInspectState, 0)
- .eq(QualityInspect::getCheckTime, prevDayStr));
- // 璁＄畻浠婂ぉ鐨勫緟瀹屾垚鏁伴噺
- BigDecimal todayPendingCount = todayPendingList.stream()
- .map(QualityInspect::getQuantity)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
+ // 浠婃棩宸插畬鎴愶紙inspectState=1锛�
+ BigDecimal todayCompletedCount = sumInspectQuantity(todayStartStr, tomorrowStartStr, 1);
+ BigDecimal yesterdayCompletedCount = sumInspectQuantity(yesterdayStartStr, todayStartStr, 1);
+ BigDecimal todayCompletedCountGrowthRate = calcGrowthRate(todayCompletedCount, yesterdayCompletedCount);
- // 璁＄畻鍓嶄竴澶╃殑寰呭畬鎴愭暟閲�
- BigDecimal prevPendingCount = prevPendingList.stream()
- .map(QualityInspect::getQuantity)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
- // 璁＄畻浠婂ぉ鐨勫緟瀹屾垚鏁伴噺鐩稿鏄ㄥぉ鐨勪竴涓悓姣斿闀�
- BigDecimal todayPendingCountGrowthRate = calcGrowthRate(todayPendingCount, prevPendingCount);
- // 璁＄畻浠婂ぉ鐨勫凡瀹屾垚鏁伴噺
- List<QualityInspect> todayCompletedList = qualityInspectMapper
- .selectList(new LambdaQueryWrapper<QualityInspect>()
- .eq(QualityInspect::getInspectState, 1)
- .eq(QualityInspect::getCheckTime, todayStr));
- // 璁＄畻鍓嶄竴澶╃殑宸插畬鎴愭暟閲�
- List<QualityInspect> prevCompletedList = qualityInspectMapper
- .selectList(new LambdaQueryWrapper<QualityInspect>()
- .eq(QualityInspect::getInspectState, 1)
- .eq(QualityInspect::getCheckTime, prevDayStr));
- // 璁＄畻浠婂ぉ鐨勫凡瀹屾垚鏁伴噺
- BigDecimal todayCompletedCount = todayCompletedList.stream()
- .map(QualityInspect::getQuantity)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
- // 璁＄畻鍓嶄竴澶╃殑宸插畬鎴愭暟閲�
- BigDecimal prevCompletedCount = prevCompletedList.stream()
- .map(QualityInspect::getQuantity)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
- // 璁＄畻浠婂ぉ鐨勫凡瀹屾垚鏁伴噺鐩稿鏄ㄥぉ鐨勪竴涓悓姣斿闀�
- BigDecimal todayCompletedCountGrowthRate = calcGrowthRate(todayCompletedCount, prevCompletedCount);
QualityInspectionCountDto dto = new QualityInspectionCountDto();
- dto.setTotalCount(todayCount);
+ dto.setTotalCount(totalCount);
dto.setTotalCountGrowthRate(growthRate);
dto.setTodayPendingCount(todayPendingCount);
dto.setTodayPendingCountGrowthRate(todayPendingCountGrowthRate);
dto.setTodayCompletedCount(todayCompletedCount);
dto.setTodayCompletedCountGrowthRate(todayCompletedCountGrowthRate);
return dto;
+ }
+
+ /**
+ * 閫氳繃 SQL SUM 鑱氬悎 quality_inspect.quantity锛岄伩鍏嶆妸鍏ㄨ〃鍔犺浇鍒板唴瀛�
+ */
+ private BigDecimal sumInspectQuantity(String startInclusive, String endExclusive, Integer inspectState) {
+ QueryWrapper<QualityInspect> wrapper = new QueryWrapper<>();
+ wrapper.select("COALESCE(SUM(quantity), 0) AS total");
+ if (startInclusive != null) {
+ wrapper.ge("check_time", startInclusive);
+ }
+ if (endExclusive != null) {
+ wrapper.lt("check_time", endExclusive);
+ }
+ if (inspectState != null) {
+ wrapper.eq("inspect_state", inspectState);
+ }
+ List<Map<String, Object>> rows = qualityInspectMapper.selectMaps(wrapper);
+ if (rows == null || rows.isEmpty()) {
+ return BigDecimal.ZERO;
+ }
+ Object total = rows.get(0).get("total");
+ if (total == null) {
+ return BigDecimal.ZERO;
+ }
+ return total instanceof BigDecimal ? (BigDecimal) total : new BigDecimal(total.toString());
}
private BigDecimal calcGrowthRate(BigDecimal today, BigDecimal prev) {
@@ -1892,14 +1883,14 @@
public NonComplianceWarningDto nonComplianceWarning() {
String[] range = lastSevenDaysDateRange();
String startStr = range[0];
- String endStr = range[1];
+ String endExclusiveStr = range[1];
// 鏌ヨ杩戜竷澶╁凡澶勭悊涓嶅悎鏍兼暟鎹�
List<QualityUnqualified> list = qualityUnqualifiedMapper.selectList(
new LambdaQueryWrapper<QualityUnqualified>()
.eq(QualityUnqualified::getInspectState, 1)
.ge(QualityUnqualified::getCheckTime, startStr)
- .le(QualityUnqualified::getCheckTime, endStr));
+ .lt(QualityUnqualified::getCheckTime, endExclusiveStr));
NonComplianceWarningDto dto = new NonComplianceWarningDto();
@@ -1998,24 +1989,24 @@
}
/**
- * 鑾峰彇杩戜竷澶╃殑鏃ユ湡鍖洪棿锛堜粎鍚勾鏈堟棩锛�
+ * 鑾峰彇杩戜竷澶╃殑鏃ユ湡鍖洪棿锛堜粎鍚勾鏈堟棩锛夛細杩斿洖 [start, endExclusive] 鈥斺�� endExclusive 鏄粖澶� + 1 澶╋紝渚夸簬浣跨敤 lt 鍖呭惈浠婂ぉ鍏ㄩ儴
*/
public static String[] lastSevenDaysDateRange() {
LocalDate today = LocalDate.now();
- return new String[]{today.minusDays(6).toString(), today.toString()};
+ return new String[]{today.minusDays(6).toString(), today.plusDays(1).toString()};
}
@Override
public List<CompletedInspectionCountDto> completedInspectionCount() {
String[] range = lastSevenDaysDateRange();
String startStr = range[0];
- String endStr = range[1];
+ String endExclusiveStr = range[1];
// 鏌ヨ杩戜竷澶╁凡瀹屾垚鐨勬楠屾暟鎹�
List<QualityInspect> list = qualityInspectMapper.selectList(new LambdaQueryWrapper<QualityInspect>()
.eq(QualityInspect::getInspectState, 1)
.ge(QualityInspect::getCheckTime, startStr)
- .le(QualityInspect::getCheckTime, endStr));
+ .lt(QualityInspect::getCheckTime, endExclusiveStr));
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("MM-dd");
@@ -2067,8 +2058,15 @@
@Override
public List<UnqualifiedProductRankDto> unqualifiedProductRanking() {
+ // 闄愬畾杩� 30 澶╋紝閬垮厤鍏ㄨ〃鍔犺浇
+ LocalDate today = LocalDate.now();
+ String startStr = today.minusDays(29).toString();
+ String endExclusiveStr = today.plusDays(1).toString();
+
List<QualityInspect> list = qualityInspectMapper.selectList(new LambdaQueryWrapper<QualityInspect>()
- .eq(QualityInspect::getInspectState, 1));
+ .eq(QualityInspect::getInspectState, 1)
+ .ge(QualityInspect::getCheckTime, startStr)
+ .lt(QualityInspect::getCheckTime, endExclusiveStr));
if (CollectionUtils.isEmpty(list)) {
return new ArrayList<>();
@@ -2219,7 +2217,7 @@
List<QualityInspect> qualityInspectList = qualityInspectMapper
.selectList(new LambdaQueryWrapper<QualityInspect>()
.ge(QualityInspect::getCheckTime, startDate.toString())
- .le(QualityInspect::getCheckTime, endDate.toString())
+ .lt(QualityInspect::getCheckTime, endDate.plusDays(1).toString())
.eq(QualityInspect::getInspectState, 1));
QualityStatisticsDto dto = new QualityStatisticsDto();
@@ -2294,15 +2292,15 @@
// 缁熻姣忕妫�楠岀被鍨嬬殑涓嶅悎鏍兼暟閲�
item.setSupplierNum(list.stream()
- .filter(i -> i.getInspectType() == 0)
+ .filter(i -> Objects.equals(i.getInspectType(), 0))
.map(i -> i.getUnqualifiedQuantity() != null ? i.getUnqualifiedQuantity() : BigDecimal.ZERO)
.reduce(BigDecimal.ZERO, BigDecimal::add));
item.setProcessNum(list.stream()
- .filter(i -> i.getInspectType() == 1)
+ .filter(i -> Objects.equals(i.getInspectType(), 1))
.map(i -> i.getUnqualifiedQuantity() != null ? i.getUnqualifiedQuantity() : BigDecimal.ZERO)
.reduce(BigDecimal.ZERO, BigDecimal::add));
item.setFactoryNum(list.stream()
- .filter(i -> i.getInspectType() == 2)
+ .filter(i -> Objects.equals(i.getInspectType(), 2))
.map(i -> i.getUnqualifiedQuantity() != null ? i.getUnqualifiedQuantity() : BigDecimal.ZERO)
.reduce(BigDecimal.ZERO, BigDecimal::add));
--
Gitblit v1.9.3