cc/QMPlusServer/model/sysModel/sys_api.go

package sysModel

import (
	"gin-vue-admin/controller/servers"
	"gin-vue-admin/init/qmsql"
	"gin-vue-admin/model/modelInterface"
	"github.com/jinzhu/gorm"
	"github.com/pkg/errors"
)

type SysApi struct {
	gorm.Model
	Path        string `json:"path"`
	Description string `json:"description"`
	Group       string `json:"group"`
	Method      string `json:"method" gorm:"default:'POST'"`
}

//新增基础api
func (a *SysApi) CreateApi() (err error) {
	findOne := qmsql.DEFAULTDB.Where("path = ?", a.Path).Find(&SysMenu{}).Error
	if findOne == nil {
		return errors.New("存在相同api")
	} else {
		err = qmsql.DEFAULTDB.Create(a).Error
	}
	return err
}

//删除基础api
func (a *SysApi) DeleteApi() (err error) {
	err = qmsql.DEFAULTDB.Delete(a).Error
	new(CasbinModel).clearCasbin(1, a.Path)
	return err
}

//更新api
func (a *SysApi) UpdataApi() (err error) {
	var oldA SysApi
	err = qmsql.DEFAULTDB.Where("id = ?", a.ID).First(&oldA).Error
	if err != nil {
		return err
	} else {
		err = new(CasbinModel).CasbinApiUpdata(oldA.Path, a.Path)
		if err != nil {
			return err
		} else {
			err = qmsql.DEFAULTDB.Save(a).Error
		}
	}
	return err
}

//获取选中角色所拥有的api
func (a *SysApi) GetApiById(id float64) (err error, api SysApi) {
	err = qmsql.DEFAULTDB.Where("id = ?", id).First(&api).Error
	return
}

// 获取所有api信息
func (a *SysApi) GetAllApis() (err error, apis []SysApi) {
	err = qmsql.DEFAULTDB.Find(&apis).Error
	return
}

// 分页获取数据  需要分页实现这个接口即可
func (a *SysApi) GetInfoList(info modelInterface.PageInfo) (err error, list interface{}, total int) {
	// 封装分页方法 调用即可 传入 当前的结构体和分页信息
	err, db, total := servers.PagingServer(a, info)
	if err != nil {
		return
	} else {
		var apiList []SysApi
		model := qmsql.DEFAULTDB.Model(info)
		if a.Path != "" {
			model = model.Where("path LIKE ?", "%"+a.Path+"%")
			db = db.Where("path LIKE ?", "%"+a.Path+"%")
		}

		if a.Description != "" {
			model = model.Where("description LIKE ?", "%"+a.Description+"%")
			db = db.Where("description LIKE ?", "%"+a.Description+"%")
		}

		if a.Method != "" {
			model = model.Where("method = ?", a.Method)
			db = db.Where("method = ?", a.Method)
		}
		err = model.Find(&apiList).Count(&total).Error
		if err != nil {
			return err, apiList, total
		} else {
			err = db.Order("group", true).Find(&apiList).Error
		}
		return err, apiList, total
	}
}