From 41b7f1c314b68ee37de6e71ac0a4695344a13633 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Fri, 19 Jan 2024 08:56:14 +0800
Subject: [PATCH] 城市编码替换
---
src/main/java/org/springblade/modules/house/mapper/UserHouseLabelMapper.xml | 2 +-
src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml
index d859087..981f7ee 100644
--- a/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml
+++ b/src/main/java/org/springblade/modules/grid/mapper/GridMapper.xml
@@ -114,7 +114,7 @@
parent_code as parentId,
name
FROM blade_region
- where district_code = '361102'
+ where district_code = '361102000000'
union all
(select id,
community_code as parentId,
diff --git a/src/main/java/org/springblade/modules/house/mapper/UserHouseLabelMapper.xml b/src/main/java/org/springblade/modules/house/mapper/UserHouseLabelMapper.xml
index d9f3a63..193e7cf 100644
--- a/src/main/java/org/springblade/modules/house/mapper/UserHouseLabelMapper.xml
+++ b/src/main/java/org/springblade/modules/house/mapper/UserHouseLabelMapper.xml
@@ -193,7 +193,7 @@
`blade_region` br
WHERE
br.region_level = 4
- AND br.city_code = 3611
+ AND br.city_code = 361100000000
</select>
--
Gitblit v1.9.3