| | |
| | | @Override |
| | | public ActionLog findOne(ActionLog actionLog) { |
| | | QueryWrapper<ActionLog> wrapper = new QueryWrapper<>(actionLog); |
| | | return actionLogMapper.selectOne(wrapper); |
| | | return actionLogMapper.selectOne(wrapper.last(" limit 1")); |
| | | } |
| | | |
| | | @Override |
| | |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | 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()); |
| | |
| | | |
| | | IPage<ActionLog> result = actionLogJoinMapper.selectJoinPage(page, ActionLog.class, queryWrapper); |
| | | |
| | | |
| | | |
| | | return PageData.from(result); |
| | | } |
| | | @Override |
| | | public PageData<ActionLog> findRidePae(PageWrap<ActionLog> pageWrap){ |
| | | |
| | | IPage<MemberRides> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | |
| | | MPJLambdaWrapper<ActionLog> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.orderByDesc(ActionLog::getCreateDate); |
| | | queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,ActionLog::getUserId); |
| | | queryWrapper.leftJoin(MemberRides.class,MemberRides::getMemberId,ActionLog::getObjId); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,MemberRides::getMemberId); |
| | | 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.selectAs(ActionLog::getCreateDate,ActionLog::getCreateDate) |
| | | .selectAs(ActionLog::getActInfo,ActionLog::getActInfo) |
| | | .selectAs(ActionLog::getActReason,ActionLog::getActReason) |
| | | .selectAs(SystemUser::getNickname,ActionLog::getCreator) |
| | | .selectAs(Member::getOpenid,ActionLog::getOpenid) |
| | | .selectAs(MemberRides::getBikeCode,ActionLog::getBikeCode) |
| | | .selectAs(MemberRides::getRentSiteId,ActionLog::getRentSiteId) |
| | | .selectAs(MemberRides::getRentDate,ActionLog::getRentDate); |
| | | |
| | | 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); |