<?php
/**
* @author Bettina Schwarzer, Fritz-Haber-Institut
* @copyright 11/2012
*
* 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';
?>
<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="60%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td>Name *</td>
<td><input name="ma[name]" type="text" size="30" maxlength="30" 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>
<td>Vorname</td>
<td><input name="ma[vname]" type="text" size="30" maxlength="30" 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>
<tr>
<td>Titel</td>
<td><input name="ma[titel]" type="text" size="30" maxlength="30" value="<?php echo $ma['titel']; ?>" /></td>
</tr>
<tr><td>Ort</td>
<td valign="top">Haus
<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>
<tr>
<td>Telefon</td>
<td><div id="addtel">
<select name="ma[tel][]" size="1">
<?php
$select = null;
$select = ( "-1"==$ma['tel'][0] ) ? ' selected' : null;
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
";
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' : null;
echo "<option $select value=\"$row->telefon_nr\">$teln $telr</option>\n";
$tel .= "'".$row->telefon_nr. "':'" . $teln ." ". $telr. "',";
}
}
$tel = substr($tel,0,strlen($tel)-1);
?>
</select>
<script type="text/javascript">
<!--
arr = {<?php echo ($tel); ?>}; // Ergebnis: {key:'value',key:'value',...}
//-->
</script>
oder neu <input name="ma[ntel][]" type="text" size="20" maxlength="20" value="<?php echo $ma['ntel'][0]; ?>" />
öffentlich <input name="ma[pub][]" type="checkbox" value="1" <?php if ($ma['pub'][0]) echo "checked"; ?> />
<a href="<?php echo "javascript:addInput('addtel');" ?>" title="weitere Telefon-Nr."><img src="/fhiiqm/img/add.png" /></a>
<a href="<?php echo "javascript:delInput('addtel');" ?>" title="lö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 "<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 $telr</option>\n";
}
echo "</select>";
echo " oder neu <input name=\"ma[ntel][]\" type=\"text\" size=\"20\" maxlength=\"20\" value=\"".$ma['ntel'][$i]."\" />";
echo " öffentlich <input name=\"ma[pub][$i]\" type=\"checkbox\" value=\"1\"";
$check = ($ma['pub'][$i]) ? " checked" : "" ;
echo "$check /><br />";
}
$i++;
}
}
}
?>
</div>
</td>
</tr>
<tr>
<td>E-Mail</td>
<td><input name="ma[email]" type="text" size="30" maxlength="100" value="<?php echo $ma['email']; ?>" /></td>
</tr>
<tr><td>Abteilung *</td>
<td valign="top">
<select name="ma[abt]">
<?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'])
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";
}
}
?>
</select>
Mitarbeiter FHI? <input name="ma[fhi]" type="checkbox" value="1" <?php if ($ma['fhi']) echo "checked"; ?> />
<input type="hidden" name="okn" value="<?php echo $okn; ?>" />
</td>
</tr>
<!--
</table>
</div>
</form>
-->