<div class="y13w">Показать: <a href='?a=stat&sort=0'>за сегодня</a> <a href='?a=stat&sort=1'>за неделю</a> <a href='?a=stat&sort=2'>за месяц</a> <a href='?a=stat&sort=3'>за год</a> <a href='?a=stat&sort=4'>за всё время</a> <a href='?a=admin_geo'><b style="color: green;">GEO</b></a></div>
<?php
if (isset($_GET['sort'])) {
$sort = $_GET['sort'];
$sql = 'SELECT * FROM `logs` WHERE id != 0 ';
switch ($sort)
{
case 0:
$sql .= ' AND `date` = "'.date('d.m.Y').'" LIMIT 1';
break;
case 1:
$sql .= 'ORDER BY id DESC LIMIT 0, 7';
break;
case 2:
$sql .= 'ORDER BY id DESC LIMIT 0, 30';
break;
case 3:
$sql .= 'ORDER BY id DESC LIMIT 0, 365';
break;
case 4:
$sql .= 'ORDER BY id DESC';
break;
}
?>
<table width="100%" border="0" class="graph" cellpadding="1" cellspacing="1">
<tr align="center" height="19">
<td width="60"><strong>Дата</strong></td>
<td width="45"><strong>Ввод</strong></td>
<td width="45"><strong>Вывод</strong></td>
<?php
$result = mysql_query("SELECT * FROM parametrs WHERE part = 0 AND view = 1 ORDER BY id ASC");
while($row = mysql_fetch_array($result)) {
print "<td colspan=\"2\"><strong>".$row['path']."</strong></td>";
}
?>
</tr>
<tr align=center valign="top" bgcolor="#dddddd">
<td>-</td>
<td>-</td>
<td>-</td>
<?php
$result = mysql_query("SELECT * FROM parametrs WHERE part = 0 AND view = 1 ORDER BY id ASC");
while($row = mysql_fetch_array($result)) {
print "<td>Sum</td><td>Clx</td>";
$allenter = 0;
$allout = 0;
$all[$row['path']] = 0;
$allclx[$row['path']] = 0;
}
?>
</tr>
<?php
$rs = mysql_query($sql);
while ($a = mysql_fetch_array($rs))
{
print '<tr align="center">
<td><nobr>'.$a['date'].'</nobr></td>
<td>'.$a['enter'].'</td>
<td>'.$a['out'].'</td>';
$result = mysql_query("SELECT * FROM parametrs WHERE part = 0 AND view = 1 ORDER BY id ASC");
while($row = mysql_fetch_array($result)) {
print '<td>'.sprintf("%01.2f", $a[$row['path']]).'</td>
<td>'.$a[$row['path'].'_clx'].'</td>';
$allm[$row['path']] = $allm[$row['path']] + $a[$row['path']];
$allclx[$row['path']] = $allclx[$row['path']] + $a[$row['path'].'_clx'];
}
print '</tr>';
$allenter = $allenter + $a['enter'];
$allout = $allout + $a['out'];
}
?>
<tr align=center valign="top">
<td>Итого:</td>
<td><strong><?php print sprintf("%01.2f", $allenter); ?></strong></td>
<td><strong><?php print sprintf("%01.2f", $allout); ?></strong></td>
<?php
$result = mysql_query("SELECT * FROM parametrs WHERE part = 0 AND view = 1 ORDER BY id ASC");
while($row = mysql_fetch_array($result)) {
print '<td>'.sprintf("%01.2f", $allm[$row['path']]).'</td>
<td>'.$allclx[$row['path']].'</td>';
}
?>
</tr>
</table>
<?php
}
?>