chart_classify.go 33 KB

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