From 079c4fdc2ac37c06ef3aa17672a8e5dff69c58bc Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Mon, 01 Apr 2024 10:22:05 +0800
Subject: [PATCH] 场所检查新增日志打印，报警新增排序
---
src/main/java/org/springblade/modules/discuss/service/impl/UserTopicsServiceImpl.java | 321 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 320 insertions(+), 1 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..a432098 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,53 @@
*/
package org.springblade.modules.discuss.service.impl;
+import com.alibaba.excel.EasyExcelFactory;
+import com.alibaba.excel.ExcelWriter;
+import com.alibaba.excel.write.metadata.WriteSheet;
+import com.alibaba.excel.write.metadata.style.WriteCellStyle;
+import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
+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.apache.poi.ss.usermodel.HorizontalAlignment;
+import org.jetbrains.annotations.Nullable;
+import org.springblade.common.constant.CommonConstant;
+import org.springblade.common.utils.SpringUtils;
+import org.springblade.core.redis.cache.BladeRedis;
+import org.springblade.core.secure.utils.AuthUtil;
+import org.springblade.core.tool.utils.SpringUtil;
+import org.springblade.modules.discuss.entity.PublicDiscussEntity;
+import org.springblade.modules.discuss.entity.TopicsEntity;
import org.springblade.modules.discuss.entity.UserTopicsEntity;
+import org.springblade.modules.discuss.excel.UserTopicsExcel;
+import org.springblade.modules.discuss.excel.householdExcel;
import org.springblade.modules.discuss.mapper.UserTopicsMapper;
+import org.springblade.modules.discuss.service.IPublicDiscussService;
+import org.springblade.modules.discuss.service.ITopicsService;
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.springblade.modules.house.entity.HouseEntity;
+import org.springblade.modules.house.entity.HouseholdEntity;
+import org.springblade.modules.house.excel.HouseHoldExcel;
+import org.springblade.modules.house.service.IHouseService;
+import org.springblade.modules.house.service.IHouseholdService;
+import org.springblade.modules.house.vo.HouseholdVO;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import javax.annotation.Resource;
+import java.io.OutputStream;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.stream.Collectors;
/**
* 用户议题报表 服务实现类
@@ -32,11 +72,290 @@
*/
@Service
public class UserTopicsServiceImpl extends ServiceImpl<UserTopicsMapper, UserTopicsEntity> implements IUserTopicsService {
+ @Resource
+ private ITopicsService topicsService;
+ public static final String SMS_VALIDATE_PHONE = "sms:validate:code:";
+
+ @Autowired
+ private BladeRedis redisTemplate;
@Override
public IPage<UserTopicsVO> selectUserTopicsPage(IPage<UserTopicsVO> page, UserTopicsVO userTopics) {
- return page.setRecords(baseMapper.selectUserTopicsPage(page, userTopics));
+ if (StringUtils.isNotBlank(userTopics.getDistrictId())) {
+ List<String> longs = JSON.parseArray(userTopics.getDistrictId()).toJavaList(String.class);
+ IDistrictService bean = SpringUtils.getBean(IDistrictService.class);
+ List<DistrictEntity> list = bean.list(Wrappers.<DistrictEntity>lambdaQuery().in(DistrictEntity::getId, longs));
+ List<String> collect = list.stream().map(item ->
+ item.getAoiCode()
+ ).collect(Collectors.toList());
+ if (collect != null) {
+ userTopics.setAoiCodeList(collect);
+ }
+ }
+ IHouseholdService householdService = SpringUtils.getBean(IHouseholdService.class);
+ HouseholdEntity householdEntity = householdService.getOne(Wrappers.<HouseholdEntity>lambdaQuery()
+ .eq(HouseholdEntity::getHouseCode, userTopics.getHouseCode())
+ .eq(HouseholdEntity::getAssociatedUserId, AuthUtil.getUserId())
+ .eq(HouseholdEntity::getIsDeleted, 0)
+ .last("limit 1"));
+ if (householdEntity != null) {
+ userTopics.setHouseholdId(householdEntity.getId());
+ }
+ List<UserTopicsVO> userTopicsVOS = baseMapper.selectUserTopicsPage(page, userTopics);
+ return page.setRecords(userTopicsVOS);
}
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public String batchSave(TopicsVO topics) throws Exception {
+ if (StringUtils.isNotBlank(topics.getPhone())) {
+ Object validateCode = redisTemplate.get(SMS_VALIDATE_PHONE + topics.getPhone());
+ if (validateCode == null) {
+ return "验证码已过期";
+ }
+ if (!validateCode.toString().equals(topics.getCode())) {
+ return "验证码错误";
+ }
+ //删除验证码
+ redisTemplate.del(SMS_VALIDATE_PHONE + topics.getPhone());
+ }
+ // 判断是否一户一票 还是一人一票
+ List<TopicsVO> topicsList = topics.getChildren();
+ IHouseholdService householdService = SpringUtils.getBean(IHouseholdService.class);
+ HouseholdEntity householdEntity = householdService.getOne(Wrappers.<HouseholdEntity>lambdaQuery()
+ .eq(HouseholdEntity::getHouseCode, topicsList.get(0).getHouseCode())
+ .eq(HouseholdEntity::getAssociatedUserId, AuthUtil.getUserId())
+ .eq(HouseholdEntity::getIsDeleted, 0)
+ .last("limit 1"));
+ IPublicDiscussService bean = SpringUtil.getBean(IPublicDiscussService.class);
+ PublicDiscussEntity one = bean.getOne(Wrappers.<PublicDiscussEntity>lambdaQuery().eq(PublicDiscussEntity::getArticleId, topicsList.get(0).getArticleId()));
+ // 一户一票
+ if (one.getVoteRestrictions().equals(CommonConstant.NUMBER_ONE)) {
+ long count = count(Wrappers.<UserTopicsEntity>lambdaQuery()
+ .eq(UserTopicsEntity::getHouseCode, topicsList.get(0).getHouseCode())
+ .eq(UserTopicsEntity::getArticleId, topicsList.get(0).getArticleId()));
+ if (count > 0) {
+ return "您的房屋已投票，不能重复投票！";
+ }
+ } else {
+ //
+ long count = count(Wrappers.<UserTopicsEntity>lambdaQuery()
+ .eq(UserTopicsEntity::getHouseholdId, householdEntity.getId())
+ .eq(UserTopicsEntity::getArticleId, topicsList.get(0).getArticleId()));
+ if (count > 0) {
+ return "您已投票，不能重复投票！";
+ }
+ }
+ for (TopicsVO topic : topicsList) {
+ if (topic.getMandatoryFlag().equals(2)) {
+ if (topic.getOptionNumberMin() > 1) {
+ JSONArray objects1 = JSON.parseArray(topic.getSelected());
+ if (objects1.size() < topic.getOptionNumberMin()) {
+ return topic.getDiscussContent() + "：议题最少需要选择" + topic.getOptionNumberMin() + "项";
+ }
+ }
+ if (topic.getOptionNumber() > 1) {
+ JSONArray objects1 = JSON.parseArray(topic.getSelected());
+ if (objects1.size() > topic.getOptionNumber()) {
+ return topic.getDiscussContent() + "：议题最多需要选择" + topic.getOptionNumber() + "项";
+ }
+ }
+ }
+ }
+ Boolean userTopics = getaBoolean(topicsList, householdEntity);
+ if (userTopics) return "200";
+ return "操作失败！";
+ }
+
+ @Nullable
+ private Boolean getaBoolean(List<TopicsVO> topics, HouseholdEntity householdEntity) {
+ List<UserTopicsEntity> objects = new ArrayList<>();
+ Boolean result = false;
+ for (TopicsVO topic : topics) {
+ UserTopicsEntity userTopicsEntity = new UserTopicsEntity();
+ userTopicsEntity.setHouseholdId(householdEntity.getId());
+ 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.setSelected(topic.getSelected());
+ userTopics.setHouseholdId(householdEntity.getId());
+ userTopics.setPublicDiscussId(topic.getPublicDiscussId());
+ userTopics.setTopicsId(Integer.valueOf(topic.getSelected()));
+ userTopics.setArticleId(topic.getArticleId());
+ userTopics.setHouseCode(topic.getHouseCode());
+ userTopics.setSignaturePath(topic.getSignaturePath());
+ UpdateWrapper<TopicsEntity> objectUpdateWrapper = new UpdateWrapper<>();
+ objectUpdateWrapper.setSql("number = number + 1");
+ objectUpdateWrapper.eq("id", topic.getSelected());
+ topicsService.update(null, objectUpdateWrapper);
+ result = save(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.setSelected(topic.getSelected());
+ userTopics.setHouseholdId(householdEntity.getId());
+ userTopics.setPublicDiscussId(topic.getPublicDiscussId());
+ userTopics.setArticleId(topic.getArticleId());
+ userTopics.setHouseCode(topic.getHouseCode());
+ userTopics.setTopicsId((Integer) o);
+ userTopics.setSignaturePath(topic.getSignaturePath());
+ objectsTwo.add(userTopics);
+ UpdateWrapper<TopicsEntity> objectUpdateWrapper = new UpdateWrapper<>();
+ objectUpdateWrapper.setSql("number = number + 1");
+ objectUpdateWrapper.eq("id", o);
+ topicsService.update(null, objectUpdateWrapper);
+ }
+ result = saveBatch(objectsTwo);
+ }
+ }
+ return result;
+ }
+
+
+ @Override
+ public Integer getCount(Integer id) {
+ List<UserTopicsEntity> list = list(Wrappers.<UserTopicsEntity>lambdaQuery()
+ .eq(UserTopicsEntity::getPublicDiscussId, id)
+ .groupBy(UserTopicsEntity::getHouseholdId));
+ return list.size();
+ }
+
+ @Override
+ public List<UserTopicsExcel> exportUser(UserTopicsVO userTopics) {
+ if (StringUtils.isNotBlank(userTopics.getDistrictId())) {
+ List<String> longs = JSON.parseArray(userTopics.getDistrictId()).toJavaList(String.class);
+ IDistrictService bean = SpringUtils.getBean(IDistrictService.class);
+ List<DistrictEntity> list = bean.list(Wrappers.<DistrictEntity>lambdaQuery().in(DistrictEntity::getId, longs));
+ List<String> collect = list.stream().map(item ->
+ item.getAoiCode()
+ ).collect(Collectors.toList());
+ if (collect != null) {
+ userTopics.setAoiCodeList(collect);
+ }
+ }
+ List<UserTopicsExcel> userTopicsExcels = baseMapper.exportUser(userTopics);
+ return userTopicsExcels;
+ }
+
+ @Override
+ public Boolean saveUserTopicsEntity(UserTopicsEntity userTopics) {
+ IHouseholdService householdService = SpringUtils.getBean(IHouseholdService.class);
+ HouseholdEntity householdEntity = householdService.getOne(Wrappers.<HouseholdEntity>lambdaQuery()
+ .eq(HouseholdEntity::getHouseCode, userTopics.getHouseCode())
+ .eq(HouseholdEntity::getAssociatedUserId, AuthUtil.getUserId())
+ .eq(HouseholdEntity::getIsDeleted, 0)
+ .last("limit 1"));
+ if (householdEntity != null) {
+ userTopics.setHouseholdId(householdEntity.getId());
+ }
+ return save(userTopics);
+ }
+
+ @Override
+ public void handleExcel(OutputStream out, UserTopicsVO userTopics) {
+ ExcelWriter excelWriter = EasyExcelFactory.write(out).build();
+ //设置内容样式
+ WriteCellStyle contentStyle = new WriteCellStyle();
+ contentStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);//居中
+ contentStyle.setWrapped(true);//自动换行
+ //设置头部样式
+ WriteCellStyle headerStyle = new WriteCellStyle();
+ headerStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
+ //设置策略
+ HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headerStyle, contentStyle);
+ WriteSheet proposalSheet = EasyExcelFactory.writerSheet(0, "委员提案").head(HouseHoldExcel.class).registerWriteHandler(horizontalCellStyleStrategy).build();
+ WriteSheet publicopinionSheet = EasyExcelFactory.writerSheet(1, "社情民意").head(HouseHoldExcel.class).registerWriteHandler(horizontalCellStyleStrategy).build();
+ excelWriter.write(getProposal(userTopics), proposalSheet);
+ excelWriter.write(getPublicopinion(userTopics), publicopinionSheet);
+
+
+ }
+
+ //首页-房屋记录
+ private List<householdExcel> getProposal(UserTopicsVO userTopics) {
+ List<householdExcel> list = new ArrayList<>();
+ JSONArray objects1 = JSON.parseArray(userTopics.getDistrictId());
+ List<String> collect1 = objects1.stream().map(item -> (String)item).collect(Collectors.toList());
+ IDistrictService bean3 = SpringUtils.getBean(IDistrictService.class);
+ List<DistrictEntity> list3 = bean3.list(Wrappers.<DistrictEntity>lambdaQuery().in(DistrictEntity::getId, collect1));
+ List<String> aoiCodeList = list3.stream().map(item -> item.getAoiCode() ).collect(Collectors.toList());
+ userTopics.setAoiCodeList(aoiCodeList);
+ List<householdExcel> householdList = baseMapper.getHouseholdList(userTopics);
+//
+// householdExcel vo = new householdExcel();
+// list.add(vo);
+// IHouseService bean = SpringUtils.getBean(IHouseService.class);
+// JSONArray objects = JSON.parseArray(userTopics.getDistrictId());
+//
+// List<HouseEntity> list1 = bean.list(Wrappers.<HouseEntity>lambdaQuery().in(HouseEntity::getDistrictCode, aoiCodeList));
+//
+// IHouseholdService bean1 = SpringUtils.getBean(IHouseholdService.class);
+//
+// IUserTopicsService bean2 = SpringUtils.getBean(IUserTopicsService.class);
+//
+// for (HouseEntity houseEntity : list1) {
+// householdExcel householdExcel = new householdExcel();
+// householdExcel.setArea(houseEntity.getArea());
+// householdExcel.setBuilding(houseEntity.getBuilding());
+// householdExcel.setRoom(houseEntity.getRoom());
+// householdExcel.setRemark(houseEntity.getRemark());
+// // 查询住户
+// List<HouseholdEntity> list2 = bean1.list(Wrappers.<HouseholdEntity>lambdaQuery()
+// .eq(HouseholdEntity::getHouseCode, houseEntity.getHouseCode())
+// .eq(HouseholdEntity::getIsDeleted, 0)
+// .ne(HouseholdEntity::getRelationship, 18));
+// // 判断住户是否有投票
+// for (HouseholdEntity householdEntity : list2) {
+// householdExcel.setName(householdEntity.getName());
+// householdExcel.setPhone(householdEntity.getPhoneNumber());
+// long count = bean2.count(Wrappers.<UserTopicsEntity>lambdaQuery()
+// .eq(UserTopicsEntity::getHouseholdId, householdEntity.getId()));
+// if (count > 0) {
+// // 查询选择的结果
+// userTopics.setDiscussContent("管理规约");
+// userTopics.setHouseholdId(householdEntity.getId());
+// UserTopicsVO getresult = baseMapper.getresult(userTopics);
+// if (getresult != null) {
+// householdExcel.setManagementRegulations(getresult.getOptionContent());
+// }
+// userTopics.setDiscussContent("议事规则");
+// UserTopicsVO getresult2 = baseMapper.getresult(userTopics);
+// if (getresult2 != null) {
+// householdExcel.setRulesOfProcedure(getresult2.getOptionContent());
+// }
+// householdExcel.setVoteFlag("是");
+// break;
+// } else {
+// householdExcel.setVoteFlag("否");
+// }
+// }
+ // 添加
+ list.addAll(householdList);
+// }
+ return list;
+ }
+
+ //首页-议事
+ private List<UserTopicsExcel> getPublicopinion(UserTopicsVO userTopics) {
+ List<UserTopicsExcel> list = new ArrayList<>();
+ List<UserTopicsExcel> userTopicsExcels = baseMapper.getresultTwo(userTopics);
+ UserTopicsExcel vo = new UserTopicsExcel();
+ list.add(vo);
+ list.addAll(userTopicsExcels);
+ return list;
+ }
}
--
Gitblit v1.9.3