chart_classify.go 30 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025
  1. package data_manage
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/controllers"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/data_manage"
  7. "eta/eta_api/models/system"
  8. "eta/eta_api/services/data"
  9. "eta/eta_api/utils"
  10. "fmt"
  11. "strconv"
  12. "time"
  13. )
  14. // 数据管理-分类模块
  15. type ChartClassifyController struct {
  16. controllers.BaseAuthController
  17. }
  18. //
  19. //// @Title 图表分类列表
  20. //// @Description 图表分类列表接口
  21. //// @Success 200 {object} data_manage.ChartClassifyListResp
  22. //// @router /chart_classify/list [get]
  23. //func (this *ChartClassifyController) ChartClassifyList() {
  24. // br := new(models.BaseResponse).Init()
  25. // defer func() {
  26. // this.Data["json"] = br
  27. // this.ServeJSON()
  28. // }()
  29. // rootList, err := data_manage.GetChartClassifyByParentId(0)
  30. // if err != nil {
  31. // br.Msg = "获取失败"
  32. // br.ErrMsg = "获取数据失败,Err:" + err.Error()
  33. // return
  34. // }
  35. //
  36. // classifyAll, err := data_manage.GetChartClassifyAll()
  37. // if err != nil {
  38. // br.Msg = "获取失败"
  39. // br.ErrMsg = "获取数据失败,Err:" + err.Error()
  40. // return
  41. // }
  42. //
  43. // nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  44. // for k := range rootList {
  45. // rootNode := rootList[k]
  46. // data.ChartClassifyListMakeTree(classifyAll, rootNode)
  47. // nodeAll = append(nodeAll, rootNode)
  48. // }
  49. // resp := new(data_manage.ChartClassifyListResp)
  50. // resp.AllNodes = nodeAll
  51. // br.Ret = 200
  52. // br.Success = true
  53. // br.Msg = "获取成功"
  54. // br.Data = resp
  55. //}
  56. // ChartClassifyListV2
  57. // @Title 图表分类列表
  58. // @Description 图表分类列表接口
  59. // @Param IsShowMe query bool true "是否只看我的,true、false"
  60. // @Success 200 {object} data_manage.ChartClassifyListResp
  61. // @router /chart_classify/list [get]
  62. func (this *ChartClassifyController) ChartClassifyListV2() {
  63. br := new(models.BaseResponse).Init()
  64. defer func() {
  65. this.Data["json"] = br
  66. this.ServeJSON()
  67. }()
  68. resp := new(data_manage.ChartClassifyListResp)
  69. // 获取当前账号的不可见指标
  70. noPermissionChartIdMap := make(map[int]bool)
  71. {
  72. obj := data_manage.EdbInfoNoPermissionAdmin{}
  73. confList, err := obj.GetAllChartListByAdminId(this.SysUser.AdminId)
  74. if err != nil && err.Error() != utils.ErrNoRow() {
  75. br.Msg = "获取失败"
  76. br.ErrMsg = "获取不可见指标配置数据失败,Err:" + err.Error()
  77. return
  78. }
  79. for _, v := range confList {
  80. noPermissionChartIdMap[v.ChartInfoId] = true
  81. }
  82. }
  83. isShowMe, _ := this.GetBool("IsShowMe")
  84. if isShowMe {
  85. errMsg, err := getChartClassifyListForMe(*this.SysUser, resp)
  86. if err != nil {
  87. br.Msg = errMsg
  88. br.ErrMsg = err.Error()
  89. return
  90. }
  91. // 移除没有权限的图表
  92. allNodes := data.HandleNoPermissionChart(resp.AllNodes, noPermissionChartIdMap)
  93. resp.AllNodes = allNodes
  94. br.Ret = 200
  95. br.Success = true
  96. br.Msg = "获取成功"
  97. br.Data = resp
  98. fmt.Println("source my classify")
  99. return
  100. }
  101. //判断是否存在缓存,如果存在缓存,那么直接从缓存中获取
  102. key := utils.CACHE_CHART_CLASSIFY
  103. if utils.Re == nil {
  104. if utils.Re == nil && utils.Rc.IsExist(key) {
  105. if redisData, err1 := utils.Rc.RedisBytes(key); err1 == nil {
  106. err := json.Unmarshal(redisData, &resp)
  107. if err == nil && resp != nil {
  108. // 移除没有权限的图表
  109. allNodes := data.HandleNoPermissionChart(resp.AllNodes, noPermissionChartIdMap)
  110. resp.AllNodes = allNodes
  111. br.Ret = 200
  112. br.Success = true
  113. br.Msg = "获取成功"
  114. br.Data = resp
  115. fmt.Println("source redis")
  116. return
  117. }
  118. }
  119. }
  120. }
  121. rootList, err := data_manage.GetChartClassifyByParentId(0, utils.CHART_SOURCE_DEFAULT)
  122. if err != nil && err.Error() != utils.ErrNoRow() {
  123. br.Msg = "获取失败"
  124. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  125. return
  126. }
  127. classifyAll, err := data_manage.GetChartClassifyAll(utils.CHART_SOURCE_DEFAULT)
  128. if err != nil && err.Error() != utils.ErrNoRow() {
  129. br.Msg = "获取失败"
  130. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  131. return
  132. }
  133. allChartInfo, err := data_manage.GetChartInfoAll([]int{utils.CHART_SOURCE_DEFAULT})
  134. if err != nil && err.Error() != utils.ErrNoRow() {
  135. br.Msg = "获取失败"
  136. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  137. return
  138. }
  139. chartInfoMap := make(map[int][]*data_manage.ChartClassifyItems)
  140. for _, v := range allChartInfo {
  141. chartInfoMap[v.ChartClassifyId] = append(chartInfoMap[v.ChartClassifyId], v)
  142. }
  143. rootChildMap := make(map[int][]*data_manage.ChartClassifyItems)
  144. for _, v := range classifyAll {
  145. rootChildMap[v.ParentId] = append(rootChildMap[v.ParentId], v)
  146. if existItems, ok := chartInfoMap[v.ChartClassifyId]; ok {
  147. v.Children = existItems
  148. } else {
  149. items := make([]*data_manage.ChartClassifyItems, 0)
  150. v.Children = items
  151. }
  152. }
  153. nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  154. for _, v := range rootList {
  155. if existItems, ok := rootChildMap[v.ChartClassifyId]; ok {
  156. v.Children = existItems
  157. } else {
  158. items := make([]*data_manage.ChartClassifyItems, 0)
  159. v.Children = items
  160. }
  161. nodeAll = append(nodeAll, v)
  162. }
  163. //
  164. //
  165. //nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  166. //for k := range rootList {
  167. // rootNode := rootList[k]
  168. // data.ChartClassifyListMakeTree(classifyAll, rootNode)
  169. // nodeAll = append(nodeAll, rootNode)
  170. //}
  171. resp.AllNodes = nodeAll
  172. // 将数据加入缓存
  173. if utils.Re == nil {
  174. redisData, _ := json.Marshal(resp)
  175. utils.Rc.Put(key, redisData, 2*time.Hour)
  176. }
  177. // 移除没有权限的图表
  178. allNodes := data.HandleNoPermissionChart(resp.AllNodes, noPermissionChartIdMap)
  179. resp.AllNodes = allNodes
  180. br.Ret = 200
  181. br.Success = true
  182. br.Msg = "获取成功"
  183. br.Data = resp
  184. }
  185. // getChartClassifyListForMe 获取我创建的图表
  186. func getChartClassifyListForMe(adminInfo system.Admin, resp *data_manage.ChartClassifyListResp) (errMsg string, err error) {
  187. rootList, err := data_manage.GetChartClassifyByParentId(0, utils.CHART_SOURCE_DEFAULT)
  188. if err != nil && err.Error() != utils.ErrNoRow() {
  189. errMsg = "获取失败"
  190. return
  191. }
  192. classifyAll, err := data_manage.GetChartClassifyAll(utils.CHART_SOURCE_DEFAULT)
  193. if err != nil && err.Error() != utils.ErrNoRow() {
  194. errMsg = "获取失败"
  195. return
  196. }
  197. allChartInfo, err := data_manage.GetChartInfoByAdminId([]int{utils.CHART_SOURCE_DEFAULT}, adminInfo.AdminId)
  198. if err != nil && err.Error() != utils.ErrNoRow() {
  199. errMsg = "获取失败"
  200. return
  201. }
  202. chartInfoMap := make(map[int][]*data_manage.ChartClassifyItems)
  203. for _, v := range allChartInfo {
  204. chartInfoMap[v.ChartClassifyId] = append(chartInfoMap[v.ChartClassifyId], v)
  205. }
  206. rootChildMap := make(map[int][]*data_manage.ChartClassifyItems)
  207. for _, v := range classifyAll {
  208. rootChildMap[v.ParentId] = append(rootChildMap[v.ParentId], v)
  209. if existItems, ok := chartInfoMap[v.ChartClassifyId]; ok {
  210. v.Children = existItems
  211. } else {
  212. items := make([]*data_manage.ChartClassifyItems, 0)
  213. v.Children = items
  214. }
  215. }
  216. nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  217. for _, v := range rootList {
  218. if existItems, ok := rootChildMap[v.ChartClassifyId]; ok {
  219. v.Children = existItems
  220. } else {
  221. items := make([]*data_manage.ChartClassifyItems, 0)
  222. v.Children = items
  223. }
  224. nodeAll = append(nodeAll, v)
  225. }
  226. resp.AllNodes = nodeAll
  227. return
  228. }
  229. // ChartClassifyItems
  230. // @Title 获取所有图表分类接口-不包含图表
  231. // @Description 获取所有图表分类接口-不包含图表
  232. // @Success 200 {object} data_manage.ChartClassifyListResp
  233. // @router /chart_classify/items [get]
  234. func (this *ChartClassifyController) ChartClassifyItems() {
  235. br := new(models.BaseResponse).Init()
  236. defer func() {
  237. this.Data["json"] = br
  238. this.ServeJSON()
  239. }()
  240. rootList, err := data_manage.GetChartClassifyByParentId(0, utils.CHART_SOURCE_DEFAULT)
  241. if err != nil {
  242. br.Msg = "获取失败"
  243. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  244. return
  245. }
  246. classifyAll, err := data_manage.GetChartClassifyAll(utils.CHART_SOURCE_DEFAULT)
  247. if err != nil {
  248. br.Msg = "获取失败"
  249. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  250. return
  251. }
  252. nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  253. for k := range rootList {
  254. rootNode := rootList[k]
  255. data.ChartClassifyItemsMakeTree(this.SysUser, classifyAll, rootNode)
  256. nodeAll = append(nodeAll, rootNode)
  257. }
  258. language := `CN`
  259. // 指标显示的语言
  260. {
  261. configDetail, _ := system.GetConfigDetailByCode(this.SysUser.AdminId, system.ChartLanguageVar)
  262. if configDetail != nil {
  263. language = configDetail.ConfigValue
  264. } else {
  265. configDetail, _ = system.GetDefaultConfigDetailByCode(system.ChartLanguageVar)
  266. if configDetail != nil {
  267. language = configDetail.ConfigValue
  268. }
  269. }
  270. }
  271. // 是否允许添加分类
  272. canOpClassify := true
  273. // 如果不是 超管 或者 ficc管理员 或者 ficc研究员,那么就没有权限
  274. //if !utils.InArrayByStr([]string{utils.ROLE_TYPE_CODE_ADMIN, utils.ROLE_TYPE_CODE_FICC_ADMIN, utils.ROLE_TYPE_CODE_RESEARCHR, utils.ROLE_TYPE_CODE_FICC_RESEARCHR}, this.SysUser.RoleTypeCode) {
  275. // canOpClassify = false
  276. //}
  277. resp := data_manage.ChartClassifyListResp{
  278. AllNodes: nodeAll,
  279. Language: language,
  280. CanOpClassify: canOpClassify,
  281. }
  282. br.Ret = 200
  283. br.Success = true
  284. br.Msg = "获取成功"
  285. br.Data = resp
  286. }
  287. // @Title 新增图表分类
  288. // @Description 新增图表分类接口
  289. // @Param request body data_manage.AddChartClassifyReq true "type json string"
  290. // @Success 200 Ret=200 保存成功
  291. // @router /chart_classify/add [post]
  292. func (this *ChartClassifyController) AddChartClassify() {
  293. br := new(models.BaseResponse).Init()
  294. defer func() {
  295. this.Data["json"] = br
  296. this.ServeJSON()
  297. }()
  298. var req data_manage.AddChartClassifyReq
  299. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  300. if err != nil {
  301. br.Msg = "参数解析异常!"
  302. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  303. return
  304. }
  305. if req.ChartClassifyName == "" {
  306. br.Msg = "请输入分类名称"
  307. br.IsSendEmail = false
  308. return
  309. }
  310. if req.ParentId < 0 {
  311. br.Msg = "参数错误"
  312. br.IsSendEmail = false
  313. return
  314. }
  315. count, err := data_manage.GetChartClassifyCount(req.ChartClassifyName, req.ParentId, utils.CHART_SOURCE_DEFAULT)
  316. if err != nil {
  317. br.Msg = "判断名称是否已存在失败"
  318. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  319. return
  320. }
  321. if count > 0 {
  322. br.Msg = "分类名称已存在,请重新输入"
  323. br.IsSendEmail = false
  324. return
  325. }
  326. //获取该层级下最大的排序数
  327. maxSort, err := data_manage.GetChartClassifyMaxSort(req.ParentId, utils.CHART_SOURCE_DEFAULT)
  328. classify := new(data_manage.ChartClassify)
  329. classify.ParentId = req.ParentId
  330. classify.ChartClassifyName = req.ChartClassifyName
  331. classify.HasData = 0
  332. classify.CreateTime = time.Now()
  333. classify.ModifyTime = time.Now()
  334. classify.SysUserId = this.SysUser.AdminId
  335. classify.SysUserRealName = this.SysUser.RealName
  336. classify.Level = req.Level + 1
  337. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  338. classify.UniqueCode = utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
  339. classify.Sort = maxSort + 1
  340. classify.Source = utils.CHART_SOURCE_DEFAULT
  341. _, err = data_manage.AddChartClassify(classify)
  342. if err != nil {
  343. br.Msg = "保存分类失败"
  344. br.ErrMsg = "保存分类失败,Err:" + err.Error()
  345. return
  346. }
  347. br.Ret = 200
  348. br.Msg = "保存成功"
  349. br.Success = true
  350. }
  351. // @Title 修改图表分类
  352. // @Description 修改图表分类接口
  353. // @Param request body data_manage.EditChartClassifyReq true "type json string"
  354. // @Success 200 Ret=200 修改成功
  355. // @router /chart_classify/edit [post]
  356. func (this *ChartClassifyController) EditChartClassify() {
  357. br := new(models.BaseResponse).Init()
  358. defer func() {
  359. this.Data["json"] = br
  360. this.ServeJSON()
  361. }()
  362. var req data_manage.EditChartClassifyReq
  363. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  364. if err != nil {
  365. br.Msg = "参数解析异常!"
  366. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  367. return
  368. }
  369. if req.ChartClassifyName == "" {
  370. br.Msg = "请输入分类名称"
  371. br.IsSendEmail = false
  372. return
  373. }
  374. if req.ChartClassifyId <= 0 {
  375. br.Msg = "参数错误"
  376. br.IsSendEmail = false
  377. return
  378. }
  379. item, err := data_manage.GetChartClassifyById(req.ChartClassifyId)
  380. if err != nil {
  381. br.Msg = "保存失败"
  382. br.Msg = "获取分类信息失败,Err:" + err.Error()
  383. return
  384. }
  385. // 权限校验
  386. {
  387. button := data.GetChartClassifyOpButton(this.SysUser, item.SysUserId)
  388. if !button.OpButton {
  389. br.Msg = "无操作权限"
  390. br.IsSendEmail = false
  391. return
  392. }
  393. }
  394. if item.ChartClassifyName != req.ChartClassifyName {
  395. count, err := data_manage.GetChartClassifyCount(req.ChartClassifyName, item.ParentId, utils.CHART_SOURCE_DEFAULT)
  396. if err != nil {
  397. br.Msg = "判断名称是否已存在失败"
  398. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  399. return
  400. }
  401. if count > 0 {
  402. br.Msg = "分类名称已存在,请重新输入"
  403. br.IsSendEmail = false
  404. return
  405. }
  406. err = data_manage.EditChartClassify(req.ChartClassifyId, utils.CHART_SOURCE_DEFAULT, req.ChartClassifyName)
  407. if err != nil {
  408. br.Msg = "保存失败"
  409. br.ErrMsg = "保存失败,Err:" + err.Error()
  410. return
  411. }
  412. }
  413. br.Ret = 200
  414. br.Msg = "保存成功"
  415. br.Success = true
  416. br.IsAddLog = true
  417. }
  418. // @Title 删除图表检测接口
  419. // @Description 删除图表检测接口
  420. // @Param request body data_manage.ChartClassifyDeleteCheckResp true "type json string"
  421. // @Success 200 Ret=200 检测成功
  422. // @router /chart_classify/delete/check [post]
  423. func (this *ChartClassifyController) DeleteChartClassifyCheck() {
  424. br := new(models.BaseResponse).Init()
  425. defer func() {
  426. this.Data["json"] = br
  427. this.ServeJSON()
  428. }()
  429. var req data_manage.ChartClassifyDeleteCheckReq
  430. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  431. if err != nil {
  432. br.Msg = "参数解析异常!"
  433. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  434. return
  435. }
  436. if req.ChartClassifyId < 0 && req.ChartInfoId <= 0 {
  437. br.Msg = "参数错误"
  438. br.IsSendEmail = false
  439. return
  440. }
  441. var deleteStatus int
  442. var tipsMsg string
  443. //删除分类
  444. if req.ChartClassifyId > 0 && req.ChartInfoId == 0 {
  445. // 查找分类
  446. item, err := data_manage.GetChartClassifyById(req.ChartClassifyId)
  447. if err != nil {
  448. br.Msg = "保存失败"
  449. br.Msg = "获取分类信息失败,Err:" + err.Error()
  450. return
  451. }
  452. // 权限校验
  453. {
  454. button := data.GetChartClassifyOpButton(this.SysUser, item.SysUserId)
  455. if !button.OpButton {
  456. br.Msg = "无操作权限"
  457. br.IsSendEmail = false
  458. return
  459. }
  460. }
  461. //判断图表分类下,是否含有图表
  462. count, err := data_manage.GetChartInfoCountByClassifyId(req.ChartClassifyId)
  463. if err != nil {
  464. br.Msg = "删除失败"
  465. br.ErrMsg = "分类下是否含有指标失败,Err:" + err.Error()
  466. return
  467. }
  468. if count > 0 {
  469. deleteStatus = 1
  470. tipsMsg = "该分类下关联图表不可删除"
  471. }
  472. }
  473. if deleteStatus != 1 && req.ChartInfoId == 0 {
  474. classifyCount, err := data_manage.GetChartClassifyCountByClassifyId(req.ChartClassifyId)
  475. if err != nil && err.Error() != utils.ErrNoRow() {
  476. br.Msg = "删除失败"
  477. br.ErrMsg = "分类下是否含有图表失败,Err:" + err.Error()
  478. return
  479. }
  480. if classifyCount > 0 {
  481. deleteStatus = 2
  482. tipsMsg = "确认删除当前目录及包含的子目录吗"
  483. }
  484. }
  485. if deleteStatus == 0 {
  486. tipsMsg = "可删除,进行删除操作"
  487. }
  488. resp := new(data_manage.ChartClassifyDeleteCheckResp)
  489. resp.DeleteStatus = deleteStatus
  490. resp.TipsMsg = tipsMsg
  491. br.Ret = 200
  492. br.Msg = "检测成功"
  493. br.Success = true
  494. br.Data = resp
  495. }
  496. // @Title 删除图表分类/图表
  497. // @Description 删除图表分类/图表接口
  498. // @Param request body data_manage.DeleteChartClassifyReq true "type json string"
  499. // @Success 200 Ret=200 删除成功
  500. // @router /chart_classify/delete [post]
  501. func (this *ChartClassifyController) DeleteChartClassify() {
  502. br := new(models.BaseResponse).Init()
  503. defer func() {
  504. this.Data["json"] = br
  505. this.ServeJSON()
  506. }()
  507. sysUser := this.SysUser
  508. if sysUser == nil {
  509. br.Msg = "请登录"
  510. br.ErrMsg = "请登录,SysUser Is Empty"
  511. br.Ret = 408
  512. return
  513. }
  514. var req data_manage.DeleteChartClassifyReq
  515. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  516. if err != nil {
  517. br.Msg = "参数解析异常!"
  518. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  519. return
  520. }
  521. if req.ChartClassifyId < 0 && req.ChartInfoId <= 0 {
  522. br.Msg = "参数错误"
  523. br.IsSendEmail = false
  524. return
  525. }
  526. //删除分类
  527. if req.ChartClassifyId > 0 && req.ChartInfoId == 0 {
  528. // 查找分类
  529. item, err := data_manage.GetChartClassifyById(req.ChartClassifyId)
  530. if err != nil {
  531. br.Msg = "保存失败"
  532. br.Msg = "获取分类信息失败,Err:" + err.Error()
  533. return
  534. }
  535. // 权限校验
  536. {
  537. button := data.GetChartClassifyOpButton(this.SysUser, item.SysUserId)
  538. if !button.OpButton {
  539. br.Msg = "无操作权限"
  540. br.IsSendEmail = false
  541. return
  542. }
  543. }
  544. //判断是否含有指标
  545. count, err := data_manage.GetChartInfoCountByClassifyId(req.ChartClassifyId)
  546. if err != nil && err.Error() != utils.ErrNoRow() {
  547. br.Msg = "删除失败"
  548. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  549. return
  550. }
  551. if count > 0 {
  552. br.Msg = "该目录下存在关联指标,不可删除"
  553. br.IsSendEmail = false
  554. return
  555. }
  556. err = data_manage.DeleteChartClassify(req.ChartClassifyId)
  557. if err != nil {
  558. br.Msg = "删除失败"
  559. br.ErrMsg = "删除失败,Err:" + err.Error()
  560. return
  561. }
  562. }
  563. resp := new(data_manage.AddChartInfoResp)
  564. //删除图表
  565. if req.ChartInfoId > 0 {
  566. chartInfo, err := data_manage.GetChartInfoById(req.ChartInfoId)
  567. if err != nil {
  568. if err.Error() == utils.ErrNoRow() {
  569. br.Msg = "图表已删除,请刷新页面"
  570. br.ErrMsg = "指标不存在,Err:" + err.Error()
  571. return
  572. } else {
  573. br.Msg = "删除失败"
  574. br.ErrMsg = "删除失败,获取指标信息失败,Err:" + err.Error()
  575. return
  576. }
  577. }
  578. if chartInfo == nil {
  579. br.Msg = "图表已删除,请刷新页面"
  580. return
  581. }
  582. //图表操作权限
  583. ok := data.CheckOpChartPermission(sysUser, chartInfo.SysUserId)
  584. if !ok {
  585. br.Msg = "没有该图表的操作权限"
  586. br.ErrMsg = "没有该图表的操作权限"
  587. return
  588. }
  589. // 获取引用该图表的MyCharts, 用于ES删除
  590. var myCond string
  591. var myPars []interface{}
  592. myCond += ` AND a.chart_info_id = ? `
  593. myPars = append(myPars, req.ChartInfoId)
  594. myCharts, e := data_manage.GetMyChartListGroupByCharyInfoIdAndAdminIdByCondition(myCond, myPars)
  595. if e != nil {
  596. br.Msg = "删除失败"
  597. br.ErrMsg = "获取引用图表的MyChats失败, Err: " + e.Error()
  598. return
  599. }
  600. myIds := make([]int, 0)
  601. for _, m := range myCharts {
  602. myIds = append(myIds, m.MyChartId)
  603. }
  604. //删除图表及关联指标
  605. err = data_manage.DeleteChartInfoAndData(req.ChartInfoId)
  606. if err != nil {
  607. br.Msg = "删除失败"
  608. br.ErrMsg = "删除失败,Err:" + err.Error()
  609. return
  610. }
  611. //删除ES
  612. {
  613. go data.EsDeleteChartInfo(req.ChartInfoId)
  614. // 删除MY ETA 图表 es数据
  615. //go data.EsDeleteMyChartInfoByChartInfoId(req.ChartInfoId)
  616. go data.EsDeleteMyChartInfoByMyChartIds(myIds)
  617. }
  618. var condition string
  619. var pars []interface{}
  620. condition += " AND chart_classify_id=? AND source = ? "
  621. pars = append(pars, chartInfo.ChartClassifyId, utils.CHART_SOURCE_DEFAULT)
  622. condition += " AND chart_info_id>? ORDER BY create_time ASC LIMIT 1 "
  623. pars = append(pars, req.ChartInfoId)
  624. nextItem, err := data_manage.GetChartInfoByCondition(condition, pars)
  625. if err != nil && err.Error() != utils.ErrNoRow() {
  626. br.Msg = "删除失败"
  627. br.ErrMsg = "获取下一级图库信息失败,Err:" + err.Error()
  628. return
  629. }
  630. if nextItem != nil {
  631. resp.UniqueCode = nextItem.UniqueCode
  632. resp.ChartInfoId = nextItem.ChartInfoId
  633. } else {
  634. var condition string
  635. var pars []interface{}
  636. condition += " AND level=3 "
  637. //pars = append(pars, chartInfo.ChartClassifyId)
  638. condition += " AND chart_classify_id>? ORDER BY chart_classify_id ASC LIMIT 1 "
  639. pars = append(pars, chartInfo.ChartClassifyId)
  640. classifyItem, err := data_manage.GetChartClassifyByCondition(condition, pars)
  641. if err != nil && err.Error() != utils.ErrNoRow() {
  642. br.Msg = "删除失败"
  643. br.ErrMsg = "获取下一级图库分类信息失败,Err:" + err.Error()
  644. return
  645. }
  646. if classifyItem != nil {
  647. nextItem, err = data_manage.GetNextChartInfo(chartInfo.ChartClassifyId)
  648. if err != nil && err.Error() != utils.ErrNoRow() {
  649. br.Msg = "删除失败"
  650. br.ErrMsg = "获取下一级图库信息失败,Err:" + err.Error()
  651. return
  652. }
  653. if nextItem != nil {
  654. resp.UniqueCode = nextItem.UniqueCode
  655. resp.ChartInfoId = nextItem.ChartInfoId
  656. }
  657. }
  658. }
  659. //新增操作日志
  660. {
  661. chartLog := new(data_manage.ChartInfoLog)
  662. chartLog.ChartName = chartInfo.ChartName
  663. chartLog.ChartInfoId = req.ChartInfoId
  664. chartLog.ChartClassifyId = chartInfo.ChartClassifyId
  665. chartLog.SysUserId = sysUser.AdminId
  666. chartLog.SysUserRealName = sysUser.RealName
  667. chartLog.UniqueCode = chartInfo.UniqueCode
  668. chartLog.CreateTime = time.Now()
  669. chartLog.Content = string(this.Ctx.Input.RequestBody)
  670. chartLog.Status = "删除图表"
  671. chartLog.Method = this.Ctx.Input.URI()
  672. go data_manage.AddChartInfoLog(chartLog)
  673. }
  674. }
  675. br.Ret = 200
  676. br.Msg = "删除成功"
  677. br.Success = true
  678. br.Data = resp
  679. br.IsAddLog = true
  680. }
  681. // ChartClassifyMove
  682. // @Title 图表分类移动接口
  683. // @Description 图表分类移动接口
  684. // @Success 200 {object} data_manage.MoveChartClassifyReq
  685. // @router /chart_classify/move [post]
  686. func (this *ChartClassifyController) ChartClassifyMove() {
  687. br := new(models.BaseResponse).Init()
  688. defer func() {
  689. if br.ErrMsg == "" {
  690. br.IsSendEmail = false
  691. }
  692. this.Data["json"] = br
  693. this.ServeJSON()
  694. }()
  695. sysUser := this.SysUser
  696. if sysUser == nil {
  697. br.Msg = "请登录"
  698. br.ErrMsg = "请登录,SysUser Is Empty"
  699. br.Ret = 408
  700. return
  701. }
  702. var req data_manage.MoveChartClassifyReq
  703. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  704. if err != nil {
  705. br.Msg = "参数解析异常!"
  706. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  707. return
  708. }
  709. if req.ClassifyId <= 0 {
  710. br.Msg = "参数错误"
  711. br.ErrMsg = "分类id小于等于0"
  712. return
  713. }
  714. //判断分类是否存在
  715. chartClassifyInfo, err := data_manage.GetChartClassifyById(req.ClassifyId)
  716. if err != nil {
  717. if err.Error() == utils.ErrNoRow() {
  718. br.Msg = "分类不存在,请刷新页面"
  719. return
  720. }
  721. br.Msg = "移动失败"
  722. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  723. return
  724. }
  725. // 校验移动的父级目录下是否有重名分类
  726. exists, e := data_manage.GetChartClassifyByParentIdAndName(req.ParentClassifyId, chartClassifyInfo.ChartClassifyName, req.ClassifyId)
  727. if e != nil && e.Error() != utils.ErrNoRow() {
  728. br.Msg = "移动失败"
  729. br.ErrMsg = "获取父级目录下的同名分类失败, Err: " + e.Error()
  730. return
  731. }
  732. if exists != nil {
  733. br.Msg = "移动失败,分类名称已存在"
  734. return
  735. }
  736. // 权限校验
  737. {
  738. button := data.GetChartClassifyOpButton(this.SysUser, chartClassifyInfo.SysUserId)
  739. if !button.OpButton {
  740. br.Msg = "无操作权限"
  741. br.IsSendEmail = false
  742. return
  743. }
  744. }
  745. if chartClassifyInfo.Source != utils.CHART_SOURCE_DEFAULT {
  746. br.Msg = "分类异常"
  747. br.ErrMsg = "分类异常,不是ETA图库的分类"
  748. return
  749. }
  750. updateCol := make([]string, 0)
  751. //判断上级id是否一致,如果不一致的话,那么需要移动该分类层级
  752. if chartClassifyInfo.ParentId != req.ParentClassifyId && req.ParentClassifyId != 0 {
  753. parentChartClassifyInfo, err := data_manage.GetChartClassifyById(req.ParentClassifyId)
  754. if err != nil {
  755. br.Msg = "移动失败"
  756. br.ErrMsg = "获取上级分类信息失败,Err:" + err.Error()
  757. return
  758. }
  759. chartClassifyInfo.ParentId = parentChartClassifyInfo.ChartClassifyId
  760. chartClassifyInfo.Level = parentChartClassifyInfo.Level + 1
  761. chartClassifyInfo.ModifyTime = time.Now()
  762. updateCol = append(updateCol, "ParentId", "Level", "ModifyTime")
  763. }
  764. //如果有传入 上一个兄弟节点分类id
  765. if req.PrevClassifyId > 0 {
  766. //上一个兄弟节点
  767. prevClassify, err := data_manage.GetChartClassifyById(req.PrevClassifyId)
  768. if err != nil {
  769. br.Msg = "移动失败"
  770. br.ErrMsg = "获取上一个兄弟节点分类信息失败,Err:" + err.Error()
  771. return
  772. }
  773. //如果是移动在两个兄弟节点之间
  774. if req.NextClassifyId > 0 {
  775. //下一个兄弟节点
  776. nextClassify, err := data_manage.GetChartClassifyById(req.NextClassifyId)
  777. if err != nil {
  778. br.Msg = "移动失败"
  779. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  780. return
  781. }
  782. //如果上一个兄弟与下一个兄弟的排序权重是一致的,那么需要将下一个兄弟(以及下个兄弟的同样排序权重)的排序权重+2,自己变成上一个兄弟的排序权重+1
  783. if prevClassify.Sort == nextClassify.Sort || prevClassify.Sort == chartClassifyInfo.Sort {
  784. //变更兄弟节点的排序
  785. updateSortStr := `sort + 2`
  786. _ = data_manage.UpdateChartClassifySortByParentId(prevClassify.ParentId, prevClassify.ChartClassifyId, prevClassify.Sort, updateSortStr)
  787. } else {
  788. //如果下一个兄弟的排序权重正好是上个兄弟节点的下一层,那么需要再加一层了
  789. if nextClassify.Sort-prevClassify.Sort == 1 {
  790. //变更兄弟节点的排序
  791. updateSortStr := `sort + 1`
  792. _ = data_manage.UpdateChartClassifySortByParentId(prevClassify.ParentId, 0, prevClassify.Sort, updateSortStr)
  793. }
  794. }
  795. }
  796. chartClassifyInfo.Sort = prevClassify.Sort + 1
  797. chartClassifyInfo.ModifyTime = time.Now()
  798. updateCol = append(updateCol, "Sort", "ModifyTime")
  799. } else {
  800. firstClassify, err := data_manage.GetFirstChartClassifyByParentId(chartClassifyInfo.ParentId)
  801. if err != nil && err.Error() != utils.ErrNoRow() {
  802. br.Msg = "移动失败"
  803. br.ErrMsg = "获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + err.Error()
  804. return
  805. }
  806. //如果该分类下存在其他分类,且第一个其他分类的排序等于0,那么需要调整排序
  807. if firstClassify != nil && firstClassify.Sort == 0 {
  808. updateSortStr := ` sort + 1 `
  809. _ = data_manage.UpdateChartClassifySortByParentId(firstClassify.ParentId, firstClassify.ChartClassifyId-1, 0, updateSortStr)
  810. }
  811. chartClassifyInfo.Sort = 0 //那就是排在第一位
  812. chartClassifyInfo.ModifyTime = time.Now()
  813. updateCol = append(updateCol, "Sort", "ModifyTime")
  814. }
  815. //更新
  816. if len(updateCol) > 0 {
  817. err = chartClassifyInfo.Update(updateCol)
  818. if err != nil {
  819. br.Msg = "移动失败"
  820. br.ErrMsg = "修改失败,Err:" + err.Error()
  821. return
  822. }
  823. }
  824. br.Ret = 200
  825. br.Success = true
  826. br.Msg = "移动成功"
  827. }
  828. // getChartClassifyListForMe 获取我创建的图表分类
  829. func getChartClassifyListForMeV2(adminInfo system.Admin, resp *data_manage.ChartClassifyListResp) (errMsg string, err error) {
  830. rootList, err := data_manage.GetChartClassifyByParentId(0, utils.CHART_SOURCE_DEFAULT)
  831. if err != nil && err.Error() != utils.ErrNoRow() {
  832. errMsg = "获取失败"
  833. return
  834. }
  835. classifyAll, err := data_manage.GetChartClassifyAll(utils.CHART_SOURCE_DEFAULT)
  836. if err != nil && err.Error() != utils.ErrNoRow() {
  837. errMsg = "获取失败"
  838. return
  839. }
  840. rootChildMap := make(map[int][]*data_manage.ChartClassifyItems)
  841. for _, v := range classifyAll {
  842. rootChildMap[v.ParentId] = append(rootChildMap[v.ParentId], v)
  843. }
  844. nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  845. for _, v := range rootList {
  846. if existItems, ok := rootChildMap[v.ChartClassifyId]; ok {
  847. v.Children = existItems
  848. } else {
  849. items := make([]*data_manage.ChartClassifyItems, 0)
  850. v.Children = items
  851. }
  852. nodeAll = append(nodeAll, v)
  853. }
  854. resp.AllNodes = nodeAll
  855. return
  856. }
  857. // ChartClassifyChartListV2
  858. // @Title 根据图表分类获取图表列表
  859. // @Description 根据图表分类获取图表列表接口
  860. // @Param IsShowMe query bool true "是否只看我的,true、false"
  861. // @Param ChartClassifyId query bool true "图片分类id"
  862. // @Success 200 {object} data_manage.ChartClassifyListResp
  863. // @router /chart_classify/chart/list [get]
  864. func (this *ChartClassifyController) ChartClassifyChartListV2() {
  865. br := new(models.BaseResponse).Init()
  866. defer func() {
  867. this.Data["json"] = br
  868. this.ServeJSON()
  869. }()
  870. sysUser := this.SysUser
  871. if sysUser == nil {
  872. br.Msg = "请登录"
  873. br.ErrMsg = "请登录,SysUser Is Empty"
  874. br.Ret = 408
  875. return
  876. }
  877. resp := new(data_manage.ChartClassifyListResp)
  878. chartClassifyId, _ := this.GetInt("ChartClassifyId")
  879. if chartClassifyId <= 0 {
  880. br.Msg = "参数错误"
  881. return
  882. }
  883. // 获取当前账号的不可见指标
  884. noPermissionChartIdMap := make(map[int]bool)
  885. {
  886. obj := data_manage.EdbInfoNoPermissionAdmin{}
  887. confList, err := obj.GetAllChartListByAdminId(this.SysUser.AdminId)
  888. if err != nil && err.Error() != utils.ErrNoRow() {
  889. br.Msg = "获取失败"
  890. br.ErrMsg = "获取不可见指标配置数据失败,Err:" + err.Error()
  891. return
  892. }
  893. for _, v := range confList {
  894. noPermissionChartIdMap[v.ChartInfoId] = true
  895. }
  896. }
  897. isShowMe, _ := this.GetBool("IsShowMe")
  898. if isShowMe {
  899. allChartInfo, err := data_manage.GetChartInfoByAdminIdAndClassify([]int{utils.CHART_SOURCE_DEFAULT}, sysUser.AdminId, chartClassifyId)
  900. if err != nil && err.Error() != utils.ErrNoRow() {
  901. br.Msg = "获取失败"
  902. br.ErrMsg = "获取全部数据失败,Err:" + err.Error()
  903. return
  904. }
  905. // 移除没有权限的图表
  906. allNodes := data.HandleNoPermissionChart(allChartInfo, noPermissionChartIdMap)
  907. resp.AllNodes = allNodes
  908. br.Ret = 200
  909. br.Success = true
  910. br.Msg = "获取成功"
  911. br.Data = resp
  912. fmt.Println("source my classify")
  913. return
  914. }
  915. allChartInfo, err := data_manage.GetChartInfoAllByClassifyId(utils.CHART_SOURCE_DEFAULT, chartClassifyId)
  916. if err != nil && err.Error() != utils.ErrNoRow() {
  917. br.Msg = "获取失败"
  918. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  919. return
  920. }
  921. // 移除没有权限的图表
  922. allNodes := data.HandleNoPermissionChart(allChartInfo, noPermissionChartIdMap)
  923. for k, item := range allNodes {
  924. item.Button = data.GetChartOpButton(this.SysUser, item.SysUserId)
  925. item.Button.AddButton = false
  926. item.Button.OpButton = false
  927. item.Button.DeleteButton = false
  928. allNodes[k] = item
  929. }
  930. resp.AllNodes = allNodes
  931. br.Ret = 200
  932. br.Success = true
  933. br.Msg = "获取成功"
  934. br.Data = resp
  935. }