<?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>

<!--

    </table>

    </form>

-->