Changeset 51

Timestamp:

Jan 2, 2020, 12:34:24 AM (4 years ago)

Author:

chronos

Message:

• Added: New section Events to import dance events from various dance clubs and dance schools.

Location:

trunk

Files:

• Modules/Event (added)
• Modules/Event/Event.php (added)
• Modules/Event/EventPage.php (added)
• Modules/Event/Import (added)
• Modules/Event/Import/JoeClub.php (added)
• SQL/Structure.sql (modified) (1 diff)
• SQL/Update.php (modified) (1 diff)
• index.php (modified) (5 diffs)

trunk/SQL/Structure.sql

@@ -44 +44 @@
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+-- Export dat nebyl vybrán.
+
+-- Exportování struktury pro tabulka tanec.Event
+CREATE TABLE IF NOT EXISTS `Event` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `TimeFrom` datetime DEFAULT NULL,
+  `TimeTo` datetime DEFAULT NULL,
+  `Source` int(11) DEFAULT NULL,
+  `Link` varchar(255) DEFAULT NULL,
+  `Hidden` int(11) DEFAULT 0,
+  `Description` text DEFAULT NULL,
+  `Title` varchar(255) DEFAULT NULL,
+  `Price` int(11) DEFAULT NULL,
+  `Location` varchar(255) DEFAULT NULL,
+  `TimeImport` datetime DEFAULT NULL,
+  `RemoteId` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Source` (`Source`)
+) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;
+
+-- Export dat nebyl vybrán.
+
+-- Exportování struktury pro tabulka tanec.EventSource
+CREATE TABLE IF NOT EXISTS `EventSource` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) DEFAULT NULL,
+  `Method` varchar(255) DEFAULT NULL,
+  `URL` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
 
 -- Export dat nebyl vybrán.

trunk/SQL/Update.php

@@ -56 +56 @@
 ALTER TABLE `MeetItem`
   ADD COLUMN `Hidden` INT NULL DEFAULT '0' AFTER `RemoteId`;
+
+-- rev 51
+CREATE TABLE IF NOT EXISTS `Event` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `TimeFrom` datetime DEFAULT NULL,
+  `TimeTo` datetime DEFAULT NULL,
+  `Source` int(11) DEFAULT NULL,
+  `Link` varchar(255) DEFAULT NULL,
+  `Hidden` int(11) DEFAULT 0,
+  `Description` text DEFAULT NULL,
+  `Title` varchar(255) DEFAULT NULL,
+  `Price` int(11) DEFAULT NULL,
+  `Location` varchar(255) DEFAULT NULL,
+  `TimeImport` datetime DEFAULT NULL,
+  `RemoteId` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Source` (`Source`)
+) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS `EventSource` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) DEFAULT NULL,
+  `Method` varchar(255) DEFAULT NULL,
+  `URL` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

trunk/index.php

@@ -13 +13 @@
 require_once('Modules/School/School.php');
 require_once('Modules/Club/Club.php');
+require_once('Modules/Event/Event.php');
+require_once('Modules/Event/EventPage.php');
 
 if(isset($_SERVER['REMOTE_ADDR'])) session_start();
@@ -220 +222 @@
       '/tance/',
       '/filmy/',
+      '/udalosti/',
     );
     $Result = '<?xml version="1.0" encoding="UTF-8"?>'."\n".
@@ -230 +233 @@
         '</url>'."\n";
     }
-    // MeetItems
+
+    // Meets
     $DbResult = $this->Database->query('SELECT `Id`,`Time` FROM `MeetItem` WHERE (`Hidden`=0)');
     while ($DbRow = $DbResult->fetch_array())
@@ -236 +240 @@
       $Url = '/seznamka/inzerat/'.$DbRow['Id'];
       $Time = MysqlDateTimeToTime($DbRow['Time']);
+      $Result .= '<url>'."\n".
+        '  <loc>'.$this->System->AbsoluteLink($Url).'</loc>'."\n".
+        '  <lastmod>'.date('c', $Time).'</lastmod>'."\n".
+        '</url>'."\n";
+    }
+
+    // Events
+    $DbResult = $this->Database->query('SELECT `Id`,`TimeFrom` FROM `Event` WHERE (`Hidden`=0)');
+    while ($DbRow = $DbResult->fetch_array())
+    {
+      $Url = '/udalosti/udalost/'.$DbRow['Id'];
+      $Time = MysqlDateTimeToTime($DbRow['TimeFrom']);
       $Result .= '<url>'."\n".
         '  <loc>'.$this->System->AbsoluteLink($Url).'</loc>'."\n".
@@ -293 +309 @@
 }
 
-$Revision = 48; // Subversion revision
-$DatabaseRevision = 48; // SQL structure revision
-$ReleaseTime = strtotime('2019-12-22');
+$Revision = 51; // Subversion revision
+$DatabaseRevision = 51; // SQL structure revision
+$ReleaseTime = strtotime('2020-01-01');
 
 $Application = new ApplicationTanec();