From 755b60c531999e9d3c0a94759a2a5e92f5e4ad4e Mon Sep 17 00:00:00 2001 From: nidapeng <jp@doumee.com> Date: 星期一, 25 三月 2024 14:18:01 +0800 Subject: [PATCH] 整理 --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncEmpowerServiceImpl.java | 68 ++++++++++++++++++++++++++++++++-- 1 files changed, 64 insertions(+), 4 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncEmpowerServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncEmpowerServiceImpl.java index 3b9e929..d94d165 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncEmpowerServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncEmpowerServiceImpl.java @@ -21,6 +21,7 @@ import com.github.yulichang.wrapper.MPJLambdaWrapper; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; +import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.scheduling.annotation.Async; import org.springframework.stereotype.Service; @@ -119,26 +120,26 @@ //濡傛灉鏄凡鍒犻櫎鐨勬暟鎹紝涓嬪彂澶辫触锛堥槻姝㈣澶囩绾匡級锛屽垯灏濊瘯閲嶆柊涓嬪彂浠诲姟 if(Constants.equalsInteger(c.getIsdeleted(), Constants.ONE) ){ // && Constants.formatIntegerNum(c.getTryNum())+1 < tryNum ){ - empowerMapper.update(null, new UpdateWrapper<Empower>() + /* empowerMapper.update(null, new UpdateWrapper<Empower>() .lambda() .eq(Empower::getId, c.getId()) .set(Empower::getRemark, "涓嬪彂澶辫触锛岀瓑寰呴噸鏂板垹闄ゆ潈闄�") -// .set(Empower::getHkId,null) -// .set(Empower::getSendDate,null) .set(Empower::getTryNum,Constants.formatIntegerNum(c.getTryNum())+1) .set(Empower::getSendInfo, "涓嬪彂澶辫触锛岀瓑寰呴噸鏂板垹闄ゆ潈闄�") - .set(Empower::getSendStatus, Constants.EmpowerStatus.wait)); + .set(Empower::getSendStatus, Constants.EmpowerStatus.wait));*/ empowerMapper.update(null, new UpdateWrapper<Empower>() .lambda() .eq(Empower::getId, c.getId()) .set(Empower::getRemark, "鍒犻櫎鏉冮檺涓嬪彂澶辫触") .set(Empower::getSendInfo, "鍒犻櫎鏉冮檺涓嬪彂澶辫触") + .set(Empower::getTryNum,Constants.formatIntegerNum(c.getTryNum())+1) .set(Empower::getSendStatus, Constants.EmpowerStatus.fail)); }else{ empowerMapper.update(null, new UpdateWrapper<Empower>() .lambda() .eq(Empower::getId, c.getId()) .set(Empower::getRemark, "涓嬪彂澶辫触") + .set(Empower::getTryNum,Constants.formatIntegerNum(c.getTryNum())+1) .set(Empower::getSendInfo, "涓嬪彂澶辫触") .set(Empower::getSendStatus, Constants.EmpowerStatus.fail)); } @@ -318,6 +319,53 @@ * 澶勭悊浜哄憳鎺堟潈鏁版嵁锛屽畾鏃朵笅鍙� */ @Override + public Integer syncEmpowerFailData(Integer endId) { + List<Empower> allList =getAllFailDealList( endId); + if(allList!=null && allList.size()>0){ + Date date = new Date(); + List<Integer> retryIds = new ArrayList<>(); + List<Integer> noIds = new ArrayList<>(); + for(Empower empower:allList){ + //濡傛灉鏄垹闄ょ殑鏉冮檺涓嬪彂锛屾煡璇㈡槸鍚︿己鍊欐湁涓嬪彂鎴愬姛鐨勬暟鎹紝濡傛灉鏈夛紝鍒欎笉澶勭悊 + if(empower.getId().equals(392479)){ + System.out.println("============================"); + } +// int flag= empowerMapper.selectCount(new QueryWrapper<Empower>().lambda() +// .eq(Empower::getMemberId,empower.getMemberId()) +// .eq(Empower::getDeviceId,empower.getDeviceId() ) +// .gt(Empower::getId,empower.getId()) +// .last("limit 1")); + if(empower.getTempCouunt() ==0){ + //濡傛灉涔嬪悗鏃堕棿鍐呭張閲嶆柊涓嬪彂璁板綍锛屽垯璺宠繃涓嶅仛澶勭悊 + retryIds.add(empower.getId()); + }else{ + noIds.add(empower.getId()); + } + } + + if(retryIds.size()>0){ + empowerMapper.update(null,new UpdateWrapper<Empower>().lambda() + .set(Empower::getCreateDate,date) + .set(Empower::getSendStatus,Constants.EmpowerStatus.wait) + .set(Empower::getEditDate,date) + .set(Empower::getRemark,"涓嬪彂澶辫触锛屽緟閲嶆柊涓嬪彂~") + .set(Empower::getSendInfo,"涓嬪彂澶辫触锛屽緟閲嶆柊涓嬪彂~") + .in(Empower::getId,retryIds)); + } + if(noIds.size()>0){ + empowerMapper.update(null,new UpdateWrapper<Empower>().lambda() + .set(Empower::getEditDate,date) + .set(Empower::getFailFlag,Constants.ONE) + .in(Empower::getId,noIds)); + } + return allList.get(allList.size()-1).getId(); + } + return null; + } + /** + * 澶勭悊浜哄憳鎺堟潈鏁版嵁锛屽畾鏃朵笅鍙� + */ + @Override public Integer syncEmpowerData(Integer endId) { // if(Constants.DEALING_HK_EMPOWER){ // return null ; @@ -363,6 +411,7 @@ }catch (Exception e){ e.printStackTrace(); }finally { + } } @@ -596,6 +645,17 @@ List<Empower> list = empowerMapper.selectJoinList(Empower.class,queryWrapper); return list; } + private List<Empower> getAllFailDealList(int endId ) { + MPJLambdaWrapper<Empower> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.select(Empower::getId,Empower::getMemberId,Empower::getDeviceId,Empower::getIsdeleted); + queryWrapper.select(" (select count(1) from empower ee where ee.member_id=t.MEMBER_ID and ee.device_id =t.DEVICE_ID and ee.id>t.id) as tempCouunt"); + queryWrapper.eq(Empower::getSendStatus,Constants.EmpowerStatus.fail); + queryWrapper.gt(Empower::getId,endId); + queryWrapper.orderByAsc(Empower::getId ); + queryWrapper.ne( Empower::getFailFlag,Constants.ONE); + List<Empower> list = empowerMapper.selectJoinList(Empower.class,queryWrapper); + return list; + } private List<Empower> getDealList(int del ,int start,int end) { MPJLambdaWrapper<Empower> queryWrapper = new MPJLambdaWrapper<>(); -- Gitblit v1.9.3