report_v2.go 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/models"
  5. "eta/eta_api/models/report"
  6. "eta/eta_api/models/report_approve"
  7. "eta/eta_api/models/system"
  8. "eta/eta_api/services"
  9. "eta/eta_api/services/alarm_msg"
  10. "eta/eta_api/utils"
  11. "github.com/rdlucklib/rdluck_tools/paging"
  12. "html"
  13. "strconv"
  14. "time"
  15. )
  16. // ListReport
  17. // @Title 获取报告列表接口
  18. // @Description 获取报告列表
  19. // @Param PageSize query int true "每页数据条数"
  20. // @Param CurrentIndex query int true "当前页页码,从1开始"
  21. // @Param TimeType query string true "筛选的时间类别:publish_time(发布时间),modify_time(更新时间);approve_time(审批时间)"
  22. // @Param StartDate query string true "开始时间"
  23. // @Param EndDate query string true "结束时间"
  24. // @Param Frequency query string true "频度"
  25. // @Param ClassifyIdFirst query int true "一级分类id"
  26. // @Param ClassifyIdSecond query int true "二级分类id"
  27. // @Param ClassifyIdThird query int true "三级分类id"
  28. // @Param State query int true "状态"
  29. // @Param KeyWord query string true "搜索关键词"
  30. // @Param PublishSort query string true "desc:降序,asc 升序(预留)"
  31. // @Param FilterReportType query string true "筛选报告类型,1:公共研报,2:共享研报,3:我的研报"
  32. // @Success 200 {object} models.ReportListResp
  33. // @router /list [get]
  34. func (this *ReportController) ListReport() {
  35. br := new(models.BaseResponse).Init()
  36. defer func() {
  37. this.Data["json"] = br
  38. this.ServeJSON()
  39. }()
  40. pageSize, _ := this.GetInt("PageSize")
  41. currentIndex, _ := this.GetInt("CurrentIndex")
  42. timeType := this.GetString("TimeType")
  43. startDate := this.GetString("StartDate")
  44. endDate := this.GetString("EndDate")
  45. frequency := this.GetString("Frequency")
  46. classifyIdFirst, _ := this.GetInt("ClassifyIdFirst", 0)
  47. classifyIdSecond, _ := this.GetInt("ClassifyIdSecond", 0)
  48. classifyIdThird, _ := this.GetInt("ClassifyIdThird", 0)
  49. state, _ := this.GetInt("State")
  50. keyWord := this.GetString("KeyWord")
  51. msgIsSend, _ := this.GetInt("MsgIsSend")
  52. filterReportType, _ := this.GetInt("FilterReportType", 1)
  53. var startSize int
  54. if pageSize <= 0 {
  55. pageSize = utils.PageSize20
  56. }
  57. if currentIndex <= 0 {
  58. currentIndex = 1
  59. }
  60. startSize = utils.StartIndex(currentIndex, pageSize)
  61. if timeType == "" {
  62. timeType = "publish_time"
  63. }
  64. if timeType != "publish_time" && timeType != "modify_time" && timeType != "approve_time" {
  65. br.Msg = "请选择正确的时间"
  66. br.ErrMsg = "请选择正确的时间"
  67. return
  68. }
  69. var condition string
  70. var pars []interface{}
  71. if keyWord != "" {
  72. condition += ` AND (a.title LIKE ? OR a.admin_real_name LIKE ? ) `
  73. pars = utils.GetLikeKeywordPars(pars, keyWord, 2)
  74. }
  75. if startDate != "" {
  76. condition += ` AND a.` + timeType + ` >= ? `
  77. pars = append(pars, startDate)
  78. }
  79. if endDate != "" {
  80. condition += ` AND a.` + timeType + ` <= ? `
  81. pars = append(pars, endDate)
  82. }
  83. if frequency != "" {
  84. condition += ` AND a.frequency = ? `
  85. pars = append(pars, frequency)
  86. }
  87. if classifyIdFirst > 0 {
  88. condition += ` AND a.classify_id_first = ? `
  89. pars = append(pars, classifyIdFirst)
  90. }
  91. if classifyIdSecond > 0 {
  92. condition += ` AND a.classify_id_second = ? `
  93. pars = append(pars, classifyIdSecond)
  94. }
  95. if classifyIdThird > 0 {
  96. condition += ` AND a.classify_id_third = ? `
  97. pars = append(pars, classifyIdSecond)
  98. }
  99. if state > 0 {
  100. condition += ` AND a.state = ? `
  101. pars = append(pars, state)
  102. }
  103. // 消息是否已推送 1-未推送; 2-已推送
  104. if msgIsSend == 1 {
  105. condition += ` AND (a.msg_is_send = 0 OR a.ths_msg_is_send = 0) `
  106. }
  107. if msgIsSend == 2 {
  108. condition += ` AND a.msg_is_send = 1 AND a.ths_msg_is_send = 1 `
  109. }
  110. var err error
  111. var total int
  112. var list []*models.ReportList
  113. switch filterReportType {
  114. // 筛选报告类型,1:公共研报,2:共享研报,3:我的研报
  115. case 1:
  116. condition += ` AND a.is_public_publish = ? `
  117. // TODO 临时使用,提测上线前得打开注释
  118. //condition += ` AND a.state in (2,6) `
  119. pars = append(pars, 1)
  120. case 3:
  121. condition += ` AND a.admin_id = ? `
  122. pars = append(pars, this.SysUser.AdminId)
  123. case 2:
  124. condition += ` AND (a.admin_id = ? or b.admin_id = ?) `
  125. pars = append(pars, this.SysUser.AdminId, this.SysUser.AdminId)
  126. }
  127. // 共享报告需要连表查询,所以需要单独写
  128. if filterReportType == 2 {
  129. total, err = models.GetReportListCountByGrant(condition, pars)
  130. if err != nil {
  131. br.Msg = "获取失败"
  132. br.ErrMsg = "获取失败,Err:" + err.Error()
  133. return
  134. }
  135. list, err = models.GetReportListByGrant(condition, pars, startSize, pageSize)
  136. if err != nil {
  137. br.Msg = "获取失败"
  138. br.ErrMsg = "获取失败,Err:" + err.Error()
  139. return
  140. }
  141. } else {
  142. total, err = models.GetReportListCountV1(condition, pars)
  143. if err != nil {
  144. br.Msg = "获取失败"
  145. br.ErrMsg = "获取失败,Err:" + err.Error()
  146. return
  147. }
  148. list, err = models.GetReportListV1(condition, pars, startSize, pageSize)
  149. if err != nil {
  150. br.Msg = "获取失败"
  151. br.ErrMsg = "获取失败,Err:" + err.Error()
  152. return
  153. }
  154. }
  155. listLen := len(list)
  156. if listLen > 0 {
  157. pvMap := make(map[int]int)
  158. uvMap := make(map[int]int)
  159. reportIdArr := make([]string, 0)
  160. syncReportIdArr := make([]string, 0) // 同步过来的报告IDs
  161. oldAndNewReportIdMap := make(map[int]int) // 旧报告和新报告的id对应关系
  162. for i := 0; i < listLen; i++ {
  163. reportIdArr = append(reportIdArr, strconv.Itoa(list[i].Id))
  164. if list[i].OldReportId > 0 {
  165. syncReportIdArr = append(syncReportIdArr, strconv.Itoa(list[i].OldReportId))
  166. oldAndNewReportIdMap[list[i].OldReportId] = list[i].Id
  167. }
  168. pvMap[list[i].Id] = list[i].Pv
  169. uvMap[list[i].Id] = list[i].Uv
  170. }
  171. // 当下报告的pv,uv
  172. if len(reportIdArr) > 0 {
  173. pvList, e := models.GetReportPvUvByReportIdList(reportIdArr)
  174. if e != nil {
  175. br.Msg = "获取失败"
  176. br.ErrMsg = "获取同步报告对应的PV、UV失败, Err: " + e.Error()
  177. return
  178. }
  179. for _, v := range pvList {
  180. pv := pvMap[v.ReportId]
  181. uv := uvMap[v.ReportId]
  182. pvMap[v.ReportId] = v.PvTotal + pv
  183. uvMap[v.ReportId] = v.UvTotal + uv
  184. }
  185. }
  186. //reportIds := strings.Join(reportIdArr, ",")
  187. //syncReportIds := strings.Join(syncReportIdArr, ",")
  188. // 查询同步过来的报告对应的老报告PV+UV
  189. if len(syncReportIdArr) > 0 {
  190. puvList, e := models.GetPUVByResearchReportIds(syncReportIdArr)
  191. if e != nil {
  192. br.Msg = "获取失败"
  193. br.ErrMsg = "获取同步报告对应的PV、UV失败, Err: " + e.Error()
  194. return
  195. }
  196. puvLen := len(puvList)
  197. for i := 0; i < puvLen; i++ {
  198. newReportId, ok := oldAndNewReportIdMap[puvList[i].ResearchReportId]
  199. if ok {
  200. pv := pvMap[newReportId]
  201. uv := uvMap[newReportId]
  202. pvMap[newReportId] = puvList[i].Pv + pv
  203. uvMap[newReportId] = puvList[i].Uv + uv
  204. }
  205. }
  206. }
  207. // 晨周报音频列表
  208. videoList, err := models.GetReportChapterVideoListByReportIds(reportIdArr)
  209. if err != nil {
  210. br.Msg = "获取失败"
  211. br.ErrMsg = "获取报告音频文件失败,Err:" + err.Error()
  212. return
  213. }
  214. for i := 0; i < listLen; i++ {
  215. list[i].Content = html.UnescapeString(list[i].Content)
  216. list[i].ContentSub = html.UnescapeString(list[i].ContentSub)
  217. // 除周报外其余报告均可推送客群
  218. list[i].NeedThsMsg = 1
  219. //if list[i].HasChapter == 1 && list[i].ChapterType == utils.REPORT_TYPE_WEEK {
  220. // list[i].NeedThsMsg = 0
  221. //}
  222. chapterList := make([]*models.ReportChapterVideoList, 0)
  223. for ii := 0; ii < len(videoList); ii++ {
  224. if list[i].Id == videoList[ii].ReportId {
  225. chapterList = append(chapterList, videoList[ii])
  226. }
  227. }
  228. list[i].ChapterVideoList = chapterList
  229. list[i].Pv += pvMap[list[i].Id]
  230. list[i].Uv += uvMap[list[i].Id]
  231. }
  232. }
  233. for _, item := range list {
  234. /*key := fmt.Sprint(`crm:report:edit:`, item.Id)
  235. opUserId, _ := utils.Rc.RedisInt(key)
  236. //如果当前没有人操作,获取当前操作人是本人,那么编辑按钮可用
  237. if opUserId <= 0 || (opUserId == this.SysUser.AdminId) || item.ClassifyNameFirst == "周报" || item.ClassifyNameFirst == "晨报" {
  238. item.CanEdit = true
  239. } else {
  240. adminInfo, errAdmin := system.GetSysUserById(opUserId)
  241. if errAdmin != nil {
  242. br.Msg = "获取失败"
  243. br.ErrMsg = "获取失败,Err:" + errAdmin.Error()
  244. return
  245. }
  246. item.Editor = adminInfo.RealName
  247. }*/
  248. if item.HasChapter == 1 {
  249. item.CanEdit = true
  250. continue
  251. }
  252. markStatus, err := services.UpdateReportEditMark(item.Id, 0, this.SysUser.AdminId, 2, this.SysUser.RealName, this.Lang)
  253. if err != nil {
  254. br.Msg = "查询标记状态失败"
  255. br.ErrMsg = "查询标记状态失败,Err:" + err.Error()
  256. return
  257. }
  258. if markStatus.Status == 0 {
  259. item.CanEdit = true
  260. } else {
  261. item.Editor = markStatus.Editor
  262. }
  263. }
  264. page := paging.GetPaging(currentIndex, pageSize, total)
  265. resp := new(models.ReportListResp)
  266. resp.Paging = page
  267. resp.List = list
  268. br.Ret = 200
  269. br.Success = true
  270. br.Msg = "获取成功"
  271. br.Data = resp
  272. }
  273. // Add
  274. // @Title 新增报告接口
  275. // @Description 新增报告(不区分报告类型)
  276. // @Param request body models.AddReq true "type json string"
  277. // @Success 200 {object} models.AddResp
  278. // @router /add [post]
  279. func (this *ReportController) Add() {
  280. br := new(models.BaseResponse).Init()
  281. defer func() {
  282. this.Data["json"] = br
  283. this.ServeJSON()
  284. }()
  285. sysUser := this.SysUser
  286. if sysUser == nil {
  287. br.Msg = "请登录"
  288. br.ErrMsg = "请登录,SysUser Is Empty"
  289. br.Ret = 408
  290. return
  291. }
  292. var req models.AddReq
  293. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  294. if err != nil {
  295. br.Msg = "参数解析异常!"
  296. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  297. return
  298. }
  299. if req.Title == `` {
  300. br.Msg = "标题不能为空"
  301. br.ErrMsg = "标题不能为空"
  302. br.IsSendEmail = false
  303. return
  304. }
  305. if req.ClassifyIdFirst <= 0 {
  306. br.Msg = "分类必填"
  307. br.ErrMsg = "分类必填"
  308. br.IsSendEmail = false
  309. return
  310. }
  311. var contentSub string
  312. if req.Content != "" {
  313. e := utils.ContentXssCheck(req.Content)
  314. if e != nil {
  315. br.Msg = "存在非法标签"
  316. br.ErrMsg = "存在非法标签, Err: " + e.Error()
  317. return
  318. }
  319. content, e := services.FilterReportContentBr(req.Content)
  320. if e != nil {
  321. br.Msg = "内容去除前后空格失败"
  322. br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error()
  323. return
  324. }
  325. req.Content = content
  326. contentSub, err = services.GetReportContentSub(req.Content)
  327. if err != nil {
  328. go alarm_msg.SendAlarmMsg("ContentSub 失败,Err:"+err.Error(), 3)
  329. //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers)
  330. }
  331. }
  332. // 报告期数
  333. maxStage, err := models.GetReportStage(req.ClassifyIdFirst, req.ClassifyIdSecond, req.ClassifyIdThird)
  334. if err != nil {
  335. br.Msg = "期数获取失败!"
  336. br.ErrMsg = "期数获取失败,Err:" + err.Error()
  337. return
  338. }
  339. // 根据审批开关及审批流判断当前报告状态
  340. state, e := services.CheckReportCurrState(report_approve.FlowReportTypeChinese, req.ClassifyIdFirst, req.ClassifyIdSecond, req.ClassifyIdThird, models.ReportOperateAdd)
  341. if e != nil {
  342. br.Msg = "操作失败"
  343. br.ErrMsg = "校验报告当前状态失败, Err: " + e.Error()
  344. return
  345. }
  346. // 协作方式,1:个人,2:多人协作。默认:1
  347. if req.CollaborateType == 0 {
  348. req.CollaborateType = 1
  349. }
  350. // 报告布局,1:常规布局,2:智能布局。默认:1
  351. if req.ReportLayout == 0 {
  352. req.ReportLayout = 1
  353. }
  354. // 是否公开发布,1:是,2:否
  355. if req.IsPublicPublish == 0 {
  356. req.IsPublicPublish = 1
  357. }
  358. item := new(models.Report)
  359. item.AddType = req.AddType
  360. item.ReportVersion = 2
  361. item.ClassifyIdFirst = req.ClassifyIdFirst
  362. item.ClassifyNameFirst = req.ClassifyNameFirst
  363. item.ClassifyIdSecond = req.ClassifyIdSecond
  364. item.ClassifyNameSecond = req.ClassifyNameSecond
  365. item.Title = req.Title
  366. item.Abstract = req.Abstract
  367. item.Author = req.Author
  368. item.Frequency = req.Frequency
  369. item.State = state
  370. item.Content = html.EscapeString(req.Content)
  371. item.Stage = maxStage + 1
  372. item.ContentSub = html.EscapeString(contentSub)
  373. item.CreateTime = req.CreateTime
  374. item.ModifyTime = time.Now()
  375. item.ReportVersion = req.ReportVersion
  376. item.AdminId = sysUser.AdminId
  377. item.AdminRealName = sysUser.RealName
  378. item.ClassifyIdThird = req.ClassifyIdThird
  379. item.ClassifyNameThird = req.ClassifyNameThird
  380. // 产品要求,如果是多人协作,那么就是章节类型的报告
  381. if req.CollaborateType == 2 {
  382. item.HasChapter = 1
  383. item.ChapterType = ""
  384. }
  385. item.LastModifyAdminId = sysUser.AdminId
  386. item.LastModifyAdminName = sysUser.RealName
  387. item.ContentModifyTime = time.Now()
  388. item.NeedSplice = 1
  389. item.ContentStruct = html.EscapeString(req.ContentStruct)
  390. item.HeadImg = req.HeadImg
  391. item.EndImg = req.EndImg
  392. item.CanvasColor = req.CanvasColor
  393. item.HeadResourceId = req.HeadResourceId
  394. item.EndResourceId = req.EndResourceId
  395. item.CollaborateType = req.CollaborateType
  396. item.ReportLayout = req.ReportLayout
  397. item.IsPublicPublish = req.IsPublicPublish
  398. item.ReportCreateTime = time.Now()
  399. err, errMsg := services.AddReportAndChapter(item, req.InheritReportId, req.GrantAdminIdList)
  400. if err != nil {
  401. br.Msg = "保存失败"
  402. if errMsg != "" {
  403. br.Msg = errMsg
  404. }
  405. br.ErrMsg = "保存失败,Err:" + err.Error()
  406. return
  407. }
  408. recordItem := &models.ReportStateRecord{
  409. ReportId: item.Id,
  410. ReportType: 1,
  411. State: 1,
  412. AdminId: this.SysUser.AdminId,
  413. AdminName: this.SysUser.AdminName,
  414. CreateTime: time.Now(),
  415. }
  416. go func() {
  417. _, _ = models.AddReportStateRecord(recordItem)
  418. }()
  419. resp := new(models.AddResp)
  420. resp.ReportId = int64(item.Id)
  421. resp.ReportCode = item.ReportCode
  422. br.Ret = 200
  423. br.Success = true
  424. br.Msg = "保存成功"
  425. br.Data = resp
  426. }
  427. // Edit
  428. // @Title 编辑报告基础信息接口
  429. // @Description 编辑报告基础信息(不区分报告类型)
  430. // @Param request body models.EditReq true "type json string"
  431. // @Success 200 {object} models.EditResp
  432. // @router /edit [post]
  433. func (this *ReportController) Edit() {
  434. br := new(models.BaseResponse).Init()
  435. defer func() {
  436. this.Data["json"] = br
  437. this.ServeJSON()
  438. }()
  439. sysUser := this.SysUser
  440. if sysUser == nil {
  441. br.Msg = "请登录"
  442. br.ErrMsg = "请登录,SysUser Is Empty"
  443. br.Ret = 408
  444. return
  445. }
  446. var req models.EditReq
  447. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  448. if err != nil {
  449. br.Msg = "参数解析异常!"
  450. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  451. return
  452. }
  453. //if req.Content == "" {
  454. // br.Msg = "报告内容不能为空"
  455. // return
  456. //}
  457. //更新标记key
  458. markStatus, err := services.UpdateReportEditMark(int(req.ReportId), 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang)
  459. if err != nil {
  460. br.Msg = err.Error()
  461. return
  462. }
  463. if markStatus.Status == 1 {
  464. br.Msg = markStatus.Msg
  465. //br.Ret = 202 //202 服务器已接受请求,但尚未处理。
  466. return
  467. }
  468. reportInfo, e := models.GetReportByReportId(int(req.ReportId))
  469. if e != nil {
  470. if e.Error() == utils.ErrNoRow() {
  471. br.Msg = "报告已被删除, 请刷新页面"
  472. return
  473. }
  474. br.Msg = "操作失败"
  475. br.ErrMsg = "获取报告失败, Err: " + e.Error()
  476. return
  477. }
  478. if reportInfo.State == models.ReportStatePublished || reportInfo.State == models.ReportStatePass {
  479. br.Msg = "该报告已发布,不允许编辑"
  480. br.ErrMsg = "该报告已发布,不允许编辑"
  481. return
  482. }
  483. // 编辑报告信息
  484. err, errMsg := services.EditReport(reportInfo, req, sysUser)
  485. if err != nil {
  486. br.Msg = "保存失败"
  487. if errMsg != "" {
  488. br.Msg = errMsg
  489. }
  490. br.ErrMsg = "保存失败,Err:" + err.Error()
  491. return
  492. }
  493. reportCode := utils.MD5(strconv.Itoa(int(req.ReportId)))
  494. resp := new(models.EditResp)
  495. resp.ReportId = req.ReportId
  496. resp.ReportCode = reportCode
  497. br.Ret = 200
  498. br.Success = true
  499. br.Msg = "保存成功"
  500. br.Data = resp
  501. }
  502. // Detail
  503. // @Title 获取报告详情接口
  504. // @Description 获取报告详情
  505. // @Param request body models.ReportDetailReq true "type json string"
  506. // @Success 200 {object} models.Report
  507. // @router /detail [get]
  508. func (this *ReportController) Detail() {
  509. br := new(models.BaseResponse).Init()
  510. defer func() {
  511. this.Data["json"] = br
  512. this.ServeJSON()
  513. }()
  514. /*var req models.ReportDetailReq
  515. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  516. if err != nil {
  517. br.Msg = "参数解析异常!"
  518. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  519. return
  520. }
  521. if req.ReportId <= 0 {
  522. br.Msg = "参数错误"
  523. return
  524. }*/
  525. reportId, err := this.GetInt("ReportId")
  526. if err != nil {
  527. br.Msg = "获取参数失败!"
  528. br.ErrMsg = "获取参数失败,Err:" + err.Error()
  529. return
  530. }
  531. if reportId <= 0 {
  532. br.Msg = "参数错误"
  533. return
  534. }
  535. item, err := models.GetReportById(reportId)
  536. if err != nil {
  537. if err.Error() == utils.ErrNoRow() {
  538. br.Msg = "报告已被删除"
  539. return
  540. }
  541. br.Msg = "获取失败"
  542. br.ErrMsg = "获取失败,Err:" + err.Error()
  543. return
  544. }
  545. chapterList := make([]*models.ReportChapter, 0)
  546. if item.HasChapter == 1 {
  547. // 获取章节内容
  548. tmpChapterList, err := models.GetPublishedChapterListByReportId(item.Id)
  549. if err != nil {
  550. br.Msg = "获取失败"
  551. br.ErrMsg = "获取晨/周报章节列表失败, Err: " + err.Error()
  552. return
  553. }
  554. if len(tmpChapterList) > 0 {
  555. // 章节类型的字段赋值
  556. for _, item := range tmpChapterList {
  557. item.Content = html.UnescapeString(item.Content)
  558. item.ContentSub = html.UnescapeString(item.ContentSub)
  559. chapterList = append(chapterList, item)
  560. }
  561. }
  562. //item.Abstract = item.Title
  563. }
  564. item.Content = html.UnescapeString(item.Content)
  565. item.ContentSub = html.UnescapeString(item.ContentSub)
  566. item.ContentStruct = html.UnescapeString(item.ContentStruct)
  567. resp := &models.ReportDetailView{
  568. ReportDetail: item,
  569. ChapterList: chapterList,
  570. }
  571. br.Ret = 200
  572. br.Success = true
  573. br.Msg = "获取成功"
  574. br.Data = resp
  575. }
  576. // SaveReportContent
  577. // @Title 保存草稿
  578. // @Description 保存草稿
  579. // @Param request body models.SaveReportContent true "type json string"
  580. // @Success 200 {object} models.ReportAuthorResp
  581. // @router /saveReportContent [post]
  582. func (this *ReportController) SaveReportContent() {
  583. br := new(models.BaseResponse).Init()
  584. br.IsSendEmail = false
  585. defer func() {
  586. this.Data["json"] = br
  587. this.ServeJSON()
  588. }()
  589. sysUser := this.SysUser
  590. if sysUser == nil {
  591. br.Msg = "请登录"
  592. br.ErrMsg = "请登录,SysUser Is Empty"
  593. br.Ret = 408
  594. return
  595. }
  596. var req models.SaveReportContent
  597. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  598. if err != nil {
  599. br.Msg = "参数解析异常!"
  600. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  601. return
  602. }
  603. reportId := req.ReportId
  604. noChangeFlag := req.NoChange
  605. if reportId <= 0 {
  606. resp := new(models.SaveReportContentResp)
  607. resp.ReportId = reportId
  608. br.Ret = 200
  609. br.Success = true
  610. br.Msg = "保存成功"
  611. br.Data = resp
  612. return
  613. }
  614. // 获取报告详情
  615. reportInfo, _ := models.GetReportByReportId(int(req.ReportId))
  616. if reportInfo != nil && reportInfo.State == 2 {
  617. br.Msg = "该报告已发布,不允许编辑"
  618. br.ErrMsg = "该报告已发布,不允许编辑"
  619. return
  620. }
  621. // 标记更新中
  622. {
  623. markStatus, err := services.UpdateReportEditMark(int(req.ReportId), 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang)
  624. if err != nil {
  625. br.Msg = err.Error()
  626. return
  627. }
  628. if markStatus.Status == 1 {
  629. br.Msg = markStatus.Msg
  630. return
  631. }
  632. }
  633. // 内容有过修改的话,那么逻辑处理
  634. if noChangeFlag != 1 {
  635. content := req.Content
  636. if content == "" {
  637. content = this.GetString("Content")
  638. }
  639. if content != "" {
  640. e := utils.ContentXssCheck(req.Content)
  641. if e != nil {
  642. br.Msg = "存在非法标签"
  643. br.ErrMsg = "存在非法标签, Err: " + e.Error()
  644. return
  645. }
  646. contentClean, e := services.FilterReportContentBr(req.Content)
  647. if e != nil {
  648. br.Msg = "内容去除前后空格失败"
  649. br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error()
  650. return
  651. }
  652. content = contentClean
  653. contentSub, err := services.GetReportContentSub(content)
  654. if err != nil {
  655. go alarm_msg.SendAlarmMsg("解析 ContentSub 失败,Err:"+err.Error(), 3)
  656. //utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败,Err:"+err.Error(), utils.EmailSendToUsers)
  657. }
  658. reportInfo.Content = html.EscapeString(content)
  659. reportInfo.ContentSub = html.EscapeString(contentSub)
  660. reportInfo.ContentStruct = html.EscapeString(req.ContentStruct)
  661. reportInfo.HeadImg = req.HeadImg
  662. reportInfo.EndImg = req.EndImg
  663. reportInfo.CanvasColor = req.CanvasColor
  664. reportInfo.HeadResourceId = req.HeadResourceId
  665. reportInfo.EndResourceId = req.EndResourceId
  666. reportInfo.ModifyTime = time.Now()
  667. reportInfo.ContentModifyTime = time.Now()
  668. updateCols := []string{"Content", "ContentSub", "ContentStruct", "HeadImg", "EndImg", "CanvasColor", "HeadResourceId", "EndResourceId", "ModifyTime", "ContentModifyTime"}
  669. err = reportInfo.UpdateReport(updateCols)
  670. if err != nil {
  671. br.Msg = "保存失败"
  672. br.ErrMsg = "保存失败,Err:" + err.Error()
  673. return
  674. }
  675. go models.AddReportSaveLog(reportId, this.SysUser.AdminId, reportInfo.Content, reportInfo.ContentSub, reportInfo.ContentStruct, reportInfo.CanvasColor, this.SysUser.AdminName, reportInfo.HeadResourceId, reportInfo.EndResourceId)
  676. }
  677. }
  678. resp := new(models.SaveReportContentResp)
  679. resp.ReportId = reportId
  680. br.Ret = 200
  681. br.Success = true
  682. br.Msg = "保存成功"
  683. br.Data = resp
  684. }
  685. // AuthorizedListReport
  686. // @Title 获取有权限的报告列表接口
  687. // @Description 获取有权限的报告列表接口
  688. // @Param PageSize query int true "每页数据条数"
  689. // @Param CurrentIndex query int true "当前页页码,从1开始"
  690. // @Param Keyword query string true "搜索关键词"
  691. // @Param ClassifyIdFirst query int true "一级分类id"
  692. // @Param ClassifyIdSecond query int true "二级分类id"
  693. // @Param ClassifyIdThird query int true "三级分类id"
  694. // @Success 200 {object} models.ReportListResp
  695. // @router /list/authorized [get]
  696. func (this *ReportController) AuthorizedListReport() {
  697. br := new(models.BaseResponse).Init()
  698. defer func() {
  699. this.Data["json"] = br
  700. this.ServeJSON()
  701. }()
  702. pageSize, _ := this.GetInt("PageSize")
  703. currentIndex, _ := this.GetInt("CurrentIndex")
  704. keyword := this.GetString("Keyword")
  705. classifyIdFirst, _ := this.GetInt("ClassifyIdFirst", 0)
  706. classifyIdSecond, _ := this.GetInt("ClassifyIdSecond", 0)
  707. classifyIdThird, _ := this.GetInt("ClassifyIdThird", 0)
  708. var startSize int
  709. if pageSize <= 0 {
  710. pageSize = utils.PageSize20
  711. }
  712. if currentIndex <= 0 {
  713. currentIndex = 1
  714. }
  715. startSize = utils.StartIndex(currentIndex, pageSize)
  716. var list []*models.ReportList
  717. // 没有输入信息,那就不展示
  718. if keyword == `` && classifyIdFirst <= 0 {
  719. page := paging.GetPaging(currentIndex, pageSize, 0)
  720. resp := new(models.ReportListResp)
  721. resp.Paging = page
  722. resp.List = list
  723. br.Ret = 200
  724. br.Success = true
  725. br.Msg = "获取成功"
  726. br.Data = resp
  727. return
  728. }
  729. // 当前用户有权限的报告id列表
  730. grantReportIdList := make([]int, 0)
  731. {
  732. obj := report.ReportGrant{}
  733. grantList, err := obj.GetGrantListByAdminId(this.SysUser.AdminId)
  734. if err != nil {
  735. br.Msg = "获取失败"
  736. br.ErrMsg = "获取授权报告id失败,Err:" + err.Error()
  737. return
  738. }
  739. for _, v := range grantList {
  740. grantReportIdList = append(grantReportIdList, v.ReportId)
  741. }
  742. }
  743. var condition string
  744. var pars []interface{}
  745. if classifyIdFirst > 0 {
  746. condition += ` AND a.classify_id_first = ? `
  747. pars = append(pars, classifyIdFirst)
  748. }
  749. if classifyIdSecond > 0 {
  750. condition += ` AND a.classify_id_second = ? `
  751. pars = append(pars, classifyIdSecond)
  752. }
  753. if classifyIdThird > 0 {
  754. condition += ` AND a.classify_id_third = ? `
  755. pars = append(pars, classifyIdSecond)
  756. }
  757. if keyword != `` {
  758. condition += ` AND a.title LIKE ? `
  759. pars = utils.GetLikeKeywordPars(pars, keyword, 1)
  760. }
  761. var err error
  762. var total int
  763. orCondition := `AND ( (a.is_public_publish = ? AND a.state in (2,6)) or a.admin_id = ? `
  764. pars = append(pars, 1, this.SysUser.AdminId)
  765. // 当前用户有权限的报告id列表
  766. num := len(grantReportIdList)
  767. if num > 0 {
  768. orCondition += ` OR a.id in (` + utils.GetOrmInReplace(num) + `)`
  769. pars = append(pars, grantReportIdList)
  770. }
  771. orCondition += ` ) `
  772. condition += orCondition
  773. total, err = models.GetReportListCountByAuthorized(condition, pars)
  774. if err != nil {
  775. br.Msg = "获取失败"
  776. br.ErrMsg = "获取失败,Err:" + err.Error()
  777. return
  778. }
  779. list, err = models.GetReportListByAuthorized(condition, pars, startSize, pageSize)
  780. if err != nil {
  781. br.Msg = "获取失败"
  782. br.ErrMsg = "获取失败,Err:" + err.Error()
  783. return
  784. }
  785. //for _, item := range list {
  786. // if item.HasChapter == 1 {
  787. // item.CanEdit = true
  788. // } else {
  789. // markStatus, err := services.UpdateReportEditMark(item.Id, this.SysUser.AdminId, 2, this.SysUser.RealName, this.Lang)
  790. // if err != nil {
  791. // br.Msg = "查询标记状态失败"
  792. // br.ErrMsg = "查询标记状态失败,Err:" + err.Error()
  793. // return
  794. // }
  795. // if markStatus.Status == 0 {
  796. // item.CanEdit = true
  797. // } else {
  798. // item.Editor = markStatus.Editor
  799. // }
  800. // }
  801. //}
  802. page := paging.GetPaging(currentIndex, pageSize, total)
  803. resp := new(models.ReportListResp)
  804. resp.Paging = page
  805. resp.List = list
  806. br.Ret = 200
  807. br.Success = true
  808. br.Msg = "获取成功"
  809. br.Data = resp
  810. }
  811. // BaseDetail
  812. // @Title 获取报告基础信息详情接口
  813. // @Description 获取报告基础信息详情接口
  814. // @Param request body models.ReportDetailReq true "type json string"
  815. // @Success 200 {object} models.Report
  816. // @router /detail/base [get]
  817. func (this *ReportController) BaseDetail() {
  818. br := new(models.BaseResponse).Init()
  819. defer func() {
  820. this.Data["json"] = br
  821. this.ServeJSON()
  822. }()
  823. /*var req models.ReportDetailReq
  824. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  825. if err != nil {
  826. br.Msg = "参数解析异常!"
  827. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  828. return
  829. }
  830. if req.ReportId <= 0 {
  831. br.Msg = "参数错误"
  832. return
  833. }*/
  834. reportId, err := this.GetInt("ReportId")
  835. if err != nil {
  836. br.Msg = "获取参数失败!"
  837. br.ErrMsg = "获取参数失败,Err:" + err.Error()
  838. return
  839. }
  840. if reportId <= 0 {
  841. br.Msg = "参数错误"
  842. return
  843. }
  844. reportInfo, err := models.GetReportById(reportId)
  845. if err != nil {
  846. if err.Error() == utils.ErrNoRow() {
  847. br.Msg = "报告已被删除"
  848. return
  849. }
  850. br.Msg = "获取失败"
  851. br.ErrMsg = "获取失败,Err:" + err.Error()
  852. return
  853. }
  854. // 基础信息就不获取章节信息了
  855. chapterList := make([]*models.ReportChapter, 0)
  856. reportInfo.Content = html.UnescapeString(reportInfo.Content)
  857. reportInfo.ContentSub = html.UnescapeString(reportInfo.ContentSub)
  858. grandAdminList := make([]models.ReportDetailViewAdmin, 0)
  859. permissionList := make([]models.ReportDetailViewPermission, 0)
  860. // 处理报告授权用户列表
  861. {
  862. obj := report.ReportGrant{}
  863. grantList, tmpErr := obj.GetGrantListById(reportId)
  864. if tmpErr != nil {
  865. br.Msg = "获取章节id授权用户列表失败"
  866. br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error()
  867. return
  868. }
  869. if len(grantList) > 0 {
  870. grandAdminIdList := make([]int, 0)
  871. for _, v := range grantList {
  872. grandAdminIdList = append(grandAdminIdList, v.AdminId)
  873. }
  874. adminList, tmpErr := system.GetAdminListByIdList(grandAdminIdList)
  875. if tmpErr != nil {
  876. br.Msg = "获取章节id授权用户列表失败"
  877. br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error()
  878. return
  879. }
  880. for _, v := range adminList {
  881. grandAdminList = append(grandAdminList, models.ReportDetailViewAdmin{
  882. AdminId: v.AdminId,
  883. AdminName: v.RealName,
  884. })
  885. }
  886. }
  887. }
  888. // 处理章节id关联品种id列表
  889. {
  890. minClassifyId := reportInfo.ClassifyIdThird
  891. if minClassifyId <= 0 {
  892. minClassifyId = reportInfo.ClassifyIdSecond
  893. }
  894. if minClassifyId <= 0 {
  895. minClassifyId = reportInfo.ClassifyIdFirst
  896. }
  897. if minClassifyId <= 0 {
  898. br.Msg = "分类异常"
  899. br.ErrMsg = "分类异常"
  900. return
  901. }
  902. // 获取分类关联的品种id
  903. classifyPermissionList, tmpErr := models.GetPermission(minClassifyId)
  904. if tmpErr != nil {
  905. br.Msg = "获取分类信息失败"
  906. br.ErrMsg = "获取失败,Err:" + tmpErr.Error()
  907. return
  908. }
  909. if len(classifyPermissionList) > 0 {
  910. permissionIdList := make([]int, 0)
  911. for _, v := range classifyPermissionList {
  912. permissionIdList = append(permissionIdList, v.ChartPermissionId)
  913. }
  914. adminList, tmpErr := models.GetChartPermissionByIdList(permissionIdList)
  915. if tmpErr != nil {
  916. br.Msg = "获取章节id授权用户列表失败"
  917. br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error()
  918. return
  919. }
  920. for _, v := range adminList {
  921. permissionList = append(permissionList, models.ReportDetailViewPermission{
  922. PermissionId: v.ChartPermissionId,
  923. PermissionName: v.ChartPermissionName,
  924. })
  925. }
  926. }
  927. }
  928. resp := &models.ReportDetailView{
  929. ReportDetail: reportInfo,
  930. ChapterList: chapterList,
  931. GrandAdminList: grandAdminList,
  932. PermissionList: permissionList,
  933. }
  934. br.Ret = 200
  935. br.Success = true
  936. br.Msg = "获取成功"
  937. br.Data = resp
  938. }
  939. // EditLayoutImg
  940. // @Title 版图设置接口
  941. // @Description 版图设置接口
  942. // @Param request body models.EditLayoutImgReq true "type json string"
  943. // @Success 200 {object} models.EditResp
  944. // @router /layout_img/edit [post]
  945. func (this *ReportController) EditLayoutImg() {
  946. br := new(models.BaseResponse).Init()
  947. defer func() {
  948. this.Data["json"] = br
  949. this.ServeJSON()
  950. }()
  951. sysUser := this.SysUser
  952. if sysUser == nil {
  953. br.Msg = "请登录"
  954. br.ErrMsg = "请登录,SysUser Is Empty"
  955. br.Ret = 408
  956. return
  957. }
  958. var req models.EditLayoutImgReq
  959. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  960. if err != nil {
  961. br.Msg = "参数解析异常!"
  962. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  963. return
  964. }
  965. //if req.Content == "" {
  966. // br.Msg = "报告内容不能为空"
  967. // return
  968. //}
  969. //更新标记key
  970. markStatus, err := services.UpdateReportEditMark(int(req.ReportId), 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang)
  971. if err != nil {
  972. br.Msg = err.Error()
  973. return
  974. }
  975. if markStatus.Status == 1 {
  976. br.Msg = markStatus.Msg
  977. //br.Ret = 202 //202 服务器已接受请求,但尚未处理。
  978. return
  979. }
  980. reportInfo, e := models.GetReportByReportId(int(req.ReportId))
  981. if e != nil {
  982. if e.Error() == utils.ErrNoRow() {
  983. br.Msg = "报告已被删除, 请刷新页面"
  984. return
  985. }
  986. br.Msg = "操作失败"
  987. br.ErrMsg = "获取报告失败, Err: " + e.Error()
  988. return
  989. }
  990. if reportInfo.State == models.ReportStatePublished || reportInfo.State == models.ReportStatePass {
  991. br.Msg = "该报告已发布,不允许编辑"
  992. br.ErrMsg = "该报告已发布,不允许编辑"
  993. return
  994. }
  995. // 编辑报告信息
  996. err, errMsg := services.EditReportLayoutImg(reportInfo, req, sysUser)
  997. if err != nil {
  998. br.Msg = "保存失败"
  999. if errMsg != "" {
  1000. br.Msg = errMsg
  1001. }
  1002. br.ErrMsg = "保存失败,Err:" + err.Error()
  1003. return
  1004. }
  1005. reportCode := utils.MD5(strconv.Itoa(int(req.ReportId)))
  1006. resp := new(models.EditResp)
  1007. resp.ReportId = req.ReportId
  1008. resp.ReportCode = reportCode
  1009. br.Ret = 200
  1010. br.Success = true
  1011. br.Msg = "保存成功"
  1012. br.Data = resp
  1013. }
  1014. // TODO 报告发布后,图片和pdf的生成