#pgsql 运营监控

jiaosong

2023-10-10 cac8f41a47915de2a30a8784fe1fc35c364e86df

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

@@ -4,19 +4,30 @@
import com.doumee.core.constants.Constants;
import com.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.model.LoginUserInfo;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.DateUtil;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.GoodsorderMapper;
import com.doumee.dao.business.LocksMapper;
import com.doumee.dao.business.ActionLogMapper;
import com.doumee.dao.business.MemberRidesMapper;
import com.doumee.dao.business.join.MemberRidesJoinMapper;
import com.doumee.dao.business.model.*;
import com.doumee.dao.business.model.BaseParam;
import com.doumee.dao.business.model.Goodsorder;
import com.doumee.dao.business.model.Member;
import com.doumee.dao.business.model.MemberRides;
import com.doumee.dao.business.model.*;
import com.doumee.dao.business.web.request.MemberRidesQuery;
import com.doumee.dao.business.web.response.BikeLogDTO;
import com.doumee.dao.business.web.response.MemberRidesDTO;
import com.doumee.dao.business.web.response.MemberRidesDetailResponse;
import com.doumee.service.business.DeviceService;
import com.doumee.service.business.GoodsorderService;
import com.doumee.service.business.MemberRidesService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
@@ -25,6 +36,8 @@
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.checkerframework.checker.units.qual.C;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -48,12 +61,17 @@
    @Autowired
    private ActionLogMapper actionLogMapper;


    @Autowired
    private MemberRidesJoinMapper memberRidesJoinMapper;

    @Autowired
    private DeviceService deviceService;

    @Autowired
    private LocksMapper locksMapper;

    @Autowired
    private GoodsorderService goodsorderService;

    @Override
    public String create(MemberRides memberRides) {
@@ -202,10 +220,16 @@
        }
        return memberRides.getBikeCode();
    }

    /**
     * 骑行时长修改
     * @param memberRides
     */
    @Override
    public  void updateDuration(MemberRides memberRides){
        LoginUserInfo user =(LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
        if(StringUtils.isBlank(memberRides.getMemberId())
                ||StringUtils.isBlank(memberRides.getBackReason())
                || memberRides.getDuration() == null){
            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
        }
@@ -237,6 +261,8 @@

        ActionLog log = new ActionLog();
        log.setId(Constants.getUUID());
        log.setActInfo(memberRides.getBackInfo());
        log.setActReason(memberRides.getBackReason());
        log.setIsdeleted(Constants.ZERO);
        log.setCreateDate(update.getBackDate());
        log.setCreator(user.getId());
@@ -310,13 +336,66 @@
        log.setObjType(Constants.ACTIONLOG_TYPE.FORCE_BACK.getKey());
        log.setContent(Constants.ACTIONLOG_TYPE.FORCE_BACK.getInfo());
        log.setTitle(Constants.ACTIONLOG_TYPE.FORCE_BACK.getName());
        log.setActInfo(memberRides.getBackInfo());
        log.setActReason(memberRides.getBackReason());
        //记录操作日志
        actionLogMapper.insert(log);

    }


    @Override
    public MemberRidesDetailResponse openLock(String code,String memberId){
        //判断当前是否已支付押金
        Goodsorder goodsorder = goodsorderService.findOneByWrapper(new QueryWrapper<Goodsorder>()
                .eq("isdeleted",Constants.ZERO)
                .eq("status",Constants.goodsorderStatus.pay)
                .eq("member_id",memberId)
                .orderByDesc("create_date")
                .last("limit 1"));
        if(Objects.isNull(goodsorder)){
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未支付押金，无法进行该操作！");
        }
        //判断当前押金订单是否为今日押金
        if(!DateUtil.DateToStr(goodsorder.getPayDate(),"yyyy-MM-dd").equals(DateUtil.getDate(new Date(),"yyyy-MM-dd"))){
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非今日押金订单，请结算后重新支付！");
        }
        //判断是否处于营业时间
        goodsorderService.checkBusiness();
        //查询是否处于骑行中
        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"));
        Boolean flag = deviceService.openLock(locks);
        if(!flag){
            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"开锁失败");
        }
        //存储骑行记录
        MemberRides memberRides = new MemberRides();
        memberRides.setIsdeleted(Constants.ZERO);
        memberRides.setMemberId(memberId);
        memberRides.setCreateDate(new Date());
        memberRides.setRentSiteId(locks.getSiteId());
        memberRides.setRentLockId(locks.getId());
        memberRides.setStatus(Constants.MEMBER_RIDES_STATUS.LOCKING.getKey());
        memberRidesMapper.insert(memberRides);

        MemberRidesDetailResponse memberRidesDetailResponse = new MemberRidesDetailResponse();
        BeanUtils.copyProperties(memberRides,memberRidesDetailResponse);
        return memberRidesDetailResponse;

    }

    @Override
    public MemberRidesDetailResponse refreshLock(String id){
        MemberRides memberRides = memberRidesMapper.selectById(id);
        if(Objects.isNull(memberRides)){
            throw new BusinessException(ResponseStatus.DATA_EMPTY);
        }
        MemberRidesDetailResponse memberRidesDetailResponse = new MemberRidesDetailResponse();
        BeanUtils.copyProperties(memberRides,memberRidesDetailResponse);
        return memberRidesDetailResponse;

    }
}