1 <?php

     2 

     3 /**

     4  * @author Bettina Schwarzer, Fritz-Haber-Institut

     5  * @copyright 09/2011

     6  * 

     7  * Form Berichte Vertrag

     8  */

     9 

    10 

    11 	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");

    12 	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();

    13     $okn = true;

    14 

    15 ?>

    16 <div align="center">

    17 <h3><font face="Verdana, Arial, Helvetica, sans-serif"></font></h3>

    18 <p>Bitte Kriterien f&uuml;r den Vertragsbericht w&auml;hlen</p>

    19 </div>

    20 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self">	

    21 <div align="center">

    22 <table width="50%" border="0" cellspacing="3" cellpadding="3">

    23     <tr>

    24         <td>Produktgruppe</td>

    25         <td><select name="vr[prodg]">

    26             <?php 

    27                 $select = null;

    28                 if ($vr["prodg"] == -1) $select = " selected "; else $select = "";

    29                 echo "<option $select value=\"-1\"></option>\n";

    30                 $sql = "SELECT prod_group_ID, prod_group_name FROM Produkt_Gruppe ORDER BY 2";

    31                 if ($result = $dbc->queryObjectArray($sql))

    32                 {

    33                     foreach ($result as $row)

    34                     {

    35                         if (is_array($vr["prodg"])) $select = in_array( $row->prod_group_ID, $vr["prodg"] ) ? ' selected' : null;

    36     					   echo "<option $select value=\"$row->prod_group_ID\">$row->prod_group_name</option>\n";

    37                     }

    38                 }

    39             ?>

    40             </select>

    41         </td>

    42     </tr>

    43     <tr>

    44         <td>Produkt</td>

    45         <td><select name="vr[prod]">

    46             <?php 

    47                 $select = null;

    48                 if ($vr["prod"] == -1) $select = " selected "; else $select = "";

    49                 echo "<option $select value=\"-1\"></option>\n";

    50                 $sql = "SELECT produkt_ID, prod_name FROM Produkt ORDER BY 2";

    51                 if ($result = $dbc->queryObjectArray($sql))

    52                 {

    53                     foreach ($result as $row)

    54                     {

    55                         if (is_array($vr["prod"])) $select = in_array( $row->produkt_ID, $vr["prod"] ) ? ' selected' : null;

    56     					   echo "<option $select value=\"$row->produkt_ID\">$row->prod_name</option>\n";

    57                     }

    58                 }

    59             ?>

    60             </select>

    61         </td>

    62     </tr>

    63     <tr>

    64         <td>Vertrag-Typ</td>

    65         <td><select name="vr[vtyp]">

    66             <?php 

    67                 $select = null;

    68                 if ($vr['vtyp'] == -1) $select = " selected "; else $select = "";

    69                 echo "<option $select value=\"-1\"></option>\n";

    70                 $sql = "SELECT vtyp_ID, vtyp_bezeichnung FROM Vertrag_Typ ORDER BY 2";

    71                 if ($result = $dbc->queryObjectArray($sql))

    72                 {

    73                     foreach ($result as $row)

    74                     {

    75                         if (is_array($vr["vtyp"])) $select = in_array( $row->vtyp_ID, $vr["vtyp"] ) ? ' selected' : null;

    76 	                       echo "<option $select value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";

    77                     }

    78             }

    79             ?>

    80             </select>

    81         </td>

    82     </tr>

    83     <tr>

    84         <td>Jahr</td>

    85         <td>

    86              <select name="vr[jahr]" size="1">

    87     		 <?php

    88         		if (!$vr['jahr'] ) 

    89         		 	echo "<option selected value=\"-1\"></option>\n";  

    90         		else

    91         		 	echo "<option value=\"-1\"></option>\n";  

    92         		$ja = $vr['jahr'];

    93         		for ($i=2000; $i<2031; $i++)

    94         		 {	if ($i==intval($j1)) 

    95         				echo "<option selected>$ja1</option>\n";

    96         			else		

    97         				echo "<option>$i</option>\n";

    98         		  }

    99     		 ?> 

   100     		 </select>

   101         </td>

   102     </tr>    

   103     <tr> 

   104           <td>Verkn&uuml;pfung</td>

   105           <td>UND&nbsp;&nbsp;&nbsp;

   106             <input type="radio" name="vr[bind]" value="AND" <?php if (isset($vr["bind"]) && $vr["bind"]=="AND") echo "checked"; else  echo "checked";?>>

   107                 ODER   

   108             <input type="radio" name="vr[bind]" value="OR" <?php if (isset($vr["bind"]) && $vr["bind"]=="OR") echo "checked"; ?>></td>

   109     </tr>

   110     <tr>

   111         <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>

   112     <?php

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

   114         for ($i=1; $i<4; $i++)

   115         { 

   116           echo "$i.&nbsp;&nbsp;<select name='vr[sort$i]'>\n";

   117           foreach ($sort as $key=>$val)

   118           {

   119             $rsort = $sort . $i;

   120             if ($rag[$rsort] == $i) $select= " selected"; else $select = "";

   121             echo "<option$select value='$key'>$val</option>\n";

   122           }

   123           echo "</select>&nbsp;&nbsp;&nbsp;&nbsp;\n";

   124         } 

   125         echo "</td></tr>\n";

   126     ?>

   127     <tr> 

   128         <td>&nbsp;</td>

   129         <td><input class="button" type="submit" name="create" value="Bericht erstellen"></td>

   130     </tr>

   131 </table>

   132 </div>

   133 </form>