commit 59ba3435708ad5277e7e2e7c0e20063f7d050548
author avm99963 <me@avm99963.com> Mon Sep 28 19:03:29 2020 +0200
committer avm99963 <me@avm99963.com> Mon Sep 28 19:03:29 2020 +0200
tree b05e5b19e7edd2ab47dc6f6b33960d343446a638
parent 282af722a37da7e4843bc6c68ca18b34cb57c8da

Canvi de date a timestamp a la taula classes

Ara les columnes 'begins' i 'ends' contindran enters en comptes de
dates, per solventar un problema existent amb la diferència de zones
horàries. Els enters seran UNIX timestamps.

Change-Id: I460b9b33447e21f05349107d68eb61bd36304780

inc/Classes.php

diff --git a/inc/Classes.php b/inc/Classes.php
index f0ebf90..b7e05a9 100644
--- a/inc/Classes.php
+++ b/inc/Classes.php
@@ -15,8 +15,8 @@
           ON s.id = u_s.subject_id
         ' : '').
         'WHERE
-          c.begins < NOW() AND
-          c.ends > NOW()'.($isSignedIn ? ' AND
+          c.begins < UNIX_TIMESTAMP() AND
+          c.ends > UNIX_TIMESTAMP()'.($isSignedIn ? ' AND
           (
             u_s.user_id = :user_id OR
             u_s.subject_id IS NULL

utils/db_structure.sql

diff --git a/utils/db_structure.sql b/utils/db_structure.sql
index b22a6dd..64837a6 100644
--- a/utils/db_structure.sql
+++ b/utils/db_structure.sql
@@ -29,9 +29,9 @@
   calendar_name VARCHAR(100) NOT NULL,
   INDEX(calendar_name),
   room VARCHAR(10) NOT NULL,
-  begins DATETIME NOT NULL,
+  begins INT NOT NULL, -- UNIX timestamp de l'hora d'inici
   INDEX(begins),
-  ends DATETIME NOT NULL,
+  ends INT NOT NULL, -- UNIX timestamp de l'hora de fi
   INDEX(ends)
 );