Changeset 153 for www/otevreno.php

Timestamp:

Feb 16, 2009, 6:16:00 PM (15 years ago)

Author:

george

Message:

• Přidáno: Zobrazování chyb v SQL povelech. Nastavení v konfigureaci.
• Upraveno: Zpřístupnění stavu financí dle ip i dle přihlášení.

File:

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

www/otevreno.php

@@ -11 +11 @@
   {
     $Output = '<div align="center">';
-    $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())
+    $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 ORDER BY Name');
+    while($Subject = $DbResult->fetch_assoc())
     {
       $Output .= '<strong>'.$Subject['Name'].':</strong><br />';
@@ -18 +18 @@
       if($DbResult2->num_rows > 0)
       {
-        $DbRow = $DbResult2->fetch_array();
+        $DbRow = $DbResult2->fetch_assoc();
         $Output .= 'Zavírá za '.$DbRow['RemainTime'];
       } else
       {
         $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();
+        $DbRow = $DbResult2->fetch_assoc();
         $Output .= 'Otevírá za '.$DbRow['RemainTime'];
       }
@@ -34 +34 @@
         if($DbResult2->num_rows)
         {
-          while($TimeInterval = $DbResult2->fetch_array())
+          while($TimeInterval = $DbResult2->fetch_assoc())
           {
             $Output .= $TimeInterval['OpenTime'].' - '.$TimeInterval['CloseTime'].' &nbsp;&nbsp; ';