From 7bfa5f63181b0cedd43899e9dacdfca26ebfd4ad Mon Sep 17 00:00:00 2001 From: liulin <lin.liu@88.com> Date: 星期二, 08 七月 2025 09:50:58 +0800 Subject: [PATCH] 修改支付接口 --- src/main/java/com/lunhan/water/repository/impl/WaterFacilityRecordsMapperImpl.java | 137 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 137 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/lunhan/water/repository/impl/WaterFacilityRecordsMapperImpl.java b/src/main/java/com/lunhan/water/repository/impl/WaterFacilityRecordsMapperImpl.java new file mode 100644 index 0000000..b5345ea --- /dev/null +++ b/src/main/java/com/lunhan/water/repository/impl/WaterFacilityRecordsMapperImpl.java @@ -0,0 +1,137 @@ +/** +# __----~~~~~~~~~~~------___ +# . . ~~//====...... __--~ ~~ +# -. \_|// |||\\ ~~~~~~::::... /~ +# ___-==_ _-~o~ \/ ||| \\ _/~~- +# __---~~~.==~||\=_ -_--~/_-~|- |\\ \\ _/~ +# _-~~ .=~ | \\-_ '-~7 /- / || \ / +# .~ .~ | \\ -_ / /- / || \ / +# / ____ / | \\ ~-_/ /|- _/ .|| \ / +# |~~ ~~|--~~~~--_ \ ~==-/ | \~--===~~ .\ +# ' ~-| /| |-~\~~ __--~~ +# |-~~-_/ | | ~\_ _-~ /\ +# / \ \__ \/~ \__ +# _--~ _/ | .-~~____--~-/ ~~==. +# ((->/~ '.|||' -_| ~~-/ , . _|| +# -_ ~\ ~~---l__i__i__i--~~_/ +# _-~-__ ~) \--______________--~~ +# //.-~~~-~_--~- |-------~~~~~~~~ +# //.-~~~--\ +# 神兽保佑 +# 永无BUG! +*/ +package com.lunhan.water.repository.impl; + +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.lunhan.water.common.PagerResult; +import com.lunhan.water.common.enums.EYesOrNo; +import com.lunhan.water.common.util.*; +import com.lunhan.water.entity.dto.*; +import com.lunhan.water.entity.enums.*; +import com.lunhan.water.repository.BasicMapperImpl; +import org.springframework.stereotype.Repository; + +import java.util.List; +import com.lunhan.water.entity.search.SearchWaterFacilityRecords; +import com.lunhan.water.repository.mapper.WaterFacilityRecordsMapper; +import com.lunhan.water.repository.po.WaterFacilityRecordsPO; + +/** + * 设备供水记录 + * @author lin.liu + */ +@Repository +public class WaterFacilityRecordsMapperImpl extends BasicMapperImpl<WaterFacilityRecordsPO, WaterFacilityRecordsMapper> { + WaterFacilityRecordsMapperImpl(WaterFacilityRecordsMapper mapper) { + super(mapper); + } + + @Override + public PagerResult<WaterFacilityRecordsPO> search(SearchBasicDTO request) { + // 还原查询条件真实类型 + SearchWaterFacilityRecords search = (SearchWaterFacilityRecords)request; + // 查询条件 + LambdaQueryWrapper<WaterFacilityRecordsPO> queryWrapper = this.query(); + // 非逻辑删除 + queryWrapper.eq(WaterFacilityRecordsPO::getIsDelete, EYesOrNo.NO.getValue()); + // 状态 + //queryWrapper.eq(NumericUtil.tryParseInt(search.getStatus()).compareTo(0) > 0, WaterFacilityRecordsPO::getStatus, search.getStatus()); + // 状态列表 + //queryWrapper.in(ListUtil.isNotNullOrEmpty(search.getListStatus()), WaterFacilityRecordsPO::getStatus, search.getListStatus()); + + // 数据创建时间-起始 + queryWrapper.ge(NumericUtil.tryParseLong(search.getCreateTimeStart()).compareTo(0L) > 0, WaterFacilityRecordsPO::getCreateTime, search.getCreateTimeStart()); + // 数据创建时间-截止 + queryWrapper.le(NumericUtil.tryParseLong(search.getCreateTimeEnd()).compareTo(0L) > 0, WaterFacilityRecordsPO::getCreateTime, search.getCreateTimeEnd()); + // 关键字 + //if (StringUtil.isNotNullOrEmpty(search.getKeywords())) { + // queryWrapper.and(q -> + // q.like(WaterFacilityRecordsPO::getName, search.getKeywords()) + // .or().like(WaterFacilityRecordsPO::getPhone, search.getKeywords()) + // ); + //} + + // 排序处理 + if (ListUtil.isNotNullOrEmpty(search.getOrderBy())) { + for (OrderByDTO item : search.getOrderBy()) { + EOrderBy orderBy = EOrderBy.getByValue(item.getOrderBy()); + // 顺序排序 + if (item.getIsAsc()) { + switch (orderBy) { + // 主键 + case ID: + queryWrapper.orderByAsc(WaterFacilityRecordsPO::getId); + break; + // 数据创建时间 + case CREATE_TIME: + queryWrapper.orderByAsc(WaterFacilityRecordsPO::getCreateTime); + break; + // 最后更新时间 + case UPDATE_TIME: + queryWrapper.orderByAsc(WaterFacilityRecordsPO::getUpdateTime); + break; + } + } else { + // 倒叙排序 + switch (orderBy) { + // 主键 + case ID: + queryWrapper.orderByDesc(WaterFacilityRecordsPO::getId); + break; + // 数据创建时间 + case CREATE_TIME: + queryWrapper.orderByDesc(WaterFacilityRecordsPO::getCreateTime); + break; + // 最后更新时间 + case UPDATE_TIME: + queryWrapper.orderByDesc(WaterFacilityRecordsPO::getUpdateTime); + break; + } + } + } + } else { + queryWrapper.orderByDesc(WaterFacilityRecordsPO::getId); + } + Page<WaterFacilityRecordsPO> pageResult = super.selectPage(new Page<>(search.getPage(), search.getLimit()), queryWrapper); + return new PagerResult<>(pageResult.getSize(), pageResult.getCurrent(), pageResult.getTotal(), pageResult.getRecords()); + } + + public Boolean add(WaterFacilityRecordsPO item) { + int rowCount = super.insert(item); + return rowCount == 1; + } + + public Boolean addNotIncrement(WaterFacilityRecordsPO item) { + int rowCount = super.insert(item); + return rowCount == 1; + } + + public WaterFacilityRecordsPO getById(Long id) { + return super.get(id); + } + + public List<WaterFacilityRecordsPO> getListById(List<Long> listId) { + return super.getList(listId); + } +} -- Gitblit v1.9.3