package com.vci.client.portal.UI;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
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.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.btm.BtmItem;
import com.vci.corba.portal.data.PLAction;
import com.vci.corba.portal.data.PLCommandParameter;
import com.vci.corba.portal.data.PLPageDefination;
import com.vci.corba.portal.data.PLUILayout;
import com.vci.corba.portal.data.PLTabButton;
import com.vci.corba.portal.data.PLTabPage;

public class ImportExcel {

	private BtmItem selectTreeNodeobject;
	private String plpageLayoutDefinationId = "";
	private String plPageContextOId = "";
	private String plTableOId = "";
	private String plCommandOId = "";
	HSSFWorkbook readworkbook;
	public ImportExcel(BtmItem 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 = "";
		if (showOpenDialog == JFileChooser.APPROVE_OPTION) {
			File file = jf.getSelectedFile();
			xfileName = file.getAbsolutePath();
			if(!xfileName.endsWith(".xls")){
				xfileName = xfileName+".xls";
			}
		}
		try {
			FileInputStream fin = new FileInputStream(xfileName);
			PLUILayout[] plpagelayoutdefinations = null;
			try {
				readworkbook = new HSSFWorkbook(fin);
				HSSFSheet plpagelayoutdefnationsheet = readworkbook.getSheet("PlpageLayoutDefnation");
				HSSFSheet pltabpagesheet = readworkbook.getSheet("Pltabpage");
				HSSFSheet plpagedefinationsheet = readworkbook.getSheet("Plpagedefination");
				HSSFSheet pltabbuttonsheet = readworkbook.getSheet("Pltabbutton");
				HSSFSheet plcommondparamsheet = readworkbook.getSheet("PlcommondParam");
				
				Map<PLUILayout,List<PLTabPage>> pdMap = new HashMap<PLUILayout,List<PLTabPage>>();
				Map<PLTabPage,List<PLPageDefination>> tdMap = new HashMap<PLTabPage,List<PLPageDefination>>();
				Map<PLPageDefination,List<PLTabButton>> dbMap = new HashMap<PLPageDefination,List<PLTabButton>>();
				Map<PLTabButton,List<PLCommandParameter>> bcMap = new HashMap<PLTabButton,List<PLCommandParameter>>();
				
				List<PLUILayout> plpagelayoutdefinationList = new ArrayList<PLUILayout>();
				List<PLTabPage> pltabpagelist = new ArrayList<PLTabPage>();
				List<PLPageDefination> plpagedefinationlist = new ArrayList<PLPageDefination>();
				List<PLTabButton> pltabbuttonlist = new ArrayList<PLTabButton>();
				List<PLCommandParameter> plcommandparameterlist = new ArrayList<PLCommandParameter>();
				
				StringBuffer checkplpagelayoutdefination = new StringBuffer();
				StringBuffer checkplpagelayoutdefinationPlcode = new StringBuffer();
				StringBuffer plActionIDNulls = new StringBuffer();
				String btmName = selectTreeNodeobject.name;
				//add by caill start 初始化标记
				int count=0;
				int preCount=0;
				String preOID="";
				String doublePreOID="";
				//add by caill end
				PLAction[] allPLAction = UITools.getService().getAllPLAction();
				Map<String,String> relation = null;
				for(int i=0;i<=plpagelayoutdefnationsheet.getLastRowNum();i++){
					pltabpagelist = new ArrayList<PLTabPage>();
					PLUILayout p = new PLUILayout();
					HSSFRow readrow = plpagelayoutdefnationsheet.getRow(i);
					if(readrow==null){
						break;
					}
					
					plpagelayoutdefinations = UITools.getService().getPLUILayoutsByRelatedType(btmName);
					
					p.plOId = ObjectUtility.getNewObjectID36();
					HSSFCell readcell = readrow.getCell(0);
					p.plName = readcell.getStringCellValue();
					readcell = readrow.getCell(1);
					p.plCode = readcell.getStringCellValue();
					//add by caill start
					//遍历UI名称
					for(PLUILayout pd : plpagelayoutdefinations){
						if(pd.plName.equals(p.plName)){	
							int vc=VCIOptionPane.showConfirmDialog(LogonApplication.frame, pd.plName+"名称已经存在,是否覆盖?","温馨提示", VCIOptionPane.YES_NO_OPTION);
							if(vc==0){
								;
							}else{
								return false;
							}
							//checkplpagelayoutdefination.append(pd.plName).append(",");
						}
						//根据UI上下文做判断
						if(pd.plCode.equals(p.plCode)){
							count=1;
							preOID=pd.plOId;  //如果UI上下文相同，就把系统中的id赋值给新导入的id
							p.plOId=pd.plOId;
						}
					}
					//add by caill end
					readcell = readrow.getCell(2);
					plpageLayoutDefinationId = readcell.getStringCellValue();	
					readcell = readrow.getCell(3);
					String name = readcell.getStringCellValue();
					readcell = readrow.getCell(4);
					p.plRelatedType = readcell.getStringCellValue();					
					readcell = readrow.getCell(5);
					p.plIsShowNavigator = (short) readcell.getNumericCellValue();
					readcell = readrow.getCell(6);
					p.plIsShowTab = (short) readcell.getNumericCellValue();
					readcell = readrow.getCell(7);
					p.plIsShowForm = (short) readcell.getNumericCellValue();
					if(!btmName.equals(name)){
						VCIOptionPane.showMessage(LogonApplication.frame, "请选择要导入的类型节点名称！");
						return false;
					}
					/*plpagelayoutdefinations = Tool.getService().getPLUILayoutsByRelatedType(btmName);
					for(PLUILayout pd : plpagelayoutdefinations){
						if(pd.plName.equals(p.plName)){
							
							checkplpagelayoutdefination.append(pd.plName).append(",");
						}
						if(pd.plCode.equals(p.plCode)){
							
							if(!checkplpagelayoutdefinationPlcode.toString().contains(p.plCode)){
								checkplpagelayoutdefinationPlcode.append(p.plCode).append(",");
							}
						}
					}*/
					plpagelayoutdefinationList.add(p);
					for(int j=0;j<=pltabpagesheet.getLastRowNum();j++){
						plpagedefinationlist = new ArrayList<PLPageDefination>();
						PLTabPage pt = new PLTabPage();
						HSSFRow readrow1 = pltabpagesheet.getRow(j);
						if(readrow1==null){
							break;
						}
						pt.plOId = ObjectUtility.getNewObjectID36();
						HSSFCell readcell1 = readrow1.getCell(0);
						pt.plName = readcell1.getStringCellValue();
						readcell1 = readrow1.getCell(1);
						pt.plCode = readcell1.getStringCellValue();
						//add by caill start
						if(count==1) {
						    PLTabPage[] PLTabPages = UITools.getService().getPLTabPagesByPageDefinationOId(preOID);
							//遍历控制区表格
							for(PLTabPage pl : PLTabPages){
								if(pl.plCode.equals(pt.plCode)){
									pt.plOId=pl.plOId; //如果控制区表格的编码和导入的编码一样，就把控制区id赋值给新导入的id
									preCount=1;
									doublePreOID=pl.plOId;
								}
							}
						}
						//add by caill end
						readcell1 = readrow1.getCell(2);
						pt.plSeq = (short) readcell1.getNumericCellValue();
						readcell1 = readrow1.getCell(3);
						pt.plContextOId = readcell1.getStringCellValue();
						readcell1 = readrow1.getCell(4);
						pt.plDesc = readcell1.getStringCellValue();
						readcell1 = readrow1.getCell(5);
						pt.plIsOpen = (short) readcell1.getNumericCellValue();
						readcell1 = readrow1.getCell(6);
						pt.plAreaType = (short) readcell1.getNumericCellValue();
						readcell1 = readrow1.getCell(7);
						pt.plOpenExpression = readcell1.getStringCellValue();
						readcell1 = readrow1.getCell(8);
						pt.plLicensOrs = readcell1.getStringCellValue();
						readcell1 = readrow1.getCell(9);
						pt.plLabel = readcell1.getStringCellValue();
						readcell1 = readrow1.getCell(10);
						plPageContextOId = readcell1.getStringCellValue();
						if(pt.plContextOId.equals(plpageLayoutDefinationId)){
							pt.plContextOId = p.plOId;
							pltabpagelist.add(pt);
							for(int k=0;k<=plpagedefinationsheet.getLastRowNum();k++){
								pltabbuttonlist = new ArrayList<PLTabButton>();
								PLPageDefination plpagedefination  = new PLPageDefination();
								HSSFRow readrow2 = plpagedefinationsheet.getRow(k);
								if(readrow2==null){
									break;
								}
								plpagedefination.plOId = ObjectUtility.getNewObjectID36();
								HSSFCell readcell2 = readrow2.getCell(0);
								plpagedefination.name = readcell2.getStringCellValue();
								//add by caill start
								//最后一级的判断
								if(preCount==1) {
									PLPageDefination[] PLPageDefinations = UITools.getService().getPLPageDefinationsByPageContextOId(doublePreOID);
									for(PLPageDefination plp : PLPageDefinations) {
										if(plp.name.equals(plpagedefination.name)) {
											plpagedefination.plOId=plp.plOId;
											
										}
										
									}
								}
								//add by caill end
								readcell2 = readrow2.getCell(1);
								plpagedefination.plDefination = readcell2.getStringCellValue();
								readcell2 = readrow2.getCell(2);
								plpagedefination.seq = (short) readcell2.getNumericCellValue();
								readcell2 = readrow2.getCell(3);
								plpagedefination.plTabPageOId = readcell2.getStringCellValue();
								readcell2 = readrow2.getCell(4);
								plpagedefination.desc = readcell2.getStringCellValue();
								readcell2 = readrow2.getCell(5);
								plpagedefination.plType = (short) readcell2.getNumericCellValue();
								readcell2 = readrow2.getCell(6);
								plTableOId = readcell2.getStringCellValue();
								if(plpagedefination.plTabPageOId.equals(plPageContextOId)){
									plpagedefination.plTabPageOId = pt.plOId;
									plpagedefinationlist.add(plpagedefination);
									//保存新旧oid的关系，在确定层级关系时使用
									relation = new HashMap<String,String>();
									for(int a=0;a<=pltabbuttonsheet.getLastRowNum();a++){
										HSSFRow readrow3 = pltabbuttonsheet.getRow(a);
										if(readrow3!=null){
											HSSFCell readcell3 = readrow3.getCell(7);
											plCommandOId = readcell3.getStringCellValue();
											String newOId = ObjectUtility.getNewObjectID36();
											relation.put(plCommandOId, newOId);											
										}
									}
									for(int a=0;a<=pltabbuttonsheet.getLastRowNum();a++){
										plcommandparameterlist = new ArrayList<PLCommandParameter>();
										PLTabButton plTabButton = new PLTabButton();
										HSSFRow readrow3 = pltabbuttonsheet.getRow(a);
										if(readrow3==null){
											break;
										}
										plTabButton.plOId = ObjectUtility.getNewObjectID36();
										HSSFCell readcell3 = readrow3.getCell(0);
										plTabButton.plLabel = readcell3.getStringCellValue();
										readcell3 = readrow3.getCell(1);
										plTabButton.plAreaType = readcell3.getStringCellValue();
										readcell3 = readrow3.getCell(2);
										plTabButton.plTableOId = readcell3.getStringCellValue();
										readcell3 = readrow3.getCell(3);
										plTabButton.plSeq = (short) readcell3.getNumericCellValue();
										String plActionId = "";
										//PLAction[] allPLAction = Tool.getService().getAllPLAction();
										for(PLAction action : allPLAction){
											if((readrow3.getCell(4).getStringCellValue()!=null&&!"".equals(readrow3.getCell(4).getStringCellValue())
													)&&(readrow3.getCell(4).getStringCellValue().trim().equals(action.plCode.trim()))
													){
												plActionId = action.plOId;
												break;
											}
										}
										if(plActionId==null||"".equals(plActionId)){
											if(!plActionIDNulls.toString().contains(readrow3.getCell(4).getStringCellValue())){
												plActionIDNulls.append("\n\tAction编号:"+readrow3.getCell(4).getStringCellValue());
											}
										}
										plTabButton.plActionOId = plActionId;
										readcell3 = readrow3.getCell(5);
										plTabButton.plAreaType = readcell3.getStringCellValue();
										readcell3 = readrow3.getCell(6);
										plTabButton.plDesc = readcell3.getStringCellValue();
										readcell3 = readrow3.getCell(8);
										String parentOid = readcell3.getStringCellValue();//父oid
										readcell3 = readrow3.getCell(7);
										plCommandOId = readcell3.getStringCellValue();
										readcell3 = readrow3.getCell(9);
										if(readcell3 != null) {
											plTabButton.displayMode = readcell3.getStringCellValue();
										}	
										readcell3 = readrow3.getCell(10);
										if(readcell3 != null) {
											plTabButton.iconPath = readcell3.getStringCellValue();
										}
										readcell3 = readrow3.getCell(11);
										if(readcell3 != null) {
											plTabButton.authorization = readcell3.getStringCellValue();
										}
										readcell3 = readrow3.getCell(12);
										if(readcell3 != null) {
											plTabButton.show = readcell3.getStringCellValue();
										}
										//赋予保存好的值，来保证层级关系不会丢失
										plTabButton.plOId = relation.get(plCommandOId);
										if(parentOid != null && parentOid.length() > 0) {											
											plTabButton.plParentOid = 
													relation.get(parentOid) == null ? "" : relation.get(parentOid);
										}
										if(plTabButton.plTableOId.equals(plTableOId)){
											plTabButton.plTableOId = plpagedefination.plOId;
											pltabbuttonlist.add(plTabButton);
											for(int b=0;b<=plcommondparamsheet.getLastRowNum();b++){
												PLCommandParameter plCommandParameter = new PLCommandParameter();
												HSSFRow readrow4 = plcommondparamsheet.getRow(b);
												if(readrow4==null){
													break;
												}
												plCommandParameter.plOId = ObjectUtility.getNewObjectID36();
												HSSFCell readcell4 = readrow4.getCell(0);
												plCommandParameter.plCommandOId = readcell4.getStringCellValue();
												readcell4 = readrow4.getCell(1);
												plCommandParameter.plKey = readcell4.getStringCellValue();
												readcell4 = readrow4.getCell(2);
												plCommandParameter.plValue = readcell4.getStringCellValue();
												if(plCommandParameter.plCommandOId.equals(plCommandOId)){
													plCommandParameter.plCommandOId = plTabButton.plOId;
													plcommandparameterlist.add(plCommandParameter);
												}
											}
											bcMap.put(plTabButton, plcommandparameterlist);
										}
									}
									dbMap.put(plpagedefination, pltabbuttonlist);
								}
							}
							tdMap.put(pt, plpagedefinationlist);
						}
					}
					pdMap.put(p, pltabpagelist);
				}
				
				if(plActionIDNulls.length()>0){
					VCIOptionPane.showMessage(LogonApplication.frame, plActionIDNulls.toString()+"不存在！");
					return false;
				}
				
				//删除原有button数据
				if(tdMap.size() > 0) {
					for(List<PLPageDefination> list : tdMap.values()) {
						for(PLPageDefination ppd : list) {
							if(ppd.plOId != null && ppd.plOId.length() > 0) {
								PLTabButton[] buttons = UITools.getService().getPLTabButtonsByTableOId(ppd.plOId);
								if(buttons != null && buttons.length > 0) {
									for(PLTabButton ptb : buttons) {
										UITools.getService().deletePLTabButtonByID(ptb.plOId);
									}
								}
							}
						}
					}
				}
				
				for(PLUILayout plPageLayoutDefination : plpagelayoutdefinationList){
					List<PLTabPage> pltabpagelists = pdMap.get(plPageLayoutDefination);
					for(PLTabPage pltabpage:pltabpagelists){
						List<PLPageDefination> plpagedefinationlists = tdMap.get(pltabpage);
						for(PLPageDefination plpagedefination : plpagedefinationlists){
							List<PLTabButton> pltabbuttons = dbMap.get(plpagedefination);
							for(PLTabButton pltabbutton : pltabbuttons){
								List<PLCommandParameter> plcommandParams = bcMap.get(pltabbutton);
								for(PLCommandParameter plcommandparameter : plcommandParams){
									plcommandparameter.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
									plcommandparameter.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
									UITools.getService().savePLCommandParameter(plcommandparameter);
								}
								pltabbutton.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
								pltabbutton.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
								UITools.getService().savePLTabButton(pltabbutton);
							}
							UITools.getService().savePLPageDefination(plpagedefination);
						}
						pltabpage.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
						pltabpage.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
						UITools.getService().savePLTabPage(pltabpage);
					}
					plPageLayoutDefination.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
					plPageLayoutDefination.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
					UITools.getService().savePLUILayout(plPageLayoutDefination);
				}
				return true;
			} catch (IOException e) {
				e.printStackTrace();
				return false;
			} catch (VCIError e) {
				e.printStackTrace();
				return false;
			}
		} catch (FileNotFoundException e) {
			e.printStackTrace();
			return false;
		}
	}
}