package models

type Dictionary struct {
	Id          string `gorm:"primary_key;column:id;" json:"id"`
	Value       string `gorm:"column:value" json:"value"`             //值
	Name        string `gorm:"column:name" json:"name"`               //名称
	Type        string `gorm:"column:type" json:"type"`               //类型
	Description string `gorm:"column:description" json:"description"` //描述
	Sort        int    `gorm:"column:sort;default:1" json:"sort"`
	ParentId    string `gorm:"column:parent_id;default:0" json:"parent_id"`
}

const (
	TYPE_VEHICLE_COLOR = "nVehicleColor" //车身颜色
	TYPE_VEHICLE_TYPE  = "nVehicleType"  //车辆类型
	TYPE_PLATE_TYPE    = "nPlateType"    //车牌类型
	TYPE_VEHICLE_BRAND = "nVehicleBrand" //车辆品牌
)

func (Dictionary) TableName() string {
	return "dictionary"
}

func (dic *Dictionary) FindAll() (dics []Dictionary, err error) {
	if err := db.Table(dic.TableName()).Find(&dics).Error; err != nil {
		return nil, err
	}
	return dics, nil
}

func (dic *Dictionary) FindByType(dicType string) (dics []Dictionary, err error) {
	if err := db.Table(dic.TableName()).Where("type=?", dicType).Order("sort asc").Scan(&dics).Error; err != nil {
		return nil, err
	}
	return dics, nil
}

func (dic *Dictionary) FindByParentId(parentId string) (dics []Dictionary, err error) {
	if err := db.Table(dic.TableName()).Where("parent_id=?", parentId).Scan(&dics).Error; err != nil {
		return nil, err
	}
	return dics, nil
}

func (dic *Dictionary) Insert() (bool, error) {
	if err := db.Table(dic.TableName()).Create(&dic).Error; err != nil {
		return false, err
	}
	return true, nil
}

func (dic *Dictionary) Update() (bool, error) {
	if err := db.Table(dic.TableName()).Update(&dic).Error; err != nil {
		return false, err
	}
	return true, nil
}

func (dic *Dictionary) SelectById(id string) (bool, error) {
	result := db.Table(dic.TableName()).Where("id=?", id).First(&dic)
	if result.Error != nil {
		return false, err
	}
	return result.RecordNotFound(), nil
}