function pie_single_mailbox_user()
{
$tpl = new Templates();
$USER_STORAGE_USAGE = $_GET["USER_STORAGE_USAGE"];
$USER_STORAGE_LIMIT = $_GET["STORAGE_LIMIT"];
$FREE = $_GET["FREE"];
writelogs("USER_STORAGE_USAGE={$USER_STORAGE_USAGE}", __FUNCTION__, __FILE__);
writelogs("STORAGE_LIMIT={$USER_STORAGE_LIMIT}", __FUNCTION__, __FILE__);
if ($USER_STORAGE_LIMIT == null) {
$USER_STORAGE_LIMIT = 1000000;
$USER_STORAGE_USAGE = 0;
$FREE = $USER_STORAGE_LIMIT;
}
$USER_STORAGE_RESTANT = $USER_STORAGE_LIMIT - $USER_STORAGE_USAGE;
if ($USER_STORAGE_RESTANT > 1) {
$reste = round($USER_STORAGE_RESTANT / 1024);
$data = array($USER_STORAGE_USAGE, $USER_STORAGE_RESTANT);
} else {
$data = array($USER_STORAGE_USAGE);
}
$title = $tpl->_ENGINE_parse_body("{your mailbox usage}\n ({$reste} mb free)");
writelogs("USER_STORAGE_USAGE={$USER_STORAGE_USAGE} - USER_STORAGE_LIMIT={$USER_STORAGE_LIMIT} FREE={$FREE}", __FUNCTION__, __FILE__);
$date = date('Y-m-d');
$textes = array();
$donnees = array();
$zlabel = array();
$date = date('Y-m-d');
$textes[] = 'title';
$donnees[] = '';
$donnees[] = $FREE;
$textes[] = "Free";
$donnees[] = $USER_STORAGE_USAGE;
$textes[] = "used";
BuildPieChart(array($textes, $donnees));
}
function build_statistics(){
$today=date('Y-m-d');
$yesterday=date("Y-m-d",mktime(0,0,0,date("m") ,date("d")-1,date("Y")));
$mysql=new mysql();
$query_aliases=query_aliases();
$search_pattern=$_GET["search"];
if(!isset($_GET["section"])){$_GET["section"]='today';}
switch ($_GET["section"]) {
case "today":$todate="AND DATE_FORMAT(`quarantine`.zDate,'%Y-%m-%d')='$today'";break;
case "yesterday";$todate="AND DATE_FORMAT(`quarantine`.zDate,'%Y-%m-%d')='$yesterday'";break;
case "week";
$todate="AND WEEK(`quarantine`.zDate)=WEEK(NOW())";
$date_plus=",DATE_FORMAT(`quarantine`.zDate,'%W') AS WeekDay";
break;
default:$todate="AND DATE_FORMAT(`quarantine`.zDate,'%Y-%m-%d')='$today'";break;
}
if(isset($_GET["datas"])){
$field="`mailfrom_domain`,`mailfrom`";
$addp="AND mailfrom_domain='{$_GET["datas"]}'";
}else{
$field="`mailfrom_domain`";
}
$sql="SELECT COUNT(*) as tcount, $field FROM quarantine,storage_recipients WHERE
`quarantine`.MessageID=storage_recipients.MessageID $todate
AND (".query_aliases().")
$addp
$search_patternq GROUP BY $field ORDER BY tcount DESC LIMIT 0,10";
$results=$mysql->QUERY_SQL($sql,'artica_backup');
$textes[]='title';
$donnees[]='';
while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){
if(isset($ligne["mailfrom"])){
$textes[]=$ligne["mailfrom"];
}else{
$textes[]=$ligne["mailfrom_domain"];
}
$donnees[]=$ligne["tcount"];
}
$page=CurrentPageName();
unset($_GET["QuaratinePie"]);
while (list ($num, $val) = each ($_GET) ){
$datas=$datas. "&$num=$val";
}
$links=array("url"=>"javascript:LoadAjax('content_q','$page?main=stats$datas',_category_)","target"=>"javascript");
//javascript:display_info( _col_, _row_, _value_, _category_, _series_, 'Hello World!' )" target='javascript'
include_once(dirname(__FILE__).'/listener.graphs.php');
BuildPieChart(array($textes,$donnees),$links);
}
