//days set
$days=$monthes[$month-1]['month_duration'];
$xtpl->assign("SECTION_NAME", "Statistics: Managers work for ".$monthes[$month-1]['month_name']." ".$year);
//user set
if ( (isset($_POST['user'])) and ($_POST['user'])!=0 )
{
$user=$_POST['user'];
//main part: get from db, replace and execute queries
$r=get_queries('answers_ud','closed_ud','complains_ud','comments_ud');
$r=replace_queries($r,array("#year#","#month#","#user#"),array($year,$month,$user));
$d=do_queries_d($r,$days);
//drawing diagrams
foreach ($d as $dn=>$dv)
{
$s='';
foreach ($r as $rk=>$rv )
{
if (isset($dv[$rv['q_html_title']]))
{
$title=$dv[$rv['q_html_title']];
$height=$title*2;
$xtpl->assign("TD_CONTENT",'<a href="stat_tickets.php?uname='.$users[$user].'&user='******'&day='.$dn.'&month='.$month.'&year='.$year.'&type='.$rv['q_html_title'].'">'.$dv[$rv['q_html_title']].'</a>');
}
else
{
$mquery="SELECT * FROM monthes";
$monthes=SQL_select($mquery);
$today=getdate();
//year set
if ( (isset($_POST['year'])) and ($_POST['year'])!=0 )
$year=$years[$_POST['year']];
else
$year=$today['year'];
$xtpl->assign("SECTION_NAME", "Statistics: Summary for ".$year." year");
//main part: get from db, replace and execute queries
$r=get_queries('answers_y','closed_y','new_y','complains_y','comments_y');
$r=replace_queries($r,array("#year#"),array($year));
$d=do_queries_d($r,12);
//drawing diagrams
foreach ($d as $dn=>$dv)
{
$s='';
foreach ($r as $rk=>$rv )
{
if (isset($dv[$rv['q_html_title']]))
{
$title=$dv[$rv['q_html_title']];
$height=$title/6;
$xtpl->assign("TD_CONTENT",$dv[$rv['q_html_title']]);
}
else
{
