From 1fe1ac0e09132e0147e48007986be235e4130aa1 Mon Sep 17 00:00:00 2001 From: zhangmei <645025773@qq.com> Date: 星期五, 28 二月 2025 12:54:12 +0800 Subject: [PATCH] 分页查询更改 --- ruoyi-system/src/main/java/com/ruoyi/system/service/impl/THouseServiceImpl.java | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 45 insertions(+), 0 deletions(-) diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/THouseServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/THouseServiceImpl.java index 7604dcf..9aa06f9 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/THouseServiceImpl.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/THouseServiceImpl.java @@ -1,10 +1,24 @@ package com.ruoyi.system.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.ruoyi.common.basic.PageInfo; +import com.ruoyi.common.constant.DictConstants; +import com.ruoyi.common.utils.DictUtils; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.system.mapper.TContractMapper; import com.ruoyi.system.mapper.THouseMapper; +import com.ruoyi.system.model.TContract; import com.ruoyi.system.model.THouse; +import com.ruoyi.system.query.THouseQuery; +import com.ruoyi.system.query.TUserHistoryQuery; import com.ruoyi.system.service.THouseService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.system.vo.HouseVO; import org.springframework.stereotype.Service; + +import javax.annotation.Resource; +import java.time.LocalDateTime; +import java.util.List; /** * <p> @@ -16,5 +30,36 @@ */ @Service public class THouseServiceImpl extends ServiceImpl<THouseMapper, THouse> implements THouseService { + @Resource + private TContractMapper contractMapper; + @Override + public PageInfo<THouse> houseList(THouseQuery query) { + PageInfo<THouse> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize()); + List<THouse> list = this.baseMapper.houseList(query,pageInfo); + List<TContract> tContracts = contractMapper.selectList(new LambdaQueryWrapper<TContract>() + .eq(TContract::getStatus, 4) + .le(TContract::getStartTime, LocalDateTime.now()) + .ge(TContract::getEndTime, LocalDateTime.now())); + for (THouse tHouse : list) { + tHouse.setLeaseStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_LEASE_STATUS,tHouse.getLeaseStatus())); + tHouse.setBusinessAttributes(DictUtils.getDictLabel(DictConstants.DICT_TYPE_BUSINESS_ATTRIBUTES,tHouse.getBusinessAttributes())); + TContract tContract = tContracts.stream().filter(e -> e.getHouseId().equals(tHouse.getId())).findFirst().orElse(null); + if (tContract!=null){ + tHouse.setTenantType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE,tContract.getPayType())); + } + } + pageInfo.setRecords(list); + return pageInfo; + } + @Override + public PageInfo<HouseVO> userHistoryList(TUserHistoryQuery query) { + PageInfo<HouseVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize()); + List<HouseVO> list = this.baseMapper.userHistoryList(query,pageInfo); + for (HouseVO houseVO : list) { + houseVO.setTenantAttributes(StringUtils.isNotEmpty(houseVO.getTenantAttributes())?DictUtils.getDictLabel(DictConstants.DICT_TYPE_TENANT_ATTRIBUTE,houseVO.getTenantAttributes()):""); + } + pageInfo.setRecords(list); + return pageInfo; + } } -- Gitblit v1.7.1