| | |
| | | THIS_YEAR_MONTH("THIS_YEAR_MONTH", "当年月份"), |
| | | LAST_YEAR("LAST_YEAR", "去年"), |
| | | THIS_YEAR("THIS_YEAR_MONTH", "今年"), |
| | | LAST_HOUR_24("LAST_HOUR_24", "最近24小时"), |
| | | CUSTOM("CUSTOM", "自定义"); |
| | | |
| | | private String code; |
| | |
| | | whereSql.append(DateUtils.format(calendar.getTime(), PATTERN_YEAR)); |
| | | whereSql.append("'"); |
| | | break; |
| | | case LAST_HOUR_24: |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append("' < '"); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); |
| | | whereSql.append("' AND '"); |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" >= '"); |
| | | calendar.add(Calendar.HOUR_OF_DAY, -24); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); |
| | | whereSql.append("'"); |
| | | break; |
| | | case CUSTOM: |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" <= '"); |