From ae4e620514b1c1baf94cef706d16c5385fdff837 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Mon, 09 Feb 2026 15:04:42 +0800
Subject: [PATCH] 查询飞手优化
---
drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/service/impl/GdFlyerServiceImpl.java | 50 ++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 48 insertions(+), 2 deletions(-)
diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/service/impl/GdFlyerServiceImpl.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/service/impl/GdFlyerServiceImpl.java
index 315a327..3f97cda 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/service/impl/GdFlyerServiceImpl.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/service/impl/GdFlyerServiceImpl.java
@@ -16,7 +16,11 @@
*/
package org.sxkj.gd.flyer.service.impl;
+import org.springblade.core.secure.utils.AuthUtil;
+import org.springblade.core.tool.utils.StringUtil;
+import org.sxkj.common.utils.HeaderUtils;
import org.sxkj.gd.flyer.entity.GdFlyerEntity;
+import org.sxkj.gd.flyer.param.GdFlyerPageParam;
import org.sxkj.gd.flyer.vo.GdFlyerVO;
import org.sxkj.gd.flyer.excel.GdFlyerExcel;
import org.sxkj.gd.flyer.mapper.GdFlyerMapper;
@@ -25,6 +29,10 @@
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.core.mp.base.BaseServiceImpl;
+import org.sxkj.gd.utils.GdGeoAddressUtil;
+import org.sxkj.system.cache.SysCache;
+
+import java.util.ArrayList;
import java.util.List;
/**
@@ -37,7 +45,21 @@
public class GdFlyerServiceImpl extends BaseServiceImpl<GdFlyerMapper, GdFlyerEntity> implements IGdFlyerService {
@Override
- public IPage<GdFlyerVO> selectGdFlyerPage(IPage<GdFlyerVO> page, GdFlyerVO gdFlyer) {
+ public IPage<GdFlyerVO> selectGdFlyerPage(IPage<GdFlyerVO> page, GdFlyerPageParam gdFlyer) {
+ if (!AuthUtil.isAdministrator()) {
+ List<Long> deptList = SysCache.getDeptChildIds(Long.valueOf(AuthUtil.getDeptId()));
+ gdFlyer.setDeptList(deptList);
+ }
+ // 通过经纬度获取行政区划
+ if (StringUtil.isNotBlank(gdFlyer.getLongitude()) && StringUtil.isNotBlank(gdFlyer.getLatitude())) {
+ String areaCode = GdGeoAddressUtil.getCountyCode(Double.valueOf(gdFlyer.getLongitude()), Double.valueOf(gdFlyer.getLatitude()));
+ // 去掉前面三位数字
+ if (areaCode != null && areaCode.length() > 3) {
+ areaCode = areaCode.substring(3);
+ }
+ gdFlyer.setAreaCode(HeaderUtils.fillZero(areaCode));
+ }
+
return page.setRecords(baseMapper.selectGdFlyerPage(page, gdFlyer));
}
@@ -45,10 +67,34 @@
@Override
public List<GdFlyerExcel> exportGdFlyer(Wrapper<GdFlyerEntity> queryWrapper) {
List<GdFlyerExcel> gdFlyerList = baseMapper.exportGdFlyer(queryWrapper);
- //gdFlyerList.forEach(gdFlyer -> {
+ // gdFlyerList.forEach(gdFlyer -> {
// gdFlyer.setTypeName(DictCache.getValue(DictEnum.YES_NO, GdFlyer.getType()));
//});
return gdFlyerList;
}
+ /**
+ * 新增或修改
+ * @param convert 飞手实体对象
+ * @return 保存或更新成功返回true，失败返回false
+ */
+ @Override
+ public boolean saveOrUpdateFlyer(GdFlyerEntity convert) {
+ // 步骤1：校验电话号码是否为空
+ if (StringUtil.isNotBlank(convert.getFlyerPhone())) {
+ // 步骤2：查询数据库中是否存在相同电话号码的记录
+ Long count = baseMapper.selectCount(
+ new com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper<GdFlyerEntity>()
+ .eq(GdFlyerEntity::getFlyerPhone, convert.getFlyerPhone())
+ .ne(convert.getId() != null, GdFlyerEntity::getId, convert.getId())
+ );
+ // 步骤3：如果存在重复的电话号码，抛出异常
+ if (count > 0) {
+ throw new RuntimeException("电话号码已存在，请使用其他电话号码");
+ }
+ }
+ convert.setAreaCode(HeaderUtils.processAreaCode(convert.getRegionCode()));
+ // 步骤4：执行保存或更新操作
+ return saveOrUpdate(convert);
+ }
}
--
Gitblit v1.9.3