scenter/object_raspvoda.php at main · Olejek88/scenter · GitHub

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
<?php
$i = mysql_connect ($mysql_host,$mysql_user,$mysql_password); $e=mysql_select_db ($mysql_db_name);
$today=getdate();
$sts=sprintf("%d%02d01000000",$ye,$mn);
$fns=sprintf("%d%02d01000000",$ye,$mn+1);
$allm1=$allm2=$dt0=0;
for ($hr=0;$hr<=23;$hr++)
 {
  if ($hr<10) $date1='%0'.$hr.':00:00%'; else $date1='%'.$hr.':00:00%';
  if ($device=='') $query = 'SELECT SUM(value),COUNT(id) FROM data WHERE type=1 AND value>0 AND prm=12 AND source=6 AND value<10 AND date>='.$sts.' AND date<'.$fns.' AND date LIKE \''.$date1.'\'';
  else  $query = 'SELECT SUM(value),COUNT(id) FROM data WHERE type=1 AND device='.$device.' AND value>0 AND prm=12 AND source=6 AND value<10 AND date>'.$sts.' AND date<'.$fns.' AND date LIKE \''.$date1.'\'';
  $a = mysql_query ($query,$i);
  if ($a) $uy = mysql_fetch_row ($a);

  if ($uy[1]) $data[$hr]=$uy[0]/$uy[1];
  if ($hr>=20 || $hr<=8) $dt0+=$uy[0];
  $dat[$hr]=$hr.':00';
  $allm1+=$uy[0];
  $allm2=$dt0;
 }
if ($allm1) $pr0=$allm2*100/$allm1;

for ($hr=0;$hr<=6;$hr++)
 {
  if ($device!='') $query = 'SELECT SUM(value),COUNT(id) FROM data WHERE type=2 AND device='.$device.' AND prm=12 AND source=6 AND value>0 AND value<50 AND date>='.$sts.' AND date<'.$fns.' AND WEEKDAY(date)='.$hr;
  else $query = 'SELECT SUM(value),COUNT(id) FROM data WHERE type=2 AND prm=12 AND source=6 AND value>0 AND value<50 AND date>'.$sts.' AND date<'.$fns.' AND WEEKDAY(date)='.$hr;
  $a = mysql_query ($query,$i);
  if ($a) $uy = mysql_fetch_row ($a);

  if ($uy[1]) $data[$hr]=$uy[0]/$uy[1]-$data2;
  if ($hr==0) $dat[$hr]='ïîíåäåëüíèê';
  if ($hr==1) $dat[$hr]='âòîðíèê';
  if ($hr==2) $dat[$hr]='ñðåäà';
  if ($hr==3) $dat[$hr]='÷åòâåðã';
  if ($hr==4) $dat[$hr]='ïÿòíèöà';
  if ($hr==5) $dat[$hr]='ñóááîòà';
  if ($hr==6) $dat[$hr]='âîñêðåñåíüå';
  if ($hr>=5) $dt1+=$uy[0];
  if ($hr<=4) $avg+=$data[$hr];
  $allm3+=$uy[0];
  $allm4=$dt1;
 }
if ($allm3) $pr1=$allm4*100/$allm3;

print  '<table border="0" cellpadding="2" cellspacing="0"><tr><td align="center" class="m_separator">Íàçíà÷åíèå</td><td align=center class="menuitem">Îöåíêà ðàçìåðà íåïðîèçâîäèòåëüíûõ óòå÷åê âîäû â íî÷íûå ÷àñû è âûõîäíûå äíè</td></tr></table>
	<table border="0" cellpadding="2" cellspacing="2"><tbody>
	<tr><td align=center class="m_separator" colspan="2">Àíàëèç ýôôåêòèâíîñòè ïîòðåáëåíèÿ âîäû ïî äíÿì íåäåëè çà '.$prevmonth.' ãîäà (êóá.ì.)</td></tr>
	<tr><td><img src="charts/barplot_hourly.php?dev='.$device.'&type=3&month='.$_GET["month"].'&year='.$_GET["year"].'"></td><td valign="top">
	<table border="0" cellpadding="2" cellspacing="2">
	<tr><td class="m_separator" colspan="2">Ðàñõîä âîäû (êóá.ì.)</td><td class="simple"></td></tr>
	<tr><td class="m_separator">Èòîãî çà ìåñÿö</td><td class="simple">'.number_format($allm1,3).'</td></tr>
	<tr><td class="m_separator">Èòîãî çà âûõîäíûå è ïðàçäíè÷íûå äíè</td><td class="simple">'.number_format($allm2,3).'</td></tr>
	<tr><td class="m_separator">Èòîãî çà ðàáî÷èå äíè</td><td class="simple">'.number_format($allm1-$allm2,3).'</td></tr>
	</table></td></tr>
	<tr><td></td></tr>
	<tr><td align=center class="m_separator">Àíàëèç ýôôåêòèâíîñòè ïîòðåáëåíèÿ âîäû ïî ÷àñàì â ñðåäíåì çà '.$prevmonth.' ãîäà (êóá.ì.)</td></tr>
	<tr><td><img src="charts/barplot_hourly.php?dev='.$device.'&type=4&month='.$_GET["month"].'&year='.$_GET["year"].'"></td><td valign="top">
	<table border="0" cellpadding="2" cellspacing="2">
	<tr><td class="m_separator" colspan="2">Ðàñõîä âîäû çà äåíü (êóá.ì.)</td><td class="simple"></td></tr>
	<tr><td class="m_separator">Èòîãî çà ìåñÿö</td><td class="simple">'.number_format($allm3,3).'</td></tr>
	<tr><td class="m_separator">Èòîãî çà âûõîäíûå è ïðàçäíè÷íûå äíè</td><td class="simple">'.number_format($allm4,3).'</td></tr>
	<tr><td class="m_separator">% íåïðîèçâîäèòåëüíûõ ïîòåðü</td><td class="simple">'.number_format($pr1,3).'</td></tr>
	</table></td></tr>
	<tr><td></td></tr>
	<tr><td class="simple" colspan="2"><strong>Ðåêîìåíäàöèè:</strong><br>Îöåíèòü âîçìîæíîñòü ñíèæåíèÿ ïîòðåáëåíèÿ âîäû â íåðàáî÷åå âðåìÿ (â.ò.÷ âûõîäíûå è ïðàçäíè÷íûå äíè) è ïðîâåñòè îïòèìèçàöèþ ðàñõîäà â äíåâíîå âðåìÿ
	<br>Çà ïåðèîä '.$prevmonth.' êîëè÷åñòâî íåïðîèçâîäèòåëüíûõ ïîòåðü âîäû ñîñòàâèëî '.$allm2.' ì3
	<br>Ïåðåðàñõîä â ïðîöåíòíîì âûðàæåíèè ñîñòàâëÿåò '.$pr0.' %</td></tr>
</tbody></table>
</td></tr>
<tr><td><img src="charts/barplots21.php?type=2&prm=10&&x=1200&y=300&device='.$uo[11].'&name='.$nnnm.'&month='.$_GET["month"].'&year='.$_GET["year"].'" width="1200"></td></tr>
</tbody></table>';
?>