From e00f05d7c636f9a1b7a10930402cfeb9331f6631 Mon Sep 17 00:00:00 2001
From: Anhgelus Morhtuuzh <william@herges.fr>
Date: Thu, 21 Aug 2025 15:41:40 +0200
Subject: feat(command): fetch stats

---
 commands/stats.go | 62 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 62 insertions(+)
 create mode 100644 commands/stats.go

(limited to 'commands/stats.go')

diff --git a/commands/stats.go b/commands/stats.go
new file mode 100644
index 0000000..80a9b1b
--- /dev/null
+++ b/commands/stats.go
@@ -0,0 +1,62 @@
+package commands
+
+import (
+	"time"
+
+	"git.anhgelus.world/anhgelus/les-copaings-bot/config"
+	"git.anhgelus.world/anhgelus/les-copaings-bot/exp"
+	"git.anhgelus.world/anhgelus/les-copaings-bot/user"
+	"github.com/anhgelus/gokord"
+	"github.com/anhgelus/gokord/cmd"
+	"github.com/anhgelus/gokord/logger"
+	"github.com/bwmarrin/discordgo"
+)
+
+type data struct {
+	CreatedAt time.Time
+	XP        int
+	CopaingID int
+	copaing   *user.Copaing
+}
+
+func Stats(_ *discordgo.Session, i *discordgo.InteractionCreate, opt cmd.OptionMap, resp *cmd.ResponseBuilder) {
+	cfg := config.GetGuildConfig(i.GuildID)
+	days := cfg.DaysXPRemains
+	if v, ok := opt["days"]; ok {
+		in := v.IntValue()
+		if in < 0 || uint(in) > days {
+			if err := resp.SetMessage("Nombre de jours invalide").IsEphemeral().Send(); err != nil {
+				logger.Alert("commands/stats.go - Sending invalid days", err.Error())
+			}
+			return
+		}
+		days = uint(in)
+	}
+	var stats []*data
+	res := gokord.DB.Raw(
+		`SELECT "created_at"::date::text, sum(xp) as xp, copaing_id FROM copaing_xps GROUP BY "created_at"::date `+
+			` WHERE guild_id = ? and created_at < ?`,
+		i.GuildID, exp.TimeStampNDaysBefore(days),
+	)
+	if res.Error != nil {
+		logger.Alert("commands/stats.go - Fetching XP data", res.Error.Error(), "guild_id", i.GuildID)
+		return
+	}
+	if err := res.Scan(&stats).Error; err != nil {
+		logger.Alert("commands/stats.go - Scanning result", err.Error(), "res")
+		return
+	}
+	copaings := map[int]*user.Copaing{}
+	for _, s := range stats {
+		c, ok := copaings[s.CopaingID]
+		if ok {
+			s.copaing = c
+		} else {
+			if err := gokord.DB.First(s.copaing, s.CopaingID).Error; err != nil {
+				logger.Alert("commands/stats.go - Finding copaing", err.Error(), "id", s.CopaingID)
+				return
+			}
+			copaings[s.CopaingID] = s.copaing
+		}
+	}
+}
-- 
cgit v1.2.3