diff -r f1a8785434e4 -r fc60ef80a7ad fhiiqm/form/ma_ed_form.inc.php
--- a/fhiiqm/form/ma_ed_form.inc.php Fri Dec 21 15:31:50 2012 +0100
+++ b/fhiiqm/form/ma_ed_form.inc.php Wed Feb 27 09:43:08 2013 +0100
@@ -10,7 +10,11 @@
include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
$okn = true;
- if (!$ma) $ma['geb'] = 'A';
+ if (!$ma)
+ {
+ $ma['geb'] = 'A';
+ $ma['abt'][0] = $dbc -> querySingleItem("SELECT abt_ID FROM Abteilung ORDER BY abt_ID+0 LIMIT 0,1");
+ }
?>
@@ -97,10 +101,12 @@
-
+
Arbeitsgruppe |
-
|
-
+ ";
+*/
+?>
Telefon |
\n";
- $sql = "SELECT telefon_nr,geb_ID,raum_nr, telefon_typ FROM fhiiqm.Telefon t
+/* $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
-";
+ 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' : null;
- echo "\n";
- $tel .= "'".$row->telefon_nr. "':'" . $teln ." ". $telr. "',";
+// if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = "";
+ $select = ( $row->telefon_nr==$ma['tel'][0] ) ? " selected='selected'" : "";
+ echo "\n";
+// $tel .= "'".$row->telefon_nr. "':'" . $teln ." ". $telr. "',";
+ $tel .= "'".$row->telefon_nr. "':'" . $teln . "',";
}
}
$tel = substr($tel,0,strlen($tel)-1);
@@ -153,6 +163,17 @@
//-->
oder neu
+ Priorität
+ \n";
+ for ($i=1; $i<10; $i++)
+ {
+ $select=($ma["so"][0] == $i)? " selected='selected'" : "";
+ echo "\n";
+ }
+ ?>
+
öffentlich />
" title="weitere Telefon-Nr.">
" title="löschen letzte Telefon-Nr.">
@@ -166,22 +187,32 @@
{
if ($i>0)
{
- echo "";
+ echo "";
$select = ( "-1" == $atel ) ? ' selected' : null;
echo "\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 = "";
+// if ($row->raum_nr) $telr = "[". $row->geb_ID. " ". $row->raum_nr . "]"; else $telr = "";
$select = ( $row->telefon_nr == $atel ) ? ' selected' : null;
- echo "\n";
+ echo "\n";
}
echo "";
echo " oder neu ";
- echo " öffentlich ";
+ echo " Priorität ";
+
+ $select = ( $ma["so"][$i] == "-1" ) ? " selected='selected'" : "";
+ echo "\n";
+ for ($j=1; $j<10; $j++)
+ {
+ $select=($ma["so"][$i] == $j)? " selected='selected'" : "";
+ echo "\n";
+ }
+ echo "\n";
+ echo " öffentlich \n";
}
$i++;
}
@@ -198,25 +229,100 @@
|
Abteilung * |
-
-
+
+
queryObjectArray($sql))
{
foreach ($result as $row)
{
- if ($row->abt_ID == $ma['abt'])
+ if ($row->abt_ID == $ma['abt'][0])
echo "\n";
else
echo "\n";
+ $abt .= "'".$row->abt_ID. "':'" . $row->abt_name .": ". $row->abt_long . "',";
}
- }
+ $abt = substr($abt,0,strlen($abt)-1);
+ }
+ ?>
+
+
+ Arbeitsgruppe
+
+ \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 "\n";
+ else
+ echo "\n";
+// $rag .= "'".$row->rag_ID. "':'" . $row->rag_bez . "',";
+ }
+// $rag = substr($rag,0,strlen($rag)-1);
+ }
+ $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 ($res = $dbc->queryObjectArray($sql))
+ {
+ foreach ($res as $row)
+ $rag .= "'".$row->rag_ID. "':'" . $row->abt_name . ": ". $row->rag_bez . "',";
+ $rag = substr($rag,0,strlen($rag)-1);
+ }
?>
-
+
+ " title="weitere Arbeitsgruppe">
+ " title="löschen letzte Arbeitsgruppe">
+ 1 || count($ma['rag'])>1)
+ {
+ $i=0;
+ foreach ($ma['abt'] as $eabt)
+ {
+ if ($i>0)
+ {
+ echo " ";
+
+ foreach ($result as $row)
+ {
+ $select = ( $row->abt_ID == $eabt ) ? ' selected' : null;
+ echo "\n";
+ }
+ echo "";
+ echo " Arbeitsgruppe ";
+ echo " ";
+ $select = ( $ma["rag"][$i] == "-1" ) ? " selected='selected'" : "";
+ echo "\n";
+ foreach ($res as $row)
+ {
+ $select = ( $row->rag_ID == $ma['rag'][$i] ) ? ' selected' : null;
+ echo "\n";
+ }
+ echo "";
+ }
+ $i++;
+ }
+ }
+ }
+ ?>
+
|
|
+
+