From 566e7986291e73051d30ee252b0ebf852b1577a7 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Tue, 02 Apr 2024 14:25:51 +0800
Subject: [PATCH] 娱乐场所标签新增180200
---
src/main/java/org/springblade/modules/police/service/impl/PoliceAffairsGridServiceImpl.java | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 57 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/police/service/impl/PoliceAffairsGridServiceImpl.java b/src/main/java/org/springblade/modules/police/service/impl/PoliceAffairsGridServiceImpl.java
index 0aa5264..6774fad 100644
--- a/src/main/java/org/springblade/modules/police/service/impl/PoliceAffairsGridServiceImpl.java
+++ b/src/main/java/org/springblade/modules/police/service/impl/PoliceAffairsGridServiceImpl.java
@@ -1,12 +1,25 @@
package org.springblade.modules.police.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.core.secure.utils.AuthUtil;
+import org.springblade.core.tool.utils.BeanUtil;
+import org.springblade.core.tool.utils.SpringUtil;
import org.springblade.modules.police.entity.PoliceAffairsGridEntity;
+import org.springblade.modules.police.entity.PoliceStationEntity;
+import org.springblade.modules.police.excel.PoliceAffairsGridExcel;
+import org.springblade.modules.police.excel.PoliceStationExcel;
+import org.springblade.modules.police.service.IPoliceStationService;
import org.springblade.modules.police.vo.PoliceAffairsGridVO;
import org.springblade.modules.police.mapper.PoliceAffairsGridMapper;
import org.springblade.modules.police.service.IPoliceAffairsGridService;
+import org.springblade.modules.system.entity.User;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;
+
+import java.util.Date;
+import java.util.List;
+import java.util.Objects;
/**
* 警务网格（辖区）表 服务实现类
@@ -22,5 +35,49 @@
return page.setRecords(baseMapper.selectPoliceAffairsGridPage(page, policeAffairsGrid));
}
+ /**
+ * 导入警务辖区数据
+ * @param data
+ * @param isCovered
+ */
+ @Override
+ public void importPoliceAffairsGrid(List<PoliceAffairsGridExcel> data, Boolean isCovered) {
+ for (PoliceAffairsGridExcel policeAffairsGridExcel : data) {
+ PoliceAffairsGridEntity policeAffairsGridEntity
+ = Objects.requireNonNull(BeanUtil.copy(policeAffairsGridExcel, PoliceAffairsGridEntity.class));
+ // 查询派出所对应的编号
+ QueryWrapper<PoliceStationEntity> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("is_deleted",0).eq("name",policeAffairsGridExcel.getPcsName());
+ PoliceStationEntity stationEntity = SpringUtil.getBean(IPoliceStationService.class).getOne(queryWrapper);
+ if (null!=stationEntity){
+ policeAffairsGridEntity.setPcsCode(stationEntity.getCode());
+ }
+ policeAffairsGridEntity.setCreateUser(AuthUtil.getUserId());
+ policeAffairsGridEntity.setCreateTime(new Date());
+ policeAffairsGridEntity.setUpdateUser(AuthUtil.getUserId());
+ policeAffairsGridEntity.setUpdateTime(new Date());
+ // 新增
+ save(policeAffairsGridEntity);
+ }
+ }
+ /**
+ * 空间分析
+ * @param point
+ * @return
+ */
+ @Override
+ public List<PoliceAffairsGridEntity> spatialAnalysis(String point) {
+ return baseMapper.spatialAnalysis(point);
+ }
+
+ /**
+ * 查询对应的社区编号
+ * @param userId
+ * @return
+ */
+ @Override
+ public List<String> getCommunityCodeListByUserId(Long userId) {
+ return baseMapper.getCommunityCodeListByUserId(userId.toString());
+ }
}
--
Gitblit v1.9.3