--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/vertrag_form.inc.php Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,390 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 05/2011
+ *
+ * Form Vertrag
+ */
+
+ include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+ if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+ $okn = true;
+
+?>
+<div align="center">
+<?php
+ if (strpos($_SERVER['PHP_SELF'],"ins") > -1) $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="application/x-www-form-urlencoded" name="form_svc"> -->
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_vertrag" target="_self">
+<div align="center">
+<table width="50%" 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]" 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 align="left"><select name="vertrag[btag]" size="1">
+ <?php
+ if (!$vtr['btag'] ) $ta1=0; else $ta1 = $vtr['btag'];
+ for ($i=0; $i<32; $i++)
+ { if ($i==intval($ta1))
+ {
+ if ($i == 0)
+ echo "<option selected></option>\n";
+ else
+ echo "<option selected>$ta1</option>\n";
+ }
+ else {
+ if ($i<10)
+ {
+ if ($i == 0)
+ echo "<option></option>\n";
+ else
+ echo "<option>0$i</option>\n";
+ }
+ else
+ echo "<option>$i</option>\n";
+ }
+ }
+ ?>
+ </select>.
+ <select name="vertrag[bmon]" size="1">
+ <?php
+ if (!$vtr['bmon'] ) $mo1=0; else $mo1 = $vtr['bmon'];
+ for ($i=0; $i<13; $i++)
+ { if ($i==intval($mo1))
+ {
+ if ($i == 0)
+ echo "<option selected></option>\n";
+ else
+ echo "<option selected>$mo1</option>\n";
+ }
+ else {
+ if ($i<10)
+ {
+ if ($i == 0)
+ echo "<option></option>\n";
+ else
+ echo "<option>0$i</option>\n";
+ }
+ else
+ echo "<option>$i</option>\n";
+ }
+ }
+ ?>
+ </select>.
+ <select name="vertrag[bjahr]" size="1">
+ <?php
+
+ if (!$vtr['bjahr'] )
+ echo "<option selected></option>\n";
+ else
+ echo "<option></option>\n";
+ $ja1 = $vtr['bjahr'];
+ for ($i=2000; $i<2036; $i++)
+ { if ($i==intval($ja1))
+ echo "<option selected>$ja1</option>\n";
+ else
+ echo "<option>$i</option>\n";
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Datum Vertragende</td>
+ <td align="left"><select name="vertrag[etag]" size="1">
+ <?php
+ if (!$vtr['etag'] ) $ta1=0; else $ta1 = $vtr['etag'];
+ for ($i=0; $i<32; $i++)
+ { if ($i==intval($ta1))
+ {
+ if ($i == 0)
+ echo "<option selected></option>\n";
+ else
+ echo "<option selected>$ta1</option>\n";
+ }
+ else {
+ if ($i<10)
+ {
+ if ($i == 0)
+ echo "<option></option>\n";
+ else
+ echo "<option>0$i</option>\n";
+ }
+ else
+ echo "<option>$i</option>\n";
+ }
+ }
+ ?>
+ </select>.
+ <select name="vertrag[emon]" size="1">
+ <?php
+ if (!$vtr['emon'] ) $mo1=0; else $mo1 = $vtr['emon'];
+ for ($i=0; $i<13; $i++)
+ { if ($i==intval($mo1))
+ {
+ if ($i == 0)
+ echo "<option selected></option>\n";
+ else
+ echo "<option selected>$mo1</option>\n";
+ }
+ else {
+ if ($i<10)
+ {
+ if ($i == 0)
+ echo "<option></option>\n";
+ else
+ echo "<option>0$i</option>\n";
+ }
+ else
+ echo "<option>$i</option>\n";
+ }
+ }
+ ?>
+ </select>.
+ <select name="vertrag[ejahr]" size="1">
+ <?php
+
+ if (!$vtr['ejahr'] )
+ echo "<option selected></option>\n";
+ else
+ echo "<option></option>\n";
+ $ja1 = $vtr['ejahr'];
+ for ($i=2000; $i<2036; $i++)
+ { if ($i==intval($ja1))
+ echo "<option selected>$ja1</option>\n";
+ else
+ echo "<option>$i</option>\n";
+ }
+ ?>
+ </select>
+ <?php
+ if ($vtr['bjahr'] && $vtr['bmon'] && $vtr['btag'] && $vtr['ejahr'] && $vtr['emon'] && $vtr['etag'])
+ {
+ $dat = $vtr['ejahr']."-".$vtr['emon']."-".$vtr['etag'];
+ $edate = new DateTime("$dat");
+ $edate = $edate->add(new DateInterval('P1D'));
+ $dat = $vtr['bjahr']."-".$vtr['bmon']."-".$vtr['btag'];
+ $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>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>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
+ 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, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter 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['bjahr'])
+ {
+ echo "<tr>
+ <td>jährliche Kosten (€)</td><br />
+ <td>";
+ $j=0;
+ if ($vtr['ejahr'])
+ {
+ for ($i=(int)$vtr['bjahr']; $i<(int)$vtr['ejahr']+1; $i++ )
+ {
+ echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"$i\"/> ";
+ echo "<input name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/><br />";
+ $j++;
+ }
+ }
+ else
+ {
+ echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"" . $vtr['bjahr'] . "\"/> ";
+ echo "<input 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";
+ }
+ }
+*/
+ $sql = "CALL 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>Dateibezeichnung Dokument *</td>
+ <td><input name="vertrag[cfname]" type="text" size="50" maxlength="50" value="<?php echo $vtr['cfname']; ?>">
+ <?php
+ echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!";
+ if (isset($vtr['cfname']) && $vtr['cfname']<'!')
+ {
+ echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
+ $okn = false;
+ }
+ else
+ {
+ if ($vtr['cfname']>='!' && file_exists("documents/".$vtr['cfname']))
+ echo "<br />Dokument anschauen: <a href='documents/" . $vtr['cfname'] ."'>" . $vtr['cfname'] . "</a>";
+ if ($okn) $okn = true; else $okn=false;
+ }
+ ?>
+ </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>
+
+ <input type="hidden" name="MAX_FILE_SIZE" value="6000000"/>
+ <input type="hidden" name="vertrag[okn]" value="<?php echo $okn; ?>"/>
+
+<!-- </table>
+ </div>
+</form> -->
\ No newline at end of file