| 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/ODLDDD_2/cp-admin/ |
Upload File : |
<?PHP
include_once('includes/header.php');
$id_volet ="52";
include('includes/volet.php');
/****************************/
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>
Statistique - Résumé
</h1>
</div>
</div>
</div>
<div class="row">
<div class="middle">
<h3>Résumé</h3>
<table width="100%" border="0" cellpadding="5" cellspacing="0" class="oneview">
<tr valign="top">
<?PHP
// Gesamt Besucher ermitteln
$abfrage = $GLOBALS['bdd']->query("SELECT SUM(user) AS sumUsers, SUM(view) AS sumViews FROM stats_day");
$result = $abfrage->fetch();
$visitors = $result['sumUsers'];
$visits = $result['sumViews'];
echo "<td width=\"30%\">Visiteurs</td><td width=\"20%\">$visitors</td>\n";
echo "<td width=\"30%\">Pages visitées</td><td width=\"20%\">$visits</td>\n";
?>
</tr>
<tr valign="top">
<?PHP
// Online
$time = time();
$isonline=$time-(3*60); // 3 Minuten Online Zeit
$abfrage=$bdd->query("SELECT count(id) as num from stats_ips where online>='$isonline'");
$result = $abfrage->fetch();
$online=$result['num'];
echo "<td>En ligne</td><td>$online</td>\n";
echo "<td> </td><td> </td>\n";
?>
</tr>
<tr valign="top">
<td> </td><td> </td><td> </td><td> </td>
</tr>
<tr valign="top">
<?PHP
// Bounce
$abfrage=$bdd->query("SELECT count(id) as num from stats_ips");
$result = $abfrage->fetch();
$total=$result['num'];
$abfrage=$bdd->query("SELECT count(id) as num from stats_ips where online=time");
$result = $abfrage->fetch();
$onepage=$result['num'];
echo "<td>Taux de Rebond</td><td>".round(($onepage/$total)*100,2)."%</td>\n";
// Page/User and 7 days averange
$from_day=date("Ymd",$time -(7*24*60*60));
$to_day=date("Ymd",$time - (24*60*60)); // <= ohne heute
$abfrage=$bdd->query("SELECT AVG(user) as avgUsers, (SUM(view)/SUM(user)) as ratio FROM stats_day WHERE day>='$from_day' AND day<='$to_day'");
$result = $abfrage->fetch();
$avg_7=round($result['avgUsers'],2);
$page_user=round($result['ratio'],1);
echo "<td>Page/Vis. 7 derniers jours</td><td>$page_user</td>\n";
?>
<tr valign="top">
<?PHP
echo'<br />';
echo" <td>Ø 7 derniers jours</td>\n";
echo" <td>$avg_7</td>\n";
// 30 days averange
$from_day=date("Ymd",$time -(30*24*60*60));
$to_day=date("Ymd",$time - (24*60*60)); // <= ohne heute
$abfrage=$bdd->query("SELECT AVG(user) as avgUsers from stats_day where day>='$from_day' AND day<='$to_day'");
$result = $abfrage->fetch();
$avg_30=round($result['avgUsers'],2);
echo" <td>Ø 30 derniers jours</td>\n";
echo" <td>$avg_30</td>\n";
?>
</tr>
<tr valign="top">
<?PHP
// Gesamt User Heute
$sel_timestamp = mktime(0, 0, 0, date("n"), date("j"), date("Y"));
$sel_tag = date("Ymd",$sel_timestamp);
$abfrage=$bdd->query("SELECT sum(user) as sumUsers from stats_day where day='$sel_tag'");
$result = $abfrage->fetch();
$today=$result['sumUsers'];
if ($today=="") $today=0;
echo "<td>Aujourd'hui</td><td>$today</td>\n";
// gestern zur gleichen Zeit
$anfangTag = mktime(0, 0, 0, date(n), date(j), date(Y)) - 24*60*60 ;
$endeTag = $time - 24*60*60 ;
$abfrage=$bdd->query("SELECT count(id) as num from stats_ips where time>='$anfangTag' AND time<=$endeTag");
$result = $abfrage->fetch();
$yesterday=$result['num'];
echo "<td>Hier (".date("G:i",$time).")</td><td>$yesterday</td>\n";
?>
</tr>
</table>
</div>
<div class="middle">
<h3>Dernière 24 Heures </h3>
<table height="200" width="100%" cellpadding="0" cellspacing="0" align="right">
<tr valign="bottom" height="180">
<?PHP
// User der letzten 24 Stunden abfragen
$bar_nr=0;
$bar_mark="";
for($Stunde=23; $Stunde>=0; $Stunde--)
{
$anfangStunde = mktime(date("H")-$Stunde, 0, 0, date("n"), date("j"), date("Y")) ;
$endeStunde = mktime(date("H")-$Stunde, 59, 59, date("n"), date("j"), date("Y")) ;
$abfrage=$bdd->query("SELECT count(id) as num from stats_ips where time>='$anfangStunde' AND time<=$endeStunde");
$result = $abfrage->fetch();
$User=$result['num'];
// Diagramm vorbereiten, Array erstellen
$bar[$bar_nr] = $User;
$bar_title[$bar_nr] = date("G:i",$anfangStunde)." - ".date("G:i",$endeStunde);
if (date("H")-$Stunde == 0) $bar_mark = $bar_nr;
$bar_nr++;
}
// Diagramm
for($i=0; $i<$bar_nr; $i++)
{
$value=$bar[$i];
if ($value == "") $value = 0;
if (max($bar) > 0) {$bar_hight=round((170/max($bar))*$value);} else $bar_hight = 0;
if ($bar_hight == 0) $bar_hight = 1;
if ($bar_mark == "$i" ) { echo "<td style=\"border-left: #FF0000 1px dotted;\" width=\"19\">";}
else echo "<td width=\"19\">";
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" width="25%" class="timeline"><?PHP echo date("G:i",mktime(date("H")-23, 0, 0, date("n"), date("j"), date("Y"))); ?></td>
<td colspan="6" width="25%" class="timeline"><?PHP echo date("G:i",mktime(date("H")-17, 0, 0, date("n"), date("j"), date("Y"))); ?></td>
<td colspan="6" width="25%" class="timeline"><?PHP echo date("G:i",mktime(date("H")-11, 0, 0, date("n"), date("j"), date("Y"))); ?></td>
<td colspan="6" width="25%" class="timeline"><?PHP echo date("G:i",mktime(date("H")-5, 0, 0, date("n"), date("j"), date("Y"))); ?></td>
</tr></table>
</div>
<div style="clear:both"></div>
<div class="full">
<h3>30 Derniers Jours </h3>
<table height="230" width="100%" cellpadding="0" cellspacing="0" align="right">
<tr valign="bottom" height="210">
<?PHP
setlocale(LC_TIME, 'fr_FR.utf8','fra');
// User der letzten 30 Tage abfragen
$bar_nr=0;
$bar_mark="";
for($day=29; $day>=0; $day--)
{
$sel_timestamp = mktime(0, 0, 0, date("n"), date("j")-$day, date("Y"));
$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;
if ($bar_mark == "$i" ) { echo "<td style=\"border-left: #FF0000 1px dotted;\" width=\"31\">";}
else echo "<td width=\"31\">";
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, date("n"), date("j")-29, date("Y"))); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, date("n"), date("j")-23, date("Y"))); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, date("n"), date("j")-17, date("Y"))); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, date("n"), date("j")-11, date("Y"))); ?></td>
<td colspan="6" class="timeline"><?PHP echo strftime("%d %B",mktime(0, 0, 0, date("n"), date("j")-5, date("Y"))); ?></td>
</tr></table>
</div>
<div style="clear:both"></div>
</div>
</div>
<?php
include_once('includes/footer.php');
?>