package com.zbooksoft.gdmis.controller;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
|
import com.ruili.wcp.common.StringUtil;
|
import com.ruili.wcp.data.entity.config.View;
|
import com.ruili.wcp.data.entity.management.User;
|
import com.ruili.wcp.engine.form.IFormData;
|
import com.ruili.wcp.service.config.ModuleService;
|
import com.ruili.wcp.service.config.ViewService;
|
import com.ruili.wcp.web.model.AjaxResponse;
|
import org.apache.shiro.SecurityUtils;
|
import org.apache.shiro.authz.annotation.RequiresUser;
|
import org.apache.shiro.session.Session;
|
import org.apache.shiro.subject.Subject;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.RequestBody;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
import org.springframework.web.servlet.ModelAndView;
|
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Description
|
* @Author fsr
|
* @Date 2020/12/12
|
* 扫描枪分发
|
**/
|
@Controller
|
@RequestMapping("/scanPrintController")
|
public class ScanPrintController {
|
|
private static final Logger logger = LoggerFactory.getLogger(ScanPrintController.class);
|
|
@Autowired
|
ModuleService moduleService;
|
|
|
@Autowired
|
IFormData iFormData;
|
|
@Autowired
|
JdbcTemplate jdbcTemplate;
|
|
@Autowired
|
ViewService viewService;
|
|
/**
|
* @Description 出库扫描
|
* @Date 2020/12/12
|
**/
|
@RequestMapping(value = "/outScanPrint")
|
public ModelAndView outScanPrint(Long viewId) {
|
ModelAndView modelAndView = new ModelAndView();
|
modelAndView.setViewName("scanPrint/scanPrint");
|
modelAndView.addObject("viewId", viewId);
|
modelAndView.addObject("printType", 1);
|
return modelAndView;
|
}
|
|
/**
|
* @Description 归还扫描
|
* @Date 2020/12/12
|
**/
|
@RequestMapping(value = "/returnScanPrint")
|
public ModelAndView returnScanPrint(Long viewId) {
|
ModelAndView modelAndView = new ModelAndView();
|
modelAndView.setViewName("scanPrint/returnPrint");
|
modelAndView.addObject("viewId", viewId);
|
|
modelAndView.addObject("printType", 2);
|
return modelAndView;
|
}
|
|
/**
|
* @Description 入库扫描
|
* @Date 2020/12/12
|
**/
|
@RequestMapping(value = "/inScanPrint")
|
public ModelAndView inScanPrint(Long viewId) {
|
ModelAndView modelAndView = new ModelAndView();
|
modelAndView.setViewName("scanPrint/scanInPrint");
|
modelAndView.addObject("viewId", viewId);
|
modelAndView.addObject("printType", 0);
|
return modelAndView;
|
//ARCHIVAL_TYPE
|
}
|
|
/**
|
* @Description 保存扫描枪数据
|
* @Date 2020/12/12
|
* printType 扫描类型 1.出 0. 进
|
* operationType 操作类型 1 出入库 2 销毁
|
**/
|
@RequestMapping(value = "/saveScanPrintData")
|
@RequiresUser
|
@ResponseBody
|
public Object saveScanPrintData(@RequestBody List<Map<String, Object>> data, int printType, Long viewId, String boxNum) {
|
Subject currentUser = SecurityUtils.getSubject();
|
Session session = currentUser.getSession();
|
User user = (User) session.getAttribute("user");
|
|
|
try {
|
View view = viewService.getViewById(viewId);
|
String mainTableName = view.getMainTableName();
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
if (data != null && data.size() > 0) {
|
if (printType == 0) { //入库扫描
|
updateWarehousing(data, boxNum);
|
}
|
if (printType == 1) { //出库
|
outWarehousing(data);
|
}
|
if (printType == 2) { //归还
|
returnWarehousing(data);
|
}
|
}
|
} catch (Exception e) {
|
return new AjaxResponse(false);
|
}
|
return new AjaxResponse(true);
|
}
|
|
private Map<String, Object> getBusinessData(String tableName, String archivalCode) {
|
String sql = "SELECT * FROM " + tableName + " WHERE ARCHIVAL_STATE = 3 AND ARCHIVAL_CODE='" + archivalCode + "'";
|
Map<String, Object> data = null;
|
try {
|
data = jdbcTemplate.queryForMap(sql);
|
} catch (Exception e) {
|
logger.error(e.getMessage());
|
}
|
return data;
|
}
|
|
/**
|
* @Description 入库
|
* @Date 2020/12/13
|
**/
|
private void updateWarehousing(List<Map<String, Object>> data, String boxNum) {
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
//更新出库状态
|
for (int i = 0; i < data.size(); i++) {
|
String archivalCode = (String) data.get(i).get("archival_code");
|
String sqlSelect = "select * from BUS_PACKING_MANAGE where ITEM_NUM = '" + archivalCode + "'";
|
Map<String, Object> packingMap = jdbcTemplate.queryForMap(sqlSelect);
|
|
long itemId = Long.parseLong(packingMap.get("ITEM_ID").toString());
|
String sql = "select * from BUS_WAREHOUSING where item_id =" + itemId + " and IN_STATUS_CODE =2";
|
List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
|
if (mapList.size() > 0) {
|
Map<String, Object> map = mapList.get(0);
|
|
|
Date date = new Date();
|
String format = sdf.format(date);
|
HashMap<String, Object> mapData = new HashMap<>();
|
mapData.put("IN_STATUS_CODE", 3);
|
mapData.put("OUT_STATUS", "已入库");
|
mapData.put("IN_TIME", format);
|
iFormData.update(1972515952908148738L, mapData, Long.parseLong(map.get("ID").toString()));
|
|
String sqlUpdateBox = "update BUS_PACKING_MANAGE SET BOX_NUMBER='" + boxNum + "', ITEM_STATE='已入库' WHERE ID=" + packingMap.get("ID");
|
jdbcTemplate.update(sqlUpdateBox);
|
}
|
}
|
}
|
|
/**
|
* @Description 归还
|
* @Date 2020/12/13
|
**/
|
private void returnWarehousing(List<Map<String, Object>> data) {
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
//更新出库状态
|
for (int i = 0; i < data.size(); i++) {
|
String archivalCode = (String) data.get(i).get("archival_code");
|
String sqlSelect = "select * from BUS_PACKING_MANAGE where ITEM_NUM = '" + archivalCode + "'";
|
Map<String, Object> packingMap = jdbcTemplate.queryForMap(sqlSelect);
|
|
long itemId = Long.parseLong(packingMap.get("ITEM_ID").toString());
|
String sql = "select * from BUS_WAREHOUSING where item_id =" + itemId + " and IN_STATUS_CODE =1";
|
List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
|
if (mapList.size() > 0) {
|
Map<String, Object> map = mapList.get(0);
|
Date date = new Date();
|
String format = sdf.format(date);
|
String sqlUpdate = "update BUS_WAREHOUSING SET IN_STATUS_CODE=2, OUT_STATUS='待入库', IN_TIME='" + format + "' WHERE ID=" + map.get("ID");
|
jdbcTemplate.update(sqlUpdate);
|
|
String sqlUpdateBox = "update BUS_PACKING_MANAGE SET ITEM_STATE='已归还' WHERE ID=" + packingMap.get("ID");
|
jdbcTemplate.update(sqlUpdateBox);
|
}
|
}
|
}
|
|
/**
|
* @Description 出库
|
* @Date 2020/12/13
|
**/
|
private void outWarehousing(List<Map<String, Object>> data) {
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
//更新出库状态
|
for (int i = 0; i < data.size(); i++) {
|
String archivalCode = (String) data.get(i).get("archival_code");
|
String sqlSelect = "select * from BUS_PACKING_MANAGE where ITEM_NUM = '" + archivalCode + "'";
|
List<Map<String, Object>> mapList1 = jdbcTemplate.queryForList(sqlSelect);
|
Map<String, Object> packingMap = null;
|
if (mapList1.size() > 0) {
|
packingMap = mapList1.get(0);
|
}
|
|
long itemId = Long.parseLong(packingMap.get("ITEM_ID").toString());
|
String sql = "select * from BUS_WAREHOUSING where item_id =" + itemId + " and IN_STATUS_CODE =0";
|
List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
|
if (mapList.size() > 0) {
|
Map<String, Object> map = mapList.get(0);
|
|
String boxNumber = packingMap.get("BOX_NUMBER") == null ? "" : packingMap.get("BOX_NUMBER").toString();
|
String storageLocation = packingMap.get("STORAGE_LOCATION") == null ? "" : packingMap.get("STORAGE_LOCATION").toString();
|
Date date = new Date();
|
String format = sdf.format(date);
|
HashMap<String, Object> mapData = new HashMap<>();
|
mapData.put("IN_STATUS_CODE", 1);
|
mapData.put("OUT_STATUS", "已出库");
|
mapData.put("OUT_TIME", format);
|
mapData.put("BOX_NUM", boxNumber);
|
mapData.put("LOCATION_NUMBER", storageLocation);
|
iFormData.update(1972515952908148738L, mapData, Long.parseLong(map.get("ID").toString()));
|
|
String sqlUpdateBox = "update BUS_PACKING_MANAGE SET ITEM_STATE='借出' WHERE ID=" + packingMap.get("ID");
|
jdbcTemplate.update(sqlUpdateBox);
|
}
|
}
|
}
|
|
/**
|
* @Description 保存到销毁库
|
* @Date 2020/12/13
|
**/
|
private void saveToDisposeForm(Map<String, Object> businessData) {
|
|
}
|
|
|
}
|
