From 8a6d160963ff362fea468637b1a0873d445d7aea Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期二, 29 四月 2025 16:07:06 +0800 Subject: [PATCH] 大屏修改 --- ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/large/service/impl/AnalysisRecycleDataServiceImpl.java | 69 +++++++++++++++++++--------------- 1 files changed, 39 insertions(+), 30 deletions(-) diff --git a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/large/service/impl/AnalysisRecycleDataServiceImpl.java b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/large/service/impl/AnalysisRecycleDataServiceImpl.java index fdb1f67..806a300 100644 --- a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/large/service/impl/AnalysisRecycleDataServiceImpl.java +++ b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/large/service/impl/AnalysisRecycleDataServiceImpl.java @@ -13,10 +13,7 @@ import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.LocalDateTime; -import java.util.Date; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import java.util.*; /** * <p> @@ -31,49 +28,61 @@ @Override - public Map<String,Long> recycleLarge(Integer analysisType) { - Map<String,Long> map = new HashMap<>(); + public Map<String,Integer> recycleLarge(Integer analysisType) { + Map<String,Integer> map = new HashMap<>(); if (analysisType == 1) { // 年份 String year = LocalDateTime.now().getYear()+"年"; - long count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, year)); - map.put(year,count); + AnalysisRecycleData analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, year).last("LIMIT 1")); + map.put(year,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); year = LocalDateTime.now().minusYears(1).getYear()+"年"; - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, year)); - map.put(year,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, year).last("LIMIT 1")); + map.put(year,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); year = LocalDateTime.now().minusYears(2).getYear()+"年"; - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, year)); - map.put(year,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, year).last("LIMIT 1")); + map.put(year,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); year = LocalDateTime.now().minusYears(3).getYear()+"年"; - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, year)); - map.put(year,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, year).last("LIMIT 1")); + map.put(year,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); year = LocalDateTime.now().minusYears(4).getYear()+"年"; - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, year)); - map.put(year,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, year).last("LIMIT 1")); + map.put(year,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); year = LocalDateTime.now().minusYears(5).getYear()+"年"; - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, year)); - map.put(year,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, year).last("LIMIT 1")); + map.put(year,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); return map; } else{ // 月份 String month = new SimpleDateFormat("yyyy年MM月").format(new Date()); - long count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, month)); - map.put(month,count); + AnalysisRecycleData analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, month).last("LIMIT 1")); + map.put(month, Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); month = new SimpleDateFormat("yyyy年MM月").format(DateUtils.localDateTimeToDate(LocalDateTime.now().minusMonths(1))); - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, month)); - map.put(month,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, month).last("LIMIT 1")); + map.put(month,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); month = new SimpleDateFormat("yyyy年MM月").format(DateUtils.localDateTimeToDate(LocalDateTime.now().minusMonths(2))); - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, month)); - map.put(month,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, month).last("LIMIT 1")); + map.put(month,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); month = new SimpleDateFormat("yyyy年MM月").format(DateUtils.localDateTimeToDate(LocalDateTime.now().minusMonths(3))); - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, month)); - map.put(month,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, month).last("LIMIT 1")); + map.put(month,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); month = new SimpleDateFormat("yyyy年MM月").format(DateUtils.localDateTimeToDate(LocalDateTime.now().minusMonths(4))); - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, month)); - map.put(month,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, month).last("LIMIT 1")); + map.put(month,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); month = new SimpleDateFormat("yyyy年MM月").format(DateUtils.localDateTimeToDate(LocalDateTime.now().minusMonths(5))); - count = this.count(Wrappers.lambdaQuery(AnalysisRecycleData.class).eq(AnalysisRecycleData::getAnalysisValue, month)); - map.put(month,count); + analysisRecycleData = this.getOne(Wrappers.lambdaQuery(AnalysisRecycleData.class) + .eq(AnalysisRecycleData::getAnalysisValue, month).last("LIMIT 1")); + map.put(month,Objects.nonNull(analysisRecycleData)?analysisRecycleData.getOrderCount():0); return map; } } -- Gitblit v1.7.1