From 7d234970f6cee01b940fae5a04b84a5316dd0162 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 16 十二月 2021 13:27:40 +0800
Subject: [PATCH] 12/16 西区大屏参数增加
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java | 682 +++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 523 insertions(+), 159 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java
index f091d30..e3eb9f9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java
@@ -1,39 +1,64 @@
package com.panzhihua.service_community.service.impl;
-import com.alibaba.fastjson.JSONArray;
+import static java.util.Objects.isNull;
+import static org.apache.commons.lang3.StringUtils.isBlank;
+import static org.apache.commons.lang3.StringUtils.isNotBlank;
+
+import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.text.DecimalFormat;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.Date;
+import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
+
+import javax.annotation.Resource;
+
+import org.apache.commons.lang3.time.DateUtils;
+import org.springframework.beans.BeanUtils;
+import org.springframework.data.redis.core.StringRedisTemplate;
+import org.springframework.stereotype.Service;
+import org.springframework.util.ObjectUtils;
+
import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.panzhihua.common.model.dtos.community.ExcelElderAuthDTO;
import com.panzhihua.common.model.dtos.community.bigscreen.work.ScreenActActivityListDTO;
import com.panzhihua.common.model.dtos.community.bigscreen.work.ScreenActActivityPeopleListDTO;
import com.panzhihua.common.model.vos.IndexDataVO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
-import com.panzhihua.common.model.vos.community.*;
+import com.panzhihua.common.model.vos.community.ActivitySignVO;
+import com.panzhihua.common.model.vos.community.ComActActEvaluateVO;
+import com.panzhihua.common.model.vos.community.ComActActPictureVO;
+import com.panzhihua.common.model.vos.community.ComActActRegistVO;
+import com.panzhihua.common.model.vos.community.ComActActivityStatisticsVO;
+import com.panzhihua.common.model.vos.community.ComActActivityVO;
+import com.panzhihua.common.model.vos.community.CommunityActivitiesVO;
+import com.panzhihua.common.model.vos.community.CommunityGovernanceTrendsVO;
+import com.panzhihua.common.model.vos.community.SignactivityVO;
import com.panzhihua.common.model.vos.community.screen.work.ActActivityListVO;
import com.panzhihua.common.service.user.UserService;
+import com.panzhihua.common.utlis.WxUtil;
+import com.panzhihua.common.utlis.WxXCXTempSend;
+import com.panzhihua.service_community.dao.ComActActEvaluateDAO;
+import com.panzhihua.service_community.dao.ComActActPictureDAO;
+import com.panzhihua.service_community.dao.ComActActRegistDAO;
import com.panzhihua.service_community.dao.ComActActSignDAO;
import com.panzhihua.service_community.dao.ComActActivityDAO;
-import com.panzhihua.service_community.dao.ComActDiscussOptionUserDAO;
+import com.panzhihua.service_community.model.dos.ComActActEvaluateDO;
+import com.panzhihua.service_community.model.dos.ComActActPictureDO;
+import com.panzhihua.service_community.model.dos.ComActActRegistDO;
import com.panzhihua.service_community.model.dos.ComActActSignDO;
import com.panzhihua.service_community.model.dos.ComActActivityDO;
import com.panzhihua.service_community.service.ComActActivityService;
-import lombok.extern.slf4j.Slf4j;
-import org.apache.commons.lang3.time.DateUtils;
-import org.springframework.beans.BeanUtils;
-import org.springframework.stereotype.Service;
-import org.springframework.util.ObjectUtils;
-import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.Arrays;
-import java.util.Date;
-import java.util.List;
-import java.util.stream.Collectors;
-import java.util.stream.Stream;
+import lombok.extern.slf4j.Slf4j;
/**
* @program: springcloud_k8s_panzhihuazhihuishequ
@@ -43,63 +68,118 @@
**/
@Slf4j
@Service
-public class ComActActivityServiceImpl extends ServiceImpl<ComActActivityDAO, ComActActivityDO> implements ComActActivityService {
+public class ComActActivityServiceImpl extends ServiceImpl<ComActActivityDAO, ComActActivityDO>
+ implements ComActActivityService {
+ private static final String DELIMITER = ":";
+ private static final String ACTIVITY_SIGN_IN = "ACTIVITY:SIGN:IN";
@Resource
private ComActActivityDAO comActActivityDAO;
@Resource
private ComActActSignDAO comActActSignDAO;
@Resource
private UserService userService;
+ @Resource
+ private ComActActEvaluateDAO comActActEvaluateDAO;
+ @Resource
+ private ComActActRegistDAO comActActRegistDAO;
+ @Resource
+ private StringRedisTemplate stringRedisTemplate;
+ @Resource
+ private ComActActPictureDAO comActActPictureDAO;
/**
* 新增社区活动
- * @param comActActivityVO 新增信息
+ *
+ * @param comActActivityVO
+ * 新增信息
* @return 新增结果
*/
@Override
public R addActivity(ComActActivityVO comActActivityVO) {
- ComActActivityDO comActActivityDO=new ComActActivityDO();
- BeanUtils.copyProperties(comActActivityVO,comActActivityDO);
+ ComActActivityDO comActActivityDO = new ComActActivityDO();
+ BeanUtils.copyProperties(comActActivityVO, comActActivityDO);
Integer status = comActActivityVO.getStatus();
Date now = new Date();
- if (status.intValue()!=1) {
- comActActivityDO.setPublishAt(now);//发布时间
+ if (status.intValue() != 1) {
+ comActActivityDO.setPublishAt(now);// 发布时间
}
- //如果发布时间大于现在时间状态改为进行中
+ // 如果发布时间大于现在时间状态改为进行中
/*if(now.getTime()<comActActivityVO.getBeginAt().getTime()){
comActActivityDO.setStatus(3);
}*/
- if(status.intValue()==2) {//点击‘保存并发布’ 按钮
- //报名结束时间大于当前时间则设置为“进行中”
+ if (status.intValue() == 2) {// 点击‘保存并发布’ 按钮
+ // 报名结束时间大于当前时间则设置为“进行中”
if (comActActivityVO.getSignUpEnd() != null && now.getTime() < comActActivityVO.getSignUpEnd().getTime()) {
- comActActivityDO.setStatus(4);
+ comActActivityDO.setStatus(3);
}
}
boolean save = this.save(comActActivityDO);
- if(!save){
+ if (!save) {
return R.fail();
}
- ComActActivityDO one = this.getOne(new QueryWrapper<ComActActivityDO>().lambda().eq(ComActActivityDO::getActivityName, comActActivityDO.getActivityName()).orderByDesc(ComActActivityDO::getCreateAt).last(" limit 1 "));
+ ComActActivityDO one = this.getOne(new QueryWrapper<ComActActivityDO>().lambda()
+ .eq(ComActActivityDO::getActivityName, comActActivityDO.getActivityName())
+ .orderByDesc(ComActActivityDO::getCreateAt).last(" limit 1 "));
Long activityId = one.getId();
+
+ //保存上传照片
+ ComActActPictureDO comActActPictureDO = new ComActActPictureDO();
+ comActActPictureDO.setActivityId(activityId);
+ comActActPictureDO.setUserId(comActActivityVO.getUserId());
+ comActActPictureDO.setUploadPicture(comActActivityVO.getCover());
+ comActActPictureDO.setSysFlag(0);
+ comActActPictureDAO.insert(comActActPictureDO);
return R.ok(activityId);
}
/**
* 编辑社区活动
*
- * @param comActActivityVO 编辑内容
+ * @param comActActivityVO
+ * 编辑内容
* @return 编辑结果
*/
@Override
public R putActivity(ComActActivityVO comActActivityVO) {
- ComActActivityDO comActActivityDO=new ComActActivityDO();
- BeanUtils.copyProperties(comActActivityVO,comActActivityDO);
+ ComActActivityDO comActActivityDO = this.comActActivityDAO.selectById(comActActivityVO.getId());
+ if (comActActivityDO == null) {
+ return R.fail("未找到社区活动");
+ }
- //结束时间大于当前时间则设置为“进行中”
+ if (!comActActivityDO.getActivityAddr().equals(comActActivityVO.getActivityAddr())
+ || !comActActivityDO.getBeginAt().equals(comActActivityVO.getBeginAt())) {
+ // 修改活动开始时间与活动地点需要推送订阅消息给用户
+ ActivitySignVO activitySignVO = new ActivitySignVO();
+ activitySignVO.setActivityId(comActActivityVO.getId());
+ List<ActivitySignVO> activitySignVOS = comActActSignDAO.listActivitySigns(activitySignVO);
+ if (!activitySignVOS.isEmpty()) {
+ try {
+ WxXCXTempSend util = new WxXCXTempSend();
+ String accessToken = util.getAppAccessToken();
+
+ activitySignVOS.forEach(activitySignVO1 -> {
+ // 变更社区活动推送订阅消息给用户
+ WxUtil.sendSubscribeHDBG(activitySignVO1.getOpenid(), accessToken,
+ comActActivityVO.getActivityName(),
+ com.panzhihua.common.utlis.DateUtils.format(
+ comActActivityDO.getBeginAt(), com.panzhihua.common.utlis.DateUtils.ymdhms_format),
+ comActActivityDO.getActivityAddr(),
+ com.panzhihua.common.utlis.DateUtils.format(comActActivityVO.getBeginAt(),
+ com.panzhihua.common.utlis.DateUtils.ymdhms_format),
+ comActActivityVO.getActivityAddr());
+ });
+ } catch (Exception e) {
+ log.error("消息推送失败，失败原因：" + e.getMessage());
+ }
+ }
+ }
+ BeanUtils.copyProperties(comActActivityVO, comActActivityDO);
+
+ // 结束时间大于当前时间则设置为“进行中”
Date now = new Date();
- if(comActActivityVO.getSignUpEnd()!=null && now.getTime()<comActActivityVO.getSignUpEnd().getTime()){
- comActActivityDO.setStatus(4);
+ if (comActActivityVO.getSignUpEnd() != null && now.getTime() < comActActivityVO.getSignUpEnd().getTime()) {
+ comActActivityDO.setStatus(3);
}
boolean b = this.updateById(comActActivityDO);
if (b) {
@@ -111,7 +191,8 @@
/**
* 分页查询社区活动
*
- * @param comActActivityVO 查询参数
+ * @param comActActivityVO
+ * 查询参数
* @return 分页集合
*/
@Override
@@ -119,41 +200,44 @@
Page page = new Page<>();
Long pageNum = comActActivityVO.getPageNum();
Long pageSize = comActActivityVO.getPageSize();
- if (null==pageNum||0==pageNum) {
+ if (null == pageNum || 0 == pageNum) {
pageNum = 1l;
}
- if (null==pageSize||0==pageSize) {
+ if (null == pageSize || 0 == pageSize) {
pageSize = 10l;
}
page.setSize(pageSize);
page.setCurrent(pageNum);
IPage<ComActActivityVO> iPage = comActActivityDAO.pageActivity(page, comActActivityVO);
- List<ComActActivityVO> records = iPage.getRecords();
- if (!ObjectUtils.isEmpty(records)) {
- records.forEach(comActActivityVO1 -> {
- Integer status = comActActivityVO1.getStatus();
- if (status.intValue()==3) {
- comActActivityVO1.setStatus(4);
- }
- });
- }
+// List<ComActActivityVO> records = iPage.getRecords();
+// if (!ObjectUtils.isEmpty(records)) {
+// records.forEach(comActActivityVO1 -> {
+// Integer status = comActActivityVO1.getStatus();
+// if (status.intValue() == 3) {
+// comActActivityVO1.setStatus(4);
+// }
+// });
+// }
return R.ok(iPage);
}
/**
* 发布活动
*
- * @param comActActivityVO 主键id 发布时间
+ * @param comActActivityVO
+ * 主键id 发布时间
* @return 发布结果
*/
@Override
public R releaseActivity(ComActActivityVO comActActivityVO) {
- ComActActivityDO comActActivityDO=new ComActActivityDO();
- comActActivityDO.setId(comActActivityVO.getId());
+ ComActActivityDO comActActivityDO = comActActivityDAO.selectById(comActActivityVO.getId());
comActActivityDO.setPublishAt(comActActivityVO.getPublishAt());
- comActActivityDO.setStatus(comActActivityVO.getStatus());
+ comActActivityDO.setStatus(3);
+ if (comActActivityVO.getPublishAt().after(comActActivityDO.getSignUpEnd())) {
+ comActActivityVO.setStatus(4);
+ }
int update = comActActivityDAO.updateById(comActActivityDO);
- if (update>0) {
+ if (update > 0) {
return R.ok();
}
return R.fail();
@@ -162,17 +246,18 @@
/**
* 取消活动
*
- * @param comActActivityVO 取消原因
+ * @param comActActivityVO
+ * 取消原因
* @return 取消结果
*/
@Override
public R cancelActivity(ComActActivityVO comActActivityVO) {
- ComActActivityDO comActActivityDO=new ComActActivityDO();
+ ComActActivityDO comActActivityDO = new ComActActivityDO();
comActActivityDO.setId(comActActivityVO.getId());
comActActivityDO.setStatus(comActActivityVO.getStatus());
comActActivityDO.setCancelReason(comActActivityVO.getCancelReason());
int update = comActActivityDAO.updateById(comActActivityDO);
- if (update>0) {
+ if (update > 0) {
return R.ok();
}
return R.fail();
@@ -181,20 +266,24 @@
/**
* 活动详情
*
- * @param id 活动id
+ * @param id
+ * 活动id
* @param userId
* @return 详情
*/
@Override
public ComActActivityVO inforActivity(Long id, Long userId) {
- ComActActivityVO comActActivityVO=comActActivityDAO.inforActivity(id);
+ ComActActivityVO comActActivityVO = comActActivityDAO.inforActivity(id);
if (!ObjectUtils.isEmpty(comActActivityVO)) {
- ComActActSignDO comActActSignDO = comActActSignDAO.selectOne(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getActivityId, id).eq(ComActActSignDO::getUserId, userId));
- if (!ObjectUtils.isEmpty(comActActSignDO)) {
- comActActivityVO.setIsSign(1);
- comActActivityVO.setIsVolunteer(comActActSignDO.getIsVolunteer());
- }else {
-
+ if (userId != null) {
+ LambdaQueryWrapper<ComActActSignDO> actSignQuery = new LambdaQueryWrapper<>();
+ actSignQuery.eq(ComActActSignDO::getActivityId, id);
+ actSignQuery.eq(ComActActSignDO::getUserId, userId);
+ ComActActSignDO comActActSignDO = comActActSignDAO.selectOne(actSignQuery);
+ if (!ObjectUtils.isEmpty(comActActSignDO)) {
+ comActActivityVO.setIsSign(1);
+ comActActivityVO.setIsVolunteer(comActActSignDO.getIsVolunteer());
+ }
}
}
return comActActivityVO;
@@ -203,21 +292,112 @@
/**
* 活动报名名单
*
- * @param activitySignVO 查询参数
+ * @param activitySignVO
+ * 查询参数
* @return 报名人员集合
*/
@Override
public R listActivitySign(ActivitySignVO activitySignVO) {
- IPage<ActivitySignVO> activitySignVOS = comActActSignDAO.listActivitySign(new Page(activitySignVO.getPageNum(),activitySignVO.getPageSize()),activitySignVO);
-// List<ActivitySignVO> activitySignVOS = comActActSignDAO.listActivitySign(activitySignVO);
+ IPage<ActivitySignVO> activitySignVOS = comActActSignDAO
+ .listActivitySign(new Page(activitySignVO.getPageNum(), activitySignVO.getPageSize()), activitySignVO);
+ // List<ActivitySignVO> activitySignVOS = comActActSignDAO.listActivitySign(activitySignVO);
return R.ok(activitySignVOS);
+ }
+
+ @Override
+ public R listActivitySigns(ActivitySignVO activitySignVO) {
+ List<ActivitySignVO> activitySignVOS = comActActSignDAO.listActivitySigns(activitySignVO);
+ return R.ok(activitySignVOS);
+ }
+
+ @Override
+ public R getSignLists(ActivitySignVO activitySignVO) {
+ return R.ok(comActActSignDAO.getSignLists(activitySignVO));
+ }
+
+ @Override
+ public R pageActivityEvaluates(ComActActEvaluateVO comActActEvaluateVO) {
+ IPage<ComActActEvaluateVO> comActActEvaluateVOIPage = comActActEvaluateDAO
+ .pageActivityEvaluates(new Page(comActActEvaluateVO.getPageNum(), comActActEvaluateVO.getPageSize()), comActActEvaluateVO);
+ return R.ok(comActActEvaluateVOIPage);
+ }
+
+ @Override
+ public R getEvaluateLists(ComActActEvaluateVO comActActEvaluateVO) {
+ return R.ok(comActActEvaluateDAO.getEvaluateLists(comActActEvaluateVO));
+ }
+
+ @Override
+ public R pageActivityRegists(ComActActRegistVO comActActRegistVO) {
+ IPage<ComActActRegistVO> comActActRegistVOIPage = comActActRegistDAO.pageActivityRegists(new Page(comActActRegistVO.getPageNum(), comActActRegistVO.getPageSize()), comActActRegistVO);
+ return R.ok(comActActRegistVOIPage);
+ }
+
+ @Override
+ public R getRegistLists(ComActActRegistVO comActActRegistVO) {
+ return R.ok(comActActRegistDAO.getRegistLists(comActActRegistVO));
+ }
+
+ @Override
+ public R getNoRegistLists(ComActActRegistVO comActActRegistVO) {
+ return R.ok(comActActRegistDAO.getNoRegistLists(comActActRegistVO));
+ }
+
+ @Override
+ public R activityStatistics(Long activityId) {
+ ComActActivityStatisticsVO comActActivityStatisticsVO = comActActivityDAO.activityStatistics(activityId);
+ if (comActActivityStatisticsVO != null) {
+ if (comActActivityStatisticsVO.getSignTotal().equals(0)){
+ comActActivityStatisticsVO.setSignTotalStr("不限");
+ comActActivityStatisticsVO.setNoSignTotalStr("");
+ comActActivityStatisticsVO.setSignPersent("");
+ }else {
+ comActActivityStatisticsVO.setSignTotalStr(String.valueOf(comActActivityStatisticsVO.getSignTotal()));
+ comActActivityStatisticsVO.setNoSignTotalStr(String.valueOf(Integer.valueOf(comActActivityStatisticsVO.getSignTotalStr()) - comActActivityStatisticsVO.getReallySignTotal()));
+ comActActivityStatisticsVO.setSignPersent(getPersent(comActActivityStatisticsVO.getReallySignTotal(),comActActivityStatisticsVO.getSignTotal()));
+ }
+ comActActivityStatisticsVO.setRegistPersent(getPersent(comActActivityStatisticsVO.getReallyRegistTotal(),comActActivityStatisticsVO.getRegistTotal()));
+ comActActivityStatisticsVO.setEvaluatePersent(getPersent(comActActivityStatisticsVO.getReallyEvaluateTotal(),comActActivityStatisticsVO.getEvaluateTotal()));
+ }
+ return R.ok(comActActivityStatisticsVO);
+ }
+
+ @Override
+ public R getPictureList(Long userId) {
+ List<ComActActPictureVO> comActActPictureVOS = new ArrayList<>();
+ List<ComActActPictureDO> comActActPictureDOS = comActActPictureDAO.selectList(new QueryWrapper<ComActActPictureDO>().lambda().
+ eq(ComActActPictureDO::getUserId, userId));
+ if (comActActPictureDOS != null && comActActPictureDOS.size() != 0) {
+ comActActPictureDOS.forEach(comActActPictureDO -> {
+ ComActActPictureVO comActActPictureVO = new ComActActPictureVO();
+ BeanUtils.copyProperties(comActActPictureDO, comActActPictureVO);
+ comActActPictureVOS.add(comActActPictureVO);
+ });
+ }
+ return R.ok(comActActPictureVOS);
+ }
+
+ @Override
+ public R getSysPictureList(Integer type) {
+ List<ComActActPictureVO> comActActPictureVOS = new ArrayList<>();
+ List<ComActActPictureDO> comActActPictureDOS = comActActPictureDAO.selectList(new QueryWrapper<ComActActPictureDO>().lambda().
+ eq(ComActActPictureDO::getSysFlag, 1).eq(ComActActPictureDO :: getType, type));
+ if (comActActPictureDOS != null && comActActPictureDOS.size() != 0) {
+ comActActPictureDOS.forEach(comActActPictureDO -> {
+ ComActActPictureVO comActActPictureVO = new ComActActPictureVO();
+ BeanUtils.copyProperties(comActActPictureDO, comActActPictureVO);
+ comActActPictureVOS.add(comActActPictureVO);
+ });
+ }
+ return R.ok(comActActPictureVOS);
}
/**
* 分页展示我的所有活动 时间倒序排列
*
- * @param comActActivityVO 分页参数
+ * @param comActActivityVO
+ * 分页参数
* @return 分页集合
*/
@Override
@@ -225,10 +405,10 @@
Page page = new Page<>();
Long pageNum = comActActivityVO.getPageNum();
Long pageSize = comActActivityVO.getPageSize();
- if (null==pageNum||0==pageNum) {
+ if (null == pageNum || 0 == pageNum) {
pageNum = 1l;
}
- if (null==pageSize||0==pageSize) {
+ if (null == pageSize || 0 == pageSize) {
pageSize = 10l;
}
page.setSize(pageSize);
@@ -240,7 +420,8 @@
/**
* 报名/取消报名社区活动
*
- * @param signactivityVO 报名参数
+ * @param signactivityVO
+ * 报名参数
* @return 报名 取消报名 结果
*/
@Override
@@ -249,17 +430,51 @@
Integer type = signactivityVO.getType();
Long userId = signactivityVO.getUserId();
Integer isVolunteer = signactivityVO.getIsVolunteer();
-
- int num=0;
- if (1==type) {
+ // 查询社区活动
+ ComActActivityDO actActivityDO = this.baseMapper.selectById(activityId);
+ if (isNull(actActivityDO)) {
+ return R.fail("活动不存在");
+ }
+ int num = 0;
+ if (1 == type) {
R<LoginUserInfoVO> userInfoR = userService.getUserInfoByUserId(String.valueOf(userId));
- LoginUserInfoVO loginUserInfoVO = JSONObject.parseObject(JSONObject.toJSONString(userInfoR.getData()), LoginUserInfoVO.class);
- boolean userNotVolunteer = !(loginUserInfoVO.getIsVolunteer()==1);
- if(isVolunteer == 1 && userNotVolunteer){
+ LoginUserInfoVO loginUserInfoVO =
+ JSONObject.parseObject(JSONObject.toJSONString(userInfoR.getData()), LoginUserInfoVO.class);
+ boolean userNotVolunteer = !(loginUserInfoVO.getIsVolunteer() == 1);
+ if (isVolunteer == 1 && userNotVolunteer) {
return R.fail("只有志愿者才能报名");
}
- ComActActSignDO comActActSignDO=new ComActActSignDO();
+ // 查询当前活动下参与志愿者/居民数量
+ Integer count = comActActSignDAO.selectCount(new QueryWrapper<ComActActSignDO>().lambda()
+ .eq(ComActActSignDO::getActivityId, activityId).eq(ComActActSignDO::getIsVolunteer, isVolunteer));
+ if (isVolunteer.equals(1) && actActivityDO.getVolunteerMax() <= count
+ && !actActivityDO.getVolunteerMax().equals(-1)) {
+ return R.fail("志愿者报名人数已满");
+ }
+
+ //审查用户是否有该活动报名权限（是否活动指定参与人群）
+ String currentUserTags = loginUserInfoVO.getTags();
+ String attendPeople = actActivityDO.getAattendPeople();
+ if (isVolunteer.intValue() == 0 && isNotBlank(attendPeople)) {
+ if (isBlank(currentUserTags)) {
+ currentUserTags = "全部居民";
+ } else {
+ currentUserTags = currentUserTags.concat(",全部居民");
+ }
+ List<String> currentUserTagList = Arrays.asList(currentUserTags.split(","));
+ boolean checkResult = currentUserTagList.stream().anyMatch(currentUserTag -> attendPeople.contains(currentUserTag));
+ if (!checkResult) {
+ return R.fail("您不是指定参与人群！");
+ }
+ }
+
+ if (isVolunteer.equals(0) && actActivityDO.getParticipantMax() <= count
+ && !actActivityDO.getParticipantMax().equals(-1)) {
+ return R.fail("居民报名人数已满");
+ }
+
+ ComActActSignDO comActActSignDO = new ComActActSignDO();
comActActSignDO.setActivityId(activityId);
comActActSignDO.setUserId(userId);
comActActSignDO.setIsVolunteer(isVolunteer);
@@ -272,9 +487,11 @@
log.error(e.getMessage());
}
} else {
- num = comActActSignDAO.delete(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getUserId, userId).eq(ComActActSignDO::getActivityId, activityId).eq(ComActActSignDO::getIsVolunteer, isVolunteer));
+ num = comActActSignDAO
+ .delete(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getUserId, userId)
+ .eq(ComActActSignDO::getActivityId, activityId).eq(ComActActSignDO::getIsVolunteer, isVolunteer));
}
- if (num>0) {
+ if (num > 0) {
return R.ok();
}
return R.fail();
@@ -283,34 +500,41 @@
/**
* 用户参加的所有社区活动
*
- * @param userId 用户id
+ * @param userId
+ * 用户id
* @return 活动列表
*/
@Override
public R listActivity(Long userId) {
- List<ComActActSignDO> comActActSignDOS = comActActSignDAO.selectList(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getUserId, userId));
+ List<ComActActSignDO> comActActSignDOS = comActActSignDAO
+ .selectList(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getUserId, userId));
if (ObjectUtils.isEmpty(comActActSignDOS)) {
return R.fail();
}
- List<Long> longs = comActActSignDOS.stream().map(comActActSignDO -> comActActSignDO.getActivityId()).collect(Collectors.toList());
+ List<Long> longs = comActActSignDOS.stream().map(comActActSignDO -> comActActSignDO.getActivityId())
+ .collect(Collectors.toList());
List<ComActActivityDO> comActActivityDOS = comActActivityDAO.selectBatchIds(longs);
- List<ComActActivityVO>comActActivityVOS=new ArrayList<>();
+ List<ComActActivityVO> comActActivityVOS = new ArrayList<>();
comActActivityDOS.forEach(comActActivityDO -> {
- ComActActivityVO comActActivityVO=new ComActActivityVO();
- BeanUtils.copyProperties(comActActivityDO,comActActivityVO);
- List<ComActActSignDO> collect = comActActSignDOS.stream().filter(comActActSignDO -> comActActSignDO.getActivityId().equals(comActActivityVO.getId())).limit(1).collect(Collectors.toList());
+ ComActActivityVO comActActivityVO = new ComActActivityVO();
+ BeanUtils.copyProperties(comActActivityDO, comActActivityVO);
+ List<ComActActSignDO> collect = comActActSignDOS.stream()
+ .filter(comActActSignDO -> comActActSignDO.getActivityId().equals(comActActivityVO.getId())).limit(1)
+ .collect(Collectors.toList());
ComActActSignDO comActActSignDO = collect.get(0);
Integer isVolunteer = comActActSignDO.getIsVolunteer();
- if (isVolunteer.intValue()==1) {
+ if (isVolunteer.intValue() == 1) {
comActActivityVO.setType(1);
- }else{
+ } else {
comActActivityVO.setType(2);
}
Integer status = comActActivityVO.getStatus();
- if (status.intValue()==3) {
+ if (status.intValue() == 3) {
comActActivityVO.setStatus(4);
}
- comActActivityVO.setSingDate(comActActSignDOS.stream().filter(comActActSignDO1 -> comActActSignDO1.getActivityId().equals(comActActivityVO.getId())).collect(Collectors.toList()).get(0).getCreateAt());
+ comActActivityVO.setSingDate(comActActSignDOS.stream()
+ .filter(comActActSignDO1 -> comActActSignDO1.getActivityId().equals(comActActivityVO.getId()))
+ .collect(Collectors.toList()).get(0).getCreateAt());
comActActivityVOS.add(comActActivityVO);
});
return R.ok(comActActivityVOS);
@@ -319,12 +543,13 @@
/**
* 查询志愿者参与的所有已经完成的活动
*
- * @param phone 用户手机号
+ * @param phone
+ * 用户手机号
* @return 所有活动集合
*/
@Override
public List<ComActActivityVO> listActivityByPhone(String phone) {
- List<ComActActivityVO> comActActivityVOS=comActActivityDAO.listActivityByPhone(phone);
+ List<ComActActivityVO> comActActivityVOS = comActActivityDAO.listActivityByPhone(phone);
return comActActivityVOS;
}
@@ -335,32 +560,34 @@
*/
@Override
public R timedTaskActActivity() {
- List<Long>longs=comActActivityDAO.selectTimedTaskActActivity();
- if (ObjectUtils.isEmpty(longs)) {
- return R.fail("没有需要取消的社区活动");
- }
- List<ComActActivityDO> comActActivityDOS = comActActivityDAO.selectBatchIds(longs);
- List<ComActActivityVO>comActActivityVOS=new ArrayList<>();
- if (!ObjectUtils.isEmpty(comActActivityDOS)) {
- comActActivityDOS.forEach(comActActivityDO -> {
- ComActActivityVO comActActivityVO=new ComActActivityVO();
- BeanUtils.copyProperties(comActActivityDO,comActActivityVO);
- List<ComActActSignDO> comActActSignDOS = comActActSignDAO.selectList(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getActivityId, comActActivityDO.getId()));
- if (!ObjectUtils.isEmpty(comActActSignDOS)) {
- List<ActivitySignVO> activitySignVOList=new ArrayList<>();
- comActActSignDOS.forEach(comActActSignDO -> {
- ActivitySignVO activitySignVO=new ActivitySignVO();
- BeanUtils.copyProperties(comActActSignDO,activitySignVO);
- activitySignVOList.add(activitySignVO);
- comActActivityVO.setActivitySignVOList(activitySignVOList);
- });
- }
- comActActivityVOS.add(comActActivityVO);
- });
- int num=comActActivityDAO.updateIdBatch(longs);
- log.info("定时任务--一共取消社区活动数量【{}】",num);
- }
- return R.ok(comActActivityVOS);
+// List<Long> longs = comActActivityDAO.selectTimedTaskActActivity();
+// if (ObjectUtils.isEmpty(longs)) {
+// return R.fail("没有需要取消的社区活动");
+// }
+// List<ComActActivityDO> comActActivityDOS = comActActivityDAO.selectBatchIds(longs);
+// List<ComActActivityVO> comActActivityVOS = new ArrayList<>();
+// if (!ObjectUtils.isEmpty(comActActivityDOS)) {
+// comActActivityDOS.forEach(comActActivityDO -> {
+// ComActActivityVO comActActivityVO = new ComActActivityVO();
+// BeanUtils.copyProperties(comActActivityDO, comActActivityVO);
+// List<ComActActSignDO> comActActSignDOS = comActActSignDAO.selectList(new QueryWrapper<ComActActSignDO>()
+// .lambda().eq(ComActActSignDO::getActivityId, comActActivityDO.getId()));
+// if (!ObjectUtils.isEmpty(comActActSignDOS)) {
+// List<ActivitySignVO> activitySignVOList = new ArrayList<>();
+// comActActSignDOS.forEach(comActActSignDO -> {
+// ActivitySignVO activitySignVO = new ActivitySignVO();
+// BeanUtils.copyProperties(comActActSignDO, activitySignVO);
+// activitySignVOList.add(activitySignVO);
+// comActActivityVO.setActivitySignVOList(activitySignVOList);
+// });
+// }
+// comActActivityVOS.add(comActActivityVO);
+// });
+// int num = comActActivityDAO.updateIdBatch(longs);
+// log.info("定时任务--一共取消社区活动数量【{}】", num);
+// }
+// return R.ok(comActActivityVOS);
+ return R.ok();
}
/**
@@ -370,24 +597,27 @@
*/
@Override
public R timedTaskActActivityAll() {
-// 修改发布状态 变为未开始
- int num=comActActivityDAO.updateStatusToNotBegin();
- log.info("定时任务--修改社区活动发布状态活动数量【{}】",num);
-// 修改报名状态 变为报名中
- int num1=comActActivityDAO.updateStatusToBeginSign();
- log.info("定时任务--修改社区活动报名状态活动数量【{}】",num1);
-// 修改进行状态 变为进行中或者已结束
- int num2=comActActivityDAO.updateStatusToBeginActiveOrEnd();
- log.info("定时任务--修改社区活动进行状态活动数量【{}】",num2);
- int num3=comActActivityDAO.updateStatusToBeginAfterSingEnd();
- log.info("定时任务--报名结束修改社区活动进行状态活动数量【{}】",num3);
- return R.ok();
+ // 修改发布状态 变为未开始
+ int num = comActActivityDAO.updateStatusToNotBegin();
+ log.info("定时任务--修改社区活动发布状态活动数量【{}】", num);
+ // 修改报名状态 变为报名中
+// int num1 = comActActivityDAO.updateStatusToBeginSign();
+// log.info("定时任务--修改社区活动报名状态活动数量【{}】", num1);
+ int num3 = comActActivityDAO.updateStatusToBeginAfterSingEnd();
+ log.info("定时任务--报名结束修改社区活动进行状态活动数量【{}】", num3);
+ // 查询已经结束的活动，需要计算积分
+ List<Long> activityEndIds = comActActivityDAO.getActivityEndIds();
+ // 修改进行状态 变为进行中或者已结束
+ int num2 = comActActivityDAO.updateStatusToBeginActiveOrEnd();
+ log.info("定时任务--修改社区活动进行状态活动数量【{}】", num2);
+ return R.ok(activityEndIds);
}
/**
* 社区后台分页查询社区活动
*
- * @param comActActivityVO 查询参数
+ * @param comActActivityVO
+ * 查询参数
* @return 返回结果
*/
@Override
@@ -395,36 +625,57 @@
Page page = new Page<>();
Long pageNum = comActActivityVO.getPageNum();
Long pageSize = comActActivityVO.getPageSize();
- if (null==pageNum||0==pageNum) {
+ if (null == pageNum || 0 == pageNum) {
pageNum = 1l;
}
- if (null==pageSize||0==pageSize) {
+ if (null == pageSize || 0 == pageSize) {
pageSize = 10l;
}
page.setSize(pageSize);
page.setCurrent(pageNum);
IPage<ComActActivityVO> iPage = comActActivityDAO.pageActivityCommunityBack(page, comActActivityVO);
+ iPage.getRecords().forEach(vo ->{
+ List<ComActActEvaluateDO> comActActEvaluateDOList = comActActEvaluateDAO
+ .selectList(new QueryWrapper<ComActActEvaluateDO>().lambda().eq(ComActActEvaluateDO::getActivityId, vo.getId()));
+ if (comActActEvaluateDOList != null && comActActEvaluateDOList.size() > 0) {
+ BigDecimal starNum = BigDecimal.ZERO;
+ //总星级
+ for (ComActActEvaluateDO evaluateDO:comActActEvaluateDOList) {
+ starNum = starNum.add(BigDecimal.valueOf(evaluateDO.getStarLevel()==null?0:evaluateDO.getStarLevel()));
+ }
+ //评分星级(如果无评分默认5分)=总星级/总评价人数
+ if(starNum.compareTo(BigDecimal.ZERO) == 0){
+ vo.setEvaluateLevel(BigDecimal.valueOf(5));
+ }else{
+ vo.setEvaluateLevel(starNum.divide(BigDecimal.valueOf(comActActEvaluateDOList.size()),2, RoundingMode.HALF_UP));
+ }
+ }else{
+ vo.setEvaluateLevel(BigDecimal.valueOf(5));
+ }
+ });
return R.ok(iPage);
}
/**
* 首页图表数据汇总
*
- * @param communityId 社区id
+ * @param communityId
+ * 社区id
* @return 图表数据 IndexDataVO
*/
@Override
public R indexDataCommunityBackstageEchart(Long communityId) {
- IndexDataVO indexDataVO=new IndexDataVO();
- CommunityGovernanceTrendsVO communityGovernanceTrendsVO=new CommunityGovernanceTrendsVO();
- List<CommunityActivitiesVO> communityActivitiesVOS=new ArrayList<>();
- List<Date>dates=this.getServenDays();
- String s=comActActivityDAO.selectCommunityGovernanceTrendsVO(communityId);
- List<String>y= Arrays.asList(s.split(","));
+ IndexDataVO indexDataVO = new IndexDataVO();
+ CommunityGovernanceTrendsVO communityGovernanceTrendsVO = new CommunityGovernanceTrendsVO();
+ List<CommunityActivitiesVO> communityActivitiesVOS = new ArrayList<>();
+ List<Date> dates = this.getServenDays();
+ String s = comActActivityDAO.selectCommunityGovernanceTrendsVO(communityId);
+ List<String> y = Arrays.asList(s.split(","));
communityGovernanceTrendsVO.setY(y);
- communityGovernanceTrendsVO.setX(Arrays.asList(new String[]{"一起议","微心愿","随手拍","社区活动"}));
+ communityGovernanceTrendsVO.setX(Arrays.asList("一起议", "微心愿", "随手拍", "社区活动"));
dates.forEach(date -> {
- CommunityActivitiesVO communityActivitiesVO=comActActivityDAO.selectCommunityActivitiesVO(communityId,date);
+ CommunityActivitiesVO communityActivitiesVO =
+ comActActivityDAO.selectCommunityActivitiesVO(communityId, date);
communityActivitiesVO.setDate(date);
communityActivitiesVOS.add(communityActivitiesVO);
});
@@ -435,13 +686,14 @@
}
@Override
- public R getScreenActActivityList(ScreenActActivityListDTO actActivityListDTO){
+ public R getScreenActActivityList(ScreenActActivityListDTO actActivityListDTO) {
IPage<ActActivityListVO> actActivityListVOIPage = comActActivityDAO.getScreenActActivityList(
- new Page(actActivityListDTO.getPageNum(),actActivityListDTO.getPageSize()),actActivityListDTO);
- if(!actActivityListVOIPage.getRecords().isEmpty()){
+ new Page(actActivityListDTO.getPageNum(), actActivityListDTO.getPageSize()), actActivityListDTO);
+ if (!actActivityListVOIPage.getRecords().isEmpty()) {
actActivityListVOIPage.getRecords().forEach(actActivityListVO -> {
- ActActivityListVO activityListVO = comActActivityDAO.getScreenActActivityPeopleCount(actActivityListVO.getId());
- if(activityListVO != null){
+ ActActivityListVO activityListVO =
+ comActActivityDAO.getScreenActActivityPeopleCount(actActivityListVO.getId());
+ if (activityListVO != null) {
actActivityListVO.setParticipantCount(activityListVO.getParticipantCount());
actActivityListVO.setVolunteerCount(activityListVO.getVolunteerCount());
}
@@ -451,32 +703,144 @@
}
@Override
- public R getActActivityPeopleList(ScreenActActivityPeopleListDTO activityPeopleListDTO){
- return R.ok(comActActSignDAO.getActActivityPeopleList(new Page(activityPeopleListDTO.getPageNum(),activityPeopleListDTO.getPageSize()),activityPeopleListDTO));
+ public R getActActivityPeopleList(ScreenActActivityPeopleListDTO activityPeopleListDTO) {
+ return R.ok(comActActSignDAO.getActActivityPeopleList(
+ new Page(activityPeopleListDTO.getPageNum(), activityPeopleListDTO.getPageSize()), activityPeopleListDTO));
}
/**
* 获取最近七天的时间
+ *
* @return
*/
private List<Date> getServenDays() {
- List<Date> dates=new ArrayList<>();
- Date date=new Date();
- for(int i=6;i>=0;i--){
- Date date1= DateUtils.addDays(date,-i);
+ List<Date> dates = new ArrayList<>();
+ Date date = new Date();
+ for (int i = 6; i >= 0; i--) {
+ Date date1 = DateUtils.addDays(date, -i);
dates.add(date1);
}
return dates;
}
- public static void main(String[] args) {
- List<Date> dates=new ArrayList<>();
- Date date=new Date();
- for(int i=6;i>=0;i--){
- Date date1= DateUtils.addDays(date,-i);
- dates.add(date1);
+ /**
+ * 定时任务检测即将开始的社区活动，并使用订阅消息通知用户
+ */
+ @Override
+ public R timedTaskActivityNotice() {
+ // 查询所有即将开始的活动
+ List<ComActActivityDO> actActivityList = comActActivityDAO.selectList(new QueryWrapper<ComActActivityDO>()
+ .lambda().le(ComActActivityDO::getBeginAt, DateUtils.addDays(new Date(), 1))
+ .ge(ComActActivityDO::getBeginAt, new Date()).notIn(ComActActivityDO::getStatus,5,6));
+ if (!actActivityList.isEmpty()) {
+ WxXCXTempSend util = new WxXCXTempSend();
+ try {
+ String accessToken = util.getAppAccessToken();
+ actActivityList.forEach(actActivity -> {
+ // 查询报名活动人员列表
+ List<ComActActSignDO> actSignList = comActActSignDAO.selectList(new QueryWrapper<ComActActSignDO>()
+ .lambda().eq(ComActActSignDO::getActivityId, actActivity.getId()));
+ actSignList.forEach(actSign -> {
+ // 查询用户openId
+ Map<String, String> map = comActActSignDAO.getUserOpenId(actSign.getUserId());
+ if (map != null) {
+ String openid = map.get("openid");
+ // 推送消息
+ WxUtil.sendSubscribeHDJJKS(openid, accessToken, actActivity.getActivityName(),
+ com.panzhihua.common.utlis.DateUtils.format(actActivity.getBeginAt(),
+ com.panzhihua.common.utlis.DateUtils.ymdhms_format),
+ actActivity.getActivityAddr(), actSignList.size() + "");
+ }
+
+ });
+
+ });
+ } catch (Exception e) {
+ log.error("推送失败，错误原因：" + e.getMessage());
+ }
}
- System.out.println(dates);
+ return R.ok();
}
+ private String getPersent(int x, int y){
+ if (y == 0) {
+ return "";
+ }
+ if (x == 0) {
+ return "0.00%";
+ }
+ double d1 = x * 1.0;
+ double d2 = y * 1.0;
+ DecimalFormat decimalFormat = new DecimalFormat("##.00%");
+ return decimalFormat.format(d1 / d2);
+ }
+
+ /**
+ * 用户签到
+ *
+ * @param comActActRegistVO 签到参数
+ * @return 签到结果
+ */
+ @Override
+ public R activitySignIn(ComActActRegistVO comActActRegistVO) {
+ Long activityId = comActActRegistVO.getActivityId();
+ Long userId = comActActRegistVO.getUserId();
+ if (isNull(activityId)) {
+ return R.fail("签到所属活动id不能为空！");
+ }
+ ComActActivityDO comActActivityDO = comActActivityDAO.selectById(activityId);
+ if (isNull(comActActivityDO)) {
+ return R.fail("活动不存在！");
+ }
+
+ Date beginAt = comActActivityDO.getBeginAt();
+ Date endAt = comActActivityDO.getEndAt();
+ Date nowDate = new Date();
+ if (nowDate.before(beginAt) || nowDate.after(endAt)) {
+ return R.fail("不在活动时间范围内");
+ }
+
+ int signCount = comActActRegistDAO.selectCount(new QueryWrapper<ComActActRegistDO>()
+ .lambda().eq(ComActActRegistDO::getActivityId, activityId).eq(ComActActRegistDO::getUserId, userId));
+
+ if (signCount > 0) {
+ return R.fail("请勿重复签到");
+ }
+
+// String activitySignInKey = String.join(DELIMITER, ACTIVITY_SIGN_IN, userId.toString(), activityId.toString());
+// if (stringRedisTemplate.hasKey(activitySignInKey)) {
+// return R.fail("你已签到，如要再次签到请三十分钟后尝试！");
+// }
+ ComActActRegistDO comActActRegistDO = new ComActActRegistDO();
+ comActActRegistDO.setActivityId(activityId);
+ comActActRegistDO.setUserId(userId);
+ comActActRegistDO.setIsVolunteer(comActActRegistVO.getIsVolunteer());
+ comActActRegistDO.setCreateAt(nowDate);
+ int result = comActActRegistDAO.insert(comActActRegistDO);
+ if (result > 0) {
+// ValueOperations<String, String> opsForValue = stringRedisTemplate.opsForValue();
+// opsForValue.set(activitySignInKey, "", 1800L, TimeUnit.SECONDS);
+ return R.ok();
+ }
+ return R.fail("网络错误，请重试");
+ }
+
+ /**
+ *用户签到记录列表
+ *
+ * @param userId 用id
+ * @return 用户签到列表
+ */
+ @Override
+ public R listSignInActivity(Long userId) {
+ List<ComActActRegistDO> comActActRegistDOS = comActActRegistDAO.selectList(new QueryWrapper<ComActActRegistDO>()
+ .lambda().eq(ComActActRegistDO::getUserId, userId));
+ ArrayList<ComActActRegistVO> comActActRegistVOS = new ArrayList<>();
+ comActActRegistDOS.forEach(comActActRegistDO -> {
+ ComActActRegistVO comActActRegistVO = new ComActActRegistVO();
+ BeanUtils.copyProperties(comActActRegistDO, comActActRegistVO);
+ comActActRegistVOS.add(comActActRegistVO);
+ });
+ return R.ok(comActActRegistVOS);
+ }
}
--
Gitblit v1.7.1