package com.vci.client.framework.systemConfig.stafforgmanage;

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.Date;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import javax.swing.JPanel;

import com.vci.client.LogonApplication;
import com.vci.client.common.objects.RoleObject;
import com.vci.client.common.objects.UserObject;
import com.vci.client.framework.delegate.RightManagementClientDelegate;
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.common.utility.ObjectUtility;
import com.vci.corba.common.VCIError;

public class RolesExcelImportDialogActionListener  extends JPanel implements ActionListener  {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	/**
	 * 父窗体
	 */
	private RolesImportDialog ownerDialog = null;
	/**
	 * 所有Roles信息。
	 */
	private ArrayList<RoleObject> fileDatas = new ArrayList<RoleObject>();
	private UserObject logonUserInfo;//
	private String userName = LogonApplication.getUserEntityObject().getUserName();
	
	public RolesExcelImportDialogActionListener(
			RolesImportDialog excelImprotDialog) {
		this.ownerDialog = excelImprotDialog;
	}

	public RolesExcelImportDialogActionListener() {
		// 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();
			save();
			
		} else if (actionCommand.equals(ownerDialog.getBtnSelect()
				.getActionCommand())) {
			getFile();
		} 	
	}

	/**
	 * 保存对象
	 */
	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("正在导入表单人员信息......");
		boolean b = importExcelData();
		return b;
	}

	/**
	 * 收集表单信息。
	 * 
	 * @throws VCIError
	 * @throws IOException
	 */
	// add by caill start 2016.1.20 收集导入文件中的数据
	private boolean collectionDatas() throws VCIError, IOException{
		LinkedList<File> selectedFiles = this.ownerDialog.getSelectedFiles();
		RoleObject[] preRoles = null;
		int type = logonUserInfo.getUserType();
		if(type < 2){
			type = type+1;
		}
		try {
			//add by caill 2016.1.20根据type获得数据库中已经存在的角色
			preRoles = new RightManagementClientDelegate(LogonApplication.getUserEntityObject()).fetchRoleInfoByRoleType(type);
		} catch (VCIException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		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();
						for (int i = 1; i < dataSet.size(); i++) {
							String[] oneData = dataSet.get(i);
							String userId = ObjectUtility
									.getNewObjectID36();
							RoleObject RolesObj = new RoleObject();
							RolesObj.setId(userId);
							boolean flag = false;
							//add by caill 2016.1.20对于数据库中存在的同名角色，不覆盖不导入
							for(int j = 0;j < preRoles.length;j++){
								if(preRoles[j].getName().equals(oneData[0])){
									flag = true;
								}
							}
							if(oneData[0] != null && !oneData[0].trim().equals("") && flag == false){
								RolesObj.setName(oneData[0]); // 名称
								RolesObj.setDescription(oneData[1]);// 描述
								RolesObj.setType(logonUserInfo.getUserType());
								RolesObj.setCreateTime(System.currentTimeMillis());
								RolesObj.setCreateUser(userName);
								RolesObj.setUpdateTime(System.currentTimeMillis());
								RolesObj.setUpdateUser(userName);
								RolesObj.setGrantor("");
					    		
								fileDatas.add(RolesObj);
							}
							
						}
					}
				}
			}
		}
		return true;
	}
	/**
	 * 导入表单数据
	 * @throws VCIException 
	 */
	//add by caill start 2016.1.20将导入的数据插入到数据库中
	private boolean importExcelData() throws VCIError {
		boolean b = new RightManagementClientDelegate(LogonApplication.getUserEntityObject()).batchSaveRoles(fileDatas.toArray(new RoleObject[]{}));
		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 File getExcelFile() {
		File file = null;
		String filePath = VCISwingUtil.getExcelFileURL(ownerDialog, true, "");
		if (filePath != null) {
			file = new File(filePath);
		}
		return file;
	}

}