工业互联网平台
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
houzhongjian
3 天以前 6e0d1d51916e4f41e06c06e984a70ebd08352d95 
 iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/ind/collection/utils/IndSqlUtils.java


@@ -166,7 +166,9 @@


                break;


            case YESTERDAY:


                whereSql.append(indItem.getTimeLabel());


                whereSql.append(" <= '");


                whereSql.append(" < '");


                calendar.set(Calendar.MINUTE, 0);


                calendar.set(Calendar.HOUR_OF_DAY, 0);


                whereSql.append(DateUtils.format(calendar.getTime(), datePattern));


                whereSql.append("' AND ");


                whereSql.append(indItem.getTimeLabel());


@@ -177,7 +179,9 @@


                break;


            case LAST_DAY_7:


                whereSql.append(indItem.getTimeLabel());


                whereSql.append(" <= '");


                whereSql.append(" < '");


                calendar.set(Calendar.MINUTE, 0);


                calendar.set(Calendar.HOUR_OF_DAY, 0);


                whereSql.append(DateUtils.format(calendar.getTime(), datePattern));


                whereSql.append("' AND ");


                whereSql.append(indItem.getTimeLabel());


@@ -188,7 +192,9 @@


                break;


            case LAST_DAY_30:


                whereSql.append(indItem.getTimeLabel());


                whereSql.append(" <= '");


                whereSql.append(" < '");


                calendar.set(Calendar.MINUTE, 0);


                calendar.set(Calendar.HOUR_OF_DAY, 0);


                whereSql.append(DateUtils.format(calendar.getTime(), datePattern));


                whereSql.append("' AND ");


                whereSql.append(indItem.getTimeLabel());


@@ -199,7 +205,9 @@


                break;


            case LAST_DAY_90:


                whereSql.append(indItem.getTimeLabel());


                whereSql.append(" <= '");


                whereSql.append(" < '");


                calendar.set(Calendar.MINUTE, 0);


                calendar.set(Calendar.HOUR_OF_DAY, 0);


                whereSql.append(DateUtils.format(calendar.getTime(), datePattern));


                whereSql.append("' AND ");


                whereSql.append(indItem.getTimeLabel());