package models

//大区对应的摄像机和多边形关系
//一个大区内可以有多个摄像机，每个摄像机可以画多个多边形
type AreaCameraPolygon struct {
	Id 					string 		`gorm:"primary_key;column:id" json:"id"`
	Name 				string 		`gorm:"column:name" json:"name"`
	Desc 				string 		`gorm:"column:desc" json:"desc"`
	CameraPgn 			string 		`gorm:"column:camPolygons" json:"camPolygons"`
}

func (AreaCameraPolygon) TableName() string {
	return "area_camera_polygon"
}

func (acp *AreaCameraPolygon) FindAll() (list []AreaCameraPolygon, err error) {
	if err := db.Table(acp.TableName()).Order("name asc").Find(&list).Error; err != nil {
		return nil, err
	}
	return list, nil
}

func (acp *AreaCameraPolygon) SelectById(id string) (rows int64,err error) {
	dbselect := db.Table(acp.TableName()).Where("id = ?", id).First(acp)
	if dbselect.Error != nil || dbselect.RowsAffected == 0 {
		return 0, err
	}
	return dbselect.RowsAffected, nil
}

func (acp *AreaCameraPolygon) Insert() bool{
	result := db.Table(acp.TableName()).Create(acp)
	if result.Error !=nil {
		return false
	}
	if result.RowsAffected>0 {
		return true
	}
	return false
}

func (acp *AreaCameraPolygon) Update() bool{
	result := db.Table(acp.TableName()).Where("id = ?", acp.Id).Update(acp)
	if result.Error !=nil {
		return false
	}
	if result.RowsAffected>0 {
		return true
	}
	return false
}
func (acp *AreaCameraPolygon) Delete(ids []string) bool {
	str := ""
	for _,id := range ids {
		str += `'`+id+`',`
	}
	str = str[:len(str)-1]
	sql := "delete from area_camera_polygon where id in ("+str+")"
	result := db.Exec(sql)
	if result.Error !=nil {
		return false
	}
	return result.RowsAffected >0
}