修改托管模型

zhangzengfei

2025-02-06 dd39847ba992605ef5fe2254140e8bfd8cf04b25

修改托管模型

 db/db.go

@@ -180,13 +180,13 @@
                Alias:    "age",
                Name:     "年龄段",
                Type:     "range",
                Must:     true,
                Must:     false,
                Unit:     "岁",
                Range:    "1,100",
                Value:    "60, 90",
                ValType:  "int",
                Operator: "==",
                Sort:     1,
                Sort:     2,
            },
        },
        {
@@ -203,7 +203,7 @@
                Value:    "",
                ValType:  "string",
                Operator: "==",
                Sort:     2,
                Sort:     1,
            },
        },
    }

 db/task_results.go

@@ -15,13 +15,14 @@
    ModelTaskID   string `json:"modelTaskID" gorm:"type:varchar(255)"`                                         // 模型任务ID
    OrgID         string `json:"orgID" gorm:"index;column:org_id;type:varchar(299);not null;"`                 // 派出所 domain unit ID
    CommunityId   string `json:"communityID" gorm:"index;column:community_id;type:varchar(299);not null;"`     // 小区ID
    PicDate       string `json:"picDate"       gorm:"uniqueIndex:pic_date_first_person_id;type:varchar(255);"` // 抓拍时间
    FirstPersonID string `json:"-" gorm:"uniqueIndex:pic_date_first_person_id;type:varchar(255);"`             // 第一个人的ID
    //PicDate       string `json:"picDate" gorm:"uniqueIndex:pic_date_first_person_id;type:varchar(255);"` // 抓拍时间
    //FirstPersonID string `json:"-" gorm:"uniqueIndex:pic_date_first_person_id;type:varchar(255);"`             // 第一个人的ID
    PicDate       string `json:"picDate" gorm:"type:varchar(255);"`  // 抓拍时间
    FirstPersonID string `json:"-" gorm:"type:varchar(255);"`        // 第一个人的ID
    ObjectIds     string `json:"objectIds" gorm:"type:text"`                                                   // 事件对象，可以是人，多个用逗号分隔
    Location      string `json:"location" gorm:"type:varchar(255)"`                                            // 发生地点
    Building      string `json:"building" gorm:"type:varchar(255);"`                                           // 楼栋
    Floor         string `json:"floor"       gorm:"type:varchar(255);"`                                        // 楼层

}

func (m *ModelTaskResults) TableName() string {

 models/disappear.go

@@ -109,8 +109,7 @@
            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' ),