<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 11/2012, 12/2013

 * 

 * Form Mitarbeiter/Objekte FHI

 */

	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");

	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();

    $okn = true;

    if (!$ma) 

    {

       $ma['geb'] = 'A';

       $ma['fhi'] = '1';

       $ma['abt'][0] = $dbc -> querySingleItem("SELECT abt_ID FROM Abteilung ORDER BY abt_ID+0 LIMIT 0,1");

       $ma['so'][0] = 1;

    }

?>

<div align="center">

<h5>* - Felder sind erforderlich!</h5>

</div>

<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_ma">

<div align="center"> 

<table width="65%" border="0" cellspacing="3" cellpadding="3">

    <tr>

        <td>

            <u>Mitarbeiter</u> FHI?

        </td>

        <td><select name="ma[fhi]" id="fhi" size="1" onchange="this.form.submit();" >

        <?php 

            $akt = array("0"=>"inaktiv","1"=>"aktiv","2"=>"Objekt","-1"=>"Gast");

            foreach ($akt as $key=>$value)

            {

                if ($ma['fhi'] == $key) $select = " selected='selected'"; else $select="";

                echo "<option$select value='$key'>$value</option>\n";

            } 

        ?> 

            </select>

        </td>    

    </tr>        

	<tr>

        <?php if ($ma["fhi"] == 2) echo "<td>Bezeichnung 1 *</td>\n";

	           else echo "<td>Name *</td>\n"; ?>

	   <td><input name="ma[name]" id="nname" type="text" size="30" maxlength="50" value="<?php echo $ma['name']; ?>" />

        <?php

			     if (isset($ma['name']) && $ma['name']<'!')

				{

					echo "<br><span class=\"red\">Name ist erforderlich!</span>\n";

					$okn = false;

				}

        ?>

        </td>

    </tr>

	<tr>

        <?php if ($ma["fhi"] == 2) echo "<td>Bezeichnung 2 </td>\n";

	           else echo "<td>Vorname </td>\n"; ?>

	   <td><input name="ma[vname]" id="vname" type="text" size="30" maxlength="50" value="<?php echo $ma['vname']; ?>" />

        <?php

		/*	     if (isset($ma['vname']) && $ma['vname']<'!')

				{

					echo "<br><span class=\"red\">Vorname ist erforderlich!</span>\n";

					$okn = false;

				}   */

        ?>

        </td>

    </tr>

    <?php if ($ma["fhi"] != 2) {   ?>   

	<tr>

	   <td>Titel</td>

	   <td><input name="ma[titel]" type="text" size="30" maxlength="30" value="<?php echo $ma['titel']; ?>" /></td>

    </tr>

    <?php } ?>

    <tr><td>Ort</td>

        <td valign="top">Haus&nbsp;

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

            <?php 

                if ($ma['geb'] == -1) $select = " selected "; else $select = "";

                echo "<option $select value=\"-1\"></option>\n";

                $sql = "SELECT geb_ID, geb_name FROM `fhiiqm`.`Haus` ORDER BY 1";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->geb_ID == $ma['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>

              Raum             

             <select name="ma[raum]">

            <?php 

                if ($ma['raum'] == -1) $select = " selected "; else $select = "";

                echo "<option $select value=\"-1\"></option>\n";

                $sql = "SELECT raum_ID, raum_nr, raum_name FROM `fhiiqm`.`Raum` WHERE geb_ID='" . $ma['geb'] ."' ORDER BY 2";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->raum_ID == $ma['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>

<?php

/*  // deaktiviert am 08.01.2013, Kaendler, Schwarzer

    echo

    "<tr>

        <td>Arbeitsgruppe</td>

        <td><select name=\"ma[rag]\">";

                if ($ma['rag'] == -1) $select = " selected "; else $select = "";

                echo "<option $select value=\"-1\"></option>\n";

                $sql = "SELECT rag_ID, rag_bez, abt_name FROM RaumArb_Gruppe g INNER JOIN Abteilung a 

                        ON g.abt_ID = a.abt_ID ORDER BY g.abt_ID,rag_ID";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->rag_ID == $ma['rag'])

                        {

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

                        }  

    				    else

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

                    }

            }

    echo

            "</select>

        </td>

    </tr>";

*/

?>

    <tr>

        <td>Telefon</td>

        <td><div id="addtel">

        <select name="ma[tel][]" size="1">

            <?php

                $select = null;

                $select = ( "-1"==$ma['tel'][0] ) ? " selected='selected'" : "";

                echo "<option $select value=\"-1\"></option>\n";

/*                $sql = "SELECT telefon_nr,geb_ID,raum_nr, telefon_typ FROM fhiiqm.Telefon t

                        LEFT OUTER JOIN Raum r ON t.raum_ID=r.Raum_ID 

                        ORDER BY telefon_nr";   */

                $sql = "SELECT telefon_nr, telefon_typ FROM fhiiqm.Telefon 

                        ORDER BY telefon_nr";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->telefon_typ == "fax") $teln = $row->telefon_nr." FAX"; else $teln = $row->telefon_nr;

//                        if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = "";

                        $select = ( $row->telefon_nr==$ma['tel'][0] ) ? " selected='selected'" : "";

    					echo "<option $select value=\"$row->telefon_nr\">$teln</option>\n";

//                        $tel .= "'".$row->telefon_nr. "':'" . $teln ."   ". $telr. "',";

                        $tel .= "'".$row->telefon_nr. "':'" . $teln . "',";

                    }

                }

                $tel = substr($tel,0,strlen($tel)-1);

            ?>

            </select>

            <script type="text/javascript">

            <!--

                arr = {<?php echo ($tel); ?>}; // Ergebnis: {key:'value',key:'value',...} 

            //-->

            </script>

            &nbsp;&nbsp;&nbsp;oder neu&nbsp;&nbsp;&nbsp;<input name="ma[ntel][]" type="text" size="20" maxlength="20" value="<?php echo $ma['ntel'][0]; ?>" />

            &nbsp;&nbsp;&nbsp;Priorit&auml;t&nbsp;&nbsp;&nbsp;<select name="ma[so][]" size="1">

            <?php

            $select = ($ma["so"][0] == '-1')? " selected='selected'" : "";

            echo "<option$select value=-1></option>\n";

            for ($i=1; $i<10; $i++)

            {

                $select=($ma["so"][0] == $i)? " selected='selected'" : "";

                echo "<option$select value=$i>$i</option>\n";

            }

            ?>

            </select>

            &nbsp;&nbsp;&nbsp;&ouml;ffentlich&nbsp;&nbsp;&nbsp;<input name="ma[pub][]" type="checkbox" value="1" <?php if ($ma['pub'][0]) echo "checked"; ?> />

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('addtel');" ?>" title="weitere Telefon-Nr."><img src="/fhiiqm/img/add.png" /></a>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('addtel');" ?>" title="l&ouml;schen letzte Telefon-Nr."><img src="/fhiiqm/img/delete.png" /></a><br />

            <?php

                if (isset($ma) && (!$ok || $sub))

                {

                    if (count($ma['ntel'])>1 || count($ma['tel'])>1)

                    {

                        $i=0;

                        foreach ($ma['tel'] as $atel)

                        {

                            if ($i>0)

                            {

                                echo "<span></span><select name=\"ma[tel][]\" size=\"1\">";

                                $select = ( "-1" == $atel ) ? ' selected' : null;

                                echo "<option $select value=\"-1\"></option>\n";

                                foreach ($result as $row)

                                {

                                    if ($row->telefon_typ == "fax") $teln = $row->telefon_nr." FAX"; else $teln = $row->telefon_nr;

//                                    if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = "";

                                    $select = ( $row->telefon_nr == $atel ) ? ' selected' : null;

                					echo "<option $select value=\"$row->telefon_nr\">$teln</option>\n";

                                }

                                echo "</select>";

                                echo "&nbsp;&nbsp;&nbsp;&nbsp;oder neu&nbsp;&nbsp;&nbsp;<input name=\"ma[ntel][]\" type=\"text\" size=\"20\" maxlength=\"20\" value=\"".$ma['ntel'][$i]."\" />";

                                echo "&nbsp;&nbsp;&nbsp;&nbsp;Priorit&auml;t&nbsp;&nbsp;&nbsp;<select name=\"ma[so][]\" size=\"1\">";

                                $select = ( $ma["so"][$i] == "-1" ) ? " selected='selected'" : "";

                                echo "<option$select value=\"-1\"></option>\n";

                                for ($j=1; $j<10; $j++)

                                {

                                    $select=($ma["so"][$i] == $j)? " selected='selected'" : "";

                                    echo "<option$select value=$j>$j</option>\n";

                                }

                                echo "</select>\n";

                                echo "&nbsp;&nbsp;&nbsp;&ouml;ffentlich&nbsp;&nbsp;&nbsp;<input name=\"ma[pub][$i]\" type=\"checkbox\" value=\"1\""; 

                                $check = ($ma['pub'][$i]) ? " checked='checked'" : "" ;

                                echo "$check /><br />\n";

                            }

                            $i++;

                        }

                    }

                }

        ?>

        </div>

        </td>   

    </tr>

    <?php if ($ma["fhi"]) {   ?>   

	<tr>

	   <td>E-Mail</td>

	   <td><input name="ma[email]" id="email" type="text" size="30" maxlength="100" value="<?php echo $ma['email']; ?>" /></td>

    </tr>

    <?php } ?>

    <tr><td>Abteilung *</td>

        <td valign="top"><div id="addabt">

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

            <?php 

                $sql = "SELECT abt_ID, abt_name, abt_long FROM `fhiiqm`.`Abteilung` ORDER BY abt_ID+0";

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

                {

                    foreach ($result as $row)

                    {

                        if ($row->abt_ID == $ma['abt'][0])

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

    				    else

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

                        $abt .= "'".$row->abt_ID. "':'" . $row->abt_name .": ". $row->abt_long . "',";

                    }

                    $abt = substr($abt,0,strlen($abt)-1);

                }

            ?>

            </select>

              

        Arbeitsgruppe   

             <select name="ma[rag][]">

            <?php 

                if ($ma['rag'] == -1) $select = " selected "; else $select = "";

                echo "<option $select value=\"-1\"></option>\n";

                $sql = "SELECT rag_ID, rag_bez FROM `fhiiqm`.`RaumArb_Gruppe` WHERE abt_ID = " .$ma["abt"][0] . " ORDER BY rag_bez";

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

                {

                    foreach ($resrag as $row)

                    {

                        if ($row->rag_ID == $ma['rag'][0])

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

    				    else

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

//                        $rag .= "'".$row->rag_ID. "':'" . $row->rag_bez . "',";

                    }

//                    $rag = substr($rag,0,strlen($rag)-1);

                }

                $sql = "SELECT rag_ID, rag_bez, abt_name, g.abt_ID FROM RaumArb_Gruppe g INNER JOIN Abteilung a 

                        ON g.abt_ID = a.abt_ID ORDER BY g.abt_ID,rag_ID";

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

                {

                    foreach ($res as $row)

                    {

                        $faktor = ($row->abt_ID*1000)+$row->rag_ID; // wegen sort nach Abt. fuer JS, z.B. 7047

                        $rag .= "'".$faktor. "':'" . $row->abt_name . ": ". $row->rag_bez . "',";

                    }    

                    $rag = substr($rag,0,strlen($rag)-1);

                }

            ?>

            </select>

            <script type="text/javascript">

            <!--

                arra = {<?php echo ($abt); ?>}; // Ergebnis: {key:'value',key:'value',...} 

                arrg = {<?php echo ($rag); ?>}; // Ergebnis: {key:'value',key:'value',...} 

            //-->

            </script>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('addabt');" ?>" title="weitere Arbeitsgruppe"><img src="/fhiiqm/img/add.png" /></a>

            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('addabt');" ?>" title="l&ouml;schen letzte Arbeitsgruppe"><img src="/fhiiqm/img/delete.png" /></a><br />

            <?php

                if (isset($ma) && (!$ok || $sub))

                {

                    if (count($ma['abt'])>1 || count($ma['rag'])>1)

                    {

                        $i=0;

                        foreach ($ma['abt'] as $eabt)

                        {

                            if ($i>0)

                            {

                                echo "<span></span><select name=\"ma[abt][]\" size=\"1\">";

                                foreach ($result as $row)

                                {

                                    $select = ( $row->abt_ID == $eabt ) ? ' selected' : null;

                					echo "<option $select value=\"$row->abt_ID\">$row->abt_name: $row->abt_long</option>\n";

                                }

                                echo "</select>";

                                echo "     Arbeitsgruppe    ";

                                echo "<select name='ma[rag][]' size=1>";

                                $select = ( $ma["rag"][$i] == "-1" ) ? " selected='selected'" : "";

                                echo "<option$select value=\"-1\"></option>\n";

                                foreach ($res as $row)

                                {

                                    $select = ( $row->rag_ID == $ma['rag'][$i] ) ? ' selected' : null;

                					echo "<option $select value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n";

                                }

                                echo "</select>";

                                echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' /><br />\n";

                            }

                            $i++;

                        }

                    }

                }

            ?>

            </div>

        </td>   

    </tr>

<?php

                if ($ma["tstmp"] && $ma["tstmp"]>0)

                {

                    echo "<tr><td>letzte &Auml;nderung</td>";

                    $ts = new DateTime($ma["tstmp"]);    

                    echo "<td>".$ts->format('d.m.Y H:i:s');   

                }

                if (isset($ma["uid"]) && $ma["uid"]) 

                    echo "   (".$ma["uid"] .")";

                echo "</td></tr>\n"; 

?>

            <input type="hidden" name="ma[abtm]" value="<?php echo $ma['abtm']; ?>" />

            <input type="hidden" name="okn" value="<?php echo $okn; ?>" />

<!--

</table>

 </div>   

</form>       

-->