From 4fabfe4dbd2eb28d07a4350597d314958cc1c281 Mon Sep 17 00:00:00 2001 From: MrShi <1878285526@qq.com> Date: 星期四, 09 十月 2025 11:16:43 +0800 Subject: [PATCH] 优化 --- server/services/src/main/java/com/doumee/service/business/impl/RefundServiceImpl.java | 43 ++++++++++++++++++++++++++++++++++++------- 1 files changed, 36 insertions(+), 7 deletions(-) diff --git a/server/services/src/main/java/com/doumee/service/business/impl/RefundServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/RefundServiceImpl.java index c9eff3b..0c322f5 100644 --- a/server/services/src/main/java/com/doumee/service/business/impl/RefundServiceImpl.java +++ b/server/services/src/main/java/com/doumee/service/business/impl/RefundServiceImpl.java @@ -4,11 +4,11 @@ import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Utils; +import com.doumee.core.wx.WxMiniUtilService; import com.doumee.dao.business.RefundMapper; +import com.doumee.dao.business.TransactionsMapper; import com.doumee.dao.business.join.RefundJoinMapper; -import com.doumee.dao.business.model.Goodsorder; -import com.doumee.dao.business.model.Member; -import com.doumee.dao.business.model.Refund; +import com.doumee.dao.business.model.*; import com.doumee.dao.business.model.RefundPlatExportVO; import com.doumee.dao.business.vo.GoodsorderExportVO; import com.doumee.dao.system.model.SystemUser; @@ -18,6 +18,9 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.github.yulichang.wrapper.MPJLambdaWrapper; +import com.wechat.pay.java.service.refund.model.RefundNotification; +import io.swagger.models.auth.In; +import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -25,7 +28,9 @@ import java.math.BigDecimal; import java.sql.Ref; import java.util.ArrayList; +import java.util.Date; import java.util.List; +import java.util.Objects; /** * 閫�娆句俊鎭〃Service瀹炵幇 @@ -39,6 +44,9 @@ private RefundMapper refundMapper; @Autowired private RefundJoinMapper refundJoinMapper; + @Autowired + private TransactionsMapper transactionsMapper; + @Override public String create(Refund refund) { @@ -96,7 +104,7 @@ QueryWrapper<Refund> wrapper = new QueryWrapper<>(refund); return refundMapper.selectList(wrapper); } - + @Override public PageData<Refund> findPlatPage(PageWrap<Refund> pageWrap) { pageWrap.getModel().setTypeList(new ArrayList<>()); @@ -106,8 +114,19 @@ pageWrap.getModel().setStatus(Constants.TWO); IPage<Goodsorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper<Refund> queryWrapper = initQueryParamByModel(pageWrap.getModel()); - return PageData.from(refundJoinMapper.selectJoinPage(page, Refund.class,queryWrapper)); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCreatorName()) + ,SystemUser::getRealname + ,pageWrap.getModel().getCreatorName()); + IPage<Refund> refundIPage = refundJoinMapper.selectJoinPage(page, Refund.class, queryWrapper); + if (!CollectionUtils.isEmpty(refundIPage.getRecords())){ + refundIPage.getRecords().forEach(s->{ + s.setMoney(Constants.translateMoney(s.getMoney())); + s.setCanBalance(Constants.translateMoney(s.getCanBalance())); + }); + } + return PageData.from(refundIPage); } + @Override public List<RefundPlatExportVO> findPlatExportPage( Refund pageWrap) { pageWrap.setTypeList(new ArrayList<>()); @@ -124,6 +143,7 @@ for(Refund order : list){ RefundPlatExportVO vo = new RefundPlatExportVO(); vo.setId(order.getId()); + vo.setObjId(order.getObjId()); vo.setOpenid(order.getOpenid()); vo.setDoneDate(order.getDoneDate()); vo.setMoney(Constants.formatDecimalNum(order.getMoney()).divide(new BigDecimal(100), 2, BigDecimal.ROUND_UP)); @@ -149,13 +169,22 @@ queryWrapper.leftJoin(Member.class, Member::getId ,Goodsorder::getMemberId); queryWrapper.leftJoin(SystemUser.class, SystemUser::getId ,Refund::getCreator); //鏃堕棿娈电瓫閫� - queryWrapper.ge(model.getStartDate()!=null, Refund::getDoneDate, model.getStartDate()); - queryWrapper.le(model.getEndDate()!=null, Refund::getDoneDate, model.getEndDate()); + 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.ge(model.getStartDate()!=null, Refund::getDoneDate, model.getStartDate()); +// queryWrapper.le(model.getEndDate()!=null, Refund::getDoneDate, model.getEndDate()); queryWrapper.eq(model.getCreator() !=null,Refund::getCreator,model.getCreator()); queryWrapper.eq(model.getStatus() !=null,Refund::getStatus,model.getStatus()); + queryWrapper.in(model.getTypeList() !=null,Refund::getType,model.getTypeList()); + queryWrapper.eq(model.getType() !=null,Refund::getType,model.getType()); queryWrapper.like(model.getPayOnlineOrderid() !=null,Goodsorder::getOnlineOrderid,model.getPayOnlineOrderid()); queryWrapper.like(model.getOnlineOrderid() !=null,Refund::getOnlineOrderid,model.getOnlineOrderid()); queryWrapper.like(model.getOpenid() !=null,Member::getOpenid,model.getOpenid()); + queryWrapper.like(model.getCreatorName() !=null,SystemUser::getRealname,model.getCreatorName()); queryWrapper.eq(Goodsorder::getIsdeleted,Constants.ZERO); queryWrapper.orderByDesc(Refund::getDoneDate); return queryWrapper; -- Gitblit v1.9.3