package com.slcf.service.impl;

import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;
import org.springframework.web.multipart.MultipartFile;

import com.slcf.bean.MatCodeCondition;
import com.slcf.dao.MatCodeDao;
import com.slcf.erp.OperateOracle;
import com.slcf.pojo.LocDetailBean;
import com.slcf.pojo.MatCodeBean;
import com.slcf.pojo.WorkDetailBean;
import com.slcf.service.MatCodeService;
import com.slcf.util.DateTimeUtil;

/**
 * 物料编码接口实现
 * @author admin
 * @date 2018年11月10日
 */
@Service
public class MatCodeServiceImpl implements MatCodeService {

	@Autowired
	MatCodeDao matCodeDao;
	
	/**
	 * 添加
	 */
	@Transactional
//	public int insertMatCode(MatCodeBean matCode) throws Exception{
//		int result=0;
//		try {
//			result=matCodeDao.insertMatCode(matCode);
//		}catch(Exception e) {
//			throw new RuntimeException(e.getMessage());
//		}
//		return result;
//	}
	public int insertMatCode(MatCodeBean matCode) throws Exception{
		int result=0;
		try {
			result=matCodeDao.insertMatCode(matCode);
//			if(result>0) {
////				matCode.setMat_no("555");
////				matCode.setMat_name("abcdefghijk");
//				result=matCodeDao.insertMatCode(matCode);
//				if(result>=0){
//					TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
//		            throw new RuntimeException("1111");
//		        }
//			}
		}catch(Exception e) {
			TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
			System.out.println(e.getMessage());
			throw new RuntimeException("1111");
		}
		return result;
	}

//	/**
//	 * 统计数量
//	 */
//	public int queryMatCodeCount(){
//		int result = 0;
//		try {
//			result = matCodeDao.getMatCodeCount();
//		}catch(Exception e) {
//			System.out.println(e.getMessage());
//		}
//		return result;
//	}

	/**
	 * 分页查询所有
	 */
	public Map<String,Object> queryMatCodeList(MatCodeCondition matCodeCon) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<MatCodeBean> list=matCodeDao.queryMatCodeList(matCodeCon);
			int count =matCodeDao.getMatCodeCount(matCodeCon);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	public Map<String,Object> queryMatCodeByNo(MatCodeCondition matCodeCon) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			int count =matCodeDao.getMatCountByNo(matCodeCon);
			if(count<=0) {
				//ERP中提取数据
				OperateOracle oerp=new OperateOracle();
				MatCodeBean matCode = oerp.SelectMatCode(matCodeCon.getMat_no());
				if(matCode!=null) {
					matCodeDao.insertMatCode(matCode);
				}
			}
			count =matCodeDao.getMatCountByNo(matCodeCon);
			List<MatCodeBean> list=matCodeDao.queryMatCodeByNo(matCodeCon);
			
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
//	public List<MatCodeBean> queryMatCodeList(int spage, int epage) {
//		try {
//			return matCodeDao.queryMatCodeList(spage, epage);
//		}catch(Exception e) {
//			System.out.println(e.getMessage());
//			return null;
//		}
//	}

	/**
	 * 根据id查找
	 */
	public MatCodeBean queryMatCodeById(String id) {
		try {
			return matCodeDao.getMatCodeById(id);
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 根据id查找
	 */
	public MatCodeBean queryMatCodeByBarcode(String id) {
		try {
			return matCodeDao.getMatCodeByBarcode(id);
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	//更新
	public int upMatCode(MatCodeBean matCode) {
		int result=0;
		try {
			result=matCodeDao.upMatCode(matCode);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}

	//更新
	public int upMatBarcode(MatCodeBean matCode) {
		int result=0;
		try {
			result=matCodeDao.upMatBarcode(matCode);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
		
	/**
	 * 根据id删除
	 */
	public int delMatCode(String did) {
		int result=0;
		try {
			List<LocDetailBean> listLoc = matCodeDao.getLocMatNoList(did);
			List<WorkDetailBean> listWrk = matCodeDao.getWrkMatNoList(did);
			if ((listLoc!=null && listLoc.size()>0)
					||listWrk!=null && listWrk.size()>0) {
				return result;
			}
			result=matCodeDao.delMatCodeById(did);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 批量删除
	 */
	public int delMatCodes(String did) {
		int result=0;
		try {
			result=matCodeDao.delMatCodesById(did);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}

	/**
	 * 查询所有
	 * @return
	 */
	public List<MatCodeBean> getMatCodeList() {
		try {
			return matCodeDao.getMatCodeList();
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 导出excel 
	 */
	public void ExportMatCodeList(MatCodeCondition matCodeCon, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("物料编码信息");

			// 行数，参数为行索引(excel的行)
			// HSSFRow rowHead=sheet.createRow(0);//第一行 可以是0～65535之间的任何一个

			// //创建excel的单元格，参数为列索引，可以是0～255之间的任何一个
			// HSSFCell cellOne=rowHead.createCell(0);
			// cellOne.setCellValue("用户信息");//表头

			// 合并单元格CellRangeAddress构造参数依次表示起始行，截至行，起始列， 截至列
			// sheet.addMergedRegion(new CellRangeAddress(0,0,0,5));

			sheet.setColumnWidth(0, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((30 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((30 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((30 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((30 + 0.72) * 256));

			HSSFRow rows = sheet.createRow(0);// 第二行
			// 创建单元格并设置单元格内容
			rows.createCell(0).setCellValue("箱号/批号");
			rows.createCell(1).setCellValue("托盘号");
			rows.createCell(2).setCellValue("物料编号");
			rows.createCell(3).setCellValue("物料描述");
			rows.createCell(4).setCellValue("客户名称");
			rows.createCell(5).setCellValue("毛重");
			rows.createCell(6).setCellValue("净重");

			List<MatCodeBean> matCodeList = matCodeDao.getMatCodeAll(matCodeCon);
			for (int i = 0; i < matCodeList.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(matCodeList.get(i).getMat_no());
				row.createCell(1).setCellValue(matCodeList.get(i).getBarcode());
				row.createCell(2).setCellValue(matCodeList.get(i).getStr3());
				row.createCell(3).setCellValue(matCodeList.get(i).getMat_name());
				row.createCell(4).setCellValue(matCodeList.get(i).getStr2());
				row.createCell(5).setCellValue(matCodeList.get(i).getNum4());
				row.createCell(6).setCellValue(matCodeList.get(i).getNum6());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=MatCode" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
		
	/**
	 * 导入excel
	 * @param file
	 * @return
	 */
	public Map<String, Object> importExcel(MultipartFile file) {
		List<MatCodeBean> matList = new ArrayList<MatCodeBean>();
		Map<String, Object> map = new HashMap<String, Object>();
		int x = 0, y = 0, sum = 0;
		boolean flag = false;
		if (file != null) {
			// 根据指定的文件输入流导入Excel从而产生Workbook对象
			try {
				Workbook workBook = new HSSFWorkbook(file.getInputStream());
				// 获取Excel文档中的第一个表单
				Sheet sheet = workBook.getSheetAt(0);
				// 对Sheet中的每一行进行迭代
				for (Row r : sheet) {
					// 如果当前行的行号（从0开始）未达到1（第二行）则从新循环
					if (r.getRowNum() < 1) {
						continue;
					}

					MatCodeBean mat = new MatCodeBean();
					if(r.getCell(0)==null || r.getCell(0).getStringCellValue()=="") {
						continue;
					}
					mat.setMat_no(r.getCell(0)!=null ? r.getCell(0).getStringCellValue() : "");
					mat.setBarcode(r.getCell(1)!=null ? r.getCell(1).getStringCellValue() : "");
					mat.setStr3(r.getCell(2)!=null ? r.getCell(2).getStringCellValue() : "");
					mat.setMat_name(r.getCell(3)!=null ? r.getCell(3).getStringCellValue() : "");
					mat.setStr2(r.getCell(4)!=null ? r.getCell(4).getStringCellValue() : "");
					mat.setNum4(r.getCell(5)!=null ? Double.parseDouble(r.getCell(5).getStringCellValue()) : 0);
					mat.setNum6(r.getCell(6)!=null ? Double.parseDouble(r.getCell(6).getStringCellValue()) : 0);
					matList.add(mat);
				}
			} catch (IOException e) {
				e.printStackTrace();
			}

			y = matList.size();
			for (MatCodeBean m : matList) {
				MatCodeBean matCode = matCodeDao.getMatCodeById(m.getMat_no());
				if (matCode != null && !matCode.getMat_no().equals("")) {
					x++;
				} else {
					int i = matCodeDao.insertMatCode(m);
					sum += i;
				}
			}
			if (sum == (y - x)) {
				flag = true;
			}
		}
		map.put("msg", "共有" + y + "条数据,成功导入" + sum + "条数据,物料编码重名的数据有" + x + "条");
		map.put("flag", flag);
		return map;
	}
	
	/*
	 * 查询库存、工作档中已存在物料数据数量
	 */
	public int getMatCount(String mat_no) {
		int result=0;
		try {
			List<LocDetailBean> listLoc = matCodeDao.getLocMatNoList(mat_no);
			List<WorkDetailBean> listWrk = matCodeDao.getWrkMatNoList(mat_no);
			if (listWrk!=null && listWrk.size()>0) {
				result = listWrk.size();
			}
			if (listLoc!=null && listLoc.size()>0) {
				result = listLoc.size();
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
		
}