source: trunk/img_statistic.php@ 286

<?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'].')';
} else $team = '';
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.')';
} else $user_sql = '';

$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));
$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);

$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;
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);
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); 
           
?>