package com.slcf.controller;

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

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

import com.slcf.pojo.*;
import com.slcf.service.*;
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.ResponseBody;

import com.slcf.bean.LocDetailCondition;
import com.slcf.util.AuthorityCode;

/**
 * 日志统计控制器层
 * @author admin
 * @date 2018年11月23日
 */
@Controller
@RequestMapping("/report")
public class ReportQueryController {

	@Resource
	ReportQueryService reportQueryService;
	@Autowired
	SysLogService sysLogService;
	@Autowired
	LocDetailService locDetailService;
	@Autowired
	RoleService roleService;
	@Autowired
	SapRequestLogService sapRequestLogService;

	@RequestMapping("/goViewSapRequestLog.action")
	public String goViewSapRequestLog(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid),
					AuthorityCode.ViewStockUseCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewStockUse.action");
			sysLog.setTts_keyname("访问:SAP请求日志");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "sapRequestLog";
	}

	@RequestMapping("/goViewStockUse.action")
	public String goViewStockUsePage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewStockUseCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewStockUse.action");
			sysLog.setTts_keyname("访问:库位使用率统计");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewStockUse";
	}
	
	@RequestMapping("/goViewStayTime.action")
	public String goViewStayTimePage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewStayTimeCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewStayTime.action");
			sysLog.setTts_keyname("访问:库存滞留时间统计");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewStayTime";
	}
	
	@RequestMapping("/goViewAdjDetail.action")
	public String goViewAdjDetailPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewAdjDetailCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewAdjDetail.action");
			sysLog.setTts_keyname("访问:库存调整记录");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewAdjDetail";
	}
	
	@RequestMapping("/goViewInOut.action")
	public String goViewInOutPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewInOutCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewInOut.action");
			sysLog.setTts_keyname("访问:日入出库次数统计");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewInOut";
	}
	
	@RequestMapping("/goViewWorkIn.action")
	public String goViewWorkInPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewWorkInCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewWorkIn.action");
			sysLog.setTts_keyname("访问:日入库明细");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewWorkIn";
	}
	
	@RequestMapping("/goViewWorkOut.action")
	public String goViewWorkOutPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewWorkOutCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewWorkOut.action");
			sysLog.setTts_keyname("访问:日出库明细");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewWorkOut";
	}
	
	@RequestMapping("/goViewLocMap.action")
	public String goViewLocMapPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewLocMapCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewLocMap.action");
			sysLog.setTts_keyname("访问:库存状态图");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewLocMap";
	}
	
	@RequestMapping("/goViewCrnError.action")
	public String goViewCrnErrorPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.ViewCrnErrorCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goViewCrnError.action");
			sysLog.setTts_keyname("访问:堆垛机异常记录");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "viewCrnError";
	}
	
	//------------------库位使用统计--------------------------------------
	@ResponseBody
	@RequestMapping("/viewStockUseList.action")
	public Map<String,Object> queryViewStockUseListByPages(ViewStockUseBean viewStockUse){
		Map<String,Object>map=reportQueryService.queryViewStockUseList(viewStockUse);
		return map;
	}
	//excel导出
	@RequestMapping("/exportViewStockUse.action")
	public void exportViewStockUse(ViewStockUseBean viewStockUse, HttpServletResponse response,HttpServletRequest request){
		try {
			reportQueryService.ExportViewStockUseList(viewStockUse,response);
			
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("exportViewStockUse.action");
			sysLog.setTts_keyname("导出库位使用率到EXCEL");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
	
	//------------------库存滞留统计--------------------------------------
	@ResponseBody
	@RequestMapping("/viewStayTimeList.action")
	public Map<String,Object> queryViewStayTimeListByPages(ViewStayTimeBean viewStayTime){
		Map<String,Object>map=reportQueryService.queryViewStayTimeList(viewStayTime);
		return map;
	}
	//excel导出
	@RequestMapping("/exportViewStayTime.action")
	public void exportViewStayTime(ViewStayTimeBean viewStayTime, HttpServletResponse response,HttpServletRequest request){
		try {
			reportQueryService.ExportViewStayTimeList(viewStayTime,response);
			
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("exportStayTimeUse.action");
			sysLog.setTts_keyname("导出库存滞留时间");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
	
	//------------------库存调整记录--------------------------------------
	@ResponseBody
	@RequestMapping("/viewAdjDetailList.action")
	public Map<String,Object> queryAdjDetailListByPages(AdjDetailBean adjDetail){
		Map<String,Object>map=reportQueryService.queryAdjDetailList(adjDetail);
		return map;
	}
	//excel导出
	@RequestMapping("/exportViewAdjDetail.action")
	public void exportAdjDetail(AdjDetailBean adjDetail, HttpServletResponse response,HttpServletRequest request){
		try {
			reportQueryService.ExportAdjDetailList(adjDetail,response);
			
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("exportViewAdjDetail.action");
			sysLog.setTts_keyname("导出库存调整记录");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
	
	//------------------站点日入出库次数统计--------------------------------------
	@ResponseBody
	@RequestMapping("/viewInOutList.action")
	public Map<String,Object> queryViewInOutListByPages(ViewInOutBean viewInOut){
		Map<String,Object>map=reportQueryService.queryViewInOutList(viewInOut);
		return map;
	}
	//excel导出
	@RequestMapping("/exportViewInOut.action")
	public void exportViewInOut(ViewInOutBean viewInOut, HttpServletResponse response,HttpServletRequest request){
		try {
			reportQueryService.ExportViewInOutList(viewInOut,response);
			
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("exportViewInOut.action");
			sysLog.setTts_keyname("导出日入出库次数统计");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
	
	//------------------日入库明细统计--------------------------------------
	@ResponseBody
	@RequestMapping("/viewWorkInList.action")
	public Map<String,Object> queryViewWorkInListByPages(ViewWorkInBean viewWorkIn){
		Map<String,Object>map=reportQueryService.queryViewWorkInList(viewWorkIn);
		return map;
	}
	//excel导出
	@RequestMapping("/exportViewWorkIn.action")
	public void exportViewWorkIn(ViewWorkInBean viewWorkIn, HttpServletResponse response,HttpServletRequest request){
		try {
			reportQueryService.ExportViewWorkInList(viewWorkIn,response);
			
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("exportViewWorkIn.action");
			sysLog.setTts_keyname("导出日入库明细");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
	
	//------------------日出库明细统计--------------------------------------
	@ResponseBody
	@RequestMapping("/viewWorkOutList.action")
	public Map<String,Object> queryViewWorkOutListByPages(ViewWorkInBean viewWorkOut){
		Map<String,Object>map=reportQueryService.queryViewWorkOutList(viewWorkOut);
		return map;
	}
	//excel导出
	@RequestMapping("/exportViewWorkOut.action")
	public void exportViewWorkOut(ViewWorkInBean viewWorkOut, HttpServletResponse response,HttpServletRequest request){
		try {
			reportQueryService.ExportViewWorkOutList(viewWorkOut,response);
			
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("exportViewWorkOut.action");
			sysLog.setTts_keyname("导出日出库明细");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
	}
	
	//-----------------库存MAP图--------------------------------------
	@ResponseBody
	@RequestMapping("/viewLocMapList.action")
	public Map<String,Object> queryViewLocMapListByPages(ViewLocMapBean viewLocMap){
		Map<String,Object> map=null;
		try {
			String row1 = viewLocMap.getRow1();
			if(row1!=null && !row1.equals("")) {
				row1 = String.format("%02d", Integer.parseInt(row1));
				viewLocMap.setRow1(row1);
				map = reportQueryService.queryViewLocMapList(viewLocMap);
			}
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return map;
	}
	
	@ResponseBody
	@RequestMapping("/getLocDetailList.action")
	public Map<String,Object> queryLocDetailListByPages(LocDetailCondition locDetailCon){
		Map<String,Object> map= null;
		try {
			String loc_no = locDetailCon.getLoc_no();
			if(loc_no!=null && !loc_no.equals("")) {
				map=locDetailService.queryLocDetailList(locDetailCon);
			}
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return map;
	}
	
	//------------------堆垛机异常记录--------------------------------------
		@ResponseBody
		@RequestMapping("/viewCrnErrorList.action")
		public Map<String,Object> queryCrnErrorListByPages(PlcCommandBean plcCommand){
			Map<String,Object> map=reportQueryService.queryCrnErrorList(plcCommand);
			return map;
		}
		//excel导出
		@RequestMapping("/exportViewCrnError.action")
		public void exportAdjDetail(PlcCommandBean plcCommand, HttpServletResponse response,HttpServletRequest request){
			try {
				reportQueryService.ExportCrnErrorList(plcCommand,response);
				
				// 插入日志
				UserBean user = (UserBean) request.getSession().getAttribute("USER");
				SysLogBean sysLog = new SysLogBean();
				sysLog.setLogin_no(user.getUser_account());
				sysLog.setMachine_ip(request.getRemoteAddr());
				sysLog.setForm_no("exportViewCrnError.action");
				sysLog.setTts_keyname("导出堆垛机异常记录");
				sysLog.setModi_user(user.getUser_account());
				sysLogService.insertSysLog(sysLog);
			}catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
}