Changeset 217 for trunk/img_statistic.php

Timestamp:

Jun 25, 2009, 1:18:16 PM (16 years ago)

Author:

maron

Message:

Statistika vyberu uzivatele po exportu

File:

• trunk/img_statistic.php (modified) (2 diffs)

trunk/img_statistic.php

@@ -13 +13 @@
         $language = ' AND Language = '.$_GET['language'].'';
 } else $language = '';
+if (array_key_exists('user', $_GET)) {
+    $DbResult = $Database->SQLCommand('SELECT user,ExportSetting FROM `user` WHERE ID='.$_GET['user']);
+    $User = mysql_fetch_assoc($DbResult);
+        $ExportSetting = unserialize($User['ExportSetting']);
+        $SelectedUsers = ''; 
+    foreach($ExportSetting['users-selection'] as $Item)
+      $SelectedUsers .= ','.$Item;
+    $SelectedUsers = substr($SelectedUsers, 1);
+        $user_sql = ' AND User IN ('.$SelectedUsers.')';
+} else $user_sql = '';
 
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE (Language <> 0) AND (Complete = 1) '.$team.$language));
+$where = ' (Language <> 0) AND (Complete = 1) '.$team.$language.$user_sql;
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE '.$where));
 $NumberTranslate = $ID[0];
   
@@ -37 +48 @@
 imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
 $FontSize = 10;
-if (($NumberPerDay > 0) and ($team == '') and ($language == '') and ($NotTran>0)) {
+if (($NumberPerDay > 0) and ($team == '') and ($language == '') and ($user_sql == '') and ($NotTran>0)) {
         $TimeToTranslate = ($NotTran  / $NumberPerDay)* $Days;
         ImageTTFText($Image, $FontSize, 0, 5, 13, $Color3, $FontFile, 'Čas do dokončení');
         ImageTTFText($Image, $FontSize, 0, 5, 29, $Color3, $FontFile, getmonthyears($TimeToTranslate) );
+}
+if ($user_sql <> '') {
+        ImageTTFText($Image, $FontSize, 0, 5, 13, $Color3, $FontFile, 'Statistika výběru');
+        ImageTTFText($Image, $FontSize, 0, 5, 29, $Color3, $FontFile, 'uživatele: '.$User['user'] );
 }
 ImageTTFText($Image, $FontSize, 0, 140, 13, $Color3, $FontFile, $NumberTranslate.'/'.$NumberAJ);