main.go 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. package main
  2. import (
  3. "context"
  4. "fmt"
  5. _ "github.com/gogf/gf/contrib/drivers/clickhouse/v2"
  6. _ "github.com/gogf/gf/contrib/drivers/mysql/v2"
  7. "github.com/gogf/gf/v2/frame/g"
  8. "time"
  9. "workTasks/userSign/userAnalysis"
  10. )
  11. func main() {
  12. runOnce(context.TODO())
  13. }
  14. func runOnce(ctx context.Context) {
  15. manager := userAnalysis.NewManager()
  16. var allRes []*userAnalysis.AnalysisRes
  17. if err := manager.LoadMapping(); err != nil {
  18. g.Log().Errorf(ctx, "加载对应关系异常 %v", err)
  19. }
  20. //订单分析
  21. if res, err := manager.TiDBOrderRange(ctx); err == nil && len(res) > 0 {
  22. allRes = append(allRes, res...)
  23. }
  24. //会员状态分析
  25. if res, err := manager.GetMgoUserRes(ctx); err == nil && len(res) > 0 {
  26. allRes = append(allRes, res...)
  27. }
  28. var (
  29. sourceArr = []string{"pc", "wx", "app"}
  30. nowTime = time.Now()
  31. unActiveTime = []int{30, 90}
  32. )
  33. //活跃用户分析
  34. for _, source := range sourceArr {
  35. if res, err := manager.ActiveUserLoad(ctx, nowTime.AddDate(0, 0, -30), source); err == nil && len(res) > 0 {
  36. allRes = append(allRes, &userAnalysis.AnalysisRes{Name: fmt.Sprintf("30天%s活跃用户", source), Code: fmt.Sprintf("active_%s_%d", source, 30), Data: res})
  37. }
  38. }
  39. //未活跃用户占比
  40. for _, day := range unActiveTime {
  41. if res, err := manager.UnActiveUserLoad(ctx, nowTime.AddDate(0, 0, -day)); err == nil && len(res) > 0 {
  42. allRes = append(allRes, &userAnalysis.AnalysisRes{Name: fmt.Sprintf("%d天未活跃用户", day), Code: fmt.Sprintf("unActive_%d", day), Data: res})
  43. }
  44. }
  45. for _, re := range allRes {
  46. re.UpdateTag(ctx)
  47. }
  48. }