<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 4/2012
 * 
 * Form Raum - Arbeitsplatztyp
 * 
 */

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

?>
    <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_info" target="_self">
    <div align="center"> 	
    <table width="45%" border="0" cellspacing="3" cellpadding="3">
    <tr>
        <td width="30%">Haus *</td>
        <td><select name="ap[geb]" onchange="this.form.submit();">
            <?php 
                $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->geb_ID == $ap['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>
        </td>
    </tr>
    <tr>
        <td>Raum *</td>
        <td><select name="ap[raum]">
            <?php 
                if (!isset($ap) && !$ap['geb']) $ap['geb'] = "A";
                $sql = "SELECT raum_ID, raum_nr, raum_name FROM Raum WHERE geb_ID = '". $ap['geb']."' ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->raum_ID == $ap['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>Arbeitsplatztyp *
            <br />&nbsp;&nbsp;&nbsp;Hinzufügen weiterer<br />&nbsp;&nbsp;&nbsp;Typen mit '+'
        </td>        
        <td>
        <div id="add">
            <select name="ap[aptyp][]" size="1">
            <?php
                $select = null;
                $select = ( "-1"==$ap['aptyp'][0] ) ? ' selected' : null;
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT arbplatz_typ, arbplatz_typ_bez FROM fhiiqm.Arbplatz_Typ ORDER BY 1";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        $select = ( $row->arbplatz_typ==$ap['aptyp'][0] ) ? ' selected' : null;
    					echo "<option $select value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
                        $apt .= "'".$row->arbplatz_typ."':'".$row->arbplatz_typ_bez."',";
                    }
                }
                $apt = substr($apt,0,strlen($apt)-1);
            ?>
            </select>
            <script type="text/javascript">
            <!--
                arr = {<?php echo ($apt); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
            //-->
            </script>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('add');" ?>" title="weiterer Arbeitsplatztyp"><img src="/fhiiqm/img/add.png" /></a>
            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('add');" ?>" title="l&ouml;schen letzten Arbeitsplatztyp"><img src="/fhiiqm/img/delete.png" /></a>
        <?php
            if ($apid || ($sub && isset($ap) && !$ok))
            {
                if (count($ap['aptyp'])>1)
                {
                    $i=0;
                    foreach ($ap['aptyp'] as $apte)
                    {
                        if ($i>0)
                        {
                            echo "<select name=\"ap[aptyp][]\" size=\"1\">";
            
                            $select = ( "-1" == $apte ) ? ' selected' : null;
                            echo "<option $select value=\"-1\"></option>\n";
                            foreach ($result as $row)
                            {
                                $select = ( $row->arbplatz_typ == $apte ) ? ' selected' : null;
            					echo "<option $select value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
                            }
                            echo "</select><br/>\n";
                        }
                        $i++;
                    }
                }
            }
        ?>
        </div>
        </td>   
    </tr>
    <tr>
        <td>Bemerkung</td>
        <td><textarea name="ap[bem]" cols="80" rows="10"><?php echo $ap['bem']; ?></textarea>
		<div>max. 800 Zeichen sind m&ouml;glich</div></td>
    </tr>
<!--
    </table>
    </form>
-->