source: trunk/Modules/Ride/PageRideDetail.php

<?php

class PageRideDetail extends Page
{
  function ShowDetail()
  {
    $RideId = $_GET['id'];
    $DbResult = $this->Database->query('SELECT Ride.Details, Ride.Id, Ride.SeatCount, '.
      'RideStopFrom.Id AS RideStopFromId, RideStopTo.Id AS RideStopToId, '.
      '(SELECT Name FROM User WHERE User.Id=Ride.Driver) AS DriverName, '.
      'CONCAT(CarManufacturer.Name, " ", CarModel.Name) AS CarName FROM Ride '.
      'JOIN RideStop AS RideStopFrom ON (RideStopFrom.Ride = Ride.Id) AND (RideStopFrom.Place LIKE "%'.$_GET['from'].'%") '.
      'JOIN RideStop AS RideStopTo ON (RideStopTo.Ride = Ride.Id) AND (RideStopTo.Place LIKE "%'.$_GET['to'].'%") '.
        'LEFT JOIN Car ON Car.Id = Ride.Car '.
      'LEFT JOIN CarModel ON CarModel.Id = Car.Model '.
      'LEFT JOIN CarManufacturer ON CarManufacturer.Id = CarModel.Manufacturer '.
      'WHERE Ride.Id='.$RideId);
    $DbRow = $DbResult->fetch_assoc();
    $Track = array();
    $Stops = array();
    $DbResult2 = $this->Database->query('SELECT * FROM RideStop WHERE Ride='.$DbRow['Id'].' ORDER BY Sequence');
    while ($DbRow2 = $DbResult2->fetch_assoc())
    {
      $Track[] = $DbRow2;
      $Stops[] = $DbRow2['Place'];
    }

    $Output = '<h3>Detail jízdy</h3><table>'.
      '<tr><td>Trasa:</td><td>'.implode(' → ', $Stops).'</td></tr>'.
      '<tr><td>Odjezd z:</td><td>'.$Track[0]['Place'].'</td></tr>'.
      '<tr><td>Příjezd do:</td><td>'.$Track[count($Track) - 1]['Place'].'</td></tr>'.
      '<tr><td>Čas odjezdu:</td><td>'.$Track[0]['Time'].'</td></tr>'.
      '<tr><td>Podrobnosti:</td><td>'.$DbRow['Details'].'</td></tr>';
    $Output .= '</table>';
    $Output .= '<form action="?step=2" method="post">'.
      'Počet míst: <input type="text" name="seats" value="1"/>'.
      '<input type="hidden" name="id" value="'.$RideId.'"/>'.
      '<input type="hidden" name="fromid" value="'.$DbRow['RideStopFromId'].'"/>'.
      '<input type="hidden" name="toid" value="'.$DbRow['RideStopToId'].'"/>'.
      '<input type="submit" value="Rezervovat"/>'.
      '</form>';

    $Output .= '<h3>Cestující</h3>'.
      '<table class="WideTable">';

    // Load passengers table
    $Table = array_fill(0, count($Track), array_fill(0, $DbRow['SeatCount'], NULL));
    $Passengers = array();
    $DbResult = $this->System->Database->query('SELECT User.Name AS UserName, PassengerRideStopFrom.Sequence AS SequenceFrom, '.
      'PassengerRideStopTo.Sequence AS SequenceTo FROM Passenger '.
      'LEFT JOIN RideStop AS PassengerRideStopFrom ON PassengerRideStopFrom.Id=Passenger.RideStopFrom '.
      'LEFT JOIN RideStop AS PassengerRideStopTo ON PassengerRideStopTo.Id=Passenger.RideStopTo '.
      'LEFT JOIN User ON User.Id=Passenger.User '.
      'WHERE Passenger.Ride='.$RideId);
    while ($Passenger = $DbResult->fetch_assoc())
    {
      $Passengers[] = $Passenger;
      $Seat = 0;
      do {
        $Check = true;
        for ($I = $Passenger['SequenceFrom']; $I < $Passenger['SequenceTo']; $I++)
        {
          if ($Table[$I][$Seat] != 0) $Check = false;
        }
        if (!$Check) $Seat++;
      } while (!$Check);
      for ($I = $Passenger['SequenceFrom']; $I < $Passenger['SequenceTo']; $I++)
        $Table[$I][$Seat] = count($Passengers) - 1;
    }

    $Output .= '<tr><th>Zastávka / Čas</th><th style="width: 80px">Řidič</th>';
    for ($I = 0; $I < $DbRow['SeatCount']; $I++)
      $Output .= '<th style="width: 80px">Cestující</th>';
    $Output .= '</tr>';
    foreach ($Track as $Index => $TrackItem)
    {
      $Output .= '<tr><td style="height: 100px">'.$TrackItem['Place'].'<br/>'.$TrackItem['Time'].'</td>';
      if ($Index == 0) $Output .= '<td rowspan="'.count($Track).'">Řidič</td>';
      for ($I = 0; $I < $DbRow['SeatCount']; $I++)
      {
        if (!is_null($Table[$Index][$I])) {
          $Passenger = $Passengers[$Table[$Index][$I]];
          if ($Index == $Passenger['SequenceFrom'])
          $Output .= '<td rowspan="'.($Passenger['SequenceTo'] - $Passenger['SequenceFrom']).'">'.$Passenger['UserName'].'</td>';
        } else {
          // Show unused space
          if (($Index == 0) or ((($Index - 1) >= 0) and (!is_null($Table[$Index - 1][$I]))))
          {
            $J = 1;
            while ((($Index + $J) < count($Table)) and is_null($Table[$Index + $J][$I])) $J++;
            $Output .= '<td rowspan="'.$J.'">&nbsp;</td>';
          }
        }
      }
      $Output .= '</tr>';
    }
    $Output .= '</table>';


    return $Output;
  }

  function Show(): string
  {
    if (!array_key_exists('step', $_GET)) $Output = $this->ShowDetail();
    else {
      if ($_GET['step'] == 2) {
        $this->System->Database->insert('Passenger', array(
          'Ride' => $_POST['id'],
          'User' => Core::Cast($this->System)->User->User['Id'],
          'SeatCount' => $_POST['seats'],
          'RideStopFrom' => $_POST['fromid'],
          'RideStopTo' => $_POST['toid'],
        ));
        $this->System->ModuleManager->Modules['Ride']->UpdatePassengerCount($_POST['id']);
        $Output = 'Rezervace dokončena';
      }
    }
    return $Output;
  }
}