source: trunk/otevreno.php@ 203

<?php
include_once('global.php');

class SubjectOpenTimePage extends Page
{
  var $FullTitle = 'Otvírací doby místních subjektů';
  var $ShortTitle = 'Otvírací doby';
  var $DaysOfWeek = array('Pondělí', 'Úterý', 'Středa', 'Čtvrtek', 'Pátek', 'Sobota', 'Neděle');
  var $DayShift = 3;

  function Show()
  {
    $Output = '<div class="Centred">';
    $DbResult = $this->Database->query('SELECT SubjectOpenTime.*, DATE_FORMAT(SubjectOpenTime.UpdateTime, "%e.%c.%Y") as UpdateTime, Subject.Name as Name FROM SubjectOpenTime JOIN Subject ON Subject.Id = SubjectOpenTime.Subject ORDER BY Name');
    while($Subject = $DbResult->fetch_assoc())
    {
      $Output .= '<strong>'.$Subject['Name'].':</strong><br />';
          
      $DbResult2 = $this->Database->query('SELECT Subject, OpenTime, CloseTime, TIMEDIFF(DATE_FORMAT(CloseTime, "0000-01-%w %T"), DATE_FORMAT(NOW(), "0000-01-%w %T")) as RemainTime FROM `SubjectOpenTimeInterval` WHERE DATE_FORMAT(NOW(), "0000-01-%w %T") > OpenTime AND DATE_FORMAT(NOW(), "0000-01-%w %T") < CloseTime AND Subject='.$Subject['Subject']);
      if($DbResult2->num_rows > 0)
      {
        $DbRow = $DbResult2->fetch_assoc();
        $Output .= 'Zavírá za '.$DbRow['RemainTime'];
      } else
      {
        $DbResult2 = $this->Database->query('SELECT Subject, OpenTime, CloseTime, TIMEDIFF(OpenTime, DATE_FORMAT(NOW(), "0000-01-%w %T")) as RemainTime FROM `SubjectOpenTimeInterval` WHERE DATE_FORMAT(NOW(), "0000-01-%w %T") < OpenTime AND Subject='.$Subject['Subject'].' ORDER BY OpenTime LIMIT 1');
        $DbRow = $DbResult2->fetch_assoc();
        $Output .= 'Otevírá za '.$DbRow['RemainTime'];
      }

            $Output .= '<table class="WideTable">
<tr><th>Den</th><th>Čas</th></tr>';
      foreach($this->DaysOfWeek as $DayIndex => $DayOfWeek)
      {
        $DbResult2 = $this->Database->query('SELECT *, DATE_FORMAT(OpenTime, "%k:%i") as OpenTime2, DATE_FORMAT(CloseTime, "%k:%i") as CloseTime2, DAYOFWEEK(OpenTime) as Week FROM SubjectOpenTimeInterval WHERE SubjectOpenTimeInterval.Subject = '.$Subject['Subject'].' AND ((DAYOFWEEK(OpenTime) + 7) MOD 7)='.$DayIndex);
        $Output .= '<tr><td>'.$DayOfWeek.'</td><td align="center">';
        if($DbResult2->num_rows)
        {
          while($TimeInterval = $DbResult2->fetch_assoc())
          {
            $Output .= $TimeInterval['OpenTime2'].' - '.$TimeInterval['CloseTime2'].' &nbsp;&nbsp; ';
          }
        } else
          $Output .= '&nbsp;';
        $Output .= '</td></tr>';
      }
      $Output .= '</table>Aktualizováno: '.$Subject['UpdateTime'].'<br />';
      if($Subject['Notice'] != '') $Output .= 'Poznámka: '.$Subject['Notice'].'<br />';
      $Output .= '<br />';
    }
    $Output .= '</div>';
    return($Output);
  }
}

$System->AddModule(new SubjectOpenTimePage());
$System->Modules['SubjectOpenTimePage']->GetOutput();

?>