Changeset 50 for branches/old/index.php

Timestamp:

Feb 20, 2015, 8:54:42 AM (9 years ago)

Author:

chronos

Message:

• Modified: Show graph, table and other controls horizontally centered.
• Added: Check for existence of config file.
• Added: Check if database is accessible.

File:

• branches/old/index.php (modified) (12 diffs)

branches/old/index.php

@@ -11 +11 @@
 
       $TimeParts = getdate($_SESSION[$Time]);
-      //print_r($TimeParts); 
 
       // Day selection
@@ -17 +16 @@
       for($I = 1; $I < 32; $I++)
       {
-        if($I == $TimeParts['mday']) $Selected = ' selected="1"'; else $Selected = ''; 
+        if($I == $TimeParts['mday']) $Selected = ' selected="1"'; else $Selected = '';
         $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
       }
@@ -25 +24 @@
       $Output .= '<select name="Month">';
       foreach($Months as $Index => $Month)
-      { 
-        if($Index == $TimeParts['mon']) $Selected = ' selected="1"'; else $Selected = ''; 
+      {
+        if($Index == $TimeParts['mon']) $Selected = ' selected="1"'; else $Selected = '';
         if($Index > 0) $Output .= '<option value="'.$Index.'"'.$Selected.'>'.$Month.'</option>';
       }
       $Output .= '</select>. ';
-      
+
       // Day selection
       $Output .= '<select name="Year">';
       for($I = 2000; $I < 2010; $I++)
-      { 
-        if($I == $TimeParts['year']) $Selected = ' selected="1"'; else $Selected = ''; 
+      {
+        if($I == $TimeParts['year']) $Selected = ' selected="1"'; else $Selected = '';
         $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
       }
       $Output .= '</select> &nbsp;&nbsp; ';
-      
-      
+
       // Hour selection
       $Output .= '<select name="Hour">';
       for($I = 0; $I < 24; $I++)
-      { 
-        if($I == $TimeParts['hours']) $Selected = ' selected="1"'; else $Selected = ''; 
+      {
+        if($I == $TimeParts['hours']) $Selected = ' selected="1"'; else $Selected = '';
         $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
       }
@@ -54 +52 @@
       for($I = 0; $I < 60; $I++) 
       {
-        if($I == $TimeParts['minutes']) $Selected = ' selected="1"'; else $Selected = ''; 
+        if($I == $TimeParts['minutes']) $Selected = ' selected="1"'; else $Selected = '';
         $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
       }
       $Output .= '</select> ';
-      $Output .= '<input type="submit" value="Nastavit">';     
+      $Output .= '<input type="submit" value="Nastavit">';
       $Output .= '</form>';
 
       $Output .= ' <form style="display: inline;" action="?Operation=SetTimeNow&amp;Time='.$Time.'" method="post">';
-      $Output .= '<input type="submit" value="Aktuální čas">';     
+      $Output .= '<input type="submit" value="Aktuální čas">';
       $Output .= '</form>';
-      
+
       return($Output);
 }
@@ -73 +71 @@
 $GrafTimeRanges = array(
   'hour' => array(
-    'caption' => 'Hodina', 
+    'caption' => 'Hodina',
     'period' => 3600,
   ),
   'day' => array(
     'caption' => 'Den',
-    'period' => 3600*24,
+    'period' => 3600 * 24,
   ),
   'week' => array(
     'caption' => 'Týden',
-    'period' => 3600*24*7,
+    'period' => 3600 * 24 * 7,
   ),
   'month' => array(
     'caption' => 'Měsíc',
-    'period' => 3600*24*30,
+    'period' => 3600 * 24 * 30,
   ),
   'year' => array(
     'caption' => 'Rok',
-    'period' => 3600*24*365,
+    'period' => 3600 * 24 * 365,
   ),
   'years' => array(
     'caption' => 'Desetiletí',
-    'period' => 3600*24*365*10,
-  ),
-); 
+    'period' => 3600 * 24 * 365 * 10,
+  ),
+);
 
 foreach($Config['DefaultVariables'] as $Index => $Variable)
@@ -104 +102 @@
   if(array_key_exists($Index, $_POST)) $_SESSION[$Index] = $_POST[$Index];
   //$$Index = $_SESSION[$Index];
-} 
+}
 
 if($_SESSION['TimeSpecify'] == 0) 
@@ -112 +110 @@
 }
 
-$Output = '<div class="Title">Statistiky</div>';
+$Output = '<div style="text-align: center"><div class="Title">Statistiky</div>';
 
 if(!array_key_exists('Operation', $_GET)) $_GET['Operation'] = ''; 
@@ -128 +126 @@
         }
       }
-    break; 
+    break;
   case 'SetTimeNow':
     if(array_key_exists('Time', $_GET)) 
@@ -138 +136 @@
       }
     }
-    break; 
-  
+    break;
+
     }
     $Output .= '<strong>Časový úsek:</strong><br>';
-    // Show graf time range menu
+    // Show graph time range menu
     if($_SESSION['TimeSpecify'] == 0)
     {
@@ -151 +149 @@
       $Output .= '<a href="?TimeSpecify=1">Přesnější nastavení...</a><br>';  
     } else {
-      $Output .= '<table cellspacing="0" cellpadding="2" border="0">';
+      $Output .= '<table cellspacing="0" cellpadding="2" border="0" style="margin: 0px auto;">';
       $Output .= '<tr><td>Počátek:</td><td>'.EditTime('TimeStart').'</td></tr>';
       $Output .= '<tr><td>Konec:</td><td>'.EditTime('TimeEnd').'</td></tr>';
@@ -162 +160 @@
 $Output .= '<img alt="Graf" src="graph.php?Measure='.$_SESSION['Measure'].'&amp;From='.$_SESSION['TimeStart'].'&amp;To='.$_SESSION['TimeEnd'].'&amp;Width=750&amp;Height=200&amp;Differential='.$_SESSION['Differential'].'" width="750" height="200"><br>';
 $Output .= '<a href="?Measure='.$_SESSION['Measure'].'&amp;TimeStart='.$_SESSION['TimeStart'].'&amp;TimeEnd='.$_SESSION['TimeEnd'].'&amp;TimeSpecify=1&amp;Differential='.$_SESSION['Differential'].'">Odkaz na vybraný graf</a><br>';
-//print_r(GetValues($Measure, $TimeStart, $TimeEnd));
- 
+
 $Output .= '<br>';
 
-$Output .= '<table border="1" cellspacing="0" cellpadding="2" style="font-size: small;">';
+// Table with available measures
+$Output .= '<table border="1" cellspacing="0" cellpadding="2" style="font-size: small; margin: 0px auto;">';
 $Output .= '<tr><th>Měřená veličina</th><th>Poslední hodnota</th><th>Čas posledního měření</th><th>Interpolace</th><th>Poznámky</th>';
 if(array_key_exists('Debug', $_GET)) $Output .= '<th>Počet položek</th><th>Čas vykonání</th>';
 $Output .= '</tr>';
 $Database->select_db('measure');
-$Result = $Database->select('measure', '*', 'Enabled=1 AND PermissionView="all" OR PermissionView="'.gethostbyaddr($_SERVER['REMOTE_ADDR']).'" ORDER BY Description');
-//echo($Database->error);
-
+$Result = $Database->select('measure', '*', '(Enabled=1) AND ((PermissionView="all") OR (PermissionView="'.gethostbyaddr($_SERVER['REMOTE_ADDR']).'")) ORDER BY Description');
 while($Measure = $Result->fetch_array())
 {
@@ -202 +198 @@
 $Output .= '</table>';
 $Output .= '<br><a href="http://svn.zdechov.net/trac/statistic/">Sekce vývoje systému</a>';
-//echo(time());
-//print_r(gd_info());
-$Output .= '</body></html>';
-//print_r($_SESSION);
+$Output .= '</div></body></html>';
 
 ShowPage($Output);
-
-//echo(AddPrefixMultipliers('-0.000000071112345', 'B'));