| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/cp-admin/ |
Upload File : |
<?php
include_once('includes/header.php');
$id_volet ="54";
include('includes/volet.php');
/****************************/
// Get Month and Year
$time=time();
if (is_numeric($_GET["m"]) AND $_GET["m"] >= 1 AND $_GET["m"] <= 12 ) {$show_month = $_GET["m"];}
else {$show_month=date("n",$time);}
if (is_numeric($_GET["y"]) AND $_GET["y"] >= 1 AND $_GET["y"] <= 9999 ) {$show_year = $_GET["y"];}
else {$show_year=date("Y",$time);}
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>
Statistique - Historique
</h1>
</div>
</div>
</div>
<div class="row">
<div class="middle">
<h3>Historique</h3>
<?PHP
setlocale(LC_TIME, 'fr_FR.utf8','fra');
// Gesamt Besucher ermitteln
$abfrage=$bdd->query("SELECT sum(user) as sumUsers, sum(view) as sumViews, min(day) as minDay, avg(user) as avgUser from stats_day");
$result = $abfrage->fetch();
$visitors=$result['sumUsers'];
$visits=$result['sumViews'];
$since=$result['minDay'];
$since=str_replace(".", "-", $since);
$since=strtotime($since);
$since=strftime("%d %B %Y", $since);
$total_avg=round($result['avgUser'],2);
?>
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr valign="top">
<td colspan="4"><strong>Depuis le <?PHP echo $since;?></strong></td>
</tr>
<tr valign="top">
<td width="30%">Visiteurs</td><td width="20%"><?PHP echo $visitors; ?></td>
<td width="30%">Visites</td><td width="20%"><?PHP echo $visits; ?></td>
</tr>
<tr valign="top">
<td width="30%">Ø Jour</td><td width="20%"><?PHP echo $total_avg; ?></td>
<td width="30%"> </td><td width="20%"> </td>
</tr>
</table>
<br />
<?PHP
// selected Moth
$sel_timestamp = mktime(0, 0, 0, $show_month, 1, $show_year);
$sel_month = date("Y-m%",$sel_timestamp);
$abfrage=$bdd->query("SELECT sum(user) as sumUsers, sum(view) as sumViews, avg(user) as avgUser from stats_day where day LIKE '$sel_month'");
$result = $abfrage->fetch();
$visitors=$result['sumUsers'];
$visits=$result['sumViews'];
$day_avg=round($result['avgUser'],2);
?>
<table width="100%" border="0" cellpadding="5" cellspacing="0">
<tr valign="top">
<td colspan="4"><strong>Mois de <?PHP echo strftime("%B %Y",mktime(0, 0, 0, $show_month, 1, $show_year)); ?></strong></td>
</tr>
<tr valign="top">
<td>Visiteurs</td><td><?PHP echo $visitors; ?></td><td>Visites</td><td><?PHP echo $visits; ?></td>
</tr>
<tr valign="top">
<td>Ø Jour</td><td><?PHP echo $day_avg; ?></td><td> </td><td> </td>
</tr>
</table>
</div>
<div class="middle">
<h3>
<?PHP
echo "Année ".date("Y",mktime(0, 0, 0, $show_month, 1, $show_year));
$back_month=date("n",mktime(0, 0, 0, $show_month, 1, $show_year-1));
$back_yaer=date("Y",mktime(0, 0, 0, $show_month, 1, $show_year-1));
$next_month=date("n",mktime(0, 0, 0, $show_month, 1, $show_year+1));
$next_yaer=date("Y",mktime(0, 0, 0, $show_month, 1, $show_year+1));
echo "<span><a href=\"stats_history.php?m=$back_month&y=$back_yaer\"><</a> <a href=\"stats_history.php?m=$next_month&y=$next_yaer\">></a></span>";
?>
</h3>
<table height="200" width="100%" cellpadding="0" cellspacing="0" align="right">
<tr valign="bottom" height="180">
<?PHP
// Max Month
$abfrage=$bdd->query("SELECT LEFT(day,7) as month, sum(user) as user_month from stats_day GROUP BY month ORDER BY user_month DESC LIMIT 1");
$result = $abfrage->fetch();
$max_month=$result['user_month'];
// Monat abfragen
$bar_nr=0;
for($month=1; $month<=12; $month++)
{
$sel_timestamp = mktime(0, 0, 0, $month, 1, $show_year);
$sel_month = date("Y-m%",$sel_timestamp);
$abfrage=$bdd->query("SELECT sum(user) as sumUsers from stats_day where day LIKE '$sel_month'");
$result = $abfrage->fetch();
$User=$result['sumUsers'];
$bar[$bar_nr]=$User; // Im Array Speichern
$bar_title[$bar_nr] = strftime("%B %Y",$sel_timestamp);
$bar_month[$bar_nr]=$month;
$bar_nr++;
}
// Diagramm
for($i=0; $i<$bar_nr; $i++)
{
$value=$bar[$i];
if ($value == "") $value = 0;
if ($max_month > 0) {$bar_hight=round((170/$max_month)*$value);} else $bar_hight = 0;
if ($bar_hight == 0) $bar_hight = 1;
echo "<td width=\"38\">";
echo "<a href=\"stats_history.php?m=".$bar_month[$i]."&y=$show_year\">";
echo "<div class=\"bar\" style=\"height:".$bar_hight."px;\" title=\"".$bar_title[$i]." - $value Visiteur(s)\"></div>";
echo "</a></td>\n";
}
?>
</tr><tr height="20">
<td colspan="3" width="25%" class="timeline"><?PHP echo strftime("%b %Y",mktime(0, 0, 0, 1, 1, $show_year)); ?></td>
<td colspan="3" width="25%" class="timeline"><?PHP echo strftime("%b %Y",mktime(0, 0, 0, 4, 1, $show_year)); ?></td>
<td colspan="3" width="25%" class="timeline"><?PHP echo strftime("%b %Y",mktime(0, 0, 0, 7, 1, $show_year)); ?></td>
<td colspan="3" width="25%" class="timeline"><?PHP echo strftime("%b %Y",mktime(0, 0, 0, 10, 1, $show_year)); ?></td>
</tr></table>
</div>
<div style="clear:both"></div>
<div class="full">
<h3>
<?PHP
echo strftime("%B %Y",mktime(0, 0, 0, $show_month, 1, $show_year));
$back_month=date("n",mktime(0, 0, 0, $show_month-1, 1, $show_year));
$back_yaer=date("Y",mktime(0, 0, 0, $show_month-1, 1, $show_year));
$next_month=date("n",mktime(0, 0, 0, $show_month+1, 1, $show_year));
$next_yaer=date("Y",mktime(0, 0, 0, $show_month+1, 1, $show_year));
echo "<span><a href=\"stats_history.php?m=$back_month&y=$back_yaer\"><</a> <a href=\"stats_history.php?m=$next_month&y=$next_yaer\">></a></span>";
?>
</h3>
<table height="230" width="100%" cellpadding="0" cellspacing="0" align="right">
<tr valign="bottom" height="210">
<?PHP
// Ausgewählten Monat anzeigen
$bar_nr=0;
$month_days=date(t,mktime(0,0,0,$show_month,1,$show_year));
for($day=1; $day<=$month_days; $day++)
{
$sel_timestamp = mktime(0, 0, 0, $show_month, $day, $show_year);
$sel_tag = date("Ymd",$sel_timestamp);
$abfrage=$bdd->query("SELECT sum(user) as sumUsers from stats_day where day='$sel_tag'");
$result = $abfrage->fetch();
$User=$result['sumUsers'];
$bar[$bar_nr]=$User; // Im Array Speichern
$bar_title[$bar_nr] = strftime("%d %B %Y",$sel_timestamp);
if (date("j")-$day == 1) $bar_mark = $bar_nr;
if ( date("w", $sel_timestamp) == 6 OR date("w", $sel_timestamp)== 0) {$weekend[$bar_nr]=true;}
else {$weekend[$bar_nr]=false;}
$bar_nr++;
}
// Diagramm
for($i=0; $i<$bar_nr; $i++)
{
$value=$bar[$i];
if ($value == "") $value = 0;
if (max($bar) > 0) {$bar_hight=round((200/max($bar))*$value);} else $bar_hight = 0;
if ($bar_hight == 0) $bar_hight = 1;
echo "<td width=\"30\">";
echo "<div class=\"bar\" style=\"height:".$bar_hight."px;\" title=\"".$bar_title[$i]." - $value Visiteur(s)\"></div></td>\n";
}
?>
</tr><tr height="20">
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, $show_month, 1, $show_yaer)); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, $show_month, 7, $show_yaer)); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, $show_month, 13, $show_yaer)); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, $show_month, 19, $show_yaer)); ?></td>
<td colspan="7" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, $show_month, 25, $show_yaer)); ?></td>
</tr></table>
</div>
<div style="clear:both"></div>
</div>
</div>
<?php
include_once('includes/footer.php');
?>