queryStatisticOrder

Fancy

2025-01-14 057d4df78bcc5b34ca7c6897918946c4a9e65d18

 pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java

@@ -49,6 +49,7 @@

    private OthStatisticWorkloadMapper workloadDao;
    private PrOrderMapper orderDao;
    private OthStatisticWorkloadMapper statisticWorkDao;

    @Autowired
    public void setOrderDao(PrOrderMapper orderDao) {
@@ -95,6 +96,10 @@
        this.workloadDao = workloadDao;
    }

    @Autowired
    public void setStatisticWorkDao(OthStatisticWorkloadMapper statisticWorkDao) {
        this.statisticWorkDao = statisticWorkDao;
    }

    public Map<String, Object> getDeviceInfo(String deviceNo) {
        if (StringUtils.isBlank(deviceNo)) {
@@ -172,6 +177,7 @@
        return list;
    }

    //没写完
    public List<JSONObject> queryOrderList() {
        List<JSONObject> list = assemblyPlanDao.queryPlanList();
       /* Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize();
@@ -214,11 +220,36 @@
        List<JSONObject> list = deviceProductionLogDao.queryTopError(startDt, endDt);
        return list;
    }
    public List<JSONObject> queryAttendUser() {
    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);
    }
}