Changeset 880 for trunk/Modules/Translation/TranslationList.php

Timestamp:

Apr 7, 2020, 10:15:48 PM (4 years ago)

Author:

chronos

Message:

• Modified: Improved code formatting.

File:

• trunk/Modules/Translation/TranslationList.php (modified) (31 diffs)

trunk/Modules/Translation/TranslationList.php

@@ -47 +47 @@
     );
     foreach ($StateTypes as $index => $StateType) {
-      if($Filter['State'] == $index) $Selected = ' selected="selected"';
+      if ($Filter['State'] == $index) $Selected = ' selected="selected"';
       else $Selected = '';
       $Output .= '<option value="'.$index.'"'.$Selected.'>'.$StateType.'</option>';
@@ -54 +54 @@
 
     // Translation group
-    if($GroupId == 0)
+    if ($GroupId == 0)
     {
       $Filter['Group'] = GetParameter('group', 0, true, true);
-      if($Filter['Group'] != 0)
+      if ($Filter['Group'] != 0)
       {
-        if(isset($TranslationTree[$Filter['Group']]) == false)
+        if (isset($TranslationTree[$Filter['Group']]) == false)
           ErrorMessage('Překladová skupina dle zadaného Id neexistuje.');
         $Table = $TranslationTree[$Filter['Group']]['TablePrefix'];
@@ -70 +70 @@
 
     $Output .= '<td><select name="group" style="width: 80px">';
-    if($Filter['Group'] == 0) $Selected = ' selected="selected"';
+    if ($Filter['Group'] == 0) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
     $DbResult = $this->Database->query('SELECT `Id`,`Name` FROM `Group`');
-    while($Group = $DbResult->fetch_assoc())
+    while ($Group = $DbResult->fetch_assoc())
       $Groups[T($Group['Name'])] = $Group;
     ksort($Groups);
-    foreach($Groups as $Group)
-    {
-      if($Group['Id'] == $Filter['Group']) $Selected = ' selected="selected"';
+    foreach ($Groups as $Group)
+    {
+      if ($Group['Id'] == $Filter['Group']) $Selected = ' selected="selected"';
       else $Selected = '';
       $Output .= '<option value="'.$Group['Id'].'"'.$Selected.'>'.T($Group['Name']).'</option>';
@@ -89 +89 @@
     else
       $Filter['Version'] = GetParameter('version', 0, true, true);
-    if($Filter['Version'] != 0)
+    if ($Filter['Version'] != 0)
     {
       $DbResult = $this->Database->query('SELECT `Id`, `BuildNumber`,`Version` FROM `ClientVersion` WHERE (`Imported` = 1) AND (`Id` ='.$Filter['Version'].')');
-      if($DbResult->num_rows > 0)
+      if ($DbResult->num_rows > 0)
       {
         $DbRow = $DbResult->fetch_assoc();
@@ -99 +99 @@
     }
     $Output .= '<td><select name="version">';
-    if($Filter['Version'] == 0) $Selected = ' selected="selected"';
+    if ($Filter['Version'] == 0) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
     $DbResult = $this->Database->query('SELECT `Id`, `BuildNumber`,`Version` FROM `ClientVersion` WHERE `Imported` = 1 ORDER BY `BuildNumber` DESC');
-    while($Version = $DbResult->fetch_assoc())
-    {
-      if($Version['Id'] == $Filter['Version']) $Selected = ' selected="selected"';
+    while ($Version = $DbResult->fetch_assoc())
+    {
+      if ($Version['Id'] == $Filter['Version']) $Selected = ' selected="selected"';
       else $Selected = '';
       $Output .= '<option value="'.$Version['Id'].'"'.$Selected.'>'.$Version['Version'].'</option>';
     }
     $Output .= '</select></td>';
-    if($Filter['Version'] != 0) $VersionFilter = ' AND (`VersionStart` <= '.$Filter['BuildNumber'].') AND (`VersionEnd` >= '.$Filter['BuildNumber'].')';
+    if ($Filter['Version'] != 0) $VersionFilter = ' AND (`VersionStart` <= '.$Filter['BuildNumber'].') AND (`VersionEnd` >= '.$Filter['BuildNumber'].')';
     else $VersionFilter = '';
     //else $Filter['SQL'] .= ' AND '; DISTINCT(Entry)
@@ -117 +117 @@
     $Filter['Language'] = GetParameter('lang', 0, true, true);
     $Output .= '<td><select name="lang">';
-    if($Filter['Language'] == 0) $Selected = ' selected="selected"';
+    if ($Filter['Language'] == 0) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
     $DbResult = $this->Database->query('SELECT `Id`, `Name` FROM `Language` WHERE `Enabled` = 1 ORDER BY `Name`');
-    while($Language = $DbResult->fetch_assoc())
-    {
-      if($Language['Id'] == $Filter['Language']) $Selected = ' selected="selected"';
+    while ($Language = $DbResult->fetch_assoc())
+    {
+      if ($Language['Id'] == $Filter['Language']) $Selected = ' selected="selected"';
       else $Selected = '';
       $Output .= '<option value="'.$Language['Id'].'"'.$Selected.'>'.T($Language['Name']).'</option>';
@@ -130 +130 @@
     $LanguageFilter = '';
     $LanguageFilterSub = '';
-    if($Filter['Language'] != 0) {
+    if ($Filter['Language'] != 0) {
       $LanguageFilter = ' AND (`T`.`Language` = '.$Filter['Language'].')';
       $LanguageFilterSub = ' AND (`Sub`.`Language` = '.$Filter['Language'].')';
@@ -138 +138 @@
     $Filter['User'] = GetParameter('user', 0, true, true);
     $Output .= '<td><select name="user" style="width: 80px">';
-    if($Filter['User'] == 0) $Selected = ' selected="selected"';
+    if ($Filter['User'] == 0) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
     $DbResult = $this->Database->query('SELECT `Id`, `Name` FROM `User` ORDER BY `Name`');
-    while($User = $DbResult->fetch_assoc())
-    {
-      if($User['Id'] == $Filter['User']) $Selected = ' selected="selected"';
+    while ($User = $DbResult->fetch_assoc())
+    {
+      if ($User['Id'] == $Filter['User']) $Selected = ' selected="selected"';
       else $Selected = '';
       $Output .= '<option value="'.$User['Id'].'"'.$Selected.'>'.$User['Name'].'</option>';
     }
     $Output .= '</select></td>';
-    if($Filter['User'] != 0) $UserFilter = ' AND (`User` = '.$Filter['User'].')';
+    if ($Filter['User'] != 0) $UserFilter = ' AND (`User` = '.$Filter['User'].')';
     else $UserFilter = '';
 
@@ -155 +155 @@
     $Filter['Text'] = GetParameter('text', '', false, true);
     $Output .= '<td><input name="text" type="text" style="width: 60px;" value="'.htmlentities($Filter['Text']).'"></td>';
-    if($Filter['Text'] != '')
+    if ($Filter['Text'] != '')
     {
       $Items = array('(`T`.`ID` LIKE "%'.$Filter['Text'].'%")', '(`T`.`Entry` LIKE "%'.$Filter['Text'].'%")');
-      if($Filter['Group'] != 0)
-        foreach($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
-        if($GroupItem['Visible'] == 1)
+      if ($Filter['Group'] != 0)
+        foreach ($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
+        if ($GroupItem['Visible'] == 1)
         $Items[] = '(`T`.`'.$GroupItem['Column'].'` LIKE "%'.$Filter['Text'].'%")';
       $Filter['SQL'] .= ' AND ('.implode(' OR ', $Items).')';
@@ -168 +168 @@
     $Filter['Entry'] = GetParameter('entry', '', false, true);
     $Output .= '<td><input name="entry" type="text" style="width: 60px;" value="'.htmlentities($Filter['Entry']).'"></td>';
-    if($Filter['Entry'] != '')
+    if ($Filter['Entry'] != '')
     {
       $Filter['SQL'] .= ' AND (`Entry` = "'.$Filter['Entry'].'")';
     }
 
-    if($Filter['Group'] != 0)
+    if ($Filter['Group'] != 0)
     {
         $WithoutAlter =       ' AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE '.
@@ -179 +179 @@
           ' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`ID` != `T`.`ID`) AND (`Sub`.`Complete` = 1) AND '.
           '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`) LIMIT 1 ) ';
-        foreach($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
-          if($GroupItem['Visible'] == 1) {
+        foreach ($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
+          if ($GroupItem['Visible'] == 1) {
             $ItemsVar[] =    'LENGTH(`T`.`'.$GroupItem['Column'].'`) - LENGTH( REPLACE( `T`.`'.$GroupItem['Column'].'`,  \'$\',  \'\' ) ) '.
                            ' < ('.
@@ -188 +188 @@
                               ')';
           }
-      if($Filter['State'] == CompletionState::All) {
+      if ($Filter['State'] == CompletionState::All) {
         $Filter['SQL'] .= $UserFilter.$VersionFilter;
       } else
-      if($Filter['State'] == CompletionState::NotTranslated) {
+      if ($Filter['State'] == CompletionState::NotTranslated) {
         $Filter['SQL'] .= $VersionFilter.' AND (`T`.`Language` = '.$this->System->Config['OriginalLanguage'].') '.
           'AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE '.
@@ -198 +198 @@
           '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`))';
       } else
-      if($Filter['State'] == CompletionState::Translated) {
+      if ($Filter['State'] == CompletionState::Translated) {
         $Filter['SQL'] .= $UserFilter.$LanguageFilter.$VersionFilter.' AND (`T`.`Complete` = 1)';
       } else
-      if($Filter['State'] == CompletionState::NotFinished) {
+      if ($Filter['State'] == CompletionState::NotFinished) {
         $Filter['SQL'] .= $UserFilter.$LanguageFilter.$VersionFilter.' AND (`T`.`Language` != '.$this->System->Config['OriginalLanguage'].
       ') AND (`T`.`Complete` = 0)';
       } else
-      if($Filter['State'] == CompletionState::Original) {
+      if ($Filter['State'] == CompletionState::Original) {
         $Filter['SQL'] .= $VersionFilter.' AND (`T`.`Language` = '.$this->System->Config['OriginalLanguage'].')';
       } else
-      if($Filter['State'] == CompletionState::NotFinishedNotTranslated) {
+      if ($Filter['State'] == CompletionState::NotFinishedNotTranslated) {
         $Filter['SQL'] .= $UserFilter.$VersionFilter.$WithoutAlter.
       ' AND (`T`.`Language` != '.$this->System->Config['OriginalLanguage'].
       ') AND (`T`.`Complete` = 0)';
       } else
-      if($Filter['State'] == CompletionState::Missing1) {
+      if ($Filter['State'] == CompletionState::Missing1) {
         $Filter['SQL'] .= $UserFilter.$VersionFilter.' AND (`T`.`Complete` = 1) AND `T`.`Language` != '.$this->System->Config['OriginalLanguage'];
         $Filter['SQL'] .= ' AND ('.implode(' OR ', $ItemsVar).') ';
       } else
-      if($Filter['State'] == CompletionState::Missing2) {
+      if ($Filter['State'] == CompletionState::Missing2) {
         $Filter['SQL'] .= $UserFilter.$VersionFilter.' AND (`T`.`Complete` = 1) AND `T`.`Language` != '.$this->System->Config['OriginalLanguage'];
         $Filter['SQL'] .= ' '. $WithoutAlter;
@@ -226 +226 @@
     /*
      // Ownership
-    if(array_key_exists('owner', $_GET) and is_numeric($_GET['owner'])) $Filter['Owner'] = $_GET['owner'];
+    if (array_key_exists('owner', $_GET) and is_numeric($_GET['owner'])) $Filter['Owner'] = $_GET['owner'];
     else $Filter['Owner'] = 0;
     $Output .= ' <td><select name="owner">';
-    if($Filter['Owner'] == 0) $Selected = ' selected="selected"';
+    if ($Filter['Owner'] == 0) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="0"'.$Selected.'>Všech</option>';
-    if($Filter['Owner'] == 1) $Selected = ' selected="selected"';
+    if ($Filter['Owner'] == 1) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="1"'.$Selected.'>Překladatelův tým</option>';
-    if($Filter['Owner'] == 2) $Selected = ' selected="selected"';
+    if ($Filter['Owner'] == 2) $Selected = ' selected="selected"';
     else $Selected = '';
     $Output .= '<option value="2"'.$Selected.'>Překladatele</option>';
     $Output .= '</select></td>';
-    if(($Filter['Owner'] == 2) AND ($Filter['User'] != 0)) $Filter['SQL'] .= ' AND (`User` = '.$Filter['User'].')';
+    if (($Filter['Owner'] == 2) AND ($Filter['User'] != 0)) $Filter['SQL'] .= ' AND (`User` = '.$Filter['User'].')';
     */
 
@@ -246 +246 @@
     $Output .= '</form><br/>';
     $Filter['Output'] = $Output;
-    return($Filter);
+    return $Filter;
   }
 
@@ -289 +289 @@
 
     $DbResult = $this->Database->query($Query.' '.$Order['SQL'].' '.$PageList['SQLLimit']);
-    while($Line = $DbResult->fetch_assoc())
+    while ($Line = $DbResult->fetch_assoc())
     {
       $Output .= '<tr><td><a href="'.$this->System->Link('/form.php?group='.$Filter['Group'].'&amp;ID='.$Line['ID']).'">'.$Line['ID'].'</a></td>'.
@@ -305 +305 @@
     $Output .= '</table>'.
         $PageList['Output'];
-    return($Output);
+    return $Output;
   }
 
@@ -316 +316 @@
     $Output .= '<table class="BaseTable"><tr><th>'.T('Group').'</th><th>'.T('Count').'</th></tr>';
     $Total = 0;
-    foreach($TranslationTree as $Group)
-      if($Group['TablePrefix'] != '')
+    foreach ($TranslationTree as $Group)
+      if ($Group['TablePrefix'] != '')
       {
         $Filter = $this->ShowFilter($Group['Id']);
@@ -328 +328 @@
       $Output .= '<tr><td><strong>'.T('Total').'</strong></td><td><strong>'.$Total.'</strong></td></tr>'.
           '</table>';
-      return($Output);
+      return $Output;
   }
 
@@ -336 +336 @@
 
     $GroupId = GetParameter('group', 0, true);
-    if($GroupId == 0) $Output = ShowMessage('Skupina nenalezena', MESSAGE_CRITICAL);
+    if ($GroupId == 0) $Output = ShowMessage('Skupina nenalezena', MESSAGE_CRITICAL);
     else {
       $Table = $TranslationTree[$GroupId]['TablePrefix'];
@@ -351 +351 @@
           '<td>'.T('Texts marked as unfinished').'</td></tr>';
 
-      if($this->System->User->Licence(LICENCE_USER))
+      if ($this->System->User->Licence(LICENCE_USER))
       {
         $Output .= '<tr><td><a title="'.T('Unfinished texts').'" href="?group='.$GroupId.'&amp;state=3&amp;user='.$this->System->User->Id.'">'.T('My unfinished').'</a></td>
@@ -373 +373 @@
       $Output .= '</table>';
     }
-    return($Output);
+    return $Output;
   }
 
@@ -380 +380 @@
     $this->Title = T('Translation groups');
     $Action = GetParameter('action', '');
-    if($Action == 'filter') $Output = $this->ShowMenu();
+    if ($Action == 'filter') $Output = $this->ShowMenu();
     else
     {
       $Filter = $this->ShowFilter();
-      if($Filter['Group'] > 0) $Output = $this->ShowTranslationList($Filter);
+      if ($Filter['Group'] > 0) $Output = $this->ShowTranslationList($Filter);
         else $Output = $this->ShowGroupList($Filter);
     }
-    return($Output);
+    return $Output;
   }
 }
@@ -409 +409 @@
       array('Name' => 'LastVersion', 'Title' => T('Version of last import')),
    );
-   if($this->System->User->Licence(LICENCE_ADMIN))
+   if ($this->System->User->Licence(LICENCE_ADMIN))
    $TableColumns[] = array('Name' => '', 'Title' => T('Actions'));
 
@@ -416 +416 @@
 
    $DbResult = $this->Database->query('SELECT * FROM `Group`'.$Order['SQL'].$PageList['SQLLimit']);
-   while($Group = $DbResult->fetch_assoc())
+   while ($Group = $DbResult->fetch_assoc())
    {
      $Output .= '<tr><td><a href="'.$this->System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;action=filter').'">'.T($Group['Name']).'</a></td>'.
        '<td>'.$Group['SourceType'].'</td><td>';
-     if($Group['MangosTable'] != '') $Output .= $Group['MangosTable'].'.sql ';
-     if($Group['DBCFileName'] != '') $Output .= $Group['DBCFileName'].'.dbc ';
-     if($Group['LuaFileName'] != '') $Output .= $Group['LuaFileName'].'.lua ';
+     if ($Group['MangosTable'] != '') $Output .= $Group['MangosTable'].'.sql ';
+     if ($Group['DBCFileName'] != '') $Output .= $Group['DBCFileName'].'.dbc ';
+     if ($Group['LuaFileName'] != '') $Output .= $Group['LuaFileName'].'.lua ';
      $Output .= '</td>';
-     if($this->System->User->Licence(LICENCE_ADMIN))
+     if ($this->System->User->Licence(LICENCE_ADMIN))
        $Output .= '<td><a title="Změny po posledním importu u vybrané překladové skupiny" href="'.$this->System->Link('/log/?group='.
      $Group['Id'].'&amp;type=11').'">'.HumanDate($Group['LastImport']).'</a></td>';
@@ -430 +430 @@
      $Output .= '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.
        GetVersionWOWId($Group['LastVersion'])).'">'.GetVersionWOW($Group['LastVersion']).'</a></td>';
-     if($this->System->User->Licence(LICENCE_ADMIN))
+     if ($this->System->User->Licence(LICENCE_ADMIN))
        $Output .= '<td><a href="?action=groupdelete&amp;id='.$Group['Id'].'">'.T('Remove').'</a></td>';
      $Output .= '</tr>';
@@ -436 +436 @@
     $Output .= '</table>'.
       '<br /><a title="'.T('Changelog of changes after import').'" href="'.$this->System->Link('/log/?type=11').'">'.T('Changelog of text modification during import').'</a><br/>';
-    if($this->System->User->Licence(LICENCE_ADMIN)) $Output .= '<a href="?action=groupadd">'.T('Add translation group').'</a>';
-    return($Output);
+    if ($this->System->User->Licence(LICENCE_ADMIN)) $Output .= '<a href="?action=groupadd">'.T('Add translation group').'</a>';
+    return $Output;
   }
 
   function ShowGroupAdd()
   {
-    if($this->System->User->Licence(LICENCE_ADMIN))
+    if ($this->System->User->Licence(LICENCE_ADMIN))
     {
       $Output = '<h3>Vložení nové překladové skupiny</h3>'.
@@ -452 +452 @@
           '</table></form>';
     } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-    return($Output);
+    return $Output;
   }
 
   function ShowGroupAddFinish()
   {
-    if($this->System->User->Licence(LICENCE_ADMIN))
+    if ($this->System->User->Licence(LICENCE_ADMIN))
     {
       $TableName = 'Text'.$_POST['TablePrefix'];
       $DbResult = $this->System->Database->select('Group', 'Id', 'TablePrefix="'.$TableName.'"');
-      if($DbResult->num_rows == 0)
+      if ($DbResult->num_rows == 0)
       {
 
@@ -500 +500 @@
       $Output .= $this->ShowList();
     } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-    return($Output);
+    return $Output;
   }
 
   function ShowGroupDelete()
   {
-    if($this->System->User->Licence(LICENCE_ADMIN))
+    if ($this->System->User->Licence(LICENCE_ADMIN))
     {
       $DbResult = $this->System->Database->select('Group', '*', '`Id`='.$_GET['id']);
-      if($DbResult->num_rows == 1)
+      if ($DbResult->num_rows == 1)
       {
         $Group = $DbResult->fetch_assoc();
@@ -518 +518 @@
     } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
     $Output .= $this->ShowList();
-    return($Output);
+    return $Output;
   }
 
@@ -525 +525 @@
     $this->Title = T('Translation groups');
     $Action = GetParameter('action', '');
-    if($Action == 'groupadd') $Output = $this->ShowGroupAdd();
-    else if($Action == 'groupdelete') $Output = $this->ShowGroupDelete();
-    else if($Action == 'groupaddfinish') $Output = $this->ShowGroupAddFinish();
+    if ($Action == 'groupadd') $Output = $this->ShowGroupAdd();
+    else if ($Action == 'groupdelete') $Output = $this->ShowGroupDelete();
+    else if ($Action == 'groupaddfinish') $Output = $this->ShowGroupAddFinish();
     else $Output = $this->ShowList();
-    return($Output);
+    return $Output;
   }
 }