Changeset 398 for trunk/export/index.php

Timestamp:

Mar 19, 2010, 5:56:56 PM (15 years ago)

Author:

maron

Message:

U seznamu exportu zobrazení typu exportu a verze

File:

• trunk/export/index.php (modified) (2 diffs)

trunk/export/index.php

@@ -33 +33 @@
     array('Name' => 'UserName', 'Title' => 'Překladatel'), 
     array('Name' => 'Title', 'Title' => 'Označení'), 
+  //  array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'), 
+  //  array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'), 
+    array('Name' => 'OutputType', 'Title' => 'Typ výstupu'), 
+    array('Name' => 'ClientVersion', 'Title' => 'Verze klienta'), 
     array('Name' => 'UsedCount', 'Title' => 'Prohlédnutí výstupu'), 
-    array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'), 
-    array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'), 
     array('Name' => '', 'Title' => 'Akce'), 
   );  
@@ -42 +44 @@
   echo($Order['Output']);
 
-  $DbResult = $Database->SQLCommand('SELECT `User`.`Name` AS `UserName`, `Export`.*, (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 = $Database->SQLCommand('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']);
   while($Export = mysql_fetch_assoc($DbResult))
   {
-    $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'">Zobrazit</a> <a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=6">Exportovat</a>';
+    $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=0">Zobrazit</a> <a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=6">Exportovat</a>';
     if($Export['User'] == $User->Id) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\'Opravdu smazat položku?\');">Smazat</a>';
-    echo('<tr><td>'.HumanDate($Export['TimeCreate']).'</td><td>'.$Export['UserName'].'</td><td>'.$Export['Title'].'</td><td>'.$Export['UsedCount'].'</td><td>'.$Export['UserCount'].'</td><td>'.$Export['GroupCount'].'</td><td>'.$Action.'</td></tr>');
+    echo('<tr><td>'.HumanDate($Export['TimeCreate']).'</td><td>'.$Export['UserName'].'</td><td>'.$Export['Title'].'</td><td>'.$Export['OutputType'].'</td><td>'.$Export['ClientVersion'].'</td><td>'.$Export['UsedCount'].'</td><td>'.$Action.'</td></tr>');
   }
   echo('</table>');