Changeset 148 for www/otevreno.php

Timestamp:

Feb 15, 2009, 7:59:35 PM (15 years ago)

Author:

george

Message:

• Upraveno: Přepracován systém generování zobrazení výstupu. Pro nový systím přepsáno mnoho stránek.

File:

• www/otevreno.php (modified) (4 diffs)

www/otevreno.php

@@ -1 +1 @@
 <?php
-include('style.php');
+include_once('global.php');
 
-ShowHeader('Otvírací doby místních subjektů', 'Otvírací doby');
-$DaysOfWeek = array('Pondělí', 'Úterý', 'Středa', 'Čtvrtek', 'Pátek', 'Sobota', 'Neděle');
+class SubjectOpenTimePage extends Page
+{
+  var $FullTitle = 'Otvírací doby místních subjektů';
+  var $ShortTitle = 'Otvírací doby';
+  var $DaysOfWeek = array('Pondělí', 'Úterý', 'Středa', 'Čtvrtek', 'Pátek', 'Sobota', 'Neděle');
 
   function Show()
   {
-        global $Database, $DaysOfWeek;
-        
     $Output = '<div align="center">';
-    $DbResult = $Database->query('SELECT SubjectOpenTime.*, DATE_FORMAT(SubjectOpenTime.UpdateTime, "%e.%c.%Y") as UpdateTime, Subject.Name as Name FROM SubjectOpenTime JOIN Subject ON Subject.Id = SubjectOpenTime.Subject');
+    $DbResult = $this->Database->query('SELECT SubjectOpenTime.*, DATE_FORMAT(SubjectOpenTime.UpdateTime, "%e.%c.%Y") as UpdateTime, Subject.Name as Name FROM SubjectOpenTime JOIN Subject ON Subject.Id = SubjectOpenTime.Subject');
     while($Subject = $DbResult->fetch_array())
     {
       $Output .= '<strong>'.$Subject['Name'].':</strong><br />';
-      $DbResult2 = $Database->query('SELECT Subject, OpenTime, CloseTime, TIMEDIFF(CloseTime, DATE_FORMAT(NOW(), "0000-01-%w %T")) as RemainTime FROM `SubjectOpenTimeInterval` WHERE DATE_FORMAT(NOW(), "0000-01-%w %T") > OpenTime AND DATE_FORMAT(NOW(), "0000-01-%w %T") < CloseTime AND Subject='.$Subject['Subject']);
+      $DbResult2 = $this->Database->query('SELECT Subject, OpenTime, CloseTime, TIMEDIFF(CloseTime, DATE_FORMAT(NOW(), "0000-01-%w %T")) as RemainTime FROM `SubjectOpenTimeInterval` WHERE DATE_FORMAT(NOW(), "0000-01-%w %T") > OpenTime AND DATE_FORMAT(NOW(), "0000-01-%w %T") < CloseTime AND Subject='.$Subject['Subject']);
       if($DbResult2->num_rows > 0)
       {
@@ -21 +22 @@
       } else
       {
-        $DbResult2 = $Database->query('SELECT Subject, OpenTime, CloseTime, TIMEDIFF(OpenTime, DATE_FORMAT(NOW(), "0000-01-%w %T")) as RemainTime FROM `SubjectOpenTimeInterval` WHERE DATE_FORMAT(NOW(), "0000-01-%w %T") < OpenTime AND Subject='.$Subject['Subject'].' ORDER BY OpenTime LIMIT 1');
+        $DbResult2 = $this->Database->query('SELECT Subject, OpenTime, CloseTime, TIMEDIFF(OpenTime, DATE_FORMAT(NOW(), "0000-01-%w %T")) as RemainTime FROM `SubjectOpenTimeInterval` WHERE DATE_FORMAT(NOW(), "0000-01-%w %T") < OpenTime AND Subject='.$Subject['Subject'].' ORDER BY OpenTime LIMIT 1');
         $DbRow = $DbResult2->fetch_array();
         $Output .= 'Otevírá za '.$DbRow['RemainTime'];
@@ -27 +28 @@
       $Output .= '<table class="WideTable">
 <tr><th>Den</th><th>Čas</th></tr>';
-      foreach($DaysOfWeek as $DayIndex => $DayOfWeek)
+      foreach($this->DaysOfWeek as $DayIndex => $DayOfWeek)
       {
-        $DbResult2 = $Database->query('SELECT *, DATE_FORMAT(OpenTime, "%k:%i") as OpenTime, DATE_FORMAT(CloseTime, "%k:%i") as CloseTime FROM SubjectOpenTimeInterval WHERE SubjectOpenTimeInterval.Subject = '.$Subject['Subject'].' AND ((DAYOFWEEK(OpenTime) + 0) MOD 7)='.$DayIndex);
+        $DbResult2 = $this->Database->query('SELECT *, DATE_FORMAT(OpenTime, "%k:%i") as OpenTime, DATE_FORMAT(CloseTime, "%k:%i") as CloseTime FROM SubjectOpenTimeInterval WHERE SubjectOpenTimeInterval.Subject = '.$Subject['Subject'].' AND ((DAYOFWEEK(OpenTime) + 0) MOD 7)='.$DayIndex);
         $Output .= '<tr><td>'.$DayOfWeek.'</td><td align="center">';
         if($DbResult2->num_rows)
@@ -47 +48 @@
     return($Output);
   }
+}
 
-echo(Show());
-
-ShowFooter();
+$System->AddModule(new SubjectOpenTimePage());
+$System->Modules['SubjectOpenTimePage']->GetOutput();
 
 ?>