zhaoqingang
2025-02-19 fca319958029fa924308e50cb61202d7d6ff5008
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
package db
 
type SnapshotCountSummary struct {
    OrgId                    string  `gorm:"column:org_id"`                      // 派出所id
    CommunityID              string  `gorm:"column:community_id"`                // 小区id
    DocumentNumber           string  `gorm:"column:document_number"`             // 档案编号
    DaysAppeared             int     `gorm:"column:days_appeared"`               // 出现天数
    Count                    int     `gorm:"column:count"`                       // 抓拍次数
    Status                   string  `gorm:"column:status"`                      // 标签
    LastAppearanceTime       int64   `gorm:"column:last_appearance_time"`        // 最后出现时间
    LastAppearanceStatusTime int64   `gorm:"column:last_appearance_status_time"` // 最后出现时间
    LastLocation             string  `gorm:"column:last_location"`               // 最后出现地点
    Building                 string  `gorm:"column:building"`                    // 楼栋号
    Floor                    string  `gorm:"column:floor"`                       // 楼层
    FrequentAddress          string  `gorm:"column:frequent_address"`            // 常住地址
    IDStatus                 int     `gorm:"type:tinyint;not null;default:2"`    // 1已实名 2未实名
    KeyStatus                int     `gorm:"type:tinyint;not null;default:2"`    // 1重点人员 2 非重点人员
    StatusScore              float64 `gorm:"column:status_score"`                // 居住属性评分
    StatusInitTime           int64   `gorm:"column:status_init_time"`
    LastDirection            string  `gorm:"column:last_direction;type:varchar(255);"` // 最后出现方向
}
 
func (sc *SnapshotCountSummary) TableName() string {
    return "snapshot_count_summary"
}
 
func (sc *SnapshotCountSummary) FindByPersonId(commId, docId string) error {
    return GetDB().Table(sc.TableName()).Where("community_id = ? and document_number = ?", commId, docId).First(sc).Error
}