source: trunk/img_statistic.php@ 327

<?php

include('includes/global.php');

$Days = 14;
$FontFile = 'images/FRIZQT__.ttf';
$TranslationTree = GetTranslationTree();
$GroupId = LoadGroupIdParameter();
$Group = $TranslationTree[$GroupId];
if(array_key_exists('team', $_GET)) 
{
  $team = ' AND `User` IN (SELECT `ID` FROM `user` WHERE `team` = '.($_GET['team'] * 1).')';
} else $team = '';

if(array_key_exists('language', $_GET)) 
{
  $language = ' AND `Language` = '.$_GET['language'].'';
} else $language = '';


$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;
$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)'));
$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'].'%"'));
$NumberPerDay = $ID[0]; //date ("Y-m-d H:i:s")

if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; 
  else $Percent = 0;
$Percent = substr($Percent, 0, 5);

$Database->SQLCommand('UPDATE '.$Config['Database']['Database'].'.group SET BuffPercent = '.$Percent.' WHERE Id = '.$GroupId);


$PercentBar = $Percent * 4;
$NotTran = $NumberAJ - $NumberTranslate;

$Image = ImageCreateTrueColor(400, 32);
$Color1 = imagecolorallocate($Image, 214, 214, 214);
$Color2 = imagecolorallocate($Image, 239, 131, 166);
$Color3 = imagecolorallocate($Image, 225, 0, 0);
imagefilledrectangle($Image, 0, 0, 400, 31, $Color1);
imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
imagefilledrectangle($Image, 0, 0, 400, 0, $Color3);
imagefilledrectangle($Image, 0, 31, 0, 0, $Color3);
imagefilledrectangle($Image, 0, 31, 400, 31, $Color3);
$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']);
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'));

Header('Content-type: image/png'); 
ImagePNG($Image); 
ImageDestroy($Image); 
           
?>