| | |
| | | JOIN person AS p ON p.id = s.document_number |
| | | WHERE |
| | | p.id_card != "" |
| | | AND (p.community_id IN ? |
| | | OR p.org_id IN ?) |
| | | AND p.status IN ? |
| | | AND (s.community_id IN ? |
| | | OR s.org_id IN ?) |
| | | AND s.status IN ? |
| | | `, m.AreaIds, m.OrgIds, m.PersonIdentity).Scan(&baseFilter).Error |
| | | if err != nil { |
| | | logger.Warnf(err.Error()) |
| | | } |
| | | |
| | | if len(baseFilter) == 0 { |
| | | return fmt.Errorf("no results found that match the age condition %s - %s ", m.AreaIds, m.OrgIds) |
| | | return fmt.Errorf("no results found that match the age condition %s - %s - %s ", m.AreaIds, m.OrgIds, m.PersonIdentity) |
| | | } |
| | | |
| | | logger.Debugf("task %s match age result %d", m.Task.Name, len(baseFilter)) |