| | |
| | | package com.ruoyi.admin.large.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.admin.large.mapper.AnalysisRecycleDataMapper; |
| | | import com.ruoyi.admin.large.model.AnalysisRecycleData; |
| | | import com.ruoyi.admin.large.model.vo.RecycleLargeVO; |
| | | import com.ruoyi.admin.large.service.AnalysisRecycleDataService; |
| | | import com.ruoyi.common.core.utils.DateUtils; |
| | | import io.swagger.models.auth.In; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | @Service |
| | | public class AnalysisRecycleDataServiceImpl extends ServiceImpl<AnalysisRecycleDataMapper, AnalysisRecycleData> implements AnalysisRecycleDataService { |
| | | |
| | | |
| | | @Override |
| | | public Map<String,Integer> recycleLarge(Integer analysisType) { |
| | | Map<String,Integer> map = new HashMap<>(); |
| | | if (analysisType == 1) { |
| | | // 年份 |
| | | String year = LocalDateTime.now().getYear()+"年"; |
| | | 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()+"年"; |
| | | 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()+"年"; |
| | | 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()+"年"; |
| | | 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()+"年"; |
| | | 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()+"年"; |
| | | 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()); |
| | | 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))); |
| | | 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))); |
| | | 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))); |
| | | 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))); |
| | | 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))); |
| | | 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; |
| | | } |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | System.err.println(LocalDateTime.now().getYear()+"年"); |
| | | } |
| | | |
| | | } |