eta_api/models/bi_dashboard/bi_dashboard.go

package bi_dashboard

import (
	"eta_gn/eta_api/global"
	"time"
)

type BiDashboard struct {
	BiDashboardId         int       `gorm:"primaryKey;autoIncrement;column:bi_dashboard_id"` // bi看板id
	BiDashboardClassifyId int       `gorm:"column:bi_dashboard_classify_id" `                // 看板分类id
	BiDashboardName       string    `gorm:"column:bi_dashboard_name;size:255"`               // 看板名称
	SysAdminId            int       `gorm:"column:sys_admin_id" `                            // 创建人ID
	SysAdminName          string    `gorm:"column:sys_admin_name;size:128" `                 // 创建人姓名
	Sort                  int       `gorm:"column:sort" `                                    // 排序字段
	CreateTime            time.Time `gorm:"column:create_time" `                             // 创建时间
	ModifyTime            time.Time `gorm:"column:modify_time"`                              // 更新时间
	State                 int       `gorm:"column:state"`                                    // 状态
}

// tableName
func (m *BiDashboard) TableName() string {
	return "bi_dashboard"
}

// AddBiDashboard 新增看板
func AddBiDashboard(item *BiDashboard) (lastId int64, err error) {
	err = global.DEFAULT_DmSQL.Create(item).Error
	lastId = int64(item.BiDashboardId)
	return
}

// GetShareDashboard 获取公开分享的看板
func GetShareDashboard() (items []*BiDashboard, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM bi_dashboard WHERE 1=1 AND state = 6 `

	sql += `ORDER BY create_time DESC`
	//sql += `ORDER BY create_time DESC LIMIT ?,?`
	//_, err = o.Raw(sql).QueryRows(&items)
	err = global.DEFAULT_DmSQL.Raw(sql).Find(&items).Error
	return
}

func GetBiDashboardList(condition string, pars []interface{}) (items []*BiDashboard, err error) {
	sql := `SELECT * FROM bi_dashboard WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	//
	sql += `ORDER BY modify_time DESC `
	//sql += `ORDER BY create_time DESC LIMIT ?,?`
	//_, err = o.Raw(sql, pars...).QueryRows(&items)
	err = global.DEFAULT_DmSQL.Raw(sql, pars...).Find(&items).Error
	return
}

// GetDashboardById 获取看板
func GetDashboardById(id int) (item *BiDashboard, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM bi_dashboard WHERE bi_dashboard_id = ? limit 1`

	//sql += `ORDER BY create_time DESC LIMIT ?,?`
	//_, err = o.Raw(sql).QueryRows(&items)
	err = global.DEFAULT_DmSQL.Raw(sql, id).First(&item).Error
	return
}

// del
func DelDashboard(id int) (err error) {
	return global.DEFAULT_DmSQL.Delete(&BiDashboard{BiDashboardId: id}).Error
}

// DashboardDetailResp 详情响应体
type DashboardDetailResp struct {
	*BiDashboard
	List []*BiDashboardDetail
}

type AddDashboardReq struct {
	List            []*AddDashboardListReq
	BiDashboardName string `description:"看板名称"`
}

type AddDashboardListReq struct {
	Type       int
	UniqueCode string
	Sort       int
}

type EditDashboardReq struct {
	List            []*AddDashboardListReq
	BiDashboardId   int    `description:"看板id"`
	BiDashboardName string `description:"看板名称"`
}

// update
func EditDashboard(item *BiDashboard) (err error) {
	return global.DEFAULT_DmSQL.Model(item).Updates(item).Error
}

type DelDashboardReq struct {
	BiDashboardId   int    `description:"看板id"`
}