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