lighting_control/server/dao/device_loop.go

package dao

import "server/global"

type DeviceLoop struct {
	global.GVA_MODEL
	RelayId               int    `json:"relayId" gorm:"column:relay_id;comment:回路ID"`
	DeviceId              int    `json:"deviceId" gorm:"column:device_id;comment:设备ID"`
	Name                  string `json:"name" gorm:"column:name;comment:名称"`
	State                 int    `json:"state" gorm:"column:state;default:0;comment:状态"`
	TimeCondition1OnTime  string `json:"timeCondition1OnTime" gorm:"column:time_condition_1_on_time;default:关闭;comment:定时1 开"`
	TimeCondition1OffTime string `json:"timeCondition1OffTime" gorm:"column:time_condition_1_off_time;default:关闭;comment:定时1 关"`
	TimeCondition2OnTime  string `json:"timeCondition2OnTime" gorm:"column:time_condition_2_on_time;default:关闭;comment:定时2 开"`
	TimeCondition2OffTime string `json:"timeCondition2OffTime" gorm:"column:time_condition_2_off_time;default:关闭;comment:定时2 关"`
}

func (DeviceLoop) TableName() string {
	return "device_loop"
}

func QueryDeviceLoopsByDeviceId(deviceId int) (devices []DeviceLoop, err error) {
	err = global.GVA_DB.Model(&DeviceLoop{}).Where("device_id = ?", deviceId).Find(&devices).Error
	return
}

func (d DeviceLoop) CreateDeviceLoop() error {
	return global.GVA_DB.Create(&d).Error
}

func UpdateDeviceLoopStateByDeviceIdAndRelayId(deviceId, relayId, state int) error {
	return global.GVA_DB.Model(&DeviceLoop{}).Where("device_id = ? AND relay_id = ?", deviceId, relayId).Update("state", state).Error
}

func UpdateDeviceLoopStateByDeviceId(deviceId, state int) error {
	return global.GVA_DB.Model(&DeviceLoop{}).Where("device_id = ?", deviceId).Update("state", state).Error
}