report.go 33 KB

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