| | |
| | | */ |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | }else { |
| | | timeStart = LocalDate.now() + " 00:00:00"; |
| | | } |
| | | |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | }else { |
| | | timeStart = LocalDate.now() + " 00:00:00"; |
| | | } |
| | | }else { |
| | | timeStart = null; |
| | | } |
| | | qo.setTimeStart(timeStart); |
| | | qo.setTimeStop(timeStop); |
| | |
| | | */ |
| | | public VoCountOfOpenType getCountByOpenType(OpenTypeQO qo) { |
| | | /** |
| | | * 补齐起止时间,如果开始时间为空,则默认为当前日期 |
| | | * 补齐起止时间,如果开始时间为空,则默认为当前日期,如果结束时间为空,则查询时间为空 |
| | | */ |
| | | String timeStart = qo.getTimeStart(); |
| | | String timeStop = qo.getTimeStop(); |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | }else { |
| | | timeStart = LocalDate.now() + " 00:00:00"; |
| | | } |
| | | if(timeStop != null) { |
| | | timeStop = timeStop + " 23:59:59"; |
| | | if(timeStart != null) { |
| | | timeStart = timeStart + " 00:00:00"; |
| | | }else { |
| | | timeStart = LocalDate.now() + " 00:00:00"; |
| | | } |
| | | }else { |
| | | timeStart = null; |
| | | } |
| | | qo.setTimeStart(timeStart); |
| | | qo.setTimeStop(timeStop); |
| | | |
| | | Integer openType = qo.getOpenType(); |
| | | String openTypeName = ""; |
| | | switch (openType) { |
| | | case 1: |
| | | openTypeName = "刷卡开阀"; |
| | | break; |
| | | case 3: |
| | | openTypeName = "中心站开阀"; |
| | | break; |
| | | case 8: |
| | | openTypeName = "用户远程开阀"; |
| | | break; |
| | | case 11: |
| | | openTypeName = "开关阀卡开阀"; |
| | | break; |
| | | case 13: |
| | | openTypeName = "开关阀卡开阀"; |
| | | break; |
| | | if (openType == null){ |
| | | openTypeName = "未知"; |
| | | }else { |
| | | switch (openType) { |
| | | case 1: |
| | | openTypeName = "刷卡开阀"; |
| | | break; |
| | | case 3: |
| | | openTypeName = "中心站开阀"; |
| | | break; |
| | | case 8: |
| | | openTypeName = "用户远程开阀"; |
| | | break; |
| | | case 11: |
| | | openTypeName = "开关阀卡开阀"; |
| | | break; |
| | | case 13: |
| | | openTypeName = "开关阀卡开阀"; |
| | | break; |
| | | default: |
| | | openTypeName = "未知"; |
| | | } |
| | | } |
| | | |
| | | // 生成查询参数 |