<?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>