8 files changed, 330 insertions, 0 deletions

diff --git a/api/internal/controllers/auth.go b/api/internal/controllers/auth.go
new file mode 100644
index 0000000..744a884
--- /dev/null
+++ b/api/internal/controllers/auth.go
@@ -0,0 +1,66 @@
+package controllers
+
+import (
+        "encoding/base64"
+        "net/http"
+        "github.com/gin-gonic/gin"
+        "water/api/database"
+        "errors"
+        "crypto/rand"
+        "database/sql"
+        
+        "water/api/models"
+        _ "github.com/mattn/go-sqlite3"
+        "golang.org/x/crypto/bcrypt"
+)
+
+func AuthHandler (c *gin.Context) {
+        username, password, ok := c.Request.BasicAuth()
+        if !ok {
+                c.Header("WWW-Authenticate", `Basic realm="Please enter your username and password."`)
+                c.AbortWithStatus(http.StatusUnauthorized)
+                return
+        }
+
+        db := database.EstablishDBConnection()
+        defer func(db *sql.DB) {
+                err := db.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(db)
+
+        var user models.User
+        var preference models.Preference
+        var size models.Size
+
+        row := db.QueryRow("SELECT name, uuid, password, color, size, unit FROM Users u INNER JOIN Preferences p ON p.user_id = u.id INNER JOIN Sizes s ON p.size_id = s.id WHERE u.name = ?", username)
+        if err := row.Scan(&user.Name, &user.UUID, &user.Password, &preference.Color, &size.Size, &size.Unit); err != nil {
+                if errors.Is(err, sql.ErrNoRows) {
+                        c.AbortWithStatus(http.StatusUnauthorized)
+                        return
+                }
+        }
+
+        if err := bcrypt.CompareHashAndPassword([]byte(user.Password), []byte(password)); err != nil {
+                c.AbortWithStatus(http.StatusUnauthorized)
+                return
+        }
+
+        preference.Size = size
+
+        // Generate a simple API token
+        apiToken := generateToken()
+        c.JSON(http.StatusOK, gin.H{"token": apiToken, "user": user, "preferences": preference})
+}
+
+// generatToken will g
+func generateToken() string {
+        token := make([]byte, 32)
+        _, err := rand.Read(token)
+        if err != nil {
+                return ""
+        }
+        return base64.StdEncoding.EncodeToString(token)
+}
\ No newline at end of file
diff --git a/api/internal/controllers/stats.go b/api/internal/controllers/stats.go
new file mode 100644
index 0000000..9808ace
--- /dev/null
+++ b/api/internal/controllers/stats.go
@@ -0,0 +1,164 @@
+package controllers
+
+import (
+        "database/sql"
+        "github.com/gin-gonic/gin"
+        "net/http"
+        "water/api/database"
+        "water/api/models"
+)
+
+func GetAllStatistics(c *gin.Context) {
+        db := database.EstablishDBConnection()
+        defer func(db *sql.DB) {
+                err := db.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(db)
+
+        rows, err := db.Query("SELECT s.date, s.quantity, u.uuid, u.name FROM Statistics s INNER JOIN Users u ON u.id = s.user_id")
+        if err != nil {
+                c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                return
+        }
+        defer func(rows *sql.Rows) {
+                err := rows.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(rows)
+
+        var data []models.Statistic
+
+        for rows.Next() {
+                var stat models.Statistic
+                var user models.User
+                if err := rows.Scan(&stat.Date, &stat.Quantity, &user.UUID, &user.Name); err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+                stat.User = user
+                data = append(data, stat)
+        }
+
+        c.JSON(http.StatusOK, data)
+}
+
+func PostNewStatistic(c *gin.Context) {
+        var stat models.StatisticPost
+
+        if err := c.BindJSON(&stat); err != nil {
+                c.JSON(http.StatusBadRequest, gin.H{"error": err.Error()})
+                return
+        }
+
+        db := database.EstablishDBConnection()
+        defer func(db *sql.DB) {
+                err := db.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(db)
+
+        result, err := db.Exec("INSERT INTO statistics (date, user_id, quantity) values (?, ?, ?)", stat.Date, stat.UserID, stat.Quantity)
+
+        if err != nil {
+                c.JSON(http.StatusBadRequest, gin.H{"error": err.Error()})
+        }
+
+        id, err := result.LastInsertId()
+        if err != nil {
+                c.JSON(http.StatusBadRequest, gin.H{"error": err.Error()})
+        }
+
+        c.JSON(http.StatusCreated, gin.H{"status": "created", "id": id})
+}
+
+func GetWeeklyStatistics (c *gin.Context) {
+        db := database.EstablishDBConnection()
+        defer func(db *sql.DB) {
+                err := db.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(db)
+
+        rows, err := db.Query("SELECT date, total FROM `WeeklyStatisticsView`")
+        if err != nil {
+                c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                return
+        }
+        defer func(rows *sql.Rows) {
+                err := rows.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(rows)
+
+        var data []models.WeeklyStatistic
+        for rows.Next() {
+                var weeklyStat models.WeeklyStatistic
+                if err := rows.Scan(&weeklyStat.Date, &weeklyStat.Total); err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                }
+                data = append(data, weeklyStat)
+        }
+
+        c.JSON(http.StatusOK, data)
+}
+
+func GetDailyUserStatistics(c *gin.Context) {
+        db := database.EstablishDBConnection()
+        defer func(db *sql.DB) {
+                err := db.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(db)
+
+        rows, err := db.Query("SELECT name, total FROM DailyUserStatistics")
+
+        if err != nil {
+                c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                return
+        }
+        defer func(rows *sql.Rows) {
+                err := rows.Close()
+                if err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+        }(rows)
+
+        var data []models.DailyUserTotals
+        for rows.Next() {
+                var stat models.DailyUserTotals
+                if err := rows.Scan(&stat.Name, &stat.Total); err != nil {
+                        c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
+                        return
+                }
+                data = append(data, stat)
+        }
+
+        c.JSON(http.StatusOK, data)
+
+}
+
+func GetUserStatistics(c *gin.Context) {
+        c.JSON(http.StatusOK, gin.H{"status": "ok", "uuid": c.Param("uuid")})
+}
+
+func UpdateUserStatistic(c *gin.Context) {
+        c.JSON(http.StatusNoContent, gin.H{"status": "No Content"})
+}
+
+func DeleteUserStatistic(c *gin.Context) {
+        c.JSON(http.StatusNoContent, gin.H{"status": "No Content"})
+}
diff --git a/api/internal/controllers/user.go b/api/internal/controllers/user.go
new file mode 100644
index 0000000..1f3f813
--- /dev/null
+++ b/api/internal/controllers/user.go
@@ -0,0 +1,17 @@
+package controllers
+
+import (
+        "net/http"
+        "github.com/gin-gonic/gin"
+)
+
+func GetUser(c *gin.Context) {
+        c.JSON(http.StatusOK, gin.H{"message": "User found"})
+}
+func GetUserPreferences(c *gin.Context) {
+        c.JSON(http.StatusOK, gin.H{"message": "Preferences fetched successfully"})
+}
+
+func UpdateUserPreferences(c *gin.Context) {
+        c.JSON(http.StatusOK, gin.H{"message": "Preferences updated successfully"})
+}
\ No newline at end of file
diff --git a/api/internal/database/database.go b/api/internal/database/database.go
new file mode 100644
index 0000000..e313af5
--- /dev/null
+++ b/api/internal/database/database.go
@@ -0,0 +1,22 @@
+package database
+
+import (
+        "database/sql"
+        _ "github.com/mattn/go-sqlite3"
+        "log"
+)
+
+func SetupDatabase() {
+        _, err := sql.Open("sqlite3", "water.db")
+        if err != nil {
+                log.Fatal(err)
+        }
+}
+
+func EstablishDBConnection() *sql.DB {
+        db, err := sql.Open("sqlite3", "../db/water.sqlite3")
+        if err != nil {
+                panic(err)
+        }
+        return db
+}
\ No newline at end of file
diff --git a/api/internal/models/auth.go b/api/internal/models/auth.go
new file mode 100644
index 0000000..41344d5
--- /dev/null
+++ b/api/internal/models/auth.go
@@ -0,0 +1,11 @@
+package models
+
+import "time"
+
+type Token struct {
+        ID        int64     `json:"-"`
+        UserID    int64     `json:"user_id"`
+        Token     string    `json:"token"`
+        CreatedAt time.Time `json:"created_at"`
+        ExpiredAt time.Time `json:"expired_at"`
+}
diff --git a/api/internal/models/preferences.go b/api/internal/models/preferences.go
new file mode 100644
index 0000000..cbbd47c
--- /dev/null
+++ b/api/internal/models/preferences.go
@@ -0,0 +1,14 @@
+package models
+
+type Preference struct {
+        ID     int64  `json:"-"`
+        Color  string `json:"color"`
+        UserID int64  `json:"-"`
+        Size   Size   `json:"size"`
+}
+
+type Size struct {
+        ID   int64  `json:"-"`
+        Size int64  `json:"size"`
+        Unit string `json:"unit"`
+}
diff --git a/api/internal/models/statistics.go b/api/internal/models/statistics.go
new file mode 100644
index 0000000..457e6a0
--- /dev/null
+++ b/api/internal/models/statistics.go
@@ -0,0 +1,26 @@
+package models
+
+import "time"
+
+type Statistic struct {
+        ID       int64     `json:"-"`
+        Date     time.Time `json:"date"`
+        User     User      `json:"user"`
+        Quantity int       `json:"quantity"`
+}
+
+type StatisticPost struct {
+        Date     time.Time `json:"date"`
+        Quantity int64     `json:"quantity"`
+        UserID   int64     `json:"user_id"`
+}
+
+type WeeklyStatistic struct {
+        Date  string `json:"date"`
+        Total int64  `json:"total"`
+}
+
+type DailyUserTotals struct {
+        Name  string `json:"name"`
+        Total int64  `json:"total"`
+}
diff --git a/api/internal/models/user.go b/api/internal/models/user.go
new file mode 100644
index 0000000..2a3e6fd
--- /dev/null
+++ b/api/internal/models/user.go
@@ -0,0 +1,10 @@
+package models
+
+import "github.com/google/uuid"
+
+type User struct {
+        ID       int64     `json:"-"`
+        Name     string    `json:"name"`
+        UUID     uuid.UUID `json:"uuid"`
+        Password string    `json:"-"`
+}