<?
include("includes/config.html");
include("includes/dbconnect.html");

$kat=$_REQUEST['kat'];
$art=$_REQUEST['art'];

$keine_kats=0;

// erste kat rausfinden
$kcheck=@mysql_query("select * from immogruppen order by sort");
if(@mysql_num_rows($kcheck)=="0")
{
  $keine_kats=1;
}
else
{
  while($erg_kcheck=@mysql_fetch_array($kcheck))
  {
    $arr_wkats[$erg_kcheck[id]]=$erg_kcheck[bezeichnung];
    $arr_wkatsid[]=$erg_kcheck[id];
  }
  $erste_kat=$arr_wkatsid[0];
}

// jetzt rausfinden, ob die kategorie mit der immobilie übereinstimmt

$keine_immos=0;

$wcheck=@mysql_query("select id, gruppe from immobilien");
if(@mysql_num_rows($wcheck)=="0")
{
  $keine_immos=1;
}
else
{
  while($erg_wcheck=@mysql_fetch_array($wcheck))
  {
    $arr_wcheck[$erg_wcheck[gruppe]][]=$erg_wcheck[id];
  }
}

// jetzt die ganzen checks

if(isset($kat) && (!is_numeric($kat) || $kat=="" || !in_array($kat,$arr_wkatsid)))
{
  @mysql_close($dblink);
  header("Location:immobilien.html");
}

if(isset($art) && (!is_numeric($art) || $art=="" || !in_array($art,$arr_wcheck[$kat])))
{
  @mysql_close($dblink);
  header("Location:immobilien.html");
}

if(isset($art) && !isset($kat))
{
  @mysql_close($dblink);
  header("Location:immobilien.html");
}

if(!isset($kat) && !isset($art))
{
  $kat=$erste_kat;
}

if(isset($_POST['anf_send']))
{
  $anf_name=trim(strip_tags($_POST['anf_name']));
  $anf_email=trim(strip_tags($_POST['anf_email']));
  $anf_telefon=trim(strip_tags($_POST['anf_telefon']));
  $anfrage=trim(strip_tags($_POST['anfrage']));
  $anf_ip=getenv("REMOTE_ADDR");



  if(empty($anf_name))
  {
    $mess = "please enter your name";
    $fclass="error";
  }
  elseif(empty($anf_email))
  {
    $mess = "please enter your email address";
    $fclass="error";
  }
  elseif(!eregi("^[a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9\-]+(\.[a-z0-9-]+)*\.([a-z]{2,4})$", $anf_email))
  {
    $mess = "your email address is not valid";
    $fclass="error";
  }
  elseif(empty($anfrage))
  {
    $mess = "please enter your message";
    $fclass="error";	
  }
  elseif(strlen($anfrage)<5)
  {
    $mess = "this message is too short";
    $fclass="error";	
  }
  else
  {
    $anf_check=mysql_query("select id from immobilienanfragen where immobilie='$art' and name='$anf_name' and email='$anf_email' and telefon='$anf_telefon' and anfrage='$anfrage' and ip='$anf_ip'");
    if(@mysql_num_rows($anf_check)=="0")
    {
      @mysql_query("insert into immobilienanfragen (immobilie,name,email,telefon,anfrage,ip) values ('$art','$anf_name','$anf_email','$anf_telefon','$anfrage','$anf_ip')");
      $anwen=@mysql_query("select asp.email, imo.bezeichnung from ansprechpartner as asp inner join immobilien as imo on asp.id=imo.ansprechpartner where imo.id='$art' LIMIT 1");

      if(@mysql_num_rows($anwen)!="0")
      {
        $erg_anwen=@mysql_fetch_array($anwen);
        $empfaenger=$erg_anwen[email];

        $mailbetreff="Englische Immobilien-Anfrage: ".$erg_anwen[bezeichnung];
        $mailtel=!empty($anf_telefon)?$anf_telefon:"keine Angabe";

$mailinhalt=$anf_name." (Telefon: $mailtel) schreibt:

$anfrage";

        $header="From:$anf_name<$anf_email>\n";
        @mail($empfaenger,$mailbetreff,$mailinhalt,$header);
      }
	 
      $mess="thank you for your message";
      $fclass="ok";
      $anf_name="";
      $anf_email="";
      $anf_telefon="";
      $anfrage="";
    }
    else
    {
      $mess="your message has been sent";
      $fclass="ok";
    }
  }
}



// metatags

if(isset($kat) && !isset($art)) // Übersichtsseiten
{
  $meta=@mysql_query("select bezeichnung from immogruppen where id='$kat' LIMIT 1");
  if(@mysql_num_rows($meta)!="0")
  {
    $erg_meta=@mysql_fetch_array($meta);
    $meta_title=$erg_meta[bezeichnung];
    $meta_desc="GI Greiner Immobilien KG. $meta_title! here is an overview of JGI Immobilien KG, category $meta_title!";
  }
}

if(isset($kat) && isset($art)) // Detailansichten
{
  $meta=@mysql_query("select bezeichnung, beschreibung from immobilien where id='$art' LIMIT 1");
  if(@mysql_num_rows($meta)!="0")
  {
    $erg_meta=@mysql_fetch_array($meta);
  }

  $meta1=@mysql_query("select bezeichnung from immogruppen where id='$kat' LIMIT 1");
  if(@mysql_num_rows($meta1)!="0")
  {
    $erg_meta1=@mysql_fetch_array($meta1);
    $meta_title1=$erg_meta1[bezeichnung];
  }
  $meta_title=$erg_meta[bezeichnung]." - $meta_title1";
  $m_besch=str_replace("\r\n"," - ",$erg_meta[beschreibung]);
  $m_besch=str_replace("\"","",$m_besch);
  $meta_desc="$meta_title - ".substr($m_besch,0,120)." ...";
}

?>
<html>
<head>
<title><?=$meta_title?> - JGI Immobilien KG</title>
<meta name="description" content="<?=$meta_desc?>">
<meta name="robots" content="index,follow">
<link rel="stylesheet" href="css/style.css" type="text/css">
<link rel="stylesheet" href="css/galerie.css" type="text/css">

<script type="text/javascript" src="js/highslide.js"></script>
<script type="text/javascript">    
    hs.graphicsDir = 'js/graphics/';
</script>

</head>

<body>

<?
include("includes/header.html");
?>

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
  <td bgcolor="<?=$col_body?>">
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td width="55" height="200"></td>
    <td bgcolor="<?=$col_navi?>" width="230" align="center" valign="top"><br>

<? include("includes/navi.html");?>

    </td>
    <td valign="top"><br>
    <table border="0" cellpadding="0" cellspacing="0" width="1000">
    <tr>
      <td width="15"></td>
      <td width="770" valign="top">


<?
if($keine_kats=="0" && $keine_immos=="0")
{
  if(isset($kat) && isset($art)) // dann detailansicht
  {
    $det=@mysql_query("select i.id, i.gruppe, i.bezeichnung, i.beschreibung, i.anzeigen, i.hinweis, i.sort, a.anrede, a.vorname, a.nachname, a.telefon from immobilien as i left join ansprechpartner as a on i.ansprechpartner=a.id where i.id='$art' LIMIT 1");
    $erg=@mysql_fetch_array($det);

    $ib=@mysql_query("select bild, bildtext, sort from immobilienbilder where immobilie='$art' order by sort");
    if(@mysql_num_rows($ib)=="0")
    {
      $keinebilder=1;
      $immobild[]="";
      $immobildtext[]="";
    }
    else
    {
      $keinebilder=0;
      while($erg_ib=@mysql_fetch_array($ib))
      {
        $immobild[$erg_ib[sort]]=$erg_ib[bild];
        $immobildtext[$erg_ib[sort]]=$erg_ib[bildtext];
      }
    }

?>
      <table border="0" cellpadding="0" cellspacing="0" width="770">
<? 
    $bildtextanzeige=$immobildtext[1]!=""?"<div class='highslide-caption' id='caption1'>".$immobildtext[1]."</div>":"";
    $bildanzeige="<a href=\"bilder/immobilien/large/".$immobild[1]."\" class=\"highslide\" onclick=\"return hs.expand(this, {captionId: 'caption1'})\"><img src=\"bilder/immobilien/medium/".$immobild[1]."\" border=\"0\" style=\"float:left;margin-right:20px;margin-bottom:0px\"></a>$bildtextanzeige";

    $db_text=str_replace("::fett:: ","<b>",$erg[beschreibung]);
    $db_text=str_replace(" ::fettende::","</b>",$db_text);
    $db_text=str_replace("::fett::","<b>",$db_text);
    $db_text=str_replace("::fettende::","</b>",$db_text);
    $db_text=nl2br($db_text);

    $textanzeige="<font class=\"headers\">".$erg[bezeichnung]."</font><br><br>$db_text";

    if($erg[hinweis]!="0")
    {
      $vkvm=$erg[hinweis]=="1"?"<br><center><img src=\"images/g_vm.gif\" border=\"0\" title=\"rented\"></center>":"<br><center><img src=\"images/g_vk.gif\" border=\"0\" title=\"sold\"></center>";   
    }
    else
    {
      $vkvm="";
    }

?>
      <tr>
        <td valign="top"><?if($keinebilder=="0"){echo $bildanzeige;}?><?=$textanzeige?><?=$vkvm?></td>
      </tr>
<?
    if(@is_array($immobild) && @count($immobild) > 1)
    {
?>
      <tr>
        <td height="21" background="images/hteiler.gif"></td>
      </tr>
      <tr>
        <td><font class="headers">More pictures:</font><br><br></td>
      </tr>
      <tr>
        <td align="center" Valign="top">
        <table border="0" cellpadding="0" cellspacing="0">
<?
      $z=0;
      foreach($immobild as $ikey=>$ivalue)
      {
        if($ikey!="1")  // das erste Bild nicht ausgeben
        {       
          $z++;

          $bildtextanzeige=$immobildtext[$ikey]!=""?"<div class='highslide-caption' id='caption".$ikey."'>".$immobildtext[$ikey]."</div>":"";

          if($z==1)
          {
?>
        <tr>
          <td class="gal" align="center" valign="middle">
          <a href="bilder/immobilien/large/<?=$immobild[$ikey]?>" class="highslide" onclick="return hs.expand(this, {captionId: 'caption<?=$ikey?>'})"><img src="bilder/immobilien/small/<?=$immobild[$ikey]?>" border="0"></a>
          <?=$bildtextanzeige?></td>
          <td width="15"></td>       
<?
          }
          elseif($z==6)
          {
?>
          <td class="gal" align="center" valign="middle">
          <a href="bilder/immobilien/large/<?=$immobild[$ikey]?>" class="highslide" onclick="return hs.expand(this, {captionId: 'caption<?=$ikey?>'})"><img src="bilder/immobilien/small/<?=$immobild[$ikey]?>" border="0"></a>
          <?=$bildtextanzeige?></td>
        </tr>
        <tr>
          <td height="15" colspan="11"></td>
        </tr>
<?
          }
          else
          {
?>
          <td class="gal" align="center" valign="middle">
          <a href="bilder/immobilien/large/<?=$immobild[$ikey]?>" class="highslide" onclick="return hs.expand(this, {captionId: 'caption<?=$ikey?>'})"><img src="bilder/immobilien/small/<?=$immobild[$ikey]?>" border="0"></a>
          <?=$bildtextanzeige?></td>
          <td width="15"></td> 
<?
          }
          if($z==6){$z=0;}
        }
      }

      if($z==1)
      {
?>
          <td colspan="9">&nbsp;</td>
        </tr>
<?
      }
      if($z==2)
      {
?>
          <td colspan="7">&nbsp;</td>
        </tr>
<?
      }
      if($z==3)
      {
?>
          <td colspan="5">&nbsp;</td>
        </tr>
<?
      }
      if($z==4)
      {
?>
          <td colspan="3">&nbsp;</td>
        </tr>
<?
      } 
      if($z==5)
      {
?>
          <td>&nbsp;</td>
        </tr>
<?
      }  

?>
        </table>   
        </td>
      </tr>
<?
    }
?>


      </table><br><br><center><a href="<?=$_SERVER['PHP_SELF']?>?kat=<?=$kat?>">back</a></center><br><br>
<?

  }

  if(isset($kat) && !isset($art)) // dann auflistung
  {
?>
      <table border="0" cellpadding="0" cellspacing="0" width="770">
<?
    $cont=@mysql_query("select id, bezeichnung, beschreibung, hinweis from immobilien where gruppe='$kat' and aktiv='1' order by hinweis, sort");
    if(@mysql_num_rows($cont)=="0")
    {
?>
    <tr>
      <td>nothing found in this category</td>
    </tr>
<?
    }
    else
    {
      while($erg=@mysql_fetch_array($cont))
      {
        $bc=@mysql_query("select bild from immobilienbilder where immobilie='$erg[id]' and sort='1'");
        if(@mysql_num_rows($bc)=="0")
        {
          $erstesbild="";
        }
        else
        {
          $erg_bc=@mysql_fetch_array($bc);
          $erstesbild=$erg_bc[bild];
        }
        $ar=@substr($erg[beschreibung],0,130)." ...";
        $anriss="$ar<br><br><a href=\"".$_SERVER['PHP_SELF']."?kat=$kat&art=".$erg[id]."\">more details</a>";

        if($erg[hinweis]!="0")
        {
          $vkvm=$erg[hinweis]=="1"?"<br><center><img src=\"images/k_vm.gif\" border=\"0\" title=\"rented\"></center>":"<br><center><img src=\"images/k_vk.gif\" border=\"0\" title=\"sold\"></center>";   
        }
        else
        {
          $vkvm="";
        }
?>
      <tr>
        <td width="200" valign="top" align="center"><?if($erstesbild!=""){?><a href="<?=$_SERVER['PHP_SELF']?>?kat=<?=$kat?>&art=<?=$erg[id]?>"><img src="bilder/immobilien/medium/<?=$erstesbild?>" title="<?=$erg[bezeichnung]?>" border="0" style="width:100%;max-width:200px"></a><?}?><?=$vkvm?></td>
        <td width="20"></td>
        <td width="550" valign="top"><a class="det" href="<?=$_SERVER['PHP_SELF']?>?kat=<?=$kat?>&art=<?=$erg[id]?>"><b><?=$erg[bezeichnung]?></b></a><br><br><?=$anriss?></td>
      </tr>
      <tr>
        <td colspan="3" height="21" background="images/hteiler.gif"></td>
      </tr>
<?
      }
    }
?>
      </table>




<?
}
  }
  else
  {
    echo "site under construction";
  }
?>


      </td>
      <td width="15"></td>
      <td width="200" valign="top">
<?
if($keine_kats=="0" && $keine_immos=="0")
{
  if(isset($kat) && $kat!="" && is_numeric($kat) && isset($art) && $art!="" && is_numeric($art))
  {
?>
      <table class="rightbox" border="0" cellpadding="5" cellspacing="0">
      <tr>
        <td><font class="headers">Request:</font></td>
      </tr>
<?
    if($erg[anzeigen]=="1")
    {
      $anre=$erg[anrede]=="1"?"Mr.":"Mrs.";
?>
      <tr>
        <td>For questions and further information please contact</td>
      </tr>
      <tr>
        <td align="center"><?=$anre." <b>".$erg[vorname]." ".$erg[nachname]."</b>";?></td>
      </tr>
      <tr>
        <td align="center">phone number</td>
      </tr>
      <tr>
        <td align="center"><b><?=$erg[telefon]?></b></td>
      </tr>
      <tr>
        <td>or fill in the contact form below and write an email to us.</td>
      </tr>
<?
    }
    else
    {
?>
      <tr>
        <td>For questions and further information fill in the contact form below and write an email to us.</td>
      </tr>
<?
    }
?>
      <tr>
        <td><font class="small">Fields marked with an asterisk (*) are optional.</font><br><br>
<?if(isset($mess) && $mess!=""){?><font class="<?=$fclass?>"><?=$mess?></font><br><br><?}?>
        <form name="anfrage" action="<?=$_SERVER['PHP_SELF']?>" method="POST">
        <table border="0" cellpadding="0" cellspacing="1" width="100%">
        <tr>
          <td><font class="small">Your name:</td>
        </tr>
        <tr>
          <td><input type="text" name="anf_name" style="width:100%" maxlength="50" value="<?=$anf_name?>"></td>
        </tr>
        <tr>
          <td><font class="small">Your email address:</td>
        </tr>
        <tr>
          <td><input type="text" name="anf_email" style="width:100%" maxlength="90" value="<?=$anf_email?>"></td>
        </tr>
        <tr>
          <td><font class="small">Your phone number: *</td>
        </tr>
        <tr>
          <td><input type="text" name="anf_telefon" style="width:100%" maxlength="50" value="<?=$anf_telefon?>"></td>
        </tr>
        <tr>
          <td><font class="small">Anfrage:</td>
        </tr>
        <tr>
          <td><textarea name="anfrage" style="width:100%;height:80px;"><?=$anfrage?></textarea></td>
        </tr>
        <tr>
          <td><input type="submit" value="send" name="anf_send"></td>
        </tr>
        </table><input type="hidden" name="kat" value="<?=$kat?>"><input type="hidden" name="art" value="<?=$art?>"></form>

        </td>
      </tr>
      </table><br>



<?
  }
  if(!isset($art))
  {
?>
      <table class="rightbox" border="0" cellpadding="5" cellspacing="0">
      <tr>
        <td height="10"></td>
      </tr>
      <tr>
        <td><font class="headers">Please choose:</font><br><br>
<?
  foreach($arr_wkats as $wkatid=>$wkatname)
  {
    if(!isset($art) && isset($kat))
    { 
      if($wkatid==$kat)
      {
?>
      <img src="images/rightarrow.gif" border="0"><b><?=$wkatname?></b><br>
<?
      }
      else
      {
?>
        <a class="right" href="<?=$_SERVER['PHP_SELF']?>?kat=<?=$wkatid?>"><img src="images/rightarrow.gif" border="0"><?=$wkatname?></a><br>
<?
      }
    }
    else
    {
?>
        <a class="right" href="<?=$_SERVER['PHP_SELF']?>?kat=<?=$wkatid?>"><img src="images/rightarrow.gif" border="0"><?=$wkatname?></a><br>
<?
    }
  }
?>
        </td>
      </tr>
      <tr>
        <td height="10"></td>
      </tr>
      </table><br><br>
<?
  }
}
?>
      </td>
    </tr>
    </table><br>
    </td>
  </tr>
  </table>
  </td>
</tr>
</table>

<?include("includes/footer.html");?>

</body>
</html>
<? @mysql_close($dblink);?>