| | |
|---|
| | | .select(" ( select ROUND( ifnull(SUM(pl.PARAM3),0) / 3600 , 2 ) from platform_log pl where pl.remark = t.id " + |
|---|
| | | " and pl.CREATE_DATE > '"+DateUtil.getFomartDate(platform.getQueryDateStart(),"yyyy-MM-dd")+" 00:00:00' " + |
|---|
| | | "and pl.CREATE_DATE <= '"+DateUtil.getFomartDate(platform.getQueryDateEnd(),"yyyy-MM-dd")+" 23:59:59' ) as workCountTime ") |
|---|
| | | .select(" ( select count(1) from platform_log pl where pl.remark = t.id " + |
|---|
| | | " and pl.CREATE_DATE > '"+DateUtil.getFomartDate(platform.getQueryDateStart(),"yyyy-MM-dd")+" 00:00:00' " + |
|---|
| | | "and pl.CREATE_DATE <= '"+DateUtil.getFomartDate(platform.getQueryDateEnd(),"yyyy-MM-dd")+" 23:59:59' and pl.OBJ_TYPE = 5 ) as stopCount ") |
|---|
| | | .leftJoin(PlatformGroup.class,PlatformGroup::getId,Platform::getGroupId); |
|---|
| | | queryWrapper |
|---|
| | | .eq(platform.getGroupId() != null, Platform::getGroupId, platform.getGroupId()) |
|---|
| | |
|---|
| | | //查询2日期相差天数 |
|---|
| | | Integer sumDays = DateUtil.daysBetweenDates(platform.getQueryDateEnd(),platform.getQueryDateStart())+1; |
|---|
| | | for (Platform bean:platformList) { |
|---|
| | | List<PlatformJob> beanJobList = platformJobList.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),bean.getId())).collect(Collectors.toList()); |
|---|
| | | bean.setStopCount(beanJobList.size()); |
|---|
| | | if(Objects.isNull(bean.getOpenTime())||bean.getOpenTime().compareTo(BigDecimal.ZERO)<=0){ |
|---|
| | | bean.setUseRata(BigDecimal.ZERO); |
|---|
| | | continue; |
|---|
