Changeset 015ce46 in Klonkt for src/services

Timestamp:

06/21/2026 04:32:54 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

9effb80

Parents:

5a394e5

Message:

fix(inplannen): scheduled posts never went live + timezone bug

(1) Scheduler compared publish_at (ISO 'T..Z') string-wise with SQLite
CURRENT_TIMESTAMP ('YYYY-MM-DD HH:MM:SS'); because 'T' > space the condition
was never true → scheduled posts NEVER flipped to published. Now
datetime(publish_at) <= datetime('now') (both UTC, same format).
(2) datetime-local was stored as UTC without timezone → 18:10 CEST became
18:10 UTC (= 20:10 local). Now: client converts local input to UTC ISO on save,
pre-fills the field from UTC→local, and shows "Scheduled for" in readable local
time instead of raw UTC ISO.

Co-Authored-By: Claude <noreply@…>

Location:

src/services

Files:

• Scheduler.js (modified) (1 diff)
• i18n.js (modified) (3 diffs)

src/services/Scheduler.js

@@ -16 +16 @@
       SELECT p.id, p.title, p.content, u.username
       FROM posts p JOIN users u ON u.id = p.author_id
-      WHERE p.status = 'scheduled' AND p.publish_at IS NOT NULL AND p.publish_at <= CURRENT_TIMESTAMP
+      WHERE p.status = 'scheduled' AND p.publish_at IS NOT NULL AND datetime(p.publish_at) <= datetime('now')
     `).all();
     if (!due.length) return 0;

src/services/i18n.js

@@ -729 +729 @@
     'pedit.publish_at_label': 'Datum & tijd',
     'pedit.scheduled_for': 'Ingepland voor {d}',
+    'pedit.scheduled_prefix': 'Ingepland voor',
     'pedit.cancel': 'Annuleren',
     'pedit.publish': 'Publish',
@@ -1687 +1688 @@
     'pedit.publish_at_label': 'Date & time',
     'pedit.scheduled_for': 'Scheduled for {d}',
+    'pedit.scheduled_prefix': 'Scheduled for',
     'pedit.cancel': 'Cancel',
     'pedit.publish': 'Publish',
@@ -2645 +2647 @@
     'pedit.publish_at_label': 'Datum & Uhrzeit',
     'pedit.scheduled_for': 'Geplant für {d}',
+    'pedit.scheduled_prefix': 'Geplant für',
     'pedit.cancel': 'Abbrechen',
     'pedit.publish': 'Veröffentlichen',