<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 08/2011
 *
 * Form Info
 */

	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
    $okn = true;

?>
<div align="center">
<?php
    if (!is_null($_SESSION["recht"]) && !in_array("ie",$_SESSION["recht"]))
        $text = "";
    else
        if  (strpos($_SERVER['PHP_SELF'],"ins") > -1) $text = "Eingabe"; else $text="&Auml;ndern / L&ouml;schen";
?>
<h3><font face="Verdana, Arial, Helvetica, sans-serif"><?php echo $text;?> Informationen </font></h3>
<h5>* - Felder sind erforderlich!</h5>
</div>
<!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> -->	
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> 	
<div align="center">
<table width="50%" border="0" cellspacing="3" cellpadding="3">
    <tr>
        <td>Titel *</td>
        <td><textarea name="inf[iname]"  cols="50" rows="2"><?php echo $inf['iname']; ?></textarea>
            <?php 
			     if (isset($inf['iname']) && $inf['iname']<'!')
				{
					echo "<br><span class=\"red\">Titel ist erforderlich!</span>\n";
					$okn = false;
				}
             ?> 
		<div>max. 300 Zeichen sind m&ouml;glich</div></td>
    </tr>
    <tr>
        <td>Kurzinformation</td>
        <td><textarea name="inf[ilong]" cols="50" rows="10"><?php echo $inf['ilong']; ?></textarea>
        </td>
    </tr>
    <tr>
        <td>Info-Typ</td>
        <td><select name="inf[ityp]">
            <?php 
                if ($inf['ityp'] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->infotyp_ID == $inf['ityp'])
    					   echo "<option selected value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n";
    				    else
    					   echo "<option value=\"$row->infotyp_ID\">$row->infotyp_bez</option>\n";
                    }
            }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Erstellungsdatum *</td>
    	    <td align="left"><select name="inf[itag]" size="1">
    		  <?php
    		 if (!$inf['itag'] ) $ta1=date('d'); else $ta1 = $inf['itag'];
    		 for ($i=1; $i<32; $i++)
    		 {	if ($i==intval($ta1)) 
    		 	{
    				if ($i == 0)
    					echo "<option selected></option>\n";
    				else
    					echo "<option selected>$ta1</option>\n";
    			}
    			else	{	
    				if ($i<10)
    				{				
    					if ($i == 0)
    						echo "<option></option>\n";
    					else
    						echo "<option>0$i</option>\n";
    				} 
    				else			
    					echo "<option>$i</option>\n";
    					}  
    		  }
    		 ?> 
    		</select>.
    		 <select name="inf[imon]" size="1">
    		  <?php
    		 if (!$inf['imon'] ) $mo1=date('m');  else $mo1 = $inf['imon'];
    		 for ($i=1; $i<13; $i++)
    		 {	if ($i==intval($mo1)) 
    		 	{
    				if ($i == 0)
    					echo "<option selected></option>\n";
    				else
    					echo "<option selected>$mo1</option>\n";
    			}
    			else	{	
    				if ($i<10)
    				{
    					if ($i == 0)
    						echo "<option></option>\n";
    					else
    						echo "<option>0$i</option>\n";
    				} 
    				else			
    					echo "<option>$i</option>\n";
    					}  
    		  }
    		 ?> 
    		 </select>.
    		 <select name="inf[ijahr]" size="1">
    		 <?php
    		  
    		if (!$inf['ijahr'] ) 
    		 	$ja1 = date('Y') . "</option>\n";
            else  
    		  $ja1 = $inf['ijahr'];
    		for ($i=2000; $i<2036; $i++)
    		 {	if ($i==intval($ja1)) 
    				echo "<option selected>$ja1</option>\n";
    			else		
    				echo "<option>$i</option>\n";
    		  }
    		 ?> 
    		 </select>
        </td>
    </tr>
    <tr>
        <td>g&uuml;ltig ab</td>
    	    <td align="left"><select name="inf[btag]" size="1">
    		  <?php
    		 if (!$inf['btag'] ) $ta1=0; else $ta1 = $inf['btag'];
    		 for ($i=0; $i<32; $i++)
    		 {	if ($i==intval($ta1)) 
    		 	{
    				if ($i == 0)
    					echo "<option selected></option>\n";
    				else
    					echo "<option selected>$ta1</option>\n";
    			}
    			else	{	
    				if ($i<10)
    				{				
    					if ($i == 0)
    						echo "<option></option>\n";
    					else
    						echo "<option>0$i</option>\n";
    				} 
    				else			
    					echo "<option>$i</option>\n";
    					}  
    		  }
    		 ?> 
    		</select>.
    		 <select name="inf[bmon]" size="1">
    		  <?php
    		 if (!$inf['bmon'] ) $mo1=0;  else $mo1 = $inf['bmon'];
    		 for ($i=0; $i<13; $i++)
    		 {	if ($i==intval($mo1)) 
    		 	{
    				if ($i == 0)
    					echo "<option selected></option>\n";
    				else
    					echo "<option selected>$mo1</option>\n";
    			}
    			else	{	
    				if ($i<10)
    				{
    					if ($i == 0)
    						echo "<option></option>\n";
    					else
    						echo "<option>0$i</option>\n";
    				} 
    				else			
    					echo "<option>$i</option>\n";
    					}  
    		  }
    		 ?> 
    		 </select>.
    		 <select name="inf[bjahr]" size="1">
    		 <?php
    		  
    		if (!$inf['bjahr'] ) 
    		 	echo "<option selected></option>\n";  
    		else
    		 	echo "<option></option>\n";  
    		$ja1 = $inf['bjahr'];
    		for ($i=2000; $i<2036; $i++)
    		 {	if ($i==intval($ja1)) 
    				echo "<option selected>$ja1</option>\n";
    			else		
    				echo "<option>$i</option>\n";
    		  }
    		 ?> 
    		 </select>
        </td>
    </tr>
     <tr>
        <td>g&uuml;ltig bis</td>
    	    <td align="left"><select name="inf[etag]" size="1">
    		  <?php
    		 if (!$inf['etag'] ) $ta1=0; else $ta1 = $inf['etag'];
    		 for ($i=0; $i<32; $i++)
    		 {	if ($i==intval($ta1)) 
    		 	{
    				if ($i == 0)
    					echo "<option selected></option>\n";
    				else
    					echo "<option selected>$ta1</option>\n";
    			}
    			else	{	
    				if ($i<10)
    				{				
    					if ($i == 0)
    						echo "<option></option>\n";
    					else
    						echo "<option>0$i</option>\n";
    				} 
    				else			
    					echo "<option>$i</option>\n";
    					}  
    		  }
    		 ?> 
    		</select>.
    		 <select name="inf[emon]" size="1">
    		  <?php
    		 if (!$inf['emon'] ) $mo1=0;  else $mo1 = $inf['emon'];
    		 for ($i=0; $i<13; $i++)
    		 {	if ($i==intval($mo1)) 
    		 	{
    				if ($i == 0)
    					echo "<option selected></option>\n";
    				else
    					echo "<option selected>$mo1</option>\n";
    			}
    			else	{	
    				if ($i<10)
    				{
    					if ($i == 0)
    						echo "<option></option>\n";
    					else
    						echo "<option>0$i</option>\n";
    				} 
    				else			
    					echo "<option>$i</option>\n";
    					}  
    		  }
    		 ?> 
    		 </select>.
    		 <select name="inf[ejahr]" size="1">
    		 <?php
    		  
    		if (!$inf['ejahr'] ) 
    		 	echo "<option selected></option>\n";  
    		else
    		 	echo "<option></option>\n";  
    		$ja1 = $inf['ejahr'];
    		for ($i=2000; $i<2036; $i++)
    		 {	if ($i==intval($ja1)) 
    				echo "<option selected>$ja1</option>\n";
    			else		
    				echo "<option>$i</option>\n";
    		  }
    		 ?> 
    		 </select>
        </td>
    </tr>
    <tr>
        <td>Autor</td>
        <td>
            <select name="inf[pers]" size="1">
                <?php
                    $select = $inf['pers'] == "-1" ? ' selected' : null;
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter ORDER BY 2";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            $select = $row->persknr == $inf['pers'] ? ' selected' : null;
        					echo "<option $select value=\"$row->persknr\">$row->pname</option>\n";
                        }
                    }
                ?>
            </select>
        </td>
    </tr>
   <tr>
        <td>zugeordnet zu Produkt<br /><br />
            &nbsp;&nbsp;&nbsp;Mehrfachauswahl m&ouml;glich:<br />
            &nbsp;&nbsp;&nbsp;[Strg]-Taste + Anklicken der<br /> 
            &nbsp;&nbsp;&nbsp;gewünschten Listeneinträge</td>
        <td>
            <select name="inf[prid][]" size="8" multiple="multiple">
            <?php 
                if (is_array($inf['prid'])) $select = in_array( "-1", $inf['prid'] ) ? ' selected' : null;
                echo "<option $select value=\"-1\"></option>\n";
//                $sql = "SELECT produkt_ID, LEFT(prod_name,70) AS prod, LENGTH(prod_name) AS lenp FROM Produkt ORDER BY 2";
                $sql = "CALL prod_hiera_all(0,0)";  
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if (strlen($row->bez) > 70) 
                            $prod=str_replace(" ","&nbsp;",htmlentities(substr($row->bez,0,70))) ."..."; 
                        else 
                            $prod=str_replace(" ","&nbsp;",htmlentities($row->bez));
                        if ($row->prid >0) $color=" class='green'"; else $color="";
                        if (is_array($inf['prid'])) $select = in_array($row->prid, $inf['prid']) ? ' selected' : null;
                        echo "<option $color $select value=\"$row->prid\">$prod</option>\n";
                    }
                }
                unset($result);
            ?>
            </select>
            <br />bitte nur die <font color="green">gr&uuml;nen</font> Eintr&auml;ge w&auml;hlen
        </td>
    </tr>
    <tr><td>Adressat<br /><br />
            &nbsp;&nbsp;&nbsp;Mehrfachauswahl m&ouml;glich</td>
        <td><select name="inf[adr][]" size="4" multiple="multiple">
            <?php
                if (is_array($inf['adr'])) $select = in_array( "-1", $inf['adr'] ) ? ' selected' : null;
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT info_adr_ID, info_adr_name FROM Adressat ORDER BY 2";
                if ($result = $dbc -> queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if (is_array($inf['adr'])) $select = in_array( $row->info_adr_ID, $inf['adr'] ) ? ' selected' : null;
       					echo "<option $select value=\"$row->info_adr_ID\">$row->info_adr_name</option>\n";
                    }
                }
            ?>
        </select>
        </td>
    </tr>
    <tr><td>geh&ouml;rt zu Info</td>
        <td><select name="inf[infrel]">
            <?php
                if ($inf['adr'] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                if (isset($inf["infid"]) && $inf["infid"]>0) $where = " WHERE info_ID != " . $inf["infid"]; else $where=""; 
                $sql = "SELECT info_ID, LEFT(info_name_s,50) AS iname FROM Info $where ORDER BY 2";
                if ($result = $dbc -> queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->info_ID == $inf['infrel'])
    					   echo "<option selected value=\"$row->info_ID\">$row->iname</option>\n";
    				    else
    					   echo "<option value=\"$row->info_ID\">$row->iname</option>\n";
                    }
                }
            ?>
        </select>
        </td>
    </tr>
    <tr><td>Sprache</td>
        <td><select name="inf[lang]">
        <?php
                if ($inf['lang'] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $alang = array("de"=>"deutsch","en"=>"englisch");
                foreach ($alang as $key=>$value)
                {
                    if ($inf['lang'] == $key) $select = " selected "; else $select = "";
                    echo "<option $select value=\"$key\">$value</option>\n";
                }
        ?>
        </select></td>
    </tr>
	<tr>
	   <td>Dateibezeichnung Dokument (*)</td>
	   <td><input name="inf[ifname]" type="text" size="50" maxlength="50" value="<?php echo $inf['ifname']; ?>">
	   <?php
            echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!";   
			if (isset($inf['ifname']) && $upd && is_uploaded_file($_FILES["ifile"]["tmp_name"]) && $inf['ifname']<'!')
				{
					echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
					$okn = false;
				}
				else
				{
                    if ($inf['ifname']>='!' && file_exists("infos/".$inf['ifname']))
                        echo "<br />Dokument anschauen:&nbsp;<a href='infos/" . $inf['ifname'] ."'>" . $inf['ifname'] . "</a>";
                    if ($okn) $okn = true; else $okn=false;
                }
		?>
		</td>
    </tr>

    <input type="hidden" name="inf[infid]" value="<?php echo $inf['infoid']; ?>"/>
    <input type="hidden" name="MAX_FILE_SIZE" value="6000000"/>    
    <input type="hidden" name="inf[okn]" value="<?php echo $okn; ?>"/>
<!--  </table>
 </div>   
</form> -->