From 58efaec9ed06a348154b1ece394795db0e48490f Mon Sep 17 00:00:00 2001 From: jiaosong <jiaosong6760@dingtalk.com> Date: 星期五, 10 十一月 2023 11:17:41 +0800 Subject: [PATCH] # 导出排序 --- server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java | 6 ++++-- 1 files changed, 4 insertions(+), 2 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 4e70912..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 @@ -241,6 +241,7 @@ 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{ @@ -264,7 +265,7 @@ queryWrapper.le( Refund::getDoneDate, Utils.Date.getEnd(model.getEndDate())); } queryWrapper.eq(Refund::getStatus,Constants.TWO);//閫�娆惧畬鎴� - queryWrapper.orderByAsc(Goodsorder::getPayDate); + queryWrapper.orderByAsc(Refund::getDoneDate);; goodsorderList = refundJoinMapper.selectJoinList(GoodsorderExportVO.class,queryWrapper); } if (!CollectionUtils.isEmpty(goodsorderList)){ @@ -300,7 +301,7 @@ queryWrapper.like(model.getOpenid() !=null,Member::getOpenid,model.getOpenid()); queryWrapper.eq(Goodsorder::getIsdeleted,Constants.ZERO); queryWrapper.eq(Goodsorder::getPayStatus,Constants.ONE); - queryWrapper.orderByDesc(Goodsorder::getPayDate); + return queryWrapper; } @@ -309,6 +310,7 @@ public PageData<Goodsorder> findPage(PageWrap<Goodsorder> pageWrap) { IPage<Goodsorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper<Goodsorder> queryWrapper = initQueryParamByModel(pageWrap.getModel()); + queryWrapper.orderByDesc(Goodsorder::getPayDate); queryWrapper.select("(select er.status from member_rides er where er.ordre_id=t.id order by er.create_date desc limit 1) as memberRidesStatus"); if(Objects.nonNull(pageWrap.getModel().getCloseStatus()) && pageWrap.getModel().getCloseStatus().equals(Constants.ZERO)){ queryWrapper.ne(Goodsorder::getStatus,Constants.GOODSORDER_STATUS.CLOSE.getKey()); -- Gitblit v1.9.3