归档支持自定义文件夹路径（多层级）

许鹏程

2025-02-17 857a2c00d1c1fe388af449badf6c9d67d05c0bd9

归档支持自定义文件夹路径（多层级）

 src/main/java/com/product/file/service/DocumentDirectoryService.java

@@ -124,7 +124,7 @@
                }
                fieldInfo = BaseUtil.getSingleInfoByCache("表字段信息", new String[]{functionUuid.getString("table_uuid"), fieldName});
                i++;
            } while (FieldSetEntity.isEmpty(fieldInfo));
            } while (!FieldSetEntity.isEmpty(fieldInfo));
            FieldSetEntity fs = new FieldSetEntity();
            fs.setTableName(CmnConst.PRODUCT_SYS_DATAMODEL_FIELD);
            fs.setValue("table_uuid", functionUuid.getString("table_uuid"));
@@ -250,7 +250,7 @@
        for (int i = 0; i < businessValueField.size(); i++) {
            sql.append("\tT1." + businessValueField.get(i) + " as val_").append(i).append("\n,");
        }
        sql.append("\tT2.uuid,T2.attachment_size,T2.file_name,T3.dict_label file_type\n");
        sql.append("\tT2.uuid,T2.attachment_size,T2.file_name,T3.dict_label file_type,T4.record_uuid\n");
        sql.append("FROM\n");
        sql.append("\t").append(tableInfo.getString(CoreConst.FIELD_TABLE_NAME)).append(" T1\n");
        sql.append("\tJOIN product_sys_flow_detail T4 ON T1.uuid=T4.record_uuid\n");
@@ -258,9 +258,9 @@
        sql.append("\tJOIN product_sys_dict T3 ON T2.attachment_type_uuid=T3.uuid\n");
        sql.append("WHERE\n");
        sql.append("\tT1.flow_flag =2\n");
        sql.append("\tAND T1." + archiveFlagField + " =1\n");
        sql.append("\tAND T1.").append(archiveFlagField).append(" is null or ").append(archiveFlagField).append("!=1\n");
        sql.append("\tAND T4.table_name='").append(tableInfo.getString(CoreConst.FIELD_TABLE_NAME)).append("'\n");
        sql.append("\tGROUP BY 1,2,3,4 limit ").append(pageSize);
        sql.append("\tGROUP BY 1,2,3,4,5 limit ").append(pageSize);

        DataTableEntity files = null;
        String filing_catalog = fs.getString("filing_catalog");
@@ -306,6 +306,7 @@
                document.setValue("created_utc_datetime", new Date());
                document.setValue("file_size", file.getString("attachment_size"));
                baseDao.saveFieldSetEntity(document);
                baseDao.executeUpdate(" update " + tableInfo.getString("table_name") + " set " + archiveFlagField + "= '1' where uuid=?", new Object[]{file.getString("record_uuid")});
            }
        } while (!DataTableEntity.isEmpty(files));