package models
|
|
//设备添加申请记录
|
type DeviceApply struct {
|
Id string `gorm:"column:id;primary_key;type:varchar(50);unique;not null;" json:"id"`
|
DevId string `gorm:"column:devId;unique;not null;" json:"devId"`
|
DevName string `gorm:"column:devName" json:"devName"`
|
ApplyKey string `gorm:"column:applyKey" json:"applyKey"`
|
Ip string `gorm:"column:ip" json:"ip"`
|
CreateTime string `gorm:"column:createTime" json:"createTime"`
|
Status int `gorm:"column:status;default:0;" json:"status"` //状态 0：已添加，待发送给对方 1：已成功发送请求到对方，等待反馈。 2：对方已同意 -2:对方已拒绝
|
}
|
|
const (
|
ApplyStatus_KeyErr = -2 //密钥错误
|
ApplyStatus_Reject = -1 //已拒绝
|
ApplyStatus_Sending = 0 //等待发送给对方
|
ApplyStatus_Waiting = 1 //等待响应
|
ApplyStatus_Agreed = 2 //已同意
|
ApplyStatus_Managed = 3 //已处于管理状态
|
)
|
|
func (DeviceApply) TableName() string {
|
return "t_device_apply"
|
}
|
|
func (da *DeviceApply) Insert() bool {
|
result := db.Table(da.TableName()).Create(&da)
|
if result.Error == nil && result.RowsAffected > 0 {
|
return true
|
}
|
return false
|
}
|
|
func (da *DeviceApply) FindByDevId(devId string) (int64,error) {
|
result := db.Table(da.TableName()).Where("devId=?", devId).First(&da)
|
if result.Error != nil || result.RowsAffected == 0 {
|
return 0, result.Error
|
}
|
return result.RowsAffected, nil
|
}
|
|
func (da *DeviceApply) Update() bool {
|
result := db.Table(da.TableName()).Where("id=?", da.Id).Update(&da)
|
if result.Error ==nil && result.RowsAffected > 0 {
|
return true
|
}
|
return false
|
}
|
|
func (da *DeviceApply) DeleteById(id string) bool {
|
result := db.Exec("delete from "+da.TableName()+" where id='"+id+"'")
|
if result.Error == nil && result.RowsAffected > 0 {
|
return true
|
}
|
return false
|
}
|
|
func (da *DeviceApply) FindByStatus(status int) (list []DeviceApply) {
|
err := db.Table(da.TableName()).Where("status=?", status).Find(&list).Error
|
if err != nil {
|
return nil
|
}
|
return list
|
}
|
|
func (da *DeviceApply) UpdateStatus(status int, id string) bool {
|
return db.Exec("update "+da.TableName()+" set status=? where id=?", status, id).RowsAffected >0
|
}
|
