package com.vci.server.base.utility;

import org.apache.commons.lang3.StringUtils;

import com.vci.corba.omd.atm.AttribItem;

public final class OmdHelper {
	
	// 业务类型系统属性
	private static AttribItem[] _btSysAttributes = null;
	// 链接类型系统属性
	private static AttribItem[] _ltSysAttrItems = null;

	private static String[] _btSysANames = {"OID","REVISIONOID","NAMEOID","BTMNAME",
			"ISLastR","ISFirstR","ISLastV","ISFirstV",
			"Creator","CreateTime",
			"LastModifier","LastModifyTime","RevisionRule","VersionRule","RevisionSeq",
			"RevisionValue","VersionSeq","VersionValue","LCTID","LCStatus","TS",
			"ID", "NAME", "DESCRIPTION", "OWNER", "CHECKINBY", "CHECKINTIME", 
			"CHECKOUTBY", "CHECKOUTTIME", "COPYFROMVERSION"};

	private static String[] _ltSysAttibutes = {"OID","Creator","CreateTime","LastModifier","LASTMODIFYTIME","F_OID","F_REVISIONOID","F_NAMEOID","F_BtwName",
			"T_OID","T_REVISIONOID","T_NAMEOID","T_BtwName","TS"};
	

	/**
	 * 业务table名的前缀
	 */
	private static final String PLATFORMBTM_ = "PLATFORMBTM_";
	/**
	 * 链接类型table名的前缀
	 */
	private static final String PLATFORMLT_ = "PLATFORMLT_";
	
	private static final String _TV = "_TV";
	private static final String _FV = "_FV";
	private static final String _V = "_V";
	
	/**
	 * 表名最大长度
	 */
	private static final int TABLEMAXLENTGH = 30;

	/**
	 * 获取链接类型名的最大长度:
	 * 30(oracle中table名的最大长度) - PLATFORMLT_.length()
	 * @return
	 */
	public static int getLTNameMaxLength() {
		// TODO Auto-generated method stub
		return TABLEMAXLENTGH - PLATFORMLT_.length();
	}

	/**
	 * 获取业务名的最大长度:
	 * 30(oracle中table名的最大长度) - PLATFORMBTM_.length()
	 * @return
	 */
	public static int getBTNameMaxLength() {
		// TODO Auto-generated method stub
		return TABLEMAXLENTGH - PLATFORMBTM_.length();
	}
	
	
	/**
	 * 由业务类型名获取该业务类型的table名
	 * @param btmName
	 * @return
	 */
	public static String getBTTableName(String btmName){
		if(btmName == null || btmName.equals("")){
			return "";
		}
		return PLATFORMBTM_ + btmName.toUpperCase();
	}

	/**
	 * 由链接类型名获取该业务类型的table名
	 * @param ltName
	 * @return
	 */
	public static String getLTTableName(String ltName){
		if(ltName == null || ltName.equals("")){
			return "";
		}
		return PLATFORMLT_ + ltName.toUpperCase();
	}
	
	/**
	 * 获取索引名称
	 * @param ltName
	 * @return
	 */
	public static String getIndexName(String typeName, String name){
		if(StringUtils.isBlank(name) || StringUtils.isBlank(typeName)){
			return "";
		}
		
		return String.format("PI_%s_%s", typeName.toUpperCase(), name.toUpperCase());
	}
	
	/**
	 * 获取链接类型TO端业务类型视图名
	 * @param ltName
	 * @return
	 */
	public static String getToViewName(String ltName){
		return ltName + _TV;
	}
	
	/**
	 * 获取链接类型From端业务类型视图名
	 * @param ltName
	 * @return
	 */
	public static String getFromViewName(String ltName){
		return ltName + _FV;
	}
	
	/**
	 * 获取业务类型视图名
	 * @param ltName
	 * @return
	 */
	public static String getBtViewName(String btName){
		return btName + _V;
	}
	

	/**
	 * 获取系统属性
	 * @return
	 */
	public static String[] getBTSysANames() {
		return _btSysANames;
	}
	
	public static AttribItem[] getBTSysAttribItems() {
		if (_btSysAttributes == null) {
			int count = _btSysANames.length;
			_btSysAttributes  = new AttribItem[count];
			for (int i = 0; i < count; i++) {
				AttribItem attr = new AttribItem();
				_btSysAttributes[i] = attr;
				attr.name = _btSysANames[i].toLowerCase();
				attr.vtDataType = getSysAttribDataType(attr.name);
				attr.label = getSysAttribLabel(attr.name);
			}
		}
		return _btSysAttributes;
	}
	
	
	private static String getSysAttribLabel(String name) {
		
		String field = name.toUpperCase();
		if (field.equals("OID")) {
			return "版次对象ID";
		} else if (field.equals("REVISIONOID")) {
			return "版本对象ID";
		} else if (field.equals("NAMEOID")) {
			return "对象ID";
		} else if (field.equals("BTMNAME")) {
			return "对象类型";
		} else if (field.equals("ISLASTR")) {
			return "是否最新版本";
		} else if (field.equals("ISFIRSTR")) {
			return "是否第一版本";
		} else if (field.equals("ISLASTV")) {
			return "是否最新版次";
		} else if (field.equals("ISFIRSTV")) {
			return "是否第一版次";
		} else if (field.equals("CREATOR")) {
			return "创建时间";
		} else if (field.equals("CREATETIME")) {
			return "创建时间";
		} else if (field.equals("LASTMODIFIER")) {
			return "修改人";
		} else if (field.equals("LASTMODIFYTIME")) {
			return "修改时间";
		} else if (field.equals("REVISIONRULE")) {
			return "版本规则";
		} else if (field.equals("VERSIONRULE")) {
			return "版次规则";
		} else if (field.equals("REVISIONSEQ")) {
			return "版本序号";
		} else if (field.equals("REVISIONVALUE")) {
			return "版本";
		} else if (field.equals("VERSIONSEQ")) {
			return "版次序号";
		} else if (field.equals("VERSIONVALUE")) {
			return "版次";
		} else if (field.equals("LCTID")) {
			return "生命周期模型";
		} else if (field.equals("LCStatus")) {
			return "状态";
		} else if (field.equals("TS")) {
			return "时间戳";
		} else if (field.equals("ID")) {
			return "编码";
		} else if (field.equals("NAME")) {
			return "名称";
		} else if (field.equals("DESCRIPTION")) {
			return "描述";
		} else if (field.equals("OWNER")) {
			return "所有者";
		} else if (field.equals("CHECKINBY")) {
			return "检入人";
		} else if (field.equals("CHECKINTIME")) {
			return "检入时间";
		} else if (field.equals("CHECKOUTBY")) {
			return "检出人";
		} else if (field.equals("CHECKOUTTIME")) {
			return "检出时间";
		} else if (field.equals("COPYFROMVERSION")) {
			return "源版本";
		} else if (field.equals("F_OID")) {
			return "F端对象版次ID";
		} else if (field.equals("F_REVISIONOID")) {
			return "F端对象版本ID";
		} else if (field.equals("F_NAMEOID")) {
			return "F端对象ID";
		} else if (field.equals("F_BTWNAME")) {
			return "F端对象类型";
		} else if (field.equals("T_OID")) {
			return "T对象版次ID";
		} else if (field.equals("T_REVISIONOID")) {
			return "T对象版本ID";
		} else if (field.equals("T_NAMEOID")) {
			return "T端对象ID";
		} else if (field.equals("T_BTWNAME")) {
			return "T端对象类型";
		}
		
		return "";
	}
	
	
	public static String[] getLTSysAbItems(){
		return _ltSysAttibutes;
	}
	
	
	public static AttribItem[] getLTSysAttribItems() {
		if (_ltSysAttrItems == null) {
			int count = _ltSysAttibutes.length;
			_ltSysAttrItems  = new AttribItem[count];
			for (int i = 0; i < count; i++) {
				AttribItem attr = new AttribItem();
				_ltSysAttrItems[i] = attr;
				attr.name = _ltSysAttibutes[i].toLowerCase();
				attr.vtDataType = getSysAttribDataType(attr.name);
				attr.label = getLTSysAttribItemLabel(attr.name);
			}
		}
		return _ltSysAttrItems;
	}
	

	
	private static String getLTSysAttribItemLabel(String name) {
		
		String field = name.toUpperCase();
		if (field.equals("OID")) {
			return "链接对象ID";
		} else if (field.equals("CREATOR")) {
			return "创建时间";
		} else if (field.equals("CREATETIME")) {
			return "创建时间";
		} else if (field.equals("LASTMODIFIER")) {
			return "修改人";
		} else if (field.equals("LASTMODIFYTIME")) {
			return "修改时间";
		} else if (field.equals("F_OID")) {
			return "F端对象版次ID";
		} else if (field.equals("F_REVISIONOID")) {
			return "F端对象版本ID";
		} else if (field.equals("F_NAMEOID")) {
			return "F端对象ID";
		} else if (field.equals("F_BTWNAME")) {
			return "F端对象类型";
		} else if (field.equals("T_OID")) {
			return "T对象版次ID";
		} else if (field.equals("T_REVISIONOID")) {
			return "T对象版本ID";
		} else if (field.equals("T_NAMEOID")) {
			return "T端对象ID";
		} else if (field.equals("T_BTWNAME")) {
			return "T端对象类型";
		} else if (field.equals("TS")) {
			return "时间戳";
		}
		
		return "";
	}
	
	/**
	 * 获取属性的数据类型, 属性: 系统属性, 属性池属性
	 * @param abUpperName
	 * @return"ISLastR","ISFirstR","ISLastV","ISFirstV",
	 */
	public static String getSysAttribDataType(String abName){
		String dataType = null;
		String abUpperName = abName.toUpperCase();
		//系统属性
		if(abUpperName.equals("OID") || abUpperName.equals("REVISIONOID") || abUpperName.equals("NAMEOID") || abUpperName.equals("BTMNAME")
				|| abUpperName.equals("CREATOR") || abUpperName.equals("LASTMODIFIER") || abUpperName.equals("REVISIONRULE")
				|| abUpperName.equals("VERSIONRULE") || abUpperName.equals("REVISIONVALUE") || abUpperName.equals("VERSIONVALUE")
				|| abUpperName.equals("LCTID") || abUpperName.equals("LCSTATUS")
				|| abUpperName.equals("ID") || abUpperName.equals("NAME") || abUpperName.equals("DESCRIPTION") 
				|| abUpperName.equals("OWNER") || abUpperName.equals("CHECKINBY") 
				|| abUpperName.equals("CHECKOUTBY") || abUpperName.equals("COPYFROMVERSION")
				|| abUpperName.equals("ISLASTR") || abUpperName.equals("ISFIRSTR")
				|| abUpperName.equals("ISLASTV") || abUpperName.equals("ISFIRSTV")
				|| abUpperName.equals("F_OID") || abUpperName.equals("F_REVISIONOID") 
				|| abUpperName.equals("F_NAMEOID") || abUpperName.equals("F_BTWNAME")
				|| abUpperName.equals("T_OID") || abUpperName.equals("T_REVISIONOID") 
				|| abUpperName.equals("T_NAMEOID") || abUpperName.equals("T_BTWNAME")){
			dataType = "VTString";
		}else if(abUpperName.equals("REVISIONSEQ") || abUpperName.equals("VERSIONSEQ")){
			dataType = "VTInteger";
		}else if(abUpperName.equals("CREATETIME") || abUpperName.equals("LASTMODIFYTIME")
				|| abUpperName.equals("TS") || abUpperName.equals("CHECKINTIME") || abUpperName.equals("CHECKOUTTIME")){
			dataType = "VTDateTime";
		}
		return dataType;
	}
}