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;
import com.alibaba.fastjson.JSONObject;
import com.drew.metadata.Face;
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;
import com.product.core.service.support.AbstractBaseService;
import com.product.mobile.core.config.MobileCoreCode;
import com.product.mobile.core.config.MobileCoreConst;
import com.product.mobile.core.entity.FaceFieldEntity;
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.*;

/**
 * @Author cheng
 * @Date 2024/8/15 10:21
 * @Desc
 */
@Service
public class FaceMobileService extends AbstractBaseService {

	@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"))) {
			//通过业务表信息查表单信息
			FieldSetEntity detailFse = getBaseDao().getFieldSetEntity(CmnConst.TABLE_FLOW_DETAIL, fse.getString(CmnConst.FIELD_UUID), false);
			if(detailFse!=null) {
				//获取表名
				fse.setValue("table_name", detailFse.getString("table_name"));
			}
			
		}
		//通过审批任务的uuid来查表单信息
		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 && 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.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()) && 
								!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()) && 
								!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()) && 
								!StringUtils.isEmpty(dt.getFieldSetEntity(0).getString("field_show_name"))) {
							ls.get(i).setName(dt.getFieldSetEntity(0).getString("field_show_name"));
						}
					}
					ls.get(i).setTable(table_name);
				}else {
					//============把子表字段也处理一下
					//子表
					FieldSetEntity tableInfo = BaseUtil.getSingleInfoByCache("所有表信息", new String[]{subTableName});
					if (!FieldSetEntity.isEmpty(tableInfo)) {
						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.setHidden("1"); 
				ls.add(uuid);
			}
			
		}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);
				}
			}
			
		}
	}
	/**
	 * 数据库表字段定义转换成表单定义
	 * @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");
		if (StringUtils.isEmpty(tableUuid) && !StringUtils.isEmpty(tableName)) {
			FieldSetEntity tableInfo = BaseUtil.getSingleInfoByCache("所有表信息", new String[]{tableName});
			if (!FieldSetEntity.isEmpty(tableInfo)) {
				tableUuid = tableInfo.getString("uuid");
			}
		}
		if (StringUtils.isEmpty(tableUuid)) {
			throw new BaseException(MobileCoreCode.SYSTEM_FORM_COUNT);
		}
		FieldSetEntity faceFse = getBaseDao().getFieldSetByFilter("product_sys_face", "table_uuid=? and face_type=2", new Object[]{tableUuid}, true);
		faceFse.setTableName(tableName);
		return getFaceField(faceFse);
	}


	public List<FaceFieldEntity> getFlowFaceField(FieldSetEntity fse) throws BaseException {
		String flowBusinessForm = flowDetailService.getFlowBusinessForm(fse);
		JSONObject jsonObject = JSON.parseObject(flowBusinessForm);
		JSONObject data = jsonObject.getJSONObject("data");
		FieldSetEntity faceFse = null;
		if (data != null && !StringUtils.isEmpty(data.getString("face_number"))) {
			if (!StringUtils.isEmpty(data.getString("face_number"))) {
				faceFse = getBaseDao().getFieldSetEntityByFilter("product_sys_face", "face_number=?", new Object[]{data.getString("face_number")}, true);
			}
		} else {
			do {
				//根据流程获取表名
				FieldSetEntity detailFse;
				if (CmnConst.TABLE_FLOW_TASK.equals(fse.getTableName())) {
					detailFse = getBaseDao().getFieldSetEntityByFilter(CmnConst.TABLE_FLOW_DETAIL, "task_uuid=? and source_uuid is null", new Object[]{fse.getUUID()}, false);
				} else {
					detailFse = getBaseDao().getFieldSetEntity(CmnConst.TABLE_FLOW_DETAIL, fse.getString(CmnConst.FIELD_UUID), false);
				}
				if (FieldSetEntity.isEmpty(detailFse)) {
					break;
				}
				//获取表名
				String tableName = detailFse.getString("table_name");
				FieldSetEntity tableInfo = BaseUtil.getSingleInfoByCache("所有表信息", new String[]{tableName});
				if (FieldSetEntity.isEmpty(tableInfo)) {
					break;
				}
				String tableUuid = tableInfo.getString("uuid");
				faceFse = getBaseDao().getFieldSetByFilter("product_sys_face", "table_uuid=?", new Object[]{tableUuid}, true);
			} while (false);

		}
		return getFaceField(faceFse);
	}

	private List<FaceFieldEntity> getFaceField(FieldSetEntity faceFse) {
		if (FieldSetEntity.isEmpty(faceFse) || DataTableEntity.isEmpty(faceFse.getSubDataTable("product_sys_face_control_property"))) {
			return null;
//			throw new BaseException(MobileCoreCode.GET_FACE_CONFIG_FAIL);
		}

		DataTableEntity productSysFaceControlProperty = faceFse.getSubDataTable("product_sys_face_control_property");
		List<FieldSetEntity> tagFieldSetEntityList = new ArrayList<>();
		//根据group_uuid 分组
		Map<String, List<FieldSetEntity>> groupMap = new HashMap<>();
		Map<String, List<FieldSetEntity>> parentMap = new HashMap<>();
		for (FieldSetEntity fieldSetEntity : productSysFaceControlProperty.getData()) {
			String groupUuid = fieldSetEntity.getString("group_uuid");
			String parentUuid = fieldSetEntity.getString("parent_uuid");
			if (!StringUtils.isEmpty(parentUuid)) {
				List<FieldSetEntity> fieldSetEntities = parentMap.get(parentUuid);
				if (fieldSetEntities == null) {
					fieldSetEntities = new ArrayList<>();
					parentMap.put(parentUuid, fieldSetEntities);
				}
				fieldSetEntities.add(fieldSetEntity);
			}
			if ("tag".equals(fieldSetEntity.getString("property_name"))) {
				tagFieldSetEntityList.add(fieldSetEntity);
			}
			if (StringUtils.isEmpty(groupUuid)) {
				continue;
			}
			if (!groupMap.containsKey(groupUuid)) {
				groupMap.put(groupUuid, new ArrayList<>());
			}
			groupMap.get(groupUuid).add(fieldSetEntity);
		}

		if (CollectionUtil.isEmpty(groupMap)) {
			throw new BaseException(MobileCoreCode.GET_FACE_CONFIG_FAIL);
		}

		List<FaceFieldEntity> result = new ArrayList<>();
		List<List<FieldSetEntity>> subTableField = new ArrayList<>();
		for (FieldSetEntity fs : tagFieldSetEntityList) {
			String groupUuid = fs.getString("group_uuid");
			String parentUuid = fs.getString("parent_uuid");
			if (StringUtils.isEmpty(groupUuid) || StringUtils.isEmpty(parentUuid)) {
				continue;
			}
			List<FieldSetEntity> fieldSetEntity = productSysFaceControlProperty.getFieldSetEntity(parentUuid);
			if (CollectionUtil.isEmpty(fieldSetEntity)) {
				continue;
			}

			to(groupMap, fieldSetEntity, subTableField, result, parentMap);
		}
		if (!CollectionUtil.isEmpty(subTableField)) {
			//根据子表表名装载
			Map<String, FaceFieldEntity> tableByFaceField = new HashMap<>();
			for (List<FieldSetEntity> fieldSetEntities : subTableField) {
				String parentUuid = fieldSetEntities.get(0).getString("parent_uuid");
				//先找到children
				List<FieldSetEntity> fieldSetEntity = productSysFaceControlProperty.getFieldSetEntity(parentUuid);
				if (CollectionUtil.isEmpty(fieldSetEntities)) {
					continue;
				}
				//找到了children
				FieldSetEntity fieldSetEntity1 = fieldSetEntity.get(0);
				String p = fieldSetEntity1.getString("parent_uuid");
				String cGroupUuid = fieldSetEntity1.getString("group_uuid");
				if (StringUtils.isEmpty(p) || StringUtils.isEmpty(cGroupUuid)) {
					continue;
				}
				List<FieldSetEntity> childrenGroup = groupMap.get(cGroupUuid);
				List<FieldSetEntity> fieldSetEntity2 = productSysFaceControlProperty.getFieldSetEntity(p);
				if (CollectionUtil.isEmpty(fieldSetEntity2) || CollectionUtil.isEmpty(childrenGroup)) {
					continue;
				}
				//找到了 __config__
				FieldSetEntity fieldSetEntity3 = fieldSetEntity2.get(0);
				String groupUuid = fieldSetEntity3.getString("group_uuid");
				if (StringUtils.isEmpty(groupUuid)) {
					continue;
				}
				String uuid = fieldSetEntity3.getUUID();

				FaceFieldEntity faceFieldEntity = tableByFaceField.get(uuid);
				if (faceFieldEntity == null) {
					faceFieldEntity = new FaceFieldEntity();
				}
				faceFieldEntity.setComponentType("subTable");
				boolean isSub = CollectionUtil.isNotEmpty(faceFieldEntity.getSubField());
				if (!isSub) {
					for (FieldSetEntity setEntity : childrenGroup) {
						String propertyName = setEntity.getString("property_name");
						if ("tag".equals(propertyName) && "lx-form-sub-table".equals(setEntity.getString("property_value"))) {
							isSub = true;
							break;
						}
					}
				}
				if (!isSub) {
					//不是子表组件
					continue;
				}
				for (FieldSetEntity setEntity : groupMap.get(groupUuid)) {
					String propertyName = setEntity.getString("property_name");
					if ("subTableName".equals(propertyName)) {
						faceFieldEntity.setSubTableName(setEntity.getString("property_value"));
						tableByFaceField.put(faceFieldEntity.getSubTableName(), faceFieldEntity);
					} else if ("add".equals(propertyName)) {
						faceFieldEntity.setAllowAdd(setEntity.getBoolean("property_value"));
					} else if ("delete".equals(propertyName)) {
						faceFieldEntity.setAllowDelete(setEntity.getBoolean("property_value"));
					}
				}
				List<FaceFieldEntity> subFieldList = faceFieldEntity.getSubField();
				if (CollectionUtil.isEmpty(subFieldList)) {
					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;

			}
		}
		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) {
		FieldSetEntity parent = fieldSetEntity.get(0);
		String groupUuid1 = parent.getString("group_uuid");
		if (StringUtils.isEmpty(groupUuid1)) {
			return;
		}
		List<FieldSetEntity> parentGroup = groupMap.get(groupUuid1);
		FaceFieldEntity faceFieldEntity = new FaceFieldEntity();
		String __config__ = null;
		List<FieldSetEntity> other = null;
		do {
			for (FieldSetEntity setEntity : parentGroup) {
				//找到属性名称= __vModel__
				String propertyName = setEntity.getString("property_name");
				if ("parentType".equals(propertyName) && "subTable".equals(setEntity.getString("property_value")) && subTableField != null) {
					//子表字段
					subTableField.add(parentGroup);
					result.remove(faceFieldEntity);
					break;
				}
				if ("__vModel__".equals(setEntity.getString("property_name"))) {
					result.add(faceFieldEntity);
					propertyName = "field";
				} else if ("label".equals(setEntity.getString("property_name"))) {
					propertyName = "name";
				} else if ("advanceName".equals(setEntity.getString("property_name"))) {
					propertyName = "field";
				} else if ("__config__".equals(propertyName)) {
					__config__ = setEntity.getUUID();
				}
				if (!StringUtils.isAnyEmpty(__config__)) {
					//读取子表属性
					if (parentMap != null) {
						other = parentMap.get(__config__);
					}
				}
				propertyName = StrUtil.toCamelCase(propertyName);
				if (ReflectUtil.hasField(FaceFieldEntity.class, propertyName)) {
					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())) {
				return;
			}
			if (parentGroup == other) {
				break;
			}
			if (other != null) {
				parentGroup = other;
				parentMap = null;
			}
		} while (other != null);
		Set<FieldSetEntity> configGroup = Sets.newHashSet(groupMap.get(fieldSetEntity.get(0).getString("group_uuid")));
		if (other != null) {
			if (configGroup == null) {
				configGroup = Sets.newHashSet(other);
			} else {
				configGroup.addAll(other);
			}
		}
		parentGroup = groupMap.get(groupUuid1);
		if (configGroup != null && parentGroup != null) {
			configGroup.addAll(parentGroup);
		}

		for (FieldSetEntity setEntity : configGroup) {
			//找到属性名称= __vModel__
			String propertyName = setEntity.getString("property_name");
			if ("tag".equals(propertyName)) {
				propertyName = "component_type";
			} else if ("field".equals(propertyName)) {
				propertyName = "fileField";
			} else if ("tableName".equals(propertyName)) {
				propertyName = "fileTableName";
			}
			propertyName = StrUtil.toCamelCase(propertyName);
			if (ReflectUtil.hasField(FaceFieldEntity.class, propertyName)) {
				ReflectUtil.setFieldValue(faceFieldEntity, propertyName, setEntity.getObject("property_value"));
			}
		}
	}

}