From 5d5cd3ad979a0b85ab8c7034dcad1663fdcf71be Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Fri, 01 Dec 2023 14:18:53 +0800
Subject: [PATCH] 文章通过范围查询
---
src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java | 71 +++++++++++++++++++++++++++++++++++
1 files changed, 71 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java b/src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java
index 354bea1..d6f00db 100644
--- a/src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java
+++ b/src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java
@@ -16,13 +16,27 @@
*/
package org.springblade.modules.discuss.service.impl;
+import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.JSONArray;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.apache.commons.lang3.StringUtils;
+import org.springblade.core.secure.utils.AuthUtil;
+import org.springblade.modules.discuss.entity.TopicsEntity;
+import org.springblade.modules.discuss.entity.UserPublicEnrollEntity;
import org.springblade.modules.discuss.entity.UserTopicsEntity;
import org.springblade.modules.discuss.mapper.UserTopicsMapper;
+import org.springblade.modules.discuss.service.ITopicsService;
import org.springblade.modules.discuss.service.IUserTopicsService;
import org.springblade.modules.discuss.vo.UserTopicsVO;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import javax.annotation.Resource;
+import java.util.ArrayList;
+import java.util.List;
/**
* 用户议题报表 服务实现类
@@ -32,6 +46,8 @@
*/
@Service
public class UserTopicsServiceImpl extends ServiceImpl<UserTopicsMapper, UserTopicsEntity> implements IUserTopicsService {
+ @Resource
+ private ITopicsService topicsService;
@Override
public IPage<UserTopicsVO> selectUserTopicsPage(IPage<UserTopicsVO> page, UserTopicsVO userTopics) {
@@ -39,4 +55,59 @@
}
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public Boolean batchSave(List<TopicsEntity> topics) {
+ List<UserTopicsEntity> objects = new ArrayList<>();
+ for (TopicsEntity topic : topics) {
+ UserTopicsEntity userTopicsEntity = new UserTopicsEntity();
+ userTopicsEntity.setUserId(AuthUtil.getUserId());
+ userTopicsEntity.setSelected(topic.getSelected());
+ userTopicsEntity.setTopicsId(topic.getId());
+ userTopicsEntity.setPublicDiscussId(topic.getPublicDiscussId());
+ objects.add(userTopicsEntity);
+ if (topic.getOptionRange().equals(0)) {
+ if (StringUtils.isBlank(topic.getSelected())) {
+ break;
+ }
+ UserTopicsEntity userTopics = new UserTopicsEntity();
+ userTopics.setTopicsId(Integer.valueOf(topic.getSelected()));
+ userTopics.setUserId(AuthUtil.getUserId());
+ userTopics.setPublicDiscussId(topic.getPublicDiscussId());
+ UpdateWrapper<TopicsEntity> objectUpdateWrapper = new UpdateWrapper<>();
+ objectUpdateWrapper.setSql("number = number + 1");
+ objectUpdateWrapper.eq("id", topic.getSelected());
+ topicsService.update(null, objectUpdateWrapper);
+ baseMapper.insert(userTopics);
+ } else {
+ if (StringUtils.isBlank(topic.getSelected())) {
+ break;
+ }
+ JSONArray objects1 = JSON.parseArray(topic.getSelected());
+ List<UserTopicsEntity> objectsTwo = new ArrayList<>();
+ for (Object o : objects1) {
+ UserTopicsEntity userTopics = new UserTopicsEntity();
+ userTopics.setTopicsId((Integer) o);
+ userTopics.setUserId(AuthUtil.getUserId());
+ userTopics.setPublicDiscussId(topic.getPublicDiscussId());
+ UpdateWrapper<TopicsEntity> objectUpdateWrapper = new UpdateWrapper<>();
+ objectUpdateWrapper.setSql("number = number + 1");
+ objectUpdateWrapper.eq("id", o);
+ objectsTwo.add(userTopics);
+ topicsService.update(null, objectUpdateWrapper);
+ }
+ saveOrUpdateBatch(objectsTwo);
+ }
+ }
+ return saveOrUpdateBatch(objects);
+ }
+
+
+ @Override
+ public Integer getCount(Integer id) {
+ List<UserTopicsEntity> list = list(Wrappers.<UserTopicsEntity>lambdaQuery()
+ .eq(UserTopicsEntity::getPublicDiscussId, id)
+ .groupBy(UserTopicsEntity::getUserId));
+ return list.size();
+ }
}
--
Gitblit v1.9.3