| | |
| | | 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.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.web.response.HomeResponse; |
| | | 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.dao.business.web.response.GoodsorderDetailDTO; |
| | | import com.doumee.dao.business.web.response.MemberRidesResponse; |
| | | import com.doumee.dao.business.web.response.PayOrderDTO; |
| | | 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; |
| | | import com.github.binarywang.wxpay.exception.WxPayException; |
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
| | | 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 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 |
| | | public class GoodsorderServiceImpl implements GoodsorderService { |
| | |
| | | @Autowired |
| | | private SystemDictDataBiz systemDictDataBiz; |
| | | |
| | | @Autowired |
| | | private MemberRidesMapper memberRidesMapper; |
| | | |
| | | @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) { |
| | |
| | | @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 |
| | |
| | | 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) { |
| | |
| | | @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()); |
| | |
| | | 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); |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | @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); |
| | | .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.setPayType(goodsorder.getPayWay()); |
| | | payOrderDTO.setMoney(goodsorder.getMoney()); |
| | | 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.getCode()); |
| | | refundOrderDTO.setPayType(s.getPayWay()); |
| | | refundOrderDTO.setMoney(s.getMoney()); |
| | | 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); |
| | | }); |
| | | } |
| | | 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()); |
| | | //如果是一口价方式,价格直接为一口价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 Goodsorder closerGoodsorder(String id) { |
| | | |
| | | Goodsorder goodsorder = goodsorderMapper.selectById(id); |
| | | |
| | | |
| | | |
| | | return null; |
| | | 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()); |
| | | 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 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){ |
| | |
| | | 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); |
| | |
| | | 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()); |
| | |
| | | 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){ |
| | |
| | | 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 WxPayNotifyResponse.success("处理成功!"); |
| | | } |
| | | |