投票人员查询优化

linwei

2024-02-22 50bc8229fb29e4ca3ca8314ad66b43151953d49a

投票人员查询优化

 src/main/java/org/springblade/modules/discuss/mapper/UserTopicsMapper.xml

@@ -53,6 +53,11 @@
            <if test="userTopics.phone != null and userTopics.phone != ''">
                and bu.phone like concat('%',#{userTopics.phone},'%')
            </if>

            <if test="userTopics.aoiCode != null and userTopics.aoiCode != ''">
                and jda.aoi_code =#{userTopics.aoiCode}
            </if>

            <if test="userTopics.userId != null ">and jut.user_id = #{userTopics.userId}</if>
            <if test="userTopics.topicsId != null ">and jut.topics_id = #{userTopics.topicsId}</if>
            <if test="userTopics.createTime != null ">and jut.create_time = #{userTopics.createTime}</if>

 src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java

@@ -25,6 +25,7 @@
import org.apache.commons.lang3.StringUtils;
import org.jetbrains.annotations.Nullable;
import org.springblade.common.constant.CommonConstant;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.SpringUtil;
import org.springblade.modules.discuss.entity.PublicDiscussEntity;
@@ -36,6 +37,8 @@
import org.springblade.modules.discuss.service.IUserTopicsService;
import org.springblade.modules.discuss.vo.TopicsVO;
import org.springblade.modules.discuss.vo.UserTopicsVO;
import org.springblade.modules.district.entity.DistrictEntity;
import org.springblade.modules.district.service.IDistrictService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@@ -56,6 +59,13 @@

    @Override
    public IPage<UserTopicsVO> selectUserTopicsPage(IPage<UserTopicsVO> page, UserTopicsVO userTopics) {
        if (StringUtils.isNotBlank(userTopics.getDistrictId())) {
            IDistrictService bean = SpringUtils.getBean(IDistrictService.class);
            DistrictEntity one = bean.getOne(Wrappers.<DistrictEntity>lambdaQuery().eq(DistrictEntity::getId, userTopics.getDistrictId()));
            if (one != null) {
                userTopics.setAoiCode(one.getAoiCode());
            }
        }
        return page.setRecords(baseMapper.selectUserTopicsPage(page, userTopics));
    }


 src/main/java/org/springblade/modules/discuss/vo/UserTopicsVO.java

@@ -41,4 +41,8 @@
    private String addressName;

    private String aoiName;

    private String aoiCode;

    private String districtId;
}