package com.shlanbao.tzsc.pms.cos.spare.controller;

import java.io.File;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.shlanbao.tzsc.base.dao.CosSparePartsDaoI;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.model.Json;
import com.shlanbao.tzsc.base.model.PageParams;
import com.shlanbao.tzsc.pms.cos.spare.beans.CosSparePartsBean;
import com.shlanbao.tzsc.pms.cos.spare.service.CosSparePartsServiceI;

@Controller
@RequestMapping("/pms/spare")
public class CosSparePartsController {
	@Autowired
	public CosSparePartsServiceI cosSparePartsServiceI;
	@RequestMapping("/gotoUpdateBean")
	public String gotoUpdateBean(HttpServletRequest request,String id) throws Exception{
		request.setAttribute("bean", cosSparePartsServiceI.getBeanById(id));
		request.setAttribute("id", "i");
		return "/pms/equ/spare/editSpareParts";
	}
	//WCT备品备件查询
	@ResponseBody
	@RequestMapping("/queryData")
	public DataGrid queryDataGrid(CosSparePartsBean bean,PageParams pageParams) throws Exception{
		
		return cosSparePartsServiceI.queryGridByBean(bean, pageParams);
	}
	
	//PMS备品备件查询
	@ResponseBody
	@RequestMapping("/queryDataPMS")
	public DataGrid queryDataGridPMS(CosSparePartsBean bean,PageParams pageParams) throws Exception{
		
		return cosSparePartsServiceI.queryGridByBeanPMS(bean, pageParams);
	}
	
	@ResponseBody
	@RequestMapping("/updateBean")
	public Json updateBean(CosSparePartsBean bean) {
		Json json=new Json();
		try{
			if(cosSparePartsServiceI.saveOrUpdateBean(bean)){
				json.setMsg("操作成功!");
				json.setSuccess(true);
			}
		}catch(Exception e){
			json.setMsg("操作失败!");
			json.setSuccess(false);
			return json;
		}
		return json;
	}
	
	@ResponseBody
	@RequestMapping("/addBean")
	public Json addBean(CosSparePartsBean bean,PageParams pageParams){
		Json json=new Json();
		try{
			if(cosSparePartsServiceI.saveOrUpdateBean(bean)){
				json.setMsg("操作成功!");
				json.setSuccess(true);
			}
		}catch(Exception e){
			json.setMsg("操作失败!");
			json.setSuccess(false);
			return json;
		}
		return json;
	}
	
	@ResponseBody
	@RequestMapping("/deleteBean")
	public Json deleteBean(String id) {
		Json json=new Json();
		try{
			cosSparePartsServiceI.deleteById(id);
			json.setMsg("操作成功!");
			json.setSuccess(true);
		}catch(Exception e){
			json.setMsg("操作失败!");
			json.setSuccess(false);
			return json;
		}
		return json;
	}

	@ResponseBody
	@RequestMapping("/batchDeleteBean")
	public Json batchDeleteBean(String ids){
		Json json=new Json();
		try{
			cosSparePartsServiceI.batchDeleteBean(ids);
			json.setMsg("操作成功!");
			json.setSuccess(true);
		}catch(Exception e){
			json.setMsg("操作失败!");
			json.setSuccess(false);
			return json;
		}
		return json;
	}


	/**
	 * 【功能说明】：备品备件批量导入功能- 跳转导入选择界面
	 * @author wchuang
	 * @time 2015年8月2日14:50:16
	 * @param id
	 * @param request
	 * @return path -页面路径
	 * 
	 * */
	@RequestMapping("/inputExcelDatas")
	public String inputExcelDatas(HttpServletRequest request,String id) {
		return "/pms/equ/spare/iframe_excel";
	}
	
	/**
	 * 【功能说明】：备品备件批量导入功能- 添加解析excel
	 * @author wchuang
	 * @time 2015年8月2日14:50:16
	 * @param id
	 * @param request
	 * @return path -页面路径
	 * 
	 * */
	@RequestMapping("/inputExeclAndReadWrite")
	@ResponseBody
	 public Json inputExeclAndReadWrite(@RequestParam(value = "importFile", required = false)
	                                       MultipartFile file,HttpServletRequest request, CosSparePartsBean cspb) {
		    Json json=new Json();   
			try {
				String path = request.getSession().getServletContext().getRealPath("upload");
				String fileName = file.getOriginalFilename();
				File targetFile = new File(path, fileName);
				if (!targetFile.exists()) {
				    targetFile.mkdirs();
				}
				try {
				    file.transferTo(targetFile);
				} catch (Exception e) {
				    e.printStackTrace();
				}
				String url = path + "/" + fileName;
				String bm=fileName.substring( (fileName.lastIndexOf(".")+1) ,fileName.length());
				List<CosSparePartsBean> list =null;
				InputFilesController fl=new InputFilesController();
				if("xls".equals(bm)){ 
					list=fl.readXls2003(url);
				}else if("xlsx".equals(bm)){ 
					list=fl.readXlsx2007(url);
				}
				if(list!=null&&list.size()>0){
					 cosSparePartsServiceI.batchInputExeclAndReadWrite(list,cspb);
					 json.setMsg("导入成功!");
					 json.setSuccess(true);
				}
			} catch (Exception e) {
				json.setMsg("导入失败!");
	        	 json.setSuccess(false);
				e.printStackTrace();
			}
			return json;
	}


}