From e4d0117beacf94bfd58cbdf3be7b232a0d4a21b9 Mon Sep 17 00:00:00 2001
From: Chris Fulljames <christianfulljames@gmail.com>
Date: Sun, 13 Apr 2025 17:11:44 -0400
Subject: [PATCH] Fix timezones for jam events

---
 src/littlesongplace/jams.py                  | 12 +++++++++---
 src/littlesongplace/songs.py                 |  5 ++---
 src/littlesongplace/templates/jam-event.html | 12 ++++++------
 3 files changed, 17 insertions(+), 12 deletions(-)

diff --git a/src/littlesongplace/jams.py b/src/littlesongplace/jams.py
index 4f27233..26978d6 100644
--- a/src/littlesongplace/jams.py
+++ b/src/littlesongplace/jams.py
@@ -161,8 +161,8 @@ def events_update(jamid, eventid):
     description = request.form["description"]
     startdate = request.form["startdate"]
     enddate = request.form["enddate"]
-    _validate_timestamp(startdate)
-    _validate_timestamp(enddate)
+    startdate = _validate_timestamp(startdate)
+    enddate = _validate_timestamp(enddate)
     db.query(
             """
             UPDATE jam_events
@@ -202,7 +202,13 @@ def _get_jam_by_id(jamid):
 
 def _validate_timestamp(timestamp):
     try:
-        datetime.fromisoformat(timestamp)
+        dt = datetime.fromisoformat(timestamp)
+        if dt.tzinfo:
+            # Has timezone, convert to UTC
+            return dt.astimezone(timezone.utc)
+        else:
+            # No timezone, assume it is already UTC
+            return dt.replace(tzinfo=timezone.utc)
     except ValueError:
         abort(400)
 
diff --git a/src/littlesongplace/songs.py b/src/littlesongplace/songs.py
index fd21ff0..5e4e021 100644
--- a/src/littlesongplace/songs.py
+++ b/src/littlesongplace/songs.py
@@ -183,12 +183,11 @@ def _from_db(query, args=()):
                     [sd["eventid"]],
                     one=True)
             if event_row and event_row["enddate"]:
-                enddate = datetime.fromisoformat(event_row["enddate"]).astimezone()
-                hidden = datetime.now().astimezone() < enddate
+                enddate = datetime.fromisoformat(event_row["enddate"])
+                hidden = datetime.now(timezone.utc) < enddate
 
         created = (
                 datetime.fromisoformat(sd["created"])
-                .astimezone()
                 .strftime("%Y-%m-%d"))
 
         songs.append(Song(
diff --git a/src/littlesongplace/templates/jam-event.html b/src/littlesongplace/templates/jam-event.html
index 7b8f7e9..b1b19fc 100644
--- a/src/littlesongplace/templates/jam-event.html
+++ b/src/littlesongplace/templates/jam-event.html
@@ -13,12 +13,12 @@
             <br/>
         {% if event.startdate %}
         <strong>Start Date:</strong>
-            {{ event.startdate.astimezone().strftime("%Y-%m-%d %I:%M%p") }}
+            {{ event.startdate.strftime("%Y-%m-%d %I:%M%p") }} (UTC)
             <br/>
         {% endif %}
         {% if event.enddate %}
         <strong>End Date:</strong>
-            {{ event.enddate.astimezone().strftime("%Y-%m-%d %I:%M%p") }}
+            {{ event.enddate.strftime("%Y-%m-%d %I:%M%p") }} (UTC)
         {% endif %}
     </div>
 
@@ -38,11 +38,11 @@
     {{ jam.description }}
     </div>
 
-    <h2>Submissions</h2>
+    <h2>Entries</h2>
     <a class="button" href="/edit-song?eventid={{ event.eventid }}">Submit a Song</a>
     <br/>
     <br/>
-    {% if songs %}<p><small>This event has received {{ songs|length }} submission{% if songs|length > 1 %}s{% endif %}</small></p>{% endif %}
+    {% if songs %}<p><small>This event has received {{ songs|length }} {% if songs|length > 1 %}entries{% else %}entry{% endif %}</small></p>{% endif %}
     {% include "song-list.html" %}
 
     <h2>Comments</h2>
@@ -62,12 +62,12 @@
         <br/>
         <label>
             Event Start (When the event title and description become public)<br/>
-            <input type="datetime-local" name="startdate" value="{{ event.startdate }}" required/>
+            <input type="datetime-local" name="startdate" value="{% if event.startdate %}{{ event.startdate.replace(tzinfo=None).isoformat() }}{% endif %}" required/> (UTC)
         </label>
         <br/>
         <label>
             Event End (When submitted songs become public)<br/>
-            <input type="datetime-local" name="enddate" value="{{ event.enddate }}" required/>
+            <input type="datetime-local" name="enddate" value="{% if event.enddate %}{{ event.enddate.replace(tzinfo=None).isoformat() }}{% endif %}" required/> (UTC)
         </label>
         <br/>
         <input type="submit" value="Save"/>
-- 
2.39.5