source: trunk/img_statistic.php@ 577

<?php

$InitSystem = true;
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 = '';


$DbResult = $System->Database->query('SELECT MAX(`VersionEnd`) FROM '.$Group['TablePrefix']);
$ID = $DbResult->fetch_row();
$BuildNumber_max = $ID[0];
if($BuildNumber_max == '') $BuildNumber_max = 0; // Empty result, no items in this group

$where = '(`VersionEnd` = '.$BuildNumber_max.') AND (`Language` <> '.$Config['OriginalLanguage'].') AND (`Complete` = 1) '.$team.$language;
$DbResult = $System->Database->query('SELECT COUNT(DISTINCT(`Entry`)) FROM `'.$Group['TablePrefix'].'` WHERE '.$where);
$ID = $DbResult->fetch_row();
$NumberTranslate = $ID[0];
  
$DbResult = $System->Database->query('SELECT COUNT(DISTINCT(`Entry`)) FROM `'.$Group['TablePrefix'].'` WHERE (`VersionEnd` = '.$BuildNumber_max.') AND (`Language` = '.$Config['OriginalLanguage'].')');
$ID = $DbResult->fetch_row();
$NumberAJ = $ID[0];

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

$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);
$FontSize = 10;
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);