-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrep_ddt.php
122 lines (120 loc) · 5.77 KB
/
rep_ddt.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
<?php include("config/local.php"); ?>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<!doctype php manual "-//by the PHP Documentation Group//en">
<!doctype odbc manual "-//by microsoft corp.//en">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link rel="stylesheet" href="shablon.css" type="text/css">
<title>detail</title></head>
<body align=left bgcolor=black leftmargin=0 topmargin=5 rightmargin=0 bottommargin=0 marginwidth=0 marginheight=0>
<table align=left border=0 cellspacing=0 cellpadding=1 width=100% bgcolor=#000000>
<tr><td>
<?php
$i = mysql_connect ($mysql_host,$mysql_user,$mysql_password); $e=mysql_select_db ($mysql_db_name);
$arr = get_defined_vars();
$x=0; $y=0;
$query = 'SELECT * FROM buyers WHERE caption=\''.$arr["idbuy"].'\'';
$r = mysql_query ($query,$i);
$uo = mysql_fetch_row ($r);
if ($uo == true) $buy=$uo[0];
print '<tr>';
print '<td bgcolor=#880000><font class="main">Íàçâàíèå</font></td>';
print '<td bgcolor=#880000><font class="main">Êîðïóñ</font></td>';
print '<td bgcolor=#880000><font class="main">Òèï</font></td>';
print '<td bgcolor=#880000><font class="main">Òèï ïîìåùåíèÿ</td><td bgcolor=#880000><font class="main">Ïëîùàäü</td>';
print '<td bgcolor=#880000 align=center><font class="main">Ìàññà (êã)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Òåïëîâàÿ ýíåðãèÿ (ÃÄæ/÷)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Ðàñõîä âîäû (ì3)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Ðàñõîä ïàðà (ì3)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Ìàññîâûé ðàñõîä (êã/÷)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Îáúåìíûé ðàñõîä (ì3)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Îáúåìíûé ðàñõîä (ì3)</td>';
print '<td bgcolor=#880000 align=center><font class="main">Ìîùíîñòü (êÂò)</td></tr>';
$source=$ut[2]+1;
if ($arr["idkor"]==99) $query = 'SELECT * FROM objects WHERE type!=1 AND idbuy='.$buy;
else $query = 'SELECT * FROM objects WHERE type!=1 AND idbuy='.$buy.' AND idkorp='.$uu[1];
$a = mysql_query ($query,$i);
for ($p=1;$p<=500;$p++)
{
$uu = mysql_fetch_row ($a);
if ($uu == true)
{
print '<tr>';
print '<td><font class="dd">'.$uu[1].'</font></td>';
print '<td><font class="dd">';
$query = 'SELECT name FROM korp WHERE korp_id='.'\''. $uu[4].'\'';
$p = mysql_query ($query,$i); $up = mysql_fetch_row ($p);
if ($up == true) print $up[0];
else print 'Unknown'; print '</font></td>';
print '<td><font class="dd">';
if ($uu[5]=='1') print 'Êîðïóñ ';
if ($uu[5]=='2') print 'Ïîìåùåíèå ';
if ($uu[5]=='3') print 'Àãðåãàò ';
print '</font></td>';
print '<td><font class="dd">';
if ($uu[38]=='1') print 'Âñïîìîãàòåëüíîå';
if ($uu[38]=='2') print 'Ïðîèçâîäñòâåííîå';
if ($uu[38]=='3') print 'Ñêëàäñêîå';
if ($uu[38]=='4') print 'Ïóñòóþùåå';
if ($uu[38]=='5') print 'Àäìèíèñòðàòèâíîå';
if ($uu[38]=='6') print 'Ñàíèòàðíî-áûòîâîå';
print '</font></td>';
print '<td><font class="main">'.$uu[14].'</td>';
$query = 'SELECT * FROM energy_supply';
$t = mysql_query ($query,$i);
for ($y=1;$y<=8;$y++)
{
$ut = mysql_fetch_row ($t);
if ($ut)
if ($uu[6+$ut[2]]>0)
{
$data=0;
if ($arr["day"]<10) $day='0'.$arr["day"]; else $day=''.$arr["day"];
if ($arr["otch"]==1)
$query = 'SELECT * FROM data WHERE type='.$arr["otch"].' AND date='.$arr["year"].$month.$day.'000000 AND korp='.$uu[4].' AND source='.$ut[2];
if ($arr["otch"]==2)
$query = 'SELECT * FROM data WHERE type='.$arr["otch"].' AND (date='.$arr["year"].$month.$day.'000000 OR date='.$arr["year"].$month.$day.'120000) AND korp='.$uu[4].' AND source='.$ut[2];
if ($arr["otch"]==3)
$query = 'SELECT * FROM data WHERE type='.$arr["otch"].' AND (date='.$arr["year"].$month.'01000000 OR date='.$arr["year"].$month.'01120000) AND korp='.$uu[4].' AND source='.$ut[2];
if ($arr["otch"]==4)
$query = 'SELECT * FROM data WHERE type='.$arr["otch"].' AND (date='.$arr["year"].$month.'01000000 OR date='.$arr["year"].$month.'01120000) AND korp='.$uu[4].' AND source='.$ut[2];
$K=$uu[6+$ut[2]];
//echo $query;
$z = mysql_query ($query,$i);
if ($z)
for ($o=1;$o<=10;$o++)
{
$uo = mysql_fetch_row ($z);
if ($uo == true)
{
//echo $ut[2].' '.$uo[1].' '.$uo[7];
if ($ut[2]==0)
{
if (strstr ($uo[1],'ìàññ') && strstr ($uo[1],'ïîäàþùåé')) $data=$uo[7]*$K;
if (strstr ($uo[1],'ìàññ') && strstr ($uo[1],'îáðàòíîé')) { $data=$data-$uo[7]*$K; $o=100;}
}
if ($ut[2]==1)
if (strstr ($uo[1],'òåïëîâîé ýíåðãèè')) $data=$data+$uo[7]*$K;
if ($ut[2]==2) $data=$uo[7]*$K;
if ($ut[2]==3) $data=$uo[7]*$K;
if ($ut[2]==4)
if (strstr ($uo[1],'ìàññû')) $data=$uo[7]*$K;
if ($ut[2]==5)
if (strstr ($uo[1],'îáúåìà')) $data=$uo[7]*$K;
if ($ut[2]==6)
if (strstr ($uo[1],'îáúåìà')) $data=$uo[7]*$K;
if ($ut[2]==7) $data=$uo[7]*$K;
}
}
print '<td align=center><font class="dd">'.$data.'</td>';
}
else print '<td align=center><font class="dd">0</td>';
}
print '</tr>';
}
}
?>
</td><tr>
</table>
</body>
</html>