-
Notifications
You must be signed in to change notification settings - Fork 0
/
analys7.php
128 lines (117 loc) · 5.42 KB
/
analys7.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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<div id="maincontent" style="width:100%; left: 0px;">
<?php
$today=getdate();
if ($_GET["year"]=='') $ye=$today["year"];
else $ye=$_GET["year"];
if ($_GET["month"]=='') $mn=$today["mon"];
else $mn=$_GET["month"];
$month=$mn;
include ("time.inc");
$prevmonth=$month.', '.$today["year"];
$tarif_svoda=18.56;
if ($_POST["year"]=='') $_POST["year"]=2012;
if ($_POST["year2"]=='') $_POST["year2"]=2012;
if ($_POST["month"]=='') $_POST["month"]=5;
if ($_POST["month2"]=='') $_POST["month2"]=8;
if ($_POST["day"]=='') $_POST["day"]=1;
if ($_POST["day2"]=='') $_POST["day2"]=28;
$stdate=sprintf ("%d%02d%02d000000",$_POST["year"],$_POST["month"],$_POST["day"]);
$endate=sprintf ("%d%02d%02d000000",$_POST["year2"],$_POST["month2"],$_POST["day2"]);
$stdate2=sprintf ("%02d-%02d-%d",$_POST["year"],$_POST["month"],$_POST["day"]);
$endate2=sprintf ("%02d-%02d-%d",$_POST["year2"],$_POST["month2"],$_POST["day2"]);
print '<table><tr><td class="m_separator">Âûáðàòü ïåðèîä: '; include("ch_mon2.php"); print '</td></tr></table>';
print '<table border="0" cellpadding="2" cellspacing="0"><tbody><tr><td align="center" valign="top">';
print '<table width="1200px" cellspacing="1" bgcolor="#5D6D2f"><tr>';
print '<td align="center" class="m_separator">N </td>';
print '<td align="center" class="m_separator">Îáúåêò ðàñ÷åòà</td>';
print '<td align="center" class="m_separator">Àäðåñ</td>';
print '<td align="center" class="m_separator">Íà÷àëî ïåðèîäà</td>';
print '<td align="center" class="m_separator">Êîíåö ïåðèîäà</td>';
print '<td align="center" class="m_separator">Çíà÷åíèå íà÷àëî</td>';
print '<td align="center" class="m_separator">Çíà÷åíèå êîíåö</td>';
print '<td align="center" class="m_separator">Ïîòðåáëåíèå</td>';
print '</tr>';
$query = 'SELECT * FROM objects WHERE uvoda>0 ORDER BY type';
if ($_POST["uprav"]) $query = 'SELECT * FROM objects WHERE type='.$_POST["uprav"].' ORDER BY id';
$a = mysql_query ($query,$i);$object=0;
if ($a)
while ($uy = mysql_fetch_row ($a))
{
$query = 'SELECT * FROM devices WHERE object='.$uy[0];
$u = mysql_query ($query,$i);
if ($u) $uo = mysql_fetch_row ($u);
if ($uo) $dev[$object]=$uo[11];
$data6[$object]=$data16[$object]=$data3[$object]=$data13[$object]=0;
$object++;
}
$query = 'SELECT * FROM data WHERE type=2 AND value>0 AND (prm=12) AND date<='.$stdate.' ORDER BY date DESC LIMIT 30000';
//echo $query;
$a2 = mysql_query ($query,$i);
if ($a2) $uy2 = mysql_fetch_row ($a2);
while ($uy2)
{
$x=$object;
for ($t=0;$t<$object;$t++)
if ($uy2[4]==$dev[$t]) $x=$t;
if ($uy2[8]==12 && $uy2[6]==25) if ($data6[$x]==0) $data6[$x]=$uy2[3];
if ($uy2[8]==12 && $uy2[6]==26) if ($data3[$x]==0) $data3[$x]=$uy2[3];
$uy2 = mysql_fetch_row ($a2);
}
$query = 'SELECT * FROM data WHERE type=2 AND value>0 AND (prm=12) AND date<='.$endate.' ORDER BY date DESC LIMIT 30000';
$a2 = mysql_query ($query,$i);
if ($a2) $uy2 = mysql_fetch_row ($a2);
while ($uy2)
{
$x=$object;
for ($t=0;$t<$object;$t++)
if ($uy2[4]==$dev[$t]) $x=$t;
if ($uy2[8]==12 && $uy2[6]==25) if ($data16[$x]==0) $data16[$x]=$uy2[3];
if ($uy2[8]==12 && $uy2[6]==26) if ($data13[$x]==0) $data13[$x]=$uy2[3];
$uy2 = mysql_fetch_row ($a2);
}
$today=getdate();
$x=0;
$query = 'SELECT * FROM objects WHERE uvoda>0 ORDER BY type';
if ($_POST["uprav"]) $query = 'SELECT * FROM objects WHERE type='.$_POST["uprav"].' ORDER BY id';
$a = mysql_query ($query,$i); $ccn=1; $object=0; $itt=0;
if ($a)
while ($uy = mysql_fetch_row ($a))
{
//$data13[$x]=$data16[$x]=$data3[$x]=$data6[$x]=0;
$query = 'SELECT * FROM devices WHERE object='.$uy[0];
$u = mysql_query ($query,$i);
if ($u) $uo = mysql_fetch_row ($u);
$device=$uo[11];
$types[$object]=$uy[2];
$name[$object]=$uy[1];
$adr[$object]=$uy[3];
$voda2=$data16[$x]-$data6[$x];
$voda=$data13[$x]-$data3[$x];
if ($data3[$x]>$data13[$x]) $data13[$x]=$data3[$x];
if ($voda2<0) $voda2=0; if ($voda<0) $voda=0;
print '<tr><td align="center" class="m_separator">'.($object+1).'</td>';
print '<td align="left" class="simple" style="white-space:nowrap"><font style="font-weight:bold"><a href="index.php?sel=object&menu=report_voda2&day='.$_POST["day"].'&month='.$_POST["month"].'&year='.$_POST["year"].'&day2='.$_POST["day2"].'&month2='.$_POST["month2"].'&year2='.$_POST["year2"].'&id='.$uy[0].'">'.$name[$object].'</font></td>';
print '<td align="left" class="simple" style="white-space:nowrap"><font style="font-weight:bold">'.$adr[$object].'</font></td>';
print '<td align="center" class="simple">'.$stdate2.'</td>';
print '<td align="center" class="simple">'.$endate2.'</td>';
//print '<td align="center" class="simple">'.number_format($teplo,3).' '.$data16[$x].'-'.$data6[$x].'</font></td>';
//print '<td align="center" class="simple">'.number_format($voda,3).' '.$data13[$x].'-'.$data3[$x].'</font></td>';
// print '<td align="center" class="simple">'.number_format($teplo,3).'</font></td>';
print '<td align="center" class="simple">'.number_format($data3[$x],3).'</font></td>';
print '<td align="center" class="simple">'.number_format($data13[$x],3).'</font></td>';
print '<td align="left" class="simple"><font style="font-weight:bold">'.number_format($voda,2).'</font></td>';
print '</tr>';
$object++; $x++;
}
print '</table></td>';
?>
</tr>
</tbody></table>
</td></tr></tbody></table>
</td></tr>
<tr><td>
<table>
</table>
</td></tr>
</tbody></table>
</div>