fix: GIS 关键词查询参数与 PostGIS ILIKE 类型 #63

New issue

Closed

opened 2026-11-02 16:16:26 +08:00 by Lijianping · 0 comments

Lijianping commented

2026-11-02 16:16:26 +08:00

Collaborator

目标

修好 /txys/gis/query：前端传参与后端一致，PostGIS 模糊查询可执行。目标仓：backend

范围

jeecg-boot/.../gis/controller/GisController.java
jeecg-boot/.../gis/pg/mapper/GisPgNodeMapper.java
jeecg-boot/.../gis/pg/mapper/GisPgPipeMapper.java

不做

不改 frontend/、app/、gis-cs/、txys-*
不改区面/其它 GIS 业务、不提交 .env/密钥与无关 SQL 补丁

验收

GET /txys/gis/query?q=P0015 成功且不因参数类型报错
GET /txys/gis/query?keyword=P0015 同样可用
结果为编码/名称/备注包含关键字的点线，不因 id 误伤
仅包含上述 3 个文件改动

相关文档

工作区 docs/AI单人开发工作流.md

## 目标修好 `/txys/gis/query`：前端传参与后端一致，PostGIS 模糊查询可执行。目标仓：backend ## 范围 - `jeecg-boot/.../gis/controller/GisController.java` - `jeecg-boot/.../gis/pg/mapper/GisPgNodeMapper.java` - `jeecg-boot/.../gis/pg/mapper/GisPgPipeMapper.java` ## 不做 - 不改 `frontend/`、`app/`、`gis-cs/`、`txys-*` - 不改区面/其它 GIS 业务、不提交 `.env`/密钥与无关 SQL 补丁 ## 验收 - [ ] `GET /txys/gis/query?q=P0015` 成功且不因参数类型报错 - [ ] `GET /txys/gis/query?keyword=P0015` 同样可用 - [ ] 结果为编码/名称/备注包含关键字的点线，不因 id 误伤 - [ ] 仅包含上述 3 个文件改动 ## 相关文档 - 工作区 `docs/AI单人开发工作流.md`

Lijianping added the

labels

2026-11-02 16:16:26 +08:00

Lijianping referenced this issue

2026-11-02 16:16:48 +08:00

fix(#63): 修复 GIS 关键词查询参数与 PostGIS ILIKE 类型 #64

Lijianping referenced this issue from a commit

2026-11-02 16:16:49 +08:00