package com.vci.client.portal.NewNewUI.actionmng;

import java.io.File;
import java.io.FileInputStream;
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.corba.portal.*;
import com.vci.corba.portal.data.Constraint;
import com.vci.corba.portal.data.PLAction;
import com.vci.corba.portal.data.PLActionCls;
import com.vci.corba.portal.data.PLActionParam;
import com.vci.client.LogonApplication;
import com.vci.client.portal.utility.UITools;
import com.vci.common.utility.ObjectUtility;
import com.vci.corba.common.VCIError;

public class ImpAction {

	private Map<String, PLActionCls> clsMap;

	public ImpAction(){
		this.parseActionCls();
	}
	public boolean impExcel(){
		JFileChooser jf = new JFileChooser();
		jf.setDialogTitle("打开");
		jf.removeChoosableFileFilter(jf.getFileFilter());
		jf.setFileFilter(new FileFilter() {
			public String getDescription() {
				return "xls";
			}
			public boolean accept(File f) {
				return ((f.isDirectory()) || (f.getName().endsWith(".xls")));
			}
		});
		int showOpenDialog = jf.showOpenDialog(LogonApplication.frame);
		if(showOpenDialog == JFileChooser.APPROVE_OPTION){
			File selectedFile = jf.getSelectedFile();
			String fileName = selectedFile.getAbsolutePath();
			if(!fileName.endsWith(".xls")){
				fileName = fileName + ".xls";
			}
			FileInputStream fin = null;
			try {
				fin = new FileInputStream(fileName);
				HSSFWorkbook workbook = new HSSFWorkbook(fin);
				this.importActionCls(workbook);
				List<PLAction> actions = new ArrayList<PLAction>();
				this.importActions(workbook, actions);
				this.importActionParams(workbook, actions);
				return true;
			} catch (Exception e) {
				e.printStackTrace();
			}finally{
				if(fin != null){
					try{
						fin.close();
					}catch(Exception e){
					}
				}
			}
		}
		return false;
	}

	private void importActionParams(HSSFWorkbook workbook,	List<PLAction> actions) {
		HSSFSheet sheet = workbook.getSheet("param_sheet");
		HSSFRow titleRow = sheet.getRow(0);
		for(int i = 1; i<=sheet.getLastRowNum(); i++){
			HSSFRow row = sheet.getRow(i);
			this.implActionParam(row, titleRow, actions);
		}
	}
	private void implActionParam(HSSFRow row, HSSFRow titleRow, List<PLAction> actions) {
		PLActionParam actionParam = null;
		for(int i=0; i< titleRow.getLastCellNum(); i++){
			String title = titleRow.getCell(i).getStringCellValue();
			/*int cellType = titleRow.getCell(i).getCellType();
			String value = "";
			if(cellType == HSSFCell.CELL_TYPE_NUMERIC){
				value = String.valueOf(row.getCell(i).getNumericCellValue());
			}else if(cellType == HSSFCell.CELL_TYPE_STRING){
				value = row.getCell(i).getStringCellValue();
			}*/
			String value = row.getCell(i).toString();
			if(value == null || value.trim().length() == 0){
				continue;
			}
			if(actionParam == null){
				actionParam = new PLActionParam();
			}
			if(title.equals("参数名称")){
				actionParam.name = value.trim();
			}else if(title.equals("默认值")){
				actionParam.defaultValue = value.trim();
			}else if(title.equals("提示信息")){
				actionParam.description = value.trim();
			}else if(title.equals("所属action")){
				actionParam.action = value.trim();
			}
		}
		try {
			if(actionParam != null){
				String actionName = actionParam.action;
				String actionParamName = actionParam.name;
				for(PLAction action: actions){
					if(actionName.equals(action.plCode)){
						actionParam.action =  action.plOId;
						PLActionParam[] params = UITools.getService().getPLActionParamArrayByActionId(action.plOId);
						boolean isExist = false;
						for(PLActionParam param: params){
							if(actionParamName.equals(param.name)){
								isExist = true;
								break;
							}
						}
						if(!isExist){
							UITools.getService().createPLActionParam(actionParam);
						}
					}
				}
			}
		} catch (VCIError e) {
			e.printStackTrace();
		}
	}
	private void importActionCls(HSSFWorkbook workbook) {
		HSSFSheet sheet = workbook.getSheet("cls_sheet");
		HSSFRow titleRow = sheet.getRow(0);
		for(int i = 1; i<=sheet.getLastRowNum(); i++){
			HSSFRow row = sheet.getRow(i);
			this.implActionCls(row, titleRow);
		}
	}

	private void implActionCls(HSSFRow row, HSSFRow titleRow) {
		PLActionCls actionCls = null;
		for(int i=0; i< titleRow.getLastCellNum(); i++){
			String title = titleRow.getCell(i).getStringCellValue();
			int cellType = titleRow.getCell(i).getCellType();
			//String value = "";
			String value = row.getCell(i).toString();
			/*if(cellType == HSSFCell.CELL_TYPE_NUMERIC){
				value = String.valueOf(row.getCell(i).getNumericCellValue());
			}else if(cellType == HSSFCell.CELL_TYPE_STRING){
				value = row.getCell(i).getStringCellValue();
			}*/
			if(value == null || value.trim().length() == 0){
				continue;
			}
			if(actionCls == null){
				actionCls = new PLActionCls();
			}
			if(title.equals("类全路径")){
				String clsPath = value.trim();
				if(clsMap.get(clsPath) != null){
					actionCls = null;
					break;
				} 
				if(clsPath.contains("#")){
					int lastIndex = clsPath.lastIndexOf("#");
					PLActionCls parent = clsMap.get(clsPath.substring(0, lastIndex));
					actionCls.pid = parent.id;
					actionCls.name = clsPath.substring(lastIndex+1, clsPath.length());
				}else{
					actionCls.pid = "";
					actionCls.name = value.trim();
				}
			}else if(title.equals("描述")){
				actionCls.description = value.trim();
			}else if(title.equals("创建人")){
				actionCls.creator = value.trim();
			}else if(title.equals("创建时间")){
				actionCls.createTime = Long.valueOf(value.trim());
			}else if(title.equals("分类序号")){
				actionCls.serialno = Short.valueOf(value.trim());
			}
		}
		if(actionCls != null){
			UITools.getService().creaetePLActionCls(actionCls);
			this.parseActionCls();
		}
	}

	private String getClsPath(PLActionCls cls) {
		try {
			PLActionCls[] clses = UITools.getService().getPLActionClsArray();
			StringBuilder sbuf = new StringBuilder();
			this.parseClsPath(cls, clses, sbuf);
			return sbuf.substring(0, sbuf.length()-1).toString();
		} catch (VCIError e) {
			e.printStackTrace();
		}
		return "";
	}
	private void parseClsPath(PLActionCls cls, PLActionCls[] clses, StringBuilder sbuf) {
		if(cls.pid != null && cls.pid.trim().length() > 0){
			for(PLActionCls actionCls: clses){
				if(cls.pid.equals(actionCls.id)){
					this.parseClsPath(actionCls, clses, sbuf);
				}
			}
		}
		sbuf.append(cls.name).append("#");
	}

	private void importActions(HSSFWorkbook workbook, List<PLAction> selActions) {
		List<PLAction> actions = new ArrayList<PLAction>();
		HSSFSheet sheet = workbook.getSheet("action_sheet");
		HSSFRow titleRow = sheet.getRow(0);
		for(int i = 1; i<=sheet.getLastRowNum(); i++){
			HSSFRow row = sheet.getRow(i);
			PLAction action = this.parse2Action(row, titleRow);
			if(action != null){
				actions.add(action);
			}
		}
		System.out.println(actions.size());
		try {
			for(PLAction action: actions){
				Constraint[] consArray = new Constraint[6];
				consArray[0] = new Constraint("plcode", action.plCode);
				consArray[1] = new Constraint("plname", action.plName);
				consArray[2] = new Constraint("plbsurl", action.plBSUrl);
				consArray[3] = new Constraint("plcsclass", action.plCSClass);
				consArray[4] = new Constraint("pltypetype", action.plTypeType);
				consArray[5] = new Constraint("plactioncls", action.plActionCls);
				PLAction[] actionArr = UITools.getService().getPLActionsByConsArray(consArray);
				if(actionArr != null && actionArr.length > 0){
					selActions.add(actionArr[0]);
					continue;
				}
				action.plOId = ObjectUtility.getNewObjectID36();
				UITools.getService().savePLAction(action);
				selActions.add(action);
			}
		} catch (VCIError e) {
			e.printStackTrace();
		}
	}
	
	private PLAction parse2Action(HSSFRow row, HSSFRow titleRow) {
		PLAction action = null;
		for(int i=0; i< titleRow.getLastCellNum(); i++){
			String title = titleRow.getCell(i).getStringCellValue();
			/*int cellType = titleRow.getCell(i).getCellType();
			String value = "";
			if(cellType == HSSFCell.CELL_TYPE_NUMERIC){
				value = String.valueOf(row.getCell(i).getNumericCellValue());
			}else if(cellType == HSSFCell.CELL_TYPE_STRING){
				value = row.getCell(i).getStringCellValue();
			}*/
			String value = row.getCell(i).toString();
			if(value == null || value.trim().length() == 0){
				continue;
			}
			if(action == null){
				action = new PLAction();
			}
			if(title.equals("编号")){
				action.plCode = value.trim();
			}else if(title.equals("名称")){
				action.plName = value.trim();
			}else if(title.equals("类路径")){
				action.plCSClass = value.trim();
			}else if(title.equals("链接地址")){
				action.plBSUrl = value.trim();
			}else if(title.equals("类型")){
				action.plTypeType = value.trim();
			}else if(title.equals("描述")){
				action.plDesc = value.trim();
			}else if(title.equals("创建人")){
				action.plCreateUser = value.trim();
			}else if(title.equals("创建时间")){
				action.plCreateTime = Long.valueOf(value.trim());
			}else if(title.equals("修改人")){
				action.plModifyUser = value.trim();
			}else if(title.equals("修改时间")){
				action.plModifyTime = Long.valueOf(value.trim());
			}else if(title.equals("所属分类")){
				PLActionCls plActionCls = clsMap.get(value.trim());
				if(plActionCls != null){
					action.plActionCls = plActionCls.id;
				}else{
					action.plActionCls = "";
				}
			}else if(title.equals("plLicensOrs")){
				action.plLicensOrs = value.trim();
			}
		}
		return action;
	}

	private void parseActionCls() {
		try {
			clsMap = new HashMap<String, PLActionCls>();
			PLActionCls[] allClses = UITools.getService().getPLActionClsArray();
			for(PLActionCls cls: allClses){
				String clsPath = this.getClsPath(cls);
				clsMap.put(clsPath, cls);
			}
		} catch (VCIError e) {
			e.printStackTrace();
		}
	}
}