From c0639a991a40b2aa41f9a0081511aa51940afe2a Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期二, 11 二月 2025 10:22:29 +0800
Subject: [PATCH] 修复sql bug
---
models/accessRegularity.go | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/models/accessRegularity.go b/models/accessRegularity.go
index 3c90fda..98e3197 100644
--- a/models/accessRegularity.go
+++ b/models/accessRegularity.go
@@ -110,14 +110,14 @@
SELECT
document_number,
frequent_address,
- community_id,
+ community_id
FROM
snapshot_count_summary
WHERE
last_appearance_time > ?
- AND (p.community_id IN ?
- OR p.org_id IN ?)
- AND p.status IN ?
+ AND (community_id IN ?
+ OR org_id IN ?)
+ AND status IN ?
`, startDate.Unix(), m.AreaIds, m.OrgIds, m.IdentityType).Scan(&baseFilter).Error
if err != nil {
logger.Warnf(err.Error())
--
Gitblit v1.8.0