<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 05/2011
 *
 * Form Vertrag
 */

	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("ve",$_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;?> Vertragsdaten</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_vertrag" target="_self"> 	
<div align="center">
<table width="50%" border="0" cellspacing="3" cellpadding="3">
<!--	<tr>
        <td>Vertrag-ID *</td>
        <td><input name="vertrag[cid]" type="text" size="10" maxlength="6" value="<?php echo $vtr['cid']; ?>"/>
            <?php 
			   /*  if (isset($vtr['cid']) && $vtr['cid']<'!')
				{
					echo "<br><span class=\"red\">ID ist erforderlich!</span>\n";
					$okn = false;
				}
				else
					$okn = true; */
             ?> 
        </td>
    </tr>
-->    
    <tr>
        <td>Vertragsbezeichnung *</td>
        <td><input name="vertrag[cname]" type="text" size="50" maxlength="50" value="<?php echo $vtr['cname']; ?>"/>
            <?php 
			     if (isset($vtr['cname']) && $vtr['cname']<'!')
				{
					echo "<br><span class=\"red\">Bezeichnung ist erforderlich!</span>\n";
					$okn = false;
				}
				else
					if ($okn) $okn = true; else $okn=false;
             ?> 
        </td>
    </tr>
<!--    <tr>
        <td>Vertrag Titel</td>
        <td><input name="vertrag[cshort]" type="text" size="30" maxlength="50" value="<?php echo $vtr['cshort']; ?>"/></td>
    </tr>
-->
    <tr>
        <td>Vertrag Beschreibung</td>
        <td><textarea name="vertrag[clong]" cols="50" rows="2"><?php echo $vtr['clong']; ?></textarea>
		<div>max. 100 Zeichen sind m&ouml;glich</div></td>
    </tr>
    <tr>
        <td>Vertrag-Typ</td>
        <td><select name="vertrag[vtyp]">
            <?php 
                if ($vtr['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 ($row->vtyp_ID == $vtr['vtyp'])
    					   echo "<option selected value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
    				    else
    					   echo "<option value=\"$row->vtyp_ID\">$row->vtyp_bezeichnung</option>\n";
                    }
            }
            ?>
            </select>
        </td>
    </tr>
    <tr>
        <td>Datum Vertragbeginn</td>
    	    <td align="left"><select name="vertrag[btag]" size="1">
    		  <?php
    		 if (!$vtr['btag'] ) $ta1=0; else $ta1 = $vtr['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="vertrag[bmon]" size="1">
    		  <?php
    		 if (!$vtr['bmon'] ) $mo1=0;  else $mo1 = $vtr['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="vertrag[bjahr]" size="1">
    		 <?php
    		  
    		if (!$vtr['bjahr'] ) 
    		 	echo "<option selected></option>\n";  
    		else
    		 	echo "<option></option>\n";  
    		$ja1 = $vtr['bjahr'];
    		for ($i=1990; $i<2036; $i++)
    		 {	if ($i==intval($ja1)) 
    				echo "<option selected>$ja1</option>\n";
    			else		
    				echo "<option>$i</option>\n";
    		  }
    		 ?> 
    		 </select>
        </td>
    </tr>
     <tr>
        <td>Datum Vertragende</td>
    	    <td align="left"><select name="vertrag[etag]" size="1">
    		  <?php
    		 if (!$vtr['etag'] ) $ta1=0; else $ta1 = $vtr['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="vertrag[emon]" size="1">
    		  <?php
    		 if (!$vtr['emon'] ) $mo1=0;  else $mo1 = $vtr['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="vertrag[ejahr]" size="1">
    		 <?php
    		  
    		if (!$vtr['ejahr'] ) 
    		 	echo "<option selected></option>\n";  
    		else
    		 	echo "<option></option>\n";  
    		$ja1 = $vtr['ejahr'];
    		for ($i=2000; $i<2036; $i++)
    		 {	if ($i==intval($ja1)) 
    				echo "<option selected>$ja1</option>\n";
    			else		
    				echo "<option>$i</option>\n";
    		  }
    		 ?> 
    		 </select>
             <?php
                if ($vtr['bjahr'] && $vtr['bmon'] && $vtr['btag'] && $vtr['ejahr'] && $vtr['emon'] && $vtr['etag'])
                {
                    $dat = $vtr['ejahr']."-".$vtr['emon']."-".$vtr['etag'];
                    $edate = new DateTime("$dat");
                    $edate = $edate->add(new DateInterval('P1D'));
                    $dat = $vtr['bjahr']."-".$vtr['bmon']."-".$vtr['btag'];
                    $bdate = new DateTime("$dat");
                    $diff = $edate->diff($bdate);
                    echo "<br />Vertragsdauer: ".$diff->format('%y Jahr(e), %m Monat(e), %d Tag(e)');
                }
             ?>
        </td>
    </tr>
    <tr>
        <td>automatische Verl&auml;ngerung</td>
        <td><input name="vertrag[cautoend]" type="checkbox" value="1" <?php if ($vtr["cautoend"]) echo "checked";?>/></td>
    </tr>
	<tr>
        <td>K&uuml;ndigungsfrist<br />(Monate vor Ablauf)</td>
        <td><input name="vertrag[cnot]" type="text" size="10" maxlength="3" value="<?php echo $vtr['cnot']; ?>"/></td>
    </tr>
    <tr>
        <td>autom. E-Mail vor Vertr.-Ende</td>
        <td><input name="vertrag[email]" type="checkbox" value="1" <?php if ($vtr["email"]) echo "checked";?>/></td>
    </tr>
    <tr>
        <td>Partner (Firma)</td>
        <td>
            <select name="vertrag[partid]">
            <?php 
                if ($vtr['partid'] == -1) $select = " selected "; else $select = "";
                echo "<option $select value=\"-1\"></option>\n";
                $sql = "SELECT part_ID, part_firma FROM Partner ORDER BY 2";
                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->part_ID == $vtr['partid'])
    					   echo "<option selected value=\"$row->part_ID\">$row->part_firma</option>\n";
    				    else
    					   echo "<option value=\"$row->part_ID\">$row->part_firma</option>\n";
                    }
               //$result->free();
            }
            ?>
            </select> oder neu
            <input name="vertrag[partner]" type="text" size="30" maxlength="50" value="<?php echo $vtr['partner']; ?>"/>        
        </td>
    </tr>
    <tr>
        <td>Ansprechpartner FHI <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="vertrag[cpers][]" size="7" multiple="multiple">
                <?php
                    $select = null;
                    if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
                    echo "<option $select value=\"-1\"></option>\n";
                    $sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
                    if ($result = $dbc->queryObjectArray($sql))
                    {
                        foreach ($result as $row)
                        {
                            if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null;
        					echo "<option $select value=\"$row->persknr\">$row->pname</option>\n";
                        }
                    }
                ?>
            </select>
        </td>
    </tr>
        <?php
            if ($vtr['bjahr'])
            {
                echo "<tr>
                    <td>j&auml;hrliche Teilbrutto-Kosten (&euro;)</td><br />
                    <td>";
                $j=0;
                if ($vtr['ejahr']) 
                    $ejahr = $vtr['ejahr'];
                elseif ($vtr["cautoend"] && !$vtr['ejahr']) // automatische Vertragsverlaengerung und kein Endjahr angegeben
                    $ejahr = date("Y");
                else 
                    $ejahr = null;
                if ($ejahr)
                {
                    for ($i=(int)$vtr['bjahr']; $i<(int)$ejahr+1; $i++ )
                    {
                        echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"$i\"/>&nbsp;&nbsp;&nbsp;";
                        echo "<input class='right' name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/><br />\n";
                        $j++;
                    }
                }
                else
                {
                    echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"" . $vtr['bjahr'] . "\"/>&nbsp;&nbsp;&nbsp;";
                        echo "<input class='right' name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/>";
                }
                
             echo  "</td>
                </tr>";
            }
         ?>
   <tr>
        <td>zugeordnet zu </td>
        <td>
            <select name="vertrag[prodid]">
            <?php 
                if ($vtr['prodid'] == -1) $select = " selected "; else $select = "";
                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";
/*                if ($result = $dbc->queryObjectArray($sql))
                {
                    foreach ($result as $row)
                    {
                        if ($row->lenp > 70) $prod=$row->prod ."..."; else $prod=$row->prod;
                        if ($row->produkt_ID == $vtr['prodid'])
    					   echo "<option selected value=\"$row->produkt_ID\">$prod</option>\n";
    				    else
    					   echo "<option value=\"$row->produkt_ID\">$prod</option>\n";
                    }
                }
*/
                // Recht Produktgruppe beruecksichtigen
                if (is_array($_SESSION["prodg"]))
                {
                        foreach ($_SESSION["prodg"] as $val)
                            $listg .= "," .$val;
                        $listg = substr($listg,1);
                        $sql = "CALL fhiiqm.hier_prodgroup('$listg')";                
                }
                else
                    $sql = "CALL fhiiqm.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 ($row->prid == $vtr['prodid'])
    					   echo "<option $color selected value=\"$row->prid\">$prod</option>\n";
    				    else
    					   echo "<option $color value=\"$row->prid\">$prod</option>\n";
                    }
                }
                unset($row);
                unset($result);
                $sql=null;
            ?>
            </select>
            <br />bitte nur die <font color="green">gr&uuml;nen</font> Eintr&auml;ge w&auml;hlen
        </td>
    </tr>
	<tr>
	   <td>Dateibezeichnung Dokument *</td>
	   <td><input name="vertrag[cfname]" type="text" size="50" maxlength="50" value="<?php echo $vtr['cfname']; ?>">
	   <?php
            echo "<br />bitte <u>keine</u> Umlaute im Dateinamen angeben!";   
			if (isset($vtr['cfname']) && $vtr['cfname']<'!')
				{
					echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
					$okn = false;
				}
				else
				{
                    if ($vtr['cfname']>='!' && file_exists("documents/".$vtr['cfname']))
                        echo "<br />Dokument anschauen:&nbsp;<a href='documents/" . $vtr['cfname'] ."'>" . $vtr['cfname'] . "</a>";
                    if ($okn) $okn = true; else $okn=false;
                }
		?>
		</td>
    </tr>
    <tr>
        <td>Bemerkung</td>
        <td><textarea name="vertrag[cbem]" cols="50" rows="5"><?php echo $vtr['cbem']; ?></textarea>
		<div>max. 500 Zeichen sind m&ouml;glich</div></td>
    </tr>

    <input type="hidden" name="MAX_FILE_SIZE" value="10000000"/>    
    <input type="hidden" name="vertrag[okn]" value="<?php echo $okn; ?>"/>
       
<!--  </table>
 </div>   
</form> -->