<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 06/2012
 * 
 * Form RaumArb_Gruppe Raum, Mitarbeiter
 * 
 */

	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_rag" target="_self">
    <div align="center"> 	
    <table width="45%" border="0" cellspacing="3" cellpadding="3">
    <tr>
        <td width="20%">Raum-Arbeits-Gruppe *</td>        
        <td>
            <select name="rag[gr]" size="1">
            <?php
                $select = null;
                $sql = "SELECT rag_ID, rag_bez, abt_name FROM fhiiqm.RaumArb_Gruppe r LEFT OUTER JOIN Abteilung a ON r.abt_ID=a.abt_ID ORDER BY 3,2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        $select = ( $row->rag_ID==$rag['gr'] ) ? ' selected' : null;
    					echo "<option $select value=\"$row->rag_ID\">$row->rag_bez ($row->abt_name)</option>\n";
                    }
                }
            ?>
            </select>
        </td>   
    </tr>
    <tr>
        <td>zugeh&ouml;rige R&auml;ume *
            <br />&nbsp;&nbsp;&nbsp;leeres Feld = L&ouml;schen
        </td>        
        <td>
        <div id="addr">
            <select name="rag[ra][]" size="1">
            <?php
                $select = null;
                $select = ( "-1"==$rag['ra'][0] ) ? ' selected' : null;
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID FROM Raum ORDER BY geb_ID,raum_nr";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        $select = ( $row->raum_ID==$rag['ra'][0] ) ? ' selected' : null;
    					echo "<option $select value=\"$row->raum_ID\">$row->geb_ID: $row->raum_nr - $row->raum_name</option>\n";
                        $sra .= "'".$row->raum_ID."':'".$row->geb_ID.": ".$row->raum_nr. " - " .$row->raum_name."',";
                    }
                }
                $sra = substr($sra,0,strlen($sra)-1);
            ?>
            ?>
            </select>
            <script type="text/javascript">
            <!--
                arr = {<?php echo ($sra); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
            //-->
            </script>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('addr',arr);" ?>" title="weiterer Raum"><img src="/fhiiqm/img/add.png" /></a>
            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('addr');" ?>" title="l&ouml;schen letzten Raum"><img src="/fhiiqm/img/delete.png" /></a>
        <?php
            if ($ragid || ($sub && isset($rag) && !$ok))
            {
                if (count($rag['ra'])>1)
                {
                    $i=0;
                    foreach ($rag['ra'] as $rae)
                    {
                        if ($i>0)
                        {
                            echo "<select name=\"rag[ra][]\" size=\"1\">";
            
                            $select = ( "-1" == $rae ) ? ' selected' : null;
                            echo "<option $select value=\"-1\"></option>\n";
                            foreach ($result as $row)
                            {
                                $select = ( $row->raum_ID == $rae ) ? ' selected' : null;
            					echo "<option $select value=\"$row->raum_ID\">$row->geb_ID: $row->raum_nr - $row->raum_name</option>\n";
                            }
                            echo "</select><br/>\n";
                        }
                        $i++;
                    }
                }
            }
        ?>
        </div>
        </td>   
    </tr>
    <tr>
        <td>zugeh&ouml;rige Mitarbeiter *
            <br />&nbsp;&nbsp;&nbsp;leeres Feld = L&ouml;schen
        </td>        
        <td>
        <div id="addm">
            <select name="rag[ma][]" size="1">
            <?php
                $select = null;
                $select = ( "-1"==$rag['ma'][0] ) ? ' selected' : null;
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') AS ma
                 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        $select = ( $row->persknr==$rag['ma'][0] ) ? ' selected' : null;
    					echo "<option $select value=\"$row->persknr\">$row->ma</option>\n";
                        $sma .= "'".$row->persknr."':'".$row->ma."',";
                    }
                }
                $sma = substr($sma,0,strlen($sma)-1);
            ?>
            ?>
            </select>
            <script type="text/javascript">
            <!--
                arm = {<?php echo ($sma); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
            //-->
            </script>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('addm',arm);" ?>" title="weiterer MA"><img src="/fhiiqm/img/add.png" /></a>
            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('addm');" ?>" title="l&ouml;schen letzten MA"><img src="/fhiiqm/img/delete.png" /></a>
        <?php
            if ($ragid || ($sub && isset($rag) && !$ok))
            {
                if (count($rag['ma'])>1)
                {
                    $i=0;
                    foreach ($rag['ma'] as $mae)
                    {
                        if ($i>0)
                        {
                            echo "<select name=\"rag[ma][]\" size=\"1\">";
            
                            $select = ( "-1" == $mae ) ? ' selected' : null;
                            echo "<option $select value=\"-1\"></option>\n";
                            foreach ($result as $row)
                            {
                                $select = ( $row->persknr == $mae ) ? ' selected' : null;
            					echo "<option $select value=\"$row->persknr\">$row->ma</option>\n";
                            }
                            echo "</select><br/>\n";
                        }
                        $i++;
                    }
                }
            }
        ?>
        </div>
        </td>   
    </tr>
<!--
    </table>
    </form>
-->