表单字段

许鹏程

2024-10-08 10017b649b2e77ef0dc45130c2903f104d1b76d7

 src/main/java/com/product/mobile/core/service/FaceMobileService.java

@@ -1,6 +1,8 @@
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.ReflectUtil;
import cn.hutool.core.util.StrUtil;
import com.alibaba.fastjson.JSON;
@@ -9,6 +11,7 @@
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,9 +22,13 @@
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.*;

/**
@@ -34,15 +41,18 @@

   @Resource
   FlowDetailService flowDetailService;
	

   @Autowired
   public BaseDao baseDao;

   ///获取表单总入口
   /**
    * 
    *
    * @param fse传入表名，或 表UUID
    * @return
    */
   public List<FaceFieldEntity> getFaceConfig(FieldSetEntity fse) {
	

      String tableUuid=fse.getString("table_uuid");
      if (tableUuid==null && StringUtils.isNotEmpty(fse.getString("uuid"))
            && StringUtils.isEmpty(fse.getString("table_name"))) {
@@ -52,7 +62,7 @@
            //获取表名
            fse.setValue("table_name", detailFse.getString("table_name"));
         }
			

      }
      //通过审批任务的uuid来查表单信息
      if (tableUuid==null && StringUtils.isNotEmpty(fse.getString("table_name"))) {
@@ -62,53 +72,50 @@
            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);
		
      if(ls==null)ls=new ArrayList<FaceFieldEntity>();
      addproperty(tableUuid,fse.getString("table_name"),ls);
      //所有表单uuid自动添加，并为hidden
      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)) {///主表字段
               DataTableEntity dt = DataPoolCacheImpl.getInstance().getCacheData("表字段信息"
                     ,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"));
                  }
@@ -122,41 +129,83 @@
                  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();
            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;
         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.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 +218,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 +261,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");
@@ -260,7 +310,7 @@
            continue;
         }

         to(groupMap, fieldSetEntity, subTableField, result,parentMap);
         to(groupMap, fieldSetEntity, subTableField, result, parentMap);
      }
      if (!CollectionUtil.isEmpty(subTableField)) {
         //根据子表表名装载
@@ -342,6 +392,31 @@
      return result;
   }

   public static void main(String[] args) {

      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, List<List<FieldSetEntity>> subTableField, List<FaceFieldEntity> result, Map<String, List<FieldSetEntity>> parentMap) {
@@ -352,7 +427,6 @@
      }
      List<FieldSetEntity> parentGroup = groupMap.get(groupUuid1);
      FaceFieldEntity faceFieldEntity = new FaceFieldEntity();
      boolean parentType = false;
      String __config__ = null;
      List<FieldSetEntity> other = null;
      do {
@@ -368,25 +442,29 @@
            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();
            }
            if (!StringUtils.isAnyEmpty(__config__) ) {
            if (!StringUtils.isAnyEmpty(__config__)) {
               //读取子表属性
               if (parentMap != null) {
                  other = parentMap.get(__config__);
               }
            }
            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 (ReflectUtil.hasField(FaceFieldEntity.class, propertyName) && !"field".equals(setEntity.getString("property_name")) && !"prompt".equals(setEntity.getString("property_name"))) {
               if("prompt".equals(propertyName)){
                  System.out.println(1);
               }
               ReflectUtil.setFieldValue(faceFieldEntity, propertyName, setEntity.getObject("property_value"));

            } else if (!StringUtils.isEmpty(setEntity.getObject("property_value"))) {
               //判断是否
               faceFieldEntity.putOtherParam(propertyName, setEntity.getObject("property_value"));
            }
         }
         if (StringUtils.isEmpty(faceFieldEntity.getField())) {
@@ -422,13 +500,16 @@
            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 (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"));
         }
      }

   }

}