<?php

include('includes/global.php');

$Days = 14;
$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'].')';
} 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 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); 
           
?>