xuhy
2025-04-29 8a6d160963ff362fea468637b1a0873d445d7aea
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;
        }
    }