package com.slcf.controller;
|
|
import java.util.Map;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
|
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.pojo.UserBean;
|
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.bean.LocDetailCondition;
|
import com.slcf.pojo.AdjDetailBean;
|
import com.slcf.pojo.PlcCommandBean;
|
import com.slcf.pojo.SysLogBean;
|
import com.slcf.service.LocDetailService;
|
import com.slcf.service.ReportQueryService;
|
import com.slcf.service.RoleService;
|
import com.slcf.service.SysLogService;
|
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;
|
|
@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());
|
}
|
}
|
}
|
