-
Notifications
You must be signed in to change notification settings - Fork 0
/
object_qual2.php
60 lines (55 loc) · 3.35 KB
/
object_qual2.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<?php
print '<table border="0" cellpadding="0" cellspacing="0"><tr><td width="1200" valign=top>';
print '<table border="0" cellpadding="1" cellspacing="1"><tbody>';
print '<tr><td align=center class="m_separator"><font color="black">Äàâëåíèå âîäû ['.$name.']</td></tr>';
print '<tr><td align=center><img src="charts/trend2.php?obj='.$_GET["id"].'&device='.$device.'&type=1&prm=5&prm2=16&source=2&x=1200&y=300&month='.$_GET["month"].'&year='.$_GET["year"].'" width=1200 height=300></td></tr>';
print '<tr><td align=center class="m_separator"><font color="black">Ðàñõîä âîäû ['.$name.']</td></tr>';
print '<tr><td align=center><img src="charts/trend2.php?obj='.$_GET["id"].'&device='.$device.'&type=1&prm=5&prm2=12&source=6&x=1200&y=300&month='.$_GET["month"].'&year='.$_GET["year"].'" width=1200 height=300></td></tr>';
print '<tr><td align=center class="m_separator"><font color="black">Ðàñõîä âîäû ïî äíÿì ['.$name.']</td></tr>';
print '<tr><td align=center><img src="charts/barplots21.php?type=2&prm=3&x=1200&y=300&device='.$device.'&name='.$name.'&month='.$_GET["month"].'&year='.$_GET["year"].'"></td></tr>';
print '</table></td><td width="400px" valign="top"><table border="0" cellpadding="0" cellspacing="0">';
print '<tr align="center"><td class="m_separator">Äàòà</td><td class="m_separator">Põâñ</td><td class="m_separator">Võâñ</td><td class="m_separator">÷àñ</td></tr>';
$today=getdate();
if ($_GET["year"]=='') $ye=$today["year"];
else $ye=$_GET["year"];
if ($_GET["month"]=='') $mn=$today["mon"];
else $mn=$_GET["month"];
$tm=$dy=31; $x=0;
if (!checkdate ($mn,31,$ye)) { $dy=30; }
if (!checkdate ($mn,30,$ye)) { $dy=29; }
if (!checkdate ($mn,29,$ye)) { $dy=28; }
for ($tn=$dy; $tn>=1; $tn--)
{
$date11[$x]=sprintf ("%d%02d%02d000000",$ye,$mn,$tn);
$date12[$x]=sprintf ("%d-%02d-%02d 00:00:00",$ye,$mn,$tn);
$dats[$x]=sprintf ("%d-%02d-%02d",$ye,$mn,$tn);
$x++;
}
$max=$x;
$query = 'SELECT * FROM data WHERE type=2 AND device='.$device;
$aa = mysql_query ($query,$i);
if ($aa) $uy = mysql_fetch_row ($aa); $x=0;
while ($uy)
{
for ($t=0;$t<$max;$t++)
if ($date12[$t]==$uy[2]) $x=$t;
if ($uy[8]==16 && $uy[6]==2) $datas0[$x]=$uy[3];
if ($uy[8]==12 && $uy[6]==6) if ($uy[3]>0) $datas1[$x]=$uy[3];
$uy = mysql_fetch_row ($aa);
}
$max--;
for ($j=0; $j<=$max; $j++)
{
$like='\''.$dats[$j].'%\'';
$query = 'SELECT COUNT(id) FROM data WHERE type=1 AND prm=16 AND source=2 AND value=0 AND date LIKE '.$like.' AND device='.$device;
$aa = mysql_query ($query,$i);
if ($aa) $uy = mysql_fetch_row ($aa);
if ($uy) $datas2[$j]=$uy[0];
print '<tr><td class="m_separator">'.$dats[$j].'</td><td class="simple_bold" align="center">'.number_format($datas0[$j],3).'</td>
<td class="simple_bold" align="center">'.number_format($datas1[$j],3).'</td><td class="simple_bold" align="center">'.number_format($datas2[$j],0).'</td></tr>';
$it1+=$datas1[$j]; $it2+=$datas2[$j];
}
print '<tr><td class="m_separator">Èòîãî</td><td class="m_separator"></td><td class="m_separator">'.number_format($it1,2).'</td><td class="m_separator">'.number_format($it2,0).'</td></tr>';
print '</table></td></tr>';
print '</td></tr></table>';
?>