From 99f77c0fd2ee8ed8840be5e5f99309b184a09e9f Mon Sep 17 00:00:00 2001 From: jiaosong <jiaosong6760@dingtalk.com> Date: 星期三, 18 十月 2023 11:27:57 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev --- server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java | 120 ++++++++++++++++++++++++++++++++++++++++++----------------- 1 files changed, 85 insertions(+), 35 deletions(-) diff --git a/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java index 1a2b104..eaeb724 100644 --- a/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java +++ b/server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java @@ -36,6 +36,7 @@ import org.apache.shiro.SecurityUtils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; @@ -74,10 +75,13 @@ @Autowired private SitesMapper sitesMapper; @Autowired + private BaseParamMapper baseParamMapper; + @Autowired private BikesMapper bikesMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired + @Lazy private GoodsorderService goodsorderService; @@ -217,6 +221,8 @@ queryWrapper.le(model.getRentDateEnd()!=null, MemberRides::getRentDate,model.getRentDateEnd()); queryWrapper.eq(model.getCloseStatus()!=null,MemberRides::getCloseStatus, model.getCloseStatus()); queryWrapper.eq(model.getGoodsorderId()!=null,MemberRides::getOrdreId, model.getGoodsorderId()); + queryWrapper.in(MemberRides::getStatus, + Arrays.asList(Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey(),Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey())); queryWrapper .selectAs(MemberRides::getId,MemberRidesDTO::getId) .selectAs(Member::getOpenid,MemberRidesDTO::getOpenid) @@ -228,12 +234,14 @@ .selectAs(MemberRides::getRentDate,MemberRidesDTO::getRentDate) .selectAs(MemberRides::getRentLockId,MemberRidesDTO::getRentLockId) .selectAs(MemberRides::getRentSiteId,MemberRidesDTO::getRentSiteId) - .selectAs(MemberRides::getBackDate,MemberRidesDTO::getBackDate); + .selectAs(MemberRides::getBackDate,MemberRidesDTO::getBackDate) + .selectAs(MemberRides::getBackSiteId,MemberRidesDTO::getBackSiteId) + .selectAs(MemberRides::getBackLockId,MemberRidesDTO::getBackLockId); return queryWrapper; } @Override - public String getOnlineBike(String memberId){ + public MemberRides getOnlineBike(String memberId){ MemberRides memberRides = memberRidesMapper.selectOne(new QueryWrapper<MemberRides>() .eq("isdeleted", Constants.ZERO) .eq("member_id",memberId) @@ -243,7 +251,7 @@ if(Objects.isNull(memberRides)){ return null; } - return memberRides.getBikeCode(); + return memberRides; } /** @@ -393,6 +401,9 @@ @Override public MemberRidesDetailResponse openLock(String code,String memberId) { + if(StringUtils.isBlank(code) || code.split("/").length != 2){ + throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝璇ョ珯鐐圭紪鍙蜂笉瀛樺湪锛岃灏濊瘯鏇存崲杞﹁締锛�"); + } //鍒ゆ柇褰撳墠鏄惁宸叉敮浠樻娂閲� Goodsorder goodsorder = goodsorderService.findOneByWrapper(new QueryWrapper<Goodsorder>() .eq("isdeleted", Constants.ZERO) @@ -413,12 +424,17 @@ if (memberRidesMapper.selectCount(new QueryWrapper<MemberRides>().eq("member_id", memberId).in("status", 0, 1)) > Constants.ZERO) { throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀛樺湪楠戣涓溅杈嗭紝鏃犳硶鎵爜"); } - Locks locks = locksMapper.selectOne(new QueryWrapper<Locks>().eq("code", code).eq("isdeleted", Constants.ZERO).last("limit 1")); + String[] codes = code.split("/"); + Locks locks = locksMapper.selectOne(new QueryWrapper<Locks>() + .lambda().eq(Locks::getCode, codes[1]) + .eq(Locks::getSiteId, codes[0]) + .eq(Locks::getIsdeleted, Constants.ZERO) + .last("limit 1")); if (Objects.isNull(locks)) { throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "鎵爜鏃犳晥锛屾湭鏌ヨ鍒伴攣澶翠俊鎭�"); } //鏌ヨ閿佸ご鏄惁瀛樺湪杞﹁締 浠ュ強鏄惁姝e父 - if (!locks.getStatus().equals(Constants.ZERO)) { + if (Constants.formatIntegerNum(locks.getStatus())!=Constants.ZERO) { throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "褰撳墠鎵爜閿佸ご鐘舵�侀敊璇紝鏃犳硶杩涜寮�閿�"); } if (StringUtils.isBlank(locks.getBikeCode())) { @@ -436,7 +452,7 @@ memberRides.setMemberId(memberId); memberRides.setCreateDate(new Date()); memberRides.setRentSiteId(locks.getSiteId()); - memberRides.setRentLockId(locks.getId()); + memberRides.setRentLockId(locks.getCode()); memberRides.setOrdreId(goodsorder.getId()); memberRides.setRentDate(new Date()); memberRides.setBalance(new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_DEPOSIT).getCode())); @@ -446,14 +462,12 @@ memberRidesMapper.insert(memberRides); BeanUtils.copyProperties(memberRides, memberRidesDetailResponse); } - - return memberRidesDetailResponse; } private boolean isValidePricingType(Locks locks,MemberRides memberRides ) { Bikes bike= new Bikes(); - bike.setLockId(locks.getId()); + bike.setLockId(locks.getCode()); bike.setSiteId(locks.getSiteId()); //鏌ヨ杞﹁締淇℃伅 bike = bikesMapper.selectOne(new QueryWrapper<>(bike).last("limit 1")); @@ -523,7 +537,6 @@ MemberRidesDetailResponse memberRidesDetailResponse = new MemberRidesDetailResponse(); BeanUtils.copyProperties(memberRides,memberRidesDetailResponse); return memberRidesDetailResponse; - } /** @@ -532,37 +545,42 @@ * @return */ @Override + @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public int mqttLockInfoEvent(Locks locks){ - if(StringUtils.isBlank(locks.getId()) ||StringUtils.isBlank(locks.getSiteId())){ + if(StringUtils.isBlank(locks.getCode()) ||StringUtils.isBlank(locks.getSiteId())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"閿佸ご淇℃伅涓婃姤鍙傛暟閿欒锛�"); } //鍒ゆ柇妫�鏌ュ鐞嗙珯鐐归攣澶翠俊鎭� Locks model = dealLockAndSite(locks); //杞﹁締璁板綍 Bikes bikes = dealBikesByParam(model); - //鐘舵�侊紝0闂悎, 1鎵撳紑锛�2杩愯涓�, 3寮傚父 if(model.getStatus() == Constants.LockStatus.open){ //濡傛灉鏄紑閿佷笟鍔★紝鍒ゆ柇鏄惁鏈夊紑閿佷腑鐨勪俊鎭� MemberRides memberRides = new MemberRides(); memberRides.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey()); - memberRides.setRentLockId(model.getId()); + memberRides.setRentLockId(model.getCode()); + memberRides.setRentSiteId(model.getSiteId()); memberRides.setIsdeleted(Constants.ZERO); memberRides = findOne(memberRides); if(memberRides == null){ return 0; } + MemberRides update = new MemberRides(); + update.setStatus(Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey()); + update.setEditDate(new Date()); + update.setId(memberRides.getId()); //锛堟洿鏂拌姹傚紑閿佷腑鐨勯攣澶村叧鑱旂殑楠戣璁板綍锛� - memberRidesMapper.updateById( memberRides); + memberRidesMapper.updateById( update); } return 0; } private Bikes dealBikesByParam(Locks model) { QueryWrapper<Bikes> wrapper = new QueryWrapper<>(); - wrapper.lambda().eq(Bikes::getLockId, model.getId()); + wrapper.lambda().eq(Bikes::getLockId, model.getCode()); wrapper.lambda().eq(Bikes::getSiteId, model.getSiteId()); - Bikes bikes = bikesMapper.selectOne(wrapper.last("last 1")); + Bikes bikes = bikesMapper.selectOne(wrapper.last("limit 1")); if(bikes != null ) { if ( StringUtils.equals(model.getBikeCode(), bikes.getCode())){ //濡傛灉缁戝畾杞﹁締淇℃伅鍙戠敓缂栧彿锛屾洿鎹㈢粦瀹氬叧绯� @@ -574,12 +592,21 @@ bikesMapper.updateById(bikes); } }else{ + if(StringUtils.isNotBlank(model.getBikeCode())){ + UpdateWrapper<Bikes> updateWrapper = new UpdateWrapper<>(); + updateWrapper.lambda().set(Bikes::getCode, null ); + updateWrapper.lambda().set(Bikes::getParamId, null ); + updateWrapper.lambda().set(Bikes::getEditDate, new Date() ); + updateWrapper.lambda().eq(Bikes::getCode, model.getCode() ); + //娓呯┖鍘熸潵鐨勮嚜琛岃溅缁戝畾鍏崇郴 + bikesMapper.update(null, updateWrapper); + } bikes = new Bikes(); bikes.setId(Constants.getUUID()); bikes.setIsdeleted(Constants.ZERO); bikes.setCreateDate(new Date()); bikes.setSiteId(model.getSiteId()); - bikes.setLockId(model.getId()); + bikes.setLockId(model.getCode()); bikes.setCode(model.getBikeCode()); bikes.setParamId(getBileTypeByCode(model.getBikeCode())); bikesMapper.insert(bikes); @@ -588,14 +615,35 @@ } - //TODO-----JP------------鏍规嵁杞﹁締code鍒嗘瀽杞﹁締绫诲瀷锛屽緟纭鏂规------------------- + /** + -----------鏍规嵁杞﹁締code鍒嗘瀽杞﹁締绫诲瀷锛屽緟纭鏂规------------------- + * + */ private String getBileTypeByCode(String bikeCode) { - int temp=1+(int)(Math.random()*(8)); - return temp+""; +// int temp=1+(int)(Math.random()*(8)); + if(StringUtils.isBlank(bikeCode)){ + return null; + } + String type = bikeCode.substring(0,1); + if(Constants.BIKE_TYPE.contains(type)){ + return null; + } + BaseParam param = new BaseParam(); + param.setIsdeleted(Constants.ZERO); + param.setType(Constants.THREE); + param.setSortnum(Integer.parseInt(type)); + param = baseParamMapper.selectOne(new QueryWrapper<>(param).lambda().last("limit 1" )); + if(param == null){ + return type; + } + return param.getId(); } private Locks dealLockAndSite(Locks locks) { - Locks model = locksMapper.selectById(locks.getId()); + Locks model = new Locks(); + model.setSiteId(locks.getSiteId()); + model.setCode(locks.getCode()); + model = locksMapper.selectOne(new QueryWrapper<>(model).last("limit 1")); Date date =new Date(); //妫�鏌ョ珯鐐逛俊鎭紝涓嶅瓨鍦ㄥ垯鏂板 Sites sites = sitesMapper.selectById(locks.getSiteId()); @@ -606,15 +654,15 @@ sites.setId(locks.getSiteId()); sites.setCreateDate(date); sites.setStatus(Constants.ZERO); + sites.setEditDate(date); sites.setLockNum(1); //鏂板閿佸ご sitesMapper.insert(sites); } - if(model == null){ //濡傛灉閿佸ご涓嶅瓨鍦紝鍒ゆ柇瀛樺偍 model = new Locks(); - model.setId(locks.getId()); + model.setId(Constants.getUUID()); model.setSiteId(locks.getSiteId()); model.setIsdeleted(Constants.ZERO); model.setCode(locks.getCode()); @@ -624,15 +672,15 @@ model.setStatus(locks.getStatus()); locksMapper.insert(model); }else{ - model.setSiteId(locks.getSiteId()); - model.setIsdeleted(Constants.ZERO); - model.setCode(locks.getCode()); - model.setId(locks.getSiteId()); - model.setEditDate(date); - model.setBikeCode(locks.getBikeCode()); - model.setStatus(locks.getStatus()); - locksMapper.update(null, new QueryWrapper<>(model)); + UpdateWrapper<Locks> updateWrapper = new UpdateWrapper<Locks>(); + updateWrapper.lambda().eq(Locks::getCode, locks.getCode() ); + updateWrapper.lambda().eq(Locks::getSiteId, locks.getSiteId() ); + updateWrapper.lambda().set(Locks::getBikeCode, locks.getBikeCode() ); + updateWrapper.lambda().set(Locks::getStatus, locks.getStatus() ); + updateWrapper.lambda().set(Locks::getEditDate, new Date() ); + updateWrapper.lambda().set(Locks::getIsdeleted, Constants.ZERO); + locksMapper.update(null,updateWrapper); } model.setSites(sites); return model; @@ -644,6 +692,7 @@ * @return */ @Override + @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public int mqttCloseBikeEvent(MemberRides bikes){ //鍏嶈垂楠戣鏃堕暱鏌ヨ锛屾暟鎹瓧鍏搁厤缃� if(StringUtils.isBlank(bikes.getBikeCode()) ||StringUtils.isBlank(bikes.getBackLockId())||StringUtils.isBlank(bikes.getBackSiteId())){ @@ -654,7 +703,7 @@ wrapper.lambda().eq(MemberRides::getStatus, Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey()); wrapper.lambda().eq(MemberRides::getIsdeleted, Constants.ZERO); //鏍规嵁杞﹁締缂栫爜鏌ヨ楠戣涓殑楠戣璁板綍淇℃伅锛屽鏋滄湁杩涜杩樿溅鎿嶄綔 - MemberRides memberRides = memberRidesMapper.selectOne(wrapper.last("last 1")); + MemberRides memberRides = memberRidesMapper.selectOne(wrapper.last("limit 1")); if(memberRides!=null){ //杩涜 dealMemberRidesBack(memberRides,bikes); @@ -680,19 +729,20 @@ update.setDuration(duration>0?duration:0); update.setBackType(Constants.ONE); update.setBackInfo("鐢ㄦ埛姝e父杩樿溅"); + update.setId(memberRides.getId()); Bikes bikes = new Bikes(); bikes.setSiteId(memberRides.getBackSiteId()); bikes.setLockId(memberRides.getBackLockId()); // bikes.setCode(memberRides.getBikeCode()); - bikes = bikesMapper.selectById(new QueryWrapper<>(bikes).last("limit 1")); + bikes = bikesMapper.selectOne(new QueryWrapper<>(bikes).last("limit 1")); if(bikes != null ) { UpdateWrapper<Bikes> updateWrapper = new UpdateWrapper<>(); - updateWrapper.lambda().set(Bikes::getId, bikes.getId()); + updateWrapper.lambda().eq(Bikes::getId, bikes.getId()); updateWrapper.lambda().set(Bikes::getEditDate,new Date()); updateWrapper.lambda().set(Bikes::getLastBackDate,new Date()); //鏇存柊鑷杞︽渶鍚庤繕杞︽椂闂� - bikesMapper.updateById(bikes); + bikesMapper.update(null,updateWrapper); } //鏇存柊杩樿溅璁板綍涓哄凡杩樿溅 memberRidesMapper.updateById(update); -- Gitblit v1.9.3