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

-->