package models

type App struct {
	Id        string `gorm:"column:id;primary_key;type:varchar(50);unique;not null;" json:"id"`
	Name      string `gorm:"column:name" json:"name"`                        //中文名称,eg:算力管理
	Package   string `gorm:"column:package;unique;not null;" json:"package"` //英文名字
	Type      string `gorm:"column:type" json:"type"`                        //新开页面:"1",弹框："2"
	Url       string `gorm:"column:url" json:"url"`                          //eg: /view/analysisPower/
	Title     string `gorm:"column:title" json:"title"`                      //打开弹框或新开页面顶部显示
	Width     int    `gorm:"column:width" json:"width"`                      //定义弹框的默认宽度
	Height    int    `gorm:"column:height" json:"height"`                    //定义弹框的默认高度
	IconBlob  string `gorm:"column:iconBlob" json:"iconBlob"`                //图片的base64
	IconBlob2 string `gorm:"column:iconBlob2" json:"iconBlob2"`              //第二套图片的base64
	Icon      string `gorm:"column:icon" json:"icon"`                        //图片相对路径或者是iconfont
	Version   string `gorm:"column:version;default:''" json:"version"`

	CreateTime string `gorm:"column:create_time" json:"create_time"`
	CreateBy   string `gorm:"column:create_by" json:"create_by"`
	UpdateTime string `gorm:"column:update_time" json:"update_time"`
	UpdateBy   string `gorm:"column:update_by" json:"update_by"`
	IsDefault  bool   `gorm:"column:isDefault;default:0;" json:"isDefault"`

	ProcName string `gorm:"column:procName" json:"procName"` //应用的后端服务名，系统监控器中需要用,由商城端维护

	Price        float32 `json:"price"`                                   //商城端价格
	CanUpOrIns   bool    `json:"canUpOrIns"`                              //是否可安装或升级
	Platforms    []PtIns `json:"platforms"`                               //可适配的平台信息
	ActivateCode string  `gorm:"column:activateCode" json:"activateCode"` // 激活码
}

type PtIns struct {
	Platform string `json:"platform"`
	Version  string `json:"version"`
	VGpus    string `json:"vGpus"`
}

func (App) TableName() string {
	return "t_app"
}

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

func (a *App) Save() (err error) {
	tx := db.Table(a.TableName()).Begin()
	if tx.Error != nil {
		return tx.Error
	}

	if err := tx.Save(&a).Error; err != nil {
		tx.Rollback()
		return err
	}

	err = tx.Commit().Error
	if err == nil {
		return nil
	}
	return err
}

func (a *App) Update() (result bool, err error) {
	entity := App{}

	rows, err := entity.SelectById(a.Id)
	if err != nil {
		return false, err
	}
	if rows == 0 {
		return false, err
	}
	if err := db.Table("t_app").Where("id=?", a.Id).Update(&a).Error; err != nil {
		return false, err
	}
	return true, nil
}

func (a *App) UpdateCode(appId, code string) (err error) {
	if err := db.Table("t_app").Where("id=?", appId).Update("activateCode", code).Error; err != nil {
		return err
	}
	return nil
}

func (a *App) DeleteById(id string) (result bool) {
	updateResult := db.Exec("delete from "+a.TableName()+" where id=?", id)
	if updateResult.Error != nil || updateResult.RowsAffected == 0 {
		return false
	}
	return true
}

func (a *App) FindAll(name string) (rows []App, err error) {
	mutex.Lock()
	defer mutex.Unlock()

	if name != "" {
		if err := db.Table(a.TableName()).Where("name like ?", name).Order("create_time asc").Find(&rows).Error; err != nil {
			return nil, err
		}
		return rows, nil
	} else {
		if err := db.Table(a.TableName()).Find(&rows).Error; err != nil {
			return nil, err
		}
		return rows, nil
	}
}

func (a *App) FindAllMap() map[string]App {
	m := make(map[string]App)
	list, _ := a.FindAll("")
	if list != nil {
		for _, s := range list {
			m[s.Id] = s
		}
	}
	return m
}

func (a *App) Total(inputText string) (int, error) {
	var total int
	sql := "select count(1) as total from " + a.TableName() + " where 1=1"
	if inputText != "" {
		sql += " and name like '%" + inputText + "%'"
	}
	err := db.Raw(sql).Count(&total).Error
	if err != nil {
		return 0, err
	}
	return total, nil
}

func (a *App) FindByPage(inputText string, page int, size int) (list []App, err error) {
	offset := (page - 1) * size
	sql := "select * from " + a.TableName() + " where 1=1"

	if inputText != "" {
		sql += " and name like '%" + inputText + "%'"
	}
	sql += " order by create_time desc"
	err = db.Raw(sql).Offset(offset).Limit(size).Find(&list).Error
	if err != nil {
		return nil, err
	}
	return list, nil
}