<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 09/2011

 */

?>

<div align="center">

<table>

<tr><td class="bigger">Die Auswahl eines Mitarbeiters geschieht durch<br />Eingeben von mindesten 2 Zeichen in das Mitarbeiter-Feld.

</td></tr>

<tr><td class="bigger"><div class="red">Achtung! </div>Umlaute wie '&auml;', '&uuml;', '&ouml;', '&szlig;' werden nicht gefunden, bitte benachbarte Zeichen eingeben.</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="fmafkt"> 

<div align="center">

    <table border="0" cellspacing="3" cellpadding="3">

<!--        <div class="ui-widget"> -->

        <tr><td>Mitarbeiter *</td>

            <td valign="top"><input class="long20" type="text" name="fkt[persknr]" id="persknr" value="<?php echo $fkt['persknr']; ?>"/>

            </td>

        </tr>

        <tr><td>Funktion *</td>

            <td valign="top">

                <!--<input class="long20" type="text" name="fkt[func]" id="func" value="<?php echo $fkt['func']; ?>"/> -->

                <select name="fkt[func]" onchange="this.form.submit();">

                <?php 

                    $sql = "SELECT fkt_bez, fkt_ID FROM `fhiiqm`.`Funktion` ORDER BY 1";

                    if ($result = $dbc->queryObjectArray($sql))

                    {

                        foreach ($result as $row)

                        {

                            if ($row->fkt_ID == $fkt['func'])

        					   echo "<option selected value=\"$row->fkt_ID\">$row->fkt_bez</option>\n";

        				    else

        					   echo "<option value=\"$row->fkt_ID\">$row->fkt_bez</option>\n";

                        }

                }

                ?>

                </select>            

            </td>

        </tr>

        <td valign="top">

        <?php

            if (isset($fkt['func']) && $fkt["func"]=='AL')

            {

                echo "<select name='fkt[ber]'>\n";

                $sql = "SELECT  abt_ID,abt_name,abt_long FROM `fhiiqm`.`Abteilung`";

                if ($result = $dbc->queryObjectArray($sql))

                {

                    foreach ($result as $row)

                    {

                        if ($row->abt_name == $fkt['ber'])

    					   echo "<option selected value=\"$row->abt_name\">$row->abt_name</option>\n";

    				    else

    					   echo "<option value=\"$row->abt_name\">$row->abt_name</option>\n";

                    }

                }

                echo "</select>";

            }

            elseif (isset($fkt['func']) && $fkt["func"]=='AGL')

            {

                echo "<select name='fkt[ber]'>\n";

                $sql = "SELECT ag_name, abt_name FROM `fhiiqm`.`Arbeitsgruppe` ag INNER JOIN fhiiqm.Abteilung a

                        ON ag.abt_ID=a.abt_ID ORDER BY ag.abt_ID, ag_ID";

                if ($result = $dbc->queryObjectArray($sql))

                {

                    foreach ($result as $row)

                    {

                        if ($row->ag_name == $fkt['ber'])

    					   echo "<option selected value=\"$row->ag_name\">$row->ag_name, $row->abt_name</option>\n";

    				    else

    					   echo "<option value=\"$row->ag_name\">$row->ag_name, $row->abt_name</option>\n";

                    }

                }

                echo "</select>";

            }

            else

            {

        ?>

            <input class="long20" type="text" name="fkt[ber]" id="ber" maxlength="50" value="<?php echo $fkt['ber']; ?>" onfocus="this.select();"/>

        <?php } ?>   

            </td>

        </tr>

        <tr><td>Beginn</td>

            <td valign="top"><input class="long10" type="text" name="fkt[von]" id="von" value="<?php echo $fkt['von']; ?>"/>

            </td>

        </tr>

        <tr><td>Ende</td>

            <td valign="top"><input class="long10" type="text" name="fkt[bis]" id="bis" value="<?php echo $fkt['bis']; ?>"/>

            </td>

        </tr>

        <tr><td>Bemerkung</td>

            <td valign="top"><textarea name="fkt[bem]" id="bem" rows="3" cols="33"><?php echo $fkt['bem']; ?></textarea>

            </td>

        </tr>

        <?php

        if (!is_null($_SESSION["recht"]) && in_array("fme",$_SESSION["recht"]))

        {

        ?>

           	<tr><td>&nbsp;</td>

            	<td><input  class="button" type="submit" name="eintragen" value="  eintragen  " /></td>

           	</tr>

        <?php

        }

        ?>

<!--         </div> -->

    </table>

    <input type="hidden" name="fkt[pid]" id="pid" value="<?php echo $fkt['pid']; ?>"/>

    <input type="hidden" name="fkt[fid]" id="fid" value="<?php echo $fkt['fid']; ?>"/>

<?php

    echo "</div>\n";

    if (!is_null($_SESSION["recht"]) && !in_array("fme", $_SESSION["recht"]))

        echo "<p>&nbsp;&nbsp;&nbsp;<a href=\"ma_fkt_flist.php\" target=\"_self\" title=\"Funktionen\">&laquo; zur Funktionenliste</a></p>\n"; 

    echo "</form>\n";   

?>