Changeset 12 for trunk/index.php

Timestamp:

Aug 29, 2019, 12:14:23 AM (5 years ago)

Author:

chronos

Message:

• Added: Summary page with total numbers of items in all categories.

File:

• trunk/index.php (modified) (3 diffs)

trunk/index.php

@@ -36 +36 @@
   {
     $Output = '<div>'.
+      '<a href="'.$this->Link('/').'">Summary</a> '.
       '<a href="'.$this->Link('/runners').'">Runners</a> '.
       '<a href="'.$this->Link('/teams').'">Teams</a> '.
@@ -592 +593 @@
   function ShowMain()
   {
-    return "";
+    $Output = '';
+    $DbResult = $this->Database->select('Runner', 'COUNT(*) AS Total');
+    $DbRow = $DbResult->fetch_assoc();
+    $RunnersCount = $DbRow['Total'];
+
+    $Output = '';
+    $DbResult = $this->Database->select('Runner', 'COUNT(*) AS Total', 'Gender=1');
+    $DbRow = $DbResult->fetch_assoc();
+    $MenCount = $DbRow['Total'];
+
+    $Output = '';
+    $DbResult = $this->Database->select('Runner', 'COUNT(*) AS Total', 'Gender=2');
+    $DbRow = $DbResult->fetch_assoc();
+    $WomenCount = $DbRow['Total'];
+
+    $Output = '';
+    $DbResult = $this->Database->select('Runner', 'COUNT(*) AS Total', 'Gender=3');
+    $DbRow = $DbResult->fetch_assoc();
+    $KidsCount = $DbRow['Total'];
+
+    $DbResult = $this->Database->select('Team', 'COUNT(*) AS Total', 'IsFamily=0');
+    $DbRow = $DbResult->fetch_assoc();
+    $TeamsCount = $DbRow['Total'];
+
+    $DbResult = $this->Database->select('Team', 'COUNT(*) AS Total', 'IsFamily=1');
+    $DbRow = $DbResult->fetch_assoc();
+    $FamiliesCount = $DbRow['Total'];
+    
+    $Output .= '<div class="page-title">Summary</div>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Category</th><th>Total count</th></tr>';
+    $Output .= '<tr><td>Runners</td><td>'.$RunnersCount.'</td></tr>';
+    $Output .= '<tr><td>Men</td><td>'.$MenCount.'</td></tr>';
+    $Output .= '<tr><td>Women</td><td>'.$WomenCount.'</td></tr>';
+    $Output .= '<tr><td>Kids</td><td>'.$KidsCount.'</td></tr>';
+    $Output .= '<tr><td>Teams</td><td>'.$TeamsCount.'</td></tr>';
+    $Output .= '<tr><td>Families</td><td>'.$FamiliesCount.'</td></tr>';
+    $Output .= '</table>';
+
+    return $Output;
   }
 
@@ -632 +672 @@
     {
       if($this->PathItems[0] == 'sync') $Output .= $this->ShowSync();
-      else if($this->PathItems[0] == 'empty') $Output .= $this->ShowEmpty();
+      //else if($this->PathItems[0] == 'empty') $Output .= $this->ShowEmpty();
       else if($this->PathItems[0] == 'runner') $Output .= $this->ShowRunner();
       else if($this->PathItems[0] == 'runners') $Output .= $this->ShowRunners();