package com.cabletech.business.wplan.patrolitem.action;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.lang.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.InterceptorRef;
import org.apache.struts2.convention.annotation.InterceptorRefs;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.Result;
import org.apache.struts2.convention.annotation.Results;
import org.springframework.context.annotation.Scope;
import org.springframework.util.CollectionUtils;
import com.cabletech.baseinfo.business.entity.UserInfo;
import com.cabletech.business.wplan.patrolitem.model.PatrolItem;
import com.cabletech.business.wplan.patrolitem.service.PatrolItemImportService;
import com.cabletech.common.base.BaseAction;
import com.cabletech.common.base.SysConstant;
import com.cabletech.common.externalresources.ExternalResourcesAccessService;
import com.cabletech.common.util.Page;
/**
*
* 巡检项导入 ACTION
*
* @author wnagjie
* @author 杨隽 2011-10-25 添加导入巡检项目的“值域范围”和“默认值”字段
* @author 杨隽 2012-04-06 修改页面的列表控件显示方式
*/
@Namespace("/wplan")
@Results({
@Result(name = "input", location = "/wplan/patrolitem/import_patrol_item.jsp"),
@Result(name = "preview", location = "/wplan/patrolitem/import_patrol_item_preview.jsp"),
@Result(name = "success", location = "/wplan/patrolitem/import_patrol_item_result.jsp") })
@Action("/patrolItemImportAction")
@InterceptorRefs({ @InterceptorRef("fileUploadStack"),
@InterceptorRef("defaultStack") })
@Scope("prototype")
public class PatrolItemImportAction extends BaseAction<PatrolItem, String> {
private static final long serialVersionUID = 1L;
// 预览导入数据跳转页面
private static final String PREVIEW = "preview";
// 巡检项导入数据业务服务
@Resource(name = "patrolItemImportServiceImpl")
private PatrolItemImportService patrolItemImportService;
// 外部资源服务业务服务
@Resource(name = "externalResourcesAccessService")
private ExternalResourcesAccessService externalResourcesAccessService;
// 上传的数据文件
private File file;
// 上传文件的内容类型
private String fileContentType;
// 上传文件名
private String fileFileName;
// 资源专业类型
private String businessType;
/**
* 转到表单输入
*/
public String input() throws Exception {
return INPUT;
}
/**
* 导入单模板下载
*
* @return
*/
public String downloadTemplate() {
HttpServletResponse response = getResponse();
response.reset();
response.setContentType("application/vnd.ms-excel");
try {
response.setHeader("Content-Disposition", "attachment;filename="
+ new String("巡检项信息导入模板.xls".getBytes(), "iso-8859-1"));
OutputStream out = response.getOutputStream();
String downloadFilePath = SysConstant.EXCEL_DOWNLOAD_TEMPLATES_PACKAGE_PATH
+ "/wplan_patrolitem_template.xls";
String templateFile = getClass().getResource(downloadFilePath)
.getPath();
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(
templateFile));
HSSFWorkbook workbook = new HSSFWorkbook(fs);
workbook.write(out);
} catch (Exception e) {
logger.error("下载巡检项信息导入模板出错：", e);
}
return null;
}
/**
* 导入数据预览（从导入文件中解析上传数据进行分页）
*
* @return
*/
@SuppressWarnings({ "rawtypes", "unchecked" })
public String preview() {
// 上传导入数据文件
String[] uploadInfo = uploadFile();
if (!"S001".equals(uploadInfo[0])) {
super.addMessage("提示:" + uploadInfo[2],
"/wplan/patrolItemImportAction!input.action",
SysConstant.WARNING);
return SUCCESS;
}
String filePath = uploadInfo[1];
// 生成预览数据
List list = patrolItemImportService.createItemPreviewData(filePath);
super.sessionManager.put("PATROLITEM_IMPORT_FILEPATH", filePath);
super.sessionManager.put("PREVIEW_IMPORT_LIST", list);
super.getRequest().setAttribute("businessType", businessType);
return PREVIEW;
}
/**
* 导入数据预览（直接从会话中获取导入数据列表进行分页）
*
* @return
*/
@SuppressWarnings({ "rawtypes" })
public void previewList() {
List list = (List) super.sessionManager.get("PREVIEW_IMPORT_LIST");
createPage(list);
super.getRequest().setAttribute("businessType", businessType);
}
/**
* 导入信息数据处理（保存导入数据后进行分页）
*
* @return
*/
@SuppressWarnings({ "rawtypes", "unchecked" })
public String importData() {
UserInfo user = super.getUser();
String regionId = user.getRegionId();
// 执行导入分析数据文件
String filePath = super.getParameter("filePath");
Map<String, String> parameterMap = new HashMap<String, String>();
parameterMap.put("file_path", filePath);
parameterMap.put("business_type", businessType);
parameterMap.put("region_id", regionId);
Map resultMap = patrolItemImportService.importItemData(parameterMap);
List list = (List) resultMap.get("valid_cell_list");
super.sessionManager.put("import_data_map", resultMap);
super.sessionManager.put("ERROR_IMPORT_LIST",
resultMap.get("invalid_cell_list"));
super.sessionManager.put("CELL_IMPORTED_LIST", list);
super.sessionManager.put("businessType", businessType);
return SUCCESS;
}
/**
* 导入信息数据处理（直接从会话中获取导入后合法数据列表进行分页）
*
* @return
*/
@SuppressWarnings({ "rawtypes" })
public void importDataList() {
List list = (List) super.sessionManager.get("CELL_IMPORTED_LIST");
createPage(list);
}
/**
* 导出巡检项不合法数据以及不合法信息提示
*
* @return
* @throws Exception
*/
@SuppressWarnings("rawtypes")
public String exportInvalidItemData() throws Exception {
HttpServletResponse response = getResponse();
OutputStream out;
initResponse(response, "未导入巡检项信息一览表.xls");
out = response.getOutputStream();
List list = (List) sessionManager.get("ERROR_IMPORT_LIST");
patrolItemImportService.exportInvalidItemData(out, list);
return null;
}
/**
* 根据数据列表创建列表页面的分页结果集合
*
* @param list
* List 数据列表
*/
@SuppressWarnings({ "rawtypes", "unchecked" })
private void createPage(List list) {
// TODO Auto-generated method stub
Page page = super.initPage();
if (CollectionUtils.isEmpty(list)) {
page.setTotalCount(0);
return;
}
List result = new ArrayList();
for (int i = 0; i < page.getPageSize(); i++) {
if (page.getFirst() + i + 1 > list.size()) {
break;
}
result.add(list.get(page.getFirst() + i));
}
page.setResult(result);
page.setTotalCount(list.size());
super.convertObjToJson(page);
}
/**
* 执行上传导入数据的文件
*
* @return String[] 上传文件信息：数组第一个元素为上传是否成功信息，第二个元素为上传后的数据文件路径
*/
private String[] uploadFile() {
// FormFile file = getFile();
String uploadCode = "S001";
String filePathNameStr = "";
String errorMsg = "";
if (file != null) {
String filename = fileFileName;
if (StringUtils.isBlank(filename)) {
uploadCode = "fileerror";
errorMsg = "文件名为空！";
}
// 文件类型必须是xls的
if (!filename.substring(filename.length() - 3, filename.length())
.equals("xls")) {
uploadCode = "structerror";
errorMsg = "文件类型不是xls格式!";
}
if (file.length() > 2000000) {
uploadCode = "fileoutsize";
errorMsg = "文件超过规定长度!";
}
} else {
uploadCode = "fileerror";
errorMsg = "文件上传错误!";
}
// 保存文件
if ("S001".equals(uploadCode)) {
filePathNameStr = saveFile(file);
if (filePathNameStr == null) {
uploadCode = "fileerror";
errorMsg = "文件上传错误!";
}
}
return new String[] { uploadCode, filePathNameStr, errorMsg };
}
/**
* 将上传的文件保存为临时文件
*
* @param formFile
* File
* @return String
*/
private String saveFile(File formFile) {
if (formFile == null) {
return null;
}
String uploadRoot = externalResourcesAccessService.getUploadroot();
uploadRoot = uploadRoot + File.separator + "temp";
SimpleDateFormat formatter = new SimpleDateFormat("yyyy/MM/ddHHmmss");
String strTemp = formatter.format(new Date());
String fileSptr = File.separator;
String saveAsName = strTemp.substring(8, 16) + fileFileName;
String relativePath = strTemp.substring(0, 4) + fileSptr
+ strTemp.subSequence(5, 7);
String absolutePath = uploadRoot + fileSptr + relativePath;
String absolutePathFile = absolutePath + fileSptr + saveAsName;
(new File(absolutePath)).mkdirs();
// 保存文件
try {
InputStream streamIn = new FileInputStream(formFile);
OutputStream streamOut = new FileOutputStream(absolutePathFile);
int bytesRead = 0;
byte[] buffer = new byte[8192];
while ((bytesRead = streamIn.read(buffer, 0, 8192)) != -1) {
streamOut.write(buffer, 0, bytesRead);
}
streamOut.close();
streamIn.close();
return absolutePathFile;
} catch (Exception e) {
logger.error("导入文件时出错:", e);
return null;
}
}
public File getFile() {
return file;
}
public void setFile(File file) {
this.file = file;
}
public String getFileContentType() {
return fileContentType;
}
public void setFileContentType(String fileContentType) {
this.fileContentType = fileContentType;
}
public String getFileFileName() {
return fileFileName;
}
public void setFileFileName(String fileFileName) {
this.fileFileName = fileFileName;
}
public void setBusinessType(String businessType) {
this.businessType = businessType;
}
@Override
public PatrolItem getModel() {
// TODO Auto-generated method stub
return null;
}
@Override
protected void prepareViewModel() throws Exception {
// TODO Auto-generated method stub
}
@Override
protected void prepareSaveModel() throws Exception {
// TODO Auto-generated method stub
}
}