/** # __----~~~~~~~~~~~------___ # . . ~~//====...... __--~ ~~ # -. \_|// |||\\ ~~~~~~::::... /~ # ___-==_ _-~o~ \/ ||| \\ _/~~- # __---~~~.==~||\=_ -_--~/_-~|- |\\ \\ _/~ # _-~~ .=~ | \\-_ '-~7 /- / || \ / # .~ .~ | \\ -_ / /- / || \ / # / ____ / | \\ ~-_/ /|- _/ .|| \ / # |~~ ~~|--~~~~--_ \ ~==-/ | \~--===~~ .\ # ' ~-| /| |-~\~~ __--~~ # |-~~-_/ | | ~\_ _-~ /\ # / \ \__ \/~ \__ # _--~ _/ | .-~~____--~-/ ~~==. # ((->/~ '.|||' -_| ~~-/ , . _|| # -_ ~\ ~~---l__i__i__i--~~_/ # _-~-__ ~) \--______________--~~ # //.-~~~-~_--~- |-------~~~~~~~~ # //.-~~~--\ # 神兽ä¿ä½‘ # æ°¸æ— BUGï¼ */ package com.nanjing.water.repository.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.nanjing.water.common.PagerResult; import com.nanjing.water.common.enums.EYesOrNo; import com.nanjing.water.common.util.*; import com.nanjing.water.entity.dto.*; import com.nanjing.water.entity.enums.*; import com.nanjing.water.repository.BasicMapperImpl; import org.springframework.stereotype.Repository; import java.util.List; import com.nanjing.water.entity.search.SearchHeartbeatData; import com.nanjing.water.repository.mapper.HeartbeatDataMapper; import com.nanjing.water.repository.po.HeartbeatDataPO; /** * HeartbeatData * @author lin.liu */ @Repository public class HeartbeatDataMapperImpl extends BasicMapperImpl<HeartbeatDataPO, HeartbeatDataMapper> { HeartbeatDataMapperImpl(HeartbeatDataMapper mapper) { super(mapper); } @Override public PagerResult<HeartbeatDataPO> search(SearchBasicDTO request) { // 还原查询æ¡ä»¶çœŸå®žç±»åž‹ SearchHeartbeatData search = (SearchHeartbeatData)request; // 查询æ¡ä»¶ LambdaQueryWrapper<HeartbeatDataPO> queryWrapper = this.query(); // éžé€»è¾‘åˆ é™¤ queryWrapper.eq(HeartbeatDataPO::getIsDelete, EYesOrNo.NO.getValue()); // çŠ¶æ€ //queryWrapper.eq(NumericUtil.tryParseInt(search.getStatus()).compareTo(0) > 0, HeartbeatDataPO::getStatus, search.getStatus()); // 状æ€åˆ—表 //queryWrapper.in(ListUtil.isNotNullOrEmpty(search.getListStatus()), HeartbeatDataPO::getStatus, search.getListStatus()); // æ•°æ®åˆ›å»ºæ—¶é—´-èµ·å§‹ queryWrapper.ge(NumericUtil.tryParseLong(search.getCreateTimeStart()).compareTo(0L) > 0, HeartbeatDataPO::getCreateTime, search.getCreateTimeStart()); // æ•°æ®åˆ›å»ºæ—¶é—´-æˆªæ¢ queryWrapper.le(NumericUtil.tryParseLong(search.getCreateTimeEnd()).compareTo(0L) > 0, HeartbeatDataPO::getCreateTime, search.getCreateTimeEnd()); // å…³é”®å— //if (StringUtil.isNotNullOrEmpty(search.getKeywords())) { // queryWrapper.and(q -> // q.like(HeartbeatDataPO::getName, search.getKeywords()) // .or().like(HeartbeatDataPO::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(HeartbeatDataPO::getId); break; // æ•°æ®åˆ›å»ºæ—¶é—´ case CREATE_TIME: queryWrapper.orderByAsc(HeartbeatDataPO::getCreateTime); break; // æœ€åŽæ›´æ–°æ—¶é—´ case UPDATE_TIME: queryWrapper.orderByAsc(HeartbeatDataPO::getUpdateTime); break; } } else { // å€’å™æŽ’åº switch (orderBy) { // 主键 case ID: queryWrapper.orderByDesc(HeartbeatDataPO::getId); break; // æ•°æ®åˆ›å»ºæ—¶é—´ case CREATE_TIME: queryWrapper.orderByDesc(HeartbeatDataPO::getCreateTime); break; // æœ€åŽæ›´æ–°æ—¶é—´ case UPDATE_TIME: queryWrapper.orderByDesc(HeartbeatDataPO::getUpdateTime); break; } } } } else { queryWrapper.orderByDesc(HeartbeatDataPO::getId); } Page<HeartbeatDataPO> pageResult = super.selectPage(new Page<>(search.getPage(), search.getLimit()), queryWrapper); return new PagerResult<>(pageResult.getSize(), pageResult.getCurrent(), pageResult.getTotal(), pageResult.getRecords()); } public Boolean add(HeartbeatDataPO item) { int rowCount = super.insert(item); return rowCount == 1; } public Boolean addNotIncrement(HeartbeatDataPO item) { int rowCount = super.insert(item); return rowCount == 1; } public HeartbeatDataPO getById(Long id) { return super.get(id); } public HeartbeatDataPO getByCode(String code) { LambdaQueryWrapper<HeartbeatDataPO> queryWrapper = this.query(); queryWrapper.eq(HeartbeatDataPO::getDataKey,code); return super.selectOne(queryWrapper); } public List<HeartbeatDataPO> getListById(List<Long> listId) { return super.getList(listId); } }