<?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  (strpos($_SERVER['PHP_SELF'],"ins") > -1) $text = "Eingabe"; else $text="Ändern / Lö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=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>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>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>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 /> 

               gewünschten Listeneinträge

        </td>

        <td>

            <select name="vertrag[cpers][]" size="7" multiple="multiple">

                <?php

                    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, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter 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 Kosten (&euro;)</td><br />

                    <td>";

                $j=0;

                if ($vtr['ejahr'])

                {

                    for ($i=(int)$vtr['bjahr']; $i<(int)$vtr['ejahr']+1; $i++ )

                    {

                        echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"$i\"/>&nbsp;&nbsp;&nbsp;";

                        echo "<input name=\"vertrag[kost][$j]\" type=\"text\" value=\"" . $vtr['kost'][$j] . "\"/><br />";

                        $j++;

                    }

                }

                else

                {

                    echo "<input name=\"vertrag[kjahr][$j]\" type=\"text\" size=\"4\" value=\"" . $vtr['bjahr'] . "\"/>&nbsp;&nbsp;&nbsp;";

                        echo "<input 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";

                    }

                }

*/

                $sql = "CALL prod_hiera_all(0,0)";  

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

                {

                    foreach ($result as $row)

                    {

                        if (strlen($row->bez) > 70) 

                            $prod=str_replace(" "," ",htmlentities(substr($row->bez,0,70))) ."..."; 

                        else 

                            $prod=str_replace(" "," ",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="6000000"/>    

    <input type="hidden" name="vertrag[okn]" value="<?php echo $okn; ?>"/>

<!--  </table>

 </div>   

</form> -->