UserOnlineService.go 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. package service
  2. import (
  3. "designs/global"
  4. "designs/model"
  5. "strconv"
  6. "time"
  7. )
  8. type logData struct {
  9. LogTime time.Time `json:"LogTime"`
  10. Type int `json:"Type"`
  11. }
  12. func UserOnlineSummary(gid string, pf string, date string, startTime string, endTime string) (map[int]string, error) {
  13. var onlineData []model.UserOnline
  14. //从数据库中查询出所有的数据
  15. query := global.App.DB.Table("user_online").Where("gid", gid)
  16. if date != "" {
  17. query = query.Where("date", "=", date).Where("pf", pf)
  18. }
  19. if startTime != "" && endTime != "" {
  20. query = query.Where("logTime", ">=", startTime).Where("logTime", "<=", endTime)
  21. }
  22. err := query.Scan(&onlineData).Error
  23. if err != nil {
  24. return nil, err
  25. }
  26. //对数据进行分组
  27. userOnlineData := make(map[int][]logData)
  28. for _, v := range onlineData {
  29. value, exists := userOnlineData[v.UserId]
  30. if exists {
  31. userOnlineData[v.UserId] = append(value, logData{v.LogTime, v.Type})
  32. } else {
  33. userOnlineData[v.UserId] = []logData{{v.LogTime, v.Type}}
  34. }
  35. }
  36. onlineData = nil
  37. userLogMsg := make(map[int]string)
  38. //分组后对于每个用户的数据进行处理,得到他们的具体在线时长
  39. for k, v := range userOnlineData {
  40. userLogMsg[k] = calculateUserOnlineTime(v)
  41. }
  42. userOnlineData = nil
  43. return userLogMsg, nil
  44. }
  45. func calculateUserOnlineTime(logData []logData) string {
  46. var lastLog int64
  47. var isStart bool
  48. var onlineTimeTotal int64
  49. for k, v := range logData {
  50. if v.Type == 1 && isStart == false {
  51. isStart = true
  52. lastLog = v.LogTime.Unix()
  53. continue
  54. }
  55. if v.Type == 1 && isStart == true {
  56. logTime := v.LogTime.Unix()
  57. onlineTimeTotal = onlineTimeTotal + (logTime - lastLog)
  58. lastLog = logTime
  59. //如果下一次的心跳,间隔时间大于6分钟了,就可以认为,这次就算是结束了
  60. if k+1 == len(logData) || logData[k+1].LogTime.Unix() > logTime+60*6 {
  61. isStart = false
  62. }
  63. continue
  64. }
  65. if v.Type == 2 && isStart == true {
  66. logTime := v.LogTime.Unix()
  67. onlineTimeTotal = onlineTimeTotal + (logTime - lastLog)
  68. isStart = false
  69. continue
  70. }
  71. }
  72. return "用户在线时长:" + strconv.Itoa(int(onlineTimeTotal))
  73. }