package com.fh.util;

import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.springframework.web.servlet.view.document.AbstractExcelView;

import com.fh.util.PageData;
import com.fh.util.Tools;
public class ObjectExcelView2 extends AbstractExcelView{

	@Override
	protected void buildExcelDocument(Map<String, Object> model,
			HSSFWorkbook workbook, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub
		Date date = new Date();
		String filename = Tools.date2Str(date, "yyyyMMddHHmmss");
		HSSFSheet sheet;
		HSSFCell cell;
		response.setContentType("application/octet-stream");
		response.setHeader("Content-Disposition", "attachment;filename="+filename+".xls");
		if(model.get("class")!=null && !model.get("class").toString().isEmpty()){
			sheet = workbook.createSheet(model.get("class").toString());
		}else{
			sheet = workbook.createSheet("sheet1");
		}
		
		
		List<String> titles = (List<String>) model.get("titles");
		int len = titles.size();
		HSSFCellStyle headerStyle = workbook.createCellStyle(); //标题样式
		headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
		HSSFFont headerFont = workbook.createFont();	//标题字体
		headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
		headerFont.setFontHeightInPoints((short)11);
		headerStyle.setFont(headerFont);
		short width = 20,height=25*20;
		sheet.setDefaultColumnWidth(width);
		for(int i=0; i<len; i++){ //设置标题
			String title = titles.get(i);
			cell = getCell(sheet, 0, i);
			cell.setCellStyle(headerStyle);
			setText(cell,title);
		}
		sheet.getRow(0).setHeight(height);
		
		HSSFCellStyle contentStyle = workbook.createCellStyle(); //内容样式
		contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		List<PageData> varList = (List<PageData>) model.get("varList");
		int varCount = varList.size();
		Integer test_num =0;
		for(int i=0; i<varCount; i++){
			PageData vpd = varList.get(i);
			List<String> score = (List<String>)vpd.get("var6");
			
			for(int j=0;j<len;j++){
				if(j<5){
					
					if(score.size()>1){
						CellRangeAddress region = new CellRangeAddress(test_num+1, test_num+score.size(), j, j);
				        sheet.addMergedRegion(region);
					}
					
					String varstr = vpd.getString("var"+(j+1)) != null ? vpd.getString("var"+(j+1)) : "";
					cell = getCell(sheet, test_num+1, j);
					cell.setCellStyle(contentStyle);
					setText(cell,varstr);
				}else{
					//List<String> score = (List<String>)vpd.get("var6");
					for(int x=0;x<score.size();x++){
						String varstr = vpd.getString("var"+(j+1)) != null ? vpd.getString("var"+(j+1)) : "";
						varstr = varstr.replace("[", "");
						varstr = varstr.replace("]", "");
						String[] s = varstr.split(",");
						cell = getCell(sheet, test_num+1+x, j);
						cell.setCellStyle(contentStyle);
						setText(cell,s[x]);
					}
		
				}
			}
			test_num = score.size()+test_num;
		}
		
	}

}