package models

//已授权的设备
type AuthDevice struct {
	Id 				string 		`gorm:"primary_key;column:id" json:"id"`
	DevId 			string 		`gorm:"column:devId;unique;not null;" json:"devId"`
	DevName 		string 		`gorm:"column:devName" json:"devName"`
	DevIp 			string 		`gorm:"column:devIp" json:"devIp"`
	ApplyKey 		string 		`gorm:"column:applyKey" json:"applyKey"`
	AuthTime 		string 		`gorm:"column:authTime" json:"authTime"` //授权时间或解除授权时间
	Status 			int 		`gorm:"column:status" json:"status"`  //授权状态:0:待审核，1：已授权,-1:已解除授权
	CreateTime 		string 		`gorm:"column:createTime" json:"createTime"` //创建时间
}

const (
	AuthStatus_AuthCanceled = -2 //已解除授权
	AuthStatus_Rejected     = -1 //已拒绝
	AuthStatus_Waiting      = 0  //待审核
	AuthStatus_Agreed       = 1  //已授权

)

func (AuthDevice) TableName() string {
	return "auth_device"
}

func (ad *AuthDevice) Insert() bool {
	result := db.Table(ad.TableName()).Create(&ad)
	if result.Error !=nil {
		return false
	}
	return result.RowsAffected>0
}

func (ad *AuthDevice) Update() bool {
	result := db.Table(ad.TableName()).Update(&ad)
	if result.Error !=nil {
		return false
	}
	return result.RowsAffected>0
}

func (ad *AuthDevice) SelectById(id string) (int64, error){
	result := db.Table(ad.TableName()).Where("id=?",id).First(&ad)
	if result.Error != nil || result.RowsAffected == 0 {
		return 0, err
	}
	return result.RowsAffected, nil
}


func (ad *AuthDevice) FindByDevId(devId string) (int64, error){
	result := db.Table(ad.TableName()).Where("devId=?",devId).First(&ad)
	if result.Error != nil || result.RowsAffected == 0 {
		return 0, err
	}
	return result.RowsAffected, nil
}

func (ad *AuthDevice) FindByStatus(status int) (list []AuthDevice){
	if err:=db.Table(ad.TableName()).Where("status=?", status).Scan(&list).Error;err !=nil{
		return nil
	}
	return list
}

func (ad *AuthDevice) UpdateStatus(id string, status int) bool {
	return db.Exec("update "+ad.TableName()+" set status=? where id=?", status, id).RowsAffected >0
}