bi_dashboard.go 28 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta_gn/eta_api/models"
  6. "eta_gn/eta_api/models/bi_dashboard"
  7. "eta_gn/eta_api/models/system"
  8. biapprove "eta_gn/eta_api/services/bi_approve"
  9. "eta_gn/eta_api/utils"
  10. "fmt"
  11. "strconv"
  12. "strings"
  13. "time"
  14. )
  15. type BIDaShboardController struct {
  16. BaseAuthController
  17. }
  18. // GroupList
  19. // @Title 获取我的列表
  20. // @Description 获取我的列表接口
  21. // @Success 200 {object} models.RespGroupList
  22. // @router /my_list [get]
  23. func (this *BIDaShboardController) MyList() {
  24. br := new(models.BaseResponse).Init()
  25. defer func() {
  26. this.Data["json"] = br
  27. this.ServeJSON()
  28. }()
  29. // 获取我的看板列表
  30. privateCond := ` AND sys_admin_id = ? AND state IN (1,6) `
  31. privatePars := []interface{}{this.SysUser.AdminId}
  32. privateList, err := bi_dashboard.GetBiDashboardList(privateCond, privatePars)
  33. if err != nil {
  34. err = errors.New("我的看板列表查询出错:" + err.Error())
  35. return
  36. }
  37. br.Ret = 200
  38. br.Success = true
  39. br.Msg = "查询成功"
  40. br.Data = privateList
  41. return
  42. }
  43. // AddDashboard
  44. // @Title 新增看板
  45. // @Description 新增看板接口
  46. // @Param request body models.AddDashboardReq true "type json string"
  47. // @Success 200 Ret=200 新增成功
  48. // @router /add [post]
  49. func (this *BIDaShboardController) AddDashboard() {
  50. br := new(models.BaseResponse).Init()
  51. defer func() {
  52. this.Data["json"] = br
  53. this.ServeJSON()
  54. }()
  55. var req bi_dashboard.AddDashboardReq
  56. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  57. if err != nil {
  58. br.Msg = "参数解析异常!"
  59. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  60. return
  61. }
  62. if req.BiDashboardName == "" {
  63. br.Msg = "名称不能为空"
  64. return
  65. }
  66. item := &bi_dashboard.BiDashboard{
  67. //BiDashboardClassifyId: req.ClassifyId,
  68. BiDashboardName: req.BiDashboardName,
  69. SysAdminId: this.SysUser.AdminId,
  70. SysAdminName: this.SysUser.AdminName,
  71. //Sort: 0,
  72. CreateTime: time.Now(),
  73. ModifyTime: time.Now(),
  74. State: 1,
  75. }
  76. id, e := bi_dashboard.AddBiDashboard(item)
  77. if e != nil {
  78. err = e
  79. br.Msg = "新增失败"
  80. br.ErrMsg = "新增失败,Err:" + e.Error()
  81. return
  82. }
  83. detailList := make([]*bi_dashboard.BiDashboardDetail, 0)
  84. for i, v := range req.List {
  85. item := &bi_dashboard.BiDashboardDetail{
  86. BiDashboardId: int(id),
  87. Type: v.Type,
  88. UniqueCode: v.UniqueCode,
  89. Sort: i + 1,
  90. CreateTime: time.Now(),
  91. ModifyTime: time.Now(),
  92. }
  93. detailList = append(detailList, item)
  94. }
  95. err = bi_dashboard.AddBiDashboardDetailMulti(detailList)
  96. if err != nil {
  97. br.Msg = "新增详情失败"
  98. br.ErrMsg = "新增详情失败,Err:" + err.Error()
  99. return
  100. }
  101. br.Ret = 200
  102. br.Success = true
  103. br.Msg = "新增成功"
  104. //br.Data =
  105. }
  106. // EditPpt
  107. // @Title 编辑看板
  108. // @Description 编辑看板接口
  109. // @Param request body bi_dashboard.EditDashboardReq true "type json string"
  110. // @Success 200 Ret=200 编辑成功
  111. // @router /edit [post]
  112. func (this *BIDaShboardController) EditDashboard() {
  113. br := new(models.BaseResponse).Init()
  114. defer func() {
  115. this.Data["json"] = br
  116. this.ServeJSON()
  117. }()
  118. var req bi_dashboard.EditDashboardReq
  119. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  120. if err != nil {
  121. br.Msg = "参数解析异常!"
  122. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  123. return
  124. }
  125. if req.BiDashboardName == "" {
  126. br.Msg = "标题不能为空"
  127. return
  128. }
  129. item, err := bi_dashboard.GetDashboardById(req.BiDashboardId)
  130. if err != nil && !utils.IsErrNoRow(err) {
  131. br.Msg = "获取数据异常!"
  132. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  133. return
  134. }
  135. // 判断权限
  136. if item.SysAdminId != this.SysUser.AdminId {
  137. br.Msg = `无权编辑`
  138. return
  139. }
  140. // 修改
  141. item.BiDashboardName = req.BiDashboardName
  142. item.ModifyTime = time.Now()
  143. err = bi_dashboard.EditDashboard(item)
  144. if err != nil {
  145. br.Msg = "编辑失败"
  146. br.ErrMsg = "编辑失败,Err:" + err.Error()
  147. return
  148. }
  149. err = bi_dashboard.DeleteBiDashboardDetail(req.BiDashboardId)
  150. if err != nil {
  151. br.Msg = "删除详情失败"
  152. br.ErrMsg = "删除详情失败,Err:" + err.Error()
  153. return
  154. }
  155. detailList := make([]*bi_dashboard.BiDashboardDetail, 0)
  156. for _, v := range req.List {
  157. item := &bi_dashboard.BiDashboardDetail{
  158. BiDashboardId: req.BiDashboardId,
  159. Type: v.Type,
  160. UniqueCode: v.UniqueCode,
  161. Sort: v.Sort,
  162. CreateTime: time.Now(),
  163. ModifyTime: time.Now(),
  164. }
  165. detailList = append(detailList, item)
  166. }
  167. err = bi_dashboard.AddBiDashboardDetailMulti(detailList)
  168. if err != nil {
  169. br.Msg = "新增详情失败"
  170. br.ErrMsg = "新增详情失败,Err:" + err.Error()
  171. return
  172. }
  173. br.Ret = 200
  174. br.Success = true
  175. br.Msg = "编辑成功"
  176. br.IsAddLog = true
  177. }
  178. // DeleteDashboard
  179. // @Title 删除看板
  180. // @Description 删除看板接口
  181. // @Param request body bi_dashboard.DelDashboardReq true "type json string"
  182. // @Success 200 Ret=200 删除成功
  183. // @router /delete [post]
  184. func (this *BIDaShboardController) DeleteDashboard() {
  185. br := new(models.BaseResponse).Init()
  186. defer func() {
  187. this.Data["json"] = br
  188. this.ServeJSON()
  189. }()
  190. var req bi_dashboard.DelDashboardReq
  191. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  192. if err != nil {
  193. br.Msg = "参数解析异常!"
  194. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  195. return
  196. }
  197. if req.BiDashboardId <= 0 {
  198. br.Msg = "参数错误"
  199. return
  200. }
  201. item, err := bi_dashboard.GetDashboardById(req.BiDashboardId)
  202. if err != nil && !utils.IsErrNoRow(err) {
  203. br.Msg = "获取数据异常!"
  204. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  205. return
  206. }
  207. if item.SysAdminId != this.SysUser.AdminId {
  208. br.Msg = "无权删除"
  209. return
  210. }
  211. err = bi_dashboard.DelDashboard(req.BiDashboardId)
  212. if err != nil {
  213. br.Msg = "删除失败"
  214. br.ErrMsg = "删除失败,Err:" + err.Error()
  215. return
  216. }
  217. err = bi_dashboard.DelDashboard(req.BiDashboardId)
  218. if err != nil {
  219. br.Msg = "删除失败"
  220. br.ErrMsg = "删除失败,Err:" + err.Error()
  221. return
  222. }
  223. br.Ret = 200
  224. br.Success = true
  225. br.IsAddLog = true
  226. br.Msg = "删除成功"
  227. }
  228. // DeleteDashboard
  229. // @Title 删除看板详情
  230. // @Description 删除看板详情接口
  231. // @Param request body bi_dashboard.DelDashboardDetailReq true "type json string"
  232. // @Success 200 Ret=200 删除成功
  233. // @router /detail/delete [post]
  234. func (this *BIDaShboardController) DeleteDashboardDetail() {
  235. br := new(models.BaseResponse).Init()
  236. defer func() {
  237. this.Data["json"] = br
  238. this.ServeJSON()
  239. }()
  240. var req bi_dashboard.DelDashboardDetailReq
  241. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  242. if err != nil {
  243. br.Msg = "参数解析异常!"
  244. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  245. return
  246. }
  247. if req.BiDashboardDetailId <= 0 {
  248. br.Msg = "参数错误"
  249. return
  250. }
  251. err = bi_dashboard.DeleteBiDashboardDetailByDetailId(req.BiDashboardDetailId)
  252. if err != nil {
  253. br.Msg = "删除失败"
  254. br.ErrMsg = "删除失败,Err:" + err.Error()
  255. return
  256. }
  257. br.Ret = 200
  258. br.Success = true
  259. br.IsAddLog = true
  260. br.Msg = "删除成功"
  261. }
  262. // DetailDashboard
  263. // @Title 获取看板详情
  264. // @Description 获取看板详情接口
  265. // @Param PptId query int true "PptId"
  266. // @Success 200 {object} models.PptV2
  267. // @router /detail [get]
  268. func (this *BIDaShboardController) DetailDashboard() {
  269. br := new(models.BaseResponse).Init()
  270. defer func() {
  271. if br.ErrMsg == "" {
  272. br.IsSendEmail = false
  273. }
  274. this.Data["json"] = br
  275. this.ServeJSON()
  276. }()
  277. sysUser := this.SysUser
  278. if sysUser == nil {
  279. br.Msg = "请登录"
  280. br.ErrMsg = "请登录,SysUser Is Empty"
  281. br.Ret = 408
  282. return
  283. }
  284. dashboardId, _ := this.GetInt("DashboardId")
  285. resp := new(bi_dashboard.DashboardDetailResp)
  286. dashboardItem, err := bi_dashboard.GetDashboardById(dashboardId)
  287. if err != nil {
  288. err = errors.New("我的看板列表查询出错:" + err.Error())
  289. br.Msg = "我的看板列表查询出错"
  290. br.ErrMsg = err.Error()
  291. return
  292. }
  293. grantInfoList, err := bi_dashboard.GetDashboardGrantInfo(dashboardId)
  294. if err != nil {
  295. br.Msg = "信息获取失败"
  296. br.ErrMsg = "共享信息获取失败,Err:" + err.Error()
  297. return
  298. }
  299. if len(grantInfoList) > 0 {
  300. resp.IsGrant = 1
  301. }
  302. detailList, err := bi_dashboard.GetBiDashboardDetailById(dashboardId)
  303. if err != nil {
  304. br.Msg = "详情获取失败"
  305. br.ErrMsg = "详情获取失败,Err:" + err.Error()
  306. return
  307. }
  308. resp.BiDashboard = dashboardItem
  309. resp.List = detailList
  310. br.Ret = 200
  311. br.Success = true
  312. br.Msg = "获取成功"
  313. br.Data = resp
  314. }
  315. // MoveDashboard
  316. // @Title 移动看板详情
  317. // @Description 移动看板详情接口
  318. // @Param request body bi_dashboard.MoveDashboardDetailReq true "type json string"
  319. // @Success 200 Ret=200 移动成功
  320. // @router /detail/move [post]
  321. func (this *BIDaShboardController) MoveDashboard() {
  322. br := new(models.BaseResponse).Init()
  323. defer func() {
  324. this.Data["json"] = br
  325. this.ServeJSON()
  326. }()
  327. var req bi_dashboard.MoveDashboardDetailReq
  328. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  329. if err != nil {
  330. br.Msg = "参数解析异常!"
  331. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  332. return
  333. }
  334. if req.BiDashboardId <= 0 {
  335. br.Msg = "参数错误"
  336. return
  337. }
  338. if req.BiDashboardDetailId == req.OtherDetailId || req.BiDashboardDetailId <= 0 || req.OtherDetailId <= 0 {
  339. br.Msg = "看板Id有误"
  340. return
  341. }
  342. if req.Sort < 0 || req.OtherSort < 0 || req.Sort == req.OtherSort {
  343. br.Msg = "排序有误"
  344. return
  345. }
  346. item, err := bi_dashboard.GetDashboardById(req.BiDashboardId)
  347. if err != nil && !utils.IsErrNoRow(err) {
  348. br.Msg = "获取数据异常!"
  349. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  350. return
  351. }
  352. // 判断权限
  353. if item.SysAdminId != this.SysUser.AdminId {
  354. br.Msg = `无权移动`
  355. return
  356. }
  357. // 修改
  358. detailItem := &bi_dashboard.BiDashboardDetail{
  359. BiDashboardDetailId: req.BiDashboardDetailId,
  360. Sort: req.OtherSort,
  361. ModifyTime: time.Now(),
  362. }
  363. err = bi_dashboard.EditBiDashboardDetail(detailItem)
  364. if err != nil {
  365. br.Msg = "编辑详情失败"
  366. br.ErrMsg = "编辑详情失败,Err:" + err.Error()
  367. return
  368. }
  369. otherItem := &bi_dashboard.BiDashboardDetail{
  370. BiDashboardDetailId: req.OtherDetailId,
  371. Sort: req.Sort,
  372. ModifyTime: time.Now(),
  373. }
  374. err = bi_dashboard.EditBiDashboardDetail(otherItem)
  375. if err != nil {
  376. br.Msg = "编辑详情失败"
  377. br.ErrMsg = "编辑详情失败,Err:" + err.Error()
  378. return
  379. }
  380. br.Ret = 200
  381. br.Success = true
  382. br.Msg = "编辑成功"
  383. br.IsAddLog = true
  384. }
  385. // ShareList
  386. // @Title 获取共享列表
  387. // @Description 获取共享列表接口
  388. // @Success 200 {object} models.RespGroupList
  389. // @router /share_list [get]
  390. func (this *BIDaShboardController) ShareList() {
  391. br := new(models.BaseResponse).Init()
  392. defer func() {
  393. this.Data["json"] = br
  394. this.ServeJSON()
  395. }()
  396. //myPptList := make([]*bi_dashboard.BiDashboard, 0)
  397. //otherPptList := make([]*bi_dashboard.BiDashboard, 0)
  398. grantList := bi_dashboard.RespGroupList{}
  399. // 获取我的看板列表
  400. ShareCond := ` AND sys_admin_id = ? AND state IN (1,6) `
  401. SharePars := []interface{}{this.SysUser.AdminId}
  402. ShareList, err := bi_dashboard.GetBiDashboardList(ShareCond, SharePars)
  403. if err != nil {
  404. err = errors.New("我的看板列表查询出错:" + err.Error())
  405. br.ErrMsg = err.Error()
  406. br.Msg = "查询失败"
  407. return
  408. }
  409. grantList.MyList = ShareList
  410. //dashboardMap := make(map[int]*bi_dashboard.BiDashboard)
  411. adminIdList := make([]int, 0) //需要查询的创建人admin_id列表集合
  412. adminIdMap := make(map[int]int) //需要查询的创建人admin_id集合,用来去重的,避免重复id
  413. grantDashboardList, err := bi_dashboard.GetAllGrantList(this.SysUser.AdminId)
  414. if err != nil {
  415. err = errors.New("我的看板列表查询出错:" + err.Error())
  416. br.ErrMsg = err.Error()
  417. br.Msg = "查询失败"
  418. return
  419. }
  420. publicAdminIdList := make([]int, 0)
  421. publicDashboardListMap := make(map[int][]*bi_dashboard.BiDashboard)
  422. for _, v := range grantDashboardList {
  423. publicDashboardList, ok := publicDashboardListMap[v.SysAdminId]
  424. if !ok {
  425. publicDashboardList = make([]*bi_dashboard.BiDashboard, 0)
  426. publicAdminIdList = append(publicAdminIdList, v.SysAdminId)
  427. if _, ok := adminIdMap[v.SysAdminId]; !ok {
  428. adminIdList = append(adminIdList, v.SysAdminId) //需要查询的创建人admin_id列表集合
  429. adminIdMap[v.SysAdminId] = v.SysAdminId //需要查询的创建人admin_id集合,用来去重的,避免重复id
  430. }
  431. }
  432. tmp := &bi_dashboard.BiDashboard{
  433. BiDashboardId: v.BiDashboardId,
  434. BiDashboardName: v.BiDashboardName,
  435. CreateTime: v.CreateTime,
  436. ModifyTime: v.ModifyTime,
  437. Sort: v.Sort,
  438. State: v.State,
  439. SysAdminId: v.SysAdminId,
  440. SysAdminName: v.SysAdminName,
  441. }
  442. publicDashboardList = append(publicDashboardList, tmp)
  443. publicDashboardListMap[v.SysAdminId] = publicDashboardList
  444. }
  445. // 创建人信息
  446. systemAdminMap := make(map[int]*system.Admin)
  447. systemAdminList, err := system.GetAdminListByIdList(adminIdList)
  448. if err != nil {
  449. return
  450. }
  451. for _, v := range systemAdminList {
  452. systemAdminMap[v.AdminId] = v
  453. }
  454. for _, v := range publicAdminIdList {
  455. systemAdmin, ok := systemAdminMap[v]
  456. if !ok {
  457. continue
  458. }
  459. // 看板 列表信息
  460. respGroupNameListItemList, ok := publicDashboardListMap[v]
  461. if !ok {
  462. respGroupNameListItemList = make([]*bi_dashboard.BiDashboard, 0)
  463. }
  464. // ppt 分组信息
  465. tmpRespGroupListItem := &bi_dashboard.RespOtherGroupListItem{
  466. GroupId: int64(systemAdmin.AdminId),
  467. GroupName: systemAdmin.RealName,
  468. AdminId: systemAdmin.AdminId,
  469. DashboardList: respGroupNameListItemList,
  470. }
  471. grantList.OtherList = append(grantList.OtherList, tmpRespGroupListItem)
  472. }
  473. //if len(dashboradIds) > 0 {
  474. // // 通过dashboradIds列表字段获取所有的看板信息
  475. // dashboradList, tmpErr := bi_dashboard.GetDashboradByIds(dashboradIds)
  476. // if tmpErr != nil {
  477. // err = errors.New("查询dashborad详情出错:" + err.Error())
  478. // br.Msg = "查询dashborad详情出错"
  479. // br.ErrMsg = err.Error()
  480. // return
  481. // }
  482. // for _, v := range dashboradList {
  483. // dashboardMap[v.BiDashboardId] = v
  484. // }
  485. //}
  486. br.Ret = 200
  487. br.Success = true
  488. br.Msg = "查询成功"
  489. br.Data = grantList
  490. return
  491. }
  492. // PublicList
  493. // @Title 获取公共列表
  494. // @Description 获取公共列表接口
  495. // @Success 200 {object} models.RespGroupList
  496. // @router /public_list [get]
  497. func (this *BIDaShboardController) PublicList() {
  498. br := new(models.BaseResponse).Init()
  499. defer func() {
  500. this.Data["json"] = br
  501. this.ServeJSON()
  502. }()
  503. resp := make([]*bi_dashboard.RespPublicGroupListItem, 0)
  504. // 获取公共看板列表
  505. publicCond := ` AND state = 6 AND bi_dashboard_classify_id > 0 `
  506. publicPars := []interface{}{this.SysUser.AdminId}
  507. publicList, err := bi_dashboard.GetBiDashboardList(publicCond, publicPars)
  508. if err != nil {
  509. err = errors.New("我的看板列表查询出错:" + err.Error())
  510. return
  511. }
  512. //dashboardMap := make(map[int]*bi_dashboard.BiDashboard)
  513. adminIdList := make([]int, 0) //需要查询的创建人admin_id列表集合
  514. adminIdMap := make(map[int]int) //需要查询的创建人admin_id集合,用来去重的,避免重复id
  515. publicAdminIdList := make([]int, 0)
  516. publicDashboardListMap := make(map[int][]*bi_dashboard.BiDashboard)
  517. publicDashboardClassifyIdMap := make(map[int]int)
  518. for _, v := range publicList {
  519. publicDashboardList, ok := publicDashboardListMap[v.SysAdminId]
  520. if !ok {
  521. publicDashboardList = make([]*bi_dashboard.BiDashboard, 0)
  522. publicAdminIdList = append(publicAdminIdList, v.SysAdminId)
  523. if _, ok := adminIdMap[v.SysAdminId]; !ok {
  524. adminIdList = append(adminIdList, v.SysAdminId) //需要查询的创建人admin_id列表集合
  525. adminIdMap[v.SysAdminId] = v.SysAdminId //需要查询的创建人admin_id集合,用来去重的,避免重复id
  526. }
  527. }
  528. tmp := &bi_dashboard.BiDashboard{
  529. BiDashboardId: v.BiDashboardId,
  530. BiDashboardName: v.BiDashboardName,
  531. CreateTime: v.CreateTime,
  532. ModifyTime: v.ModifyTime,
  533. Sort: v.Sort,
  534. State: v.State,
  535. SysAdminId: v.SysAdminId,
  536. SysAdminName: v.SysAdminName,
  537. }
  538. publicDashboardList = append(publicDashboardList, tmp)
  539. publicDashboardListMap[v.SysAdminId] = publicDashboardList
  540. publicDashboardClassifyIdMap[v.BiDashboardClassifyId] = v.BiDashboardClassifyId
  541. }
  542. // 创建人信息
  543. systemAdminMap := make(map[int]*system.Admin)
  544. systemAdminList, err := system.GetAdminListByIdList(adminIdList)
  545. if err != nil {
  546. return
  547. }
  548. for _, v := range systemAdminList {
  549. systemAdminMap[v.AdminId] = v
  550. }
  551. classifyList, err := bi_dashboard.GetBiDashboardClassifyAllList()
  552. if err != nil {
  553. br.Msg = "查询失败"
  554. br.ErrMsg = "查询失败,Err:" + err.Error()
  555. return
  556. }
  557. for _, c := range classifyList {
  558. tmpItem := &bi_dashboard.RespPublicGroupListItem{
  559. GroupId: int64(c.BiDashboardClassifyId),
  560. GroupName: c.BiDashboardClassifyName,
  561. Children: make([]*bi_dashboard.RespPublicGroupListItem, 0),
  562. }
  563. if _, ok := publicDashboardClassifyIdMap[c.BiDashboardClassifyId]; ok {
  564. for _, v := range publicAdminIdList {
  565. systemAdmin, ok := systemAdminMap[v]
  566. if !ok {
  567. continue
  568. }
  569. // 看板 列表信息
  570. respGroupNameListItemList, ok := publicDashboardListMap[v]
  571. if !ok {
  572. respGroupNameListItemList = make([]*bi_dashboard.BiDashboard, 0)
  573. }
  574. // ppt 分组信息
  575. tmpRespGroupListItem := &bi_dashboard.RespPublicGroupListItem{
  576. GroupId: int64(systemAdmin.AdminId),
  577. GroupName: systemAdmin.RealName,
  578. AdminId: systemAdmin.AdminId,
  579. }
  580. for _, vv := range respGroupNameListItemList {
  581. if vv.BiDashboardClassifyId == c.BiDashboardClassifyId {
  582. tmpRespGroupListItem.DashboardList = append(tmpRespGroupListItem.DashboardList, vv)
  583. tmpItem.Children = append(tmpItem.Children, tmpRespGroupListItem)
  584. }
  585. }
  586. }
  587. }
  588. resp = append(resp, tmpItem)
  589. }
  590. br.Ret = 200
  591. br.Success = true
  592. br.Msg = "查询成功"
  593. br.Data = resp
  594. return
  595. }
  596. // AddDashboardClassify
  597. // @Title 新增看板分类
  598. // @Description 新增看板分类接口
  599. // @Param request body bi_dashboard.AddDashboardClassifyReq true "type json string"
  600. // @Success 200 Ret=200 新增成功
  601. // @router /classify/add [post]
  602. func (this *BIDaShboardController) AddDashboardClassify() {
  603. br := new(models.BaseResponse).Init()
  604. defer func() {
  605. this.Data["json"] = br
  606. this.ServeJSON()
  607. }()
  608. var req bi_dashboard.AddDashboardClassifyReq
  609. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  610. if err != nil {
  611. br.Msg = "参数解析异常!"
  612. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  613. return
  614. }
  615. if req.ClassifyName == "" {
  616. br.Msg = "名称不能为空"
  617. return
  618. }
  619. maxSort, err := bi_dashboard.GetBiDashboardClassifyMaxSort()
  620. if err != nil {
  621. br.Msg = "获取最大排序值失败"
  622. br.ErrMsg = "获取最大排序值失败,Err:" + err.Error()
  623. return
  624. }
  625. item := &bi_dashboard.BiDashboardClassify{
  626. BiDashboardClassifyName: req.ClassifyName,
  627. Sort: maxSort + 1,
  628. CreateTime: time.Now(),
  629. ModifyTime: time.Now(),
  630. }
  631. _, e := bi_dashboard.AddBiDashboardClassify(item)
  632. if e != nil {
  633. err = e
  634. br.Msg = "新增失败"
  635. br.ErrMsg = "新增失败,Err:" + e.Error()
  636. return
  637. }
  638. br.Ret = 200
  639. br.Success = true
  640. br.Msg = "新增成功"
  641. //br.Data =
  642. }
  643. // EditDashboardClassify
  644. // @Title 编辑看板分类
  645. // @Description 编辑看板分类接口
  646. // @Param request body bi_dashboard.EditDashboardReq true "type json string"
  647. // @Success 200 Ret=200 编辑成功
  648. // @router /classify/edit [post]
  649. func (this *BIDaShboardController) EditDashboardClassify() {
  650. br := new(models.BaseResponse).Init()
  651. defer func() {
  652. this.Data["json"] = br
  653. this.ServeJSON()
  654. }()
  655. var req bi_dashboard.EditDashboardClassifyReq
  656. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  657. if err != nil {
  658. br.Msg = "参数解析异常!"
  659. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  660. return
  661. }
  662. if req.ClassifyName == "" {
  663. br.Msg = "标题不能为空"
  664. return
  665. }
  666. if req.BiDashboardClassifyId <= 0 {
  667. br.Msg = "参数有误"
  668. br.ErrMsg = fmt.Sprintf("参数有误, BiDashboardClassifyId: %d", req.BiDashboardClassifyId)
  669. return
  670. }
  671. item, err := bi_dashboard.GetBiDashboardClassifyById(req.BiDashboardClassifyId)
  672. if err != nil && !utils.IsErrNoRow(err) {
  673. br.Msg = "获取数据异常!"
  674. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  675. return
  676. }
  677. // 修改
  678. item.BiDashboardClassifyName = req.ClassifyName
  679. item.ModifyTime = time.Now()
  680. err = bi_dashboard.EditDashboardClassify(item)
  681. if err != nil {
  682. br.Msg = "编辑失败"
  683. br.ErrMsg = "编辑失败,Err:" + err.Error()
  684. return
  685. }
  686. br.Ret = 200
  687. br.Success = true
  688. br.Msg = "编辑成功"
  689. br.IsAddLog = true
  690. }
  691. // EditDashboardClassify
  692. // @Title 删除看板分类
  693. // @Description 删除看板分类接口
  694. // @Param request body bi_dashboard.DelDashboardClassifyReq true "type json string"
  695. // @Success 200 Ret=200 编辑成功
  696. // @router /classify/del [post]
  697. func (this *BIDaShboardController) DelDashboardClassify() {
  698. br := new(models.BaseResponse).Init()
  699. defer func() {
  700. this.Data["json"] = br
  701. this.ServeJSON()
  702. }()
  703. var req bi_dashboard.DelDashboardClassifyReq
  704. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  705. if err != nil {
  706. br.Msg = "参数解析异常!"
  707. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  708. return
  709. }
  710. if req.BiDashboardClassifyId <= 0 {
  711. br.Msg = "参数有误"
  712. br.ErrMsg = fmt.Sprintf("参数有误, BiDashboardClassifyId: %d", req.BiDashboardClassifyId)
  713. return
  714. }
  715. err = bi_dashboard.DelBiDashboardClassify(req.BiDashboardClassifyId)
  716. if err != nil {
  717. br.Msg = "编辑失败"
  718. br.ErrMsg = "编辑失败,Err:" + err.Error()
  719. return
  720. }
  721. br.Ret = 200
  722. br.Success = true
  723. br.Msg = "删除成功"
  724. br.IsAddLog = true
  725. }
  726. // Grant
  727. // @Title 分配看板权限
  728. // @Description 分配看板权限接口
  729. // @Param request body models.GrantPptReq true "type json string"
  730. // @Success 200 Ret=200 分配成功
  731. // @router /grant [post]
  732. func (this *BIDaShboardController) Grant() {
  733. br := new(models.BaseResponse).Init()
  734. defer func() {
  735. this.Data["json"] = br
  736. this.ServeJSON()
  737. }()
  738. var req bi_dashboard.GrantDashboardReq
  739. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  740. if err != nil {
  741. br.Msg = "参数解析异常!"
  742. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  743. return
  744. }
  745. if req.AdminIdStr == "" {
  746. br.Msg = "参数错误"
  747. return
  748. }
  749. if req.BiDashboardId <= 0 {
  750. br.Msg = "参数错误"
  751. return
  752. }
  753. dashboardItem, err := bi_dashboard.GetDashboardById(req.BiDashboardId)
  754. if err != nil {
  755. err = errors.New("我的看板列表查询出错:" + err.Error())
  756. br.Msg = "我的看板列表查询出错"
  757. br.ErrMsg = err.Error()
  758. return
  759. }
  760. if dashboardItem.SysAdminId != this.SysUser.AdminId {
  761. br.Msg = "无权配置"
  762. return
  763. }
  764. list := make([]*bi_dashboard.BiDashboardGrant, 0)
  765. grantAdminIdStrList := strings.Split(req.AdminIdStr, ",")
  766. lenGrantAdminIdStrList := len(grantAdminIdStrList) //指定用户的人数
  767. for _, v := range grantAdminIdStrList {
  768. grantAdminId, tmpErr := strconv.Atoi(v)
  769. if tmpErr != nil {
  770. br.Msg = "参数有误"
  771. br.ErrMsg = fmt.Sprintf("参数有误,Err:%s", tmpErr.Error())
  772. return
  773. }
  774. //如果只选择了自己作为指定的人,那么就提示他报错。如果多人,那么就过滤自己
  775. if grantAdminId == this.SysUser.AdminId {
  776. if lenGrantAdminIdStrList == 1 {
  777. br.Msg = "不能指定自己为权限用户"
  778. br.ErrMsg = fmt.Sprintf("参数有误,Err:%s", tmpErr.Error())
  779. return
  780. }
  781. continue
  782. }
  783. tmpV := &bi_dashboard.BiDashboardGrant{
  784. BiDashboardId: req.BiDashboardId,
  785. GrantAdminId: grantAdminId,
  786. CreateTime: time.Now(),
  787. }
  788. list = append(list, tmpV)
  789. }
  790. if len(list) <= 0 {
  791. br.Msg = "参数有误"
  792. br.ErrMsg = fmt.Sprintf("参数有误,Err:%s", "指定用户为空")
  793. return
  794. }
  795. err = bi_dashboard.MultiAddDashboardGrant(req.BiDashboardId, list)
  796. if err != nil {
  797. br.Msg = "分配失败"
  798. br.ErrMsg = fmt.Sprintf("分配失败,Err:%s", err.Error())
  799. return
  800. }
  801. br.Ret = 200
  802. br.Success = true
  803. br.IsAddLog = true
  804. br.Msg = "分配成功"
  805. }
  806. // Public
  807. // @Title
  808. // @Description 设置公共看板
  809. // @Param request body models.GrantPptReq true "type json string"
  810. // @Success 200 Ret=200 分配成功
  811. // @router /public [post]
  812. func (this *BIDaShboardController) Public() {
  813. br := new(models.BaseResponse).Init()
  814. defer func() {
  815. this.Data["json"] = br
  816. this.ServeJSON()
  817. }()
  818. var req bi_dashboard.PublicDashboardReq
  819. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  820. if err != nil {
  821. br.Msg = "参数解析异常!"
  822. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  823. return
  824. }
  825. // 校验是否开启了审批流
  826. opening, e := biapprove.CheckBiOpenApprove(req.ClassifyId)
  827. if e != nil {
  828. br.Msg = "操作失败"
  829. br.ErrMsg = "校验报告是否开启审批流失败, Err: " + e.Error()
  830. return
  831. }
  832. item, err := bi_dashboard.GetDashboardById(req.BiDashboardId)
  833. if err != nil && !utils.IsErrNoRow(err) {
  834. br.Msg = "获取数据异常!"
  835. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  836. return
  837. }
  838. if opening {
  839. _, err = biapprove.SubmitBiApprove(req.BiDashboardId, item.BiDashboardName, req.ClassifyId, this.SysUser.AdminId, this.SysUser.RealName)
  840. if err != nil {
  841. br.Msg = "提交审批失败"
  842. br.ErrMsg = "提交审批失败, Err: " + err.Error()
  843. return
  844. }
  845. item.State = 4
  846. } else {
  847. item.State = 6
  848. }
  849. item.BiDashboardClassifyId = req.ClassifyId
  850. err = bi_dashboard.EditDashboard(item)
  851. if err != nil {
  852. br.Msg = "编辑失败"
  853. br.ErrMsg = "编辑失败,Err:" + err.Error()
  854. return
  855. }
  856. br.Ret = 200
  857. br.Success = true
  858. br.IsAddLog = true
  859. br.Msg = "分配成功"
  860. }
  861. // GroupList
  862. // @Title 获取分类列表
  863. // @Description 获取分类列表接口
  864. // @Success 200 {object} models.RespGroupList
  865. // @router /classify/list [get]
  866. func (this *BIDaShboardController) ClassifyList() {
  867. br := new(models.BaseResponse).Init()
  868. defer func() {
  869. this.Data["json"] = br
  870. this.ServeJSON()
  871. }()
  872. classifyList, err := bi_dashboard.GetBiDashboardClassifyAllList()
  873. if err != nil {
  874. br.Msg = "查询失败"
  875. br.ErrMsg = "查询失败,Err:" + err.Error()
  876. return
  877. }
  878. br.Ret = 200
  879. br.Success = true
  880. br.Msg = "查询成功"
  881. br.Data = classifyList
  882. return
  883. }
  884. // CancelGrant
  885. // @Title 取消分配看板权限
  886. // @Description 取消分配看板权限
  887. // @Param request body bi_dashboard.DelDashboardReq true "type json string"
  888. // @Success 200 Ret=200 分配成功
  889. // @router /grant/cancel [post]
  890. func (this *BIDaShboardController) CancelGrant() {
  891. br := new(models.BaseResponse).Init()
  892. defer func() {
  893. this.Data["json"] = br
  894. this.ServeJSON()
  895. }()
  896. var req bi_dashboard.DelDashboardReq
  897. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  898. if err != nil {
  899. br.Msg = "参数解析异常!"
  900. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  901. return
  902. }
  903. if req.BiDashboardId <= 0 {
  904. br.Msg = "参数错误"
  905. return
  906. }
  907. item, err := bi_dashboard.GetDashboardById(req.BiDashboardId)
  908. if err != nil {
  909. br.Msg = "数据不存在"
  910. br.ErrMsg = "数据不存在,Err:" + err.Error()
  911. return
  912. }
  913. if item.SysAdminId != this.SysUser.AdminId {
  914. br.Msg = "无权配置"
  915. return
  916. }
  917. // 分配
  918. err = bi_dashboard.DeleteDashboardGrant(req.BiDashboardId)
  919. if err != nil {
  920. br.Msg = "取消失败"
  921. br.ErrMsg = "取消失败,Err:" + err.Error()
  922. return
  923. }
  924. br.Ret = 200
  925. br.Success = true
  926. br.IsAddLog = true
  927. br.Msg = "取消成功"
  928. }
  929. // GrantInfo
  930. // @Title 获取分配ppt权限详情
  931. // @Description 获取分配ppt权限详情接口
  932. // @Param BiDashboardId query int true "看板的id"
  933. // @Success 200 {object} models.GrantInfoResp
  934. // @router /grant/info [get]
  935. func (this *BIDaShboardController) GrantInfo() {
  936. br := new(models.BaseResponse).Init()
  937. defer func() {
  938. this.Data["json"] = br
  939. this.ServeJSON()
  940. }()
  941. biDashboardId, _ := this.GetInt("BiDashboardId")
  942. if biDashboardId <= 0 {
  943. br.Msg = "参数错误"
  944. return
  945. }
  946. item, err := bi_dashboard.GetDashboardById(biDashboardId)
  947. if err != nil {
  948. br.Msg = "数据不存在"
  949. br.ErrMsg = "数据不存在,Err:" + err.Error()
  950. return
  951. }
  952. if item.SysAdminId != this.SysUser.AdminId {
  953. br.Msg = "无权配置"
  954. return
  955. }
  956. grantInfoList, err := bi_dashboard.GetDashboardGrantInfo(biDashboardId)
  957. if err != nil {
  958. br.Msg = "信息获取失败"
  959. br.ErrMsg = "信息获取失败,Err:" + err.Error()
  960. return
  961. }
  962. if len(grantInfoList) <= 0 {
  963. br.Msg = "未配置"
  964. br.IsSendEmail = false
  965. return
  966. }
  967. var adminIdStr string
  968. adminIdsList := make([]string, 0)
  969. for _, v := range grantInfoList {
  970. adminIdsList = append(adminIdsList, strconv.Itoa(int(v.GrantAdminId)))
  971. }
  972. adminIdStr = strings.Join(adminIdsList, ",")
  973. br.Ret = 200
  974. br.Success = true
  975. br.Data = adminIdStr
  976. br.Msg = "查询成功"
  977. }