From 239df6b32472882b4bd74fe97d9cc589c4f39baf Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期日, 15 八月 2021 12:25:47 +0800
Subject: [PATCH] Merge branch 'test' into 'master'
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java | 566 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 566 insertions(+), 0 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
new file mode 100644
index 0000000..53d8f20
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java
@@ -0,0 +1,566 @@
+package com.panzhihua.service_community.service.impl;
+
+import com.alibaba.fastjson.JSONArray;
+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.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.ComActActSignDAO;
+import com.panzhihua.service_community.dao.ComActActivityDAO;
+import com.panzhihua.service_community.dao.ComActDiscussOptionUserDAO;
+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.checkerframework.checker.units.qual.A;
+import org.springframework.beans.BeanUtils;
+import org.springframework.stereotype.Service;
+import org.springframework.util.ObjectUtils;
+
+import javax.annotation.Resource;
+import java.util.*;
+import java.util.stream.Collectors;
+import java.util.stream.Stream;
+
+/**
+ * @program: springcloud_k8s_panzhihuazhihuishequ
+ * @description: 社区活动
+ * @author: huang.hongfa weixin hhf9596 qq 959656820
+ * @create: 2020-12-07 14:35
+ **/
+@Slf4j
+@Service
+public class ComActActivityServiceImpl extends ServiceImpl<ComActActivityDAO, ComActActivityDO> implements ComActActivityService {
+ @Resource
+ private ComActActivityDAO comActActivityDAO;
+ @Resource
+ private ComActActSignDAO comActActSignDAO;
+ @Resource
+ private UserService userService;
+
+ /**
+ * 新增社区活动
+ * @param comActActivityVO 新增信息
+ * @return 新增结果
+ */
+ @Override
+ public R addActivity(ComActActivityVO comActActivityVO) {
+ ComActActivityDO comActActivityDO=new ComActActivityDO();
+ BeanUtils.copyProperties(comActActivityVO,comActActivityDO);
+ Integer status = comActActivityVO.getStatus();
+ Date now = new Date();
+ if (status.intValue()!=1) {
+ comActActivityDO.setPublishAt(now);//发布时间
+ }
+ //如果发布时间大于现在时间状态改为进行中
+ /*if(now.getTime()<comActActivityVO.getBeginAt().getTime()){
+ comActActivityDO.setStatus(3);
+ }*/
+ if(status.intValue()==2) {//点击‘保存并发布’ 按钮
+ //报名结束时间大于当前时间则设置为“进行中”
+ if (comActActivityVO.getSignUpEnd() != null && now.getTime() < comActActivityVO.getSignUpEnd().getTime()) {
+ comActActivityDO.setStatus(4);
+ }
+ }
+
+ boolean save = this.save(comActActivityDO);
+ if(!save){
+ return R.fail();
+ }
+ ComActActivityDO one = this.getOne(new QueryWrapper<ComActActivityDO>().lambda().eq(ComActActivityDO::getActivityName, comActActivityDO.getActivityName()).orderByDesc(ComActActivityDO::getCreateAt).last(" limit 1 "));
+ Long activityId = one.getId();
+ return R.ok(activityId);
+ }
+
+ /**
+ * 编辑社区活动
+ *
+ * @param comActActivityVO 编辑内容
+ * @return 编辑结果
+ */
+ @Override
+ public R putActivity(ComActActivityVO comActActivityVO) {
+ 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);
+ }
+ boolean b = this.updateById(comActActivityDO);
+ if (b) {
+ return R.ok();
+ }
+ return R.fail();
+ }
+
+ /**
+ * 分页查询社区活动
+ *
+ * @param comActActivityVO 查询参数
+ * @return 分页集合
+ */
+ @Override
+ public R pageActivity(ComActActivityVO comActActivityVO) {
+ Page page = new Page<>();
+ Long pageNum = comActActivityVO.getPageNum();
+ Long pageSize = comActActivityVO.getPageSize();
+ if (null==pageNum||0==pageNum) {
+ pageNum = 1l;
+ }
+ 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);
+ }
+ });
+ }
+ return R.ok(iPage);
+ }
+
+ /**
+ * 发布活动
+ *
+ * @param comActActivityVO 主键id 发布时间
+ * @return 发布结果
+ */
+ @Override
+ public R releaseActivity(ComActActivityVO comActActivityVO) {
+ ComActActivityDO comActActivityDO=new ComActActivityDO();
+ comActActivityDO.setId(comActActivityVO.getId());
+ comActActivityDO.setPublishAt(comActActivityVO.getPublishAt());
+ comActActivityDO.setStatus(comActActivityVO.getStatus());
+ int update = comActActivityDAO.updateById(comActActivityDO);
+ if (update>0) {
+ return R.ok();
+ }
+ return R.fail();
+ }
+
+ /**
+ * 取消活动
+ *
+ * @param comActActivityVO 取消原因
+ * @return 取消结果
+ */
+ @Override
+ public R cancelActivity(ComActActivityVO comActActivityVO) {
+ ComActActivityDO comActActivityDO=new ComActActivityDO();
+ comActActivityDO.setId(comActActivityVO.getId());
+ comActActivityDO.setStatus(comActActivityVO.getStatus());
+ comActActivityDO.setCancelReason(comActActivityVO.getCancelReason());
+ int update = comActActivityDAO.updateById(comActActivityDO);
+ if (update>0) {
+ return R.ok();
+ }
+ return R.fail();
+ }
+
+ /**
+ * 活动详情
+ *
+ * @param id 活动id
+ * @param userId
+ * @return 详情
+ */
+ @Override
+ public ComActActivityVO inforActivity(Long id, Long userId) {
+ ComActActivityVO comActActivityVO=comActActivityDAO.inforActivity(id);
+ if (!ObjectUtils.isEmpty(comActActivityVO)) {
+ 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;
+ }
+
+ /**
+ * 活动报名名单
+ *
+ * @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);
+ return R.ok(activitySignVOS);
+ }
+
+ @Override
+ public R listActivitySigns(ActivitySignVO activitySignVO) {
+ List<ActivitySignVO> activitySignVOS = comActActSignDAO.listActivitySigns(activitySignVO);
+ return R.ok(activitySignVOS);
+ }
+
+ /**
+ * 分页展示我的所有活动 时间倒序排列
+ *
+ * @param comActActivityVO 分页参数
+ * @return 分页集合
+ */
+ @Override
+ public R pageMyActivity(ComActActivityVO comActActivityVO) {
+ Page page = new Page<>();
+ Long pageNum = comActActivityVO.getPageNum();
+ Long pageSize = comActActivityVO.getPageSize();
+ if (null==pageNum||0==pageNum) {
+ pageNum = 1l;
+ }
+ if (null==pageSize||0==pageSize) {
+ pageSize = 10l;
+ }
+ page.setSize(pageSize);
+ page.setCurrent(pageNum);
+ IPage<ComActActivityVO> iPage = comActActivityDAO.pageMyActivity(page, comActActivityVO);
+ return R.ok(iPage);
+ }
+
+ /**
+ * 报名/取消报名社区活动
+ *
+ * @param signactivityVO 报名参数
+ * @return 报名 取消报名 结果
+ */
+ @Override
+ public R signActivity(SignactivityVO signactivityVO) {
+ Long activityId = signactivityVO.getActivityId();
+ Integer type = signactivityVO.getType();
+ Long userId = signactivityVO.getUserId();
+ Integer isVolunteer = signactivityVO.getIsVolunteer();
+
+ 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){
+ return R.fail("只有志愿者才能报名");
+ }
+
+ //查询社区活动
+ ComActActivityDO actActivityDO = this.baseMapper.selectById(activityId);
+ if(actActivityDO != null){
+ //查询当前活动下参与志愿者/居民数量
+ 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("志愿者报名人数已满");
+ }
+
+ 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);
+ try {
+ num = comActActSignDAO.insert(comActActSignDO);
+ } catch (Exception e) {
+ if (e.getMessage().contains("unique_activity_id_user_id")) {
+ return R.fail("已经报名过了，请勿重复提交");
+ }
+ log.error(e.getMessage());
+ }
+ } else {
+ num = comActActSignDAO.delete(new QueryWrapper<ComActActSignDO>().lambda().eq(ComActActSignDO::getUserId, userId).eq(ComActActSignDO::getActivityId, activityId).eq(ComActActSignDO::getIsVolunteer, isVolunteer));
+ }
+ if (num>0) {
+ return R.ok();
+ }
+ return R.fail();
+ }
+
+ /**
+ * 用户参加的所有社区活动
+ *
+ * @param userId 用户id
+ * @return 活动列表
+ */
+ @Override
+ public R listActivity(Long 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<ComActActivityDO> comActActivityDOS = comActActivityDAO.selectBatchIds(longs);
+ 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());
+ ComActActSignDO comActActSignDO = collect.get(0);
+ Integer isVolunteer = comActActSignDO.getIsVolunteer();
+ if (isVolunteer.intValue()==1) {
+ comActActivityVO.setType(1);
+ }else{
+ comActActivityVO.setType(2);
+ }
+ Integer status = comActActivityVO.getStatus();
+ if (status.intValue()==3) {
+ comActActivityVO.setStatus(4);
+ }
+ comActActivityVO.setSingDate(comActActSignDOS.stream().filter(comActActSignDO1 -> comActActSignDO1.getActivityId().equals(comActActivityVO.getId())).collect(Collectors.toList()).get(0).getCreateAt());
+ comActActivityVOS.add(comActActivityVO);
+ });
+ return R.ok(comActActivityVOS);
+ }
+
+ /**
+ * 查询志愿者参与的所有已经完成的活动
+ *
+ * @param phone 用户手机号
+ * @return 所有活动集合
+ */
+ @Override
+ public List<ComActActivityVO> listActivityByPhone(String phone) {
+ List<ComActActivityVO> comActActivityVOS=comActActivityDAO.listActivityByPhone(phone);
+ return comActActivityVOS;
+ }
+
+ /**
+ * 定时任务查询所有要取消的社区活动
+ *
+ * @return 社区活动集合
+ */
+ @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);
+ }
+
+ /**
+ * 定时任务刷新社区活动的各个状态 除取消外
+ *
+ * @return 更新结果
+ */
+ @Override
+ public R timedTaskActActivityAll() {
+// 修改发布状态 变为未开始
+ int num=comActActivityDAO.updateStatusToNotBegin();
+ log.info("定时任务--修改社区活动发布状态活动数量【{}】",num);
+// 修改报名状态 变为报名中
+ int num1=comActActivityDAO.updateStatusToBeginSign();
+ log.info("定时任务--修改社区活动报名状态活动数量【{}】",num1);
+ //查询已经结束的活动，需要计算积分
+ List<Long> activityEndIds = comActActivityDAO.getActivityEndIds();
+// 修改进行状态 变为进行中或者已结束
+ int num2=comActActivityDAO.updateStatusToBeginActiveOrEnd();
+ log.info("定时任务--修改社区活动进行状态活动数量【{}】",num2);
+ int num3=comActActivityDAO.updateStatusToBeginAfterSingEnd();
+ log.info("定时任务--报名结束修改社区活动进行状态活动数量【{}】",num3);
+ return R.ok(activityEndIds);
+ }
+
+ /**
+ * 社区后台分页查询社区活动
+ *
+ * @param comActActivityVO 查询参数
+ * @return 返回结果
+ */
+ @Override
+ public R pageActivityCommunityBack(ComActActivityVO comActActivityVO) {
+ Page page = new Page<>();
+ Long pageNum = comActActivityVO.getPageNum();
+ Long pageSize = comActActivityVO.getPageSize();
+ if (null==pageNum||0==pageNum) {
+ pageNum = 1l;
+ }
+ if (null==pageSize||0==pageSize) {
+ pageSize = 10l;
+ }
+ page.setSize(pageSize);
+ page.setCurrent(pageNum);
+ IPage<ComActActivityVO> iPage = comActActivityDAO.pageActivityCommunityBack(page, comActActivityVO);
+ return R.ok(iPage);
+ }
+
+ /**
+ * 首页图表数据汇总
+ *
+ * @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(","));
+ communityGovernanceTrendsVO.setY(y);
+ communityGovernanceTrendsVO.setX(Arrays.asList(new String[]{"一起议","微心愿","随手拍","社区活动"}));
+ dates.forEach(date -> {
+ CommunityActivitiesVO communityActivitiesVO=comActActivityDAO.selectCommunityActivitiesVO(communityId,date);
+ communityActivitiesVO.setDate(date);
+ communityActivitiesVOS.add(communityActivitiesVO);
+ });
+
+ indexDataVO.setCommunityGovernanceTrendsVO(communityGovernanceTrendsVO);
+ indexDataVO.setCommunityActivitiesVOS(communityActivitiesVOS);
+ return R.ok(indexDataVO);
+ }
+
+ @Override
+ public R getScreenActActivityList(ScreenActActivityListDTO actActivityListDTO){
+ IPage<ActActivityListVO> actActivityListVOIPage = comActActivityDAO.getScreenActActivityList(
+ 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.setParticipantCount(activityListVO.getParticipantCount());
+ actActivityListVO.setVolunteerCount(activityListVO.getVolunteerCount());
+ }
+ });
+ }
+ return R.ok(actActivityListVOIPage);
+ }
+
+ @Override
+ 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);
+ dates.add(date1);
+ }
+ return dates;
+ }
+
+
+ /**
+ * 定时任务检测即将开始的社区活动，并使用订阅消息通知用户
+ */
+ @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()));
+ 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());
+ }
+ }
+ return R.ok();
+ }
+
+}
--
Gitblit v1.7.1