excel_classify.go 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782
  1. package excel
  2. import (
  3. "encoding/json"
  4. "eta_gn/eta_api/controllers"
  5. "eta_gn/eta_api/models"
  6. "eta_gn/eta_api/models/data_manage/excel"
  7. "eta_gn/eta_api/models/data_manage/excel/request"
  8. response2 "eta_gn/eta_api/models/data_manage/excel/response"
  9. "eta_gn/eta_api/services/data/data_manage_permission"
  10. excel2 "eta_gn/eta_api/services/data/excel"
  11. "eta_gn/eta_api/utils"
  12. "fmt"
  13. "sort"
  14. "strconv"
  15. "time"
  16. )
  17. type ExcelClassifyController struct {
  18. controllers.BaseAuthController
  19. }
  20. // @router /excel_classify/list [get]
  21. func (this *ExcelClassifyController) List() {
  22. br := new(models.BaseResponse).Init()
  23. defer func() {
  24. this.Data["json"] = br
  25. this.ServeJSON()
  26. }()
  27. source, _ := this.GetInt("Source")
  28. if source <= 0 {
  29. source = utils.EXCEL_DEFAULT
  30. }
  31. isShowMe, _ := this.GetBool("IsShowMe")
  32. showUserId := 0
  33. if isShowMe {
  34. showUserId = this.SysUser.AdminId
  35. }
  36. classifyList, err := excel.GetExcelClassifyBySource(source)
  37. if err != nil {
  38. br.Msg = "获取失败"
  39. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  40. return
  41. }
  42. classifyMap := make(map[int]*excel.ExcelClassifyItems)
  43. for _, v := range classifyList {
  44. classifyMap[v.ExcelClassifyId] = v
  45. }
  46. allExcelInfo := make([]*excel.ExcelClassifyItems, 0)
  47. if source == utils.BALANCE_TABLE {
  48. var excelIds []int
  49. if isShowMe {
  50. obj := new(excel.ExcelWorker)
  51. existList, err := obj.GetBySysUserId(this.SysUser.AdminId)
  52. if err != nil {
  53. br.Msg = "获取表格协作人失败!"
  54. br.ErrMsg = "获取表格协作人失败,Err:" + err.Error()
  55. return
  56. }
  57. if len(existList) > 0 {
  58. for _, v := range existList {
  59. excelIds = append(excelIds, v.ExcelInfoId)
  60. }
  61. }
  62. }
  63. allExcelInfo, err = excel.GetBalanceNoContentExcelInfoAll(source, excelIds, showUserId)
  64. if err != nil && !utils.IsErrNoRow(err) {
  65. br.Msg = "获取失败"
  66. br.ErrMsg = "获取表格信息失败,Err:" + err.Error()
  67. return
  68. }
  69. } else {
  70. allExcelInfo, err = excel.GetNoContentExcelInfoAll(source, showUserId)
  71. if err != nil && !utils.IsErrNoRow(err) {
  72. br.Msg = "获取失败"
  73. br.ErrMsg = "获取表格信息失败,Err:" + err.Error()
  74. return
  75. }
  76. }
  77. permissionEdbIdList, permissionClassifyIdList, err := data_manage_permission.GetUserExcelAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  78. if err != nil {
  79. br.Msg = "获取失败"
  80. br.ErrMsg = "获取所有有权限的指标和分类失败,Err:" + err.Error()
  81. return
  82. }
  83. ExcelInfoMap := make(map[int][]*excel.ExcelClassifyItems)
  84. for _, v := range allExcelInfo {
  85. if classifyInfo, ok := classifyMap[v.ExcelClassifyId]; ok {
  86. v.HaveOperaAuth = data_manage_permission.CheckExcelPermissionByPermissionIdList(v.IsJoinPermission, classifyInfo.IsJoinPermission, v.ExcelInfoId, v.ExcelClassifyId, permissionEdbIdList, permissionClassifyIdList)
  87. }
  88. if source == utils.BALANCE_TABLE && isShowMe && !v.HaveOperaAuth { // 过滤我不可编辑的表格
  89. continue
  90. }
  91. ExcelInfoMap[v.ExcelClassifyId] = append(ExcelInfoMap[v.ExcelClassifyId], v)
  92. }
  93. classifyListMap := make(map[int][]*excel.ExcelClassifyItems)
  94. for _, v := range classifyList {
  95. v.HaveOperaAuth = data_manage_permission.CheckExcelClassifyPermissionByPermissionIdList(v.IsJoinPermission, v.ExcelClassifyId, permissionClassifyIdList)
  96. if existItems, ok := ExcelInfoMap[v.ExcelClassifyId]; ok {
  97. v.Children = existItems
  98. }
  99. }
  100. for _, v := range classifyList {
  101. if v.ParentId > 0 {
  102. classifyListMap[v.ParentId] = append(classifyListMap[v.ParentId], v)
  103. }
  104. }
  105. for key, classify := range classifyList {
  106. subList, ok := classifyListMap[classify.ExcelClassifyId]
  107. if ok {
  108. classifyList[key].Children = append(classifyList[key].Children, subList...)
  109. sort.Slice(classifyList[key].Children, func(i, j int) bool {
  110. return excel.ExcelClassifyItemBySort(classifyList[key].Children[i], classifyList[key].Children[j])
  111. })
  112. }
  113. }
  114. nodeAll := make([]*excel.ExcelClassifyItems, 0)
  115. for _, v := range classifyList {
  116. if v.ParentId == 0 {
  117. sort.Slice(v.Children, func(i, j int) bool { return excel.ExcelClassifyItemBySort(v.Children[i], v.Children[j]) })
  118. nodeAll = append(nodeAll, v)
  119. }
  120. }
  121. resp := response2.ExcelClassifyListResp{
  122. AllNodes: nodeAll,
  123. }
  124. br.Ret = 200
  125. br.Success = true
  126. br.Msg = "获取成功"
  127. br.Data = resp
  128. }
  129. func AnalysisClassifyList(this *ExcelClassifyController) (br *models.BaseResponse) {
  130. br = new(models.BaseResponse).Init()
  131. defer func() {
  132. this.Data["json"] = br
  133. this.ServeJSON()
  134. }()
  135. source, _ := this.GetInt("Source")
  136. if source <= 0 {
  137. source = utils.EXCEL_DEFAULT
  138. }
  139. showUserId := this.SysUser.AdminId
  140. classifyList, err := excel.GetExcelClassifyBySource(source)
  141. if err != nil {
  142. br.Msg = "获取失败"
  143. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  144. return
  145. }
  146. classifyMap := make(map[int]*excel.ExcelClassifyItems)
  147. for _, v := range classifyList {
  148. classifyMap[v.ExcelClassifyId] = v
  149. }
  150. allExcelInfo, err := excel.GetNoContentExcelInfoAll(source, showUserId)
  151. if err != nil && !utils.IsErrNoRow(err) {
  152. br.Msg = "获取失败"
  153. br.ErrMsg = "获取表格信息失败,Err:" + err.Error()
  154. return
  155. }
  156. permissionEdbIdList, permissionClassifyIdList, err := data_manage_permission.GetUserExcelAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  157. if err != nil {
  158. br.Msg = "获取失败"
  159. br.ErrMsg = "获取所有有权限的指标和分类失败,Err:" + err.Error()
  160. return
  161. }
  162. ExcelInfoMap := make(map[int][]*excel.ExcelClassifyItems)
  163. for _, v := range allExcelInfo {
  164. if classifyInfo, ok := classifyMap[v.ExcelClassifyId]; ok {
  165. v.HaveOperaAuth = data_manage_permission.CheckExcelPermissionByPermissionIdList(v.IsJoinPermission, classifyInfo.IsJoinPermission, v.ExcelInfoId, v.ExcelClassifyId, permissionEdbIdList, permissionClassifyIdList)
  166. }
  167. ExcelInfoMap[v.ExcelClassifyId] = append(ExcelInfoMap[v.ExcelClassifyId], v)
  168. }
  169. classifyListMap := make(map[int][]*excel.ExcelClassifyItems)
  170. for _, v := range classifyList {
  171. v.HaveOperaAuth = data_manage_permission.CheckExcelClassifyPermissionByPermissionIdList(v.IsJoinPermission, v.ExcelClassifyId, permissionClassifyIdList)
  172. if existItems, ok := ExcelInfoMap[v.ExcelClassifyId]; ok {
  173. v.Children = existItems
  174. }
  175. }
  176. for _, v := range classifyList {
  177. if v.ParentId > 0 {
  178. classifyListMap[v.ParentId] = append(classifyListMap[v.ParentId], v)
  179. }
  180. }
  181. for key, classify := range classifyList {
  182. subList, ok := classifyListMap[classify.ExcelClassifyId]
  183. if ok {
  184. classifyList[key].Children = append(classifyList[key].Children, subList...)
  185. sort.Slice(classifyList[key].Children, func(i, j int) bool {
  186. return excel.ExcelClassifyItemBySort(classifyList[key].Children[i], classifyList[key].Children[j])
  187. })
  188. }
  189. }
  190. nodeAll := make([]*excel.ExcelClassifyItems, 0)
  191. for _, v := range classifyList {
  192. if v.ParentId == 0 {
  193. sort.Slice(v.Children, func(i, j int) bool { return excel.ExcelClassifyItemBySort(v.Children[i], v.Children[j]) })
  194. nodeAll = append(nodeAll, v)
  195. }
  196. }
  197. nodeAll = removeNodesWithAnalysisClassify(nodeAll, this.SysUser.AdminId)
  198. resp := response2.ExcelClassifyListResp{
  199. AllNodes: nodeAll,
  200. }
  201. br.Ret = 200
  202. br.Success = true
  203. br.Msg = "获取成功"
  204. br.Data = resp
  205. return
  206. }
  207. func removeNodesWithAnalysisClassify(nodes []*excel.ExcelClassifyItems, adminId int) []*excel.ExcelClassifyItems {
  208. var newListNode []*excel.ExcelClassifyItems
  209. for _, node := range nodes {
  210. if node.Children != nil {
  211. node.Children = removeNodesWithAnalysisClassify(node.Children, adminId)
  212. }
  213. if node.ExcelInfoId > 0 {
  214. newListNode = append(newListNode, node)
  215. continue
  216. }
  217. if node.SysUserId == 0 && node.Children != nil && len(node.Children) > 0 {
  218. newListNode = append(newListNode, node)
  219. continue
  220. }
  221. if node.SysUserId == adminId {
  222. newListNode = append(newListNode, node)
  223. continue
  224. }
  225. }
  226. return newListNode
  227. }
  228. // @router /excel_classify/items [get]
  229. func (this *ExcelClassifyController) ExcelClassifyItems() {
  230. br := new(models.BaseResponse).Init()
  231. defer func() {
  232. this.Data["json"] = br
  233. this.ServeJSON()
  234. }()
  235. source, _ := this.GetInt("Source")
  236. if source <= 0 {
  237. source = utils.EXCEL_DEFAULT
  238. }
  239. classifyList, err := excel.GetExcelClassifyBySource(source)
  240. if err != nil {
  241. br.Msg = "获取失败"
  242. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  243. return
  244. }
  245. classifyMap := make(map[int][]*excel.ExcelClassifyItems)
  246. for _, v := range classifyList {
  247. if v.ParentId > 0 {
  248. classifyMap[v.ParentId] = append(classifyMap[v.ParentId], v)
  249. }
  250. }
  251. for key, classify := range classifyList {
  252. subList, ok := classifyMap[classify.ExcelClassifyId]
  253. if ok {
  254. classifyList[key].Children = append(classifyList[key].Children, subList...)
  255. }
  256. }
  257. nodeAll := make([]*excel.ExcelClassifyItems, 0)
  258. for _, v := range classifyList {
  259. if v.ParentId == 0 {
  260. nodeAll = append(nodeAll, v)
  261. }
  262. }
  263. resp := response2.ExcelClassifyListResp{
  264. AllNodes: nodeAll,
  265. }
  266. br.Ret = 200
  267. br.Success = true
  268. br.Msg = "获取成功"
  269. br.Data = resp
  270. }
  271. // @router /excel_classify/add [post]
  272. func (this *ExcelClassifyController) AddExcelClassify() {
  273. br := new(models.BaseResponse).Init()
  274. defer func() {
  275. this.Data["json"] = br
  276. this.ServeJSON()
  277. }()
  278. var req request.AddExcelClassifyReq
  279. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  280. if err != nil {
  281. br.Msg = "参数解析异常!"
  282. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  283. return
  284. }
  285. if req.ExcelClassifyName == "" {
  286. br.Msg = "请输入分类名称"
  287. br.IsSendEmail = false
  288. return
  289. }
  290. if req.ParentId < 0 {
  291. br.Msg = "参数错误"
  292. br.IsSendEmail = false
  293. return
  294. }
  295. source := req.Source
  296. if source <= 0 {
  297. source = utils.EXCEL_DEFAULT
  298. }
  299. var count int
  300. if source == utils.CUSTOM_ANALYSIS_TABLE {
  301. ct, e := excel.GetCustomAnalysisExcelClassifyCount(req.ExcelClassifyName, req.ParentId, source, this.SysUser.AdminId)
  302. if e != nil {
  303. br.Msg = "操作失败"
  304. br.ErrMsg = fmt.Sprintf("获取自定义分析同级分类下同名分类失败, %v", e)
  305. return
  306. }
  307. count = ct
  308. } else {
  309. ct, e := excel.GetExcelClassifyCount(req.ExcelClassifyName, req.ParentId, source)
  310. if e != nil {
  311. br.Msg = "操作失败"
  312. br.ErrMsg = fmt.Sprintf("获取同级分类下同名分类失败, %v", e)
  313. return
  314. }
  315. count = ct
  316. }
  317. if count > 0 {
  318. br.Msg = "分类名称已存在,请重新输入"
  319. br.IsSendEmail = false
  320. return
  321. }
  322. maxSort, err := excel2.GetExcelClassifyMaxSort(req.ParentId, req.Source)
  323. if err != nil {
  324. br.Msg = "获取失败"
  325. br.ErrMsg = "查询排序信息失败,Err:" + err.Error()
  326. return
  327. }
  328. level := 1
  329. if req.ParentId > 0 {
  330. var parent *excel.ExcelClassify
  331. parent, err = excel.GetExcelClassifyById(req.ParentId)
  332. if err != nil {
  333. if utils.IsErrNoRow(err) {
  334. br.Msg = "父级分类不存在"
  335. return
  336. }
  337. br.Msg = "获取失败"
  338. br.ErrMsg = "查询父级分类信息失败,Err:" + err.Error()
  339. return
  340. }
  341. level = parent.Level + 1
  342. }
  343. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  344. classify := &excel.ExcelClassify{
  345. ExcelClassifyName: req.ExcelClassifyName,
  346. ParentId: req.ParentId,
  347. Source: source,
  348. SysUserId: this.SysUser.AdminId,
  349. SysUserRealName: this.SysUser.RealName,
  350. Level: level,
  351. UniqueCode: utils.MD5(utils.EXCEL_DATA_PREFIX + "_" + timestamp),
  352. Sort: maxSort + 1,
  353. CreateTime: time.Now(),
  354. ModifyTime: time.Now(),
  355. }
  356. _, err = excel.AddExcelClassify(classify)
  357. if err != nil {
  358. br.Msg = "保存分类失败"
  359. br.ErrMsg = "保存分类失败,Err:" + err.Error()
  360. return
  361. }
  362. {
  363. go data_manage_permission.InheritParentClassify(6, source, classify.ExcelClassifyId, classify.ParentId, classify.ExcelClassifyName)
  364. }
  365. br.Ret = 200
  366. br.Msg = "保存成功"
  367. br.Success = true
  368. }
  369. // @router /excel_classify/edit [post]
  370. func (this *ExcelClassifyController) EditExcelClassify() {
  371. br := new(models.BaseResponse).Init()
  372. defer func() {
  373. this.Data["json"] = br
  374. this.ServeJSON()
  375. }()
  376. var req request.EditExcelClassifyReq
  377. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  378. if err != nil {
  379. br.Msg = "参数解析异常!"
  380. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  381. return
  382. }
  383. if req.ExcelClassifyName == "" {
  384. br.Msg = "请输入分类名称"
  385. br.IsSendEmail = false
  386. return
  387. }
  388. if req.ExcelClassifyId <= 0 {
  389. br.Msg = "参数错误"
  390. br.IsSendEmail = false
  391. return
  392. }
  393. item, err := excel.GetExcelClassifyById(req.ExcelClassifyId)
  394. if err != nil {
  395. br.Msg = "保存失败"
  396. br.Msg = "获取分类信息失败,Err:" + err.Error()
  397. return
  398. }
  399. if item.ExcelClassifyName == req.ExcelClassifyName {
  400. br.Ret = 200
  401. br.Msg = "保存成功"
  402. br.Success = true
  403. return
  404. }
  405. count, err := excel.GetExcelClassifyCount(req.ExcelClassifyName, item.ParentId, item.Source)
  406. if err != nil {
  407. br.Msg = "判断名称是否已存在失败"
  408. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  409. return
  410. }
  411. if count > 0 {
  412. br.Msg = "分类名称已存在,请重新输入"
  413. br.IsSendEmail = false
  414. return
  415. }
  416. item.ExcelClassifyName = req.ExcelClassifyName
  417. err = item.Update([]string{"ExcelClassifyName"})
  418. if err != nil {
  419. br.Msg = "保存失败"
  420. br.ErrMsg = "保存失败,Err:" + err.Error()
  421. return
  422. }
  423. br.Ret = 200
  424. br.Msg = "修改成功"
  425. br.Success = true
  426. br.IsAddLog = true
  427. }
  428. // @router /excel_classify/delete/check [post]
  429. func (this *ExcelClassifyController) DeleteExcelClassifyCheck() {
  430. br := new(models.BaseResponse).Init()
  431. defer func() {
  432. this.Data["json"] = br
  433. this.ServeJSON()
  434. }()
  435. var req request.ExcelClassifyDeleteCheckReq
  436. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  437. if err != nil {
  438. br.Msg = "参数解析异常!"
  439. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  440. return
  441. }
  442. if req.ExcelClassifyId < 0 && req.ExcelInfoId <= 0 {
  443. br.Msg = "参数错误"
  444. br.IsSendEmail = false
  445. return
  446. }
  447. var deleteStatus int
  448. var tipsMsg string
  449. ExcelClassifyInfo, err := excel.GetExcelClassifyById(req.ExcelClassifyId)
  450. if err != nil {
  451. if utils.IsErrNoRow(err) {
  452. br.Msg = "该分类不存在"
  453. br.ErrMsg = "该分类不存在"
  454. return
  455. }
  456. br.Msg = "删除失败"
  457. br.ErrMsg = "查询该分类失败,Err:" + err.Error()
  458. return
  459. }
  460. if ExcelClassifyInfo == nil {
  461. br.Msg = "该分类不存在"
  462. br.ErrMsg = "该分类不存在"
  463. br.IsSendEmail = false
  464. return
  465. }
  466. if req.ExcelClassifyId > 0 && req.ExcelInfoId == 0 {
  467. count, err := excel.GetExcelInfoCountByClassifyId(req.ExcelClassifyId)
  468. if err != nil {
  469. br.Msg = "删除失败"
  470. br.ErrMsg = "分类下是否含有指标失败,Err:" + err.Error()
  471. return
  472. }
  473. if count > 0 {
  474. deleteStatus = 1
  475. tipsMsg = "该分类下关联表格不可删除"
  476. } else {
  477. childClassify, e := excel.GetChildClassifyById(req.ExcelClassifyId)
  478. if e != nil && !utils.IsErrNoRow(e) {
  479. br.Msg = "获取失败"
  480. br.ErrMsg = "获取分类信息失败, GetEdbClassify,Err:" + e.Error()
  481. return
  482. }
  483. if len(childClassify) > 0 {
  484. var classifyIds []int
  485. for _, v := range childClassify {
  486. classifyIds = append(classifyIds, v.ExcelClassifyId)
  487. }
  488. condition := fmt.Sprintf(` AND excel_classify_id IN (%s) `, utils.GetOrmInReplace(len(classifyIds)))
  489. var pars []interface{}
  490. pars = append(pars, classifyIds)
  491. childCount, err := excel.GetExcelInfoCountByCondition(condition, pars)
  492. if err != nil && !utils.IsErrNoRow(err) {
  493. br.Msg = "删除失败"
  494. br.ErrMsg = "查询分类下表格数量失败,Err:" + err.Error()
  495. return
  496. }
  497. if childCount > 0 {
  498. deleteStatus = 1
  499. tipsMsg = "该分类下关联表格不可删除"
  500. }
  501. }
  502. }
  503. }
  504. if deleteStatus == 0 {
  505. tipsMsg = "可删除,进行删除操作"
  506. }
  507. resp := response2.ExcelClassifyDeleteCheckResp{
  508. DeleteStatus: deleteStatus,
  509. TipsMsg: tipsMsg,
  510. }
  511. br.Ret = 200
  512. br.Msg = "检测成功"
  513. br.Success = true
  514. br.Data = resp
  515. }
  516. // @router /excel_classify/delete [post]
  517. func (this *ExcelClassifyController) DeleteExcelClassify() {
  518. br := new(models.BaseResponse).Init()
  519. defer func() {
  520. this.Data["json"] = br
  521. this.ServeJSON()
  522. }()
  523. sysUser := this.SysUser
  524. if sysUser == nil {
  525. br.Msg = "请登录"
  526. br.ErrMsg = "请登录,SysUser Is Empty"
  527. br.Ret = 408
  528. return
  529. }
  530. var req request.DeleteExcelClassifyReq
  531. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  532. if err != nil {
  533. br.Msg = "参数解析异常!"
  534. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  535. return
  536. }
  537. if req.ExcelClassifyId < 0 && req.ExcelInfoId <= 0 {
  538. br.Msg = "参数错误"
  539. br.IsSendEmail = false
  540. return
  541. }
  542. if req.ExcelClassifyId > 0 && req.ExcelInfoId == 0 {
  543. count, err := excel.GetExcelInfoCountByClassifyId(req.ExcelClassifyId)
  544. if err != nil && !utils.IsErrNoRow(err) {
  545. br.Msg = "删除失败"
  546. br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error()
  547. return
  548. }
  549. if count > 0 {
  550. br.Msg = "该目录下存在关联ETA表格,不可删除"
  551. br.IsSendEmail = false
  552. return
  553. } else {
  554. childClassify, e := excel.GetChildClassifyById(req.ExcelClassifyId)
  555. if e != nil && !utils.IsErrNoRow(e) {
  556. br.Msg = "获取失败"
  557. br.ErrMsg = "获取分类信息失败, GetEdbClassify,Err:" + e.Error()
  558. return
  559. }
  560. if len(childClassify) > 0 {
  561. var classifyIds []int
  562. for _, v := range childClassify {
  563. classifyIds = append(classifyIds, v.ExcelClassifyId)
  564. }
  565. condition := fmt.Sprintf(` AND excel_classify_id IN (%s) `, utils.GetOrmInReplace(len(classifyIds)))
  566. var pars []interface{}
  567. pars = append(pars, classifyIds)
  568. childCount, err := excel.GetExcelInfoCountByCondition(condition, pars)
  569. if err != nil && !utils.IsErrNoRow(err) {
  570. br.Msg = "删除失败"
  571. br.ErrMsg = "查询分类下表格数量失败,Err:" + err.Error()
  572. return
  573. }
  574. if childCount > 0 {
  575. br.Msg = "该目录下存在关联ETA表格,不可删除"
  576. br.IsSendEmail = false
  577. return
  578. }
  579. }
  580. }
  581. classifyItem, err := excel.GetExcelClassifyById(req.ExcelClassifyId)
  582. if err != nil {
  583. br.Msg = "删除失败"
  584. br.ErrMsg = "获取分类失败,Err:" + err.Error()
  585. if utils.IsErrNoRow(err) {
  586. br.Msg = "分类不存在"
  587. br.ErrMsg = "分类不存在"
  588. }
  589. return
  590. }
  591. classifyItem.IsDelete = 1
  592. err = classifyItem.Update([]string{"IsDelete"})
  593. if err != nil {
  594. br.Msg = "删除失败"
  595. br.ErrMsg = "删除失败,Err:" + err.Error()
  596. return
  597. }
  598. }
  599. resp := response2.AddExcelInfoResp{}
  600. if req.ExcelInfoId > 0 {
  601. excelInfo, err := excel.GetExcelInfoById(req.ExcelInfoId)
  602. if err != nil {
  603. if utils.IsErrNoRow(err) {
  604. br.Msg = "表格已删除,请刷新页面"
  605. br.ErrMsg = "表格已删除,请刷新页面"
  606. return
  607. } else {
  608. br.Msg = "删除失败"
  609. br.ErrMsg = "删除失败,获取指标信息失败,Err:" + err.Error()
  610. return
  611. }
  612. }
  613. if excelInfo == nil {
  614. br.Msg = "表格已删除,请刷新页面"
  615. br.IsSendEmail = false
  616. return
  617. }
  618. err, errMsg, isSendEmail := excel2.Delete(excelInfo, sysUser)
  619. if err != nil {
  620. br.Msg = "删除失败"
  621. if errMsg != `` {
  622. br.Msg = errMsg
  623. }
  624. br.ErrMsg = "删除失败,Err:" + err.Error()
  625. br.IsSendEmail = isSendEmail
  626. return
  627. }
  628. {
  629. var nextItem *excel.ExcelInfo
  630. var condition string
  631. var pars []interface{}
  632. condition += " AND excel_classify_id=? "
  633. pars = append(pars, excelInfo.ExcelClassifyId)
  634. if excelInfo.Source == utils.BALANCE_TABLE {
  635. condition += " AND parent_id=0 AND balance_type=0 "
  636. }
  637. condition += " AND (sort>? OR (sort=? AND excel_info_id<?) ) "
  638. pars = append(pars, excelInfo.Sort, excelInfo.Sort, excelInfo.ExcelInfoId)
  639. nextItem, err = excel.GetNextExcelInfoByCondition(condition, pars)
  640. if err != nil && !utils.IsErrNoRow(err) {
  641. br.Msg = "删除失败"
  642. br.ErrMsg = "获取下一级表格信息失败,Err:" + err.Error()
  643. return
  644. }
  645. if nextItem == nil {
  646. currClassifyInfo, err := excel.GetExcelClassifyById(excelInfo.ExcelClassifyId)
  647. if err != nil && !utils.IsErrNoRow(err) {
  648. br.Msg = "删除失败"
  649. br.ErrMsg = "获取当前表格分类信息失败,Err:" + err.Error()
  650. return
  651. }
  652. nextItem, err = excel.GetNextExcelInfo(excelInfo.ExcelClassifyId, currClassifyInfo.Sort, currClassifyInfo.Source)
  653. if err != nil && !utils.IsErrNoRow(err) {
  654. br.Msg = "删除失败"
  655. br.ErrMsg = "获取下一级表格信息失败,Err:" + err.Error()
  656. return
  657. }
  658. }
  659. if nextItem != nil {
  660. resp = response2.AddExcelInfoResp{
  661. ExcelInfoId: nextItem.ExcelInfoId,
  662. UniqueCode: nextItem.UniqueCode,
  663. }
  664. }
  665. }
  666. }
  667. br.Ret = 200
  668. br.Msg = "删除成功"
  669. br.Success = true
  670. br.Data = resp
  671. br.IsAddLog = true
  672. }
  673. // @router /excel_classify/move [post]
  674. func (this *ExcelClassifyController) ExcelClassifyMove() {
  675. br := new(models.BaseResponse).Init()
  676. defer func() {
  677. this.Data["json"] = br
  678. this.ServeJSON()
  679. }()
  680. sysUser := this.SysUser
  681. if sysUser == nil {
  682. br.Msg = "请登录"
  683. br.ErrMsg = "请登录,SysUser Is Empty"
  684. br.Ret = 408
  685. return
  686. }
  687. var req request.MoveExcelClassifyReq
  688. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  689. if err != nil {
  690. br.Msg = "参数解析异常!"
  691. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  692. return
  693. }
  694. if req.ClassifyId <= 0 && req.ExcelInfoId <= 0 {
  695. br.Msg = "参数错误"
  696. br.ErrMsg = "请选择拖动目标,分类目录或者指标"
  697. return
  698. }
  699. err, errMsg := excel2.MoveExcelClassify(req)
  700. if err != nil {
  701. br.Msg = err.Error()
  702. br.ErrMsg = errMsg
  703. return
  704. }
  705. br.Ret = 200
  706. br.Success = true
  707. br.IsAddLog = true
  708. br.Msg = "移动成功"
  709. }