回显同一户投票结果

lin

2024-03-27 f2d5ea44de8cf97542e99b9c1180b141d5f04105

回显同一户投票结果

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

@@ -116,7 +116,9 @@
        LEFT JOIN jczz_topics jts ON jts.id = jut.topics_id
        WHERE
        jut.article_id = jt.article_id
        AND jts.parent_id = jt.id  AND jut.household_id = #{householdId} AND jut.house_code = #{houseCode}
        AND jts.parent_id = jt.id
        <if test="householdId != null ">   AND jut.household_id = #{householdId}</if>
          AND jut.house_code = #{houseCode}
        limit 1
        ) selected
        FROM

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

@@ -19,11 +19,14 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.common.constant.CommonConstant;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.discuss.dto.TopicsDTO;
import org.springblade.modules.discuss.entity.PublicDiscussEntity;
import org.springblade.modules.discuss.entity.TopicsEntity;
import org.springblade.modules.discuss.mapper.TopicsMapper;
import org.springblade.modules.discuss.service.IPublicDiscussService;
import org.springblade.modules.discuss.service.ITopicsService;
import org.springblade.modules.discuss.vo.TopicsVO;
import org.springblade.modules.house.entity.HouseholdEntity;
@@ -51,12 +54,18 @@
        IHouseholdService householdService = SpringUtils.getBean(IHouseholdService.class);
        HouseholdEntity householdEntity = householdService.getOne(Wrappers.<HouseholdEntity>lambdaQuery()
            .eq(HouseholdEntity::getHouseCode, topicsDTO.getHouseCode())
            .eq(HouseholdEntity::getAssociatedUserId,AuthUtil.getUserId())
            .eq(HouseholdEntity::getIsDeleted,0)
            .eq(HouseholdEntity::getAssociatedUserId, AuthUtil.getUserId())
            .eq(HouseholdEntity::getIsDeleted, 0)
            .last("limit 1"));
        if (householdEntity != null) {
            topicsDTO.setHouseholdId(householdEntity.getId());
        }
        return  baseMapper.selectTopicsList( topicsDTO);
        // 判断是否一户一票,如果一户一票，回显之前投票结果
        IPublicDiscussService discussService = SpringUtils.getBean(IPublicDiscussService.class);
        PublicDiscussEntity discussEntity = discussService.getOne(Wrappers.<PublicDiscussEntity>lambdaQuery().eq(PublicDiscussEntity::getArticleId, topicsDTO.getArticleId()));
        if (discussEntity != null && discussEntity.getVoteRestrictions().equals(CommonConstant.NUMBER_ONE)) {
            topicsDTO.setHouseholdId(null);
        }
        return baseMapper.selectTopicsList(topicsDTO);
    }
}