package com.zy.asrs.controller; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.core.annotations.AppAuth; import com.core.common.BaseRes; import com.core.common.Cools; import com.core.common.R; import com.core.exception.CoolException; import com.zy.asrs.entity.LocMast; import com.zy.asrs.entity.param.*; import com.zy.asrs.entity.result.OpenInventoryVo; import com.zy.asrs.entity.result.OpenSummaryVo; import com.zy.asrs.entity.result.TokenVo; import com.zy.asrs.mapper.LocDetlMapper; import com.zy.asrs.service.LocDetlService; import com.zy.asrs.service.LocMastService; import com.zy.asrs.service.OpenService; import com.zy.common.service.wms.Result; import com.zy.common.web.BaseController; import com.zy.system.entity.Config; import com.zy.system.service.ConfigService; import lombok.Synchronized; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import java.math.BigDecimal; import java.util.*; import java.util.concurrent.ConcurrentHashMap; import java.util.stream.Collectors; /** * Created by vincent on 2022/4/8 */ @Slf4j @RestController @RequestMapping("open/asrs") public class OpenController extends BaseController { private static final boolean auth = true; public static final ArrayList APP_KEY_LIST = new ArrayList() {{ add("ea1f0459efc02a79f046f982767939ae"); }}; @Autowired private OpenService openService; @Autowired private ConfigService configService; @Autowired private LocMastService locMastService; @Autowired private LocDetlMapper locDetlMapper; @Value("${open-asrs.auth.app-id:wms_8f7c3d126a944e3ab5c89d21f4a7c6b2}") private String openAppId; @Value("${open-asrs.auth.app-secret:D9f3A7xP1kLm8Q2tW5zH0sY6vR4bNcE7FjK3uM9pT2aL8qX6}") private String openAppSecret; @Value("${open-asrs.auth.token-valid-minutes:30}") private Integer tokenValidMinutes; private static final Map TOKEN_CACHE = new ConcurrentHashMap<>(); @Deprecated @PostMapping("/grouping") @AppAuth(memo = "AGV组托调用") public synchronized R grouping(@RequestHeader(required = false) String appkey, @RequestBody(required = false) AgvGroupingParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param.getOrderNo())) { param.setOrderNo(param.getBillNo()); } List combMats = param.getCombMats(); combMats.forEach(elem -> { if (Cools.isEmpty(elem.getBatch())) { elem.setBatch(elem.getItemBatch()); } }); return openService.grouping(param); } @PostMapping("/barcodeVerificatio") @AppAuth(memo = "AGV调用校验条码") public synchronized R barcodeVerificatio(@RequestHeader(required = false) String appkey, @RequestBody(required = false) Map param, HttpServletRequest request) { auth(appkey, param, request); // 托盘条码 String barcode = param.get("barcode"); if (Cools.isEmpty(barcode)) { return R.parse("条码不能为空"); } return openService.barcodeVerificatio(barcode); } @PostMapping("/outbound") @AppAuth(memo = "MES调用出库") public synchronized R outbound(@RequestHeader(required = false) String appkey, @RequestBody(required = false) OutBoundParam param, HttpServletRequest request) { Config mesAuto = configService.selectConfigByCode("CLOSE_OUTBOUND"); if (mesAuto != null && mesAuto.getValue().equals("0")) { return R.parse("关闭自动出库"); } auth(appkey, param, request); if (Cools.isEmpty(param.getEndLocation(), param.getBarcode(), param.getOrderNo())) { return R.parse(BaseRes.PARAM); } return openService.outbound(param); } @PostMapping("/order/matSync/default/v1") @AppAuth(memo = "商品信息同步接口") public synchronized R syncMatInfo(@RequestHeader(required = false) String appkey, @RequestBody(required = false) MatSyncParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } openService.syncMat(param); return R.ok(); } /****************************************************************************/ /********************************* 打包上线 **********************************/ /****************************************************************************/ // @PostMapping("/order/pakin/new/package/v1") // @AppAuth(memo = "打包上线接口") // public synchronized R pakinOrderPackage(@RequestHeader(required = false) String appkey, // @RequestBody(required = false) PackParam param, // HttpServletRequest request) { // auth(appkey, param, request); // if (Cools.isEmpty(param)) { // return R.parse(BaseRes.PARAM); // } // openService.packageUp(param); // return R.ok(); // } /** * 添加入库单 */ @PostMapping("/order/pakin/default/v1") public synchronized R pakinOrderCreate(@RequestHeader(required = false) String appkey, @RequestBody OpenOrderPakinParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } if (Cools.isEmpty(param.getOrderNo())) { return R.error("单据编号[orderNo]不能为空"); } if (Cools.isEmpty(param.getOrderType())) { return R.error("单据类型[orderType]不能为空"); } if (Cools.isEmpty(param.getOrderDetails())) { return R.error("单据明细[orderDetails]不能为空"); } //openService.pakinOrderCreate(param); return R.ok(); } /** * 入库单回写 */ @PostMapping("/order/pakin/complete/default/v1") public synchronized R orderPakinComplete(@RequestHeader(required = false) String appkey, @RequestBody(required = false) OpenOrderCompleteParam param, HttpServletRequest request) { auth(appkey, param, request); return R.ok().add(openService.pakinOrderComplete(param)); } /** * 添加出库单 */ @PostMapping("/order/pakout/default/v1") @AppAuth(memo = "添加订单出库") public synchronized R pakoutOrderCreate(@RequestHeader(required = false) String appkey, @RequestBody OpenOrderPakoutParam param, HttpServletRequest request) { auth(appkey, param, request); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } if (Cools.isEmpty(param.getLgort())) { return R.error("单据编号[lgort]不能为空"); } if (!param.getLgort().equals("5006")) { return R.ok(); } if (Cools.isEmpty(param.getOrderNo())) { return R.error("单据编号[orderNo]不能为空"); } if (Cools.isEmpty(param.getOrderType())) { return R.error("单据类型[orderType]不能为空"); } if (Cools.isEmpty(param.getOrderDetails())) { return R.error("单据明细[orderDetails]不能为空"); } openService.pakoutOrderCreate(param); return R.ok(); } /** * 出库单回写 */ @PostMapping("/order/pakout/complete/default/v1") public synchronized R orderPakoutComplete(@RequestHeader(required = false) String appkey, @RequestBody(required = false) OpenOrderCompleteParam param, HttpServletRequest request) { auth(appkey, param, request); return R.ok().add(openService.pakoutOrderComplete(param)); } /** * 库存统计 */ @RequestMapping("/stock/default/v1") public R queryStock(@RequestHeader(required = false) String appkey, HttpServletRequest request) { auth(appkey, null, request); return R.ok().add(openService.queryStock()); } /** * 返回库存利用率 */ @Synchronized @PostMapping("/stock/used/v1") public R getRate(@RequestHeader(required = false) String appkey, @RequestBody(required = false) OpenOrderCompleteParam param, HttpServletRequest request) { auth(appkey, param, request); int i = locMastService.selectCount(new EntityWrapper().in("loc_sts", "O")); int i1 = locMastService.selectCount(new EntityWrapper().in("loc_sts", Arrays.asList("D", "F", "P", "Q", "R", "S"))); BigDecimal dividend = new BigDecimal(i1 - i); BigDecimal divisor = new BigDecimal(i1); BigDecimal quotient = dividend.divide(divisor,4, BigDecimal.ROUND_HALF_UP); return R.ok().add(quotient); } private void auth(String appkey, Object obj, HttpServletRequest request) { log.info("{}接口被访问;appkey:{};请求数据:{}", "open/sensorType/list/auth/v1", appkey, JSON.toJSONString(obj)); request.setAttribute("cache", obj); if (!auth) { return; } if (Cools.isEmpty(appkey)) { throw new CoolException("认证失败,请确认appkey无误!"); } if (!APP_KEY_LIST.contains(appkey)) { throw new CoolException("认证失败,请确认appkey无误!"); } } // public static void main(String[] args) { // // 1 // System.out.println("======================================"); // OpenOrderPakinParam param = new OpenOrderPakinParam(); // param.setOrderNo(String.valueOf(new SnowflakeIdWorker().nextId())); // param.setOrderType("打包上线单"); // param.setOrderTime(DateUtils.convert(new Date())); // List orderDetails = new ArrayList<>(); // param.setOrderDetails(orderDetails); // for (int i = 0; i < 3; i++) { // DetlDto detlDto = new DetlDto(locDto); // switch (i) { // case 0: // detlDto.setMatnr("MDH020030530"); // detlDto.setBatch("500"); // detlDto.setAnfme(18.0); // break; // case 1: // detlDto.setMatnr("MDH020016416"); // detlDto.setBatch("500"); // detlDto.setAnfme(32.0); // break; // case 2: // detlDto.setMatnr("LSH90152025"); // detlDto.setAnfme(50.0); // break; // default: // break; // } // orderDetails.add(detlDto); // } // System.out.println(JSON.toJSONString(param)); // // 2 // System.out.println("======================================"); // OpenOrderCompleteParam param1 = new OpenOrderCompleteParam(); // param1.setOrderNo("963001846497017856"); // System.out.println(JSON.toJSONString(param1)); // } /*========================================new Agreement==============================================================*/ /** * 获取token * @param param * @param request * @return */ @PostMapping("/getToken") public synchronized R getToken(@RequestHeader(required = false) String appkey, @RequestBody(required = true) TokenParam param, HttpServletRequest request){ log.info("获取Token:/getToken接口被访问,appkey={},请求数据={}", appkey, JSON.toJSONString(param)); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } String appId = param.getAppId(); String appSecret = param.getAppSecret(); if (Cools.isEmpty(appId)) { return R.error("参数[appId]不能为空"); } if (Cools.isEmpty(appSecret)) { return R.error("参数[appSecret]不能为空"); } if (Cools.isEmpty(openAppId) || Cools.isEmpty(openAppSecret)) { throw new CoolException("系统未配置open-asrs.auth.app-id或open-asrs.auth.app-secret"); } if (!openAppId.equals(appId) || !openAppId.equals(appSecret)) { throw new CoolException("认证失败,请确认appId或appSecret无误!"); } String token = UUID.randomUUID().toString().replace("-", ""); long expireAt = System.currentTimeMillis() + tokenValidMinutes * 60L * 1000L; TOKEN_CACHE.put(token,new TokenVo(appId, expireAt)); Map result = new HashMap<>(); result.put("token", token); result.put("expireAt", expireAt); return R.ok().add(result); } private void authNew(String appkey, Object obj, HttpServletRequest request, String url) { log.info("{}接口被访问;appkey:{};请求数据:{}", url, appkey, JSON.toJSONString(obj)); request.setAttribute("cache", obj); if (!auth) { return; } String authorization = request.getHeader("Authorization"); if (Cools.isEmpty(authorization)) { authorization = request.getHeader("authorization"); } if (!Cools.isEmpty(authorization)) { String val = authorization.trim(); if (val.toLowerCase().startsWith("bearer ")) { int idx = val.indexOf(' '); authorization = idx > -1 ? val.substring(idx + 1).trim() : ""; }else { authorization = val; } } if (!Cools.isEmpty(authorization)) { if (validToken(authorization)){ return; } throw new CoolException("认证失败,请确认Authorization无误!"); } throw new CoolException("认证失败,请确认Authorization无误!"); } public static boolean validToken(String authorization){ if (Cools.isEmpty(authorization)) { return false; } TokenVo tokenInfo = TOKEN_CACHE.get(authorization); if (tokenInfo == null) { return false; } if (System.currentTimeMillis() > tokenInfo.getValidTime()) { TOKEN_CACHE.remove(authorization); return false; } return true; } /** * 物料基础信息同步 * @param appkey * @param param * @param request * @return */ @PostMapping("/erp/mat/sync") public synchronized R syncMatInfoV2(@RequestHeader(required = false) String appKey, @RequestBody(required = false) List param, HttpServletRequest request){ authNew(appKey, param, request, "物料基础信息同步:/erp/mat/sync"); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } MatSyncParam matSyncParam = new MatSyncParam(); List objects = new ArrayList<>(); objects = param; matSyncParam.matDetails = objects; openService.syncMat(matSyncParam); return R.ok(); } /** * 入/出库通知单下发 * @param param * @return */ @PostMapping("/erp/order/add") public synchronized R addOrder(@RequestHeader(required = false) String appKey, @RequestBody OpenOrderParam param, HttpServletRequest request){ authNew(appKey, param, request, "入/出库通知单下发:/erp/order/add"); if (Cools.isEmpty(param)) { return R.parse(BaseRes.PARAM); } if (Cools.isEmpty(param.getOrderNo())){ return R.error("单据编号[orderNo]不能为空"); } if (Cools.isEmpty(param.getOrderType())){ return R.error("单据类型[orderType]不能为空"); } if (Cools.isEmpty(param.getWkType())){ return R.error("业务类型[wkType]不能为空"); } if (Cools.isEmpty(param.getOrderItems())){ return R.error("订单明细[orderItems]不能为空"); } openService.orderCreate(param); return R.ok(); } /** * 库存明细查询 * @param param * @return */ @PostMapping("/erp/inventory/details") public synchronized Result inventory(@RequestHeader(required = false) String appKey, @RequestBody JSONObject param, HttpServletRequest request){ authNew(appKey, param, request, "库存明细查询:/erp/inventory/details"); try { String wareHouseId = param == null ? null : param.getString("wareHouseId"); String locId = param == null ? null : param.getString("locId"); String matNr = param == null ? null : param.getString("matNr"); String orderNo = param == null ? null : param.getString("orderNo"); String batch = param == null ? null : param.getString("batch"); return new Result(200, "操作成功", locDetlMapper.inventory(wareHouseId, locId, matNr, orderNo, batch)); }catch (Exception e){ return new Result(500, e.getMessage(), null); } } /** * 库存汇总查询 * @param param * @return */ @PostMapping("/erp/inventory/summary") public synchronized Result invSummary(@RequestHeader(required = false) String appKey, @RequestBody JSONObject param, HttpServletRequest request){ authNew(appKey, param, request, "库存汇总查询:/erp/inventory/summary"); try { String wareHouseId = param == null ? null : param.getString("wareHouseId"); String matNr = param == null ? null : param.getString("matNr"); Collection matNrs = null; if (!Cools.isEmpty(matNr)){ matNrs = Arrays.stream(matNr.split(",")) .map(String::trim) .filter(s -> !s.isEmpty()) .collect(Collectors.toList()); } return new Result(200, "操作成功", locDetlMapper.invSummary(wareHouseId, matNrs)); }catch (Exception e){ return new Result(500, e.getMessage(), null); } } }