$page=CurrentPageName();

$tpl=new templates();

$title=$tpl->_ENGINE_parse_body("{day}»»{member}»»{$_GET["user"]}");

$html="YahooWin4('890','$page?tabs=yes&user={$_GET["user"]}&field={$_GET["field"]}&table={$_GET["table"]}','$title')";

echo $html;

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$titleW="{day}";

$t=time();

$websites=$tpl->_ENGINE_parse_body("{websites}");

$size=$tpl->_ENGINE_parse_body("{size}");

$hitsTitl=$tpl->_ENGINE_parse_body("{hits}");

if(preg_match("#^[0-9]+#", $_GET["table"])){

$timeT=$q->TIME_FROM_HOUR_TABLE( $_GET["table"]);

$DayTime=date("Y {l} {F} d",$timeT);

}

$TITLE_PAGE="{$_GET["field"]}:{$_GET["user"]} $titleW";

if($_GET["field"]=="MAC"){

$userText=$q->UID_FROM_MAC($_GET["user"]);

if($userText<>null){

$TITLE_PAGE="$userText ({$_GET["user"]})";

}

}

$html="

<table class='events-table-$t' style='display: none' id='events-table-$t' style='width:99%'></table>

<script>

$(document).ready(function(){

$('#events-table-$t').flexigrid({

url: '$page?websites-search=yes&user={$_GET["user"]}&field={$_GET["field"]}&table={$_GET["table"]}',

dataType: 'json',

colModel : [

{display: '$hitsTitl', name : 'hits', width :160, sortable : false, align: 'left'},

{display: '$size', name : 'size', width :184, sortable : true, align: 'left'},

{display: '$websites', name : 'sitename', width :425, sortable : true, align: 'left'},

],

searchitems : [

{display: '$websites', name : 'sitename'},

],

sortname: 'hits',

sortorder: 'desc',

usepager: true,

title: '<span style=font-size:16px>$titleW $DayTime $TITLE_PAGE</span>',

useRp: true,

rp: 50,

showTableToggleBtn: false,

width: 833,

height: 503,

singleSelect: true

});

});

</script>";

echo $tpl->_ENGINE_parse_body($html);

$tpl=new templates();

$MyPage=CurrentPageName();

$q=new mysql_squid_builder();

$page=1;

$search='%';

$table=$_GET["table"];

$field=$_GET["field"];

if($q->COUNT_ROWS($table)==0){json_error_show("No data");}

if(isset($_POST["sortname"])){if($_POST["sortname"]<>null){$ORDER="ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";}}

if(isset($_POST['page'])) {$page = $_POST['page'];}

$searchstring=string_to_flexquery();

if($searchstring<>null){

$sql="SELECT SUM(hits) as hits,SUM(size) as size,`sitename`,`$field`

FROM $table GROUP BY `sitename`,`$field` HAVING `$field`='{$_GET["user"]}' $searchstring";

$results=$q->QUERY_SQL($sql,"artica_events");

$total = mysql_num_rows($results);

}else{

$sql="SELECT SUM(hits) as hits,SUM(size) as size,`sitename`,`$field`

FROM $table GROUP BY `sitename`,`$field`

HAVING `$field`='{$_GET["user"]}'";

$results=$q->QUERY_SQL($sql,"artica_events");

$total = mysql_num_rows($results);

}

if (isset($_POST['rp'])) {$rp = $_POST['rp'];}

$pageStart = ($page-1)*$rp;

$limitSql = "LIMIT $pageStart, $rp";

$sql="SELECT SUM(hits) as hits,SUM(size) as size,`sitename`,`$field`

FROM $table GROUP BY `sitename`,`$field` HAVING `$field`='{$_GET["user"]}' $searchstring $ORDER $limitSql";

writelogs($sql,__FUNCTION__,__FILE__,__LINE__);

$results = $q->QUERY_SQL($sql,"artica_events");

$data = array();

$data['page'] = $page;

$data['total'] = $total;

$data['rows'] = array();

if(!$q->ok){json_error_show($q->mysql_error);}

$span="<span style='font-size:16px'>";

$spanoff="</span>";

if(mysql_num_rows($results)==0){

$sql=wordwrap($sql,80,"<br>");

$data['rows'][] = array('id' => $ligne[time()],'cell' => array($sql,"", "",""));}

while ($ligne = mysql_fetch_assoc($results)) {

$ligne["size"]=FormatBytes($ligne["size"]/1024);

$data['rows'][] = array(

'id' => $ligne['client'],

'cell' => array($span.XUFormatNumber($ligne["hits"]).$spanoff,$span.$ligne["size"].$spanoff,$span.$ligne["sitename"].$spanoff)

);

}

echo json_encode($data);

$tmp1 = round((float) $number, $decimals);

while (($tmp2 = preg_replace('/(\d+)(\d\d\d)/', '\1 \2', $tmp1)) != $tmp1)

$tmp1 = $tmp2;

return strtr($tmp1, array(' ' => $thousand_separator, '.' => $decimal_point));

$tpl=new templates();

$page=CurrentPageName();

$id=md5("user={$_GET["user"]}&field={$_GET["field"]}&table={$_GET["table"]}");

$array["popup"]=$tpl->_ENGINE_parse_body('{status}');

$array["visited"]=$tpl->_ENGINE_parse_body('{visited_websites}');

while (list ($num, $ligne) = each ($array) ){

$html[]= "<li><a href=\"$page?$num=yes&user={$_GET["user"]}&field={$_GET["field"]}&table={$_GET["table"]}\"><span style='font-size:14px'>$ligne</span></a></li>\n";

}

echo "<div id='$id' style='width:100%;'>

<ul>". implode("\n",$html)."</ul>

</div>

<script>

$(document).ready(function(){

$('#$id').tabs();

});

</script>" ;

$t=time();

$table=$_GET["table"];

$page=CurrentPageName();

$tpl=new templates();

$html="

<div id='member-$t-list'></div>

<script>

function DayMembersSearch(){

var search='';

LoadAjaxTiny('member-$t-list','$page?users-search=yes&table=$table&user={$_GET["user"]}&field={$_GET["field"]}&query='+search);

}

DayMembersSearch();

</script>";

echo $tpl->_ENGINE_parse_body($html);

$page=CurrentPageName();

$tpl=new templates();

$t=time();

$html="

<table style='width:101%;margin-left:-15px;margin-right:-15px'>

<tbody>

<tr>

<td valign='top' width=1%><div id='week-search-users-list'></div></td>

<td valign='top' width=99%>

<div id='$t'></div>

</td>

</tr>

</tbody>

</table>

<script>

function RefreshStatsUser(user,field,table){

if(!table){table='{$_GET["table"]}';}

if(!user){user='{$_GET["user"]}';}

if(!field){field='{$_GET["field"]}';}

LoadAjax('$t','$page?display-synthesis=yes&user='+user+'&field='+field+'&table='+table+'&divkey=$t');

}

RefreshStatsUser();

</script>

";

echo $tpl->_ENGINE_parse_body($html);

$table=$_GET["table"];

$user=$_GET["user"];

$field=$_GET["field"];

$page=CurrentPageName();

$tpl=new templates();

$html="

<script>

function LoadUserReport1(){

LoadAjaxTiny('paragraphe1','$page?paragraphe1=yes&table=$table&user=$user&field=$field');

}

function LoadUserReport2(){

LoadAjaxTiny('paragraphe2','$page?paragraphe2=yes&table=$table&user=$user&field=$field');

}

LoadUserReport1();

</script>

";

echo $tpl->_ENGINE_parse_body($html);

$table=$_GET["table"];

$user=$_GET["user"];

$field=$_GET["field"];

$page=CurrentPageName();

$tpl=new templates();

$q=new mysql_squid_builder();

$t=time();

$sql="SELECT SUM(hits) as thits,SUM(size) as tsize,category FROM(SELECT $table.hits,$table.size,$table.category,

webfilters_categories_caches.master_category FROM webfilters_categories_caches,$table

WHERE webfilters_categories_caches.categorykey=$table.category

AND $table.`$field`='$user'

) as t

GROUP BY category ORDER BY tsize DESC LIMIT 0,1";

$ligne2=mysql_fetch_array($q->QUERY_SQL($sql));

$p0=$tpl->_ENGINE_parse_body("{top_visited_categories_mostwieght}");

$p0=str_replace("X", "<strong>".$ligne2["category"]."</strong>", $p0);

$p0=str_replace("Y", "<strong>".FormatBytes($ligne2["tsize"]/1024)."</strong>", $p0);

$p0="<div style='color:#CF1717;margin-top:5px;font-size:12px'>$p0</div>";

$sql="SELECT SUM(hits) as thits,SUM(size) as tsize,category FROM(SELECT $table.hits,$table.size,$table.category,

webfilters_categories_caches.master_category FROM webfilters_categories_caches,$table

WHERE webfilters_categories_caches.categorykey=$table.category

AND $table.`$field`='$user'

) as t

GROUP BY category ORDER BY thits DESC LIMIT 0,10";

$results=$q->QUERY_SQL($sql);

if(!$q->ok){echo "<H4>$q->mysql_error</H4>";}

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

if($ligne["category"]==null){continue;}

$ligne["tsize"]=FormatBytes($ligne["tsize"]/1024);

$ydata[]="{$ligne["category"]}";

$xdata[]=$ligne["thits"];

$PIEDATA["{$ligne["category"]}"]=$ligne["thits"];

$rows[]="<tr>

<td width=1%><img src='img/20-categories-personnal.png'></td>

<td><strong style='font-size:12px'>

<a href=\"javascript:blur();\"

OnClick=\"javascript:Loadjs('squid.traffic.week.user.category.php?category={$ligne["category"]}&table=$table&field=$field&user=$user');\"

style='font-size:12px;text-decoration:underline;font-weight:bold'>

{$ligne["category"]}</a> ({$ligne["thits"]} {hits} - {$ligne["tsize"]})</strong></td></tr>";

}

$arrayHREF=urlencode(base64_encode(serialize($PIEDATA)));

//$gp->PieLegendHide=true;

//$gp->x_title=$tpl->_ENGINE_parse_body("{cache}");

$html="<div style='color:#CF1717;font-weight:bold;margin-top:5px;font-size:13.5px'>{top_visited_categories} :</div>$p0

<table style='width:100%'>

<tbody>

". @implode("\n", $rows)."

</tbody>

</table>

<div style='margin-top:10px;width:400px;height:250px;' id='graph-$t'><center><img src='img/wait_verybig_mini_red.gif'></center></div>

<script>

Loadjs('$page?paragraphe2-category-graph=yes&container=graph-$t&data=$arrayHREF');

</script>

";

echo $tpl->_ENGINE_parse_body($html);

$PieData=unserialize(base64_decode($_GET["data"]));

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->PieDatas=$PieData;

$highcharts->ChartType="pie";

$highcharts->PiePlotTitle="{hits}";

$highcharts->Title="{top_categories}";

echo $highcharts->BuildChart();

$table=$_GET["table"];

$user=$_GET["user"];

$field=$_GET["field"];

$page=CurrentPageName();

$tpl=new templates();

$q=new mysql_squid_builder();

$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT SUM(size) as tsize FROM $table"));

$downloadedINT=$ligne["tsize"];

$sql="SELECT SUM(size) as tsize FROM $table WHERE `$field`='$user' AND cached=1";

$ligne=mysql_fetch_array($q->QUERY_SQL($sql));

$X3_bin=$ligne["tsize"];

$X3_text="<strong>".FormatBytes($X3_bin/1024)."</strong>";

$ligne2=mysql_fetch_array($q->QUERY_SQL("SELECT SUM(size) as tsize FROM $table WHERE `$field`='$user'"));

$X1_bin=$ligne2["tsize"];

$X1_text="<strong>".FormatBytes($X1_bin/1024)."</strong>";

$PRC=(($X3_bin/$X1_bin)*100);

$PRC=round($PRC,3);

$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT SUM(hits) as tsize FROM $table WHERE `$field`='$user'"));

if(!$q->ok){echo "<H4>$q->mysql_error line ".__LINE__."</H4>";}

$X2_bin=$ligne["tsize"];

$X2_text="<strong>$X2_bin</strong>";

$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT COUNT(familysite) as familysite,`$field` FROM $table WHERE `$field`='$user'"));

if(!$q->ok){echo "<H4>$q->mysql_error line ".__LINE__."</H4>";}

$X0_bin=$ligne["familysite"];

$X0_text="<strong>$X0_bin</strong>";

$webstatsUserIntro1=$tpl->_ENGINE_parse_body("{webstatsUserIntro1}");

$webstatsUserIntro1=str_replace("X3PRC", "<strong style='color:#CF1717'>$PRC%</strong>", $webstatsUserIntro1);

$webstatsUserIntro1=str_replace("X0", $X0_text, $webstatsUserIntro1);

$webstatsUserIntro1=str_replace("X1", $X1_text, $webstatsUserIntro1);

$webstatsUserIntro1=str_replace("X2", $X2_text, $webstatsUserIntro1);

$webstatsUserIntro1=str_replace("X3", $X3_text, $webstatsUserIntro1);

$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT SUM(size) as tsize,familysite,`$field` FROM $table GROUP BY familysite,`$field` HAVING `$field`='$user' ORDER BY tsize DESC LIMIT 0,1"));

if(!$q->ok){echo "<H4>$q->mysql_error line ".__LINE__."</H4>";}

$XXWWWS=$ligne["familysite"];

$XWSZE=FormatBytes($ligne["tsize"]/1024);

$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT SUM(hits) as tsize,familysite,`$field` FROM $table GROUP BY familysite,`$field` HAVING `$field`='$user' ORDER BY tsize DESC LIMIT 0,1"));

if(!$q->ok){echo "<H4>$q->mysql_error line ".__LINE__."</H4>";}

$XXWWWR=$ligne["familysite"];

$XWSZR=$ligne["tsize"];

$XWSCAT=familysite_MergeCategories(array($XXWWWS,$XXWWWR));

$line=$tpl->_ENGINE_parse_body("{phrase_the_most_websites}");

$line=str_replace("XXWWWS", "<strong>$XXWWWS</strong>", $line);

$line=str_replace("XWSZE", "<strong>$XWSZE</strong>", $line);

$line=str_replace("XXWWWR", "<strong>$XXWWWR</strong>", $line);

$line=str_replace("XWSZR", "<strong>$XWSZR</strong>", $line);

$line=str_replace("XWSCAT", "<strong>$XWSCAT</strong>", $line);

$webstatsUserIntro2="<div style='font-size:12px;text-align:justify'>$line</div>";

//*********************************************************************** GRAPHIQUE PAR JOUR

$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT `hour`,SUM(hits) as thits,SUM(size) as tsize,`$field`

FROM $table GROUP BY `hour`,`$field` HAVING `$field`='$user' ORDER BY thits DESC LIMIT 0,1"));

if(!$q->ok){echo $q->mysql_error;}

$MostActiveHourNum=$ligne["hour"];

$MostActiveDaySize=FormatBytes($ligne["tsize"]/1024);

if(strlen($MostActiveHourNum)==1){$MostActiveHourNum="0$MostActiveHourNum";}

$title="{$MostActiveHourNum}:00 {phrase_most_day_activehour} {for} $user";

$prc=round($ligne["tsize"]/$downloadedINT,2)*100;

$webstatsUserIntro3="<div style='color:#CF1717;font-weight:bold;margin-top:5px;font-size:13.5px'>$title</div>

<div style='font-size:12px;text-align:justify;'>{with} <strong>{$ligne["thits"]} {hits}</strong> {or} <strong>$MostActiveDaySize</strong> {it_represents} <strong>$prc%</strong> {of_bandwith}</div>

<div style='font-size:12px;text-align:justify;margin-top:10px;margin-bottom:15px'>{phrase_thisisthegraph1}:</div>";

$sql="SELECT `hour`,SUM(hits) as thits,`$field` FROM $table GROUP BY `hour`,`$field` HAVING `$field`='$user' ORDER BY `hour`";

$results=$q->QUERY_SQL($sql);

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

$xdata[]=$ligne["hour"];

$ydata[]=$ligne["thits"];

}

$time=time();

$arrayHREF=urlencode(base64_encode(serialize(array($xdata,$ydata))));

$t=time();

$graph1="<div style='margin-top:10px;width:400px;height:250px;' id='graph2-$t'><center><img src='img/wait_verybig_mini_red.gif'></center></div>

<script>

</script> ";

$HTML="<p style='font-size:12px'>$webstatsUserIntro1</p>

<p style='font-size:12px'>$webstatsUserIntro2</p>

$webstatsUserIntro3

$graph1

<script>

Loadjs('$page?paragraphe1-day-graph=yes&container=graph2-$t&data=$arrayHREF');

LoadUserReport2()</script>

";

echo $tpl->_ENGINE_parse_body($HTML);

$AR=unserialize(base64_decode($_GET["data"]));

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->xAxis=$AR[0];

$highcharts->Title="{hits}/{hours}";

$highcharts->yAxisTtitle="{hits}";

$highcharts->xAxisTtitle="{hours}";

$highcharts->datas=array("{hits}"=>$AR[1]);

echo $highcharts->BuildChart();

$page=CurrentPageName();

$tpl=new templates();

$q=new mysql_squid_builder();

$table=$_GET["table"];

$user=$_GET["user"];

$field=$_GET["field"];

$t=$_GET["divkey"];

$year=substr($table,0,4);

$month=substr($table,4, 2);

$day=substr($table,6, 2);

$time=strtotime("$year-$month-$day 00:00:00");

$dayTitle=date('{l}, {F} Y',$time);

$TITLE_PAGE="&laquo;$user&raquo; ({{$field}}) <br>$dayTitle";

if($field=="MAC"){

$userText=$q->UID_FROM_MAC($user);

if($userText<>null){

$TITLE_PAGE="$userText ({$user}) <br>$dayTitle";

}

}

$html="

<table style='width:99%' class=form>

<tbody>

<tr>

<td width=1%><img src='img/postmaster-48.png'></td>

<td><div style='width:100%;font-size:16px;font-weight:bold'>$TITLE_PAGE</div></td>

</tr>

</tbody>

</table>

<table style='width:100%'>

<tbody>

<tr>

<td width=50% valign='top'><div id='paragraphe1'></div></td>

<td width=50% valign='top'><div id='paragraphe2'></div></td>

</tr>

</tbody>

</table>

<script>

function LoadUserSearchSection(){

if(!document.getElementById('week-search-users-list')){alert('week-search-users-list no such id');}

LoadAjaxTiny('week-search-users-list','$page?users-form=yes&table=$table&user=$user&field=$field');

}

LoadUserSearchSection();

</script>

";

echo $tpl->_ENGINE_parse_body($html);

$q=new mysql_squid_builder();

$tpl=new templates();

$catz=array();

while (list ($index, $familysite) = each ($array) ){

$sql="SELECT category FROM visited_sites WHERE familysite='$familysite'";

$results=$q->QUERY_SQL($sql);

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

if(strpos($ligne["category"], ",")>0){

$as=explode(",", $ligne["category"]);

while (list ($a, $b) = each ($as) ){$catz[$b]=$b;}

continue;

}

$catz[$ligne["category"]]=$ligne["category"];

}

}

while (list ($a, $b) = each ($catz) ){if($b==null){continue;}$c[]=$b;}

if(count($c)==0){$c[]="{unknown}";}

$cats=texttooltip(": ".count($c)." {categories}",@implode(",<br>", $c),null,null,0,"font-size:12px;nodiv");

return $tpl->_ENGINE_parse_body($cats);

}