调整年龄条件

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())