initcfg.go 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. package subject_util
  2. import (
  3. log "github.com/donnie4w/go-logger/logger"
  4. qu "qfw/util"
  5. )
  6. var (
  7. SourceMgo, QyxyMgo, SpiMgo *MongodbSim
  8. TimeLayout = "2006-01-02 15:04:05"
  9. MysqlGlobalTool *Mysql
  10. BuyerClassData = map[string]string{}
  11. RegionCodeData = map[string]string{}
  12. IsLocal bool
  13. )
  14. const (
  15. S_Coll_Name = "bidding"
  16. O_Coll_Name = "zktest_subject_data"
  17. G_Units_Baseinfo = "dws_f_ent_baseinfo"
  18. G_Units_Contact = "dws_f_ent_contact"
  19. G_Units_Tags = "dws_f_ent_tags"
  20. G_Units_Warning = "dws_f_ent_warning"
  21. )
  22. func InitClass() {
  23. initMgo()
  24. initMysql()
  25. initVCode()
  26. }
  27. //初始化mgo
  28. func initMgo() {
  29. if IsLocal {
  30. SourceMgo = &MongodbSim{
  31. MongodbAddr: "127.0.0.1:27017",
  32. DbName: "mixdata",
  33. Size: 10,
  34. UserName: "",
  35. Password: "",
  36. }
  37. SourceMgo.InitPool()
  38. QyxyMgo = &MongodbSim{
  39. MongodbAddr: "127.0.0.1:27017",
  40. DbName: "mixdata",
  41. Size: 10,
  42. UserName: "",
  43. Password: "",
  44. }
  45. QyxyMgo.InitPool()
  46. SpiMgo = &MongodbSim{
  47. MongodbAddr: "127.0.0.1:27017",
  48. DbName: "mixdata",
  49. Size: 10,
  50. UserName: "",
  51. Password: "",
  52. }
  53. SpiMgo.InitPool()
  54. } else {
  55. SourceMgo = &MongodbSim{
  56. MongodbAddr: "172.17.145.163:27083,172.17.4.187:27082",
  57. DbName: "qfw",
  58. Size: 10,
  59. UserName: "zhengkun",
  60. Password: "zk@123123",
  61. }
  62. SourceMgo.InitPool()
  63. QyxyMgo = &MongodbSim{
  64. MongodbAddr: "172.17.145.163:27083,172.17.4.187:27082",
  65. DbName: "mixdata",
  66. Size: 10,
  67. UserName: "zhengkun",
  68. Password: "zk@123123",
  69. }
  70. QyxyMgo.InitPool()
  71. SpiMgo = &MongodbSim{
  72. MongodbAddr: "172.17.4.181:27001",
  73. DbName: "mixdata",
  74. Size: 10,
  75. UserName: "",
  76. Password: "",
  77. }
  78. SpiMgo.InitPool()
  79. }
  80. }
  81. func initMysql() {
  82. username, password := "root", "=PDT49#80Z!RVv52_z"
  83. address := "192.168.3.217:4000"
  84. if !IsLocal {
  85. username = "zhengkun"
  86. password = "Zk#20220824"
  87. address = "172.17.4.242:4000"
  88. }
  89. MysqlGlobalTool = &Mysql{
  90. Address: address,
  91. UserName: username,
  92. PassWord: password,
  93. DBName: "global_common_data",
  94. }
  95. MysqlGlobalTool.Init()
  96. }
  97. //加载代码表
  98. func initVCode() {
  99. data_types := MysqlGlobalTool.Find("code_buyerclass", nil, "", "", -1, -1)
  100. //先构建所有一级数据
  101. for _, v := range *data_types {
  102. name := qu.ObjToString(v["name"])
  103. code := qu.ObjToString(v["code"])
  104. BuyerClassData[name] = code
  105. }
  106. BuyerClassData["其它"] = "00"
  107. log.Debug("招标行业分类表~", len(BuyerClassData))
  108. data_regions := MysqlGlobalTool.Find("code_area", nil, "", "", -1, -1)
  109. //先构建所有一级数据
  110. for _, v := range *data_regions {
  111. area := qu.ObjToString(v["area"])
  112. city := qu.ObjToString(v["city"])
  113. district := qu.ObjToString(v["district"])
  114. code := qu.ObjToString(v["code"])
  115. key := area + "~" + city + "~" + district + "~"
  116. RegionCodeData[key] = code
  117. }
  118. log.Debug("地域信息数量~", len(RegionCodeData))
  119. }
  120. //插入数据
  121. func InsertMysqlData(name string, data map[string]interface{}, mark string) int64 {
  122. inb := MysqlGlobalTool.Insert(name, data)
  123. if inb == -1 {
  124. log.Debug("插入数据异常...", name, "~", mark)
  125. }
  126. return inb
  127. }