spotify-scrobble-frontend/playtime_counts.php at main · ReactiveSlime/spotify-scrobble-frontend · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
<?php
require_once './includes/config.php';
require_once './includes/navbar.php';
$pdo = new PDO(
    "mysql:host=" . DB_HOST . ";port=" . DB_PORT . ";dbname=" . DB_NAME,
    DB_USER,
    DB_PASS
);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

function getSongStats($pdo, $interval) {
    $validIntervals = ['1 DAY' => '1 DAY', '1 WEEK' => '1 WEEK', '1 MONTH' => '1 MONTH'];
    if (!isset($validIntervals[$interval])) {
        throw new InvalidArgumentException("Invalid interval: $interval");
    }
    $stmt = $pdo->prepare(
        "SELECT COUNT(*) AS song_count
         FROM playbacks WHERE played_at >= NOW() - INTERVAL " . $validIntervals[$interval]
    );
    $stmt->execute();
    return $stmt->fetch(PDO::FETCH_ASSOC);
}

$daySongStats = getSongStats($pdo, '1 DAY');
$weekSongStats = getSongStats($pdo, '1 WEEK');
$monthSongStats = getSongStats($pdo, '1 MONTH');

function getListeningStats($pdo, $interval) {
    $validIntervals = ['1 DAY' => '1 DAY', '1 WEEK' => '1 WEEK', '1 MONTH' => '1 MONTH'];
    if (!isset($validIntervals[$interval])) {
        throw new InvalidArgumentException("Invalid interval: $interval");
    }
    $stmt = $pdo->prepare(
        "SELECT SUM(seconds_played) / 60 AS minutes_listened
         FROM playbacks WHERE played_at >= NOW() - INTERVAL " . $validIntervals[$interval]
    );
    $stmt->execute();
    return $stmt->fetch(PDO::FETCH_ASSOC);
}

$dayListeningStats = getListeningStats($pdo, '1 DAY');
$weekListeningStats = getListeningStats($pdo, '1 WEEK');
$monthListeningStats = getListeningStats($pdo, '1 MONTH');

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Song Counts and Listening Stats</title>
    <link rel="stylesheet" href="./assets/css/styles.css">
</head>
<body>
<header>
    <div class="navbar">
        <div class="menu">Menu</div>

        <div class="nav-links">
            <?php renderNavbar("playtime_counts.php"); ?>
        </div>
    </div>
</header>
<div class="main-content">
    <section class="song-stats">
        <h1>Song Counts</h1>
        <ul>
            <li>
                <strong>Past 24 Hours:</strong>
                <span class="count"><?= $daySongStats['song_count'] ?> songs</span>
            </li>
            <li>
                <strong>Past Week:</strong>
                <span class="count"><?= $weekSongStats['song_count'] ?> songs</span>
            </li>
            <li>
                <strong>Past Month:</strong>
                <span class="count"><?= $monthSongStats['song_count'] ?> songs</span>
            </li>
        </ul>
    </section>

    <section class="listening-stats">
        <h1>Listening Time</h1>
        <ul>
            <li>
                <strong>Past 24 Hours:</strong>
                <span class="time"><?= ceil($dayListeningStats['minutes_listened']) ?> minutes</span>
            </li>
            <li>
                <strong>Past Week:</strong>
                <span class="time"><?= ceil($weekListeningStats['minutes_listened']) ?> minutes</span>
            </li>
            <li>
                <strong>Past Month:</strong>
                <span class="time"><?= ceil($monthListeningStats['minutes_listened']) ?> minutes</span>
            </li>
        </ul>
    </section>
</div>

<script src="./assets/js/script.js"></script>
</body>
</html>