| | |
| | | YESTERDAY("YESTERDAY", "昨天"), |
| | | LAST_DAY_7("LAST_DAY_7", "最近7天"), |
| | | LAST_DAY_30("LAST_DAY_30", "最近30天"), |
| | | LAST_DAY_90("LAST_DAY_90", "最近90天"), |
| | | THIS_MONTH("THIS_MONTH", "当前月"), |
| | | LAST_MONTH("LAST_MONTH", "上月"), |
| | | LAST_MONTH_12("LAST_MONTH_12", "最近12个月"), |
| | |
| | | import org.springframework.stereotype.Component; |
| | | |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.YearMonth; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.Calendar; |
| | | import java.util.Date; |
| | | |
| | |
| | | whereSql.append(DateUtils.format(calendar.getTime(), datePattern)); |
| | | whereSql.append("'"); |
| | | break; |
| | | case LAST_DAY_90: |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" <= '"); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), datePattern)); |
| | | whereSql.append("' AND "); |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" >= '"); |
| | | calendar.add(Calendar.DAY_OF_YEAR, -90); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), datePattern)); |
| | | whereSql.append("'"); |
| | | break; |
| | | case THIS_MONTH: |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append("='"); |