excel_info.go 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "eta/eta_chart_lib/models"
  5. "eta/eta_chart_lib/models/request"
  6. "eta/eta_chart_lib/models/response"
  7. "eta/eta_chart_lib/services/data"
  8. "eta/eta_chart_lib/services/data/table"
  9. "eta/eta_chart_lib/services/excel"
  10. "eta/eta_chart_lib/utils"
  11. "fmt"
  12. "github.com/shopspring/decimal"
  13. "time"
  14. )
  15. // ExcelInfoController excel表格
  16. type ExcelInfoController struct {
  17. BaseAuthController
  18. }
  19. // GetTableDetail
  20. // @Title 获取表格表详情
  21. // @Description 获取表格表详情接口
  22. // @Param UniqueCode query string true "表格表唯一编码,如果是管理后台访问,传固定字符串:7c69b590249049942070ae9dcd5bf6dc"
  23. // @Param FromScene query int true "场景来源,1:智能研报,2:研报列表;3:英文研报;4:中文PPT;5:英文PPT"
  24. // @Success 200 {object} response.ExcelTableDetailResp
  25. // @router /detail [get]
  26. func (this *ExcelInfoController) GetTableDetail() {
  27. br := new(models.BaseResponse).Init()
  28. defer func() {
  29. this.Data["json"] = br
  30. this.ServeJSON()
  31. }()
  32. uniqueCode := this.GetString("UniqueCode")
  33. if uniqueCode == "" {
  34. br.Msg = "参数错误"
  35. br.ErrMsg = "参数错误,uniqueCode is empty"
  36. return
  37. }
  38. fromScene, _ := this.GetInt("FromScene", 0)
  39. key := utils.HZ_CHART_LIB_EXCEL_TABLE_DETAIL + ":" + uniqueCode
  40. resp := new(response.ExcelTableDetailResp)
  41. //判断是否有缓存
  42. if utils.Re == nil {
  43. if utils.Re == nil && utils.Rc.IsExist(key) {
  44. if data, err1 := utils.Rc.RedisBytes(key); err1 == nil {
  45. err := json.Unmarshal(data, &resp)
  46. if err == nil && resp != nil {
  47. // 配置项
  48. config := response.ExcelTableDetailConfigResp{
  49. FontSize: 9,
  50. }
  51. // 获取配置的字体大小
  52. confName := models.FromSceneMap[fromScene]
  53. if confName != `` {
  54. busConf, err := models.GetBusinessConfByKey(confName)
  55. if err == nil {
  56. sizeDeci, err := decimal.NewFromString(busConf.ConfVal)
  57. if err == nil {
  58. config.FontSize = int(sizeDeci.IntPart())
  59. }
  60. }
  61. }
  62. resp.Config = config
  63. br.Ret = 200
  64. br.Success = true
  65. br.Msg = "获取成功"
  66. br.Data = resp
  67. fmt.Println("source redis")
  68. return
  69. }
  70. }
  71. }
  72. }
  73. excelInfo, err := models.GetExcelInfoByUniqueCode(uniqueCode)
  74. if err != nil {
  75. if err.Error() == utils.ErrNoRow() {
  76. br.Msg = "该表格已被删除,请刷新页面"
  77. br.ErrMsg = "该表格已被删除,请刷新页面,Err:" + err.Error()
  78. return
  79. }
  80. br.Msg = "获取失败"
  81. br.ErrMsg = "获取表格表信息失败,Err:" + err.Error()
  82. return
  83. }
  84. var tableData excel.TableData
  85. switch excelInfo.Source {
  86. case utils.EXCEL_DEFAULT:
  87. luckySheetData, err := excel.GetLuckySheetData(excelInfo.Content)
  88. if err != nil {
  89. br.Msg = "获取失败"
  90. br.ErrMsg = "获取excel数据失败,Err:" + err.Error()
  91. return
  92. }
  93. tableData, err = luckySheetData.GetTableDataByLuckySheetDataStr()
  94. if err != nil {
  95. br.Msg = "获取失败"
  96. br.ErrMsg = "转换成table失败,Err:" + err.Error()
  97. return
  98. }
  99. case utils.TIME_TABLE:
  100. var tableDataConfig data.TableDataConfig
  101. err = json.Unmarshal([]byte(excelInfo.Content), &tableDataConfig)
  102. if err != nil {
  103. br.Msg = "获取失败"
  104. br.ErrMsg = "表格json转结构体失败,Err:" + err.Error()
  105. return
  106. }
  107. result, err := data.GetDataByTableDataConfig(tableDataConfig)
  108. if err != nil {
  109. br.Msg = "获取失败"
  110. br.ErrMsg = "获取最新的表格数据失败,Err:" + err.Error()
  111. return
  112. }
  113. tableData, err = excel.GetTableDataByCustomData(excelInfo.ExcelType, result)
  114. if err != nil {
  115. br.Msg = "获取失败"
  116. br.ErrMsg = "转换成table失败,Err:" + err.Error()
  117. return
  118. }
  119. case utils.MIXED_TABLE:
  120. var result request.MixedTableReq
  121. err = json.Unmarshal([]byte(excelInfo.Content), &result)
  122. if err != nil {
  123. br.Msg = "获取失败"
  124. br.ErrMsg = "表格json转结构体失败,Err:" + err.Error()
  125. return
  126. }
  127. newResult, tmpErr, tmpErrMsg := table.GetMixedTableCellData(result)
  128. if tmpErr != nil {
  129. br.Msg = "获取失败"
  130. if tmpErrMsg != `` {
  131. br.Msg = tmpErrMsg
  132. }
  133. br.ErrMsg = "获取最新的数据失败,Err:" + tmpErr.Error()
  134. return
  135. }
  136. tableData, err = excel.GetTableDataByMixedTableData(newResult)
  137. if err != nil {
  138. br.Msg = "获取失败"
  139. br.ErrMsg = "转换成table失败,Err:" + err.Error()
  140. return
  141. }
  142. }
  143. tableData = excel.HandleTableCell(tableData)
  144. config := response.ExcelTableDetailConfigResp{
  145. FontSize: 9,
  146. }
  147. // 获取配置的字体大小
  148. confName := models.FromSceneMap[fromScene]
  149. if confName != `` {
  150. busConf, err := models.GetBusinessConfByKey(confName)
  151. if err == nil {
  152. sizeDeci, err := decimal.NewFromString(busConf.ConfVal)
  153. if err == nil {
  154. config.FontSize = int(sizeDeci.IntPart())
  155. }
  156. }
  157. }
  158. resp.TableInfo = tableData
  159. resp.Source = excelInfo.Source
  160. resp.ExcelType = excelInfo.ExcelType
  161. resp.ExcelName = excelInfo.ExcelName
  162. resp.ExcelImage = excelInfo.ExcelImage
  163. resp.UniqueCode = excelInfo.UniqueCode
  164. resp.Config = config
  165. if utils.Re == nil {
  166. data, _ := json.Marshal(resp)
  167. utils.Rc.Put(key, data, 5*time.Minute)
  168. }
  169. br.Ret = 200
  170. br.Success = true
  171. br.Msg = "获取成功"
  172. br.Data = resp
  173. }