--- a/fhiiqm/form/laser_form.inc.php Wed Jul 31 15:10:48 2013 +0200
+++ b/fhiiqm/form/laser_form.inc.php Thu Sep 12 09:04:56 2013 +0200
@@ -1,354 +1,357 @@
-<?php
-
-/**
- * @author Bettina Schwarzer, Fritz-Haber-Institut
- * @copyright 12/2011
- *
- * Form Laser
- */
-
- include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
- if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
- $okn = true;
- if (!$la["geb"]) $la["geb"]="A";
-
-?>
-<div align="center">
-<table>
-<tr><td class="bigger">Die Auswahl eines Verantwortlichen geschieht durch Eingeben von<br />mindesten 2 Zeichen in das entsprechende Feld.
-</td></tr>
-<tr><td class="bigger"> </td></tr>
-</table>
-</div>
-<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="flas">
-<div align="center">
- <table border="0" cellspacing="3" cellpadding="3">
-<!-- <div class="ui-widget"> -->
- <tr>
- <td>
- <? if ($laid)
- {
- echo "Laser-ID</td>";
- echo "<td><input class='read' name='la[lid]' type='text' size='5' value='" .$la['lid']."' readonly='readonly' />";
- echo " ";
- }
- echo "gehört zu Laser ";
- if (!$laid) echo "</td><td>";
- echo "<select name=\"la[lidref]\">";
- if ($la["lidref"] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- if ($laid) $wher = " WHERE las_ID <> $laid "; else $wher = "";
- $sql = "SELECT las_ID, las_bez FROM Laser $wher ORDER BY 2";
- if ($res = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($res as $row)
- {
- if ($row->las_ID == $la['lidref']) $select="selected"; else $select="";
- echo "<option $select value='$row->las_ID'>$row->las_ID - $row->las_bez</option>\n";
- }
- }
- ?>
- </td>
- </tr>
- <tr><td>Laserbezeichnung *</td>
- <td valign="top"><input type="text" name="la[lbez]" id="lbez" size="50" maxlength="250" value="<?php echo $la['lbez']; ?>"/>
- <?php
- if (isset($la['lbez']) && $la['lbez']<'!')
- {
- echo "<br><span class=\"red\">Laserbezeichnung ist erforderlich!</span>\n";
- $okn = false;
- }
- else
- if ($okn) $okn = true; else $okn=false;
- ?>
- </td>
- </tr>
- <tr><td>Inventar-Nr.</td>
- <td valign="top"><input type="text" name="la[invnr]" size="20" maxlength="20" value="<?php echo $la['invnr']; ?>"/>
- </td>
- </tr>
- <tr><td>in Betrieb</td>
- <td><input type="checkbox" name="la[akt]" value="1" <?php echo ($la["akt"] )? "checked=\"checked\"" : "";?> />
- </td>
- </tr>
- <tr><td>Wellenlänge(nm) von</td>
- <td valign="top"><input type="text" name="la[wvon]" size="10" maxlength="7" value="<?php echo $la['wvon']; ?>"/>
- Wellenlänge(nm) bis
- <input type="text" name="la[wbis]" size="10" maxlength="7" value="<?php echo $la['wbis']; ?>"/></td>
- </tr>
- <tr><td>Laserart</td>
- <td><select name="la[lart]">
- <?php
- if ($la['lart'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT las_art_ID, las_art_bez FROM Laser_Art ORDER BY 2";
- if ($res = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($res as $row)
- {
- if ($row->las_art_ID == $la['lart']) $select="selected"; else $select="";
- echo "<option $select value='$row->las_art_ID'>$row->las_art_bez</option>\n";
- }
- }
- ?>
- </select> oder neu
- <input name="la[lartnew]" type="text" size="30" maxlength="50" value="<?php echo $la['lartnew']; ?>"/> </td>
- </tr>
- <tr><td>Lasertyp</td>
- <td><select name="la[ltyp]">
- <?php
- if ($la['ltyp'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT las_typ_ID, las_typ_bez FROM Laser_Typ ORDER BY 2";
- if ($res = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($res as $row)
- {
- if ($row->las_typ_ID == $la['ltyp']) $select="selected"; else $select="";
- echo "<option $select value='$row->las_typ_ID'>$row->las_typ_bez</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Laserklasse</td>
- <td><select name="la[lkla]">
- <?php
- if ($la['lkla'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT las_klasse_ID, las_klasse_bez FROM Laser_Klasse ORDER BY 2";
- if ($res = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($res as $row)
- {
- if ($row->las_klasse_ID == $la['lkla']) $select="selected"; else $select="";
- echo "<option $select value='$row->las_klasse_ID'>$row->las_klasse_bez</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Schutzstufe</td>
- <td><select name="la[suid]">
- <?php
- if ($la['suid'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe WHERE LEFT(schutzst_bez,2)<>'OD' ORDER BY 2";
- if ($res = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($res as $row)
- {
- if ($row->schutzst_ID == $la['suid']) $select="selected"; else $select="";
- echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n";
- }
- }
- ?>
- </select> Schutzstufe OD
- <select name="la[suodid]">
- <?php
- if ($la['suid'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe WHERE LEFT(schutzst_bez,2)='OD' ORDER BY 2";
- if ($res = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($res as $row)
- {
- if ($row->schutzst_ID == $la['suodid']) $select="selected"; else $select="";
- echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Leistung</td>
- <td valign="top"><input type="text" name="la[leist]" size="10" maxlength="7" value="<?php echo $la['leist']; ?>"/>
- Einheit
- <select name="la[eleist]">
- <?php
- $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY sort";
- if ($ree = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($ree as $row)
- {
- if ($row->einheit_ID == $la['eleist']) $select="selected"; else $select="";
- echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>max. Leistung</td>
- <td valign="top"><input type="text" name="la[leistmax]" size="10" maxlength="7" value="<?php echo $la['leistmax']; ?>"/>
- Einheit
- <select name="la[eleistmax]">
- <?php
- $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY sort";
- if ($ree = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($ree as $row)
- {
- if ($row->einheit_ID == $la['eleistmax']) $select="selected"; else $select="";
- echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Energie</td>
- <td valign="top"><input type="text" name="la[eng]" size="10" maxlength="7" value="<?php echo $la['eng']; ?>"/>
- Einheit
- <select name="la[eeng]">
- <?php
- $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=2 ORDER BY sort";
- if ($ree = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($ree as $row)
- {
- if ($row->einheit_ID == $la['eeng']) $select="selected"; else $select="";
- echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Apertur</td>
- <td valign="top"><input type="text" name="la[apt]" size="10" maxlength="7" value="<?php echo $la['apt']; ?>"/>
- Einheit
- <select name="la[eapt]">
- <?php
- $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=3 ORDER BY sort";
- if ($ree = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($ree as $row)
- {
- if ($row->einheit_ID == $la['eapt']) $select="selected"; else $select="";
- echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Frequenz</td>
- <td valign="top"><input type="text" name="la[frq]" size="10" maxlength="7" value="<?php echo $la['frq']; ?>"/>
- Einheit
- <select name="la[efrq]">
- <?php
- $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=4 ORDER BY sort";
- if ($ree = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($ree as $row)
- {
- if ($row->einheit_ID == $la['efrq']) $select="selected"; else $select="";
- echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr><td>Impulsbreite</td>
- <td valign="top"><input type="text" name="la[ipb]" size="10" maxlength="7" value="<?php echo $la['ipb']; ?>"/>
- Einheit
- <select name="la[eipb]">
- <?php
- $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=5 ORDER BY sort";
- if ($ree = $dbc -> queryObjectArray($sql))
- {
- $select = "";
- foreach ($ree as $row)
- {
- if ($row->einheit_ID == $la['eipb']) $select="selected"; else $select="";
- echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
- }
- }
- ?>
- </select></td>
- </tr>
- <tr>
- <td>Hersteller (Firma)</td>
- <td>
- <select name="la[hstid]">
- <?php
- if ($la['hstid'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT las_hersteller_ID, las_hersteller_bez FROM fhiiqm.Laser_Hersteller ORDER BY 2";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if ($row->las_hersteller_ID == $la['hstid']) $select="selected"; else $select="";
- echo "<option $select value=\"$row->las_hersteller_ID\">$row->las_hersteller_bez</option>\n";
- }
- }
- ?>
- </select> oder neu
- <input name="la[herst]" type="text" size="30" maxlength="50" value="<?php echo $la['herst']; ?>"/>
- </td>
- </tr>
- <tr><td>Standort</td>
- <td valign="top">Haus
- <select name="la[geb]" onchange="this.form.submit();">
- <?php
- $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 == $la['geb']) $select="selected"; else $select="";
- echo "<option $select value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n";
- }
- }
- ?>
- </select>
- Raum
- <select name="la[raum]">
- <?php
- if ($la['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='" . $la['geb'] ."' ORDER BY 2";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if ($row->raum_ID == $la['raum']) $select="selected"; else $select="";
- echo "<option $select value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
- }
- }
- ?>
- </select>
- </td>
- </tr>
- <tr><td>Verantwortlicher</td>
- <td valign="top"><input class="long20" type="text" name="la[persknr]" id="persknr" value="<?php echo $la['persknr']; ?>"/>
- </td>
- </tr>
- <tr><td>Laser-Infos</td>
- <td><textarea name="la[linfo]" cols="50" rows="4"><?php echo $la['linfo']; ?></textarea></td>
- </tr>
-
- <?php
- if ($la["tstmp"] && $la["tstmp"]>0)
- {
- echo "<tr><td>letzte Änderung</td>";
- $ts = new DateTime($la["tstmp"]);
- echo "<td>".$ts->format('d.m.Y H:i:s')."</td></tr>\n";
- }
- ?>
-
- <input type="hidden" name="la[pid]" id="pid" value="<?php echo $la['pid']; ?>"/>
- <input type="hidden" name="la[tstmp]" value="<?php echo $la['tstmp']; ?>"/>
- <input type="hidden" name="la[okn]" value="<?php echo $okn; ?>"/>
-<!--
-</div>
-</form>
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 12/2011
+ *
+ * Form Laser
+ */
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ $okn = true;
+ if (!$la["geb"]) $la["geb"]="A";
+
+?>
+<div align="center">
+<table>
+<tr><td class="bigger">Die Auswahl eines Verantwortlichen geschieht durch Eingeben von<br />mindesten 2 Zeichen in das entsprechende Feld.
+</td></tr>
+<tr><td class="bigger"> </td></tr>
+</table>
+</div>
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="flas">
+<div align="center">
+ <table border="0" cellspacing="3" cellpadding="3">
+<!-- <div class="ui-widget"> -->
+ <tr>
+ <td>
+ <? if ($laid)
+ {
+ echo "Laser-ID</td>";
+ echo "<td><input class='read' name='la[lid]' type='text' size='5' value='" .$la['lid']."' readonly='readonly' />";
+ echo " ";
+ }
+ echo "gehört zu Laser ";
+ if (!$laid) echo "</td><td>";
+ echo "<select name=\"la[lidref]\">";
+ if ($la["lidref"] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ if ($laid) $wher = " WHERE las_ID <> $laid "; else $wher = "";
+ $sql = "SELECT las_ID, las_bez FROM Laser $wher ORDER BY 2";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($res as $row)
+ {
+ if ($row->las_ID == $la['lidref']) $select="selected"; else $select="";
+ echo "<option $select value='$row->las_ID'>$row->las_ID - $row->las_bez</option>\n";
+ }
+ }
+ ?>
+ </td>
+ </tr>
+ <tr><td>Laserbezeichnung *</td>
+ <td valign="top"><input type="text" name="la[lbez]" id="lbez" size="50" maxlength="250" value="<?php echo $la['lbez']; ?>"/>
+ <?php
+ if (isset($la['lbez']) && $la['lbez']<'!')
+ {
+ echo "<br><span class=\"red\">Laserbezeichnung ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ else
+ if ($okn) $okn = true; else $okn=false;
+ ?>
+ </td>
+ </tr>
+ <tr><td>Inventar-Nr.</td>
+ <td valign="top"><input type="text" name="la[invnr]" size="20" maxlength="20" value="<?php echo $la['invnr']; ?>"/>
+ </td>
+ </tr>
+ <tr><td>in Betrieb</td>
+ <td><input type="checkbox" name="la[akt]" value="1" <?php echo ($la["akt"] )? "checked=\"checked\"" : "";?> />
+ </td>
+ </tr>
+ <tr><td>Wellenlänge(nm) von</td>
+ <td valign="top"><input type="text" name="la[wvon]" size="10" maxlength="7" value="<?php echo $la['wvon']; ?>"/>
+ Wellenlänge(nm) bis
+ <input type="text" name="la[wbis]" size="10" maxlength="7" value="<?php echo $la['wbis']; ?>"/></td>
+ </tr>
+ <tr><td>Laserart</td>
+ <td><select name="la[lart]">
+ <?php
+ if ($la['lart'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT las_art_ID, las_art_bez FROM Laser_Art ORDER BY 2";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($res as $row)
+ {
+ if ($row->las_art_ID == $la['lart']) $select="selected"; else $select="";
+ echo "<option $select value='$row->las_art_ID'>$row->las_art_bez</option>\n";
+ }
+ }
+ ?>
+ </select> oder neu
+ <input name="la[lartnew]" type="text" size="30" maxlength="50" value="<?php echo $la['lartnew']; ?>"/> </td>
+ </tr>
+ <tr><td>Lasertyp</td>
+ <td><select name="la[ltyp]">
+ <?php
+ if ($la['ltyp'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT las_typ_ID, las_typ_bez FROM Laser_Typ ORDER BY 2";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($res as $row)
+ {
+ if ($row->las_typ_ID == $la['ltyp']) $select="selected"; else $select="";
+ echo "<option $select value='$row->las_typ_ID'>$row->las_typ_bez</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Laserklasse</td>
+ <td><select name="la[lkla]">
+ <?php
+ if ($la['lkla'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT las_klasse_ID, las_klasse_bez FROM Laser_Klasse ORDER BY 2";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($res as $row)
+ {
+ if ($row->las_klasse_ID == $la['lkla']) $select="selected"; else $select="";
+ echo "<option $select value='$row->las_klasse_ID'>$row->las_klasse_bez</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Schutzstufe</td>
+ <td><select name="la[suid]">
+ <?php
+ if ($la['suid'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe WHERE LEFT(schutzst_bez,2)<>'OD' ORDER BY 2";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($res as $row)
+ {
+ if ($row->schutzst_ID == $la['suid']) $select="selected"; else $select="";
+ echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n";
+ }
+ }
+ ?>
+ </select> Schutzstufe OD
+ <select name="la[suodid]">
+ <?php
+ if ($la['suid'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT schutzst_ID, schutzst_bez FROM Schutzstufe WHERE LEFT(schutzst_bez,2)='OD' ORDER BY 2";
+ if ($res = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($res as $row)
+ {
+ if ($row->schutzst_ID == $la['suodid']) $select="selected"; else $select="";
+ echo "<option $select value='$row->schutzst_ID'>$row->schutzst_bez</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Leistung</td>
+ <td valign="top"><input type="text" name="la[leist]" size="10" maxlength="7" value="<?php echo $la['leist']; ?>"/>
+ Einheit
+ <select name="la[eleist]">
+ <?php
+ $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY sort";
+ if ($ree = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($ree as $row)
+ {
+ if ($row->einheit_ID == $la['eleist']) $select="selected"; else $select="";
+ echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>max. Leistung</td>
+ <td valign="top"><input type="text" name="la[leistmax]" size="10" maxlength="7" value="<?php echo $la['leistmax']; ?>"/>
+ Einheit
+ <select name="la[eleistmax]">
+ <?php
+ $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=1 ORDER BY sort";
+ if ($ree = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($ree as $row)
+ {
+ if ($row->einheit_ID == $la['eleistmax']) $select="selected"; else $select="";
+ echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Energie</td>
+ <td valign="top"><input type="text" name="la[eng]" size="10" maxlength="7" value="<?php echo $la['eng']; ?>"/>
+ Einheit
+ <select name="la[eeng]">
+ <?php
+ $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=2 ORDER BY sort";
+ if ($ree = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($ree as $row)
+ {
+ if ($row->einheit_ID == $la['eeng']) $select="selected"; else $select="";
+ echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Apertur</td>
+ <td valign="top"><input type="text" name="la[apt]" size="10" maxlength="7" value="<?php echo $la['apt']; ?>"/>
+ Einheit
+ <select name="la[eapt]">
+ <?php
+ $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=3 ORDER BY sort";
+ if ($ree = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($ree as $row)
+ {
+ if ($row->einheit_ID == $la['eapt']) $select="selected"; else $select="";
+ echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Frequenz</td>
+ <td valign="top"><input type="text" name="la[frq]" size="10" maxlength="7" value="<?php echo $la['frq']; ?>"/>
+ Einheit
+ <select name="la[efrq]">
+ <?php
+ $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=4 ORDER BY sort";
+ if ($ree = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($ree as $row)
+ {
+ if ($row->einheit_ID == $la['efrq']) $select="selected"; else $select="";
+ echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr><td>Impulsbreite</td>
+ <td valign="top"><input type="text" name="la[ipb]" size="10" maxlength="7" value="<?php echo $la['ipb']; ?>"/>
+ Einheit
+ <select name="la[eipb]">
+ <?php
+ $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser=5 ORDER BY sort";
+ if ($ree = $dbc -> queryObjectArray($sql))
+ {
+ $select = "";
+ foreach ($ree as $row)
+ {
+ if ($row->einheit_ID == $la['eipb']) $select="selected"; else $select="";
+ echo "<option $select value='$row->einheit_ID'>$row->einheit ($row->einheit_beschr)</option>\n";
+ }
+ }
+ ?>
+ </select></td>
+ </tr>
+ <tr>
+ <td>Hersteller (Firma)</td>
+ <td>
+ <select name="la[hstid]">
+ <?php
+ if ($la['hstid'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT las_hersteller_ID, las_hersteller_bez FROM fhiiqm.Laser_Hersteller ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->las_hersteller_ID == $la['hstid']) $select="selected"; else $select="";
+ echo "<option $select value=\"$row->las_hersteller_ID\">$row->las_hersteller_bez</option>\n";
+ }
+ }
+ ?>
+ </select> oder neu
+ <input name="la[herst]" type="text" size="30" maxlength="50" value="<?php echo $la['herst']; ?>"/>
+ </td>
+ </tr>
+ <tr><td>Standort</td>
+ <td valign="top">Haus
+ <select name="la[geb]" onchange="this.form.submit();">
+ <?php
+ $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 == $la['geb']) $select="selected"; else $select="";
+ echo "<option $select value=\"$row->geb_ID\">$row->geb_ID: $row->geb_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ Raum
+ <select name="la[raum]">
+ <?php
+ if ($la['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='" . $la['geb'] ."' ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->raum_ID == $la['raum']) $select="selected"; else $select="";
+ echo "<option $select value=\"$row->raum_ID\">$row->raum_nr $row->raum_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr><td>Verantwortlicher</td>
+ <td valign="top"><input class="long20" type="text" name="la[persknr]" id="persknr" value="<?php echo $la['persknr']; ?>"/>
+ </td>
+ </tr>
+ <tr><td>Laser-Infos</td>
+ <td><textarea name="la[linfo]" cols="50" rows="4"><?php echo $la['linfo']; ?></textarea></td>
+ </tr>
+
+ <?php
+ if ($la["tstmp"] && $la["tstmp"]>0)
+ {
+ echo "<tr><td>letzte Änderung</td>";
+ $ts = new DateTime($la["tstmp"]);
+ echo "<td>".$ts->format('d.m.Y H:i:s');
+ }
+ if (isset($la["uid"]) && $la["uid"])
+ echo " (".$la["uid"] .")";
+ echo "</td></tr>\n";
+ ?>
+
+ <input type="hidden" name="la[pid]" id="pid" value="<?php echo $la['pid']; ?>"/>
+ <input type="hidden" name="la[tstmp]" value="<?php echo $la['tstmp']; ?>"/>
+ <input type="hidden" name="la[okn]" value="<?php echo $okn; ?>"/>
+<!--
+</div>
+</form>
</table> -->
\ No newline at end of file