stat_center/models/dailystatmod/daily.go

package dailystatmod

import (
	"context"
	"fmt"
	"stat/common/log"
	"stat/common/mongos"
	"stat/common/utils"
	"time"

	"go.mongodb.org/mongo-driver/mongo"

	"go.mongodb.org/mongo-driver/mongo/options"

	"go.mongodb.org/mongo-driver/bson"
)

// 初始化model
func Init() {
	// 获取数据库表
	db = mongos.New(mongos.MgoManager, CollDailyStat)

	indexes := []mongo.IndexModel{
		{
			Keys: bson.D{{Key: "sumDate", Value: 1}},
		},
	}

	if _, err := db.CreateIndex(context.Background(), indexes); err != nil {
		panic(fmt.Sprintf("Model %s InitIndex error %+v", CollDailyStat, err))
	}
}

// UpsertDailyStat 更新或插入一条统计记录
func UpsertDailyStat(ctx context.Context, sumDate time.Time, appId int32, doc DailyStatDoc) (err error) {
	var filter = bson.M{
		"sumDate": sumDate,
		"appId":   appId,
	}
	var update = mongos.ToBsonM(doc)

	exists, err := db.Exists(ctx, filter)
	if err != nil {
		return err
	}

	if exists {
		_, err = db.UpdateOne(ctx, filter, bson.M{"$set": update})
	} else {
		insertDoc := update
		insertDoc["sumDate"] = sumDate
		insertDoc["appId"] = appId

		_, err = db.InsertOne(ctx, insertDoc)
	}

	return
}

// 获取日常统计列表
func GetDailyStatList(ctx context.Context, appId *[]int32, start, end *time.Time, skip, limit int64) (count int64, data []*DailyStatMod, err error) {
	filter := bson.M{}
	if appId != nil {
		filter["appId"] = bson.M{"$in": appId}
	}

	if start != nil && end != nil {
		filter["sumDate"] = bson.M{"$gte": start, "$lt": end}
	} else if start != nil {
		filter["sumDate"] = bson.M{"$gte": start}
	} else if end != nil {
		filter["sumDate"] = bson.M{"$lt": end}
	}

	sort := bson.D{{Key: "sumDate", Value: -1}}

	opts := options.Find().SetSort(sort).SetSkip(skip).SetLimit(limit)

	if err = db.Find(ctx, &data, filter, opts); err != nil {
		log.Error("channel GetDailyStatList Find err", log.E(err))
		return
	}

	if count, err = db.Count(ctx, filter); err != nil {
		log.Error("channel GetDailyStatList Count err", log.E(err))
		return
	}

	return
}

// 获取日常统计列表
func GetDailyStatTotalList(ctx context.Context, appId *int32, start, end *time.Time) (data []*DailyStatMod, err error) {
	filter := bson.M{}
	if appId != nil {
		filter["appId"] = appId
	}

	if start != nil && end != nil {
		filter["sumDate"] = bson.M{"$gte": start, "$lt": end}
	} else if start != nil {
		filter["sumDate"] = bson.M{"$gte": start}
	} else if end != nil {
		filter["sumDate"] = bson.M{"$lt": end}
	}

	if err = db.Find(ctx, &data, filter); err != nil {
		log.Error("channel GetDailyStatList Find err", log.E(err))
		return
	}

	return
}

type OnItem func(item *DailyStatMod)

// 获取日常统计列表
func GetDailyStatTotalListShard(ctx context.Context, appId *[]int32, start, end *time.Time, shard time.Duration, onItem OnItem) error {
	if start == nil {
		b := utils.DefaultStatBeginTime
		start = &b
	}
	if end == nil {
		e := time.Now()
		end = &e
	}
	segments := utils.CalcTimeSegments(*start, *end, shard)
	for _, segment := range segments {
		filter := bson.M{
			"sumDate": bson.M{"$gte": segment.Begin, "$lt": segment.End},
		}
		if appId != nil {
			filter["appId"] = bson.M{"$in": appId}
		}
		list := make([]*DailyStatMod, 0)
		if err := db.Find(ctx, &list, filter); err != nil {
			log.Error("channel GetDailyStatList Find err", log.E(err))
			return err
		}
		for _, item := range list {
			onItem(item)
		}
	}
	return nil
}

// 获取日常统计列表
func FindOneDailyStat(ctx context.Context, appId int32, sumDate time.Time) (data DailyStatMod, err error) {
	filter := bson.M{
		"appId":   appId,
		"sumDate": sumDate,
	}

	if err = db.FindOne(ctx, &data, filter); err != nil {
		log.Error("channel GetDailyStatList Find err", log.E(err))
		return
	}

	return
}

func FindDailyStatList(ctx context.Context, appIds []int32, sumDate time.Time) (list []DailyStatMod, err error) {
	filter := bson.M{
		"appId":   bson.M{"$in": appIds},
		"sumDate": sumDate,
	}

	log.Info("FindDailyStatList", log.Any("filter", filter))

	list = make([]DailyStatMod, 0)
	if err = db.Find(ctx, &list, filter); err != nil {
		log.Error("channel GetDailyStatList Find err", log.E(err))
		return
	}

	return
}