line_chart_classify.go 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699
  1. package line_equation
  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. "strconv"
  11. "time"
  12. )
  13. // LineEquationChartClassifyController 拟合方程图表分类
  14. type LineEquationChartClassifyController struct {
  15. controllers.BaseAuthController
  16. }
  17. // ChartClassifyList
  18. // @Title 拟合方程图表分类列表
  19. // @Description 拟合方程图表分类列表接口
  20. // @Param IsShowMe query bool true "是否只看我的,true、false"
  21. // @Param Source query int true "图表类型,3:拟合方程,4:滚动拟合方程"
  22. // @Success 200 {object} data_manage.ChartClassifyListResp
  23. // @router /chart_classify/list [get]
  24. func (this *LineEquationChartClassifyController) ChartClassifyList() {
  25. br := new(models.BaseResponse).Init()
  26. defer func() {
  27. this.Data["json"] = br
  28. this.ServeJSON()
  29. }()
  30. resp := new(data_manage.ChartClassifyListResp)
  31. // 获取当前账号的不可见指标
  32. noPermissionChartIdMap := make(map[int]bool)
  33. {
  34. obj := data_manage.EdbInfoNoPermissionAdmin{}
  35. confList, err := obj.GetAllChartListByAdminId(this.SysUser.AdminId)
  36. if err != nil && err.Error() != utils.ErrNoRow() {
  37. br.Msg = "获取失败"
  38. br.ErrMsg = "获取不可见指标配置数据失败,Err:" + err.Error()
  39. return
  40. }
  41. for _, v := range confList {
  42. noPermissionChartIdMap[v.ChartInfoId] = true
  43. }
  44. }
  45. isShowMe, _ := this.GetBool("IsShowMe")
  46. if isShowMe {
  47. errMsg, err := getChartClassifyListForMe(*this.SysUser, resp)
  48. if err != nil {
  49. br.Msg = errMsg
  50. br.ErrMsg = err.Error()
  51. return
  52. }
  53. br.Ret = 200
  54. br.Success = true
  55. br.Msg = "获取成功"
  56. br.Data = resp
  57. return
  58. }
  59. source := utils.CHART_SOURCE_LINE_EQUATION
  60. rootList, err := data_manage.GetChartClassifyByParentId(0, source)
  61. if err != nil && err.Error() != utils.ErrNoRow() {
  62. br.Msg = "获取失败"
  63. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  64. return
  65. }
  66. allChartInfo, err := data_manage.GetChartInfoAll([]int{source})
  67. if err != nil && err.Error() != utils.ErrNoRow() {
  68. br.Msg = "获取失败"
  69. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  70. return
  71. }
  72. chartInfoMap := make(map[int][]*data_manage.ChartClassifyItems)
  73. for _, v := range allChartInfo {
  74. if !isShowMe {
  75. chartInfoMap[v.ChartClassifyId] = append(chartInfoMap[v.ChartClassifyId], v)
  76. continue
  77. }
  78. if v.SysUserId != this.SysUser.AdminId {
  79. continue
  80. }
  81. chartInfoMap[v.ChartClassifyId] = append(chartInfoMap[v.ChartClassifyId], v)
  82. }
  83. rootChildMap := make(map[int][]*data_manage.ChartClassifyItems)
  84. for _, v := range rootList {
  85. rootChildMap[v.ParentId] = append(rootChildMap[v.ParentId], v)
  86. if existItems, ok := chartInfoMap[v.ChartClassifyId]; ok {
  87. v.Children = existItems
  88. } else {
  89. items := make([]*data_manage.ChartClassifyItems, 0)
  90. v.Children = items
  91. }
  92. }
  93. // 移除没有权限的图表
  94. allNodes := data.HandleNoPermissionChart(rootList, noPermissionChartIdMap)
  95. resp.AllNodes = allNodes
  96. br.Ret = 200
  97. br.Success = true
  98. br.Msg = "获取成功"
  99. br.Data = resp
  100. }
  101. // getChartClassifyListForMe 获取我创建的图表
  102. func getChartClassifyListForMe(adminInfo system.Admin, resp *data_manage.ChartClassifyListResp) (errMsg string, err error) {
  103. // 获取所有的分类
  104. rootList, err := data_manage.GetChartClassifyByParentId(0, utils.CHART_SOURCE_LINE_EQUATION)
  105. if err != nil && err.Error() != utils.ErrNoRow() {
  106. errMsg = "获取失败"
  107. return
  108. }
  109. // /获取所有的图表
  110. allChartInfo, err := data_manage.GetChartInfoByAdminId([]int{utils.CHART_SOURCE_LINE_EQUATION}, adminInfo.AdminId)
  111. if err != nil && err.Error() != utils.ErrNoRow() {
  112. errMsg = "获取失败"
  113. return
  114. }
  115. chartInfoMap := make(map[int][]*data_manage.ChartClassifyItems)
  116. for _, v := range allChartInfo {
  117. chartInfoMap[v.ChartClassifyId] = append(chartInfoMap[v.ChartClassifyId], v)
  118. }
  119. for k, v := range rootList {
  120. if existItems, ok := chartInfoMap[v.ChartClassifyId]; ok {
  121. v.Children = existItems
  122. } else {
  123. items := make([]*data_manage.ChartClassifyItems, 0)
  124. v.Children = items
  125. }
  126. rootList[k] = v
  127. }
  128. resp.AllNodes = rootList
  129. return
  130. }
  131. // ChartClassifyItems
  132. // @Title 获取所有拟合方程图表分类接口-不包含图表
  133. // @Description 获取所有拟合方程图表分类接口-不包含图表
  134. // @Success 200 {object} data_manage.ChartClassifyListResp
  135. // @router /chart_classify/items [get]
  136. func (this *LineEquationChartClassifyController) ChartClassifyItems() {
  137. br := new(models.BaseResponse).Init()
  138. defer func() {
  139. this.Data["json"] = br
  140. this.ServeJSON()
  141. }()
  142. rootList, err := data_manage.GetChartClassifyByParentId(0, utils.CHART_SOURCE_LINE_EQUATION)
  143. if err != nil {
  144. br.Msg = "获取失败"
  145. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  146. return
  147. }
  148. nodeAll := make([]*data_manage.ChartClassifyItems, 0)
  149. for k := range rootList {
  150. rootNode := rootList[k]
  151. nodeAll = append(nodeAll, rootNode)
  152. }
  153. resp := new(data_manage.ChartClassifyListResp)
  154. resp.AllNodes = nodeAll
  155. br.Ret = 200
  156. br.Success = true
  157. br.Msg = "获取成功"
  158. br.Data = resp
  159. }
  160. // AddChartClassify
  161. // @Title 新增拟合方程图表分类
  162. // @Description 新增拟合方程图表分类接口
  163. // @Param request body data_manage.AddChartClassifyReq true "type json string"
  164. // @Success 200 Ret=200 保存成功
  165. // @router /chart_classify/add [post]
  166. func (this *LineEquationChartClassifyController) AddChartClassify() {
  167. br := new(models.BaseResponse).Init()
  168. defer func() {
  169. this.Data["json"] = br
  170. this.ServeJSON()
  171. }()
  172. var req data_manage.AddChartClassifyReq
  173. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  174. if err != nil {
  175. br.Msg = "参数解析异常!"
  176. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  177. return
  178. }
  179. if req.ChartClassifyName == "" {
  180. br.Msg = "请输入分类名称"
  181. br.IsSendEmail = false
  182. return
  183. }
  184. if req.ParentId < 0 {
  185. br.Msg = "参数错误"
  186. br.IsSendEmail = false
  187. return
  188. }
  189. source := utils.CHART_SOURCE_LINE_EQUATION
  190. count, err := data_manage.GetChartClassifyCount(req.ChartClassifyName, req.ParentId, source)
  191. if err != nil {
  192. br.Msg = "判断名称是否已存在失败"
  193. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  194. return
  195. }
  196. if count > 0 {
  197. br.Msg = "分类名称已存在,请重新输入"
  198. br.IsSendEmail = false
  199. return
  200. }
  201. //获取该层级下最大的排序数
  202. maxSort, err := data_manage.GetChartClassifyMaxSort(req.ParentId, source)
  203. classify := new(data_manage.ChartClassify)
  204. //classify.ParentId = req.ParentId
  205. classify.ParentId = 0
  206. classify.ChartClassifyName = req.ChartClassifyName
  207. classify.HasData = 0
  208. classify.CreateTime = time.Now()
  209. classify.ModifyTime = time.Now()
  210. classify.SysUserId = this.SysUser.AdminId
  211. classify.SysUserRealName = this.SysUser.RealName
  212. classify.Level = req.Level + 1
  213. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  214. classify.UniqueCode = utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
  215. classify.Sort = maxSort + 1
  216. classify.Source = source
  217. _, err = data_manage.AddChartClassify(classify)
  218. if err != nil {
  219. br.Msg = "保存分类失败"
  220. br.ErrMsg = "保存分类失败,Err:" + err.Error()
  221. return
  222. }
  223. br.Ret = 200
  224. br.Msg = "添加成功"
  225. br.Success = true
  226. }
  227. // EditChartClassify
  228. // @Title 修改拟合方程图表分类
  229. // @Description 修改拟合方程图表分类接口
  230. // @Param request body data_manage.EditChartClassifyReq true "type json string"
  231. // @Success 200 Ret=200 修改成功
  232. // @router /chart_classify/edit [post]
  233. func (this *LineEquationChartClassifyController) EditChartClassify() {
  234. br := new(models.BaseResponse).Init()
  235. defer func() {
  236. this.Data["json"] = br
  237. this.ServeJSON()
  238. }()
  239. var req data_manage.EditChartClassifyReq
  240. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  241. if err != nil {
  242. br.Msg = "参数解析异常!"
  243. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  244. return
  245. }
  246. if req.ChartClassifyName == "" {
  247. br.Msg = "请输入分类名称"
  248. br.IsSendEmail = false
  249. return
  250. }
  251. if req.ChartClassifyId <= 0 {
  252. br.Msg = "参数错误"
  253. br.IsSendEmail = false
  254. return
  255. }
  256. item, err := data_manage.GetChartClassifyById(req.ChartClassifyId)
  257. if err != nil {
  258. br.Msg = "保存失败"
  259. br.Msg = "获取分类信息失败,Err:" + err.Error()
  260. return
  261. }
  262. source := utils.CHART_SOURCE_LINE_EQUATION
  263. if item.ChartClassifyName != req.ChartClassifyName {
  264. count, err := data_manage.GetChartClassifyCount(req.ChartClassifyName, item.ParentId, source)
  265. if err != nil {
  266. br.Msg = "判断名称是否已存在失败"
  267. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  268. return
  269. }
  270. if count > 0 {
  271. br.Msg = "分类名称已存在,请重新输入"
  272. br.IsSendEmail = false
  273. return
  274. }
  275. err = data_manage.EditChartClassify(req.ChartClassifyId, source, req.ChartClassifyName)
  276. if err != nil {
  277. br.Msg = "保存失败"
  278. br.ErrMsg = "保存失败,Err:" + err.Error()
  279. return
  280. }
  281. }
  282. br.Ret = 200
  283. br.Msg = "修改成功"
  284. br.Success = true
  285. br.IsAddLog = true
  286. }
  287. // DeleteChartClassifyCheck
  288. // @Title 删除图表检测接口
  289. // @Description 删除图表检测接口
  290. // @Param request body data_manage.ChartClassifyDeleteCheckResp true "type json string"
  291. // @Success 200 Ret=200 检测成功
  292. // @router /chart_classify/delete/check [post]
  293. func (this *LineEquationChartClassifyController) DeleteChartClassifyCheck() {
  294. br := new(models.BaseResponse).Init()
  295. defer func() {
  296. this.Data["json"] = br
  297. this.ServeJSON()
  298. }()
  299. var req data_manage.ChartClassifyDeleteCheckReq
  300. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  301. if err != nil {
  302. br.Msg = "参数解析异常!"
  303. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  304. return
  305. }
  306. if req.ChartClassifyId < 0 && req.ChartInfoId <= 0 {
  307. br.Msg = "参数错误"
  308. br.IsSendEmail = false
  309. return
  310. }
  311. var deleteStatus int
  312. var tipsMsg string
  313. //删除分类
  314. if req.ChartClassifyId > 0 && req.ChartInfoId == 0 {
  315. //判断拟合方程图表分类下,是否含有图表
  316. count, err := data_manage.GetChartInfoCountByClassifyId(req.ChartClassifyId)
  317. if err != nil {
  318. br.Msg = "删除失败"
  319. br.ErrMsg = "分类下是否含有图表失败,Err:" + err.Error()
  320. return
  321. }
  322. if count > 0 {
  323. deleteStatus = 1
  324. tipsMsg = "该分类下关联图表不可删除"
  325. }
  326. }
  327. if deleteStatus != 1 && req.ChartInfoId == 0 {
  328. classifyCount, err := data_manage.GetChartClassifyCountByClassifyId(req.ChartClassifyId)
  329. if err != nil && err.Error() != utils.ErrNoRow() {
  330. br.Msg = "删除失败"
  331. br.ErrMsg = "分类下是否含有图表失败,Err:" + err.Error()
  332. return
  333. }
  334. if classifyCount > 0 {
  335. deleteStatus = 2
  336. tipsMsg = "确认删除当前目录及包含的子目录吗"
  337. }
  338. }
  339. if deleteStatus == 0 {
  340. tipsMsg = "可删除,进行删除操作"
  341. }
  342. resp := new(data_manage.ChartClassifyDeleteCheckResp)
  343. resp.DeleteStatus = deleteStatus
  344. resp.TipsMsg = tipsMsg
  345. br.Ret = 200
  346. br.Msg = "检测成功"
  347. br.Success = true
  348. br.Data = resp
  349. }
  350. // DeleteChartClassify
  351. // @Title 删除拟合方程图表分类/图表
  352. // @Description 删除拟合方程图表分类/图表接口
  353. // @Param request body data_manage.DeleteChartClassifyReq true "type json string"
  354. // @Success 200 Ret=200 删除成功
  355. // @router /chart_classify/delete [post]
  356. func (this *LineEquationChartClassifyController) DeleteChartClassify() {
  357. br := new(models.BaseResponse).Init()
  358. defer func() {
  359. this.Data["json"] = br
  360. this.ServeJSON()
  361. }()
  362. sysUser := this.SysUser
  363. if sysUser == nil {
  364. br.Msg = "请登录"
  365. br.ErrMsg = "请登录,SysUser Is Empty"
  366. br.Ret = 408
  367. return
  368. }
  369. var req data_manage.DeleteChartClassifyReq
  370. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  371. if err != nil {
  372. br.Msg = "参数解析异常!"
  373. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  374. return
  375. }
  376. if req.ChartClassifyId < 0 && req.ChartInfoId <= 0 {
  377. br.Msg = "参数错误"
  378. br.IsSendEmail = false
  379. return
  380. }
  381. //删除分类
  382. if req.ChartClassifyId > 0 && req.ChartInfoId == 0 {
  383. //判断是否含有指标
  384. count, err := data_manage.GetChartInfoCountByClassifyId(req.ChartClassifyId)
  385. if err != nil && err.Error() != utils.ErrNoRow() {
  386. br.Msg = "删除失败"
  387. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  388. return
  389. }
  390. if count > 0 {
  391. br.Msg = "该目录下存在关联指标,不可删除"
  392. br.IsSendEmail = false
  393. return
  394. }
  395. err = data_manage.DeleteChartClassify(req.ChartClassifyId)
  396. if err != nil {
  397. br.Msg = "删除失败"
  398. br.ErrMsg = "删除失败,Err:" + err.Error()
  399. return
  400. }
  401. }
  402. resp := new(data_manage.AddChartInfoResp)
  403. //删除图表
  404. if req.ChartInfoId > 0 {
  405. chartInfo, err := data_manage.GetChartInfoById(req.ChartInfoId)
  406. if err != nil {
  407. if err.Error() == utils.ErrNoRow() {
  408. br.Msg = "图表已删除,请刷新页面"
  409. br.ErrMsg = "指标不存在,Err:" + err.Error()
  410. return
  411. } else {
  412. br.Msg = "删除失败"
  413. br.ErrMsg = "删除失败,获取指标信息失败,Err:" + err.Error()
  414. return
  415. }
  416. }
  417. if chartInfo == nil {
  418. br.Msg = "图表已删除,请刷新页面"
  419. return
  420. }
  421. //图表操作权限
  422. ok := data.CheckOpChartPermission(sysUser, chartInfo.SysUserId)
  423. if !ok {
  424. br.Msg = "没有该图表的操作权限"
  425. br.ErrMsg = "没有该图表的操作权限"
  426. return
  427. }
  428. myIds := make([]int, 0)
  429. {
  430. // 获取引用该图表的MyCharts, 用于ES删除
  431. var myCond string
  432. var myPars []interface{}
  433. myCond += ` AND a.chart_info_id = ? `
  434. myPars = append(myPars, req.ChartInfoId)
  435. myCharts, e := data_manage.GetMyChartListGroupByCharyInfoIdAndAdminIdByCondition(myCond, myPars)
  436. if e != nil {
  437. br.Msg = "删除失败"
  438. br.ErrMsg = "获取引用图表的MyChats失败, Err: " + e.Error()
  439. return
  440. }
  441. for _, m := range myCharts {
  442. myIds = append(myIds, m.MyChartId)
  443. }
  444. }
  445. //删除图表及关联指标
  446. err = data_manage.DeleteChartInfoAndData(chartInfo.ChartInfoId)
  447. if err != nil {
  448. br.Msg = "删除失败"
  449. br.ErrMsg = "删除失败,Err:" + err.Error()
  450. return
  451. }
  452. //删除ES
  453. {
  454. go data.EsDeleteChartInfo(chartInfo.ChartInfoId)
  455. // 删除MY ETA 图表 es数据
  456. go data.EsDeleteMyChartInfoByMyChartIds(myIds)
  457. }
  458. source := chartInfo.Source // 拟合方程图表
  459. var condition string
  460. var pars []interface{}
  461. condition += " AND chart_classify_id=? AND source = ? "
  462. pars = append(pars, chartInfo.ChartClassifyId, source)
  463. condition += " AND chart_info_id>? ORDER BY create_time ASC LIMIT 1 "
  464. pars = append(pars, req.ChartInfoId)
  465. nextItem, err := data_manage.GetChartInfoByCondition(condition, pars)
  466. if err != nil && err.Error() != utils.ErrNoRow() {
  467. br.Msg = "删除失败"
  468. br.ErrMsg = "获取下一级图库信息失败,Err:" + err.Error()
  469. return
  470. }
  471. if nextItem != nil {
  472. resp.UniqueCode = nextItem.UniqueCode
  473. resp.ChartInfoId = nextItem.ChartInfoId
  474. } else {
  475. var condition string
  476. var pars []interface{}
  477. condition += " AND level=1 "
  478. //pars = append(pars, chartInfo.ChartClassifyId)
  479. condition += " AND chart_classify_id>? ORDER BY chart_classify_id ASC LIMIT 1 "
  480. pars = append(pars, chartInfo.ChartClassifyId)
  481. classifyItem, err := data_manage.GetChartClassifyByCondition(condition, pars)
  482. if err != nil && err.Error() != utils.ErrNoRow() {
  483. br.Msg = "删除失败"
  484. br.ErrMsg = "获取下一级图库分类信息失败,Err:" + err.Error()
  485. return
  486. }
  487. if classifyItem != nil {
  488. nextItem, err = data_manage.GetNextChartInfo(chartInfo.ChartClassifyId)
  489. if err != nil && err.Error() != utils.ErrNoRow() {
  490. br.Msg = "删除失败"
  491. br.ErrMsg = "获取下一级图库信息失败,Err:" + err.Error()
  492. return
  493. }
  494. if nextItem != nil {
  495. resp.UniqueCode = nextItem.UniqueCode
  496. resp.ChartInfoId = nextItem.ChartInfoId
  497. }
  498. }
  499. }
  500. //新增操作日志
  501. {
  502. chartLog := new(data_manage.ChartInfoLog)
  503. chartLog.ChartName = chartInfo.ChartName
  504. chartLog.ChartInfoId = req.ChartInfoId
  505. chartLog.ChartClassifyId = chartInfo.ChartClassifyId
  506. chartLog.SysUserId = sysUser.AdminId
  507. chartLog.SysUserRealName = sysUser.RealName
  508. chartLog.UniqueCode = chartInfo.UniqueCode
  509. chartLog.CreateTime = time.Now()
  510. chartLog.Content = string(this.Ctx.Input.RequestBody)
  511. chartLog.Status = "删除图表"
  512. chartLog.Method = this.Ctx.Input.URI()
  513. go data_manage.AddChartInfoLog(chartLog)
  514. }
  515. }
  516. br.Ret = 200
  517. br.Msg = "删除成功"
  518. br.Success = true
  519. br.Data = resp
  520. br.IsAddLog = true
  521. }
  522. // ChartClassifyMove
  523. // @Title 拟合方程图表分类移动接口
  524. // @Description 拟合方程图表分类移动接口
  525. // @Success 200 {object} data_manage.MoveChartClassifyReq
  526. // @router /chart_classify/move [post]
  527. func (this *LineEquationChartClassifyController) ChartClassifyMove() {
  528. br := new(models.BaseResponse).Init()
  529. defer func() {
  530. this.Data["json"] = br
  531. this.ServeJSON()
  532. }()
  533. sysUser := this.SysUser
  534. if sysUser == nil {
  535. br.Msg = "请登录"
  536. br.ErrMsg = "请登录,SysUser Is Empty"
  537. br.Ret = 408
  538. return
  539. }
  540. var req data_manage.MoveChartClassifyReq
  541. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  542. if err != nil {
  543. br.Msg = "参数解析异常!"
  544. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  545. return
  546. }
  547. if req.ClassifyId <= 0 {
  548. br.Msg = "参数错误"
  549. br.ErrMsg = "分类id小于等于0"
  550. return
  551. }
  552. //判断分类是否存在
  553. chartClassifyInfo, err := data_manage.GetChartClassifyById(req.ClassifyId)
  554. if err != nil {
  555. br.Msg = "移动失败"
  556. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  557. return
  558. }
  559. if chartClassifyInfo.Source != utils.CHART_SOURCE_LINE_EQUATION {
  560. br.Msg = "分类异常"
  561. br.ErrMsg = "分类异常,不是拟合方程图表的分类"
  562. return
  563. }
  564. updateCol := make([]string, 0)
  565. //判断上级id是否一致,如果不一致的话,那么需要移动该分类层级
  566. if chartClassifyInfo.ParentId != req.ParentClassifyId && req.ParentClassifyId != 0 {
  567. parentChartClassifyInfo, err := data_manage.GetChartClassifyById(req.ParentClassifyId)
  568. if err != nil {
  569. br.Msg = "移动失败"
  570. br.ErrMsg = "获取上级分类信息失败,Err:" + err.Error()
  571. return
  572. }
  573. chartClassifyInfo.ParentId = parentChartClassifyInfo.ChartClassifyId
  574. chartClassifyInfo.Level = parentChartClassifyInfo.Level + 1
  575. chartClassifyInfo.ModifyTime = time.Now()
  576. updateCol = append(updateCol, "ParentId", "Level", "ModifyTime")
  577. }
  578. //如果有传入 上一个兄弟节点分类id
  579. if req.PrevClassifyId > 0 {
  580. //上一个兄弟节点
  581. prevClassify, err := data_manage.GetChartClassifyById(req.PrevClassifyId)
  582. if err != nil {
  583. br.Msg = "移动失败"
  584. br.ErrMsg = "获取上一个兄弟节点分类信息失败,Err:" + err.Error()
  585. return
  586. }
  587. //如果是移动在两个兄弟节点之间
  588. if req.NextClassifyId > 0 {
  589. //下一个兄弟节点
  590. nextClassify, err := data_manage.GetChartClassifyById(req.NextClassifyId)
  591. if err != nil {
  592. br.Msg = "移动失败"
  593. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  594. return
  595. }
  596. //如果上一个兄弟与下一个兄弟的排序权重是一致的,那么需要将下一个兄弟(以及下个兄弟的同样排序权重)的排序权重+2,自己变成上一个兄弟的排序权重+1
  597. if prevClassify.Sort == nextClassify.Sort || prevClassify.Sort == chartClassifyInfo.Sort {
  598. //变更兄弟节点的排序
  599. updateSortStr := `sort + 2`
  600. _ = data_manage.UpdateChartClassifySortByParentId(prevClassify.ParentId, prevClassify.ChartClassifyId, prevClassify.Sort, updateSortStr)
  601. } else {
  602. //如果下一个兄弟的排序权重正好是上个兄弟节点的下一层,那么需要再加一层了
  603. if nextClassify.Sort-prevClassify.Sort == 1 {
  604. //变更兄弟节点的排序
  605. updateSortStr := `sort + 1`
  606. _ = data_manage.UpdateChartClassifySortByParentId(prevClassify.ParentId, 0, prevClassify.Sort, updateSortStr)
  607. }
  608. }
  609. }
  610. chartClassifyInfo.Sort = prevClassify.Sort + 1
  611. chartClassifyInfo.ModifyTime = time.Now()
  612. updateCol = append(updateCol, "Sort", "ModifyTime")
  613. } else {
  614. firstClassify, err := data_manage.GetFirstChartClassifyByParentId(chartClassifyInfo.ParentId)
  615. if err != nil && err.Error() != utils.ErrNoRow() {
  616. br.Msg = "移动失败"
  617. br.ErrMsg = "获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + err.Error()
  618. return
  619. }
  620. //如果该分类下存在其他分类,且第一个其他分类的排序等于0,那么需要调整排序
  621. if firstClassify != nil && firstClassify.Sort == 0 {
  622. updateSortStr := ` sort + 1 `
  623. _ = data_manage.UpdateChartClassifySortByParentId(firstClassify.ParentId, firstClassify.ChartClassifyId-1, 0, updateSortStr)
  624. }
  625. chartClassifyInfo.Sort = 0 //那就是排在第一位
  626. chartClassifyInfo.ModifyTime = time.Now()
  627. updateCol = append(updateCol, "Sort", "ModifyTime")
  628. }
  629. //更新
  630. if len(updateCol) > 0 {
  631. err = chartClassifyInfo.Update(updateCol)
  632. if err != nil {
  633. br.Msg = "移动失败"
  634. br.ErrMsg = "修改失败,Err:" + err.Error()
  635. return
  636. }
  637. }
  638. br.Ret = 200
  639. br.Success = true
  640. br.Msg = "移动成功"
  641. }