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
|
<?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_month($start, $end, $pred_day, $image_name, $table, $fontfile, $show_text) {
// Create a date array
$date = getdate(strtotime($end));
// Select daily energy for each day of month
// 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 DAY($table.created) AS day, kdy FROM $table, (SELECT MAX(created) AS created FROM $table WHERE MONTH(created)=$date[mon] AND YEAR(created)=$date[year] GROUP BY DAYOFYEAR(created)) AS sublog WHERE $table.created=sublog.created AND MONTH($table.created)=$date[mon] AND YEAR($table.created)=$date[year]") or die(mysql_error());
$result = @mysql_query("SELECT DAY(created) AS day, MAX(kdy) AS kdy FROM $table WHERE MONTH(created)=$date[mon] AND YEAR(created)=$date[year] GROUP BY DAYOFYEAR(created)") or die(mysql_error());
if (mysql_num_rows($result) == 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 />';
}
// include monthly predictions
include 'solarertrag_month_predictions.php';
$pred_month = ${'m_'.date('m', mktime(0, 0, 0, $row['month'], 1, 0))};
// Initialize kdy image
$sum=0;
// Pixel per day determines bar width
$px_per_day = 25;
// Width = days * px per day + gap
$width = $date['mday'] * $px_per_day + 45;
$maxkwh = 25;
// How many kWh per diagram line
$step_w = 2;
// 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 = 72;
$height = $maxkwh / $step_w * $vert_px + $gap;
// 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('/gridmonth/', $show_text)) {
// Draw horizontal lines with some space above and below
for ($i = 0; $i <= $maxkwh / $step_w; $i++) {
// Create horizontal grid line
$ypos = $height - $i * $vert_px - $gap + 22;
imageline($image, 12, $ypos, $width - 35, $ypos, $gray);
// Draw the kWh value at the end of the horizontal line
imagefttext($image, 8, 0, $width - 30, $ypos + 4, $black, $fontfile, $i * $step_w);
}
// Draw vertical lines with some space at the left and right
for ($i = 1; $i <= $date['mday']; $i++) {
// Create vertical grid line
$xpos = $i * $px_per_day;
imageline($image, $xpos, 5, $xpos, $height - $gap + 27, $gray);
// Draw the hour value at the end of the vertical line
imagefttext($image, 8, 0, $xpos - 4, $height - $gap + 40, $black, $fontfile, $i);
}
}
// Draw kdy values
while($row = mysql_fetch_assoc($result)) {
// Determine x position
$xpos = $row['day'] * $px_per_day - $px_per_day / 2;
$lastxpos = $xpos;
// Transform kWh to pixel height
$kwh = $row['kdy'] / $step_w * $vert_px;
$days++;
$sum = $sum + $row['kdy'] ;
// Draw acumulated yield
$factor = $height/50*$pred_month;
$totalkwh = $totalkwh + kwh;
if ($lasttotalkwh == 0) {
imagesetpixel($image, $xpos, $height - $gap + 22 - $totalkwh, $black);
} else {
imageline($image, $lastxpos - $px_per_day/2, ($height - $gap + 22 - $lasttotalkwh), $xpos + $px_per_day/2, ($height - $gap + 22 - $totalkwh), $black);
}
$lasttotalkwh = $totalkwh;
// Draw kWh bar
imagefilledrectangle($image, $xpos + 2, $height - $gap + 22, $xpos + $px_per_day - 2, $height - $gap - $kwh + 22, $green);
if (preg_match('/numbersmonth/', $show_text)) {
imagefttext($image, 12, 90, $xpos + 19, $height - $gap - $kwh + 17, $black, $fontfile, $row['kdy']);
}
}
// Draw prediction line
if (preg_match('/predmonth/', $show_text)) {
$pred = $pred_day / $step_w * $vert_px;
imageline($image, 12, $height - $pred - $gap + 22, $width - 35, $height - $pred - $gap + 22, $blue);
imageline($image, $width - ($width * 3 / 4) -10, $height - 15, $width - ($width * 3 / 4) + 5, $height - 15, $blue);
imagefttext($image, 7, 0, $width - ($width * 3 / 4) + 20, $height - 12, $black, $fontfile, $GLOBALS["graphmonth2".$GLOBALS['lang']]);
}
// Draw average line
if (preg_match('/avg/', $show_text)) {
$avg =$sum / $days / $step_w * $vert_px;
imageline($image, 12, $height - $avg - $gap + 22, $width - 35, $height - $avg - $gap + 22, $yellow);
imageline($image, $width - ($width * 2 / 4) - 5, $height - 15, $width - ($width * 2 / 4) +10, $height - 15, $yellow);
imagefttext($image, 7, 0, $width - ($width * 2 / 4) +25, $height - 12, $black, $fontfile, $GLOBALS["graphmonth3".$GLOBALS['lang']]);
}
imagepng($image, $image_name);
imagedestroy($image);
return '<p>' . $GLOBALS["graphmonth1".$GLOBALS['lang']] . '</p>';
}
?>
|
