| | |
| | | |
| | | import ( |
| | | "fmt" |
| | | "gorm.io/gorm" |
| | | "time" |
| | | |
| | | "gorm.io/gorm" |
| | | ) |
| | | |
| | | type ModelTaskResults struct { |
| | | BaseModel |
| | | Title string `json:"name" gorm:"type:varchar(255)"` //预警名称,暂时用任务名称 |
| | | Event string `json:"event" gorm:"type:varchar(255)"` //预警事件 |
| | | ModelID string `json:"modelID" gorm:"type:varchar(255)"` //模型ID |
| | | 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 |
| | | 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);"` //楼层 |
| | | |
| | | Title string `json:"name" gorm:"type:varchar(255)"` // 预警名称,暂时用任务名称 |
| | | Event string `json:"event" gorm:"type:varchar(255)"` // 预警事件 |
| | | ModelID string `json:"modelID" gorm:"type:varchar(255)"` // 模型ID |
| | | 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:"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 { |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ModelTaskResultsSearch) SetTaskId(id string) *ModelTaskResultsSearch { |
| | | slf.ModelTaskID = id |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ModelTaskResultsSearch) SetFirstPersonId(firstId string) *ModelTaskResultsSearch { |
| | | slf.FirstPersonID = firstId |
| | | return slf |
| | |
| | | db = db.Where("first_person_id = ?", slf.FirstPersonID) |
| | | } |
| | | |
| | | if slf.ModelTaskID != "" { |
| | | db = db.Where("model_task_id = ?", slf.ModelTaskID) |
| | | } |
| | | |
| | | if slf.Keyword != "" { |
| | | kw := "%" + slf.Keyword + "%" |
| | | db = db.Where("name like ?", kw) |