report_v2.go 67 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250
  1. package services
  2. import (
  3. "archive/zip"
  4. "encoding/json"
  5. "errors"
  6. "eta/eta_api/models"
  7. "eta/eta_api/models/company"
  8. "eta/eta_api/models/data_manage/excel"
  9. "eta/eta_api/models/report"
  10. "eta/eta_api/models/report_approve"
  11. "eta/eta_api/models/system"
  12. "eta/eta_api/models/yb"
  13. "eta/eta_api/services/alarm_msg"
  14. "eta/eta_api/utils"
  15. "fmt"
  16. "github.com/rdlucklib/rdluck_tools/file"
  17. "github.com/rdlucklib/rdluck_tools/http"
  18. html2 "golang.org/x/net/html"
  19. "html"
  20. "net/url"
  21. "os"
  22. "path"
  23. "strconv"
  24. "strings"
  25. "time"
  26. "github.com/beego/beego/v2/server/web"
  27. "github.com/beego/beego/v2/server/web/context"
  28. "github.com/go-redis/redis/v8"
  29. )
  30. // AddReportAndChapter
  31. // @Description: 新增报告(包含章节)
  32. // @author: Roc
  33. // @datetime 2024-06-04 11:23:20
  34. // @param reportInfo *models.Report
  35. // @param inheritReportId int
  36. // @return err error
  37. // @return errMsg string
  38. func AddReportAndChapter(reportInfo *models.Report, inheritReportId int, grantAdminIdList []int, reportDate time.Time) (err error, errMsg string) {
  39. // 根据审批开关及审批流判断当前报告状态
  40. state, e := CheckReportCurrState(report_approve.FlowReportTypeChinese, reportInfo.ClassifyIdFirst, reportInfo.ClassifyIdSecond, reportInfo.ClassifyIdThird, models.ReportOperateAdd)
  41. if e != nil {
  42. //errMsg = "操作失败"
  43. err = errors.New("校验报告当前状态失败, Err: " + e.Error())
  44. return
  45. }
  46. // 报告状态
  47. reportInfo.State = state
  48. // 获取最小分类id
  49. minClassifyId := reportInfo.ClassifyIdThird
  50. if minClassifyId <= 0 {
  51. minClassifyId = reportInfo.ClassifyIdSecond
  52. }
  53. if minClassifyId <= 0 {
  54. minClassifyId = reportInfo.ClassifyIdFirst
  55. }
  56. if minClassifyId <= 0 {
  57. errMsg = "分类异常"
  58. err = errors.New(errMsg)
  59. return
  60. }
  61. errMsg = "生成报告失败"
  62. // 报告继承
  63. if inheritReportId > 0 {
  64. inheritReport, tmpErr := models.GetReportByReportId(inheritReportId)
  65. if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
  66. errMsg = "获取待继承的报告失败"
  67. err = tmpErr
  68. return
  69. }
  70. if inheritReport != nil {
  71. // 判断当前的报告分类与继承的报告分类是否一致
  72. if inheritReport.ClassifyIdFirst != reportInfo.ClassifyIdFirst || inheritReport.ClassifyIdSecond != reportInfo.ClassifyIdSecond || inheritReport.ClassifyIdThird != reportInfo.ClassifyIdThird {
  73. errMsg = "分类异常,与继承的报告分类不一致"
  74. err = errors.New(errMsg)
  75. return
  76. }
  77. reportInfo.ChapterType = inheritReport.ChapterType
  78. reportInfo.Content = inheritReport.Content
  79. reportInfo.ContentSub = inheritReport.ContentSub
  80. reportInfo.ContentStruct = inheritReport.ContentStruct
  81. reportInfo.CanvasColor = inheritReport.CanvasColor
  82. //reportInfo.NeedSplice = inheritReport.NeedSplice
  83. reportInfo.NeedSplice = 1
  84. reportInfo.HeadResourceId = inheritReport.HeadResourceId
  85. //reportInfo.HeadImg = inheritReport.HeadImg
  86. //reportInfo.EndImg = inheritReport.EndImg
  87. reportInfo.HeadImg = ``
  88. reportInfo.EndImg = ``
  89. reportInfo.EndResourceId = inheritReport.EndResourceId
  90. if inheritReport.HeadResourceId > 0 {
  91. reportInfo.HeadImg = inheritReport.HeadImg
  92. }
  93. if inheritReport.EndResourceId > 0 {
  94. reportInfo.EndImg = inheritReport.EndImg
  95. }
  96. reportInfo.InheritReportId = inheritReport.Id
  97. }
  98. }
  99. // 获取待生成的报告章节
  100. addChapterList, allGrantUserList, err, errMsg := getAddChapter(reportInfo, minClassifyId, inheritReportId, grantAdminIdList, reportDate)
  101. // 新增报告及章节
  102. var reportId int64
  103. reportId, err = models.AddReportAndChapter(reportInfo, allGrantUserList, addChapterList)
  104. if err != nil {
  105. err = errors.New("新增报告及章节失败, Err: " + err.Error())
  106. return
  107. }
  108. reportCode := utils.MD5(strconv.Itoa(reportInfo.Id))
  109. reportInfo.ReportCode = reportCode
  110. // 修改唯一编码
  111. {
  112. go models.ModifyReportCode(reportId, reportCode)
  113. }
  114. // 如果是继承报告,那么同时需要继承被引用的表格设置
  115. if reportInfo.InheritReportId > 0 {
  116. handlerReportTableReferenced(reportInfo)
  117. }
  118. // 报告权限处理
  119. go handleReportPermission(reportId, minClassifyId)
  120. return
  121. }
  122. // EditReport
  123. // @Description: 修改报告的基础信息、授权用户权限
  124. // @author: Roc
  125. // @datetime 2024-06-06 17:16:58
  126. // @param reportInfo *models.Report
  127. // @param req models.EditReq
  128. // @param sysUser *system.Admin
  129. // @return err error
  130. // @return errMsg string
  131. func EditReport(reportInfo *models.Report, req models.EditReq, sysUser *system.Admin) (err error, errMsg string) {
  132. errMsg = `保存失败`
  133. //var stage int
  134. //if reportInfo.ClassifyNameFirst != req.ClassifyNameFirst || reportInfo.ClassifyNameSecond != req.ClassifyNameSecond {
  135. // // 报告期数
  136. // maxStage, _ := models.GetReportStageEdit(req.ClassifyIdFirst, req.ClassifyIdSecond, req.ClassifyIdThird, int(req.ReportId))
  137. // maxStage = maxStage + 1
  138. // stage = maxStage
  139. //} else {
  140. // stage = reportInfo.Stage
  141. //}
  142. //if req.State != reportInfo.State {
  143. // recordItem := &models.ReportStateRecord{
  144. // ReportId: int(req.ReportId),
  145. // ReportType: 1,
  146. // State: req.State,
  147. // AdminId: this.SysUser.AdminId,
  148. // AdminName: this.SysUser.AdminName,
  149. // CreateTime: time.Now(),
  150. // }
  151. // go func() {
  152. // _, _ = models.AddReportStateRecord(recordItem)
  153. // }()
  154. //}
  155. //item := new(models.Report)
  156. //reportInfo.ClassifyIdFirst = req.ClassifyIdFirst
  157. //reportInfo.ClassifyNameFirst = req.ClassifyNameFirst
  158. //reportInfo.ClassifyIdSecond = req.ClassifyIdSecond
  159. //reportInfo.ClassifyNameSecond = req.ClassifyNameSecond
  160. //reportInfo.ClassifyIdThird = req.ClassifyIdThird
  161. //reportInfo.ClassifyNameThird = req.ClassifyNameThird
  162. reportInfo.Title = req.Title
  163. reportInfo.Abstract = req.Abstract
  164. reportInfo.Author = req.Author
  165. reportInfo.Frequency = req.Frequency
  166. //reportInfo.State = reportInfo.State // 编辑不变更状态
  167. //reportInfo.Stage = stage // 编辑不变更期数
  168. //reportInfo.Content = html.EscapeString(req.Content) // 编辑不变更具体内容
  169. //reportInfo.ContentSub = html.EscapeString(contentSub) // 编辑不变更具体内容
  170. reportInfo.CreateTime = req.CreateTime
  171. //reportInfo.CollaborateType = req.CollaborateType
  172. //reportInfo.ReportLayout = req.ReportLayout
  173. if req.IsPublicPublish <= 0 {
  174. req.IsPublicPublish = 1
  175. }
  176. reportInfo.IsPublicPublish = req.IsPublicPublish
  177. reportInfo.LastModifyAdminId = sysUser.AdminId
  178. reportInfo.LastModifyAdminName = sysUser.RealName
  179. reportInfo.ModifyTime = time.Now()
  180. state, e := CheckReportCurrState(report_approve.FlowReportTypeChinese, reportInfo.ClassifyIdFirst, reportInfo.ClassifyIdSecond, reportInfo.ClassifyIdThird, models.ReportOperateEdit)
  181. if e != nil {
  182. //errMsg = "操作失败"
  183. err = errors.New("校验报告当前状态失败, Err: " + e.Error())
  184. return
  185. }
  186. // 报告状态
  187. reportInfo.State = state
  188. //updateCols := []string{"ClassifyIdFirst", "ClassifyNameFirst", "ClassifyIdSecond", "ClassifyNameSecond", "ClassifyIdThird", "ClassifyNameThird", "Title", "Abstract", "Author", "Frequency", "Stage", "CreateTime", "IsPublicPublish", "LastModifyAdminId", "LastModifyAdminName", "ModifyTime"}
  189. updateCols := []string{"Title", "Abstract", "Author", "Frequency", "CreateTime", "IsPublicPublish", "LastModifyAdminId", "LastModifyAdminName", "ModifyTime", "State"}
  190. if req.HeadResourceId > 0 {
  191. reportInfo.HeadResourceId = req.HeadResourceId
  192. updateCols = append(updateCols, "HeadResourceId")
  193. }
  194. if req.EndResourceId > 0 {
  195. reportInfo.EndResourceId = req.EndResourceId
  196. updateCols = append(updateCols, "EndResourceId")
  197. }
  198. // 需要添加的报告授权数据
  199. addReportAdminList := make([]*report.ReportGrant, 0)
  200. // 待移除的报告授权数据id
  201. delReportGrantIdList := make([]int, 0)
  202. // 处理当前报告需要新增/移除的授权信息
  203. {
  204. reportGrantObj := report.ReportGrant{}
  205. // 获取当前报告已经授权的用户信息
  206. reportGrantList, tmpErr := reportGrantObj.GetGrantListById(reportInfo.Id)
  207. if tmpErr != nil {
  208. err = tmpErr
  209. return
  210. }
  211. // 当前报告已经授权的用户信息
  212. currReportAdminMap := make(map[int]*report.ReportGrant)
  213. // 需要删除的报告授权数据
  214. delReportAdminMap := make(map[int]*report.ReportGrant)
  215. for _, v := range reportGrantList {
  216. currReportAdminMap[v.AdminId] = v
  217. delReportAdminMap[v.AdminId] = v
  218. }
  219. // 先看需要新增哪些用户
  220. for _, tmpAdminId := range req.GrantAdminIdList {
  221. _, ok := currReportAdminMap[tmpAdminId]
  222. // 如果章节中需要新增的用户 已经在 报告授权用户里面,那么就忽略,可以不用新增了
  223. if ok {
  224. delete(delReportAdminMap, tmpAdminId)
  225. continue
  226. }
  227. // 如果不存在,那么就新增授权
  228. addReportAdminList = append(addReportAdminList, &report.ReportGrant{
  229. //GrantId: 0,
  230. ReportId: reportInfo.Id,
  231. AdminId: tmpAdminId,
  232. CreateTime: time.Now(),
  233. })
  234. }
  235. // 查出需要移除的授权id
  236. for _, v := range delReportAdminMap {
  237. delReportGrantIdList = append(delReportGrantIdList, v.GrantId)
  238. }
  239. }
  240. // 修改报告的基本信息,以及报告的授权用户
  241. err = models.EditReportAndPermission(reportInfo, updateCols, addReportAdminList, delReportGrantIdList)
  242. if err != nil {
  243. return
  244. }
  245. // 报告权限处理
  246. {
  247. minClassifyId, _, tmpErr := getMinClassify(reportInfo)
  248. if tmpErr != nil {
  249. return
  250. }
  251. go handleReportPermission(int64(reportInfo.Id), minClassifyId)
  252. }
  253. return
  254. }
  255. // getAddChapter
  256. // @Description: 获取待新增的报告章节列表
  257. // @author: Roc
  258. // @datetime 2024-06-04 13:10:58
  259. // @param reportInfo *models.Report
  260. // @param minClassifyId int
  261. // @param inheritReportId int
  262. // @param grantAdminIdList []int
  263. // @return chapterList []*models.ReportChapter
  264. // @return err error
  265. // @return errMsg string
  266. func getAddChapter(reportInfo *models.Report, minClassifyId, inheritReportId int, grantAdminIdList []int, reportDate time.Time) (chapterList []models.AddReportChapter, allGrantUserList []*report.ReportGrant, err error, errMsg string) {
  267. // 待生成的报告章节内容
  268. chapterList = make([]models.AddReportChapter, 0)
  269. // 所有的授权用户
  270. allGrantUserList = make([]*report.ReportGrant, 0)
  271. // 报告授权的用户ID
  272. needAdminIdMap := make(map[int]bool)
  273. for _, adminId := range grantAdminIdList {
  274. needAdminIdMap[adminId] = true
  275. allGrantUserList = append(allGrantUserList, &report.ReportGrant{
  276. //GrantId: 0,
  277. //ReportId: 0,
  278. AdminId: adminId,
  279. CreateTime: time.Now(),
  280. })
  281. }
  282. if reportInfo.HasChapter != 1 {
  283. return
  284. }
  285. // 最小单元的分类
  286. var minClassifyName string
  287. if reportInfo.ClassifyIdThird == minClassifyId {
  288. minClassifyName = reportInfo.ClassifyNameThird
  289. } else if reportInfo.ClassifyIdSecond == minClassifyId {
  290. minClassifyName = reportInfo.ClassifyNameSecond
  291. } else {
  292. minClassifyName = reportInfo.ClassifyNameFirst
  293. }
  294. errMsg = "生成报告章节失败"
  295. // 章节类型列表
  296. allTypeList, err := models.GetReportChapterTypeListByClassifyId(minClassifyId)
  297. if err != nil {
  298. err = errors.New(errMsg)
  299. return
  300. }
  301. // 待添加的章节
  302. chapterTypeList := make([]*models.ReportChapterType, 0)
  303. // 待添加的章节类型id列表
  304. chapterTypeIdList := make([]int, 0)
  305. //nowTime := time.Now().Local()
  306. for _, chapterType := range allTypeList {
  307. // 如果被永久暂停更新了
  308. if chapterType.Enabled == 0 { //该章节已被永久禁用,那么就不允许继承或者新增该章节
  309. continue
  310. }
  311. if chapterType.PauseStartTime != "" && chapterType.PauseEndTime != "" && chapterType.PauseStartTime != utils.EmptyDateStr && chapterType.PauseEndTime != utils.EmptyDateStr {
  312. startTime, timeErr := time.ParseInLocation(utils.FormatDate, chapterType.PauseStartTime, time.Local)
  313. if timeErr != nil {
  314. utils.FileLog.Error("更新规则时间转换失败4001, Err: " + timeErr.Error())
  315. continue
  316. }
  317. endTime, timeErr := time.ParseInLocation(utils.FormatDate, chapterType.PauseEndTime, time.Local)
  318. if timeErr != nil {
  319. utils.FileLog.Error("更新规则时间转换失败4002, Err: " + timeErr.Error())
  320. continue
  321. }
  322. // 暂停更新(此处用报告日期去判断是否需要停更,而不是报告创建日期)
  323. if !reportDate.Before(startTime) && !reportDate.After(endTime) {
  324. continue
  325. }
  326. }
  327. // 正常的章节类型状态,那么应该自动创建该章节
  328. chapterTypeList = append(chapterTypeList, chapterType)
  329. chapterTypeIdList = append(chapterTypeIdList, chapterType.ReportChapterTypeId)
  330. }
  331. // 待继承的章节类id的授权用户
  332. oldChapterIdGrantListMap := make(map[int][]*report.ReportChapterGrant)
  333. // 待继承的章节类id关联的品种列表
  334. oldChapterPermissionListMap := make(map[int][]*report.ReportChapterPermissionMapping)
  335. // 自定义章节列表
  336. customAddChapterList := make([]models.AddReportChapter, 0)
  337. // 报告继承
  338. inheritChapterMap := make(map[int]*models.ReportChapter)
  339. // 当前分类下配置的章节类型id所关联的品种列表(默认配置,不是从继承报告里面获取的,如果有继承章节,那么需要从继承报告里面获取)
  340. currChapterTypePermissionListMap := make(map[int][]*report.ReportChapterPermissionMapping)
  341. if len(chapterTypeIdList) > 0 {
  342. mappingList, e := models.GetChapterTypePermissionByChapterTypeIdList(chapterTypeIdList)
  343. if e != nil {
  344. err = fmt.Errorf("获取章节类型权限列表失败, Err: " + e.Error())
  345. return
  346. }
  347. hasPermissionMap := make(map[string]bool)
  348. for _, v := range mappingList {
  349. tmpChapterTypePermissionList, ok := currChapterTypePermissionListMap[v.ReportChapterTypeId]
  350. if !ok {
  351. tmpChapterTypePermissionList = make([]*report.ReportChapterPermissionMapping, 0)
  352. }
  353. key := fmt.Sprint(v.ReportChapterTypeId, "-", v.ChartPermissionId)
  354. if _, has := hasPermissionMap[key]; !has {
  355. hasPermissionMap[key] = true
  356. currChapterTypePermissionListMap[v.ReportChapterTypeId] = append(tmpChapterTypePermissionList, &report.ReportChapterPermissionMapping{
  357. ReportChapterPermissionMappingId: 0,
  358. ReportChapterId: 0,
  359. ChartPermissionId: v.ChartPermissionId,
  360. CreateTime: time.Now(),
  361. })
  362. }
  363. }
  364. }
  365. if inheritReportId > 0 {
  366. // 继承待继承的报告章节内容
  367. inheritReportChapters, tmpErr := models.GetChapterListByReportId(inheritReportId)
  368. if tmpErr != nil {
  369. errMsg = "获取待继承的报告章节失败"
  370. err = tmpErr
  371. return
  372. }
  373. reportChaptersIdList := make([]int, 0)
  374. for _, v := range inheritReportChapters {
  375. reportChaptersIdList = append(reportChaptersIdList, v.ReportChapterId)
  376. }
  377. // 继承的报告章节用户map
  378. grantListMap := make(map[int][]*report.ReportChapterGrant)
  379. // 继承的报告章节的关联品种map
  380. chapterPermissionListMap := make(map[int][]*report.ReportChapterPermissionMapping)
  381. // 授权数据列表
  382. if len(reportChaptersIdList) > 0 {
  383. // 授权用户数据
  384. obj := report.ReportChapterGrant{}
  385. grantList, tmpErr := obj.GetGrantListByIdList(reportChaptersIdList)
  386. if tmpErr != nil {
  387. errMsg = "获取待继承的报告章节的授权用户列表失败"
  388. err = tmpErr
  389. return
  390. }
  391. for _, v := range grantList {
  392. // 如果不在报告授权的用户ID里面,那么该章节就不继承该授权用户
  393. if _, ok := needAdminIdMap[v.AdminId]; !ok {
  394. continue
  395. }
  396. currReportChapterId := v.ReportChapterId
  397. tmpGrantList, ok := grantListMap[currReportChapterId]
  398. if !ok {
  399. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  400. }
  401. v.ReportChapterId = 0
  402. v.GrantId = 0
  403. tmpGrantList = append(tmpGrantList, v)
  404. grantListMap[currReportChapterId] = tmpGrantList
  405. }
  406. // 授权关联品种数据
  407. permissionObj := report.ReportChapterPermissionMapping{}
  408. permissionList, tmpErr := permissionObj.GetPermissionListByIdList(reportChaptersIdList)
  409. if tmpErr != nil {
  410. errMsg = "获取待继承的报告章节的授权用户列表失败"
  411. err = tmpErr
  412. return
  413. }
  414. for _, v := range permissionList {
  415. currReportChapterId := v.ReportChapterId
  416. tmpPermissionList, ok := chapterPermissionListMap[currReportChapterId]
  417. if !ok {
  418. tmpPermissionList = make([]*report.ReportChapterPermissionMapping, 0)
  419. }
  420. v.ReportChapterId = 0
  421. v.ReportChapterPermissionMappingId = 0
  422. tmpPermissionList = append(tmpPermissionList, v)
  423. chapterPermissionListMap[currReportChapterId] = tmpPermissionList
  424. }
  425. }
  426. // 继承的报告章节内容
  427. for i := 0; i < len(inheritReportChapters); i++ {
  428. customChapter := inheritReportChapters[i]
  429. // 授权用户列表
  430. tmpGrantList, ok := grantListMap[customChapter.ReportChapterId]
  431. if !ok {
  432. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  433. }
  434. oldChapterIdGrantListMap[customChapter.ReportChapterId] = tmpGrantList
  435. // 关联品种列表
  436. chapterPermissionList, ok := chapterPermissionListMap[customChapter.ReportChapterId]
  437. if !ok {
  438. chapterPermissionList = make([]*report.ReportChapterPermissionMapping, 0)
  439. }
  440. oldChapterPermissionListMap[customChapter.ReportChapterId] = chapterPermissionList
  441. // 判断该章节是否是系统章节,如果是的话,那就是需要额外创建的
  442. if customChapter.TypeId > 0 {
  443. inheritChapterMap[customChapter.TypeId] = customChapter
  444. continue
  445. }
  446. // 自定义的报告内容
  447. customChapter.ReportId = reportInfo.Id
  448. customChapter.ReportChapterId = 0
  449. customChapter.ClassifyIdFirst = minClassifyId
  450. customChapter.ClassifyNameFirst = minClassifyName
  451. customChapter.Stage = reportInfo.Stage
  452. customChapter.PublishState = 1
  453. customChapter.CreateTime = reportInfo.CreateTime
  454. customChapter.ModifyTime = time.Now()
  455. customChapter.LastModifyAdminId = reportInfo.LastModifyAdminId
  456. customChapter.LastModifyAdminName = reportInfo.LastModifyAdminName
  457. customChapter.ContentModifyTime = time.Now()
  458. customAddChapter := models.AddReportChapter{
  459. ReportChapter: customChapter,
  460. GrantList: tmpGrantList,
  461. GrantPermissionList: chapterPermissionList,
  462. }
  463. customAddChapterList = append(customAddChapterList, customAddChapter)
  464. }
  465. }
  466. // 最大排序
  467. var maxSort int
  468. for _, typeItem := range chapterTypeList {
  469. v, ok := inheritChapterMap[typeItem.ReportChapterTypeId]
  470. // 章节授权用户
  471. var tmpGrantList []*report.ReportChapterGrant
  472. // 章节关联品种
  473. var tmpChapterPermissionList []*report.ReportChapterPermissionMapping
  474. chapterItem := new(models.ReportChapter)
  475. if ok && v != nil {
  476. // 如果存在继承的章节,那么就从继承的章节内容中获取
  477. chapterItem.AddType = 2
  478. chapterItem.Title = v.Title
  479. chapterItem.ReportType = v.ReportType
  480. chapterItem.ClassifyIdFirst = minClassifyId
  481. chapterItem.ClassifyNameFirst = minClassifyName
  482. chapterItem.TypeId = typeItem.ReportChapterTypeId
  483. chapterItem.TypeName = typeItem.ReportChapterTypeName
  484. chapterItem.Content = v.Content
  485. chapterItem.ContentSub = v.ContentSub
  486. chapterItem.Stage = reportInfo.Stage
  487. chapterItem.PublishState = 1
  488. chapterItem.Sort = typeItem.Sort
  489. chapterItem.CreateTime = reportInfo.CreateTime
  490. chapterItem.ModifyTime = time.Now()
  491. chapterItem.LastModifyAdminId = reportInfo.LastModifyAdminId
  492. chapterItem.LastModifyAdminName = reportInfo.LastModifyAdminName
  493. chapterItem.ContentModifyTime = time.Now()
  494. chapterItem.ContentStruct = v.ContentStruct
  495. chapterItem.ReportLayout = v.ReportLayout
  496. chapterItem.ReportCreateTime = time.Now()
  497. // 继承历史章节中的授权用户列表
  498. tmpGrantList, ok = oldChapterIdGrantListMap[v.ReportChapterId]
  499. if !ok {
  500. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  501. }
  502. // 继承历史章节中的关联品种列表
  503. tmpChapterPermissionList, ok = oldChapterPermissionListMap[v.ReportChapterId]
  504. if !ok {
  505. tmpChapterPermissionList = make([]*report.ReportChapterPermissionMapping, 0)
  506. }
  507. } else {
  508. // 如果系统章节未从继承的报告中找到,那么获取往期中最新版本的此章节内容
  509. var findChapter bool
  510. if inheritReportId > 0 {
  511. chapterNewest, e := models.GetNewestPreReportChapterByClassifyIdAndTypeId(minClassifyId, typeItem.ReportChapterTypeId)
  512. if e != nil && e.Error() == utils.ErrNoRow() {
  513. errMsg = "继承最新内容的章节失败"
  514. err = fmt.Errorf("获取最新内容的章节失败, %v", e)
  515. return
  516. }
  517. if chapterNewest != nil {
  518. chapterItem.AddType = 2
  519. chapterItem.Title = chapterNewest.Title
  520. chapterItem.ReportType = chapterNewest.ReportType
  521. chapterItem.ClassifyIdFirst = minClassifyId
  522. chapterItem.ClassifyNameFirst = minClassifyName
  523. chapterItem.TypeId = typeItem.ReportChapterTypeId
  524. chapterItem.TypeName = typeItem.ReportChapterTypeName
  525. chapterItem.Content = chapterNewest.Content
  526. chapterItem.ContentSub = chapterNewest.ContentSub
  527. chapterItem.Stage = reportInfo.Stage
  528. chapterItem.PublishState = 1
  529. chapterItem.Sort = typeItem.Sort
  530. chapterItem.CreateTime = reportInfo.CreateTime
  531. chapterItem.ModifyTime = time.Now()
  532. chapterItem.LastModifyAdminId = reportInfo.LastModifyAdminId
  533. chapterItem.LastModifyAdminName = reportInfo.LastModifyAdminName
  534. chapterItem.ContentModifyTime = time.Now()
  535. chapterItem.ContentStruct = chapterNewest.ContentStruct
  536. chapterItem.ReportLayout = chapterNewest.ReportLayout
  537. chapterItem.ReportCreateTime = time.Now()
  538. // 这里的授权和品种权限需要额外查询
  539. tmpGrantList = make([]*report.ReportChapterGrant, 0)
  540. tmpChapterPermissionList = make([]*report.ReportChapterPermissionMapping, 0)
  541. {
  542. grantOb := report.ReportChapterGrant{}
  543. chapterGrant, e := grantOb.GetGrantListById(chapterNewest.ReportChapterId)
  544. if e != nil {
  545. errMsg = "获取待继承的报告章节的授权用户列表失败"
  546. err = fmt.Errorf("获取待继承的报告章节的授权用户列表失败, ChapterId: %d, Err: %v", chapterNewest.ReportChapterId, e)
  547. return
  548. }
  549. for _, cg := range chapterGrant {
  550. // 如果不在报告授权的用户ID里面,那么该章节就不继承该授权用户
  551. if _, ok := needAdminIdMap[cg.AdminId]; !ok {
  552. continue
  553. }
  554. cg.ReportChapterId = 0
  555. cg.GrantId = 0
  556. tmpGrantList = append(tmpGrantList, cg)
  557. }
  558. permissionOb := report.ReportChapterPermissionMapping{}
  559. permissions, e := permissionOb.GetPermissionListById(chapterNewest.ReportChapterId)
  560. if e != nil {
  561. errMsg = "获取待继承的报告章节的品种权限失败"
  562. err = fmt.Errorf("获取待继承的报告章节的品种权限失败, ChapterId: %d, Err: %v", chapterNewest.ReportChapterId, e)
  563. return
  564. }
  565. for _, ps := range permissions {
  566. ps.ReportChapterId = 0
  567. ps.ReportChapterPermissionMappingId = 0
  568. tmpChapterPermissionList = append(tmpChapterPermissionList, ps)
  569. }
  570. }
  571. findChapter = true
  572. }
  573. }
  574. // 没找到那就新增一篇空白的
  575. if !findChapter {
  576. chapterItem.AddType = 1
  577. chapterItem.Title = typeItem.ReportChapterTypeName
  578. chapterItem.ReportType = typeItem.ResearchType
  579. chapterItem.ClassifyIdFirst = minClassifyId
  580. chapterItem.ClassifyNameFirst = minClassifyName
  581. chapterItem.TypeId = typeItem.ReportChapterTypeId
  582. chapterItem.TypeName = typeItem.ReportChapterTypeName
  583. chapterItem.Stage = reportInfo.Stage
  584. chapterItem.PublishState = 1
  585. chapterItem.Sort = typeItem.Sort
  586. chapterItem.CreateTime = reportInfo.CreateTime
  587. chapterItem.ModifyTime = time.Now()
  588. chapterItem.LastModifyAdminId = reportInfo.LastModifyAdminId
  589. chapterItem.LastModifyAdminName = reportInfo.LastModifyAdminName
  590. chapterItem.ContentModifyTime = time.Now()
  591. //chapterItem.ContentStruct = v.ContentStruct
  592. chapterItem.ReportLayout = reportInfo.ReportLayout
  593. chapterItem.ReportCreateTime = time.Now()
  594. // 默认配置:从当前分类下配置的章节类型id所关联的品种列表
  595. tmpChapterPermissionList, ok = currChapterTypePermissionListMap[typeItem.ReportChapterTypeId]
  596. if !ok {
  597. tmpChapterPermissionList = make([]*report.ReportChapterPermissionMapping, 0)
  598. }
  599. }
  600. }
  601. if typeItem.Sort > maxSort {
  602. maxSort = typeItem.Sort
  603. }
  604. addChapter := models.AddReportChapter{
  605. ReportChapter: chapterItem,
  606. GrantList: tmpGrantList,
  607. GrantPermissionList: tmpChapterPermissionList,
  608. }
  609. chapterList = append(chapterList, addChapter)
  610. }
  611. // 将自定义的章节内容添加到待生成的章节内容中
  612. for _, addChapterItem := range customAddChapterList {
  613. maxSort++
  614. addChapterItem.ReportChapter.Sort = maxSort
  615. chapterList = append(chapterList, addChapterItem)
  616. }
  617. //hasGrantUserMap := make(map[int]bool)
  618. //for _, grantList := range typeGrantListMap {
  619. // for _, grant := range grantList {
  620. // if _, ok := hasGrantUserMap[grant.AdminId]; !ok {
  621. // allGrantUserList = append(allGrantUserList, &report.ReportGrant{
  622. // //GrantId: 0,
  623. // //ReportId: 0,
  624. // AdminId: grant.AdminId,
  625. // CreateTime: time.Now(),
  626. // })
  627. // }
  628. // }
  629. //}
  630. return
  631. }
  632. // AddChapterBaseInfoAndPermission
  633. // @Description: 添加章节基本信息及权限
  634. // @author: Roc
  635. // @datetime 2024-06-11 15:35:23
  636. // @param reportInfo *models.Report
  637. // @param reportChapterInfo *models.ReportChapter
  638. // @param permissionIdList []int
  639. // @param adminIdList []int
  640. // @return err error
  641. // @return errMsg string
  642. func AddChapterBaseInfoAndPermission(reportInfo *models.Report, reportChapterInfo *models.ReportChapter, permissionIdList []int, adminIdList []int) (err error, errMsg string) {
  643. errMsg = "新增失败"
  644. if reportInfo.State == 2 {
  645. errMsg = "该报告已发布,不允许编辑"
  646. err = errors.New(errMsg)
  647. return
  648. }
  649. // 需要添加的报告章节授权数据
  650. addChapterAdminList := make([]*report.ReportChapterGrant, 0)
  651. for _, adminId := range adminIdList {
  652. //新增授权
  653. addChapterAdminList = append(addChapterAdminList, &report.ReportChapterGrant{
  654. //GrantId: 0,
  655. //ReportChapterId: reportChapterInfo.ReportChapterId,
  656. AdminId: adminId,
  657. CreateTime: time.Now(),
  658. })
  659. }
  660. // 需要添加的报告章节品种权限数据
  661. addChapterPermissionList := make([]*report.ReportChapterPermissionMapping, 0)
  662. // 品种权限
  663. for _, permissionId := range permissionIdList {
  664. // 如果不存在,那么就新增品种权限配置
  665. addChapterPermissionList = append(addChapterPermissionList, &report.ReportChapterPermissionMapping{
  666. //ReportChapterPermissionMappingId: 0,
  667. //ReportChapterId: reportChapterInfo.ReportChapterId,
  668. ChartPermissionId: permissionId,
  669. CreateTime: time.Now(),
  670. })
  671. }
  672. err = models.AddChapterBaseInfoAndPermission(reportChapterInfo, addChapterAdminList, addChapterPermissionList)
  673. return
  674. }
  675. // EditChapterBaseInfoAndPermission
  676. // @Description: 修改报告章节的基础信息、授权用户权限、品种权限
  677. // @author: Roc
  678. // @datetime 2024-06-05 11:49:11
  679. // @param reportInfo *models.Report
  680. // @param reportChapterInfo *models.ReportChapter
  681. // @param title string
  682. // @param permissionIdList []int
  683. // @param adminIdList []int
  684. // @return err error
  685. // @return errMsg string
  686. func EditChapterBaseInfoAndPermission(reportInfo *models.Report, reportChapterInfo *models.ReportChapter, title string, permissionIdList []int, adminIdList []int) (err error, errMsg string) {
  687. errMsg = "修改失败"
  688. if reportInfo.State == 2 {
  689. errMsg = "该报告已发布,不允许编辑"
  690. err = errors.New(errMsg)
  691. return
  692. }
  693. updateCols := make([]string, 0)
  694. // 如果标题内容,那么就修改
  695. if title != `` {
  696. reportChapterInfo.Title = title
  697. reportChapterInfo.ModifyTime = time.Now()
  698. updateCols = append(updateCols, "Title", "ModifyTime")
  699. reportChapterInfo.UpdateChapter(updateCols)
  700. }
  701. reportGrantObj := report.ReportGrant{}
  702. chapterGrantObj := report.ReportChapterGrant{}
  703. chapterPermissionObj := report.ReportChapterPermissionMapping{}
  704. // 报告授权的用户map
  705. reportGrantAdminIdMap := make(map[int]bool)
  706. // 获取报告授权的用户信息
  707. {
  708. // 获取当前报告已经授权的用户信息
  709. reportGrantList, tmpErr := reportGrantObj.GetGrantListById(reportInfo.Id)
  710. if tmpErr != nil {
  711. err = tmpErr
  712. return
  713. }
  714. for _, v := range reportGrantList {
  715. reportGrantAdminIdMap[v.AdminId] = true
  716. }
  717. }
  718. // 需要添加的报告章节授权数据
  719. addChapterAdminList := make([]*report.ReportChapterGrant, 0)
  720. // 待移除的报告章节授权数据id
  721. delReportChapterGrantIdList := make([]int, 0)
  722. // 处理当前报告章节需要新增/移除的授权信息
  723. {
  724. // 获取当前章节已经授权的用户信息
  725. chapterGrantList, tmpErr := chapterGrantObj.GetGrantListById(reportChapterInfo.ReportChapterId)
  726. if tmpErr != nil {
  727. err = tmpErr
  728. return
  729. }
  730. // 当前章节已经授权的用户信息
  731. currChapterAdminMap := make(map[int]*report.ReportChapterGrant)
  732. // 需要删除的报告章节授权数据
  733. delChapterAdminMap := make(map[int]*report.ReportChapterGrant)
  734. for _, v := range chapterGrantList {
  735. currChapterAdminMap[v.AdminId] = v
  736. delChapterAdminMap[v.AdminId] = v
  737. }
  738. for _, adminId := range adminIdList {
  739. // 如果该用户 不在 报告授权的用户map 里面,说明这个用户是要移除的
  740. if _, ok := reportGrantAdminIdMap[adminId]; !ok {
  741. continue
  742. }
  743. _, ok := currChapterAdminMap[adminId]
  744. // 如果存在,那么从 “需要删除的报告章节授权数据” 的map中移除
  745. if ok {
  746. delete(delChapterAdminMap, adminId)
  747. continue
  748. }
  749. // 如果不存在,那么就新增授权
  750. addChapterAdminList = append(addChapterAdminList, &report.ReportChapterGrant{
  751. //GrantId: 0,
  752. ReportChapterId: reportChapterInfo.ReportChapterId,
  753. AdminId: adminId,
  754. CreateTime: time.Now(),
  755. })
  756. }
  757. // 查出需要移除的授权id
  758. for _, v := range delChapterAdminMap {
  759. delReportChapterGrantIdList = append(delReportChapterGrantIdList, v.GrantId)
  760. }
  761. }
  762. // 其他章节授权的用户
  763. otherChapterAdminMap := make(map[int]bool)
  764. {
  765. // 获取报告所有的章节id
  766. reportChapterIdList, tmpErr := models.GetReportChapterIdList(reportInfo.Id)
  767. if tmpErr != nil {
  768. err = tmpErr
  769. return
  770. }
  771. if len(reportChapterIdList) > 0 {
  772. list, tmpErr := chapterGrantObj.GetGrantListByIdList(reportChapterIdList)
  773. if tmpErr != nil {
  774. err = tmpErr
  775. return
  776. }
  777. for _, v := range list {
  778. // 如果是当前章节,因为涉及到重新授权,所以得过滤
  779. if v.ReportChapterId == reportChapterInfo.ReportChapterId {
  780. continue
  781. }
  782. otherChapterAdminMap[v.AdminId] = true
  783. }
  784. }
  785. }
  786. // 需要添加的报告章节品种权限数据
  787. addChapterPermissionList := make([]*report.ReportChapterPermissionMapping, 0)
  788. // 待移除的报告章节品种权限数据id
  789. delChapterPermissionMappingIdList := make([]int, 0)
  790. // 处理当前报告章节需要新增/移除的品种权限信息
  791. {
  792. // 获取当前章节已经配置的品种权限信息
  793. chapterPermissionList, tmpErr := chapterPermissionObj.GetPermissionListById(reportChapterInfo.ReportChapterId)
  794. if tmpErr != nil {
  795. err = tmpErr
  796. return
  797. }
  798. // 当前章节已经配置的品种权限信息
  799. currChapterPermissionMap := make(map[int]*report.ReportChapterPermissionMapping)
  800. // 需要删除的报告章节品种权限配置
  801. delChapterPermissionMap := make(map[int]*report.ReportChapterPermissionMapping)
  802. for _, v := range chapterPermissionList {
  803. currChapterPermissionMap[v.ChartPermissionId] = v
  804. delChapterPermissionMap[v.ChartPermissionId] = v
  805. }
  806. for _, permissionId := range permissionIdList {
  807. _, ok := currChapterPermissionMap[permissionId]
  808. // 如果存在,那么从 “需要删除的报告章节品种权限配置” 的map中移除
  809. if ok {
  810. delete(delChapterPermissionMap, permissionId)
  811. continue
  812. }
  813. // 如果不存在,那么就新增品种权限配置
  814. addChapterPermissionList = append(addChapterPermissionList, &report.ReportChapterPermissionMapping{
  815. //ReportChapterPermissionMappingId: 0,
  816. ReportChapterId: reportChapterInfo.ReportChapterId,
  817. ChartPermissionId: permissionId,
  818. CreateTime: time.Now(),
  819. })
  820. }
  821. // 查出需要移除的品种权限配置
  822. for _, v := range delChapterPermissionMap {
  823. delChapterPermissionMappingIdList = append(delChapterPermissionMappingIdList, v.ReportChapterPermissionMappingId)
  824. }
  825. }
  826. err = models.EditChapterBaseInfoAndPermission(reportInfo, reportChapterInfo, updateCols, addChapterAdminList, addChapterPermissionList, delReportChapterGrantIdList, delChapterPermissionMappingIdList)
  827. return
  828. }
  829. // DelChapter
  830. // @Description: 删除报告章节、授权用户权限、品种权限
  831. // @author: Roc
  832. // @datetime 2024-06-06 17:28:37
  833. // @param reportInfo *models.Report
  834. // @param reportChapterInfo *models.ReportChapter
  835. // @param sysUser *system.Admin
  836. // @return err error
  837. // @return errMsg string
  838. func DelChapter(reportInfo *models.Report, reportChapterInfo *models.ReportChapter, sysUser *system.Admin) (err error, errMsg string) {
  839. errMsg = "删除失败"
  840. if reportInfo.State == 2 {
  841. errMsg = "该报告已发布,不允许删除"
  842. err = errors.New(errMsg)
  843. return
  844. }
  845. reportInfo.LastModifyAdminId = sysUser.AdminId
  846. reportInfo.LastModifyAdminName = sysUser.RealName
  847. reportInfo.ModifyTime = time.Now()
  848. updateReportCols := []string{"LastModifyAdminId", "LastModifyAdminName", "ModifyTime"}
  849. err = models.DelChapterAndPermission(reportInfo, updateReportCols, reportChapterInfo)
  850. return
  851. }
  852. // DownloadVoice
  853. // @Description: 下载报告音频文件
  854. // @author: Roc
  855. // @datetime 2024-06-13 15:36:46
  856. // @param reportInfo *models.ReportDetail
  857. // @return savePath string
  858. // @return fileName string
  859. // @return err error
  860. // @return errMsg string
  861. func DownloadVoice(reportInfo *models.ReportDetail) (savePath, fileName string, err error, errMsg string) {
  862. errMsg = `下载失败`
  863. // 如果报告有音频,那么下载音频
  864. if reportInfo.VideoUrl != `` {
  865. savePath = time.Now().Format(utils.FormatDateTimeUnSpace) + utils.GetRandString(5) + ".mp3"
  866. fileName = reportInfo.VideoName + ".mp3"
  867. fileBody, tmpErr := http.Get(reportInfo.VideoUrl)
  868. if tmpErr != nil {
  869. err = tmpErr
  870. errMsg = "音频下载失败"
  871. return
  872. }
  873. err = file.SaveFile(fileBody, savePath)
  874. if err != nil {
  875. errMsg = "音频保存失败"
  876. return
  877. }
  878. }
  879. // 如果是章节报告,那么就下载压缩包
  880. if reportInfo.HasChapter == 1 {
  881. videoList, tmpErr := models.GetReportChapterVideoList(reportInfo.Id)
  882. if tmpErr != nil {
  883. err = tmpErr
  884. errMsg = "获取音频列表失败"
  885. return
  886. }
  887. if len(videoList) > 0 {
  888. // 创建zip
  889. savePath = time.Now().Format(utils.FormatDateTimeUnSpace) + utils.GetRandString(5) + ".zip"
  890. fileName = reportInfo.VideoName + ".zip"
  891. zipFile, tmpErr := os.Create(savePath)
  892. if tmpErr != nil {
  893. err = tmpErr
  894. return
  895. }
  896. zipWriter := zip.NewWriter(zipFile)
  897. // 生成zip过程中报错关闭
  898. defer func() {
  899. if err != nil {
  900. zipWriter.Close()
  901. zipFile.Close()
  902. }
  903. }()
  904. // 获取音频,写入zip
  905. for i := 0; i < len(videoList); i++ {
  906. item := videoList[i]
  907. if item.VideoName == "" || item.VideoUrl == "" {
  908. continue
  909. }
  910. // 音频文件后缀
  911. ext := path.Ext(item.VideoUrl)
  912. ioWriter, tmpErr := zipWriter.Create(fmt.Sprintf("%s%s", item.VideoName, ext))
  913. if tmpErr != nil {
  914. err = tmpErr
  915. if os.IsPermission(err) {
  916. fmt.Println("权限不足: ", err)
  917. return
  918. }
  919. return
  920. }
  921. var content []byte
  922. content, err = http.Get(item.VideoUrl)
  923. if err != nil {
  924. content = []byte("")
  925. }
  926. ioWriter.Write(content)
  927. }
  928. // 生成zip后关闭,否则下载文件会损坏
  929. zipWriter.Close()
  930. zipFile.Close()
  931. }
  932. }
  933. return
  934. }
  935. // CheckReportAuthByAdminIdList
  936. // @Description: 根据管理员id列表,判断当前用户是否有报告权限
  937. // @author: Roc
  938. // @datetime 2024-06-13 11:03:10
  939. // @param adminId int
  940. // @param createAdminId int
  941. // @param grantAdminIdList []int
  942. // @return isAuth bool
  943. func CheckReportAuthByAdminIdList(adminId, createAdminId int, grantAdminIdList []int) (isAuth bool) {
  944. // 如果是自己创建的报告,那么就有权限
  945. if adminId == createAdminId {
  946. isAuth = true
  947. return
  948. }
  949. // 如果是授权用户,那么就有权限
  950. if utils.IsCheckInList(grantAdminIdList, adminId) {
  951. isAuth = true
  952. return
  953. }
  954. return
  955. }
  956. // CheckReportAuthByReportId
  957. // @Description: 根据报告ID,判断当前用户是否有报告权限
  958. // @author: Roc
  959. // @datetime 2024-06-13 16:21:28
  960. // @param adminId int
  961. // @param reportInfoId int
  962. // @return isAuth bool
  963. // @return err error
  964. func CheckReportAuthByReportId(sysUser *system.Admin, createAdminId int, reportInfoId int) (isAuth bool, err error) {
  965. // 如果是自己创建的报告,那么就有权限
  966. if sysUser.AdminId == createAdminId {
  967. isAuth = true
  968. return
  969. }
  970. // 如果本人是超管,那么就有权限
  971. if utils.IsAdminRole(sysUser.RoleTypeCode) {
  972. isAuth = true
  973. return
  974. }
  975. obj := report.ReportGrant{}
  976. item, err := obj.GetGrantByIdAndAdmin(reportInfoId, sysUser.AdminId)
  977. if err != nil {
  978. // 如果是没找到数据,那么就是无权限
  979. if err.Error() == utils.ErrNoRow() {
  980. err = nil
  981. return
  982. }
  983. // sql报错了
  984. return
  985. }
  986. // 用户id一致就有权限
  987. if item.AdminId == sysUser.AdminId {
  988. isAuth = true
  989. }
  990. return
  991. }
  992. // EditReportLayoutImg
  993. // @Description: 修改报告的版图信息
  994. // @author: Roc
  995. // @datetime 2024-06-18 11:35:00
  996. // @param reportInfo *models.Report
  997. // @param req models.EditLayoutImgReq
  998. // @param sysUser *system.Admin
  999. // @return err error
  1000. // @return errMsg string
  1001. func EditReportLayoutImg(reportInfo *models.Report, req models.EditLayoutImgReq, sysUser *system.Admin) (err error, errMsg string) {
  1002. errMsg = `保存失败`
  1003. reportInfo.HeadResourceId = req.HeadResourceId
  1004. reportInfo.HeadImg = req.HeadImg
  1005. reportInfo.EndResourceId = req.EndResourceId
  1006. reportInfo.EndImg = req.EndImg
  1007. reportInfo.CanvasColor = req.CanvasColor
  1008. reportInfo.LastModifyAdminId = sysUser.AdminId
  1009. reportInfo.LastModifyAdminName = sysUser.RealName
  1010. reportInfo.ModifyTime = time.Now()
  1011. updateCols := []string{"HeadResourceId", "HeadImg", "EndResourceId", "EndImg", "CanvasColor", "LastModifyAdminId", "LastModifyAdminName", "ModifyTime"}
  1012. err = reportInfo.UpdateReport(updateCols)
  1013. if err != nil {
  1014. return
  1015. }
  1016. return
  1017. }
  1018. // PublishReport
  1019. // @Description: 报告发布
  1020. // @author: Roc
  1021. // @datetime 2024-06-20 09:44:13
  1022. // @param reportId int
  1023. // @param reportUrl string
  1024. // @param sysUser *system.Admin
  1025. // @return tips string
  1026. // @return err error
  1027. // @return errMsg string
  1028. func PublishReport(reportId int, reportUrl string, sysUser *system.Admin) (tips string, err error, errMsg string) {
  1029. errMsg = `报告发布失败`
  1030. reportInfo, err := models.GetReportByReportId(reportId)
  1031. if err != nil {
  1032. errMsg = "获取报告信息失败"
  1033. return
  1034. }
  1035. if reportInfo == nil {
  1036. errMsg = "获取报告信息失败"
  1037. err = errors.New(errMsg)
  1038. return
  1039. }
  1040. var publishTime time.Time
  1041. if reportInfo.MsgIsSend == 1 && reportInfo.PublishTime.IsZero() { //如果报告曾经发布过,并且已经发送过模版消息,则章节的发布时间为报告的发布时间
  1042. publishTime = reportInfo.PublishTime
  1043. } else {
  1044. publishTime = time.Now()
  1045. }
  1046. var tmpErr error
  1047. // 章节类型的报告(原来的晨周报)
  1048. if reportInfo.HasChapter == 1 {
  1049. tips, tmpErr, errMsg = PublishChapterReport(reportInfo, reportUrl, sysUser)
  1050. if tmpErr != nil {
  1051. err = errors.New("晨周报发布失败, Err:" + tmpErr.Error() + ", report_id:" + strconv.Itoa(reportId))
  1052. }
  1053. return
  1054. }
  1055. // 普通报告
  1056. if reportInfo.Content == "" {
  1057. errMsg = `报告内容为空,不可发布`
  1058. err = errors.New("报告内容为空,不需要生成,report_id:" + strconv.Itoa(reportId))
  1059. return
  1060. }
  1061. // 根据审批开关及审批流判断当前报告状态
  1062. state, e := CheckReportCurrState(report_approve.FlowReportTypeChinese, reportInfo.ClassifyIdFirst, reportInfo.ClassifyIdSecond, reportInfo.ClassifyIdThird, models.ReportOperatePublish)
  1063. if e != nil {
  1064. errMsg = "操作失败"
  1065. err = errors.New("校验报告当前状态失败, Err: " + e.Error())
  1066. return
  1067. }
  1068. if state == models.ReportStatePublished {
  1069. // 发布报告
  1070. if tmpErr = models.PublishReportById(reportId, publishTime, sysUser.AdminId, sysUser.RealName); tmpErr != nil {
  1071. err = errors.New("报告发布失败, Err:" + tmpErr.Error() + ", report_id:" + strconv.Itoa(reportId))
  1072. return
  1073. }
  1074. go func() {
  1075. // 生成音频
  1076. if reportInfo.VideoUrl == "" {
  1077. go UpdateReportVideo(reportInfo)
  1078. }
  1079. // 更新报告Es
  1080. _ = UpdateReportEs(reportId, 2)
  1081. }()
  1082. } else {
  1083. // 从无审批切换为有审批, 状态重置
  1084. if e = models.ResetReportById(reportId, state, sysUser.AdminId, sysUser.RealName); e != nil {
  1085. errMsg = "操作失败"
  1086. err = fmt.Errorf("重置报告状态失败, Err: %s, ReportId: %d", e.Error(), reportId)
  1087. return
  1088. }
  1089. }
  1090. recordItem := &models.ReportStateRecord{
  1091. ReportId: reportId,
  1092. ReportType: 1,
  1093. State: state,
  1094. AdminId: sysUser.AdminId,
  1095. AdminName: sysUser.AdminName,
  1096. CreateTime: time.Now(),
  1097. }
  1098. go func() {
  1099. _, _ = models.AddReportStateRecord(recordItem)
  1100. }()
  1101. // 生成报告pdf和长图
  1102. {
  1103. reportPdfUrl := GetGeneralPdfUrl(reportInfo.ReportCode, reportInfo.ClassifyNameFirst, reportInfo.ReportLayout)
  1104. go Report2pdfAndJpeg(reportPdfUrl, reportId, 1)
  1105. }
  1106. // 报告权限处理
  1107. {
  1108. minClassifyId, _, tmpErr := getMinClassify(reportInfo)
  1109. if tmpErr != nil {
  1110. return
  1111. }
  1112. go handleReportPermission(int64(reportInfo.Id), minClassifyId)
  1113. }
  1114. return
  1115. }
  1116. // PublishChapterReport
  1117. // @Description: 发布章节类型的报告
  1118. // @author: Roc
  1119. // @datetime 2024-06-28 10:38:50
  1120. // @param reportInfo *models.Report
  1121. // @param reportUrl string
  1122. // @return tips string
  1123. // @return err error
  1124. // @return errMsg string
  1125. func PublishChapterReport(reportInfo *models.Report, reportUrl string, sysUser *system.Admin) (tips string, err error, errMsg string) {
  1126. reportId := reportInfo.Id
  1127. if reportInfo.State == 2 {
  1128. return
  1129. }
  1130. // 获取所有章节列表
  1131. chapters, err := models.GetChapterListByReportId(reportId)
  1132. if err != nil {
  1133. return
  1134. }
  1135. chapterLen := len(chapters)
  1136. if chapterLen <= 0 {
  1137. tips = "报告章节为空,不可发布"
  1138. errMsg = tips
  1139. err = errors.New(tips)
  1140. return
  1141. }
  1142. // 获取报告中的所有章节列表
  1143. chapterList, err := models.GetChapterListByReportId(reportId)
  1144. if err != nil {
  1145. return
  1146. }
  1147. for _, chapter := range chapterList {
  1148. if chapter.PublishState == 1 {
  1149. tips = "还存在未发布的章节"
  1150. errMsg = tips
  1151. err = errors.New(tips)
  1152. return
  1153. }
  1154. }
  1155. // 根据审批开关及审批流判断当前报告状态
  1156. state, e := CheckReportCurrState(report_approve.FlowReportTypeChinese, reportInfo.ClassifyIdFirst, reportInfo.ClassifyIdSecond, reportInfo.ClassifyIdThird, models.ReportOperatePublish)
  1157. if e != nil {
  1158. //errMsg = "操作失败"
  1159. err = errors.New("校验报告当前状态失败, Err: " + e.Error())
  1160. return
  1161. }
  1162. // 如果状态不是已发布,那么就重置状态
  1163. if state != models.ReportStatePublished {
  1164. // 从无审批切换为有审批, 状态重置
  1165. if e = models.ResetReportById(reportId, state, sysUser.AdminId, sysUser.RealName); e != nil {
  1166. //errMsg = "操作失败"
  1167. err = fmt.Errorf("重置报告状态失败, Err: %s, ReportId: %d", e.Error(), reportId)
  1168. return
  1169. }
  1170. return
  1171. }
  1172. // 需发布整期
  1173. updateCols := make([]string, 0)
  1174. reportInfo.LastModifyAdminId = sysUser.AdminId
  1175. reportInfo.LastModifyAdminName = sysUser.RealName
  1176. updateCols = append(updateCols, "LastModifyAdminId", "LastModifyAdminName", "Title", "State", "ModifyTime")
  1177. // 发布后标题调整
  1178. //title := reportInfo.Title
  1179. //title = strings.ReplaceAll(title, "【弘则FICC晨报】", "")
  1180. //title = strings.ReplaceAll(title, "【弘则FICC周报】", "")
  1181. //if title == "" {
  1182. // // 取第一个需发布章节的标题
  1183. // firstId := publishIdArr[0]
  1184. // firstTitle := ""
  1185. // for i := 0; i < chapterLen; i++ {
  1186. // if chapters[i].ReportChapterId == firstId {
  1187. // firstTitle = chapters[i].Title
  1188. // break
  1189. // }
  1190. // }
  1191. // title = firstTitle
  1192. //}
  1193. //report.Title = title
  1194. reportInfo.State = state
  1195. // 研报后台4.4 只在没有发布过时更新发布时间,其余均按模版消息发送时间当作发布时间
  1196. if reportInfo.MsgIsSend == 0 || reportInfo.PublishTime.IsZero() {
  1197. reportInfo.PublishTime = time.Now().Local()
  1198. updateCols = append(updateCols, "PublishTime")
  1199. }
  1200. reportInfo.ModifyTime = time.Now().Local()
  1201. if e := models.PublishReportAndChapter(reportInfo, true, updateCols); e != nil {
  1202. err = errors.New("发布报告及章节失败")
  1203. return
  1204. }
  1205. // 生成章节音频
  1206. go UpdateReportVideo(reportInfo)
  1207. // 更新报告ES
  1208. go func() {
  1209. _ = UpdateReportEs(reportInfo.Id, 2)
  1210. }()
  1211. // 发布时备份内容
  1212. go SaveReportLogs(reportInfo, chapters, reportInfo.AdminId, reportInfo.AdminRealName)
  1213. // 生成报告pdf和长图
  1214. {
  1215. reportPdfUrl := GetGeneralPdfUrl(reportInfo.ReportCode, reportInfo.ClassifyNameFirst, reportInfo.ReportLayout)
  1216. go Report2pdfAndJpeg(reportPdfUrl, reportId, 1)
  1217. }
  1218. return
  1219. }
  1220. // DeleteReportAndChapter 删除报告及章节
  1221. func DeleteReportAndChapter(reportId int) (err error) {
  1222. reportInfo, err := models.GetReportByReportId(reportId)
  1223. if err != nil {
  1224. err = errors.New("报告信息有误, Err: " + err.Error())
  1225. return
  1226. }
  1227. if reportInfo.State == 2 {
  1228. err = errors.New("报告已发布,不可删除")
  1229. return
  1230. }
  1231. // 更新ES
  1232. _ = UpdateReportEs(reportId, 1)
  1233. // 删除
  1234. if reportInfo.HasChapter == 1 {
  1235. err = models.DeleteDayWeekReportAndChapter(reportId)
  1236. } else {
  1237. err = models.DeleteReport(reportId)
  1238. }
  1239. if err != nil {
  1240. err = errors.New("删除失败, Err: " + err.Error())
  1241. return
  1242. }
  1243. // 重置PPT关联报告
  1244. go func() {
  1245. _ = ResetPPTReport(reportId, false)
  1246. }()
  1247. return
  1248. }
  1249. // getMinClassify
  1250. // @Description: 获取最小分类ID
  1251. // @author: Roc
  1252. // @datetime 2024-06-20 09:23:19
  1253. // @param reportInfo *models.Report
  1254. // @return minClassifyId int
  1255. // @return minClassifyName string
  1256. // @return err error
  1257. func getMinClassify(reportInfo *models.Report) (minClassifyId int, minClassifyName string, err error) {
  1258. defer func() {
  1259. if err != nil {
  1260. utils.FileLog.Error("获取最小分类ID失败,报告ID:%d,Err:%s", reportInfo.Id, err.Error())
  1261. }
  1262. }()
  1263. minClassifyId = reportInfo.ClassifyIdThird
  1264. minClassifyName = reportInfo.ClassifyNameThird
  1265. if minClassifyId <= 0 {
  1266. minClassifyId = reportInfo.ClassifyIdSecond
  1267. minClassifyName = reportInfo.ClassifyNameSecond
  1268. }
  1269. if minClassifyId <= 0 {
  1270. minClassifyId = reportInfo.ClassifyIdFirst
  1271. minClassifyName = reportInfo.ClassifyNameFirst
  1272. }
  1273. if minClassifyId <= 0 {
  1274. err = errors.New("分类异常")
  1275. }
  1276. return
  1277. }
  1278. // handleReportPermission
  1279. // @Description: 报告权限处理
  1280. // @author: Roc
  1281. // @datetime 2024-06-19 18:00:51
  1282. // @param reportId int64
  1283. // @param minClassifyId int
  1284. func handleReportPermission(reportId int64, minClassifyId int) {
  1285. // TODO 报告权限处理
  1286. var err error
  1287. defer func() {
  1288. if err != nil {
  1289. utils.FileLog.Error("报告权限处理失败,报告ID:%d,分类ID:%d,Err:%s", reportId, minClassifyId, err.Error())
  1290. //alarm_msg.SendAlarmMsg("修改删除报告权限失败,Err:"+err.Error(), 3)
  1291. }
  1292. }()
  1293. err = models.RemoveChartPermissionChapterMapping(reportId)
  1294. if err != nil {
  1295. err = errors.New("修改删除报告权限失败,Err:" + err.Error())
  1296. return
  1297. }
  1298. permissionItems, err := models.GetPermission(minClassifyId)
  1299. if err != nil {
  1300. err = errors.New("获取权限失败,Err:" + err.Error())
  1301. return
  1302. }
  1303. for _, v := range permissionItems {
  1304. err = models.AddChartPermissionChapterMapping(v.ChartPermissionId, reportId)
  1305. if err != nil {
  1306. err = errors.New("新增权限失败,Err:" + err.Error())
  1307. return
  1308. }
  1309. }
  1310. // 同步crm权限
  1311. _ = EditReportPermissionSync(reportId, minClassifyId)
  1312. return
  1313. }
  1314. // handlerReportTableReferenced
  1315. // @Description: 继承报告后,需要同时继承原来报告中表格的拖动数据逻辑
  1316. // @author: Roc
  1317. // @datetime 2025-01-09 15:35:55
  1318. // @param reportInfo *models.Report
  1319. func handlerReportTableReferenced(reportInfo *models.Report) {
  1320. var err error
  1321. defer func() {
  1322. if err != nil {
  1323. utils.FileLog.Error("报告表关联处理失败,旧报告ID:%d,新报告ID:%d,Err:%s", reportInfo.InheritReportId, reportInfo.Id, err.Error())
  1324. }
  1325. }()
  1326. addList, err := excel.CopyReferencedExcelConfigByReferencedIdAndFromScene(reportInfo.InheritReportId, utils.TableReferencedByReport, reportInfo.Id, utils.TableReferencedByReport, reportInfo.AdminId, reportInfo.AdminRealName)
  1327. if err != nil {
  1328. return
  1329. }
  1330. if len(addList) > 0 {
  1331. // 修改内容
  1332. reportInfo.Content = HandleReportContentTable(reportInfo.Id, reportInfo.Content)
  1333. reportInfo.ContentStruct = HandleReportContentStructTable(reportInfo.Id, reportInfo.ContentStruct)
  1334. err = reportInfo.Update([]string{"Content", "ContentStruct"})
  1335. if err != nil {
  1336. return
  1337. }
  1338. if reportInfo.HasChapter == 1 {
  1339. chapterList, tmpErr := models.GetChapterListByReportId(reportInfo.Id)
  1340. if tmpErr != nil {
  1341. err = tmpErr
  1342. return
  1343. }
  1344. for _, v := range chapterList {
  1345. v.Content = HandleReportContentTable(reportInfo.Id, v.Content)
  1346. v.ContentStruct = HandleReportContentStructTable(reportInfo.Id, v.ContentStruct)
  1347. err = v.Update([]string{"Content", "ContentStruct"})
  1348. if err != nil {
  1349. return
  1350. }
  1351. }
  1352. }
  1353. }
  1354. }
  1355. // HandleReportPermission
  1356. // @Description: 报告权限处理
  1357. // @author: Roc
  1358. // @datetime 2024-07-12 11:17:49
  1359. // @param reportInfo *models.Report
  1360. func HandleReportPermission(reportInfo *models.Report) {
  1361. minClassifyId, _, tmpErr := getMinClassify(reportInfo)
  1362. if tmpErr != nil {
  1363. return
  1364. }
  1365. handleReportPermission(int64(reportInfo.Id), minClassifyId)
  1366. }
  1367. // UpdateReportVideo
  1368. // @Description: 更新报告音频
  1369. // @author: Roc
  1370. // @datetime 2024-07-17 18:11:10
  1371. // @param reportInfo *models.Report
  1372. func UpdateReportVideo(reportInfo *models.Report) {
  1373. if reportInfo.HasChapter == 1 {
  1374. reportChapterIdList := make([]int, 0)
  1375. // 获取报告中的所有章节列表
  1376. chapterList, err := models.GetChapterListByReportId(reportInfo.Id)
  1377. if err != nil {
  1378. return
  1379. }
  1380. reportContent := ""
  1381. for _, chapter := range chapterList {
  1382. if chapter.PublishState == 2 {
  1383. reportChapterIdList = append(reportChapterIdList, chapter.ReportChapterId)
  1384. reportContent += chapter.Title + `。`
  1385. reportContent += chapter.Content + `。`
  1386. }
  1387. }
  1388. if len(reportChapterIdList) > 0 {
  1389. err = UpdateChaptersVideo(reportChapterIdList)
  1390. if err != nil {
  1391. utils.FileLog.Info(fmt.Sprintf("%d报告音频生产失败:%s", reportInfo.Id, err.Error()))
  1392. }
  1393. }
  1394. // 生成汇总音频
  1395. {
  1396. if reportInfo.VideoUrl != "" && reportInfo.VideoName != "" && reportInfo.VideoSize != "" && reportInfo.VideoPlaySeconds != "" {
  1397. return
  1398. }
  1399. weekClassifyId, err := company.GetReportClassifyIdByConfigKey("report_week_classify_id")
  1400. if err != nil && err.Error() != utils.ErrNoRow() {
  1401. msg := "获取周报ID配置失败:" + err.Error()
  1402. utils.FileLog.Info(msg)
  1403. return
  1404. }
  1405. if reportInfo.ClassifyIdFirst == weekClassifyId {
  1406. return
  1407. }
  1408. videoUrl, videoName, videoSize, videoPlaySeconds, e := CreateReportVideo(reportInfo.Title, html.UnescapeString(reportContent), time.Now().Format(utils.FormatDateTime))
  1409. if e != nil {
  1410. err = e
  1411. return
  1412. }
  1413. // 修改报告的音频信息
  1414. err = models.ModifyReportVideoByNoVideo(reportInfo.Id, videoUrl, videoName, videoSize, videoPlaySeconds)
  1415. }
  1416. } else {
  1417. err := CreateVideo(reportInfo)
  1418. if err != nil {
  1419. utils.FileLog.Info(fmt.Sprintf("%d报告音频生产失败:%s", reportInfo.Id, err.Error()))
  1420. }
  1421. }
  1422. }
  1423. // GetGeneralPdfUrl
  1424. // @Description: 获取生成pdf的地址
  1425. // @author: Roc
  1426. // @datetime 2024-07-19 14:09:28
  1427. // @param reportCode string
  1428. // @param reportLayout int8
  1429. // @return pdfUrl string
  1430. func GetGeneralPdfUrl(reportCode, classifyFirstName string, reportLayout int8) (pdfUrl string) {
  1431. // 如果是弘则,且是晨、周报,那么就不返回
  1432. if utils.InArrayByStr([]string{utils.BusinessCodeRelease, utils.BusinessCodeSandbox, utils.BusinessCodeDebug}, utils.BusinessCode) && utils.InArrayByStr([]string{"晨报", "周报"}, classifyFirstName) {
  1433. return
  1434. }
  1435. // 优先取Report2ImgUrl(用于兼容内外网环境的), 没有的话取报告详情地址
  1436. var reportUrl string
  1437. conf, _ := models.GetBusinessConfByKey(models.BusinessConfReport2ImgUrl)
  1438. if conf != nil && conf.ConfVal != "" {
  1439. reportUrl = conf.ConfVal
  1440. }
  1441. if reportUrl == "" {
  1442. conf, e := models.GetBusinessConfByKey(models.BusinessConfReportViewUrl)
  1443. if e != nil {
  1444. return
  1445. }
  1446. reportUrl = conf.ConfVal
  1447. }
  1448. switch reportLayout {
  1449. case 1:
  1450. // 普通布局
  1451. pdfUrl = fmt.Sprintf("%s/reportshare_pdf?code=%s", reportUrl, reportCode)
  1452. case 2:
  1453. // 智能布局
  1454. pdfUrl = fmt.Sprintf("%s/reportshare_smart_pdf?code=%s", reportUrl, reportCode)
  1455. }
  1456. return
  1457. }
  1458. func GetReportWaterMarkPdf(reportInfo *models.Report, sysUser *system.Admin) {
  1459. dateDir := time.Now().Format("20060102")
  1460. uploadDir := utils.STATIC_DIR + "pdf/" + dateDir
  1461. filePath, err := utils.DownloadFile(reportInfo.DetailPdfUrl, uploadDir)
  1462. if err != nil {
  1463. return
  1464. }
  1465. // 移除临时Pdf文件
  1466. defer func() {
  1467. _ = os.Remove(filePath)
  1468. }()
  1469. waterMarkStr := fmt.Sprintf("%s - %s", sysUser.RealName, sysUser.Mobile)
  1470. GeneralWaterMarkPdf(filePath, waterMarkStr)
  1471. }
  1472. // ResetMiniProgramReportDetailCover 重置小程序报告封面
  1473. func ResetMiniProgramReportDetailCover(reportId int) (err error) {
  1474. if utils.MYSQL_WEEKLY_URL == `` {
  1475. return
  1476. }
  1477. defer func() {
  1478. if err != nil {
  1479. tips := fmt.Sprintf("ResetMiniProgramReportDetailCover-重置小程序报告封面失败, %v", err)
  1480. utils.FileLog.Info(tips)
  1481. alarm_msg.SendAlarmMsg(tips, 2)
  1482. }
  1483. }()
  1484. ob := new(yb.YbPosterResource)
  1485. cond := fmt.Sprintf(` AND path LIKE 'reportDetailCover?ReportId=%d&%%'`, reportId)
  1486. pars := make([]interface{}, 0)
  1487. list, e := ob.GetItemsByCondition(cond, pars, []string{"id"}, "")
  1488. if e != nil {
  1489. err = fmt.Errorf("获取报告海报失败, %v", e)
  1490. return
  1491. }
  1492. if len(list) == 0 {
  1493. return
  1494. }
  1495. var removeIds []int
  1496. for _, v := range list {
  1497. removeIds = append(removeIds, v.Id)
  1498. }
  1499. if e = ob.RemovePosters(removeIds); e != nil {
  1500. err = fmt.Errorf("清除报告海报失败, %v", e)
  1501. }
  1502. return
  1503. }
  1504. // HandleReportContentTable
  1505. // @Description: 处理报告内容(动态表格添加报告来源id)(跟另一个需求代码冲突了,不好处理,只能额外写个方法出来使用了)
  1506. // @author: Roc
  1507. // @datetime 2025-01-09 13:25:41
  1508. // @param reportId int
  1509. // @param body string
  1510. // @return newBody string
  1511. func HandleReportContentTable(reportId int, body string) (newBody string) {
  1512. if body == `` {
  1513. return
  1514. }
  1515. newBody = body
  1516. // 解析HTML
  1517. doc, err := html2.Parse(strings.NewReader(body))
  1518. if err != nil {
  1519. fmt.Println("Error parsing HTML:", err)
  1520. return
  1521. }
  1522. replaceIframeSrcTable(doc, reportId, 0)
  1523. // 输出修改后的HTML
  1524. var modifiedHtml strings.Builder
  1525. err = html2.Render(&modifiedHtml, doc)
  1526. if err != nil {
  1527. fmt.Println("Error rendering HTML:", err)
  1528. return
  1529. }
  1530. newBody = modifiedHtml.String()
  1531. fmt.Println(newBody)
  1532. return
  1533. }
  1534. // HandleReportContentTableAndScene
  1535. // @Description: 处理报告内容(动态表格添加报告来源id)(跟另一个需求代码冲突了,不好处理,只能额外写个方法出来使用了)
  1536. // @author: Roc
  1537. // @datetime 2025-01-10 10:15:39
  1538. // @param reportId int
  1539. // @param fromScene int
  1540. // @param body string
  1541. // @return newBody string
  1542. func HandleReportContentTableAndScene(reportId, fromScene int, body string) (newBody string) {
  1543. if body == `` {
  1544. return
  1545. }
  1546. newBody = body
  1547. // 解析HTML
  1548. doc, err := html2.Parse(strings.NewReader(body))
  1549. if err != nil {
  1550. fmt.Println("Error parsing HTML:", err)
  1551. return
  1552. }
  1553. replaceIframeSrcTable(doc, reportId, fromScene)
  1554. // 输出修改后的HTML
  1555. var modifiedHtml strings.Builder
  1556. err = html2.Render(&modifiedHtml, doc)
  1557. if err != nil {
  1558. fmt.Println("Error rendering HTML:", err)
  1559. return
  1560. }
  1561. newBody = modifiedHtml.String()
  1562. return
  1563. }
  1564. // replaceIframeSrc 遍历HTML节点,替换iframe的src属性
  1565. func replaceIframeSrcTable(n *html2.Node, reportId, fromScene int) {
  1566. if n.Type == html2.ElementNode && n.Data == "iframe" {
  1567. for i, attr := range n.Attr {
  1568. if attr.Key == "src" {
  1569. newLink := handleTableLinkReportId(attr.Val, reportId, fromScene)
  1570. // 替换原来的链接
  1571. n.Attr[i].Val = newLink
  1572. break
  1573. }
  1574. }
  1575. }
  1576. // 递归处理子节点
  1577. for c := n.FirstChild; c != nil; c = c.NextSibling {
  1578. replaceIframeSrcTable(c, reportId, fromScene)
  1579. }
  1580. }
  1581. // handleTableLinkReportId 链接添加token
  1582. func handleTableLinkReportId(link string, reportId, fromScene int) string {
  1583. var err error
  1584. defer func() {
  1585. if err != nil {
  1586. utils.FileLog.Info("处理链接失败,ERR:" + err.Error())
  1587. }
  1588. }()
  1589. if link == `` {
  1590. return link
  1591. }
  1592. parsedURL, err := url.Parse(link)
  1593. if err != nil {
  1594. return link
  1595. }
  1596. // 获取查询参数
  1597. queryParams := parsedURL.Query()
  1598. // 先移除sourceId参数,避免莫名其妙的这个值入库了
  1599. queryParams.Del("sourceId")
  1600. queryParams.Add("sourceId", fmt.Sprint(reportId))
  1601. if fromScene > 0 {
  1602. queryParams.Del("fromScene")
  1603. queryParams.Add("fromScene", fmt.Sprint(fromScene))
  1604. }
  1605. // 更新URL的查询参数
  1606. parsedURL.RawQuery = queryParams.Encode()
  1607. // 在链接后面添加一个来源值
  1608. return parsedURL.String()
  1609. }
  1610. // HandleReportContentStructTable
  1611. // @Description: 处理内容组件的表格链接(跟另一个需求代码冲突了,不好处理,只能额外写个方法出来使用了)
  1612. // @author: Roc
  1613. // @datetime 2025-01-09 13:40:35
  1614. // @param reportId int
  1615. // @param body string
  1616. // @return newBody string
  1617. func HandleReportContentStructTable(reportId int, body string) (newBody string) {
  1618. if body == `` {
  1619. return
  1620. }
  1621. newBody = body
  1622. // 解析JSON数据到map[string]interface{}
  1623. var jsonData []map[string]interface{}
  1624. if err := json.Unmarshal([]byte(body), &jsonData); err != nil {
  1625. fmt.Println("Error parsing JSON:", err)
  1626. return
  1627. }
  1628. // 处理每个组件
  1629. for i := range jsonData {
  1630. if err := processMapTable(jsonData[i], reportId, 0); err != nil {
  1631. fmt.Println("Error processing component:", err)
  1632. return
  1633. }
  1634. }
  1635. // 将处理后的数据转换回JSON字符串
  1636. //modifiedJSON, err := json.MarshalIndent(jsonData, "", " ")
  1637. modifiedJSON, err := json.Marshal(jsonData)
  1638. if err != nil {
  1639. fmt.Println("Error marshaling JSON:", err)
  1640. return
  1641. }
  1642. newBody = string(modifiedJSON)
  1643. return
  1644. }
  1645. // HandleReportContentStructTableAndScene
  1646. // @Description: 处理内容组件的表格链接,需要处理来源(跟另一个需求代码冲突了,不好处理,只能额外写个方法出来使用了)
  1647. // @author: Roc
  1648. // @datetime 2025-01-09 13:40:35
  1649. // @param reportId int
  1650. // @param body string
  1651. // @return newBody string
  1652. func HandleReportContentStructTableAndScene(reportId, fromScene int, body string) (newBody string) {
  1653. if body == `` {
  1654. return
  1655. }
  1656. newBody = body
  1657. // 解析JSON数据到map[string]interface{}
  1658. var jsonData []map[string]interface{}
  1659. if err := json.Unmarshal([]byte(body), &jsonData); err != nil {
  1660. fmt.Println("Error parsing JSON:", err)
  1661. return
  1662. }
  1663. // 处理每个组件
  1664. for i := range jsonData {
  1665. if err := processMapTable(jsonData[i], reportId, 0); err != nil {
  1666. fmt.Println("Error processing component:", err)
  1667. return
  1668. }
  1669. }
  1670. // 将处理后的数据转换回JSON字符串
  1671. modifiedJSON, err := json.MarshalIndent(jsonData, "", " ")
  1672. if err != nil {
  1673. fmt.Println("Error marshaling JSON:", err)
  1674. return
  1675. }
  1676. newBody = string(modifiedJSON)
  1677. return
  1678. }
  1679. // processMapTable 递归处理map中的content字段
  1680. func processMapTable(data map[string]interface{}, reportId, fromScene int) error {
  1681. for key, value := range data {
  1682. switch v := value.(type) {
  1683. case string:
  1684. if key == "content" {
  1685. contentSource, ok := data["compType"]
  1686. if !ok {
  1687. continue
  1688. }
  1689. contentSourceType, ok := contentSource.(string)
  1690. if !ok {
  1691. continue
  1692. }
  1693. if !utils.InArrayByStr([]string{`sheet`, `chart`}, contentSourceType) {
  1694. continue
  1695. }
  1696. newContent := handleTableLinkReportId(v, reportId, fromScene)
  1697. data[key] = newContent
  1698. }
  1699. case map[string]interface{}:
  1700. if err := processMapTable(v, reportId, fromScene); err != nil {
  1701. return err
  1702. }
  1703. case []interface{}:
  1704. for i := range v {
  1705. if m, ok := v[i].(map[string]interface{}); ok {
  1706. if err := processMapTable(m, reportId, fromScene); err != nil {
  1707. return err
  1708. }
  1709. }
  1710. }
  1711. }
  1712. }
  1713. return nil
  1714. }
  1715. // HandleReportContent
  1716. // @Description: 处理报告内容(动态图表/表格添加授权token)
  1717. // @author: Roc
  1718. // @datetime 2025-01-07 10:03:15
  1719. // @param body string
  1720. // @return newBody string
  1721. func HandleReportContent(body string, opType string, tokenMap map[string]string) (newBody string) {
  1722. if body == `` {
  1723. return
  1724. }
  1725. newBody = body
  1726. // 解析HTML
  1727. doc, err := html2.Parse(strings.NewReader(body))
  1728. if err != nil {
  1729. fmt.Println("Error parsing HTML:", err)
  1730. return
  1731. }
  1732. replaceIframeSrc(doc, opType, tokenMap)
  1733. // 输出修改后的HTML
  1734. var modifiedHtml strings.Builder
  1735. err = html2.Render(&modifiedHtml, doc)
  1736. if err != nil {
  1737. fmt.Println("Error rendering HTML:", err)
  1738. return
  1739. }
  1740. newBody = modifiedHtml.String()
  1741. fmt.Println(newBody)
  1742. return
  1743. }
  1744. // replaceIframeSrc 遍历HTML节点,替换iframe的src属性
  1745. func replaceIframeSrc(n *html2.Node, opType string, tokenMap map[string]string) {
  1746. if n.Type == html2.ElementNode && n.Data == "iframe" {
  1747. for i, attr := range n.Attr {
  1748. if attr.Key == "src" {
  1749. newLink := attr.Val
  1750. // 处理链接
  1751. switch opType {
  1752. case `add`:
  1753. newLink = linkAddToken(attr.Val, tokenMap)
  1754. case `del`:
  1755. newLink = linkDelToken(attr.Val)
  1756. }
  1757. // 替换原来的链接
  1758. n.Attr[i].Val = newLink
  1759. break
  1760. }
  1761. }
  1762. }
  1763. // 递归处理子节点
  1764. for c := n.FirstChild; c != nil; c = c.NextSibling {
  1765. replaceIframeSrc(c, opType, tokenMap)
  1766. }
  1767. }
  1768. // linkAddToken 链接添加token
  1769. func linkAddToken(link string, tokenMap map[string]string) string {
  1770. var err error
  1771. defer func() {
  1772. if err != nil {
  1773. utils.FileLog.Info("处理链接失败,ERR:" + err.Error())
  1774. }
  1775. }()
  1776. if link == `` {
  1777. return link
  1778. }
  1779. parsedURL, err := url.Parse(link)
  1780. if err != nil {
  1781. return link
  1782. }
  1783. // 获取查询参数
  1784. queryParams := parsedURL.Query()
  1785. // 先移除authToken参数,避免莫名其妙的这个值入库了
  1786. queryParams.Del("authToken")
  1787. // 获取code参数
  1788. code := queryParams.Get("code")
  1789. if code == "" {
  1790. return link
  1791. }
  1792. showType := `chart`
  1793. if strings.Contains(parsedURL.Path, "sheetshow") {
  1794. showType = `excel`
  1795. }
  1796. // 避免报告里面一个图表/表格重复生成token
  1797. key := fmt.Sprint(showType, `:`, code)
  1798. if tokenMap != nil {
  1799. if token, ok := tokenMap[key]; ok {
  1800. // 在链接后面添加一个token值
  1801. return link + "&authToken=" + token
  1802. }
  1803. }
  1804. token, err := GeneralChartToken(showType, code)
  1805. if err != nil {
  1806. return link
  1807. }
  1808. if tokenMap != nil {
  1809. tokenMap[key] = token
  1810. }
  1811. // 在链接后面添加一个token值
  1812. return link + "&authToken=" + token
  1813. }
  1814. // linkDelToken 链接添加token
  1815. func linkDelToken(link string) string {
  1816. var err error
  1817. defer func() {
  1818. if err != nil {
  1819. utils.FileLog.Info("处理链接失败,ERR:" + err.Error())
  1820. }
  1821. }()
  1822. parsedURL, err := url.Parse(link)
  1823. if err != nil {
  1824. return link
  1825. }
  1826. // 获取查询参数
  1827. queryParams := parsedURL.Query()
  1828. // 移除authToken参数
  1829. queryParams.Del("authToken")
  1830. // 更新URL的查询参数
  1831. parsedURL.RawQuery = queryParams.Encode()
  1832. return parsedURL.String()
  1833. }
  1834. // GeneralChartToken
  1835. // @Description: 生成图表/表格授权token
  1836. // @author: Roc
  1837. // @datetime 2025-01-07 10:41:36
  1838. // @param showType string
  1839. // @param uniqueCode string
  1840. // @return token string
  1841. // @return err error
  1842. func GeneralChartToken(showType, uniqueCode string) (token string, err error) {
  1843. // 缓存key
  1844. token = utils.MD5(fmt.Sprint(showType+`:`, uniqueCode, time.Now().UnixNano()/1e6))
  1845. key := fmt.Sprint(utils.CACHE_CHART_AUTH, token)
  1846. err = utils.Rc.Put(key, uniqueCode, utils.BusinessConfReportChartExpiredTime)
  1847. return
  1848. }
  1849. // GeneralReportToken
  1850. // @Description: 生成报告授权token
  1851. // @author: Roc
  1852. // @datetime 2025-01-07 10:41:36
  1853. // @param uniqueCode string
  1854. // @return token string
  1855. // @return err error
  1856. func GeneralReportToken(uniqueCode string) (token string, err error) {
  1857. // 缓存key
  1858. token = utils.MD5(fmt.Sprint(uniqueCode, time.Now().UnixNano()/1e6))
  1859. key := fmt.Sprint(utils.CACHE_REPORT_AUTH, token)
  1860. err = utils.Rc.Put(key, uniqueCode, utils.BusinessConfReportChartExpiredTime)
  1861. return
  1862. }
  1863. // HandleReportContentStruct
  1864. // @Description: 处理内容组件的链接
  1865. // @author: Roc
  1866. // @datetime 2025-01-07 13:38:39
  1867. // @param body string
  1868. // @param opType string
  1869. // @return newBody string
  1870. func HandleReportContentStruct(body string, opType string, tokenMap map[string]string) (newBody string) {
  1871. if body == `` {
  1872. return
  1873. }
  1874. newBody = body
  1875. // 解析JSON数据到map[string]interface{}
  1876. var jsonData []map[string]interface{}
  1877. if err := json.Unmarshal([]byte(body), &jsonData); err != nil {
  1878. fmt.Println("Error parsing JSON:", err)
  1879. return
  1880. }
  1881. // 处理每个组件
  1882. for i := range jsonData {
  1883. if err := processMap(jsonData[i], opType, tokenMap); err != nil {
  1884. fmt.Println("Error processing component:", err)
  1885. return
  1886. }
  1887. }
  1888. // 将处理后的数据转换回JSON字符串
  1889. modifiedJSON, err := json.MarshalIndent(jsonData, "", " ")
  1890. if err != nil {
  1891. fmt.Println("Error marshaling JSON:", err)
  1892. return
  1893. }
  1894. newBody = string(modifiedJSON)
  1895. return
  1896. }
  1897. // processMap 递归处理map中的content字段
  1898. func processMap(data map[string]interface{}, opType string, tokenMap map[string]string) error {
  1899. for key, value := range data {
  1900. switch v := value.(type) {
  1901. case string:
  1902. if key == "content" {
  1903. contentSource, ok := data["compType"]
  1904. if !ok {
  1905. continue
  1906. }
  1907. contentSourceType, ok := contentSource.(string)
  1908. if !ok {
  1909. continue
  1910. }
  1911. if !utils.InArrayByStr([]string{`sheet`, `chart`}, contentSourceType) {
  1912. continue
  1913. }
  1914. newContent := v
  1915. // 处理链接
  1916. switch opType {
  1917. case `add`:
  1918. newContent = linkAddToken(v, tokenMap)
  1919. case `del`:
  1920. newContent = linkDelToken(v)
  1921. }
  1922. data[key] = newContent
  1923. }
  1924. case map[string]interface{}:
  1925. if err := processMap(v, opType, tokenMap); err != nil {
  1926. return err
  1927. }
  1928. case []interface{}:
  1929. for i := range v {
  1930. if m, ok := v[i].(map[string]interface{}); ok {
  1931. if err := processMap(m, opType, tokenMap); err != nil {
  1932. return err
  1933. }
  1934. }
  1935. }
  1936. }
  1937. }
  1938. return nil
  1939. }
  1940. // GetReportShareUrlToken 获取报告分享链接token
  1941. func GetReportShareUrlToken(req models.ReportShartUrlReq, adminId int) (linkToken string, err error) {
  1942. cacheLinkKey := utils.CACHE_REPORT_SHARE_SHORT_Url + strconv.Itoa(req.ReportId) + "userId:" + strconv.Itoa(adminId)
  1943. linkToken, _ = utils.Rc.RedisString(cacheLinkKey)
  1944. if linkToken != "" && utils.Rc.IsExist(utils.CACHE_REPORT_SHARE_ORIGIN_Url+linkToken) {
  1945. return
  1946. }
  1947. var tokenKey string
  1948. var ok bool
  1949. // 冲突检测
  1950. for i := 0; i < 3; i++ {
  1951. linkToken = req.Url
  1952. if i > 0 {
  1953. linkToken += "_" + utils.GetRandDigit(3)
  1954. }
  1955. hashUrl := utils.MurmurHash64([]byte(linkToken))
  1956. linkToken = utils.ConvertNumToBase62(hashUrl)
  1957. // 拼上报告标题
  1958. linkToken = fmt.Sprintf("%s %s", linkToken, req.Title)
  1959. tokenKey = fmt.Sprint(utils.CACHE_REPORT_SHARE_ORIGIN_Url, utils.MD5(linkToken))
  1960. ok = utils.Rc.IsExist(tokenKey)
  1961. if !ok {
  1962. break
  1963. }
  1964. }
  1965. if !ok {
  1966. after := time.Now().AddDate(0, 0, 7)
  1967. err = utils.Rc.Put(cacheLinkKey, linkToken, time.Until(after))
  1968. if err != nil {
  1969. return
  1970. }
  1971. err = utils.Rc.Put(tokenKey, req.Url, time.Until(after))
  1972. if err != nil {
  1973. return
  1974. }
  1975. } else {
  1976. linkToken = ""
  1977. err = errors.New("生成链接失败")
  1978. }
  1979. return
  1980. }
  1981. func TransfromToOriginUrl(linkToken string) (originLink string, msg string, err error) {
  1982. cacheLinkKey := fmt.Sprint(utils.CACHE_REPORT_SHARE_ORIGIN_Url, utils.MD5(linkToken))
  1983. originLink, err = utils.Rc.RedisString(cacheLinkKey)
  1984. if err != nil {
  1985. if err == redis.Nil {
  1986. msg = "链接已失效, 请重新获取"
  1987. return
  1988. }
  1989. msg = "获取链接失败"
  1990. return
  1991. }
  1992. if originLink == "" {
  1993. msg = "链接已失效, 请重新获取"
  1994. return
  1995. }
  1996. return
  1997. }
  1998. func FilterShareUrl() web.FilterFunc {
  1999. return func(c *context.Context) {
  2000. path := c.Input.Context.Request.URL.Path
  2001. tokenArr := strings.Split(path, "/")
  2002. token := tokenArr[len(tokenArr)-1]
  2003. newPath := "/adminapi/report/share/link"
  2004. q := c.Input.Context.Request.URL.Query()
  2005. q.Add("Token", token)
  2006. c.Input.Context.Request.URL.Path = newPath
  2007. c.Input.Context.Request.URL.RawQuery = q.Encode()
  2008. utils.ApiLog.Info(fmt.Sprintf("原始请求为:%s, 已修改请求路径为:%s?%s", path, newPath, q.Encode()))
  2009. }
  2010. }