edb_data_calculate_ljztbpj.go 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645
  1. package models
  2. import (
  3. "errors"
  4. "eta/eta_index_lib/global"
  5. "eta/eta_index_lib/utils"
  6. "fmt"
  7. "github.com/shopspring/decimal"
  8. "gorm.io/gorm"
  9. "sort"
  10. "strings"
  11. "time"
  12. )
  13. // EdbDataCalculateLjztbpj 累计值同比拼接数据结构体
  14. type EdbDataCalculateLjztbpj struct {
  15. EdbDataId int `gorm:"primaryKey;autoIncrement;column:edb_data_id"`
  16. EdbInfoId int `gorm:"column:edb_info_id" description:"指标ID"`
  17. EdbCode string `gorm:"column:edb_code" description:"指标编码"`
  18. DataTime string `gorm:"column:data_time" description:"数据日期"`
  19. Value float64 `gorm:"column:value" description:"数据值"`
  20. Status int `gorm:"column:status" description:"状态"`
  21. CreateTime time.Time `gorm:"column:create_time" description:"创建时间"`
  22. ModifyTime time.Time `gorm:"column:modify_time" description:"修改时间"`
  23. DataTimestamp int64 `gorm:"column:data_timestamp" description:"数据日期时间戳"`
  24. }
  25. func (e *EdbDataCalculateLjztbpj) AfterFind(db *gorm.DB) (err error) {
  26. e.DataTime = utils.GormDateStrToDateStr(e.DataTime)
  27. return
  28. }
  29. // AddCalculateLjztbpj 新增累计值同比拼接数据
  30. func AddCalculateLjztbpj(req *EdbInfoCalculateBatchSaveReq, firstEdbInfo, secondEdbInfo *EdbInfo, edbCode, uniqueCode string, sysUserId int, sysUserRealName string) (edbInfo *EdbInfo, err error) {
  31. to := global.DEFAULT_DB.Begin()
  32. defer func() {
  33. if err != nil {
  34. to.Rollback()
  35. } else {
  36. to.Commit()
  37. }
  38. }()
  39. //待拼接指标map
  40. pjDataMap := make(map[string]float64)
  41. //拼接指标的日期切片数据
  42. pjEdbDataTimeList := make([]string, 0)
  43. //最近开始的时间
  44. var lastDateTime time.Time
  45. //获取待拼接指标
  46. {
  47. var condition string
  48. var pars []interface{}
  49. //获取待拼接指标最近的个12月31日有值的年份
  50. condition += " AND data_time like ? AND edb_info_id=? "
  51. pars = append(pars, "%12-31", firstEdbInfo.EdbInfoId)
  52. lastEdbData, tmpErr := GetLastEdbData(condition, pars, firstEdbInfo.Source, firstEdbInfo.SubSource)
  53. if tmpErr != nil {
  54. err = tmpErr
  55. return
  56. }
  57. lastDateTime, _ = time.ParseInLocation(utils.FormatDate, lastEdbData.DataTime, time.Local)
  58. //获取待拼接指标的数据列表
  59. firstDataList, tmpErr := GetEdbDataListAllByTo(to, firstEdbInfo.Source, firstEdbInfo.SubSource, FindEdbDataListAllCond{
  60. EdbInfoId: firstEdbInfo.EdbInfoId,
  61. EndDataTime: lastEdbData.DataTime,
  62. EndDataTimeCond: "<=",
  63. }, 0)
  64. if tmpErr != nil {
  65. err = tmpErr
  66. return
  67. }
  68. for _, v := range firstDataList {
  69. pjDataMap[v.DataTime] = v.Value
  70. pjEdbDataTimeList = append(pjEdbDataTimeList, v.DataTime)
  71. }
  72. }
  73. if req.EdbInfoId <= 0 {
  74. edbInfo = &EdbInfo{
  75. SourceName: "累计值同比拼接",
  76. Source: utils.DATA_SOURCE_CALCULATE_LJZTBPJ,
  77. EdbCode: edbCode,
  78. EdbName: req.EdbName,
  79. EdbNameSource: req.EdbName,
  80. Frequency: req.Frequency,
  81. Unit: req.Unit,
  82. StartDate: firstEdbInfo.StartDate,
  83. EndDate: firstEdbInfo.EndDate,
  84. ClassifyId: req.ClassifyId,
  85. SysUserId: sysUserId,
  86. SysUserRealName: sysUserRealName,
  87. UniqueCode: uniqueCode,
  88. CreateTime: time.Now(),
  89. ModifyTime: time.Now(),
  90. CalculateFormula: lastDateTime.Format(utils.FormatDate),
  91. EdbNameEn: req.EdbName,
  92. UnitEn: req.Unit,
  93. EdbType: 2,
  94. Sort: GetAddEdbMaxSortByClassifyId(req.ClassifyId, utils.EDB_INFO_TYPE),
  95. }
  96. tmpErr := to.Create(edbInfo).Error
  97. if tmpErr != nil {
  98. err = tmpErr
  99. return
  100. }
  101. } else {
  102. edbInfo, err = GetEdbInfoById(req.EdbInfoId)
  103. if err != nil {
  104. return
  105. }
  106. //查询
  107. tmpEdbInfo, tmpErr := GetEdbInfoById(edbInfo.EdbInfoId)
  108. if tmpErr != nil {
  109. err = tmpErr
  110. return
  111. }
  112. tmpEdbInfo.EdbName = req.EdbName
  113. tmpEdbInfo.ClassifyId = req.ClassifyId
  114. tmpEdbInfo.Frequency = req.Frequency
  115. tmpEdbInfo.Unit = req.Unit
  116. tmpEdbInfo.CalculateFormula = req.Formula
  117. edbInfo = tmpEdbInfo
  118. //删除指标数据
  119. dataTableName := GetEdbDataTableName(utils.DATA_SOURCE_CALCULATE_LJZTBPJ, utils.DATA_SUB_SOURCE_EDB)
  120. fmt.Println("dataTableName:" + dataTableName)
  121. deleteSql := ` DELETE FROM %s WHERE edb_info_id=? `
  122. deleteSql = fmt.Sprintf(deleteSql, dataTableName)
  123. err = to.Exec(deleteSql, req.EdbInfoId).Error
  124. if err != nil {
  125. return
  126. }
  127. //删除指标关系
  128. sql := ` DELETE FROM edb_info_calculate_mapping WHERE edb_info_id=? `
  129. err = to.Exec(sql, edbInfo.EdbInfoId).Error
  130. }
  131. //关联关系
  132. var existItemA, existItemB *EdbInfoCalculateMapping
  133. //拼接指标
  134. {
  135. existItemA = &EdbInfoCalculateMapping{
  136. EdbInfoCalculateMappingId: 0,
  137. EdbInfoId: edbInfo.EdbInfoId,
  138. Source: edbInfo.Source,
  139. SourceName: edbInfo.SourceName,
  140. EdbCode: edbInfo.EdbCode,
  141. FromEdbInfoId: firstEdbInfo.EdbInfoId,
  142. FromEdbCode: firstEdbInfo.EdbCode,
  143. FromEdbName: firstEdbInfo.EdbName,
  144. FromSource: firstEdbInfo.Source,
  145. FromSourceName: firstEdbInfo.SourceName,
  146. FromTag: "A",
  147. Sort: 1,
  148. CreateTime: time.Now(),
  149. ModifyTime: time.Now(),
  150. FromSubSource: firstEdbInfo.SubSource,
  151. }
  152. tmpErr := to.Create(existItemA).Error
  153. if tmpErr != nil {
  154. err = tmpErr
  155. return
  156. }
  157. }
  158. //同比值指标
  159. {
  160. existItemB = &EdbInfoCalculateMapping{
  161. EdbInfoCalculateMappingId: 0,
  162. EdbInfoId: edbInfo.EdbInfoId,
  163. Source: edbInfo.Source,
  164. SourceName: edbInfo.SourceName,
  165. EdbCode: edbInfo.EdbCode,
  166. FromEdbInfoId: secondEdbInfo.EdbInfoId,
  167. FromEdbCode: secondEdbInfo.EdbCode,
  168. FromEdbName: secondEdbInfo.EdbName,
  169. FromSource: secondEdbInfo.Source,
  170. FromSourceName: secondEdbInfo.SourceName,
  171. FromTag: "B",
  172. Sort: 1,
  173. CreateTime: time.Now(),
  174. ModifyTime: time.Now(),
  175. FromSubSource: secondEdbInfo.SubSource,
  176. }
  177. tmpErr := to.Create(existItemB).Error
  178. if tmpErr != nil {
  179. err = tmpErr
  180. return
  181. }
  182. }
  183. // 添加数据
  184. err = refreshAllCalculateLjztbpj(to, edbInfo, existItemA, existItemB)
  185. return
  186. }
  187. // EditCalculateLjztbpj 编辑累计值同比拼接数据
  188. func EditCalculateLjztbpj(req *EdbInfoCalculateBatchEditReq, edbInfo, firstEdbInfo, secondEdbInfo *EdbInfo) (err error) {
  189. to := global.DEFAULT_DB.Begin()
  190. defer func() {
  191. if err != nil {
  192. to.Rollback()
  193. } else {
  194. to.Commit()
  195. }
  196. }()
  197. nowEdbInfo := *edbInfo // 现在的指标信息
  198. sql := ``
  199. //修改指标信息
  200. edbInfo.EdbNameSource = req.EdbName
  201. edbInfo.Frequency = req.Frequency
  202. edbInfo.Unit = req.Unit
  203. edbInfo.ClassifyId = req.ClassifyId
  204. //edbInfo.CalculateFormula = req.Formula
  205. edbInfo.EdbNameEn = req.EdbNameEn
  206. edbInfo.UnitEn = req.UnitEn
  207. edbInfo.ModifyTime = time.Now()
  208. err = to.Model(edbInfo).Select([]string{"EdbName", "EdbNameSource", "Frequency", "Unit", "ClassifyId", "ModifyTime", "EdbNameEn", "UnitEn"}).Updates(edbInfo).Error
  209. if err != nil {
  210. return
  211. }
  212. //查询出所有的关联指标
  213. var existCondition string
  214. var existPars []interface{}
  215. existCondition += " AND edb_info_id=? "
  216. existPars = append(existPars, edbInfo.EdbInfoId)
  217. existList, err := GetEdbInfoCalculateListByCondition(existCondition, existPars)
  218. if err != nil {
  219. err = errors.New("判断指标是否改变失败,Err:" + err.Error())
  220. return
  221. }
  222. var existItemA, existItemB *EdbInfoCalculateMapping
  223. for _, existItem := range existList {
  224. if existItem.FromTag == "A" {
  225. existItemA = existItem
  226. } else if existItem.FromTag == "B" {
  227. existItemB = existItem
  228. }
  229. }
  230. // 是否需要删除数据重新计算
  231. isNeedCalculateData := false
  232. // 如果截止日期变更,那么需要重新计算
  233. if req.Formula != nowEdbInfo.CalculateFormula {
  234. isNeedCalculateData = true
  235. }
  236. //待拼接指标数据
  237. //如果拼接指标变更了,那么需要删除所有的指标进行重新拼接
  238. if existItemA.FromEdbInfoId != firstEdbInfo.EdbInfoId {
  239. //删除之前的A指标关联关系
  240. sql := ` DELETE FROM edb_info_calculate_mapping WHERE edb_info_id = ? and from_edb_info_id = ?`
  241. err = to.Exec(sql, edbInfo.EdbInfoId, existItemA.FromEdbInfoId).Error
  242. if err != nil {
  243. err = errors.New("删除拼接日期之前的指标关联关系失败,Err:" + err.Error())
  244. return
  245. }
  246. //添加新的指标关系
  247. {
  248. existItemA = &EdbInfoCalculateMapping{
  249. EdbInfoCalculateMappingId: 0,
  250. EdbInfoId: edbInfo.EdbInfoId,
  251. Source: edbInfo.Source,
  252. SourceName: edbInfo.SourceName,
  253. EdbCode: edbInfo.EdbCode,
  254. FromEdbInfoId: firstEdbInfo.EdbInfoId,
  255. FromEdbCode: firstEdbInfo.EdbCode,
  256. FromEdbName: firstEdbInfo.EdbName,
  257. FromSource: firstEdbInfo.Source,
  258. FromSourceName: firstEdbInfo.SourceName,
  259. FromTag: "A",
  260. Sort: 1,
  261. CreateTime: time.Now(),
  262. ModifyTime: time.Now(),
  263. FromSubSource: firstEdbInfo.SubSource,
  264. }
  265. tmpErr := to.Create(existItemA).Error
  266. if tmpErr != nil {
  267. err = tmpErr
  268. return
  269. }
  270. isNeedCalculateData = true
  271. }
  272. }
  273. //同比值指标
  274. if existItemB.FromEdbInfoId != secondEdbInfo.EdbInfoId {
  275. //删除之前的B指标关联关系
  276. sql = ` DELETE FROM edb_info_calculate_mapping WHERE edb_info_id = ? and from_edb_info_id = ?`
  277. err = to.Exec(sql, edbInfo.EdbInfoId, existItemB.FromEdbInfoId).Error
  278. if err != nil {
  279. err = errors.New("删除拼接日期之后的指标关联关系失败,Err:" + err.Error())
  280. return
  281. }
  282. //添加新的指标关系
  283. {
  284. existItemB = &EdbInfoCalculateMapping{
  285. EdbInfoCalculateMappingId: 0,
  286. EdbInfoId: edbInfo.EdbInfoId,
  287. Source: edbInfo.Source,
  288. SourceName: edbInfo.SourceName,
  289. EdbCode: edbInfo.EdbCode,
  290. FromEdbInfoId: secondEdbInfo.EdbInfoId,
  291. FromEdbCode: secondEdbInfo.EdbCode,
  292. FromEdbName: secondEdbInfo.EdbName,
  293. FromSource: secondEdbInfo.Source,
  294. FromSourceName: secondEdbInfo.SourceName,
  295. FromTag: "B",
  296. Sort: 2,
  297. CreateTime: time.Now(),
  298. ModifyTime: time.Now(),
  299. FromSubSource: secondEdbInfo.SubSource,
  300. }
  301. tmpErr := to.Create(existItemB).Error
  302. if tmpErr != nil {
  303. err = tmpErr
  304. return
  305. }
  306. isNeedCalculateData = true
  307. }
  308. }
  309. // 如果需要重新计算,那么先删除所有的指标数据,然后再重新计算
  310. if isNeedCalculateData {
  311. // 删除之前所有的指标数据
  312. tableName := GetEdbDataTableName(edbInfo.Source, edbInfo.SubSource)
  313. sql = fmt.Sprintf(` DELETE FROM %s WHERE edb_info_id = ? `, tableName)
  314. err = to.Exec(sql, edbInfo.EdbInfoId).Error
  315. if err != nil {
  316. err = errors.New("删除所有的累计值同比拼接指标数据失败,Err:" + err.Error())
  317. return
  318. }
  319. //获取待拼接指标最近一年的12月份日期
  320. {
  321. var condition string
  322. var pars []interface{}
  323. //获取待拼接指标最近的个12月31日有值的年份
  324. condition += " AND data_time like ? AND edb_info_id=? "
  325. pars = append(pars, "%12-31", firstEdbInfo.EdbInfoId)
  326. lastEdbData, tmpErr := GetLastEdbData(condition, pars, firstEdbInfo.Source, firstEdbInfo.SubSource)
  327. if tmpErr != nil {
  328. err = tmpErr
  329. return
  330. }
  331. lastDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, lastEdbData.DataTime, time.Local)
  332. if tmpErr != nil {
  333. err = tmpErr
  334. return
  335. }
  336. edbInfo.CalculateFormula = lastDateTime.Format(utils.FormatDate)
  337. err = to.Model(edbInfo).Select([]string{"CalculateFormula"}).Updates(edbInfo).Error
  338. if err != nil {
  339. return
  340. }
  341. }
  342. // 重新计算
  343. err = refreshAllCalculateLjztbpj(to, edbInfo, existItemA, existItemB)
  344. }
  345. return
  346. }
  347. // RefreshAllCalculateLjztbpj 刷新所有 累计值同比拼接 数据
  348. func RefreshAllCalculateLjztbpj(edbInfo *EdbInfo) (err error) {
  349. to := global.DEFAULT_DB.Begin()
  350. defer func() {
  351. if err != nil {
  352. to.Rollback()
  353. } else {
  354. to.Commit()
  355. }
  356. }()
  357. //查询关联指标信息
  358. var existCondition string
  359. var existPars []interface{}
  360. existCondition += " AND edb_info_id=? "
  361. existPars = append(existPars, edbInfo.EdbInfoId)
  362. existList, err := GetEdbInfoCalculateListByCondition(existCondition, existPars)
  363. if err != nil {
  364. err = errors.New("判断指标是否改变失败,Err:" + err.Error())
  365. return
  366. }
  367. var existItemA, existItemB *EdbInfoCalculateMapping
  368. for _, existItem := range existList {
  369. if existItem.FromTag == "A" {
  370. existItemA = existItem
  371. } else if existItem.FromTag == "B" {
  372. existItemB = existItem
  373. }
  374. }
  375. // 刷新数据
  376. err = refreshAllCalculateLjztbpj(to, edbInfo, existItemA, existItemB)
  377. return
  378. }
  379. // refreshAllCalculateLjztbpj 刷新所有 累计值同比拼接 数据
  380. func refreshAllCalculateLjztbpj(to *gorm.DB, edbInfo *EdbInfo, existItemA, existItemB *EdbInfoCalculateMapping) (err error) {
  381. //查询当前指标现有的数据
  382. var condition string
  383. var pars []interface{}
  384. condition += " AND edb_info_id=? "
  385. pars = append(pars, edbInfo.EdbInfoId)
  386. //根据指标id获取全部的数据
  387. var dataList []*EdbDataCalculateLjztbpj
  388. sql := ` SELECT * FROM edb_data_calculate_ljztbpj WHERE edb_info_id=? ORDER BY data_time DESC `
  389. err = to.Raw(sql, edbInfo.EdbInfoId).Find(&dataList).Error
  390. if err != nil {
  391. return err
  392. }
  393. //待拼接指标map
  394. pjDataMap := make(map[string]float64) //需要入库的数据
  395. nowEdbDataMap := make(map[string]float64) //当前指标的数据(已经在库里了,不需要重新)
  396. //拼接指标的日期切片数据
  397. pjEdbDataTimeList := make([]string, 0)
  398. dataMap := make(map[string]*EdbDataCalculateLjztbpj)
  399. for _, v := range dataList {
  400. pjEdbDataTimeList = append(pjEdbDataTimeList, v.DataTime)
  401. dataMap[v.DataTime] = v
  402. nowEdbDataMap[v.DataTime] = v.Value
  403. }
  404. // 原数据开始计算日期
  405. startCalculationDate, _ := time.ParseInLocation(utils.FormatDate, edbInfo.CalculateFormula, time.Local)
  406. //待拼接指标
  407. {
  408. //第一个指标的数据列表
  409. firstDataList, tmpErr := GetEdbDataListAllByTo(to, existItemA.FromSource, existItemA.FromSubSource, FindEdbDataListAllCond{
  410. EdbInfoId: existItemA.FromEdbInfoId,
  411. EndDataTime: startCalculationDate.Format(utils.FormatDate),
  412. EndDataTimeCond: "<=",
  413. }, 0)
  414. if tmpErr != nil {
  415. return tmpErr
  416. }
  417. for _, v := range firstDataList {
  418. //时间戳
  419. if edbData, ok := dataMap[v.DataTime]; ok {
  420. if edbData.Value != v.Value {
  421. //更新指标数据
  422. edbData.Value = v.Value
  423. _ = to.Model(edbData).Select([]string{"Value"}).Updates(edbData).Error
  424. }
  425. } else {
  426. pjDataMap[v.DataTime] = v.Value
  427. pjEdbDataTimeList = append(pjEdbDataTimeList, v.DataTime)
  428. }
  429. //将新的数据存入已入库指标map里面,以便后续计算
  430. nowEdbDataMap[v.DataTime] = v.Value
  431. }
  432. }
  433. //同比值指标map
  434. tbzEdbDataMap := make(map[string]float64)
  435. //同比值日期切片列表
  436. tbzEdbDataTimeList := make([]string, 0)
  437. //同比值指标
  438. {
  439. //第二个指标的数据列表
  440. secondDataList, tmpErr := GetEdbDataListAllByTo(to, existItemB.FromSource, existItemB.FromSubSource, FindEdbDataListAllCond{
  441. EdbInfoId: existItemB.FromEdbInfoId,
  442. StartDataTime: startCalculationDate.Format(utils.FormatDate),
  443. StartDataTimeCond: ">",
  444. }, 0)
  445. if tmpErr != nil {
  446. return tmpErr
  447. }
  448. for _, v := range secondDataList {
  449. tbzEdbDataMap[v.DataTime] = v.Value
  450. tbzEdbDataTimeList = append(tbzEdbDataTimeList, v.DataTime)
  451. }
  452. }
  453. sort.Strings(tbzEdbDataTimeList)
  454. // 遍历现有的数据,判断拼接指标中是否存在该日期数据,如果拼接指标无此数据,那么需要删除该日期数据(日期的判断:需要在开始计算日期之后)
  455. removeDateList := make([]string, 0)
  456. for nowEdbDate := range nowEdbDataMap {
  457. nowEdbDateTime, _ := time.ParseInLocation(utils.FormatDate, nowEdbDate, time.Local)
  458. //校验日期 需要 大于 拼接前日期
  459. if startCalculationDate.Before(nowEdbDateTime) {
  460. if _, ok := tbzEdbDataMap[nowEdbDate]; !ok {
  461. // 同比指标中,不存在该日期数据,那么需要移除 现有数据 中该日期的数据
  462. removeDateList = append(removeDateList, nowEdbDate)
  463. }
  464. }
  465. }
  466. //待修改的指标数据map(index:日期,value:值)
  467. updateEdbDataMap := make(map[string]float64)
  468. for _, v := range tbzEdbDataTimeList {
  469. tbzDataTime, _ := time.ParseInLocation(utils.FormatDate, v, time.Local)
  470. //获取拼接指标上一年同一天的数据
  471. var pjDataTime time.Time
  472. if tbzDataTime.Month() == 2 {
  473. pjDataTime = tbzDataTime.AddDate(0, -11, 0)
  474. pjDataTime = time.Date(pjDataTime.Year(), pjDataTime.Month(), 1, 0, 0, 0, 0, time.Now().Location()).AddDate(0, 0, -1)
  475. } else {
  476. pjDataTime = tbzDataTime.AddDate(-1, 0, 0)
  477. }
  478. //校验现有数据中,是否存在该日期的数据,如果存在的话,那么就要去校验 最新计算数据 与 现有数据 是否一致
  479. if nowEdbDataValue, isHas := nowEdbDataMap[v]; isHas {
  480. //获取去年今日的数据,获取到后,然后是去修改该日期的数据
  481. if lastYearEdbDataValue, ok := nowEdbDataMap[pjDataTime.Format(utils.FormatDate)]; ok {
  482. if v == "2021-08-31" {
  483. fmt.Println("进来了")
  484. }
  485. tbzDataValue := tbzEdbDataMap[v] //同比值
  486. currValue := lastYearEdbDataValue * (1 + tbzDataValue/100)
  487. currValue, _ = decimal.NewFromFloat(currValue).Truncate(4).Float64() //保留4位小数
  488. //如果计算出来的值与库里面的值不匹配,那么就去修改该值
  489. if nowEdbDataValue != currValue {
  490. //将计算后的数据存入待拼接指标map里面,以便后续计算
  491. updateEdbDataMap[v] = currValue
  492. }
  493. }
  494. } else {
  495. //因为 现有数据中 不存在该日期数据,那么需要做新增数据处理
  496. //如果去年今日存在该数据,那么就去计算当前的数据
  497. if pjDataValue, ok := nowEdbDataMap[pjDataTime.Format(utils.FormatDate)]; ok {
  498. tbzDataValue := tbzEdbDataMap[v] //同比值
  499. currValue := pjDataValue * (1 + tbzDataValue/100)
  500. currValue, _ = decimal.NewFromFloat(currValue).Truncate(4).Float64()
  501. //将计算后的数据存入已入库指标map里面,以便后续计算
  502. nowEdbDataMap[v] = currValue
  503. //将计算后的数据存入待拼接指标map里面,以便后续入库
  504. pjDataMap[v] = currValue
  505. pjEdbDataTimeList = append(pjEdbDataTimeList, v)
  506. }
  507. }
  508. }
  509. //新增的数据入库
  510. {
  511. addDataList := make([]*EdbDataCalculateLjztbpj, 0)
  512. //日期排序下
  513. sort.Strings(pjEdbDataTimeList)
  514. //这么做的目的是为了让数据插入的时候,可以正序插入(业务上没啥卵用,就是为了让我看数据的时候舒服点,手动狗头-_-|)
  515. for _, dataTime := range pjEdbDataTimeList {
  516. if dataValue, ok := pjDataMap[dataTime]; ok {
  517. //时间戳
  518. currentDate, _ := time.ParseInLocation(utils.FormatDate, dataTime, time.Local)
  519. timestamp := currentDate.UnixNano() / 1e6
  520. edbDataLjztbpj := &EdbDataCalculateLjztbpj{
  521. EdbInfoId: edbInfo.EdbInfoId,
  522. EdbCode: edbInfo.EdbCode,
  523. DataTime: dataTime,
  524. Value: dataValue,
  525. Status: 1,
  526. CreateTime: time.Now(),
  527. ModifyTime: time.Now(),
  528. DataTimestamp: timestamp,
  529. }
  530. addDataList = append(addDataList, edbDataLjztbpj)
  531. }
  532. }
  533. //数据入库
  534. if len(addDataList) > 0 {
  535. tmpErr := to.CreateInBatches(addDataList, utils.MultiAddNum).Error
  536. if tmpErr != nil {
  537. err = tmpErr
  538. return
  539. }
  540. }
  541. }
  542. //删除已经不存在的累计同比拼接指标数据(由于同比值当日的数据删除了)
  543. {
  544. if len(removeDateList) > 0 {
  545. removeDateStr := strings.Join(removeDateList, `','`)
  546. removeDateStr = `'` + removeDateStr + `'`
  547. //如果拼接指标变更了,那么需要删除所有的指标数据
  548. tableName := GetEdbDataTableName(edbInfo.Source, edbInfo.SubSource)
  549. sql := fmt.Sprintf(` DELETE FROM %s WHERE edb_info_id = ? and data_time in (%s) `, tableName, removeDateStr)
  550. err = to.Exec(sql, edbInfo.EdbInfoId).Error
  551. if err != nil {
  552. err = errors.New("删除不存在的累计值同比拼接指标数据失败,Err:" + err.Error())
  553. return
  554. }
  555. }
  556. }
  557. //修改现有的数据中对应的值
  558. {
  559. tableName := GetEdbDataTableName(edbInfo.Source, edbInfo.SubSource)
  560. for edbDate, edbDataValue := range updateEdbDataMap {
  561. sql := fmt.Sprintf(` UPDATE %s set value = ?,modify_time=now() WHERE edb_info_id = ? and data_time = ? `, tableName)
  562. err = to.Exec(sql, edbDataValue, edbInfo.EdbInfoId, edbDate).Error
  563. if err != nil {
  564. err = errors.New("更新现有的累计值同比拼接指标数据失败,Err:" + err.Error())
  565. return
  566. }
  567. }
  568. }
  569. return
  570. }