source: trunk/Modules/Translation/Progress.php

<?php

class PageProgress extends Page
{
  function ShowStatTable()
  {
    $Output = '';

    $BuildNumber = GetBuildNumber($_SESSION['StatVersion']);
    if (is_numeric($_SESSION['language'])) $LanguageFilter = 'AND (`Language`='.$_SESSION['language'].')';
    else $LanguageFilter = ' AND (`Language`!='.Core::Cast($this->System)->Config['OriginalLanguage'].')';

    $GroupListQuery = 'SELECT `Id`, `TablePrefix`, `Name` FROM `Group`';
    $Query = '';
    $DbResult = $this->Database->query($GroupListQuery);
    if ($DbResult->num_rows > 0)
    {
      while ($DbRow = $DbResult->fetch_assoc())
      {
        $Query .= 'SELECT (SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
          'SELECT `T`.`Entry` FROM `'.$DbRow['TablePrefix'].'` AS `T` '.
          'WHERE (`Complete` = 1) '.$LanguageFilter.' '.
          'AND (`VersionStart` <= '.$BuildNumber.') AND (`VersionEnd` >= '.$BuildNumber.')'.
          ') AS `C1`) AS `Translated`, '.
          '(SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
          'SELECT `T`.`Entry` FROM `'.$DbRow['TablePrefix'].'` AS `T` '.
          'WHERE (`Language` = '.Core::Cast($this->System)->Config['OriginalLanguage'].') '.
          'AND (`VersionStart` <= '.$BuildNumber.') AND (`VersionEnd` >= '.$BuildNumber.')'.
          ') AS `C2`) AS `Total`, "'.$DbRow['Name'].'" AS `Name` UNION ';
      }
      $Query = substr($Query, 0, - 6);

      $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$GroupListQuery.') AS `T`');
      $DbRow = $DbResult->fetch_row();
      $PageList = GetPageList($DbRow[0]);
      $Output .= $PageList['Output'];

      $Output .= '<table class="BaseTable">';
      $TableColumns = array(
        array('Name' => 'Name', 'Title' => T('Name')),
        array('Name' => 'Translated', 'Title' => T('Translated')),
        array('Name' => 'Total', 'Title' => T('Original')),
        array('Name' => 'Percent', 'Title' => T('Percentage')),
      );

      $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
      $Output .= $Order['Output'];

      $Translated = 0;
      $Total = 0;
      $DbResult = $this->Database->query('SELECT *, ROUND(`Translated` / `Total` * 100, 2) AS `Percent` FROM ('.$Query.') AS `C3` '.$Order['SQL'].$PageList['SQLLimit']);
      while ($Group = $DbResult->fetch_assoc())
      {
        $Output .= '<tr><td>'.T($Group['Name']).'</td><td>'.$Group['Translated'].'</td><td>'.$Group['Total'].'</td><td>'.ProgressBar(150, $Group['Percent']).'</td></tr>';
        $Translated += $Group['Translated'];
        $Total += $Group['Total'];
      }
      if ($Total <> 0) $TotalCount = round($Translated / $Total * 100, 2);
      else $TotalCount = 0;
      $Output .= '<tr><td><strong>'.T('Total').'</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, $TotalCount).'</strong></td></tr>'.
        '</table>';
    }
    return $Output;
  }

  function Show(): string
  {
    $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
    $this->Title = T('Progress');
    $LanguageList = GetLanguageList();

    if (array_key_exists('Version', $_GET)) $_SESSION['StatVersion'] = $_GET['Version'];
    if (!array_key_exists('StatVersion', $_SESSION))
    {
      if ($User->Licence(LICENCE_USER) and ($User->PreferredVersionGame != ''))
      {
        $_SESSION['StatVersion'] = $User->PreferredVersionGame;
      } else 
      {
        $_SESSION['StatVersion'] = Core::Cast($this->System)->Config['Web']['GameVersion'];
      }
    }

    if (!isset($_SESSION['language']))
    {
      if ($User->Licence(LICENCE_USER))
      {
        $_SESSION['language'] = $User->Language;
      } else 
      {
        $_SESSION['language'] = '';
      }
    }
    if (array_key_exists('language', $_GET))
    {
      if ($_GET['language'] == '') {
        $_SESSION['language'] = '';
      } else 
      {
        $_SESSION['language'] = $_GET['language'] * 1;
      }
    }
    if (!array_key_exists($_SESSION['language'], $LanguageList)) $_SESSION['language'] = '';

    // Show client version selection
    $Output = T('Client version:').' ';
    $DbResult = $this->Database->query('SELECT `Version`, `Title` FROM `ClientVersion` WHERE `Imported`=1 ORDER BY `Version`');
    while ($DbRow = $DbResult->fetch_assoc())
    {
      $Output .= '<a href="?Version='.$DbRow['Version'].'" title="'.$DbRow['Title'].'">'.$DbRow['Version'].'</a> ';
    }
    $Output .= '<br/>';

    // Show language selection
    $Output .= T('Language:').' ';
    $Lang = '<a href="?language=">'.T('All').'</a>';
    if ($_SESSION['language'] == '') $Output .= '<strong>'.$Lang.'</strong> ';
      else $Output .= $Lang;
    foreach ($LanguageList as $Language)
    if ($Language['Enabled'] == 1)
    {
      $Lang = ' <a href="?language='.$Language['Id'].'">'.T($Language['Name']).'</a>';
      if ($Language['Id'] == $_SESSION['language']) $Output .= '<strong>'.$Lang.'</strong> ';
        else $Output .= $Lang;
    }

    if (is_numeric($_SESSION['language'])) $LanguageName = $LanguageList[$_SESSION['language']]['Name'];
      else $LanguageName = T('All');
    $Output .= '<br/><br/><h3>'.sprintf(T('Statistics of translation completion of language %s for version %s'), T($LanguageName), $_SESSION['StatVersion']).'</h3><br/>';
    $Output .= $this->ShowStatTable();

    return $Output;
  }
}