--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/vertrag_report_form.inc.php	Fri Sep 16 16:15:15 2011 +0200
@@ -0,0 +1,133 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 09/2011
+ * 
+ * Form Berichte Vertrag
+ */
+
+
+	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+    $okn = true;
+
+?>
+<div align="center">
+<h3><font face="Verdana, Arial, Helvetica, sans-serif"></font></h3>
+<p>Bitte Kriterien f&uuml;r den Vertragsbericht w&auml;hlen</p>
+</div>
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self">	
+<div align="center">
+<table width="50%" border="0" cellspacing="3" cellpadding="3">
+    <tr>
+        <td>Produktgruppe</td>
+        <td><select name="vr[prodg]">
+            <?php 
+                $select = null;
+                if ($vr["prodg"] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe ORDER BY 2";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if (is_array($vr["prodg"])) $select = in_array( $row->prod_group_ID, $vr["prodg"] ) ? ' selected' : null;
+    					   echo "<option $select value=\"$row->prod_group_ID\">$row->prod_group_name</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Produkt</td>
+        <td><select name="vr[prod]">
+            <?php 
+                $select = null;
+                if ($vr["prod"] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT produkt_ID, prod_name FROM Produkt ORDER BY 2";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if (is_array($vr["prod"])) $select = in_array( $row->produkt_ID, $vr["prod"] ) ? ' selected' : null;
+    					   echo "<option $select value=\"$row->produkt_ID\">$row->prod_name</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Vertrag-Typ</td>
+        <td><select name="vr[vtyp]">
+            <?php 
+                $select = null;
+                if ($vr['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 (is_array($vr["vtyp"])) $select = in_array( $row->vtyp_ID, $vr["vtyp"] ) ? ' selected' : null;
+	                       echo "<option $select value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
+                    }
+            }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Jahr</td>
+        <td>
+             <select name="vr[jahr]" size="1">
+    		 <?php
+        		if (!$vr['jahr'] ) 
+        		 	echo "<option selected value=\"-1\"></option>\n";  
+        		else
+        		 	echo "<option value=\"-1\"></option>\n";  
+        		$ja = $vr['jahr'];
+        		for ($i=2000; $i<2031; $i++)
+        		 {	if ($i==intval($j1)) 
+        				echo "<option selected>$ja1</option>\n";
+        			else		
+        				echo "<option>$i</option>\n";
+        		  }
+    		 ?> 
+    		 </select>
+        </td>
+    </tr>    
+    <tr> 
+          <td>Verkn&uuml;pfung</td>
+          <td>UND&nbsp;&nbsp;&nbsp;
+            <input type="radio" name="vr[bind]" value="AND" <?php if (isset($vr["bind"]) && $vr["bind"]=="AND") echo "checked"; else  echo "checked";?>>
+          &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ODER&nbsp;&nbsp;&nbsp;
+            <input type="radio" name="vr[bind]" value="OR" <?php if (isset($vr["bind"]) && $vr["bind"]=="OR") echo "checked"; ?>></td>
+    </tr>
+    <tr>
+        <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
+    <?php
+        $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Kostenjahr");
+        for ($i=1; $i<4; $i++)
+        { 
+          echo "$i.&nbsp;&nbsp;<select name='vr[sort$i]'>\n";
+          foreach ($sort as $key=>$val)
+          {
+            $rsort = $sort . $i;
+            if ($rag[$rsort] == $i) $select= " selected"; else $select = "";
+            echo "<option$select value='$key'>$val</option>\n";
+          }
+          echo "</select>&nbsp;&nbsp;&nbsp;&nbsp;\n";
+        } 
+        echo "</td></tr>\n";
+    ?>
+    <tr> 
+        <td>&nbsp;</td>
+        <td><input class="button" type="submit" name="create" value="Bericht erstellen"></td>
+    </tr>
+</table>
+</div>
+</form>
\ No newline at end of file