| | |
| | | public MemberRides findJoinById(String id) { |
| | | |
| | | MPJLambdaWrapper<MemberRides> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.leftJoin(BaseParam.class,BaseParam::getId,MemberRides::getParamId); |
| | | queryWrapper.leftJoin(BaseParam.class,BaseParam::getId,MemberRides::getParamId) |
| | | .leftJoin(Member.class,Member::getId,MemberRides::getMemberId); |
| | | queryWrapper.eq(MemberRides::getId, id); |
| | | queryWrapper.selectAll(MemberRides.class); |
| | | queryWrapper.selectAs(BaseParam::getName,MemberRidesDTO::getBikeType) ; |
| | | queryWrapper.selectAs(BaseParam::getName,MemberRidesDTO::getBikeType); |
| | | queryWrapper.selectAs(Member::getOpenid,MemberRides::getMemberOpenid); |
| | | queryWrapper.last("limit 1"); |
| | | |
| | | return memberRidesJoinMapper.selectJoinOne(MemberRides.class, queryWrapper); |
| | |
| | | //车辆记录 |
| | | Bikes bikes = dealBikesByParam(model); |
| | | //状态,0闭合, 1打开,2运行中, 3异常 |
| | | if(model.getStatus() == Constants.LockStatus.open){ |
| | | if(locks.getStatus() == Constants.LockStatus.open){ |
| | | //如果是开锁业务,判断是否有开锁中的信息 |
| | | MemberRides memberRides = new MemberRides(); |
| | | memberRides.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey()); |
| | |
| | | update.setId(memberRides.getId()); |
| | | //(更新请求开锁中的锁头关联的骑行记录) |
| | | memberRidesMapper.updateById( update); |
| | | }else if(locks.getStatus() == Constants.LockStatus.closed ){ |
| | | //如果是关锁业务,判断触发还车 |
| | | if(StringUtils.isNotBlank(locks.getBikeCode())){ |
| | | MemberRides mbikes = new MemberRides(); |
| | | mbikes.setBackLockId(locks.getCode()); |
| | | mbikes.setBackSiteId(locks.getSiteId()); |
| | | mbikes.setBikeCode(locks.getBikeCode()); |
| | | mqttCloseBikeEventDo(mbikes); |
| | | /* if(StringUtils.isBlank(locks.getBikeCode()) ||StringUtils.isBlank(locks.getCode()) |
| | | ||StringUtils.isBlank(bikes.getSiteId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"还车上报参数错误!"); |
| | | } |
| | | QueryWrapper<MemberRides> wrapper = new QueryWrapper<>(); |
| | | List<Integer> statusList = new ArrayList<>(); |
| | | statusList.add(Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey()); |
| | | statusList.add(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey()); |
| | | wrapper.lambda().eq(MemberRides::getBikeCode, locks.getBikeCode()); |
| | | wrapper.lambda().in(MemberRides::getStatus, statusList); |
| | | wrapper.lambda().eq(MemberRides::getIsdeleted, Constants.ZERO); |
| | | //根据车辆编码查询骑行中的骑行记录信息,如果有进行还车操作 |
| | | List<MemberRides> list = memberRidesMapper.selectList(wrapper); |
| | | // MemberRides memberRides = memberRidesMapper.selectOne(wrapper.last("limit 1")); |
| | | if(list!=null){ |
| | | //进行 |
| | | for(MemberRides memberRides : list){ |
| | | dealMemberRidesBack(memberRides,bikes); |
| | | } |
| | | }*/ |
| | | } |
| | | } |
| | | return 0; |
| | | } |
| | |
| | | // 大于阈值 |
| | | if (between > 2){ |
| | | s.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING_DEFEAT.getKey()); |
| | | s.setEditDate(new Date()); |
| | | memberRidesMapper.updateById(s); |
| | | } |
| | | }); |
| | |
| | | if(bikes != null ) { |
| | | if ( !StringUtils.equals(model.getBikeCode(), bikes.getCode())){ |
| | | //如果绑定车辆信息发生编号,更换绑定关系 |
| | | String type =getBileTypeByCode(model.getBikeCode()); |
| | | UpdateWrapper<Bikes> updateWrapper = new UpdateWrapper<>(); |
| | | updateWrapper.lambda().eq(Bikes::getId, bikes.getId()); |
| | | updateWrapper.lambda().set(Bikes::getCode,model.getBikeCode()); |
| | | updateWrapper.lambda().set(Bikes::getParamId,getBileTypeByCode(model.getBikeCode())); |
| | | updateWrapper.lambda().set(Bikes::getParamId,type); |
| | | //更新自行站点锁头绑定自行车信息 |
| | | bikesMapper.update(null,updateWrapper); |
| | | bikes.setCode(model.getBikeCode()); |
| | | bikes.setParamId(model.getBikeType()); |
| | | } |
| | | }else{ |
| | | bikes = new Bikes(); |
| | |
| | | updateWrapper.lambda().set(Locks::getEditDate, new Date() ); |
| | | updateWrapper.lambda().set(Locks::getIsdeleted, Constants.ZERO); |
| | | locksMapper.update(null,updateWrapper); |
| | | model.setStatus(locks.getStatus()); |
| | | model.setBikeCode(locks.getBikeCode()); |
| | | } |
| | | model.setSites(sites); |
| | | return model; |
| | |
| | | locks.setCode(bikes.getBackLockId()); |
| | | locks.setBikeCode(bikes.getBikeCode()); |
| | | locks.setInfo(bikes.getBackCommondId()); |
| | | locks.setStatus(bikes.getStatus()); |
| | | //处理锁头数据 |
| | | mqttLockInfoEvent(locks); |
| | | //免费骑行时长查询,数据字典配置 |
| | | mqttCloseBikeEventDo(bikes); |
| | | return 0; |
| | | } |
| | | |
| | | private void mqttCloseBikeEventDo(MemberRides bikes) { |
| | | if(StringUtils.isBlank(bikes.getBikeCode()) ||StringUtils.isBlank(bikes.getBackLockId())||StringUtils.isBlank(bikes.getBackSiteId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"还车上报参数错误!"); |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"还车上报参数错误!"); |
| | | } |
| | | QueryWrapper<MemberRides> wrapper = new QueryWrapper<>(); |
| | | List<Integer> statusList = new ArrayList<>(); |
| | |
| | | wrapper.lambda().in(MemberRides::getStatus, statusList); |
| | | wrapper.lambda().eq(MemberRides::getIsdeleted, Constants.ZERO); |
| | | //根据车辆编码查询骑行中的骑行记录信息,如果有进行还车操作 |
| | | MemberRides memberRides = memberRidesMapper.selectOne(wrapper.last("limit 1")); |
| | | if(memberRides!=null){ |
| | | List<MemberRides> list = memberRidesMapper.selectList(wrapper); |
| | | // MemberRides memberRides = memberRidesMapper.selectOne(wrapper.last("limit 1")); |
| | | if(list!=null){ |
| | | //进行 |
| | | dealMemberRidesBack(memberRides,bikes); |
| | | for(MemberRides memberRides : list){ |
| | | dealMemberRidesBack(memberRides,bikes); |
| | | } |
| | | } |
| | | return 0; |
| | | } |
| | | |
| | | private void dealMemberRidesBack(MemberRides memberRides,MemberRides param) { |