<?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  if ($rvnr == 1) echo "onchange=\"this.form.submit();\""; ?>>
            <?php 
                if (is_array($_SESSION["prodg"]))
                {
                        foreach ($_SESSION["prodg"] as $val)
                            $listg .= ",'" .$val . "'";
                        $listg = substr($listg,1);
                }
                else
                {
                    if ($vr["prodg"] == -1) $select = " selected "; else $select = "";
                    echo "<option $select value=\"-1\"></option>\n";
                }    
                //Einschraenkung Produktgruppe
                if (isset($listg) && $listg) $wher = " WHERE prod_group_ID IN ($listg) "; else $wher = "";
                $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe $wher ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    $select = "";
                    foreach ($result as $row)
                    {
                        if (isset($vr["prodg"])) $select = ($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>
    <?php if ($rvnr == 1)
    { ?>
    <tr>
        <td>Produkt</td>
        <td><select name="vr[prod]">
            <?php 
                if ($vr["prod"] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                if (isset($vr["prodg"]) && $vr["prodg"] > -1) 
                    $where = " WHERE prod_group_ID = $vr[prodg] ";
                elseif ($listg>"")
                    $where = " WHERE prod_group_ID IN ($listg) "; 
                else $where = "";
                $sql = "SELECT produkt_ID, prod_name FROM Produkt $where ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    $select = null;
                   foreach ($result as $row)
                    {
                        if (isset($vr["prod"])) $select = ( $row->produkt_ID == $vr["prod"] ) ? ' selected' : null;
    					   echo "<option $select value=\"$row->produkt_ID\">$row->prod_name</option>\n";
                    }
                }
            ?>
            </select>
        </td>
    </tr>
    <?php 
    } ?>
    <tr>
        <td>Vertrag-Typ</td>
        <td><select name="vr[vtyp]">
            <?php 
                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))
                {
                    $select = null;
                    foreach ($result as $row)
                    {
                        if (isset($vr["vtyp"])) $select = ( $row->vtyp_ID == $vr["vtyp"] ) ? ' selected' : null;
	                       echo "<option $select value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
                    }
            }
            ?>
            </select>
        </td>
    </tr>
    <?php if ($rvnr == 2)
    { ?>
    <tr><td>gew&uuml;nschtes<br />K&uuml;ndigungsdatum</td>
        <td valign="top"><input type="text" name="vr[kd]" id="kd" value="<?php echo $vr['kd']; ?>"/>
        </td>
    </tr>
    <?php 
    } ?>
    <?php if ($rvnr == 1)
    { ?>
    <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($ja)) 
        				echo "<option selected>$ja</option>\n";
        			else		
        				echo "<option>$i</option>\n";
        		  }
    		 ?> 
    		 </select>
        </td>
    </tr>    
    <?php 
    } ?>
    <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
        if ($rvnr == 1)
            $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Jahr");
        elseif ($rvnr ==2)
            $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","12"=>"Partner","13"=>"K&uuml;ndigungstermin");
        for ($i=1; $i<count($sort); $i++)
        { 
          echo "$i.&nbsp;&nbsp;<select name='vr[sort$i]'>\n";
          foreach ($sort as $key=>$val)
          {
            if ($vr["sort$i"] == $key) $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>