package models

import (
	"sort"
	"strings"
)

type CameraTaskLink struct {
	CameraIds  string `gorm:"column:camera_ids" json:"camera_ids"` //需要对摄像机id先进行排序
	LinkTaskId string `gorm:"column:link_task_id" json:"link_task_id"`
}

func (CameraTaskLink) TableName() string {
	return "camera_task_link"
}

func (ctl *CameraTaskLink) FindByCameraIds(cameraIds []string) (list []CameraTaskLink, err error) {
	sort.Strings(cameraIds)
	idStr := strings.Join(cameraIds, ",")
	if err := db.Table(ctl.TableName()).Where("camera_ids like ?", "%"+idStr+"%").Scan(&list).Error; err != nil {
		return nil, err
	}
	return list, err
}

func (ctl *CameraTaskLink) FindAll() (list []CameraTaskLink, err error) {
	if err := db.Table(ctl.TableName()).Find(&list).Error; err != nil {
		return nil, err
	}
	return list, err
}