Changeset 286 for trunk/img_statistic.php

Timestamp:

Dec 22, 2009, 10:22:38 AM (15 years ago)

Author:

george

Message:

• Opraveno: Kontrola správného zadání Id překladové skupiny.
• Opraveno: Kontrola správného zadání Id překladového jazyka.
• Upraveno: Zobrazovat PageFooter pouze pokud již byl zobrazen PageHeader.
• Opraveno: Chyba určení počtu stránek pro zobrazení stránkování.

File:

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

trunk/img_statistic.php

@@ -6 +6 @@
 $FontFile = 'images/FRIZQT__.ttf';
 $TranslationTree = GetTranslationTree();
-$Group = $TranslationTree[$_GET['group']];
-if (array_key_exists('team', $_GET)) {
-        $team = ' AND User IN (SELECT ID FROM user WHERE team = '.$_GET['team'].')';
+$GroupId = LoadGroupIdParameter();
+$Group = $TranslationTree[$GroupId];
+if(array_key_exists('team', $_GET)) 
+{
+  $team = ' AND `User` IN (SELECT `ID` FROM `user` WHERE `team` = '.$_GET['team'].')';
 } else $team = '';
-if (array_key_exists('language', $_GET)) {
-        $language = ' AND Language = '.$_GET['language'].'';
+if(array_key_exists('language', $_GET)) 
+{
+  $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.')';
+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 max(VersionEnd) FROM '.$Group['TablePrefix']));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT MAX(`VersionEnd`) FROM '.$Group['TablePrefix']));
 $BuildNumber_max = $ID[0];
 
-$where = 'VersionEnd = '.$BuildNumber_max.' AND (Language <> 0) AND (Complete = 1) '.$team.$language.$user_sql;
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE '.$where));
+$where = 'VersionEnd = '.$BuildNumber_max.' AND (`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];
   
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE VersionEnd = '.$BuildNumber_max.' AND (Language = 0)'));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(`entry`)) FROM '.$Group['TablePrefix'].' WHERE `VersionEnd` = '.$BuildNumber_max.' AND (`Language` = 0)'));
 $NumberAJ = $ID[0];
 
-$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM log WHERE Type = 1 AND date >= CURRENT_DATE - INTERVAL '.$Days.' DAY
- AND text LIKE "%'.$Group['Name'].'%"'));
+$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `log` WHERE `Type` = 1 AND `date` >= CURRENT_DATE - INTERVAL '.$Days.' DAY
+ AND `text` LIKE "%'.$Group['Name'].'%"'));
 $NumberPerDay = $ID[0]; //date ("Y-m-d H:i:s")
 
-if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; else $Percent = 0;
+if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; 
+  else $Percent = 0;
 $Percent = substr($Percent, 0, 5);
 
@@ -51 +56 @@
 imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
 $FontSize = 10;
-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(($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'] );
+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);
@@ -64 +71 @@
 ImageTTFText($Image, $FontSize, 0, 140, 29, $Color3, $FontFile, $Percent.'%');
 $FontSize = 6;
-ImageTTFText($Image, $FontSize, 0, 240, 28, $Color3, $FontFile, 'Aktualizace: '.date("m.d.y  H:i"));
+ImageTTFText($Image, $FontSize, 0, 240, 28, $Color3, $FontFile, 'Aktualizace: '.date('m.d.y  H:i'));
 
-Header("Content-type: image/png"); 
+Header('Content-type: image/png'); 
 ImagePNG($Image); 
 ImageDestroy($Image);