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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
|
<?php
/*
Simple solarmax visualizer php program written by zagibu@gmx.ch in July 2010
This program was originally licensed under WTFPL 2 http://sam.zoy.org/wtfpl/
Improvements by Frank Lassowski flassowski@gmx.de in August 2010
This program is now licensed under GPLv2 or later http://www.gnu.org/licenses/gpl2.html
*/
function draw_day($start, $end, $pred_day, $image_name, $table, $fontfile, $show_text) {
// Select data from given day
// If you are experiencing problems with the value 'kdy' especially the days very first 'kdy' is equal to the last one of the previous day comment in the next line and comment out the following one. Be aware: This is !!!untested!!! Don't slap me if something's going wrong!
//$result = @mysql_query("SELECT HOUR(created) AS hour, MINUTE(created) AS minute, pac, kdy FROM $table WHERE created BETWEEN '$start' AND '$end' LIMIT 1, 999999999") or die(mysql_error());
$result1 = @mysql_query("SELECT HOUR(created) AS hour, MINUTE(created) AS minute, pac FROM $table WHERE created BETWEEN '$start' AND '$end'") or die(mysql_error());
$result2 = @mysql_query("SELECT HOUR(created) AS hour, MINUTE(created) AS minute, kdy, tkk, udc FROM $table WHERE created BETWEEN '$start' AND '$end'") or die(mysql_error());
if (mysql_num_rows($result1) == 0)
{
// No data...create dummy image
$image = imagecreatetruecolor(10, 10);
$white = imagecolorallocate($image, 255, 255, 255);
imagefill($image, 0, 0, $white);
imagepng($image, $image_name);
imagedestroy($image);
return $GLOBALS["error3".$GLOBALS[lang]] . '<br />';
}
// Initialize pac image
// Sun rise and fall during longest day at your place, must be integer
$rise = 5; $fall = 22;
// Pixel per hour should be equal to log entries per hour (I log every minute)
$px_per_hour = 39;
// Width = hours * px per hour + gap
$width = ($fall - $rise) * $px_per_hour +157;
$maxpac = 5200;
$maxkdy = 25;
$maxtkk = 60;
$lasttkk = 0;
$maxudc = 400;
$lastudc = 0;
// How many W per diagram line
$step_w = 500;
$step = floor ( $maxpac / $step_w);
$step_kdy = $maxkdy / $step;
$step_tkk = $maxtkk / $step;
$step_udc = $maxudc / $step;
// How many px per diagram line (W/px = $step_w / $vert_px)
$vert_px = 30;
// Height = number of lines * px per line + px per line (for 0-line) + gap
$gap = 50;
$height = $maxpac / $step_w * $vert_px + $gap + 10;
// Create image, prepare colors and set background to white
$image = imagecreatetruecolor($width, $height);
// get the colors
include 'colors.php';
imagefill($image, 0, 0, $white);
if (preg_match('/gridday/', $show_text)) {
// Draw horizontal lines with some space above and below
for ($i = 0; $i <= $step; $i++) {
// Create horizontal grid line
$ypos = $height - $i * $vert_px - $gap;
imageline($image, 12, $ypos, $width - 110, $ypos, $gray);
// Draw the needed scales at the end of the horizontal line
$pac = $i * $step_w;
$kdy = $i * $step_kdy;
$tkk = $i * $step_tkk;
$udc = $i * $step_udc;
if (preg_match('/yield/', $show_text))
imagefttext($image, 7, 0, $width - 109, $ypos + 4, $black, $fontfile, floor ($pac));
if (preg_match('/accu/', $show_text) | preg_match('/predday/', $show_text))
imagefttext($image, 7, 0, $width - 74, $ypos + 4, $blue, $fontfile, floor ($kdy));
if (preg_match('/temp/', $show_text))
imagefttext($image, 7, 0, $width - 47, $ypos + 4, $black, $fontfile, floor ($tkk));
if (preg_match('/volt/', $show_text))
imagefttext($image, 7, 0, $width - 25, $ypos + 4, $red, $fontfile, floor ($udc));
}
// Draw vertical lines with some space at the left and right
for ($i = 0; $i <= $fall - $rise; $i++) {
// Create vertical grid line
$xpos = $i * $px_per_hour + 25;
imageline($image, $xpos, 5, $xpos, $height - $gap + 6, $gray);
// Draw the hour value at the end of the vertical line
$hour = ($i + $rise) % 24 . ':00';
imagefttext($image, 8, 0, $xpos - 10, $height - $gap + 18, $black, $fontfile, $hour);
}
}
//explain colored lines
if (preg_match('/yield/', $show_text) & preg_match('/gridday/', $show_text))
imagefttext($image, 7, 0, $width - 107, 10, $black, $fontfile, "(W)");
if (preg_match('/accu/', $show_text) | preg_match('/predday/', $show_text)) {
imageline($image, $width - ($width * 4 / 4) + 10, $height - 15, $width - ($width * 4 / 4) + 25, $height - 15, $blue);
imagefttext($image, 7, 0, $width - ($width * 4 / 4) + 40, $height - 12, $black, $fontfile, $GLOBALS["graphday2".$GLOBALS['lang']]);
if (preg_match('/gridday/', $show_text))
imagefttext($image, 6, 0, $width - 81, 10, $blue, $fontfile, "(kWh)");
}
if (preg_match('/temp/', $show_text)) {
imageline($image, $width - ($width * 2 / 4) + 0, $height - 15, $width - ($width * 2 / 4) + 15, $height - 15, $black);
imagefttext($image, 7, 0, $width - ($width * 2 / 4) + 30, $height - 12, $black, $fontfile, $GLOBALS["graphday3".$GLOBALS['lang']]);
if (preg_match('/gridday/', $show_text))
imagefttext($image, 6, 0, $width - 50, 10, $black, $fontfile, "(°C)");
}
if (preg_match('/volt/', $show_text)) {
imageline($image, $width - ($width * 1 / 4) - 30, $height - 15, $width - ($width * 1 / 4) - 15, $height - 15, $red);
imagefttext($image, 7, 0, $width - ($width * 1 / 4) + 0, $height - 12, $black, $fontfile, $GLOBALS["graphday4".$GLOBALS['lang']]);
if (preg_match('/gridday/', $show_text))
imagefttext($image, 7, 0, $width - 25, 10, $red, $fontfile, "(V)");
}
// Draw pac values
$lastxpos=0;
if (preg_match('/yield/', $show_text)) {
while($row = mysql_fetch_assoc($result1)) {
// Determine x position
$xpos = floor (($row['hour'] - $rise) * $px_per_hour + $row['minute'] / 60 * $px_per_hour + 25);
if ($xpos > $lastxpos) {
// Calculate y position with logged pac
$pac = $row['pac'] / $step_w * $vert_px;
// Draw pac line
imageline($image, $xpos, $height - $gap, $xpos, $height - $gap - $pac, $green);
}
$lastxpos = $xpos;
}
}
// Draw prediction line
if (preg_match('/predday/', $show_text)) {
$pred = $pred_day / $step_kdy * $vert_px;
imageline($image, 12, $height - $pred - $gap, $width - 122, $height - $pred - $gap, $blue);
}
// Draw other logged values: kdy, tkk, udc
while($row = mysql_fetch_assoc($result2)) {
// Determine x position
$xpos = ($row['hour'] - $rise) * $px_per_hour + $row['minute'] / 60 * $px_per_hour + 25;
$lastxpos = $xpos;
// Logged kdy is ten times as high as effective
if (preg_match('/accu/', $show_text)) {
$kdy = $row['kdy'] / $step_kdy * $vert_px;
// Draw kdy dot
imagesetpixel($image, $xpos, $height - $gap - $kdy, $blue);
}
// draw tkk as a stair-line
if (preg_match('/temp/', $show_text)) {
$tkk = $row['tkk'] / $step_tkk * $vert_px;
if ($lasttkk == 0) {
imagesetpixel($image, $xpos, $height - $gap - $tkk, $black);
} else {
imageline($image, $lastxpos, $height - $gap - $lasttkk, $xpos, $height - $gap - $tkk, $black);
}
$lasttkk = $tkk;
}
if (preg_match('/volt/', $show_text)) {
$udc = $row['udc'] / $step_udc * $vert_px;
if ($lastudc == 0) {
imagesetpixel($image, $xpos, $height - $gap - $udc, $red);
} else {
imageline($image, $lastxpos, $height - $gap - $lastudc, $xpos, $height - $gap - $udc, $red);
}
$lastudc = $udc;
}
}
imagepng($image, $image_name);
imagedestroy($image);
return '<p>' . $GLOBALS["graphday1".$GLOBALS['lang']] . '</p>';
}
?>
|
