From 06620a6b0e64126e216edab8fced4597b38936b3 Mon Sep 17 00:00:00 2001
From: manailin <261030956@qq.com>
Date: 星期一, 21 六月 2021 13:55:11 +0800
Subject: [PATCH] [修改]合并test_excel分支到test分支。解决部分冲突。

---
 springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java |   61 +++++++++++++++++++++++++-----
 1 files changed, 51 insertions(+), 10 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
index de5baad..1a6c2f9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
@@ -2,6 +2,7 @@
 
 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;
@@ -13,6 +14,7 @@
 import com.panzhihua.common.model.vos.community.ComActVO;
 import com.panzhihua.common.model.vos.grid.*;
 import com.panzhihua.common.service.community.CommunityService;
+import com.panzhihua.common.utlis.ExcelSelectListUtil;
 import com.panzhihua.common.utlis.LngLatUtils;
 import com.panzhihua.common.utlis.StringUtils;
 import com.panzhihua.service_grid.dao.*;
@@ -25,12 +27,11 @@
 import org.springframework.stereotype.Service;
 import org.springframework.beans.BeanUtils;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.CollectionUtils;
 
 import javax.annotation.Resource;
 import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
 
 /**
  * @author cedoo
@@ -55,7 +56,8 @@
     private EventGridMemberRelationMapper eventGridMemberRelationMapper;
     @Resource
     private EventGridDataService eventGridDataService;
-
+    @Resource
+    private EventResourceMapper eventResourceMapper;
     /**
      * 分页查找事件
      *
@@ -234,10 +236,17 @@
             }
             eventDetailsVO.setTrans(eventTransferRecordVOS);
 
-            //查询事件发布人头像
-            String imageUrl = eventMapper.getGridMemberImageUrl(eventDO.getGridMemberId());
-            if (StringUtils.isNotEmpty(imageUrl)) {
-                eventDetailsVO.setGridMemberImageUrl(imageUrl);
+            //查询网格员头像,姓名
+            Map<String,Object> gridMember = eventMapper.getUserBaseInfo(eventDO.getGridMemberId());
+            if (!CollectionUtils.isEmpty(gridMember)) {
+                eventDetailsVO.setGridMemberName(gridMember.get("name") == null ? "" : gridMember.get("name").toString());
+                eventDetailsVO.setGridMemberImageUrl(gridMember.get("image_url") == null ? "" : gridMember.get("image_url").toString());
+            }
+            if(Objects.equals(eventDO.getGridMemberId(),eventDO.getCreateBy())){
+                eventDetailsVO.setCreator(eventDetailsVO.getGridMemberName());
+            }else{
+                Map<String,Object> createUser = eventMapper.getUserBaseInfo(eventDO.getCreateBy());
+                eventDetailsVO.setCreator(createUser.get("name") == null ? "" : createUser.get("name").toString());
             }
 
             return R.ok(eventDetailsVO);
@@ -280,6 +289,7 @@
                 eventResourceDO.setRefId(eventDO.getId());
                 eventResourceDO.setCreateBy(commonEventAddDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventAddDTO.getAudioTime());
+                eventResourceDO.setResourceName(commonEventAddDTO.getAudio().substring(commonEventAddDTO.getAudio().lastIndexOf("/")+1));
                 int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
                 if (audioAdd != 1) {
                     throw new ServiceException("添加音频失败");
@@ -294,6 +304,7 @@
                 eventResourceDO.setRefId(eventDO.getId());
                 eventResourceDO.setCreateBy(commonEventAddDTO.getUserId());
                 eventResourceDO.setResourceTime(commonEventAddDTO.getVideoTime());
+                eventResourceDO.setResourceName(commonEventAddDTO.getVideo().substring(commonEventAddDTO.getVideo().lastIndexOf("/")+1));
                 int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
                 if (videoAdd != 1) {
                     throw new ServiceException("添加视频失败");
@@ -309,6 +320,7 @@
                     eventResourceDO.setUrl(pica[i]);
                     eventResourceDO.setRefId(eventDO.getId());
                     eventResourceDO.setCreateBy(commonEventAddDTO.getUserId());
+                    eventResourceDO.setResourceName(pica[i].substring(pica[i].lastIndexOf("/")+1));
                     int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO);
                     if (picAdd != 1) {
                         throw new ServiceException("添加图片失败");
@@ -516,7 +528,7 @@
         eventDO.setProcessType(1);//网格员处理
         eventDO.setCommunityProcess(0);//非 社区处理
         eventDO.setRevokeType(eventRevokeDTO.getRevokeType());
-        eventDO.setRevokeID(eventRevokeDTO.getRevokeId());
+        eventDO.setRevokeId(eventRevokeDTO.getRevokeId());
         int updated = this.getBaseMapper().updateById(eventDO);
         if (updated == 1) {
             addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(),
@@ -1283,7 +1295,7 @@
         eventDO.setEventStatus(4);//4、撤销
         eventDO.setProcessType(1);//网格员处理
         eventDO.setCommunityProcess(0);//非 社区处理
-        eventDO.setRevokeID(eventRevokeDTO.getRevokeId());
+        eventDO.setRevokeId(eventRevokeDTO.getRevokeId());
         eventDO.setRevokeType(eventRevokeDTO.getRevokeType());
         int updated = this.getBaseMapper().updateById(eventDO);
         if (updated == 1) {
@@ -2047,4 +2059,33 @@
 
         return R.fail();
     }
+
+    @Override
+    public List<EventDetailsVO> getUnUploadEvent() {
+        List<EventDetailsVO> eventDetailsVOList =new ArrayList<>();
+        List<EventDO> unEventList = baseMapper.selectList(
+                new QueryWrapper<EventDO>()
+                        .eq("upload", false)
+        );
+        unEventList.forEach(eventDO -> {
+            eventDetailsVOList.add(eventDetails(eventDO.getId()).getData());
+        });
+        return eventDetailsVOList;
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public Boolean updateLcUploadFlag(Long id) {
+        EventDO event = baseMapper.selectById(id);
+        event.setUpload(true);
+        baseMapper.updateById(event);
+        EventResourceDO eventResourceDO =new EventResourceDO();
+        eventResourceDO.setUpload(true);
+        int flag = eventResourceMapper.update(eventResourceDO, new QueryWrapper<EventResourceDO>()
+                .eq("ref_id", id));
+        if(flag>0){
+            return true;
+        }
+        return false;
+    }
 }

--
Gitblit v1.7.1