From c3811d01d1929a98a0f34f70ca187d82ee312dbb Mon Sep 17 00:00:00 2001 From: manailin <261030956@qq.com> Date: 星期三, 03 十一月 2021 17:26:50 +0800 Subject: [PATCH] Merge branch 'test' of http://gitlab.nhys.cdnhxx.com/root/zhihuishequ into test --- springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java | 1860 +++++++++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 1,476 insertions(+), 384 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 c1edcd6..a1038a9 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 @@ -1,47 +1,58 @@ package com.panzhihua.service_grid.service.impl; +import java.text.SimpleDateFormat; +import java.util.*; + +import javax.annotation.Resource; + +import org.springframework.beans.BeanUtils; +import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; +import org.springframework.util.CollectionUtils; + 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.enums.EventType; import com.panzhihua.common.exceptions.ServiceException; import com.panzhihua.common.model.dtos.community.ComMngPopulationDTO; +import com.panzhihua.common.model.dtos.community.bigscreen.event.ScreenDrawEventListDTO; +import com.panzhihua.common.model.dtos.community.bigscreen.event.ScreenEventListDTO; import com.panzhihua.common.model.dtos.grid.*; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.ComActVO; -import com.panzhihua.common.model.vos.grid.EventDetailsVO; -import com.panzhihua.common.model.vos.grid.EventResourceVO; -import com.panzhihua.common.model.vos.grid.EventTransferRecordVO; -import com.panzhihua.common.model.vos.grid.EventVO; +import com.panzhihua.common.model.vos.community.screen.civil.CivilVillageStatisticsVO; +import com.panzhihua.common.model.vos.community.screen.event.EventGridIncidentStatisticsVO; +import com.panzhihua.common.model.vos.community.screen.event.EventLeftDownStatisticsVO; +import com.panzhihua.common.model.vos.community.screen.event.EventListVO; +import com.panzhihua.common.model.vos.grid.*; +import com.panzhihua.common.model.vos.screen.*; import com.panzhihua.common.service.community.CommunityService; +import com.panzhihua.common.utlis.DateUtils; +import com.panzhihua.common.utlis.GisPointUtil; +import com.panzhihua.common.utlis.LngLatUtils; import com.panzhihua.common.utlis.StringUtils; import com.panzhihua.service_grid.dao.*; import com.panzhihua.service_grid.model.dos.*; -import com.panzhihua.service_grid.service.EventResourceService; -import com.panzhihua.service_grid.service.EventService; -import com.panzhihua.service_grid.service.EventTransferRecordService; -import lombok.extern.slf4j.Slf4j; -import org.springframework.stereotype.Service; -import org.springframework.beans.BeanUtils; -import org.springframework.transaction.annotation.Transactional; +import com.panzhihua.service_grid.service.*; -import javax.annotation.Resource; -import java.text.SimpleDateFormat; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; +import cn.hutool.core.date.DateTime; +import cn.hutool.core.date.DateUtil; +import cn.hutool.core.util.IdcardUtil; +import lombok.extern.slf4j.Slf4j; /** - * @author cedoo - * 2021-04-14 15:03:01 - * 订单表服务实现类 + * @author cedoo 2021-04-14 15:03:01 订单表服务实现类 */ @Slf4j @Service public class EventServiceImpl extends ServiceImpl<EventMapper, EventDO> implements EventService { + private final String moth_format_str = "yyyy-MM"; + private final String[] monthStr = new String[] {"一", "二", "三", "四", "五", "六", "七", "八", "九", "十", "十一", "十二"}; @Resource private EventMapper eventMapper; @Resource @@ -52,35 +63,44 @@ private CommunityService communityService; @Resource private EventGridDataMapper eventGridDataMapper; + @Resource + private EventGridMemberRelationMapper eventGridMemberRelationMapper; + @Resource + private EventSpecialCrowdRecordService eventSpecialCrowdRecordService; + @Resource + private EventSpecialCrowdRecordMapper eventSpecialCrowdRecordMapper; + @Resource + private EventGridDataService eventGridDataService; + @Resource + private EventResourceMapper eventResourceMapper; /** * 分页查找事件 + * * @param pageEventDTO * @return 维护结果 */ @Override - public R<IPage<EventVO>> query(PageEventDTO pageEventDTO){ - Page page = new Page(1,10); - if(pageEventDTO.getPageNum()!=null) { + public R<IPage<EventVO>> query(PageEventDTO pageEventDTO) { + Page page = new Page(1, 10); + if (pageEventDTO.getPageNum() != null) { page.setCurrent(pageEventDTO.getPageNum()); } - if(pageEventDTO.getPageSize()!=null) { + if (pageEventDTO.getPageSize() != null) { page.setSize(pageEventDTO.getPageSize()); } IPage<EventVO> ipage = eventMapper.findByPage(page, pageEventDTO); - if(ipage!=null){ + if (ipage != null) { List<EventVO> eventVOList = ipage.getRecords(); eventVOList.forEach(eventVO -> { List<EventResourceDO> eventResourceDOList = - eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification, 1) - .eq(EventResourceDO::getRefId, eventVO.getId()) - ); + eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId())); List<EventResourceVO> picList = new ArrayList<>(); List<EventResourceVO> audioList = new ArrayList<>(); List<EventResourceVO> videoList = new ArrayList<>(); eventResourceDOList.forEach(eventResourceDO -> { - switch (eventResourceDO.getType()){ + switch (eventResourceDO.getType()) { case 1: EventResourceVO picEventResourceVO = new EventResourceVO(); BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); @@ -102,10 +122,11 @@ eventVO.setPics(picList); eventVO.setVideos(videoList); - //查询网格员头像 - String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); - if(StringUtils.isNotEmpty(imageUrl)){ - eventVO.setGridMemberImageUrl(imageUrl); + // 查询网格员头像 + Map<String, String> userMap = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); + if (StringUtils.isNotEmpty(userMap)) { + eventVO.setGridMemberName(userMap.get("nick_name")); + eventVO.setGridMemberImageUrl(userMap.get("image_url")); } }); return R.ok(ipage); @@ -115,52 +136,55 @@ /** * 删除事件 + * * @param commonEventDeleteDTO * @return 平台用户信息 */ @Override - public R delete(CommonEventDeleteDTO commonEventDeleteDTO){ + public R delete(CommonEventDeleteDTO commonEventDeleteDTO) { EventDO eventDO = eventMapper.selectById(commonEventDeleteDTO.getId()); - if(eventDO==null){ + if (eventDO == null) { return R.fail("事件不存在"); } - if(eventDO.getEventStatus()!=null && - (eventDO.getEventStatus().intValue()==1||eventDO.getEventStatus().intValue()==4)){//草稿 或者 已撤销 的事件可以删除 - eventDO.setEventStatus(3);//逻辑删除 + if (eventDO.getEventStatus() != null + && (eventDO.getEventStatus().intValue() == 1 || eventDO.getEventStatus().intValue() == 4)) {// 草稿 或者 已撤销 + // 的事件可以删除 + eventDO.setEventStatus(3);// 逻辑删除 eventDO.setUpdateBy(commonEventDeleteDTO.getUserId()); int updated = this.getBaseMapper().updateById(eventDO); - return updated==1?R.ok():R.fail(); + return updated == 1 ? R.ok() : R.fail(); } return R.fail("事件不是草稿/已撤销/无效状态, 不允许删除"); } /** * 查询事件详细信息 - * @param id 事件 id + * + * @param id + * 事件 id * @return 查找结果 */ @Override - public R<EventDetailsVO> eventDetails(Long id){ + public R<EventDetailsVO> eventDetails(Long id) { EventDO eventDO = eventMapper.selectById(id); - if(eventDO!=null) { + if (eventDO != null) { EventDetailsVO eventDetailsVO = new EventDetailsVO(); BeanUtils.copyProperties(eventDO, eventDetailsVO); EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(eventDO.getGridId()); - if(eventGridDataDO!=null) { + if (eventGridDataDO != null) { eventDetailsVO.setGridName(eventGridDataDO.getGridName()); + eventDetailsVO.setCommunityId(eventGridDataDO.getGridCommunityId()); } - //查询事件关联附件 + // 查询事件关联附件 List<EventResourceDO> eventResourceDOList = - eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification, 1) - .eq(EventResourceDO::getRefId, id) - ); + eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, id)); List<EventResourceVO> picList = new ArrayList<>(); List<EventResourceVO> audioList = new ArrayList<>(); List<EventResourceVO> videoList = new ArrayList<>(); eventResourceDOList.forEach(eventResourceDO -> { - switch (eventResourceDO.getType()){ + switch (eventResourceDO.getType()) { case 1: EventResourceVO picEventResourceVO = new EventResourceVO(); BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); @@ -182,29 +206,23 @@ eventDetailsVO.setPics(picList); eventDetailsVO.setVideos(videoList); - - - //查询事件流转记录 - List<EventTransferRecordDO> eventTransferRecordDOList = eventTransferRecordService.getBaseMapper() - .selectList(new LambdaQueryWrapper<EventTransferRecordDO>() - .eq(EventTransferRecordDO::getEventId, id) - .orderByAsc(EventTransferRecordDO::getCreateAt) - ); + // 查询事件流转记录 + List<EventTransferRecordDO> eventTransferRecordDOList = + eventTransferRecordService.getBaseMapper().selectList(new LambdaQueryWrapper<EventTransferRecordDO>() + .eq(EventTransferRecordDO::getEventId, id).orderByAsc(EventTransferRecordDO::getCreateAt)); List<EventTransferRecordVO> eventTransferRecordVOS = new ArrayList<>(); for (EventTransferRecordDO eventTransferRecordDO : eventTransferRecordDOList) { EventTransferRecordVO eventTransferRecordVO = new EventTransferRecordVO(); BeanUtils.copyProperties(eventTransferRecordDO, eventTransferRecordVO); - List<EventResourceDO> eventTransferResourceDOList = - eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification, 3) - .eq(EventResourceDO::getRefId, eventTransferRecordDO.getId()) - ); + List<EventResourceDO> eventTransferResourceDOList = eventResourceService.getBaseMapper() + .selectList(new LambdaQueryWrapper<EventResourceDO>().eq(EventResourceDO::getClassification, 3) + .eq(EventResourceDO::getRefId, eventTransferRecordDO.getId())); List<EventResourceVO> transferPicList = new ArrayList<>(); List<EventResourceVO> transferAudioList = new ArrayList<>(); List<EventResourceVO> transferVideoList = new ArrayList<>(); eventTransferResourceDOList.forEach(eventResourceDO -> { - switch (eventResourceDO.getType()){ + switch (eventResourceDO.getType()) { case 1: EventResourceVO picEventResourceVO = new EventResourceVO(); BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); @@ -229,12 +247,33 @@ } 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("nick_name") == null ? "" : gridMember.get("nick_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("nick_name") == null ? "" : createUser.get("nick_name").toString()); } + // 当事件为特殊人群上报时,需要查询事件与人口关联关系 + if (eventDetailsVO.getEventType() != null && eventDetailsVO.getEventType().equals(6)) { + List<EventSpecialPopulationDetailsVO> specialPopulationList = + eventSpecialCrowdRecordMapper.getSpecialPopulationIds(eventDetailsVO.getId()); + if (!specialPopulationList.isEmpty()) { + specialPopulationList.forEach(special -> { + special.setAge(IdcardUtil.getAgeByIdCard(special.getIdCard())); + }); + } + eventDetailsVO.setPopulationList(specialPopulationList); + } return R.ok(eventDetailsVO); } return R.fail("事件不存在"); @@ -245,29 +284,58 @@ public R addCommon(CommonEventAddDTO commonEventAddDTO) { EventDO eventDO = new EventDO(); BeanUtils.copyProperties(commonEventAddDTO, eventDO); - if(commonEventAddDTO instanceof CommonEventCommunityAddDTO) { + if (commonEventAddDTO instanceof CommonEventCommunityAddDTO) { CommonEventCommunityAddDTO commonEventCommunityAddDTO = (CommonEventCommunityAddDTO)commonEventAddDTO; eventDO.setGridMemberId(commonEventCommunityAddDTO.getGridMemberId()); - }else{ + } else { eventDO.setGridMemberId(commonEventAddDTO.getUserId()); } EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventAddDTO.getGridId()); - if(eventGridDataDO==null){ + if (eventGridDataDO == null) { return R.fail("网格不存在"); } - eventDO.setEventCategory(1l);//办件事件 - eventDO.setEventStatus(2);//事件状态 2发布 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setGridMemberCommunity(eventGridDataDO.getGridCommunityId()); + eventDO.setGridMemberStreet(eventGridDataDO.getGridStreetId()); + + // 检查特殊人群上报时参数 + // if(commonEventAddDTO.getEventType().equals(6)){ + // if(commonEventAddDTO.getPopulationIds() == null || commonEventAddDTO.getPopulationIds().size() <= 0){ + // return R.fail("上报人员为空"); + // } + // } + + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventStatus(2);// 事件状态 2发布 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setEventProcessStatus(1); eventDO.setGridMemberName(commonEventAddDTO.getUserName()); eventDO.setGridMemberTelephone(commonEventAddDTO.getPhone()); eventDO.setCreateBy(commonEventAddDTO.getUserId()); eventDO.setSubmitDate(new Date()); eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); - if(eventMapper.insert(eventDO)==1){ - //添加音频 - if(StringUtils.isNotEmpty(commonEventAddDTO.getAudio())){ + + if (eventMapper.insert(eventDO) == 1) { + // 如果是特殊人群,则新增特殊人群与事件关系 + if (commonEventAddDTO.getEventType().equals(6) + && commonEventAddDTO.getPopulationIds() != null + && commonEventAddDTO.getPopulationIds().size() > 0) { + if (commonEventAddDTO.getPopulationIds() != null && commonEventAddDTO.getPopulationIds().size() > 0) { + List<EventSpecialCrowdRecordDO> crowdRecordList = new ArrayList<>(); + commonEventAddDTO.getPopulationIds().forEach(populationId -> { + EventSpecialCrowdRecordDO specialCrowdRecordDO = new EventSpecialCrowdRecordDO(); + specialCrowdRecordDO.setEventId(eventDO.getId()); + specialCrowdRecordDO.setPopulationId(populationId); + specialCrowdRecordDO.setCreateAt(new Date()); + crowdRecordList.add(specialCrowdRecordDO); + }); + // 添加特殊人群上报事件与人口关系 + eventSpecialCrowdRecordService.saveBatch(crowdRecordList); + } + } + + // 添加音频 + if (StringUtils.isNotEmpty(commonEventAddDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); eventResourceDO.setType(2); @@ -275,13 +343,15 @@ 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){ + if (audioAdd != 1) { throw new ServiceException("添加音频失败"); } } - //添加视频 - if(StringUtils.isNotEmpty(commonEventAddDTO.getVideo())){ + // 添加视频 + if (StringUtils.isNotEmpty(commonEventAddDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); eventResourceDO.setType(3); @@ -289,13 +359,15 @@ 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){ + if (videoAdd != 1) { throw new ServiceException("添加视频失败"); } } - //添加图片 - if(StringUtils.isNotEmpty(commonEventAddDTO.getPics())){ + // 添加图片 + if (StringUtils.isNotEmpty(commonEventAddDTO.getPics())) { String[] pica = commonEventAddDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { EventResourceDO eventResourceDO = new EventResourceDO(); @@ -304,8 +376,9 @@ 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){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -320,24 +393,48 @@ @Transactional(rollbackFor = Exception.class) public R saveDraft(CommonEventEditDTO commonEventEditDTO) { EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventEditDTO.getGridId()); - if(eventGridDataDO==null){ + if (eventGridDataDO == null) { return R.fail("网格不存在"); } - if(commonEventEditDTO.getId()==null) { + + if (commonEventEditDTO.getId() == null) { + // 检查特殊人群上报时参数 +// if (commonEventEditDTO.getEventType().equals(6)) { +// if (commonEventEditDTO.getPopulationIds().isEmpty()) { +// return R.fail("上报人员为空"); +// } +// } + EventDO eventDO = new EventDO(); BeanUtils.copyProperties(commonEventEditDTO, eventDO); eventDO.setGridMemberId(commonEventEditDTO.getUserId()); - eventDO.setEventCategory(1l);//办件事件 - eventDO.setEventStatus(1);//事件状态 1草稿 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventStatus(1);// 事件状态 1草稿 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setCreateBy(commonEventEditDTO.getUserId()); eventDO.setGridMemberId(commonEventEditDTO.getUserId()); eventDO.setGridMemberName(commonEventEditDTO.getUserName()); eventDO.setGridMemberTelephone(commonEventEditDTO.getPhone()); eventDO.setEventDealStatus(5); if (eventMapper.insert(eventDO) > 0) { - //添加音频 + + // 如果是特殊人群,则新增特殊人群与事件关系 + if (commonEventEditDTO.getEventType().equals(6) && commonEventEditDTO.getPopulationIds() != null + && commonEventEditDTO.getPopulationIds().size() > 0) { + List<EventSpecialCrowdRecordDO> crowdRecordList = new ArrayList<>(); + commonEventEditDTO.getPopulationIds().forEach(populationId -> { + EventSpecialCrowdRecordDO specialCrowdRecordDO = new EventSpecialCrowdRecordDO(); + specialCrowdRecordDO.setEventId(eventDO.getId()); + specialCrowdRecordDO.setPopulationId(populationId); + specialCrowdRecordDO.setCreateAt(new Date()); + crowdRecordList.add(specialCrowdRecordDO); + }); + // 添加特殊人群上报事件与人口关系 + eventSpecialCrowdRecordService.saveBatch(crowdRecordList); + } + + // 添加音频 if (StringUtils.isNotEmpty(commonEventEditDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -351,7 +448,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(commonEventEditDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -365,7 +462,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(commonEventEditDTO.getPics())) { String[] pica = commonEventEditDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -384,26 +481,25 @@ return R.ok(); } return R.fail(); - }else{ - //编辑原来的 + } else { + // 编辑原来的 EventDO eventDO = eventMapper.selectById(commonEventEditDTO.getId()); - if(eventDO.getEventStatus()!=null && eventDO.getEventStatus()!=1){ - return R.fail("保存草稿失败,事件不是草稿状态"); + if (eventDO.getEventStatus() != null && eventDO.getEventStatus() != 1 + && eventDO.getEventDealStatus() != 6) { + return R.fail("保存草稿失败,事件不是草稿/已撤销状态"); } BeanUtils.copyProperties(commonEventEditDTO, eventDO); eventDO.setGridMemberId(commonEventEditDTO.getUserId()); - eventDO.setEventCategory(1l);//办件事件 - eventDO.setEventStatus(1);//事件状态 2发布 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventStatus(1);// 事件状态 2发布 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setUpdateBy(commonEventEditDTO.getUserId()); eventDO.setEventDealStatus(5); if (eventMapper.updateById(eventDO) > 0) { - int deleted = eventResourceService.getBaseMapper() - .delete(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification,1) - .eq(EventResourceDO::getRefId, eventDO.getId())); - //添加音频 + int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId())); + // 添加音频 if (StringUtils.isNotEmpty(commonEventEditDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -417,7 +513,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(commonEventEditDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -431,7 +527,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(commonEventEditDTO.getPics())) { String[] pica = commonEventEditDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -457,35 +553,37 @@ @Transactional(rollbackFor = Exception.class) public R report(CommonEventReportDTO commonEventReportDTO) { EventDO eventDO = this.getBaseMapper().selectById(commonEventReportDTO.getEventId()); - if(eventDO==null){ + if (eventDO == null) { return R.fail("事件不存在"); } - if(eventDO.getEventStatus()!=2){ + if (eventDO.getEventStatus() != 2) { return R.fail("当前事件不能上报社区"); } - if(eventDO.getProcessType()==2){ + if (eventDO.getProcessType() == 2) { return R.fail("当前事件已交由社区处理"); } - R r = communityService.detailCommunity(commonEventReportDTO.getToId()); - if(!R.isOk(r)){ + R r = communityService.detailCommunity(commonEventReportDTO.getToId()); + if (!R.isOk(r)) { return R.fail("社区不存在"); } - ComActVO comActVO= JSONObject.parseObject(JSONObject.toJSONString(r.getData()),ComActVO.class); - if(comActVO==null){ + ComActVO comActVO = JSONObject.parseObject(JSONObject.toJSONString(r.getData()), ComActVO.class); + if (comActVO == null) { return R.fail("社区不存在"); } - eventDO.setCommunityProcess(1); //社区处理 - eventDO.setProcessType(2); //当前处理对象: 社区处理 + eventDO.setCommunityProcess(1); // 社区处理 + eventDO.setProcessType(2); // 当前处理对象: 社区处理 eventDO.setCommunityProcess(1); - eventDO.setEventProcessStatus(1); //待处理 + eventDO.setEventProcessStatus(1); // 待处理 eventDO.setUpdateBy(commonEventReportDTO.getUserId()); eventDO.setSubmitDate(new Date()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated!=1){ + if (updated != 1) { throw new ServiceException("更新突发事件状态更新失败"); } - addTransferRecord(eventDO.getId(), commonEventReportDTO.getToId(), comActVO.getName(), 2, commonEventReportDTO.getProcessResult()); + addTransferRecord(eventDO.getId(), commonEventReportDTO.getToId(), comActVO.getName(), 2, + commonEventReportDTO.getProcessResult(), commonEventReportDTO.getUserId(), + commonEventReportDTO.getUserName(), 2); return R.ok(); } @@ -494,25 +592,27 @@ @Transactional(rollbackFor = Exception.class) public R emergenciesRevoke(EventRevokeDTO eventRevokeDTO) { EventDO eventDO = this.getBaseMapper().selectById(eventRevokeDTO.getId()); - if(eventDO==null){ + if (eventDO == null) { return R.fail("事件不存在"); } - boolean canRevoke = eventDO.getEventStatus()==2; //发布状态 - if(!canRevoke){ - return R.fail("当前事件不允许撤销"); + boolean canRevoke = eventDO.getEventStatus() == 2; // 发布状态 + if (!canRevoke) { + return R.fail("当前事件不允许·"); } - if(eventDO.getEventCategory()!=null && eventDO.getEventCategory().intValue()==2){//宣传教育事件 - //不做验证 - }else if(eventDO.getEventProcessStatus()==2 ||eventDO.getEventProcessStatus()==3) { //已解决 或者 待验证 不允许撤销 + Integer eventProcessStatus = eventDO.getEventProcessStatus() != null ? eventDO.getEventProcessStatus() : -1; + if (eventProcessStatus == 2 || eventProcessStatus == 3) { // 已解决 或者 待验证 不允许撤销 return R.fail("当前事件不允许撤销"); } eventDO.setEventStatus(4); eventDO.setUpdateBy(eventRevokeDTO.getUserId()); - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 + eventDO.setRevokeType(eventRevokeDTO.getRevokeType()); + eventDO.setRevokeId(eventRevokeDTO.getRevokeId()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated == 1){ - addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1,"撤销成功"); + if (updated == 1) { + addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1, "撤销成功", + eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 7); return R.ok(); } return R.fail(); @@ -525,35 +625,43 @@ if (eventDO == null) { return R.fail("事件不存在"); } - boolean canDealByUser = eventDO.getEventStatus()==2 && eventDO.getEventProcessStatus()==1; - if(!canDealByUser){ - if(eventDO.getEventStatus()!=2){ - return R.fail("事件不是发布状态"); + boolean canDealByUser = + (eventDO.getEventStatus() == 2 || eventDO.getEventStatus() == 4) && eventDO.getEventProcessStatus() == 1; + if (!canDealByUser) { + if (eventDO.getEventStatus() != 2) { + return R.fail("事件不是发布/待处理状态"); } - if(eventDO.getEventProcessStatus()!=1){ + if (eventDO.getEventProcessStatus() != 1) { return R.fail("事件不是待处理状态"); } return R.fail("事件当前不可自处理"); } - eventDO.setEventProcessStatus(2);//2已解决 + eventDO.setEventProcessStatus(2);// 2已解决 eventDO.setUpdateBy(commonEventDealDTO.getUserId()); - //更新处理信息 + // 更新处理信息 eventDO.setProcessUserId(commonEventDealDTO.getUserId()); eventDO.setProcessUserName(commonEventDealDTO.getUserName()); eventDO.setProcessDate(new Date()); eventDO.setProcessDesc(commonEventDealDTO.getProcessResult()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated!=1){ + if (updated != 1) { return R.fail("更新事件状态失败"); } + Integer processType = -1; + if (eventDO.getInvalid() != null) { + processType = 5; + } else { + processType = 1; + } EventTransferRecordDO transferRecordDO = - addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(),1, "网格员自处理完成"); - if(transferRecordDO!=null && transferRecordDO.getId()!=null){ - //添加音频 - if(StringUtils.isNotEmpty(commonEventDealDTO.getAudio())){ + addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), 1, + "网格员自处理完成", commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), processType); + if (transferRecordDO != null && transferRecordDO.getId() != null) { + // 添加音频 + if (StringUtils.isNotEmpty(commonEventDealDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(3); eventResourceDO.setType(2); @@ -562,12 +670,12 @@ eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); eventResourceDO.setResourceTime(commonEventDealDTO.getAudioTime()); int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(audioAdd!=1){ + if (audioAdd != 1) { throw new ServiceException("添加音频失败"); } } - //添加视频 - if(StringUtils.isNotEmpty(commonEventDealDTO.getVideo())){ + // 添加视频 + if (StringUtils.isNotEmpty(commonEventDealDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(3); eventResourceDO.setType(3); @@ -576,12 +684,12 @@ eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); eventResourceDO.setResourceTime(commonEventDealDTO.getVideoTime()); int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(videoAdd!=1){ + if (videoAdd != 1) { throw new ServiceException("添加视频失败"); } } - //添加图片 - if(StringUtils.isNotEmpty(commonEventDealDTO.getPics())){ + // 添加图片 + if (StringUtils.isNotEmpty(commonEventDealDTO.getPics())) { String[] pica = commonEventDealDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { EventResourceDO eventResourceDO = new EventResourceDO(); @@ -591,7 +699,7 @@ eventResourceDO.setRefId(transferRecordDO.getId()); eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(picAdd!=1){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -601,56 +709,64 @@ EventDO eventDOToUpdate = this.getBaseMapper().selectById(commonEventDealDTO.getId()); eventDOToUpdate.setProcessRecordId(transferRecordId); int transferRecordUpdated = this.getBaseMapper().updateById(eventDOToUpdate); - if(transferRecordUpdated!=1){ + if (transferRecordUpdated != 1) { throw new ServiceException("更新事件处理流程失败"); } return R.ok(); - }else{ + } else { throw new ServiceException("处理事件记录出错"); } } - @Override public R verifyEvent(CommonEventVerifyDTO commonEventVerifyDTO) { EventDO eventDO = this.getBaseMapper().selectById(commonEventVerifyDTO.getId()); - boolean canVerifyByUser = eventDO.getEventProcessStatus()==3; - if(!canVerifyByUser){ + boolean canVerifyByUser = eventDO.getEventProcessStatus() == 3; + if (!canVerifyByUser) { return R.fail("当前不是待验证状态"); } - boolean processTypeRight = eventDO.getProcessType()==1; - if(!processTypeRight){ + boolean processTypeRight = eventDO.getProcessType() == 1; + if (!processTypeRight) { return R.fail("当前处理对象不是网格员"); } - eventDO.setEventProcessStatus(2);//2已解决 + eventDO.setEventProcessStatus(2);// 2已解决 eventDO.setUpdateBy(commonEventVerifyDTO.getUserId()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated!=1){ + if (updated != 1) { return R.fail("更新事件状态失败"); } - addTransferRecord(eventDO.getId(), commonEventVerifyDTO.getUserId(), commonEventVerifyDTO.getUserName(), 1, commonEventVerifyDTO.getProcessResult()); + addTransferRecord(eventDO.getId(), commonEventVerifyDTO.getUserId(), commonEventVerifyDTO.getUserName(), 1, + commonEventVerifyDTO.getProcessResult(), commonEventVerifyDTO.getUserId(), + commonEventVerifyDTO.getUserName(), 6); return R.ok(); } @Override public R republishEvent(CommonEventRepublishDTO commonEventRepublishDTO) { EventDO eventDO = this.getBaseMapper().selectById(commonEventRepublishDTO.getId()); - boolean canRepublishByUser = eventDO.getEventStatus()==4; - if(!canRepublishByUser){ - return R.fail("当前不是撤销状态"); + // boolean canRepublishByUser = eventDO.getEventStatus() == 4 || eventDO.getEventStatus() == 1; + boolean canRepublishByUser = eventDO.getEventDealStatus() == 6 | eventDO.getEventDealStatus() == 5; // 已失效状态 + if (!canRepublishByUser) { + return R.fail("当前不是撤销/草稿状态"); } - eventDO.setEventStatus(2);//2 发布 - eventDO.setEventProcessStatus(1); //待解决 - eventDO.setProcessType(1); //网格员处理 + if (eventDO.getEventCategory().equals(2L)) {// 宣传教育 + eventDO.setEventDealStatus(8); + } else { + eventDO.setEventProcessStatus(1); // 待解决 + eventDO.setProcessType(1); // 网格员处理 + } + eventDO.setEventStatus(2);// 2 发布 eventDO.setUpdateBy(commonEventRepublishDTO.getUserId()); + int updated = this.getBaseMapper().updateById(eventDO); - if(updated!=1){ + if (updated != 1) { return R.fail("更新事件状态失败"); } - addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), 1, "重新发布已撤销事件"); + addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), + 1, "重新发布已撤销事件", commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), 8); return R.ok(); } @@ -658,18 +774,18 @@ @Transactional(rollbackFor = Exception.class) public R draftRelease(CommonEventPublicDTO commonEventPublicDTO) { EventDO eventDO = this.getBaseMapper().selectById(commonEventPublicDTO.getId()); - boolean draftCanRelease = eventDO.getEventStatus()==1; - if(!draftCanRelease){ + boolean draftCanRelease = eventDO.getEventStatus() == 1; + if (!draftCanRelease) { return R.fail("当前不是草稿状态"); } eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); - eventDO.setEventStatus(2);//事件状态 2发布 - eventDO.setProcessType(1);//当前处理对象类型:网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 - eventDO.setEventProcessStatus(1);//待处理 + eventDO.setEventStatus(2);// 事件状态 2发布 + eventDO.setProcessType(1);// 当前处理对象类型:网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 + eventDO.setEventProcessStatus(1);// 待处理 eventDO.setUpdateBy(commonEventPublicDTO.getUserId()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated!=1){ + if (updated != 1) { return R.fail("更新事件状态失败"); } addReleaseRecord(eventDO.getId(), commonEventPublicDTO.getUserId(), commonEventPublicDTO.getUserName()); @@ -678,40 +794,43 @@ /** * 生成服务单号 - * @param eventType 事件类型,宣传事件默认为20 + * + * @param eventType + * 事件类型,宣传事件默认为20 * @return */ private String getEventOrderSn(Integer eventType) { SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd"); - if(eventType==null){ - eventType = 20; + if (eventType == null) { + eventType = 20; } String pre = String.format(simpleDateFormat.format(new Date()) + "%02d", eventType); - Integer todayCount = this.getBaseMapper().selectCount(new LambdaQueryWrapper<EventDO>().likeRight(EventDO::getOrderSn, pre)); - String orderSn = String.format(pre + "%04d", todayCount+1); + Integer todayCount = + this.getBaseMapper().selectCount(new LambdaQueryWrapper<EventDO>().likeRight(EventDO::getOrderSn, pre)); + String orderSn = String.format(pre + "%04d", todayCount + 1); return orderSn; } @Override public R saveSpecialDraft(SpecialEventEditDTO specialEventEditDTO) { EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(specialEventEditDTO.getGridId()); - if(eventGridDataDO==null){ + if (eventGridDataDO == null) { return R.fail("网格不存在"); } R rtVal = R.fail(); - if(specialEventEditDTO.getId()==null) { + if (specialEventEditDTO.getId() == null) { EventDO eventDO = new EventDO(); BeanUtils.copyProperties(specialEventEditDTO, eventDO); eventDO.setGridMemberId(specialEventEditDTO.getUserId()); - eventDO.setEventCategory(1l);//办件事件 - eventDO.setEventType(EventType.SPECIAL);//特殊人群信息上报-事件分类 - eventDO.setEventStatus(1);//事件状态 1草稿 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventType(EventType.SPECIAL);// 特殊人群信息上报-事件分类 + eventDO.setEventStatus(1);// 事件状态 1草稿 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setCreateBy(specialEventEditDTO.getUserId()); - eventDO.setEventDealStatus(5);//草稿状态 + eventDO.setEventDealStatus(5);// 草稿状态 if (eventMapper.insert(eventDO) > 0) { - //添加音频 + // 添加音频 if (StringUtils.isNotEmpty(specialEventEditDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -725,7 +844,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(specialEventEditDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -739,7 +858,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(specialEventEditDTO.getPics())) { String[] pica = specialEventEditDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -758,23 +877,21 @@ rtVal = R.ok(); } rtVal = R.fail(); - }else{ - //编辑原来的 + } else { + // 编辑原来的 EventDO eventDO = eventMapper.selectById(specialEventEditDTO.getId()); BeanUtils.copyProperties(specialEventEditDTO, eventDO); eventDO.setGridMemberId(specialEventEditDTO.getUserId()); - eventDO.setEventCategory(1l);//办件事件 - eventDO.setEventStatus(1);//事件状态 1草稿 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventStatus(1);// 事件状态 1草稿 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setUpdateBy(specialEventEditDTO.getUserId()); - eventDO.setEventDealStatus(5);//草稿状态 + eventDO.setEventDealStatus(5);// 草稿状态 if (eventMapper.updateById(eventDO) > 0) { - int deleted = eventResourceService.getBaseMapper() - .delete(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification,1) - .eq(EventResourceDO::getRefId, eventDO.getId())); - //添加音频 + int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId())); + // 添加音频 if (StringUtils.isNotEmpty(specialEventEditDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -788,7 +905,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(specialEventEditDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -802,7 +919,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(specialEventEditDTO.getPics())) { String[] pica = specialEventEditDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -822,8 +939,8 @@ } rtVal = R.fail(); } - if(R.isOk(rtVal)){ - //TODO 处理特殊人群实有人口数据 + if (R.isOk(rtVal)) { + // TODO 处理特殊人群实有人口数据 } return rtVal; @@ -832,22 +949,22 @@ @Override public R addSpecial(SpecialEventAddDTO specialEventAddDTO) { EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(specialEventAddDTO.getGridId()); - if(eventGridDataDO==null){ + if (eventGridDataDO == null) { return R.fail("网格不存在"); } R rtVal = R.fail(); EventDO eventDO = new EventDO(); BeanUtils.copyProperties(specialEventAddDTO, eventDO); eventDO.setGridMemberId(specialEventAddDTO.getUserId()); - eventDO.setEventCategory(1l);//办件事件 - eventDO.setEventType(EventType.SPECIAL);//特殊人群信息上报-事件分类 - eventDO.setEventStatus(2);//事件状态 2发布 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventType(EventType.SPECIAL);// 特殊人群信息上报-事件分类 + eventDO.setEventStatus(2);// 事件状态 2发布 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setCreateBy(specialEventAddDTO.getUserId()); eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); if (eventMapper.insert(eventDO) > 0) { - //添加音频 + // 添加音频 if (StringUtils.isNotEmpty(specialEventAddDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -861,7 +978,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(specialEventAddDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -875,7 +992,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(specialEventAddDTO.getPics())) { String[] pica = specialEventAddDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -895,8 +1012,8 @@ } rtVal = R.fail(); - if(R.isOk(rtVal)){ - //TODO 处理特殊人群实有人口数据 + if (R.isOk(rtVal)) { + // TODO 处理特殊人群实有人口数据 addReleaseRecord(eventDO.getId(), specialEventAddDTO.getUserId(), specialEventAddDTO.getUserName()); return R.ok(); @@ -916,22 +1033,30 @@ @Override public R addPublicity(PublicityEventAddDTO publicityEventAddDTO) { EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(publicityEventAddDTO.getGridId()); - if(eventGridDataDO==null){ + if (eventGridDataDO == null) { return R.fail("网格不存在"); } EventDO eventDO = new EventDO(); BeanUtils.copyProperties(publicityEventAddDTO, eventDO); + eventDO.setHappenTime(publicityEventAddDTO.getPropagandaTime()); eventDO.setGridMemberId(publicityEventAddDTO.getUserId()); - eventDO.setEventCategory(2l);//宣传事件 - eventDO.setEventStatus(2);//事件状态 2发布 - eventDO.setGridMemberId(publicityEventAddDTO.getUserId()); + eventDO.setEventCategory(2l);// 宣传事件 + eventDO.setEventStatus(2);// 事件状态 2发布 + eventDO.setEventType(8); + eventDO.setGridMemberCommunity(eventGridDataDO.getGridCommunityId()); + eventDO.setGridMemberStreet(eventGridDataDO.getGridStreetId()); + if (publicityEventAddDTO.getGridMemberId() != null) { + eventDO.setGridMemberId(publicityEventAddDTO.getGridMemberId()); + } else { + eventDO.setGridMemberId(publicityEventAddDTO.getUserId()); + } eventDO.setGridMemberName(publicityEventAddDTO.getUserName()); eventDO.setGridMemberTelephone(publicityEventAddDTO.getPhone()); eventDO.setCreateBy(publicityEventAddDTO.getUserId()); eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); - if(eventMapper.insert(eventDO)==1){ - //添加音频 - if(StringUtils.isNotEmpty(publicityEventAddDTO.getAudio())){ + if (eventMapper.insert(eventDO) == 1) { + // 添加音频 + if (StringUtils.isNotEmpty(publicityEventAddDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); eventResourceDO.setType(2); @@ -940,12 +1065,12 @@ eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId()); eventResourceDO.setResourceTime(publicityEventAddDTO.getAudioTime()); int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(audioAdd!=1){ + if (audioAdd != 1) { throw new ServiceException("添加音频失败"); } } - //添加视频 - if(StringUtils.isNotEmpty(publicityEventAddDTO.getVideo())){ + // 添加视频 + if (StringUtils.isNotEmpty(publicityEventAddDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); eventResourceDO.setType(3); @@ -954,12 +1079,12 @@ eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId()); eventResourceDO.setResourceTime(publicityEventAddDTO.getVideoTime()); int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(videoAdd!=1){ + if (videoAdd != 1) { throw new ServiceException("添加视频失败"); } } - //添加图片 - if(StringUtils.isNotEmpty(publicityEventAddDTO.getPics())){ + // 添加图片 + if (StringUtils.isNotEmpty(publicityEventAddDTO.getPics())) { String[] pica = publicityEventAddDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { EventResourceDO eventResourceDO = new EventResourceDO(); @@ -969,7 +1094,7 @@ eventResourceDO.setRefId(eventDO.getId()); eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId()); int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(picAdd!=1){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -984,22 +1109,23 @@ @Override public R savePublicityDraft(PublicityEventEditDTO publicityEventEditDTO) { EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(publicityEventEditDTO.getGridId()); - if(eventGridDataDO==null){ + if (eventGridDataDO == null) { return R.fail("网格不存在"); } - if(publicityEventEditDTO.getId()==null) { + if (publicityEventEditDTO.getId() == null) { EventDO eventDO = new EventDO(); BeanUtils.copyProperties(publicityEventEditDTO, eventDO); eventDO.setGridMemberId(publicityEventEditDTO.getUserId()); - eventDO.setEventCategory(2l);//宣传事件 - eventDO.setEventStatus(1);//事件状态 1草稿 + eventDO.setEventCategory(2l);// 宣传事件 + eventDO.setEventStatus(1);// 事件状态 1草稿 eventDO.setCreateBy(publicityEventEditDTO.getUserId()); eventDO.setGridMemberId(publicityEventEditDTO.getUserId()); eventDO.setGridMemberName(publicityEventEditDTO.getUserName()); eventDO.setGridMemberTelephone(publicityEventEditDTO.getPhone()); - eventDO.setEventDealStatus(5);//草稿状态 + eventDO.setEventDealStatus(5);// 草稿状态 + eventDO.setEventType(8); if (eventMapper.insert(eventDO) > 0) { - //添加音频 + // 添加音频 if (StringUtils.isNotEmpty(publicityEventEditDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -1013,7 +1139,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(publicityEventEditDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -1027,7 +1153,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(publicityEventEditDTO.getPics())) { String[] pica = publicityEventEditDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -1046,26 +1172,25 @@ return R.ok(); } return R.fail(); - }else{ - //编辑原来的 + } else { + // 编辑原来的 EventDO eventDO = eventMapper.selectById(publicityEventEditDTO.getId()); - if(eventDO.getEventStatus()!=null && eventDO.getEventStatus()!=1){ - return R.fail("保存草稿失败,事件不是草稿状态"); + if (eventDO.getEventStatus() != null && eventDO.getEventStatus() != 1 + && eventDO.getEventDealStatus() != 6) { + return R.fail("保存草稿失败,事件不是草稿/撤销状态"); } BeanUtils.copyProperties(publicityEventEditDTO, eventDO); eventDO.setGridMemberId(publicityEventEditDTO.getUserId()); - eventDO.setEventCategory(2L);//宣传事件 - eventDO.setEventStatus(1);//事件状态 1草稿 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventCategory(2L);// 宣传事件 + eventDO.setEventStatus(1);// 事件状态 1草稿 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 eventDO.setUpdateBy(publicityEventEditDTO.getUserId()); - eventDO.setEventDealStatus(5);//草稿状态 + eventDO.setEventDealStatus(5);// 草稿状态 if (eventMapper.updateById(eventDO) > 0) { - int deleted = eventResourceService.getBaseMapper() - .delete(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification,1) - .eq(EventResourceDO::getRefId, eventDO.getId())); - //添加音频 + int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId())); + // 添加音频 if (StringUtils.isNotEmpty(publicityEventEditDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -1079,7 +1204,7 @@ throw new ServiceException("添加音频失败"); } } - //添加视频 + // 添加视频 if (StringUtils.isNotEmpty(publicityEventEditDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); @@ -1093,7 +1218,7 @@ throw new ServiceException("添加视频失败"); } } - //添加图片 + // 添加图片 if (StringUtils.isNotEmpty(publicityEventEditDTO.getPics())) { String[] pica = publicityEventEditDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { @@ -1117,27 +1242,25 @@ @Override public R selectPublicity(PagePublicityEventDTO pagePublicityEventDTO) { - Page page = new Page(1,10); - if(pagePublicityEventDTO.getPageNum()!=null) { + Page page = new Page(1, 10); + if (pagePublicityEventDTO.getPageNum() != null) { page.setCurrent(pagePublicityEventDTO.getPageNum()); } - if(pagePublicityEventDTO.getPageSize()!=null) { + if (pagePublicityEventDTO.getPageSize() != null) { page.setSize(pagePublicityEventDTO.getPageSize()); } IPage<EventVO> ipage = eventMapper.findPublicityByPage(page, pagePublicityEventDTO); - if(ipage!=null){ + if (ipage != null) { List<EventVO> eventVOList = ipage.getRecords(); eventVOList.forEach(eventVO -> { List<EventResourceDO> eventResourceDOList = - eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification, 1) - .eq(EventResourceDO::getRefId, eventVO.getId()) - ); + eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId())); List<EventResourceVO> picList = new ArrayList<>(); List<EventResourceVO> audioList = new ArrayList<>(); List<EventResourceVO> videoList = new ArrayList<>(); eventResourceDOList.forEach(eventResourceDO -> { - switch (eventResourceDO.getType()){ + switch (eventResourceDO.getType()) { case 1: EventResourceVO picEventResourceVO = new EventResourceVO(); BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); @@ -1158,6 +1281,12 @@ eventVO.setAudios(audioList); eventVO.setPics(picList); eventVO.setVideos(videoList); + // 查询网格员头像 + Map<String, String> userMap = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); + if (StringUtils.isNotEmpty(userMap)) { + eventVO.setGridMemberName(userMap.get("nick_name")); + eventVO.setGridMemberImageUrl(userMap.get("image_url")); + } }); return R.ok(ipage); } @@ -1171,28 +1300,26 @@ @Override public R eventToManage(PageEventManageDTO pageEventManageDTO) { - //查询管理事件 - Page page = new Page(1,10); - if(pageEventManageDTO.getPageNum()!=null) { + // 查询管理事件 + Page page = new Page(1, 10); + if (pageEventManageDTO.getPageNum() != null) { page.setCurrent(pageEventManageDTO.getPageNum()); } - if(pageEventManageDTO.getPageSize()!=null) { + if (pageEventManageDTO.getPageSize() != null) { page.setSize(pageEventManageDTO.getPageSize()); } IPage<EventVO> ipage = eventMapper.findToManageByPage(page, pageEventManageDTO); - if(ipage!=null){ + if (ipage != null) { List<EventVO> eventVOList = ipage.getRecords(); eventVOList.forEach(eventVO -> { List<EventResourceDO> eventResourceDOList = - eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification, 1) - .eq(EventResourceDO::getRefId, eventVO.getId()) - ); + eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId())); List<EventResourceVO> picList = new ArrayList<>(); List<EventResourceVO> audioList = new ArrayList<>(); List<EventResourceVO> videoList = new ArrayList<>(); eventResourceDOList.forEach(eventResourceDO -> { - switch (eventResourceDO.getType()){ + switch (eventResourceDO.getType()) { case 1: EventResourceVO picEventResourceVO = new EventResourceVO(); BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); @@ -1214,10 +1341,11 @@ eventVO.setPics(picList); eventVO.setVideos(videoList); - //查询网格员头像 - String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); - if(StringUtils.isNotEmpty(imageUrl)){ - eventVO.setGridMemberImageUrl(imageUrl); + // 查询网格员头像 + Map<String, String> userMap = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); + if (StringUtils.isNotEmpty(userMap)) { + eventVO.setGridMemberName(userMap.get("nick_name")); + eventVO.setGridMemberImageUrl(userMap.get("image_url")); } }); return R.ok(ipage); @@ -1228,34 +1356,39 @@ @Override public R markEventInvalid(EventRevokeDTO eventRevokeDTO) { EventDO eventDO = this.getBaseMapper().selectById(eventRevokeDTO.getId()); - if(eventDO==null){ + if (eventDO == null) { return R.fail("事件不存在"); } - if(eventDO.getEventCategory()!=null) { + if (eventDO.getEventCategory() != null) { if (eventDO.getEventCategory() == 1) { - boolean canRevoke = eventDO.getEventDealStatus() == 3; //上报状态 + boolean canRevoke = eventDO.getEventDealStatus() == 3; // 上报状态 if (!canRevoke) { - return R.fail("当前事件不是上报状态,不允许标为无效"); + return R.fail("当前事件不是上报状态,不允许撤销"); } - }else if (eventDO.getEventCategory() == 2) { - boolean canRevoke = eventDO.getEventDealStatus() == 8; //发布状态 + } else if (eventDO.getEventCategory() == 2) { + boolean canRevoke = eventDO.getEventDealStatus() == 8; // 发布状态 if (!canRevoke) { - return R.fail("当前事件不是发布状态,不允许标为无效"); + return R.fail("当前事件不是发布状态,不允许撤销"); } - }else{ + } else { return R.fail(""); } - }else{ + } else { return R.fail("事件所属错误"); } - eventDO.setInvalid(false); +// eventDO.setInvalid(false); + // 标为无效后, 交给网格员处理 eventDO.setUpdateBy(eventRevokeDTO.getUserId()); - eventDO.setEventStatus(4);//4、撤销 - eventDO.setProcessType(1);//网格员处理 - eventDO.setCommunityProcess(0);//非 社区处理 + eventDO.setEventStatus(4);// 4、撤销 + eventDO.setEventDealStatus(6);// 4、撤销 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 + eventDO.setRevokeId(eventRevokeDTO.getRevokeId()); + eventDO.setRevokeType(eventRevokeDTO.getRevokeType()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated == 1){ - addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1,"撤销成功"); + if (updated == 1) { + addTransferRecord(eventDO.getId(), eventRevokeDTO.getUserId(), eventRevokeDTO.getUserName(), 1, "标为无效", + eventRevokeDTO.getCommunityId(), eventRevokeDTO.getCommunityName(), 4); return R.ok(); } return R.fail(); @@ -1264,17 +1397,21 @@ @Override public R republishInvalidEvent(CommonEventRepublishDTO commonEventRepublishDTO) { EventDO eventDO = this.getBaseMapper().selectById(commonEventRepublishDTO.getId()); - if(eventDO==null){ + if (eventDO == null) { return R.fail("事件不存在"); } - boolean canRepulish = eventDO.getEventDealStatus()==7; //已失效状态 - if(!canRepulish){ - return R.fail("当前事件不是已失效状态,不能重新发布"); + boolean canRepulish = eventDO.getEventDealStatus() == 7 || eventDO.getEventDealStatus() == 5 || eventDO.getEventDealStatus() == 6; // 已失效状态 + if (!canRepulish) { + return R.fail("当前事件不是已失效状态/草稿状态/撤销状态,不能重新发布"); } eventDO.setInvalid(true); + eventDO.setEventStatus(2); + eventDO.setEventDealStatus(1); int updated = this.getBaseMapper().updateById(eventDO); - if(updated == 1){ - addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), commonEventRepublishDTO.getUserName(), 1,"重新发布事件成功"); + if (updated == 1) { + addTransferRecord(eventDO.getId(), commonEventRepublishDTO.getUserId(), + commonEventRepublishDTO.getUserName(), 1, "重新发布事件成功", commonEventRepublishDTO.getUserId(), + commonEventRepublishDTO.getUserName(), 9); return R.ok(); } return R.fail(); @@ -1287,33 +1424,51 @@ return R.fail("事件不存在"); } boolean canDealByCommunity = eventDO.getEventDealStatus() == 3; - if(!canDealByCommunity){ + if (!canDealByCommunity) { return R.fail("事件当前不是上报状态"); } - if(commonEventDealDTO.getNeedVerify()){ - eventDO.setEventProcessStatus(3);//待验证状态 - eventDO.setProcessType(1);//交给网格员处理-验证 - }else { - eventDO.setEventProcessStatus(2);//2已解决 + List<EventTransferRecordDO> list = eventTransferRecordService.getBaseMapper().selectList( + new LambdaQueryWrapper<EventTransferRecordDO>().eq(EventTransferRecordDO::getEventId, eventDO.getId()) + .orderByDesc(EventTransferRecordDO::getCreateAt)); + + Long reportToInDB = -1L; + for (int i = 0; i < list.size(); i++) { + EventTransferRecordDO eventTransferRecordDO = list.get(i); + if (eventTransferRecordDO.getProcessType() != null && eventTransferRecordDO.getProcessType() == 2) { + reportToInDB = eventTransferRecordDO.getToId(); + } + } + if (commonEventDealDTO.getCommunityId() == null) { + return R.fail("当前用户社区获取失败"); + } + if (reportToInDB.longValue() != commonEventDealDTO.getCommunityId().longValue()) { + return R.fail("用户上报的社区不是当前社区"); + } + if (commonEventDealDTO.getNeedVerify()) { + eventDO.setEventProcessStatus(3);// 待验证状态 + eventDO.setProcessType(1);// 交给网格员处理-验证 + } else { + eventDO.setEventProcessStatus(2);// 2已解决 } eventDO.setUpdateBy(commonEventDealDTO.getUserId()); - //更新处理信息 + // 更新处理信息 eventDO.setProcessUserId(commonEventDealDTO.getUserId()); eventDO.setProcessUserName(commonEventDealDTO.getUserName()); eventDO.setProcessDate(new Date()); eventDO.setProcessDesc(commonEventDealDTO.getProcessResult()); int updated = this.getBaseMapper().updateById(eventDO); - if(updated!=1){ + if (updated != 1) { return R.fail("更新事件状态失败"); } EventTransferRecordDO transferRecordDO = - addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(),1, "社区处理完成"); - if(transferRecordDO!=null && transferRecordDO.getId()!=null){ - //添加音频 - if(StringUtils.isNotEmpty(commonEventDealDTO.getAudio())){ + addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), 1, + "社区处理完成", commonEventDealDTO.getCommunityId(), commonEventDealDTO.getCommunityName(), 3); + if (transferRecordDO != null && transferRecordDO.getId() != null) { + // 添加音频 + if (StringUtils.isNotEmpty(commonEventDealDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(3); eventResourceDO.setType(2); @@ -1322,12 +1477,12 @@ eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); eventResourceDO.setResourceTime(commonEventDealDTO.getAudioTime()); int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(audioAdd!=1){ + if (audioAdd != 1) { throw new ServiceException("添加音频失败"); } } - //添加视频 - if(StringUtils.isNotEmpty(commonEventDealDTO.getVideo())){ + // 添加视频 + if (StringUtils.isNotEmpty(commonEventDealDTO.getVideo())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(3); eventResourceDO.setType(3); @@ -1336,12 +1491,12 @@ eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); eventResourceDO.setResourceTime(commonEventDealDTO.getVideoTime()); int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(videoAdd!=1){ + if (videoAdd != 1) { throw new ServiceException("添加视频失败"); } } - //添加图片 - if(StringUtils.isNotEmpty(commonEventDealDTO.getPics())){ + // 添加图片 + if (StringUtils.isNotEmpty(commonEventDealDTO.getPics())) { String[] pica = commonEventDealDTO.getPics().split(","); for (int i = 0; i < pica.length; i++) { EventResourceDO eventResourceDO = new EventResourceDO(); @@ -1351,7 +1506,7 @@ eventResourceDO.setRefId(transferRecordDO.getId()); eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(picAdd!=1){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -1360,38 +1515,36 @@ EventDO eventDOToUpdate = this.getBaseMapper().selectById(commonEventDealDTO.getId()); eventDOToUpdate.setProcessRecordId(transferRecordId); int transferRecordUpdated = this.getBaseMapper().updateById(eventDOToUpdate); - if(transferRecordUpdated!=1){ + if (transferRecordUpdated != 1) { throw new ServiceException("更新事件处理流程失败"); } return R.ok(); - }else{ + } else { throw new ServiceException("处理事件记录出错"); } } @Override public R selectCommunityPublicity(PagePublicityEventCommunityDTO pagePublicityEventDTO) { - Page page = new Page(1,10); - if(pagePublicityEventDTO.getPageNum()!=null) { + Page page = new Page(1, 10); + if (pagePublicityEventDTO.getPageNum() != null) { page.setCurrent(pagePublicityEventDTO.getPageNum()); } - if(pagePublicityEventDTO.getPageSize()!=null) { + if (pagePublicityEventDTO.getPageSize() != null) { page.setSize(pagePublicityEventDTO.getPageSize()); } IPage<EventVO> ipage = eventMapper.findCommunityPublicityByPage(page, pagePublicityEventDTO); - if(ipage!=null){ + if (ipage != null) { List<EventVO> eventVOList = ipage.getRecords(); eventVOList.forEach(eventVO -> { List<EventResourceDO> eventResourceDOList = - eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification, 1) - .eq(EventResourceDO::getRefId, eventVO.getId()) - ); + eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventVO.getId())); List<EventResourceVO> picList = new ArrayList<>(); List<EventResourceVO> audioList = new ArrayList<>(); List<EventResourceVO> videoList = new ArrayList<>(); eventResourceDOList.forEach(eventResourceDO -> { - switch (eventResourceDO.getType()){ + switch (eventResourceDO.getType()) { case 1: EventResourceVO picEventResourceVO = new EventResourceVO(); BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); @@ -1420,12 +1573,16 @@ /** * 添加发布事件流转记录 - * @param eventId 事件ID - * @param userId 操作用户ID - * @param userName 操作用户姓名 + * + * @param eventId + * 事件ID + * @param userId + * 操作用户ID + * @param userName + * 操作用户姓名 * @return 添加成功返回true, 否则返回false */ - private EventTransferRecordDO addReleaseRecord(Long eventId, Long userId, String userName){ + private EventTransferRecordDO addReleaseRecord(Long eventId, Long userId, String userName) { EventTransferRecordDO eventTransferRecordDO = new EventTransferRecordDO(); eventTransferRecordDO.setFromType(1); eventTransferRecordDO.setFromId(userId); @@ -1436,8 +1593,9 @@ eventTransferRecordDO.setProcessDate(new Date()); eventTransferRecordDO.setEventId(eventId); eventTransferRecordDO.setProcessResult("发布成功"); + eventTransferRecordDO.setProcessType(0);// 初始状态 int inserted = eventTransferRecordService.getBaseMapper().insert(eventTransferRecordDO); - if(inserted!=1){ + if (inserted != 1) { throw new ServiceException("事件流转记录添加失败"); } this.updateEventDealStatus(eventId); @@ -1446,110 +1604,1044 @@ /** * 查询最后的流转记录,并添加事件流转记录 - * @param eventId 事件ID - * @param toId 流转到 ID - * @param toName 流转到 名称 - * @param toType 发送类型 - * @param msg 流转消息 + * + * @param eventId + * 事件ID + * @param toId + * 流转到 ID + * @param toName + * 流转到 名称 + * @param toType + * 发送类型 + * @param msg + * 流转消息 * @return */ - private EventTransferRecordDO addTransferRecord(Long eventId, Long toId, String toName, Integer toType, String msg){ - List<EventTransferRecordDO> list = eventTransferRecordService.getBaseMapper().selectList(new LambdaQueryWrapper<EventTransferRecordDO>() - .eq(EventTransferRecordDO::getEventId, eventId) - .orderByDesc(EventTransferRecordDO::getCreateAt) - ); - if(list==null ||list.size()==0){ - throw new ServiceException("事件流转记录异常"); - } - EventTransferRecordDO lastRecord = list.get(0); + private EventTransferRecordDO addTransferRecord(Long eventId, Long toId, String toName, Integer toType, String msg, + Long processBy, String processByName, Integer processType) { + List<EventTransferRecordDO> list = + eventTransferRecordService.getBaseMapper().selectList(new LambdaQueryWrapper<EventTransferRecordDO>() + .eq(EventTransferRecordDO::getEventId, eventId).orderByDesc(EventTransferRecordDO::getCreateAt)); EventTransferRecordDO eventTransferRecordDO = new EventTransferRecordDO(); - eventTransferRecordDO.setFromType(lastRecord.getToType()); - eventTransferRecordDO.setFromId(lastRecord.getToId()); - eventTransferRecordDO.setFromName(lastRecord.getToName()); + if (list != null && list.size() > 0) { + EventTransferRecordDO lastRecord = list.get(0); + eventTransferRecordDO.setFromType(lastRecord.getToType()); + eventTransferRecordDO.setFromId(lastRecord.getToId()); + eventTransferRecordDO.setFromName(lastRecord.getToName()); + } eventTransferRecordDO.setToType(toType); eventTransferRecordDO.setToId(toId); eventTransferRecordDO.setProcessDate(new Date()); eventTransferRecordDO.setToName(toName); eventTransferRecordDO.setEventId(eventId); eventTransferRecordDO.setProcessResult(msg); + eventTransferRecordDO.setProcessBy(processBy); + eventTransferRecordDO.setProcessByName(processByName); + eventTransferRecordDO.setProcessType(processType); int inserted = eventTransferRecordService.getBaseMapper().insert(eventTransferRecordDO); - if(inserted==1) { + if (inserted == 1) { this.updateEventDealStatus(eventId); return eventTransferRecordDO; - }else{ + } else { throw new ServiceException("事件流转记录添加失败"); } } /** - * 根据子状态 查询用户事件处理状态 - * @param eventId 事件ID + * 查询最后的流转记录,并添加事件流转记录 + * + * @param eventId + * 事件ID + * @param toId + * 流转到 ID + * @param toName + * 流转到 名称 + * @param toType + * 发送类型 + * @param msg + * 流转消息 + * @return */ - private EventDO updateEventDealStatus(Long eventId){ + /* private EventTransferRecordDO addTransferRecord(Long eventId, Long toId, String toName, Integer toType, String msg,Integer processType){ + return addTransferRecord(eventId, toId, toName, toType, msg, null, null, processType); + }*/ + + /** + * 根据子状态 查询用户事件处理状态 + * + * @param eventId + * 事件ID + */ + private EventDO updateEventDealStatus(Long eventId) { EventDO eventDO = this.getBaseMapper().selectById(eventId); Integer eventDealStatus = getEventDealStatus(eventDO); eventDO.setEventDealStatus(eventDealStatus); int updated = this.getBaseMapper().updateById(eventDO); - if(updated == 1){ + if (updated == 1) { return eventDO; - }else{ + } else { throw new ServiceException("更新事件处理状态错误"); } } /** * 根据子状态 查询用户事件处理状态 - * @param eventDO 事件 + * + * @param eventDO + * 事件 */ - private Integer getEventDealStatus(EventDO eventDO){ - //1 待处理、2 待验证、3 已上报、4 已解决、5 草稿箱、6已撤销、7已失效、8已发布 - if(eventDO.getEventCategory()!=null) { + private Integer getEventDealStatus(EventDO eventDO) { + // 1 待处理、2 待验证、3 已上报、4 已解决、5 草稿箱、6已撤销、7已失效、8已发布 + if (eventDO.getEventCategory() != null) { if (eventDO.getEventCategory() == 1) { - Integer event_status = eventDO.getEventStatus()!=null?eventDO.getEventStatus():-1; - Integer event_process_status = eventDO.getEventProcessStatus()!=null?eventDO.getEventProcessStatus():-1; - Integer process_type = eventDO.getProcessType()!=null?eventDO.getProcessType():-1; - Integer community_process = eventDO.getCommunityProcess()!=null?eventDO.getCommunityProcess():-1; + Integer event_status = eventDO.getEventStatus() != null ? eventDO.getEventStatus() : -1; + Integer event_process_status = + eventDO.getEventProcessStatus() != null ? eventDO.getEventProcessStatus() : -1; + Integer process_type = eventDO.getProcessType() != null ? eventDO.getProcessType() : -1; + Integer community_process = eventDO.getCommunityProcess() != null ? eventDO.getCommunityProcess() : -1; Integer eventDealStatus = -1; - if (eventDO.getInvalid() != null && eventDO.getInvalid() == false) { + /*if (eventDO.getInvalid() != null && eventDO.getInvalid() == false) { eventDealStatus = 7; //7已失效 - } else if (event_status == 1) { + }*/ + if (event_status == 1) { eventDealStatus = 5; - //"草稿箱" - } else if ( event_status == 4) { + // "草稿箱" + } else if (event_status == 4) { eventDealStatus = 6; - //"已撤销" - } else if (event_status ==2){ + // "已撤销" + } else if (event_status == 2) { if (event_process_status == 3) { eventDealStatus = 2; - //"待验证" - }else if (event_process_status == 2) { + // "待验证" + } else if (event_process_status == 2) { eventDealStatus = 4; - //"已解决" - }else if ( community_process == 1 && process_type == 2) { + // "已解决" + } else if (community_process == 1 && process_type == 2) { eventDealStatus = 3; - //"已上报" - }else if ( event_process_status == 1 && process_type == 1) { + // "已上报" + } else if (event_process_status == 1 && process_type == 1) { eventDealStatus = 1; - //"待处理" - } + // "待处理" + } } return eventDealStatus; } else if (eventDO.getEventCategory() == 2) { Integer event_status = eventDO.getEventStatus(); if (event_status != null && event_status == 1) { return 5; - //"草稿箱" + // "草稿箱" } else if (event_status != null && event_status == 2) { return 8; - //已发布 + // 已发布 } else if (event_status != null && event_status == 4) { return 6; - //"已撤销" + // "已撤销" } } } return -1; } + + /** + * 后台管理-统计模块 + * + * @param communityId + * 社区id + * @return 统计信息 + */ + @Override + public R eventStatistics(Long communityId) { + return R.ok(this.baseMapper.eventStatistics(communityId)); + } + + /** + * 后台管理-网格员统计 + * + * @param statisticsAdminDTO + * 请求参数 + * @return 网格员统计信息 + */ + @Override + public R gridMemberStatistics(MemberStatisticsAdminDTO statisticsAdminDTO) { + return R.ok(eventGridMemberRelationMapper.gridMemberStatistics( + new Page(statisticsAdminDTO.getPageNum(), statisticsAdminDTO.getPageSize()), statisticsAdminDTO)); + } + + @Override + public R getNearByGrid(PageEventGridNearbyDTO pageEventGridNearbyDTO) { + Page page = new Page(pageEventGridNearbyDTO.getPageNum(), pageEventGridNearbyDTO.getPageSize()); + String latLng = pageEventGridNearbyDTO.getHappentLatLng(); + // if(!latLng.matches("^[\\-\\+]?(0(\\.\\d{1,10})?|([1-9](\\d)?)(\\.\\d{1,10})?|1[0-7]\\d{1}(\\.\\d{1,10})?|180\\.0{1,10}),[\\-\\+]?((0|([1-8]\\d?))(\\.\\d{1,10})?|90(\\.0{1,10})?)$")){ + // return R.fail("经纬度参数错误"); + // } + // 经纬度匹配规则:(短(纬度)在前长(经度)在后,不要擅自修改此规则,否则出现问题后果自负) + // if(!latLng.matches("[1-9][0-9](\\.[0-9]{1,6})?,[1-9][0-9]{2}(\\.[0-9]{1,6})?")){ + // return R.fail("经纬度参数错误"); + // } + String[] latLngArr = latLng.split(","); + try { + Double lat = Double.valueOf(latLngArr[1]); + Double lng = Double.valueOf(latLngArr[0]); + List<EventGridDataAreaVO> gridList = eventGridDataMapper.selectGridWithArea(page, pageEventGridNearbyDTO); + if (gridList != null && gridList.size() > 0) { + List<EventGridDataVO> rtEventGridList = new ArrayList<>(); + for (EventGridDataAreaVO eventGridDataDO : gridList) { + String data = eventGridDataDO.getData(); + if (data != null) { + List<LatLngVO> latLngList = LngLatUtils.getLatLngFromText(data); + boolean inGrid = LngLatUtils.isInPolygon(latLngList, lng, lat); + if (inGrid) { + EventGridDataVO eventGridDataVO = new EventGridDataVO(); + BeanUtils.copyProperties(eventGridDataDO, eventGridDataVO); + rtEventGridList.add(eventGridDataVO); + } + } + } + return R.ok(rtEventGridList); + } else { + return R.ok("未找到社区"); + } + } catch (Exception e) { + return R.fail(e.getMessage()); + } + } + + @Override + @Transactional(rollbackFor = Exception.class) + public R deleteEventBatch(EventDeleteDTO eventDeleteDTO) { + List<String> eventIds = eventDeleteDTO.getId(); + if (eventIds != null && eventIds.size() > 0) { + R rt = null; + Long userId = eventDeleteDTO.getUserId(); + for (String id : eventIds) { + try { + Long eventId = Long.parseLong(id); + EventDO eventDO = eventMapper.selectById(eventId); + if (eventDO == null) { + throw new ServiceException("id为" + id + "的事件不存在"); + } + if (eventDO.getEventStatus() != null) { + eventDO.setEventStatus(3);// 逻辑删除 + eventDO.setUpdateBy(userId); + int updated = this.getBaseMapper().updateById(eventDO); + if (updated != 1) { + throw new ServiceException("删除事件失败"); + } + } + } catch (Exception e) { + throw new ServiceException("事件ID错误,删除失败"); + } + } + return R.ok(); + } else { + return R.fail("参数错误"); + } + + } + + @Override + @Transactional(rollbackFor = Exception.class) + public R batchRepublishEvent(CommonEventBatchRepublishDTO commonEventBatchRepublishDTO) { + List<String> ids = commonEventBatchRepublishDTO.getId(); + if (ids != null && ids.size() > 0) { + Long userId = commonEventBatchRepublishDTO.getUserId(); + String userName = commonEventBatchRepublishDTO.getUserName(); + for (String id : ids) { + Long eventId = -1L; + try { + eventId = Long.parseLong(id); + } catch (Exception e) { + throw new ServiceException("事件ID错误,发布失败"); + } + EventDO eventDO = this.getBaseMapper().selectById(eventId); + if (eventDO == null) { + throw new ServiceException("id为" + id + "的事件不存在"); + } + boolean canRepublishByUser = eventDO.getEventDealStatus() != null + && (eventDO.getEventDealStatus() == 5 || eventDO.getEventDealStatus() == 6); + if (!canRepublishByUser) { + throw new ServiceException("当前不是撤销/草稿状态"); + } + eventDO.setEventStatus(2);// 2 发布 + eventDO.setEventProcessStatus(1); // 待解决 + eventDO.setProcessType(1); // 网格员处理 + eventDO.setUpdateBy(userId); + int updated = this.getBaseMapper().updateById(eventDO); + if (updated != 1) { + throw new ServiceException("更新事件状态失败"); + } + addTransferRecord(eventDO.getId(), userId, userName, 1, "重新发布已撤销事件", userId, userName, 8); + } + return R.ok(); + } else { + return R.fail("参数错误"); + } + } + + @Override + @Transactional(rollbackFor = Exception.class) + public R batchMarkEventInvalid(EventBatchRevokeDTO eventBatchRevokeDTO) { + List<String> ids = eventBatchRevokeDTO.getId(); + if (ids != null && ids.size() > 0) { + Long userId = eventBatchRevokeDTO.getUserId(); + String userName = eventBatchRevokeDTO.getUserName(); + Long communityId = eventBatchRevokeDTO.getCommunityId(); + String communityName = eventBatchRevokeDTO.getCommunityName(); + for (String id : ids) { + Long eventId = -1L; + try { + eventId = Long.parseLong(id); + } catch (Exception e) { + throw new ServiceException("事件ID错误,不能标记失效"); + } + EventDO eventDO = this.getBaseMapper().selectById(eventId); + if (eventDO == null) { + throw new ServiceException("id为" + id + "的事件不存在"); + } + if (eventDO.getEventCategory() != null) { + if (eventDO.getEventCategory() == 1) {// + boolean canRevoke = eventDO.getEventDealStatus() == 3; // 上报状态 + if (!canRevoke) { + throw new ServiceException("当前事件不是上报状态,不允许撤销"); + } + } else if (eventDO.getEventCategory() == 2) {// 宣传教育 + boolean canRevoke = eventDO.getEventDealStatus() == 8; // 发布状态 + if (!canRevoke) { + throw new ServiceException("当前事件不是发布状态,不允许撤销"); + } + } else { + throw new ServiceException("事件分类错误"); + } + } else { + throw new ServiceException("事件所属错误"); + } + eventDO.setInvalid(false); + // 标为无效后, 交给网格员处理 + eventDO.setUpdateBy(userId); + eventDO.setEventStatus(4);// 4、撤销 + eventDO.setProcessType(1);// 网格员处理 + eventDO.setCommunityProcess(0);// 非 社区处理 + int updated = this.getBaseMapper().updateById(eventDO); + if (updated == 1) { + addTransferRecord(eventDO.getId(), userId, userName, 1, "标为无效", communityId, communityName, 4); + } else { + throw new ServiceException("事件流转信息添加错误"); + } + } + return R.ok(); + } else { + return R.fail("参数错误"); + } + } + + /** + * 根据网格id查询网格统计数据 + * + * @param gridId + * 网格id + * @return 网格统计数据 + */ + @Override + public R getGridEventStatisticsByApp(Long gridId, Long userId) { + GridEventStatisticsVO result = this.baseMapper.getGridEventStatisticsByApp(gridId); + if (result != null) { + result.setTodayNum(result.getTodayNum() + result.getZfTodayNum() + result.getSspTodayNum()); + result.setMonthNum(result.getMonthNum() + result.getZfMonthNum() + result.getSspMonthNum()); + + // 查询当前网格员下管理的楼栋名称 + List<Map<String, Object>> buildNameList = this.baseMapper.getMemberBuildName(userId); + Integer specialTotal = 0; + if (!buildNameList.isEmpty()) { + for (Map<String, Object> buildMap : buildNameList) { + String buildName = buildMap.get("name").toString(); + Long villageId = Long.parseLong(buildMap.get("village_id").toString()); + Integer num = this.baseMapper.getPopulationByLabelCount(buildName, villageId); + specialTotal += num; + } + } + result.setSpecialTotal(specialTotal); + } + return R.ok(result); + } + + /** + * 查询网格事件统计数据 + * + * @param statisticsDTO + * 请求参数 + * @return 网格事件统计数据 + */ + @Override + public R getGridEventDetailStatisticsByApp(GridEventStatisticsDTO statisticsDTO) { + GridEventStatisticsDetailVO statisticsDetailVO = + this.baseMapper.getGridEventDetailStatisticsByApp(statisticsDTO); + if (statisticsDetailVO == null) { + statisticsDetailVO = new GridEventStatisticsDetailVO(); + } + + if (statisticsDetailVO.getEventSSPTotal() == null) { + statisticsDetailVO.setEventSSPTotal(0); + } + if (statisticsDetailVO.getNoEventSSPTotal() == null) { + statisticsDetailVO.setNoEventSSPTotal(0); + } + if (statisticsDetailVO.getEventZFTotal() == null) { + statisticsDetailVO.setEventZFTotal(0); + } + if (statisticsDetailVO.getNoEventZFTotal() == null) { + statisticsDetailVO.setNoEventZFTotal(0); + } + + // 查询网格 + EventGridDataDO gridDataDO = eventGridDataMapper.selectById(statisticsDTO.getGridId()); + if (gridDataDO != null) { + Map<String, Long> sspCountMap = this.baseMapper.getSSPEventTotal(gridDataDO.getGridCommunityId()); + if (!sspCountMap.isEmpty()) { + statisticsDetailVO.setEventSSPTotal( + sspCountMap.get("eventSSPTotal") != null ? sspCountMap.get("eventSSPTotal").intValue() : 0); + statisticsDetailVO.setNoEventSSPTotal( + sspCountMap.get("noEventSSPTotal") != null ? sspCountMap.get("noEventSSPTotal").intValue() : 0); + } + } + + // 统计数据 + Integer sum = statisticsDetailVO.getEventTFTotal() + statisticsDetailVO.getEventMDTotal() + + statisticsDetailVO.getEventZATotal() + statisticsDetailVO.getEventBWDTotal() + + statisticsDetailVO.getEventTSTotal() + statisticsDetailVO.getEventGGTotal() + + statisticsDetailVO.getEventXCTotal() + statisticsDetailVO.getEventSSPTotal() + + statisticsDetailVO.getEventZFTotal(); + statisticsDetailVO.setSum(sum); + + Integer noSum = statisticsDetailVO.getNoEventTFTotal() + statisticsDetailVO.getNoEventMDTotal() + + statisticsDetailVO.getNoEventZATotal() + statisticsDetailVO.getNoEventBWDTotal() + + statisticsDetailVO.getNoEventTSTotal() + statisticsDetailVO.getNoEventGGTotal() + + statisticsDetailVO.getNoEventSSPTotal() + statisticsDetailVO.getNoEventZFTotal(); + statisticsDetailVO.setNoSum(noSum); + return R.ok(statisticsDetailVO); + } + + @Override + @Transactional(rollbackFor = Exception.class) + public R reportDirect(CommonEventDirectReportDTO commonEventDirectReportDTO) { + + if (commonEventDirectReportDTO.getEventId() != null) { + // 编辑原来的 + EventDO eventDO = eventMapper.selectById(commonEventDirectReportDTO.getEventId()); + if (eventDO.getEventStatus() != null && eventDO.getEventStatus() != 1 + && eventDO.getEventDealStatus() != 6) { + return R.fail("保存草稿失败,事件不是草稿/已撤销状态"); + } + BeanUtils.copyProperties(commonEventDirectReportDTO, eventDO); + eventDO.setGridMemberId(commonEventDirectReportDTO.getUserId()); + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventStatus(1);// 事件状态 2发布 + eventDO.setProcessType(2);// 社区处理 + eventDO.setCommunityProcess(1);// 社区处理 + eventDO.setUpdateBy(commonEventDirectReportDTO.getUserId()); + if (eventMapper.updateById(eventDO) > 0) { + int deleted = eventResourceService.getBaseMapper().delete(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, eventDO.getId())); + // 添加音频 + if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getAudio())) { + EventResourceDO eventResourceDO = new EventResourceDO(); + eventResourceDO.setClassification(1); + eventResourceDO.setType(2); + eventResourceDO.setRefId(eventDO.getId()); + eventResourceDO.setUrl(commonEventDirectReportDTO.getAudio()); + eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + eventResourceDO.setResourceTime(commonEventDirectReportDTO.getAudioTime()); + int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); + if (audioAdd != 1) { + throw new ServiceException("添加音频失败"); + } + } + // 添加视频 + if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getVideo())) { + EventResourceDO eventResourceDO = new EventResourceDO(); + eventResourceDO.setClassification(1); + eventResourceDO.setType(3); + eventResourceDO.setRefId(eventDO.getId()); + eventResourceDO.setUrl(commonEventDirectReportDTO.getVideo()); + eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + eventResourceDO.setResourceTime(commonEventDirectReportDTO.getVideoTime()); + int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); + if (videoAdd != 1) { + throw new ServiceException("添加视频失败"); + } + } + // 添加图片 + if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getPics())) { + String[] pica = commonEventDirectReportDTO.getPics().split(","); + for (int i = 0; i < pica.length; i++) { + EventResourceDO eventResourceDO = new EventResourceDO(); + eventResourceDO.setClassification(1); + eventResourceDO.setType(1); + eventResourceDO.setRefId(eventDO.getId()); + eventResourceDO.setUrl(pica[i]); + eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); + if (picAdd != 1) { + throw new ServiceException("添加图片失败"); + } + } + } + + R r = communityService.detailCommunity(commonEventDirectReportDTO.getToId()); + if (!R.isOk(r)) { + return R.fail("社区不存在"); + } + ComActVO comActVO = JSONObject.parseObject(JSONObject.toJSONString(r.getData()), ComActVO.class); + if (comActVO == null) { + return R.fail("社区不存在"); + } + EventDO eventDOInDB = this.getBaseMapper().selectById(commonEventDirectReportDTO.getEventId()); + eventDOInDB.setCommunityProcess(1); // 社区处理 + eventDOInDB.setProcessType(2); // 当前处理对象: 社区处理 + eventDOInDB.setCommunityProcess(1); + eventDOInDB.setEventProcessStatus(1); // 待处理 + eventDOInDB.setUpdateBy(commonEventDirectReportDTO.getUserId()); + eventDOInDB.setSubmitDate(new Date()); + int updated = this.getBaseMapper().updateById(eventDO); + if (updated != 1) { + throw new ServiceException("事件状态更新失败"); + } + addTransferRecord(eventDO.getId(), commonEventDirectReportDTO.getToId(), comActVO.getName(), 2, + commonEventDirectReportDTO.getProcessResult(), commonEventDirectReportDTO.getUserId(), + commonEventDirectReportDTO.getUserName(), 2); + return R.ok(); + } + + } else { + EventDO eventDO = new EventDO(); + BeanUtils.copyProperties(commonEventDirectReportDTO, eventDO); + eventDO.setGridMemberId(commonEventDirectReportDTO.getUserId()); + EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventDirectReportDTO.getGridId()); + if (eventGridDataDO == null) { + return R.fail("网格不存在"); + } + eventDO.setEventCategory(1l);// 办件事件 + eventDO.setEventStatus(2);// 事件状态 2发布 + eventDO.setProcessType(2);// 社区处理 + eventDO.setCommunityProcess(1);// 社区处理 + eventDO.setEventProcessStatus(1); + eventDO.setGridMemberName(commonEventDirectReportDTO.getUserName()); + eventDO.setGridMemberTelephone(commonEventDirectReportDTO.getPhone()); + eventDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + eventDO.setSubmitDate(new Date()); + eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); + if (eventMapper.insert(eventDO) == 1) { + // 添加音频 + if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getAudio())) { + EventResourceDO eventResourceDO = new EventResourceDO(); + eventResourceDO.setClassification(1); + eventResourceDO.setType(2); + eventResourceDO.setUrl(commonEventDirectReportDTO.getAudio()); + eventResourceDO.setRefId(eventDO.getId()); + eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + eventResourceDO.setResourceTime(commonEventDirectReportDTO.getAudioTime()); + int audioAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); + if (audioAdd != 1) { + throw new ServiceException("添加音频失败"); + } + } + // 添加视频 + if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getVideo())) { + EventResourceDO eventResourceDO = new EventResourceDO(); + eventResourceDO.setClassification(1); + eventResourceDO.setType(3); + eventResourceDO.setUrl(commonEventDirectReportDTO.getVideo()); + eventResourceDO.setRefId(eventDO.getId()); + eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + eventResourceDO.setResourceTime(commonEventDirectReportDTO.getVideoTime()); + int videoAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); + if (videoAdd != 1) { + throw new ServiceException("添加视频失败"); + } + } + // 添加图片 + if (StringUtils.isNotEmpty(commonEventDirectReportDTO.getPics())) { + String[] pica = commonEventDirectReportDTO.getPics().split(","); + for (int i = 0; i < pica.length; i++) { + EventResourceDO eventResourceDO = new EventResourceDO(); + eventResourceDO.setClassification(1); + eventResourceDO.setType(1); + eventResourceDO.setUrl(pica[i]); + eventResourceDO.setRefId(eventDO.getId()); + eventResourceDO.setCreateBy(commonEventDirectReportDTO.getUserId()); + int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); + if (picAdd != 1) { + throw new ServiceException("添加图片失败"); + } + } + } + addReleaseRecord(eventDO.getId(), commonEventDirectReportDTO.getUserId(), + commonEventDirectReportDTO.getUserName()); + + R r = communityService.detailCommunity(commonEventDirectReportDTO.getToId()); + if (!R.isOk(r)) { + return R.fail("社区不存在"); + } + ComActVO comActVO = JSONObject.parseObject(JSONObject.toJSONString(r.getData()), ComActVO.class); + if (comActVO == null) { + return R.fail("社区不存在"); + } + EventDO eventDOInDB = this.getBaseMapper().selectById(eventDO.getId()); + eventDOInDB.setCommunityProcess(1); // 社区处理 + eventDOInDB.setProcessType(2); // 当前处理对象: 社区处理 + eventDOInDB.setCommunityProcess(1); + eventDOInDB.setEventProcessStatus(1); // 待处理 + eventDOInDB.setUpdateBy(commonEventDirectReportDTO.getUserId()); + eventDOInDB.setSubmitDate(new Date()); + int updated = this.getBaseMapper().updateById(eventDO); + if (updated != 1) { + throw new ServiceException("更新突发事件状态更新失败"); + } + addTransferRecord(eventDO.getId(), commonEventDirectReportDTO.getToId(), comActVO.getName(), 2, + commonEventDirectReportDTO.getProcessResult(), commonEventDirectReportDTO.getUserId(), + commonEventDirectReportDTO.getUserName(), 2); + return R.ok(eventDO.getId()); + } + } + + return R.fail(); + } + + /** + * 事件大屏查询事件列表 + * + * @param eventListDTO + * 请求参数 + * @return 事件列表 + */ + @Override + public R getScreenEventList(ScreenEventListDTO eventListDTO) { + if (eventListDTO.getEventTypes() != null && !eventListDTO.getEventTypes().isEmpty()) { + eventListDTO.getEventTypes().forEach(eventType -> { + if (eventType.equals(ScreenEventListDTO.eventType.xc)) { + eventListDTO.setEventCategory(null); + } + }); + + } + IPage<EventListVO> eventPageList = this.baseMapper + .getScreenEventList(new Page(eventListDTO.getPageNum(), eventListDTO.getPageSize()), eventListDTO); + if (!eventPageList.getRecords().isEmpty()) { + eventPageList.getRecords().forEach(event -> { + // 查询事件关联附件 + List<EventResourceDO> eventResourceDOList = + eventResourceService.getBaseMapper().selectList(new LambdaQueryWrapper<EventResourceDO>() + .eq(EventResourceDO::getClassification, 1).eq(EventResourceDO::getRefId, event.getId())); + List<EventResourceVO> picList = new ArrayList<>(); + List<EventResourceVO> audioList = new ArrayList<>(); + List<EventResourceVO> videoList = new ArrayList<>(); + eventResourceDOList.forEach(eventResourceDO -> { + switch (eventResourceDO.getType()) { + case 1: + EventResourceVO picEventResourceVO = new EventResourceVO(); + BeanUtils.copyProperties(eventResourceDO, picEventResourceVO); + picList.add(picEventResourceVO); + break; + case 2: + EventResourceVO audioResourceVO = new EventResourceVO(); + BeanUtils.copyProperties(eventResourceDO, audioResourceVO); + audioList.add(audioResourceVO); + break; + case 3: + EventResourceVO videoResourceVO = new EventResourceVO(); + BeanUtils.copyProperties(eventResourceDO, videoResourceVO); + videoList.add(videoResourceVO); + break; + } + }); + event.setAudios(audioList); + event.setPics(picList); + event.setVideos(videoList); + }); + } + return R.ok(eventPageList); + } + + /** + * 特殊人群上报-社区人口数据列表 + * + * @param specialPopulationDTO + * 请求参数 + * @return 社区人口数据列表 + */ + @Override + public R specialPopulationList(PageEventSpecialPopulationDTO specialPopulationDTO) { + IPage<EventSpecialPopulationVO> specialPopulationVOIPage = this.baseMapper.specialPopulationList( + new Page(specialPopulationDTO.getPageNum(), specialPopulationDTO.getPageSize()), specialPopulationDTO); + if (!specialPopulationVOIPage.getRecords().isEmpty()) { + specialPopulationVOIPage.getRecords().forEach(specialPopulation -> { + try { + Integer age = IdcardUtil.getAgeByIdCard(specialPopulation.getIdCard()); + specialPopulation.setAge(age); + } catch (Exception e) { + log.error("身份证号码转换年龄失败,人员id:" + specialPopulation.getId()); + } + }); + } + return R.ok(specialPopulationVOIPage); + } + + @Override + public List<EventDetailsVO> getUnUploadEvent() { + List<EventDetailsVO> eventDetailsVOList = new ArrayList<>(); + List<EventDO> unEventList = + baseMapper.selectList(new QueryWrapper<EventDO>().eq("upload", false).eq("event_process_status", 2)); + 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)); + return flag > 0; + } + + @Override + public R eventWork(Long communityId) { + EventWorkScreenVO workScreenVO = new EventWorkScreenVO(); + String date = DateUtils.getDateFormatString(new Date(), moth_format_str); + Map<String, Long> countMap = this.eventMapper.countByCommunityId(communityId, date); + if (!countMap.isEmpty()) { + workScreenVO.setResolvedNum( + countMap.get("resolvedNum") == null ? 0L : Long.valueOf(countMap.get("resolvedNum").toString())); + workScreenVO.setPendingNum( + countMap.get("pendingNum") == null ? 0L : Long.valueOf(countMap.get("pendingNum").toString())); + workScreenVO.setPropagandaNum( + countMap.get("propagandaNum") == null ? 13L : Long.valueOf(countMap.get("propagandaNum").toString())); + workScreenVO.setCurrentNum(countMap.get("sspCurrentNum") + countMap.get("currentNum")); + } + + // 计算处理时间消耗的时间 + DateScreenVO countAvg = this.eventMapper.countByAvgCommunityId(communityId); + if (countAvg != null) { + int second = (int)(countAvg.getEndTime().getTime() - countAvg.getStartTime().getTime()) / 1000; + if (second > 0) { + second = second / workScreenVO.getResolvedNum().intValue(); + workScreenVO.setAvgCost(second); + } + } + // 查询最新事件轮播列表 + List<EventDetailWorkVO> eventList = this.eventMapper.getWorkScreenEventList(communityId); + if (!eventList.isEmpty()) { + workScreenVO.setEventList(eventList); + } + + // 统计近半年数据 + List<EventWorkVO> list = new ArrayList<>(); + for (EventWorkVO eventWorkVO : listHalfYearByDyn()) { + EventWorkVO result = + this.eventMapper.countByTime(eventWorkVO.getStart(), eventWorkVO.getEnd(), communityId); + result.setEventTotal(result.getEventTotal() + result.getSspTotal()); + result.setEventAdd(result.getEventAdd() + result.getSspAdd()); + result.setEventSolve(result.getEventSolve() + result.getSspSolve()); + result.setMonth(eventWorkVO.getMonth()); + list.add(result); + } + workScreenVO.setList(list); + + // 查询完成事件统计 + EventTypeWorkVO complete = this.eventMapper.getComplete(communityId); + if (complete != null) { + workScreenVO.setComplete(complete); + } + // 查询未完成事件统计 + EventTypeWorkVO noComplete = this.eventMapper.getNoComplete(communityId); + if (complete != null) { + workScreenVO.setNoComplete(noComplete); + } + return R.ok(workScreenVO); + } + + private List<EventWorkVO> listHalfYearByDyn() { + List<EventWorkVO> dateList = new ArrayList<>(); + Date now = new Date(); + for (int i = 6; i >= 1; i--) { + Date date = DateUtils.getDateM(now, -(i - 1)); + DateTime endDay = DateUtil.endOfMonth(date); + + int m = DateUtil.month(endDay); + // m++; + if (m == 12) { + m = 0; + } + int day = DateUtil.dayOfMonth(endDay); + int half = day / 2; + String month = DateUtil.format(date, moth_format_str); + EventWorkVO eventWorkVO = new EventWorkVO(); + eventWorkVO.setMonth(monthStr[m] + "月上旬"); + eventWorkVO.setStart(month + "-01 00:00:00"); + eventWorkVO.setEnd(month + "-" + half + " 23:59:59"); + dateList.add(eventWorkVO); + EventWorkVO eventWorkVO1 = new EventWorkVO(); + eventWorkVO1.setMonth(monthStr[m] + "月下旬"); + eventWorkVO1.setStart(month + "-" + half + " 23:59:59"); + eventWorkVO1.setEnd(DateUtils.getDateFormatString(endDay, "yyyy-MM-dd HH:mm:ss")); + dateList.add(eventWorkVO1); + } + return dateList; + } + + /** + * 绘制多边形统计数据 + * + * @param eventListDTO + * 请求参数 + * @return 统计数据 + */ + @Override + public R getCivilDrawList(ScreenDrawEventListDTO eventListDTO) { + + ScreenDrawEventVO drawEventVO = new ScreenDrawEventVO(); + // 返回事件列表结果集 + List<EventGridIncidentStatisticsVO> eventResultList = new ArrayList<>(); + // 返回小区列表结果集 + List<CivilVillageStatisticsVO> villageResultList = new ArrayList<>(); + // 返回事件统计 + EventLeftDownStatisticsVO leftDownStatisticsVO = new EventLeftDownStatisticsVO(); + // 返回人口统计 + ScreenDrawEventPopulationTotalVO drawEventPopulationTotalVO = new ScreenDrawEventPopulationTotalVO(); + // 查询所有事件 + List<EventGridIncidentStatisticsVO> gridIncidentList = + this.baseMapper.getEventListByCommunityId(eventListDTO.getCommunityId()); + if (!gridIncidentList.isEmpty()) { + gridIncidentList.forEach(gridIncident -> { + // 拆分事件经纬度 + Double lng = 0.0;// 经度 + Double lat = 0.0;// 纬度 + String[] lngLatString = gridIncident.getLatLng().split(","); + if (!gridIncident.getType().equals(7)) { + lat = Double.parseDouble(lngLatString[0]); + lng = Double.parseDouble(lngLatString[1]); + } else { + lat = Double.parseDouble(lngLatString[1]); + lng = Double.parseDouble(lngLatString[0]); + } + + // 判断绘制的图形类型 + if (eventListDTO.getType().equals(ScreenDrawEventListDTO.type.yx)) { + // 判断这个点是否在圆形范围内 + if (GisPointUtil.isInCircle(eventListDTO.getCenterLng(), eventListDTO.getCenterLat(), lng, lat, + eventListDTO.getRadius())) { + if (eventResultList.size() <= eventListDTO.getCount()) { + eventResultList.add(gridIncident); + } + switch (gridIncident.getType()) { + case 1: + leftDownStatisticsVO.setEventZATotal(leftDownStatisticsVO.getEventZATotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventZATotal(leftDownStatisticsVO.getYesEventZATotal() + 1); + } + break; + case 2: + leftDownStatisticsVO.setEventGGTotal(leftDownStatisticsVO.getEventGGTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventGGTotal(leftDownStatisticsVO.getYesEventGGTotal() + 1); + } + break; + case 3: + leftDownStatisticsVO.setEventMDTotal(leftDownStatisticsVO.getEventMDTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventMDTotal(leftDownStatisticsVO.getYesEventMDTotal() + 1); + } + break; + case 4: + leftDownStatisticsVO.setEventBWDTotal(leftDownStatisticsVO.getEventBWDTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventBWDTotal(leftDownStatisticsVO.getYesEventBWDTotal() + 1); + } + break; + case 5: + leftDownStatisticsVO.setEventTFTotal(leftDownStatisticsVO.getEventTFTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventTFTotal(leftDownStatisticsVO.getYesEventTFTotal() + 1); + } + break; + case 6: + leftDownStatisticsVO.setEventTSTotal(leftDownStatisticsVO.getEventTSTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventTSTotal(leftDownStatisticsVO.getYesEventTSTotal() + 1); + } + break; + case 7: + leftDownStatisticsVO.setEventSSPTotal(leftDownStatisticsVO.getEventSSPTotal() + 1); + if (gridIncident.getStatus().equals(2)) { + leftDownStatisticsVO + .setYesEventSSPTotal(leftDownStatisticsVO.getYesEventSSPTotal() + 1); + } + break; + default: + break; + } + } + } else {// 多边形类型 + if (GisPointUtil.isInPolygon(lng, lat, eventListDTO.getLngLatList())) { + if (eventResultList.size() <= eventListDTO.getCount()) { + eventResultList.add(gridIncident); + } + switch (gridIncident.getType()) { + case 1: + leftDownStatisticsVO.setEventZATotal(leftDownStatisticsVO.getEventZATotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventZATotal(leftDownStatisticsVO.getYesEventZATotal() + 1); + } + break; + case 2: + leftDownStatisticsVO.setEventGGTotal(leftDownStatisticsVO.getEventGGTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventGGTotal(leftDownStatisticsVO.getYesEventGGTotal() + 1); + } + break; + case 3: + leftDownStatisticsVO.setEventMDTotal(leftDownStatisticsVO.getEventMDTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventMDTotal(leftDownStatisticsVO.getYesEventMDTotal() + 1); + } + break; + case 4: + leftDownStatisticsVO.setEventBWDTotal(leftDownStatisticsVO.getEventBWDTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventBWDTotal(leftDownStatisticsVO.getYesEventBWDTotal() + 1); + } + break; + case 5: + leftDownStatisticsVO.setEventTFTotal(leftDownStatisticsVO.getEventTFTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventTFTotal(leftDownStatisticsVO.getYesEventTFTotal() + 1); + } + break; + case 6: + leftDownStatisticsVO.setEventTSTotal(leftDownStatisticsVO.getEventTSTotal() + 1); + if (gridIncident.getStatus().equals(4)) { + leftDownStatisticsVO + .setYesEventTSTotal(leftDownStatisticsVO.getYesEventTSTotal() + 1); + } + break; + case 7: + leftDownStatisticsVO.setEventSSPTotal(leftDownStatisticsVO.getEventSSPTotal() + 1); + if (gridIncident.getStatus().equals(2)) { + leftDownStatisticsVO + .setYesEventSSPTotal(leftDownStatisticsVO.getYesEventSSPTotal() + 1); + } + break; + default: + break; + } + } + } + }); + } + drawEventVO.setGridIncidentList(eventResultList); + drawEventVO.setLeftDownStatisticsVO(leftDownStatisticsVO); + + // 查询所有小区 + List<CivilVillageStatisticsVO> villageStatisticsList = + this.baseMapper.getCivilScreenVillageList(eventListDTO.getCommunityId()); + if (!villageStatisticsList.isEmpty()) { + villageStatisticsList.forEach(village -> { + // 判断绘制的图形类型 + if (eventListDTO.getType().equals(ScreenDrawEventListDTO.type.yx)) { + // 判断这个点是否在圆形范围内 + if (GisPointUtil.isInCircle(eventListDTO.getCenterLng(), eventListDTO.getCenterLat(), + Double.parseDouble(village.getLng()), Double.parseDouble(village.getLat()), + eventListDTO.getRadius())) { + villageResultList.add(village); + ScreenDrawEventPopulationTotalVO populationTotalVO = + this.baseMapper.getVillagePopulationTotal(village.getVillageId()); + if (populationTotalVO != null) { + drawEventPopulationTotalVO + .setVillageTotal(drawEventPopulationTotalVO.getVillageTotal() + 1); + drawEventPopulationTotalVO + .setPopulationTotal(drawEventPopulationTotalVO.getPopulationTotal() + + populationTotalVO.getPopulationTotal()); + drawEventPopulationTotalVO.setLocalTotal( + drawEventPopulationTotalVO.getLocalTotal() + populationTotalVO.getLocalTotal()); + drawEventPopulationTotalVO.setOutTotal( + drawEventPopulationTotalVO.getOutTotal() + populationTotalVO.getOutTotal()); + drawEventPopulationTotalVO.setSpecialTotal( + drawEventPopulationTotalVO.getSpecialTotal() + populationTotalVO.getSpecialTotal()); + drawEventPopulationTotalVO.setBuildTotal( + drawEventPopulationTotalVO.getBuildTotal() + populationTotalVO.getBuildTotal()); + } + } + } else {// 多边形类型 + if (GisPointUtil.isInPolygon(Double.parseDouble(village.getLng()), + Double.parseDouble(village.getLat()), eventListDTO.getLngLatList())) { + villageResultList.add(village); + ScreenDrawEventPopulationTotalVO populationTotalVO = + this.baseMapper.getVillagePopulationTotal(village.getVillageId()); + if (populationTotalVO != null) { + drawEventPopulationTotalVO + .setVillageTotal(drawEventPopulationTotalVO.getVillageTotal() + 1); + drawEventPopulationTotalVO + .setPopulationTotal(drawEventPopulationTotalVO.getPopulationTotal() + + populationTotalVO.getPopulationTotal()); + drawEventPopulationTotalVO.setLocalTotal( + drawEventPopulationTotalVO.getLocalTotal() + populationTotalVO.getLocalTotal()); + drawEventPopulationTotalVO.setOutTotal( + drawEventPopulationTotalVO.getOutTotal() + populationTotalVO.getOutTotal()); + drawEventPopulationTotalVO.setSpecialTotal( + drawEventPopulationTotalVO.getSpecialTotal() + populationTotalVO.getSpecialTotal()); + drawEventPopulationTotalVO.setBuildTotal( + drawEventPopulationTotalVO.getBuildTotal() + populationTotalVO.getBuildTotal()); + } + } + } + }); + } + + drawEventVO.setVillageStatisticsList(villageResultList); + drawEventVO.setDrawEventPopulationTotalVO(drawEventPopulationTotalVO); + return R.ok(drawEventVO); + } + + /** + * 大屏-根据小区id查询小区统计人数 + * + * @param villageId + * 小区id + * @return 小区统计数据 + */ + @Override + public R civilVillageStatistics(Long villageId) { + ScreenDrawEventPopulationTotalVO result = this.baseMapper.getVillagePopulationTotal(villageId); + result.setVillageTotal(1); + return R.ok(result); + } + + /** + * 查询所有网格员工作汇总数据 + * + * @param statisticsAdminDTO + * 请求参数 + * @return 网格员工作汇总数据 + */ + @Override + public R gridMemberStatisticsAll(MemberStatisticsAdminDTO statisticsAdminDTO) { + return R.ok(eventGridMemberRelationMapper.gridMemberStatisticsAll(statisticsAdminDTO)); + } } -- Gitblit v1.7.1