material.go 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023
  1. package material
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/controllers"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/material"
  7. materialService "eta/eta_api/services/material"
  8. "eta/eta_api/utils"
  9. "fmt"
  10. "github.com/rdlucklib/rdluck_tools/paging"
  11. "strings"
  12. "time"
  13. )
  14. // versionSize 版本列表第一页数据约定是:3条
  15. var versionSize = 3
  16. // MaterialController 逻辑导图
  17. type MaterialController struct {
  18. controllers.BaseAuthController
  19. }
  20. // ClassifyMaterialItems
  21. // @Title 获取所有素材库分类接口-包含素材库
  22. // @Description 获取所有素材库分类接口-包含素材库
  23. // @Param IsShowMe query bool true "是否只看我的,true、false"
  24. // @Success 200 {object} data_manage.ChartClassifyListResp
  25. // @router /classify/materialList [get]
  26. func (this *MaterialController) ClassifyMaterialItems() {
  27. br := new(models.BaseResponse).Init()
  28. defer func() {
  29. this.Data["json"] = br
  30. this.ServeJSON()
  31. }()
  32. resp := new(material.MaterialClassifyListResp)
  33. MaterialClassifyId, _ := this.GetInt("MaterialClassifyId")
  34. isShowMe, _ := this.GetBool("IsShowMe")
  35. if isShowMe {
  36. errMsg, err := materialService.GetMaterialClassifyListForMe(*this.SysUser, resp, MaterialClassifyId)
  37. if err != nil {
  38. br.Msg = errMsg
  39. br.ErrMsg = err.Error()
  40. return
  41. }
  42. // 移除没有权限的图表
  43. br.Ret = 200
  44. br.Success = true
  45. br.Msg = "获取成功"
  46. br.Data = resp
  47. fmt.Println("source my classify")
  48. return
  49. }
  50. rootList, err := material.GetMaterialClassifyAndInfoByParentId(MaterialClassifyId)
  51. if err != nil && err.Error() != utils.ErrNoRow() {
  52. br.Msg = "获取失败"
  53. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  54. return
  55. }
  56. classifyAll, err := material.GetMaterialClassifyAndInfoByParentId(MaterialClassifyId)
  57. if err != nil && err.Error() != utils.ErrNoRow() {
  58. br.Msg = "获取失败"
  59. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  60. return
  61. }
  62. nodeAll := make([]*material.MaterialClassifyItems, 0)
  63. for k := range rootList {
  64. rootNode := rootList[k]
  65. materialService.MaterialClassifyItemsMakeTreeV2(this.SysUser, classifyAll, rootNode)
  66. nodeAll = append(nodeAll, rootNode)
  67. }
  68. //newAll := materialService.MaterialItemsMakeTree(nodeAll, sandListMap, MaterialClassifyId)
  69. resp.AllNodes = nodeAll
  70. br.Ret = 200
  71. br.Success = true
  72. br.Msg = "获取成功"
  73. br.Data = resp
  74. }
  75. // AddMaterialClassify
  76. // @Title 新增素材库分类
  77. // @Description 新增材库分类接口
  78. // @Param request body data_manage.AddChartClassifyReq true "type json string"
  79. // @Success 200 Ret=200 保存成功
  80. // @router /classify/add [post]
  81. func (this *MaterialController) AddMaterialClassify() {
  82. br := new(models.BaseResponse).Init()
  83. defer func() {
  84. this.Data["json"] = br
  85. this.ServeJSON()
  86. }()
  87. var req material.AddMaterialClassifyReq
  88. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  89. if err != nil {
  90. br.Msg = "参数解析异常!"
  91. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  92. return
  93. }
  94. if req.ClassifyName == "" {
  95. br.Msg = "请输入分类名称"
  96. br.IsSendEmail = false
  97. return
  98. }
  99. if req.ParentId < 0 {
  100. br.Msg = "参数错误"
  101. br.IsSendEmail = false
  102. return
  103. }
  104. level := 1
  105. levelPath := ""
  106. if req.ParentId > 0 {
  107. //查找父级分类
  108. parentClassify, e := material.GetMaterialClassifyById(req.ParentId)
  109. if e != nil {
  110. br.Msg = "获取父级分类失败"
  111. br.ErrMsg = "获取父级分类失败,Err:" + e.Error()
  112. return
  113. }
  114. level = parentClassify.Level + 1
  115. levelPath = parentClassify.LevelPath
  116. }
  117. count, e := material.GetMaterialClassifyNameCount(req.ClassifyName, req.ParentId)
  118. if e != nil {
  119. br.Msg = "判断名称是否已存在失败"
  120. br.ErrMsg = "判断名称是否已存在失败,Err:" + e.Error()
  121. return
  122. }
  123. if count > 0 {
  124. br.Msg = "分类名称已存在,请重新输入"
  125. br.IsSendEmail = false
  126. return
  127. }
  128. //获取该层级下最大的排序数
  129. classify := new(material.MaterialClassify)
  130. maxSort, _ := material.GetMaterialClassifyMaxSort(req.ParentId)
  131. classify.ParentId = req.ParentId
  132. classify.ClassifyName = req.ClassifyName
  133. classify.CreateTime = time.Now()
  134. classify.ModifyTime = time.Now()
  135. classify.SysUserId = this.SysUser.AdminId
  136. classify.SysUserRealName = this.SysUser.RealName
  137. classify.Level = level
  138. classify.Sort = maxSort + 1
  139. classifyId, e := material.AddMaterialClassify(classify)
  140. if e != nil {
  141. br.Msg = "保存分类失败"
  142. br.ErrMsg = "保存分类失败,Err:" + e.Error()
  143. return
  144. }
  145. if req.ParentId > 0 {
  146. levelPath = fmt.Sprintf("%s,%d", levelPath, classifyId)
  147. } else {
  148. levelPath = fmt.Sprintf("%d", classifyId)
  149. }
  150. classify.ClassifyId = int(classifyId)
  151. classify.LevelPath = levelPath
  152. e = classify.Update([]string{"LevelPath"})
  153. if e != nil {
  154. br.Msg = "保存分类失败"
  155. br.ErrMsg = "保存分类失败,Err:" + e.Error()
  156. return
  157. }
  158. br.Ret = 200
  159. br.Msg = "保存成功"
  160. br.Success = true
  161. }
  162. // EditMaterialClassify
  163. // @Title 修改素材库分类
  164. // @Description 修改素材库分类接口
  165. // @Param request body data_manage.EditChartClassifyReq true "type json string"
  166. // @Success 200 Ret=200 修改成功
  167. // @router /classify/edit [post]
  168. func (this *MaterialController) EditMaterialClassify() {
  169. br := new(models.BaseResponse).Init()
  170. defer func() {
  171. this.Data["json"] = br
  172. this.ServeJSON()
  173. }()
  174. var req material.EditMaterialClassifyReq
  175. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  176. if err != nil {
  177. br.Msg = "参数解析异常!"
  178. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  179. return
  180. }
  181. if req.ClassifyName == "" {
  182. br.Msg = "请输入分类名称"
  183. br.IsSendEmail = false
  184. return
  185. }
  186. if req.ClassifyId <= 0 {
  187. br.Msg = "参数错误"
  188. br.IsSendEmail = false
  189. return
  190. }
  191. // 只允许修改分类名称
  192. item, err := material.GetMaterialClassifyById(req.ClassifyId)
  193. if err != nil {
  194. if err.Error() == utils.ErrNoRow() {
  195. br.Msg = "分类不存在"
  196. return
  197. }
  198. br.Msg = "保存失败"
  199. br.Msg = "获取分类信息失败,Err:" + err.Error()
  200. return
  201. }
  202. count, err := material.GetMaterialClassifyNameNotSelfCount(req.ClassifyId, req.ClassifyName, item.ParentId)
  203. if err != nil {
  204. br.Msg = "判断名称是否已存在失败"
  205. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  206. return
  207. }
  208. if count > 0 {
  209. br.Msg = "分类名称已存在,请重新输入"
  210. br.IsSendEmail = false
  211. return
  212. }
  213. //levelPath = fmt.Sprintf("%s,%d", levelPath, req.ClassifyId)
  214. //item.LevelPath = levelPath
  215. //item.ParentId = req.ParentId
  216. item.ClassifyName = req.ClassifyName
  217. item.ModifyTime = time.Now()
  218. //e = item.Update([]string{"LevelPath", "ParentId", "ClassifyName", "ModifyTime"})
  219. err = item.Update([]string{"ClassifyName", "ModifyTime"})
  220. if err != nil {
  221. br.Msg = "保存分类失败"
  222. br.ErrMsg = "保存分类失败,Err:" + err.Error()
  223. return
  224. }
  225. //todo 测试更新子集的levelPath
  226. /*levelPath := ""
  227. oldLevelPath := item.LevelPath
  228. if item.ParentId > 0 {
  229. //查找父级分类
  230. parentClassify, e := material.GetMaterialClassifyById(item.ParentId)
  231. if e != nil {
  232. br.Msg = "获取父级分类失败"
  233. br.ErrMsg = "获取父级分类失败,Err:" + e.Error()
  234. return
  235. }
  236. levelPath = fmt.Sprintf("%s,%d", parentClassify.LevelPath, item.ClassifyId)
  237. tmpList, e := material.GetMaterialClassifyByLevelPath(oldLevelPath)
  238. if e != nil {
  239. br.Msg = "保存分类失败"
  240. br.ErrMsg = "保存分类失败,Err:" + e.Error()
  241. return
  242. }
  243. // 把原先的父级levePath,替换成最新的父级序列
  244. for _, tmp := range tmpList {
  245. tmp.LevelPath = strings.Replace(tmp.LevelPath, oldLevelPath, levelPath, -1)
  246. tmp.ModifyTime = time.Now()
  247. e = tmp.Update([]string{"LevelPath", "ModifyTime"})
  248. if e != nil {
  249. br.Msg = "保存分类失败"
  250. br.ErrMsg = "保存分类失败,Err:" + e.Error()
  251. return
  252. }
  253. }
  254. } else {
  255. // 只有更改了父级才需要更新levelPath
  256. }*/
  257. br.Ret = 200
  258. br.Msg = "保存成功"
  259. br.Success = true
  260. br.IsAddLog = true
  261. }
  262. // DeleteMaterialClassifyCheck
  263. // @Title 删除素材库检测接口
  264. // @Description 删除素材库检测接口
  265. // @Param request body data_manage.ChartClassifyDeleteCheckResp true "type json string"
  266. // @Success 200 Ret=200 检测成功
  267. // @router /classify/del/check [post]
  268. func (this *MaterialController) DeleteMaterialClassifyCheck() {
  269. br := new(models.BaseResponse).Init()
  270. defer func() {
  271. this.Data["json"] = br
  272. this.ServeJSON()
  273. }()
  274. var req material.MaterialClassifyDeleteCheckReq
  275. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  276. if err != nil {
  277. br.Msg = "参数解析异常!"
  278. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  279. return
  280. }
  281. if req.ClassifyId < 0 {
  282. br.Msg = "参数错误"
  283. br.IsSendEmail = false
  284. return
  285. }
  286. var deleteStatus int
  287. var tipsMsg string
  288. //删除分类
  289. // 查询当前的分类
  290. classifyInfo, err := material.GetMaterialClassifyById(req.ClassifyId)
  291. if err != nil {
  292. br.Msg = "分类不存在"
  293. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  294. return
  295. }
  296. classifyIds := strings.Split(classifyInfo.LevelPath, ",")
  297. if len(classifyIds) > 0 {
  298. //判断素材库分类下,是否含有素材库
  299. count, e := material.GetMaterialInfoCountByClassifyIds(classifyIds)
  300. if e != nil {
  301. br.Msg = "删除失败"
  302. br.ErrMsg = "分类下是否含有指标失败,Err:" + e.Error()
  303. return
  304. }
  305. if count > 0 {
  306. deleteStatus = 1
  307. tipsMsg = "该分类下关联素材库不可删除"
  308. } else {
  309. if len(classifyIds) > 1 {
  310. deleteStatus = 2
  311. tipsMsg = "确认删除当前目录及包含的子目录吗"
  312. }
  313. }
  314. }
  315. if deleteStatus == 0 {
  316. tipsMsg = "可删除,进行删除操作"
  317. }
  318. resp := new(material.MaterialClassifyDeleteCheckResp)
  319. resp.DeleteStatus = deleteStatus
  320. resp.TipsMsg = tipsMsg
  321. br.Ret = 200
  322. br.Msg = "检测成功"
  323. br.Success = true
  324. br.Data = resp
  325. }
  326. // DeleteMaterialClassify
  327. // @Title 删除素材库分类/素材库
  328. // @Description 删除素材库分类/素材库接口
  329. // @Param request body data_manage.DeleteChartClassifyReq true "type json string"
  330. // @Success 200 Ret=200 删除成功
  331. // @router /classify/del [post]
  332. func (this *MaterialController) DeleteMaterialClassify() {
  333. br := new(models.BaseResponse).Init()
  334. defer func() {
  335. this.Data["json"] = br
  336. this.ServeJSON()
  337. }()
  338. sysUser := this.SysUser
  339. if sysUser == nil {
  340. br.Msg = "请登录"
  341. br.ErrMsg = "请登录,SysUser Is Empty"
  342. br.Ret = 408
  343. return
  344. }
  345. var req material.DeleteMaterialClassifyReq
  346. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  347. if err != nil {
  348. br.Msg = "参数解析异常!"
  349. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  350. return
  351. }
  352. if req.ClassifyId < 0 {
  353. br.Msg = "参数错误"
  354. br.IsSendEmail = false
  355. return
  356. }
  357. // 查询当前的分类
  358. classifyInfo, err := material.GetMaterialClassifyById(req.ClassifyId)
  359. if err != nil {
  360. br.Msg = "分类不存在"
  361. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  362. return
  363. }
  364. classifyIds := strings.Split(classifyInfo.LevelPath, ",")
  365. if len(classifyIds) > 0 {
  366. //判断素材库分类下,是否含有素材库
  367. count, e := material.GetMaterialInfoCountByClassifyIds(classifyIds)
  368. if e != nil {
  369. br.Msg = "删除失败"
  370. br.ErrMsg = "分类下是否含有指标失败,Err:" + e.Error()
  371. return
  372. }
  373. if count > 0 {
  374. br.Msg = "该目录下存在关联指标,不可删除"
  375. br.IsSendEmail = false
  376. return
  377. }
  378. err = material.DeleteMaterialClassify(classifyIds)
  379. if err != nil {
  380. br.Msg = "删除失败"
  381. br.ErrMsg = "删除失败,Err:" + err.Error()
  382. return
  383. }
  384. }
  385. //删除素材库
  386. /*if req.MaterialId > 0 {
  387. materialInfo, err := material.GetMaterialById(req.MaterialId)
  388. if err != nil {
  389. if err.Error() == utils.ErrNoRow() {
  390. br.Msg = "素材库已删除,请刷新页面"
  391. br.ErrMsg = "指标不存在,Err:" + err.Error()
  392. return
  393. } else {
  394. br.Msg = "删除失败"
  395. br.ErrMsg = "删除失败,获取指标信息失败,Err:" + err.Error()
  396. return
  397. }
  398. }
  399. if materialInfo == nil {
  400. br.Msg = "素材库已删除,请刷新页面"
  401. return
  402. }
  403. err = materialService.DeleteMaterial(req.MaterialId)
  404. if err != nil {
  405. br.Msg = err.Error()
  406. return
  407. }
  408. }*/
  409. br.Ret = 200
  410. br.Msg = "删除成功"
  411. br.Success = true
  412. br.IsAddLog = true
  413. }
  414. // ClassifyMove
  415. // @Title 素材库分类移动接口
  416. // @Description 素材库分类移动接口
  417. // @Success 200 {object} data_manage.MoveChartClassifyReq
  418. // @router /classify/move [post]
  419. func (this *MaterialController) ClassifyMove() {
  420. br := new(models.BaseResponse).Init()
  421. defer func() {
  422. this.Data["json"] = br
  423. this.ServeJSON()
  424. }()
  425. sysUser := this.SysUser
  426. if sysUser == nil {
  427. br.Msg = "请登录"
  428. br.ErrMsg = "请登录,SysUser Is Empty"
  429. br.Ret = 408
  430. return
  431. }
  432. var req material.MoveMaterialClassifyReq
  433. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  434. if err != nil {
  435. br.Msg = "参数解析异常!"
  436. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  437. return
  438. }
  439. if req.ClassifyId <= 0 {
  440. br.Msg = "参数错误"
  441. br.ErrMsg = "分类id小于等于0"
  442. return
  443. }
  444. //判断分类是否存在
  445. materialClassifyInfo, err := material.GetMaterialClassifyById(req.ClassifyId)
  446. if err != nil {
  447. if err.Error() == utils.ErrNoRow() {
  448. br.Msg = "分类不存在,请刷新页面"
  449. br.ErrMsg = "分类不存在,Err:" + err.Error()
  450. return
  451. }
  452. br.Msg = "移动失败"
  453. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  454. return
  455. }
  456. if materialClassifyInfo.ParentId != req.ParentClassifyId {
  457. count, err := material.GetMaterialClassifyNameNotSelfCount(materialClassifyInfo.ClassifyId, materialClassifyInfo.ClassifyName, materialClassifyInfo.ParentId)
  458. if err != nil {
  459. br.Msg = "判断名称是否已存在失败"
  460. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  461. return
  462. }
  463. if count > 0 {
  464. br.Msg = "移动失败,分类名称已存在"
  465. br.IsSendEmail = false
  466. return
  467. }
  468. }
  469. err, errMsg := materialService.MoveMaterialClassify(materialClassifyInfo, &req)
  470. if err != nil {
  471. br.Msg = errMsg
  472. if errMsg == "" {
  473. br.Msg = "移动失败"
  474. }
  475. br.ErrMsg = err.Error()
  476. }
  477. // todo权限校验
  478. //移动的是分类
  479. //判断上级id是否一致,如果不一致的话,那么需要移动该分类层级
  480. /*updateCol := make([]string, 0)
  481. if MaterialClassifyInfo.ParentId != req.ParentClassifyId && req.ParentClassifyId != 0 {
  482. parentChartClassifyInfo, err := material.GetMaterialClassifyById(req.ParentClassifyId)
  483. if err != nil {
  484. br.Msg = "移动失败"
  485. br.ErrMsg = "获取上级分类信息失败,Err:" + err.Error()
  486. return
  487. }
  488. MaterialClassifyInfo.ParentId = parentChartClassifyInfo.ClassifyId
  489. MaterialClassifyInfo.Level = parentChartClassifyInfo.Level + 1
  490. MaterialClassifyInfo.ModifyTime = time.Now()
  491. updateCol = append(updateCol, "ParentId", "Level", "ModifyTime")
  492. } else if MaterialClassifyInfo.ParentId != req.ParentClassifyId && req.ParentClassifyId == 0 {
  493. //改为一级分类
  494. MaterialClassifyInfo.ParentId = req.ParentClassifyId
  495. MaterialClassifyInfo.Level = 1
  496. MaterialClassifyInfo.ModifyTime = time.Now()
  497. updateCol = append(updateCol, "ParentId", "Level", "ModifyTime")
  498. }
  499. //如果有传入 上一个兄弟节点分类id
  500. if req.PrevId > 0 {
  501. if req.PrevType == 1 {
  502. //上一个节点是分类
  503. //上一个兄弟节点
  504. prevClassify, err := material.GetMaterialClassifyById(req.PrevId)
  505. if err != nil {
  506. br.Msg = "移动失败"
  507. br.ErrMsg = "获取上一个兄弟节点分类信息失败,Err:" + err.Error()
  508. return
  509. }
  510. //如果是移动在两个兄弟节点之间
  511. if req.NextId > 0 {
  512. if req.NextType == 1 {
  513. //上一个节点是分类 下一个节点是分类的情况
  514. //下一个兄弟节点
  515. nextClassify, err := material.GetMaterialClassifyById(req.NextId)
  516. if err != nil {
  517. br.Msg = "移动失败"
  518. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  519. return
  520. }
  521. //如果上一个兄弟与下一个兄弟的排序权重是一致的,那么需要将下一个兄弟(以及下个兄弟的同样排序权重)的排序权重+2,自己变成上一个兄弟的排序权重+1
  522. if prevClassify.Sort == nextClassify.Sort || prevClassify.Sort == MaterialClassifyInfo.Sort {
  523. //变更兄弟节点的排序
  524. updateSortStr := `sort + 2`
  525. _ = material.UpdateMaterialClassifySortByParentId(prevClassify.ParentId, prevClassify.ClassifyId, prevClassify.Sort, updateSortStr)
  526. _ = material.UpdateMaterialSortByClassifyId(prevClassify.ClassifyId, prevClassify.Sort, 0, updateSortStr)
  527. } else {
  528. //如果下一个兄弟的排序权重正好是上个兄弟节点的下一层,那么需要再加一层了
  529. if nextClassify.Sort-prevClassify.Sort == 1 {
  530. //变更兄弟节点的排序
  531. updateSortStr := `sort + 1`
  532. _ = material.UpdateMaterialClassifySortByParentId(prevClassify.ParentId, 0, prevClassify.Sort, updateSortStr)
  533. _ = material.UpdateMaterialSortByClassifyId(prevClassify.ClassifyId, prevClassify.Sort, 0, updateSortStr)
  534. }
  535. }
  536. } else {
  537. //上一个节点是分类 下一个节点是素材库的情况
  538. //下一个兄弟节点
  539. nextChartInfo, err := material.GetMaterialById(req.NextId)
  540. if err != nil {
  541. br.Msg = "移动失败"
  542. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  543. return
  544. }
  545. //如果上一个兄弟(分类)与下一个兄弟(素材库)的排序权重是一致的,那么需要将下一个兄弟(素材库)(以及下个兄弟(素材库)的同样排序权重)的排序权重+2,自己变成上一个兄弟(分类)的排序权重+1
  546. if prevClassify.Sort == nextChartInfo.Sort || prevClassify.Sort == MaterialClassifyInfo.Sort {
  547. //变更兄弟节点的排序
  548. updateSortStr := `sort + 2`
  549. _ = material.UpdateMaterialClassifySortByParentId(prevClassify.ParentId, prevClassify.ClassifyId, prevClassify.Sort, updateSortStr)
  550. _ = material.UpdateMaterialSortByClassifyId(prevClassify.ClassifyId, prevClassify.Sort, 0, updateSortStr)
  551. } else {
  552. //如果下一个兄弟(素材库)的排序权重正好是上个兄弟节点(分类)的下一层,那么需要再加一层了
  553. if nextChartInfo.Sort-prevClassify.Sort == 1 {
  554. //变更兄弟节点的排序
  555. updateSortStr := `sort + 1`
  556. _ = material.UpdateMaterialClassifySortByParentId(prevClassify.ParentId, 0, prevClassify.ClassifyId, updateSortStr)
  557. _ = material.UpdateMaterialSortByClassifyId(prevClassify.ClassifyId, prevClassify.Sort, 0, updateSortStr)
  558. }
  559. }
  560. }
  561. }
  562. MaterialClassifyInfo.Sort = prevClassify.Sort + 1
  563. MaterialClassifyInfo.ModifyTime = time.Now()
  564. updateCol = append(updateCol, "Sort", "ModifyTime")
  565. } else {
  566. //上一个节点是素材库
  567. prevMaterial, err := material.GetMaterialById(req.PrevId)
  568. if err != nil {
  569. br.Msg = "移动失败"
  570. br.ErrMsg = "获取上一个兄弟节点分类信息失败,Err:" + err.Error()
  571. return
  572. }
  573. //如果是移动在两个兄弟节点之间
  574. if req.NextId > 0 {
  575. if req.NextType == 1 {
  576. //上一个节点是素材库 下一个节点是分类的情况
  577. //下一个兄弟节点
  578. nextClassify, err := material.GetMaterialClassifyById(req.NextId)
  579. if err != nil {
  580. br.Msg = "移动失败"
  581. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  582. return
  583. }
  584. //如果上一个兄弟(素材库)与下一个兄弟(分类)的排序权重是一致的,那么需要将下一个兄弟(分类)(以及下个兄弟(分类)的同样排序权重)的排序权重+2,自己变成上一个兄弟(素材库)的排序权重+1
  585. if prevMaterial.Sort == nextClassify.Sort || prevMaterial.Sort == MaterialClassifyInfo.Sort {
  586. //变更兄弟节点的排序
  587. updateSortStr := `sort + 2`
  588. _ = material.UpdateMaterialClassifySortByParentId(prevMaterial.ClassifyId, 0, prevMaterial.Sort, updateSortStr)
  589. _ = material.UpdateMaterialSortByClassifyId(prevMaterial.ClassifyId, prevMaterial.Sort, prevMaterial.MaterialId, updateSortStr)
  590. } else {
  591. //如果下一个兄弟(分类)的排序权重正好是上个兄弟(素材库)节点的下一层,那么需要再加一层了
  592. if nextClassify.Sort-prevMaterial.Sort == 1 {
  593. //变更兄弟节点的排序
  594. updateSortStr := `sort + 1`
  595. _ = material.UpdateMaterialClassifySortByParentId(prevMaterial.ClassifyId, 0, prevMaterial.Sort, updateSortStr)
  596. _ = material.UpdateMaterialSortByClassifyId(prevMaterial.ClassifyId, prevMaterial.Sort, prevMaterial.MaterialId, updateSortStr)
  597. }
  598. }
  599. } else {
  600. //上一个节点是素材库 下一个节点是素材库的情况
  601. //下一个兄弟节点
  602. nextChartInfo, err := material.GetMaterialById(req.NextId)
  603. if err != nil {
  604. br.Msg = "移动失败"
  605. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  606. return
  607. }
  608. //如果上一个兄弟(素材库)与下一个兄弟(分类)的排序权重是一致的,那么需要将下一个兄弟(分类)(以及下个兄弟(分类)的同样排序权重)的排序权重+2,自己变成上一个兄弟(素材库)的排序权重+1
  609. if prevMaterial.Sort == nextChartInfo.Sort || prevMaterial.Sort == MaterialClassifyInfo.Sort {
  610. //变更兄弟节点的排序
  611. updateSortStr := `sort + 2`
  612. _ = material.UpdateMaterialClassifySortByParentId(prevMaterial.ClassifyId, 0, prevMaterial.Sort, updateSortStr)
  613. _ = material.UpdateMaterialSortByClassifyId(prevMaterial.ClassifyId, prevMaterial.Sort, prevMaterial.MaterialId, updateSortStr)
  614. } else {
  615. //如果下一个兄弟(分类)的排序权重正好是上个兄弟(素材库)节点的下一层,那么需要再加一层了
  616. if nextChartInfo.Sort-prevMaterial.Sort == 1 {
  617. //变更兄弟节点的排序
  618. updateSortStr := `sort + 1`
  619. _ = material.UpdateMaterialClassifySortByParentId(prevMaterial.ClassifyId, 0, prevMaterial.Sort, updateSortStr)
  620. _ = material.UpdateMaterialSortByClassifyId(prevMaterial.ClassifyId, prevMaterial.Sort, prevMaterial.MaterialId, updateSortStr)
  621. }
  622. }
  623. }
  624. }
  625. MaterialClassifyInfo.Sort = prevMaterial.Sort + 1
  626. MaterialClassifyInfo.ModifyTime = time.Now()
  627. updateCol = append(updateCol, "Sort", "ModifyTime")
  628. }
  629. } else {
  630. firstClassify, err := material.GetFirstMaterialClassifyByParentId(MaterialClassifyInfo.ParentId)
  631. if err != nil && err.Error() != utils.ErrNoRow() {
  632. br.Msg = "移动失败"
  633. br.ErrMsg = "获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + err.Error()
  634. return
  635. }
  636. //如果该分类下存在其他分类,且第一个其他分类的排序等于0,那么需要调整排序
  637. if firstClassify != nil && firstClassify.Sort == 0 {
  638. updateSortStr := ` sort + 1 `
  639. _ = material.UpdateMaterialClassifySortByParentId(firstClassify.ParentId, firstClassify.ClassifyId-1, 0, updateSortStr)
  640. }
  641. MaterialClassifyInfo.Sort = 0 //那就是排在第一位
  642. MaterialClassifyInfo.ModifyTime = time.Now()
  643. updateCol = append(updateCol, "Sort", "ModifyTime")
  644. }
  645. //更新
  646. if len(updateCol) > 0 {
  647. err = MaterialClassifyInfo.Update(updateCol)
  648. if err != nil {
  649. br.Msg = "移动失败"
  650. br.ErrMsg = "修改失败,Err:" + err.Error()
  651. return
  652. }
  653. // todo 记录整个层级的分类ID
  654. }*/
  655. br.Ret = 200
  656. br.Success = true
  657. br.Msg = "移动成功"
  658. }
  659. // @Title ETA图表列表接口
  660. // @Description ETA图表列表接口
  661. // @Param PageSize query int true "每页数据条数"
  662. // @Param CurrentIndex query int true "当前页页码,从1开始"
  663. // @Param ChartClassifyId query int true "分类id"
  664. // @Param KeyWord query string true "搜索关键词"
  665. // @Param IsShowMe query bool true "是否只看我的,true、false"
  666. // @Success 200 {object} data_manage.ChartListResp
  667. // @router /list [get]
  668. func (this *MaterialController) List() {
  669. br := new(models.BaseResponse).Init()
  670. defer func() {
  671. this.Data["json"] = br
  672. this.ServeJSON()
  673. }()
  674. sysUser := this.SysUser
  675. if sysUser == nil {
  676. br.Msg = "请登录"
  677. br.ErrMsg = "请登录,SysUser Is Empty"
  678. br.Ret = 408
  679. return
  680. }
  681. MaterialClassifyId, _ := this.GetInt("MaterialClassifyId")
  682. pageSize, _ := this.GetInt("PageSize")
  683. currentIndex, _ := this.GetInt("CurrentIndex")
  684. keyWord := this.GetString("KeyWord")
  685. var total int
  686. page := paging.GetPaging(currentIndex, pageSize, total)
  687. var startSize int
  688. if pageSize <= 0 {
  689. pageSize = utils.PageSize20
  690. }
  691. if currentIndex <= 0 {
  692. currentIndex = 1
  693. }
  694. startSize = paging.StartIndex(currentIndex, pageSize)
  695. var condition string
  696. var pars []interface{}
  697. if MaterialClassifyId > 0 {
  698. MaterialClassifyId, err := material.GetMaterialClassify(MaterialClassifyId)
  699. if err != nil && err.Error() != utils.ErrNoRow() {
  700. br.Msg = "获取图表信息失败"
  701. br.ErrMsg = "获取信息失败,GetChartClassify,Err:" + err.Error()
  702. return
  703. }
  704. condition += " AND sandbox_classify_id IN(" + MaterialClassifyId + ") "
  705. //pars = append(pars, chartClassifyId)
  706. }
  707. if keyWord != "" {
  708. condition += ` AND ( name LIKE '%` + keyWord + `%' )`
  709. }
  710. //只看我的
  711. isShowMe, _ := this.GetBool("IsShowMe")
  712. if isShowMe {
  713. condition += ` AND sys_user_id = ? `
  714. pars = append(pars, sysUser.AdminId)
  715. }
  716. //获取图表信息
  717. condition += ` AND is_delete = 0 `
  718. list, err := material.GetMaterialListByCondition(condition, pars, startSize, pageSize)
  719. if err != nil && err.Error() != utils.ErrNoRow() {
  720. br.Success = true
  721. br.Msg = "获取素材库信息失败"
  722. br.ErrMsg = "获取素材库信息失败,Err:" + err.Error()
  723. return
  724. }
  725. for i, v := range list {
  726. ids, err := material.GetMaterialAllParentByClassifyId(v.ClassifyId)
  727. if err != nil {
  728. br.Msg = "获取父级信息错误!"
  729. br.ErrMsg = "获取父级信息错误,Err:" + err.Error()
  730. return
  731. }
  732. list[i].ParentIds = ids
  733. }
  734. resp := new(material.MaterialListResp)
  735. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  736. items := make([]*material.MaterialListItems, 0)
  737. resp.Paging = page
  738. resp.List = items
  739. br.Ret = 200
  740. br.Success = true
  741. br.Msg = "获取成功"
  742. return
  743. }
  744. dataCount, err := material.GetMaterialListCountByCondition(condition, pars)
  745. if err != nil && err.Error() != utils.ErrNoRow() {
  746. br.Msg = "获取指标信息失败"
  747. br.ErrMsg = "获取指标数据总数失败,Err:" + err.Error()
  748. return
  749. }
  750. page = paging.GetPaging(currentIndex, pageSize, dataCount)
  751. resp.Paging = page
  752. resp.List = list
  753. br.Ret = 200
  754. br.Success = true
  755. br.Msg = "获取成功"
  756. br.Data = resp
  757. }
  758. // Save
  759. // @Title 新增/编辑保存素材库
  760. // @Description 新增/编辑保存素材库接口
  761. // @Param request body material.AddAndEditSandbox true "type json string"
  762. // @Success 200 {object} material.Material
  763. // @router /save [post]
  764. func (this *MaterialController) Save() {
  765. br := new(models.BaseResponse).Init()
  766. defer func() {
  767. this.Data["json"] = br
  768. this.ServeJSON()
  769. }()
  770. sysUser := this.SysUser
  771. if sysUser == nil {
  772. br.Msg = "请登录"
  773. br.ErrMsg = "请登录,SysUser Is Empty"
  774. br.Ret = 408
  775. return
  776. }
  777. var req material.AddAndEditMaterial
  778. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  779. if err != nil {
  780. br.Msg = "参数解析异常!"
  781. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  782. return
  783. }
  784. var materialResp *material.MaterialSaveResp
  785. var errMsg string
  786. if req.MaterialId <= 0 {
  787. //新增素材库
  788. materialResp, err = materialService.AddMaterial(req, sysUser.AdminId, sysUser.RealName)
  789. if err != nil {
  790. br.Msg = "保存失败!"
  791. if errMsg != `` {
  792. br.Msg = errMsg
  793. }
  794. br.ErrMsg = "保存失败,Err:" + err.Error()
  795. return
  796. }
  797. } else {
  798. //编辑素材库
  799. materialInfo := &material.Material{
  800. MaterialId: req.MaterialId,
  801. MaterialName: utils.TrimStr(req.MaterialName),
  802. ImgUrl: utils.TrimStr(req.ImgUrl),
  803. ModifyTime: time.Now(),
  804. ClassifyId: req.ClassifyId,
  805. }
  806. //缩略图为空时不更新
  807. var updateSandboxColumn = []string{}
  808. if req.ImgUrl == "" {
  809. updateSandboxColumn = []string{"Name", "Content", "MindmapData", "ModifyTime", "MaterialClassifyId", "Style"}
  810. } else {
  811. updateSandboxColumn = []string{"Name", "Content", "MindmapData", "ImgUrl", "ModifyTime", "MaterialClassifyId", "Style"}
  812. }
  813. err = materialInfo.Update(updateSandboxColumn)
  814. if err != nil {
  815. br.Msg = "保存失败!"
  816. if errMsg != `` {
  817. br.Msg = errMsg
  818. }
  819. br.ErrMsg = "保存失败,Err:" + err.Error()
  820. return
  821. }
  822. }
  823. msg := "保存成功"
  824. br.Ret = 200
  825. br.Success = true
  826. br.Msg = msg
  827. br.Data = materialResp
  828. }
  829. // Delete
  830. // @Title 删除素材库
  831. // @Description 删除素材库接口
  832. // @Param request body material.DeleteSandbox true "type json string"
  833. // @Success 200 标记成功
  834. // @router /delete [post]
  835. func (this *MaterialController) Delete() {
  836. br := new(models.BaseResponse).Init()
  837. defer func() {
  838. this.Data["json"] = br
  839. this.ServeJSON()
  840. }()
  841. sysUser := this.SysUser
  842. if sysUser == nil {
  843. br.Msg = "请登录"
  844. br.ErrMsg = "请登录,SysUser Is Empty"
  845. br.Ret = 408
  846. return
  847. }
  848. var req material.DeleteMaterial
  849. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  850. if err != nil {
  851. br.Msg = "参数解析异常!"
  852. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  853. return
  854. }
  855. if req.MaterialId <= 0 {
  856. br.Msg = "缺少素材库编号"
  857. return
  858. }
  859. //删除素材库
  860. err = materialService.DeleteMaterial(req.MaterialId)
  861. if err != nil {
  862. br.Msg = err.Error()
  863. return
  864. }
  865. msg := "删除成功"
  866. br.Ret = 200
  867. br.Success = true
  868. br.Msg = msg
  869. }
  870. // GetMaterialVersionDetail
  871. // @Title 获取素材库版本数据详情(已保存的)
  872. // @Description 获取素材库版本数据详情接口(已保存的)
  873. // @Param SandboxVersionCode query string true "素材库版本code"
  874. // @Success 200 {object} material.MaterialVersion
  875. // @router /detail [get]
  876. func (this *MaterialController) GetMaterialDetail() {
  877. br := new(models.BaseResponse).Init()
  878. defer func() {
  879. this.Data["json"] = br
  880. this.ServeJSON()
  881. }()
  882. sysUser := this.SysUser
  883. if sysUser == nil {
  884. br.Msg = "请登录"
  885. br.ErrMsg = "请登录,SysUser Is Empty"
  886. br.Ret = 408
  887. return
  888. }
  889. sandboxId, _ := this.GetInt("SandboxId")
  890. if sandboxId == 0 {
  891. br.Msg = "缺少素材库Id"
  892. return
  893. }
  894. //获取素材库数据详情(已保存的)
  895. materialInfo, err := material.GetMaterialById(sandboxId)
  896. if err != nil {
  897. br.Msg = "获取失败"
  898. br.ErrMsg = "获取失败,Err:" + err.Error()
  899. return
  900. }
  901. msg := "获取成功"
  902. br.Ret = 200
  903. br.Success = true
  904. br.Msg = msg
  905. br.Data = materialInfo
  906. }
  907. // MaterialClassifyList
  908. // @Title 获取所有素材库分类接口-不包含素材库
  909. // @Description 获取所有素材库分类接口-不包含素材库
  910. // @Param IsShowMe query bool true "是否只看我的,true、false"
  911. // @Success 200 {object} data_manage.ChartClassifyListResp
  912. // @router /classify/list [get]
  913. func (this *MaterialController) MaterialClassifyList() {
  914. br := new(models.BaseResponse).Init()
  915. defer func() {
  916. this.Data["json"] = br
  917. this.ServeJSON()
  918. }()
  919. resp := new(material.MaterialClassifyListResp)
  920. rootList, err := material.GetMaterialClassifyByParentId(0)
  921. if err != nil && err.Error() != utils.ErrNoRow() {
  922. br.Msg = "获取失败"
  923. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  924. return
  925. }
  926. classifyAll, err := material.GetMaterialClassifyAll()
  927. if err != nil && err.Error() != utils.ErrNoRow() {
  928. br.Msg = "获取失败"
  929. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  930. return
  931. }
  932. nodeAll := make([]*material.MaterialClassifyItems, 0)
  933. for k := range rootList {
  934. rootNode := rootList[k]
  935. materialService.MaterialClassifyItemsMakeTree(this.SysUser, classifyAll, rootNode)
  936. nodeAll = append(nodeAll, rootNode)
  937. }
  938. resp.AllNodes = nodeAll
  939. br.Ret = 200
  940. br.Success = true
  941. br.Msg = "获取成功"
  942. br.Data = resp
  943. }