From ccca3f92e450392072f64f7781e6a25162ca81b0 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Thu, 29 Feb 2024 10:46:43 +0800
Subject: [PATCH] 场所新增地址编码绑定初始化接口
---
src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java b/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java
index d98abca..26bf66c 100644
--- a/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java
+++ b/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java
@@ -1419,4 +1419,33 @@
}
return null;
}
+
+ /**
+ * 场所二维码绑定处理
+ */
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public Object placeDoorBindHandle() {
+ // 查询对应未的场所 house_code_binds 为空，source = 1 的
+ List<PlaceEntity> list = baseMapper.selectPlaceNotDoorBindList();
+ // 遍历
+ for (PlaceEntity placeEntity : list) {
+ // 更新
+ placeEntity.setHouseCodeBinds(placeEntity.getHouseCode());
+ updateById(placeEntity);
+ // 查询绑定关系是否已存在
+ QueryWrapper<PlaceDoorEntity> wrapper = new QueryWrapper<>();
+ wrapper.eq("house_code",placeEntity.getHouseCode()).eq("place_id",placeEntity.getId());
+ // 查询
+ PlaceDoorEntity one = placeDoorService.getOne(wrapper);
+ if (null==one){
+ // 新增
+ PlaceDoorEntity placeDoorEntity = new PlaceDoorEntity();
+ placeDoorEntity.setPlaceId(placeEntity.getId());
+ placeDoorEntity.setHouseCode(placeEntity.getHouseCode());
+ placeDoorService.save(placeDoorEntity);
+ }
+ }
+ return null;
+ }
}
--
Gitblit v1.9.3