Changeset 728 for trunk/Modules/User/Profile.php

Timestamp:

Jan 7, 2014, 10:17:46 PM (11 years ago)

Author:

chronos

Message:

• Added: More client version value on pages as clickable link.

File:

• trunk/Modules/User/Profile.php (modified) (4 diffs)

trunk/Modules/User/Profile.php

@@ -50 +50 @@
                                 $Order['Output'];
         
-                $DbResult = $this->System->Database->query('SELECT `User`.`Name` AS `UserName`, `Export`.`Id`, `Export`.`TimeCreate`, `Export`.`Title`, `Export`.`User`, `Export`.`UsedCount`, (SELECT Version FROM `ClientVersion` WHERE `ClientVersion`.`Id`=`Export`.`ClientVersion`) AS `ClientVersion`,(SELECT Name FROM `ExportOutputType` WHERE `ExportOutputType`.`Id`=`Export`.`OutputType`) AS `OutputType`, (SELECT COUNT(*) FROM `ExportGroup` WHERE `ExportGroup`.`Export`=`Export`.`Id`) AS `GroupCount`, (SELECT COUNT(*) FROM `ExportUser` WHERE `ExportUser`.`Export`=`Export`.`Id`) AS `UserCount` FROM `Export` LEFT JOIN `User` ON `User`.`ID`=`Export`.`User` '.$Filter.$Order['SQL'].$PageList['SQLLimit']);
+                $DbResult = $this->System->Database->query('SELECT `User`.`Name` AS `UserName`, `Export`.`Id`, `Export`.`TimeCreate`, `Export`.`Title`, `Export`.`User`, `Export`.`UsedCount`, `Export`.`ClientVersion` AS `ClientVersionId`, '.
+      '(SELECT Version FROM `ClientVersion` WHERE `ClientVersion`.`Id`=`Export`.`ClientVersion`) AS `ClientVersion`, '.
+      '(SELECT Name FROM `ExportOutputType` WHERE `ExportOutputType`.`Id`=`Export`.`OutputType`) AS `OutputType`, '.
+      '(SELECT COUNT(*) FROM `ExportGroup` WHERE `ExportGroup`.`Export`=`Export`.`Id`) AS `GroupCount`, '.
+      '(SELECT COUNT(*) FROM `ExportUser` WHERE `ExportUser`.`Export`=`Export`.`Id`) AS `UserCount` FROM `Export` '.
+      'LEFT JOIN `User` ON `User`.`ID`=`Export`.`User` '.$Filter.$Order['SQL'].$PageList['SQLLimit']);
                 while($Export = $DbResult->fetch_assoc())
                 {
@@ -60 +65 @@
                                 '<td>'.$Export['Title'].'</td>'.
                                 '<td>'.$Export['OutputType'].'</td>'.
-                                '<td>'.$Export['ClientVersion'].'</td>'.
+                                '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.$Export['ClientVersionId']).'">'.$Export['ClientVersion'].'</a></td>'.
                                 '<td>'.$Export['UsedCount'].'</td>'.
                           '<td>'.$Action.'</td></tr>';
@@ -116 +121 @@
                 $Output = '';
                 $Query = 'SELECT `User`.`Name`, `UserTrace`.`LastLogin`, `UserTrace`.`LastIP`, '.
-                                '`User`.`Email`, `UserTrace`.`UserAgent`, '.
+                                '`User`.`Email`, `UserTrace`.`UserAgent`, `User`.`PreferredVersion`, '.
                                 '`User`.`TranslatedCount`, `User`.`Team`, `User`.`ID`, `User`.`Info`, '.
                                 '`Team`.`Name` AS `TeamName`, `Language`.`Name` AS `LanguageName`, '.
@@ -133 +138 @@
                 '<h3>Překladatel '.$UserLine['Name'].'</h3>'.
                 'Výchozí jazyk: <strong>'.$UserLine['LanguageName'].'</strong><br />'.
-                'Výchozí verze klienta: <strong>'.$UserLine['Version'].'</strong><br />'.
+                'Výchozí verze klienta: <a href="'.$this->System->Link('/client-version/?action=item&amp;id='.$UserLine['PreferredVersion']).'"><strong>'.$UserLine['Version'].'</strong></a><br />'.
                 'Poslední připojení: <strong>'.HumanDateTime($UserLine['LastLogin']).'</strong><br />'.
                 'Počet přeložených: <a href="TranslationList.php?user='.$UserLine['ID'].'&amp;state=2&group=0" title="Zobrazit Všechny jeho přeložené texty"><strong>'.$UserLine['TranslatedCount'].'</strong></a><br />';