| | |
|---|
| | | temperatureHumidityDataResponseList.stream().filter(i->i.getIndexCode().indexOf(code)>=Constants.ZERO).collect(Collectors.toList()); |
|---|
| | | TemperatureHumidityDataVO temperatureHumidityDataVO = new TemperatureHumidityDataVO(); |
|---|
| | | for (TemperatureHumidityDataResponse data:dateList) { |
|---|
| | | if(data.getSensorType().equals("temp")){ |
|---|
| | | if(StringUtils.isNotBlank(data.getName())){ |
|---|
| | | Integer index = data.getName().indexOf("-"); |
|---|
| | | if(index>=0){ |
|---|
| | | data.setName(data.getName().substring(0,index)); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if(data.getSensorType().equals("currTemperature")){ |
|---|
| | | temperatureHumidityDataVO.setTemperatureData(data); |
|---|
| | | }else{ |
|---|
| | | temperatureHumidityDataVO.setHumidityData(data); |
|---|
| | |
|---|
| | | .select("( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newStartDate") |
|---|
| | | //.select(" ( select sum(ifnull(pl.IO_QTY , 0 )) from platform_wms_detail pl where pl.job_id = t.id and pl.isdeleted=0 )",PlatformJob::getWorkNum) |
|---|
| | | .select(" ( case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end )",PlatformJob::getWorkNum) |
|---|
| | | .apply("to_days(t.create_date) = to_days(now())") |
|---|
| | | // .apply("to_days(t.create_date) = to_days(now())") |
|---|
| | | .eq(Platform::getIsdeleted, Constants.ZERO) |
|---|
| | | .in(PlatformJob ::getStatus,new Integer[]{Constants.PlatformJobStatus.WORKING.getKey(),Constants.PlatformJobStatus.CALLED.getKey() }) |
|---|
| | | // .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
|---|
| | | .orderByDesc(PlatformJob::getStatus )); |
|---|
| | | .orderByDesc(PlatformJob::getStatus ) |
|---|
| | | .orderByAsc(PlatformJob::getId ) |
|---|
| | | ); |
|---|
| | | //月台状态：0=作业中；1=空闲中；2=作业超时;3=叫号 |
|---|
| | | for(Platform model : platformList){ |
|---|
| | | PlatformWorkDataVO platformDurationVO = new PlatformWorkDataVO(); |
|---|
