| | |
| | | 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' ), |
| | |
| | | } |
| | | |
| | | logger.Debugf("match key person result %d", len(keyFilter)) |
| | | } |
| | | |
| | | if len(lastFilter) > 0 { |
| | | lastFilter = intersectPersonInfo(lastFilter, keyFilter) |
| | | } else { |
| | | lastFilter = keyFilter |
| | | if len(lastFilter) > 0 { |
| | | lastFilter = intersectPersonInfo(lastFilter, keyFilter) |
| | | } else { |
| | | lastFilter = keyFilter |
| | | } |
| | | } |
| | | |
| | | logger.Debugf("last result %d", len(lastFilter)) |
| | |
| | | return service.SaveTaskResults(results) |
| | | } |
| | | |
| | | func (m *DisappearModel) KeepAlive() error { |
| | | db.GetDB().Model(m.Task).Where("id = ?", m.Task.ID).Update("last_run_time", time.Now()) |
| | | return nil |
| | | } |
| | | |
| | | func (m *DisappearModel) Shutdown() error { |
| | | // 清理资源 |
| | | fmt.Println("Shutting down Disappear Model") |