--- a/fhiiqm/form/vertragmf_form.inc.php Wed Jul 31 15:10:48 2013 +0200
+++ b/fhiiqm/form/vertragmf_form.inc.php Thu Sep 12 09:04:56 2013 +0200
@@ -1,349 +1,358 @@
-<?php
-
-/**
- * @author Bettina Schwarzer, Fritz-Haber-Institut
- * @copyright 03/2013
- *
- * Form Vertrag Multifile
- */
-
- 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("ve",$_SESSION["recht"]))
- $text = "";
- else
- if (!$cid) $text = "Eingabe"; else $text="Ändern / Löschen";
-?>
-<h3><font face="Verdana, Arial, Helvetica, sans-serif"><?php echo $text;?> Vertragsdaten</font></h3>
-<h5>* - Felder sind erforderlich!</h5>
-</div>
-<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_vertrag" target="_self">
-<div align="center">
-<table width="70%" border="0" cellspacing="3" cellpadding="3">
-<!-- <tr>
- <td>Vertrag-ID *</td>
- <td><input name="vertrag[cid]" type="text" size="10" maxlength="6" value="<?php echo $vtr['cid']; ?>"/>
- <?php
- /* if (isset($vtr['cid']) && $vtr['cid']<'!')
- {
- echo "<br><span class=\"red\">ID ist erforderlich!</span>\n";
- $okn = false;
- }
- else
- $okn = true; */
- ?>
- </td>
- </tr>
--->
- <tr>
- <td>Vertragsbezeichnung *</td>
- <td><input name="vertrag[cname]" id="bez" type="text" size="50" maxlength="50" value="<?php echo $vtr['cname']; ?>"/>
- <?php
- if (isset($vtr['cname']) && $vtr['cname']<'!')
- {
- echo "<br><span class=\"red\">Bezeichnung ist erforderlich!</span>\n";
- $okn = false;
- }
- else
- if ($okn) $okn = true; else $okn=false;
- ?>
- </td>
- </tr>
-<!-- <tr>
- <td>Vertrag Titel</td>
- <td><input name="vertrag[cshort]" type="text" size="30" maxlength="50" value="<?php echo $vtr['cshort']; ?>"/></td>
- </tr>
--->
- <tr>
- <td>Vertrag Beschreibung</td>
- <td><textarea name="vertrag[clong]" cols="50" rows="2"><?php echo $vtr['clong']; ?></textarea>
- <div>max. 100 Zeichen sind möglich</div></td>
- </tr>
- <tr>
- <td>Vertrag-Typ</td>
- <td><select name="vertrag[vtyp]">
- <?php
- if ($vtr['vtyp'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if ($row->vtyp_ID == $vtr['vtyp'])
- echo "<option selected value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
- else
- echo "<option value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
- }
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td>Datum Vertragbeginn</td>
- <td><input class="long10" name="vertrag[bdat]" id="bdat" value="<?php echo $vtr['bdat']; ?>" />
- </tr>
- <tr>
- <td>Datum Vertragende</td>
- <td><input class="long10" name="vertrag[edat]" id="edat" value="<?php echo $vtr['edat']; ?>" />
- <?php
- if ($vtr['bdat'] && $vtr['edat'])
- {
- $dat = $vtr['edat'];
- $edate = new DateTime("$dat");
- $edate = $edate->add(new DateInterval('P1D'));
- $dat = $vtr['bdat'];
- $bdate = new DateTime("$dat");
- $diff = $edate->diff($bdate);
- echo "<br />Vertragsdauer: ".$diff->format('%y Jahr(e), %m Monat(e), %d Tag(e)');
- }
- ?>
- </td>
- </tr>
- <tr>
- <td>automatische Verlängerung</td>
- <td><input name="vertrag[cautoend]" type="checkbox" value="1" <?php if ($vtr["cautoend"]) echo "checked";?>/></td>
- </tr>
- <tr>
- <td>Kündigungsfrist<br />(Monate vor Ablauf)</td>
- <td><input name="vertrag[cnot]" type="text" size="10" maxlength="3" value="<?php echo $vtr['cnot']; ?>"/></td>
- </tr>
- <tr>
- <td>autom. E-Mail vor Vertr.-Ende</td>
- <td><input name="vertrag[email]" type="checkbox" value="1" <?php if ($vtr["email"]) echo "checked";?>/></td>
- </tr>
- <tr>
- <td>Partner (Firma)</td>
- <td>
- <select name="vertrag[partid]">
- <?php
- if ($vtr['partid'] == -1) $select = " selected "; else $select = "";
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT part_ID, part_firma FROM Partner ORDER BY 2";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if ($row->part_ID == $vtr['partid'])
- echo "<option selected value=\"$row->part_ID\">$row->part_firma</option>\n";
- else
- echo "<option value=\"$row->part_ID\">$row->part_firma</option>\n";
- }
- //$result->free();
- }
- ?>
- </select> oder neu
- <input name="vertrag[partner]" type="text" size="30" maxlength="50" value="<?php echo $vtr['partner']; ?>"/>
- </td>
- </tr>
- <tr>
- <td>Ansprechpartner FHI <br /><br />
- Mehrfachauswahl möglich:<br />
- [Strg]-Taste + Anklicken der<br />
- gewünschten Listeneinträge
- </td>
- <td>
- <select name="vertrag[cpers][]" size="7" multiple="multiple">
- <?php
- $select = null;
- if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
- echo "<option $select value=\"-1\"></option>\n";
- $sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null;
- echo "<option $select value=\"$row->persknr\">$row->pname</option>\n";
- }
- }
- ?>
- </select>
- </td>
- </tr>
- <?php
- if ($vtr['bdat'])
- {
- echo "<tr>
- <td>jährliche Teilbrutto-Kosten (€)</td><br />
- <td>";
- $j=0;
- if ($vtr['edat'])
- {
- $dat = $vtr['edat'];
- $edate = new DateTime("$dat");
- $ejahr = $edate->format("Y");
- }
- elseif ($vtr["cautoend"]) // automatische Vertragsverlaengerung und kein Endjahr angegeben
- $ejahr = date("Y");
- else
- $ejahr = null;
- if ($ejahr)
- {
- $dat = $vtr['bdat'];
- $bdate = new DateTime("$dat");
- $bjahr = $bdate->format("Y");
- for ($i=(int)$bjahr; $i<(int)$ejahr+1; $i++ )
- {
- echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"$i\"/> ";
- echo "<input class='right' name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/><br />\n";
- $j++;
- }
- }
- else
- {
- echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"" . $vtr['bjahr'] . "\"/> ";
- echo "<input class='right' name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/>";
- }
-
- echo "</td>
- </tr>";
- }
- ?>
- <tr>
- <td>zugeordnet zu </td>
- <td>
- <select name="vertrag[prodid]">
- <?php
- if ($vtr['prodid'] == -1) $select = " selected "; else $select = "";
- 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";
-/* if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if ($row->lenp > 70) $prod=$row->prod ."..."; else $prod=$row->prod;
- if ($row->produkt_ID == $vtr['prodid'])
- echo "<option selected value=\"$row->produkt_ID\">$prod</option>\n";
- else
- echo "<option value=\"$row->produkt_ID\">$prod</option>\n";
- }
- }
-*/
- // Recht Produktgruppe beruecksichtigen
- if (is_array($_SESSION["prodg"]))
- {
- foreach ($_SESSION["prodg"] as $val)
- $listg .= "," .$val;
- $listg = substr($listg,1);
- $sql = "CALL fhiiqm.hier_prodgroup('$listg')";
- }
- else
- $sql = "CALL fhiiqm.prod_hiera_all(0,0)";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if (strlen($row->bez) > 70)
- $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."...";
- else
- $prod=str_replace(" "," ",htmlentities($row->bez));
- if ($row->prid >0) $color=" class='green'"; else $color="";
- if ($row->prid == $vtr['prodid'])
- echo "<option $color selected value=\"$row->prid\">$prod</option>\n";
- else
- echo "<option $color value=\"$row->prid\">$prod</option>\n";
- }
- }
- unset($row);
- unset($result);
- $sql=null;
- ?>
- </select>
- <br />bitte nur die <font color="green">grünen</font> Einträge wählen
- </td>
- </tr>
- <tr>
- <td>Bemerkung</td>
- <td><textarea name="vertrag[cbem]" cols="50" rows="5"><?php echo $vtr['cbem']; ?></textarea>
- <div>max. 500 Zeichen sind möglich</div></td>
- </tr>
- <?php
- if (isset($vtr['cfname'])) $anzdoc = count($vtr['cfname']); else $anzdoc = 1;
- echo
- "<tr>
- <td>Vertragsdokumente
- <br /> bitte <u>keine</u> Umlaute<br /> in gewählten Dateinamen angeben!</td>
- <td><div id='adddoc'>
- <span></span>\nDok-Name <input name=\"vertrag[cfname][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"". $vtr['cfname'][0] ."\" />
-
- Schlagwort <input type='text' name=vertrag[swort][] size=\"30\" maxlength=\"50\" value='".$vtr['swort'][0]."' />";
- echo "<input class='pr' type='checkbox' id='del_0' name='vertrag[del][0]' value='1'/>";
- echo " <a href=\"javascript:addInput('adddoc',$anzdoc)\" title=\"weiteres Dokument\"><img src=\"/fhiiqm/img/add.png\" /></a>
- <a href=\"javascript:markdelInput('adddoc',$anzdoc)\" title=\"löschen markiertes Dokument\"><img src=\"/fhiiqm/img/delete.png\" /></a>";
- if (isset($vtr['cfname'][0]) && $vtr['cfname'][0]<'!')
- {
- echo "<br /><span class=\"red\">Dateiname ist erforderlich!</span>\n";
- $okn = false;
- }
- else
- if ($vtr['cfname'][0]>='!' && $okn) $okn = true; else $okn = false;
- if ($sub)
- {
- echo "<br />Upload-Dokument
- <input type=\"file\" name=\"vfile[]\" size=\"50\" maxlength=\"50\" value=\"" .$_FILES["vfile"]["name"][0] . "\"/>";
- }
- if ($sub || (isset($vtr) && !$ok))
- {
- if (count($vtr['cfname'])>1)
- {
- $i=0;
- foreach ($vtr['cfname'] as $akt)
- {
- if ($i>0)
- {
- echo "<span></span><br />\nDok-Name
- <input name=\"vertrag[cfname][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"". $vtr['cfname'][$i] ."\" />
-
- Schlagwort <input type='text' name=vertrag[swort][] size=\"30\" maxlength=\"50\" value='".$vtr['swort'][$i]."' />";
- if (isset($vtr['del'])) $cls = "dispil"; else $cls = "pr";
- if (isset($vtr['del'][$i])) $chk = "checked = ' checked'"; else $chk ="";
- echo "<span id='cbl_$i'> <input class='$cls' type='checkbox' id='del_$i' name='vertrag[del][$i]' value='1'$chk /></span>
- <span id='lb_$i' class='$cls'> löschen?</span>";
- if (isset($vtr['cfname'][$i]) && $vtr['cfname'][$i]<'!')
- {
- echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
- $okn = false;
- }
- else
- if ($vtr['cfname'][$i]>='!' && $okn) $okn = true; else $okn = false;
- echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";
- if ($sub)
- {
- echo "<br />Upload-Dokument
- <input type=\"file\" name=\"vfile[]\" size=\"50\" maxlength=\"50\" value=\"" .$_FILES["vfile"]["name"][$i] . "\"/>";
- }
- }
- $i++;
- }
- }
- }
- echo "
- </div>";
- if (count($vtr['cfname'])>0)
- {
- $i=0;
- foreach ($vtr['cfname'] as $akt)
- {
- if ($vtr['cfname'][$i]>='!' && file_exists("documents/".$vtr['cfname'][$i]))
- echo "<br />Dokument anschauen: <a href='/fhiiqm/documents/" . $vtr['cfname'][$i] ."'>" . $vtr['cfname'][$i] . "</a>";
- $i++;
- }
- }
-
- echo "</td>
- </tr>\n";
- ?>
-
- <input type="hidden" name="MAX_FILE_SIZE" value="10000000"/>
- <input type="hidden" name="vertrag[okn]" value="<?php echo $okn; ?>"/>
-
-<!-- </table>
- </div>
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 03/2013
+ *
+ * Form Vertrag Multifile
+ */
+
+ 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("ve",$_SESSION["recht"]))
+ $text = "";
+ else
+ if (!$cid) $text = "Eingabe"; else $text="Ändern / Löschen";
+?>
+<h3><font face="Verdana, Arial, Helvetica, sans-serif"><?php echo $text;?> Vertragsdaten</font></h3>
+<h5>* - Felder sind erforderlich!</h5>
+</div>
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_vertrag" target="_self">
+<div align="center">
+<table width="70%" border="0" cellspacing="3" cellpadding="3">
+<!-- <tr>
+ <td>Vertrag-ID *</td>
+ <td><input name="vertrag[cid]" type="text" size="10" maxlength="6" value="<?php echo $vtr['cid']; ?>"/>
+ <?php
+ /* if (isset($vtr['cid']) && $vtr['cid']<'!')
+ {
+ echo "<br><span class=\"red\">ID ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ else
+ $okn = true; */
+ ?>
+ </td>
+ </tr>
+-->
+ <tr>
+ <td>Vertragsbezeichnung *</td>
+ <td><input name="vertrag[cname]" id="bez" type="text" size="50" maxlength="50" value="<?php echo $vtr['cname']; ?>"/>
+ <?php
+ if (isset($vtr['cname']) && $vtr['cname']<'!')
+ {
+ echo "<br><span class=\"red\">Bezeichnung ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ else
+ if ($okn) $okn = true; else $okn=false;
+ ?>
+ </td>
+ </tr>
+<!-- <tr>
+ <td>Vertrag Titel</td>
+ <td><input name="vertrag[cshort]" type="text" size="30" maxlength="50" value="<?php echo $vtr['cshort']; ?>"/></td>
+ </tr>
+-->
+ <tr>
+ <td>Vertrag Beschreibung</td>
+ <td><textarea name="vertrag[clong]" cols="50" rows="2"><?php echo $vtr['clong']; ?></textarea>
+ <div>max. 100 Zeichen sind möglich</div></td>
+ </tr>
+ <tr>
+ <td>Vertrag-Typ</td>
+ <td><select name="vertrag[vtyp]">
+ <?php
+ if ($vtr['vtyp'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->vtyp_ID == $vtr['vtyp'])
+ echo "<option selected value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
+ else
+ echo "<option value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Datum Vertragbeginn</td>
+ <td><input class="long10" name="vertrag[bdat]" id="bdat" value="<?php echo $vtr['bdat']; ?>" />
+ </tr>
+ <tr>
+ <td>Datum Vertragende</td>
+ <td><input class="long10" name="vertrag[edat]" id="edat" value="<?php echo $vtr['edat']; ?>" />
+ <?php
+ if ($vtr['bdat'] && $vtr['edat'])
+ {
+ $dat = $vtr['edat'];
+ $edate = new DateTime("$dat");
+ $edate = $edate->add(new DateInterval('P1D'));
+ $dat = $vtr['bdat'];
+ $bdate = new DateTime("$dat");
+ $diff = $edate->diff($bdate);
+ echo "<br />Vertragsdauer: ".$diff->format('%y Jahr(e), %m Monat(e), %d Tag(e)');
+ }
+ ?>
+ </td>
+ </tr>
+ <tr>
+ <td>automatische Verlängerung</td>
+ <td><input name="vertrag[cautoend]" type="checkbox" value="1" <?php if ($vtr["cautoend"]) echo "checked";?>/></td>
+ </tr>
+ <tr>
+ <td>Kündigungsfrist<br />(Monate vor Ablauf)</td>
+ <td><input name="vertrag[cnot]" type="text" size="10" maxlength="3" value="<?php echo $vtr['cnot']; ?>"/></td>
+ </tr>
+ <tr>
+ <td>autom. E-Mail vor Vertr.-Ende</td>
+ <td><input name="vertrag[email]" type="checkbox" value="1" <?php if ($vtr["email"]) echo "checked";?>/></td>
+ </tr>
+ <tr>
+ <td>Partner (Firma)</td>
+ <td>
+ <select name="vertrag[partid]">
+ <?php
+ if ($vtr['partid'] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT part_ID, part_firma FROM Partner ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->part_ID == $vtr['partid'])
+ echo "<option selected value=\"$row->part_ID\">$row->part_firma</option>\n";
+ else
+ echo "<option value=\"$row->part_ID\">$row->part_firma</option>\n";
+ }
+ //$result->free();
+ }
+ ?>
+ </select> oder neu
+ <input name="vertrag[partner]" type="text" size="30" maxlength="50" value="<?php echo $vtr['partner']; ?>"/>
+ </td>
+ </tr>
+ <tr>
+ <td>Ansprechpartner FHI <br /><br />
+ Mehrfachauswahl möglich:<br />
+ [Strg]-Taste + Anklicken der<br />
+ gewünschten Listeneinträge
+ </td>
+ <td>
+ <select name="vertrag[cpers][]" size="7" multiple="multiple">
+ <?php
+ $select = null;
+ if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null;
+ echo "<option $select value=\"$row->persknr\">$row->pname</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <?php
+ if ($vtr['bdat'])
+ {
+ echo "<tr>
+ <td>jährliche Teilbrutto-Kosten (€)</td><br />
+ <td>";
+ $j=0;
+ if ($vtr['edat'])
+ {
+ $dat = $vtr['edat'];
+ $edate = new DateTime("$dat");
+ $ejahr = $edate->format("Y");
+ }
+ elseif ($vtr["cautoend"]) // automatische Vertragsverlaengerung und kein Endjahr angegeben
+ $ejahr = date("Y");
+ else
+ $ejahr = null;
+ if ($ejahr)
+ {
+ $dat = $vtr['bdat'];
+ $bdate = new DateTime("$dat");
+ $bjahr = $bdate->format("Y");
+ for ($i=(int)$bjahr; $i<(int)$ejahr+1; $i++ )
+ {
+ echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"$i\"/> ";
+ echo "<input class='right' name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/><br />\n";
+ $j++;
+ }
+ }
+ else
+ {
+ echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"" . $vtr['bjahr'] . "\"/> ";
+ echo "<input class='right' name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/>";
+ }
+
+ echo "</td>
+ </tr>";
+ }
+ ?>
+ <tr>
+ <td>zugeordnet zu </td>
+ <td>
+ <select name="vertrag[prodid]">
+ <?php
+ if ($vtr['prodid'] == -1) $select = " selected "; else $select = "";
+ 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";
+/* if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->lenp > 70) $prod=$row->prod ."..."; else $prod=$row->prod;
+ if ($row->produkt_ID == $vtr['prodid'])
+ echo "<option selected value=\"$row->produkt_ID\">$prod</option>\n";
+ else
+ echo "<option value=\"$row->produkt_ID\">$prod</option>\n";
+ }
+ }
+*/
+ // Recht Produktgruppe beruecksichtigen
+ if (is_array($_SESSION["prodg"]))
+ {
+ foreach ($_SESSION["prodg"] as $val)
+ $listg .= "," .$val;
+ $listg = substr($listg,1);
+ $sql = "CALL fhiiqm.hier_prodgroup('$listg')";
+ }
+ else
+ $sql = "CALL fhiiqm.prod_hiera_all(0,0)";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if (strlen($row->bez) > 70)
+ $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."...";
+ else
+ $prod=str_replace(" "," ",htmlentities($row->bez));
+ if ($row->prid >0) $color=" class='green'"; else $color="";
+ if ($row->prid == $vtr['prodid'])
+ echo "<option $color selected value=\"$row->prid\">$prod</option>\n";
+ else
+ echo "<option $color value=\"$row->prid\">$prod</option>\n";
+ }
+ }
+ unset($row);
+ unset($result);
+ $sql=null;
+ ?>
+ </select>
+ <br />bitte nur die <font color="green">grünen</font> Einträge wählen
+ </td>
+ </tr>
+ <tr>
+ <td>Bemerkung</td>
+ <td><textarea name="vertrag[cbem]" cols="50" rows="5"><?php echo $vtr['cbem']; ?></textarea>
+ <div>max. 500 Zeichen sind möglich</div></td>
+ </tr>
+ <?php
+ if (isset($vtr['cfname'])) $anzdoc = count($vtr['cfname']); else $anzdoc = 1;
+ echo
+ "<tr>
+ <td>Vertragsdokumente
+ <br /> bitte <u>keine</u> Umlaute<br /> in gewählten Dateinamen angeben!</td>
+ <td><div id='adddoc'>
+ <span></span>\nDok-Name <input name=\"vertrag[cfname][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"". $vtr['cfname'][0] ."\" />
+
+ Schlagwort <input type='text' name=vertrag[swort][] size=\"30\" maxlength=\"50\" value='".$vtr['swort'][0]."' />";
+ echo "<input class='pr' type='checkbox' id='del_0' name='vertrag[del][0]' value='1'/>";
+ echo " <a href=\"javascript:addInput('adddoc',$anzdoc)\" title=\"weiteres Dokument\"><img src=\"/fhiiqm/img/add.png\" /></a>
+ <a href=\"javascript:markdelInput('adddoc',$anzdoc)\" title=\"löschen markiertes Dokument\"><img src=\"/fhiiqm/img/delete.png\" /></a>";
+ if (isset($vtr['cfname'][0]) && $vtr['cfname'][0]<'!')
+ {
+ echo "<br /><span class=\"red\">Dateiname ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ else
+ if ($vtr['cfname'][0]>='!' && $okn) $okn = true; else $okn = false;
+ if ($sub)
+ {
+ echo "<br />Upload-Dokument
+ <input type=\"file\" name=\"vfile[]\" size=\"50\" maxlength=\"50\" value=\"" .$_FILES["vfile"]["name"][0] . "\"/>";
+ }
+ if ($sub || (isset($vtr) && !$ok))
+ {
+ if (count($vtr['cfname'])>1)
+ {
+ $i=0;
+ foreach ($vtr['cfname'] as $akt)
+ {
+ if ($i>0)
+ {
+ echo "<span></span><br />\nDok-Name
+ <input name=\"vertrag[cfname][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"". $vtr['cfname'][$i] ."\" />
+
+ Schlagwort <input type='text' name=vertrag[swort][] size=\"30\" maxlength=\"50\" value='".$vtr['swort'][$i]."' />";
+ if (isset($vtr['del'])) $cls = "dispil"; else $cls = "pr";
+ if (isset($vtr['del'][$i])) $chk = "checked = ' checked'"; else $chk ="";
+ echo "<span id='cbl_$i'> <input class='$cls' type='checkbox' id='del_$i' name='vertrag[del][$i]' value='1'$chk /></span>
+ <span id='lb_$i' class='$cls'> löschen?</span>";
+ if (isset($vtr['cfname'][$i]) && $vtr['cfname'][$i]<'!')
+ {
+ echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ else
+ if ($vtr['cfname'][$i]>='!' && $okn) $okn = true; else $okn = false;
+ echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";
+ if ($sub)
+ {
+ echo "<br />Upload-Dokument
+ <input type=\"file\" name=\"vfile[]\" size=\"50\" maxlength=\"50\" value=\"" .$_FILES["vfile"]["name"][$i] . "\"/>";
+ }
+ }
+ $i++;
+ }
+ }
+ }
+ echo "
+ </div>";
+ if (count($vtr['cfname'])>0)
+ {
+ $i=0;
+ foreach ($vtr['cfname'] as $akt)
+ {
+ if ($vtr['cfname'][$i]>='!' && file_exists("documents/".$vtr['cfname'][$i]))
+ echo "<br />Dokument anschauen: <a href='/fhiiqm/documents/" . $vtr['cfname'][$i] ."'>" . $vtr['cfname'][$i] . "</a>";
+ $i++;
+ }
+ }
+
+ echo "</td>
+ </tr>\n";
+ if ($vtr["tstmp"] && $vtr["tstmp"]>0)
+ {
+ echo "<tr><td>letzte Änderung</td>";
+ $ts = new DateTime($vtr["tstmp"]);
+ echo "<td>".$ts->format('d.m.Y H:i:s');
+ }
+ if (isset($vtr["uid"]) && $vtr["uid"])
+ echo " (".$vtr["uid"] .")";
+ echo "</td></tr>\n";
+ ?>
+
+ <input type="hidden" name="MAX_FILE_SIZE" value="10000000"/>
+ <input type="hidden" name="vertrag[okn]" value="<?php echo $okn; ?>"/>
+
+<!-- </table>
+ </div>
</form> -->
\ No newline at end of file