工业互联网平台
上一版本: 694e3428 | 补丁 | 提交 | 显示空白
dengzedong
2025-05-21 93b0088bc687bb9b33d226706892e90e4346d608 
whereSql 派生逻辑
已修改1个文件
16 ■■■■■ 文件已修改
iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/ind/collection/utils/IndSqlUtils.java 16 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 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());