| | |
| | | "fmt" |
| | | "math" |
| | | "sort" |
| | | "strconv" |
| | | "strings" |
| | | "time" |
| | | |
| | |
| | | |
| | | // 统计查询 |
| | | type StaticRecord struct { |
| | | Id int64 `json:"id"` |
| | | Id string `json:"id"` |
| | | TaskId []int64 `json:"task_id"` |
| | | RuleId []int64 `json:"rule_id"` |
| | | EventLevelId []int64 `json:"event_level_id"` |
| | |
| | | // 知识库 |
| | | type KnowledgeDocumentOption struct { |
| | | Id string `db:"id" json:"id"` |
| | | Title string `db:"file_name" json:"title"` |
| | | Title string `db:"title" json:"title"` |
| | | KnowId int64 `db:"know_id" json:"know_id"` |
| | | FileUrl string `db:"file_name" json:"file_url"` |
| | | FileUrl string `db:"title" json:"file_url"` |
| | | } |
| | | |
| | | // Pagination 分页信息 |
| | |
| | | case "id": |
| | | IdColumn := field.(*entity.ColumnInt64).Data() |
| | | if len(IdColumn) > 0 { |
| | | record.Id = IdColumn[i] |
| | | record.Id = strconv.FormatInt(IdColumn[i], 10) |
| | | } |
| | | case "task_id": |
| | | TaskIdColumn := field.(*entity.ColumnInt64Array).Data() |
| | |
| | | placeholders[i] = "?" |
| | | args[i] = id |
| | | } |
| | | sqlStr := `SELECT id, know_id, file_name FROM mal_knowledge_document where id in (` + strings.Join(placeholders, ",") + `)` |
| | | sqlStr := `SELECT id, know_id, file_name as title FROM mal_knowledge_document where id in (` + strings.Join(placeholders, ",") + `)` |
| | | if err := db.Raw(sqlStr, args...).Scan(&items).Error; err != nil { |
| | | return nil, err |
| | | } |
| | |
| | | } |
| | | |
| | | // 根据知识库id查数据 |
| | | func GetCameraIds(ids []string) (items []Camera, err error) { |
| | | func GetCameraIds(ids []string) (items []CameraDto, err error) { |
| | | placeholders := make([]string, len(ids)) |
| | | args := make([]interface{}, len(ids)) |
| | | for i, id := range ids { |