package com.vci.client.framework.rightConfig.functiontree;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.LinkedList;
import java.util.List;
import javax.swing.JPanel;

import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Workbook;

import com.vci.client.LogonApplication;
import com.vci.client.common.TransmitTreeObject;
import com.vci.client.common.objects.UserObject;
import com.vci.client.framework.delegate.FuncOperationClientDelegate;
import com.vci.client.framework.delegate.FunctionClientDelegate;
import com.vci.client.framework.delegate.RightManagementClientDelegate;
import com.vci.client.framework.rightConfig.object.FuncOperationObject;
import com.vci.client.framework.rightConfig.object.FunctionObject;
import com.vci.client.utils.excel.ExcelDocumentUtils;
import com.vci.client.utils.excel.SheetDataSet;
import com.vci.client.ui.exception.VCIException;
import com.vci.client.ui.process.QANProcessBar;
import com.vci.client.ui.process.QANProcessBarFrame;
import com.vci.client.ui.swing.VCIOptionPane;
import com.vci.client.ui.swing.VCISwingUtil;
import com.vci.client.ui.swing.components.VCIJOptionPane;
import com.vci.client.utils.excel.ExcelCellStyleSettingCallback;
import com.vci.client.utils.excel.ExcelFileOperation;
import com.vci.client.utils.excel.WorkboolStyleSetting;
import com.vci.common.utility.ObjectUtility;
import com.vci.corba.common.VCIError;
import com.vci.corba.framework.data.OperateInfo;

public class FunOperateExcelImportDialogActionListener  extends JPanel implements ActionListener  {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	/**
	 * 父窗体
	 */
	private static final String ENUM_USERSECURITYENUM = "usersecurityenum";
	private FunOperateImportDialog ownerDialog = null;
	/**
	 *  必填列
	 */
	private ArrayList<Integer> ColumnNameisRed = new ArrayList<Integer>();
	/**
	 * 所有user信息。
	 */
	private ArrayList<FunctionObject> fileDatas = new ArrayList<FunctionObject>();
	//private ArrayList<FunctionObject> fileDatas=null;
	private ArrayList<FunctionObject> fileDatas2 = new ArrayList<FunctionObject>();
	/**
	 * 用户
	 */
	private ArrayList<String[]> deptAndUserRelation = new ArrayList<String[]>();
	//模块对象
	private final FunctionClientDelegate modelDelegate = new FunctionClientDelegate(LogonApplication.getUserEntityObject());
	private final FuncOperationClientDelegate funoperDelegate = new FuncOperationClientDelegate(LogonApplication.getUserEntityObject());
	private TransmitTreeObject transmitTreeObject = new TransmitTreeObject();
	
	private UserObject logonUserInfo;//
	private String userName = LogonApplication.getUserEntityObject().getUserName();
	
	//Object obj=null;
	
	
	public FunOperateExcelImportDialogActionListener(
			FunOperateImportDialog excelImprotDialog) {
		this.ownerDialog = excelImprotDialog;
	}

	public FunOperateExcelImportDialogActionListener() {
		// TODO Auto-generated constructor stub
	}
	@Override
	public void actionPerformed(ActionEvent e) {
		try{
			logonUserInfo = new RightManagementClientDelegate(LogonApplication.getUserEntityObject()).fetchUserInfoByName(userName);
		}catch(VCIException ex) {
			VCIOptionPane.showError(LogonApplication.frame,"RMIPFramework", ex);
			return;
		}
		String actionCommand = e.getActionCommand();
		if (actionCommand.equals(ownerDialog.getBtnSave().getActionCommand())) {
			LinkedList<File> selectedFiles = this.ownerDialog.getSelectedFiles();
			if (selectedFiles == null || selectedFiles.isEmpty()) {
				VCIOptionPane.showMessageDialog(LogonApplication.frame,
						"未选择文件！");
				return;
			}
			fileDatas.clear();
			deptAndUserRelation.clear();
			save();
			this.ownerDialog.getActionExecute().reloadFunctionTreeNode();
		} else if (actionCommand.equals(ownerDialog.getBtnSelect()
				.getActionCommand())) {
			getFile();
		} else if (actionCommand.equals(ownerDialog.getBtnExport()
				.getActionCommand())) {
			//downloadImportStuffTemplate();
		}
	
		
	}

	/**
	 * 保存对象
	 */
	private void save() {
		final QANProcessBarFrame frame = new QANProcessBarFrame();
		Thread t = new Thread() {
			public void run() {
				boolean b = false;
				frame.setContent("正在进行处理数据,请稍等......");
				try {
					b = importData(frame);
				} catch (VCIError e) {
					frame.setProcessBarCancel(true);
					VCIOptionPane.showMessageDialog(LogonApplication.frame,
							e.code);
				} catch (VCIException e){
					
				} catch (IOException e) {
					e.printStackTrace();
				} finally {
					frame.setProcessBarCancel(true);
					if (b) {
						VCIOptionPane.showMessageDialog(LogonApplication.frame,
								"导入成功！");
						ownerDialog.dispose();
						
					}else{
						VCIOptionPane.showMessageDialog(LogonApplication.frame,
								"导入失败！");
					}
				}
			}
		};
		QANProcessBar bar = new QANProcessBar(t, frame, frame,
				"导入人员数据......", false);
		bar.setVisible(true);
	}

	/**
	 * 导入
	 * 
	 * @param sheetDataSet
	 * @return
	 * @throws IOException 
	 * @throws VCIError 
	 * @throws VCIException 
	 * @autor caicong
	 * @data 2014-3-12
	 */
	private boolean importData(QANProcessBarFrame frame) throws VCIError, VCIException, IOException {

		frame.setContent("正在获取系统部门数据......");
		HashMap<String, String> allDept = ownerDialog.getAllDept();
		if (allDept.size() == 0) {
			//fetchAllDeptMessage();
		}
		frame.setContent("正在收集表单数据......");
		boolean isSuccess = collectionDatas();
		//if(!isSuccess) return false;
		frame.setContent("正在导入表单人员信息......");
		System.out.println("count==="+count);
		if(isSuccess==false){
			importExcelData(count);
		}
		//boolean b = importExcelData();
		return true;
	}

	/**
	 * 收集表单信息。
	 * 
	 * @throws VCIError
	 * @throws IOException
	 */
	// add by caill start
	int count=0;
	private boolean collectionDatas() throws VCIError, IOException{
		LinkedList<File> selectedFiles = this.ownerDialog.getSelectedFiles();
		boolean b=false;
		for (File f : selectedFiles) {
			List<SheetDataSet> sheetDataSets = this.getFileList(f);
			if (sheetDataSets != null && !sheetDataSets.isEmpty()) {
				for (SheetDataSet sheet : sheetDataSets) {
					// sheet不能为空并且必须有出表头外的一条数据
					if (sheet != null && sheet.getDataSet() != null && sheet.getDataSet().size() > 1) {
						List<String[]> dataSet = sheet.getDataSet();
						String fParentId="";		//第一级的id(第二级的parentid)
						boolean boo=true;
						boolean first=false;
						String[] pd=new String[100];
						int jibie=2;
						for (int i = 1; i < dataSet.size(); i++) {
							//fileDatas = new ArrayList<FunctionObject>();
							String[] oneData = dataSet.get(i);
							String userId = ObjectUtility.getNewObjectID36();
							
							FunctionObject funObj=new FunctionObject();
							boolean onebl=false;
							boolean twobl=false;
							boolean same=false;				
							String plName=oneData[0];
							if(oneData[14].equals("1")) {
								try {
									onebl=modelDelegate.firstLevel(plName);
								} catch (VCIException e) {
									// TODO Auto-generated catch block
									e.printStackTrace();
								}
								//如果第一级重名
								if(onebl == true) {								//第一级重名后覆盖第一级
									fuzhi(funObj,oneData);
									try {
										fParentId=modelDelegate.changeFirstLevel(funObj,plName);
										pd[2]=fParentId;
									} catch (VCIException e) {
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
									funObj.setId(fParentId);														//测试
									fileDatas.add(funObj);										//标记
									first=true;
								
									
								} else {
									funObj.setId(userId);
									funObj.setParentId("business");
									fuzhi(funObj,oneData);
									fileDatas.add(funObj);
									first=false;
								}
								
								b=false;
							}
							//#########################     合并     #########################
							for(jibie=2;jibie<100;jibie++){
								if(oneData[14].equals(String.valueOf(jibie))){				//2
									if(first == true && boo == true){
										try {
											if(pd[jibie]==null){
												pd[jibie]="";
											}
											twobl=modelDelegate.secondLevel(plName,pd[jibie]);
										} catch (VCIException e) {
											// TODO Auto-generated catch block
											e.printStackTrace();
										}
										if(twobl==true) {								//重名后覆盖
											fuzhi(funObj,oneData);
											try {
												fParentId=modelDelegate.changeSecondLevel(funObj,plName,pd[jibie]);
												pd[jibie+1]=fParentId;
											} catch (VCIException e) {
												// TODO Auto-generated catch block
												e.printStackTrace();
											}
											//funObj.setId(fParentId);									//测试
											funObj.setId(pd[jibie+1]);	
											fileDatas.add(funObj);				//标记										
											boo = true;
											
										} else {	//前几级重名，最后一级不重名的情况下
//											funObj.setId(userId);
//											for(int j=i-1;j>=1;j--){
//												if(dataSet.get(j)[14].equals(String.valueOf(jibie-1))){
//													for(int c=0;c<fileDatas.size();c++){
//														if(String.valueOf(fileDatas.get(c).getModuleNo()).equals(dataSet.get(j)[5])){
//															funObj.setParentId(fileDatas.get(c).getId());
//														}
//													}
//													break;
//												}
//											}
//											fuzhi(funObj,oneData);
//											fileDatas.add(funObj);
										}
										
									} else {
										funObj.setId(userId);
//										for(int j = i-1;j >= 1;j--){
//											if(dataSet.get(j)[14].equals(String.valueOf(jibie-1))){
//												for(int c=0;c<fileDatas.size();c++){
//													if(String.valueOf(fileDatas.get(c).getModuleNo()).equals(dataSet.get(j)[5])){
//														funObj.setParentId(fileDatas.get(c).getId());
//													}
//												}
//												
//												break;
//											}
//										}
//										fuzhi(funObj,oneData);
//										fileDatas.add(funObj);
										boo = false;
									}
									b=false;
								}
							}
							
							if(oneData[14].equals("-1")) {	
								importExcelData(count);
								FuncOperationObject foObj=new FuncOperationObject();
								int len=fileDatas.size();
								//**************同一节点下不能有相同的操作类型********************
								String dataOperName=oneData[18];
								String plFuncOid=fileDatas.get(len-1).getId();
								try {
									same = funoperDelegate.selSameOper(dataOperName,plFuncOid);
								} catch (VCIException e1) {
									// TODO Auto-generated catch block
									e1.printStackTrace();
								}
								//******************************************************
								if(same == false) {
									foObj.setId(userId);
									foObj.setFuncId(fileDatas.get(len-1).getId());
									try {
										OperateInfo operObj = modelDelegate.fetchOperateTypeByName(oneData[18]);
										foObj.setOperId(operObj.id);
									} catch (VCIException e) {
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
									foObj.setNumber(Integer.parseInt(oneData[16]));
									foObj.setOperAlias(oneData[15]);
									foObj.setIsValid(Integer.parseInt(oneData[17]) != 0);
									try {
										funoperDelegate.saveFuncOperation2(foObj);
									} catch (VCIException e) {
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
									
								} else {
									foObj.setNumber(Integer.parseInt(oneData[16]));
									foObj.setOperAlias(oneData[15]);
									foObj.setIsValid(Integer.parseInt(oneData[17]) != 0);
									try {
										funoperDelegate.updateOperation(foObj,dataOperName,plFuncOid);
									} catch (VCIException e) {
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
								}
								count=fileDatas.size();
								b=true;
							}							
						}
					}
				}
			}
		}
		return b;
	}

	public void fuzhi(FunctionObject funObj,String[] oneData){
		funObj.setName(oneData[0]);
		funObj.setResourceC(oneData[1]);
		funObj.setSuffixC(oneData[2]);
		funObj.setDesc(oneData[6]);
		funObj.setResourceB(oneData[3]);
		funObj.setSuffixB(oneData[4]);
		funObj.setSequence(Integer.parseInt(oneData[9]));
		//funObj.setModuleNo(Integer.parseInt(oneData[5]));
		funObj.setImage(oneData[8]);
		funObj.setIsValid(Integer.parseInt(oneData[7]) != 0);
		funObj.setAliasName(oneData[10]);
		funObj.setResourceDotNet(oneData[12]);
		funObj.setResourceMobile(oneData[13]);	
	}
	/**
	 * 导入表单数据
	 * @throws VCIException 
	 */
	private boolean importExcelData(int count) throws VCIError {
		//boolean b = new RightManagementClientDelegate(LogonApplication.getUserEntityObject()).batchSaveUsers(fileDatas.toArray(new UserObject[]{}),deptAndUserRelation.toArray(new String[][]{}));
		boolean b=false;
		
		try {
			b=	modelDelegate.importModules(fileDatas.toArray(new FunctionObject[]{}),count);
		} catch (VCIException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		//boolean b=true;
		System.out.println("uuuuuuuuu="+b);
		return b;
	}
	/**
	 * 获取选中的文件
	 * 
	 * @return
	 * @autor caicong
	 * @data 2014-3-12
	 */
	@SuppressWarnings({ "deprecation", "unused" })
	private LinkedList<File> getSelectedFiles() {
		LinkedList<File> selectedFiles = ownerDialog.tablePanel
				.getSelectedRowObjects();
		return selectedFiles;
	}

	/**
	 * 获取表单数据
	 * 
	 * @param f
	 * @return
	 * @throws IOException
	 * @throws VCIError
	 * @autor caicong
	 * @data 2014-3-11
	 */
	private List<SheetDataSet> getFileList(File f) throws VCIError, IOException {
		// 获取流
		BufferedInputStream fileInputStream = new BufferedInputStream(
				new FileInputStream(f));
		String name = f.getName();
		// 获取表list
		List<SheetDataSet> sheetDataSets = ExcelDocumentUtils
				.readExcelDocument(name, fileInputStream);
		return sheetDataSets;
	}

	private void getFile() {
		File f = getRequiredFile(true);
		if (f == null)
			return;
		ArrayList<File> lists = ownerDialog.getLists();
		/** 判断导入的文件是否被使用的校验，如果文件已经打开，不允许导入 **/
		if (lists.contains(f)) {
			VCIOptionPane.showMessageDialog(LogonApplication.frame,
					"文件重复，请重新选择！");
			return;
		}
		// 将文件保存到table中
		lists.add(f);
		ownerDialog.tablePanel.refreshTableData();
	}

	private File getRequiredFile(boolean isRead) {
		File files = getExcelFile();
		// add by xchao 2014.04.15 begin
		// 有错误数据要输出时，必须选择有效的excel文件
		while (files == null) {
			return null;
		}
		String fileName = files.getAbsolutePath();
		// 需要写入时，必须选择一个有效的、可以写入的文件
		if (!isRead) {
			// 如果文件被打开着，则必须选择其它的未打开着的文件
			while (files.exists() && !files.renameTo(new File(fileName))) {
				VCIJOptionPane.showMessageDialog(null,
						"另一个程序正在使用此文件，进程无法访问，请重新选择！");
				// 重新选择文件时，也必须选择有效的excel文件
				files = null;
				while (files == null) {
					files = getExcelFile();
					while (files == null) {
						return null;
					}
				}
				fileName = files.getAbsolutePath();
			}
		}
		return files;
	}

	public String[] getExcel() {
		return null;
	}

	private boolean exportExcel(String[][] datas, String sheetName) {
		File file = getRequiredFile(false);
		if (file == null) {
			return false;
		}
		String fileName = file.getAbsolutePath();
		// add by xchao 2014.05.15 end
		new ExcelFileOperation().writeExcelFileInfo(fileName, sheetName, datas,
				new ExcelCellStyleSettingCallback() {
					@Override
					public WorkboolStyleSetting doSetWorkbookStyle(
							final Workbook workbook) {
						WorkboolStyleSetting setting = new WorkboolStyleSetting() {
							@Override
							public LinkedHashMap<String, CellStyle> getStyleMap() {
								LinkedHashMap<String, CellStyle> styleMap = new LinkedHashMap<String, CellStyle>();
								org.apache.poi.ss.usermodel.CellStyle style = workbook
										.createCellStyle();
								org.apache.poi.ss.usermodel.Font font = (org.apache.poi.ss.usermodel.Font) workbook
										.createFont();
								font.setColor(HSSFFont.COLOR_RED);
								style.setFont(font);
								for (int column : ColumnNameisRed) {
									styleMap.put("0*" + (column) + "", style);
								}
								return styleMap;
							}
						};
						return setting;
				
					}
				});
		return true;
	}

	private File getExcelFile() {
		File file = null;
		String filePath = VCISwingUtil.getExcelFileURL(ownerDialog, true, "");
		if (filePath != null) {
			file = new File(filePath);
		}
		return file;
	}

}