Changeset 7 for trunk

Timestamp:

Sep 14, 2018, 1:11:19 AM (6 years ago)

Author:

chronos

Message:

• Added: Show daily statistics for runners.

File:

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

trunk/index.php

@@ -98 +98 @@
         {
           $RunnerStat = $DbResult->fetch_assoc();
-          if ($RunnerStat['Distance'] != $Runner['OverallDistance'])
+          if ($RunnerStat['Distance'] < $Runner['OverallDistance'])
           {
             $this->Database->insert('RunnerStat', array(
@@ -193 +193 @@
     $DbResult = $this->Database->query('SELECT * FROM Runner WHERE Id='.$RunnerId);
     $DbRow = $DbResult->fetch_assoc();
-    $Output .= '<h4 style="text-align: center;">Runner '.$DbRow['Name'].'</h4></br>';
-
-
-    $Where = 'Runner='.$RunnerId;
-
+    $Output .= '<h4 style="text-align: center;">Runner '.$DbRow['Name'].'</h4>';
+
+
+    $Where = 'RunnerStat.Runner='.$RunnerId;
+
+    // Show detailed stats
+    $Output .= '<div style="text-align: center">Detailed</div><br/>';
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM `RunnerStat` WHERE '.$Where);
     $DbRow = $DbResult->fetch_row();
@@ -238 +240 @@
     $Output .= '</table>';
     $Output .= $PageList['Output'];
+    $Output .= '</div><br/>';
+
+    // Show daily stats
+    $Where = '1';
+
+    $DailyTableMaxId = 'SELECT * FROM (SELECT MAX(Id) AS MaxId FROM `RunnerStat` AS T1 WHERE T1.Runner='.$RunnerId.' GROUP BY DATE(Time)) AS T2 LEFT JOIN RunnerStat AS T3 ON T3.Id=T2.MaxId';
+    $DailyTableMinId = 'SELECT * FROM (SELECT MIN(Id) AS MinId FROM `RunnerStat` AS T1 WHERE T1.Runner='.$RunnerId.' GROUP BY DATE(Time)) AS T2 LEFT JOIN RunnerStat AS T3 ON T3.Id=T2.MinId';
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$DailyTableMaxId.') AS B');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $Output .= '<div style="text-align: center">Daily</div><br/>';
+    $Output .= '<div id="list_content">';
+    $Output .= $PageList['Output'];
+    $TableColumns = array(
+      array('Name' => 'Time', 'Title' => 'Time'),
+      array('Name' => 'Distance', 'Title' => 'Distance [km]'),
+      array('Name' => 'Money', 'Title' => 'Money [Kč]'),
+      array('Name' => 'Rank', 'Title' => 'Rank'),
+      array('Name' => 'Duration', 'Title' => 'Duration'),
+      array('Name' => 'Length', 'Title' => 'Length [km]'),
+      array('Name' => 'Speed', 'Title' => 'Speed [km/hour]'),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Time', 1);
+    $Output .= '<table class="WideTable">';
+    $Output .= $Order['Output'];
+    $DbResult = $this->Database->query('SELECT * '.
+      ', (SELECT T4.Distance - B.Distance + 1.5 FROM ('.$DailyTableMinId.') AS B WHERE (DATE(B.Time) = DATE(T4.Time)) AND (B.Runner = T4.Runner) ORDER BY B.Time DESC LIMIT 1) AS Length'.
+      ', (SELECT TIME_TO_SEC(TIMEDIFF(T4.Time, B.Time)) / (Length - 1.5) * Length FROM ('.$DailyTableMinId.') AS B WHERE (DATE(B.Time) = DATE(T4.Time)) AND (B.Runner = T4.Runner) ORDER BY B.Time DESC LIMIT 1) AS Duration'.
+      ', NULL AS Speed'.
+      ' FROM ('.$DailyTableMaxId.') AS T4'.
+      ' WHERE '.$Where.$Order['SQL'].$PageList['SQLLimit']);
+    while($MeetItem = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.HumanDateTime(MysqlDateTimeToTime($MeetItem['Time'])).'</td>'.
+        '<td>'.$MeetItem['Distance'].'</td>'.
+        '<td>'.$MeetItem['Money'].'</td>'.
+        '<td>'.$MeetItem['Rank'].'</td>';
+      if ($MeetItem['Duration'] != null) $Output .= '<td>'.$PrefixMultiplier->Add($MeetItem['Duration'], '', 4, 'Time').'</td>';
+        else $Output .= '<td>&nbsp;</td>';
+      $Output .= '<td>'.$MeetItem['Length'].'</td>';
+      if ($MeetItem['Duration'] > 0) $Output .= '<td>'.$PrefixMultiplier->Add($MeetItem['Length'] / $MeetItem['Duration'] * 3600, '', 4, 'Decimal').'</td>';
+        else $Output .= '<td>&nbsp;</td>';
+      $Output .= '</tr>';
+    }
+    $Output .= '</table>';
+    $Output .= $PageList['Output'];
     $Output .= '</div>';