123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169 |
- package bi_dashboard
- import (
- "github.com/beego/beego/v2/client/orm"
- "time"
- )
- type BiDashboard struct {
- BiDashboardId int `orm:"column(bi_dashboard_id);pk"`
- BiDashboardClassifyId int `gorm:"column:bi_dashboard_classify_id" `
- BiDashboardName string `gorm:"column:bi_dashboard_name;size:255"`
- SysAdminId int `gorm:"column:sys_admin_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"`
- }
- func (m *BiDashboard) TableName() string {
- return "bi_dashboard"
- }
- func (m *BiDashboard) Update(cols []string) (err error) {
- o := orm.NewOrm()
- _, err = o.Update(m, cols...)
- return
- }
- func AddBiDashboard(item *BiDashboard) (lastId int64, err error) {
- o := orm.NewOrm()
- lastId, err = o.Insert(item)
- return
- }
- func GetShareDashboard() (items []*BiDashboard, err error) {
-
- sql := `SELECT * FROM bi_dashboard WHERE 1=1 AND state = 6 `
- sql += `ORDER BY create_time DESC`
-
-
-
- return
- }
- func GetBiDashboardList(condition string, pars []interface{}) (items []*BiDashboard, err error) {
- o := orm.NewOrm()
- sql := `SELECT * FROM bi_dashboard WHERE 1=1 `
- if condition != "" {
- sql += condition
- }
-
- sql += `ORDER BY modify_time DESC `
-
- _, err = o.Raw(sql, pars...).QueryRows(&items)
- return
- }
- func GetDashboardById(id int) (item *BiDashboard, err error) {
- o := orm.NewOrm()
- sql := `SELECT * FROM bi_dashboard WHERE bi_dashboard_id = ? limit 1`
-
- err = o.Raw(sql, id).QueryRow(&item)
- return
- }
- func DelDashboard(id int) (err error) {
- o := orm.NewOrm()
- sql := `DELETE FROM bi_dashboard WHERE bi_dashboard_id = ?`
- _, err = o.Raw(sql, id).Exec()
- return
- }
- type BiDashboardEditingCache struct {
- IsEditing bool `description:"是否有人编辑"`
- AdminId int `description:"编辑者ID"`
- Editor string `description:"编辑者姓名"`
- Tips string `description:"提示信息"`
- }
- type DashboardDetailResp struct {
- *BiDashboard
- IsGrant int `description:"是否共享,0:不是,1:是"`
- Editor BiDashboardEditingCache `description:"编辑人信息"`
- 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:"看板名称"`
- }
- func EditDashboard(item *BiDashboard) (err error) {
- o := orm.NewOrm()
- sql := `UPDATE bi_dashboard SET bi_dashboard_name=?,modify_time=?,state=? WHERE bi_dashboard_id=?`
- _, err = o.Raw(sql, item.BiDashboardName, time.Now(), item.State, item.BiDashboardId).Exec()
- return
- }
- type DelDashboardReq struct {
- BiDashboardId int `description:"看板id"`
- }
- func GetDashboradByIds(dashboradIds []int) (list []*BiDashboard, err error) {
-
- return
- }
- func GetAllGrantList(sysUserId int) (list []*BiDashboard, err error) {
- sql := `SELECT a.* FROM bi_dashboard a JOIN bi_dashboard_grant b on a.bi_dashboard_id=b.bi_dashboard_id
- WHERE b.grant_admin_id=?`
- o := orm.NewOrm()
- _, err = o.Raw(sql, sysUserId).QueryRows(&list)
- return
- }
- func SaveDashboard(item *BiDashboard) (err error) {
- o := orm.NewOrm()
- _, err = o.Insert(item)
- return
- }
- type BiDashboardEditingReq struct {
- BiDashboardId int `description:"看板主键ID"`
- Status int `description:"标记状态: 1-编辑中; 2-编辑完成"`
- }
- func GetAllMyShareList(sysUserId int) (list []*BiDashboard, err error) {
- sql := `SELECT a.* FROM bi_dashboard a JOIN bi_dashboard_grant b on a.bi_dashboard_id=b.bi_dashboard_id
- WHERE a.sys_admin_id = ? GROUP BY a.bi_dashboard_id `
- o := orm.NewOrm()
- _, err = o.Raw(sql, sysUserId).QueryRows(&list)
- return
- }
- func GetDashboardByName(name string, adminId int) (item *BiDashboard, err error) {
- sql := `SELECT * FROM bi_dashboard WHERE bi_dashboard_name = ? and sys_admin_id =? limit 1`
- o := orm.NewOrm()
- err = o.Raw(sql, name, adminId).QueryRow(&item)
- return
- }
|