Changeset 4 for trunk/index.php

Timestamp:

Sep 10, 2018, 1:41:13 AM (6 years ago)

Author:

chronos

Message:

• Added: Show list of changes for each runner.

File:

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

trunk/index.php

@@ -143 +143 @@
       array('Name' => 'Distance', 'Title' => 'Distance'),
       array('Name' => 'Money', 'Title' => 'Money'),
+      array('Name' => 'Rank', 'Title' => 'Rank'),
+      array('Name' => 'Time', 'Title' => 'Last change'),
     );
     $Order = GetOrderTableHeader($TableColumns, 'Distance', 1);
@@ -149 +151 @@
     $DbResult = $this->Database->select('Runner', '*, '.
       '(SELECT RunnerStat.Distance FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Distance'.
-      ', (SELECT RunnerStat.Money FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Money',
+      ', (SELECT RunnerStat.Money FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Money'.
+      ', (SELECT RunnerStat.Time FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Time'.
+      ', (SELECT RunnerStat.Rank FROM RunnerStat WHERE RunnerStat.Runner=Runner.Id ORDER BY Time DESC LIMIT 1) AS Rank',
       $Where.$Order['SQL'].$PageList['SQLLimit']);
     while($MeetItem = $DbResult->fetch_assoc())
     {
       $Output .= '<tr>'.
-        '<td>'.$MeetItem['Name'].'</td>'.
+        '<td><a href="'.$this->Link('/runner/'.$MeetItem['Id'].'/').'">'.$MeetItem['Name'].'</a></td>'.
         '<td>'.$Gender[$MeetItem['Gender']].'</td>'.
         '<td>'.$MeetItem['Distance'].'</td>'.
         '<td>'.$MeetItem['Money'].'</td>'.
+        '<td>'.$MeetItem['Rank'].'</td>'.
+        '<td>'.HumanDateTime(MysqlDateTimeToTime($MeetItem['Time'])).'</td>'.
+        '</tr>';
+    }
+    $Output .= '</table>';
+    $Output .= $PageList['Output'];
+    $Output .= '</div>';
+
+    return($Output);
+  }
+
+  function ShowRunner()
+  {
+    $Output = '';
+
+    $RunnerId = 1;
+    if ((count($this->PathItems) > 0) and ($this->PathItems[count($this->PathItems) - 1] != ''))
+      $RunnerId = $this->PathItems[count($this->PathItems) - 1];
+    if (!is_numeric($RunnerId)) die('Runner id needs to be numeric');
+
+    $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;
+
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `RunnerStat` WHERE '.$Where);
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $Output .= '<div id="list_content">';
+    $Output .= $PageList['Output'];
+    $TableColumns = array(
+      array('Name' => 'Time', 'Title' => 'Time'),
+      array('Name' => 'Distance', 'Title' => 'Distance'),
+      array('Name' => 'Money', 'Title' => 'Money'),
+      array('Name' => 'Rank', 'Title' => 'Rank'),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Time', 1);
+    $Output .= '<table class="WideTable">';
+    $Output .= $Order['Output'];
+    $DbResult = $this->Database->select('RunnerStat', '*',
+      $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>'.
         '</tr>';
     }
@@ -204 +259 @@
     {
       if($this->PathItems[0] == 'team-update') $Output .= $this->ShowTeamUpdate();
+      if($this->PathItems[0] == 'runner') $Output .= $this->ShowRunner();
       else $Output .= $this->ShowTeam();
     } else $Output .= $this->ShowTeam();