Changeset 402

Timestamp:

Mar 24, 2010, 7:59:47 AM (14 years ago)

Author:

george

Message:

• Odebráno: Zobrazování odhadu dokončení přeložení ve zobrzení stavu dokončení. Počítání odhadu podle textového sloupce v Logu je značně neefektivní.

Location:

trunk

Files:

• img_statistic.php (modified) (2 diffs)
• statistic.php (modified) (1 diff)

trunk/img_statistic.php

@@ -24 +24 @@
 if($BuildNumber_max == '') $BuildNumber_max = 0; // Empty result, no items in this group
 
-$where = 'VersionEnd = '.$BuildNumber_max.' AND (`Language` <> 0) AND (`Complete` = 1) '.$team.$language;
+$where = '(`VersionEnd` = '.$BuildNumber_max.') AND (`Language` <> 0) AND (`Complete` = 1) '.$team.$language;
 $ID = mysql_fetch_row($Database->SQLCommand('SELECT COUNT(DISTINCT(`Entry`)) FROM `'.$Group['TablePrefix'].'` WHERE '.$where));
 $NumberTranslate = $ID[0];
   
-$DbResult = $Database->SQLCommand('SELECT COUNT(DISTINCT(`Entry`)) FROM `'.$Group['TablePrefix'].'` WHERE `VersionEnd` = '.$BuildNumber_max.' AND (`Language` = 0)');
+$DbResult = $Database->SQLCommand('SELECT COUNT(DISTINCT(`Entry`)) FROM `'.$Group['TablePrefix'].'` WHERE (`VersionEnd` = '.$BuildNumber_max.') AND (`Language` = 0)');
 $ID = mysql_fetch_row($DbResult);
 $NumberAJ = $ID[0];
-
-$DbResult = $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($DbResult);
-$NumberPerDay = $ID[0]; //date ("Y-m-d H:i:s")
 
 if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; 
@@ -50 +46 @@
 imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
 $FontSize = 10;
-if(($NumberPerDay > 0) and ($team == '') and ($language == '') 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));
-}
 ImageTTFText($Image, $FontSize, 0, 140, 13, $Color3, $FontFile, $NumberTranslate.'/'.$NumberAJ);
 ImageTTFText($Image, $FontSize, 0, 240, 13, $Color3, $FontFile, $Group['Name']);

trunk/statistic.php

@@ -11 +11 @@
 echo('<strong>Statistika:</strong> <a href="statistic.php">Všechny</a>');
 foreach($LanguageList as $Language) 
-if($Language['Enabled'] == 1) echo(' <a href="?language='.$Language['Id'].'">'.$Language['Name'].'</a>');
+  if($Language['Enabled'] == 1) echo(' <a href="?language='.$Language['Id'].'">'.$Language['Name'].'</a>');
 
 
 foreach($TranslationTree as $Group)
   if($Group['TablePrefix'] != '') 
-  echo('<div class="state-image">
-  <img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?group='.$Group['Id'].$language.'" title="statistika překladů '.$Group['Name'].'"/></div>');
+    echo('<div class="state-image"><img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?group='.$Group['Id'].$language.'" title="Statistika překladů '.$Group['Name'].'"/></div>');
 
 echo('<p><strong>Celková statistika v závislosti na čase: </strong><a href="http://stat.zdechov.net/game/?Measure=18">Počet přeložených textů</a></p>