From 1b0cf0db5c82ea8308d2f338973a91555787c34d Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 18 三月 2025 11:17:23 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev --- server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java | 822 +++++++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 661 insertions(+), 161 deletions(-) diff --git a/server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java index 9ad6314..f31398b 100644 --- a/server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java +++ b/server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java @@ -16,18 +16,28 @@ 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.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.binarywang.wxpay.bean.notify.WxPayNotifyResponse; import com.github.binarywang.wxpay.bean.request.BaseWxPayRequest; import com.github.binarywang.wxpay.bean.request.WxPayUnifiedOrderRequest; @@ -36,8 +46,10 @@ 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; @@ -47,10 +59,10 @@ import java.net.InetAddress; import java.net.UnknownHostException; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; -import java.util.Objects; +import java.sql.Ref; +import java.time.LocalTime; +import java.time.format.DateTimeFormatter; +import java.util.*; import java.util.stream.Collectors; @Service @@ -67,8 +79,6 @@ @Autowired private SystemDictDataBiz systemDictDataBiz; - @Autowired - private MemberRidesMapper memberRidesMapper; @Autowired private MemberMapper memberMapper; @@ -77,12 +87,26 @@ @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) { @@ -132,7 +156,12 @@ @Override public Goodsorder findOne(Goodsorder goodsorder) { QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder); - return goodsorderMapper.selectOne(wrapper); + return goodsorderMapper.selectOne(wrapper.last(" limit 1")); + } + + @Override + public Goodsorder findOneByWrapper(QueryWrapper<Goodsorder> wrapper) { + return goodsorderMapper.selectOne(wrapper.last(" limit 1")); } @Override @@ -140,37 +169,166 @@ 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 = new MPJLambdaWrapper<>(); - Utils.MP.blankToNull(pageWrap.getModel()); - - if (pageWrap.getModel().getCode() != null) { - queryWrapper.like(Goodsorder::getCode, pageWrap.getModel().getCode()); + 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 (pageWrap.getModel().getStatus() != null) { - queryWrapper.eq(Goodsorder::getStatus, pageWrap.getModel().getStatus()); + if(Objects.nonNull(pageWrap.getModel().getCloseStatus()) && pageWrap.getModel().getCloseStatus().equals(Constants.ONE)){ + queryWrapper.eq(Goodsorder::getStatus,Constants.GOODSORDER_STATUS.CLOSE.getKey()); } - - if (pageWrap.getModel().getOnlineOrderid() != null) { - queryWrapper.eq(Goodsorder::getOnlineOrderid, pageWrap.getModel().getOnlineOrderid()); + 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())); + }); } - - if (pageWrap.getModel().getPayDate() != null) { - queryWrapper.ge(Goodsorder::getPayDate, Utils.Date.getStart(pageWrap.getModel().getPayDate())); - queryWrapper.le(Goodsorder::getPayDate, Utils.Date.getEnd(pageWrap.getModel().getPayDate())); - } - - queryWrapper.orderByDesc(Goodsorder::getCreateDate); - queryWrapper.selectAll(Goodsorder.class) - .selectAs(Member::getName,Goodsorder::getMemberName) - .leftJoin(Member.class,Member::getId,Goodsorder::getMemberId) - .like(StringUtils.isNotBlank(pageWrap.getModel().getMemberName()),Member::getName,pageWrap.getModel().getMemberName()); - return PageData.from(goodsorderJoinMapper.selectJoinPage(page, Goodsorder.class,queryWrapper)); + return PageData.from(goodsorderIPage); } + @Override public long count(Goodsorder goodsorder) { @@ -183,24 +341,44 @@ @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())); - homeResponse.setTips(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.TIPS).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.setPricingRules(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PRICING_RULE).getCode()); - //鏌ヨ鏄惁瀛樺湪 宸叉敮浠樼殑 鎶奸噾璁㈠崟 - Integer status = this.goodsorderMapper.selectCount(new QueryWrapper<Goodsorder>() - .eq("member_id",memberId) - .eq("status",Constants.goodsorderStatus.pay)); - homeResponse.setDepositStatus(status); + 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); - if(homeResponse.getDepositStatus()==Constants.goodsorderStatus.pay) { + //鏌ヨ鏄惁瀛樺湪 宸叉敮浠樼殑 鎶奸噾璁㈠崟 + Goodsorder goodsorder = this.goodsorderMapper.selectOne(new QueryWrapper<Goodsorder>() + .eq("member_id",memberId) + .eq("status",Constants.goodsorderStatus.pay) + .last(" limit 1 ")); + if(!Objects.isNull(goodsorder)&&goodsorder.getStatus().equals(Constants.goodsorderStatus.pay)){ + homeResponse.setDepositStatus(Constants.goodsorderStatus.pay); + homeResponse.setGoodsOrderId(goodsorder.getId()); //鏌ヨ褰撳墠楠戣鐘舵�� - MemberRides memberRides = memberRidesMapper.selectOne(new QueryWrapper<MemberRides>().eq("member_id", memberId) - .orderByDesc(" create_date ") + 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()); @@ -209,21 +387,26 @@ 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.setRideTime(DateUtil.betweenMin(memberRidesResponse.getRideStartTime(),memberRidesResponse.getRideEndTime())); + 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(memberRidesResponse.getUnitTime()); - memberRidesResponse.setUnitPrice(memberRidesResponse.getUnitPrice()); + 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; } - @Autowired - private TransactionsMapper transactionsMapper; @Override @@ -231,157 +414,378 @@ 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); + .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(goodsorder.getMoney()); + 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.getCode()); + refundOrderDTO.setOrderCode(s.getObjId()); + refundOrderDTO.setId(s.getId()); refundOrderDTO.setPayWay(s.getPayWay()); refundOrderDTO.setRefundType(s.getType()); - refundOrderDTO.setMoney(s.getMoney()); + refundOrderDTO.setMoney(Constants.translateMoney(s.getMoney())); refundOrderDTO.setPayDate(s.getDoneDate()); + refundOrderDTO.setOnlineorderId(s.getOnlineOrderid()); payOrderDTOList.add(refundOrderDTO); }); } - MPJLambdaWrapper<MemberRides> wrapper = new MPJLambdaWrapper<>(); - wrapper.leftJoin(BaseParam.class,BaseParam::getId,MemberRides::getParamId) - .eq(BaseParam::getType, Constants.THREE); - List<MemberRides> memberRides = memberRidesJoinMapper.selectJoinList(MemberRides.class, wrapper); + 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.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()); + } + + @Transactional(rollbackFor = {Exception.class,BusinessException.class}) + @Override + public void closeGoodsorder( Goodsorder goodsorder ,int type ) { + + 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); + 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.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); + } + 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(update.getEditor()); + refundDTO.setType(type); + Refund refund = wxMiniUtilService.wxRefund(refundDTO); + 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(new BigDecimal(refundMoney))); + 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 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()); + //濡傛灉鏄竴鍙d环鏂瑰紡锛屼环鏍肩洿鎺ヤ负涓�鍙d环baseMoney,濡傛灉涓嶆槸璁$畻姝e父浠锋牸 + if(baseTime != -1){//涓嶆槸涓�鍙d环 + 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 closerGoodsorder(String id) { - - + public void backGoodsorder(String orderId, BigDecimal money,String reason) { LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); - Goodsorder goodsorder = goodsorderMapper.selectById(id); - QueryWrapper<MemberRides> wrapper = new QueryWrapper<>(); + 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(MemberRides::getOrdreId,id); - List<MemberRides> memberRides = memberRidesMapper.selectList(wrapper); - if (!CollectionUtils.isEmpty(memberRides)){ - boolean exitUnBack = memberRides.stream().anyMatch(s -> !Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey().equals(s.getStatus())); - if (exitUnBack){ - throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"褰撳墠璁㈠崟鏈夋湭瀹屾垚鐨勯獞琛岋紝鏃犳硶寮哄埗缁撶畻"); - } - - PricingRuleDTO pricingRule = pricingRuleService.getPricingRule(memberRides); - RidesDetailResponse ridesDetailResponse = new RidesDetailResponse(); - List<MemberRidesResponse> collect = memberRides.stream().map(s -> { - MemberRidesResponse memberRidesResponse = new MemberRidesResponse(); - memberRidesResponse.setRideStartTime(s.getRentDate()); - memberRidesResponse.setRideEndTime(s.getBackDate()); - memberRidesResponse.setRideTime(DateUtil.betweenMin(memberRidesResponse.getRideStartTime(), memberRidesResponse.getRideEndTime())); - memberRidesResponse.setDuration(s.getDuration()); - memberRidesResponse.setBikeType(s.getParamName()); - memberRidesResponse.setBikeCode(s.getBikeCode()); - memberRidesResponse.setBasePrice(s.getBasePrice()); - memberRidesResponse.setBaseTime(s.getBaseTime()); - memberRidesResponse.setUnitPrice(s.getUnitTime()); - memberRidesResponse.setUnitTime(s.getUnitTime()); - return memberRidesResponse; - }).collect(Collectors.toList()); - - Integer durationSum = memberRides.stream().filter(s -> s.getDuration() > 0).mapToInt(s -> s.getDuration()).sum(); - if (durationSum > pricingRule.getMemberRides().getBaseTime()){ - BigDecimal basePrice = pricingRule.getMemberRides().getBasePrice(); - BigDecimal multiply = pricingRule.getMemberRides().getUnitPrice().multiply(new BigDecimal((durationSum - pricingRule.getMemberRides().getBaseTime()))); - ridesDetailResponse.setAmount(basePrice.add(multiply)); - }else { - ridesDetailResponse.setAmount(pricingRule.getMemberRides().getBasePrice()); - } - ridesDetailResponse.setBikeType(pricingRule.getBikeType()); - ridesDetailResponse.setDuration(durationSum); - ridesDetailResponse.setMemberRidesResponseList(collect); - - - Refund refund = new Refund(); - refund.setCreateDate(new Date()); - refund.setCreator(principal.getId()); - refund.setEditDate(new Date()); - refund.setEditor(principal.getId()); - refund.setIsdeleted(Constants.ZERO); - refund.setInfo("绯荤粺缁撶畻鍚庤鍗曡嚜鍔ㄥ畬缁�"); -// refund.setCode(); - refund.setMemberId(goodsorder.getMemberId()); - refund.setMoney(goodsorder.getMoney().subtract(ridesDetailResponse.getAmount())); -// refund.setStatus(); -// refund.setPreOrderid(); -// refund.setOnlineOrderid(); - refund.setPayWay(goodsorder.getPayWay()); - refund.setDoneDate(new Date()); - refund.setType(Constants.ONE); - refund.setObjId(goodsorder.getId()); - refund.setReason("纭畾寮哄埗缁撶畻鍚楋紵缁撶畻鍚庤鍗曡嚜鍔ㄥ畬缁�"); - refundMapper.insert(refund); - Goodsorder update = new Goodsorder(); - update.setId(goodsorder.getId()); - update.setStatus(Constants.GOODSORDER_STATUS.CLOSE.getKey()); - update.setCloseMoney(goodsorder.getMoney().subtract(ridesDetailResponse.getAmount())); - update.setCloseId(refund.getId()); - update.setCloseDate(refund.getDoneDate()); - update.setCloseInfo(refund.getInfo()); - update.setCloseUserId(principal.getId()); - update.setCloseType(Constants.ONE); - goodsorderMapper.updateById(update); + .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()); + Refund refund = 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 RidesDetailResponse getRidesDetailResponse(String id) { + public GoodsorderTotalDataVO getTotalData(Goodsorder param){ - QueryWrapper<MemberRides> wrapper = new QueryWrapper<>(); - wrapper.lambda() - .eq(MemberRides::getOrdreId,id); - List<MemberRides> memberRides = memberRidesMapper.selectList(wrapper); - if (!CollectionUtils.isEmpty(memberRides)){ - boolean exitUnBack = memberRides.stream().anyMatch(s -> !Constants.MEMBER_RIDES_STATUS.BACK_CYCLING.getKey().equals(s.getStatus())); - if (exitUnBack){ - throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"褰撳墠璁㈠崟鏈夋湭瀹屾垚鐨勯獞琛岋紝鏃犳硶寮哄埗缁撶畻"); + 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()))); - PricingRuleDTO pricingRule = pricingRuleService.getPricingRule(memberRides); - RidesDetailResponse ridesDetailResponse = new RidesDetailResponse(); + 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(s.getBackDate()); - memberRidesResponse.setRideTime(DateUtil.betweenMin(memberRidesResponse.getRideStartTime(), memberRidesResponse.getRideEndTime())); - memberRidesResponse.setDuration(s.getDuration()); + 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.getUnitTime()); + 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()); - - Integer durationSum = memberRides.stream().filter(s -> s.getDuration() > 0).mapToInt(s -> s.getDuration()).sum(); - if (durationSum > pricingRule.getMemberRides().getBaseTime()){ - BigDecimal basePrice = pricingRule.getMemberRides().getBasePrice(); - BigDecimal multiply = pricingRule.getMemberRides().getUnitPrice().multiply(new BigDecimal((durationSum - pricingRule.getMemberRides().getBaseTime()))); - ridesDetailResponse.setAmount(basePrice.add(multiply)); - }else { - ridesDetailResponse.setAmount(pricingRule.getMemberRides().getBasePrice()); + //绱鍜岄绠楃粨绠楅噾棰� + RidesDetailResponse ridesDetailResponse = getCloseMoneyByRides(memberRides,false,goodsorder.getMoney()); + if(Constants.formatIntegerNum(goodsorder.getStatus())!= Constants.goodsorderStatus.pay){ + //濡傛灉闈炲凡鏀粯浣嗘湭缁撶畻锛屼娇鐢ㄨ鍗曢噾棰� + ridesDetailResponse.setAmount(goodsorder.getCloseMoney()); } - ridesDetailResponse.setBikeType(pricingRule.getBikeType()); - ridesDetailResponse.setDuration(durationSum); ridesDetailResponse.setMemberRidesResponseList(collect); return ridesDetailResponse; } @@ -402,12 +806,21 @@ 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())); + 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); @@ -417,11 +830,10 @@ try { Object response = null; WxPayUnifiedOrderRequest request = new WxPayUnifiedOrderRequest(); - request.setBody("鏀粯鎶奸噾"); + request.setBody("楠戣鎶奸噾"); request.setAttach("createGoodsOrder"); request.setOutTradeNo(goodsorder.getId()); -// request.setTotalFee(BaseWxPayRequest.yuanToFen(goodsorder.getMoney().toString())); - request.setTotalFee(1); + request.setTotalFee(goodsorder.getMoney().intValue()); request.setSpbillCreateIp(this.getIpAddr()); request.setTimeStart(DateUtil.DateToString(new Date(), "yyyyMMddHHmmss")); request.setOpenid(member.getOpenid()); @@ -432,6 +844,94 @@ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),e.getMessage()); } } + + /** + * 楠岃瘉钀ヤ笟鏃堕棿 + */ + @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 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.NOT_ALLOWED.getCode(),"鏃犻獞琛岃鍗曡褰�"); + } + 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); + goodsorder.setEditor(null); + closeGoodsorder( goodsorder,Constants.REFUND_TYPE.NORMAL.getKey()); + } + @Override public String payNotify(String preOrderId,String paymentNo){ @@ -452,12 +952,12 @@ transactions.setIsdeleted(Constants.ZERO); transactions.setOrderId(goodsorder.getId()); transactions.setMoney(goodsorder.getMoney()); - transactions.setType(Constants.transactionsType.deposit); + transactions.setType(Constants.TRANSACTIONS_TYPE.DEPOSIT.getKey()); transactions.setPreOrderid(goodsorder.getPreOrderid()); transactions.setOnlineOrderid(goodsorder.getOnlineOrderid()); transactions.setDoneDate(new Date()); - transactions.setTitle("鏀粯"); - transactions.setContent("鎶奸噾鏀粯"); + 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); -- Gitblit v1.9.3