mixed_table.go 38 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301
  1. package excel
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_api/models/data_manage"
  6. "eta/eta_api/models/data_manage/excel/request"
  7. "eta/eta_api/services/data"
  8. "eta/eta_api/utils"
  9. "fmt"
  10. "github.com/shopspring/decimal"
  11. "github.com/yidane/formula"
  12. "sort"
  13. "strconv"
  14. "strings"
  15. "time"
  16. )
  17. // BaseCalculate
  18. // @Description: 指标数据计算请求
  19. type BaseCalculate struct {
  20. DataList []*data_manage.EdbDataList
  21. Frequency string `description:"需要转换的频度"`
  22. Formula interface{}
  23. Calendar string `description:"公历/农历"`
  24. MoveType int `description:"移动方式:1:领先(默认),2:滞后"`
  25. MoveFrequency string `description:"移动频度"`
  26. FromFrequency string `description:"来源的频度"`
  27. Source int `description:"1:累计值转月;2:累计值转季;3:同比值;4:同差值;5:N数值移动平均数计算;6:环比值;7:环差值;8:升频;9:降频;10:时间移位;11:超季节性;12:年化;13:累计值;14:累计值年初至今;15:指数修匀;16:日均值"`
  28. }
  29. // Cell
  30. // @Description: 单元格位置
  31. type Cell struct {
  32. Column int `description:"行"`
  33. Row int `description:"列"`
  34. CellInfo request.MixedTableCellDataReq `description:"对应的单元格信息"`
  35. }
  36. // GetMixedTableCellData 获取混合表格数据
  37. func GetMixedTableCellData(mixedTableReq request.MixedTableReq) (newMixedTableCellDataList [][]request.MixedTableCellDataReq, err error, errMsg string) {
  38. cellRelationConf := mixedTableReq.CellRelation
  39. config := mixedTableReq.Data
  40. // 单元格关系配置x信息
  41. cellRelationConfMap := make(map[string]request.CellRelationConf)
  42. cellRelationConfList := make([]request.CellRelationConf, 0)
  43. if cellRelationConf != `` {
  44. err = json.Unmarshal([]byte(cellRelationConf), &cellRelationConfList)
  45. if err != nil {
  46. return
  47. }
  48. for _, v := range cellRelationConfList {
  49. cellRelationConfMap[v.Key] = v
  50. }
  51. }
  52. // 找出所有的关联指标id
  53. config, edbInfoIdList, _, err, errMsg := handleConfig(config)
  54. if err != nil {
  55. return
  56. }
  57. // 查询所有关联的指标信息
  58. edbInfoList, err := data_manage.GetEdbInfoByIdList(edbInfoIdList)
  59. if err != nil {
  60. return
  61. }
  62. // 指标信息map
  63. edbInfoMap := make(map[int]*data_manage.EdbInfo)
  64. // 日度指标数据map
  65. edbDayDataListMap := make(map[int]map[string]float64)
  66. // 月度指标数据map
  67. edbMonthDataListMap := make(map[int]map[string]string)
  68. // 日度指标数据map
  69. edbDataListMap := make(map[int][]*data_manage.EdbDataList)
  70. for _, edbInfo := range edbInfoList {
  71. edbInfoMap[edbInfo.EdbInfoId] = edbInfo
  72. dataList := make([]*data_manage.EdbDataList, 0)
  73. switch edbInfo.EdbInfoType {
  74. case 0:
  75. dataList, _ = data_manage.GetEdbDataList(edbInfo.Source, edbInfo.SubSource, edbInfo.EdbInfoId, ``, ``)
  76. case 1:
  77. _, dataList, _, _, _, _ = data.GetPredictDataListByPredictEdbInfoId(edbInfo.EdbInfoId, ``, ``, false)
  78. default:
  79. err = errors.New(fmt.Sprint("获取失败,指标类型异常", edbInfo.EdbInfoType))
  80. }
  81. dateValMap := make(map[string]float64)
  82. monthDateMap := make(map[string]string)
  83. for _, tmpData := range dataList {
  84. // 日度数据
  85. dateValMap[tmpData.DataTime] = tmpData.Value
  86. // 月度数据(取该月份的第一个数据)
  87. yearMonth := strings.Join(strings.Split(tmpData.DataTime, "-")[0:2], "-")
  88. if _, ok := monthDateMap[yearMonth]; !ok {
  89. // 存最早的时间
  90. monthDateMap[yearMonth] = tmpData.DataTime
  91. }
  92. }
  93. edbDayDataListMap[edbInfo.EdbInfoId] = dateValMap
  94. edbMonthDataListMap[edbInfo.EdbInfoId] = monthDateMap
  95. edbDataListMap[edbInfo.EdbInfoId] = dataList
  96. }
  97. // 单元格实际绑定的信息map
  98. cellDataRelationMap := make(map[string]request.MixedTableCellDataReq, 0)
  99. // 处理指定指标的日期
  100. for k, row := range config {
  101. for i, cell := range row {
  102. // 单元格是日期类型,且是日导入指标日期(指标库的最新日期)
  103. if cell.DataType == request.DateDT && cell.DataTimeType == request.EdbDateDT {
  104. // 指标id是在配置里面
  105. var edbDateConfig request.EdbDateConf
  106. err = json.Unmarshal([]byte(cell.Value), &edbDateConfig)
  107. if err != nil {
  108. return
  109. }
  110. if dataList, ok := edbDataListMap[edbDateConfig.EdbInfoId]; ok {
  111. // todo 获取配置信息,根据配置信息进行日期变换, 是否需要更新当前记录,将历史记录逐渐转换成新的记录
  112. var newDate string
  113. newDate, err = GetEdbDateByMoveForward(config[k][i].Value, dataList)
  114. if err != nil {
  115. return
  116. }
  117. newDate, err = HandleMixTableDateChange(newDate, config[k][i].Value)
  118. if err != nil {
  119. return
  120. }
  121. cell.ShowValue = newDate
  122. cell.DataTime = newDate
  123. config[k][i] = cell
  124. }
  125. }
  126. row[i] = cell
  127. cellDataRelationMap[cell.Uid] = cell
  128. }
  129. config[k] = row
  130. }
  131. // 指标计算的结果map
  132. edbSourceDataMap := make(map[string]data.BaseCalculateDataResp)
  133. // 单元格对应的key与他的值(只处理数据类型)
  134. cellKeyVal := make(map[string]float64)
  135. // 基础计算单元格的位置信息
  136. calculateCellMap := make(map[string]Cell)
  137. calculateChainList := make([]string, 0)
  138. dateCalculateList := make([]string, 0)
  139. showStyleList := make([]string, 0)
  140. // 处理单元格中的数据类型(除去基础计算,因为这个是依赖于其他)
  141. for k, row := range config {
  142. for i, cell := range row {
  143. switch cell.DataType {
  144. case request.EdbDT: // 指标类型
  145. if cell.Value == `` {
  146. if edbInfo, ok := edbInfoMap[cell.EdbInfoId]; ok {
  147. cell.ShowValue = edbInfo.EdbName
  148. }
  149. } else {
  150. cell.ShowValue = cell.Value
  151. }
  152. case request.InsertDataDT, request.PopInsertDataDT: // 数据类型
  153. // 数值先清空
  154. cell.ShowValue = ``
  155. //cell.Value = ``
  156. // 日期关系配置不存在,则默认最新数据
  157. if relationConf, ok := cellRelationConfMap[cell.Uid]; ok { //表示表格日期
  158. if relationConf.RelationDate.Key == `` {
  159. // 日期关系配置未绑定
  160. continue
  161. }
  162. // 配置
  163. relationCell, ok := cellDataRelationMap[relationConf.RelationDate.Key]
  164. if !ok {
  165. // 找不到对应日期的单元格
  166. continue
  167. }
  168. // 确实是找到了这个关联日期的单元格,那么通过日期重新获取数据值
  169. tmpDateValMap := make(map[string]float64)
  170. // 日度数据
  171. if dateValMap, ok := edbDayDataListMap[cell.EdbInfoId]; ok {
  172. tmpDateValMap = dateValMap
  173. }
  174. // todo 根据配置进行日期变换
  175. relationDate := relationCell.DataTime
  176. if strings.Contains(cell.Value, "{") {
  177. relationDate, err = HandleMixTableDateChange(relationDate, cell.Value)
  178. if err != nil {
  179. return
  180. }
  181. } else {
  182. cell.Value = ""
  183. }
  184. if val, ok2 := tmpDateValMap[relationDate]; ok2 {
  185. //cell.ShowValue = fmt.Sprint(val)
  186. cellKeyVal[cell.Uid] = val
  187. cell.ShowValue = utils.FormatMixTableDataShowValue(val)
  188. }
  189. } else {
  190. // 如果不是取得一个关联的日期,那么就是指定日期
  191. // 如果没有指定日期,则默认最新数据
  192. if cell.DataTime == `` {
  193. // 指标的最新日期
  194. if dateValList, ok := edbDataListMap[cell.EdbInfoId]; ok {
  195. tmpLenData := len(dateValList)
  196. if tmpLenData > 0 {
  197. //做期数前移动和日期变换
  198. if !strings.Contains(cell.Value, "{") {
  199. cell.Value = ""
  200. }
  201. var newDate string
  202. newDate, err = GetEdbDateByMoveForward(cell.Value, dateValList)
  203. if err != nil {
  204. return
  205. }
  206. newDate, err = HandleMixTableDateChange(newDate, cell.Value)
  207. if err != nil {
  208. return
  209. }
  210. var finalVal string
  211. for _, v := range dateValList {
  212. if v.DataTime == newDate {
  213. finalVal = utils.FormatMixTableDataShowValue(v.Value)
  214. cellKeyVal[cell.Uid] = v.Value
  215. break
  216. }
  217. }
  218. cell.ShowValue = finalVal
  219. }
  220. }
  221. } else {
  222. tmpDateList := strings.Split(cell.DataTime, "-")
  223. tmpDateValMap := make(map[string]float64)
  224. var newDate string
  225. if len(tmpDateList) == 2 {
  226. //月度数据
  227. if dateMap, ok1 := edbMonthDataListMap[cell.EdbInfoId]; ok1 {
  228. if d, ok2 := dateMap[cell.DataTime]; ok2 {
  229. newDate = d
  230. }
  231. }
  232. } else {
  233. // 日度数据
  234. newDate = cell.DataTime
  235. }
  236. // 日期变换后才能确定最后的时间
  237. //做期数前移动和日期变换
  238. if !strings.Contains(cell.Value, "{") {
  239. cell.Value = ""
  240. }
  241. newDate, err = HandleMixTableDateChange(newDate, cell.Value)
  242. if err != nil {
  243. return
  244. }
  245. if dateValMap, ok3 := edbDayDataListMap[cell.EdbInfoId]; ok3 {
  246. tmpDateValMap = dateValMap
  247. if val, ok2 := tmpDateValMap[cell.DataTime]; ok2 {
  248. //cell.ShowValue = fmt.Sprint(val)
  249. cellKeyVal[cell.Uid] = val
  250. cell.ShowValue = utils.FormatMixTableDataShowValue(val)
  251. }
  252. }
  253. }
  254. }
  255. case request.CustomTextDT: //自定义文本
  256. if cell.Value == `` {
  257. continue
  258. }
  259. // 处理看下能否转成float,如果可以的话,说明这个也是可以参与计算的
  260. tmpDeci, tmpErr := decimal.NewFromString(cell.Value)
  261. if tmpErr == nil {
  262. tmpVal, _ := tmpDeci.Float64()
  263. cellKeyVal[cell.Uid] = tmpVal
  264. }
  265. case request.FormulateCalculateDataDT: // 公式计算(A+B这种)
  266. calculateChainList = append(calculateChainList, cell.Uid)
  267. case request.InsertEdbCalculateDataDT: // 插入指标系统计算公式生成的值
  268. // 处理value的值
  269. if !strings.Contains(cell.Value, "EdbInfoId") && cell.EdbInfoId > 0 {
  270. cell.Value, _ = fixCalculateValueConfig(cell.Value, cell.EdbInfoId)
  271. row[i] = cell
  272. }
  273. // 日期
  274. var cellDateTime string
  275. // 日期关系配置不存在,则默认最新数据
  276. // 从绑定的单元格中获取数据的日期
  277. if relationConf, ok := cellRelationConfMap[cell.Uid]; ok {
  278. if relationConf.RelationDate.Key == `` {
  279. // 日期关系配置未绑定
  280. continue
  281. }
  282. // 配置
  283. relationCell, ok := cellDataRelationMap[relationConf.RelationDate.Key]
  284. if !ok {
  285. // 找不到对应日期的单元格
  286. continue
  287. }
  288. cellDateTime = relationCell.DataTime
  289. }
  290. var tmpDataMap map[string]float64
  291. key := utils.MD5(cell.Value)
  292. respItemData, ok := edbSourceDataMap[key]
  293. if !ok {
  294. // 对应的配置值
  295. var tmpConfig request.CalculateConf
  296. err = json.Unmarshal([]byte(cell.Value), &tmpConfig)
  297. if err != nil {
  298. return
  299. }
  300. tmpDataList, ok := edbDataListMap[tmpConfig.EdbInfoId]
  301. if !ok {
  302. continue
  303. }
  304. edbInfo, ok := edbInfoMap[tmpConfig.EdbInfoId]
  305. if !ok {
  306. continue
  307. }
  308. req2 := &BaseCalculate{
  309. DataList: tmpDataList,
  310. Frequency: tmpConfig.Frequency,
  311. Formula: tmpConfig.Formula,
  312. Calendar: tmpConfig.Calendar,
  313. MoveType: tmpConfig.MoveType,
  314. MoveFrequency: tmpConfig.MoveFrequency,
  315. FromFrequency: edbInfo.Frequency,
  316. Source: tmpConfig.Source,
  317. }
  318. // 调用指标库去更新
  319. reqJson, tmpErr := json.Marshal(req2)
  320. if tmpErr != nil {
  321. utils.FileLog.Error(fmt.Sprintf("计算失败1,配置信息;%s;错误原因:%s", cell.Value, tmpErr.Error()))
  322. err = tmpErr
  323. return
  324. }
  325. respItem, tmpErr := data.BaseCalculate(string(reqJson))
  326. if tmpErr != nil {
  327. utils.FileLog.Error(fmt.Sprintf("计算失败2,配置信息;%s;错误原因:%s", cell.Value, tmpErr.Error()))
  328. err = tmpErr
  329. return
  330. }
  331. if respItem.Ret != 200 {
  332. utils.FileLog.Error(fmt.Sprintf("计算失败3,配置信息;%s;原因:%s;错误原因:%s", cell.Value, respItem.Msg, respItem.ErrMsg))
  333. continue
  334. }
  335. //tmpDataMap = respItem.Data.DataMap
  336. // 计算结果存一份,万一存在重复的计算方式,那么省的重新计算一下
  337. edbSourceDataMap[key] = respItem.Data
  338. respItemData = respItem.Data
  339. }
  340. lenDataList := len(respItemData.DateList)
  341. tmpDataMap = respItemData.DataMap
  342. if cellDateTime == `` && lenDataList > 0 {
  343. //判断是否需要做期数前移动
  344. cellDateTime = respItemData.DateList[lenDataList-1]
  345. cellDateTime, err = GetEdbDateByMoveForwardByDateList(cell.Value, respItemData.DateList)
  346. if err != nil {
  347. utils.FileLog.Error(fmt.Sprintf("日期前移失败,配置信息;%s", cell.Value))
  348. continue
  349. }
  350. }
  351. // 进行日期变换
  352. cellDateTime, err = HandleMixTableDateChange(cellDateTime, cell.Value)
  353. if err != nil {
  354. utils.FileLog.Error(fmt.Sprintf("日期变换失败,配置信息;%s, 日期:%s", cell.Value, cellDateTime))
  355. continue
  356. }
  357. val, ok := tmpDataMap[cellDateTime]
  358. if ok {
  359. cellKeyVal[cell.Uid] = val
  360. cell.ShowValue = utils.FormatMixTableDataShowValue(val)
  361. } else {
  362. cell.ShowValue = ""
  363. }
  364. case request.DateCalculateDataDT: //日期计算
  365. dateCalculateList = append(dateCalculateList, cell.Uid)
  366. // 遍历数组,根据公式进行计算,并将得到的结果放到对应的单元格中
  367. }
  368. row[i] = cell
  369. }
  370. config[k] = row
  371. }
  372. // 处理指定指标的日期
  373. for k, row := range config {
  374. for i, cell := range row {
  375. calculateCellMap[cell.Uid] = Cell{
  376. Column: k,
  377. Row: i,
  378. CellInfo: cell,
  379. }
  380. cell.ShowFormatValue = cell.ShowValue
  381. if cell.ShowStyle != `` {
  382. showStyleList = append(showStyleList, cell.Uid)
  383. }
  384. row[i] = cell
  385. cellDataRelationMap[cell.Uid] = cell
  386. }
  387. config[k] = row
  388. }
  389. // 公式链计算
  390. if len(calculateChainList) > 0 {
  391. for _, cellKey := range calculateChainList {
  392. // 查找这个单元格的位置,直接map找了,而不是遍历整个单元格
  393. cellPosition, ok := calculateCellMap[cellKey]
  394. if !ok {
  395. utils.FileLog.Error("找不到单元格位置:", cellKey)
  396. continue
  397. }
  398. cell := config[cellPosition.Column][cellPosition.Row]
  399. if cell.DataType != request.FormulateCalculateDataDT { // 判断公式计算(A+B这种)类型,不是的话也过滤了
  400. continue
  401. }
  402. val, has, tmpErr, tmpErrMsg := getCalculateValueByCell(calculateCellMap, cellKey, cellKeyVal)
  403. if tmpErr != nil {
  404. errMsg = tmpErrMsg
  405. err = tmpErr
  406. return
  407. }
  408. if !has {
  409. continue
  410. }
  411. cellKeyVal[cell.Uid] = val
  412. cell.ShowValue = utils.FormatMixTableDataShowValue(val)
  413. config[cellPosition.Column][cellPosition.Row] = cell
  414. }
  415. }
  416. // 日期计算
  417. config, err, errMsg = handlerDateCalculate(dateCalculateList, calculateCellMap, config)
  418. if err != nil {
  419. return
  420. }
  421. // 格式化展示
  422. config, err, errMsg = handleMixCellShowStyle(showStyleList, calculateCellMap, config)
  423. if err != nil {
  424. return
  425. }
  426. newMixedTableCellDataList = config
  427. return
  428. }
  429. // getCalculateValue 获取公式计算的结果
  430. func getCalculateValueByCell(calculateCellMap map[string]Cell, key string, cellKeyValMap map[string]float64) (val float64, has bool, err error, errMsg string) {
  431. // 单元格的标签名
  432. val, ok := cellKeyValMap[key]
  433. if ok {
  434. has = true
  435. return
  436. }
  437. // 查找单元格数据
  438. cell, ok := calculateCellMap[key]
  439. if !ok {
  440. err = errors.New("查找单元格" + key + "的数据失败")
  441. return
  442. }
  443. colData := cell.CellInfo
  444. // 如果不是基础计算单元格,直接返回
  445. if colData.DataType != request.FormulateCalculateDataDT {
  446. return
  447. }
  448. // 如果是计算单元格
  449. tagList := make([]utils.CellPosition, 0)
  450. // 计算单元格relationCellList
  451. var relationCellList []request.RelationCell
  452. if colData.Extra == `` {
  453. err = errors.New(colData.Uid + "没有绑定关系")
  454. return
  455. }
  456. err = json.Unmarshal([]byte(colData.Extra), &relationCellList)
  457. if err != nil {
  458. return
  459. }
  460. for _, relation := range relationCellList {
  461. //relationCellTagName := strings.ToUpper(relation.Tag) + relation.Row
  462. tmpVal, _, tmpErr, tmpErrMsg := getCalculateValueByCell(calculateCellMap, relation.Key, cellKeyValMap)
  463. if tmpErr != nil {
  464. errMsg = tmpErrMsg
  465. err = tmpErr
  466. return
  467. }
  468. cellKeyValMap[relation.Key] = tmpVal
  469. rowInt, tmpErr := strconv.Atoi(relation.Row)
  470. if tmpErr != nil {
  471. err = tmpErr
  472. return
  473. }
  474. tagList = append(tagList, utils.CellPosition{
  475. Tag: relation.Tag,
  476. Row: rowInt,
  477. Value: tmpVal,
  478. })
  479. }
  480. // 计算
  481. val, errMsg, err = calculateByCellList(strings.ToUpper(colData.Value), tagList)
  482. if err != nil {
  483. return
  484. }
  485. // 重新赋值
  486. has = true
  487. cellKeyValMap[key] = val
  488. return
  489. }
  490. // handleConfig
  491. // @Description: 处理混合表格配置
  492. // @author: Roc
  493. // @datetime2023-10-27 13:24:53
  494. // @param configList [][]request.MixedTableCellDataReq
  495. // @return newConfig [][]request.MixedTableCellDataReq
  496. // @return edbInfoIdList []int
  497. // @return dataEdbInfoIdList []int
  498. // @return err error
  499. // @return errMsg string
  500. func handleConfig(configList [][]request.MixedTableCellDataReq) (newConfig [][]request.MixedTableCellDataReq, edbInfoIdList []int, dataEdbInfoIdList []int, err error, errMsg string) {
  501. edbInfoIdList = make([]int, 0)
  502. dataEdbInfoIdList = make([]int, 0)
  503. for ck, rowList := range configList {
  504. for rk, cell := range rowList {
  505. switch cell.DataType {
  506. case request.EdbDT: // 指标信息
  507. edbInfoIdList = append(edbInfoIdList, cell.EdbInfoId)
  508. case request.InsertDataDT, request.PopInsertDataDT: // 插值、弹框插值
  509. dataEdbInfoIdList = append(dataEdbInfoIdList, cell.EdbInfoId)
  510. edbInfoIdList = append(edbInfoIdList, cell.EdbInfoId)
  511. case request.InsertEdbCalculateDataDT: // 插入指标计算公式生成的值
  512. var config request.CalculateConf
  513. err = json.Unmarshal([]byte(cell.Value), &config)
  514. if err != nil {
  515. return
  516. }
  517. if config.EdbInfoId == 0 && cell.EdbInfoId > 0 {
  518. edbInfoIdList = append(edbInfoIdList, cell.EdbInfoId)
  519. } else {
  520. edbInfoIdList = append(edbInfoIdList, config.EdbInfoId)
  521. }
  522. dataEdbInfoIdList = append(dataEdbInfoIdList, cell.EdbInfoId)
  523. case request.DateDT: // 日期类型
  524. date, newVal, tmpErr, tmpErrMsg := handleDate(cell.DataTimeType, cell.Value)
  525. if tmpErr != nil {
  526. err = tmpErr
  527. errMsg = tmpErrMsg
  528. return
  529. }
  530. rowList[rk].DataTime = date
  531. rowList[rk].ShowValue = date
  532. rowList[rk].Value = newVal //兼容原有的历史数据中系统导入日期
  533. // 指标日期类型的单元格需要额外将指标id取出来
  534. if cell.DataTimeType == request.EdbDateDT {
  535. var config request.EdbDateConf
  536. err = json.Unmarshal([]byte(cell.Value), &config)
  537. if err != nil {
  538. return
  539. }
  540. edbInfoIdList = append(edbInfoIdList, config.EdbInfoId)
  541. }
  542. }
  543. }
  544. configList[ck] = rowList
  545. }
  546. newConfig = configList
  547. return
  548. }
  549. // HandleDate
  550. // @Description: 日期处理
  551. // @author: Roc
  552. // @datetime2023-10-27 09:37:02
  553. // @param dataTimeType int
  554. // @param val string
  555. // @return date string
  556. // @return err error
  557. // @return errMsg string
  558. func HandleDate(dataTimeType int, val string) (date string, newVal string, err error, errMsg string) {
  559. return handleDate(dataTimeType, val)
  560. }
  561. // handleDate
  562. // @Description: 日期处理
  563. // @author: Roc
  564. // @datetime2023-10-27 09:36:49
  565. // @param dataTimeType int
  566. // @param val string
  567. // @return date string
  568. // @return err error
  569. // @return errMsg string
  570. func handleDate(dataTimeType int, val string) (date string, newVal string, err error, errMsg string) {
  571. newVal = val
  572. if val == `` {
  573. errMsg = "错误的日期数据"
  574. err = errors.New(errMsg)
  575. return
  576. }
  577. switch dataTimeType {
  578. case request.CustomDateT: //手动输入日期
  579. /*if !strings.Contains(val, "{") {
  580. newVal, err, errMsg = handleOldCustomerDateT(val)
  581. if err != nil {
  582. return
  583. }
  584. }
  585. date, err = HandleMixTableDateChange("", newVal)
  586. if err != nil {
  587. return
  588. }*/
  589. date = val
  590. return
  591. case request.SystemDateT: // 系统日期
  592. date = time.Now().Format(utils.FormatDate)
  593. newVal, err, errMsg = handleOldSystemDateT(val)
  594. if err != nil {
  595. return
  596. }
  597. date, err = HandleMixTableDateChange(date, newVal)
  598. if err != nil {
  599. return
  600. }
  601. case request.EdbDateDT: // 导入指标日期(指标库的最新日期)
  602. default:
  603. errMsg = "错误的日期类型"
  604. err = errors.New(errMsg)
  605. return
  606. }
  607. return
  608. }
  609. func GetEdbDateByMoveForward(conf string, edbDataList []*data_manage.EdbDataList) (date string, err error) {
  610. dateList := make([]string, 0)
  611. for _, v := range edbDataList {
  612. dateList = append(dateList, v.DataTime)
  613. }
  614. date, err = GetEdbDateByMoveForwardByDateList(conf, dateList)
  615. return
  616. }
  617. func GetEdbDateByMoveForwardByDateList(conf string, dateList []string) (date string, err error) {
  618. moveForward := 0
  619. if conf != "" {
  620. var edbDateConf request.EdbDateChangeConf
  621. err = json.Unmarshal([]byte(conf), &edbDateConf)
  622. if err != nil {
  623. err = fmt.Errorf("日期变换配置json解析失败失败: %s", err.Error())
  624. return
  625. }
  626. moveForward = edbDateConf.MoveForward
  627. }
  628. // 根据日期进行排序
  629. index := len(dateList) - 1 - moveForward
  630. for k, v := range dateList {
  631. if k == index {
  632. date = v
  633. return
  634. }
  635. }
  636. return
  637. }
  638. // HandleMixTableDateChange 处理表格中的日期变换
  639. func HandleMixTableDateChange(date, conf string) (newDate string, err error) {
  640. newDate = date
  641. if conf == "" {
  642. return
  643. }
  644. var edbDateConf request.EdbDateConf
  645. err = json.Unmarshal([]byte(conf), &edbDateConf)
  646. if err != nil {
  647. err = fmt.Errorf("日期变换配置json解析失败失败: %s, Err:%s", conf, err.Error())
  648. return
  649. }
  650. if newDate != "" {
  651. if len(edbDateConf.DateChange) > 0 {
  652. var dateTime time.Time
  653. dateTime, err = time.ParseInLocation(utils.FormatDate, newDate, time.Local)
  654. if err != nil {
  655. err = fmt.Errorf("日期解析失败: %s", err.Error())
  656. return
  657. }
  658. for _, v := range edbDateConf.DateChange {
  659. if v.ChangeType == 1 {
  660. dateTime = dateTime.AddDate(v.Year, v.Month, v.Day)
  661. newDate = dateTime.Format(utils.FormatDate)
  662. } else if v.ChangeType == 2 {
  663. newDate, err, _ = handleSystemAppointDateT(dateTime, v.FrequencyDay, v.Frequency)
  664. if err != nil {
  665. return
  666. }
  667. dateTime, err = time.ParseInLocation(utils.FormatDate, newDate, time.Local)
  668. if err != nil {
  669. err = fmt.Errorf("日期解析失败: %s", err.Error())
  670. return
  671. }
  672. }
  673. }
  674. }
  675. }
  676. return
  677. }
  678. // handleOldSystemDateT
  679. // @Description: 历史数据中的导入系统日期
  680. // @author: Roc
  681. // @datetime2023-10-27 09:36:21
  682. // @param confStr string
  683. // @return date string
  684. // @return err error
  685. // @return errMsg string
  686. func handleOldSystemDateT(confStr string) (newConf string, err error, errMsg string) {
  687. newConf = confStr
  688. var config request.SystemDateConf
  689. err = json.Unmarshal([]byte(confStr), &config)
  690. if err != nil {
  691. return
  692. }
  693. newConfig := new(request.EdbDateConf)
  694. dateChange := new(request.EdbDateConfDateChange)
  695. dateChangeList := make([]*request.EdbDateConfDateChange, 0)
  696. switch config.Source {
  697. case request.SystemCurrDateT:
  698. return
  699. case request.SystemCalculateDateT:
  700. // todo 是否直接更新该excel记录,
  701. dateChange.Day = config.CalculateNum
  702. dateChange.ChangeType = 1
  703. dateChangeList = append(dateChangeList, dateChange)
  704. newConfig.DateChange = dateChangeList
  705. newConfByte, e := json.Marshal(newConfig)
  706. if e != nil {
  707. err = fmt.Errorf("日期计算额外配置,json序列化失败: %s", e.Error())
  708. return
  709. }
  710. newConf = string(newConfByte)
  711. return
  712. case request.SystemFrequencyDateT: // 处理系统日期相关的指定频率(所在周/旬/月/季/半年/年的最后/最早一天)
  713. dateChange.FrequencyDay = config.Day
  714. dateChange.Frequency = config.Frequency
  715. dateChange.ChangeType = 1
  716. dateChangeList = append(dateChangeList, dateChange)
  717. newConfig.DateChange = dateChangeList
  718. newConfByte, e := json.Marshal(newConfig)
  719. if e != nil {
  720. err = fmt.Errorf("日期计算额外配置,json序列化失败: %s", e.Error())
  721. return
  722. }
  723. newConf = string(newConfByte)
  724. return
  725. default:
  726. //errMsg = "错误的日期日期导入方式"
  727. //err = errors.New(fmt.Sprint("错误的日期日期导入方式:", config.Source))
  728. return
  729. }
  730. return
  731. }
  732. // handleSystemCalculateDateT
  733. // @Description: 处理系统日期计算后的日期
  734. // @author: Roc
  735. // @datetime2023-10-27 09:31:22
  736. // @param num int
  737. // @param frequency string
  738. // @return date string
  739. // @return err error
  740. // @return errMsg string
  741. func handleSystemCalculateDateT(num int, frequency string) (date string, err error, errMsg string) {
  742. if err != nil {
  743. return
  744. }
  745. currDate := time.Now()
  746. switch frequency {
  747. case "", "日":
  748. date = currDate.AddDate(0, 0, num).Format(utils.FormatDate)
  749. default:
  750. errMsg = "错误的日期频度:" + frequency
  751. err = errors.New(errMsg)
  752. return
  753. }
  754. return
  755. }
  756. // handleSystemAppointDateT
  757. // @Description: 处理系统日期相关的指定频率(所在周/旬/月/季/半年/年的最后/最早一天)
  758. // @author: Roc
  759. // @datetime2023-10-27 09:31:35
  760. // @param Frequency string
  761. // @param Day string
  762. // @return date string
  763. // @return err error
  764. // @return errMsg string
  765. func handleSystemAppointDateT(currDate time.Time, appointDay, frequency string) (date string, err error, errMsg string) {
  766. //currDate := time.Now()
  767. switch frequency {
  768. case "本周":
  769. day := int(currDate.Weekday())
  770. if day == 0 { // 周日
  771. day = 7
  772. }
  773. num := 0
  774. switch appointDay {
  775. case "周一":
  776. num = 1
  777. case "周二":
  778. num = 2
  779. case "周三":
  780. num = 3
  781. case "周四":
  782. num = 4
  783. case "周五":
  784. num = 5
  785. case "周六":
  786. num = 6
  787. case "周日":
  788. num = 7
  789. }
  790. day = num - day
  791. date = currDate.AddDate(0, 0, day).Format(utils.FormatDate)
  792. case "本旬":
  793. day := currDate.Day()
  794. var tmpDate time.Time
  795. switch appointDay {
  796. case "第一天":
  797. if day <= 10 {
  798. tmpDate = time.Date(currDate.Year(), currDate.Month(), 1, 0, 0, 0, 0, currDate.Location())
  799. } else if day <= 20 {
  800. tmpDate = time.Date(currDate.Year(), currDate.Month(), 11, 0, 0, 0, 0, currDate.Location())
  801. } else {
  802. tmpDate = time.Date(currDate.Year(), currDate.Month(), 21, 0, 0, 0, 0, currDate.Location())
  803. }
  804. case "最后一天":
  805. if day <= 10 {
  806. tmpDate = time.Date(currDate.Year(), currDate.Month(), 10, 0, 0, 0, 0, currDate.Location())
  807. } else if day <= 20 {
  808. tmpDate = time.Date(currDate.Year(), currDate.Month(), 20, 0, 0, 0, 0, currDate.Location())
  809. } else {
  810. tmpDate = time.Date(currDate.Year(), currDate.Month()+1, 1, 0, 0, 0, 0, currDate.Location()).AddDate(0, 0, -1)
  811. }
  812. }
  813. date = tmpDate.Format(utils.FormatDate)
  814. case "本月":
  815. var tmpDate time.Time
  816. switch appointDay {
  817. case "第一天":
  818. tmpDate = time.Date(currDate.Year(), currDate.Month(), 1, 0, 0, 0, 0, currDate.Location())
  819. case "最后一天":
  820. tmpDate = time.Date(currDate.Year(), currDate.Month()+1, 1, 0, 0, 0, 0, currDate.Location()).AddDate(0, 0, -1)
  821. }
  822. date = tmpDate.Format(utils.FormatDate)
  823. case "本季":
  824. month := currDate.Month()
  825. var tmpDate time.Time
  826. switch appointDay {
  827. case "第一天":
  828. if month <= 3 {
  829. tmpDate = time.Date(currDate.Year(), 1, 1, 0, 0, 0, 0, currDate.Location())
  830. } else if month <= 6 {
  831. tmpDate = time.Date(currDate.Year(), 4, 1, 0, 0, 0, 0, currDate.Location())
  832. } else if month <= 9 {
  833. tmpDate = time.Date(currDate.Year(), 7, 1, 0, 0, 0, 0, currDate.Location())
  834. } else {
  835. tmpDate = time.Date(currDate.Year(), 10, 1, 0, 0, 0, 0, currDate.Location())
  836. }
  837. case "最后一天":
  838. if month <= 3 {
  839. tmpDate = time.Date(currDate.Year(), 3, 31, 0, 0, 0, 0, currDate.Location())
  840. } else if month <= 6 {
  841. tmpDate = time.Date(currDate.Year(), 6, 30, 0, 0, 0, 0, currDate.Location())
  842. } else if month <= 9 {
  843. tmpDate = time.Date(currDate.Year(), 9, 30, 0, 0, 0, 0, currDate.Location())
  844. } else {
  845. tmpDate = time.Date(currDate.Year(), 12, 31, 0, 0, 0, 0, currDate.Location())
  846. }
  847. }
  848. date = tmpDate.Format(utils.FormatDate)
  849. case "本半年":
  850. month := currDate.Month()
  851. var tmpDate time.Time
  852. switch appointDay {
  853. case "第一天":
  854. if month <= 6 {
  855. tmpDate = time.Date(currDate.Year(), 1, 1, 0, 0, 0, 0, currDate.Location())
  856. } else {
  857. tmpDate = time.Date(currDate.Year(), 7, 1, 0, 0, 0, 0, currDate.Location())
  858. }
  859. case "最后一天":
  860. if month <= 6 {
  861. tmpDate = time.Date(currDate.Year(), 6, 30, 0, 0, 0, 0, currDate.Location())
  862. } else {
  863. tmpDate = time.Date(currDate.Year(), 12, 31, 0, 0, 0, 0, currDate.Location())
  864. }
  865. }
  866. date = tmpDate.Format(utils.FormatDate)
  867. case "本年":
  868. var tmpDate time.Time
  869. switch appointDay {
  870. case "第一天":
  871. tmpDate = time.Date(currDate.Year(), 1, 1, 0, 0, 0, 0, currDate.Location())
  872. case "最后一天":
  873. tmpDate = time.Date(currDate.Year(), 12, 31, 0, 0, 0, 0, currDate.Location())
  874. }
  875. date = tmpDate.Format(utils.FormatDate)
  876. default:
  877. errMsg = "错误的日期频度:" + frequency
  878. err = errors.New(errMsg)
  879. return
  880. }
  881. return
  882. }
  883. // calculateByCellList
  884. // @Description: 根据单元格来进行公式计算
  885. // @author: Roc
  886. // @datetime2023-11-14 16:17:38
  887. // @param calculateFormula string
  888. // @param tagList []utils.CellPosition
  889. // @return calVal string
  890. // @return errMsg string
  891. // @return err error
  892. func calculateByCellList(calculateFormula string, tagList []utils.CellPosition) (calVal float64, errMsg string, err error) {
  893. if calculateFormula == "" {
  894. errMsg = "公式异常"
  895. err = errors.New(errMsg)
  896. return
  897. }
  898. calculateFormula = strings.TrimPrefix(calculateFormula, "=")
  899. calculateFormula = strings.Replace(calculateFormula, "(", "(", -1)
  900. calculateFormula = strings.Replace(calculateFormula, ")", ")", -1)
  901. calculateFormula = strings.Replace(calculateFormula, ",", ",", -1)
  902. calculateFormula = strings.Replace(calculateFormula, "。", ".", -1)
  903. calculateFormula = strings.Replace(calculateFormula, "%", "*0.01", -1)
  904. rowList := make([]int, 0)
  905. rowListMap := make(map[int][]utils.CellPosition)
  906. for _, v := range tagList {
  907. tmpRowList, ok := rowListMap[v.Row]
  908. if !ok {
  909. rowList = append(rowList, v.Row)
  910. tmpRowList = make([]utils.CellPosition, 0)
  911. }
  912. tmpRowList = append(tmpRowList, v)
  913. rowListMap[v.Row] = tmpRowList
  914. }
  915. sort.Ints(rowList)
  916. list := make([]utils.CellPosition, 0)
  917. for _, row := range rowList {
  918. list = append(list, rowListMap[row]...)
  919. }
  920. formulaFormStr := utils.ReplaceFormulaByCellList(list, calculateFormula)
  921. //计算公式异常,那么就移除该指标
  922. if formulaFormStr == `` {
  923. errMsg = "公式异常"
  924. err = errors.New(errMsg)
  925. return
  926. }
  927. expression := formula.NewExpression(formulaFormStr)
  928. calResult, err := expression.Evaluate()
  929. if err != nil {
  930. errMsg = "计算失败"
  931. err = errors.New("计算失败:Err:" + err.Error() + ";formulaStr:" + formulaFormStr)
  932. // 分母为0的报错
  933. if strings.Contains(err.Error(), "divide by zero") {
  934. errMsg = "分母不能为0"
  935. err = errors.New("分母不能为空,计算公式:" + formulaFormStr)
  936. }
  937. return
  938. }
  939. // 如果计算结果是NAN,那么就提示报错
  940. if calResult.IsNan() {
  941. errMsg = "计算失败"
  942. err = errors.New("计算失败:计算结果是:NAN;formulaStr:" + formulaFormStr)
  943. return
  944. }
  945. calVal, err = calResult.Float64()
  946. if err != nil {
  947. return
  948. }
  949. // 转Decimal然后四舍五入
  950. calVal, _ = decimal.NewFromFloat(calVal).Round(4).Float64()
  951. return
  952. }
  953. // handlerDateCalculate 处理日期计算
  954. func handlerDateCalculate(dateCalculateList []string, calculateCellMap map[string]Cell, oldConfig [][]request.MixedTableCellDataReq) (config [][]request.MixedTableCellDataReq, err error, errMsg string) {
  955. config = oldConfig
  956. if len(dateCalculateList) == 0 {
  957. return
  958. }
  959. if len(dateCalculateList) > 0 {
  960. for _, cellKey := range dateCalculateList {
  961. // 查找这个单元格的位置,直接map找了,而不是遍历整个单元格
  962. cellPosition, ok := calculateCellMap[cellKey]
  963. if !ok {
  964. utils.FileLog.Error("找不到单元格位置:", cellKey)
  965. continue
  966. }
  967. cell := config[cellPosition.Column][cellPosition.Row]
  968. if cell.DataType != request.DateCalculateDataDT { // 判断公式计算(A+B这种)类型,不是的话也过滤了
  969. continue
  970. }
  971. val, tmpErr, tmpErrMsg := DateCalculatePrepare(calculateCellMap, cell.Value)
  972. if tmpErr != nil {
  973. cell.ShowValue = ""
  974. config[cellPosition.Column][cellPosition.Row] = cell
  975. utils.FileLog.Error(fmt.Sprintf("%s 日期计算报错:Err:%s:%s", cellKey, tmpErr, tmpErrMsg))
  976. continue
  977. }
  978. cell.ShowValue = utils.FormatMixTableDataShowValue(val)
  979. config[cellPosition.Column][cellPosition.Row] = cell
  980. }
  981. }
  982. return
  983. }
  984. // DateCalculatePrepare 单个单元格的日期计算
  985. func DateCalculatePrepare(calculateCellMap map[string]Cell, config string) (val float64, err error, errMsg string) {
  986. var edbDateConf request.MixDateCalculateConf
  987. err = json.Unmarshal([]byte(config), &edbDateConf)
  988. if err != nil {
  989. err = fmt.Errorf("日期计算配置json解析失败失败: %s, Err:%s", config, err.Error())
  990. return
  991. }
  992. if len(edbDateConf.RelationCellList) == 0 {
  993. err = fmt.Errorf("日期计算 未配置日期单元格失败: %s", config)
  994. return
  995. }
  996. valMap := make(map[string]int)
  997. for _, v := range edbDateConf.RelationCellList {
  998. // 查找单元格数据
  999. cell, ok := calculateCellMap[v.Uid]
  1000. if !ok {
  1001. err = fmt.Errorf("查找单元格:%s 的数据失败", v.Uid)
  1002. return
  1003. }
  1004. colData := cell.CellInfo
  1005. // 如果不是基础计算单元格,直接返回
  1006. _, err = time.ParseInLocation(utils.FormatDate, colData.ShowValue, time.Local)
  1007. if err != nil {
  1008. err = fmt.Errorf("%s 的单元格非日期类型, Err: %s", colData.ShowValue, err.Error())
  1009. return
  1010. }
  1011. // todo 把日期转换成excel里的天数
  1012. realDiffDay := utils.GetDaysDiff1900(colData.ShowValue)
  1013. valMap[strings.ToUpper(v.Tag)] = realDiffDay
  1014. }
  1015. // 计算
  1016. val, errMsg, err = DateCalculateFormula(valMap, strings.ToUpper(edbDateConf.Formula))
  1017. if err != nil {
  1018. return
  1019. }
  1020. return
  1021. }
  1022. func DateCalculateFormula(valTagMap map[string]int, calculateFormula string) (calVal float64, errMsg string, err error) {
  1023. if calculateFormula == "" {
  1024. errMsg = "公式异常"
  1025. err = errors.New(errMsg)
  1026. return
  1027. }
  1028. calculateFormula = strings.TrimPrefix(calculateFormula, "=")
  1029. calculateFormula = strings.Replace(calculateFormula, "(", "(", -1)
  1030. calculateFormula = strings.Replace(calculateFormula, ")", ")", -1)
  1031. calculateFormula = strings.Replace(calculateFormula, ",", ",", -1)
  1032. calculateFormula = strings.Replace(calculateFormula, "。", ".", -1)
  1033. calculateFormula = strings.Replace(calculateFormula, "%", "*0.01", -1)
  1034. formulaFormStr := utils.ReplaceFormulaByTagMap(valTagMap, calculateFormula)
  1035. if formulaFormStr == `` {
  1036. errMsg = "公式异常"
  1037. err = errors.New(errMsg)
  1038. return
  1039. }
  1040. fmt.Println("公式:" + formulaFormStr)
  1041. expression := formula.NewExpression(formulaFormStr)
  1042. calResult, err := expression.Evaluate()
  1043. if err != nil {
  1044. errMsg = "公式错误,请重新填写"
  1045. err = errors.New("计算失败:Err:" + err.Error() + ";formulaStr:" + formulaFormStr)
  1046. // 分母为0的报错
  1047. if strings.Contains(err.Error(), "divide by zero") {
  1048. errMsg = "分母不能为0"
  1049. err = errors.New("分母不能为空,计算公式:" + formulaFormStr)
  1050. }
  1051. return
  1052. }
  1053. // 如果计算结果是NAN,那么就提示报错
  1054. if calResult.IsNan() {
  1055. errMsg = "公式错误,请重新填写"
  1056. err = errors.New("计算失败:计算结果是:NAN;formulaStr:" + formulaFormStr)
  1057. return
  1058. }
  1059. calVal, err = calResult.Float64()
  1060. if err != nil {
  1061. return
  1062. }
  1063. // 转Decimal然后四舍五入
  1064. calVal, _ = decimal.NewFromFloat(calVal).Round(4).Float64()
  1065. return
  1066. }
  1067. // handleMixCellShowStyle 处理混合表格中,显示计算的逻辑
  1068. func handleMixCellShowStyle(showStyleList []string, calculateCellMap map[string]Cell, oldConfig [][]request.MixedTableCellDataReq) (config [][]request.MixedTableCellDataReq, err error, errMsg string) {
  1069. config = oldConfig
  1070. if len(showStyleList) == 0 {
  1071. return
  1072. }
  1073. if len(showStyleList) > 0 {
  1074. for _, cellKey := range showStyleList {
  1075. // 查找这个单元格的位置,直接map找了,而不是遍历整个单元格
  1076. cellPosition, ok := calculateCellMap[cellKey]
  1077. if !ok {
  1078. utils.FileLog.Error("找不到单元格位置:", cellKey)
  1079. continue
  1080. }
  1081. cell := config[cellPosition.Column][cellPosition.Row]
  1082. val := cell.ShowValue
  1083. isPercent := false
  1084. if strings.Contains(val, "%") {
  1085. isPercent = true
  1086. val = strings.Trim(val, "%")
  1087. }
  1088. _, e := strconv.ParseFloat(val, 64) // 将字符串转换成float类型
  1089. if e != nil { // 如果没有错误发生则返回true,说明该字符串是一个合法的数字
  1090. continue
  1091. }
  1092. var styleConf request.MixCellShowStyle
  1093. err = json.Unmarshal([]byte(cell.ShowStyle), &styleConf)
  1094. if err != nil {
  1095. err = fmt.Errorf("日期计算配置json解析失败失败: %s, Err:%s", config, err.Error())
  1096. return
  1097. }
  1098. if styleConf.Pn != 0 || styleConf.Nt != "" {
  1099. val = changePointDecimalPlaces(val, styleConf.Pn, styleConf.Nt, isPercent)
  1100. cell.ShowFormatValue = val
  1101. } else {
  1102. cell.ShowFormatValue = cell.ShowValue
  1103. }
  1104. config[cellPosition.Column][cellPosition.Row] = cell
  1105. }
  1106. }
  1107. return
  1108. }
  1109. // changePointDecimalPlaces 小数点位数加减和百分比格式
  1110. func changePointDecimalPlaces(str string, changeNum int, numberType string, isPercent bool) (newStr string) {
  1111. newStr = str
  1112. var decimalPlaces int
  1113. dotIndex := strings.Index(newStr, ".") // 查找小数点的位置
  1114. if dotIndex == -1 {
  1115. decimalPlaces = 0
  1116. } else {
  1117. decimalPlaces = len(newStr) - dotIndex - 1
  1118. }
  1119. // 把字符串转成浮点数
  1120. val, _ := strconv.ParseFloat(str, 64)
  1121. if isPercent {
  1122. if numberType == "number" { //百分数转成小数
  1123. val = val / 100
  1124. if decimalPlaces > 2 {
  1125. decimalPlaces += 2
  1126. } else if decimalPlaces == 1 {
  1127. decimalPlaces += 1
  1128. } else if decimalPlaces == 0 {
  1129. if len(str) == 1 {
  1130. decimalPlaces = 2
  1131. } else if len(str) == 2 {
  1132. if str[1] == '0' {
  1133. decimalPlaces = 1
  1134. } else {
  1135. decimalPlaces = 2
  1136. }
  1137. }
  1138. }
  1139. isPercent = false
  1140. }
  1141. } else {
  1142. if numberType == "percent" {
  1143. if decimalPlaces > 2 {
  1144. decimalPlaces -= 2
  1145. } else if decimalPlaces == 1 {
  1146. decimalPlaces = 0
  1147. }
  1148. val = val * 100
  1149. }
  1150. }
  1151. if decimalPlaces > 0 {
  1152. val, _ = decimal.NewFromFloat(val).Round(int32(decimalPlaces)).Float64()
  1153. newStr = strconv.FormatFloat(val, 'f', decimalPlaces, 64)
  1154. } else {
  1155. newStr = fmt.Sprintf("%v", val)
  1156. }
  1157. // 计算小数位数
  1158. decimalPlaces = 0
  1159. dotIndex = strings.Index(newStr, ".") // 查找小数点的位置
  1160. if dotIndex == -1 {
  1161. decimalPlaces = 0
  1162. } else {
  1163. decimalPlaces = len(newStr) - dotIndex - 1
  1164. }
  1165. decimalPlaces += changeNum
  1166. if decimalPlaces < 0 {
  1167. decimalPlaces = 0
  1168. }
  1169. val, _ = decimal.NewFromFloat(val).Round(int32(decimalPlaces)).Float64()
  1170. newStr = strconv.FormatFloat(val, 'f', decimalPlaces, 64)
  1171. if numberType == "percent" || isPercent {
  1172. newStr += "%"
  1173. }
  1174. return
  1175. }
  1176. func fixCalculateValueConfig(conf string, edbInfoId int) (newConf string, err error) {
  1177. newConf = conf
  1178. if edbInfoId == 0 {
  1179. return
  1180. }
  1181. var tmpConfig request.CalculateConf
  1182. err = json.Unmarshal([]byte(conf), &tmpConfig)
  1183. if err != nil {
  1184. return
  1185. }
  1186. if tmpConfig.EdbInfoId == 0 {
  1187. tmpConfig.EdbInfoId = edbInfoId
  1188. newConfByte, _ := json.Marshal(tmpConfig)
  1189. newConf = string(newConfByte)
  1190. return
  1191. }
  1192. return
  1193. }