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;default 0" json:"lightId"`   //照明策略id
	StartTime  string    `gorm:"type:varchar(60)" json:"startTime"`   //开始时间
	EndTime    string    `gorm:"type:varchar(60)" 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 int       `gorm:"type:int" json:"createUser"`          //新增记录操作用户ID
	UpdateTime time.Time `gorm:"type:datetime" json:"updateTime"`     //修改时间
	UpdateUser int       `gorm:"type:int" 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 "strategy_time_condition"
}

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

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

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

func (c *TimeCondition) GetAll() ([]TimeCondition, error) {
	var conditions []TimeCondition
	err := Db.Model(&c).Find(&conditions).Error
	return conditions, err
}

func (c *TimeCondition) Save() error {
	return Db.Model(&c).Save(&c).Error
}

func (c *TimeCondition) Update() error {
	return Db.Model(&c).Updates(&c).Error
}