<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 11/2011
 * 
 * Form Anlage
 */

	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
    $okn = true;
    if (!$al["geb"]) $al["geb"]="A";

?>
<div align="center">
<table>
<tr><td class="bigger">Die Auswahl eines Verantwortlichen geschieht durch Eingeben von<br />mindesten 2 Zeichen in das 'Verantwortlicher'-Feld.
</td></tr>
<tr><td class="bigger">&nbsp;</td></tr>
</table>
</div>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="fanl"> 
<div align="center">
    <table border="0" cellspacing="3" cellpadding="3">
<!--        <div class="ui-widget"> -->
        <tr><td>Anlagenbezeichnung *</td>
            <td valign="top"><input type="text" name="al[bez]" id="albez" size="50" maxlength="50" value="<?php echo $al['bez']; ?>"/>
            <?php 
			     if (isset($al['bez']) && $al['bez']<'!')
				{
					echo "<br><span class=\"red\">Anlagenbezeichnung ist erforderlich!</span>\n";
					$okn = false;
				}
				else
					if ($okn) $okn = true; else $okn=false;
             ?> 
            </td>
        </tr>
        <tr><td>Anlagenbeschreibung</td>
            <td><textarea name="al[beschr]" cols="50" rows="5"><?php echo $al['beschr']; ?></textarea></td>
        </tr>
        <tr><td>Kategorie</td>
            <td valign="top">
                 <select name="al[kat]" onchange="this.form.submit();">
                <?php 
                    if ($al['kat'] == -1) $select = " selected "; else $select = "";
                    if (isset($kat) && $kat)
                        $wher = " WHERE al_kat_ID = $kat"; 
                    else
                    { 
                        $wher = "";
                        echo "<option $select value=\"-1\"></option>\n";
                    }    
                    $sql = "SELECT al_kat_bez, al_kat_ID FROM `fhiiqm`.`A_Kategorie` $wher ORDER BY 2";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {   if (strlen($row->al_kat_ID) == 1) $katid =  "&nbsp;" . $row->al_kat_ID; else $katid = $row->al_kat_ID; 
                            if ($row->al_kat_ID == $al['kat'])
        					   echo "<option selected value=\"$row->al_kat_ID\">$katid: $row->al_kat_bez</option>\n";
        				    else
        					   echo "<option value=\"$row->al_kat_ID\">$katid: $row->al_kat_bez</option>\n";
                        }
                }
                ?>
                </select>            
            </td>
        </tr>
     <?php 
//        if ($al["kat"] != 6) // Gasflaschen
        {
     ?>       
        <tr><td>Bef&auml;higungsgrad</td>
            <td valign="top">
                 <select name="al[befg]">
                <?php 
                    if ($al['befg'] == -1) $select = " selected "; else $select = "";
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT al_befgrad_bez, al_befgrad_ID FROM `fhiiqm`.`A_BefGrad` ORDER BY 1";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            if ($row->al_befgrad_ID == $al['befg'])
        					   echo "<option selected value=\"$row->al_befgrad_ID\">$row->al_befgrad_bez</option>\n";
        				    else
        					   echo "<option value=\"$row->al_befgrad_ID\">$row->al_befgrad_bez</option>\n";
                        }
                }
                ?>
                </select>            
            </td>
        </tr>
        <tr><td>Pr&uuml;fart</td>
            <td valign="top">
                 <select name="al[part]">
                <?php 
                    if ($al['part'] == -1) $select = " selected "; else $select = "";
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT al_pruefart_bez, al_pruefart_ID FROM `fhiiqm`.`A_PruefArt` ORDER BY 1";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            if ($row->al_pruefart_ID == $al['part'])
        					   echo "<option selected value=\"$row->al_pruefart_ID\">$row->al_pruefart_bez</option>\n";
        				    else
        					   echo "<option value=\"$row->al_pruefart_ID\">$row->al_pruefart_bez</option>\n";
                        }
                }
                ?>
                </select>            
            </td>
        </tr>
        <tr><td>Pr&uuml;fintervall</td>
            <td valign="top">
                 <select name="al[pintv]">
                <?php 
                    if ($al['pintv'] == -1) $select = " selected "; else $select = "";
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT al_pruefintv_bez, al_pruefintv_ID FROM `fhiiqm`.`A_PruefIntv` ORDER BY 2";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            if ($row->al_pruefintv_ID == $al['pintv'])
        					   echo "<option selected value=\"$row->al_pruefintv_ID\">$row->al_pruefintv_bez</option>\n";
        				    else
        					   echo "<option value=\"$row->al_pruefintv_ID\">$row->al_pruefintv_bez</option>\n";
                        }
                }
                ?>
                </select>            
            </td>
        </tr>
     <?php
        }
     ?>
        <tr><td>Standort</td>
            <td valign="top">Haus&nbsp;
                 <select name="al[geb]" onchange="this.form.submit();">
                <?php 
                    $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            if ($row->geb_ID == $al['geb'])
        					   echo "<option selected value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n";
        				    else
        					   echo "<option value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n";
                        }
                }
                ?>
                </select>
                &nbsp;&nbsp;Raum&nbsp;            
                 <select name="al[raum]">
                <?php 
                    if ($al['raum'] == -1) $select = " selected "; else $select = "";
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT raum_ID, raum_nr, raum_name FROM `fhiiqm`.`Raum` WHERE geb_ID='" . $al['geb'] ."' ORDER BY 2";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            if ($row->raum_ID == $al['raum'])
        					   echo "<option selected value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
        				    else
        					   echo "<option value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
                        }
                }
                ?>
                </select>
            </td>
        </tr>
        <tr><td>Verantwortlicher</td>
            <td valign="top"><input class="long20" type="text" name="al[persknr]" id="persknr" value="<?php echo $al['persknr']; ?>"/>
            </td>
        </tr>
    <input type="hidden" name="al[pid]" id="pid" value="<?php echo $al['pid']; ?>"/>
    <input type="hidden" name="al[okn]" value="<?php echo $okn; ?>"/>