edb_info_sync.go 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  1. package data
  2. import (
  3. "hongze/hongze_task/models/data_manage"
  4. "hongze/hongze_task/utils"
  5. )
  6. //同步钢炼数据
  7. func SyncGlDataBase() {
  8. var err error
  9. defer func() {
  10. if err != nil {
  11. utils.FileLog.Info("SyncGlDataBase Err:" + err.Error())
  12. }
  13. }()
  14. var condition string
  15. var pars []interface{}
  16. condition += " AND source=? "
  17. pars = append(pars, utils.DATA_SOURCE_GL)
  18. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  19. if err != nil {
  20. return
  21. }
  22. for _, v := range items {
  23. err = data_manage.RefreshEdbDataByGl(v.EdbInfoId, v.EdbCode, v.StartDate.Format(utils.FormatDate), "")
  24. if err != nil {
  25. return
  26. }
  27. item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  28. if err != nil {
  29. return
  30. }
  31. if item != nil {
  32. err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  33. if err != nil {
  34. return
  35. }
  36. }
  37. }
  38. }
  39. //同步隆重数据
  40. func SyncLzDataBase() {
  41. var err error
  42. defer func() {
  43. if err != nil {
  44. utils.FileLog.Info("SyncLzDataBase Err:" + err.Error())
  45. }
  46. }()
  47. var condition string
  48. var pars []interface{}
  49. condition += " AND source=? "
  50. pars = append(pars, utils.DATA_SOURCE_LZ)
  51. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  52. if err != nil {
  53. return
  54. }
  55. for _, v := range items {
  56. err = data_manage.RefreshEdbDataByLz(v.EdbInfoId, v.EdbCode, v.StartDate.Format(utils.FormatDate), "")
  57. if err != nil {
  58. return
  59. }
  60. item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  61. if err != nil {
  62. return
  63. }
  64. if item != nil {
  65. err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  66. if err != nil {
  67. return
  68. }
  69. }
  70. }
  71. }
  72. //同步有色数据
  73. func SyncSmmDataBase() {
  74. var err error
  75. defer func() {
  76. if err != nil {
  77. utils.FileLog.Info("SyncSmmDataBase Err:" + err.Error())
  78. }
  79. }()
  80. var condition string
  81. var pars []interface{}
  82. condition += " AND source=? "
  83. pars = append(pars, utils.DATA_SOURCE_YS)
  84. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  85. if err != nil {
  86. return
  87. }
  88. for _, v := range items {
  89. err = data_manage.RefreshEdbDataByYs(v.EdbInfoId, v.EdbCode, v.StartDate.Format(utils.FormatDate), "")
  90. if err != nil {
  91. return
  92. }
  93. item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  94. if err != nil {
  95. return
  96. }
  97. if item != nil {
  98. err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  99. if err != nil {
  100. return
  101. }
  102. }
  103. }
  104. }
  105. //同步手工数据
  106. func SyncManualDataBase() {
  107. var err error
  108. defer func() {
  109. if err != nil {
  110. utils.FileLog.Info("SyncLzDataBase Err:" + err.Error())
  111. }
  112. }()
  113. var condition string
  114. var pars []interface{}
  115. condition += " AND source=? "
  116. pars = append(pars, utils.DATA_SOURCE_MANUAL)
  117. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  118. if err != nil {
  119. return
  120. }
  121. for _, v := range items {
  122. err = data_manage.RefreshManual(v.EdbInfoId, v.EdbCode, v.StartDate.Format(utils.FormatDate), "")
  123. if err != nil {
  124. return
  125. }
  126. item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  127. if err != nil {
  128. return
  129. }
  130. if item != nil {
  131. err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  132. if err != nil {
  133. return
  134. }
  135. }
  136. }
  137. }