From 036ffc1b770cf0a3247890b8fdd88884376d8b6d Mon Sep 17 00:00:00 2001 From: 许鹏程 <1821349743@qq.com> Date: 星期二, 26 十一月 2024 15:25:38 +0800 Subject: [PATCH] 排序 parent --- src/main/java/com/product/mobile/core/service/FaceMobileService.java | 300 +++++++++++++++++++++++++++++++++++++++++++----------------- 1 files changed, 215 insertions(+), 85 deletions(-) diff --git a/src/main/java/com/product/mobile/core/service/FaceMobileService.java b/src/main/java/com/product/mobile/core/service/FaceMobileService.java index 44bb837..3a012b3 100644 --- a/src/main/java/com/product/mobile/core/service/FaceMobileService.java +++ b/src/main/java/com/product/mobile/core/service/FaceMobileService.java @@ -1,14 +1,19 @@ package com.product.mobile.core.service; import cn.hutool.core.collection.CollectionUtil; +import cn.hutool.core.io.FileUtil; +import cn.hutool.core.util.CharsetUtil; +import cn.hutool.core.util.NumberUtil; import cn.hutool.core.util.ReflectUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.drew.metadata.Face; +import com.google.common.collect.Lists; import com.google.common.collect.Sets; import com.product.common.lang.StringUtils; import com.product.core.cache.DataPoolCacheImpl; +import com.product.core.dao.BaseDao; import com.product.core.entity.DataTableEntity; import com.product.core.entity.FieldSetEntity; import com.product.core.exception.BaseException; @@ -19,10 +24,15 @@ import com.product.tool.flow.config.CmnConst; import com.product.tool.flow.service.FlowDetailService; import com.product.util.BaseUtil; + +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.annotation.Resource; +import java.io.File; +import java.nio.charset.Charset; import java.util.*; +import java.util.stream.Collectors; /** * @Author cheng @@ -34,129 +44,184 @@ @Resource FlowDetailService flowDetailService; - + + @Autowired + public BaseDao baseDao; + ///鑾峰彇琛ㄥ崟鎬诲叆鍙� /** - * + * * @param fse浼犲叆琛ㄥ悕锛屾垨 琛║UID * @return */ public List<FaceFieldEntity> getFaceConfig(FieldSetEntity fse) { - - String tableUuid=fse.getString("table_uuid"); - if (tableUuid==null && StringUtils.isNotEmpty(fse.getString("uuid")) + + String tableUuid = fse.getString("table_uuid"); + if (tableUuid == null && StringUtils.isNotEmpty(fse.getString("uuid")) && StringUtils.isEmpty(fse.getString("table_name"))) { //閫氳繃涓氬姟琛ㄤ俊鎭煡琛ㄥ崟淇℃伅 FieldSetEntity detailFse = getBaseDao().getFieldSetEntity(CmnConst.TABLE_FLOW_DETAIL, fse.getString(CmnConst.FIELD_UUID), false); - if(detailFse!=null) { + if (detailFse != null) { //鑾峰彇琛ㄥ悕 fse.setValue("table_name", detailFse.getString("table_name")); } - + } //閫氳繃瀹℃壒浠诲姟鐨剈uid鏉ユ煡琛ㄥ崟淇℃伅 - if (tableUuid==null && StringUtils.isNotEmpty(fse.getString("table_name"))) { + if (tableUuid == null && StringUtils.isNotEmpty(fse.getString("table_name"))) { FieldSetEntity tableInfo = BaseUtil.getSingleInfoByCache("鎵�鏈夎〃淇℃伅", new String[]{fse.getString("table_name")}); if (!FieldSetEntity.isEmpty(tableInfo)) { tableUuid = tableInfo.getString("uuid"); fse.setValue("table_uuid", tableUuid); } } - - if(tableUuid!=null) { - + + if (tableUuid != null && fse.getString("table_name") == null) { + FieldSetEntity tableInfo = BaseUtil.getSingleInfoByCache("鎵�鏈夎〃淇℃伅(uuid)", new String[]{tableUuid}); if (!FieldSetEntity.isEmpty(tableInfo)) { //鑾峰彇琛ㄥ悕 fse.setValue("table_name", tableInfo.getString("table_name")); } } - - List<FaceFieldEntity> ls=getFaceFieldByTable(fse); - - addproperty(tableUuid,fse.getString("table_name"),ls); + + List<FaceFieldEntity> ls = getFaceFieldByTable(fse); + if (ls == null) ls = new ArrayList<FaceFieldEntity>(); + addproperty(tableUuid, fse.getString("table_name"), ls); //鎵�鏈夎〃鍗晆uid鑷姩娣诲姞锛屽苟涓篽idden return ls; - + } //閫掑綊鎶婁富琛ㄥ拰瀛愯〃鐨勫瓧娈靛睘鎬ф坊鍔犺繘鍘伙紝濡傛灉娌℃湁閰嶈〃鍗曪紝鍒欏彇琛ㄦ暟鎹粨鏋勮繘琛屽睍绀� + /** - * + * * @param ls鏌ュ嚭鏉ョ殑琛ㄥ崟淇℃伅 * @param tables 璁板綍鐨勬墍鏈夎〃锛屽搴旂殑琛ㄥ崟淇℃伅 */ - private void addproperty(String table_uuid,String table_name,List<FaceFieldEntity> ls) { - if(ls==null) { - ls=new ArrayList<FaceFieldEntity>(); - } - if(ls.size()>0) { - for(int i=0;i<ls.size();i++) { - String subTableName=ls.get(i).getSubTableName();///鍙兘鏄瓙琛� - if(StringUtils.isEmpty(subTableName)) {///涓昏〃瀛楁 + private void addproperty(String table_uuid, String table_name, List<FaceFieldEntity> ls) { + if (ls.size() > 0) { + for (int i = 0; i < ls.size(); i++) { + String subTableName = ls.get(i).getSubTableName();///鍙兘鏄瓙琛� + if (StringUtils.isEmpty(subTableName)) {///涓昏〃瀛楁 DataTableEntity dt = DataPoolCacheImpl.getInstance().getCacheData("琛ㄥ瓧娈典俊鎭�" - ,new String[] {table_uuid,ls.get(i).getField()}); - - if(!DataTableEntity.isEmpty(dt)) { + , new String[]{table_uuid, ls.get(i).getField()}); + + if (!DataTableEntity.isEmpty(dt)) { // if(StringUtils.isEmpty(ls.get(i).getType())) { // ls.get(i).setType(dt.getFieldSetEntity(0).getString("field_type")); // } - if(StringUtils.isEmpty(ls.get(i).getPrompt()) && + if (StringUtils.isEmpty(ls.get(i).getPrompt()) && !StringUtils.isEmpty(dt.getFieldSetEntity(0).getString("field_reference"))) { ls.get(i).setPrompt(dt.getFieldSetEntity(0).getString("field_reference")); } - if(StringUtils.isEmpty(ls.get(i).getRequired()) && + if (StringUtils.isEmpty(ls.get(i).getRequired()) && !StringUtils.isEmpty(dt.getFieldSetEntity(0).getString("is_required"))) { ls.get(i).setRequired(dt.getFieldSetEntity(0).getString("is_required")); } - if(StringUtils.isEmpty(ls.get(i).getName()) && + if (StringUtils.isEmpty(ls.get(i).getName()) && !StringUtils.isEmpty(dt.getFieldSetEntity(0).getString("field_show_name"))) { ls.get(i).setName(dt.getFieldSetEntity(0).getString("field_show_name")); } + if ("file".indexOf(ls.get(i).getComponentType()) != -1) { + //闄勪欢 + //鑾峰彇瀛楁绫诲瀷 + String fieldType = dt.getString(0, "field_type"); + if ("file-image".equals(fieldType)) { + ls.get(i).putOtherParam("fieldType", "image"); + } else { +// ls.get(i).putOtherParam("fieldType", "file"); + } + } } ls.get(i).setTable(table_name); - }else { + } else { //============鎶婂瓙琛ㄥ瓧娈典篃澶勭悊涓�涓� //瀛愯〃 FieldSetEntity tableInfo = BaseUtil.getSingleInfoByCache("鎵�鏈夎〃淇℃伅", new String[]{subTableName}); if (!FieldSetEntity.isEmpty(tableInfo)) { - addproperty(tableInfo.getString("uuid"),tableInfo.getString("table_name"),ls.get(i).getSubField()); + addproperty(tableInfo.getString("uuid"), tableInfo.getString("table_name"), ls.get(i).getSubField()); } } - + } - DataTableEntity dt = DataPoolCacheImpl.getInstance().getCacheData("琛ㄥ瓧娈典俊鎭�",new String[] {table_uuid,"uuid"}); - if(!DataTableEntity.isEmpty(dt)) { - FaceFieldEntity uuid=new FaceFieldEntity(); + DataTableEntity dt = DataPoolCacheImpl.getInstance().getCacheData("琛ㄥ瓧娈典俊鎭�", new String[]{table_uuid, "uuid"}); + if (!DataTableEntity.isEmpty(dt)) { + FaceFieldEntity uuid = new FaceFieldEntity(); + uuid.setComponentType("uuid"); uuid.setField("uuid"); + uuid.setName("缂� 鐮�"); uuid.setType("String"); uuid.setTable(table_name); - uuid.setDisabled("0"); + uuid.setHidden("1"); ls.add(uuid); } - - }else {///浠ヨ〃鍗曡璁′负鍑嗭紝濡傛灉娌℃湁閰嶇疆琛ㄥ崟锛屽垯浠ユ暟鎹〃涓哄噯锛屽叏閮ㄤ繚鐣� - DataTableEntity dte = DataPoolCacheImpl.getInstance().getCacheData("鎵�鏈夊瓧娈典俊鎭苟鎸夎〃鍒嗙粍",new String[] {table_uuid}); - for(int j=0;j<dte.getRows();j++) { - FaceFieldEntity uuid=new FaceFieldEntity(); - FieldSetEntity f=dte.getFieldSetEntity(j); - if("pk".equals(f.getString("field_type")) - ||"updated_by".equals(f.getString("field_name")) - ||"uuid".equals(f.getString("field_name")) - ||"updated_utc_datetime".equals(f.getString("field_name"))) { - continue; + + } else {///浠ヨ〃鍗曡璁′负鍑嗭紝濡傛灉娌℃湁閰嶇疆琛ㄥ崟锛屽垯浠ユ暟鎹〃涓哄噯锛屽叏閮ㄤ繚鐣� + toConvertFace(table_uuid, table_name, ls, null); + //杩斿洖瀛愯〃 + Object[][] sub = baseDao.getSubTableName(table_name); + if (sub != null && sub.length > 0 && sub[0].length > 0) { + for (int i = 0; i < sub[0].length; i++) { + toConvertFace(sub[0][i].toString(), sub[1][i].toString(), new ArrayList<FaceFieldEntity>(), ls); } - uuid.setPrompt(f.getString("field_reference")); - uuid.setName(f.getString("field_show_name")); - uuid.setField(f.getString("field_name")); - uuid.setType(f.getString("field_type")); - uuid.setTable(table_name); - ls.add(uuid); } + } } - - - + + /** + * 鏁版嵁搴撹〃瀛楁瀹氫箟杞崲鎴愯〃鍗曞畾涔� + * @param table_uuid + * @param table_name + * @param ls + * @param pls 鐖剁晫闈� + */ + private void toConvertFace(String table_uuid, String table_name, List<FaceFieldEntity> ls, List<FaceFieldEntity> pls) { + if (ls == null) { + ls = new ArrayList<FaceFieldEntity>(); + } + DataTableEntity dte = DataPoolCacheImpl.getInstance().getCacheData("鎵�鏈夊瓧娈典俊鎭苟鎸夎〃鍒嗙粍", new String[]{table_uuid}); + for (int j = 0; j < dte.getRows(); j++) { + FaceFieldEntity uuid = new FaceFieldEntity(); + FieldSetEntity f = dte.getFieldSetEntity(j); + if ("pk".equals(f.getString("field_type")) + || "updated_by".equals(f.getString("field_name")) + || "updated_utc_datetime".equals(f.getString("field_name"))) { + continue; + } + if ("uuid".equals(f.getString("field_name"))) { + uuid.setHidden("1"); + } + if ("userids".equals(f.getString("field_type")) || "orgUuids".equals(f.getString("field_type"))) { + uuid.setMultiple("1"); + } else { + uuid.setMultiple("0"); + } + + uuid.setComponentType(""); + uuid.setPrompt(f.getString("field_reference")); + uuid.setName(f.getString("field_show_name")); + uuid.setField(f.getString("field_name")); + uuid.setType(f.getString("field_type")); + uuid.setRequired(f.getString("is_required")); + uuid.setTable(table_name); + ls.add(uuid); + } + if (pls != null) { + FaceFieldEntity uuid = new FaceFieldEntity(); + uuid.setHidden(""); + uuid.setComponentType("subTable"); + uuid.setPrompt(""); + uuid.setName(""); + uuid.setField(""); + uuid.setType(""); + uuid.setSubField(ls); + uuid.setSubTableName(table_name); + pls.add(uuid); + } + } + public List<FaceFieldEntity> getFaceFieldByTable(FieldSetEntity fse) { String tableUuid = fse.getString("table_uuid"); String tableName = fse.getString("table_name"); @@ -169,7 +234,7 @@ if (StringUtils.isEmpty(tableUuid)) { throw new BaseException(MobileCoreCode.SYSTEM_FORM_COUNT); } - FieldSetEntity faceFse = getBaseDao().getFieldSetByFilter("product_sys_face", "table_uuid=?", new Object[]{tableUuid}, true); + FieldSetEntity faceFse = getBaseDao().getFieldSetByFilter("product_sys_face", "table_uuid=? and face_type=2", new Object[]{tableUuid}, true); faceFse.setTableName(tableName); return getFaceField(faceFse); } @@ -212,7 +277,8 @@ private List<FaceFieldEntity> getFaceField(FieldSetEntity faceFse) { if (FieldSetEntity.isEmpty(faceFse) || DataTableEntity.isEmpty(faceFse.getSubDataTable("product_sys_face_control_property"))) { - throw new BaseException(MobileCoreCode.GET_FACE_CONFIG_FAIL); + return null; +// throw new BaseException(MobileCoreCode.GET_FACE_CONFIG_FAIL); } DataTableEntity productSysFaceControlProperty = faceFse.getSubDataTable("product_sys_face_control_property"); @@ -248,7 +314,7 @@ } List<FaceFieldEntity> result = new ArrayList<>(); - List<List<FieldSetEntity>> subTableField = new ArrayList<>(); + Map<String, List<FieldSetEntity>> subTableFieldMap = new HashMap<>(); for (FieldSetEntity fs : tagFieldSetEntityList) { String groupUuid = fs.getString("group_uuid"); String parentUuid = fs.getString("parent_uuid"); @@ -256,16 +322,21 @@ continue; } List<FieldSetEntity> fieldSetEntity = productSysFaceControlProperty.getFieldSetEntity(parentUuid); - if (CollectionUtil.isEmpty(fieldSetEntity)) { - continue; + int i = result.size(); + to(groupMap, fieldSetEntity, subTableFieldMap, result, parentMap); + String parentUuid1 = fieldSetEntity.get(0).getString("parent_uuid"); + if (!CollectionUtil.isEmpty(fieldSetEntity) && !StringUtils.isEmpty(parentUuid1)) { + if (i + 1 == result.size()) { + result.get(i).putOtherParam("parent_uuid", parentUuid1); + } } - - to(groupMap, fieldSetEntity, subTableField, result, parentMap); } - if (!CollectionUtil.isEmpty(subTableField)) { + //鏍规嵁group_uuid 灏嗗瓙琛ㄥ瓧娈靛垎缁�5 + if (!CollectionUtil.isEmpty(subTableFieldMap)) { //鏍规嵁瀛愯〃琛ㄥ悕瑁呰浇 Map<String, FaceFieldEntity> tableByFaceField = new HashMap<>(); - for (List<FieldSetEntity> fieldSetEntities : subTableField) { + for (Map.Entry<String, List<FieldSetEntity>> entry : subTableFieldMap.entrySet()) { + List<FieldSetEntity> fieldSetEntities = entry.getValue(); String parentUuid = fieldSetEntities.get(0).getString("parent_uuid"); //鍏堟壘鍒癱hildren List<FieldSetEntity> fieldSetEntity = productSysFaceControlProperty.getFieldSetEntity(parentUuid); @@ -311,6 +382,12 @@ //涓嶆槸瀛愯〃缁勪欢 continue; } + List<FaceFieldEntity> fields = new ArrayList<>(); + for (FieldSetEntity setEntity : fieldSetEntities) { + to(groupMap, Lists.newArrayList(setEntity), null, fields, parentMap); + } + + faceFieldEntity.setSubField(fields); for (FieldSetEntity setEntity : groupMap.get(groupUuid)) { String propertyName = setEntity.getString("property_name"); if ("subTableName".equals(propertyName)) { @@ -320,6 +397,8 @@ faceFieldEntity.setAllowAdd(setEntity.getBoolean("property_value")); } else if ("delete".equals(propertyName)) { faceFieldEntity.setAllowDelete(setEntity.getBoolean("property_value")); + } else if ("control_sequence".equals(propertyName)) { + faceFieldEntity.putOtherParam("controlSequence", setEntity.getInteger("property_value")); } } List<FaceFieldEntity> subFieldList = faceFieldEntity.getSubField(); @@ -327,23 +406,55 @@ subFieldList = new ArrayList<>(); faceFieldEntity.setSubField(subFieldList); } - - for (List<FieldSetEntity> setEntities : subTableField) { - to(groupMap, setEntities, null, subFieldList, parentMap); - } if (!tableByFaceField.containsKey(uuid)) { tableByFaceField.put(uuid, faceFieldEntity); result.add(faceFieldEntity); } - break; - } + } + result.sort((item, item2) -> { + Object o = item.getOtherParams().get("controlSequence"); + if (o == null) { + return -1; + } + Object o1 = item2.getOtherParams().get("controlSequence"); + if (o1 == null) { + return 1; + } + return NumberUtil.parseInt(item.getOtherParams().get("controlSequence").toString()) - NumberUtil.parseInt(item2.getOtherParams().get("controlSequence").toString()); + }); return result; } + public static void main(String[] args) { - private void to(Map<String, List<FieldSetEntity>> groupMap, List<FieldSetEntity> fieldSetEntity, List<List<FieldSetEntity>> subTableField, List<FaceFieldEntity> result, Map<String, List<FieldSetEntity>> parentMap) { + String textFilePath = "d:\\Desktop\\鏂板缓 鏂囨湰鏂囨。 (2).txt"; + + List<String> lines = FileUtil.readLines(new File(textFilePath), CharsetUtil.defaultCharset()); + for (int i = 0; i < lines.size(); i++) { + //UPDATE `product_db_lift`.`product_sys_datamodel_table` SET `uuid` = '4503ea5c-1e10-40b6-a2b4-79760eea6474', `table_name` = 'product_deivce_failure_level_config', `table_description` = '璁惧鏁呴殰绛夌骇閰嶇疆', `table_primary_key` = NULL, `container_name` = NULL, `table_base_view` = NULL, `view_sql` = NULL, `org_level_uuid` = NULL, `is_international` = NULL, `table_type` = '1', `created_by` = '1', `created_utc_datetime` = '2024-08-09 00:00:00', `updated_by` = '1', `updated_utc_datetime` = '2024-08-09 00:00:00', `produce_msg` = NULL, `sequence` = 2, `view_status` = NULL WHERE `table_id` = 5300; + String line = lines.get(i); + line = line.replaceAll("`", ""); + String start = line.substring(line.indexOf("SET") + 3, line.indexOf("WHERE")); + String[] split = start.split(","); + Map<String, String> map = new HashMap<>(); + for (String s : split) { + String[] split1 = s.split("="); + String value = split1.length == 1 ? null : split1[1].trim(); + if ("null".equalsIgnoreCase(value)) { + value = null; + } + map.put(split1[0].trim(), value); + + } + lines.set(i, lines.get(i).substring(0, lines.get(i).indexOf("WHERE")) + " WHERE `uuid`=" + map.get("uuid") + ";"); + } + FileUtil.writeLines(lines, textFilePath, CharsetUtil.defaultCharset()); + } + + + private void to(Map<String, List<FieldSetEntity>> groupMap, List<FieldSetEntity> fieldSetEntity, Map<String, List<FieldSetEntity>> subTableField, List<FaceFieldEntity> result, Map<String, List<FieldSetEntity>> parentMap) { FieldSetEntity parent = fieldSetEntity.get(0); String groupUuid1 = parent.getString("group_uuid"); if (StringUtils.isEmpty(groupUuid1)) { @@ -357,17 +468,28 @@ for (FieldSetEntity setEntity : parentGroup) { //鎵惧埌灞炴�у悕绉�= __vModel__ String propertyName = setEntity.getString("property_name"); + if ("componentType".equals(propertyName) || "prompt".equals(propertyName)) { + continue; + } if ("parentType".equals(propertyName) && "subTable".equals(setEntity.getString("property_value")) && subTableField != null) { //瀛愯〃瀛楁 - subTableField.add(parentGroup); + String parentUuid = setEntity.getString("parent_uuid"); + List<FieldSetEntity> fieldSetEntities = subTableField.get(parentUuid); + if (fieldSetEntities == null) { + fieldSetEntities = new ArrayList<>(); + subTableField.put(parentUuid, fieldSetEntities); + } + fieldSetEntities.add(setEntity); result.remove(faceFieldEntity); break; } if ("__vModel__".equals(setEntity.getString("property_name"))) { result.add(faceFieldEntity); propertyName = "field"; - } else if ("defaultNow".equals(propertyName)) { - propertyName = "defaultValue"; + } else if ("label".equals(setEntity.getString("property_name"))) { + propertyName = "name"; + } else if ("advanceName".equals(setEntity.getString("property_name"))) { + propertyName = "prompt"; } else if ("__config__".equals(propertyName)) { __config__ = setEntity.getUUID(); } @@ -378,12 +500,11 @@ } } propertyName = StrUtil.toCamelCase(propertyName); - if (ReflectUtil.hasField(FaceFieldEntity.class, propertyName)) { - if ("defaultValue".equals(propertyName)) { - ReflectUtil.setFieldValue(faceFieldEntity, propertyName, setEntity.getBoolean("property_value")); - } else { - ReflectUtil.setFieldValue(faceFieldEntity, propertyName, setEntity.getObject("property_value")); - } + if ("defaultValue".equals(propertyName) && !"0".equals(setEntity.getString("property_value")) && !"1".equals(setEntity.getString("property_value"))) { + continue; + } + if (ReflectUtil.hasField(FaceFieldEntity.class, propertyName) && !"field".equals(setEntity.getString("property_name")) && !"prompt".equals(setEntity.getString("property_name"))) { + ReflectUtil.setFieldValue(faceFieldEntity, propertyName, setEntity.getObject("property_value")); } else if (!StringUtils.isEmpty(setEntity.getObject("property_value"))) { //鍒ゆ柇鏄惁 @@ -417,19 +538,28 @@ for (FieldSetEntity setEntity : configGroup) { //鎵惧埌灞炴�у悕绉�= __vModel__ String propertyName = setEntity.getString("property_name"); + if ("componentType".equals(propertyName) || "prompt".equals(propertyName)) { + continue; + } if ("tag".equals(propertyName)) { propertyName = "component_type"; } else if ("field".equals(propertyName)) { propertyName = "fileField"; } else if ("tableName".equals(propertyName)) { propertyName = "fileTableName"; + } else if ("label".equals(setEntity.getString("property_name"))) { + propertyName = "name"; + } else if ("advanceName".equals(setEntity.getString("property_name"))) { + propertyName = "prompt"; } propertyName = StrUtil.toCamelCase(propertyName); - if (ReflectUtil.hasField(FaceFieldEntity.class, propertyName)) { + if ("defaultValue".equals(propertyName) && !"0".equals(setEntity.getString("property_value")) && !"1".equals(setEntity.getString("property_value"))) { + continue; + } + if (ReflectUtil.hasField(FaceFieldEntity.class, propertyName) && !"field".equals(setEntity.getString("property_name")) && !"prompt".equals(setEntity.getString("property_name"))) { ReflectUtil.setFieldValue(faceFieldEntity, propertyName, setEntity.getObject("property_value")); } } - } } -- Gitblit v1.9.2