package com.vci.client.oq.ui.export;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.ObjectOutputStream;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.Map.Entry;

import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

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.NewNewUI.Export.VCIExportTree;
import com.vci.client.portal.UI.dialog.VCIGuideStepPanel;
import com.vci.client.ui.swing.VCIOptionPane;
import com.vci.corba.omd.btm.BtmItem;
import com.vci.corba.omd.qtm.QTD;
import com.vci.corba.omd.qtm.QTInfo;

/**
 * Action导出第二步界面
 * 
 * @Title :ExpActionStep2Panel.java
 * @Description :
 * @Copyright :宏博远达科技有限公司
 * @Author :平台与规划部/ZhongGY/E-mail:zhonggy@vci-tech.com
 * @Date :2015-6-5
 * @Version :1
 * @Other :产生注释:Alt+Shift+J
 */
public class QTExpQTStep2Panel extends VCIGuideStepPanel {

	private static final long serialVersionUID = 1L;

	/**
	 * 导出模型文件全路径显示
	 */
	private JLabel lblModelFileFullPath;
	/**
	 * 导出日志文件全路径显示
	 */
	private JLabel lblLogFileFullPath;
	/**
	 * 导出日志清单列表
	 */
	private JScrollPane scrollPane = new JScrollPane();
	/*private JTable tblExportLog;*/
	/**
	 * 导出文件名
	 */
	private String logFileName = "...";
	private String vciqtmfFileName = "...";
	private VCIExportTree exportTree = null;
	//xls
	HSSFWorkbook workbook;
	HSSFSheet sheet_QTD;
	HSSFSheet sheet_QTWrapper;
	HSSFSheet sheet_selectedBtmAttrs;
	HSSFSheet sheet_selectedBtmItems;
	int qtqindex =0;
	int qtwindex =0;
	int saindex =0;
	int sbindex =0;
	public QTExpQTStep2Panel() {
		GridBagLayout gridBagLayout = new GridBagLayout();
		gridBagLayout.columnWidths = new int[] { 0, 0, 0, 0, 0 };
		gridBagLayout.rowHeights = new int[] { 25, 25, 0, 0 };
		gridBagLayout.columnWeights = new double[] { 0.0, 0.0, 1.0, 0.0,
				Double.MIN_VALUE };
		gridBagLayout.rowWeights = new double[] { 0.0, 0.0, 1.0,
				Double.MIN_VALUE };
		setLayout(gridBagLayout);

		JLabel label = new JLabel(" ");
		GridBagConstraints gbc_label = new GridBagConstraints();
		gbc_label.insets = new Insets(0, 0, 5, 5);
		gbc_label.gridx = 0;
		gbc_label.gridy = 0;
		add(label, gbc_label);

		JLabel label_1 = new JLabel("导出模型文件:");
		GridBagConstraints gbc_label_1 = new GridBagConstraints();
		gbc_label_1.insets = new Insets(0, 0, 5, 5);
		gbc_label_1.gridx = 1;
		gbc_label_1.gridy = 0;
		add(label_1, gbc_label_1);

		lblModelFileFullPath = new JLabel("...");
		GridBagConstraints gbc_lblModelFileFullPath = new GridBagConstraints();
		gbc_lblModelFileFullPath.anchor = GridBagConstraints.WEST;
		gbc_lblModelFileFullPath.insets = new Insets(0, 0, 5, 5);
		gbc_lblModelFileFullPath.gridx = 2;
		gbc_lblModelFileFullPath.gridy = 0;
		add(lblModelFileFullPath, gbc_lblModelFileFullPath);

		JLabel label_2 = new JLabel(" ");
		GridBagConstraints gbc_label_2 = new GridBagConstraints();
		gbc_label_2.insets = new Insets(0, 0, 5, 0);
		gbc_label_2.gridx = 3;
		gbc_label_2.gridy = 0;
		add(label_2, gbc_label_2);

		JLabel label_4 = new JLabel("导出日志文件:");
		GridBagConstraints gbc_label_4 = new GridBagConstraints();
		gbc_label_4.insets = new Insets(0, 0, 5, 5);
		gbc_label_4.gridx = 1;
		gbc_label_4.gridy = 1;
		add(label_4, gbc_label_4);
		lblLogFileFullPath = new JLabel("...");
		GridBagConstraints gbc_lblLogFileFullPath = new GridBagConstraints();
		gbc_lblLogFileFullPath.anchor = GridBagConstraints.WEST;
		gbc_lblLogFileFullPath.insets = new Insets(0, 0, 5, 5);
		gbc_lblLogFileFullPath.gridx = 2;
		gbc_lblLogFileFullPath.gridy = 1;
		add(lblLogFileFullPath, gbc_lblLogFileFullPath);

		
		GridBagConstraints gbc_scrollPane = new GridBagConstraints();
		gbc_scrollPane.gridwidth = 2;
		gbc_scrollPane.insets = new Insets(0, 0, 0, 5);
		gbc_scrollPane.fill = GridBagConstraints.BOTH;
		gbc_scrollPane.gridx = 1;
		gbc_scrollPane.gridy = 2;
		add(scrollPane, gbc_scrollPane);
		
		table = new JTable();
		table.setModel(new DefaultTableModel(
			new Object[][] {
				{null, null, null, null},
			},
			new String[] {
				"\u5E8F\u53F7", "\u5BFC\u51FA\u72B6\u6001", "\u67E5\u8BE2\u65B9\u6848\u540D\u79F0", "\u6240\u5C5E\u7C7B\u578B\u540D\u79F0"
			}
		) {
			/**
			 * 
			 */
			private static final long serialVersionUID = 1L;
			boolean[] columnEditables = new boolean[] {
				false, false, false, false
			};
			public boolean isCellEditable(int row, int column) {
				return columnEditables[column];
			}
		});
		table.getColumnModel().getColumn(0).setResizable(false);
		table.getColumnModel().getColumn(0).setPreferredWidth(35);
		table.getColumnModel().getColumn(1).setPreferredWidth(85);
		table.getColumnModel().getColumn(2).setPreferredWidth(158);
		table.getColumnModel().getColumn(3).setPreferredWidth(173);
		scrollPane.setViewportView(table);

		/*tblExportLog = new JTable();*/
		
		
	}

	public QTExpQTStep1Panel getPreStepUI() {
		if (super.getPreStepUI() != null) {
			return (QTExpQTStep1Panel) super.getPreStepUI();
		} else {
			return null;
		}
	}
	
	public Map<String,Object> getCommonMap(){
    	return this.getGuidCommonShareData();
    }
	
	@Override
	public void initUI() {
		// 可不用处理，默认加载即可
		// ExpActionStep1Panel preUI = (ExpActionStep1Panel)
		// this.getPreStepUI();
		// String filePath = preUI.getExportFilePath();
		exportTree = (VCIExportTree) getCommonMap().get("exportTree");		
		String filePath = (String) getCommonMap().get("exportFilePath");
		Long currentTimes = System.currentTimeMillis();
		 logFileName= exportTree.getExportLogFileName(filePath,currentTimes);
		 vciqtmfFileName = exportTree.getExportDataFileName(filePath,currentTimes);
		lblModelFileFullPath.setText(vciqtmfFileName);
		lblLogFileFullPath.setText(logFileName);		
		initData();
	}

	@SuppressWarnings("unchecked")
	@Override
	public void initData() {
		//1、两个文件路径（共享 ）加载显示
		
		//加载table数据
		DefaultTableModel tblModel = (DefaultTableModel)table.getModel();
		while(tblModel.getRowCount() > 0 ){
			tblModel.removeRow(0);
		}		
		ObjectOutputStream vciamfFileStream = null;
		PrintWriter logFileWriter = null;
		try {
			qtqindex =0;
			qtwindex =0;
			saindex =0;
			sbindex =0;
			File vciqtmfFile = new File(vciqtmfFileName);		//模版文件 
			File logFile = new File(logFileName);				//日志文件
			logFileWriter = new PrintWriter(logFile);
			List<Object[]> selectedQTs = (List<Object[]>)this.getCommonMap().get("selectedQTs");
			for (int i = 0; i < selectedQTs.size(); i++) {
				logFileWriter.println(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss ").format(new Date())+" [序号=" + selectedQTs.get(i)[0] + ", 导出状态=" + selectedQTs.get(i)[1]
						+ ", 查询方案名称=" + selectedQTs.get(i)[2] + ", 所属类型名称=" + selectedQTs.get(i)[3] + "]"); 
				tblModel.addRow(selectedQTs.get(i)); 
			}
			QTExportData exportData = (QTExportData) getCommonMap().get("exportData");;// 获得导出Bean同时，记录log
			Map<String, QTD[]> allQTDs = exportData.getAllQTDs();
			Map<String, QTInfo> allQTs = exportData.getAllQTs();
			workbook = new HSSFWorkbook();
			sheet_QTD = workbook.createSheet();
			workbook.setSheetName(0, "QTD");
			Set<Entry<String, QTD[]>> pLActions = allQTDs.entrySet();
			for (Entry<String, QTD[]> entry : pLActions) {
				String key = entry.getKey();
				QTD[] value = entry.getValue();
				for (QTD qtd : value) {
					HSSFRow row = sheet_QTD.createRow(qtwindex++);
					HSSFCell cell = row.createCell(0);
					cell.setCellValue(key);
					cell = row.createCell(1);
					cell.setCellValue(qtd.btmName);
					cell = row.createCell(2);
					cell.setCellValue(qtd.createTime);
					cell = row.createCell(3);
					cell.setCellValue(qtd.creator);
					cell = row.createCell(4);
					cell.setCellValue(qtd.linkTypeName);
					cell = row.createCell(5);
					cell.setCellValue(qtd.name);
					cell = row.createCell(6);
					StringBuffer abNames = new StringBuffer();
					for (int i = 0; i < qtd.abNames.length; i++) {
						abNames.append(qtd.abNames[i]).append("#");
					}
					cell.setCellValue(abNames.toString());
					
				}
			}
			sheet_QTWrapper = workbook.createSheet();
			workbook.setSheetName(1, "QTInfo");
			Set<Entry<String, QTInfo>> pLQts = allQTs.entrySet();
			for (Entry<String, QTInfo> entry : pLQts) {
				String key = entry.getKey();
				HSSFRow row = sheet_QTWrapper.createRow(qtqindex++);
				HSSFCell cell = row.createCell(0);
				cell.setCellValue(key);
				QTInfo value = entry.getValue();
				cell=row.createCell(1);
				cell.setCellValue(value.btmName);
				cell=row.createCell(2);
				cell.setCellValue(value.createTime);
				cell=row.createCell(3);
				cell.setCellValue(value.creator);
				cell=row.createCell(4);
				cell.setCellValue(value.qtName);
				cell=row.createCell(5);
				cell.setCellValue(value.qtText);
				cell=row.createCell(6);
				cell.setCellValue(value.levelFlag);
				cell=row.createCell(7);
				cell.setCellValue(value.qtUIText);
				
			}
			sheet_selectedBtmAttrs = workbook.createSheet();
			workbook.setSheetName(2, "SelectedBtmAttrs");
			Map<String, String[]> selectedBtmAttrs = exportData.getSelectedBtmAttrs();
			Iterator<Entry<String, String[]>> it = selectedBtmAttrs.entrySet().iterator();
			while (it.hasNext()) {
				Entry<String, String[]> entry = it.next();
				HSSFRow row = sheet_selectedBtmAttrs.createRow(saindex++);
				HSSFCell cell = row.createCell(0);
				String key = entry.getKey();
				cell.setCellValue(key);
				String[] value = entry.getValue();
				StringBuffer sb = new StringBuffer();
				cell = row.createCell(1);
				for (int i = 0; i < value.length; i++) {
					sb.append(value[i]).append("#");
				}
				cell.setCellValue(sb.toString());
			}
			
			sheet_selectedBtmItems = workbook.createSheet();
			workbook.setSheetName(3, "SelectedBtmItems");
			Map<String, BtmItem> selectedBtmItems = exportData.getSelectedBtmItems();
			Iterator<Entry<String, BtmItem>> iterator = selectedBtmItems.entrySet().iterator();
			while (iterator.hasNext()) {
				Entry<String, BtmItem> entry = iterator.next();
				HSSFRow row = sheet_selectedBtmItems.createRow(sbindex++);
				String key = entry.getKey();
				HSSFCell cell = row.createCell(0);
				cell.setCellValue(key);
				BtmItem value = entry.getValue();
				cell = row.createCell(1);
				cell.setCellValue(value.createTime);
				cell = row.createCell(2);
				cell.setCellValue(value.creator);
				cell = row.createCell(3);
				cell.setCellValue(value.delimiter);
				cell = row.createCell(4);
				cell.setCellValue(value.description);
				cell = row.createCell(5);
				cell.setCellValue(value.fName);
				cell = row.createCell(6);
				cell.setCellValue(value.imageName);
				cell = row.createCell(7);
				cell.setCellValue(value.implClass);
				cell = row.createCell(8);
				cell.setCellValue(value.isAbstract);
				cell = row.createCell(9);
				cell.setCellValue(value.label);
				cell = row.createCell(10);
				cell.setCellValue(value.lifeCycle);
				cell = row.createCell(11);
				cell.setCellValue(value.modifier);
				cell = row.createCell(12);
				cell.setCellValue(value.modifyTime);
				cell = row.createCell(13);
				cell.setCellValue(value.name);
				cell = row.createCell(14);
				cell.setCellValue(value.oid);
				cell = row.createCell(15);
				cell.setCellValue(value.revInput);
				cell = row.createCell(16);
				cell.setCellValue(value.revRuleName);
				cell = row.createCell(17);
				cell.setCellValue(value.shape);
				cell = row.createCell(18);
				cell.setCellValue(value.ts);
				cell = row.createCell(19);
				cell.setCellValue(value.revLevel);
				cell = row.createCell(20);
				cell.setCellValue(value.verRuleName);
				cell = row.createCell(21);
				StringBuffer apName = new StringBuffer();
				for (int i = 0; i < value.apNameArray.length; i++) {
					apName.append(value.apNameArray[i]).append("#");
				}
				cell.setCellValue(apName.toString());
				cell = row.createCell(22);
				StringBuffer lifCs = new StringBuffer();
				for (int i = 0; i < value.lifeCycles.length; i++) {
					lifCs.append(value.lifeCycles[i]).append("#");
				}
				cell.setCellValue(lifCs.toString());
			}
			
			FileOutputStream ou = new FileOutputStream(vciqtmfFile);
			workbook.write(ou);
			ou.close();
//			vciamfFileStream = new ObjectOutputStream(new FileOutputStream(
//					vciqtmfFile));
//			vciamfFileStream.writeObject(exportData);
		} catch (FileNotFoundException e) {
			VCIOptionPane.showMessage(LogonApplication.frame, "导出文件创建失败！");
			e.printStackTrace();
		} catch (IOException e) {
			VCIOptionPane.showMessage(LogonApplication.frame, "导出流异常！");
			e.printStackTrace();
		} finally {

			try {
				if (vciamfFileStream != null) {
					vciamfFileStream.flush();
					vciamfFileStream.close();
				}
				if (logFileWriter != null) {
					logFileWriter.flush();
					logFileWriter.close();
				}
			} catch (Exception e) {
				VCIOptionPane.showMessage(LogonApplication.frame, "导出流关闭异常！");
				e.printStackTrace();

			}
		}

		// TODO: 加载日志清单数据（tblExportLog/lblModelFileFullPath/lblLogFileFullPath）

	}


	@Override
	public String getStepName() {
/*		String secondStepName = null;
		if((secondStepName = (String)this.getCommonMap().get("secondStepName") )!= null){
			return secondStepName;
		}*/
		return "第二步:查询模板导出结果";
	}

	@Override
	public boolean isPreBtnVisible() {
		return true;
	}

	@Override
	public String getPreBtnText() {
		return "上一步";
	}

	@Override
	public boolean doPreBtnAction() {
		// TODO:上一步操作处理

		return true;
	}

	@Override
	public boolean isNextBtnVisible() {
		// 最后一步不显示“下一步”
		return false;
	}

	@Override
	public String getNextBtnText() {
		return null;
	}

	@Override
	public boolean doNextBtnAction() {
		return true;
	}

	@Override
	public boolean isCancelBtnVisible() {
		return true;
	}

	@Override
	public String getcancelBtnText() {
		return "完成";
	}

	String dialogProcess = ""; // [第X步/共X步]
	private JTable table;

	public String getDialogProcess() {
		dialogProcess = "[第2步/共2步]";
		return dialogProcess;
	}
}