From 2fbce7d8c0b7e5b055bb7ab77e58b1ec9ce61885 Mon Sep 17 00:00:00 2001
From: admin <15939171744@163.com>
Date: 星期一, 24 六月 2024 19:00:22 +0800
Subject: [PATCH] 1，优化人工工位参数采集temp表删除方法 pushGeelycvMesFeedback 2，优化人工工位更新过站记录方法 workpieceRelease 3，优化未绑定小车码弹框提示 4，优化人工工位扫码重复会添加参数采集记录的问题及拧紧数据会添加上物料采集上的问题
---
jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java | 135 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 135 insertions(+), 0 deletions(-)
diff --git a/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java b/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java
index fb467e3..f645c2e 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/om/productionOrde/controller/OmProductionOrdeInfoController.java
@@ -1,11 +1,26 @@
package com.jcdm.main.om.productionOrde.controller;
+import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
+import cn.hutool.json.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.jcdm.common.core.domain.entity.SysUser;
+import com.jcdm.common.core.domain.model.LoginUser;
+import com.jcdm.common.utils.ServletUtils;
+import com.jcdm.common.utils.StringUtils;
import com.jcdm.main.om.productionOrde.domain.OmProductionOrdeInfo;
+import com.jcdm.main.om.productionOrde.domain.OmProductionOrdeInfoExcelImport;
+import com.jcdm.main.om.productionOrde.mapper.OmProductionOrdeInfoMapper;
import com.jcdm.main.om.productionOrde.service.IOmProductionOrdeInfoService;
+import com.jcdm.main.restful.factoryMes.service.RestfulService;
+import lombok.extern.slf4j.Slf4j;
+import org.aspectj.weaver.loadtime.Aj;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
@@ -22,6 +37,7 @@
import com.jcdm.common.enums.BusinessType;
import com.jcdm.common.utils.poi.ExcelUtil;
import com.jcdm.common.core.page.TableDataInfo;
+import org.springframework.web.multipart.MultipartFile;
/**
* 鐢熶骇宸ュ崟Controller
@@ -29,10 +45,13 @@
* @author ruimin
* @date 2023-12-11
*/
+@Slf4j
@RestController
@RequestMapping("/om/productionOrde")
public class OmProductionOrdeInfoController extends BaseController
{
+ private static final Logger logger = LoggerFactory.getLogger("sys-user");
+
@Autowired
private IOmProductionOrdeInfoService omProductionOrdeInfoService;
@@ -49,6 +68,37 @@
return getDataTable(list);
}
+ @GetMapping("/checkCarCode")
+ public AjaxResult checkCarCode(OmProductionOrdeInfo omProductionOrdeInfo)
+ {
+ Integer i = 0;
+ List<OmProductionOrdeInfo> list = omProductionOrdeInfoService.list(new LambdaQueryWrapper<OmProductionOrdeInfo>().eq(OmProductionOrdeInfo::getProductNum, omProductionOrdeInfo.getProductNum()));
+ if(StringUtils.isNotBlank(list.get(0).getTrolleyYard())){
+ i = 1;
+ }
+ return AjaxResult.success(i);
+ }
+
+ @GetMapping("/checkYzSfcCode")
+ public AjaxResult checkYzSfcCode(OmProductionOrdeInfo omProductionOrdeInfo)
+ {
+ Integer i = 0;
+ List<OmProductionOrdeInfo> list = omProductionOrdeInfoService.list(new LambdaQueryWrapper<OmProductionOrdeInfo>().eq(OmProductionOrdeInfo::getProductNum, omProductionOrdeInfo.getProductNum()));
+ if(StringUtils.isNotBlank(list.get(0).getSpareField2())){
+ i = 1;
+ }
+ return AjaxResult.success(i);
+ }
+
+ @GetMapping("/bindYzSfcFlag")
+ public AjaxResult bindYzSfcFlag(OmProductionOrdeInfo omProductionOrdeInfo)
+ {
+ List<OmProductionOrdeInfo> list = omProductionOrdeInfoService.list(new LambdaQueryWrapper<OmProductionOrdeInfo>().eq(OmProductionOrdeInfo::getProductNum, omProductionOrdeInfo.getProductNum()));
+ list.get(0).setSpareField2("1");
+ omProductionOrdeInfoService.saveOrUpdate(list.get(0));
+ return AjaxResult.success(null);
+ }
+
/**
* 瀵煎嚭鐢熶骇宸ュ崟鍒楄〃
*/
@@ -60,6 +110,53 @@
List<OmProductionOrdeInfo> list = omProductionOrdeInfoService.selectOmProductionOrdeInfoList(omProductionOrdeInfo);
ExcelUtil<OmProductionOrdeInfo> util = new ExcelUtil<OmProductionOrdeInfo>(OmProductionOrdeInfo.class);
util.exportExcel(response, list, "鐢熶骇宸ュ崟鏁版嵁");
+ }
+
+ @GetMapping("/receivingWorkOrders")
+ public AjaxResult receivingWorkOrders()
+ {
+ String paramProductNum = "";
+ // 鏌ヨ鏈�鏂扮殑宸ュ崟淇℃伅
+ List<OmProductionOrdeInfo> list = omProductionOrdeInfoService.list(new LambdaQueryWrapper<OmProductionOrdeInfo>().orderByAsc(OmProductionOrdeInfo::getCreateTime));
+ if(list.size() > 0){
+ paramProductNum = list.get(list.size()-1).getProductNum();
+ }
+ String orderJsonString = RestfulService.getProductionWorkOrderRequest(paramProductNum, "OP230");
+ JSONObject jsonObject = new JSONObject(orderJsonString);
+ // 浠嶫SONObject涓幏鍙杁ata瀵硅薄
+ JSONObject dataObject = jsonObject.getJSONObject("data");
+ String code = jsonObject.getStr("code");
+ // 鍒ゆ柇鎺ュ崟鏄惁鎴愬姛
+ if(code.equals("success")){
+ logger.info("璇锋眰宸ュ巶MES宸ュ崟锛氬叆鍙俻ack{}鍑哄弬pack锛歿}",paramProductNum,dataObject.getStr("productNum"));
+ List<OmProductionOrdeInfo> check = omProductionOrdeInfoService.list(new LambdaQueryWrapper<OmProductionOrdeInfo>().eq(OmProductionOrdeInfo::getProductNum,dataObject.getStr("productNum")));
+ if(check.size() == 0){
+ OmProductionOrdeInfo omProductionOrdeInfo = new OmProductionOrdeInfo();
+ omProductionOrdeInfo.setWorkOrderNo(dataObject.getStr("productionOrderNum"));
+ omProductionOrdeInfo.setProductNum(dataObject.getStr("productNum"));
+ omProductionOrdeInfo.setStationCode(dataObject.getStr("stationCode"));
+ omProductionOrdeInfo.setMaterialCode(dataObject.getStr("materialCode"));
+ if(dataObject.getStr("model").equals("PE01A")){
+ omProductionOrdeInfo.setProductCode("1P102S");
+ }else {
+ omProductionOrdeInfo.setProductCode(dataObject.getStr("model"));
+ }
+ omProductionOrdeInfo.setCreateTime(new Date());
+ omProductionOrdeInfo.setCreateUser("宸ュ巶MES");
+ omProductionOrdeInfoService.save(omProductionOrdeInfo);
+ }
+ }else {
+ return AjaxResult.error("鎺ュ崟澶辫触,璇疯仈绯荤鐞嗗憳");
+ }
+ return AjaxResult.success(dataObject.getStr("productNum"));
+ }
+
+ @GetMapping(value = "/jieBang/{id}")
+ public AjaxResult jieBang(@PathVariable("id") Long id)
+ {
+ OmProductionOrdeInfo byId = omProductionOrdeInfoService.getById(id);
+ byId.setTrolleyYard("");
+ return success(omProductionOrdeInfoService.saveOrUpdate(byId));
}
/**
@@ -114,4 +211,42 @@
{
return omProductionOrdeInfoService.upDownMove(omProductionOrdeInfo);
}
+
+ @PostMapping("/importData")
+ public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
+ {
+ ExcelUtil<OmProductionOrdeInfo> util = new ExcelUtil<OmProductionOrdeInfo>(OmProductionOrdeInfo.class);
+ List<OmProductionOrdeInfo> ordeInfo = util.importExcel(file.getInputStream());
+ for (OmProductionOrdeInfo omProductionOrdeInfo : ordeInfo) {
+ omProductionOrdeInfo.setCreateTime(new Date());
+ omProductionOrdeInfo.setCreateBy("宸ュ巶MES");
+ }
+ omProductionOrdeInfoService.overrideSaveBatch(ordeInfo);
+ return AjaxResult.success();
+ }
+
+ @PostMapping("/importTemplate")
+ public void importTemplate(HttpServletResponse response)
+ {
+ ExcelUtil<OmProductionOrdeInfoExcelImport> util = new ExcelUtil<OmProductionOrdeInfoExcelImport>(OmProductionOrdeInfoExcelImport.class);
+ util.importTemplateExcel(response, "璁㈠崟鏁版嵁");
+ }
+
+ @PostMapping("/trolleyYardBinDing")
+ public AjaxResult trolleyYardBinDing(@RequestBody OmProductionOrdeInfo omProductionOrdeInfo)
+ {
+ return omProductionOrdeInfoService.trolleyYardBinDing(omProductionOrdeInfo);
+ }
+
+ @PostMapping("/getCarCodeSize")
+ public AjaxResult getCarCodeSize(@RequestBody OmProductionOrdeInfo omProductionOrdeInfo)
+ {
+ return omProductionOrdeInfoService.getCarCodeSize(omProductionOrdeInfo);
+ }
+
+ @PostMapping("/findBytrolleyYardGetOne")
+ public AjaxResult findBytrolleyYardGetOne(@RequestBody OmProductionOrdeInfo omProductionOrdeInfo)
+ {
+ return omProductionOrdeInfoService.findBytrolleyYardGetOne(omProductionOrdeInfo);
+ }
}
--
Gitblit v1.9.3