lc_veterans/app/device/dao/timeConditionDao.go

package dao

import "time"

type TimeCondition struct {
	ID         int       `gorm:"primary key" json:"id"`               //编号
	LightId    int       `gorm:"type: int" json:"lightId"`            //照明策略id
	StartTime  string    `gorm:"type:time" json:"startTime"`          //开始时间
	EndTime    string    `gorm:"type:time" json:"endTime"`            //结束时间
	Luminance  int       `gorm:"type:int " json:"luminance"`          //开灯亮度
	Remark     string    `gorm:"type:varchar(255)" json:"remark"`     //备注
	CreateTime time.Time `gorm:"type:datetime" json:"createTime"`     //新增时间
	CreateUser string    `gorm:"type:varchar(60)" json:"createUser"`  //新增记录操作用户ID
	UpdateTime time.Time `gorm:"type:datetime" json:"updateTime"`     //修改时间
	UpdateUser string    `gorm:"type:varchar(60)" json:"updateUser"`  //修改用户
	IsDeleted  int       `gorm:"type:int;default 0" json:"isDeleted"` //是否删除 0=未删除,1=删除
	Sunshine   int       `gorm:"type:int;default 1" json:"sunshine"`  //日出日落 设置 2=开启,1=不开启
}

func (TimeCondition) TableName() string {
	return "t_strategy_time_condition"
}

func (c *TimeCondition) Get() error {
	return Db.Model(&c).Where("id = ?", c.ID).Find(&c).Error
}

func (c *TimeCondition) BatchGet(ids []int) ([]TimeCondition, error) {
	var conditions []TimeCondition
	err := Db.Model(&c).Where("id in ?", ids).Find(&conditions).Error
	return conditions, err
}

func (c *TimeCondition) GetByLightId() ([]TimeCondition, error) {
	var conditions []TimeCondition
	err := Db.Model(&c).Where("light_id = ?", c.LightId).Find(&conditions).Error
	return conditions, err
}