Changeset 30 for trunk/index.php

Timestamp:

Sep 21, 2019, 8:37:41 PM (5 years ago)

Author:

chronos

Message:

• Added: Show previous for families.

File:

• trunk/index.php (modified) (1 diff)

trunk/index.php

@@ -387 +387 @@
     if (!is_numeric($TeamId)) die('FamilyId needs to be numeric');
 
-    $DbResult = $this->Database->query('SELECT * FROM Team WHERE Id='.$TeamId.' AND IsFamily=1');
+    $DbResult = $this->Database->query('SELECT Team.*, '.
+      '(SELECT COUNT(*) FROM Runner WHERE Runner.Team=Team.Id) AS RunnerCount, '.
+      '(SELECT TeamStat.Distance FROM TeamStat WHERE TeamStat.Team=Team.Id ORDER BY TeamStat.Time DESC LIMIT 1) AS Distance, '.
+      '(SELECT TeamStat.Money FROM TeamStat WHERE TeamStat.Team=Team.Id ORDER BY Time DESC LIMIT 1) AS Money, '.
+      '(SELECT TeamStat.Rank FROM TeamStat WHERE TeamStat.Team=Team.Id ORDER BY Time DESC LIMIT 1) AS Rank '.
+      'FROM Team WHERE Id='.$TeamId.' AND IsFamily=1');
     $DbRow = $DbResult->fetch_assoc();
     $Output .= '<div class="page-title">Family '.$DbRow['Name'].'</div>';
+    $Output .= '<div class="section-title">'.$this->ItemsYearList('/family/', $RunnerId, 'Team', 'Name="'.$DbRow['Name'].'"').'</div>';
+    $Output .= '<div class="section-title">Runners: '.$DbRow['RunnerCount'].', Distance: '.$DbRow['Distance'].' km, Money: '.$DbRow['Money'].' Kč, Rank: '.$DbRow['Rank'].'</div>';
 
     $Where = 'Team='.$TeamId;