compute_statistic.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554
  1. package crontask
  2. import (
  3. "strconv"
  4. "strings"
  5. "time"
  6. "wechat-api/ent"
  7. "wechat-api/ent/contact"
  8. "wechat-api/ent/custom_types"
  9. "wechat-api/ent/labelrelationship"
  10. "wechat-api/ent/messagerecords"
  11. "wechat-api/ent/usagedetail"
  12. "wechat-api/ent/usagestatisticday"
  13. "wechat-api/ent/usagestatistichour"
  14. "wechat-api/ent/wx"
  15. )
  16. func (l *CronTask) computeStatistic() {
  17. startTime := time.Now()
  18. // 获取所有机器人信息
  19. wxbots, err := l.svcCtx.DB.Wx.Query().Select(wx.FieldWxid, wx.FieldID, wx.FieldOrganizationID).All(l.ctx)
  20. if err != nil {
  21. l.Errorf("fetch wxids error:%v\n", err)
  22. return
  23. }
  24. wxbotsSet := make(map[uint64][]*ent.Wx)
  25. for _, bot := range wxbots {
  26. if !strings.HasPrefix(bot.Wxid, "temp-") {
  27. wxbotsSet[bot.OrganizationID] = append(wxbotsSet[bot.OrganizationID], bot)
  28. }
  29. }
  30. LabelsCountSet := make(map[uint64][]custom_types.LabelDist)
  31. /*
  32. 计算本小时的数据
  33. 1. 查询出上小时里所有 usagedetail 内容
  34. 2. 挨个遍历他的 bot_id ,再查询他的 bot_id 相关的参数
  35. 3. 遍历的时候可能有重复,所以要先检查是否生成了数据,如果有就忽略,没有再生成
  36. ----------------------------------------------------------------------------------------------------------
  37. */
  38. // 获取当前时间
  39. now := time.Now()
  40. // 获取本小时的第一分钟
  41. currentHour := time.Date(now.Year(), now.Month(), now.Day(), now.Hour(), 0, 0, 0, now.Location())
  42. currentHourInt, _ := strconv.Atoi(currentHour.Format("2006010215"))
  43. // 上一个小时的起始时间
  44. lastHour := currentHour.Add(-time.Hour * 1)
  45. lastHourInt, _ := strconv.Atoi(lastHour.Format("2006010215"))
  46. lc := []custom_types.LabelDist{}
  47. var allHourAiResponseInt, allHourSopRunInt, allHourFriendCountInt, allHourGroupCountInt, allHourAccountBalanceInt, allHourConsumeTokenInt, allHourActiveUserInt, allHourNewUserInt int
  48. for orgID, wxinfos := range wxbotsSet {
  49. var orgAiResponseInt, orgSopRunInt, orgFriendCountInt, orgGroupCountInt, orgAccountBalanceInt, orgConsumeTokenInt, orgActiveUserInt, orgNewUserInt int
  50. for _, wxinfo := range wxinfos {
  51. l.Logger.Infof("开始计算小时数据:%d\n", lastHourInt)
  52. // 先判断该账号是否已经统计了小时数据,如果已经统计了,就不需要再统计了
  53. var aiResponseInt, sopRunInt, friendCountInt, groupCountInt, accountBalanceInt, consumeTokenInt, activeUserInt, newUserInt int
  54. hourDataCount, _ := l.svcCtx.DB.UsageStatisticHour.Query().Where(
  55. usagestatistichour.Type(1),
  56. usagestatistichour.BotID(wxinfo.Wxid),
  57. usagestatistichour.Addtime(uint64(lastHourInt)),
  58. ).Count(l.ctx)
  59. if hourDataCount > 0 {
  60. continue
  61. }
  62. // AI回复包括:SOP次数+AI次数
  63. // SOP次数:content 非空,source_type = 3 或 4,sub_source_id = 0
  64. // AI次数:app = 1 或 3
  65. sopresp, _ := l.svcCtx.DB.MessageRecords.Query().Where(
  66. messagerecords.SubSourceID(0),
  67. messagerecords.SourceTypeIn(3, 4),
  68. messagerecords.BotWxid(wxinfo.Wxid),
  69. messagerecords.CreatedAtGTE(lastHour),
  70. messagerecords.CreatedAtLT(currentHour),
  71. ).Count(l.ctx)
  72. airesp, _ := l.svcCtx.DB.UsageDetail.Query().Where(
  73. usagedetail.AppIn(1, 3),
  74. usagedetail.BotID(wxinfo.Wxid),
  75. usagedetail.CreatedAtGTE(lastHour),
  76. usagedetail.CreatedAtLT(currentHour),
  77. ).Count(l.ctx)
  78. aiResponseInt = sopresp + airesp
  79. orgAiResponseInt += aiResponseInt
  80. allHourAiResponseInt += aiResponseInt
  81. // SOP执行次数:SOP阶段和节点的执行次数。
  82. sopRunInt, _ = l.svcCtx.DB.MessageRecords.Query().Where(
  83. messagerecords.BotWxid(wxinfo.Wxid),
  84. messagerecords.SubSourceIDEQ(0),
  85. messagerecords.SourceTypeIn(3, 4),
  86. messagerecords.BotWxid(wxinfo.Wxid),
  87. messagerecords.CreatedAtGTE(lastHour),
  88. messagerecords.CreatedAtLT(currentHour),
  89. ).Count(l.ctx)
  90. orgSopRunInt += sopRunInt
  91. allHourSopRunInt += sopRunInt
  92. // 好友总数:contact 表中 type=1
  93. friendCountInt, _ = l.svcCtx.DB.Contact.Query().Where(
  94. contact.Type(1),
  95. contact.WxWxid(wxinfo.Wxid),
  96. contact.Ctype(1),
  97. ).Count(l.ctx)
  98. orgFriendCountInt += friendCountInt
  99. allHourFriendCountInt += friendCountInt
  100. // 群总数:contact 表中 type=2
  101. groupCountInt, _ = l.svcCtx.DB.Contact.Query().Where(
  102. contact.Type(2),
  103. contact.WxWxid(wxinfo.Wxid),
  104. contact.Ctype(1),
  105. ).Count(l.ctx)
  106. orgGroupCountInt += groupCountInt
  107. allHourGroupCountInt += groupCountInt
  108. // 消耗Token数:usage_detail 表
  109. consumeTokenInt, _ = l.svcCtx.DB.UsageDetail.Query().Where(
  110. usagedetail.TypeEQ(1),
  111. usagedetail.BotID(wxinfo.Wxid),
  112. usagedetail.CreatedAtGTE(lastHour),
  113. usagedetail.CreatedAtLT(currentHour),
  114. ).Aggregate(ent.Sum("total_tokens")).Int(l.ctx)
  115. orgConsumeTokenInt += consumeTokenInt
  116. allHourConsumeTokenInt += consumeTokenInt
  117. // 账户余额
  118. accountBalanceInt = 0
  119. orgAccountBalanceInt = 0
  120. allHourAccountBalanceInt = 0
  121. // 活跃好友:usage_detail 表 type = 1
  122. activeUsers, _ := l.svcCtx.DB.UsageDetail.Query().Where(
  123. usagedetail.Type(1),
  124. usagedetail.BotID(wxinfo.Wxid),
  125. usagedetail.CreatedAtGTE(lastHour),
  126. usagedetail.CreatedAtLT(currentHour),
  127. ).GroupBy(usagedetail.FieldReceiverID).Strings(l.ctx)
  128. activeUserInt = len(activeUsers)
  129. orgActiveUserInt += activeUserInt
  130. allHourActiveUserInt += activeUserInt
  131. lastHourData, _ := l.svcCtx.DB.UsageStatisticHour.Query().Where(
  132. usagestatistichour.AddtimeEQ(uint64(lastHourInt)),
  133. usagestatistichour.Type(1),
  134. usagestatistichour.BotID(wxinfo.Wxid),
  135. ).First(l.ctx)
  136. if lastHourData == nil {
  137. newUserInt = 0
  138. } else {
  139. newUserInt = friendCountInt - int(lastHourData.TotalFriend)
  140. }
  141. orgNewUserInt += newUserInt
  142. allHourNewUserInt += newUserInt
  143. _, err := l.svcCtx.DB.UsageStatisticHour.Create().
  144. SetType(1).
  145. SetBotID(wxinfo.Wxid).
  146. SetOrganizationID(wxinfo.OrganizationID).
  147. SetAiResponse(uint64(aiResponseInt)).
  148. SetSopRun(uint64(sopRunInt)).
  149. SetTotalFriend(uint64(friendCountInt)).
  150. SetTotalGroup(uint64(groupCountInt)).
  151. SetAccountBalance(uint64(accountBalanceInt)).
  152. SetConsumeToken(uint64(consumeTokenInt)).
  153. SetActiveUser(uint64(activeUserInt)).
  154. SetNewUser(int64(newUserInt)).
  155. SetAddtime(uint64(lastHourInt)).
  156. SetLabelDist(lc).
  157. Save(l.ctx)
  158. l.Errorf("save hour data error:%v \n", err)
  159. }
  160. // 先判断该租户是否已经统计了小时数据,如果已经统计了,就不需要再统计了
  161. hourDataCount, _ := l.svcCtx.DB.UsageStatisticHour.Query().Where(
  162. usagestatistichour.Type(1),
  163. usagestatistichour.OrganizationID(orgID),
  164. usagestatistichour.BotID(""),
  165. usagestatistichour.Addtime(uint64(lastHourInt)),
  166. ).Count(l.ctx)
  167. if hourDataCount > 0 {
  168. continue
  169. }
  170. LabelsCount := []custom_types.LabelDist{}
  171. err := l.svcCtx.DB.LabelRelationship.Query().Where(
  172. labelrelationship.OrganizationIDEQ(orgID),
  173. ).GroupBy(labelrelationship.FieldLabelID).Aggregate(ent.Count()).Scan(l.ctx, &LabelsCount)
  174. l.Errorf("save hour data error:%v \n", err)
  175. LabelsCountSet[orgID] = LabelsCount
  176. _, err = l.svcCtx.DB.UsageStatisticHour.Create().
  177. SetType(1).
  178. SetOrganizationID(orgID).
  179. SetAiResponse(uint64(orgAiResponseInt)).
  180. SetSopRun(uint64(orgSopRunInt)).
  181. SetTotalFriend(uint64(orgFriendCountInt)).
  182. SetTotalGroup(uint64(orgGroupCountInt)).
  183. SetAccountBalance(uint64(orgAccountBalanceInt)).
  184. SetConsumeToken(uint64(orgConsumeTokenInt)).
  185. SetActiveUser(uint64(orgActiveUserInt)).
  186. SetNewUser(int64(orgNewUserInt)).
  187. SetAddtime(uint64(lastHourInt)).
  188. SetNotNilLabelDist(LabelsCount).
  189. Save(l.ctx)
  190. l.Errorf("save hour data error:%v \n", err)
  191. }
  192. // 先判断该租户是否已经统计了小时数据,如果已经统计了,就不需要再统计了
  193. hourDataCount, _ := l.svcCtx.DB.UsageStatisticHour.Query().Where(
  194. usagestatistichour.Type(1),
  195. usagestatistichour.OrganizationID(0),
  196. usagestatistichour.BotID(""),
  197. usagestatistichour.Addtime(uint64(lastHourInt)),
  198. ).Count(l.ctx)
  199. if hourDataCount == 0 {
  200. _, err = l.svcCtx.DB.UsageStatisticHour.Create().
  201. SetType(1).
  202. SetOrganizationID(0).
  203. SetAiResponse(uint64(allHourAiResponseInt)).
  204. SetSopRun(uint64(allHourSopRunInt)).
  205. SetTotalFriend(uint64(allHourFriendCountInt)).
  206. SetTotalGroup(uint64(allHourGroupCountInt)).
  207. SetAccountBalance(uint64(allHourAccountBalanceInt)).
  208. SetConsumeToken(uint64(allHourConsumeTokenInt)).
  209. SetActiveUser(uint64(allHourActiveUserInt)).
  210. SetNewUser(int64(allHourNewUserInt)).
  211. SetAddtime(uint64(lastHourInt)).
  212. SetLabelDist(lc).
  213. Save(l.ctx)
  214. l.Errorf("save hour data error:%v \n", err)
  215. }
  216. /*
  217. 计算日数据
  218. ----------------------------------------------------------------------------------------------------------
  219. */
  220. //dayStr := time.Now().Format("20060102")
  221. //day, _ := strconv.Atoi(dayStr)
  222. // 获取昨天的第一小时
  223. yesterday := now.AddDate(0, 0, -1)
  224. yesterdayFirstHour := time.Date(yesterday.Year(), yesterday.Month(), yesterday.Day(), 0, 0, 0, 0, now.Location())
  225. yesterdayInt, _ := strconv.Atoi(yesterdayFirstHour.Format("20060102"))
  226. yesterdayFirstHourInt, _ := strconv.Atoi(yesterdayFirstHour.Format("2006010215"))
  227. // 获取昨天的最后一小时
  228. yesterdayLastHour := time.Date(now.Year(), now.Month(), now.Day(), 0, 0, 0, 0, now.Location())
  229. yesterdayLastHourInt, _ := strconv.Atoi(yesterdayLastHour.Format("2006010215"))
  230. var allDayAiResponseInt, allDaySopRunInt, allDayFriendCountInt, allDayGroupCountInt, allDayAccountBalanceInt, allDayConsumeTokenInt, allDayActiveUserInt uint64
  231. var allDayNewUserInt int64
  232. for orgID, wxinfos := range wxbotsSet {
  233. var orgAiResponseInt, orgSopRunInt, orgFriendCountInt, orgGroupCountInt, orgAccountBalanceInt, orgConsumeTokenInt, orgActiveUserInt uint64
  234. var orgNewUserInt int64
  235. for _, wxinfo := range wxinfos {
  236. l.Logger.Infof("开始计算日数据:%d\n", yesterdayInt)
  237. hourDataBatch, _ := l.svcCtx.DB.UsageStatisticHour.Query().Where(
  238. usagestatistichour.Type(1),
  239. usagestatistichour.BotID(wxinfo.Wxid),
  240. usagestatistichour.AddtimeGTE(uint64(yesterdayFirstHourInt)),
  241. usagestatistichour.AddtimeLT(uint64(yesterdayLastHourInt)),
  242. ).All(l.ctx)
  243. if hourDataBatch == nil {
  244. continue
  245. }
  246. var aiResponse, sopRun, totalFriend, totalGroup, accountBalance, consumeToken, activeUser uint64
  247. var newUser int64
  248. for _, hourData := range hourDataBatch {
  249. aiResponse += hourData.AiResponse
  250. sopRun += hourData.SopRun
  251. totalFriend = hourData.TotalFriend
  252. totalGroup = hourData.TotalGroup
  253. accountBalance = hourData.AccountBalance
  254. consumeToken += hourData.ConsumeToken
  255. //activeUser += hourData.ActiveUser
  256. newUser += hourData.NewUser
  257. }
  258. // 活跃好友:usage_detail 表 type = 1
  259. activeUsers, _ := l.svcCtx.DB.UsageDetail.Query().Where(
  260. usagedetail.Type(1),
  261. usagedetail.BotID(wxinfo.Wxid),
  262. usagedetail.CreatedAtGTE(yesterdayFirstHour),
  263. usagedetail.CreatedAtLT(yesterdayLastHour),
  264. ).GroupBy(usagedetail.FieldReceiverID).Strings(l.ctx)
  265. activeUser = uint64(len(activeUsers))
  266. orgAiResponseInt += aiResponse
  267. orgSopRunInt += sopRun
  268. orgFriendCountInt += totalFriend
  269. orgGroupCountInt += totalGroup
  270. orgAccountBalanceInt += accountBalance
  271. orgConsumeTokenInt += consumeToken
  272. orgActiveUserInt += activeUser
  273. orgNewUserInt += newUser
  274. allDayAiResponseInt += aiResponse
  275. allDaySopRunInt += sopRun
  276. allDayFriendCountInt += totalFriend
  277. allDayGroupCountInt += totalGroup
  278. allDayAccountBalanceInt += accountBalance
  279. allDayConsumeTokenInt += consumeToken
  280. allDayActiveUserInt += activeUser
  281. allDayNewUserInt += newUser
  282. // 先判断该账号是否已经统计了日数据,如果已经统计了,就不需要再统计了
  283. dayDataCount, _ := l.svcCtx.DB.UsageStatisticDay.Query().Where(
  284. usagestatisticday.Type(1),
  285. usagestatisticday.BotID(wxinfo.Wxid),
  286. usagestatisticday.Addtime(uint64(yesterdayInt)),
  287. ).Count(l.ctx)
  288. // 如果添加过了就略过
  289. if dayDataCount == 0 && yesterdayLastHourInt <= currentHourInt {
  290. _, err := l.svcCtx.DB.UsageStatisticDay.Create().
  291. SetAddtime(uint64(yesterdayInt)).
  292. SetType(1).
  293. SetBotID(wxinfo.Wxid).
  294. SetOrganizationID(wxinfo.OrganizationID).
  295. SetAiResponse(aiResponse).
  296. SetSopRun(sopRun).
  297. SetTotalFriend(totalFriend).
  298. SetTotalGroup(totalGroup).
  299. SetAccountBalance(accountBalance).
  300. SetConsumeToken(consumeToken).
  301. SetActiveUser(activeUser).
  302. SetNewUser(newUser).
  303. SetLabelDist(lc).
  304. Save(l.ctx)
  305. if err != nil {
  306. l.Errorf("create day data error:%v \n", err)
  307. continue
  308. }
  309. }
  310. }
  311. // 先判断该租户是否已经统计了日数据,如果已经统计了,就不需要再统计了
  312. dayDataCount, _ := l.svcCtx.DB.UsageStatisticDay.Query().Where(
  313. usagestatisticday.Type(1),
  314. usagestatisticday.OrganizationID(orgID),
  315. usagestatisticday.BotID(""),
  316. usagestatisticday.Addtime(uint64(yesterdayInt)),
  317. ).Count(l.ctx)
  318. // 如果添加过了就略过
  319. if dayDataCount == 0 && yesterdayLastHourInt <= currentHourInt {
  320. _, err := l.svcCtx.DB.UsageStatisticDay.Create().
  321. SetAddtime(uint64(yesterdayInt)).
  322. SetType(1).
  323. SetOrganizationID(orgID).
  324. SetAiResponse(orgAiResponseInt).
  325. SetSopRun(orgSopRunInt).
  326. SetTotalFriend(orgFriendCountInt).
  327. SetTotalGroup(orgGroupCountInt).
  328. SetAccountBalance(orgAccountBalanceInt).
  329. SetConsumeToken(orgConsumeTokenInt).
  330. SetActiveUser(orgActiveUserInt).
  331. SetNewUser(orgNewUserInt).
  332. SetNotNilLabelDist(LabelsCountSet[orgID]).
  333. Save(l.ctx)
  334. if err != nil {
  335. l.Errorf("create day data error:%v \n", err)
  336. continue
  337. }
  338. }
  339. }
  340. // 先判断该租户是否已经统计了日数据,如果已经统计了,就不需要再统计了
  341. dayDataCount, _ := l.svcCtx.DB.UsageStatisticDay.Query().Where(
  342. usagestatisticday.Type(1),
  343. usagestatisticday.OrganizationID(0),
  344. usagestatisticday.BotID(""),
  345. usagestatisticday.Addtime(uint64(yesterdayInt)),
  346. ).Count(l.ctx)
  347. // 如果添加过了就略过
  348. if dayDataCount == 0 && yesterdayLastHourInt <= currentHourInt {
  349. _, err = l.svcCtx.DB.UsageStatisticDay.Create().
  350. SetAddtime(uint64(yesterdayInt)).
  351. SetType(1).
  352. SetOrganizationID(0).
  353. SetAiResponse(allDayAiResponseInt).
  354. SetSopRun(allDaySopRunInt).
  355. SetTotalFriend(allDayFriendCountInt).
  356. SetTotalGroup(allDayGroupCountInt).
  357. SetAccountBalance(allDayAccountBalanceInt).
  358. SetConsumeToken(allDayConsumeTokenInt).
  359. SetActiveUser(allDayActiveUserInt).
  360. SetNewUser(allDayNewUserInt).
  361. SetLabelDist(lc).
  362. Save(l.ctx)
  363. if err != nil {
  364. l.Errorf("create day data error:%v \n", err)
  365. }
  366. }
  367. /*
  368. 查看月表数据是否已经完成
  369. 1. 查询出上月里所有 usagedetail 内容
  370. 2. 挨个遍历他的 bot_id ,再查询他的 bot_id 相关的参数
  371. ----------------------------------------------------------------------------------------------------------
  372. */
  373. //monthStr := time.Now().Format("200601")
  374. //month, _ := strconv.Atoi(monthStr)
  375. //
  376. //var allMonthAiResponseInt, allMonthSopRunInt, allMonthFriendCountInt, allMonthGroupCountInt, allMonthAccountBalanceInt, allMonthConsumeTokenInt, allMonthActiveUserInt uint64
  377. //var allMonthNewUserInt int64
  378. //for orgID, wxinfos := range wxbotsSet {
  379. // var orgAiResponseInt, orgSopRunInt, orgFriendCountInt, orgGroupCountInt, orgAccountBalanceInt, orgConsumeTokenInt, orgActiveUserInt uint64
  380. // var orgNewUserInt int64
  381. // for _, wxinfo := range wxinfos {
  382. // l.Logger.Infof("开始计算月数据:%d\n", month)
  383. //
  384. // // 获取上月的第一天
  385. // monthFirstDay := time.Date(now.Year(), now.Month()-1, 1, 0, 0, 0, 0, now.Location())
  386. // monthFirstDayInt, _ := strconv.Atoi(monthFirstDay.Format("20060102"))
  387. //
  388. // // 获取上月的最后一天
  389. // monthLastDay := time.Date(now.Year(), now.Month(), 1, 0, 0, 0, 0, now.Location())
  390. // monthLastDayInt, _ := strconv.Atoi(monthLastDay.Format("20060102"))
  391. //
  392. // // 先判断该账号是否已经统计了月数据,如果已经统计了,就不需要再统计了
  393. // monthDataCount, _ := l.svcCtx.DB.UsageStatisticMonth.Query().Where(
  394. // usagestatisticmonth.Type(1),
  395. // usagestatisticmonth.BotID(wxinfo.Wxid),
  396. // usagestatisticmonth.Addtime(uint64(month)),
  397. // ).Count(l.ctx)
  398. //
  399. // // 如果添加过了就略过
  400. // if monthDataCount > 0 {
  401. // continue
  402. // }
  403. //
  404. // dayDataBatch, _ := l.svcCtx.DB.UsageStatisticDay.Query().Where(
  405. // usagestatisticday.Type(1),
  406. // usagestatisticday.BotID(wxinfo.Wxid),
  407. // usagestatisticday.AddtimeGTE(uint64(monthFirstDayInt)),
  408. // usagestatisticday.AddtimeLT(uint64(monthLastDayInt)),
  409. // ).All(l.ctx)
  410. //
  411. // var aiResponse, sopRun, totalFriend, totalGroup, accountBalance, consumeToken, activeUser uint64
  412. // var newUser int64
  413. // for _, dayData := range dayDataBatch {
  414. // aiResponse += dayData.AiResponse
  415. // sopRun += dayData.SopRun
  416. // totalFriend += dayData.TotalFriend
  417. // totalGroup += dayData.TotalGroup
  418. // accountBalance += dayData.AccountBalance
  419. // consumeToken += dayData.ConsumeToken
  420. // activeUser += dayData.ActiveUser
  421. // newUser += dayData.NewUser
  422. // }
  423. // orgAiResponseInt += aiResponse
  424. // orgSopRunInt += sopRun
  425. // orgFriendCountInt += totalFriend
  426. // orgGroupCountInt += totalGroup
  427. // orgAccountBalanceInt += accountBalance
  428. // orgConsumeTokenInt += consumeToken
  429. // orgActiveUserInt += activeUser
  430. // orgNewUserInt += newUser
  431. //
  432. // allMonthAiResponseInt += aiResponse
  433. // allMonthSopRunInt += sopRun
  434. // allMonthFriendCountInt += totalFriend
  435. // allMonthGroupCountInt += totalGroup
  436. // allMonthAccountBalanceInt += accountBalance
  437. // allMonthConsumeTokenInt += consumeToken
  438. // allMonthActiveUserInt += activeUser
  439. // allMonthNewUserInt += newUser
  440. //
  441. // _, err := l.svcCtx.DB.UsageStatisticMonth.Create().
  442. // SetAddtime(uint64(month)).
  443. // SetType(1).
  444. // SetBotID(wxinfo.Wxid).
  445. // SetOrganizationID(wxinfo.OrganizationID).
  446. // SetAiResponse(aiResponse).
  447. // SetSopRun(sopRun).
  448. // SetTotalFriend(totalFriend).
  449. // SetTotalGroup(totalGroup).
  450. // SetAccountBalance(accountBalance).
  451. // SetConsumeToken(consumeToken).
  452. // SetActiveUser(activeUser).
  453. // SetNewUser(newUser).
  454. // SetLabelDist(lc).
  455. // Save(l.ctx)
  456. // if err != nil {
  457. // l.Errorf("create month data error:%v \n", err)
  458. // continue
  459. // }
  460. // }
  461. // // 先判断该租户是否已经统计了月数据,如果已经统计了,就不需要再统计了
  462. // monthDataCount, _ := l.svcCtx.DB.UsageStatisticMonth.Query().Where(
  463. // usagestatisticmonth.Type(1),
  464. // usagestatisticmonth.OrganizationID(orgID),
  465. // usagestatisticmonth.BotIDIsNil(),
  466. // usagestatisticmonth.Addtime(uint64(month)),
  467. // ).Count(l.ctx)
  468. //
  469. // // 如果添加过了就略过
  470. // if monthDataCount > 0 {
  471. // continue
  472. // }
  473. //
  474. // _, err := l.svcCtx.DB.UsageStatisticMonth.Create().
  475. // SetAddtime(uint64(month)).
  476. // SetType(1).
  477. // SetOrganizationID(orgID).
  478. // SetAiResponse(orgAiResponseInt).
  479. // SetSopRun(orgSopRunInt).
  480. // SetTotalFriend(orgFriendCountInt).
  481. // SetTotalGroup(orgGroupCountInt).
  482. // SetAccountBalance(orgAccountBalanceInt).
  483. // SetConsumeToken(orgConsumeTokenInt).
  484. // SetActiveUser(orgActiveUserInt).
  485. // SetNewUser(orgNewUserInt).
  486. // SetNotNilLabelDist(LabelsCountSet[orgID]).
  487. // Save(l.ctx)
  488. // if err != nil {
  489. // l.Errorf("create month data error:%v \n", err)
  490. // continue
  491. // }
  492. //}
  493. //
  494. //_, err = l.svcCtx.DB.UsageStatisticMonth.Create().
  495. // SetAddtime(uint64(month)).
  496. // SetType(1).
  497. // SetOrganizationID(0).
  498. // SetAiResponse(allMonthAiResponseInt).
  499. // SetSopRun(allMonthSopRunInt).
  500. // SetTotalFriend(allMonthFriendCountInt).
  501. // SetTotalGroup(allMonthGroupCountInt).
  502. // SetAccountBalance(allMonthAccountBalanceInt).
  503. // SetConsumeToken(allMonthConsumeTokenInt).
  504. // SetActiveUser(allMonthActiveUserInt).
  505. // SetNewUser(allMonthNewUserInt).
  506. // SetNotNilLabelDist(lc).
  507. // Save(l.ctx)
  508. //if err != nil {
  509. // l.Errorf("create month data error:%v \n", err)
  510. //}
  511. finishTime := time.Now()
  512. l.Logger.Infof("This process cost %v", finishTime.Sub(startTime).String())
  513. return
  514. }