修改

jiangping

2023-10-12 697775ce76037e4ec4a2f7de59395fc873070c71

 server/services/src/main/java/com/doumee/service/business/impl/MemberRidesServiceImpl.java

@@ -13,9 +13,7 @@
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.DateUtil;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.ActionLogMapper;
import com.doumee.dao.business.LocksMapper;
import com.doumee.dao.business.MemberRidesMapper;
import com.doumee.dao.business.*;
import com.doumee.dao.business.join.MemberRidesJoinMapper;
import com.doumee.dao.business.model.*;
import com.doumee.dao.business.web.request.MemberRidesQuery;
@@ -59,6 +57,10 @@

    @Autowired
    private LocksMapper locksMapper;
    @Autowired
    private SitesMapper sitesMapper;
    @Autowired
    private BikesMapper bikesMapper;

    @Autowired
    private GoodsorderService goodsorderService;
@@ -366,8 +368,8 @@
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"存在骑行中车辆，无法扫码");
        };
        Locks locks = locksMapper.selectOne(new QueryWrapper<Locks>().eq("code",code).eq("isdeleted", Constants.ZERO).last("limit 1"));
        Boolean flag = deviceService.openLock(locks);
        if(!flag){
        MqttLog flag = deviceService.openLock(locks);
        if(flag.getResult() == 0){
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"开锁失败");
        }
        //存储骑行记录
@@ -397,4 +399,139 @@
        return memberRidesDetailResponse;

    }

    /**
     * 锁头信息上报
     * @param locks
     * @return
     */
    @Override
    public  int mqttLockInfoEvent(Locks locks){
        //判断检查处理站点锁头信息
        Locks model = dealLockAndSite(locks);
        //车辆记录
        Bikes bikes = dealBikesByParam(model);

        //状态，0闭合, 1打开，2运行中, 3异常
        if(model.getStatus() == Constants.LockStatus.open){
            //如果是开锁业务，判断是否有开锁中的信息
            if(StringUtils.isNotBlank(locks.getBikeCode())){

            }
            MemberRides memberRides = new MemberRides();
            memberRides.setBikeCode(model.getBikeCode());


        }
        return 0;
    }

    private Bikes dealBikesByParam(Locks model) {
        QueryWrapper<Bikes> wrapper = new QueryWrapper<>();
        wrapper.lambda().eq(Bikes::getLockId, model.getId());
        wrapper.lambda().eq(Bikes::getSiteId, model.getSiteId());
        Bikes bikes = bikesMapper.selectOne(wrapper.last("last 1"));
        if(bikes != null ) {
            if (  StringUtils.equals(model.getBikeCode(), bikes.getCode())){
                //如果绑定车辆信息发生编号，更换绑定关系
                bikes.setCode(model.getBikeCode());
                bikes.setParamId(getBileTypeByCode(model.getBikeCode()));
                UpdateWrapper<Bikes> updateWrapper = new UpdateWrapper<>();
                updateWrapper.lambda().set(Bikes::getId, bikes.getId());

                //更新自行站点锁头绑定自行车信息
                bikesMapper.updateById(bikes);
            }
        }else{
            bikes = new Bikes();
            bikes.setId(Constants.getUUID());
            bikes.setIsdeleted(Constants.ZERO);
            bikes.setCreateDate(new Date());
            bikes.setSiteId(model.getSiteId());
            bikes.setLockId(model.getId());
            bikes.setCode(model.getBikeCode());
            bikes.setParamId(getBileTypeByCode(model.getBikeCode()));
            bikesMapper.insert(bikes);
        }
        return  bikes;

    }

    //TODO-----JP------------根据车辆code分析车辆类型，待确认方案-------------------
    private String getBileTypeByCode(String bikeCode) {
        return null;
    }

    private Locks dealLockAndSite(Locks locks) {
        Locks model =   locksMapper.selectById(locks.getId());
        Date date =new Date();
        //检查站点信息，不存在则新增
//        boolean newSite =false;
        Sites sites = sitesMapper.selectById(locks.getSiteId());
        if(sites == null){
            sites = new Sites();
            sites.setIsdeleted(Constants.ZERO);
            sites.setCode(locks.getSiteId());
            sites.setId(locks.getSiteId());
            sites.setCreateDate(date);
            sites.setStatus(Constants.ZERO);
            sites.setLockNum(1);
            //新增锁头
            sitesMapper.insert(sites);
//            newSite =true;
        }

        if(model == null){
            //如果锁头不存在，判断存储
            model = new Locks();
            model.setId(locks.getId());
            model.setSiteId(locks.getSiteId());
            model.setIsdeleted(Constants.ZERO);
            model.setCode(locks.getCode());
            model.setSiteId(locks.getSiteId());
            model.setBikeCode(locks.getBikeCode());
            model.setCreateDate(date);
            model.setStatus(locks.getStatus());
            locksMapper.insert(model);
         /*   UpdateWrapper<Sites> wrapper = new UpdateWrapper();
            wrapper.eq("id",sites.getId());
            wrapper.lambda().setSql("lock_num = COALESCE(lock_num,0)  + 1");
            wrapper.lambda().set(Sites::getEditDate,date);
            sitesMapper.update(null,wrapper);//累计锁头数量*/
        }else{
          /*  if(!StringUtils.equals(model.getId(),locks.getId())){
                //如果站点发生变化，原来的站点锁头数量-1
                UpdateWrapper<Sites> wrapper = new UpdateWrapper();
                wrapper.eq("id",model.getId());
                wrapper.lambda().setSql("lock_num = COALESCE(lock_num,0)  - 1");
                wrapper.lambda().set(Sites::getEditDate,date);
                sitesMapper.update(null,wrapper);//累计锁头数量
            }
            if(!newSite){
                //如果站点未发生变化， 并且不是新站点，站点锁头+1
                UpdateWrapper<Sites> wrapper = new UpdateWrapper();
                wrapper.eq("id",model.getId());
                wrapper.lambda().setSql("lock_num = COALESCE(lock_num,0)  - 1");
                wrapper.lambda().set(Sites::getEditDate,date);
                sitesMapper.update(null,wrapper);//累计锁头数量
            }*/
            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));

        }
        model.setSites(sites);
        return  model;
    }

    @Override
    public  int mqttCloseBikeEvent(MemberRides bikes){
        return  0;

    }
}