package com.doumee.service.business.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.doumee.core.constants.Constants;
|
import com.doumee.biz.system.SystemDictDataBiz;
|
import com.doumee.core.constants.Constants;
|
import com.doumee.core.constants.ResponseStatus;
|
import com.doumee.core.exception.BusinessException;
|
import com.doumee.core.model.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.dao.business.*;
|
import com.doumee.dao.business.MemberRidesMapper;
|
import com.doumee.dao.business.join.GoodsorderJoinMapper;
|
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.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.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.checkerframework.checker.units.qual.A;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.CollectionUtils;
|
import org.springframework.web.context.request.RequestContextHolder;
|
import org.springframework.web.context.request.ServletRequestAttributes;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.math.BigDecimal;
|
import java.net.InetAddress;
|
import java.net.UnknownHostException;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
|
@Service
|
public class GoodsorderServiceImpl implements GoodsorderService {
|
|
|
|
@Autowired
|
private GoodsorderMapper goodsorderMapper;
|
|
@Autowired
|
GoodsorderJoinMapper goodsorderJoinMapper;
|
|
@Autowired
|
private SystemDictDataBiz systemDictDataBiz;
|
|
@Autowired
|
private MemberRidesMapper memberRidesMapper;
|
|
@Autowired
|
private MemberMapper memberMapper;
|
@Autowired
|
private BaseParamMapper baseParamMapper;
|
|
|
|
|
@Autowired
|
private RefundMapper refundMapper;
|
|
@Autowired
|
private MemberRidesJoinMapper memberRidesJoinMapper;
|
|
@Override
|
public String create(Goodsorder goodsorder) {
|
goodsorderMapper.insert(goodsorder);
|
return goodsorder.getId();
|
}
|
|
@Override
|
public void deleteById(String id) {
|
goodsorderMapper.deleteById(id);
|
}
|
|
@Override
|
public void delete(Goodsorder goodsorder) {
|
UpdateWrapper<Goodsorder> deleteWrapper = new UpdateWrapper<>(goodsorder);
|
goodsorderMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<String> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
goodsorderMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public void updateById(Goodsorder goodsorder) {
|
goodsorderMapper.updateById(goodsorder);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<Goodsorder> goodsorders) {
|
if (CollectionUtils.isEmpty(goodsorders)) {
|
return;
|
}
|
for (Goodsorder goodsorder: goodsorders) {
|
this.updateById(goodsorder);
|
}
|
}
|
|
@Override
|
public Goodsorder findById(String id) {
|
return goodsorderMapper.selectById(id);
|
}
|
|
@Override
|
public Goodsorder findOne(Goodsorder goodsorder) {
|
QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder);
|
return goodsorderMapper.selectOne(wrapper);
|
}
|
|
@Override
|
public List<Goodsorder> findList(Goodsorder goodsorder) {
|
QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder);
|
return goodsorderMapper.selectList(wrapper);
|
}
|
|
@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());
|
}
|
|
if (pageWrap.getModel().getStatus() != null) {
|
queryWrapper.eq(Goodsorder::getStatus, pageWrap.getModel().getStatus());
|
}
|
|
if (pageWrap.getModel().getOnlineOrderid() != null) {
|
queryWrapper.eq(Goodsorder::getOnlineOrderid, pageWrap.getModel().getOnlineOrderid());
|
}
|
|
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));
|
}
|
|
@Override
|
public long count(Goodsorder goodsorder) {
|
QueryWrapper<Goodsorder> wrapper = new QueryWrapper<>(goodsorder);
|
return goodsorderMapper.selectCount(wrapper);
|
}
|
|
|
|
@Override
|
public HomeResponse getHome(String memberId){
|
HomeResponse homeResponse = new HomeResponse();
|
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.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.setRideStatus(-1);
|
if(homeResponse.getDepositStatus()==Constants.goodsorderStatus.pay) {
|
//查询当前骑行状态
|
MemberRides memberRides = memberRidesMapper.selectOne(new QueryWrapper<MemberRides>().eq("member_id", memberId)
|
.orderByDesc(" create_date ")
|
.last(" limit 1 "));
|
if (!Objects.isNull(memberRides)) {
|
homeResponse.setRideStatus(memberRides.getStatus());
|
MemberRidesResponse memberRidesResponse = new MemberRidesResponse();
|
BaseParam baseParam = baseParamMapper.selectById(memberRides.getParamId());
|
if(!Objects.isNull(baseParam)){
|
memberRidesResponse.setBikeType(baseParam.getName());
|
}
|
memberRidesResponse.setRideStartTime(memberRides.getRentDate());
|
memberRidesResponse.setRideEndTime(memberRides.getBackDate());
|
memberRidesResponse.setRideTime(DateUtil.betweenMin(memberRidesResponse.getRideStartTime(),memberRidesResponse.getRideEndTime()));
|
memberRidesResponse.setBikeCode(memberRides.getBikeCode());
|
memberRidesResponse.setBasePrice(memberRides.getBasePrice());
|
memberRidesResponse.setBaseTime(memberRides.getBaseTime());
|
memberRidesResponse.setUnitTime(memberRidesResponse.getUnitTime());
|
memberRidesResponse.setUnitPrice(memberRidesResponse.getUnitPrice());
|
homeResponse.setMemberRidesResponse(memberRidesResponse);
|
}
|
}
|
return homeResponse;
|
}
|
|
|
|
|
@Override
|
public GoodsorderDetailDTO getGoodsorderDetailDTO(String id) {
|
|
List<PayOrderDTO> payOrderDTOList = new ArrayList<>();
|
Goodsorder goodsorder = goodsorderMapper.selectById(id);
|
QueryWrapper<Refund> refundQuery = new QueryWrapper<>();
|
refundQuery.lambda()
|
.eq(Refund::getObjId,id);
|
List<Refund> refunds = refundMapper.selectList(refundQuery);
|
|
PayOrderDTO payOrderDTO = new PayOrderDTO();
|
payOrderDTO.setOrderCode(goodsorder.getCode());
|
payOrderDTO.setPayType(goodsorder.getPayWay());
|
payOrderDTO.setMoney(goodsorder.getMoney());
|
payOrderDTO.setPayDate(goodsorder.getPayDate());
|
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.setPayDate(s.getDoneDate());
|
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);
|
GoodsorderDetailDTO goodsorderDetailDTO = new GoodsorderDetailDTO();
|
goodsorderDetailDTO.setPayOrderDTOList(payOrderDTOList);
|
goodsorderDetailDTO.setMemberRidesList(memberRides);
|
return goodsorderDetailDTO;
|
}
|
|
@Override
|
public Goodsorder closerGoodsorder(String id) {
|
|
Goodsorder goodsorder = goodsorderMapper.selectById(id);
|
|
|
|
return null;
|
}
|
|
|
@Override
|
public Object createGoodsOrderPay(String memberId){
|
Member member = memberMapper.selectById(memberId);
|
if(Objects.isNull(member)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到用户对象信息");
|
}
|
Goodsorder qry = new Goodsorder();
|
qry.setStatus(Constants.goodsorderStatus.pay);
|
qry.setMemberId(memberId);
|
qry.setIsdeleted(Constants.ZERO);
|
if(goodsorderMapper.selectCount(new QueryWrapper<>(qry))>Constants.ZERO){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"已支付过定金，无法重复该操作");
|
}
|
Goodsorder goodsorder = new Goodsorder();
|
goodsorder.setId(Constants.getUUID());
|
goodsorder.setCreateDate(new Date());
|
goodsorder.setIsdeleted(Constants.ZERO);
|
goodsorder.setMemberId(memberId);
|
goodsorder.setMoney(new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.RENT_DEPOSIT).getCode()));
|
goodsorder.setStatus(Constants.goodsorderStatus.waitPay);
|
goodsorder.setPreOrderid(goodsorder.getId());
|
goodsorder.setPayStatus(Constants.goodsorderPayStatus.waitPay);
|
goodsorder.setPayWay(Constants.ZERO);
|
this.goodsorderMapper.insert(goodsorder);
|
//调起支付
|
try {
|
Object response = null;
|
WxPayUnifiedOrderRequest request = new WxPayUnifiedOrderRequest();
|
request.setBody("支付押金");
|
request.setAttach("createGoodsOrder");
|
request.setOutTradeNo(goodsorder.getId());
|
// request.setTotalFee(BaseWxPayRequest.yuanToFen(goodsorder.getMoney().toString()));
|
request.setTotalFee(1);
|
request.setSpbillCreateIp(this.getIpAddr());
|
request.setTimeStart(DateUtil.DateToString(new Date(), "yyyyMMddHHmmss"));
|
request.setOpenid(member.getOpenid());
|
response = WxMiniConfig.wxPayService.createOrder(request);
|
return response;
|
} catch (WxPayException e) {
|
e.printStackTrace();
|
throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),e.getMessage());
|
}
|
}
|
|
@Override
|
public String payNotify(String preOrderId,String paymentNo){
|
Goodsorder goodsorder = this.goodsorderMapper.selectById(preOrderId);
|
if(goodsorder.getStatus()==Constants.goodsorderStatus.pay){
|
return WxPayNotifyResponse.success("处理成功!");
|
}
|
goodsorder.setOnlineOrderid(paymentNo);
|
goodsorder.setPayStatus(Constants.goodsorderPayStatus.pay);
|
goodsorder.setStatus(Constants.goodsorderStatus.pay);
|
goodsorder.setPayDate(new Date());
|
goodsorder.setEditDate(new Date());
|
goodsorderMapper.updateById(goodsorder);
|
return WxPayNotifyResponse.success("处理成功!");
|
}
|
|
|
|
/**
|
* 得到request对象
|
*
|
* @return
|
*/
|
public HttpServletRequest getRequest() {
|
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
|
return request;
|
}
|
|
public String getIpAddr() {
|
HttpServletRequest request = this.getRequest();
|
String ipAddress = null;
|
try {
|
ipAddress = request.getHeader("x-forwarded-for");
|
if (ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {
|
ipAddress = request.getHeader("Proxy-Client-IP");
|
}
|
if (ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {
|
ipAddress = request.getHeader("WL-Proxy-Client-IP");
|
}
|
if (ipAddress == null || ipAddress.length() == 0 || "unknown".equalsIgnoreCase(ipAddress)) {
|
ipAddress = request.getRemoteAddr();
|
if (ipAddress.equals("127.0.0.1")) {
|
// 根据网卡取本机配置的IP
|
InetAddress inet = null;
|
try {
|
inet = InetAddress.getLocalHost();
|
} catch (UnknownHostException e) {
|
e.printStackTrace();
|
}
|
ipAddress = inet.getHostAddress();
|
}
|
}
|
// 对于通过多个代理的情况，第一个IP为客户端真实IP,多个IP按照','分割
|
if (ipAddress != null && ipAddress.length() > 15) { // "***.***.***.***".length()
|
// = 15
|
if (ipAddress.indexOf(",") > 0) {
|
ipAddress = ipAddress.substring(0, ipAddress.indexOf(","));
|
}
|
}
|
} catch (Exception e) {
|
ipAddress = "47.111.178.164";
|
}
|
// ipAddress = this.getRequest().getRemoteAddr();
|
|
return ipAddress;
|
}
|
|
|
}
|
