task.go 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281
  1. package main
  2. import (
  3. "fmt"
  4. "github.com/cron"
  5. "go.mongodb.org/mongo-driver/bson"
  6. "log"
  7. "qfw/util"
  8. "regexp"
  9. "strings"
  10. "sync"
  11. "time"
  12. )
  13. var MgoSaveCache = make(chan map[string]interface{}, 5000)
  14. var SP = make(chan bool, 5)
  15. var updatePool = make(chan []map[string]interface{}, 5000)
  16. var updateSp = make(chan bool, 5)
  17. func TimeTask() {
  18. c := cron.New()
  19. //cronstr := "0 0 " + fmt.Sprint(TaskTime) + " * * ?" //每天TaskTime跑一次
  20. cronstrPa := "0 0 15 ? * WED" //凭安增量数据每周二跑一次
  21. _ = c.AddFunc(cronstrPa, func() { GetData() })
  22. c.Start()
  23. }
  24. func GetData() {
  25. defer util.Catch()
  26. sess := Mgo.GetMgoConn()
  27. defer Mgo.DestoryMongoConn(sess)
  28. pool := make(chan bool, 10)
  29. wg := &sync.WaitGroup{}
  30. q := bson.M{"_id": bson.M{"$gt": lastId}}
  31. //q := bson.M{"_id": 368454367}
  32. var zid int
  33. it := sess.DB("mixdata").C("company_change").Find(q).Select(nil).Iter()
  34. count := 0
  35. for tmp := make(map[string]interface{}); it.Next(&tmp); count++ {
  36. if count%20000 == 0 {
  37. log.Println("current:", count)
  38. }
  39. zid = util.IntAll(tmp["_id"])
  40. pool <- true
  41. wg.Add(1)
  42. go func(tmp map[string]interface{}) {
  43. defer func() {
  44. <-pool
  45. wg.Done()
  46. }()
  47. currentTime := time.Now().Unix()
  48. query := bson.M{"company_id": tmp["company_id"]}
  49. info, b := MgoMix.FindOneByField(CollSave, query, bson.M{"changes": 1})
  50. if b && len(*info) > 0 {
  51. if util.ObjToString(tmp["_operation_type"]) == "insert" {
  52. update := make(map[string]interface{})
  53. item := make(map[string]interface{})
  54. item["change_field"] = tmp["change_field"]
  55. item["content_before"] = tmp["content_before"]
  56. item["content_after"] = tmp["content_after"]
  57. item["change_date"] = tmp["change_date"]
  58. setMark(item) //change_name_new
  59. //update["changes"] = changes
  60. update["update_time"] = currentTime
  61. saveInfo := map[string]interface{}{"$set": update, "$push": map[string]interface{}{"changes": item}}
  62. //updatePool <- saveInfo
  63. MgoMix.UpdateById(CollSave, tmp["company_id"], saveInfo)
  64. }
  65. } else {
  66. query := bson.M{"_id": tmp["company_id"]}
  67. qyxy, b1 := MgoMix.FindOne("qyxy_std", query)
  68. if b1 && len(*qyxy) > 0 {
  69. save := make(map[string]interface{})
  70. var changes []map[string]interface{}
  71. item := make(map[string]interface{})
  72. item["change_field"] = tmp["change_field"]
  73. item["content_before"] = tmp["content_before"]
  74. item["content_after"] = tmp["content_after"]
  75. item["change_date"] = tmp["change_date"]
  76. setMark(item) //change_name_new
  77. changes = append(changes, item)
  78. save["company_name"] = (*qyxy)["company_name"]
  79. save["company_id"] = (*qyxy)["_id"]
  80. save["changes"] = changes
  81. save["create_time"] = currentTime
  82. save["update_time"] = currentTime
  83. //save["_id"] = primitive.NewObjectID()
  84. saveInfo := map[string]interface{}{"$set": save}
  85. //updatePool <- saveInfo
  86. MgoMix.Save(CollSave, saveInfo)
  87. }
  88. }
  89. }(tmp)
  90. }
  91. util.Debug("over---", count, zid)
  92. }
  93. func setMark(tmp map[string]interface{}) {
  94. for _, v := range ChangeMap {
  95. str := util.ObjToString(tmp["change_field"])
  96. regArr := v["change_key_reg"].([]string)
  97. for _, v1 := range regArr {
  98. matched, _ := regexp.MatchString(v1, str)
  99. if matched {
  100. tmp["change_name_new"] = v["change_name"]
  101. return
  102. }
  103. }
  104. }
  105. }
  106. func clearRepeat(list []interface{}) []interface{} {
  107. var tmp []interface{}
  108. if len(list) > 1 {
  109. for k, v := range list {
  110. if k < len(list)-1 {
  111. if fmt.Sprint(list[k]) != fmt.Sprint(list[k+1]) {
  112. tmp = append(tmp, v)
  113. }
  114. } else {
  115. tmp = append(tmp, v)
  116. }
  117. }
  118. return tmp
  119. } else {
  120. return list
  121. }
  122. }
  123. // TaskAll 存量数据
  124. func TaskAll() {
  125. defer util.Catch()
  126. sess := MgoMix.GetMgoConn()
  127. defer MgoMix.DestoryMongoConn(sess)
  128. pool := make(chan bool, 10)
  129. wg := &sync.WaitGroup{}
  130. field := bson.M{"company_name": 1}
  131. it := sess.DB("mixdata").C(CollQy).Find(nil).Select(field).Iter()
  132. count := 0
  133. for tmp := make(map[string]interface{}); it.Next(&tmp); count++ {
  134. if count%20000 == 0 {
  135. log.Println("current:", count, tmp["_id"])
  136. }
  137. if strings.Contains(util.ObjToString(tmp["company_type"]), "个体") {
  138. continue
  139. }
  140. pool <- true
  141. wg.Add(1)
  142. go func(tmp map[string]interface{}) {
  143. defer func() {
  144. <-pool
  145. wg.Done()
  146. }()
  147. tmp["company_id"] = tmp["_id"]
  148. delete(tmp, "_id")
  149. query := bson.M{"company_id": tmp["company_id"]}
  150. info, b := Mgo.Find("company_change", query, nil, nil, false, -1, -1)
  151. if b && len(*info) > 0 {
  152. disposeFuc(*info, tmp)
  153. }
  154. }(tmp)
  155. }
  156. }
  157. func taskInfo(id string) {
  158. update := make(map[string]interface{})
  159. q := map[string]interface{}{"company_id": id}
  160. info, _ := Mgo.Find("company_change", q, nil, nil, false, -1, -1)
  161. if len(*info) > 0 {
  162. var changes []map[string]interface{}
  163. currentTime := time.Now().Unix()
  164. for _, v := range *info {
  165. item := make(map[string]interface{})
  166. item["change_field"] = v["change_field"]
  167. item["content_before"] = v["content_before"]
  168. item["content_after"] = v["content_after"]
  169. item["change_date"] = v["change_date"]
  170. setMark(item) //change_name_new
  171. changes = append(changes, item)
  172. }
  173. update["changes"] = changes
  174. update["update_time"] = currentTime
  175. }
  176. util.Debug(update)
  177. MgoMix.Update("qyxy_change", q, map[string]interface{}{"$set": update}, false, false)
  178. }
  179. func disposeFuc(maps []map[string]interface{}, tmp map[string]interface{}) {
  180. var changes []map[string]interface{}
  181. currentTime := time.Now().Unix()
  182. for _, v := range maps {
  183. item := make(map[string]interface{})
  184. item["change_field"] = v["change_field"]
  185. item["content_before"] = v["content_before"]
  186. item["content_after"] = v["content_after"]
  187. item["change_date"] = v["change_date"]
  188. setMark(item) //change_name_new
  189. changes = append(changes, item)
  190. }
  191. tmp["changes"] = changes
  192. tmp["create_time"] = currentTime
  193. tmp["update_time"] = currentTime
  194. MgoSaveCache <- tmp
  195. }
  196. func SaveData() {
  197. log.Println("Mgo Save...")
  198. arru := make([]map[string]interface{}, 200)
  199. indexu := 0
  200. for {
  201. select {
  202. case v := <-MgoSaveCache:
  203. arru[indexu] = v
  204. indexu++
  205. if indexu == 200 {
  206. SP <- true
  207. go func(arru []map[string]interface{}) {
  208. defer func() {
  209. <-SP
  210. }()
  211. MgoMix.SaveBulk(CollSave, arru...)
  212. }(arru)
  213. arru = make([]map[string]interface{}, 200)
  214. indexu = 0
  215. }
  216. case <-time.After(1000 * time.Millisecond):
  217. if indexu > 0 {
  218. SP <- true
  219. go func(arru []map[string]interface{}) {
  220. defer func() {
  221. <-SP
  222. }()
  223. MgoMix.SaveBulk(CollSave, arru...)
  224. }(arru[:indexu])
  225. arru = make([]map[string]interface{}, 200)
  226. indexu = 0
  227. }
  228. }
  229. }
  230. }
  231. func updateMethod() {
  232. arru := make([][]map[string]interface{}, 200)
  233. indexu := 0
  234. for {
  235. select {
  236. case v := <-updatePool:
  237. arru[indexu] = v
  238. indexu++
  239. if indexu == 200 {
  240. updateSp <- true
  241. go func(arru [][]map[string]interface{}) {
  242. defer func() {
  243. <-updateSp
  244. }()
  245. MgoMix.UpSertBulk(CollSave, arru...)
  246. }(arru)
  247. arru = make([][]map[string]interface{}, 200)
  248. indexu = 0
  249. }
  250. case <-time.After(1000 * time.Millisecond):
  251. if indexu > 0 {
  252. updateSp <- true
  253. go func(arru [][]map[string]interface{}) {
  254. defer func() {
  255. <-updateSp
  256. }()
  257. MgoMix.UpSertBulk(CollSave, arru...)
  258. }(arru[:indexu])
  259. arru = make([][]map[string]interface{}, 200)
  260. indexu = 0
  261. }
  262. }
  263. }
  264. }