From 57391775d5f5ae8a93b308d0b261b2244eb7579a Mon Sep 17 00:00:00 2001
From: 刘小明 <liuxm_a@163.com>
Date: 星期四, 16 一月 2025 09:24:26 +0800
Subject: [PATCH] 追溯小程序:产品列表,产品详情接口
---
pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 51 insertions(+), 6 deletions(-)
diff --git a/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java b/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java
index 3520071..eb86ddc 100644
--- a/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java
+++ b/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java
@@ -1,6 +1,7 @@
package com.dy.pmsOther.screen;
+import cn.hutool.core.date.DateTime;
import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
@@ -48,6 +49,7 @@
private OthStatisticWorkloadMapper workloadDao;
private PrOrderMapper orderDao;
+ private OthStatisticWorkloadMapper statisticWorkDao;
@Autowired
public void setOrderDao(PrOrderMapper orderDao) {
@@ -92,6 +94,11 @@
@Autowired
public void setWorkloadDao(OthStatisticWorkloadMapper workloadDao) {
this.workloadDao = workloadDao;
+ }
+
+ @Autowired
+ public void setStatisticWorkDao(OthStatisticWorkloadMapper statisticWorkDao) {
+ this.statisticWorkDao = statisticWorkDao;
}
public Map<String, Object> getDeviceInfo(String deviceNo) {
@@ -170,14 +177,13 @@
return list;
}
- public List<JSONObject> queryOrderList() {
- List<JSONObject> list = assemblyPlanDao.queryPlanList();
- /* Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize();
- List<PrOrder> orderList = orderDao.selectAll(params);
+ public List<PrOrder> queryOrderList() {
+ Map<String, Object> params = new HashMap<>();
+ List<PrOrder> orderList = orderDao.selectSome(params);
for (PrOrder prOrder : orderList) {
changeRate(prOrder);
- }*/
- return null;
+ }
+ return orderList;
}
private void changeRate(PrOrder prOrder) {
if (prOrder != null && prOrder.items != null) {
@@ -205,4 +211,43 @@
}
}
}
+
+ public List<JSONObject> queryTopError() {
+ Date startDt = Date.from(LocalDateTime.of(LocalDate.now().minusDays(2000), LocalTime.of(0, 0, 0)).atZone(ZoneId.systemDefault()).toInstant());
+ Date endDt = new Date();
+ List<JSONObject> list = deviceProductionLogDao.queryTopError(startDt, endDt);
+ return list;
+ }
+ public JSONObject queryAttendUser() {
+ Date startDt = Date.from(LocalDateTime.of(LocalDate.now().minusDays(2000), LocalTime.of(0, 0, 0)).atZone(ZoneId.systemDefault()).toInstant());
+ Date endDt = new Date();
+ Date todayDt = Date.from(LocalDateTime.of(LocalDate.now(), LocalTime.of(0, 0, 0)).atZone(ZoneId.systemDefault()).toInstant());
+ List<JSONObject> list = assemblyWorkLastDao.queryAttendUser(startDt, endDt,todayDt);
+ if(list.size() == 0){
+ JSONObject obj = new JSONObject();
+ obj.set("require_attend", "0");
+ obj.set("actual_attend", "0");
+ return obj;
+ }
+ return list.get(0);
+ }
+
+ public List<JSONObject> queryStatisticWork() {
+ Date startDt = Date.from(LocalDateTime.of(LocalDate.now(), LocalTime.of(0, 0, 0)).atZone(ZoneId.systemDefault()).toInstant());
+ Date endDt = new Date();
+ List<JSONObject> list = statisticWorkDao.queryStatisticWork(startDt, endDt);
+ return list;
+ }
+ public JSONObject queryStatisticOrder() {
+ List<JSONObject> list = orderDao.queryStatisticOrder();
+ if(list.size() == 0){
+ JSONObject obj = new JSONObject();
+ obj.set("total", "0");
+ obj.set("year_total", "0");
+ obj.set("complete", "0");
+ obj.set("uncomplete", "0");
+ return obj;
+ }
+ return list.get(0);
+ }
}
--
Gitblit v1.8.0