report.go 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224
  1. package english_report
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/controllers"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/company"
  7. "eta/eta_api/models/system"
  8. "eta/eta_api/services"
  9. "eta/eta_api/services/alarm_msg"
  10. "eta/eta_api/utils"
  11. "fmt"
  12. "github.com/rdlucklib/rdluck_tools/paging"
  13. "html"
  14. "strconv"
  15. "strings"
  16. "sync"
  17. "time"
  18. )
  19. // EnglishReportController 研报活动模块
  20. type EnglishReportController struct {
  21. controllers.BaseAuthController
  22. }
  23. // @Title 新增报告接口
  24. // @Description 新增报告
  25. // @Param request body models.AddEnglishReportReq true "type json string"
  26. // @Success 200 {object} models.AddEnglishReportResp
  27. // @router /add [post]
  28. func (this *EnglishReportController) Add() {
  29. br := new(models.BaseResponse).Init()
  30. defer func() {
  31. this.Data["json"] = br
  32. this.ServeJSON()
  33. }()
  34. sysUser := this.SysUser
  35. if sysUser == nil {
  36. br.Msg = "请登录"
  37. br.ErrMsg = "请登录,SysUser Is Empty"
  38. br.Ret = 408
  39. return
  40. }
  41. var req models.AddEnglishReportReq
  42. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  43. if err != nil {
  44. br.Msg = "参数解析异常!"
  45. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  46. return
  47. }
  48. if req.Content == "" {
  49. br.Msg = "请输入内容"
  50. return
  51. }
  52. if req.Overview == "" {
  53. br.Msg = "请输入overview"
  54. return
  55. }
  56. if req.Abstract == "" {
  57. br.Msg = "请输入摘要"
  58. return
  59. }
  60. var contentSub string
  61. if req.Content != "" {
  62. content, e := services.FilterReportContentBr(req.Content)
  63. if e != nil {
  64. br.Msg = "内容去除前后空格失败"
  65. br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error()
  66. return
  67. }
  68. req.Content = content
  69. contentSub, err = services.GetReportContentSub(req.Content)
  70. if err != nil {
  71. go alarm_msg.SendAlarmMsg("ContentSub 失败,Err:"+err.Error(), 3)
  72. //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers)
  73. }
  74. }
  75. maxStage, err := models.GetEnglishReportStage(req.ClassifyIdFirst, req.ClassifyIdSecond)
  76. if err != nil {
  77. br.Msg = "期数获取失败!"
  78. br.ErrMsg = "期数获取失败,Err:" + err.Error()
  79. return
  80. }
  81. item := new(models.EnglishReport)
  82. item.AddType = req.AddType
  83. item.ClassifyIdFirst = req.ClassifyIdFirst
  84. item.ClassifyNameFirst = req.ClassifyNameFirst
  85. item.ClassifyIdSecond = req.ClassifyIdSecond
  86. item.ClassifyNameSecond = req.ClassifyNameSecond
  87. item.Title = req.Title
  88. item.Abstract = req.Abstract
  89. item.Author = req.Author
  90. item.Frequency = req.Frequency
  91. item.State = req.State
  92. item.Content = html.EscapeString(req.Content)
  93. item.Stage = maxStage + 1
  94. item.ContentSub = html.EscapeString(contentSub)
  95. item.CreateTime = req.CreateTime
  96. item.ModifyTime = time.Now()
  97. item.Overview = req.Overview
  98. item.AdminId = sysUser.AdminId
  99. item.AdminRealName = sysUser.RealName
  100. newReportId, err := models.AddEnglishReport(item)
  101. if err != nil {
  102. br.Msg = "保存失败"
  103. br.ErrMsg = "保存失败,Err:" + err.Error()
  104. return
  105. }
  106. reportCode := utils.MD5(strconv.Itoa(int(newReportId)))
  107. //修改唯一编码
  108. {
  109. go models.ModifyEnglishReportCode(newReportId, reportCode)
  110. }
  111. resp := new(models.AddEnglishReportResp)
  112. resp.ReportId = newReportId
  113. resp.ReportCode = reportCode
  114. br.Ret = 200
  115. br.Success = true
  116. br.Msg = "保存成功"
  117. br.Data = resp
  118. }
  119. // @Title 编辑报告接口
  120. // @Description 编辑报告
  121. // @Param request body models.EditEnglishReportReq true "type json string"
  122. // @Success 200 {object} models.EditEnglishReportResp
  123. // @router /edit [post]
  124. func (this *EnglishReportController) Edit() {
  125. br := new(models.BaseResponse).Init()
  126. defer func() {
  127. this.Data["json"] = br
  128. this.ServeJSON()
  129. }()
  130. sysUser := this.SysUser
  131. if sysUser == nil {
  132. br.Msg = "请登录"
  133. br.ErrMsg = "请登录,SysUser Is Empty"
  134. br.Ret = 408
  135. return
  136. }
  137. var req models.EditEnglishReportReq
  138. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  139. if err != nil {
  140. br.Msg = "参数解析异常!"
  141. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  142. return
  143. }
  144. if req.Content == "" {
  145. br.Msg = "请输入内容"
  146. return
  147. }
  148. if req.Overview == "" {
  149. br.Msg = "请输入overview"
  150. return
  151. }
  152. if req.Abstract == "" {
  153. br.Msg = "请输入摘要"
  154. return
  155. }
  156. markStatus, err := services.UpdateEnReportEditMark(int(req.ReportId), sysUser.AdminId, 1, sysUser.RealName)
  157. if err != nil {
  158. br.Msg = err.Error()
  159. return
  160. }
  161. if markStatus.Status == 1 {
  162. br.Msg = markStatus.Msg
  163. return
  164. }
  165. var contentSub string
  166. if req.Content != "" {
  167. content, e := services.FilterReportContentBr(req.Content)
  168. if e != nil {
  169. br.Msg = "内容去除前后空格失败"
  170. br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error()
  171. return
  172. }
  173. req.Content = content
  174. contentSub, err = services.GetReportContentSub(req.Content)
  175. if err != nil {
  176. go alarm_msg.SendAlarmMsg("解析 ContentSub 失败,Err:"+err.Error(), 3)
  177. //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers)
  178. }
  179. }
  180. var stage int
  181. report, _ := models.GetEnglishReportById(int(req.ReportId))
  182. if report != nil {
  183. if report.ClassifyNameFirst != req.ClassifyNameFirst || report.ClassifyNameSecond != req.ClassifyNameSecond {
  184. maxStage, _ := models.GetEnglishReportStageEdit(req.ClassifyIdFirst, req.ClassifyIdSecond, int(req.ReportId))
  185. maxStage = maxStage + 1
  186. stage = maxStage
  187. } else {
  188. stage = report.Stage
  189. }
  190. }
  191. item := new(models.EnglishReport)
  192. item.ClassifyIdFirst = req.ClassifyIdFirst
  193. item.ClassifyNameFirst = req.ClassifyNameFirst
  194. item.ClassifyIdSecond = req.ClassifyIdSecond
  195. item.ClassifyNameSecond = req.ClassifyNameSecond
  196. item.Title = req.Title
  197. item.Abstract = req.Abstract
  198. item.Author = req.Author
  199. item.Frequency = req.Frequency
  200. item.State = req.State
  201. item.Stage = stage
  202. item.Content = html.EscapeString(req.Content)
  203. item.ContentSub = html.EscapeString(contentSub)
  204. item.CreateTime = req.CreateTime
  205. item.Overview = req.Overview
  206. err = models.EditEnglishReport(item, req.ReportId)
  207. if err != nil {
  208. br.Msg = "保存失败"
  209. br.ErrMsg = "保存失败,Err:" + err.Error()
  210. return
  211. }
  212. reportCode := utils.MD5(strconv.Itoa(int(req.ReportId)))
  213. resp := new(models.EditEnglishReportResp)
  214. resp.ReportId = req.ReportId
  215. resp.ReportCode = reportCode
  216. br.Ret = 200
  217. br.Success = true
  218. br.Msg = "保存成功"
  219. br.Data = resp
  220. }
  221. // @Title 获取报告详情接口
  222. // @Description 获取报告详情
  223. // @Param request body models.ReportDetailReq true "type json string"
  224. // @Success 200 {object} models.EnglishReportDetailView
  225. // @router /detail [get]
  226. func (this *EnglishReportController) Detail() {
  227. br := new(models.BaseResponse).Init()
  228. defer func() {
  229. this.Data["json"] = br
  230. this.ServeJSON()
  231. }()
  232. /*var req models.ReportDetailReq
  233. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  234. if err != nil {
  235. br.Msg = "参数解析异常!"
  236. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  237. return
  238. }
  239. if req.ReportId <= 0 {
  240. br.Msg = "参数错误"
  241. return
  242. }*/
  243. reportId, err := this.GetInt("ReportId")
  244. if err != nil {
  245. br.Msg = "获取参数失败!"
  246. br.ErrMsg = "获取参数失败,Err:" + err.Error()
  247. return
  248. }
  249. if reportId <= 0 {
  250. br.Msg = "参数错误"
  251. return
  252. }
  253. item, err := models.GetEnglishReportById(reportId)
  254. if err != nil {
  255. if err.Error() == utils.ErrNoRow() {
  256. br.Msg = "报告已被删除"
  257. return
  258. }
  259. br.Msg = "获取失败"
  260. br.ErrMsg = "获取失败,Err:" + err.Error()
  261. return
  262. }
  263. item.Content = html.UnescapeString(item.Content)
  264. item.ContentSub = html.UnescapeString(item.ContentSub)
  265. classifyNameMap := make(map[int]*models.EnglishClassifyFullName)
  266. if item.ClassifyIdSecond > 0 {
  267. nameList, tErr := models.GetEnglishClassifyFullNameByIds([]int{item.ClassifyIdSecond})
  268. if tErr != nil {
  269. br.Msg = "获取分类名称失败"
  270. br.ErrMsg = "获取分类名称失败, ERR:" + tErr.Error()
  271. return
  272. }
  273. for _, v := range nameList {
  274. classifyNameMap[v.Id] = v
  275. }
  276. //处理分类名
  277. if n, ok := classifyNameMap[item.ClassifyIdSecond]; ok {
  278. item.ClassifyNameRoot = n.RootName
  279. item.ClassifyIdRoot = n.RootId
  280. }
  281. }
  282. br.Ret = 200
  283. br.Success = true
  284. br.Msg = "获取成功"
  285. br.Data = item
  286. }
  287. // ListReport
  288. // @Title 获取报告列表接口
  289. // @Description 获取报告列表
  290. // @Param PageSize query int true "每页数据条数"
  291. // @Param CurrentIndex query int true "当前页页码,从1开始"
  292. // @Param TimeType query string true "筛选的时间类别:publish_time(发布时间),modify_time(更新时间)"
  293. // @Param StartDate query string true "开始时间"
  294. // @Param EndDate query string true "结束时间"
  295. // @Param Frequency query string true "频度"
  296. // @Param ClassifyIdFirst query string true "一级分类id"
  297. // @Param ClassifyIdSecond query string true "二级分类id"
  298. // @Param State query int true "状态"
  299. // @Param KeyWord query string true "搜索关键词"
  300. // @Param PublishSort query string true "desc:降序,asc 升序(预留)"
  301. // @Param CompanyType query string false "产品类型,枚举值:'ficc','权益';不传默认返回全部"
  302. // @Success 200 {object} models.ReportListResp
  303. // @router /list [get]
  304. func (this *EnglishReportController) ListReport() {
  305. br := new(models.BaseResponse).Init()
  306. defer func() {
  307. this.Data["json"] = br
  308. this.ServeJSON()
  309. }()
  310. sysUser := this.SysUser
  311. if sysUser == nil {
  312. br.Msg = "请登录"
  313. br.ErrMsg = "请登录,SysUser Is Empty"
  314. br.Ret = 408
  315. return
  316. }
  317. pageSize, _ := this.GetInt("PageSize")
  318. currentIndex, _ := this.GetInt("CurrentIndex")
  319. timeType := this.GetString("TimeType")
  320. startDate := this.GetString("StartDate")
  321. endDate := this.GetString("EndDate")
  322. frequency := this.GetString("Frequency")
  323. classifyIdFirst, _ := this.GetInt("ClassifyIdFirst")
  324. classifyIdSecond, _ := this.GetInt("ClassifyIdSecond")
  325. classifyIdRoot, _ := this.GetInt("ClassifyIdRoot")
  326. state, _ := this.GetInt("State")
  327. keyWord := this.GetString("KeyWord")
  328. companyType := this.GetString("CompanyType")
  329. // 群发邮件状态筛选
  330. emailState, _ := this.GetInt("EmailState")
  331. var startSize int
  332. if pageSize <= 0 {
  333. pageSize = utils.PageSize20
  334. }
  335. if currentIndex <= 0 {
  336. currentIndex = 1
  337. }
  338. startSize = utils.StartIndex(currentIndex, pageSize)
  339. var condition string
  340. var pars []interface{}
  341. if keyWord != "" {
  342. condition += ` AND (title LIKE ? OR admin_real_name LIKE ? ) `
  343. pars = utils.GetLikeKeywordPars(pars, keyWord, 2)
  344. }
  345. if timeType == "" {
  346. timeType = "publish_time"
  347. }
  348. if timeType != "publish_time" && timeType != "modify_time" {
  349. br.Msg = "请选择正确的时间"
  350. br.ErrMsg = "请选择正确的时间"
  351. return
  352. }
  353. if startDate != "" {
  354. condition += ` AND ` + timeType + ` >= ? `
  355. pars = append(pars, startDate)
  356. }
  357. if endDate != "" {
  358. condition += ` AND ` + timeType + ` <= ? `
  359. pars = append(pars, endDate)
  360. }
  361. if frequency != "" {
  362. condition += ` AND frequency = ? `
  363. pars = append(pars, frequency)
  364. }
  365. if classifyIdFirst != 0 {
  366. condition += ` AND classify_id_first = ? `
  367. pars = append(pars, classifyIdFirst)
  368. }
  369. if classifyIdSecond != 0 {
  370. condition += ` AND classify_id_second = ? `
  371. pars = append(pars, classifyIdSecond)
  372. }
  373. if state > 0 {
  374. condition += ` AND state = ? `
  375. pars = append(pars, state)
  376. }
  377. if classifyIdRoot > 0 && classifyIdFirst == 0 && classifyIdSecond == 0 {
  378. //查询顶级分类下的所有二级分类ID
  379. childClassify, err := models.GetEnglishSecondClassifyList([]int{classifyIdRoot})
  380. if err != nil {
  381. br.Msg = "查询子分类出错"
  382. br.ErrMsg = "查询子分类出错, Err:" + err.Error()
  383. return
  384. }
  385. var childClassifyIds []int
  386. if len(childClassify) > 0 {
  387. for _, v := range childClassify {
  388. childClassifyIds = append(childClassifyIds, v.Id)
  389. }
  390. condition += ` AND classify_id_first IN (` + utils.GetOrmInReplace(len(childClassifyIds)) + `)`
  391. pars = append(pars, childClassifyIds)
  392. } else {
  393. //一级分类下没有子分类,直接返回空列表
  394. page := paging.GetPaging(currentIndex, pageSize, 0)
  395. resp := new(models.EnglishReportListResp)
  396. resp.Paging = page
  397. resp.List = make([]*models.EnglishReportList, 0)
  398. br.Ret = 200
  399. br.Success = true
  400. br.Msg = "获取成功"
  401. br.Data = resp
  402. return
  403. }
  404. }
  405. // 未群发邮件(包含推送邮件失败的)
  406. if emailState == 1 {
  407. failIds, e := models.GetHasFailEmailLogReportIds()
  408. if e != nil {
  409. br.Msg = "获取失败"
  410. br.ErrMsg = "获取存在邮件推送失败记录的英文报告IDs失败, Err:" + e.Error()
  411. return
  412. }
  413. condition += ` AND email_state = 0`
  414. if len(failIds) > 0 {
  415. condition += ` OR id IN (` + utils.GetOrmInReplace(len(failIds)) + `)`
  416. pars = append(pars, failIds)
  417. }
  418. }
  419. // 已群发邮件
  420. if emailState == 2 {
  421. successIds, e := models.GetSuccessEmailLogReportIds()
  422. if e != nil {
  423. br.Msg = "获取失败"
  424. br.ErrMsg = "获取邮件推送记录均为成功的英文报告IDs失败, Err:" + e.Error()
  425. return
  426. }
  427. condition += ` AND email_state = 1`
  428. if len(successIds) > 0 {
  429. condition += ` AND id IN (` + utils.GetOrmInReplace(len(successIds)) + `)`
  430. pars = append(pars, successIds)
  431. }
  432. }
  433. var total int
  434. var errCount, errList, errOther error
  435. var authOk bool
  436. list := make([]*models.EnglishReportList, 0)
  437. failMap := make(map[int]bool, 0) // 有群发失败记录的研报
  438. adminMap := make(map[int]string, 0) // 编辑中的研究员姓名
  439. wg := sync.WaitGroup{}
  440. wg.Add(3)
  441. // 列表总数
  442. go func() {
  443. defer func() {
  444. wg.Done()
  445. }()
  446. t, e := models.GetEnglishReportListCount(condition, pars, companyType)
  447. if e != nil {
  448. errCount = fmt.Errorf("获取英文研报Count失败, Err: %s", e.Error())
  449. return
  450. }
  451. total = t
  452. }()
  453. // 列表数据
  454. go func() {
  455. defer func() {
  456. wg.Done()
  457. }()
  458. // 限制一下富文本字段, 列表用不到
  459. fieldArr := []string{
  460. "id", "add_type", "classify_id_first", "classify_name_first", "classify_id_second", "classify_name_second", "title", "abstract", "author",
  461. "frequency", "create_time", "modify_time", "state", "publish_time", "pre_publish_time", "stage", "msg_is_send", "report_code", "pv", "share_url",
  462. "pv_email", "email_state", "from_report_id", "key_takeaways", "admin_id", "admin_real_name",
  463. }
  464. items, e := models.GetEnglishReportList(condition, pars, companyType, startSize, pageSize, fieldArr)
  465. if e != nil {
  466. errList = fmt.Errorf("获取英文研报列表失败, Err: %s", e.Error())
  467. return
  468. }
  469. list = items
  470. }()
  471. // 群发权限/失败记录
  472. go func() {
  473. defer func() {
  474. wg.Done()
  475. }()
  476. // 获取邮件配置-是否有权限群发
  477. conf := new(models.EnglishReportEmailConf)
  478. authKey := "english_report_email_conf"
  479. confAuth, e := company.GetConfigDetailByCode(authKey)
  480. if e != nil {
  481. errOther = fmt.Errorf("获取群发邮件权限失败, Err: %s", e.Error())
  482. return
  483. }
  484. if confAuth.ConfigValue == "" {
  485. errOther = fmt.Errorf("群发邮件配置为空")
  486. return
  487. }
  488. if e := json.Unmarshal([]byte(confAuth.ConfigValue), &conf); e != nil {
  489. errOther = fmt.Errorf("群发邮件配置有误")
  490. return
  491. }
  492. authArr := strings.Split(conf.SendAuthGroup, ",")
  493. if utils.InArrayByStr(authArr, sysUser.RoleTypeCode) {
  494. authOk = true
  495. }
  496. // 是否有群发邮件失败的记录,标记红点
  497. failList, e := models.GetEnglishReportEmailLogFailList(0)
  498. if e != nil {
  499. errOther = fmt.Errorf("获取群发邮件记录失败, Err: %s", e.Error())
  500. return
  501. }
  502. for i := range failList {
  503. failMap[failList[i].ReportId] = true
  504. }
  505. // 获取admin, 用于匹配编辑中的研究员姓名
  506. admins, e := system.GetSysAdminList("", make([]interface{}, 0), []string{"admin_id", "real_name"}, "")
  507. if e != nil {
  508. errOther = fmt.Errorf("获取系统用户列表失败, Err: %s", e.Error())
  509. return
  510. }
  511. for _, a := range admins {
  512. adminMap[a.AdminId] = a.RealName
  513. }
  514. }()
  515. wg.Wait()
  516. if errCount != nil {
  517. br.Msg = "获取失败"
  518. br.ErrMsg = errCount.Error()
  519. return
  520. }
  521. if errList != nil {
  522. br.Msg = "获取失败"
  523. br.ErrMsg = errList.Error()
  524. return
  525. }
  526. if errOther != nil {
  527. br.Msg = "获取失败"
  528. br.ErrMsg = errOther.Error()
  529. return
  530. }
  531. // 查询分类信息
  532. var classifyIdSecondSlice []int
  533. for _, item := range list {
  534. classifyIdSecondSlice = append(classifyIdSecondSlice, item.ClassifyIdSecond)
  535. }
  536. classifyNameMap := make(map[int]*models.EnglishClassifyFullName)
  537. if len(classifyIdSecondSlice) > 0 {
  538. nameList, err := models.GetEnglishClassifyFullNameByIds(classifyIdSecondSlice)
  539. if err != nil {
  540. br.Msg = "获取分类名称失败"
  541. br.ErrMsg = "获取分类名称失败, ERR:" + err.Error()
  542. return
  543. }
  544. for _, v := range nameList {
  545. classifyNameMap[v.Id] = v
  546. }
  547. }
  548. for _, item := range list {
  549. if item.State == 2 {
  550. item.ShareUrl = "https://share.hzinsights.com/reportEn?code=" + item.ReportCode
  551. }
  552. item.EmailAuth = authOk
  553. item.EmailHasFail = failMap[item.Id]
  554. // 邮箱PV大于0的时候, 不展示最初版本的PV
  555. if item.PvEmail > 0 {
  556. item.Pv = 0
  557. }
  558. // 报告是否正在编辑中
  559. var opUser models.MarkReportItem
  560. key := fmt.Sprint(`crm:enReport:edit:`, item.Id)
  561. opUserId, e := utils.Rc.RedisInt(key)
  562. if e != nil {
  563. str, te := utils.Rc.RedisString(key)
  564. if te == nil {
  565. te = json.Unmarshal([]byte(str), &opUser)
  566. if te == nil {
  567. opUserId = opUser.AdminId
  568. }
  569. }
  570. }
  571. var ret models.MarkReportResp
  572. if opUserId > 0 && opUserId != sysUser.AdminId {
  573. editor := opUser.Editor
  574. if editor == "" {
  575. editor = adminMap[opUserId]
  576. }
  577. ret.Status = 1
  578. ret.Msg = fmt.Sprintf("当前%s正在编辑报告", editor)
  579. ret.Editor = editor
  580. }
  581. if ret.Status == 0 {
  582. item.CanEdit = true
  583. } else {
  584. item.Editor = ret.Editor
  585. }
  586. //处理分类名
  587. if n, ok := classifyNameMap[item.ClassifyIdSecond]; ok {
  588. if n.RootId == 0 {
  589. item.FullClassifyName = strings.Join([]string{n.ParentName, n.ClassifyName}, "/")
  590. } else {
  591. item.FullClassifyName = strings.Join([]string{n.RootName, n.ParentName, n.ClassifyName}, "/")
  592. }
  593. item.ClassifyIdRoot = n.RootId
  594. item.ClassifyNameRoot = n.RootName
  595. }
  596. }
  597. page := paging.GetPaging(currentIndex, pageSize, total)
  598. resp := new(models.EnglishReportListResp)
  599. resp.Paging = page
  600. resp.List = list
  601. br.Ret = 200
  602. br.Success = true
  603. br.Msg = "获取成功"
  604. br.Data = resp
  605. }
  606. // @Title 发布报告接口
  607. // @Description 发布报告
  608. // @Param request body models.PublishReq true "type json string"
  609. // @Success 200 Ret=200 发布成功
  610. // @router /publish [post]
  611. func (this *EnglishReportController) PublishReport() {
  612. br := new(models.BaseResponse).Init()
  613. defer func() {
  614. this.Data["json"] = br
  615. this.ServeJSON()
  616. }()
  617. var req models.PublishReq
  618. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  619. if err != nil {
  620. br.Msg = "参数解析异常!"
  621. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  622. return
  623. }
  624. reportIds := req.ReportIds
  625. if reportIds == "" {
  626. br.Msg = "参数错误"
  627. br.ErrMsg = "参数错误,报告id不可为空"
  628. return
  629. }
  630. reportArr := strings.Split(reportIds, ",")
  631. for _, v := range reportArr {
  632. vint, err := strconv.Atoi(v)
  633. if err != nil {
  634. br.Msg = "参数错误"
  635. br.ErrMsg = "参数错误,Err:" + err.Error()
  636. return
  637. }
  638. report, err := models.GetEnglishReportById(vint)
  639. if err != nil {
  640. br.Msg = "获取报告信息失败"
  641. br.ErrMsg = "获取报告信息失败,Err:" + err.Error()
  642. return
  643. }
  644. if report == nil {
  645. br.Msg = "报告不存在"
  646. return
  647. }
  648. var tmpErr error
  649. if report.Content == "" {
  650. br.Msg = "报告内容为空,不可发布"
  651. br.ErrMsg = "报告内容为空,不需要生成,report_id:" + strconv.Itoa(report.Id)
  652. return
  653. }
  654. var publishTime string
  655. if report.PublishTime != "" {
  656. // 发布时间固定为首次发布时间
  657. publishTime = report.PublishTime
  658. } else {
  659. publishTime = time.Now().Format(utils.FormatDateTime)
  660. }
  661. if tmpErr = models.PublishEnglishReportById(report.Id, publishTime); tmpErr != nil {
  662. br.Msg = "报告发布失败"
  663. br.ErrMsg = "报告发布失败, Err:" + tmpErr.Error() + ", report_id:" + strconv.Itoa(report.Id)
  664. return
  665. }
  666. go func() {
  667. _ = services.UpdateEnglishReportEs(report.Id, 2)
  668. }()
  669. }
  670. br.Ret = 200
  671. br.Success = true
  672. br.Msg = "发布成功"
  673. }
  674. // PrePublishReport
  675. // @Title 设置定时发布接口
  676. // @Description 设置定时发布接口
  677. // @Param request body models.PrePublishReq true "type json string"
  678. // @Success 200 Ret=200 发布成功
  679. // @router /pre_publish [post]
  680. func (this *EnglishReportController) PrePublishReport() {
  681. br := new(models.BaseResponse).Init()
  682. defer func() {
  683. this.Data["json"] = br
  684. this.ServeJSON()
  685. }()
  686. var req models.PrePublishReq
  687. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  688. if err != nil {
  689. br.Msg = "参数解析异常!"
  690. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  691. return
  692. }
  693. reportId := req.ReportId
  694. if reportId == 0 {
  695. br.Msg = "参数错误"
  696. br.ErrMsg = "参数错误,报告id不可为空"
  697. return
  698. }
  699. if req.PrePublishTime == "" {
  700. br.Msg = "发布时间不能为空"
  701. return
  702. }
  703. prePublishTime, err := time.ParseInLocation(utils.FormatDateTime, req.PrePublishTime, time.Local)
  704. if err != nil {
  705. br.Msg = "发布时间格式错误"
  706. br.ErrMsg = "发布时间格式错误,Err:" + err.Error()
  707. return
  708. }
  709. if prePublishTime.Before(time.Now()) {
  710. br.Msg = "发布时间不允许选择过去时间"
  711. return
  712. }
  713. if prePublishTime.Before(time.Now().Add(2 * time.Minute)) {
  714. br.Msg = "发布时间距离当前时间太近了"
  715. return
  716. }
  717. report, err := models.GetEnglishReportById(reportId)
  718. if err != nil {
  719. br.Msg = "获取报告信息失败"
  720. br.ErrMsg = "获取报告信息失败,Err:" + err.Error()
  721. return
  722. }
  723. if report == nil {
  724. br.Msg = "报告不存在"
  725. return
  726. }
  727. if report.Content == "" {
  728. br.Msg = "报告内容为空,不可发布"
  729. br.ErrMsg = "报告内容为空,不需要生成,report_id:" + strconv.Itoa(report.Id)
  730. return
  731. }
  732. if report.State == 2 {
  733. br.Msg = "报告已发布,不可设置定时发布"
  734. return
  735. }
  736. var tmpErr error
  737. if tmpErr = models.SetPrePublishEnglishReportById(report.Id, req.PrePublishTime); tmpErr != nil {
  738. br.Msg = "设置定时发布失败"
  739. br.ErrMsg = "设置定时发布失败, Err:" + tmpErr.Error() + ", report_id:" + strconv.Itoa(report.Id)
  740. return
  741. }
  742. br.Ret = 200
  743. br.Success = true
  744. br.Msg = "定时发布成功"
  745. }
  746. // @Title 取消发布报告接口
  747. // @Description 取消发布报告
  748. // @Param request body models.PublishCancelReq true "type json string"
  749. // @Success 200 Ret=200 取消发布成功
  750. // @router /publish/cancel [post]
  751. func (this *EnglishReportController) PublishCancleReport() {
  752. br := new(models.BaseResponse).Init()
  753. defer func() {
  754. this.Data["json"] = br
  755. this.ServeJSON()
  756. }()
  757. var req models.PublishCancelReq
  758. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  759. if err != nil {
  760. br.Msg = "参数解析异常!"
  761. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  762. return
  763. }
  764. if req.ReportIds <= 0 {
  765. br.Msg = "参数错误"
  766. br.ErrMsg = "参数错误,报告id不可为空"
  767. return
  768. }
  769. err = models.PublishCancelEnglishReport(req.ReportIds)
  770. if err != nil {
  771. br.Msg = "取消发布失败"
  772. br.ErrMsg = "取消发布失败,Err:" + err.Error()
  773. return
  774. }
  775. // 更新es里的报告状态
  776. go func() {
  777. _ = services.UpdateEnglishReportEs(req.ReportIds, 1)
  778. }()
  779. br.Ret = 200
  780. br.Success = true
  781. br.Msg = "取消发布成功"
  782. }
  783. // @Title 删除报告接口
  784. // @Description 删除报告
  785. // @Param request body models.DeleteReq true "type json string"
  786. // @Success 200 Ret=200 删除成功
  787. // @router /delete [post]
  788. func (this *EnglishReportController) Delete() {
  789. br := new(models.BaseResponse).Init()
  790. defer func() {
  791. this.Data["json"] = br
  792. this.ServeJSON()
  793. }()
  794. var req models.DeleteReq
  795. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  796. if err != nil {
  797. br.Msg = "参数解析异常!"
  798. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  799. return
  800. }
  801. if req.ReportIds <= 0 {
  802. br.Msg = "参数错误"
  803. br.ErrMsg = "参数错误,报告id不可为空"
  804. return
  805. }
  806. reportInfo, err := models.GetEnglishReportById(req.ReportIds)
  807. if err != nil {
  808. if err.Error() == utils.ErrNoRow() {
  809. br.Msg = "报告不存在"
  810. return
  811. }
  812. br.Msg = "查询报告信息失败"
  813. br.ErrMsg = "查询报告信息失败, Err" + err.Error()
  814. return
  815. }
  816. // 更新es里的报告状态
  817. _ = services.UpdateEnglishReportEs(req.ReportIds, 1)
  818. if err = models.DeleteEnglishReportAndChapter(reportInfo); err != nil {
  819. br.Msg = "删除失败"
  820. br.ErrMsg = "删除报告失败, Err: " + err.Error()
  821. return
  822. }
  823. // 重置PPT关联报告
  824. go func() {
  825. _ = services.ResetPPTReport(req.ReportIds, true)
  826. }()
  827. go func() {
  828. _ = services.EnglishPolicyReportSyncCancel(reportInfo)
  829. }()
  830. br.Ret = 200
  831. br.Success = true
  832. br.Msg = "删除成功"
  833. }
  834. // @Title 保存草稿
  835. // @Description 保存草稿
  836. // @Param request body models.SaveReportContent true "type json string"
  837. // @Success 200 {object} models.ReportAuthorResp
  838. // @router /saveReportContent [post]
  839. func (this *EnglishReportController) SaveReportContent() {
  840. br := new(models.BaseResponse).Init()
  841. br.IsSendEmail = false
  842. defer func() {
  843. this.Data["json"] = br
  844. this.ServeJSON()
  845. }()
  846. var req models.SaveReportContent
  847. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  848. if err != nil {
  849. br.Msg = "参数解析异常!"
  850. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  851. return
  852. }
  853. sysUser := this.SysUser
  854. if sysUser == nil {
  855. br.Msg = "请登录"
  856. br.ErrMsg = "请登录,SysUser Is Empty"
  857. br.Ret = 408
  858. return
  859. }
  860. reportId := req.ReportId
  861. noChangeFlag := req.NoChange
  862. fmt.Println("reportId:", reportId)
  863. if reportId <= 0 {
  864. br.Msg = "请输入报告ID"
  865. return
  866. }
  867. markStatus, err := services.UpdateEnReportEditMark(int(req.ReportId), sysUser.AdminId, 1, sysUser.RealName)
  868. if err != nil {
  869. br.Msg = err.Error()
  870. return
  871. }
  872. if markStatus.Status == 1 {
  873. br.Msg = markStatus.Msg
  874. return
  875. }
  876. if noChangeFlag != 1 {
  877. content := req.Content
  878. if content == "" {
  879. content = this.GetString("Content")
  880. }
  881. if content != "" {
  882. contentClean, e := services.FilterReportContentBr(req.Content)
  883. if e != nil {
  884. br.Msg = "内容去除前后空格失败"
  885. br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error()
  886. return
  887. }
  888. content = contentClean
  889. contentSub, err := services.GetReportContentSub(content)
  890. if err != nil {
  891. go alarm_msg.SendAlarmMsg("解析 ContentSub 失败,Err:"+err.Error(), 3)
  892. //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers)
  893. }
  894. content = html.EscapeString(content)
  895. contentSub = html.EscapeString(contentSub)
  896. err = models.EditEnglishReportContent(reportId, content, contentSub)
  897. if err != nil {
  898. br.Msg = "保存失败"
  899. br.ErrMsg = "保存失败,Err:" + err.Error()
  900. return
  901. }
  902. go models.AddEnglishReportSaveLog(reportId, this.SysUser.AdminId, content, contentSub, this.SysUser.AdminName)
  903. }
  904. }
  905. resp := new(models.SaveReportContentResp)
  906. resp.ReportId = reportId
  907. br.Ret = 200
  908. br.Success = true
  909. br.Msg = "保存成功成功"
  910. br.Data = resp
  911. }
  912. // @Title 根据分类获取最近一次报告详情接口
  913. // @Description 根据分类获取最近一次报告详情
  914. // @Param request body models.ClassifyIdDetailReq true "type json string"
  915. // @Success 200 {object} models.Report
  916. // @router /classifyIdDetail [get]
  917. func (this *EnglishReportController) ClassifyIdDetail() {
  918. br := new(models.BaseResponse).Init()
  919. defer func() {
  920. this.Data["json"] = br
  921. this.ServeJSON()
  922. }()
  923. //classify_id_first=34&classify_id_second=36
  924. /*var req models.ClassifyIdDetailReq
  925. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  926. if err != nil {
  927. br.Msg = "参数解析异常!"
  928. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  929. return
  930. }*/
  931. classifyIdFirst, _ := this.GetInt("classify_id_first")
  932. if classifyIdFirst <= 0 {
  933. classifyIdFirst, _ = this.GetInt("ClassifyIdFirst")
  934. }
  935. classifyIdSecond, _ := this.GetInt("classify_id_second")
  936. if classifyIdSecond <= 0 {
  937. classifyIdSecond, _ = this.GetInt("ClassifyIdSecond")
  938. }
  939. item, err := models.GetEnglishReportDetailByClassifyId(classifyIdFirst, classifyIdSecond)
  940. if err != nil && err.Error() != utils.ErrNoRow() {
  941. br.Msg = "获取失败!"
  942. br.ErrMsg = "获取失败,Err:" + err.Error()
  943. return
  944. }
  945. if item != nil {
  946. item.Content = html.UnescapeString(item.Content)
  947. item.ContentSub = html.UnescapeString(item.ContentSub)
  948. classifyNameMap := make(map[int]*models.EnglishClassifyFullName)
  949. if item.ClassifyIdSecond > 0 {
  950. nameList, tErr := models.GetEnglishClassifyFullNameByIds([]int{item.ClassifyIdSecond})
  951. if tErr != nil {
  952. br.Msg = "获取分类名称失败"
  953. br.ErrMsg = "获取分类名称失败, ERR:" + tErr.Error()
  954. return
  955. }
  956. for _, v := range nameList {
  957. classifyNameMap[v.Id] = v
  958. }
  959. //处理分类名
  960. if n, ok := classifyNameMap[item.ClassifyIdSecond]; ok {
  961. item.ClassifyNameRoot = n.RootName
  962. item.ClassifyIdRoot = n.RootId
  963. }
  964. }
  965. }
  966. br.Ret = 200
  967. br.Success = true
  968. br.Msg = "获取成功"
  969. br.Data = item
  970. }
  971. // Author
  972. // @Title 获取报告作者接口
  973. // @Description 获取报告作者
  974. // @Param AuthorType query int true "来源类型,1:中文,2:英文"
  975. // @Param Keyword query string true "搜索关键词"
  976. // @Param CurrentIndex query int true "当前页页码,从1开始"
  977. // @Param StartDate query string true "开始时间"
  978. // @Success 200 {object} models.ReportAuthorResp
  979. // @router /author [get]
  980. func (this *EnglishReportController) Author() {
  981. br := new(models.BaseResponse).Init()
  982. defer func() {
  983. this.Data["json"] = br
  984. this.ServeJSON()
  985. }()
  986. keyword := this.GetString("Keyword")
  987. var condition string
  988. var pars []interface{}
  989. condition += ` AND author_type = 2 AND enable = 1`
  990. if keyword != `` {
  991. condition += ` AND report_author like ? `
  992. pars = append(pars, utils.GetLikeKeyword(keyword))
  993. }
  994. _, items, err := models.GetReportAuthorList(condition, pars, 0, 10000)
  995. if err != nil {
  996. br.Msg = "获取失败!"
  997. br.ErrMsg = "获取失败,Err:" + err.Error()
  998. return
  999. }
  1000. resp := models.ReportAuthorResp{
  1001. List: items,
  1002. }
  1003. br.Ret = 200
  1004. br.Success = true
  1005. br.Msg = "获取成功"
  1006. br.Data = resp
  1007. }
  1008. // MarkEditStatus
  1009. // @Title 标记报告编辑状态
  1010. // @Description 标记报告编辑状态接口
  1011. // @Param request body request.MarkEditEnReport true "type json string"
  1012. // @Success 200 标记成功 ;202 标记成功
  1013. // @router /mark [post]
  1014. func (this *EnglishReportController) MarkEditStatus() {
  1015. br := new(models.BaseResponse).Init()
  1016. defer func() {
  1017. this.Data["json"] = br
  1018. this.ServeJSON()
  1019. }()
  1020. sysUser := this.SysUser
  1021. if sysUser == nil {
  1022. br.Msg = "请登录"
  1023. br.ErrMsg = "请登录,SysUser Is Empty"
  1024. br.Ret = 408
  1025. return
  1026. }
  1027. var req models.MarkEditEnReport
  1028. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1029. if err != nil {
  1030. br.Msg = "参数解析异常!"
  1031. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1032. return
  1033. }
  1034. if req.ReportId <= 0 {
  1035. br.Msg = "缺少报告Id"
  1036. return
  1037. }
  1038. if req.Status <= 0 {
  1039. br.Msg = "标记状态异常"
  1040. return
  1041. }
  1042. //更新标记key
  1043. data, err := services.UpdateEnReportEditMark(req.ReportId, sysUser.AdminId, req.Status, sysUser.RealName)
  1044. if err != nil {
  1045. br.Msg = err.Error()
  1046. return
  1047. }
  1048. msg := "标记成功"
  1049. br.Ret = 200
  1050. br.Success = true
  1051. br.Msg = msg
  1052. br.Data = data
  1053. }
  1054. // @Title 编辑来自策略报告的报告
  1055. // @Description 编辑来自策略报告的报告
  1056. // @Param request body models.EditEnglishReportFromPolicyReq true "type json string"
  1057. // @Success 200 {object} models.EditEnglishReportResp
  1058. // @router /edit_policy [post]
  1059. func (this *EnglishReportController) EditPolicy() {
  1060. br := new(models.BaseResponse).Init()
  1061. defer func() {
  1062. this.Data["json"] = br
  1063. this.ServeJSON()
  1064. }()
  1065. sysUser := this.SysUser
  1066. if sysUser == nil {
  1067. br.Msg = "请登录"
  1068. br.ErrMsg = "请登录,SysUser Is Empty"
  1069. br.Ret = 408
  1070. return
  1071. }
  1072. var req models.EditEnglishReportFromPolicyReq
  1073. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1074. if err != nil {
  1075. br.Msg = "参数解析异常!"
  1076. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1077. return
  1078. }
  1079. if req.ReportId <= 0 {
  1080. br.Msg = "请选择报告ID"
  1081. return
  1082. }
  1083. if req.Title == "" {
  1084. br.Msg = "请输入标题"
  1085. return
  1086. }
  1087. if req.Abstract == "" {
  1088. br.Msg = "请输入摘要"
  1089. return
  1090. }
  1091. if req.Frequency == "" {
  1092. br.Msg = "请输入频度"
  1093. return
  1094. }
  1095. if req.Author == "" {
  1096. br.Msg = "请输入作者"
  1097. return
  1098. }
  1099. if req.CreateTime == "" {
  1100. br.Msg = "请输入创建时间"
  1101. return
  1102. }
  1103. //查询报告是否存在
  1104. reportInfo, err := models.GetEnglishReportItemById(int(req.ReportId))
  1105. if err != nil {
  1106. if err.Error() == utils.ErrNoRow() {
  1107. br.Msg = "报告不存在"
  1108. return
  1109. }
  1110. br.Msg = "查询报告信息失败"
  1111. br.ErrMsg = "查询报告信息失败, Err" + err.Error()
  1112. return
  1113. }
  1114. if reportInfo.State == 2 {
  1115. br.Msg = "报告已发布不允许编辑"
  1116. return
  1117. }
  1118. markStatus, err := services.UpdateEnReportEditMark(int(req.ReportId), sysUser.AdminId, 1, sysUser.RealName)
  1119. if err != nil {
  1120. br.Msg = err.Error()
  1121. return
  1122. }
  1123. if markStatus.Status == 1 {
  1124. br.Msg = markStatus.Msg
  1125. return
  1126. }
  1127. item := reportInfo
  1128. item.Title = req.Title
  1129. item.Abstract = req.Abstract
  1130. item.Author = req.Author
  1131. item.Frequency = req.Frequency
  1132. item.CreateTime = req.CreateTime
  1133. item.ModifyTime = time.Now()
  1134. err = item.Update([]string{"Title", "Abstract", "Author", "Frequency", "CreateTime", "ModifyTime"})
  1135. if err != nil {
  1136. br.Msg = "保存失败"
  1137. br.ErrMsg = "保存失败,Err:" + err.Error()
  1138. return
  1139. }
  1140. reportCode := reportInfo.ReportCode
  1141. resp := new(models.EditEnglishReportResp)
  1142. resp.ReportId = req.ReportId
  1143. resp.ReportCode = reportCode
  1144. br.Ret = 200
  1145. br.Success = true
  1146. br.Msg = "保存成功"
  1147. br.Data = resp
  1148. }