src/main/java/com/gs/xky/config/BodyParam.java
@@ -28,7 +28,7 @@ private int[] status; private int logisticsStatus; // private int logisticsStatus; private String deliveryNo; src/main/java/com/gs/xky/entity/MesQaItemsDetect01.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,339 @@ package com.gs.xky.entity; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import java.io.Serializable; import java.math.BigDecimal; import java.util.Date; /** * æ¥æå ¥åºæ£éªè¡¨å¤´ * * @TableName MES_QA_ITEMS_DETECT_01 */ @TableName(value = "MES_QA_ITEMS_DETECT_01") @Data public class MesQaItemsDetect01 implements Serializable { @TableField(exist = false) private static final long serialVersionUID = 1L; /** * */ @TableId private Long id; /** * æ£éªåå· */ private String releaseNo; /** * æ£éªæ¥æ */ private Date fcheckDate; /** * æ£éªäººå */ private String fcheckBy; /** * ç©æç¼ç */ private String itemNo; /** * æ¥ææ°é */ private BigDecimal fbatchQty; /** * æ¥æ¶æ°é */ private String freceQty; /** * ä¾åºåç¼å· */ private String suppNo; /** * 夿³¨ */ private String fngDesc; /** * æ£éªç»æ */ private String fcheckResu; /** * OAè¯å®¡åé¦ */ private String freview; /** * æ£éªæ°´å */ private String sampleSizeNo; /** * æ£éªæ°´å¹³ */ private String fcheckLevel; /** * ææ¶æ°´å¹³ */ private String facLevel; /** * æ½æ£æ°é */ private String checkQty; /** * æ¹æ¬¡å· --å°è´§åå· */ private String lotNo; /** * æ¯å¦æ¨é */ private String fmove; /** * æ¯å¦å¤ç */ private String fhandle; /** * å建人 */ private String createBy; /** * åå»ºæ¥æ */ private Date createDate; /** * æ´æ°äºº */ private String lastupdateBy; /** * æ´æ°æ¥æ */ private Date lastupdateDate; /** * æ¯å¦å®¡æ ¸ */ private Long modify1Flag; /** * å®¡æ ¸äºº */ private String modify1By; /** * å®¡æ ¸æ¥æ */ private Date modify1Date; /** * */ private String factory; /** * XRFæµè¯æ¥åç¼å· */ private String fcheckRepno; /** * ç¬¬ä¸æ¹æ¥å */ private String fthirdRep; /** * æ¯å¦ä½åº */ private Long fcancel; /** * æäº¤æ è¯ */ private Long fsubmit; /** * æ£éªä¾æ® */ private String fcheckAccord; /** * ç±»å(0 æ¥æ 1 å¨åº) */ private Integer ftype; /** * åä½ */ private String itemUnit; /** * åºè´§æ¥æ */ private String outDate; /** * æ¯å¦å æ£ */ private Long fexemption; /** * æ¡£ä½æ å */ private String fgearStand; /** * ä¸è¯æç»å¤çæ¹å¼ */ private String fngHandle; /** * 管çç¼å· */ private String fmanageNo; /** * è½¬æ¢æ°é */ private String fcovertQty; /** * çæ¬ */ private Long fversion; /** * */ private String company; /** * */ private String fsecondResu; /** * æå¤§æ½æ£æ° */ private Long maxCheckQty; /** * ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ */ private Long modify1Flag1; /** * ç¹å®ä¿®æ¹å®¡æ ¸äºº */ private String modify1By1; /** * ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ */ private Date modify1Date1; /** * å°æ¹æ¬¡å· */ private String lotNo1; /** * éè´åå· */ private String lotNo2; /** * 产ååå· */ private String boardStyle; /** * ä»»å¡åå· */ private String workNo; /** * å°è´§æ¶é´ */ private String dha018; /** * è¡å· */ private Long dhb002; /** * å°è´§åå· */ private String dhb001; /** * ä¾åºå */ private String lifnr; /** * éææ¹å¼ */ private String fmrmode; /** * erpè¿åä¿¡æ¯ */ private String msg; /** * ç¶æ */ private String states; /** * IQCæäº¤æ¶é´ */ private Date iqcDate; /** * éè´è®¢åID */ private Long ebelnK3id; /** * éè´è®¢åè¡ID */ private Long lineK3id; /** * åè´¨å®¡æ ¸æ è¯ */ private Long qualityAudit; /** * ç©æID */ private Long itemId; /** * éªæ¶æ° */ private Long yansNum; /** * éªéæ° */ private Long yantNum; /** * éè´å®¡æ ¸æ è¯ */ private Long cgAudit; /** * éè´æè§ */ private String cgOpinion; /** * éè´å¤çæ¹å¼ */ private String cgHandle; /** * åè´¨æè§ */ private String qcOpinion; /** * åè´¨å¤çæ¹å¼ */ private String qcHandle; /** * ç»çå®¡æ ¸æ è¯ */ private Long managerAudit; /** * ç»çæè§ */ private String managerOpinion; /** * ç»çå¤çæ¹å¼ */ private String managerHandle; /** * éå®è®¢å */ private String salesOrder; /** * éè´å®¡æ ¸äºº */ private String cgUser; /** * åè´¨å®¡æ ¸äºº */ private String qcUser; /** * ç»çå®¡æ ¸äºº */ private String managerUser; /** * 计åè·è¸ªå· */ private String fmtono; /** * å®éªå®¤éæ£æ è¯ */ private Long isSj; /** * å®éªå®¤éæ£åå· */ private String sjNo; } src/main/java/com/gs/xky/entity/MesQaItemsDetectDetail12.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,70 @@ package com.gs.xky.entity; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * IQCæ£éª * * @TableName MES_QA_ITEMS_DETECT_DETAIL12 */ @TableName(value = "MES_QA_ITEMS_DETECT_DETAIL12") @Data public class MesQaItemsDetectDetail12 implements Serializable { @TableField(exist = false) private static final long serialVersionUID = 1L; /** * */ @TableId private Long id; /** * æ£éªç»æ */ private String fcheckResu; /** * æ£éªé¡¹ç® */ private String fcheckItem; /** * ç©ææ¡ç */ private String itemBarcode; /** * */ private String releaseNo; /** * */ private Long mainId; /** * */ private Date createDate; /** * */ private String company; /** * */ private String factory; /** * */ private String fstand; /** * çæäºº */ private String lastupdateBy; /** * */ private String createBy; } src/main/java/com/gs/xky/entity/MesQaItemsDetectDetail5.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,135 @@ package com.gs.xky.entity; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import java.io.Serializable; import java.math.BigDecimal; import java.util.Date; /** * æ¥ææ£éªä»è¡¨ * * @TableName MES_QA_ITEMS_DETECT_DETAIL5 */ @TableName(value = "MES_QA_ITEMS_DETECT_DETAIL5") @Data public class MesQaItemsDetectDetail5 implements Serializable { @TableField(exist = false) private static final long serialVersionUID = 1L; /** * */ @TableId private Long id; /** * æ åå¼ç±»å */ private String ftextType; /** * æ åå¼ */ private Long fstand; /** * ä¸å ¬å·® */ private String fupAllow; /** * ä¸å ¬å·® */ private String fdownAllow; /** * æ£éªæ°´å */ private String sampleSizeNo; /** * æ£éªæ°´å¹³ */ private String fcheckLevel; /** * ææ¶æ°´å¹³ */ private String facLevel; /** * æ£éªé¡¹ç® */ private String fcheckItem; /** * è§æ ¼è¦æ± */ private String fspecRequ; /** * æ½æ£æ°é */ private Long checkQyt; /** * æ£éªç»æ */ private String fcheckResu; /** * ACæ°é */ private Long facQty; /** * REæ°é */ private Long freQty; /** * ä¸åæ ¼æ° */ private Long fngQty; /** * ä¸è¯ç */ private BigDecimal fngRate; /** * å·²å½å ¥æ°é */ private BigDecimal fenterQty; /** * */ private String releaseNo; /** * */ private String company; /** * */ private String factory; /** * æ£éªé¡¹ç®æè¿° */ private String fcheckItemDesc; /** * å·¥åºå· */ private String procNo; /** * å·¥ä½ä¸å¿ç¼ç */ private String workshopCenterCode; /** * åä½ */ private String funit; /** * ç¹å®ä¿®æ¹ */ private Integer givenModify; /** * æ£éªå·¥å · */ private String fcheckTool; /** * æ´æ°äºº */ private String lastupdateBy; /** * æ´æ°æ¶é´ */ private Date lastupdateDate; } src/main/java/com/gs/xky/mapper/MesQaItemsDetect01Mapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,18 @@ package com.gs.xky.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.gs.xky.entity.MesQaItemsDetect01; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_01(æ¥æå ¥åºæ£éªè¡¨å¤´)ãçæ°æ®åºæä½Mapper * @createDate 2025-02-17 12:53:02 * @Entity com.gs.xky.entity.MesQaItemsDetect01 */ public interface MesQaItemsDetect01Mapper extends BaseMapper<MesQaItemsDetect01> { } src/main/java/com/gs/xky/mapper/MesQaItemsDetectDetail12Mapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,18 @@ package com.gs.xky.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.gs.xky.entity.MesQaItemsDetectDetail12; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_DETAIL12(IQCæ£éª)ãçæ°æ®åºæä½Mapper * @createDate 2025-02-17 12:53:29 * @Entity com.gs.xky.entity.MesQaItemsDetectDetail12 */ public interface MesQaItemsDetectDetail12Mapper extends BaseMapper<MesQaItemsDetectDetail12> { } src/main/java/com/gs/xky/mapper/MesQaItemsDetectDetail5Mapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,18 @@ package com.gs.xky.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.gs.xky.entity.MesQaItemsDetectDetail5; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_DETAIL5(æ¥ææ£éªä»è¡¨)ãçæ°æ®åºæä½Mapper * @createDate 2025-02-17 12:53:24 * @Entity com.gs.xky.entity.MesQaItemsDetectDetail5 */ public interface MesQaItemsDetectDetail5Mapper extends BaseMapper<MesQaItemsDetectDetail5> { } src/main/java/com/gs/xky/service/Impl/MesQaItemsDetect01ServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,62 @@ package com.gs.xky.service.Impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.gs.xky.entity.MesQaItemsDetect01; import com.gs.xky.entity.MesQaItemsDetectDetail12; import com.gs.xky.entity.MesQaItemsDetectDetail5; import com.gs.xky.mapper.MesQaItemsDetect01Mapper; import com.gs.xky.service.MesQaItemsDetect01Service; import com.gs.xky.service.MesQaItemsDetectDetail12Service; import com.gs.xky.service.MesQaItemsDetectDetail5Service; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_01(æ¥æå ¥åºæ£éªè¡¨å¤´)ãçæ°æ®åºæä½Serviceå®ç° * @createDate 2025-02-17 12:53:02 */ @Service @Transactional(rollbackFor = Exception.class) @RequiredArgsConstructor public class MesQaItemsDetect01ServiceImpl extends ServiceImpl<MesQaItemsDetect01Mapper, MesQaItemsDetect01> implements MesQaItemsDetect01Service { private final MesQaItemsDetectDetail5Service detectDetail5Service; private final MesQaItemsDetectDetail12Service detectDetail12Service; @Override public boolean removeQa(String lotNo) { LambdaQueryWrapper<MesQaItemsDetect01> wrapper = new LambdaQueryWrapper<>(); wrapper.eq(MesQaItemsDetect01::getLotNo, lotNo); MesQaItemsDetect01 one = getOne(wrapper, false); if (one == null) { return false; } LambdaUpdateWrapper<MesQaItemsDetect01> updateWrapper = new LambdaUpdateWrapper<>(); updateWrapper.eq(MesQaItemsDetect01::getReleaseNo, one.getReleaseNo()); if (remove(wrapper)) { LambdaQueryWrapper<MesQaItemsDetectDetail5> wrapper1 = new LambdaQueryWrapper<>(); wrapper1.eq(MesQaItemsDetectDetail5::getReleaseNo, one.getReleaseNo()); detectDetail5Service.remove(wrapper1); LambdaQueryWrapper<MesQaItemsDetectDetail12> wrapper2 = new LambdaQueryWrapper<>(); wrapper2.eq(MesQaItemsDetectDetail12::getReleaseNo, one.getReleaseNo()); detectDetail12Service.remove(wrapper2); } return true; } } src/main/java/com/gs/xky/service/Impl/MesQaItemsDetectDetail12ServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,22 @@ package com.gs.xky.service.Impl; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.gs.xky.entity.MesQaItemsDetectDetail12; import com.gs.xky.mapper.MesQaItemsDetectDetail12Mapper; import com.gs.xky.service.MesQaItemsDetectDetail12Service; import org.springframework.stereotype.Service; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_DETAIL12(IQCæ£éª)ãçæ°æ®åºæä½Serviceå®ç° * @createDate 2025-02-17 12:53:29 */ @Service public class MesQaItemsDetectDetail12ServiceImpl extends ServiceImpl<MesQaItemsDetectDetail12Mapper, MesQaItemsDetectDetail12> implements MesQaItemsDetectDetail12Service { } src/main/java/com/gs/xky/service/Impl/MesQaItemsDetectDetail5ServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,22 @@ package com.gs.xky.service.Impl; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.gs.xky.entity.MesQaItemsDetectDetail5; import com.gs.xky.mapper.MesQaItemsDetectDetail5Mapper; import com.gs.xky.service.MesQaItemsDetectDetail5Service; import org.springframework.stereotype.Service; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_DETAIL5(æ¥ææ£éªä»è¡¨)ãçæ°æ®åºæä½Serviceå®ç° * @createDate 2025-02-17 12:53:24 */ @Service public class MesQaItemsDetectDetail5ServiceImpl extends ServiceImpl<MesQaItemsDetectDetail5Mapper, MesQaItemsDetectDetail5> implements MesQaItemsDetectDetail5Service { } src/main/java/com/gs/xky/service/MesQaItemsDetect01Service.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,14 @@ package com.gs.xky.service; import com.baomidou.mybatisplus.extension.service.IService; import com.gs.xky.entity.MesQaItemsDetect01; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_01(æ¥æå ¥åºæ£éªè¡¨å¤´)ãçæ°æ®åºæä½Service * @createDate 2025-02-17 12:53:02 */ public interface MesQaItemsDetect01Service extends IService<MesQaItemsDetect01> { boolean removeQa(String lotNo); } src/main/java/com/gs/xky/service/MesQaItemsDetectDetail12Service.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,13 @@ package com.gs.xky.service; import com.baomidou.mybatisplus.extension.service.IService; import com.gs.xky.entity.MesQaItemsDetectDetail12; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_DETAIL12(IQCæ£éª)ãçæ°æ®åºæä½Service * @createDate 2025-02-17 12:53:29 */ public interface MesQaItemsDetectDetail12Service extends IService<MesQaItemsDetectDetail12> { } src/main/java/com/gs/xky/service/MesQaItemsDetectDetail5Service.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,13 @@ package com.gs.xky.service; import com.baomidou.mybatisplus.extension.service.IService; import com.gs.xky.entity.MesQaItemsDetectDetail5; /** * @author 28567 * @description é对表ãMES_QA_ITEMS_DETECT_DETAIL5(æ¥ææ£éªä»è¡¨)ãçæ°æ®åºæä½Service * @createDate 2025-02-17 12:53:24 */ public interface MesQaItemsDetectDetail5Service extends IService<MesQaItemsDetectDetail5> { } src/main/java/com/gs/xky/service/XkyService.java
@@ -36,13 +36,15 @@ private final MesInvItemArnDetailService mesInvItemArnDetailService; private final MesInvItemBarcodesService mesInvItemBarcodesService; private final MesQaItemsDetect01Service mesQaItemsDetect01Service; public void GetSaveDetail() throws IOException { long currentTimeMillis = System.currentTimeMillis(); XkyCommonParam param = XkyCommonParam.GetInit(); // 计ç®äºåéåçæ¶é´æ³ long startDate = currentTimeMillis - (5 * 60 * 1000); // 5 åé = 5 * 60 * 1000 æ¯«ç§ long startDate = currentTimeMillis - (6 * 60 * 1000); // 5 åé = 5 * 60 * 1000 æ¯«ç§ // å建 BodyParam 对象并èµå¼ BodyParam bodyParam = new BodyParam(); @@ -71,7 +73,7 @@ remove(deliveryNo); } else if ("2".equals(deliveryNo.getLogisticsStatus())) { } else if ("1".equals(deliveryNo.getStatus()) && "2".equals(deliveryNo.getLogisticsStatus())) { XkyDetail detail = getDetail(deliveryNo.getDeliveryNo()); deliveryNoticeService.saveDeliveryNotice(detail); List<BarcodeDeliveryNo> barcodeDeliveryNos = GetBarcodeInformation(deliveryNo.getDeliveryNo()); @@ -124,6 +126,7 @@ updateWrapper3.eq(MesInvItemBarcodes::getBillNo, mesInvItemArn.getBillNo()); mesInvItemBarcodesService.remove(updateWrapper3); mesQaItemsDetect01Service.removeQa(mesInvItemArn.getBillNo()); } } } src/main/resources/mapper/MesQaItemsDetect01Mapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.gs.xky.mapper.MesQaItemsDetect01Mapper"> </mapper> src/main/resources/mapper/MesQaItemsDetectDetail12Mapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.gs.xky.mapper.MesQaItemsDetectDetail12Mapper"> </mapper> src/main/resources/mapper/MesQaItemsDetectDetail5Mapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.gs.xky.mapper.MesQaItemsDetectDetail5Mapper"> </mapper>