fhiiqm/form/info_form3.inc.php
changeset 40 6f4b105daa24
parent 36 4411d3239444
--- a/fhiiqm/form/info_form3.inc.php	Wed Jul 31 15:10:48 2013 +0200
+++ b/fhiiqm/form/info_form3.inc.php	Thu Sep 12 09:04:56 2013 +0200
@@ -1,282 +1,294 @@
-<?php
-
-/**
- * @author Bettina Schwarzer, Fritz-Haber-Institut
- * @copyright 04/2012
- *
- * Form Info Geschaeftsverteilungsplan - 3
- */
-
-	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
-	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
-    $okn = true;
-
-?>
-<div align="center">
-<?php
-    if (!is_null($_SESSION["recht"]) && !in_array("ie",$_SESSION["recht"]))
-        $text = "";
-    else
-        if  (strpos($_SERVER['PHP_SELF'],"ins") > -1) $text = "Eingabe"; else $text="&Auml;ndern / L&ouml;schen";
-?>
-<h5>* - Felder sind erforderlich!</h5>
-</div>
-<!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> -->	
-<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> 	
-<div align="center">
-<table width="70%" border="0" cellspacing="3" cellpadding="3">
-    <tr>
-        <td>Titel *<br/><br />
-            &nbsp;&nbsp;&nbsp;max. 300 Zeichen m&ouml;glich</td>
-        <td><textarea name="inf[iname]" id="titel" cols="50" rows="2"><?php echo $inf['iname']; ?></textarea>
-            <?php 
-			     if (isset($inf['iname']) && $inf['iname']<'!')
-				{
-					echo "<br><span class=\"red\">Titel ist erforderlich!</span>\n";
-					$okn = false;
-				}
-                if ($infid)
-                { 
-                    echo "&nbsp;&nbsp;&nbsp;Info-ID";
-                    echo "&nbsp;&nbsp;&nbsp;<input class='read right' name='inf[infid]' type='text' size='5' value='" .$inf['infid']."' readonly='readonly' />"; 
-                }
-             ?>
-        </td>
-    </tr>
-    <tr>
-        <td>Kurzinformation<br/><br />
-            &nbsp;&nbsp;&nbsp;max. 8000 Zeichen m&ouml;glich<br /><br />
-            &nbsp;&nbsp;&nbsp;erforderlich f&uuml;r <br />
-            &nbsp;&nbsp;&nbsp;Gesch&auml;ftsverteilungsplan
-        </td>
-        <td><textarea name="inf[ilong]" cols="80" rows="6"><?php echo $inf['ilong']; ?></textarea>
-        </td>
-    </tr>
-	<tr>
-	   <td>Kennzeichen(Sort.)</td>
-	   <td><input name="inf[sort]" type="text" size="15" maxlength="10" value="<?php echo $inf['sort']; ?>" />
-       &nbsp;&nbsp;&nbsp;BK... bei KST</td>
-    </tr>
-    <tr><td>geh&ouml;rt zu Info</td>
-        <td><select name="inf[infrel]">
-            <?php
-                if ($inf['infid'] == -1) $select = " selected "; else $select = "";
-                echo "<option $select value=\"-1\"></option>\n";
-                if (isset($inf["infid"]) && $inf["infid"]>0) $where = " WHERE info_ID != " . $inf["infid"]; else $where=""; 
-                $sql = "SELECT info_ID, LEFT(info_name_s,50) AS iname FROM Info $where ORDER BY 2";
-                if ($result = $dbc -> queryObjectArray($sql))
-                {
-                    foreach ($result as $row)
-                    {
-                        if ($row->info_ID == $inf['infrel'])
-    					   echo "<option selected value=\"$row->info_ID\">$row->info_ID - $row->iname</option>\n";
-    				    else
-    					   echo "<option value=\"$row->info_ID\">$row->info_ID - $row->iname</option>\n";
-                    }
-                }
-            ?>
-        </select>
-        </td>
-    </tr>
-    <tr>
-        <td>Info-Typ</td>
-        <td><select name="inf[ityp]">
-            <?php 
-                if (!$ityp)
-                { 
-                    $wher = "";
-                    if ($inf['ityp'] == -1) $select = " selected "; else $select = "";
-                    echo "<option $select value=\"-1\"></option>\n";
-                }
-                else $wher = " WHERE infotyp_ID = $ityp";
-                $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ $wher ORDER BY 2";
-                if ($result = $dbc->queryObjectArray($sql))
-                {
-                    foreach ($result as $row)
-                    {
-                        if ($row->infotyp_ID == $inf['ityp'])
-    					   echo "<option selected value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n";
-    				    else
-    					   echo "<option value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n";
-                    }
-            }
-            ?>
-            </select>
-        </td>
-    </tr>
-    <tr>
-        <td>Erstellungsdatum *</td>
-        <td><input class="long10" name="inf[cdat]" id="cdat"  value="<?php echo $inf['cdat']; ?>" />
-            <?php
-                if (isset($inf['cdat']) && $inf['cdat']< "!")
-                { 
-                    echo "<br><span class=\"red\">Erstellungsdatum ist erforderlich!</span>\n";
-                    $okn = false;
-                }    
-            ?>
-        </td>
-    </tr>
-    <tr>
-        <td>g&uuml;ltig ab</td>
-        <td><input class="long10" name="inf[vdat]" id="vdat"  value="<?php echo $inf['vdat']; ?>" /></td>
-    </tr>
-     <tr>
-        <td>g&uuml;ltig bis</td>
-        <td><input class="long10" name="inf[bdat]" id="bdat"  value="<?php echo $inf['bdat']; ?>" /></td>
-    </tr>
-    <tr><td>Status Freigabe</td>
-        <td><select name="inf[fg]" size="1">
-            <?php
-                if (!isset($inf["fg"])) $inf["fg"] = 1;
-                if ($inf['fg']) $select = ( "-1" == $inf['fg'] ) ? ' selected' : null;
-                echo "<option $select value=\"-1\"></option>\n";
-                $sql = "SELECT info_freigabe_ID, info_freigabe_bez FROM Info_Freigabe ORDER BY 2";
-                if ($result = $dbc -> queryObjectArray($sql))
-                {
-                    foreach ($result as $row)
-                    {
-                        if ($inf['fg']) $select = ( $row->info_freigabe_ID == $inf['fg'] ) ? ' selected' : null;
-       					echo "<option $select value=\"$row->info_freigabe_ID\">$row->info_freigabe_bez</option>\n";
-                    }
-                }
-            ?>
-        </select>
-        </td>
-    </tr>
-    <tr>
-        <td>Autor</td>
-        <td><input class="long20" type="text" name="inf[persknr]" id="persknr" value="<?php echo $inf['persknr']; ?>"/>
-        &nbsp;&nbsp;&nbsp;Eingabe von mind. 2 Zeichen -&gt; Namensliste
-        </td>
-    </tr>
-    <tr>
-        <td>Verantwortliche(r) FHI 
-            <br /><br />&nbsp;&nbsp;&nbsp;Eingabe von mind. 2 Zeichen 
-            <br />&nbsp;&nbsp;&nbsp; -&gt; Namensliste,
-            <br />&nbsp;&nbsp;&nbsp;Wiederholung f&uuml;r weitere Namen
-            <br /><br />&nbsp;&nbsp;&nbsp;&Auml;ndern: alles L&ouml;schen, neu eingeben        
-        </td>
-        <td><table cellspacing="0"><tr><td>
-                <textarea cols="40" rows="5" name="inf[vpers]" id="vpers"><?php echo $inf['vpers']; ?></textarea>
-                
-                </td>
-            <?php
-            if (isset($inf["vpn"]) && $inf["vpn"])
-            {
-//                $plist = substr($inf["vpn"],0,strlen($inf["vpn"])-1);
-                if (strpos($inf["vpn"],",") === 0) $inf["vpn"] = substr($inf["vpn"],1);
-                echo "<td><table cellspacing='0' cellpadding='0'>";
-                $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname) AS ma FROM Mitarbeiter WHERE persknr IN (".$inf["vpn"].") ORDER BY 2";
-                if ($result = $dbc->queryObjectArray($sql))
-                foreach ($result as $row)
-                {
-                    echo "<tr><td class='valignb'>&nbsp;&nbsp;&nbsp;$row->ma:&nbsp;</td>";
-                    echo "<td class='valignb' width='40%'> <input name='inf[prio][$row->persknr]' type='text' size='50' maxlength='50' value='". $inf["prio"][$row->persknr] . "' />\n";
-                    echo "</td></tr>";
-                }
-                echo "</table></td>\n";    
-            }
-            ?>
-        </tr></table></td>
-    </tr>
-    <?php 
-        if ($inf['ityp'] == 6 && strtolower(substr($inf['sort'],0,2)) == 'bk')
-        {
-            echo "<tr><td>KST: <i>Obergrenze Bestellwert</i> (&euro;)</td>";
-            echo "<td><input name=\"inf[betr]\" type=\"text\" value=\"" . $inf['betr'] . "\" size='15' /></td></tr>\n";    
-        }
-    ?>
-    <tr><td>Sprache</td>
-        <td><select name="inf[lang]">
-        <?php
-                if ($inf['lang'] == -1) $select = " selected "; else $select = "";
-                echo "<option $select value=\"-1\"></option>\n";
-                $alang = array("de"=>"deutsch","en"=>"englisch");
-                foreach ($alang as $key=>$value)
-                {
-                    if ($inf['lang'] == $key) $select = " selected "; else $select = "";
-                    echo "<option $select value=\"$key\">$value</option>\n";
-                }
-        ?>
-        </select></td>
-    </tr>
-    <tr>
-        <td>zugeordnet zu Produkt<br /><br />
-            &nbsp;&nbsp;&nbsp;Mehrfachauswahl m&ouml;glich:<br />
-            &nbsp;&nbsp;&nbsp;[Strg]-Taste + Anklicken der<br /> 
-            &nbsp;&nbsp;&nbsp;gewünschten Listeneinträge</td>
-        <td>
-            <select name="inf[prid][]" size="6" multiple="multiple">
-            <?php 
-                if (is_array($inf['prid'])) $select = in_array( "-1", $inf['prid'] ) ? ' selected' : null;
-                echo "<option $select value=\"-1\"></option>\n";
-//                $sql = "SELECT produkt_ID, LEFT(prod_name,70) AS prod, LENGTH(prod_name) AS lenp FROM Produkt ORDER BY 2";
-                $sql = "CALL prod_hiera_all(0,0)";  
-                if ($result = $dbc->queryObjectArray($sql))
-                {
-                    foreach ($result as $row)
-                    {
-                        if (strlen($row->bez) > 70) 
-                            $prod=str_replace(" ","&nbsp;",htmlentities(substr($row->bez,0,70))) ."..."; 
-                        else 
-                            $prod=str_replace(" ","&nbsp;",htmlentities($row->bez));
-                        if ($row->prid >0) $color=" class='green'"; else $color="";
-                        if (is_array($inf['prid'])) $select = in_array($row->prid, $inf['prid']) ? ' selected' : null;
-                        echo "<option $color $select value=\"$row->prid\">$prod</option>\n";
-                    }
-                }
-                unset($result);
-            ?>
-            </select>
-            <br />bitte nur die <font color="green">gr&uuml;nen</font> Eintr&auml;ge w&auml;hlen
-        </td>
-    </tr>
-    <tr><td>Adressat<br /><br />
-            &nbsp;&nbsp;&nbsp;Mehrfachauswahl m&ouml;glich</td>
-        <td><select name="inf[adr][]" size="4" multiple="multiple">
-            <?php
-                if (is_array($inf['adr'])) $select = in_array( "-1", $inf['adr'] ) ? ' selected' : null;
-                echo "<option $select value=\"-1\"></option>\n";
-                $sql = "SELECT info_adr_ID, info_adr_name FROM Adressat ORDER BY 2";
-                if ($result = $dbc -> queryObjectArray($sql))
-                {
-                    foreach ($result as $row)
-                    {
-                        if (is_array($inf['adr'])) $select = in_array( $row->info_adr_ID, $inf['adr'] ) ? ' selected' : null;
-       					echo "<option $select value=\"$row->info_adr_ID\">$row->info_adr_name</option>\n";
-                    }
-                }
-            ?>
-        </select>
-        </td>
-    </tr>
-    <?php 	include($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/form/info_file_form.inc.php"); ?>
-<!--	<tr>
-	   <td>Dateibezeichnung Dokument (*)</td>
-	   <td><input name="inf[ifname]" type="text" size="50" maxlength="50" value="<?php echo $inf['ifname']; ?>" />
-	   <?php
-/*
-            echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!";   
-			if (isset($inf['ifname']) && $upd && is_uploaded_file($_FILES["ifile"]["tmp_name"]) && $inf['ifname']<'!')
-				{
-					echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
-					$okn = false;
-				}
-				else
-				{
-                    if ($inf['ifname']>='!' && file_exists("infos/".$inf['ifname']))
-                        echo "<br />Dokument anschauen:&nbsp;<a href='infos/" . $inf['ifname'] ."'>" . $inf['ifname'] . "</a>";
-                    if ($okn) $okn = true; else $okn=false;
-                }
-*/
-		?>
-		</td>
-    </tr>
--->
-    <input type="hidden" name="inf[pers]" id="pid" value="<?php echo $inf['pers']; // Author ?>"/> 
-    <input type="hidden" name="inf[vpn]" id="vpid" value="<?php echo $inf['vpn']; // Verantwortliche ?>"/> 
-    <input type="hidden" name="MAX_FILE_SIZE" value="10000000"/>    
-    <input type="hidden" name="inf[okn]" value="<?php echo $okn; ?>"/>
-<!--  </table>
- </div>   
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 04/2012
+ *
+ * Form Info Geschaeftsverteilungsplan - 3
+ */
+
+	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+    $okn = true;
+
+?>
+<div align="center">
+<?php
+    if (!is_null($_SESSION["recht"]) && !in_array("ie",$_SESSION["recht"]))
+        $text = "";
+    else
+        if  (strpos($_SERVER['PHP_SELF'],"ins") > -1) $text = "Eingabe"; else $text="&Auml;ndern / L&ouml;schen";
+?>
+<h5>* - Felder sind erforderlich!</h5>
+</div>
+<!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> -->	
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> 	
+<div align="center">
+<table width="70%" border="0" cellspacing="3" cellpadding="3">
+    <tr>
+        <td>Titel *<br/><br />
+            &nbsp;&nbsp;&nbsp;max. 300 Zeichen m&ouml;glich</td>
+        <td><textarea name="inf[iname]" id="titel" cols="50" rows="2"><?php echo $inf['iname']; ?></textarea>
+            <?php 
+			     if (isset($inf['iname']) && $inf['iname']<'!')
+				{
+					echo "<br><span class=\"red\">Titel ist erforderlich!</span>\n";
+					$okn = false;
+				}
+                if ($infid)
+                { 
+                    echo "&nbsp;&nbsp;&nbsp;Info-ID";
+                    echo "&nbsp;&nbsp;&nbsp;<input class='read right' name='inf[infid]' type='text' size='5' value='" .$inf['infid']."' readonly='readonly' />"; 
+                }
+             ?>
+        </td>
+    </tr>
+    <tr>
+        <td>Kurzinformation<br/><br />
+            &nbsp;&nbsp;&nbsp;max. 8000 Zeichen m&ouml;glich<br /><br />
+            &nbsp;&nbsp;&nbsp;erforderlich f&uuml;r <br />
+            &nbsp;&nbsp;&nbsp;Gesch&auml;ftsverteilungsplan
+        </td>
+        <td><textarea name="inf[ilong]" cols="80" rows="6"><?php echo $inf['ilong']; ?></textarea>
+        </td>
+    </tr>
+	<tr>
+	   <td>Kennzeichen(Sort.)</td>
+	   <td><input name="inf[sort]" type="text" size="15" maxlength="10" value="<?php echo $inf['sort']; ?>" />
+       &nbsp;&nbsp;&nbsp;BK... bei KST</td>
+    </tr>
+    <tr><td>geh&ouml;rt zu Info</td>
+        <td><select name="inf[infrel]">
+            <?php
+                if ($inf['infid'] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                if (isset($inf["infid"]) && $inf["infid"]>0) $where = " WHERE info_ID != " . $inf["infid"]; else $where=""; 
+                $sql = "SELECT info_ID, LEFT(info_name_s,50) AS iname FROM Info $where ORDER BY 2";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->info_ID == $inf['infrel'])
+    					   echo "<option selected value=\"$row->info_ID\">$row->info_ID - $row->iname</option>\n";
+    				    else
+    					   echo "<option value=\"$row->info_ID\">$row->info_ID - $row->iname</option>\n";
+                    }
+                }
+            ?>
+        </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Info-Typ</td>
+        <td><select name="inf[ityp]">
+            <?php 
+                if (!$ityp)
+                { 
+                    $wher = "";
+                    if ($inf['ityp'] == -1) $select = " selected "; else $select = "";
+                    echo "<option $select value=\"-1\"></option>\n";
+                }
+                else $wher = " WHERE infotyp_ID = $ityp";
+                $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ $wher ORDER BY 2";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->infotyp_ID == $inf['ityp'])
+    					   echo "<option selected value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n";
+                    }
+            }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Erstellungsdatum *</td>
+        <td><input class="long10" name="inf[cdat]" id="cdat"  value="<?php echo $inf['cdat']; ?>" />
+            <?php
+                if (isset($inf['cdat']) && $inf['cdat']< "!")
+                { 
+                    echo "<br><span class=\"red\">Erstellungsdatum ist erforderlich!</span>\n";
+                    $okn = false;
+                }    
+            ?>
+        </td>
+    </tr>
+    <tr>
+        <td>g&uuml;ltig ab</td>
+        <td><input class="long10" name="inf[vdat]" id="vdat"  value="<?php echo $inf['vdat']; ?>" /></td>
+    </tr>
+     <tr>
+        <td>g&uuml;ltig bis</td>
+        <td><input class="long10" name="inf[bdat]" id="bdat"  value="<?php echo $inf['bdat']; ?>" /></td>
+    </tr>
+    <tr><td>Status Freigabe</td>
+        <td><select name="inf[fg]" size="1">
+            <?php
+                if (!isset($inf["fg"])) $inf["fg"] = 1;
+                if ($inf['fg']) $select = ( "-1" == $inf['fg'] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT info_freigabe_ID, info_freigabe_bez FROM Info_Freigabe ORDER BY 2";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($inf['fg']) $select = ( $row->info_freigabe_ID == $inf['fg'] ) ? ' selected' : null;
+       					echo "<option $select value=\"$row->info_freigabe_ID\">$row->info_freigabe_bez</option>\n";
+                    }
+                }
+            ?>
+        </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Autor</td>
+        <td><input class="long20" type="text" name="inf[persknr]" id="persknr" value="<?php echo $inf['persknr']; ?>"/>
+        &nbsp;&nbsp;&nbsp;Eingabe von mind. 2 Zeichen -&gt; Namensliste
+        </td>
+    </tr>
+    <tr>
+        <td>Verantwortliche(r) FHI 
+            <br /><br />&nbsp;&nbsp;&nbsp;Eingabe von mind. 2 Zeichen 
+            <br />&nbsp;&nbsp;&nbsp; -&gt; Namensliste,
+            <br />&nbsp;&nbsp;&nbsp;Wiederholung f&uuml;r weitere Namen
+            <br /><br />&nbsp;&nbsp;&nbsp;&Auml;ndern: alles L&ouml;schen, neu eingeben        
+        </td>
+        <td><table cellspacing="0"><tr><td>
+                <textarea cols="40" rows="5" name="inf[vpers]" id="vpers"><?php echo $inf['vpers']; ?></textarea>
+                
+                </td>
+            <?php
+            if (isset($inf["vpn"]) && $inf["vpn"])
+            {
+//                $plist = substr($inf["vpn"],0,strlen($inf["vpn"])-1);
+                if (strpos($inf["vpn"],",") === 0) $inf["vpn"] = substr($inf["vpn"],1);
+                echo "<td><table cellspacing='0' cellpadding='0'>";
+                $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname) AS ma FROM Mitarbeiter WHERE persknr IN (".$inf["vpn"].") ORDER BY 2";
+                if ($result = $dbc->queryObjectArray($sql))
+                foreach ($result as $row)
+                {
+                    echo "<tr><td class='valignb'>&nbsp;&nbsp;&nbsp;$row->ma:&nbsp;</td>";
+                    echo "<td class='valignb' width='40%'> <input name='inf[prio][$row->persknr]' type='text' size='50' maxlength='50' value='". $inf["prio"][$row->persknr] . "' />\n";
+                    echo "</td></tr>";
+                }
+                echo "</table></td>\n";    
+            }
+            ?>
+        </tr></table></td>
+    </tr>
+    <?php 
+        if ($inf['ityp'] == 6 && strtolower(substr($inf['sort'],0,2)) == 'bk')
+        {
+            echo "<tr><td>KST: <i>Obergrenze Bestellwert</i> (&euro;)</td>";
+            echo "<td><input name=\"inf[betr]\" type=\"text\" value=\"" . $inf['betr'] . "\" size='15' /></td></tr>\n";    
+        }
+    ?>
+    <tr><td>Sprache</td>
+        <td><select name="inf[lang]">
+        <?php
+                if ($inf['lang'] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $alang = array("de"=>"deutsch","en"=>"englisch");
+                foreach ($alang as $key=>$value)
+                {
+                    if ($inf['lang'] == $key) $select = " selected "; else $select = "";
+                    echo "<option $select value=\"$key\">$value</option>\n";
+                }
+        ?>
+        </select></td>
+    </tr>
+    <tr>
+        <td>zugeordnet zu Produkt<br /><br />
+            &nbsp;&nbsp;&nbsp;Mehrfachauswahl m&ouml;glich:<br />
+            &nbsp;&nbsp;&nbsp;[Strg]-Taste + Anklicken der<br /> 
+            &nbsp;&nbsp;&nbsp;gewünschten Listeneinträge</td>
+        <td>
+            <select name="inf[prid][]" size="6" multiple="multiple">
+            <?php 
+                if (is_array($inf['prid'])) $select = in_array( "-1", $inf['prid'] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+//                $sql = "SELECT produkt_ID, LEFT(prod_name,70) AS prod, LENGTH(prod_name) AS lenp FROM Produkt ORDER BY 2";
+                $sql = "CALL prod_hiera_all(0,0)";  
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if (strlen($row->bez) > 70) 
+                            $prod=str_replace(" ","&nbsp;",htmlentities(substr($row->bez,0,70))) ."..."; 
+                        else 
+                            $prod=str_replace(" ","&nbsp;",htmlentities($row->bez));
+                        if ($row->prid >0) $color=" class='green'"; else $color="";
+                        if (is_array($inf['prid'])) $select = in_array($row->prid, $inf['prid']) ? ' selected' : null;
+                        echo "<option $color $select value=\"$row->prid\">$prod</option>\n";
+                    }
+                }
+                unset($result);
+            ?>
+            </select>
+            <br />bitte nur die <font color="green">gr&uuml;nen</font> Eintr&auml;ge w&auml;hlen
+        </td>
+    </tr>
+    <tr><td>Adressat<br /><br />
+            &nbsp;&nbsp;&nbsp;Mehrfachauswahl m&ouml;glich</td>
+        <td><select name="inf[adr][]" size="4" multiple="multiple">
+            <?php
+                if (is_array($inf['adr'])) $select = in_array( "-1", $inf['adr'] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT info_adr_ID, info_adr_name FROM Adressat ORDER BY 2";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if (is_array($inf['adr'])) $select = in_array( $row->info_adr_ID, $inf['adr'] ) ? ' selected' : null;
+       					echo "<option $select value=\"$row->info_adr_ID\">$row->info_adr_name</option>\n";
+                    }
+                }
+            ?>
+        </select>
+        </td>
+    </tr>
+    <?php 	include($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/form/info_file_form.inc.php"); ?>
+<!--	<tr>
+	   <td>Dateibezeichnung Dokument (*)</td>
+	   <td><input name="inf[ifname]" type="text" size="50" maxlength="50" value="<?php echo $inf['ifname']; ?>" />
+	   <?php
+/*
+            echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!";   
+			if (isset($inf['ifname']) && $upd && is_uploaded_file($_FILES["ifile"]["tmp_name"]) && $inf['ifname']<'!')
+				{
+					echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
+					$okn = false;
+				}
+				else
+				{
+                    if ($inf['ifname']>='!' && file_exists("infos/".$inf['ifname']))
+                        echo "<br />Dokument anschauen:&nbsp;<a href='infos/" . $inf['ifname'] ."'>" . $inf['ifname'] . "</a>";
+                    if ($okn) $okn = true; else $okn=false;
+                }
+*/
+		?>
+		</td>
+    </tr>
+-->
+        <?php                 
+            if ($inf["tstmp"] && $inf["tstmp"]>0)
+            {
+                echo "<tr><td>letzte &Auml;nderung</td>";
+                $ts = new DateTime($inf["tstmp"]);    
+                echo "<td>".$ts->format('d.m.Y H:i:s');   
+            }
+            if (isset($inf["uid"]) && $inf["uid"]) 
+                echo "&nbsp;&nbsp;&nbsp;(".$inf["uid"] .")";
+            echo "</td></tr>\n"; 
+        ?>
+
+    <input type="hidden" name="inf[pers]" id="pid" value="<?php echo $inf['pers']; // Author ?>"/> 
+    <input type="hidden" name="inf[vpn]" id="vpid" value="<?php echo $inf['vpn']; // Verantwortliche ?>"/> 
+    <input type="hidden" name="MAX_FILE_SIZE" value="10000000"/>    
+    <input type="hidden" name="inf[okn]" value="<?php echo $okn; ?>"/>
+<!--  </table>
+ </div>   
 </form> -->
\ No newline at end of file