Changeset 398


Ignore:
Timestamp:
Mar 19, 2010, 5:56:56 PM (15 years ago)
Author:
maron
Message:

U seznamu exportu zobrazení typu exportu a verze

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/export/index.php

    r376 r398  
    3333    array('Name' => 'UserName', 'Title' => 'Překladatel'),
    3434    array('Name' => 'Title', 'Title' => 'Označení'),
     35  //  array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'),
     36  //  array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'),
     37    array('Name' => 'OutputType', 'Title' => 'Typ výstupu'),
     38    array('Name' => 'ClientVersion', 'Title' => 'Verze klienta'),
    3539    array('Name' => 'UsedCount', 'Title' => 'Prohlédnutí výstupu'),
    36     array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'),
    37     array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'),
    3840    array('Name' => '', 'Title' => 'Akce'),
    3941  ); 
     
    4244  echo($Order['Output']);
    4345
    44   $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']);
     46  $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']);
    4547  while($Export = mysql_fetch_assoc($DbResult))
    4648  {
    47     $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'">Zobrazit</a> <a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=6">Exportovat</a>';
     49    $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>';
    4850    if($Export['User'] == $User->Id) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\'Opravdu smazat položku?\');">Smazat</a>';
    49     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>');
     51    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>');
    5052  }
    5153  echo('</table>');
Note: See TracChangeset for help on using the changeset viewer.