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.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.slcf.bean.LocChartPie;
import com.slcf.bean.WorkChartAxis;
import com.slcf.dao.ReportQueryDao;
import com.slcf.pojo.AdjDetailBean;
import com.slcf.pojo.PlcCommandBean;
import com.slcf.pojo.ViewInOutBean;
import com.slcf.pojo.ViewLocMapBean;
import com.slcf.pojo.ViewStayTimeBean;
import com.slcf.pojo.ViewStockUseBean;
import com.slcf.pojo.ViewWorkInBean;
import com.slcf.service.ReportQueryService;
import com.slcf.util.DateTimeUtil;

/**
 * 日志统计接口实现
 * @author admin
 * @date 2018年11月23日
 */
@Service
public class ReportQueryServiceImpl implements ReportQueryService {

	@Autowired
	ReportQueryDao reportQueryDao;
	
	//------------------库位使用统计--------------------------------------
	public Map<String,Object> queryViewStockUseList(ViewStockUseBean viewStockUse) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<ViewStockUseBean> list=reportQueryDao.queryViewStockUseList(viewStockUse);
			int count =reportQueryDao.getViewStockUseCount(viewStockUse);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportViewStockUseList(ViewStockUseBean viewStockUse, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("库位使用信息");

			sheet.setColumnWidth(0, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(7, (int) ((15 + 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("在库率(%)");
			rows.createCell(7).setCellValue("使用率(%)");

			List<ViewStockUseBean> list = reportQueryDao.getViewStockUseAll(viewStockUse);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getRow1());
				row.createCell(1).setCellValue(list.get(i).getTotal_qty());
				row.createCell(2).setCellValue(list.get(i).getFull_qty());
				row.createCell(3).setCellValue(list.get(i).getNull_qty());
				row.createCell(4).setCellValue(list.get(i).getForbid_qty());
				row.createCell(5).setCellValue(list.get(i).getEmpty_qty());
				row.createCell(6).setCellValue(list.get(i).getFull_rate());
				row.createCell(7).setCellValue(list.get(i).getOcc_rate());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=StockUse" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
		
	//------------------库存滞留统计--------------------------------------
	public Map<String,Object> queryViewStayTimeList(ViewStayTimeBean viewStayTime) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<ViewStayTimeBean> list=reportQueryDao.queryViewStayTimeList(viewStayTime);
			int count =reportQueryDao.getViewStayTimeCount(viewStayTime);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportViewStayTimeList(ViewStayTimeBean viewStayTime, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("库存滞留时间统计");

			sheet.setColumnWidth(0, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((25 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(7, (int) ((5 + 0.72) * 256));
			sheet.setColumnWidth(8, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(9, (int) ((10 + 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("数量");
			rows.createCell(7).setCellValue("单位");
			rows.createCell(8).setCellValue("托盘码");
			rows.createCell(9).setCellValue("用户ID");

			List<ViewStayTimeBean> list = reportQueryDao.getViewStayTimeAll(viewStayTime);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getAppe_time());
				row.createCell(1).setCellValue(list.get(i).getStay_time());
				row.createCell(2).setCellValue(list.get(i).getLoc_no());
				row.createCell(3).setCellValue(list.get(i).getMatnr());
				row.createCell(4).setCellValue(list.get(i).getMaktx());
				row.createCell(5).setCellValue(list.get(i).getWerks());
				row.createCell(6).setCellValue(list.get(i).getAnfme());
				row.createCell(7).setCellValue(list.get(i).getAltme());
				row.createCell(8).setCellValue(list.get(i).getZpallet());
				row.createCell(9).setCellValue(list.get(i).getBname());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=StayTime" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
		
	//------------------库存调整记录--------------------------------------
	public Map<String,Object> queryAdjDetailList(AdjDetailBean adjDetail) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<AdjDetailBean> list=reportQueryDao.queryAdjDetailList(adjDetail);
			int count =reportQueryDao.getAdjDetailCount(adjDetail);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportAdjDetailList(AdjDetailBean adjDetail, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("库存调整统计");

			sheet.setColumnWidth(0, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(7, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(8, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(9, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(10, (int) ((6 + 0.72) * 256));
			sheet.setColumnWidth(11, (int) ((20 + 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("原箱数");
			rows.createCell(7).setCellValue("调整箱数");
			rows.createCell(8).setCellValue("调整后箱数");
			rows.createCell(9).setCellValue("备注");
			rows.createCell(10).setCellValue("调整人员");
			rows.createCell(11).setCellValue("调整时间");

			List<AdjDetailBean> list = reportQueryDao.getAdjDetailAll(adjDetail);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getLoc_no());
				row.createCell(1).setCellValue(list.get(i).getMat_no());
				row.createCell(2).setCellValue(list.get(i).getMat_name());
				row.createCell(3).setCellValue(list.get(i).getS_qty());
				row.createCell(4).setCellValue(list.get(i).getAdj_qty());
				row.createCell(5).setCellValue(list.get(i).getQty());
				row.createCell(6).setCellValue(list.get(i).getS_ctns());
				row.createCell(7).setCellValue(list.get(i).getAdj_ctns());
				row.createCell(8).setCellValue(list.get(i).getCtns());
				row.createCell(9).setCellValue(list.get(i).getMemo());
				row.createCell(10).setCellValue(list.get(i).getModi_user());
				row.createCell(11).setCellValue(list.get(i).getModi_time());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=AdjDetail" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	//------------------站点日入出库次数统计--------------------------------------
	public Map<String,Object> queryViewInOutList(ViewInOutBean viewInOut) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<ViewInOutBean> list=reportQueryDao.queryViewInOutList(viewInOut);
			int count =reportQueryDao.getViewInOutCount(viewInOut);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportViewInOutList(ViewInOutBean viewInOut, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("日入出库次数统计");

			sheet.setColumnWidth(0, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((15 + 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("总次数");

			List<ViewInOutBean> list = reportQueryDao.getViewInOutAll(viewInOut);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getYmd());
				row.createCell(1).setCellValue(list.get(i).getSource_sta_no());
				row.createCell(2).setCellValue(list.get(i).getSto_qty());
				row.createCell(3).setCellValue(list.get(i).getRet_qty());
				row.createCell(4).setCellValue(list.get(i).getTotal_qty());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=InOutCount" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	//------------------日入库明细记录--------------------------------------
	public Map<String,Object> queryViewWorkInList(ViewWorkInBean viewWorkIn) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<ViewWorkInBean> list=reportQueryDao.queryViewWorkInList(viewWorkIn);
			int count =reportQueryDao.getViewWorkInCount(viewWorkIn);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportViewWorkInList(ViewWorkInBean viewWorkIn, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("日入库明细查询");

			sheet.setColumnWidth(0, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((25 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((38 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((45 + 0.72) * 256));
			sheet.setColumnWidth(7, (int) ((8 + 0.72) * 256));
			sheet.setColumnWidth(8, (int) ((20 + 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("单位");
			rows.createCell(7).setCellValue("托盘码");
			rows.createCell(8).setCellValue("用户ID");

			List<ViewWorkInBean> list = reportQueryDao.getViewWorkInAll(viewWorkIn);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getIo_time());
				row.createCell(1).setCellValue(list.get(i).getLoc_no());
				row.createCell(2).setCellValue(list.get(i).getMatnr());
				row.createCell(3).setCellValue(list.get(i).getMaktx());
				row.createCell(4).setCellValue(list.get(i).getWerks());
				row.createCell(5).setCellValue(list.get(i).getAnfme());
				row.createCell(6).setCellValue(list.get(i).getAltme());
				row.createCell(7).setCellValue(list.get(i).getZpallet());
				row.createCell(8).setCellValue(list.get(i).getBname());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=DailyStore" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	//------------------日出库明细记录--------------------------------------
	public Map<String,Object> queryViewWorkOutList(ViewWorkInBean viewWorkOut) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<ViewWorkInBean> list=reportQueryDao.queryViewWorkOutList(viewWorkOut);
			int count =reportQueryDao.getViewWorkOutCount(viewWorkOut);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportViewWorkOutList(ViewWorkInBean viewWorkOut, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("日出库明细查询");

			sheet.setColumnWidth(0, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((25 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((38 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((45 + 0.72) * 256));
			sheet.setColumnWidth(7, (int) ((8 + 0.72) * 256));
			sheet.setColumnWidth(8, (int) ((20 + 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("单位");
			rows.createCell(7).setCellValue("托盘码");
			rows.createCell(8).setCellValue("用户ID");
			
			List<ViewWorkInBean> list = reportQueryDao.getViewWorkOutAll(viewWorkOut);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getIo_time());
				row.createCell(1).setCellValue(list.get(i).getLoc_no());
				row.createCell(2).setCellValue(list.get(i).getMatnr());
				row.createCell(3).setCellValue(list.get(i).getMaktx());
				row.createCell(4).setCellValue(list.get(i).getWerks());
				row.createCell(5).setCellValue(list.get(i).getAnfme());
				row.createCell(6).setCellValue(list.get(i).getAltme());
				row.createCell(7).setCellValue(list.get(i).getZpallet());
				row.createCell(8).setCellValue(list.get(i).getBname());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=DailyRetrieve" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	//------------------库存MAP图--------------------------------------
	public Map<String,Object> queryViewLocMapList(ViewLocMapBean viewLocMap) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<ViewLocMapBean> list = new ArrayList<ViewLocMapBean>();
			String row1 = String.format("%02d", Integer.parseInt(viewLocMap.getRow1()));
			
			List<String> levList = reportQueryDao.getViewLocLevCount(Integer.parseInt(row1));
			for(String lev1 : levList) {
				List<ViewLocMapBean> bayList= reportQueryDao.getViewLocBays(Integer.parseInt(row1),Integer.parseInt(lev1));
				ViewLocMapBean locMap = new ViewLocMapBean();
				locMap.setRowlev(row1+String.format("%02d", Integer.parseInt(lev1)));
				int i=0;
//				if(Integer.parseInt(lev1)>3){
//					i = i+1;
//					locMap.setL001(bayList.get(i-1).getLoc_sts());
//					locMap.setL087(bayList.get(i+85).getLoc_sts());
//				}
				
				locMap.setL002(bayList.get(i).getLoc_sts());
				locMap.setL003(bayList.get(i+1).getLoc_sts());
				locMap.setL004(bayList.get(i+2).getLoc_sts());
				locMap.setL005(bayList.get(i+3).getLoc_sts());
				locMap.setL006(bayList.get(i+4).getLoc_sts());
				locMap.setL007(bayList.get(i+5).getLoc_sts());
				locMap.setL008(bayList.get(i+6).getLoc_sts());
				locMap.setL009(bayList.get(i+7).getLoc_sts());
				locMap.setL010(bayList.get(i+8).getLoc_sts());
				locMap.setL011(bayList.get(i+9).getLoc_sts());
				locMap.setL012(bayList.get(i+10).getLoc_sts());
				locMap.setL013(bayList.get(i+11).getLoc_sts());
				locMap.setL014(bayList.get(i+12).getLoc_sts());
				locMap.setL015(bayList.get(i+13).getLoc_sts());
				locMap.setL016(bayList.get(i+14).getLoc_sts());
				locMap.setL017(bayList.get(i+15).getLoc_sts());
				locMap.setL018(bayList.get(i+16).getLoc_sts());
				locMap.setL019(bayList.get(i+17).getLoc_sts());
				locMap.setL020(bayList.get(i+18).getLoc_sts());
				locMap.setL021(bayList.get(i+19).getLoc_sts());
				locMap.setL022(bayList.get(i+20).getLoc_sts());
				locMap.setL023(bayList.get(i+21).getLoc_sts());
				locMap.setL024(bayList.get(i+22).getLoc_sts());
				locMap.setL025(bayList.get(i+23).getLoc_sts());
				locMap.setL026(bayList.get(i+24).getLoc_sts());
				locMap.setL027(bayList.get(i+25).getLoc_sts());
				locMap.setL028(bayList.get(i+26).getLoc_sts());
				locMap.setL029(bayList.get(i+27).getLoc_sts());
				locMap.setL030(bayList.get(i+28).getLoc_sts());
				locMap.setL031(bayList.get(i+29).getLoc_sts());
				locMap.setL032(bayList.get(i+30).getLoc_sts());
				locMap.setL033(bayList.get(i+31).getLoc_sts());
				locMap.setL034(bayList.get(i+32).getLoc_sts());
				locMap.setL035(bayList.get(i+33).getLoc_sts());
				locMap.setL036(bayList.get(i+34).getLoc_sts());
				locMap.setL037(bayList.get(i+35).getLoc_sts());
				locMap.setL038(bayList.get(i+36).getLoc_sts());
				locMap.setL039(bayList.get(i+37).getLoc_sts());
				locMap.setL040(bayList.get(i+38).getLoc_sts());
				locMap.setL041(bayList.get(i+39).getLoc_sts());
				locMap.setL042(bayList.get(i+40).getLoc_sts());
				locMap.setL043(bayList.get(i+41).getLoc_sts());
				locMap.setL044(bayList.get(i+42).getLoc_sts());
				locMap.setL045(bayList.get(i+43).getLoc_sts());
				locMap.setL046(bayList.get(i+44).getLoc_sts());
				locMap.setL047(bayList.get(i+45).getLoc_sts());
//				locMap.setL048(bayList.get(i+46).getLoc_sts());
//				locMap.setL049(bayList.get(i+47).getLoc_sts());
//				locMap.setL050(bayList.get(i+48).getLoc_sts());
//				locMap.setL051(bayList.get(i+49).getLoc_sts());
//				locMap.setL052(bayList.get(i+50).getLoc_sts());
//				locMap.setL053(bayList.get(i+51).getLoc_sts());
//				locMap.setL054(bayList.get(i+52).getLoc_sts());
//				locMap.setL055(bayList.get(i+53).getLoc_sts());
//				locMap.setL056(bayList.get(i+54).getLoc_sts());
//				locMap.setL057(bayList.get(i+55).getLoc_sts());
//				locMap.setL058(bayList.get(i+56).getLoc_sts());
//				locMap.setL059(bayList.get(i+57).getLoc_sts());
//				locMap.setL060(bayList.get(i+58).getLoc_sts());
//				locMap.setL061(bayList.get(i+59).getLoc_sts());
//				locMap.setL062(bayList.get(i+60).getLoc_sts());
//				locMap.setL063(bayList.get(i+61).getLoc_sts());
//				locMap.setL064(bayList.get(i+62).getLoc_sts());
//				locMap.setL065(bayList.get(i+63).getLoc_sts());
//				locMap.setL066(bayList.get(i+64).getLoc_sts());
//				locMap.setL067(bayList.get(i+65).getLoc_sts());
//				locMap.setL068(bayList.get(i+66).getLoc_sts());
//				locMap.setL069(bayList.get(i+67).getLoc_sts());
//				locMap.setL070(bayList.get(i+68).getLoc_sts());
//				locMap.setL071(bayList.get(i+69).getLoc_sts());
//				locMap.setL072(bayList.get(i+70).getLoc_sts());
//				locMap.setL073(bayList.get(i+71).getLoc_sts());
//				locMap.setL074(bayList.get(i+72).getLoc_sts());
//				locMap.setL075(bayList.get(i+73).getLoc_sts());
//				locMap.setL076(bayList.get(i+74).getLoc_sts());
//				locMap.setL077(bayList.get(i+75).getLoc_sts());
//				locMap.setL078(bayList.get(i+76).getLoc_sts());
//				locMap.setL079(bayList.get(i+77).getLoc_sts());
//				locMap.setL080(bayList.get(i+78).getLoc_sts());
//				locMap.setL081(bayList.get(i+79).getLoc_sts());
//				locMap.setL082(bayList.get(i+80).getLoc_sts());
//				locMap.setL083(bayList.get(i+81).getLoc_sts());
//				locMap.setL084(bayList.get(i+82).getLoc_sts());
//				locMap.setL085(bayList.get(i+83).getLoc_sts());
//				locMap.setL086(bayList.get(i+84).getLoc_sts());
				
				list.add(locMap);
			}
			map.put("rows", list);
			map.put("total", levList.size());
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
//	public Map<String,Object> queryViewLocMapList(ViewLocMapBean viewLocMap) {
//		try {
//			Map<String,Object> map=new HashMap<String, Object>();
//			List<ViewLocMapBean> list=reportQueryDao.queryViewLocMapList(viewLocMap);
//			int count =reportQueryDao.getViewLocMapCount(viewLocMap);
//			map.put("rows", list);
//			map.put("total", count);
//			return map;
//		}catch(Exception e) {
//			System.out.println(e.getMessage());
//			System.out.println(e.getMessage());
//			return null;
//		}
//	}
	
	/**
	 * 库位占用图表
	 */
	public LocChartPie getLocUseRate() {
		try {
			LocChartPie locUseRate = reportQueryDao.getLocUseRate();
			return locUseRate;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 入出曲线统计图
	 */
	public List<WorkChartAxis> getChartAxis(){
		List<WorkChartAxis> list = new ArrayList<WorkChartAxis>();
		try {
			list = reportQueryDao.getChartAxis();
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return list;
	}
	
	//------------------堆垛机异常记录--------------------------------------
	public Map<String,Object> queryCrnErrorList(PlcCommandBean plcCommand) {
		try {
			Map<String,Object> map=new HashMap<String, Object>();
			List<PlcCommandBean> list=reportQueryDao.queryCrnErrorList(plcCommand);
			int count =reportQueryDao.getCrnErrorCount(plcCommand);
			map.put("rows", list);
			map.put("total", count);
			return map;
		}catch(Exception e) {
			System.out.println(e.getMessage());
			System.out.println(e.getMessage());
			return null;
		}
	}
	//导出excel
	public void ExportCrnErrorList(PlcCommandBean plcCommand, HttpServletResponse response) {
		// 输出Excel文件
		try {
			// HSSFWorkbook对象(excel的文档对象)
			HSSFWorkbook workBook = new HSSFWorkbook();

			// sheet对象（excel的表单）
			HSSFSheet sheet = workBook.createSheet("堆垛机异常记录");

			sheet.setColumnWidth(0, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(1, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(2, (int) ((20 + 0.72) * 256));
			sheet.setColumnWidth(3, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(4, (int) ((15 + 0.72) * 256));
			sheet.setColumnWidth(5, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(6, (int) ((10 + 0.72) * 256));
			sheet.setColumnWidth(7, (int) ((10 + 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("发生时间");
			rows.createCell(7).setCellValue("工作档时间");

			List<PlcCommandBean> list = reportQueryDao.getCrnErrorAll(plcCommand);
			for (int i = 0; i < list.size(); i++) {
				HSSFRow row = sheet.createRow(i + 1);// 从第三行开始
				// 创建单元格并设置单元格内容
				row.createCell(0).setCellValue(list.get(i).getIo_time());
				row.createCell(1).setCellValue(list.get(i).getDev_no());
				row.createCell(2).setCellValue(list.get(i).getWrk_no());
				row.createCell(3).setCellValue(list.get(i).getS_location());
				row.createCell(4).setCellValue(list.get(i).getErr_name());
				row.createCell(5).setCellValue(list.get(i).getO_location());
				row.createCell(6).setCellValue(list.get(i).getModi_time());
				row.createCell(7).setCellValue(list.get(i).getWrk_time());
			}
			// //输出Excel文件
			// try {
			OutputStream output = response.getOutputStream();
			response.reset();
			response.setHeader("Content-disposition",
					"attachment; filename=CrnError" + DateTimeUtil.getStringDateTime(14) + ".xls");
			response.setContentType("application/msexcel");
			workBook.write(output);
			output.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}