zhangzengfei
2024-12-20 a25ee90c656b39e652f24e3378ad2bf5698b162b
db/task_results.go
@@ -2,24 +2,25 @@
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
   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);"`                                        // 楼层
}
@@ -69,6 +70,11 @@
   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
@@ -97,6 +103,10 @@
      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)