package com.vci.client.portal.platformPortal;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.swing.JFileChooser;
import javax.swing.filechooser.FileFilter;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.vci.client.LogonApplication;
import com.vci.client.common.providers.ServiceProvider;
import com.vci.client.omd.btm.wrapper.BtmItemWrapper;
import com.vci.client.omd.linktype.LinkTypeWrapper;
import com.vci.client.omd.provider.ApProvider;
import com.vci.client.omd.provider.BtmProvider;
import com.vci.client.omd.provider.LinkTypeProvider;
import com.vci.client.oq.QTClient;
import com.vci.client.oq.QTDClient;
import com.vci.client.portal.NewUI.MessageDialog;
import com.vci.client.portal.utility.PRM;
import com.vci.client.portal.utility.PRMItem;
import com.vci.client.portal.utility.UITools;
import com.vci.client.ui.swing.VCIOptionPane;
import com.vci.common.utility.ObjectUtility;
import com.vci.corba.common.VCIError;
import com.vci.corba.omd.atm.AttribItem;
import com.vci.corba.omd.ltm.LinkType;
import com.vci.corba.omd.qtm.QTInfo;
import com.vci.corba.portal.data.PortalVI;

public class ImportExcel {

	private Object selectTreeNodeobject;
	public ImportExcel(Object selectTreeNodeobject){
		this.selectTreeNodeobject = selectTreeNodeobject;
	}

	public boolean impExcel() {
		JFileChooser jf = new JFileChooser();
		jf.setDialogTitle("打开");
		jf.removeChoosableFileFilter(jf.getFileFilter());
		jf.setFileFilter(new FileFilter() {

			@Override
			public String getDescription() {
				return "xls";
			}

			@Override
			public boolean accept(File f) {
				if (f.isDirectory() || f.getName().endsWith(".xls")) {
					return true;
				} else {
					return false;
				}
			}
		});
		int showOpenDialog = jf.showOpenDialog(LogonApplication.frame);
		String xfileName = "";
		String filePath = "";
		if (showOpenDialog == JFileChooser.APPROVE_OPTION) {
			File file = jf.getSelectedFile();
			xfileName = file.getAbsolutePath();
			filePath = file.getAbsolutePath();
			if (!xfileName.endsWith(".xls")) {
				xfileName = xfileName + ".xls";
			}
		}
		try {
			//存储form名称和oid
			Map<String,String> formNameMap = new HashMap<String,String>();
			FileInputStream fin = new FileInputStream(xfileName);
			PortalVI[] portalViInfos = null;
			try {
				HSSFWorkbook readworkbook = new HSSFWorkbook(fin);
				HSSFSheet readbtmnamesheet = readworkbook.getSheet("btmName");
				HSSFSheet readsheet = readworkbook.getSheet("portalvi");
				HSSFSheet qtdsheet = readworkbook.getSheet("QTD");
				List<PortalVI> portalVIList = new ArrayList<PortalVI>();
				StringBuffer checkPortalVI = new StringBuffer();
				StringBuffer checkAttr = new StringBuffer();
				StringBuffer checkInObj = new StringBuffer();
				String btmName = "";
				if (!(selectTreeNodeobject instanceof String)) {
					if (selectTreeNodeobject instanceof BtmItemWrapper) {
						btmName = ((BtmItemWrapper) selectTreeNodeobject).btmItem.name;
					} else if (selectTreeNodeobject instanceof LinkTypeWrapper) {
						btmName = ((LinkTypeWrapper) selectTreeNodeobject).linkType.name;
					}
					for (int i = 0; i <= readsheet.getLastRowNum(); i++) {
						String ploid = ObjectUtility.getNewObjectID36();
						PortalVI p = new PortalVI();
						HSSFRow readrow = readsheet.getRow(i);
						if (readrow == null) {
							break;
						}
						// HSSFCell readcell = readrow.getCell(0);
						p.id = ploid;
						HSSFCell readcell = readrow.getCell(0);
						p.typeName = readcell.getStringCellValue();
						if (!btmName.equals(p.typeName)) {
							VCIOptionPane.showMessage(LogonApplication.frame,
									"请选择要导入的类型节点名称！");
							return false;
						}
						readcell = readrow.getCell(1);
						p.viName = readcell.getStringCellValue();
						
						formNameMap.put(p.typeName + ":" + p.viName,ploid);
						
						readcell = readrow.getCell(2);
						p.viType = (short) readcell.getNumericCellValue();
						readcell = readrow.getCell(3);
						p.typeFlag = (short) readcell.getNumericCellValue();
						readcell = readrow.getCell(4);
						String prmStr = readcell.getStringCellValue();
						FileInputStream prmFile = new FileInputStream(filePath
								+ "." + prmStr);
						BufferedReader br = new BufferedReader(
								new InputStreamReader(prmFile, "UTF-8")); // "UTF-8"
						StringBuilder sb = new StringBuilder();
						String prmStrContent;
						while ((prmStrContent = br.readLine()) != null) {
							sb.append(prmStrContent).append("\r\n");
						}
						prmStr = sb.toString();
						if (p.viType == 0) {
							PRM prmObj = UITools.getPRM(prmStr);
							List<PRMItem> prmItemList = prmObj.getPrmItemList();
							for (int j = 0; j < prmItemList.size(); j++) {
								PRMItem pit = prmItemList.get(j);
								PortalVI[] pvs = new PortalVI[0];
								try {
									pvs = UITools.getService()
											.getPortalVIArrayByTypeName(
													p.typeName);
									if(pvs != null && pvs.length>0){
										for (PortalVI pv : pvs) {
											if (pit.getItemInObj().equals(
													p.typeName + ":" + pv.viName)) {
												pit.setItemInObj(pv.id);
											}
										}
									}else{
										if(formNameMap.get(pit.getItemInObj())==null){
											if(!checkInObj.toString().contains(pit.getItemInObj())){
												String[] split = pit.getItemInObj().split(":");
												checkInObj.append(split[1]).append(",");
											}
										}else{
											pit.setItemInObj(formNameMap.get(pit.getItemInObj()));
										}
									}
								} catch (VCIError e) {
									e.printStackTrace();
								}
							}
							try {
								prmStr = UITools.getPRMText(prmObj);
							} catch (Throwable e1) {
								e1.printStackTrace();
							}
						}
						p.prm = prmStr.trim();
						String btmname = "";
						AttribItem[] btAbItems = null;
						if (p.typeFlag == 0) {
							btmname = p.typeName;
							btAbItems = BtmProvider.getInstance().getBtAbItems(
									btmname);
						} else if (p.typeFlag == 1) {
							try {
								LinkType linkType = LinkTypeProvider.getInstance().getLinkTypeByName(p.typeName);
								btmname = linkType.name;
								btAbItems = ApProvider.getInstance().getAttribItemsByNames(LinkTypeProvider.getInstance().getAbNames(linkType));
							} catch (Exception e) {
								e.printStackTrace();
							} catch (Throwable e) {
								e.printStackTrace();
							}
						}
						readcell = readrow.getCell(5);
						String attrValue = readcell.getStringCellValue();
						String[] split = attrValue.split(",");
						for (String name : split) {
							boolean flag = false;
							for (AttribItem ait : btAbItems) {
								if (ait.name.equals(name)) {
									flag = true;
									break;
								}
							}
							if (!flag && !checkAttr.toString().contains(name)) {
								checkAttr.append(name).append(",");
							}
						}
						portalViInfos = UITools.getService()
								.getPortalVIArrayByTypeName(btmname);
						for (PortalVI pvi : portalViInfos) {
							if (pvi.viName.equals(p.viName)) {
								checkPortalVI.append(pvi.viName).append(",");
							}
						}
						portalVIList.add(p);

						QTInfo qt = new QTInfo();
						readcell = readrow.getCell(6);
						if (readcell != null && !"".equals(readcell.toString())) {				//readcell-->readcell.tostring  //by zgy 2015-06-11
							String qtName = readcell.getStringCellValue();
							qt.qtName = qtName;
							readcell = readrow.getCell(7);
							String qtText = readcell.getStringCellValue();
							FileInputStream qtprmFile = new FileInputStream(
									filePath + "." + qtText);
							BufferedReader qtbr = new BufferedReader(
									new InputStreamReader(qtprmFile, "UTF-8")); // "UTF-8"
							StringBuilder qtsb = new StringBuilder();
							String qtStrContent;
							while ((qtStrContent = qtbr.readLine()) != null) {
								qtsb.append(qtStrContent).append("\r\n");
							}
							qtText = qtsb.toString();
							qt.qtText = qtText;
							readcell = readrow.getCell(8);
							String qtBtmName = readcell.getStringCellValue();
							qt.btmName = qtBtmName;
							QTInfo qt2 = ServiceProvider.getOMDService().getQTDService().getQT(
									qt.qtName);
							if (qt2 == null) {
								ServiceProvider.getOMDService().getQTDService().saveQT(qt);
							}
						}
					}
				} else {
					for (int btmNamei = 0; btmNamei <= readbtmnamesheet
							.getLastRowNum(); btmNamei++) {
						HSSFRow btmNameReadrow = readbtmnamesheet
								.getRow(btmNamei);
						HSSFCell btmNameReadcell = btmNameReadrow.getCell(0);
						btmName = btmNameReadcell.getStringCellValue();
						if (btmNameReadrow == null) {
							break;
						}
						for (int i = 0; i <= readsheet.getLastRowNum(); i++) {
							String ploid = ObjectUtility.getNewObjectID36();
							PortalVI p = new PortalVI();
							HSSFRow readrow = readsheet.getRow(i);
							if (readrow == null) {
								break;
							}
							// HSSFCell readcell = readrow.getCell(0);
							p.id = ploid;
							HSSFCell readcell = readrow.getCell(0);
							p.typeName = readcell.getStringCellValue();
							// if(!btmName.equals(p.typeName)){
							// VCIOptionPane.showMessage(LogonApplication.frame,
							// "请选择要导入的类型节点名称！");
							// return false;
							// }
							if (btmName.equals(p.typeName)) {
								readcell = readrow.getCell(1);
								p.viName = readcell.getStringCellValue();
								
								formNameMap.put(p.typeName + ":" + p.viName,ploid);
								
								readcell = readrow.getCell(2);
								p.viType = (short) readcell.getNumericCellValue();
								readcell = readrow.getCell(3);
								p.typeFlag = (short) readcell.getNumericCellValue();
								readcell = readrow.getCell(4);
								String prmStr = readcell.getStringCellValue();
								FileInputStream prmFile = new FileInputStream(
										filePath + "." + prmStr);
								BufferedReader br = new BufferedReader(
										new InputStreamReader(prmFile, "UTF-8"));
								StringBuilder sb = new StringBuilder();
								String prmStrContent;
								while ((prmStrContent = br.readLine()) != null) {
									sb.append(prmStrContent).append("\r\n");
								}
								prmStr = sb.toString();
								if (p.viType == 0) {
									PRM prmObj = UITools.getPRM(prmStr);
									List<PRMItem> prmItemList = prmObj
											.getPrmItemList();
									for (int j = 0; j < prmItemList.size(); j++) {
										PRMItem pit = prmItemList.get(j);
										PortalVI[] pvs = new PortalVI[0];
										try {
											pvs = UITools
													.getService()
													.getPortalVIArrayByTypeName(
															p.typeName);
											
											if(pvs != null && pvs.length>0){
												for (PortalVI pv : pvs) {
													if (pit.getItemInObj().equals(
															p.typeName + ":" + pv.viName)) {
														pit.setItemInObj(pv.id);
													}
												}
											}else{
												pit.setItemInObj(formNameMap.get(pit.getItemInObj()));
											}
											
										} catch (VCIError e) {
											e.printStackTrace();
										}
									}
									try {
										prmStr = UITools.getPRMText(prmObj);
									} catch (Throwable e1) {
										e1.printStackTrace();
									}
								}
								p.prm = prmStr.trim();
								String btmname = "";
								AttribItem[] btAbItems = null;
								if (p.typeFlag == 0) {
									btmname = p.typeName;
									btAbItems = BtmProvider.getInstance()
											.getBtAbItems(btmname);
								} else if (p.typeFlag == 1) {
									try {
										LinkType linkType = LinkTypeProvider.getInstance().getLinkTypeByName(p.typeName);
										btmname = linkType.name;
										btAbItems = ApProvider.getInstance().getAttribItemsByNames(LinkTypeProvider.getInstance().getAbNames(linkType));
									} catch (Exception e) {
										e.printStackTrace();
									} catch (Throwable e) {
										e.printStackTrace();
									}
								}
								readcell = readrow.getCell(5);
								String attrValue = readcell
										.getStringCellValue();
								String[] split = attrValue.split(",");
								for (String name : split) {
									boolean flag = false;
									for (AttribItem ait : btAbItems) {
										if (ait.name.equals(name)) {
											flag = true;
											break;
										}
									}
									if (!checkAttr.toString().contains(btmname)) {
										checkAttr.append("\n\t" + btmname)
												.append(":");
									}
									if (!flag
											&& !checkAttr.toString().contains(
													name)) {
										checkAttr.append(name).append(",");
									}
								}
								portalViInfos = UITools.getService()
										.getPortalVIArrayByTypeName(btmname);
								for (PortalVI pvi : portalViInfos) {
									if (!checkPortalVI.toString().contains(
											btmname)) {
										checkPortalVI.append("\n\t" + btmname)
												.append(":");
									}
									if (pvi.viName.equals(p.viName)) {
										checkPortalVI.append(pvi.viName)
												.append(",");
									}
								}
								portalVIList.add(p);

								QTInfo qt = new QTInfo();
								readcell = readrow.getCell(6);
								if (readcell != null && !"".equals(readcell)) {
									String qtName = readcell
											.getStringCellValue();
									qt.qtName = qtName;
									readcell = readrow.getCell(7);
									String qtText = readcell
											.getStringCellValue();
									FileInputStream qtprmFile = new FileInputStream(
											filePath + "." + qtText);
									BufferedReader qtbr = new BufferedReader(
											new InputStreamReader(qtprmFile,
													"UTF-8")); // "UTF-8"
									StringBuilder qtsb = new StringBuilder();
									String qtStrContent;
									while ((qtStrContent = qtbr.readLine()) != null) {
										qtsb.append(qtStrContent)
												.append("\r\n");
									}
									qtText = qtsb.toString();
									qt.qtText = qtText;
									readcell = readrow.getCell(8);
									String qtBtmName = readcell
											.getStringCellValue();
									qt.btmName = qtBtmName;
									QTInfo qt2 = ServiceProvider.getOMDService().getQTDService()
											.getQT(qt.qtName);
									if (qt2 == null) {
										ServiceProvider.getOMDService().getQTDService().saveQT(qt);
									}
								}
							}
						}
					}
				}
				/*
				 * for(int
				 * qtdindex=0;qtdindex<=qtdsheet.getLastRowNum();qtdindex++){
				 * QTD qtd = new QTD(); HSSFRow readrow =
				 * qtdsheet.getRow(qtdindex); if(readrow==null){ break; }
				 * HSSFCell cell = readrow.getCell(0); qtd.btmName =
				 * cell.getStringCellValue(); cell = readrow.getCell(1);
				 * qtd.linkTypeName = cell.getStringCellValue(); cell =
				 * readrow.getCell(2); qtd.name = cell.getStringCellValue();
				 * cell = readrow.getCell(3); String attrValue =
				 * cell.getStringCellValue(); String[] split =
				 * attrValue.split(","); qtd.abNames = split; QTD qtdByName =
				 * ServiceProvider.getOMDService().getQTDService().getQTDByName(qtd.name);
				 * if(qtdByName==null){ ServiceProvider.getOMDService().getQTDService().addQTD(qtd); } }
				 */
				if (checkPortalVI.length() > 0) {
					// VCIOptionPane.showMessage(LogonApplication.frame,
					// checkPortalVI.toString()+"名称已经存在！");
					MessageDialog msgdia = new MessageDialog(
							checkPortalVI.toString() + "名称已经存在！");
					return false;
				}
				if (checkInObj.length() > 0) {
					MessageDialog msgdia = new MessageDialog(
							checkInObj.toString() + "表单不存在！");
					return false;
				}
				if (checkAttr.length() > 0) {
					// VCIOptionPane.showMessage(LogonApplication.frame,
					// checkAttr.toString()+"属性不存在！");
					MessageDialog msgdia = new MessageDialog(
							checkAttr.toString() + "属性不存在！");
					return false;
				}
				// save portalVi
				for (PortalVI pvi : portalVIList) {
					UITools.getService().savePortalVI(pvi);
					System.out.println("");
				}
				return true;
			} catch (IOException e) {
				e.printStackTrace();
				return false;
			} catch (VCIError e) {
				e.printStackTrace();
				return false;
			}
		} catch (FileNotFoundException e) {
			e.printStackTrace();
			return false;
		}
	}
}