<?
/*
 * index.php:
 * responsible for menu, client-side calculations, inserting iframe
 *
 * (c) 2008 alexander.philipp.lintenhofer
*/
 
    require_once("_includes/db_handle.php");         // wrapper-functions for mysql (not included)
    require_once("_includes/globals.inc.php");
    require_once("_includes/arrWPmenu.inc.php");
    require_once("_includes/arrLineValues.inc.php");

    $arrQ = wrapper_single_query("SELECT m_0500 AS uhrzeit,m_0501 AS datum, m_0800 AS unterbrechungen, m_0801 AS warnungenEingang, m_0802 AS warnungenAusgang, m_0803 AS warnungenSonstige, m_0804 AS ausfaelle, m_0805 AS fuehlerausfall, m_0806 AS fuehlerkurzschluss, m_0900 AS betriebszustand, m_0910 AS heizung, m_0912 AS WW FROM $db_getTable ORDER BY id DESC LIMIT 1");

    $imgHzg = ($arrQ['betriebszustand'] & 0x02)?'info1.jpg':'info0.jpg';
    $imgWW  = ($arrQ['betriebszustand'] & 0x01)?'info1.jpg':'info0.jpg';

    for($i=0,$currByte=bindec($arrQ['heizung']);$i<8;$i++,$currByte>>=1)
        if ($currByte&0x01) $statusHzg .= $arrHeizung[$i]."\n"; 

    for($i=0,$currByte=bindec($arrQ['WW']);$i<8;$i++,$currByte>>=1)
        if ($currByte&0x01) $statusWW .= $arrWW[$i]."\n"; 

    $imgWarning = 'warn0.jpg'; 
    for($i=0,$currByte=bindec($arrQ['unterbrechungen']);$i<count($arrUnterbrechungen);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgWarning = 'warn1.jpg';
    for($i=0,$currByte=bindec($arrQ['warnungenEingang']);$i<count($arrWarnungenEingang);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgWarning = 'warn1.jpg';
    for($i=0,$currByte=bindec($arrQ['warnungenAusgang']);$i<count($arrWarnungenAusgang);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgWarning = 'warn1.jpg';
    for($i=0,$currByte=bindec($arrQ['warnungenSonstige']);$i<count($arrWarnungenSonstige);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgWarning = 'warn1.jpg';

    $imgFail = 'fail0.jpg'; 
    for($i=0,$currByte=bindec($arrQ['ausfaelle']);$i<count($arrAusfaelle);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgFail = 'fail1.jpg';
    for($i=0,$currByte=bindec($arrQ['fuehlerausfall']);$i<count($arrFuehlerausfall);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgFail = 'fail1.jpg';
    for($i=0,$currByte=bindec($arrQ['fuehlerkurzschluss']);$i<count($arrFuehlerkurzschluss);$i++,$currByte>>=1)
        if ($currByte&0x01) $imgFail = 'fail1.jpg';

    $currYear  = intval(substr($arrQ['datum'],0,4));
    $currMonth = intval(substr($arrQ['datum'],5,2));
    $lastMonth = ($currMonth==1)?12:$currMonth-1;
    $lastYear  = (($currMonth==1)?($currYear-1):$currYear);

    $currMonthTLink = 'operating_d.php?month='.$currMonth.'&amp;year='.$currYear;
    $lastMonthTLink = 'operating_d.php?month='.$lastMonth.'&amp;year='.$lastYear;

    $currMonthELink = 'energy_d.php?month='.$currMonth.'&amp;year='.$currYear;
    $lastMonthELink = 'energy_d.php?month='.$lastMonth.'&amp;year='.$lastYear;

    $currMonthSLink = 'stats_d.php?month='.$currMonth.'&amp;year='.$currYear;
    $lastMonthSLink = 'stats_d.php?month='.$lastMonth.'&amp;year='.$lastYear;

    $currMonthTLinkName = 'T';
    $lastMonthTLinkName = 'T';
    $currMonthELinkName = 'E';
    $lastMonthELinkName = 'E';
    $currMonthSLinkName = 'S';
    $lastMonthSLinkName = 'S';
?>
<html>
<head>
    <title>W&auml;rmepumpen-Monitor</title>
    <meta name="author" content="Alexander Philipp Lintenhofer">
    <meta name="robots" content="noindex">
    <meta http-equiv="imagetoolbar" content="no">
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
    <link rel="shortcut icon" type="image/x-icon" href="favicon.ico">
    <link rel="stylesheet" href="css/styles.css" type="text/css">
    <script type="text/javascript" language="javascript" src="_includes/navitimer.js"></script>
    <script type="text/javascript" language="javascript" src="_includes/functions.js"></script>
</head>
<body onLoad="javascript:initForm();" id='naviframe'>
<div id="frame">
    <div id="container">
        <div id="navigation">
            <ul id="statusdata">
                <li><a href='#' onClick="javascript:link2infocontent(this,'overview.php');" target="inhalt">Flie&szlig;schema</a></li>
                <li><a href='#' onClick="javascript:link2infocontent(this,'status.php');" target="inhalt">Status</a></li>
                <li><a href='#' onClick="javascript:link2infocontent(this,'warnings.php');" target="inhalt">Warn</a></li>
                <li><a href='#' onClick="javascript:link2infocontent(this,'table.php');" target="inhalt">Daten</a></li>
            </ul>
            <ul id="servicedata">
                <li><a href='#' onClick="javascript:return link2servicecontent(this,'heizkurve.php');" target="inhalt">Heizkurve</a></li>
            </ul>
            <ul id="graphs">
                <li><a href='#' onClick="javascript:link2graph(this,0);" target="inhalt">Hzg/WW</a></li>
                <li><a href='#' onClick="javascript:link2graph(this,1);" target="inhalt">WQ e/a</a></li>
                <li><a href='#' onClick="javascript:link2graph(this,2);" target="inhalt">Vorl./Kond.</a></li>
                <li><a href='#' onClick="javascript:link2graph(this,3);" target="inhalt">WQaus/Verd.</a></li>
                <li><a href='#' onClick="javascript:link2graph(this,4);" target="inhalt">Wirk</a></li>
                <li><a href='#' onClick="javascript:link2dyngraph(this);" onMouseOver="showLinevaluesfields(true);" target="inhalt">dynGraph</a></li>
            </ul>

            <ul id="statistics">

                <li><a href='#' onClick="javascript:link2statisticcontent(this,'<?= $lastMonthTLink ?>');" target="inhalt" title="Betriebsstunden <?= $lastMonth.'/'.$lastYear ?>"><?= $lastMonthTLinkName ?></a></li>
                <li><a href='#' onClick="javascript:link2statisticcontent(this,'<?= $lastMonthELink ?>');" target="inhalt" title="Stromverbrauch <?= $lastMonth.'/'.$lastYear ?>"><?= $lastMonthELinkName ?></a></li>
                <li><a href='#' onClick="javascript:link2statisticcontent(this,'<?= $lastMonthSLink ?>');" target="inhalt" title="Stundenstatistik <?= $lastMonth.'/'.$lastYear ?>"><?= $lastMonthSLinkName ?></a></li>
                <li><a href='#' onClick="javascript:link2statisticcontent(this,'<?= $currMonthTLink ?>');" target="inhalt" title="Betriebsstunden <?= $currMonth.'/'.$currYear ?>"><?= $currMonthTLinkName ?></a></li>
                <li><a href='#' onClick="javascript:link2statisticcontent(this,'<?= $currMonthELink ?>');" target="inhalt" title="Stromverbrauch <?= $currMonth.'/'.$currYear ?>"><?= $currMonthELinkName ?></a></li>
                <li><a href='#' onClick="javascript:link2statisticcontent(this,'<?= $currMonthSLink ?>');" target="inhalt" title="Stundenstatistik <?= $currMonth.'/'.$currYear ?>"><?= $currMonthSLinkName ?></a></li>
                <li><a href='#' onClick="javascript:link2statisticcontent(this,'operating_m.php');" target="inhalt" title="Betriebsstunden und Stromverbrauch letzte 12 Monate">12 M</a></li>
            </ul>
            <a href='manual.pdf' target="inhalt"><img src="img/pdf.gif" width="14" height="16" border="0" alt="Bedienungsanleitung &ouml;ffnen" title="Bedienungsanleitung &ouml;ffnen"></a>
        </div>
        <div style="clear:left;"></div>
        <div id="icons">
            <a href="#" onClick="javascript:insertNowDate2Form(); resetForm(); this.href=currfile" target="inhalt"><img src='img/reset.png' border='0' alt='reset' title='reset'></a>
        </div>
        <form name='naviform' id='naviform'>
            <input type='text' name='startdd' size=1 maxlength=2 onFocus='javascript:changeDirection()' />.
            <input type='text' name='startmm' size=1 maxlength=2 onBlur="javascript:formatEntries()" onFocus='javascript:changeDirection()' />.
            <input type='text' name='startyy' size=3 maxlength=4 onBlur="javascript:formatEntries()" onFocus='javascript:changeDirection()' />,
            <input type='text' name='starthh' size=1 maxlength=2 onBlur="javascript:formatEntries()" onFocus='javascript:changeDirection()' />:
            <input type='text' name='startmin' size=1 maxlength=2 onBlur="javascript:formatEntries()" onFocus='javascript:changeDirection()' />
            <span id='durationfields'>
                <span id='durationdesc' class='formtext'>letzte</span>
                <input type='text' name='ticks' size=2 maxlength=3 />&nbsp;
                <span id="radiobuttons">
                    <input type='radio' name='granularity' value='1' /><span class='formtext'>&nbsp;Minuten&nbsp;</span>
                    <input type='radio' name='granularity' value='60' /><span class='formtext'>&nbsp;Stunden&nbsp;</span>
                    <input type='radio' name='granularity' value='1440' /><span class='formtext'>&nbsp;Tage</span>
                </span>
            </span>
            <span id='heatersettings' class='formtext'>
                Vergleichskurve:&nbsp;
                Einsatztemperatur:<input type='text' name='tempeinsatz' id='tempeinsatz' size=2 maxlength=2 />°&nbsp;
                Basis-Soll:<input type='text' name='basissoll' id='tempbasissoll' size=2 maxlength=4 />°&nbsp;
                Steilheit:<input type='text' name='steilheit' name='steilheit' size=2 maxlength=4 />%
                <span id='setvalicon'>
                    <a href='#' onClick='javascript:return setValsfromSimCurve(this)' target='inhalt'><img src="img/val2wp.png" border=0 alt="Werte in die Wärmepumpe übernehmen" title="Werte in die Wärmepumpe übernehmen"></a>
                </span>
            </span>
            <div id='linevalues' class='formtext' style="position:absolute; top: 21px; left: 630px;" onMouseOver="showLinevaluesfields(true);" onMouseOut="showLinevaluesfields(false);">
                <select name='selectedlinevalues' multiple size=<?= count($arrLineValues) ?>>
<?
    foreach ($arrLineValues as $key => $val)
        echo '<option value="'.$key.'">'.$val['attribute']."</option>\n";
?>
                </select>
            </div>
        </form>
    </div>
    <div id="statuslayer">
        <table><tr><td><img src='img/<?= $imgHzg ?>' alt='<?= $statusHzg ?>' title='<?= $statusHzg ?>'></td><td><img src='img/<?= $imgWW ?>' alt='<?= $statusWW ?>' title='<?= $statusWW ?>'></td></tr><tr><td><img src='img/<?= $imgWarning ?>'></td><td><img src='img/<?= $imgFail ?>'></td></tr></table>
    </div>
</div>

<iframe src="overview.php" width=980 height=530 marginheight="0" marginwidth="0" frameborder="0" name="inhalt">

</iframe>

</body>
</html>
