| | |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.time.ZoneId; |
|---|
| | | import java.util.*; |
|---|
| | | import java.util.stream.Collectors; |
|---|
| | | |
|---|
| | |
|---|
| | | public List<TransportMeasureVO> transportMeasure(Integer queryType){ |
|---|
| | | List<TransportMeasureVO> list = new ArrayList<>(); |
|---|
| | | Random random = new Random(); |
|---|
| | | List<String> dayList = DateUtil.getBeforDays(new Date(),7); |
|---|
| | | List<Date> dayList = DateUtil.getDateListBeforDays(new Date(),7);//近7天 |
|---|
| | | if(Constants.equalsInteger(queryType,Constants.ONE)){ |
|---|
| | | dayList = DateUtil.getBeforDays(new Date(),30); |
|---|
| | | dayList = DateUtil.getThisMonthDateList();//本月天数 |
|---|
| | | }else if(Constants.equalsInteger(queryType,Constants.TWO)){ |
|---|
| | | dayList = DateUtil.getBeforMonth(new Date(),12); |
|---|
| | | dayList = DateUtil.getThisYearMonthList();//本年月份 |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | for (String str:dayList) { |
|---|
| | | List<PlatformJob> dataList = platformJobMapper.selectJoinList(PlatformJob.class, |
|---|
| | | new MPJLambdaWrapper<PlatformJob>() |
|---|
| | | .selectAs(PlatformJob::getId,PlatformJob::getId) |
|---|
| | | .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) |
|---|
| | | .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",PlatformJob::getIoQty) |
|---|
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
|---|
| | | .apply(queryType==0,"to_days(create_date) >= to_days(now()) -7") |
|---|
| | | .apply(queryType==1,"year(create_date) = year(now()) and month(create_date) = month(now())") |
|---|
| | | .apply(queryType==2,"year(create_date) = year(now())")); |
|---|
| | | for (Date date : dayList) { |
|---|
| | | TransportMeasureVO data = new TransportMeasureVO(); |
|---|
| | | data.setPlanDate(str); |
|---|
| | | data.setPlanDate(date); |
|---|
| | | data.setPlanTimes(random.nextInt(200)); |
|---|
| | | data.setPlanTaskNum(new BigDecimal(random.nextInt(1000))); |
|---|
| | | data.setFinishTaskNum(new BigDecimal(data.getPlanTaskNum().intValue())); |
|---|
