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

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

                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

        if ($rvnr == 1)

            $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","10"=>"Kosten","11"=>"Jahr");

        elseif ($rvnr ==2)

            $sort = array("-1"=>"","2"=>"Vertragsbezeichnung","12"=>"Partner","13"=>"Kü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>