调整年龄条件

zhangzengfei

2024-12-20 9dfba3021eb74fad6d70adcad028b7d530893d32

调整年龄条件

 models/disappear.go

@@ -101,10 +101,10 @@
            s.community_id,
            s.org_id,
            p.person_name,
            p.id_card ,
            p.id_card,
            s.last_appearance_time,
            s.last_direction,
            s.last_location
            s.last_location 
        FROM
            snapshot_count_summary AS s
            JOIN person AS p ON p.id = s.document_number 
@@ -114,11 +114,13 @@
            AND TIMESTAMPDIFF(
                YEAR,
                STR_TO_DATE( CASE WHEN LENGTH( id_card ) = 18 THEN SUBSTRING( id_card, 7, 8 ) ELSE NULL END, '%Y%m%d' ),
            CURDATE( ) >= ?
            AND TIMESTAMPDIFF(
                CURDATE( ) 
            ) >= ? 
            AND TIMESTAMPDIFF(
                YEAR,
                STR_TO_DATE( CASE WHEN LENGTH( id_card ) = 18 THEN SUBSTRING( id_card, 7, 8 ) ELSE NULL END, '%Y%m%d' ),
            CURDATE( ) <= ?
            CURDATE( ) 
            ) <= ?
        `, m.MinAge, m.MaxAge).Scan(&ageFilter).Error
        if err != nil {
            logger.Warnf(err.Error())