From dd39847ba992605ef5fe2254140e8bfd8cf04b25 Mon Sep 17 00:00:00 2001 From: zhangzengfei <zhangzengfei@smartai.com> Date: 星期四, 06 二月 2025 14:39:45 +0800 Subject: [PATCH] 修改托管模型 --- models/disappear.go | 3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) diff --git a/models/disappear.go b/models/disappear.go index 542bd0f..c82bfcf 100644 --- a/models/disappear.go +++ b/models/disappear.go @@ -109,8 +109,7 @@ snapshot_count_summary AS s JOIN person AS p ON p.id = s.document_number WHERE - s.STATUS = 'resident' - AND p.id_card != "" + p.id_card != "" AND TIMESTAMPDIFF( YEAR, STR_TO_DATE( CASE WHEN LENGTH( id_card ) = 18 THEN SUBSTRING( id_card, 7, 8 ) ELSE NULL END, '%Y%m%d' ), -- Gitblit v1.8.0