<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 03/2013
 * 
 * Form Vertrag Multifile
 */

	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  (!$cid) $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="multipart/form-data" name="form_vertrag" target="_self"> 	
<div align="center">
<table width="70%" 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]" id="bez" 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><input class="long10" name="vertrag[bdat]" id="bdat"  value="<?php echo $vtr['bdat']; ?>" />
   </tr>
     <tr>
        <td>Datum Vertragende</td>
        <td><input class="long10" name="vertrag[edat]" id="edat"  value="<?php echo $vtr['edat']; ?>" />
             <?php
                if ($vtr['bdat'] && $vtr['edat'])
                {
                    if ($vtr['bdat'] > $vtr['edat'])
                    {
    					echo "<br><span class=\"red\">Datum Vertragsende < Datum Vertragsbeginn</span>\n";
    					$okn = false;
                    }
                    else
                    {
                        $dat = $vtr['edat'];
                        $edate = new DateTime("$dat");
                        $edate = $edate->add(new DateInterval('P1D'));
                        $dat = $vtr['bdat'];
                        $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 (CASE aktiv WHEN -1 THEN 'Gast' ELSE 'inaktiv' END) 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;
                            if (strpos($row->pname,"inaktiv") || strpos($row->pname,"Gast")) $class=" class='red'"; else $class="";
        					echo "<option$class $select value=\"$row->persknr\">$row->pname</option>\n";
                        }
                    }
                ?>
            </select>
        </td>
    </tr>
        <?php
            if ($vtr['bdat'])
            {
                echo "<tr>
                    <td>j&auml;hrliche Teilbrutto-Kosten (&euro;)</td><br />
                    <td>";
                $dat = $vtr['bdat']; 
                $bdate = new DateTime("$dat");
                $bjahr = $bdate->format("Y");
                $j=0;
                if ($vtr['edat'])
                { 
                    $dat = $vtr['edat'];
                    $edate = new DateTime("$dat");
                    $ejahr = $edate->format("Y");
                }    
                elseif ($vtr["cautoend"]) // automatische Vertragsverlaengerung und kein Endjahr angegeben
                    $ejahr = date("Y");
                else 
                    $ejahr = null;
                if ($ejahr)
                {
                    for ($i=(int)$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=\"" . $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>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>
    <?php 
        if (isset($vtr['cfname'])) $anzdoc = count($vtr['cfname']); else $anzdoc = 1;
        echo            
        "<tr>
	       <td>Vertragsdokumente
                <br />&nbsp;&nbsp;&nbsp;bitte <u>keine</u> Umlaute<br />&nbsp;&nbsp;&nbsp;in gew&auml;hlten Dateinamen angeben!</td>
	       <td><div id='adddoc'>
                <span></span>\nDok-Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name=\"vertrag[cfname][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"". $vtr['cfname'][0] ."\" />
                &nbsp;&nbsp;&nbsp;
                Schlagwort&nbsp;&nbsp;&nbsp;<input type='text' name=vertrag[swort][]  size=\"30\" maxlength=\"50\" value='".$vtr['swort'][0]."' />";
            echo "<input class='pr' type='checkbox' id='del_0' name='vertrag[del][0]' value='1'/>";    
            echo "&nbsp;&nbsp;&nbsp;<a href=\"javascript:addInput('adddoc',$anzdoc)\" title=\"weiteres Dokument\"><img src=\"/fhiiqm/img/add.png\" /></a>
            &nbsp;&nbsp;&nbsp;<a href=\"javascript:markdelInput('adddoc',$anzdoc)\" title=\"l&ouml;schen markiertes Dokument\"><img src=\"/fhiiqm/img/delete.png\" /></a>";
			if (isset($vtr['cfname'][0]) && $vtr['cfname'][0]<'!')
			{
				echo "<br /><span class=\"red\">Dateiname ist erforderlich!</span>\n";
				$okn = false;
			}
			else
                if ($vtr['cfname'][0]>='!' && $okn) $okn = true; else $okn = false;
            if ($sub)
            {
        		echo "<br />Upload-Dokument&nbsp;&nbsp;&nbsp;&nbsp;
        		<input type=\"file\" name=\"vfile[]\" size=\"50\" maxlength=\"50\" value=\"" .$_FILES["vfile"]["name"][0] . "\"/>";
            }
            if ($sub || (isset($vtr) && !$ok))
            {
                if (count($vtr['cfname'])>1)
                {
                    $i=0;
                    foreach ($vtr['cfname'] as $akt)
                    {
                        if ($i>0)
                        {
                            echo "<span></span><br />\nDok-Name&nbsp;&nbsp;&nbsp;&nbsp;
                            <input name=\"vertrag[cfname][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"". $vtr['cfname'][$i] ."\" />
                            &nbsp;&nbsp;&nbsp;
                            Schlagwort&nbsp;&nbsp;&nbsp;<input type='text' name=vertrag[swort][]  size=\"30\" maxlength=\"50\" value='".$vtr['swort'][$i]."' />";
                            if (isset($vtr['del'])) $cls = "dispil"; else $cls = "pr";
                            if (isset($vtr['del'][$i])) $chk = "checked = ' checked'"; else $chk ="";
                            echo "<span id='cbl_$i'>&nbsp;&nbsp;&nbsp;<input class='$cls' type='checkbox' id='del_$i' name='vertrag[del][$i]' value='1'$chk /></span>
                                <span id='lb_$i' class='$cls'>&nbsp;l&ouml;schen?</span>";    
                      		if (isset($vtr['cfname'][$i]) && $vtr['cfname'][$i]<'!')
            				{
            					echo "<br><span class=\"red\">Dateiname ist erforderlich!</span>\n";
            					$okn = false;
            				}
                			else
                                if ($vtr['cfname'][$i]>='!' && $okn) $okn = true; else $okn = false;
                            echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";
                    		if ($sub)
                            {
                                echo "<br />Upload-Dokument&nbsp;&nbsp;&nbsp;&nbsp;
                        		<input type=\"file\" name=\"vfile[]\" size=\"50\" maxlength=\"50\" value=\"" .$_FILES["vfile"]["name"][$i] . "\"/>";
                            }
                        }
                        $i++;
                    }
                }                
            }
        echo "
        </div>";
                if (count($vtr['cfname'])>0)
                {
                    $i=0;
                    foreach ($vtr['cfname'] as $akt)
                    {
                        if ($vtr['cfname'][$i]>='!' && file_exists("documents/".$vtr['cfname'][$i]))
                            echo "<br />Dokument anschauen:&nbsp;<a href='/fhiiqm/documents/" . $vtr['cfname'][$i] ."'>" . $vtr['cfname'][$i] . "</a>";
                        $i++;
                    }
                 }    

        echo "</td>
        </tr>\n";
                if ($vtr["tstmp"] && $vtr["tstmp"]>0)
                {
                    echo "<tr><td>letzte &Auml;nderung</td>";
                    $ts = new DateTime($vtr["tstmp"]);    
                    echo "<td>".$ts->format('d.m.Y H:i:s');   
                }
                if (isset($vtr["uid"]) && $vtr["uid"]) 
                    echo "&nbsp;&nbsp;&nbsp;(".$vtr["uid"] .")";
                echo "</td></tr>\n"; 
    ?>

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