english_classify.go 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523
  1. package english_report
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/controllers"
  5. "eta/eta_api/models"
  6. "eta/eta_api/services"
  7. "eta/eta_api/utils"
  8. "fmt"
  9. "github.com/rdlucklib/rdluck_tools/paging"
  10. "sort"
  11. "time"
  12. )
  13. // EnglishClassifyController 英文分类
  14. type EnglishClassifyController struct {
  15. controllers.BaseAuthController
  16. }
  17. // ListClassify
  18. // @Title 获取分类列表
  19. // @Description 获取分类列表
  20. // @Param PageSize query int true "每页数据条数"
  21. // @Param CurrentIndex query int true "当前页页码,从1开始"
  22. // @Param KeyWord query string true "检索关键词"
  23. // @Param CompanyType query string false "产品类型,枚举值:'ficc','权益';不传默认返回全部"
  24. // @Success 200 {object} models.EnglishClassifyListResp
  25. // @router /classify/list [get]
  26. func (this *EnglishReportController) ListClassify() {
  27. br := new(models.BaseResponse).Init()
  28. defer func() {
  29. this.Data["json"] = br
  30. this.ServeJSON()
  31. }()
  32. pageSize, _ := this.GetInt("PageSize")
  33. currentIndex, _ := this.GetInt("CurrentIndex")
  34. keyWord := this.GetString("KeyWord")
  35. var startSize int
  36. if pageSize <= 0 {
  37. pageSize = utils.PageSize20
  38. }
  39. if currentIndex <= 0 {
  40. currentIndex = 1
  41. }
  42. startSize = utils.StartIndex(currentIndex, pageSize)
  43. page := paging.GetPaging(currentIndex, pageSize, 0)
  44. resp := new(models.EnglishClassifyListResp)
  45. // 处理一级分类分页的情况
  46. rootList, err := models.GetEnglishClassifyRootId(startSize, pageSize, keyWord)
  47. if err != nil {
  48. br.Msg = "获取失败"
  49. br.ErrMsg = "获取失败,Err:" + err.Error()
  50. return
  51. }
  52. var ids []int
  53. var rootIds []int
  54. rootMap := make(map[int]struct{}, 0)
  55. for _, v := range rootList {
  56. rootIds = append(rootIds, v.Id)
  57. rootMap[v.Id] = struct{}{}
  58. }
  59. total, err := models.GetEnglishClassifyListCount(keyWord)
  60. if err != nil {
  61. br.Msg = "获取失败"
  62. br.ErrMsg = "获取失败,Err:" + err.Error()
  63. return
  64. }
  65. if total == 0 {
  66. resp.List = make([]*models.EnglishClassifyList, 0)
  67. resp.Paging = page
  68. br.Data = resp
  69. br.Ret = 200
  70. br.Success = true
  71. br.Msg = "获取成功"
  72. return
  73. }
  74. page = paging.GetPaging(currentIndex, pageSize, total)
  75. //获取相关的分类ID
  76. idList, err := models.GetEnglishClassifyListByRootId(rootIds, keyWord)
  77. if err != nil {
  78. br.Msg = "获取失败"
  79. br.ErrMsg = "获取失败,Err:" + err.Error()
  80. return
  81. }
  82. secondListMap := make(map[int][]*models.EnglishClassifyList)
  83. thirdListMap := make(map[int][]*models.EnglishClassifyList)
  84. var thirdIds []int
  85. var sortChildList models.RSChildClassifyList
  86. // 三级分类-品种权限
  87. permissionMap := make(map[int][]int)
  88. if len(idList) > 0 {
  89. childIdMap := make(map[int]struct{}, 0)
  90. for _, v := range idList {
  91. if _, ok := childIdMap[v.ParentId]; !ok {
  92. ids = append(ids, v.ParentId)
  93. }
  94. if _, ok := childIdMap[v.Id]; !ok {
  95. ids = append(ids, v.Id)
  96. }
  97. }
  98. tmpList, err := models.GetEnglishClassifyChildByIds(ids)
  99. if err != nil {
  100. br.Msg = "获取二级分类失败"
  101. br.ErrMsg = "获取二级分类失败,Err:" + err.Error()
  102. return
  103. }
  104. for _, v := range tmpList {
  105. if _, ok := rootMap[v.ParentId]; !ok {
  106. thirdIds = append(thirdIds, v.Id)
  107. }
  108. }
  109. {
  110. classifyIds := thirdIds
  111. if len(classifyIds) > 0 {
  112. cond := fmt.Sprintf(` AND %s IN (%s)`, models.EnClassifyPermissionColumns.EnClassifyId, utils.GetOrmInReplace(len(classifyIds)))
  113. pars := make([]interface{}, 0)
  114. pars = append(pars, classifyIds)
  115. ob := new(models.EnClassifyPermission)
  116. items, e := ob.GetItemsByCondition(cond, pars, []string{}, "")
  117. if e != nil {
  118. br.Msg = "获取失败"
  119. br.ErrMsg = "获取客户权限列表失败, Err: " + e.Error()
  120. return
  121. }
  122. for _, v := range items {
  123. if permissionMap[v.EnClassifyId] == nil {
  124. permissionMap[v.EnClassifyId] = make([]int, 0)
  125. }
  126. permissionMap[v.EnClassifyId] = append(permissionMap[v.EnClassifyId], v.EnPermissionId)
  127. }
  128. }
  129. }
  130. // 处理三级分类
  131. for _, v := range tmpList {
  132. if _, ok := rootMap[v.ParentId]; !ok {
  133. if p, ok1 := permissionMap[v.Id]; ok1 {
  134. v.EnPermissions = p
  135. }
  136. thirdListMap[v.ParentId] = append(thirdListMap[v.ParentId], v)
  137. }
  138. }
  139. //处理二级分类
  140. for _, v := range tmpList {
  141. if _, ok := rootMap[v.ParentId]; ok {
  142. if child, ok1 := thirdListMap[v.Id]; ok1 {
  143. sortChildList = child
  144. sort.Sort(sortChildList)
  145. v.Child = sortChildList
  146. }
  147. secondListMap[v.ParentId] = append(secondListMap[v.ParentId], v)
  148. }
  149. }
  150. }
  151. //处理一级分类
  152. var sortList models.RSClassifyList
  153. for _, v := range rootList {
  154. if child, ok := secondListMap[v.Id]; ok {
  155. sortChildList = child
  156. sort.Sort(sortChildList)
  157. v.Child = sortChildList
  158. }
  159. sortList = append(sortList, v)
  160. }
  161. sort.Sort(sortList)
  162. resp.List = sortList
  163. resp.Paging = page
  164. br.Data = resp
  165. br.Ret = 200
  166. br.Success = true
  167. br.Msg = "获取成功"
  168. }
  169. // @Title 新增分类
  170. // @Description 新增分类接口
  171. // @Param ClassifyName int true "分类名称"
  172. // @Param ParentId query int true "父级Id 添加父级时为0"
  173. // @Param Sort query string false "排序"
  174. // @Success 200 新增成功
  175. // @router /classify/add [get]
  176. func (this *EnglishReportController) AddClassify() {
  177. br := new(models.BaseResponse).Init()
  178. defer func() {
  179. this.Data["json"] = br
  180. this.ServeJSON()
  181. }()
  182. classifyName := this.GetString("ClassifyName")
  183. parentId, _ := this.GetInt("ParentId")
  184. classifyType, _ := this.GetInt("ClassifyType", 0)
  185. sort, _ := this.GetInt("Sort")
  186. item := &models.EnglishClassify{
  187. ClassifyName: classifyName,
  188. Sort: sort,
  189. ParentId: parentId,
  190. CreateTime: time.Now(),
  191. ModifyTime: time.Now(),
  192. ClassifyType: classifyType,
  193. IsShow: 1,
  194. }
  195. counts, err := models.GetEnglishClassifyCountsByName(classifyName, parentId, classifyType)
  196. if err != nil {
  197. br.Msg = "查询失败"
  198. br.ErrMsg = "查询失败,Err:" + err.Error()
  199. return
  200. }
  201. if counts > 0 {
  202. br.Msg = "该名称已存在"
  203. br.ErrMsg = "该名称已存在!"
  204. return
  205. }
  206. _, err = models.AddEnglishClassify(item)
  207. if err != nil {
  208. br.Msg = "保存失败"
  209. br.ErrMsg = "保存失败,Err:" + err.Error()
  210. return
  211. }
  212. br.Ret = 200
  213. br.Success = true
  214. br.Msg = "新增成功"
  215. }
  216. // @Title 编辑分类
  217. // @Description 编辑分类接口
  218. // @Param ClassifyId int true "分类Id"
  219. // @Param ClassifyName string true "分类名称"
  220. // @Param ParentId query int true "父级Id 添加父级时为0"
  221. // @Param Sort query string false "排序"
  222. // @Success 200 保存成功
  223. // @router /classify/edit [get]
  224. func (this *EnglishReportController) EditClassify() {
  225. br := new(models.BaseResponse).Init()
  226. defer func() {
  227. this.Data["json"] = br
  228. this.ServeJSON()
  229. }()
  230. classifyId, _ := this.GetInt("ClassifyId")
  231. classifyName := this.GetString("ClassifyName")
  232. parentId, _ := this.GetInt("ParentId")
  233. sort, _ := this.GetInt("Sort")
  234. if parentId == classifyId {
  235. br.Msg = "上级分类不能选择自己"
  236. return
  237. }
  238. if classifyId <= 0 {
  239. br.Msg = "参数错误"
  240. return
  241. }
  242. if classifyName == "" {
  243. br.Msg = "分类名称不可为空"
  244. return
  245. }
  246. oldItem, err := models.GetEnglishReportClassifyById(classifyId)
  247. if err != nil && err.Error() != utils.ErrNoRow() {
  248. br.Msg = "获取信息失败"
  249. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  250. return
  251. }
  252. parent, err := models.GetEnglishReportClassifyById(parentId)
  253. if err != nil && err.Error() != utils.ErrNoRow() {
  254. br.Msg = "获取信息失败"
  255. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  256. return
  257. }
  258. if oldItem.ParentId == 0 && parentId > 0 {
  259. // 一级分类变更为二级分类,禁止
  260. br.Msg = "一级分类不允许更改为二级分类"
  261. return
  262. }
  263. //判断是否已存在同个名称的分类
  264. existItem, e := models.GetEnglishClassifyByClassifyNameParentId(classifyName, parentId, oldItem.ClassifyType)
  265. if e != nil {
  266. if e.Error() != utils.ErrNoRow() {
  267. br.Msg = "查询已存在的分类出错"
  268. br.ErrMsg = "查询已存在的分类出错, Err:" + e.Error()
  269. return
  270. }
  271. }
  272. if e == nil && existItem.Id != oldItem.Id {
  273. br.Msg = "分类名称:" + classifyName + "已存在"
  274. return
  275. }
  276. if err != nil && err.Error() != utils.ErrNoRow() {
  277. br.Msg = "获取信息失败"
  278. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  279. return
  280. }
  281. //oldParentId := item.ParentId
  282. item := &models.EnglishClassify{
  283. Id: oldItem.Id,
  284. ClassifyName: classifyName,
  285. Sort: sort,
  286. ParentId: parentId,
  287. ModifyTime: time.Now(),
  288. ClassifyType: oldItem.ClassifyType,
  289. IsShow: 1,
  290. }
  291. if oldItem.ClassifyType == 1 {
  292. err = services.UpdateEnglishVideoClassifyId(oldItem, item, parent, classifyId)
  293. if err != nil {
  294. br.Msg = err.Error()
  295. return
  296. }
  297. } else {
  298. // 更新研报里的分类名称
  299. err = services.UpdateEnglishReportClassifyId(oldItem, item, parent, classifyId)
  300. if err != nil {
  301. br.Msg = err.Error()
  302. return
  303. }
  304. }
  305. err = models.ModifyEnglishClassify(item)
  306. if err != nil {
  307. br.Msg = "保存失败"
  308. br.ErrMsg = "保存失败,Err:" + err.Error()
  309. return
  310. }
  311. br.Ret = 200
  312. br.Success = true
  313. br.Msg = "保存成功"
  314. }
  315. // @Title 删除分类列表
  316. // @Description 删除分类列表
  317. // @Param ClassifyId int true "分类名称"
  318. // @Param ParentId query int true "父级Id"
  319. // @Success 200 保存成功
  320. // @router /classify/delete [get]
  321. func (this *EnglishReportController) DelClassify() {
  322. br := new(models.BaseResponse).Init()
  323. defer func() {
  324. this.Data["json"] = br
  325. this.ServeJSON()
  326. }()
  327. classifyId, _ := this.GetInt("ClassifyId")
  328. //parentId, _ := this.GetInt("ParentId")
  329. classifyInfo, err := models.GetEnglishReportClassifyById(classifyId)
  330. if err != nil {
  331. if err.Error() == utils.ErrNoRow() {
  332. br.Msg = "当前分类不存在"
  333. br.ErrMsg = "当前分类不存在"
  334. return
  335. }
  336. br.Msg = "获取分类信息失败"
  337. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  338. return
  339. }
  340. count, err := models.GetEnglishClassifyChildCounts(classifyId)
  341. if err != nil && err.Error() != utils.ErrNoRow() {
  342. br.Msg = "获取信息失败"
  343. br.ErrMsg = "获取失败,Err:" + err.Error()
  344. return
  345. }
  346. if count > 0 {
  347. br.Msg = "请先删除该分类下关联分类"
  348. br.Ret = 403
  349. return
  350. }
  351. if classifyInfo.ClassifyType == 0 {
  352. reportCount, e := models.GetEnglishReportCounts(classifyId, classifyInfo.ParentId)
  353. if e != nil && e.Error() != utils.ErrNoRow() {
  354. br.Msg = "获取信息失败"
  355. br.ErrMsg = "获取失败,Err:" + e.Error()
  356. return
  357. }
  358. if reportCount > 0 {
  359. br.Msg = "该分类有关联报告,不允许删除"
  360. br.Ret = 403
  361. return
  362. }
  363. } else {
  364. videoCount, e := models.GetEnglishVideoCounts(classifyId, classifyInfo.ParentId)
  365. if e != nil && e.Error() != utils.ErrNoRow() {
  366. br.Msg = "获取信息失败"
  367. br.ErrMsg = "获取失败,Err:" + e.Error()
  368. return
  369. }
  370. if videoCount > 0 {
  371. br.Msg = "该分类有关联的路演视频,不允许删除"
  372. br.Ret = 403
  373. return
  374. }
  375. }
  376. if err = models.DeleteEnglishClassify(classifyId); err != nil {
  377. br.Msg = "删除失败"
  378. br.ErrMsg = "删除报告失败, Err: " + err.Error()
  379. return
  380. }
  381. br.Ret = 200
  382. br.Success = true
  383. br.Msg = "删除成功"
  384. }
  385. // @Title 获取一级分类列表
  386. // @Description 获取一级分类列表
  387. // @Param PageSize query int true "每页数据条数"
  388. // @Param CurrentIndex query int true "当前页页码,从1开始"
  389. // @Param CompanyType query string false "产品类型,枚举值:'ficc','权益';不传默认返回全部"
  390. // @Success 200 {object} models.EnglishClassifyListResp
  391. // @router /classify/first/list [get]
  392. func (this *EnglishReportController) FistListClassify() {
  393. br := new(models.BaseResponse).Init()
  394. defer func() {
  395. this.Data["json"] = br
  396. this.ServeJSON()
  397. }()
  398. pageSize, _ := this.GetInt("PageSize")
  399. currentIndex, _ := this.GetInt("CurrentIndex")
  400. classifyType, _ := this.GetInt("ClassifyType", 0)
  401. var startSize int
  402. if pageSize <= 0 {
  403. pageSize = utils.PageSize20
  404. }
  405. if currentIndex <= 0 {
  406. currentIndex = 1
  407. }
  408. startSize = utils.StartIndex(currentIndex, pageSize)
  409. list, err := models.GetEnglishFirstClassifyList(classifyType, startSize, pageSize)
  410. if err != nil {
  411. br.Msg = "获取失败"
  412. br.ErrMsg = "获取失败,Err:" + err.Error()
  413. return
  414. }
  415. total, err := models.GetEnglishFirstClassifyListCount(classifyType)
  416. if err != nil {
  417. br.Msg = "获取失败"
  418. br.ErrMsg = "获取失败,Err:" + err.Error()
  419. return
  420. }
  421. page := paging.GetPaging(currentIndex, pageSize, total)
  422. resp := new(models.EnglishClassifyListResp)
  423. resp.List = list
  424. resp.Paging = page
  425. br.Data = resp
  426. br.Ret = 200
  427. br.Success = true
  428. br.Msg = "获取成功"
  429. }
  430. // PermissionEdit
  431. // @Title 编辑品种权限
  432. // @Description 编辑品种权限
  433. // @Param request body models.EnPermissionAddReq true "type json string"
  434. // @Success 200 Ret=200 操作成功
  435. // @router /permission/edit [post]
  436. func (this *EnglishClassifyController) PermissionEdit() {
  437. br := new(models.BaseResponse).Init()
  438. defer func() {
  439. if br.ErrMsg == "" {
  440. br.IsSendEmail = false
  441. }
  442. this.Data["json"] = br
  443. this.ServeJSON()
  444. }()
  445. sysUser := this.SysUser
  446. if sysUser == nil {
  447. br.Msg = "请登录"
  448. br.ErrMsg = "请登录,SysUser Is Empty"
  449. br.Ret = 408
  450. return
  451. }
  452. var req models.EnClassifyPermissionEditReq
  453. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  454. br.Msg = "参数解析异常!"
  455. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  456. return
  457. }
  458. if req.ClassifyId <= 0 {
  459. br.Msg = "参数有误"
  460. return
  461. }
  462. // 更新品种权限
  463. nowTime := time.Now().Local()
  464. permissions := make([]*models.EnClassifyPermission, 0)
  465. for _, p := range req.EnPermissions {
  466. v := new(models.EnClassifyPermission)
  467. v.EnPermissionId = p
  468. v.EnClassifyId = req.ClassifyId
  469. v.CreateTime = nowTime
  470. permissions = append(permissions, v)
  471. }
  472. if e := models.ClearAndCreateEnClassifyPermissions(req.ClassifyId, permissions); e != nil {
  473. br.Msg = "保存失败"
  474. br.ErrMsg = "更新分类品种权限失败, Err: " + e.Error()
  475. return
  476. }
  477. br.Ret = 200
  478. br.Success = true
  479. br.Msg = "操作成功"
  480. }