From ffcd3e31c9938eb256d616c80edbe1821e9fb2bf Mon Sep 17 00:00:00 2001 From: huanghongfa <huanghongfa123456> Date: 星期五, 02 七月 2021 16:15:34 +0800 Subject: [PATCH] 综治后台小区模块接口 --- springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java | 1316 ++++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 1,105 insertions(+), 211 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 9a60096..3459971 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,36 +1,40 @@ package com.panzhihua.service_grid.service.impl; +import cn.hutool.core.date.DateTime; +import cn.hutool.core.date.DateUtil; +import cn.hutool.core.util.IdcardUtil; 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.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.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.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 com.panzhihua.service_grid.service.*; import lombok.extern.slf4j.Slf4j; -import org.springframework.stereotype.Service; import org.springframework.beans.BeanUtils; +import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import org.springframework.util.CollectionUtils; import javax.annotation.Resource; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; +import java.text.SimpleDateFormat; +import java.util.*; /** * @author cedoo @@ -51,23 +55,38 @@ 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; + private final String moth_format_str = "yyyy-MM"; + + private final String[] monthStr = new String[]{"一","二","三","四","五","六","七","八","九","十","十一","十二"}; /** * 分页查找事件 + * * @param pageEventDTO * @return 维护结果 */ - public R<IPage<EventVO>> query(PageEventDTO pageEventDTO){ - Page page = new Page(1,10); - if(pageEventDTO.getPageNum()!=null) { + @Override + 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 = @@ -79,7 +98,7 @@ 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); @@ -103,7 +122,7 @@ //查询网格员头像 String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); - if(StringUtils.isNotEmpty(imageUrl)){ + if (StringUtils.isNotEmpty(imageUrl)) { eventVO.setGridMemberImageUrl(imageUrl); } }); @@ -114,37 +133,42 @@ /** * 删除事件 + * * @param commonEventDeleteDTO * @return 平台用户信息 */ - public R delete(CommonEventDeleteDTO commonEventDeleteDTO){ + @Override + 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)){//草稿 或者 已撤销 的事件可以删除 + 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 * @return 查找结果 */ - public R<EventDetailsVO> eventDetails(Long id){ + @Override + 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()); } //查询事件关联附件 @@ -157,7 +181,7 @@ 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); @@ -180,7 +204,6 @@ eventDetailsVO.setVideos(videoList); - //查询事件流转记录 List<EventTransferRecordDO> eventTransferRecordDOList = eventTransferRecordService.getBaseMapper() .selectList(new LambdaQueryWrapper<EventTransferRecordDO>() @@ -201,7 +224,7 @@ 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); @@ -226,12 +249,29 @@ } eventDetailsVO.setTrans(eventTransferRecordVOS); - //查询事件发布人头像 - String imageUrl = eventMapper.getGridMemberImageUrl(eventDO.getGridMemberId()); - if(StringUtils.isNotEmpty(imageUrl)){ - eventDetailsVO.setGridMemberImageUrl(imageUrl); + //查询网格员头像,姓名 + Map<String,Object> gridMember = eventMapper.getUserBaseInfo(eventDO.getGridMemberId()); + if (!CollectionUtils.isEmpty(gridMember)) { + eventDetailsVO.setGridMemberName(gridMember.get("name") == null ? "" : gridMember.get("name").toString()); + eventDetailsVO.setGridMemberImageUrl(gridMember.get("image_url") == null ? "" : gridMember.get("image_url").toString()); + } + if(Objects.equals(eventDO.getGridMemberId(),eventDO.getCreateBy())){ + eventDetailsVO.setCreator(eventDetailsVO.getGridMemberName()); + }else{ + Map<String,Object> createUser = eventMapper.getUserBaseInfo(eventDO.getCreateBy()); + eventDetailsVO.setCreator(createUser.get("name") == null ? "" : createUser.get("name").toString()); } + //当事件为特殊人群上报时,需要查询事件与人口关联关系 + if(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("事件不存在"); @@ -242,12 +282,24 @@ public R addCommon(CommonEventAddDTO commonEventAddDTO) { EventDO eventDO = new EventDO(); BeanUtils.copyProperties(commonEventAddDTO, eventDO); - if(commonEventAddDTO instanceof CommonEventCommunityAddDTO) { - CommonEventCommunityAddDTO commonEventCommunityAddDTO = (CommonEventCommunityAddDTO)commonEventAddDTO; + 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) { + return R.fail("网格不存在"); + } + + //检查特殊人群上报时参数 + 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);//网格员处理 @@ -257,9 +309,25 @@ eventDO.setGridMemberTelephone(commonEventAddDTO.getPhone()); eventDO.setCreateBy(commonEventAddDTO.getUserId()); eventDO.setSubmitDate(new Date()); - if(eventMapper.insert(eventDO)==1){ + eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); + if (eventMapper.insert(eventDO) == 1) { + + //如果是特殊人群,则新增特殊人群与事件关系 + if(commonEventAddDTO.getEventType().equals(6)){ + 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())){ + if (StringUtils.isNotEmpty(commonEventAddDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); eventResourceDO.setType(2); @@ -267,13 +335,14 @@ 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); @@ -281,13 +350,14 @@ 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(); @@ -296,8 +366,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("添加图片失败"); } } @@ -311,7 +382,19 @@ @Override @Transactional(rollbackFor = Exception.class) public R saveDraft(CommonEventEditDTO commonEventEditDTO) { - if(commonEventEditDTO.getId()==null) { + EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(commonEventEditDTO.getGridId()); + if (eventGridDataDO == null) { + return R.fail("网格不存在"); + } + + 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()); @@ -325,6 +408,21 @@ eventDO.setGridMemberTelephone(commonEventEditDTO.getPhone()); eventDO.setEventDealStatus(5); if (eventMapper.insert(eventDO) > 0) { + + //如果是特殊人群,则新增特殊人群与事件关系 + if(commonEventEditDTO.getEventType().equals(6)){ + 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(); @@ -372,11 +470,11 @@ 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()); @@ -389,7 +487,7 @@ if (eventMapper.updateById(eventDO) > 0) { int deleted = eventResourceService.getBaseMapper() .delete(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification,1) + .eq(EventResourceDO::getClassification, 1) .eq(EventResourceDO::getRefId, eventDO.getId())); //添加音频 if (StringUtils.isNotEmpty(commonEventEditDTO.getAudio())) { @@ -445,22 +543,22 @@ @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); //社区处理 @@ -470,10 +568,11 @@ 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(); } @@ -482,25 +581,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.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(); @@ -513,12 +614,12 @@ 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("事件当前不可自处理"); @@ -534,14 +635,20 @@ 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){ + addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), 1, "网格员自处理完成", commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), processType); + if (transferRecordDO != null && transferRecordDO.getId() != null) { //添加音频 - if(StringUtils.isNotEmpty(commonEventDealDTO.getAudio())){ + if (StringUtils.isNotEmpty(commonEventDealDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(3); eventResourceDO.setType(2); @@ -550,12 +657,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); @@ -564,12 +671,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(); @@ -579,7 +686,7 @@ eventResourceDO.setRefId(transferRecordDO.getId()); eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(picAdd!=1){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -589,12 +696,12 @@ 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("处理事件记录出错"); } } @@ -603,31 +710,33 @@ @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.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, "事件验证完成"); + 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() == 7|eventDO.getEventDealStatus() == 5; //已失效状态 + if (!canRepublishByUser) { + return R.fail("当前不是撤销/草稿状态"); } eventDO.setEventStatus(2);//2 发布 @@ -635,10 +744,11 @@ eventDO.setProcessType(1); //网格员处理 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(); } @@ -646,27 +756,49 @@ @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.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()); return R.ok(); } + /** + * 生成服务单号 + * + * @param eventType 事件类型,宣传事件默认为20 + * @return + */ + private String getEventOrderSn(Integer eventType) { + SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd"); + 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); + return orderSn; + } + @Override public R saveSpecialDraft(SpecialEventEditDTO specialEventEditDTO) { + EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(specialEventEditDTO.getGridId()); + 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()); @@ -725,7 +857,7 @@ rtVal = R.ok(); } rtVal = R.fail(); - }else{ + } else { //编辑原来的 EventDO eventDO = eventMapper.selectById(specialEventEditDTO.getId()); BeanUtils.copyProperties(specialEventEditDTO, eventDO); @@ -739,7 +871,7 @@ if (eventMapper.updateById(eventDO) > 0) { int deleted = eventResourceService.getBaseMapper() .delete(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification,1) + .eq(EventResourceDO::getClassification, 1) .eq(EventResourceDO::getRefId, eventDO.getId())); //添加音频 if (StringUtils.isNotEmpty(specialEventEditDTO.getAudio())) { @@ -789,7 +921,7 @@ } rtVal = R.fail(); } - if(R.isOk(rtVal)){ + if (R.isOk(rtVal)) { //TODO 处理特殊人群实有人口数据 } @@ -798,6 +930,10 @@ @Override public R addSpecial(SpecialEventAddDTO specialEventAddDTO) { + EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(specialEventAddDTO.getGridId()); + if (eventGridDataDO == null) { + return R.fail("网格不存在"); + } R rtVal = R.fail(); EventDO eventDO = new EventDO(); BeanUtils.copyProperties(specialEventAddDTO, eventDO); @@ -808,6 +944,7 @@ 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())) { @@ -857,7 +994,7 @@ } rtVal = R.fail(); - if(R.isOk(rtVal)){ + if (R.isOk(rtVal)) { //TODO 处理特殊人群实有人口数据 addReleaseRecord(eventDO.getId(), specialEventAddDTO.getUserId(), specialEventAddDTO.getUserName()); @@ -877,18 +1014,28 @@ @Override public R addPublicity(PublicityEventAddDTO publicityEventAddDTO) { + EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(publicityEventAddDTO.getGridId()); + if (eventGridDataDO == null) { + return R.fail("网格不存在"); + } EventDO eventDO = new EventDO(); BeanUtils.copyProperties(publicityEventAddDTO, eventDO); eventDO.setGridMemberId(publicityEventAddDTO.getUserId()); eventDO.setEventCategory(2l);//宣传事件 eventDO.setEventStatus(2);//事件状态 2发布 - eventDO.setGridMemberId(publicityEventAddDTO.getUserId()); + eventDO.setEventType(8); + 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()); - if(eventMapper.insert(eventDO)==1){ + eventDO.setOrderSn(getEventOrderSn(eventDO.getEventType())); + if (eventMapper.insert(eventDO) == 1) { //添加音频 - if(StringUtils.isNotEmpty(publicityEventAddDTO.getAudio())){ + if (StringUtils.isNotEmpty(publicityEventAddDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(1); eventResourceDO.setType(2); @@ -897,12 +1044,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); @@ -911,12 +1058,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(); @@ -926,7 +1073,7 @@ eventResourceDO.setRefId(eventDO.getId()); eventResourceDO.setCreateBy(publicityEventAddDTO.getUserId()); int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(picAdd!=1){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -940,7 +1087,11 @@ @Override public R savePublicityDraft(PublicityEventEditDTO publicityEventEditDTO) { - if(publicityEventEditDTO.getId()==null) { + EventGridDataDO eventGridDataDO = eventGridDataMapper.selectById(publicityEventEditDTO.getGridId()); + if (eventGridDataDO == null) { + return R.fail("网格不存在"); + } + if (publicityEventEditDTO.getId() == null) { EventDO eventDO = new EventDO(); BeanUtils.copyProperties(publicityEventEditDTO, eventDO); eventDO.setGridMemberId(publicityEventEditDTO.getUserId()); @@ -951,6 +1102,7 @@ eventDO.setGridMemberName(publicityEventEditDTO.getUserName()); eventDO.setGridMemberTelephone(publicityEventEditDTO.getPhone()); eventDO.setEventDealStatus(5);//草稿状态 + eventDO.setEventType(8); if (eventMapper.insert(eventDO) > 0) { //添加音频 if (StringUtils.isNotEmpty(publicityEventEditDTO.getAudio())) { @@ -999,11 +1151,11 @@ 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()); @@ -1016,7 +1168,7 @@ if (eventMapper.updateById(eventDO) > 0) { int deleted = eventResourceService.getBaseMapper() .delete(new LambdaQueryWrapper<EventResourceDO>() - .eq(EventResourceDO::getClassification,1) + .eq(EventResourceDO::getClassification, 1) .eq(EventResourceDO::getRefId, eventDO.getId())); //添加音频 if (StringUtils.isNotEmpty(publicityEventEditDTO.getAudio())) { @@ -1070,15 +1222,15 @@ @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 = @@ -1090,7 +1242,7 @@ 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); @@ -1111,6 +1263,11 @@ eventVO.setAudios(audioList); eventVO.setPics(picList); eventVO.setVideos(videoList); + //查询网格员头像 + String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); + if (StringUtils.isNotEmpty(imageUrl)) { + eventVO.setGridMemberImageUrl(imageUrl); + } }); return R.ok(ipage); } @@ -1125,15 +1282,15 @@ @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 = @@ -1145,7 +1302,7 @@ 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); @@ -1169,7 +1326,7 @@ //查询网格员头像 String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); - if(StringUtils.isNotEmpty(imageUrl)){ + if (StringUtils.isNotEmpty(imageUrl)) { eventVO.setGridMemberImageUrl(imageUrl); } }); @@ -1181,21 +1338,37 @@ @Override public R markEventInvalid(EventRevokeDTO eventRevokeDTO) { EventDO eventDO = this.getBaseMapper().selectById(eventRevokeDTO.getId()); - if(eventDO==null){ + if (eventDO == null) { return R.fail("事件不存在"); } - boolean canRevoke = eventDO.getEventDealStatus()==3; //发布状态 - if(!canRevoke){ - return R.fail("当前事件不是上报状态,不允许标为无效"); + if (eventDO.getEventCategory() != null) { + if (eventDO.getEventCategory() == 1) { + boolean canRevoke = eventDO.getEventDealStatus() == 3; //上报状态 + if (!canRevoke) { + return R.fail("当前事件不是上报状态,不允许撤销"); + } + } else if (eventDO.getEventCategory() == 2) { + boolean canRevoke = eventDO.getEventDealStatus() == 8; //发布状态 + if (!canRevoke) { + return R.fail("当前事件不是发布状态,不允许撤销"); + } + } else { + return R.fail(""); + } + } else { + return R.fail("事件所属错误"); } eventDO.setInvalid(false); + //标为无效后, 交给网格员处理 eventDO.setUpdateBy(eventRevokeDTO.getUserId()); eventDO.setEventStatus(4);//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(); @@ -1204,17 +1377,18 @@ @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; //已失效状态 + if (!canRepulish) { + return R.fail("当前事件不是已失效状态/草稿状态,不能重新发布"); } eventDO.setInvalid(true); 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(); @@ -1227,14 +1401,32 @@ return R.fail("事件不存在"); } boolean canDealByCommunity = eventDO.getEventDealStatus() == 3; - if(!canDealByCommunity){ + if (!canDealByCommunity) { return R.fail("事件当前不是上报状态"); } - if(commonEventDealDTO.getNeedVerify()){ + 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 { + } else { eventDO.setEventProcessStatus(2);//2已解决 } eventDO.setUpdateBy(commonEventDealDTO.getUserId()); @@ -1246,14 +1438,15 @@ 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){ + addTransferRecord(eventDO.getId(), commonEventDealDTO.getUserId(), commonEventDealDTO.getUserName(), 1, + "社区处理完成", commonEventDealDTO.getCommunityId(), commonEventDealDTO.getCommunityName(), 3); + if (transferRecordDO != null && transferRecordDO.getId() != null) { //添加音频 - if(StringUtils.isNotEmpty(commonEventDealDTO.getAudio())){ + if (StringUtils.isNotEmpty(commonEventDealDTO.getAudio())) { EventResourceDO eventResourceDO = new EventResourceDO(); eventResourceDO.setClassification(3); eventResourceDO.setType(2); @@ -1262,12 +1455,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); @@ -1276,12 +1469,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(); @@ -1291,7 +1484,7 @@ eventResourceDO.setRefId(transferRecordDO.getId()); eventResourceDO.setCreateBy(commonEventDealDTO.getUserId()); int picAdd = eventResourceService.getBaseMapper().insert(eventResourceDO); - if(picAdd!=1){ + if (picAdd != 1) { throw new ServiceException("添加图片失败"); } } @@ -1300,23 +1493,73 @@ 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.setCurrent(pagePublicityEventDTO.getPageNum()); + } + if (pagePublicityEventDTO.getPageSize() != null) { + page.setSize(pagePublicityEventDTO.getPageSize()); + } + IPage<EventVO> ipage = eventMapper.findCommunityPublicityByPage(page, pagePublicityEventDTO); + 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()) + ); + 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; + } + }); + eventVO.setAudios(audioList); + eventVO.setPics(picList); + eventVO.setVideos(videoList); + }); + return R.ok(ipage); + } + return R.fail(); + } + /** * 添加发布事件流转记录 - * @param eventId 事件ID - * @param userId 操作用户ID + * + * @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); @@ -1327,13 +1570,56 @@ 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); return eventTransferRecordDO; } + + + /** + * 查询最后的流转记录,并添加事件流转记录 + * + * @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, 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(); + 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) { + this.updateEventDealStatus(eventId); + return eventTransferRecordDO; + } else { + throw new ServiceException("事件流转记录添加失败"); + } + } + /** * 查询最后的流转记录,并添加事件流转记录 @@ -1344,84 +1630,692 @@ * @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); - EventTransferRecordDO eventTransferRecordDO = new EventTransferRecordDO(); - 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); - int inserted = eventTransferRecordService.getBaseMapper().insert(eventTransferRecordDO); - if(inserted==1) { - this.updateEventDealStatus(eventId); - return eventTransferRecordDO; - }else{ - throw new ServiceException("事件流转记录添加失败"); - } - } + /* 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){ + 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 事件 */ - private Integer getEventDealStatus(EventDO eventDO){ - Integer event_status = eventDO.getEventStatus(); - Integer event_process_status = eventDO.getEventProcessStatus(); - Integer process_type = eventDO.getProcessType(); - Integer community_process = eventDO.getCommunityProcess(); + 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 eventDealStatus = -1; - //1 待处理、2 待验证、3 已上报、4 已解决、5 草稿箱、6已撤销、7已失效 - if(eventDO.getInvalid()!=null && eventDO.getInvalid()==false){ - eventDealStatus = 7;//7已失效 - }else if(event_status!=null && event_status ==2 && event_process_status!=null && event_process_status == 1 - && process_type!=null && process_type == 1) { - eventDealStatus = 1;//"待处理" - }else if( event_process_status!=null && event_process_status == 3) { - eventDealStatus = 2;//"待验证" - }else if(event_status!=null && event_status == 2 && community_process!=null - && community_process == 1 && process_type!=null && process_type == 2) { - eventDealStatus=3;//"已上报" - }else if( event_process_status!=null && event_process_status == 2 ) { - eventDealStatus=4;//"已解决" - }else if( event_status!=null && event_status == 1 ) { - eventDealStatus = 5;//"草稿箱" - }else if( event_status!=null && event_status == 4 ) { - eventDealStatus=6;//"已撤销" + Integer eventDealStatus = -1; + /*if (eventDO.getInvalid() != null && eventDO.getInvalid() == false) { + eventDealStatus = 7; + //7已失效 + }*/ + if (event_status == 1) { + eventDealStatus = 5; + //"草稿箱" + } else if (event_status == 4) { + eventDealStatus = 6; + //"已撤销" + } else if (event_status == 2) { + if (event_process_status == 3) { + eventDealStatus = 2; + //"待验证" + } else if (event_process_status == 2) { + eventDealStatus = 4; + //"已解决" + } else if (community_process == 1 && process_type == 2) { + eventDealStatus = 3; + //"已上报" + } 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 eventDealStatus; + 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 eventStatistics(Long communityId){ - return R.ok(this.baseMapper.eventStatistics(communityId)); + 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.getEventStatus().intValue() == 1 || eventDO.getEventStatus().intValue() == 4)) {//草稿 或者 已撤销 的事件可以删除 + 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){ + return R.ok(this.baseMapper.getGridEventStatisticsByApp(gridId)); + } + + /** + * 查询网格事件统计数据 + * @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); + } + + //统计数据 + 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 -> { + specialPopulation.setAge(IdcardUtil.getAgeByIdCard(specialPopulation.getIdCard())); + }); + } + 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)); + if(flag>0){ + return true; + } + return false; + } + + 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("currentNum")== null ? 0L : Long.valueOf(countMap.get("currentNum").toString())); + } + + //计算处理时间消耗的时间 + 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.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); + 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:58"); + dateList.add(eventWorkVO); + EventWorkVO eventWorkVO1 = new EventWorkVO(); + eventWorkVO1.setMonth(monthStr[m]+"月下旬"); + eventWorkVO1.setStart(month+ "-"+half+" 23:59:58"); + eventWorkVO1.setEnd(DateUtils.getDateFormatString(endDay,"yyyy-MM-dd HH:mm:ss")); + dateList.add(eventWorkVO1); + } + return dateList; + + } + + public static void main(String[] args) { + String content = "30,104"; + String re = "[1-9][0-9](\\.[0-9]{1,6})?,[1-9][0-9]{2}(\\.[0-9]{1,6})?"; + + System.out.println(content.matches(re)); + } + } -- Gitblit v1.7.1