From 32b07077c733dce160ead4935e205e46755f3caf Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 10 十月 2023 16:48:03 +0800 Subject: [PATCH] 后台结算记录 --- server/services/src/main/java/com/doumee/service/business/impl/ActionLogServiceImpl.java | 116 +++++++++++++++++++++++----------------------------------- 1 files changed, 46 insertions(+), 70 deletions(-) diff --git a/server/services/src/main/java/com/doumee/service/business/impl/ActionLogServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/ActionLogServiceImpl.java index 3fa2dd7..5515eca 100644 --- a/server/services/src/main/java/com/doumee/service/business/impl/ActionLogServiceImpl.java +++ b/server/services/src/main/java/com/doumee/service/business/impl/ActionLogServiceImpl.java @@ -1,15 +1,26 @@ package com.doumee.service.business.impl; +import com.alibaba.fastjson.JSONObject; +import com.doumee.core.constants.Constants; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Utils; import com.doumee.dao.business.ActionLogMapper; +import com.doumee.dao.business.join.ActionLogJoinMapper; import com.doumee.dao.business.model.ActionLog; +import com.doumee.dao.business.model.BaseParam; +import com.doumee.dao.business.model.Member; +import com.doumee.dao.business.model.MemberRides; +import com.doumee.dao.business.web.response.BikeLogDTO; +import com.doumee.dao.business.web.response.MemberRidesDTO; +import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.ActionLogService; 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.github.yulichang.wrapper.MPJLambdaWrapper; +import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -26,6 +37,8 @@ @Autowired private ActionLogMapper actionLogMapper; + @Autowired + private ActionLogJoinMapper actionLogJoinMapper; @Override public String create(ActionLog actionLog) { @@ -86,79 +99,42 @@ @Override public PageData<ActionLog> findPage(PageWrap<ActionLog> pageWrap) { - IPage<ActionLog> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); - QueryWrapper<ActionLog> queryWrapper = new QueryWrapper<>(); + + IPage<MemberRides> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); + + MPJLambdaWrapper<ActionLog> queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); - if (pageWrap.getModel().getId() != null) { - queryWrapper.lambda().eq(ActionLog::getId, pageWrap.getModel().getId()); - } - if (pageWrap.getModel().getCreateDate() != null) { - queryWrapper.lambda().ge(ActionLog::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); - queryWrapper.lambda().le(ActionLog::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); - } - if (pageWrap.getModel().getCreator() != null) { - queryWrapper.lambda().eq(ActionLog::getCreator, pageWrap.getModel().getCreator()); - } - if (pageWrap.getModel().getEditDate() != null) { - queryWrapper.lambda().ge(ActionLog::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); - queryWrapper.lambda().le(ActionLog::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); - } - if (pageWrap.getModel().getEditor() != null) { - queryWrapper.lambda().eq(ActionLog::getEditor, pageWrap.getModel().getEditor()); - } - if (pageWrap.getModel().getIsdeleted() != null) { - queryWrapper.lambda().eq(ActionLog::getIsdeleted, pageWrap.getModel().getIsdeleted()); - } - if (pageWrap.getModel().getInfo() != null) { - queryWrapper.lambda().eq(ActionLog::getInfo, pageWrap.getModel().getInfo()); - } - if (pageWrap.getModel().getTitle() != null) { - queryWrapper.lambda().eq(ActionLog::getTitle, pageWrap.getModel().getTitle()); - } - if (pageWrap.getModel().getContent() != null) { - queryWrapper.lambda().eq(ActionLog::getContent, pageWrap.getModel().getContent()); - } - if (pageWrap.getModel().getType() != null) { - queryWrapper.lambda().eq(ActionLog::getType, pageWrap.getModel().getType()); - } - if (pageWrap.getModel().getObjId() != null) { - queryWrapper.lambda().eq(ActionLog::getObjId, pageWrap.getModel().getObjId()); - } - if (pageWrap.getModel().getObjType() != null) { - queryWrapper.lambda().eq(ActionLog::getObjType, pageWrap.getModel().getObjType()); - } - if (pageWrap.getModel().getUserId() != null) { - queryWrapper.lambda().eq(ActionLog::getUserId, pageWrap.getModel().getUserId()); - } - if (pageWrap.getModel().getUserType() != null) { - queryWrapper.lambda().eq(ActionLog::getUserType, pageWrap.getModel().getUserType()); - } - if (pageWrap.getModel().getBeforeContent() != null) { - queryWrapper.lambda().eq(ActionLog::getBeforeContent, pageWrap.getModel().getBeforeContent()); - } - if (pageWrap.getModel().getAfterContent() != null) { - queryWrapper.lambda().eq(ActionLog::getAfterContent, pageWrap.getModel().getAfterContent()); - } - if (pageWrap.getModel().getParam() != null) { - queryWrapper.lambda().eq(ActionLog::getParam, pageWrap.getModel().getParam()); - } - if (pageWrap.getModel().getParam2() != null) { - queryWrapper.lambda().eq(ActionLog::getParam2, pageWrap.getModel().getParam2()); - } - if (pageWrap.getModel().getParam3() != null) { - queryWrapper.lambda().eq(ActionLog::getParam3, pageWrap.getModel().getParam3()); - } - if (pageWrap.getModel().getResult() != null) { - queryWrapper.lambda().eq(ActionLog::getResult, pageWrap.getModel().getResult()); - } - for(PageWrap.SortData sortData: pageWrap.getSorts()) { - if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { - queryWrapper.orderByDesc(sortData.getProperty()); - } else { - queryWrapper.orderByAsc(sortData.getProperty()); + queryWrapper.orderByDesc(ActionLog::getCreateDate); + queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,ActionLog::getUserId); + queryWrapper.leftJoin(BaseParam.class,BaseParam::getId,MemberRides::getParamId); + queryWrapper.eq(ActionLog::getIsdeleted, Constants.ZERO); + queryWrapper.ge(pageWrap.getModel().getStartDate()!=null, ActionLog::getCreateDate,pageWrap.getModel().getStartDate()); + queryWrapper.le(pageWrap.getModel().getEndDate()!=null, ActionLog::getCreateDate,pageWrap.getModel().getEndDate()); + queryWrapper.eq(pageWrap.getModel().getCreator()!=null, ActionLog::getCreator,pageWrap.getModel().getCreator()); + queryWrapper.in(pageWrap.getModel().getTypeList()!=null && pageWrap.getModel().getTypeList().size()>0, ActionLog::getType,pageWrap.getModel().getTypeList()); + queryWrapper.selectAll(ActionLog.class) + .selectAs(SystemUser::getNickname,ActionLog::getCreator); + + IPage<ActionLog> result = actionLogJoinMapper.selectJoinPage(page, ActionLog.class, queryWrapper); + + if(result !=null && result.getRecords()!=null){ + for (int i = 0; i < result.getRecords().size(); i++) { + ActionLog log = result.getRecords().get(i); + if(Constants.formatIntegerNum(log.getObjType())== Constants.ActionLogObjType.memberrides){ + //濡傛灉鏄獞琛岃褰曞叧鑱斿璞★紝鍒欎娇鐢╞eforeContent + MemberRides memberRides = new MemberRides(); + try { + //寮哄埗杞崲楠戣璁板綍瀵硅薄 + memberRides = JSONObject.parseObject(log.getBeforeContent(), MemberRides.class); + }catch (Exception e){ + + } + log.setRidesObj(memberRides); + } } } - return PageData.from(actionLogMapper.selectPage(page, queryWrapper)); + + return PageData.from(result); } @Override -- Gitblit v1.9.3