report.go 86 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911
  1. package services
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/company"
  7. "eta/eta_api/models/report"
  8. "eta/eta_api/models/system"
  9. "eta/eta_api/services/alarm_msg"
  10. "eta/eta_api/services/public_api"
  11. "eta/eta_api/utils"
  12. "fmt"
  13. "github.com/PuerkitoBio/goquery"
  14. "html"
  15. "os"
  16. "regexp"
  17. "strconv"
  18. "strings"
  19. "time"
  20. )
  21. func GetReportContentSub(content string) (contentSub string, err error) {
  22. content = html.UnescapeString(content)
  23. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  24. if err != nil {
  25. fmt.Println("create doc err:", err.Error())
  26. return
  27. }
  28. n := 0
  29. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  30. if n >= 5 {
  31. return
  32. }
  33. n++
  34. phtml, err := s.Html()
  35. if err != nil {
  36. fmt.Println("get html err", err.Error())
  37. return
  38. }
  39. if s.Text() != "" || strings.Contains(phtml, "src") {
  40. contentSub = contentSub + "<p>" + phtml + "</p>"
  41. }
  42. })
  43. return
  44. }
  45. // PublishDayWeekReport 发布晨周报
  46. func PublishDayWeekReport(reportId int) (tips string, err error) {
  47. report, err := models.GetReportByReportId(reportId)
  48. if err != nil {
  49. return
  50. }
  51. if report.State == 2 {
  52. return
  53. }
  54. chapters, err := models.GetChapterListByReportId(reportId)
  55. if err != nil {
  56. return
  57. }
  58. chapterLen := len(chapters)
  59. if chapterLen <= 0 {
  60. err = errors.New("报告章节为空,不可发布")
  61. return
  62. }
  63. reportType := chapters[0].ReportType
  64. // 校验章节
  65. publishReport, tips, publishIdArr, unPublishIdArr, err := checkDayWeekChapterWrite(chapters, reportType)
  66. if err != nil {
  67. return
  68. }
  69. publishLen := len(publishIdArr)
  70. if publishLen <= 0 {
  71. err = errors.New("报告章节均不可发布")
  72. return
  73. }
  74. // 需发布整期
  75. updateCols := make([]string, 0)
  76. if publishReport {
  77. updateCols = append(updateCols, "Title", "State", "ModifyTime")
  78. // 发布后标题调整
  79. title := report.Title
  80. title = strings.ReplaceAll(title, "【弘则FICC晨报】", "")
  81. title = strings.ReplaceAll(title, "【弘则FICC周报】", "")
  82. if title == "" {
  83. // 取第一个需发布章节的标题
  84. firstId := publishIdArr[0]
  85. firstTitle := ""
  86. for i := 0; i < chapterLen; i++ {
  87. if chapters[i].ReportChapterId == firstId {
  88. firstTitle = chapters[i].Title
  89. break
  90. }
  91. }
  92. title = firstTitle
  93. }
  94. report.Title = title
  95. report.State = 2
  96. // 研报后台4.4 只在没有发布过时更新发布时间,其余均按模版消息发送时间当作发布时间
  97. if report.MsgIsSend == 0 || report.PublishTime.IsZero() {
  98. report.PublishTime = time.Now().Local()
  99. updateCols = append(updateCols, "PublishTime")
  100. }
  101. report.ModifyTime = time.Now().Local()
  102. }
  103. publishIdStr := utils.IntArr2joinString(publishIdArr, ",")
  104. //unPublishIdStr := utils.IntArr2joinString(unPublishIdArr, ",")
  105. if e := models.PublishReportAndChapter(report, publishIdArr, unPublishIdArr, publishReport, updateCols); e != nil {
  106. err = errors.New("发布报告及章节失败")
  107. return
  108. }
  109. // 生成章节音频
  110. go func() {
  111. _ = UpdateChaptersVideo(publishIdStr)
  112. }()
  113. // 更新报告ES
  114. go func() {
  115. _ = UpdateReportEs(report.Id, 2)
  116. }()
  117. // 发布时备份内容
  118. go SaveReportLogs(report, chapters, report.AdminId, report.AdminRealName)
  119. return
  120. }
  121. // UpdateChaptersVideo 更新章节音频
  122. func UpdateChaptersVideo(chapterIds string) (err error) {
  123. defer func() {
  124. if err != nil {
  125. utils.FileLog.Error("UpdateChaptersVideo, chapterIds:%s, Err:%s", chapterIds, err.Error())
  126. go alarm_msg.SendAlarmMsg("更新章节音频失败, 章节ID: "+chapterIds+", Err: "+err.Error(), 3)
  127. }
  128. }()
  129. if chapterIds == "" {
  130. return
  131. }
  132. ids := make([]int, 0)
  133. chapterIdArr := strings.Split(chapterIds, ",")
  134. for _, v := range chapterIdArr {
  135. id, e := strconv.Atoi(v)
  136. if e != nil {
  137. return
  138. }
  139. ids = append(ids, id)
  140. }
  141. chapterList, err := models.GetChapterListByChapterIds(ids)
  142. if err != nil {
  143. return
  144. }
  145. // 生成video
  146. nowTime := time.Now()
  147. updateCols := make([]string, 0)
  148. updateCols = append(updateCols, "VideoUrl", "VideoName", "VideoSize", "VideoPlaySeconds")
  149. for i := 0; i < len(chapterList); i++ {
  150. item := chapterList[i]
  151. // 忽略已有音频的章节
  152. if item.VideoUrl != "" && item.VideoName != "" && item.VideoSize != "" && item.VideoPlaySeconds != "" {
  153. continue
  154. }
  155. videoUrl, videoName, videoSize, videoPlaySeconds, e := CreateReportVideo(item.Title, html.UnescapeString(item.Content), nowTime.Format(utils.FormatDateTime))
  156. if e != nil {
  157. err = e
  158. return
  159. }
  160. item.VideoUrl = videoUrl
  161. item.VideoName = videoName
  162. item.VideoSize = videoSize
  163. item.VideoPlaySeconds = fmt.Sprintf("%.2f", videoPlaySeconds)
  164. if e = item.UpdateChapter(updateCols); e != nil {
  165. err = e
  166. }
  167. }
  168. return
  169. }
  170. // PublishTodayDayReport 发布今日晨报
  171. func PublishTodayDayReport() (err error) {
  172. nowTime := time.Now()
  173. startTime := time.Date(nowTime.Year(), nowTime.Month(), nowTime.Day(), 0, 0, 0, 0, time.Local)
  174. endTime := time.Date(nowTime.Year(), nowTime.Month(), nowTime.Day(), 23, 59, 59, 0, time.Local)
  175. todayReport, err := models.GetUnPublishDayReport(startTime, endTime)
  176. if err != nil {
  177. if err.Error() == utils.ErrNoRow() { //如果是找不到待发送的晨报,那么需要将err置空
  178. err = nil
  179. }
  180. return
  181. }
  182. if todayReport != nil {
  183. if _, tmpErr := PublishDayWeekReport(todayReport.Id); tmpErr != nil {
  184. err = tmpErr
  185. return
  186. }
  187. // 定时发布的晨报自动推送客群
  188. reportDetail, tmpErr := models.GetReportById(todayReport.Id)
  189. if tmpErr != nil {
  190. err = tmpErr
  191. return
  192. }
  193. // 推送模板消息
  194. if tmpErr = SendMiniProgramReportWxMsg(todayReport.Id); tmpErr != nil {
  195. err = tmpErr
  196. return
  197. }
  198. if tmpErr = models.ModifyReportThsMsgIsSend(reportDetail); tmpErr != nil {
  199. err = tmpErr
  200. return
  201. }
  202. }
  203. return
  204. }
  205. func initp2_838 (){
  206. var condition string
  207. var pars []interface{}
  208. condition = " AND state = 2 "
  209. list ,err:= models.GetReportByCondition(condition,pars,[]string{},"",false,0,0)
  210. if err != nil{
  211. fmt.Println(err)
  212. }
  213. fmt.Println(len(list))
  214. for _,v:= range list{
  215. fmt.Println(v.Id)
  216. UpdateReportEs(v.Id,2)
  217. }
  218. }
  219. // UpdateReportEs 更新报告/章节Es
  220. func UpdateReportEs(reportId int, publishState int) (err error) {
  221. if reportId <= 0 {
  222. return
  223. }
  224. reportInfo, err := models.GetReportByReportId(reportId)
  225. if err != nil {
  226. return
  227. }
  228. categories := ""
  229. if reportInfo.HasChapter == 1 {
  230. // 晨周报
  231. chapterList, tmpErr := models.GetPublishedChapterListByReportId(reportInfo.Id)
  232. if tmpErr != nil {
  233. return
  234. }
  235. if len(chapterList) > 0 {
  236. for i := 0; i < len(chapterList); i++ {
  237. // 章节对应的品种
  238. permissionList, tmpErr := models.GetChapterTypePermissionByReportChapterTypeId(chapterList[i].TypeId)
  239. if tmpErr != nil {
  240. return
  241. }
  242. categoryArr := make([]string, 0)
  243. if len(permissionList) > 0 {
  244. for ii := 0; ii < len(permissionList); ii++ {
  245. categoryArr = append(categoryArr, permissionList[ii].PermissionName)
  246. }
  247. }
  248. aliasArr, _ := addCategoryAliasToArr(categoryArr)
  249. chapterCategories := strings.Join(aliasArr, ",")
  250. esChapter := &models.ElasticReportDetail{
  251. ReportId: chapterList[i].ReportId,
  252. ReportChapterId: chapterList[i].ReportChapterId,
  253. Title: chapterList[i].Title,
  254. Abstract: chapterList[i].Abstract,
  255. BodyContent: utils.TrimHtml(html.UnescapeString(chapterList[i].Content)),
  256. PublishTime: chapterList[i].PublishTime.Format(utils.FormatDateTime),
  257. PublishState: chapterList[i].PublishState,
  258. Author: chapterList[i].Author,
  259. ClassifyIdFirst: chapterList[i].ClassifyIdFirst,
  260. ClassifyNameFirst: chapterList[i].ClassifyNameFirst,
  261. ClassifyIdSecond: 0,
  262. ClassifyNameSecond: "",
  263. Categories: chapterCategories,
  264. StageStr: strconv.Itoa(chapterList[i].Stage),
  265. }
  266. chapterDocId := fmt.Sprintf("%d-%d", reportInfo.Id, chapterList[i].ReportChapterId)
  267. if err = EsAddOrEditReport(utils.EsReportIndexName, chapterDocId, esChapter); err != nil {
  268. return
  269. }
  270. }
  271. }
  272. } else {
  273. //if utils.BusinessCode == utils.BusinessCodeRelease || utils.BusinessCode == utils.BusinessCodeSandbox {
  274. permissionList, tmpErr := models.GetChartPermissionNameFromMappingByKeyword("rddp", reportInfo.ClassifyIdSecond)
  275. if tmpErr != nil {
  276. return
  277. }
  278. categoryArr := make([]string, 0)
  279. for i := 0; i < len(permissionList); i++ {
  280. categoryArr = append(categoryArr, permissionList[i].PermissionName)
  281. }
  282. aliasArr, _ := addCategoryAliasToArr(categoryArr)
  283. categories = strings.Join(aliasArr, ",")
  284. //}
  285. }
  286. // 新增报告ES
  287. esReport := &models.ElasticReportDetail{
  288. ReportId: reportInfo.Id,
  289. ReportChapterId: 0,
  290. Title: reportInfo.Title,
  291. Abstract: reportInfo.Abstract,
  292. BodyContent: utils.TrimHtml(html.UnescapeString(reportInfo.Content)),
  293. PublishTime: reportInfo.PublishTime.Format(utils.FormatDateTime),
  294. PublishState: publishState,
  295. Author: reportInfo.Author,
  296. ClassifyIdFirst: reportInfo.ClassifyIdFirst,
  297. ClassifyNameFirst: reportInfo.ClassifyNameFirst,
  298. ClassifyIdSecond: reportInfo.ClassifyIdSecond,
  299. ClassifyNameSecond: reportInfo.ClassifyNameSecond,
  300. Categories: categories,
  301. StageStr: strconv.Itoa(reportInfo.Stage),
  302. }
  303. docId := fmt.Sprintf("%d-%d", reportInfo.Id, 0)
  304. if err = EsAddOrEditReport(utils.EsReportIndexName, docId, esReport); err != nil {
  305. return
  306. }
  307. return
  308. }
  309. // addCategoryAliasToArr 品种别名
  310. func addCategoryAliasToArr(categoryArr []string) (aliasArr []string, err error) {
  311. aliasArr = categoryArr
  312. if len(categoryArr) > 0 {
  313. for i := 0; i < len(categoryArr); i++ {
  314. if strings.Contains(categoryArr[i], "沥青") {
  315. aliasArr = append(aliasArr, "BU")
  316. }
  317. if strings.Contains(categoryArr[i], "MEG") {
  318. aliasArr = append(aliasArr, "EG", "乙二醇")
  319. }
  320. if strings.Contains(categoryArr[i], "聚酯") {
  321. aliasArr = append(aliasArr, "长丝", "短纤", "瓶片")
  322. }
  323. if strings.Contains(categoryArr[i], "纯苯+苯乙烯") {
  324. aliasArr = append(aliasArr, "EB")
  325. }
  326. if strings.Contains(categoryArr[i], "聚乙烯") {
  327. aliasArr = append(aliasArr, "PP", "PE")
  328. }
  329. if strings.Contains(categoryArr[i], "玻璃纯碱") {
  330. aliasArr = append(aliasArr, "玻璃", "纯碱", "FG", "SA")
  331. }
  332. if strings.Contains(categoryArr[i], "甲醇") {
  333. aliasArr = append(aliasArr, "甲醇", "MA")
  334. }
  335. if strings.Contains(categoryArr[i], "橡胶") {
  336. aliasArr = append(aliasArr, "橡胶", "RU")
  337. }
  338. }
  339. }
  340. return
  341. }
  342. // UpdateReportChapterEs 更新报告章节ES
  343. func UpdateReportChapterEs(reportChapterId int) (err error) {
  344. if reportChapterId <= 0 {
  345. return
  346. }
  347. chapterInfo, err := models.GetReportChapterInfoById(reportChapterId)
  348. if err != nil {
  349. return
  350. }
  351. // 章节对应的品种
  352. permissionList, tmpErr := models.GetChapterTypePermissionByReportChapterTypeId(chapterInfo.TypeId)
  353. if tmpErr != nil {
  354. return
  355. }
  356. categoryArr := make([]string, 0)
  357. if len(permissionList) > 0 {
  358. for ii := 0; ii < len(permissionList); ii++ {
  359. categoryArr = append(categoryArr, permissionList[ii].PermissionName)
  360. }
  361. }
  362. aliasArr, _ := addCategoryAliasToArr(categoryArr)
  363. categories := strings.Join(aliasArr, ",")
  364. // 新增/编辑ES
  365. esChapter := &models.ElasticReportDetail{
  366. ReportId: chapterInfo.ReportId,
  367. ReportChapterId: chapterInfo.ReportChapterId,
  368. Title: chapterInfo.Title,
  369. Abstract: chapterInfo.Abstract,
  370. BodyContent: utils.TrimHtml(html.EscapeString(chapterInfo.Content)),
  371. PublishTime: chapterInfo.PublishTime.Format(utils.FormatDateTime),
  372. PublishState: chapterInfo.PublishState,
  373. Author: chapterInfo.Author,
  374. ClassifyIdFirst: chapterInfo.ClassifyIdFirst,
  375. ClassifyNameFirst: chapterInfo.ClassifyNameFirst,
  376. ClassifyIdSecond: 0,
  377. ClassifyNameSecond: "",
  378. Categories: categories,
  379. StageStr: strconv.Itoa(chapterInfo.Stage),
  380. }
  381. chapterDocId := fmt.Sprintf("%d-%d", chapterInfo.ReportId, chapterInfo.ReportChapterId)
  382. if err = EsAddOrEditReport(utils.EsReportIndexName, chapterDocId, esChapter); err != nil {
  383. return
  384. }
  385. return
  386. }
  387. // DeleteReportAndChapter 删除报告及章节
  388. func DeleteReportAndChapter(reportId int) (err error) {
  389. reportInfo, err := models.GetReportByReportId(reportId)
  390. if err != nil {
  391. err = errors.New("报告信息有误, Err: " + err.Error())
  392. return
  393. }
  394. if reportInfo.State == 2 {
  395. err = errors.New("报告已发布,不可删除")
  396. return
  397. }
  398. // 更新ES
  399. _ = UpdateReportEs(reportId, 1)
  400. // 删除
  401. if reportInfo.HasChapter == 1 && (reportInfo.ChapterType == utils.REPORT_TYPE_DAY || reportInfo.ChapterType == utils.REPORT_TYPE_WEEK) {
  402. err = models.DeleteDayWeekReportAndChapter(reportId)
  403. } else {
  404. err = models.DeleteReport(reportId)
  405. }
  406. if err != nil {
  407. err = errors.New("删除失败, Err: " + err.Error())
  408. return
  409. }
  410. // 重置PPT关联报告
  411. go func() {
  412. _ = ResetPPTReport(reportId, false)
  413. }()
  414. return
  415. }
  416. // 替换报告内容中的base64图片
  417. func replaceReportBase64ToImg(content string) (newContent string, err error) {
  418. if content == "" {
  419. return
  420. }
  421. pattern := "data:([a-z]+\\/[a-z0-9-+.]+(;[a-z-]+=[a-z0-9-]+)?)?(;base64)?,([A-Za-z0-9+/]{4})*([A-Za-z0-9+/]{3}=|[A-Za-z0-9+/]{2}==)?"
  422. re, _ := regexp.Compile(pattern)
  423. matcher := re.FindAllString(content, 999)
  424. if len(matcher) > 0 {
  425. for _, v := range matcher {
  426. imgUrl, tmpErr := reportBase64ToImg(v)
  427. if tmpErr != nil {
  428. err = tmpErr
  429. return
  430. }
  431. content = strings.ReplaceAll(content, v, imgUrl)
  432. }
  433. }
  434. newContent = content
  435. return
  436. }
  437. // 转换base64图片为img并上传
  438. func reportBase64ToImg(imageBase64 string) (resourceUrl string, err error) {
  439. if imageBase64 == "" {
  440. err = errors.New("图片为空")
  441. return
  442. }
  443. ext := ".png"
  444. uploadDir := "./static"
  445. randStr := utils.GetRandStringNoSpecialChar(28)
  446. fileName := randStr + ext
  447. fpath := uploadDir + "/" + fileName
  448. b, _ := regexp.MatchString(`^data:\s*image\/(\w+);base64,`, imageBase64)
  449. if !b {
  450. err = errors.New("图片格式不正确")
  451. return
  452. }
  453. re, _ := regexp.Compile(`^data:\s*image\/(\w+);base64,`)
  454. base64Str := re.ReplaceAllString(imageBase64, "")
  455. base64Str = strings.Replace(base64Str, " ", "", -1)
  456. err = utils.SaveBase64ToFile(base64Str, fpath)
  457. if err != nil {
  458. err = errors.New("图片保存失败" + err.Error())
  459. return
  460. }
  461. defer os.Remove(fpath)
  462. hzUploadDir := utils.RESOURCE_DIR + "images/"
  463. savePath := hzUploadDir + time.Now().Format("200601/20060102/")
  464. savePath += fileName
  465. //上传到阿里云 和 minio
  466. //if utils.ObjectStorageClient == "minio" {
  467. // err = UploadFileToMinIo(fileName, fpath, savePath)
  468. // if err != nil {
  469. // err = errors.New("文件上传失败" + err.Error())
  470. // return
  471. // }
  472. // resourceUrl = utils.MinIoImghost + savePath
  473. //} else {
  474. // err = UploadFileToAliyun(fileName, fpath, savePath)
  475. // if err != nil {
  476. // err = errors.New("文件上传失败" + err.Error())
  477. // return
  478. // }
  479. // resourceUrl = utils.Imghost + savePath
  480. //}
  481. ossClient := NewOssClient()
  482. if ossClient == nil {
  483. err = fmt.Errorf("初始化OSS服务失败")
  484. return
  485. }
  486. resourceUrl, err = ossClient.UploadFile(fileName, fpath, savePath)
  487. if err != nil {
  488. err = fmt.Errorf("文件上传失败, Err: %s", err.Error())
  489. return
  490. }
  491. item := new(models.Resource)
  492. item.ResourceUrl = resourceUrl
  493. item.ResourceType = 1
  494. item.CreateTime = time.Now()
  495. _, err = models.AddResource(item)
  496. if err != nil {
  497. err = errors.New("资源上传失败" + err.Error())
  498. return
  499. }
  500. return
  501. }
  502. // UpdateReportVideo 更新报告及其章节音频
  503. func UpdateReportVideo(reportId int) (err error) {
  504. defer func() {
  505. if err != nil {
  506. utils.FileLog.Error("UpdateReportVideo, reportId:%s, Err:%s", strconv.Itoa(reportId), err.Error())
  507. go alarm_msg.SendAlarmMsg("更新报告音频失败, 报告ID: "+strconv.Itoa(reportId)+", Err: "+err.Error(), 3)
  508. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "更新报告音频失败, 报告ID: " + reportIdStr + ", Err: "+err.Error(), utils.EmailSendToUsers)
  509. }
  510. }()
  511. if reportId == 0 {
  512. return
  513. }
  514. reportInfo, err := models.GetReportByReportId(reportId)
  515. if err != nil {
  516. return
  517. }
  518. if reportInfo.HasChapter == 1 {
  519. // 更新章节音频
  520. chapterList, tmpErr := models.GetPublishedChapterListByReportId(reportInfo.Id)
  521. if tmpErr != nil {
  522. err = tmpErr
  523. return
  524. }
  525. chapterIdArr := make([]string, 0)
  526. for i := 0; i < len(chapterList); i++ {
  527. chapterIdArr = append(chapterIdArr, strconv.Itoa(chapterList[i].ReportChapterId))
  528. }
  529. chapterIds := strings.Join(chapterIdArr, ",")
  530. //go UpdateChaptersVideo(chapterIds)
  531. err = UpdateChaptersVideo(chapterIds)
  532. } else {
  533. // 更新报告音频
  534. if reportInfo.VideoUrl != "" {
  535. return
  536. }
  537. nowTime := time.Now()
  538. updateCols := make([]string, 0)
  539. updateCols = append(updateCols, "VideoUrl", "VideoName", "VideoSize", "VideoPlaySeconds")
  540. videoUrl, videoName, videoSize, videoPlaySeconds, tmpErr := CreateReportVideo(reportInfo.Title, html.UnescapeString(reportInfo.Content), nowTime.Format(utils.FormatDateTime))
  541. reportInfo.VideoUrl = videoUrl
  542. reportInfo.VideoName = videoName
  543. reportInfo.VideoSize = videoSize
  544. reportInfo.VideoPlaySeconds = fmt.Sprintf("%.2f", videoPlaySeconds)
  545. tmpErr = reportInfo.UpdateReport(updateCols)
  546. if tmpErr != nil {
  547. err = tmpErr
  548. return
  549. }
  550. }
  551. return
  552. }
  553. func UpdateEmptyVideoReportVideo() (err error) {
  554. list, err := models.GetSyncEmptyVideoReport()
  555. if err != nil {
  556. return
  557. }
  558. listLen := len(list)
  559. if listLen <= 0 {
  560. fmt.Println("无报告需要更新音频")
  561. return
  562. }
  563. fmt.Println("Start 待更新报告音频数: ", listLen)
  564. for i := 0; i < listLen; i++ {
  565. if err = UpdateReportVideo(list[i].Id); err != nil {
  566. fmt.Printf("更新音频失败")
  567. fmt.Println(err.Error())
  568. return
  569. }
  570. }
  571. fmt.Println("End 报告音频更新完毕")
  572. return
  573. }
  574. // checkDayWeekChapterWrite 校验晨周报已写章节与本期应写章节
  575. func checkDayWeekChapterWrite(chapters []*models.ReportChapter, reportType string) (publishReport bool, tips string, publishIdArr, unPublishIdArr []int, err error) {
  576. nowTime := time.Now().Local()
  577. updateTypeArr := make([]int, 0) // 需更新的章节类型IDs
  578. publishIdArr = make([]int, 0) // 需发布的章节IDs
  579. unPublishIdArr = make([]int, 0) // 需取消发布/未发布的章节IDs
  580. // 校验章节内容
  581. if reportType == utils.REPORT_TYPE_DAY {
  582. // 晨报章节不能都为空
  583. isEmpty := true
  584. for i := 0; i < len(chapters); i++ {
  585. if chapters[i].Content != "" && chapters[i].Title != "" {
  586. isEmpty = false
  587. break
  588. }
  589. }
  590. if isEmpty {
  591. err = errors.New("报告章节内容均为空或标题为空,不可发布")
  592. return
  593. }
  594. } else {
  595. // 周报章节需至少有一篇已编辑且有标题
  596. editNum := 0
  597. for i := 0; i < len(chapters); i++ {
  598. if chapters[i].IsEdit == 1 && chapters[i].Title != "" {
  599. editNum += 1
  600. }
  601. }
  602. if editNum == 0 {
  603. err = errors.New("报告均未编辑或标题为空,不可发布")
  604. return
  605. }
  606. }
  607. // 章节类型列表
  608. types, e := models.GetReportChapterTypeListByResearchType(reportType)
  609. if e != nil {
  610. err = errors.New("获取章节类型列表失败")
  611. return
  612. }
  613. // 本期需更新的章节IDs
  614. typeLen := len(types)
  615. for i := 0; i < typeLen; i++ {
  616. if types[i].IsSet != 1 && types[i].Enabled != 0 {
  617. // 正常更新
  618. updateTypeArr = append(updateTypeArr, types[i].ReportChapterTypeId)
  619. } else {
  620. // 被设置为零值的也算作正常更新
  621. if types[i].PauseStartTime == utils.EmptyDateStr && types[i].PauseEndTime == utils.EmptyDateStr {
  622. updateTypeArr = append(updateTypeArr, types[i].ReportChapterTypeId)
  623. continue
  624. }
  625. // 暂停更新需校验时间
  626. startTime, _ := time.Parse(utils.FormatDate, types[i].PauseStartTime)
  627. endTime, _ := time.Parse(utils.FormatDate, types[i].PauseEndTime)
  628. if nowTime.Before(startTime) || nowTime.After(endTime.AddDate(0, 0, 1)) {
  629. updateTypeArr = append(updateTypeArr, types[i].ReportChapterTypeId)
  630. }
  631. }
  632. }
  633. // 校验本期需更新的章节是否都已编辑
  634. chapterLen := len(chapters)
  635. updateTypeLen := len(updateTypeArr)
  636. tipsArr := make([]string, 0)
  637. for i := 0; i < chapterLen; i++ {
  638. isWrite := false
  639. for ii := 0; ii < updateTypeLen; ii++ {
  640. // 本期应发布的章节
  641. if chapters[i].TypeId == updateTypeArr[ii] {
  642. // 标题或者内容为空的情况下, 记录tips提示信息且不发布该章节
  643. if chapters[i].Title == "" || chapters[i].Content == "" {
  644. tipsArr = append(tipsArr, chapters[i].TypeName)
  645. break
  646. }
  647. isWrite = true
  648. break
  649. }
  650. }
  651. if isWrite {
  652. publishIdArr = append(publishIdArr, chapters[i].ReportChapterId)
  653. } else {
  654. unPublishIdArr = append(unPublishIdArr, chapters[i].ReportChapterId)
  655. }
  656. }
  657. if len(tipsArr) > 0 {
  658. tips = "部分章节未发布:" + strings.Join(tipsArr, "、") + "未填写标题/内容"
  659. }
  660. // 周报需发布的章节与需更新的章节数相等则表示可发布整期, 晨报无限制
  661. if reportType == utils.REPORT_TYPE_DAY {
  662. publishReport = true
  663. } else {
  664. if len(publishIdArr) == updateTypeLen {
  665. publishReport = true
  666. }
  667. }
  668. return
  669. }
  670. // PcCreateAndUploadSunCode 生成太阳码并上传OSS
  671. func PcCreateAndUploadSunCode(scene, page string) (imgUrl string, err error) {
  672. if page == "" {
  673. err = errors.New("page不能为空")
  674. return
  675. }
  676. // scene超过32位会生成失败,md5处理至32位
  677. sceneMD5 := "a=1"
  678. if scene != "" {
  679. sceneMD5 = utils.MD5(scene)
  680. }
  681. picByte, err := GetSunCode(page, sceneMD5)
  682. if err != nil {
  683. return
  684. }
  685. // 生成图片
  686. localPath := "./static/imgs"
  687. fileName := utils.GetRandStringNoSpecialChar(28) + ".png"
  688. fpath := fmt.Sprint(localPath, "/", fileName)
  689. f, err := os.Create(fpath)
  690. if err != nil {
  691. fmt.Println("11111")
  692. return
  693. }
  694. if _, err = f.Write(picByte); err != nil {
  695. return
  696. }
  697. defer func() {
  698. f.Close()
  699. os.Remove(fpath)
  700. }()
  701. // 上传OSS
  702. fileDir := "yb/suncode/"
  703. //上传到阿里云 和 minio
  704. //if utils.ObjectStorageClient == "minio" {
  705. // imgUrl, err = UploadMinIoToDir(fileName, fpath, "", fileDir)
  706. // if err != nil {
  707. // return
  708. // }
  709. //} else {
  710. // imgUrl, err = UploadAliyunToDir(fileName, fpath, "", fileDir)
  711. // if err != nil {
  712. // return
  713. // }
  714. //}
  715. savePath := fileDir + time.Now().Format("200601/20060102/") + fileName
  716. ossClient := NewOssClient()
  717. if ossClient == nil {
  718. err = fmt.Errorf("初始化OSS服务失败")
  719. return
  720. }
  721. imgUrl, err = ossClient.UploadFile(fileName, fpath, savePath)
  722. if err != nil {
  723. err = fmt.Errorf("文件上传失败, Err: %s", err.Error())
  724. return
  725. }
  726. if err != nil {
  727. return
  728. }
  729. // 记录参数
  730. if scene != "" {
  731. newSuncode := &models.YbPcSuncode{
  732. Scene: scene,
  733. SceneMd5: sceneMD5,
  734. CodePage: page,
  735. SuncodeUrl: imgUrl,
  736. CreateTime: time.Now(),
  737. }
  738. err = models.AddYbPcSunCode(newSuncode)
  739. }
  740. // 记录参数md5
  741. if scene != "" {
  742. newPars := &models.YbSuncodePars{
  743. Scene: scene,
  744. SceneKey: sceneMD5,
  745. CreateTime: time.Now(),
  746. }
  747. err = models.AddYbSuncodePars(newPars)
  748. }
  749. return
  750. }
  751. // CreateNewReport 创建新报告
  752. func CreateNewReport(req models.AddReq, adminInfo *system.Admin) (newReportId int64, reportCode, errMsg string, err error) {
  753. contentSub := ""
  754. if req.Content != "" {
  755. e := utils.ContentXssCheck(req.Content)
  756. if e != nil {
  757. errMsg = "存在非法标签"
  758. err = errors.New("存在非法标签, Err: " + e.Error())
  759. return
  760. }
  761. contentClean, e := FilterReportContentBr(req.Content)
  762. if e != nil {
  763. errMsg = "内容去除前后空格失败"
  764. err = errors.New("内容去除前后空格失败, Err: " + e.Error())
  765. return
  766. }
  767. req.Content = contentClean
  768. sub, e := GetReportContentSub(req.Content)
  769. if e != nil {
  770. go alarm_msg.SendAlarmMsg("ContentSub 失败,Err:"+e.Error(), 3)
  771. }
  772. contentSub = sub
  773. }
  774. maxStage, e := models.GetReportStage(req.ClassifyIdFirst, req.ClassifyIdSecond, req.ClassifyIdThird)
  775. if e != nil {
  776. errMsg = "期数获取失败!"
  777. err = errors.New("期数获取失败,Err:" + e.Error())
  778. return
  779. }
  780. item := new(models.Report)
  781. item.AddType = req.AddType
  782. item.ClassifyIdFirst = req.ClassifyIdFirst
  783. item.ClassifyNameFirst = req.ClassifyNameFirst
  784. item.ClassifyIdSecond = req.ClassifyIdSecond
  785. item.ClassifyNameSecond = req.ClassifyNameSecond
  786. item.Title = req.Title
  787. item.Abstract = req.Abstract
  788. item.Author = req.Author
  789. item.Frequency = req.Frequency
  790. item.State = req.State
  791. item.Content = html.EscapeString(req.Content)
  792. item.Stage = maxStage + 1
  793. item.ContentSub = html.EscapeString(contentSub)
  794. item.CreateTime = req.CreateTime
  795. item.ModifyTime = time.Now()
  796. item.ReportVersion = req.ReportVersion
  797. item.AdminId = adminInfo.AdminId
  798. item.AdminRealName = adminInfo.RealName
  799. newReportId, e = models.AddReport(item)
  800. if e != nil {
  801. errMsg = "保存失败"
  802. err = errors.New("保存失败,Err:" + e.Error())
  803. return
  804. }
  805. // 处理权限
  806. //if utils.BusinessCode == utils.BusinessCodeRelease || utils.BusinessCode == utils.BusinessCodeSandbox {
  807. go func() {
  808. permissionItems, e := models.GetPermission(req.ClassifyIdSecond)
  809. if e != nil {
  810. alarm_msg.SendAlarmMsg("获取权限失败,Err:"+err.Error(), 3)
  811. }
  812. for _, v := range permissionItems {
  813. e = models.AddChartPermissionChapterMapping(v.ChartPermissionId, newReportId)
  814. if e != nil {
  815. alarm_msg.SendAlarmMsg("新增权限失败,Err:"+err.Error(), 3)
  816. }
  817. }
  818. // 同步crm权限
  819. _ = EditReportPermissionSync(newReportId, req.ClassifyIdSecond)
  820. }()
  821. //}
  822. reportCode = utils.MD5(strconv.Itoa(int(newReportId)))
  823. //修改唯一编码
  824. {
  825. go models.ModifyReportCode(newReportId, reportCode)
  826. }
  827. return
  828. }
  829. // FilterReportContentBr 过滤报告正文前后换行符
  830. func FilterReportContentBr(content string) (res string, err error) {
  831. newContent := content
  832. //content = `<p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><strong>四季度验证投产预期</strong></p><p style=\"font-size: 16px;\"><strong>&nbsp;</strong></p><p style=\"font-size: 16px;\"><strong>PTA:<strong><strong>近端短缺的格局出现缓解的迹象,表现在:PX进口回升;国内重整及常减压提负;PTA、PX投产在即</strong></strong><strong>。正套部分或全部止盈。</strong></strong></p><p style=\"font-size: 16px;\"><strong>&nbsp;</strong></p><p style=\"font-size: 16px;\"><strong>乙二醇:</strong><strong style=\"font-weight: 700; color: rgb(0, 0, 0); font-family: ;\">到港预报集中的情况下仍在去库,4200-4600区间震荡操作,节前没有明显方向,不建议在节前备货的时间段布局空单</strong><strong>。</strong></p><p style=\"font-size: 16px;\"><strong>&nbsp;</strong></p><p style=\"font-size: 16px;\"><strong>1、PX国内供应本周回落,PTA工厂负荷变动滞后于PX装置。</strong></p><p style=\"font-size: 16px;\">PX装置变动:</p><p style=\"font-size: 16px;\">海南炼化一期66万吨PX装置因故障停车检修,重启时间待跟踪,其二期100万吨PX装置预计在此装置重启后停车检修。</p><p style=\"font-size: 16px;\">天津石化一套100万吨重整已于20日重启中,其39万吨PX预计下周初出产品。</p><p style=\"font-size: 16px;\">韩国SK 位于仁川的130万吨PX装置按计划在23日停车检修,计划检修时长45天左右。</p><p style=\"font-size: 16px;\">截至周五,中国国内PX负荷小幅回落至73.4%(前值<span style=\"color: rgb(65, 65, 65); font-family: sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">76.8</span>%),亚洲PX负荷小幅回落至68.7%(<span style=\"color: rgb(65, 65, 65); font-family: sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">72</span>%)。</p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/4VcA2eUE1Sgkx0KQ0NjchM0ajIis.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/vi3laEb3qejWISetD0SjGTwuAxUg.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=760c86a78c35ab9286903e9ce52a6682\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=1e36d11158bf146313f3f65a65dbc5f3\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=7a69494b1a84520b2cdf1dccb3c78bda\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=0a2e374c0689d5fba4a9dc40474a33b0\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"font-size: 16px;\">PXN本周延续回落至380美金附近。</p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=ad1b869f60ab31060730e8bd58260d8c\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=d1c87cb3adff22aea0fc37dfb1870626\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=bac98256b0b86e92ed4084fbbd223f5b\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><span style=\"font-size: 16px; font-family: Arial, Helvetica, sans-serif;\">PX平衡表</span></p><p style=\"margin: 0px; padding: 0px; font-size: 16px; color: rgb(0, 0, 0); font-family: ;\">海关统计,国内8月PX进口总量在78.8万吨,环比增加17.3万吨,增幅28%;同比减少30.8万吨,降幅28.1%;8月PX出口量0.47万吨,环比下降5万吨。</p><p style=\"margin: 0px; padding: 0px; font-size: 16px; color: rgb(0, 0, 0); font-family: ;\"><span style=\"color: rgb(0, 0, 0); font-family: ;\">PX 8月进口量大幅回升至79万吨附近,其中8月从韩国进口的PX量达到33.65万吨。9月目前公布的1-20号从韩国进口PX的量已经接近8月全月的水平,即环比8月仍是大幅增加的情况:</span><span style=\"font-size: 16px;\">据悉,9月1-20日韩国PX出口总量在30.9万吨,其中出口至中国27.9万吨。</span></p><p style=\"margin: 0px; padding: 0px; font-size: 16px; color: rgb(0, 0, 0); font-family: ;\"><span style=\"font-size: 16px;\">预计9月进口量环比8月进一步增加。</span></p><p style=\"margin: 0px; padding: 0px; font-size: 16px; color: rgb(0, 0, 0); font-family: ;\"><span style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/TD59rptBDNwJ7J2qpxd8HXi4X5cQ.png\" class=\"fr-fic fr-dib fr-draggable\"></span></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><strong><span style=\"color: rgb(0, 0, 0); font-family: ;\">原油本周偏弱,欧美汽油利润本周均出现了明显回升。</span></strong></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><strong><span style=\"color: rgb(0, 0, 0); font-family: ;\"><span style=\"color: rgb(34, 34, 34); font-family: system-ui, -apple-system, BlinkMacSystemFont, ;\">美国飓风将在下周登陆墨西哥湾,届时或将影响海上钻机的运行以及炼厂开工。</span>&nbsp;</span></strong></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=ef172d65e20b986351ed50545f3d36d1\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=4930c0981fc33ab125e6ef346c9cbd5b\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=f0cae34883508273d482d4cf8c577410\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><strong>2、</strong><strong>乙烯连续跌价至900美金,PX投产压力临近PXN延续压缩。石脑油亏损本周延续修复。</strong></p><p style=\"font-size: 16px;\">PTA:按照PX11-12月上1054美金(石脑油672美金,Brent86.15美金)计算,醋酸3075元,目前含醋酸的原料成本在5670元附近。可以发现虽然Brent和PX环比上周都出现了明显的下跌,但石脑油相对上周环比上涨,石脑油亏损本周延续修复,目前石脑油-Brent价差回升至0以上。</p><p style=\"font-size: 16px;\">给到200-300的最低加工成本,PTA的估值在5870-5970元。周五日盘收盘后TA11合约5742,11月及之后的PTA合约均亏损。</p><p style=\"font-size: 16px;\">PTA基差再度回升至1000附近,周五小幅走弱至970。</p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=3e743a3907292d9ad2dce6033ae7d8a4\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/Csak38HlAbt8XsbBsPeSWlaUKJiO.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/LOPKDaDnRnbJauWqlvbhQ5VNxa03.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/Ocdq2m3bMDqZnM8PTXVyj8XILt7Z.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=268b3f7204aa21accb8d292154cf4e3c\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"font-size: 16px;\">乙二醇:静态来看,按照盘面(煤价按照900元),锚定石脑油672美金,乙烯900美金,甲醇2640元,北美乙烷价格38美分/加仑计算,乙二醇的综合成本仍在5050元附近。周五日盘收盘01合约按照综合成本亏损700元附近。</p><p style=\"font-size: 16px;\">国内外采乙烷制乙二醇目前扭亏为盈。</p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=f1e3ba1df230353571d00af2dfb7e92a\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=0d17c186dda211dab039f2ccd39a8d76\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=3a93cb16f02731bc5c74b560f9590456\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=e1a38d9058b719d8dd5bf746bc9739be\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/drjYJ468Tpnr3Bno52CQZXRuayow.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/bv4JvZN7OxhXFnx0xL0EW6yGFlX8.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220918/54TYCFo1ulvOhbJpk9jQPJcnDyan.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/fZayI9g8kS2ILeVu799dBnAdugNB.png\" class=\"fr-fic fr-dib fr-draggable\"></p><ol style=\"margin: 0px; padding: 0px; list-style: none; color: rgb(0, 0, 0); font-family: ;\"><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><strong>3、</strong><span style=\"font-size: 16px; color: rgb(0, 0, 0); font-family: ;\"><strong>需求端本周仍偏弱:继上周加弹负荷下滑后,本周织造负荷下滑。延续坯布库存回升同时原料库存下降,聚酯连续累库(瓶片低库存优势也明显减弱),两家大厂减产执行过程和节前备货中和,因此减产去库成效甚微</strong><strong>。</strong></span><span style=\"font-size: 16px;\">&nbsp;</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">终端:江浙加弹综合开工微幅回升至77%(前值</span><span style=\"font-size: 16px; color: rgb(0, 0, 0); font-family: Tahoma, ;\">76</span><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">%);江浙织机综合开工回落至69%(前值</span><span style=\"font-size: 16px; color: rgb(0, 0, 0); font-family: Tahoma, ;\">71</span><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">%);</span><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">江浙印染综合开工维持在77%</span><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">&nbsp;。</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">本周,涤丝仅周三稍有放量,整体涤丝销售氛围偏弱为主。终端在新订单氛围走弱和成本端偏弱氛围下,原料不再进一步跟进,消化前期备货为主,综合原料备货有所下降。截至目前,原料备货集中在10-15天,偏高备货至10月底。</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">订单情况:近期的织造端新单氛围整体走弱明显,前期较好的圆机和经编工厂尤为明显,出货量也有所放缓,部分工厂生产前期订单为主。</span><br><span style=\"font-size: 18px !important; color: rgb(0, 0, 0); font-family: Tahoma, ;\">直接需求:</span>近期装置轮动检修与重启,长丝大厂陆续执行减产动作,但也有几套切片装置恢复,整体而言聚酯负荷仍以区间波动为主。截至本周五,初步核算聚酯负荷在83.9%(前值84.3%)。</li></ol><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=9c163c32bf7fca689c0067e285eb1a30\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"font-size: 16px;\">轻纺城成交量节前震荡回升但仍在偏低水平。</p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/sHBC03ZwLXP1jUK1mDdd0hUjEtQo.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=5e2a381802d34c5cf33502d8a9649bd6\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><p style=\"text-align: left; margin-top: 10px; font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=e47bcc409b9b7e9178805ac6c4a00bc1\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe><br></p><p style=\"font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=12be062cbc0c61819f99648cef6e2740\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe><br></p><p style=\"font-size: 16px;\"><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=fea70f6d5bf7f1899394be0619cc2da1\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe><br><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=8a50b210b7ebb4fbb890d8ad58a817f6\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe><br><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=800bf3710951ca96c2e5a3693c94a20d\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe><br><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=fd1bff8836af41d0c32d0ed168c8b748\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe><br><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=baf493ba32b3c39e070e24ac5546fd6b\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></p><ul style=\"margin: 0px; padding: 0px; list-style: none; color: rgb(0, 0, 0); font-family: ;\"><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><strong>4、PTA行情沙盘推演<strong>2022.9.23:</strong><strong>PTA近端短缺的格局出现缓解的迹象,表现在:PX进口回升;国内重整及常减压提负;PTA、PX投产在即</strong></strong><strong>。正套部分或全部止盈。</strong></li></ul><p style=\"font-size: 16px;\"><img style=\"width: 100%;\" src=\"https://hzstatic.hzinsights.com/static/images/202209/20220922/d1HYjIFoBG9L2bGuWrXq7sBPpnT7.png\" class=\"fr-fic fr-dii fr-draggable\"><br></p><p style=\"font-size: 16px;\">PTA库存结构变化跟踪:本期PTA库存大幅去化17.9万吨附近(本周仓单集中注销,仓单库存大幅下降至0附近),聚酯成品折算PTA库存大幅累库9.3万吨,叠加PTA库存在聚酯成品库存累库的情况下去库8.6万吨。</p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/qYivQYoLkxJrmWGI5kNOy8i05q8P.png\" class=\"fr-fic fr-dib fr-draggable\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/cvLkXlLwczkvzktkN4R2SKCoHFby.png\" class=\"fr-fic fr-dib fr-draggable\" style=\"width: 572px;\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/EzRc4yuCqVcbdw2lb5FS2MCWvHd1.png\" class=\"fr-fic fr-dib fr-draggable\" style=\"width: 595px;\"></p><p style=\"font-size: 16px;\">PTA平衡表——按照Q4有500万吨新装置投产(东营威联化学250万吨及嘉通能源250万吨分别在11、12月计入产能基数)计算,按照9-10月聚酯月均负荷84%(下调1%)、87%(下调1%)预估,8-12月出口预计25万吨附近。8-10月目前预估均为去库格局。</p><p style=\"font-size: 16px;\">PX折算PTA与PTA合计9月去库幅度修正后大幅收窄。</p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/6VzQkr5nkbeqlCakRzTvZgl1PeFE.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"margin: 0px; padding: 0px; font-size: 16px;\"><br></p><p style=\"margin: 0px; padding: 0px; font-size: 16px;\"><strong style=\"color: rgb(0, 0, 0); font-family: ;\">5、</strong><strong style=\"color: rgb(0, 0, 0); font-family: ;\">乙二醇行情沙盘推演2022.9.23:到港预报集中的情况下仍在去库,4200-4600区间震荡操作,节前没有明显方向,不建议在节前备货的时间段布局空单。</strong></p><p style=\"margin: 0px; padding: 0px; font-size: 16px;\"><strong style=\"color: rgb(0, 0, 0); font-family: ;\"><img style=\"width: 100%;\" src=\"https://hzstatic.hzinsights.com/static/images/202209/20220916/e5XTMMmx04X6wpKITZ2NgjUyz8sI.png\" class=\"fr-fic fr-dii fr-draggable\"></strong><br></p><p style=\"margin: 0px; padding: 0px; font-size: 16px;\">乙二醇国内供需:</p><ul style=\"margin: 0px; padding: 0px; list-style: none; color: rgb(0, 0, 0); font-family: ;\"><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"color: rgb(0, 0, 0); font-family: Arial, Helvetica, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 28px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; float: none; display: inline !important;\">乙二醇负荷低位仍在下降:截至9月22日,中国大陆地区乙二醇整体开工负荷在43.98%(较上期下降2.44%),其中煤制乙二醇开工负荷在28.67%(较上期下降2.08%)。</span><span style=\"font-family: Arial, Helvetica, sans-serif;\">&nbsp;</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-family: Arial, Helvetica, sans-serif;\">后续供应存增加预期:</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-family: Arial, Helvetica, sans-serif;\">上周意外停车的大连大型装置预计本周末或下周初开车。</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-family: Arial, Helvetica, sans-serif;\">内蒙古40万吨装置装置周内正常出料,负荷回升中。</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-family: Arial, Helvetica, sans-serif;\">陕西30万吨装置将于近日重启,预计9月底前后出料;内蒙古26万吨装置计划本月底前后投料重启。</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-family: Arial, Helvetica, sans-serif;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/Yy4lTK54zBA3ifN4DFdpAhE1TQ4w.png\" class=\"fr-fic fr-dib fr-draggable\"></span><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/eXC4GZApxmJQLQSZZ15HV6J1nGdK.png\" class=\"fr-fic fr-dib fr-draggable\"></li></ul><p style=\"font-size: 16px;\">乙二醇到港预报与实际到港:</p><p style=\"font-size: 16px;\"><span style=\"font-size: 16px; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; font-family: Arial, Helvetica, sans-serif; text-indent: 32px; float: none; display: inline !important;\"><span style=\"color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 32px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; float: none; display: inline !important;\">隆众口径:截至9月29日,国内乙二醇华东总到港量预计在19.21万吨,较上一期增加3.45万吨,提升21.93个百分点。</span>&nbsp;</span></p><p style=\"font-size: 16px;\"><span style=\"font-size: 16px; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; font-family: Arial, Helvetica, sans-serif; text-indent: 32px; float: none; display: inline !important;\">港口发货节前回升。</span></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/WXVwl3NV0U68hnEjeNX5RFPGowq3.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/2FuGYgp5dpx6XbCNXLdSzdh4uzvp.png\" class=\"fr-fic fr-dib fr-draggable\"></p><p style=\"font-size: 16px;\">海外装置:</p><p style=\"font-size: 16px;\">印度IOC 32.5万吨装置将于近期停车技改,预计停车将持续至12月份。</p><p style=\"font-size: 16px;\">伊朗 Marun 44.5万吨装置目前处于停车状态,该装置此前货源供应印度市场为主。</p><p style=\"font-size: 16px;\">美国Sasol 28万吨装置计划于10月上旬停车检修,预计检修时长在一个月附近。</p><p style=\"font-size: 16px;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/CRzzaHscEcvhW8KXdajvLqABw11g.png\" class=\"fr-fic fr-dib fr-draggable\"></p><ul style=\"margin: 0px; padding: 0px; list-style: none; color: rgb(0, 0, 0); font-family: ;\"><li style=\"margin: 0px; padding: 0px; font-size: 16px;\">库存:</li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\">隆众口径:<span style=\"font-size: 16px; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; font-family: Arial, Helvetica, sans-serif; text-indent: 32px; float: none; display: inline !important;\">截至9月22日,华东主港地区MEG港口库存总量81.6万吨,较上一统计周期减少3.64万吨,降低4.27%。受周末台风天气影响,主港本周到货延迟且整体出货尚可,本周港口库存延续去库走势。</span></li></ul><ul style=\"margin: 0px; padding: 0px; list-style: none;\"><li style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: ;\">节前备货,聚酯工厂的乙二醇备货量本周小幅回升至84万吨附近。</li><li><br></li><li><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=c13c3e669ae5940893d1fd0e669754a5\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></li><li><iframe src=\"https://chartlib.hzinsights.com/chartshow?code=0fac897a91cbfcdb67958ae9e5d039a7\" width=\"100%\" height=\"350\" style=\"border-width:0px; min-height:350px;\"></iframe></li><li style=\"margin: 0px; padding: 0px;\"><span style=\"font-size: 16px; font-family: Arial, Helvetica, sans-serif;\">乙二醇平衡表:</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; float: none; display: inline !important;\">2022年8月我国乙二醇当月进口量为598134.40吨,累计进口量为5189987.09吨,进口量环比升4.83%,进口量同比下跌23.97%,累计进口量比去年同期降9.28%。&nbsp;</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"font-family: Arial, Helvetica, sans-serif;\">按照9-10月聚酯月均负荷84%、87%,8月进口量比预估略多,9月因受到台风影响到港持续延迟,压力预计在9月下旬至9月底显现,因此预计也只有55万吨附近,Q4进口预计仍有差别,10-12月目前预计进口60-65万吨(其中10月或偏多)。</span></li><li style=\"margin: 0px; padding: 0px; font-size: 16px; font-family: Arial, Helvetica, sans-serif;\">进口量调整后,8月去库收窄至16万吨偏下,9月目前预计去库14万吨附近,10月累库压力来自于到港集中及新装置开始贡献产量,11月累库压力来自于需求回落+新装置产量提升。</li><li style=\"margin: 0px; padding: 0px; font-size: 16px; font-family: Arial, Helvetica, sans-serif;\">11-12月警惕供应端的超预期缩量。</li><li style=\"margin: 0px; padding: 0px; font-size: 16px; font-family: Arial, Helvetica, sans-serif;\"><img src=\"https://hongze.oss-accelerate.aliyuncs.com/static/images/202209/20220925/VEW93DsD4vrzXuNUfTMCFiJSU8Y3.png\" class=\"fr-fic fr-dib fr-draggable\"></li></ul><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p><p style=\"font-size: 16px;\"><br></p>`
  833. content = html.UnescapeString(content)
  834. if content == "" {
  835. return
  836. }
  837. // 过滤编辑器版权html
  838. content = strings.Replace(content, "<p data-f-id=\"pbf\" style=\"text-align: center; font-size: 14px; margin-top: 30px; opacity: 0.65; font-family: sans-serif;\">Powered by <a href=\"https://www.froala.com/wysiwyg-editor?pb=1\" title=\"Froala Editor\">Froala Editor</a></p>", "", -1)
  839. defer func() {
  840. if err != nil {
  841. go alarm_msg.SendAlarmMsg("过滤报告正文前后换行符及空格失败, ErrMsg: "+err.Error(), 3)
  842. }
  843. }()
  844. // 做一个配置,有问题的时候随时关闭
  845. configKey := "report_filter_br"
  846. conf, e := company.GetConfigDetailByCode(configKey)
  847. if e != nil {
  848. err = errors.New("获取报告过滤配置失败, Err: " + e.Error())
  849. return
  850. }
  851. if conf.ConfigValue != "1" {
  852. return content, nil
  853. }
  854. // 找出所有<p>标签, <p>标签的索引
  855. re := regexp.MustCompile(`(?is:<p(.*?)</p>)`)
  856. arr := re.FindAllString(content, -1)
  857. indexArr := re.FindAllIndex([]byte(content), -1)
  858. // 空<p>正则
  859. emptyRe := `<p[^>]*>(<br>|<br/>)+</p>`
  860. startIsBr := false
  861. countEmptyBr := 0 // 需要连续替换的空<p>总数
  862. lastBrRange := 0 // 最后一个空<p>右侧index, 用来判断是否为连续的空<p>
  863. // 注:以下逻辑只适用于去除前面的空行, 由于编辑器始终会在文章最后面跟上自己的html标签, 此处不再进行后面空行的去除=_=!
  864. for i := range arr {
  865. byteRange := indexArr[i]
  866. if len(byteRange) == 2 {
  867. // 内容开头不为<p>直接跳出遍历, 否则才进行空<p>的判断
  868. if i == 0 && byteRange[0] == 0 {
  869. startIsBr = true
  870. }
  871. if !startIsBr {
  872. break
  873. }
  874. if lastBrRange != 0 {
  875. // 说明不是连续的空<p>, 中间出现了其他标签, 那么结束遍历, 进行最终的文本替换
  876. if lastBrRange != byteRange[0] {
  877. break
  878. }
  879. }
  880. // 正则匹配为空<p>则计数, 记录该空<p>右侧index
  881. m, e := regexp.Match(emptyRe, []byte(arr[i]))
  882. if e != nil {
  883. err = e
  884. return
  885. }
  886. if m {
  887. countEmptyBr += 1
  888. lastBrRange = byteRange[1]
  889. continue
  890. }
  891. // 遍历到该<p>标签不为空了, 结束遍历
  892. break
  893. }
  894. }
  895. if countEmptyBr > 0 {
  896. reg, e := regexp.Compile(emptyRe)
  897. if e != nil {
  898. err = errors.New("正则解析失败, Err: " + e.Error())
  899. return
  900. }
  901. counted := 0 // 已替换数
  902. res = reg.ReplaceAllStringFunc(content, func(s string) string {
  903. counted += 1
  904. if counted <= countEmptyBr {
  905. return ""
  906. } else {
  907. return s
  908. }
  909. })
  910. if res == "" {
  911. res = newContent
  912. }
  913. } else {
  914. res = content
  915. if res == "" {
  916. res = newContent
  917. }
  918. }
  919. return
  920. }
  921. // GetEnglishReportOverview 获取英文研报overview部分
  922. func GetEnglishReportOverview(content string) (res string, err error) {
  923. content = html.UnescapeString(content)
  924. doc, e := goquery.NewDocumentFromReader(strings.NewReader(content))
  925. if e != nil {
  926. err = errors.New("Create Doc Err: " + e.Error())
  927. return
  928. }
  929. target := "overview"
  930. label := "</strong>"
  931. start := -1
  932. end := -1
  933. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  934. h, e := s.Html()
  935. if e != nil {
  936. err = errors.New("Get Html1 Err: " + e.Error())
  937. return
  938. }
  939. h = strings.ToLower(h)
  940. t := s.Text()
  941. t = strings.ToLower(t)
  942. if strings.Contains(h, label) && t != "" && strings.Contains(t, target) {
  943. start = i
  944. }
  945. if start != -1 && end == -1 && i > start && strings.Contains(h, label) {
  946. end = i
  947. }
  948. })
  949. if start != -1 && end != -1 {
  950. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  951. if i > start && i < end {
  952. h, e := s.Html()
  953. if e != nil {
  954. err = errors.New("Get Html2 Err: " + e.Error())
  955. return
  956. }
  957. // 包含iframe则过滤掉
  958. if strings.Contains(h, "iframe") {
  959. return
  960. }
  961. res += `<p>` + h + `</p>`
  962. }
  963. })
  964. }
  965. return
  966. }
  967. // GetReportContentSubWithoutIframe 获取报告正文前几段,过滤iframe
  968. func GetReportContentSubWithoutIframe(content string) (contentSub string, err error) {
  969. content = html.UnescapeString(content)
  970. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  971. if err != nil {
  972. fmt.Println("create doc err:", err.Error())
  973. return
  974. }
  975. label := "iframe"
  976. n := 0
  977. doc.Find("p").Each(func(i int, s *goquery.Selection) {
  978. if n >= 5 {
  979. return
  980. }
  981. n++
  982. h, err := s.Html()
  983. if err != nil {
  984. fmt.Println("get html err", err.Error())
  985. return
  986. }
  987. // 包含iframe则过滤掉
  988. if strings.Contains(h, label) {
  989. return
  990. }
  991. if s.Text() != "" || strings.Contains(h, "src") {
  992. contentSub = contentSub + "<p>" + h + "</p>"
  993. }
  994. })
  995. return
  996. }
  997. // UpdateReportEditMark 更新研报当前更新状态
  998. // status 枚举值 1:编辑中,0:完成编辑, 2:只做查询
  999. func UpdateReportEditMark(reportId, reportChapterId, nowUserId, status int, nowUserName, lang string) (ret models.MarkReportResp, err error) {
  1000. //更新标记key
  1001. key := fmt.Sprint(`crm:report:edit:`, reportId)
  1002. // 章节id不为0则加上章节id
  1003. if reportChapterId > 0 {
  1004. key = fmt.Sprint(key, ":", reportChapterId)
  1005. }
  1006. ret.Status = 0
  1007. ret.Msg = "无人编辑"
  1008. opUserId, e := utils.Rc.RedisInt(key)
  1009. var opUser models.MarkReportItem
  1010. var classifyNameFirst string
  1011. if e != nil {
  1012. opUserInfoStr, tErr := utils.Rc.RedisString(key)
  1013. if tErr == nil {
  1014. tErr = json.Unmarshal([]byte(opUserInfoStr), &opUser)
  1015. if tErr == nil {
  1016. opUserId = opUser.AdminId
  1017. }
  1018. }
  1019. }
  1020. //判断是否是晨报或者周报,如果是则跳过
  1021. var reportInfo *models.ReportDetail
  1022. classifyNameFirst = opUser.ReportClassifyNameFirst
  1023. if reportId > 0 && status != 2 && classifyNameFirst == "" {
  1024. //查询报告ID信息
  1025. reportInfo, err = models.GetReportById(reportId)
  1026. if err != nil {
  1027. err = fmt.Errorf("报告不存在")
  1028. return
  1029. }
  1030. classifyNameFirst = reportInfo.ClassifyNameFirst
  1031. }
  1032. if opUserId > 0 && opUserId != nowUserId {
  1033. editor := opUser.Editor
  1034. if editor == "" {
  1035. //查询账号的用户姓名
  1036. otherInfo, e := system.GetSysAdminById(opUserId)
  1037. if e != nil {
  1038. err = fmt.Errorf("查询其他编辑者信息失败")
  1039. return
  1040. }
  1041. editor = otherInfo.RealName
  1042. }
  1043. ret.Status = 1
  1044. if lang == utils.EnLangVersion {
  1045. ret.Msg = fmt.Sprintf("%s is currently editing the report", editor)
  1046. } else {
  1047. ret.Msg = fmt.Sprintf("当前%s正在编辑报告", editor)
  1048. }
  1049. ret.Editor = editor
  1050. return
  1051. }
  1052. if status == 1 {
  1053. nowUser := &models.MarkReportItem{AdminId: nowUserId, Editor: nowUserName, ReportClassifyNameFirst: classifyNameFirst}
  1054. bt, e := json.Marshal(nowUser)
  1055. if e != nil {
  1056. err = fmt.Errorf("格式化编辑者信息失败")
  1057. return
  1058. }
  1059. if opUserId > 0 {
  1060. utils.Rc.Do("SETEX", key, int64(180), string(bt)) //3分钟缓存
  1061. } else {
  1062. utils.Rc.SetNX(key, string(bt), time.Second*60*3) //3分钟缓存
  1063. }
  1064. } else if status == 0 {
  1065. //清除编辑缓存
  1066. _ = utils.Rc.Delete(key)
  1067. }
  1068. return
  1069. }
  1070. // HandleVideoDecibel 处理报告中的音频文件
  1071. func HandleVideoDecibel(chapterInfo *models.ReportChapter) {
  1072. public_api.HandleVideoDecibel(chapterInfo.ReportChapterId)
  1073. return
  1074. }
  1075. // SaveReportLogs 记录报告日志
  1076. func SaveReportLogs(item *models.Report, chapters []*models.ReportChapter, adminId int, adminRealName string) {
  1077. if item == nil && len(chapters) == 0 {
  1078. return
  1079. }
  1080. var err error
  1081. defer func() {
  1082. if err != nil {
  1083. tips := fmt.Sprintf("报告日志记录, SaveReportLogs error: %s", err.Error())
  1084. go alarm_msg.SendAlarmMsg(tips, 2)
  1085. }
  1086. }()
  1087. if item != nil {
  1088. e := models.AddReportSaveLog(item.Id, item.AdminId, item.Content, item.ContentSub, item.ContentStruct, item.CanvasColor, item.AdminRealName, item.HeadResourceId, item.EndResourceId)
  1089. if e != nil {
  1090. err = fmt.Errorf("AddReportSaveLog: %s", e.Error())
  1091. return
  1092. }
  1093. }
  1094. if len(chapters) > 0 {
  1095. e := models.MultiAddReportChaptersSaveLog(chapters, adminId, adminRealName)
  1096. if e != nil {
  1097. err = fmt.Errorf("MultiAddReportChaptersSaveLog: %s", e.Error())
  1098. return
  1099. }
  1100. }
  1101. return
  1102. }
  1103. // AddReportAndChapter
  1104. // @Description: 新增报告(包含章节)
  1105. // @author: Roc
  1106. // @datetime 2024-06-04 11:23:20
  1107. // @param reportInfo *models.Report
  1108. // @param inheritReportId int
  1109. // @return err error
  1110. // @return errMsg string
  1111. func AddReportAndChapter(reportInfo *models.Report, inheritReportId int) (err error, errMsg string) {
  1112. // 获取最小分类id
  1113. minClassifyId := reportInfo.ClassifyIdThird
  1114. if minClassifyId <= 0 {
  1115. minClassifyId = reportInfo.ClassifyIdSecond
  1116. }
  1117. if minClassifyId <= 0 {
  1118. minClassifyId = reportInfo.ClassifyIdFirst
  1119. }
  1120. if minClassifyId <= 0 {
  1121. errMsg = "分类异常"
  1122. err = errors.New(errMsg)
  1123. return
  1124. }
  1125. errMsg = "生成报告失败"
  1126. // 报告继承
  1127. if inheritReportId > 0 {
  1128. inheritReport, tmpErr := models.GetReportByReportId(inheritReportId)
  1129. if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
  1130. errMsg = "获取待继承的报告失败"
  1131. err = tmpErr
  1132. return
  1133. }
  1134. if inheritReport != nil {
  1135. // 判断当前的报告分类与继承的报告分类是否一致
  1136. if inheritReport.ClassifyIdFirst != reportInfo.ClassifyIdFirst || inheritReport.ClassifyIdSecond != reportInfo.ClassifyIdSecond || inheritReport.ClassifyIdThird != reportInfo.ClassifyIdThird {
  1137. errMsg = "分类异常,与继承的报告分类不一致"
  1138. err = tmpErr
  1139. return
  1140. }
  1141. reportInfo.ChapterType = inheritReport.ChapterType
  1142. reportInfo.Content = inheritReport.Content
  1143. reportInfo.ContentSub = inheritReport.ContentSub
  1144. reportInfo.ContentStruct = inheritReport.ContentStruct
  1145. reportInfo.HeadImg = inheritReport.HeadImg
  1146. reportInfo.EndImg = inheritReport.EndImg
  1147. reportInfo.CanvasColor = inheritReport.CanvasColor
  1148. reportInfo.NeedSplice = inheritReport.NeedSplice
  1149. reportInfo.HeadResourceId = inheritReport.HeadResourceId
  1150. reportInfo.EndResourceId = inheritReport.EndResourceId
  1151. }
  1152. }
  1153. // 获取待生成的报告章节
  1154. addChapterList, allGrantUserList, err, errMsg := getAddChapter(reportInfo, minClassifyId, inheritReportId)
  1155. // 新增报告及章节
  1156. var reportId int64
  1157. reportId, err = models.AddReportAndChapter(reportInfo, allGrantUserList, addChapterList)
  1158. if err != nil {
  1159. err = errors.New("新增报告及章节失败, Err: " + err.Error())
  1160. return
  1161. }
  1162. reportCode := utils.MD5(strconv.Itoa(reportInfo.Id))
  1163. reportInfo.ReportCode = reportCode
  1164. // 修改唯一编码
  1165. {
  1166. go models.ModifyReportCode(reportId, reportCode)
  1167. }
  1168. // TODO 报告权限处理
  1169. //处理权限
  1170. //go func() {
  1171. // permissionItems, e := models.GetPermission(req.ClassifyIdSecond)
  1172. // if e != nil {
  1173. // alarm_msg.SendAlarmMsg("获取权限失败,Err:"+e.Error(), 3)
  1174. // return
  1175. // }
  1176. // for _, v := range permissionItems {
  1177. // e = models.AddChartPermissionChapterMapping(v.ChartPermissionId, int64(item.Id))
  1178. // if e != nil {
  1179. // alarm_msg.SendAlarmMsg("新增权限失败,Err:"+e.Error(), 3)
  1180. // return
  1181. // }
  1182. // }
  1183. // // 同步crm权限
  1184. // _ = EditReportPermissionSync(int64(item.Id), req.ClassifyIdSecond)
  1185. //}()
  1186. return
  1187. }
  1188. // getAddChapter
  1189. // @Description: 获取待新增的报告章节列表
  1190. // @author: Roc
  1191. // @datetime 2024-06-04 13:10:58
  1192. // @param reportInfo *models.Report
  1193. // @param minClassifyId int
  1194. // @param inheritReportId int
  1195. // @return chapterList []*models.ReportChapter
  1196. // @return err error
  1197. // @return errMsg string
  1198. func getAddChapter(reportInfo *models.Report, minClassifyId, inheritReportId int) (chapterList []models.AddReportChapter, allGrantUserList []*report.ReportGrant, err error, errMsg string) {
  1199. // 待生成的报告章节内容
  1200. chapterList = make([]models.AddReportChapter, 0)
  1201. // 所有的授权用户
  1202. allGrantUserList = make([]*report.ReportGrant, 0)
  1203. if reportInfo.HasChapter != 1 {
  1204. return
  1205. }
  1206. // TODO 弘则得单独处理启用禁用的情况
  1207. //if utils.BusinessCode != utils.BusinessCodeRelease && utils.BusinessCode != utils.BusinessCodeSandbox && utils.BusinessCode != utils.BusinessCodeDebug {
  1208. // br.Ret = 200
  1209. // br.Success = true
  1210. // br.Msg = "操作成功"
  1211. // return
  1212. //}
  1213. errMsg = "生成报告章节失败"
  1214. // 章节类型列表
  1215. typeList, err := models.GetReportChapterTypeListByClassifyId(minClassifyId)
  1216. if err != nil {
  1217. err = errors.New(errMsg)
  1218. return
  1219. }
  1220. // 分类章节的授权用户
  1221. typeGrantListMap := make(map[int][]*report.ReportChapterGrant)
  1222. // 自定义章节列表
  1223. customAddChapterList := make([]models.AddReportChapter, 0)
  1224. // 报告继承
  1225. inheritChapterMap := make(map[int]*models.ReportChapter)
  1226. if inheritReportId > 0 {
  1227. // 继承待继承的报告章节内容
  1228. inheritReportChapters, tmpErr := models.GetChapterListByReportId(inheritReportId)
  1229. if tmpErr != nil {
  1230. errMsg = "获取待继承的报告章节失败"
  1231. err = tmpErr
  1232. return
  1233. }
  1234. reportChaptersIdList := make([]int, 0)
  1235. for _, v := range inheritReportChapters {
  1236. reportChaptersIdList = append(reportChaptersIdList, v.ReportChapterId)
  1237. }
  1238. // 继承的报告章节用户map
  1239. grantListMap := make(map[int][]*report.ReportChapterGrant)
  1240. // 授权数据列表
  1241. if len(reportChaptersIdList) > 0 {
  1242. obj := report.ReportChapterGrant{}
  1243. grantList, tmpErr := obj.GetGrantListByIdList(reportChaptersIdList)
  1244. if tmpErr != nil {
  1245. errMsg = "获取待继承的报告章节的授权用户列表失败"
  1246. err = tmpErr
  1247. return
  1248. }
  1249. for _, v := range grantList {
  1250. currReportChapterId := v.ReportChapterId
  1251. tmpGrantList, ok := grantListMap[currReportChapterId]
  1252. if !ok {
  1253. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  1254. }
  1255. v.ReportChapterId = 0
  1256. v.GrantId = 0
  1257. tmpGrantList = append(tmpGrantList, v)
  1258. grantListMap[currReportChapterId] = tmpGrantList
  1259. }
  1260. }
  1261. // 继承的报告章节内容
  1262. for i := 0; i < len(inheritReportChapters); i++ {
  1263. customChapter := inheritReportChapters[i]
  1264. // 授权用户列表
  1265. tmpGrantList, ok := grantListMap[customChapter.ReportChapterId]
  1266. if !ok {
  1267. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  1268. }
  1269. typeGrantListMap[customChapter.TypeId] = tmpGrantList
  1270. // 判断该章节是否是系统章节,如果是的话,那就是需要额外创建的
  1271. if customChapter.TypeId > 0 {
  1272. inheritChapterMap[customChapter.TypeId] = customChapter
  1273. continue
  1274. }
  1275. // 自定义的报告内容
  1276. customChapter.ReportId = reportInfo.Id
  1277. customChapter.ReportChapterId = 0
  1278. customChapter.ClassifyIdFirst = reportInfo.ClassifyIdFirst
  1279. customChapter.ClassifyNameFirst = reportInfo.ClassifyNameFirst
  1280. customChapter.ClassifyIdSecond = reportInfo.ClassifyIdSecond
  1281. customChapter.ClassifyNameSecond = reportInfo.ClassifyNameSecond
  1282. customChapter.ClassifyIdThird = reportInfo.ClassifyIdThird
  1283. customChapter.ClassifyNameThird = reportInfo.ClassifyNameThird
  1284. customChapter.Stage = reportInfo.Stage
  1285. customChapter.PublishState = 1
  1286. customChapter.CreateTime = reportInfo.CreateTime
  1287. customChapter.ModifyTime = time.Now()
  1288. customChapter.LastModifyAdminId = reportInfo.LastModifyAdminId
  1289. customChapter.LastModifyAdminName = reportInfo.LastModifyAdminName
  1290. customChapter.ContentModifyTime = time.Now()
  1291. customAddChapter := models.AddReportChapter{
  1292. ReportChapter: customChapter,
  1293. GrantList: tmpGrantList,
  1294. }
  1295. customAddChapterList = append(customAddChapterList, customAddChapter)
  1296. }
  1297. }
  1298. // 最大排序
  1299. var maxSort int
  1300. for _, typeItem := range typeList {
  1301. v := inheritChapterMap[typeItem.ReportChapterTypeId]
  1302. chapterItem := new(models.ReportChapter)
  1303. if v != nil {
  1304. chapterItem.AddType = 2
  1305. chapterItem.Title = v.Title
  1306. chapterItem.ReportType = v.ReportType
  1307. chapterItem.ClassifyIdFirst = reportInfo.ClassifyIdFirst
  1308. chapterItem.ClassifyNameFirst = reportInfo.ClassifyNameFirst
  1309. chapterItem.ClassifyIdSecond = reportInfo.ClassifyIdSecond
  1310. chapterItem.ClassifyNameSecond = reportInfo.ClassifyNameSecond
  1311. chapterItem.ClassifyIdThird = reportInfo.ClassifyIdThird
  1312. chapterItem.ClassifyNameThird = reportInfo.ClassifyNameThird
  1313. chapterItem.TypeId = typeItem.ReportChapterTypeId
  1314. chapterItem.TypeName = typeItem.ReportChapterTypeName
  1315. chapterItem.Content = v.Content
  1316. chapterItem.ContentSub = v.ContentSub
  1317. chapterItem.Stage = reportInfo.Stage
  1318. chapterItem.PublishState = 1
  1319. chapterItem.Sort = typeItem.Sort
  1320. chapterItem.CreateTime = reportInfo.CreateTime
  1321. chapterItem.ModifyTime = time.Now()
  1322. chapterItem.LastModifyAdminId = reportInfo.LastModifyAdminId
  1323. chapterItem.LastModifyAdminName = reportInfo.LastModifyAdminName
  1324. chapterItem.ContentModifyTime = time.Now()
  1325. chapterItem.ContentStruct = v.ContentStruct
  1326. chapterItem.CanvasColor = v.CanvasColor
  1327. chapterItem.HeadResourceId = v.HeadResourceId
  1328. chapterItem.EndResourceId = v.EndResourceId
  1329. chapterItem.CollaborateType = v.CollaborateType
  1330. chapterItem.ReportLayout = v.ReportLayout
  1331. chapterItem.ReportCreateTime = time.Now()
  1332. } else {
  1333. chapterItem.AddType = 1
  1334. //chapterItem.ReportType = reportType
  1335. chapterItem.ClassifyIdFirst = reportInfo.ClassifyIdFirst
  1336. chapterItem.ClassifyNameFirst = reportInfo.ClassifyNameFirst
  1337. chapterItem.ClassifyIdSecond = reportInfo.ClassifyIdSecond
  1338. chapterItem.ClassifyNameSecond = reportInfo.ClassifyNameSecond
  1339. chapterItem.ClassifyIdThird = reportInfo.ClassifyIdThird
  1340. chapterItem.ClassifyNameThird = reportInfo.ClassifyNameThird
  1341. chapterItem.TypeId = typeItem.ReportChapterTypeId
  1342. chapterItem.TypeName = typeItem.ReportChapterTypeName
  1343. chapterItem.Stage = reportInfo.Stage
  1344. chapterItem.PublishState = 1
  1345. chapterItem.Sort = typeItem.Sort
  1346. chapterItem.CreateTime = reportInfo.CreateTime
  1347. chapterItem.ModifyTime = time.Now()
  1348. chapterItem.LastModifyAdminId = reportInfo.LastModifyAdminId
  1349. chapterItem.LastModifyAdminName = reportInfo.LastModifyAdminName
  1350. chapterItem.ContentModifyTime = time.Now()
  1351. //chapterItem.ContentStruct = v.ContentStruct
  1352. //chapterItem.HeadImg = v.HeadImg
  1353. //chapterItem.EndImg = v.EndImg
  1354. //chapterItem.CanvasColor = v.CanvasColor
  1355. //chapterItem.HeadResourceId = v.HeadResourceId
  1356. //chapterItem.EndResourceId = v.EndResourceId
  1357. chapterItem.CollaborateType = reportInfo.CollaborateType
  1358. chapterItem.ReportLayout = reportInfo.ReportLayout
  1359. chapterItem.ReportCreateTime = time.Now()
  1360. }
  1361. if typeItem.Sort > maxSort {
  1362. maxSort = typeItem.Sort
  1363. }
  1364. // 授权用户列表
  1365. tmpGrantList, ok := typeGrantListMap[chapterItem.TypeId]
  1366. if !ok {
  1367. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  1368. }
  1369. addChapter := models.AddReportChapter{
  1370. ReportChapter: chapterItem,
  1371. GrantList: tmpGrantList,
  1372. }
  1373. chapterList = append(chapterList, addChapter)
  1374. }
  1375. // 将自定义的章节内容添加到待生成的章节内容中
  1376. for _, addChapterItem := range customAddChapterList {
  1377. maxSort++
  1378. addChapterItem.ReportChapter.Sort = maxSort
  1379. chapterList = append(chapterList, addChapterItem)
  1380. }
  1381. hasGrantUserMap := make(map[int]bool)
  1382. for _, grantList := range typeGrantListMap {
  1383. for _, grant := range grantList {
  1384. if _, ok := hasGrantUserMap[grant.AdminId]; !ok {
  1385. allGrantUserList = append(allGrantUserList, &report.ReportGrant{
  1386. //GrantId: 0,
  1387. //ReportId: 0,
  1388. AdminId: grant.AdminId,
  1389. CreateTime: time.Now(),
  1390. })
  1391. }
  1392. }
  1393. }
  1394. return
  1395. }
  1396. // EditChapterBaseInfoAndPermission
  1397. // @Description: 修改报告章节的基础信息、授权用户权限、品种权限
  1398. // @author: Roc
  1399. // @datetime 2024-06-05 11:49:11
  1400. // @param reportInfo *models.Report
  1401. // @param reportChapterInfo *models.ReportChapter
  1402. // @param title string
  1403. // @param permissionIdList []int
  1404. // @param adminIdList []int
  1405. // @return err error
  1406. // @return errMsg string
  1407. func EditChapterBaseInfoAndPermission(reportInfo *models.Report, reportChapterInfo *models.ReportChapter, title string, permissionIdList []int, adminIdList []int) (err error, errMsg string) {
  1408. errMsg = "修改失败"
  1409. if reportInfo.State == 2 {
  1410. errMsg = "该报告已发布,不允许编辑"
  1411. err = errors.New(errMsg)
  1412. return
  1413. }
  1414. updateCols := make([]string, 0)
  1415. // 如果标题内容,那么就修改
  1416. if title != `` {
  1417. reportChapterInfo.Title = title
  1418. reportChapterInfo.ModifyTime = time.Now()
  1419. updateCols = append(updateCols, "Title", "ModifyTime")
  1420. reportChapterInfo.UpdateChapter(updateCols)
  1421. }
  1422. reportGrantObj := report.ReportGrant{}
  1423. chapterGrantObj := report.ReportChapterGrant{}
  1424. chapterPermissionObj := report.ReportChapterPermissionMapping{}
  1425. // 需要添加的报告章节授权数据
  1426. addChapterAdminList := make([]*report.ReportChapterGrant, 0)
  1427. // 待移除的报告章节授权数据id
  1428. delReportChapterGrantIdList := make([]int, 0)
  1429. // 处理当前报告章节需要新增/移除的授权信息
  1430. {
  1431. // 获取当前章节已经授权的用户信息
  1432. chapterGrantList, tmpErr := chapterGrantObj.GetGrantListById(reportChapterInfo.ReportChapterId)
  1433. if tmpErr != nil {
  1434. err = tmpErr
  1435. return
  1436. }
  1437. // 当前章节已经授权的用户信息
  1438. currChapterAdminMap := make(map[int]*report.ReportChapterGrant)
  1439. // 需要删除的报告章节授权数据
  1440. delChapterAdminMap := make(map[int]*report.ReportChapterGrant)
  1441. for _, v := range chapterGrantList {
  1442. currChapterAdminMap[v.AdminId] = v
  1443. delChapterAdminMap[v.AdminId] = v
  1444. }
  1445. for _, adminId := range adminIdList {
  1446. _, ok := currChapterAdminMap[adminId]
  1447. // 如果存在,那么从 “需要删除的报告章节授权数据” 的map中移除
  1448. if ok {
  1449. delete(delChapterAdminMap, adminId)
  1450. continue
  1451. }
  1452. // 如果不存在,那么就新增授权
  1453. addChapterAdminList = append(addChapterAdminList, &report.ReportChapterGrant{
  1454. //GrantId: 0,
  1455. ReportChapterId: reportChapterInfo.ReportChapterId,
  1456. AdminId: adminId,
  1457. CreateTime: time.Now(),
  1458. })
  1459. }
  1460. // 查出需要移除的授权id
  1461. for _, v := range delChapterAdminMap {
  1462. delReportChapterGrantIdList = append(delReportChapterGrantIdList, v.GrantId)
  1463. }
  1464. }
  1465. // 其他章节授权的用户
  1466. otherChapterAdminMap := make(map[int]bool)
  1467. {
  1468. // 获取报告所有的章节id
  1469. reportChapterIdList, tmpErr := models.GetReportChapterIdList(reportInfo.Id)
  1470. if tmpErr != nil {
  1471. err = tmpErr
  1472. return
  1473. }
  1474. if len(reportChapterIdList) > 0 {
  1475. list, tmpErr := chapterGrantObj.GetGrantListByIdList(reportChapterIdList)
  1476. if tmpErr != nil {
  1477. err = tmpErr
  1478. return
  1479. }
  1480. for _, v := range list {
  1481. // 如果是当前章节,因为涉及到重新授权,所以得过滤
  1482. if v.ReportChapterId == reportChapterInfo.ReportChapterId {
  1483. continue
  1484. }
  1485. otherChapterAdminMap[v.AdminId] = true
  1486. }
  1487. }
  1488. }
  1489. // 需要添加的报告授权数据
  1490. addReportAdminList := make([]*report.ReportGrant, 0)
  1491. // 待移除的报告授权数据id
  1492. delReportGrantIdList := make([]int, 0)
  1493. // 处理当前报告需要新增/移除的授权信息
  1494. {
  1495. // 获取当前报告已经授权的用户信息
  1496. reportGrantList, tmpErr := reportGrantObj.GetGrantListById(reportInfo.Id)
  1497. if tmpErr != nil {
  1498. err = tmpErr
  1499. return
  1500. }
  1501. // 当前报告已经授权的用户信息
  1502. currReportAdminMap := make(map[int]*report.ReportGrant)
  1503. // 需要删除的报告授权数据
  1504. delReportAdminMap := make(map[int]*report.ReportGrant)
  1505. for _, v := range reportGrantList {
  1506. currReportAdminMap[v.AdminId] = v
  1507. delReportAdminMap[v.AdminId] = v
  1508. }
  1509. // 先看需要新增哪些用户
  1510. for _, tmpAdminId := range adminIdList {
  1511. _, ok := currReportAdminMap[tmpAdminId]
  1512. // 如果章节中需要新增的用户 已经在 报告授权用户里面,那么就忽略,可以不用新增了
  1513. if ok {
  1514. delete(delReportAdminMap, tmpAdminId)
  1515. continue
  1516. }
  1517. // 如果不存在,那么就新增授权
  1518. addReportAdminList = append(addReportAdminList, &report.ReportGrant{
  1519. //GrantId: 0,
  1520. ReportId: reportInfo.Id,
  1521. AdminId: tmpAdminId,
  1522. CreateTime: time.Now(),
  1523. })
  1524. }
  1525. // 再看看章节中,需要移除的用户
  1526. for _, tmpAdminId := range delReportChapterGrantIdList {
  1527. _, ok := otherChapterAdminMap[tmpAdminId]
  1528. // 如果章节中需要移除的用户 在 报告中其他章节的授权用户里面,那么就忽略,可以不用删除了
  1529. if ok {
  1530. delete(delReportAdminMap, tmpAdminId)
  1531. continue
  1532. }
  1533. }
  1534. // 查出需要移除的授权id
  1535. for _, v := range delReportAdminMap {
  1536. delReportGrantIdList = append(delReportGrantIdList, v.GrantId)
  1537. }
  1538. }
  1539. // 需要添加的报告章节品种权限数据
  1540. addChapterPermissionList := make([]*report.ReportChapterPermissionMapping, 0)
  1541. // 待移除的报告章节品种权限数据id
  1542. delChapterPermissionMappingIdList := make([]int, 0)
  1543. // 处理当前报告章节需要新增/移除的品种权限信息
  1544. {
  1545. // 获取当前章节已经配置的品种权限信息
  1546. chapterPermissionList, tmpErr := chapterPermissionObj.GetPermissionListById(reportChapterInfo.ReportChapterId)
  1547. if tmpErr != nil {
  1548. err = tmpErr
  1549. return
  1550. }
  1551. // 当前章节已经配置的品种权限信息
  1552. currChapterPermissionMap := make(map[int]*report.ReportChapterPermissionMapping)
  1553. // 需要删除的报告章节品种权限配置
  1554. delChapterPermissionMap := make(map[int]*report.ReportChapterPermissionMapping)
  1555. for _, v := range chapterPermissionList {
  1556. currChapterPermissionMap[v.ChartPermissionId] = v
  1557. delChapterPermissionMap[v.ChartPermissionId] = v
  1558. }
  1559. for _, permissionId := range permissionIdList {
  1560. _, ok := currChapterPermissionMap[permissionId]
  1561. // 如果存在,那么从 “需要删除的报告章节品种权限配置” 的map中移除
  1562. if ok {
  1563. delete(delChapterPermissionMap, permissionId)
  1564. continue
  1565. }
  1566. // 如果不存在,那么就新增品种权限配置
  1567. addChapterPermissionList = append(addChapterPermissionList, &report.ReportChapterPermissionMapping{
  1568. //ReportChapterPermissionMappingId: 0,
  1569. ReportChapterId: reportChapterInfo.ReportChapterId,
  1570. ChartPermissionId: permissionId,
  1571. CreateTime: time.Now(),
  1572. })
  1573. }
  1574. // 查出需要移除的品种权限配置
  1575. for _, v := range delChapterPermissionMap {
  1576. delChapterPermissionMappingIdList = append(delChapterPermissionMappingIdList, v.ReportChapterPermissionMappingId)
  1577. }
  1578. }
  1579. err = models.EditChapterBaseInfoAndPermission(reportChapterInfo, updateCols, addReportAdminList, addChapterAdminList, addChapterPermissionList, delReportGrantIdList, delReportChapterGrantIdList, delChapterPermissionMappingIdList)
  1580. return
  1581. }
  1582. // DelChapterBaseInfoAndPermission
  1583. // @Description: 修改报告章节的基础信息、授权用户权限、品种权限
  1584. // @author: Roc
  1585. // @datetime 2024-06-05 11:49:11
  1586. // @param reportInfo *models.Report
  1587. // @param reportChapterInfo *models.ReportChapter
  1588. // @param title string
  1589. // @param permissionIdList []int
  1590. // @param adminIdList []int
  1591. // @return err error
  1592. // @return errMsg string
  1593. func DelChapter(reportInfo *models.Report, reportChapterInfo *models.ReportChapter, title string, permissionIdList []int, adminIdList []int) (err error, errMsg string) {
  1594. errMsg = "删除失败"
  1595. if reportInfo.State == 2 {
  1596. errMsg = "该报告已发布,不允许删除"
  1597. err = errors.New(errMsg)
  1598. return
  1599. }
  1600. updateCols := make([]string, 0)
  1601. // 如果标题内容,那么就修改
  1602. if title != `` {
  1603. reportChapterInfo.Title = title
  1604. reportChapterInfo.ModifyTime = time.Now()
  1605. updateCols = append(updateCols, "Title", "ModifyTime")
  1606. reportChapterInfo.UpdateChapter(updateCols)
  1607. }
  1608. reportGrantObj := report.ReportGrant{}
  1609. chapterGrantObj := report.ReportChapterGrant{}
  1610. chapterPermissionObj := report.ReportChapterPermissionMapping{}
  1611. // 需要添加的报告章节授权数据
  1612. addChapterAdminList := make([]*report.ReportChapterGrant, 0)
  1613. // 待移除的报告章节授权数据id
  1614. delReportChapterGrantIdList := make([]int, 0)
  1615. // 处理当前报告章节需要新增/移除的授权信息
  1616. {
  1617. // 获取当前章节已经授权的用户信息
  1618. chapterGrantList, tmpErr := chapterGrantObj.GetGrantListById(reportChapterInfo.ReportChapterId)
  1619. if tmpErr != nil {
  1620. err = tmpErr
  1621. return
  1622. }
  1623. // 当前章节已经授权的用户信息
  1624. currChapterAdminMap := make(map[int]*report.ReportChapterGrant)
  1625. // 需要删除的报告章节授权数据
  1626. delChapterAdminMap := make(map[int]*report.ReportChapterGrant)
  1627. for _, v := range chapterGrantList {
  1628. currChapterAdminMap[v.AdminId] = v
  1629. delChapterAdminMap[v.AdminId] = v
  1630. }
  1631. for _, adminId := range adminIdList {
  1632. _, ok := currChapterAdminMap[adminId]
  1633. // 如果存在,那么从 “需要删除的报告章节授权数据” 的map中移除
  1634. if ok {
  1635. delete(delChapterAdminMap, adminId)
  1636. continue
  1637. }
  1638. // 如果不存在,那么就新增授权
  1639. addChapterAdminList = append(addChapterAdminList, &report.ReportChapterGrant{
  1640. //GrantId: 0,
  1641. ReportChapterId: reportChapterInfo.ReportChapterId,
  1642. AdminId: adminId,
  1643. CreateTime: time.Now(),
  1644. })
  1645. }
  1646. // 查出需要移除的授权id
  1647. for _, v := range delChapterAdminMap {
  1648. delReportChapterGrantIdList = append(delReportChapterGrantIdList, v.GrantId)
  1649. }
  1650. }
  1651. // 其他章节授权的用户
  1652. otherChapterAdminMap := make(map[int]bool)
  1653. {
  1654. // 获取报告所有的章节id
  1655. reportChapterIdList, tmpErr := models.GetReportChapterIdList(reportInfo.Id)
  1656. if tmpErr != nil {
  1657. err = tmpErr
  1658. return
  1659. }
  1660. if len(reportChapterIdList) > 0 {
  1661. list, tmpErr := chapterGrantObj.GetGrantListByIdList(reportChapterIdList)
  1662. if tmpErr != nil {
  1663. err = tmpErr
  1664. return
  1665. }
  1666. for _, v := range list {
  1667. // 如果是当前章节,因为涉及到重新授权,所以得过滤
  1668. if v.ReportChapterId == reportChapterInfo.ReportChapterId {
  1669. continue
  1670. }
  1671. otherChapterAdminMap[v.AdminId] = true
  1672. }
  1673. }
  1674. }
  1675. // 需要添加的报告授权数据
  1676. addReportAdminList := make([]*report.ReportGrant, 0)
  1677. // 待移除的报告授权数据id
  1678. delReportGrantIdList := make([]int, 0)
  1679. // 处理当前报告需要新增/移除的授权信息
  1680. {
  1681. // 获取当前报告已经授权的用户信息
  1682. reportGrantList, tmpErr := reportGrantObj.GetGrantListById(reportInfo.Id)
  1683. if tmpErr != nil {
  1684. err = tmpErr
  1685. return
  1686. }
  1687. // 当前报告已经授权的用户信息
  1688. currReportAdminMap := make(map[int]*report.ReportGrant)
  1689. // 需要删除的报告授权数据
  1690. delReportAdminMap := make(map[int]*report.ReportGrant)
  1691. for _, v := range reportGrantList {
  1692. currReportAdminMap[v.AdminId] = v
  1693. delReportAdminMap[v.AdminId] = v
  1694. }
  1695. // 先看需要新增哪些用户
  1696. for _, tmpAdminId := range adminIdList {
  1697. _, ok := currReportAdminMap[tmpAdminId]
  1698. // 如果章节中需要新增的用户 已经在 报告授权用户里面,那么就忽略,可以不用新增了
  1699. if ok {
  1700. delete(delReportAdminMap, tmpAdminId)
  1701. continue
  1702. }
  1703. // 如果不存在,那么就新增授权
  1704. addReportAdminList = append(addReportAdminList, &report.ReportGrant{
  1705. //GrantId: 0,
  1706. ReportId: reportInfo.Id,
  1707. AdminId: tmpAdminId,
  1708. CreateTime: time.Now(),
  1709. })
  1710. }
  1711. // 再看看章节中,需要移除的用户
  1712. for _, tmpAdminId := range delReportChapterGrantIdList {
  1713. _, ok := otherChapterAdminMap[tmpAdminId]
  1714. // 如果章节中需要移除的用户 在 报告中其他章节的授权用户里面,那么就忽略,可以不用删除了
  1715. if ok {
  1716. delete(delReportAdminMap, tmpAdminId)
  1717. continue
  1718. }
  1719. }
  1720. // 查出需要移除的授权id
  1721. for _, v := range delReportAdminMap {
  1722. delReportGrantIdList = append(delReportGrantIdList, v.GrantId)
  1723. }
  1724. }
  1725. // 需要添加的报告章节品种权限数据
  1726. addChapterPermissionList := make([]*report.ReportChapterPermissionMapping, 0)
  1727. // 待移除的报告章节品种权限数据id
  1728. delChapterPermissionMappingIdList := make([]int, 0)
  1729. // 处理当前报告章节需要新增/移除的品种权限信息
  1730. {
  1731. // 获取当前章节已经配置的品种权限信息
  1732. chapterPermissionList, tmpErr := chapterPermissionObj.GetPermissionListById(reportChapterInfo.ReportChapterId)
  1733. if tmpErr != nil {
  1734. err = tmpErr
  1735. return
  1736. }
  1737. // 当前章节已经配置的品种权限信息
  1738. currChapterPermissionMap := make(map[int]*report.ReportChapterPermissionMapping)
  1739. // 需要删除的报告章节品种权限配置
  1740. delChapterPermissionMap := make(map[int]*report.ReportChapterPermissionMapping)
  1741. for _, v := range chapterPermissionList {
  1742. currChapterPermissionMap[v.ChartPermissionId] = v
  1743. delChapterPermissionMap[v.ChartPermissionId] = v
  1744. }
  1745. for _, permissionId := range permissionIdList {
  1746. _, ok := currChapterPermissionMap[permissionId]
  1747. // 如果存在,那么从 “需要删除的报告章节品种权限配置” 的map中移除
  1748. if ok {
  1749. delete(delChapterPermissionMap, permissionId)
  1750. continue
  1751. }
  1752. // 如果不存在,那么就新增品种权限配置
  1753. addChapterPermissionList = append(addChapterPermissionList, &report.ReportChapterPermissionMapping{
  1754. //ReportChapterPermissionMappingId: 0,
  1755. ReportChapterId: reportChapterInfo.ReportChapterId,
  1756. ChartPermissionId: permissionId,
  1757. CreateTime: time.Now(),
  1758. })
  1759. }
  1760. // 查出需要移除的品种权限配置
  1761. for _, v := range delChapterPermissionMap {
  1762. delChapterPermissionMappingIdList = append(delChapterPermissionMappingIdList, v.ReportChapterPermissionMappingId)
  1763. }
  1764. }
  1765. err = models.EditChapterBaseInfoAndPermission(reportChapterInfo, updateCols, addReportAdminList, addChapterAdminList, addChapterPermissionList, delReportGrantIdList, delReportChapterGrantIdList, delChapterPermissionMappingIdList)
  1766. return
  1767. }