Changeset 104

Timestamp:

Feb 18, 2009, 8:48:48 AM (16 years ago)

Author:

george

Message:

• Upraveno: Zobrazení všech překladů uživatele nahrazeno přehledovou tabulkou skupin a počtu překladů uživatele s možností dále rozkliknout všechny překlady uživatele v dané překladové skupině.

Location:

trunk

Files:

• TranslationList.php (modified) (4 diffs)
• style/style.css (modified) (5 diffs)

trunk/TranslationList.php

@@ -43 +43 @@
 }
 
-if($Action != 'userall') echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />');
+if($Action != 'userall')
+  echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />');
 
 function WritePages($Address, $Where)
@@ -91 +92 @@
   }
   
-  echo('<table border="1" cellpadding="2" cellspacing="0"><tr>
+  echo('<table class="BaseTable"><tr>
     <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=ID&amp;desc='.$desc.'">Pořadové číslo</a></th>
     <th><a href="?group='.$GroupId.'&amp;action='.$address.'&amp;order=entry&amp;desc='.$desc.'">Identifikační číslo</a></th>
@@ -185 +186 @@
 if($Action == 'userall') 
 {
-  $user = $_GET['user'];
-  echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
-        <strong>Vypsání všech textů od uživatele: </strong><br /><br />');
-  
-  $WhereUser = ' User = '.$user;
-  foreach($TranslationTree as $Group) {
-    if($Group['TablePrefix'] != '') {
-      $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Group['TablePrefix'].'.user) as User FROM '.$Group['TablePrefix'].' Where '.$WhereUser;
+  $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.$_GET['user']);
+  $Line = mysql_fetch_row($ID);
+  echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a>'.
+  ' -> <strong>Počty překladů uživatele '.$Line[0].': </strong><br /><br />');
+  
+  echo('<table class="BaseTable"><tr><th>Skupina</th><th>Překladů</th></tr>');
+  $Total = 0;
+  foreach($TranslationTree as $Group)
+    if($Group['TablePrefix'] != '')
+        {
+      $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE user='.$_GET['user'];
       $ID = $Database->SQLCommand($sql);
       $Line = mysql_fetch_row($ID);
-        if ($Line) { 
           $GroupId = $Group['Id'];
-          echo ('<br />Texty: <b>'.$Group['Name'].'</b>');
-          WriteQuests($sql, '', 'userall');
+          echo('<tr><td><a href="?group='.$GroupId.'&amp;action=userid&user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
+          $Total += $Line[0];
         }
-    }
-  }
+  echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td></tr>');
+  echo('</table>');
+}
+
+if($Action == 'userid') 
+{
+  $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.$_GET['user']);
+  $Line = mysql_fetch_row($ID);
+  echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
+        <strong>Vypis překladů uživatele '.$Line[0].': </strong><br /><br />');
+  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_GET['user'], '', 'userid');
 }
 
@@ -221 +233 @@
   WriteQuests($sql, '', 'search='.$Search);
 }        
-      
+     
 if($Action == 'searchentry') 
 {

trunk/style/style.css

@@ -1 @@
-body {
-font-size: 14px;
-font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
-color:#564b47;
-padding:0px;
-margin:0px;
-}
-a {color: #DB7093;}
-a:visited {color:#c43300;}
-a:hover {color: #c43300;}
-a:active { color:#000000;}
-
- /**********vertical menu***************/
-.verticalmenu ul{
+body
+{
+  font-size: 14px;
+  font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
+  color: #564b47;
+  padding: 0px;
+  margin: 0px;
+}
+
+a
+{
+  color: #DB7093;
+}
+
+a:visited
+{
+  color:#c43300;
+}
+
+a:hover
+{
+  color: #c43300;
+}
+
+a:active
+{
+  color:#000000;
+}
+
+.verticalmenu ul
+{
  list-style:none;
 /*list-style-image: url("bullet.gif")*/
-
-
  padding: 10px;
  margin: 0px;
 }
 
- .verticalmenu li, .verticalmenua {
+ .verticalmenu li, .verticalmenua
+ {
    display: block;
    font: bold 12px Verdana, Arial, Helvetica, sans-serif;
@@ -33 +49 @@
  }
 
- .verticalmenu a:hover{
-   background: url('../images/menuhover.gif') no-repeat;
-   color: #dc4d1b;
- }
-
-
-/* ----------banner for logo-------------- */
-#banner {
-height:75px;
-text-align: center;
-background:  url('../images/header3.jpg') repeat bottom;
-background-color: #ffffff;
-
-padding: 0px;
-margin: 0px;
-}
-#banner1 {
-width: 75px;
-background:  url('../images/header1.jpg') no-repeat left;
-}
-#banner2 {
-width: 75px;
-background:  url('../images/header2.jpg') no-repeat top right;
-}
-#banner img {padding:10px 0px;} 
-#bannertitle{ font-size:24px;font-weight:bold; }
-#bannertable {
+.verticalmenu a:hover
+{
+  background: url('../images/menuhover.gif') no-repeat;
+  color: #dc4d1b;
+}
+
+#banner
+{
+  height:75px;
+  text-align: center;
+  background: url('../images/header3.jpg') repeat bottom;
+  background-color: #ffffff;
+  padding: 0px;
+  margin: 0px;
+}
+
+#banner1
+{
+  width: 75px;
+  background:  url('../images/header1.jpg') no-repeat left;
+}
+
+#banner2
+{
+  width: 75px;
+  background:  url('../images/header2.jpg') no-repeat top right;
+}
+
+#banner img
+{
+  padding: 10px 0px;
+}
+
+#bannertitle
+{
+  font-size:24px;
+  font-weight:bold;
+}
+
+#bannertable
+{
   padding: 0px;
   margin: 0px; 
@@ -65 +95 @@
   width: 100%;
 }
-/***********okraje**************/
-#border-left {
-width: 14px;
-background:  url('../images/border-left.jpg') repeat top right;
-}
-#border-top {
-width: 14px;
-background:  url('../images/border-top.jpg') repeat top right;
-}
-
-/***************Porovnávání textu**********/
-#edit {
-background-color: #DB7093;
+
+#border-left
+{
+  width: 14px;
+  background: url('../images/border-left.jpg') repeat top right;
+}
+
+#border-top
+{
+  width: 14px;
+  background: url('../images/border-top.jpg') repeat top right;
+}
+
+#edit
+{
+  background-color: #DB7093;
 }
 
@@ -93 +126 @@
   background-color: #F0F0F0;
 
-
-margin-left: auto;
-margin-right: auto;
-background: #E8E8E8 url('../images/menubottom.jpg') no-repeat bottom right;
+  margin-left: auto;
+  margin-right: auto;
+  background: #E8E8E8 url('../images/menubottom.jpg') no-repeat bottom right;
 }
 
@@ -212 +244 @@
   padding-left: 10px;
 }
-
- /**************** form *******************/
- input, select {
-   background-color: #E8E8E8;
-   border: 1px #c43300 solid;
-   font-size: 11px;
-   font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
- }
- textarea {
-   background-color: white;
-   border: 1px #c43300 solid;
-   font-size: 11px;
-   font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
- }
- 
- 
+ 
+input, select
+{
+  background-color: #E8E8E8;
+  border: 1px #c43300 solid;
+  font-size: 11px;
+  font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
+}
+ 
+textarea
+{
+  background-color: white;
+  border: 1px #c43300 solid;
+  font-size: 11px;
+  font-family: Verdana, Arial, SunSans-Regular, Sans-Serif;
+}
+ 
+