package com.doumee.service.business.impl;
|
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.doumee.core.constants.Constants;
|
import com.doumee.biz.system.SystemDictDataBiz;
|
import com.doumee.core.constants.Constants;
|
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.ID;
|
import com.doumee.core.utils.Utils;
|
import com.doumee.core.wx.WxMiniConfig;
|
import com.doumee.core.wx.WxMiniUtilService;
|
import com.doumee.core.wx.WxPayProperties;
|
import com.doumee.dao.business.*;
|
import com.doumee.dao.business.MemberRidesMapper;
|
import com.doumee.dao.business.join.GoodsorderJoinMapper;
|
import com.doumee.dao.business.join.RefundJoinMapper;
|
import com.doumee.dao.business.model.Bikes;
|
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.vo.GoodsorderExportVO;
|
import com.doumee.dao.business.vo.GoodsorderTotalDataVO;
|
import com.doumee.dao.business.web.request.BikeRepairDTO;
|
import com.doumee.dao.business.web.request.GoodsorderCanBanlanceDTO;
|
import com.doumee.dao.business.web.request.MemberRidesQuery;
|
import com.doumee.dao.business.web.request.RefundDTO;
|
import com.doumee.dao.business.web.response.*;
|
import com.doumee.dao.business.join.MemberRidesJoinMapper;
|
import com.doumee.dao.business.model.*;
|
import com.doumee.service.business.GoodsorderService;
|
import com.doumee.service.business.MemberRidesService;
|
import com.doumee.service.business.PricingRuleService;
|
import com.doumee.service.business.RefundService;
|
import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
import com.wechat.pay.java.service.partnerpayments.jsapi.JsapiServiceExtension;
|
import com.wechat.pay.java.service.partnerpayments.jsapi.model.*;
|
import com.wechat.pay.java.service.refund.model.RefundNotification;
|
import com.wechat.pay.java.service.refund.model.Status;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang3.StringUtils;
|
import org.apache.shiro.SecurityUtils;
|
import org.checkerframework.checker.units.qual.A;
|
import org.checkerframework.checker.units.qual.C;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.util.CollectionUtils;
|
import org.springframework.web.context.request.RequestContextHolder;
|
import org.springframework.web.context.request.ServletRequestAttributes;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.math.BigDecimal;
|
import java.net.InetAddress;
|
import java.net.UnknownHostException;
|
|
import java.sql.Ref;
|
import java.time.LocalTime;
|
import java.time.format.DateTimeFormatter;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
import java.util.stream.Stream;
|
|
@Service
|
@Slf4j
|
public class GoodsorderServiceImpl implements GoodsorderService {
|
|
|
|
@Autowired
|
private GoodsorderMapper goodsorderMapper;
|
|
@Autowired
|
GoodsorderJoinMapper goodsorderJoinMapper;
|
|
@Autowired
|
private SystemDictDataBiz systemDictDataBiz;
|
|
|
@Autowired
|
private MemberMapper memberMapper;
|
@Autowired
|
private BaseParamMapper baseParamMapper;
|
|
@Autowired
|
private RefundMapper refundMapper;
|
@Autowired
|
private RefundJoinMapper refundJoinMapper;
|
|
@Autowired
|
private MemberRidesJoinMapper memberRidesJoinMapper;
|
|
@Autowired
|
private AdMapper adMapper;
|
|
@Autowired
|
private TransactionsMapper transactionsMapper;
|
|
@Autowired
|
private WxMiniUtilService wxMiniUtilService;
|
|
@Autowired
|
PricingRuleService pricingRuleService;
|
|
@Autowired
|
RefundService refundService;
|
|
@Override
|
public String create(Goodsorder goodsorder) {
|
goodsorderMapper.insert(goodsorder);
|
return goodsorder.getId();
|
}
|
|
@Override
|
public void deleteById(String id) {
|
goodsorderMapper.deleteById(id);
|
}
|
|
@Override
|
public void delete(Goodsorder goodsorder) {
|
UpdateWrapper<Goodsorder> deleteWrapper = new UpdateWrapper<>(goodsorder);
|
goodsorderMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<String> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
goodsorderMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public void updateById(Goodsorder goodsorder) {
|
goodsorderMapper.updateById(goodsorder);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<Goodsorder> goodsorders) {
|
if (CollectionUtils.isEmpty(goodsorders)) {
|
return;
|
}
|
for (Goodsorder goodsorder: goodsorders) {
|
this.updateById(goodsorder);
|
}
|
}
|
|
@Override
|
public Goodsorder findById(String id) {
|
return goodsorderMapper.selectById(id);
|
}
|
|
@Override
|
public Goodsorder findOne(Goodsorder goodsorder) {
|
QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder);
|
return goodsorderMapper.selectOne(wrapper.last(" limit 1"));
|
}
|
|
@Override
|
public Goodsorder findOneByWrapper(QueryWrapper<Goodsorder> wrapper) {
|
return goodsorderMapper.selectOne(wrapper.last(" limit 1"));
|
}
|
|
@Override
|
public List<Goodsorder> findList(Goodsorder goodsorder) {
|
QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder);
|
return goodsorderMapper.selectList(wrapper);
|
}
|
@Override
|
public PageData<GoodsorderExportVO> findAccountDetailPage(PageWrap<Goodsorder> pageWrap) {
|
IPage<Goodsorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
pageWrap.getModel().setPayStatus(Constants.ONE); //只查询支付成功的
|
Goodsorder model = pageWrap.getModel();
|
Utils.MP.blankToNull(model);
|
IPage<GoodsorderExportVO> goodsorderExportVOIPage = null;
|
if (Constants.formatIntegerNum(model.getType())==Constants.ZERO){
|
MPJLambdaWrapper<Goodsorder> queryWrapper = new MPJLambdaWrapper<>();
|
queryWrapper.selectAll(Goodsorder.class);
|
queryWrapper.selectAs(Member::getOpenid, Goodsorder::getOpenid);
|
queryWrapper.leftJoin(Member.class, Member::getId ,Goodsorder::getMemberId);
|
queryWrapper.select("(select max(r.done_date) from refund r where r.obj_id=t.id and r.status=2 ) as refund_date");
|
queryWrapper.select("(select sum(r.money) from refund r where r.obj_id=t.id and r.status=2) as refund_money");
|
//时间段筛选
|
if (Objects.nonNull(model.getStartDate())){
|
queryWrapper.ge(Goodsorder::getPayDate, Utils.Date.getStart(model.getStartDate()));
|
}
|
if (Objects.nonNull(model.getEndDate())){
|
queryWrapper.le( Goodsorder::getPayDate, Utils.Date.getEnd(model.getEndDate()));
|
}
|
|
// queryWrapper.eq(model.getPayStatus() !=null,Goodsorder::getPayStatus,model.getPayStatus());
|
// queryWrapper.like(model.getCode() !=null,Goodsorder::getCode,model.getCode());
|
// queryWrapper.like(model.getId() !=null,Goodsorder::getId,model.getId());
|
// queryWrapper.eq(model.getStatus() !=null,Goodsorder::getStatus,model.getStatus());
|
// queryWrapper.like(model.getOnlineOrderid() !=null,Goodsorder::getOnlineOrderid,model.getOnlineOrderid());
|
// queryWrapper.like(model.getOpenid() !=null,Member::getOpenid,model.getOpenid());
|
queryWrapper.eq(Goodsorder::getIsdeleted,Constants.ZERO);
|
queryWrapper.eq(Goodsorder::getPayStatus,Constants.ONE);
|
queryWrapper.orderByAsc(Goodsorder::getPayDate);
|
goodsorderExportVOIPage = goodsorderJoinMapper.selectJoinPage(page, GoodsorderExportVO.class, queryWrapper);
|
}else{
|
MPJLambdaWrapper<Refund> queryWrapper = new MPJLambdaWrapper<>();
|
queryWrapper.selectAs(Refund::getMoney,GoodsorderExportVO::getRefundMoney);
|
queryWrapper.selectAs(Refund::getDoneDate,GoodsorderExportVO::getRefundDate);
|
queryWrapper.selectAs(Goodsorder::getCloseMoney,GoodsorderExportVO::getCloseMoney);
|
queryWrapper.selectAs(Goodsorder::getMoney,GoodsorderExportVO::getMoney);
|
queryWrapper.selectAs(Goodsorder::getId,GoodsorderExportVO::getId);
|
queryWrapper.selectAs(Goodsorder::getCode,GoodsorderExportVO::getCode);
|
queryWrapper.selectAs(Goodsorder::getPayDate,GoodsorderExportVO::getPayDate);
|
queryWrapper.selectAs(Member::getOpenid, GoodsorderExportVO::getOpenid);
|
queryWrapper.leftJoin(Goodsorder.class, Goodsorder::getId ,Refund::getObjId);
|
queryWrapper.leftJoin(Goodsorder.class, Goodsorder::getId ,Refund::getObjId);
|
queryWrapper.leftJoin(Member.class, Member::getId ,Goodsorder::getMemberId);
|
//时间段筛选
|
if (Objects.nonNull(model.getStartDate())){
|
queryWrapper.ge(Refund::getDoneDate, Utils.Date.getStart(model.getStartDate()));
|
}
|
if (Objects.nonNull(model.getEndDate())){
|
queryWrapper.le( Refund::getDoneDate, Utils.Date.getEnd(model.getEndDate()));
|
}
|
queryWrapper.eq(Refund::getStatus,Constants.TWO);//退款完成
|
queryWrapper.orderByAsc(Refund::getDoneDate);
|
goodsorderExportVOIPage = refundJoinMapper.selectJoinPage(page, GoodsorderExportVO.class, queryWrapper);
|
}
|
|
if (!CollectionUtils.isEmpty(goodsorderExportVOIPage.getRecords())){
|
goodsorderExportVOIPage.getRecords().forEach(s->{
|
s.setMoney(Constants.translateMoney(s.getMoney()));
|
s.setRefundMoney(Constants.translateMoney(s.getRefundMoney()));
|
s.setCloseMoney(Constants.translateMoney(s.getCloseMoney()).compareTo(s.getMoney()) > 0 ? s.getMoney() : Constants.translateMoney(s.getCloseMoney()));
|
});
|
}
|
return PageData.from(goodsorderExportVOIPage);
|
}
|
@Override
|
public List<GoodsorderExportVO> findExportAccountDetailPage(Goodsorder model){
|
model.setPayStatus(Constants.ONE); //只查询支付成功的
|
List<GoodsorderExportVO> goodsorderList = null;
|
if(Constants.formatIntegerNum(model.getType())==Constants.ZERO){
|
MPJLambdaWrapper<Goodsorder> queryWrapper = initQueryParamByModel(model);
|
queryWrapper.orderByAsc(Goodsorder::getPayDate);
|
goodsorderList = goodsorderJoinMapper.selectJoinList(GoodsorderExportVO.class,queryWrapper);
|
|
}else{
|
MPJLambdaWrapper<Refund> queryWrapper = new MPJLambdaWrapper<>();
|
queryWrapper.selectAs(Refund::getMoney,GoodsorderExportVO::getRefundMoney);
|
queryWrapper.selectAs(Refund::getDoneDate,GoodsorderExportVO::getRefundDate);
|
queryWrapper.selectAs(Goodsorder::getCode,GoodsorderExportVO::getCode);
|
queryWrapper.selectAs(Goodsorder::getId,GoodsorderExportVO::getId);
|
queryWrapper.selectAs(Goodsorder::getPayDate,GoodsorderExportVO::getPayDate);
|
queryWrapper.selectAs(Goodsorder::getCloseMoney,GoodsorderExportVO::getCloseMoney);
|
queryWrapper.selectAs(Goodsorder::getMoney,GoodsorderExportVO::getMoney);
|
queryWrapper.selectAs(Member::getOpenid, GoodsorderExportVO::getOpenid);
|
queryWrapper.leftJoin(Goodsorder.class, Goodsorder::getId ,Refund::getObjId);
|
queryWrapper.leftJoin(Goodsorder.class, Goodsorder::getId ,Refund::getObjId);
|
queryWrapper.leftJoin(Member.class, Member::getId ,Goodsorder::getMemberId);
|
//时间段筛选
|
if (Objects.nonNull(model.getStartDate())){
|
queryWrapper.ge(Refund::getDoneDate, Utils.Date.getStart(model.getStartDate()));
|
}
|
if (Objects.nonNull(model.getEndDate())){
|
queryWrapper.le( Refund::getDoneDate, Utils.Date.getEnd(model.getEndDate()));
|
}
|
queryWrapper.eq(Refund::getStatus,Constants.TWO);//退款完成
|
queryWrapper.orderByAsc(Refund::getDoneDate);;
|
goodsorderList = refundJoinMapper.selectJoinList(GoodsorderExportVO.class,queryWrapper);
|
}
|
if (!CollectionUtils.isEmpty(goodsorderList)){
|
goodsorderList.forEach(s->{
|
s.setMoney(Constants.translateMoney(s.getMoney()));
|
s.setCloseMoney(Constants.translateMoney(s.getCloseMoney()).compareTo(s.getMoney()) > 0 ? s.getMoney() : Constants.translateMoney(s.getCloseMoney()));
|
s.setRefundMoney(Constants.translateMoney(s.getRefundMoney()));
|
});
|
}
|
return goodsorderList;
|
}
|
private MPJLambdaWrapper<Goodsorder> initQueryParamByModel(Goodsorder model) {
|
Utils.MP.blankToNull(model);
|
MPJLambdaWrapper<Goodsorder> queryWrapper = new MPJLambdaWrapper<>();
|
queryWrapper.selectAll(Goodsorder.class);
|
queryWrapper.selectAs(Member::getOpenid, Goodsorder::getOpenid);
|
queryWrapper.leftJoin(Member.class, Member::getId ,Goodsorder::getMemberId);
|
queryWrapper.select("(select max(r.done_date) from refund r where r.obj_id=t.id and r.status=2 ) as refund_date");
|
queryWrapper.select("(select sum(r.money) from refund r where r.obj_id=t.id and r.status=2) as refund_money");
|
//时间段筛选
|
if (Objects.nonNull(model.getStartDate())){
|
queryWrapper.ge(Goodsorder::getPayDate, Utils.Date.getStart(model.getStartDate()));
|
}
|
if (Objects.nonNull(model.getEndDate())){
|
queryWrapper.le( Goodsorder::getPayDate, Utils.Date.getEnd(model.getEndDate()));
|
}
|
|
queryWrapper.eq(model.getPayStatus() !=null,Goodsorder::getPayStatus,model.getPayStatus());
|
queryWrapper.like(model.getCode() !=null,Goodsorder::getCode,model.getCode());
|
queryWrapper.like(model.getId() !=null,Goodsorder::getId,model.getId());
|
queryWrapper.eq(model.getStatus() !=null,Goodsorder::getStatus,model.getStatus());
|
queryWrapper.like(model.getOnlineOrderid() !=null,Goodsorder::getOnlineOrderid,model.getOnlineOrderid());
|
queryWrapper.like(model.getOpenid() !=null,Member::getOpenid,model.getOpenid());
|
queryWrapper.eq(Goodsorder::getIsdeleted,Constants.ZERO);
|
queryWrapper.eq(Goodsorder::getPayStatus,Constants.ONE);
|
|
return queryWrapper;
|
}
|
|
|
@Override
|
public PageData<Goodsorder> findPage(PageWrap<Goodsorder> pageWrap) {
|
IPage<Goodsorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
MPJLambdaWrapper<Goodsorder> queryWrapper = initQueryParamByModel(pageWrap.getModel());
|
queryWrapper.orderByDesc(Goodsorder::getPayDate);
|
queryWrapper.select("(select er.status from member_rides er where er.ordre_id=t.id order by er.create_date desc limit 1) as memberRidesStatus");
|
if(Objects.nonNull(pageWrap.getModel().getCloseStatus()) && pageWrap.getModel().getCloseStatus().equals(Constants.ZERO)){
|
queryWrapper.ne(Goodsorder::getStatus,Constants.GOODSORDER_STATUS.CLOSE.getKey());
|
}
|
if(Objects.nonNull(pageWrap.getModel().getCloseStatus()) && pageWrap.getModel().getCloseStatus().equals(Constants.ONE)){
|
queryWrapper.eq(Goodsorder::getStatus,Constants.GOODSORDER_STATUS.CLOSE.getKey());
|
}
|
IPage<Goodsorder> goodsorderIPage = goodsorderJoinMapper.selectJoinPage(page, Goodsorder.class, queryWrapper);
|
if (!CollectionUtils.isEmpty(goodsorderIPage.getRecords())){
|
goodsorderIPage.getRecords().forEach(s->{
|
s.setMoney(Constants.translateMoney(s.getMoney()));
|
s.setCloseMoney(Constants.translateMoney(s.getCloseMoney()));
|
s.setRefundMoney(Constants.translateMoney(s.getRefundMoney()));
|
});
|
}
|
return PageData.from(goodsorderIPage);
|
}
|
|
|
@Override
|
public long count(Goodsorder goodsorder) {
|
QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder);
|
return goodsorderMapper.selectCount(wrapper);
|
}
|
|
|
|
@Override
|
public HomeResponse getHome(String memberId){
|
HomeResponse homeResponse = new HomeResponse();
|
String fullPath = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.FILE_DIR).getCode() +
|
systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PROJECTS).getCode() ;
|
homeResponse.setParkName(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.PROJECT_NAME).getCode());
|
homeResponse.setServerPhone(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.SERVER_PHONE).getCode());
|
homeResponse.setLeaseNoticeUrl(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.LEASE_NOTICE_URL).getCode());
|
homeResponse.setLeaseNotice(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.LEASE_NOTICE).getCode());
|
homeResponse.setDeposit(new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_DEPOSIT).getCode()).multiply(BigDecimal.valueOf(100)));
|
homeResponse.setTips(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_NOTICE).getCode());
|
homeResponse.setLeaseVideoUrl(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_TIPS_VIDEO).getCode());
|
homeResponse.setStopServeTips(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.STOP_SERVE_TIPS).getCode());
|
homeResponse.setIsStopServe(this.checkTemporaryStop()?1:0);
|
homeResponse.setIsBusiness(this.checkBusiness()?0:1);
|
homeResponse.setUnBusinessTips("营业时间为"+ systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.BUSINESS_STARTTIME).getCode() +" ~ "+systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.BUSINESS_ENDTIME).getCode()+"，请在营业时间内使用本系统");
|
homeResponse.setAdList(adMapper.selectList(new QueryWrapper<Ad>()
|
.eq("isdeleted",Constants.ZERO)
|
.eq("status",Constants.ZERO)
|
.orderByAsc("sortnum")
|
));;
|
if(!Objects.isNull(homeResponse.getAdList())&&homeResponse.getAdList().size()>Constants.ZERO){
|
homeResponse.getAdList().forEach(i->{
|
i.setImgfullurl(fullPath + i.getImgurl());
|
});
|
}
|
homeResponse.setRideStatus(-1);
|
//查询是否存在 已支付的 押金订单
|
Goodsorder goodsorder = this.goodsorderMapper.selectOne(new QueryWrapper<Goodsorder>()
|
.eq("member_id",memberId)
|
.eq("status",Constants.goodsorderStatus.pay)
|
.last(" limit 1 "));
|
homeResponse.setDepositStatus(Constants.ZERO);
|
if(goodsorder!=null){
|
Refund r = this.refundMapper.selectOne(new QueryWrapper<Refund>().lambda()
|
.eq(Refund::getObjId,goodsorder.getId())
|
.eq(Refund::getIsdeleted,Constants.ZERO)
|
.eq(Refund::getStatus,Constants.ZERO)
|
.last("limit 1" ));
|
if(r!=null){
|
homeResponse.setDepositStatus(Constants.TWO);
|
}else{
|
homeResponse.setDepositStatus(Constants.ONE);
|
}
|
if( goodsorder.getStatus().equals(Constants.goodsorderStatus.pay)){
|
homeResponse.setGoodsOrderId(goodsorder.getId());
|
//查询当前骑行状态
|
MemberRides memberRides = memberRidesJoinMapper.selectOne(new QueryWrapper<MemberRides>().lambda()
|
.eq(MemberRides::getMemberId, memberId)
|
.eq(MemberRides::getOrdreId,goodsorder.getId())
|
.ne(MemberRides::getStatus,Constants.MEMBER_RIDES_STATUS.LOCKING_DEFEAT.getKey())
|
.orderByDesc(MemberRides::getCreateDate)
|
.last(" limit 1 "));
|
if (!Objects.isNull(memberRides)) {
|
homeResponse.setRideStatus(memberRides.getStatus());
|
MemberRidesResponse memberRidesResponse = new MemberRidesResponse();
|
BaseParam baseParam = baseParamMapper.selectById(memberRides.getParamId());
|
if(!Objects.isNull(baseParam)){
|
memberRidesResponse.setBikeType(baseParam.getName());
|
}
|
memberRidesResponse.setRideId(memberRides.getId());
|
memberRidesResponse.setRideStartTime(memberRides.getRentDate());
|
memberRidesResponse.setRideStartTimeStr(DateUtil.DateToStr(memberRides.getRentDate(),"HH:mm"));
|
memberRidesResponse.setRideEndTime(memberRides.getBackDate());
|
memberRidesResponse.setRideEndTimeStr(DateUtil.DateToStr(memberRides.getBackDate(),"HH:mm"));
|
memberRidesResponse.setRideTime(DateUtil.betweenMin(memberRides.getRentDate(),memberRides.getBackDate()));
|
memberRidesResponse.setBikeCode(memberRides.getBikeCode());
|
memberRidesResponse.setBasePrice(memberRides.getBasePrice());
|
memberRidesResponse.setBaseTime(memberRides.getBaseTime());
|
memberRidesResponse.setUnitTime(memberRides.getUnitTime());
|
memberRidesResponse.setUnitPrice(memberRides.getUnitPrice());
|
memberRidesResponse.setPriceRole(PricingDetailServiceImpl.getRoleNameByParam(
|
memberRidesResponse.getBasePrice(),memberRidesResponse.getBaseTime(),
|
memberRidesResponse.getUnitPrice()
|
,memberRidesResponse.getUnitTime()));
|
homeResponse.setMemberRidesResponse(memberRidesResponse);
|
}
|
}
|
}
|
|
|
return homeResponse;
|
}
|
|
|
@Override
|
public GoodsorderDetailDTO getGoodsorderDetailDTO(String id) {
|
|
List<PayOrderDTO> payOrderDTOList = new ArrayList<>();
|
Goodsorder goodsorder = goodsorderMapper.selectById(id);
|
if(goodsorder == null){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY );
|
}
|
QueryWrapper<Refund> refundQuery = new QueryWrapper<>();
|
refundQuery.lambda()
|
.eq(Refund::getObjId,id)
|
.orderByAsc(Refund::getDoneDate);
|
//查询所有有退款记录
|
List<Refund> refunds = refundMapper.selectList(refundQuery);
|
PayOrderDTO payOrderDTO = new PayOrderDTO();
|
payOrderDTO.setId(goodsorder.getId());
|
payOrderDTO.setOrderCode(goodsorder.getCode());
|
payOrderDTO.setPayWay(goodsorder.getPayWay());
|
payOrderDTO.setMoney(Constants.translateMoney(goodsorder.getMoney()));
|
payOrderDTO.setPayDate(goodsorder.getPayDate());
|
payOrderDTO.setRefundType(99);
|
payOrderDTO.setOnlineorderId(goodsorder.getOnlineOrderid());
|
payOrderDTOList.add(0,payOrderDTO);
|
if (!CollectionUtils.isEmpty(refunds)){
|
refunds.forEach(s->{
|
PayOrderDTO refundOrderDTO = new PayOrderDTO();
|
refundOrderDTO.setOrderCode(s.getObjId());
|
refundOrderDTO.setId(s.getId());
|
refundOrderDTO.setPayWay(s.getPayWay());
|
refundOrderDTO.setRefundType(s.getType());
|
refundOrderDTO.setMoney(Constants.translateMoney(s.getMoney()));
|
refundOrderDTO.setPayDate(s.getDoneDate());
|
refundOrderDTO.setOnlineorderId(s.getOnlineOrderid());
|
payOrderDTOList.add(refundOrderDTO);
|
});
|
}
|
MemberRidesQuery query = new MemberRidesQuery();
|
query.setGoodsorderId(goodsorder.getId());
|
List<BikeLogDTO> memberRides = MemberRidesServiceImpl.findBikeLogList(memberRidesJoinMapper,query);
|
GoodsorderDetailDTO goodsorderDetailDTO = new GoodsorderDetailDTO();
|
goodsorderDetailDTO.setPayOrderDTOList(payOrderDTOList);//交易明细
|
goodsorderDetailDTO.setMemberRidesList(memberRides);//骑行记录
|
goodsorderDetailDTO.setModel(goodsorder);//订单对象
|
return goodsorderDetailDTO;
|
}
|
@Override
|
public void forceCloseGoodsorder(String orderId) {
|
//查询订单 信息
|
if(StringUtils.isBlank(orderId)){
|
throw new BusinessException(ResponseStatus.BAD_REQUEST );
|
}
|
Goodsorder goodsorder = goodsorderMapper.selectById(orderId);
|
if(goodsorder == null ){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY );
|
}
|
if(Constants.formatIntegerNum(goodsorder.getStatus()) != Constants.GOODSORDER_STATUS.HAVING_PAY.getKey() ){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该订单当前状态不支持结算操作，请尝试刷新列表重试！" );
|
}
|
//订单结算
|
Date date = new Date();
|
goodsorder.setEditDate(date);
|
LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
goodsorder.setEditor(user.getId());
|
closeGoodsorder( goodsorder,Constants.REFUND_TYPE.PLAT_FORCE.getKey());
|
}
|
|
/**
|
* 发起退款申请
|
* @param goodsorder
|
* @param type
|
*/
|
@Transactional(rollbackFor = {Exception.class,BusinessException.class})
|
@Override
|
public void closeGoodsorder( Goodsorder goodsorder ,int type ) {
|
Refund r = refundMapper.selectOne(new QueryWrapper<Refund>().lambda()
|
.eq(Refund::getObjId,goodsorder.getId())
|
.eq(Refund::getIsdeleted,Constants.ZERO)
|
.eq(Refund::getStatus,Constants.ZERO)
|
.last("limit 1" ));
|
if(r != null){
|
throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "该订单存在退款申请正在处理中，请稍后查看订单信息哦~");
|
}
|
List<MemberRides> memberRides = getMemberRidesForClose(goodsorder.getId());
|
//默认结算为押金金额
|
BigDecimal closeMoney = new BigDecimal(0.00);
|
if (!CollectionUtils.isEmpty(memberRides)){
|
//骑行总时长
|
closeMoney = getCloseMoneyByRides(memberRides,true,goodsorder.getMoney()).getAmount();
|
//实际结算价格，记录在最高车型记录上
|
memberRides.get(0).setActualPrice(closeMoney);
|
}
|
int refundMoney =( Constants.formatDecimalNum(goodsorder.getMoney()).subtract(closeMoney)).intValue();//计算价格
|
if(refundMoney>0){
|
RefundDTO refundDTO = new RefundDTO();
|
refundDTO.setOrderId(goodsorder.getId());
|
refundDTO.setCanBalance(goodsorder.getMoney());
|
refundDTO.setRefundAmount(new BigDecimal(refundMoney));
|
refundDTO.setTotalAmount(goodsorder.getMoney());
|
refundDTO.setMemberId(goodsorder.getMemberId());
|
refundDTO.setReason(Constants.REFUND_TYPE.get(type).getName());
|
refundDTO.setCreator(goodsorder.getEditor());
|
refundDTO.setType(type);
|
boolean res = wxMiniUtilService.wxRefund(refundDTO);
|
}else{
|
//无退款结算
|
closeGoodsorderDoneNoRefund(goodsorder,type,new BigDecimal(0),null);
|
}
|
}
|
public void closeGoodsorderDoneNoRefund(Goodsorder goodsorder,int type,BigDecimal refundMoney,String closeId) {
|
log.error("========================================"+JSONObject.toJSONString(goodsorder));
|
if(goodsorder ==null || Constants.formatIntegerNum(goodsorder.getStatus()) != Constants.GOODSORDER_STATUS.HAVING_PAY.getKey()){
|
return;
|
}
|
BigDecimal closeMoney =( Constants.formatDecimalNum(goodsorder.getMoney()).subtract(refundMoney));
|
//进行订单结算业务处理
|
List<MemberRides> memberRides = getMemberRidesForClose(goodsorder.getId());
|
//默认结算为押金金额
|
if (!CollectionUtils.isEmpty(memberRides)){
|
//骑行总时长
|
for(MemberRides model :memberRides){
|
MemberRides up = new MemberRides();
|
up.setId(model.getId());
|
up.setActualPrice(model.getActualPrice());
|
up.setCloseDate(goodsorder.getEditDate());
|
up.setCloseStatus(Constants.ONE);
|
up.setEditor(goodsorder.getEditor());
|
up.setEditDate(goodsorder.getEditDate());
|
//更新骑行记录的计算金额和状态
|
memberRidesJoinMapper.updateById(up);
|
}
|
}
|
// BigDecimal closeMoney =( Constants.formatDecimalNum(goodsorder.getMoney()).subtract(refund.getMoney()));
|
//退款乐行
|
// int type =Constants.formatIntegerNum(refund.getType());
|
Goodsorder update = new Goodsorder();
|
update.setId(goodsorder.getId());
|
update.setStatus(Constants.GOODSORDER_STATUS.CLOSE.getKey());
|
update.setCloseMoney(closeMoney);
|
update.setCloseStatus(Constants.ONE);
|
update.setCloseDate(new Date());
|
update.setCloseInfo(Constants.REFUND_TYPE.get(type).getInfo());
|
update.setCloseUserId(goodsorder.getEditor());
|
if(Constants.REFUND_TYPE.PLAT_FORCE.getKey() == type){
|
//如果是强制结算
|
update.setCloseType(Constants.ONE);
|
// LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
// update.setEditor(principal.getId());
|
}else if(Constants.REFUND_TYPE.NORMAL.getKey() == type){
|
//如果是自行結算
|
update.setCloseType(Constants.ZERO);
|
}else{
|
//如果是平台自动结算
|
update.setCloseType(Constants.TWO);
|
}
|
update.setCloseId(closeId);
|
//存储 消费交易流水
|
Transactions transactions = new Transactions();
|
transactions.setId(Constants.getUUID());
|
transactions.setMemberId(goodsorder.getMemberId());
|
transactions.setCreateDate(new Date());
|
transactions.setIsdeleted(Constants.ZERO);
|
transactions.setOrderId(goodsorder.getId());
|
transactions.setMoney(closeMoney);
|
transactions.setType(Constants.TRANSACTIONS_TYPE.CONSUMPTION.getKey());
|
transactions.setDoneDate(new Date());
|
transactions.setTitle(Constants.TRANSACTIONS_TYPE.CONSUMPTION.getName());
|
transactions.setContent(Constants.TRANSACTIONS_TYPE.CONSUMPTION.getInfo());
|
transactions.setBalance(BigDecimal.ZERO);
|
transactions.setObjId(goodsorder.getId());
|
transactions.setObjType(Constants.ONE);
|
transactionsMapper.insert(transactions);
|
//修改订单信息
|
goodsorderMapper.updateById(update);
|
}
|
/**
|
* 退款成功回调
|
*/
|
@Transactional(rollbackFor = {Exception.class,BusinessException.class})
|
@Override
|
public void closeGoodsorderDone(RefundNotification param) {
|
//查询退款申请订单
|
Refund refund = refundMapper.selectById(param.getOutRefundNo());
|
if(refund == null
|
|| Constants.formatIntegerNum(refund.getIsdeleted()) == Constants.ONE
|
|| Constants.formatIntegerNum(refund.getStatus()) == Constants.TWO){
|
return;
|
}
|
if (!"SUCCESS".equals(param.getRefundStatus().name())) {
|
// 如果退款状态不正确，修改退款单状态
|
refund.setStatus(Constants.ONE);
|
refund.setEditDate(new Date());
|
refund.setOnlineOrderid(param.getTransactionId());
|
refund.setDoneDate(refund.getEditDate());
|
//更新退款单状态
|
refundMapper.updateById(refund);
|
return;
|
}
|
refund.setOnlineOrderid(param.getTransactionId());
|
doRefundTransactions(refund);
|
//退款乐行
|
int type =Constants.formatIntegerNum(refund.getType());
|
Goodsorder goodsorder = goodsorderMapper.selectById(refund.getObjId());
|
closeGoodsorderDoneNoRefund(goodsorder,refund.getType(),refund.getMoney(),refund.getId());
|
/* log.error("========================================"+JSONObject.toJSONString(goodsorder));
|
if(goodsorder ==null || Constants.formatIntegerNum(goodsorder.getStatus()) != Constants.GOODSORDER_STATUS.HAVING_PAY.getKey()){
|
return;
|
}
|
//进行订单结算业务处理
|
List<MemberRides> memberRides = getMemberRidesForClose(refund.getObjId());
|
//默认结算为押金金额
|
if (!CollectionUtils.isEmpty(memberRides)){
|
//骑行总时长
|
for(MemberRides model :memberRides){
|
MemberRides up = new MemberRides();
|
up.setId(model.getId());
|
up.setActualPrice(model.getActualPrice());
|
up.setCloseDate(goodsorder.getEditDate());
|
up.setCloseStatus(Constants.ONE);
|
up.setEditor(goodsorder.getEditor());
|
up.setEditDate(goodsorder.getEditDate());
|
//更新骑行记录的计算金额和状态
|
memberRidesJoinMapper.updateById(up);
|
}
|
}
|
|
Goodsorder update = new Goodsorder();
|
update.setId(goodsorder.getId());
|
update.setStatus(Constants.GOODSORDER_STATUS.CLOSE.getKey());
|
update.setCloseMoney(closeMoney);
|
update.setCloseStatus(Constants.ONE);
|
update.setCloseDate(new Date());
|
update.setCloseInfo(Constants.REFUND_TYPE.get(refund.getType()).getInfo());
|
update.setCloseUserId(goodsorder.getEditor());
|
if(Constants.REFUND_TYPE.PLAT_FORCE.getKey() == type){
|
//如果是强制结算
|
update.setCloseType(Constants.ONE);
|
// LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
// update.setEditor(principal.getId());
|
}else if(Constants.REFUND_TYPE.NORMAL.getKey() == type){
|
//如果是自行結算
|
update.setCloseType(Constants.ZERO);
|
}else{
|
//如果是平台自动结算
|
update.setCloseType(Constants.TWO);
|
}
|
update.setCloseId(refund.getId());
|
//存储 消费交易流水
|
Transactions transactions = new Transactions();
|
transactions.setId(Constants.getUUID());
|
transactions.setMemberId(goodsorder.getMemberId());
|
transactions.setCreateDate(new Date());
|
transactions.setIsdeleted(Constants.ZERO);
|
transactions.setOrderId(goodsorder.getId());
|
transactions.setMoney(goodsorder.getMoney().subtract(Constants.formatDecimalNum(refund.getMoney())));
|
transactions.setType(Constants.TRANSACTIONS_TYPE.CONSUMPTION.getKey());
|
transactions.setDoneDate(new Date());
|
transactions.setTitle(Constants.TRANSACTIONS_TYPE.CONSUMPTION.getName());
|
transactions.setContent(Constants.TRANSACTIONS_TYPE.CONSUMPTION.getInfo());
|
transactions.setBalance(BigDecimal.ZERO);
|
transactions.setObjId(goodsorder.getId());
|
transactions.setObjType(Constants.ONE);
|
transactionsMapper.insert(transactions);
|
//修改订单信息
|
goodsorderMapper.updateById(update);*/
|
}
|
|
private void doRefundTransactions(Refund refund ) {
|
//存储交易流水表
|
refund.setStatus(Constants.TWO);
|
refund.setEditDate(new Date());
|
refund.setDoneDate(refund.getEditDate());
|
//更新退款单状态
|
refundMapper.updateById(refund);
|
|
Transactions transactions = new Transactions();
|
transactions.setId(Constants.getUUID());
|
transactions.setMemberId(refund.getMemberId());
|
transactions.setCreateDate(new Date());
|
transactions.setIsdeleted(Constants.ZERO);
|
transactions.setOrderId(refund.getObjId());
|
transactions.setMoney(refund.getMoney());
|
transactions.setPreOrderid(refund.getObjId());
|
transactions.setOnlineOrderid(refund.getId());
|
transactions.setDoneDate(new Date());
|
if(refund.getType().equals(Constants.REFUND_TYPE.PLAT_AUTO.getKey())||refund.getType().equals(Constants.REFUND_TYPE.PLAT_FORCE.getKey())){
|
//平台自动退款 或 强制退款
|
transactions.setType(Constants.TRANSACTIONS_TYPE.REFUND.getKey());
|
transactions.setTitle(Constants.REFUND_TYPE.PLAT_AUTO.getInfo());
|
transactions.setContent(Constants.REFUND_TYPE.PLAT_AUTO.getInfo());
|
}else if(refund.getType().equals(Constants.REFUND_TYPE.NORMAL.getKey())){
|
//用户主动退款
|
transactions.setType(Constants.TRANSACTIONS_TYPE.REFUND.getKey());
|
transactions.setTitle(Constants.REFUND_TYPE.NORMAL.getInfo());
|
transactions.setContent(Constants.REFUND_TYPE.NORMAL.getInfo());
|
}else if(refund.getType().equals(Constants.REFUND_TYPE.BACK.getKey())){
|
//结算后退款
|
transactions.setType(Constants.TRANSACTIONS_TYPE.REFUND.getKey());
|
transactions.setTitle(Constants.REFUND_TYPE.BACK.getInfo());
|
transactions.setContent(Constants.REFUND_TYPE.BACK.getInfo());
|
}
|
transactions.setBalance(BigDecimal.ZERO);
|
transactions.setObjId(refund.getId());
|
transactions.setObjType(Constants.ONE);
|
transactionsMapper.insert(transactions);
|
}
|
|
private RidesDetailResponse getCloseMoneyByRides(List<MemberRides> memberRides,boolean isClose,BigDecimal yjMoney) {
|
RidesDetailResponse ridesDetailResponse = new RidesDetailResponse();
|
BigDecimal closeMoney = new BigDecimal(0.00);
|
int durationSum = 0;
|
MemberRides topRides =memberRides.get(0);
|
//取最高车型计算方案结算订单
|
for(MemberRides rides : memberRides){
|
if ( isClose && Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey()!=(Constants.formatIntegerNum(rides.getStatus()))){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"当前订单有未完成的骑行，无法强制结算");
|
}
|
durationSum += Constants.formatIntegerNum(rides.getDuration());//累计骑行（计费）时长
|
if(Constants.formatIntegerNum(topRides.getSortnum())<Constants.formatIntegerNum(rides.getSortnum())){
|
topRides = rides;
|
}
|
}
|
// MemberRides topRides =memberRides.get(0);
|
if(durationSum > 0 && topRides != null){
|
int baseTime =Constants.formatIntegerNum(topRides.getBaseTime());
|
closeMoney = Constants.formatDecimalNum(topRides.getBasePrice());
|
//如果是一口价方式，价格直接为一口价baseMoney,如果不是计算正常价格
|
if(baseTime != -1){//不是一口价
|
if(durationSum > baseTime && Constants.formatIntegerNum(topRides.getUnitTime())>0){
|
//如果超出了起步价格，计算超出价格
|
BigDecimal unit = new BigDecimal(durationSum-baseTime).divide(new BigDecimal(topRides.getUnitTime()), 0, BigDecimal.ROUND_UP);
|
//计算金额累计超出部门价格（超出时间单位*超出单位时间价格）
|
closeMoney = closeMoney.add(unit.multiply(Constants.formatDecimalNum(topRides.getUnitPrice())));
|
}
|
}
|
}
|
//如果订单价格封顶了，取订单 价格
|
if(Constants.compareBigdecimal(closeMoney, yjMoney) ==1){
|
closeMoney = yjMoney;
|
}
|
ridesDetailResponse.setDuration(durationSum);
|
ridesDetailResponse.setAmount(closeMoney);
|
ridesDetailResponse.setBikeType(topRides.getParamName());
|
return ridesDetailResponse;
|
}
|
|
private List<MemberRides> getMemberRidesForClose(String id) {
|
|
MPJLambdaWrapper<MemberRides> wrapper = new MPJLambdaWrapper<>();
|
wrapper.eq(MemberRides::getOrdreId,id);
|
wrapper.ne(MemberRides::getStatus,Constants.MEMBER_RIDES_STATUS.LOCKING_DEFEAT.getKey());
|
wrapper.selectAll(MemberRides.class)
|
.selectAs(BaseParam::getSortnum, MemberRides::getSortnum)
|
.selectAs(BaseParam::getName, MemberRides::getParamName);
|
wrapper.leftJoin(BaseParam.class, BaseParam::getId, MemberRides::getParamId);
|
wrapper.orderByDesc(BaseParam::getSortnum);
|
//取最高车型作为计价方案
|
//查询所有骑行记录
|
List<MemberRides> memberRides = memberRidesJoinMapper.selectList(wrapper);
|
return memberRides;
|
}
|
|
@Override
|
public void backGoodsorder(String orderId, BigDecimal money,String reason) {
|
LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
Goodsorder goodsorder = goodsorderMapper.selectById(orderId);
|
if(goodsorder == null){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "对不起，订单信息不存在，请刷新页面重试！");
|
}
|
if (Constants.formatIntegerNum(goodsorder.getStatus()) != Constants.GOODSORDER_STATUS.CLOSE.getKey()){
|
throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，该订单请结算后再退款~");
|
}
|
QueryWrapper<Refund> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(Refund::getObjId,orderId)
|
.eq(Refund::getStatus,Constants.TWO)
|
.eq(Refund::getIsdeleted,Constants.ZERO) ;
|
wrapper.select("sum(money) as money").last(" limit 1");
|
Refund total = refundMapper.selectOne(wrapper);
|
BigDecimal refundMoney = total == null?new BigDecimal(0):Constants.formatDecimalNum(total.getMoney());
|
//可退剩余 单位元
|
BigDecimal canBalance =Constants.translateMoney(Constants.formatDecimalNum(goodsorder.getMoney()).subtract(refundMoney));
|
if(canBalance.compareTo(money) >= Constants.ZERO){
|
RefundDTO refundDTO = new RefundDTO();
|
refundDTO.setOrderId(orderId);
|
refundDTO.setCanBalance(canBalance.multiply(new BigDecimal(100)));
|
refundDTO.setRefundAmount(money.multiply(new BigDecimal(100)));
|
refundDTO.setTotalAmount(goodsorder.getMoney());
|
refundDTO.setMemberId(goodsorder.getMemberId());
|
refundDTO.setCreator(principal.getId());
|
refundDTO.setReason(reason);
|
refundDTO.setType(Constants.REFUND_TYPE.BACK.getKey());
|
//发起退款申请
|
wxMiniUtilService.wxRefund(refundDTO);
|
}else {
|
throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，退款金额不允许超过"+canBalance+"元");
|
}
|
}
|
|
@Override
|
public GoodsorderCanBanlanceDTO getGoodsorderCanBanlanceDTO(String orderId) {
|
|
Goodsorder goodsorder = goodsorderMapper.selectById(orderId);
|
if(goodsorder ==null){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY);
|
}
|
QueryWrapper<Refund> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(Refund::getObjId,orderId)
|
.eq(Refund::getStatus,Constants.TWO)
|
.eq(Refund::getIsdeleted,Constants.ZERO) ;
|
wrapper.select("sum(money) as money").last(" limit 1");
|
Refund total = refundMapper.selectOne(wrapper);
|
GoodsorderCanBanlanceDTO goodsorderCanBanlanceDTO = new GoodsorderCanBanlanceDTO();
|
goodsorderCanBanlanceDTO.setGoodsorderMoney( Constants.translateMoney(goodsorder.getMoney()));
|
goodsorderCanBanlanceDTO.setCloseMoney(Constants.translateMoney(goodsorder.getCloseMoney()));
|
BigDecimal reduce = total!=null?Constants.formatDecimalNum(total.getMoney()):new BigDecimal(0);
|
goodsorderCanBanlanceDTO.setHasRefundMoney(Constants.translateMoney(reduce));
|
|
BigDecimal subtract = Constants.translateMoney(goodsorder.getMoney()).subtract(goodsorderCanBanlanceDTO.getHasRefundMoney());
|
goodsorderCanBanlanceDTO.setCanBanlanceMoney(subtract.compareTo(new BigDecimal("0")) > 0 ? subtract : new BigDecimal("0"));
|
return goodsorderCanBanlanceDTO;
|
}
|
|
@Override
|
public GoodsorderTotalDataVO getTotalData(Goodsorder param){
|
|
GoodsorderTotalDataVO model = new GoodsorderTotalDataVO();
|
model.setPayMoney(new BigDecimal(0.00));
|
model.setRefundMoney(new BigDecimal(0.00));
|
model.setClosedMoney(new BigDecimal(0.00));
|
model.setUnClosedMoney(new BigDecimal(0.00));
|
model.setClosedNum(0);
|
model.setUnClosedNum(0);
|
model.setPayNum(0);
|
model.setRefundNum(0);
|
QueryWrapper<Goodsorder> queryWrapper = new QueryWrapper<>();
|
if(Objects.nonNull(param.getStartDate())){
|
queryWrapper.lambda().ge(param.getStartDate() !=null,Goodsorder::getPayDate, Utils.Date.getStart(param.getStartDate()));
|
}
|
if(Objects.nonNull(param.getEndDate())) {
|
queryWrapper.lambda().le(param.getEndDate() != null, Goodsorder::getPayDate, Utils.Date.getEnd(param.getEndDate()));
|
}
|
queryWrapper.lambda().eq(Goodsorder::getPayStatus, Constants.ONE);//已支付
|
queryWrapper.lambda().eq(Goodsorder::getIsdeleted, Constants.ZERO);
|
queryWrapper.lambda().groupBy(Goodsorder::getStatus);
|
queryWrapper.select( "status ","count(id) as count_num"
|
,"sum(money) as money","sum(close_money) as close_money" );
|
//按订单状态分组统计
|
List<Goodsorder> detailList = goodsorderMapper.selectList(queryWrapper);
|
for(Goodsorder goodsorder : detailList){
|
if(Constants.formatIntegerNum(goodsorder.getStatus()) == Constants.GOODSORDER_STATUS.CLOSE.getKey()){
|
//已结算
|
model.setClosedNum(model.getClosedNum()+goodsorder.getCountNum());
|
//修改bug 结算收入 = 支付金额-退款-未结算
|
// model.setClosedMoney(model.getClosedMoney().add(Constants.translateMoney(goodsorder.getCloseMoney())));
|
|
model.setPayNum(model.getPayNum()+goodsorder.getCountNum());
|
model.setPayMoney(model.getPayMoney().add(Constants.translateMoney(goodsorder.getMoney())));
|
}else if(Constants.formatIntegerNum(goodsorder.getStatus()) == Constants.GOODSORDER_STATUS.HAVING_PAY.getKey()){
|
//已支付未结算
|
model.setUnClosedNum(model.getUnClosedNum()+goodsorder.getCountNum());
|
model.setUnClosedMoney(model.getUnClosedMoney().add(Constants.translateMoney(goodsorder.getMoney())));
|
|
model.setPayNum(model.getPayNum()+goodsorder.getCountNum());
|
model.setPayMoney(model.getPayMoney().add(Constants.translateMoney(goodsorder.getMoney())));
|
}
|
}
|
QueryWrapper<Refund> queryWrapper2 = new QueryWrapper<>();
|
if(Objects.nonNull(param.getStartDate())) {
|
queryWrapper2.lambda().ge(Refund::getDoneDate, Utils.Date.getStart(param.getStartDate()));
|
}
|
if(Objects.nonNull(param.getEndDate())) {
|
queryWrapper2.lambda().le(Refund::getDoneDate, Utils.Date.getEnd(param.getEndDate()));
|
}
|
queryWrapper2.lambda().eq(Refund::getIsdeleted, Constants.ZERO);
|
queryWrapper2.select( "count(id) as count_num"
|
,"sum(money) as money" );
|
//统计退款数据
|
Refund refund = refundMapper.selectOne(queryWrapper2.last("limit 1"));
|
if(refund !=null){
|
model.setRefundNum(Constants.formatIntegerNum(refund.getCountNum()));
|
model.setRefundMoney(Constants.translateMoney(Constants.formatDecimalNum(refund.getMoney())));
|
}
|
model.setClosedMoney(model.getPayMoney().subtract(model.getRefundMoney()).subtract(model.getUnClosedMoney()));
|
return model;
|
}
|
@Override
|
public RidesDetailResponse getRidesDetailResponse(String id) {
|
Goodsorder goodsorder = goodsorderMapper.selectById(id);
|
if(goodsorder ==null){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY);
|
}
|
|
List<MemberRides> memberRides = memberRidesJoinMapper.selectJoinList(MemberRides.class,new MPJLambdaWrapper<MemberRides>()
|
.selectAll(MemberRides.class)
|
.selectAs(BaseParam::getName,MemberRides::getParamName)
|
.selectAs(BaseParam::getSortnum,MemberRides::getSortnum)
|
.leftJoin(BaseParam.class,BaseParam::getId,MemberRides::getParamId)
|
.eq(MemberRides::getOrdreId,id)
|
.in(MemberRides::getStatus,Constants.MEMBER_RIDES_STATUS.RIDES_RUNNING.getKey(),Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey())
|
.orderByDesc(MemberRides::getCreateDate));
|
if (!CollectionUtils.isEmpty(memberRides)){
|
//预计结算价格和计算时长
|
int freeTime = 0;
|
try {
|
freeTime = Integer.parseInt(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME, Constants.FREE_RENT_TIME).getCode());
|
}catch (Exception e){
|
}
|
int finalFreeTime = freeTime;
|
List<MemberRidesResponse> collect = memberRides.stream().map(s -> {
|
MemberRidesResponse memberRidesResponse = new MemberRidesResponse();
|
Date endTime =s.getBackDate();
|
int rideTime =DateUtil.betweenMin(s.getRentDate(), endTime);
|
memberRidesResponse.setRideStartTime(s.getRentDate());
|
memberRidesResponse.setRideEndTime(endTime);
|
memberRidesResponse.setRideTime(rideTime);
|
if(!s.getStatus().equals(Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey())){
|
memberRidesResponse.setDuration(finalFreeTime >= rideTime?0:rideTime);
|
}else{
|
memberRidesResponse.setDuration(s.getDuration());
|
}
|
memberRidesResponse.setBikeType(s.getParamName());
|
memberRidesResponse.setBikeCode(s.getBikeCode());
|
memberRidesResponse.setBasePrice(s.getBasePrice());
|
memberRidesResponse.setBaseTime(s.getBaseTime());
|
memberRidesResponse.setUnitPrice(s.getUnitPrice());
|
memberRidesResponse.setUnitTime(s.getUnitTime());
|
if ( Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey()!=(Constants.formatIntegerNum(s.getStatus()))){
|
//如果是骑行中
|
s.setDuration(rideTime> finalFreeTime ?(rideTime):0);
|
}
|
s.setRideTime(rideTime);
|
return memberRidesResponse;
|
}).collect(Collectors.toList());
|
//累计和预算结算金额
|
RidesDetailResponse ridesDetailResponse = getCloseMoneyByRides(memberRides,false,goodsorder.getMoney());
|
if(Constants.formatIntegerNum(goodsorder.getStatus())!= Constants.goodsorderStatus.pay){
|
//如果非已支付但未结算，使用订单金额
|
ridesDetailResponse.setAmount(goodsorder.getCloseMoney());
|
}
|
ridesDetailResponse.setMemberRidesResponseList(collect);
|
return ridesDetailResponse;
|
}
|
|
return new RidesDetailResponse();
|
}
|
|
@Override
|
public Object createGoodsOrderPay(String memberId){
|
Member member = memberMapper.selectById(memberId);
|
if(Objects.isNull(member)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到用户对象信息");
|
}
|
Goodsorder qry = new Goodsorder();
|
qry.setStatus(Constants.goodsorderStatus.pay);
|
qry.setMemberId(memberId);
|
qry.setIsdeleted(Constants.ZERO);
|
if(goodsorderMapper.selectCount(new QueryWrapper<>(qry))>Constants.ZERO){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"已支付过定金，无法重复该操作");
|
}
|
//是否处于小程序停止服务时间内
|
if(this.checkTemporaryStop()){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.STOP_SERVE_TIPS).getCode());
|
};
|
//是否处于营业时间
|
if(this.checkBusiness()){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"营业时间为"+ systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.BUSINESS_STARTTIME).getCode() +" ~ "+systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.BUSINESS_ENDTIME).getCode()+"，请在营业时间内使用本系统");
|
};
|
Goodsorder goodsorder = new Goodsorder();
|
goodsorder.setId(Constants.getUUID());
|
goodsorder.setCreateDate(new Date());
|
goodsorder.setIsdeleted(Constants.ZERO);
|
goodsorder.setCode(goodsorder.getId());
|
goodsorder.setMemberId(memberId);
|
goodsorder.setMoney(new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_DEPOSIT).getCode()).multiply(new BigDecimal(100)));
|
goodsorder.setStatus(Constants.goodsorderStatus.waitPay);
|
goodsorder.setPreOrderid(goodsorder.getId());
|
goodsorder.setPayStatus(Constants.goodsorderPayStatus.waitPay);
|
goodsorder.setPayWay(Constants.ZERO);
|
this.goodsorderMapper.insert(goodsorder);
|
//调起支付
|
Object response = null;
|
try {
|
response = getWxPayResponse(goodsorder,member.getOpenid());
|
} catch (Exception e) {
|
throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，发起支付失败~");
|
}
|
|
return response;
|
}
|
|
private Object getWxPayResponse(Goodsorder goodsorder,String openid) throws Exception {
|
//调起支付
|
Object response = null;
|
PrepayRequest request = new PrepayRequest();
|
request.setAttach("createGoodsOrder");
|
request.setDescription("森林公园自行车骑行押金支付");
|
request.setSpMchid(WxMiniConfig.wxProperties.getMchId());
|
request.setSpAppid(WxMiniConfig.wxProperties.getAppId());
|
request.setSubMchid(WxMiniConfig.wxProperties.getSubMchId());
|
request.setSubAppid(WxMiniConfig.wxProperties.getSubAppId());
|
Payer payer = new Payer();
|
payer.setSubOpenid(openid);
|
request.setPayer(payer);
|
request.setOutTradeNo(goodsorder.getId());
|
request.setNotifyUrl(WxMiniConfig.wxProperties.getNotifyUrl());//这个回调url必须是https开头的
|
Amount amount = new Amount();
|
amount.setTotal(goodsorder.getMoney().intValue());
|
request.setAmount(amount);
|
// PrepayResponse res = WxMiniConfig.wxPayService.prepay(request);
|
// 跟之前下单示例一样，填充预下单参数
|
PrepayWithRequestPaymentResponse resParam = WxMiniConfig.jsapiExtService.prepayWithRequestPayment(request,WxMiniConfig.wxProperties.getSubAppId());
|
response =resParam;
|
|
return response;
|
|
}
|
|
|
/**
|
* 验证营业时间
|
*/
|
@Override
|
public Boolean checkBusiness(){
|
String businessStartTime = systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.BUSINESS_STARTTIME).getCode();
|
String businessEndTime = systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.BUSINESS_ENDTIME).getCode();
|
LocalTime currentTime = LocalTime.now();
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("HH:mm");
|
String nowTime = currentTime.format(formatter);
|
try {
|
if(Integer.valueOf(nowTime.replace(":",""))<= Integer.valueOf(businessStartTime.replace(":",""))
|
||Integer.valueOf(nowTime.replace(":","")) > Integer.valueOf(businessEndTime.replace(":",""))){
|
return true;
|
}
|
}catch (Exception e){
|
return true;
|
}
|
return false;
|
}
|
|
/**
|
* 临时停止服务 未交押金的用户，无法扫车使用；已经交过押金的用户可以继续扫码骑行；
|
*/
|
@Override
|
public Boolean checkTemporaryStop(){
|
if(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.IS_STOP_SERVE).getCode().equals(Constants.ONE.toString())){
|
String stopServeStartTime = systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.STOP_SERVE_STARTTIME).getCode();
|
String stopServeEndTime = systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.STOP_SERVE_ENDTIME).getCode();
|
//查询当前时间是否在停止中
|
long s = DateUtil.StringToDate(stopServeStartTime).getTime();
|
long e = DateUtil.StringToDate(stopServeEndTime).getTime();
|
if(e>System.currentTimeMillis()&&s<=System.currentTimeMillis()){
|
return true;
|
}
|
}
|
return false;
|
}
|
|
|
@Override
|
public void autoCancelRefunOrder(){
|
Date date = new Date(System.currentTimeMillis()-5*60L*1000L);
|
List<Refund> list = refundMapper.selectList(new QueryWrapper<Refund>().lambda()
|
.eq(Refund::getStatus,Constants.ZERO)
|
.lt(Refund::getCreateDate,date));
|
if(list !=null && list.size()>0){
|
List<String> cancelIds = new ArrayList<>();
|
for(Refund r:list){
|
com.wechat.pay.java.service.refund.model.Refund res =wxMiniUtilService.isSuucessRefund(r.getId());
|
if(res !=null){
|
//如果退款成功
|
RefundNotification param = new RefundNotification();
|
param.setRefundStatus(Status.SUCCESS);
|
param.setOutRefundNo(r.getId());
|
param.setTransactionId(res.getTransactionId());
|
//执行关闭订单业务
|
closeGoodsorderDone(param);
|
}else{
|
//放入取消集合中
|
cancelIds.add(r.getId());
|
}
|
}
|
if(cancelIds.size()>0){
|
refundMapper.update(null, new UpdateWrapper<Refund>().lambda()
|
.in(Refund::getId,cancelIds)
|
.set(Refund::getStatus,Constants.ONE)
|
.set(Refund::getEditDate,new Date())
|
.set(Refund::getInfo,"超时未回调，自动取消")
|
);
|
}
|
}
|
}
|
|
@Override
|
public void autoCloseOrder( ) {
|
Goodsorder goodsorder = new Goodsorder();
|
goodsorder.setIsdeleted(Constants.ZERO);
|
goodsorder.setStatus(Constants.goodsorderStatus.pay);
|
List<Goodsorder> list = findList(goodsorder);
|
if (!CollectionUtils.isEmpty(list)){
|
Date date = new Date();
|
list.forEach(s->{
|
try {
|
s.setEditDate(date);
|
s.setEditor(null);
|
s.setCloseDate(date);
|
closeGoodsorder(s,Constants.REFUND_TYPE.PLAT_AUTO.getKey());
|
}catch (BusinessException e){
|
}catch (Exception e){
|
|
}
|
});
|
}
|
|
}
|
@Override
|
public void goodsOrderSettlement(String memberId) {
|
Goodsorder goodsorder = this.goodsorderMapper.selectOne(new QueryWrapper<Goodsorder>()
|
.eq("member_id",memberId)
|
.eq("status",Constants.goodsorderStatus.pay)
|
.last(" limit 1 "));
|
if(Objects.isNull(goodsorder)){
|
throw new BusinessException(ResponseStatus.NO_UNCLOSEED_ORDER.getCode(),"无骑行订单记录");
|
}
|
if(Constants.formatIntegerNum(goodsorder.getStatus()) != Constants.GOODSORDER_STATUS.HAVING_PAY.getKey() ){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该订单当前状态不支持结算操作，请尝试刷新列表重试！" );
|
}
|
//订单结算
|
Date date = new Date();
|
goodsorder.setEditDate(date);
|
goodsorder.setEditor(null);
|
closeGoodsorder( goodsorder,Constants.REFUND_TYPE.NORMAL.getKey());
|
}
|
|
|
@Override
|
public String payNotify(String preOrderId,String paymentNo){
|
Goodsorder goodsorder = this.goodsorderMapper.selectById(preOrderId);
|
if(goodsorder.getStatus()==Constants.goodsorderStatus.pay){
|
return ("处理成功!");
|
}
|
goodsorder.setOnlineOrderid(paymentNo);
|
goodsorder.setPayStatus(Constants.goodsorderPayStatus.pay);
|
goodsorder.setStatus(Constants.goodsorderStatus.pay);
|
goodsorder.setPayDate(new Date());
|
goodsorder.setEditDate(new Date());
|
goodsorderMapper.updateById(goodsorder);
|
//存储交易流水表
|
Transactions transactions = new Transactions();
|
transactions.setMemberId(goodsorder.getMemberId());
|
transactions.setCreateDate(new Date());
|
transactions.setIsdeleted(Constants.ZERO);
|
transactions.setOrderId(goodsorder.getId());
|
transactions.setMoney(goodsorder.getMoney());
|
transactions.setType(Constants.TRANSACTIONS_TYPE.DEPOSIT.getKey());
|
transactions.setPreOrderid(goodsorder.getPreOrderid());
|
transactions.setOnlineOrderid(goodsorder.getOnlineOrderid());
|
transactions.setDoneDate(new Date());
|
transactions.setTitle(Constants.TRANSACTIONS_TYPE.DEPOSIT.getName());
|
transactions.setContent(Constants.TRANSACTIONS_TYPE.DEPOSIT.getInfo());
|
transactions.setBalance(goodsorder.getMoney());
|
transactions.setObjId(goodsorder.getId());
|
transactions.setObjType(Constants.ZERO);
|
transactionsMapper.insert(transactions);
|
return ("处理成功!");
|
}
|
|
|
|
/**
|
* 得到request对象
|
*
|
* @return
|
*/
|
public HttpServletRequest getRequest() {
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
return request;
|
}
|
|
public String getIpAddr() {
|
HttpServletRequest request = this.getRequest();
|
String ipAddress = null;
|
try {
|
ipAddress = request.getHeader("x-forwarded-for");
|
if (ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {
|
ipAddress = request.getHeader("Proxy-Client-IP");
|
}
|
if (ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {
|
ipAddress = request.getHeader("WL-Proxy-Client-IP");
|
}
|
if (ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {
|
ipAddress = request.getRemoteAddr();
|
if (ipAddress.equals("127.0.0.1")) {
|
// 根据网卡取本机配置的IP
|
InetAddress inet = null;
|
try {
|
inet = InetAddress.getLocalHost();
|
} catch (UnknownHostException e) {
|
e.printStackTrace();
|
}
|
ipAddress = inet.getHostAddress();
|
}
|
}
|
// 对于通过多个代理的情况，第一个IP为客户端真实IP,多个IP按照','分割
|
if (ipAddress != null && ipAddress.length() > 15) { // "***.***.***.***".length()
|
// = 15
|
if (ipAddress.indexOf(",") > 0) {
|
ipAddress = ipAddress.substring(0, ipAddress.indexOf(","));
|
}
|
}
|
} catch (Exception e) {
|
ipAddress = "47.111.178.164";
|
}
|
// ipAddress = this.getRequest().getRemoteAddr();
|
|
return ipAddress;
|
}
|
|
|
}
|
