source: branches/mvc/Application/View/Main.php

<?php

include_once(dirname(__FILE__).'/../../Base/View.php');

class MainView extends View
{
  var $Months = array('', 'Leden', 'Únor', 'Březen', 'Duben', 'Květen', 'Červen', 'Červenec', 'Srpen', 'Září', 'Říjen', 'Listopad', 'Prosinec');

  var $GraphTimeRanges = array
  (
    'hour' => array(
      'caption' => 'Hodina',
      'period' => 3600,
    ),
    'day' => array(
      'caption' => 'Den',
      'period' => 86400, // 3600 * 24,
    ),
    'week' => array(
      'caption' => 'Týden',
      'period' => 604800, // 3600 * 24 * 7,
    ),
    'month' => array(
      'caption' => 'Měsíc',
      'period' => 2592000, // 3600 * 24 * 30,
    ),
    'year' => array(
      'caption' => 'Rok',
      'period' => 31536000, // 3600 * 24 * 365,
    ),
    'years' => array(
      'caption' => 'Desetiletí',
      'period' => 315360000, // 3600 * 24 * 365 * 10,
    ),
  );

  function EditTime($Time)
  {
    $Output = '<form style="display: inline;" action="?Operation=SetTime&amp;Time='.$Time.'" method="post">';

    $TimeParts = getdate($_SESSION[$Time]);
    //print_r($TimeParts);

    // Day selection
    $Output .= '<select name="Day">';
    for($I = 1; $I < 32; $I++)
    {
      if($I == $TimeParts['mday']) $Selected = ' selected="1"'; else $Selected = '';
      $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
    }
    $Output .= '</select>. ';

    // Month selection
    $Output .= '<select name="Month">';
    foreach($this->Months as $Index => $Month)
    {
      if($Index == $TimeParts['mon']) $Selected = ' selected="1"'; else $Selected = '';
      if($Index > 0) $Output .= '<option value="'.$Index.'"'.$Selected.'>'.$Month.'</option>';
    }
    $Output .= '</select>. ';

    // Day selection
    $Output .= '<select name="Year">';
    for($I = 2000; $I < 2010; $I++)
    {
      if($I == $TimeParts['year']) $Selected = ' selected="1"'; else $Selected = '';
      $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
    }
    $Output .= '</select> &nbsp;&nbsp; ';

    // Hour selection
    $Output .= '<select name="Hour">';
    for($I = 0; $I < 24; $I++)
    {
      if($I == $TimeParts['hours']) $Selected = ' selected="1"'; else $Selected = '';
      $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
    }
    $Output .= '</select> : ';

    // Minute selection
    $Output .= '<select name="Minute">';
    for($I = 0; $I < 60; $I++)
    {
      if($I == $TimeParts['minutes']) $Selected = ' selected="1"'; else $Selected = '';
      $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
    }
    $Output .= '</select> ';
    $Output .= '<input type="submit" value="Nastavit">';
    $Output .= '</form>';

    $Output .= ' <form style="display: inline;" action="?Operation=SetTimeNow&amp;Time='.$Time.'" method="post">';
    $Output .= '<input type="submit" value="Aktuální čas">';
    $Output .= '</form>';

    return($Output);
  }

  function Show()
  {
    $Debug = 0;
    foreach($this->Config['Application']['DefaultVariables'] as $Index => $Variable)
    {
      if(!array_key_exists($Index, $_SESSION)) $_SESSION[$Index] = $Variable;
      if(array_key_exists($Index, $_GET)) $_SESSION[$Index] = $_GET[$Index];
      if(array_key_exists($Index, $_POST)) $_SESSION[$Index] = $_POST[$Index];
      //$$Index = $_SESSION[$Index];
    }

    if($_SESSION['TimeSpecify'] == 0)
    {
      $_SESSION['TimeEnd'] = time() - 60;
      $_SESSION['TimeStart'] = $_SESSION['TimeEnd'] - $this->GraphTimeRanges[$_SESSION['Period']]['period'];
    }

    $Output = '<div class="Main">';
    $Output .= '<div class="Title">Statistiky</div>';

    if(!array_key_exists('Operation', $_GET)) $_GET['Operation'] = '';
    switch($_GET['Operation'])
    {
      case 'SetTime':
        if(array_key_exists('Time', $_GET) and array_key_exists('Month', $_POST) and array_key_exists('Day', $_POST) and
          array_key_exists('Year', $_POST) and array_key_exists('Hour', $_POST) and array_key_exists('Minute', $_POST))
        {
          if(($_GET['Time'] == 'TimeStart') or ($_GET['Time'] == 'TimeEnd'))
          {
            $_SESSION[$_GET['Time']] = mktime($_POST['Hour'], $_POST['Minute'], 0, $_POST['Month'],
              $_POST['Day'], $_POST['Year']);
            $$_GET['Time'] = $_SESSION[$_GET['Time']];
          }
        }
        break;
      case 'SetTimeNow':
        if(array_key_exists('Time', $_GET))
        {
          if(($_GET['Time'] == 'TimeStart') or ($_GET['Time'] == 'TimeEnd'))
          {
            $_SESSION[$_GET['Time']] = time();
            $$_GET['Time'] = $_SESSION[$_GET['Time']];
          }
        }
        break;
    }
    $Output .= '<strong>Časový úsek:</strong><br/>';
    // Show graf time range menu
    if($_SESSION['TimeSpecify'] == 0)
    {
      $Output .= 'Délka úseku: ';
      foreach($this->GraphTimeRanges as $Index => $Item)
        $Output .= '<a href="?Period='.$Index.'">'.$Item['caption'].'</a>&nbsp;';
      $Output .= '<br/>';
      $Output .= '<a href="?TimeSpecify=1">Přesnější nastavení...</a><br/>';
    } else {
      $Output .= '<table cellspacing="0" cellpadding="2" border="0">';
      $Output .= '<tr><td>Počátek:</td><td>'.$this->EditTime('TimeStart').'</td></tr>';
      $Output .= '<tr><td>Konec:</td><td>'.$this->EditTime('TimeEnd').'</td></tr>';
      $Output .= '</table>';
      $Output .= '<a href="?TimeSpecify=0">Jednoduché nastavení...</a><br/>';
    }
    $Output .= '<br/>'.$this->Graph();

    $Output .= '<br/>'.$this->MeasureTable();
    $Output .= '</div>';
    return($Output);
  }

  function Graph()
  {
    $Output = '<strong>Graf:</strong><br/>';
    $Output .= '<img alt="Graf" src="?M=Graph&amp;Measure='.$_SESSION['Measure'].
      '&amp;From='.$_SESSION['TimeStart'].'&amp;To='.$_SESSION['TimeEnd'].'&amp;Width='.
      $this->Config['Application']['ImageWidth'].'&amp;Height='.$this->Config['Application']['ImageHeight'].
      '&amp;Differential='.$_SESSION['Differential'].'" width="'.$this->Config['Application']['ImageWidth'].
      '" height="'.$this->Config['Application']['ImageHeight'].'"/><br/>';
    $Output .= '<a href="?Measure='.$_SESSION['Measure'].'&amp;TimeStart='.$_SESSION['TimeStart'].'&amp;TimeEnd='.$_SESSION['TimeEnd'].'&amp;TimeSpecify=1&amp;Differential='.$_SESSION['Differential'].'">Odkaz na vybraný graf</a><br/>';
//print_r(GetValues($Measure, $TimeStart, $TimeEnd));
    return($Output);
  }

  function MeasureTable()
  {
    $Output = '<table class="WideTable">';
    $Output .= '<tr><th>Měřená veličina</th><th>Poslední hodnota</th><th>Čas posledního měření</th><th>Interpolace</th><th>Poznámky</th>';
    if(array_key_exists('Debug', $_GET)) $Output .= '<th>Počet položek</th><th>Čas vykonání</th>';
    $Output .= '</tr>';
    $PrefixMultiplier = new PrefixMultiplier();
    $Result = $this->Database->select('Measure', '*', 'Enabled=1 ORDER BY Description');
    while($Measure = $Result->fetch_array())
    {
      $DbResult2 = $this->Database->select('MeasureMethod', '*', 'Id='.$Measure['Method']);
      $MeasureMethod = $DbResult2->fetch_assoc();
      $StopWatchStart = $this->System->GetMicrotime();
      if(array_key_exists('Debug', $_GET))
      {
        $DbResult = $this->Database->select($Measure['DataTable'], 'COUNT(*)', 'Measure='.$Measure['Id']);
        $RowCount = $DbResult->fetch_array();
        $RowCount = $RowCount[0];
      }
      $Result2 = $this->Database->select($Measure['DataTable'], 'Time, Avg', 'Measure='.$Measure['Id'].' AND Level=0 ORDER BY Time DESC LIMIT 1');
      if($Result2->num_rows > 0)
      {
        $Row = $Result2->fetch_array();
        $LastMeasureTime = date('j.n.Y G:i:s', $this->Database->MysqlDateTimeToTime($Row['Time']));
        $LastMeasureValue = $PrefixMultiplier->Add($Row['Avg'], $MeasureMethod['Unit']);
      } else
      {
        $LastMeasureTime = '&nbsp;';
        $LastMeasureValue = '&nbsp;';
      }
      if($Measure['Continuity'] == 1) $Interpolate = 'Ano';
        else $Interpolate = 'Ne';
      if($Measure['Info'] == '') $Measure['Info'] = '&nbsp;';
      $GenerationTime = floor(($this->System->GetMicrotime() - $StopWatchStart) * 1000  ) / 1000;
      $Output .= '<tr><td><a href="?Measure='.$Measure['Id'].'&amp;Differential=0">'.$Measure['Name'].'</a></td><td align="center">'.$LastMeasureValue.'</td><td align="center">'.$LastMeasureTime.'</td><td align="center">'.$Interpolate.'</td><td>'.$Measure['Description'].'</td>';
      if(array_key_exists('Debug', $_GET)) $Output .= '<td>'.$RowCount.'</td><td>'.$GenerationTime.'</td>';
      $Output .= '</tr>';
    }
    $Output .= '</table>';
    //echo(time());
    //print_r(gd_info());
    //print_r($_SESSION);

    //ShowPage($Output);
    return($Output);
  }
}