From 54ad966d0b142c97fc659263b51d1ea5d7b5c7c6 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期五, 28 五月 2021 16:17:08 +0800
Subject: [PATCH] 修改bug

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java |  256 +++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 245 insertions(+), 11 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 ed13908..00412a6 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,26 +1,36 @@
 package com.panzhihua.service_community.service.impl;
 
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
 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.vos.IndexDataVO;
+import com.panzhihua.common.model.vos.LoginUserInfoVO;
 import com.panzhihua.common.model.vos.R;
-import com.panzhihua.common.model.vos.community.ActivitySignVO;
-import com.panzhihua.common.model.vos.community.ComActActivityVO;
-import com.panzhihua.common.model.vos.community.ComActEasyPhotoVO;
-import com.panzhihua.common.model.vos.community.SignactivityVO;
+import com.panzhihua.common.model.vos.community.*;
+import com.panzhihua.common.service.user.UserService;
 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.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;
 
 /**
  * @program: springcloud_k8s_panzhihuazhihuishequ
@@ -28,12 +38,16 @@
  * @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 新增信息
@@ -44,9 +58,21 @@
         ComActActivityDO comActActivityDO=new ComActActivityDO();
         BeanUtils.copyProperties(comActActivityVO,comActActivityDO);
         Integer status = comActActivityVO.getStatus();
+        Date now = new Date();
         if (status.intValue()!=1) {
-            comActActivityDO.setPublishAt(new Date());//发布时间
+            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();
@@ -66,6 +92,12 @@
     public R putActivity(ComActActivityVO comActActivityVO) {
         ComActActivityDO comActActivityDO=new ComActActivityDO();
         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();
@@ -84,15 +116,24 @@
         Page page = new Page<>();
         Long pageNum = comActActivityVO.getPageNum();
         Long pageSize = comActActivityVO.getPageSize();
-        if (ObjectUtils.isEmpty(pageNum)||0==pageNum) {
+        if (null==pageNum||0==pageNum) {
             pageNum = 1l;
         }
-        if (ObjectUtils.isEmpty(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);
+                }
+            });
+        }
         return R.ok(iPage);
     }
 
@@ -126,7 +167,7 @@
         ComActActivityDO comActActivityDO=new ComActActivityDO();
         comActActivityDO.setId(comActActivityVO.getId());
         comActActivityDO.setStatus(comActActivityVO.getStatus());
-        comActActivityDO.setCancelReason(comActActivityVO.getCancelRenson());
+        comActActivityDO.setCancelReason(comActActivityVO.getCancelReason());
         int update = comActActivityDAO.updateById(comActActivityDO);
         if (update>0) {
             return R.ok();
@@ -148,6 +189,7 @@
             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 {
 
             }
@@ -178,10 +220,10 @@
         Page page = new Page<>();
         Long pageNum = comActActivityVO.getPageNum();
         Long pageSize = comActActivityVO.getPageSize();
-        if (ObjectUtils.isEmpty(pageNum)||0==pageNum) {
+        if (null==pageNum||0==pageNum) {
             pageNum = 1l;
         }
-        if (ObjectUtils.isEmpty(pageSize)||0==pageSize) {
+        if (null==pageSize||0==pageSize) {
             pageSize = 10l;
         }
         page.setSize(pageSize);
@@ -202,13 +244,28 @@
         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("只有志愿者才能报名");
+            }
+
             ComActActSignDO comActActSignDO=new ComActActSignDO();
             comActActSignDO.setActivityId(activityId);
             comActActSignDO.setUserId(userId);
             comActActSignDO.setIsVolunteer(isVolunteer);
-            num = comActActSignDAO.insert(comActActSignDO);
+            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));
         }
@@ -218,5 +275,182 @@
         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);
+//        修改进行状态 变为进行中或者已结束
+        int num2=comActActivityDAO.updateStatusToBeginActiveOrEnd();
+        log.info("定时任务--修改社区活动进行状态活动数量【{}】",num2);
+        int num3=comActActivityDAO.updateStatusToBeginAfterSingEnd();
+        log.info("定时任务--报名结束修改社区活动进行状态活动数量【{}】",num3);
+        return R.ok();
+    }
+
+    /**
+     * 社区后台分页查询社区活动
+     *
+     * @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);
+    }
+
+    /**
+     * 获取最近七天的时间
+     * @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;
+    }
+
+    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);
+        }
+        System.out.println(dates);
+    }
 
 }

--
Gitblit v1.7.1