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

                ODER   

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