Monatssicht |
|
|
='$dFrom' AND Period<='$dTo' ) OR (Period_Type='Y' AND Period='$PeriodYear')".
"ORDER BY devGroup asc, E_End asc, TimeStart asc";
$res=mysql_query($sql,$db);
while ($row=mysql_fetch_array($res)) {
if ($row['devGroup'] != $lastGroup) {
if ($current != null) { finishGroup($current); }
$lastGroup = $row['devGroup'];
$current=array("group" => $row['devGroup'],"tabrows"=>array(), "tab" => "","ertrag" =>0, "isSenec" => ($lastGroup=="1"),"kWp"=>Dev2KWp($lastGroup));
}
//-- für Monat & Tag
if ($row["Period_Type"]=="M") {
$current["sumrowM"] = $row;
} else if ($row['Period_Type']=="Y") {
$current["sumrowY"] = $row;
} else { // Tag
$date=substr($row['TimeStart'],0,10);
$row['DATETIME']=$date;
$current["tabrows"][$date]=$row;
}
}
finishGroup($current);
mysql_close($db);
$sued=$groupdata["2"];
if ($groupdata["1"] != null) {
$total=$groupdata["1"];
$total["group"]="TOTAL";
if ($groupdata["2"] != null) { AddDev($total,$groupdata["2"]); }
if ($groupdata["3"] != null) { AddDev($total,$groupdata["3"]); }
//finishGroup($total);
finishGroupCalcWp($total);
PrintSummary($total);
PrintDevice($groupdata["1"]);
}
if ($groupdata["2"] != null) { PrintDevice($groupdata["2"]); }
if ($groupdata["3"] != null) { PrintDevice($groupdata["3"]); }
function PrintSummary($total)
{
global $isCurrentMonth,$month,$year,$labMonth,$Laenge,$Breite,$groupdata;
$row =$total["sumrowM"];
$T_End=$row['TimeEnd'];
?>
| Zusammenfassung |
| | PV1 | PV2 | PV3 | Jahr *1 |
| PV Gesamtertrag |
| je kWp |
| Tagesmaximum |
| Batterie Entnahme | | ".formatValueHtml2col($groupdata["3"]["sumrowM"]['WBATOUT'],'kWh').formatValueHtml2col($total["sumrowY"]['WBATOUT'],'kWh'); ?>
| Batterie Ladung | | ".formatValueHtml2col($groupdata["3"]["sumrowM"]['WBATIN'],'kWh').formatValueHtml2col($total["sumrowY"]['WBATIN'],'kWh'); ?>
| Einspeisung | | | | | | |
| Netzbezug | | | | | | |
| Ges. Haus | | | | | | |
Gesamt *1
// formatValueHtml2col($row['EGridIn'],'kWh')
//formatValueHtml2col($row['EGridOut'],'kWh')
//formatValueHtml2col($row['EHouse'],'kWh')
?>
*1 Seit Jahresanfang bis
|
| Zeitraum | W Photov. | je kWp |
W Haus | W Bezug | W Einsp | W Bat | Laden | Summiert |
P durchschn.
$RowDate=$row["DATETIME"];
$T_Date="".FormatDate($RowDate)."";
$T_Range=substr($row['TimeStart'],11,5)." - ".substr($row['TimeEnd'],11,5);
$tab=$tab."| $T_Date | $T_Range | "
.formatValueHtml($row['ertrag'],'KWh')
.formatValueHtml($row["ertrag"]/$total['kWp'],'KWh')
.formatValueHtml($row['WHOUSE'] ,'KWh')
.formatValueHtml($row['WGRIDOUT'],'KWh')
.formatValueHtml($row['WGRIDIN'],'KWh')
.formatValueHtml($row['WBATOUT'],'KWh')
.formatValueHtml($row['WBATIN'],'KWh')
.formatValueHtml($row['rowM']['ertrag'],'kWh')
." \n";
} ?>
|
0) {
$vglSuedPV=($sued["sumrowM"]['ertragkWp'])?(NumToString( ($row["ertragPVkWp"]/$sued["sumrowM"]['ertragkWp'])*100)):"--";
}
?>
|
|
| Zeitraum | |
| | Jahr | Gesamt bis Monatsende |
| Photovoltaik Ertrag |
0) { ?>
| je kWp |
| System Abgabe |
| je kWp |
| Batterie Entnahme |
| Batterie Ladung |
| P Max | | W | |
| Zeitraum | W Photov. | je kWp | P max |
W Bat | W Lad. |
vgl. Süd | Tag |
".FormatDate($RowDate)."";
$T_Range=substr($row['TimeStart'],11,5)." - ".substr($row['TimeEnd'],11,5);
#$vglSued=($sued['tabrows'][$RowDate]['ertragkWp'])?(NumToString( ($row["ertragkWp"]/$sued['tabrows'][$RowDate]['ertragkWp'])*100)):"--";
$vglSued=($sued['tabrows'][$RowDate]['ertragPVkWp'])?(NumToString( ($row["ertragPVkWp"]/$sued['tabrows'][$RowDate]['ertragPVkWp'])*100)):"--";
$tab=$tab."| $T_Date | $T_Range | "
.formatValueHtml($row['ertragPV'],'KWh')
.formatValueHtml($row["ertragPVkWp"],'KWh')
.formatValueHtml($row['Pmax'],'W')
.(($group==1 || $group==3)?(
formatValueHtml($row['WBATOUT'],'kWh')
.formatValueHtml($row['WBATIN'],'kWh')):"")
.(($group !=2)?"".$vglSued."% | ":"")
.formatValueHtml($row['rowM']['ertragPV'],'kWh')
." \n";
} ?>
|
;?>)
|
|
Bitte auf das Datum klicken um eine Detailansicht des Tages zu erhalten.