package dao import ( "github.com/jinzhu/gorm" "time" ) //OptoSensor 集控器 type OptoSensor struct { ID int `gorm:"primary_key" json:"id"` //编号 Name string `gorm:"type:varchar(64)" json:"name"` //名称 SN string `gorm:"type:varchar(60)" json:"sn"` //唯一编码 LampPoleId int `gorm:"type:int" json:"lampPoleId"` //灯杆id LampPoleName string `gorm:"type:varchar(64)" json:"lampPoleName"` //灯杆名称 LampPoleSN string `gorm:"type:varchar(64)" json:"lampPoleSN"` //灯杆编码 LampPoleLocation string `gorm:"type:varchar(255)" json:"lampPoleLocation"` //灯杆安装位置 LampLng float64 `gorm:"type:double(17, 14) " json:"poleLng"` //经度 LampLat float64 `gorm:"type:double(17, 14) " json:"poleLat"` //纬度 BrandID int `gorm:"type:int" json:"brandID"` //设备名称 ModelID int `gorm:"type:int" json:"modelID"` //设备型号 GatewayId int `gorm:"type:int" json:"gatewayId"` //所属网关id InstallTime *time.Time `gorm:"type:date" json:"installTime"` //安装时间 IPAddress string `gorm:"type:varchar(64)" json:"ipAddress"` //IP地址-备用 IsDefault int `gorm:"type:int;default 0" json:"isDefault"` //是否设为首页默认展示 0=不展示,1=设置展示 TenantId int `gorm:"type:int" json:"tenantId"` //租户ID CreateTime time.Time `gorm:"type:datetime" json:"createTime"` //新增时间 CreateUser int64 `gorm:"type:bigint" json:"createUser"` //新增记录操作用户ID UpdateTime time.Time `gorm:"type:datetime" json:"updateTime"` //修改时间 UpdateUser int64 `gorm:"type:bigint" json:"updateUser"` //修改用户 IsDeleted int `gorm:"type:int;default 0" json:"isDeleted"` //是否删除 0=未删除,1=删除 Status int `gorm:"type:int" json:"status"` //状态 0=正常,1=异常 Tag string `gorm:"type:varchar(255)" json:"tag"` //标签,保留字段(逗号区分) } func (OptoSensor) TableName() string { return "t_dev_opto_sensor" } func (c OptoSensor) Delete() error { return Db.Debug().Model(&c).Where("id = ?", c.ID).Updates(map[string]interface{}{"update_time": c.UpdateTime, "update_user": c.UpdateUser, "is_deleted": c.IsDeleted}).Error } func (c OptoSensor) IsExistedBySN() bool { var count = 0 _ = Db.Debug().Model(&c).Where(" sn = ? and is_deleted = ?", c.SN, c.IsDeleted).Count(&count).Error return count > 0 } func (c OptoSensor) IsExistedByNameAndCode() bool { var devices []Zigbee err := Db.Debug().Model(&c).Where(" sn = ? and is_deleted = ?", c.SN, c.IsDeleted).Find(&devices).Error //如果查询不到,返回相应的错误 if gorm.IsRecordNotFoundError(err) { return false } for _, d := range devices { if d.ID != c.ID { return true } } return false } func (c *OptoSensor) Create() error { return Db.Debug().Model(&c).Save(&c).Error } func (c *OptoSensor) Update() error { return Db.Debug().Model(&c).Where(" id = ? ", c.ID).Update(&c).Error } func (c *OptoSensor) GetDevice() error { err := Db.Debug().Model(&c).Where(" id = ? ", c.ID).Scan(&c).Error return err } func (c OptoSensor) GetDevices(offset, limit int) ([]OptoSensor, error) { var devices []OptoSensor err := Db.Debug().Model(&c).Where(" name like ? ", "%"+c.Name+"%").Offset(offset).Limit(limit).Find(&devices).Error return devices, err } func (c OptoSensor) GetAllDevices() ([]*OptoSensor, error) { var devices []*OptoSensor err := Db.Debug().Model(&c).Where(" tenant_id = ? and is_deleted = ? ", c.TenantId, c.IsDeleted).Scan(&devices).Error return devices, err }