<?php require_once('../Connections/antre011.php'); ?>
<?php
header('Content-type: application/xml');echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_antre011, $antre011);
$query_record2 = "SELECT jml_iproperty_images.title, jml_iproperty_images.propid, jml_iproperty_images.`path`, jml_iproperty_images.type, jml_iproperty.id, jml_iproperty_images.fname FROM jml_iproperty_images, jml_iproperty WHERE jml_iproperty.id = jml_iproperty_images.propid";
$record2 = mysql_query($query_record2, $antre011) or die(mysql_error());
$row_record2 = mysql_fetch_assoc($record2);
$totalRows_record2 = mysql_num_rows($record2);
mysql_select_db($database_antre011, $antre011);

$query_record = "select jml_iproperty.id, jml_iproperty.stype, jml_iproperty.street, jml_iproperty.beds, jml_iproperty.style, jml_iproperty.sqft, jml_iproperty.price, jml_iproperty.yearbuilt, jml_iproperty.lot_type, jml_iproperty.fuel, jml_iproperty.cool, jml_iproperty.apt, jml_iproperty.lot_acres, jml_iproperty.lotsize, jml_iproperty.baths, jml_iproperty.heat, jml_iproperty.garage_type, jml_iproperty.garage_size, jml_iproperty.reception, jml_iproperty.tax, jml_iproperty.income, jml_iproperty.zoning, jml_iproperty.propview, jml_iproperty.short_description, UNIX_TIMESTAMP(jml_iproperty.created), jml_iproperty.state, jml_iproperty_categories.alias, jml_iproperty_countries.mc_name
from jml_iproperty
left join  jml_iproperty_propmid on jml_iproperty.id= jml_iproperty_propmid.prop_id
left join jml_iproperty_countries on jml_iproperty_countries.id=jml_iproperty.country
left join jml_iproperty_categories on jml_iproperty_propmid.cat_id=jml_iproperty_categories.id
where jml_iproperty_categories.id IS NOT NULL and jml_iproperty_categories.alias<>'garaze' and jml_iproperty_categories.alias<>'gradjevinsko' and jml_iproperty_categories.alias<>'obradivo'
and jml_iproperty_categories.alias<>'pomocni-objekti' and jml_iproperty_categories.alias<>'skladista' and jml_iproperty_categories.alias<>'sobe' and jml_iproperty_categories.alias<>'turizam'
and jml_iproperty_categories.alias<>'ugostiteljski-objekti' and jml_iproperty_categories.alias<>'zemljista';";
mysql_set_charset('utf8');
$record = mysql_query($query_record, $antre011) or die(mysql_error());
$row_record = mysql_fetch_assoc($record);
$totalRows_record = mysql_num_rows($record);
$nekretnina1 = $row_record['id'];
$nekretnina2 = $row_record2['propid'];

echo '<oglasi>';
   
    while($row_record = mysql_fetch_array($record))
    {
    ?>
      <oglas>
        <id><?php echo $row_record['id']; ?></id>
        <tip><?php
if ($row_record['stype'] == "4")
{
  echo "2";
  }
 elseif ($row_record['stype'] == "1")
 {
  echo "1";
  }
 else
 {
  echo "-1";
  }
?></tip>
        <kraj><?php echo $row_record['mc_name']; ?></kraj>
        <struktura><?php
          $struktura = $row_record['alias'];
if ($struktura == "kuce")
{
  echo "2";
  }
 elseif ($struktura == "poslovni-prostor")
 {
  echo "3";
  }
  elseif ($struktura == "lokali")
 {
  echo "3";
  }
  elseif ($struktura == "poslovni-objekti")
 {
  echo "3";
  }
  elseif ($struktura == "05garsonjere")
 {
  echo "1";
  }
  elseif ($struktura == "1-jednosobni")
 {
  echo "1";
  }
  elseif ($struktura == "1-5-jednoiposobni")
 {
  echo "1";
  }
  elseif ($struktura == "2-0-dvosobni")
 {
  echo "1";
  }
  elseif ($struktura == "2-5-dvoiposobni")
 {
  echo "1";
  }
  elseif ($struktura == "3-0-trosobni")
 {
  echo "1";
  }
  elseif ($struktura == "3-5-troiposobni")
 {
  echo "1";
  }
  elseif ($struktura == "4-0-cetvorosobniplus")
 {
  echo "1";
  }
 else
 {
  echo "-1";
  }      
   ?></struktura>
        <adresa><?php echo $row_record['street']; ?></adresa>
        <broj_soba><?php echo $row_record['beds']; ?></broj_soba>
        <broj_etaza><?php echo $row_record['style']; ?></broj_etaza>
        <povrsina><?php echo $row_record['sqft']; ?></povrsina>
        <cena><?php echo floor ($row_record['price']); ?></cena>
        <godiste><?php
if ($row_record['yearbuilt'] == "")
{
  echo "";
  }
 else
 {
 
  echo $row_record['yearbuilt'];
  }
          ?></godiste>
        <uknjizen><?php
          if ($row_record['lot_type'] == "DA")
{
  echo "1";
  }
 else
 {
  echo "-1";
  }
          ?></uknjizen>
        <stanje><?php
          if ($row_record['fuel'] == "novo")
{
  echo "2";
  }
 elseif ($row_record['fuel'] == "u izgradnji")
 {
  echo "3";
  }
  elseif ($row_record['fuel'] == "renovirano")
 {
  echo "4";
  }
  elseif ($row_record['fuel'] == "potrebno renoviranje")
 {
  echo "5";
  }
 else
 {
  echo "1";
  }
      ?></stanje>
        <useljivo>1</useljivo>
        <opremljenost><?php
          if ($row_record['cool'] == "prazno")
{
  echo "1";
  }
 elseif ($row_record['cool'] == "nameteno")
 {
  echo "3";
  }
 else
 {
  echo "2";
  }
      ?></opremljenost>
        <sprat><?php
          if ($row_record['apt'] == "suteren")
{
  echo "-4";
  }
 elseif ($row_record['apt'] == "nisko prizemlje")
 {
  echo "-3";
  }
  elseif ($row_record['apt'] == "prizemlje")
 {
  echo "-2";
  }
  elseif ($row_record['apt'] == "visoko prizemlje")
 {
  echo "-1";
  }
 else
 {
  echo $row_record['apt'];
  }
       ?></sprat>
        <plac><?php
          if ($row_record['lot_acres'] == "")
{
  echo "";
  }
 else
 {
  echo $row_record['lot_acres'];
  }
       ?></plac>
        <terasa><?php
          if ($row_record['lotsize'] == "")
{
  echo "-1";
  }
 elseif ($row_record['lotsize'] == "ne")
 {
  echo "-1";
  }
  elseif ($row_record['lotsize'] == "da")
 {
  echo "1";
  }
 else
 {
  echo $row_record['lotsize'];
  }
       ?></terasa>
        <kupatilo><?php
          if ($row_record['baths'] == "0")
{
  echo "-1";
  }
 else
 {
  echo floor ($row_record['baths']);
  }
       ?></kupatilo>
        <grejanje><?php
          if ($row_record['heat'] == "CG")
{
  echo "1";
  }
 elseif ($row_record['heat'] == "EG")
 {
  echo "2";
  }
  elseif ($row_record['heat'] == "gas")
 {
  echo "4";
  }
  elseif ($row_record['heat'] == "kaljeva")
 {
  echo "5";
  }
  elseif ($row_record['heat'] == "norveki")
 {
  echo "6";
  }
  elseif ($row_record['heat'] == "podno")
 {
  echo "7";
  }
 else
 {
  echo "3";
  }
       ?></grejanje>
        <telefon><?php
          if ($row_record['garage_type'] == "")
{
  echo "0";
  }
 else
 {
  echo $row_record['garage_type'];
  }
       ?></telefon>
        <kablovska><?php
          if ($row_record['garage_size'] == "DA")
{
  echo "1";
  }
 else
 {
  echo "-1";
  }
       ?></kablovska>
        <internet><?php
          if ($row_record['reception'] == "da")
{
  echo "1";
  }
 elseif ($row_record['reception'] == "dial-up")
 {
  echo "2";
  }
  elseif ($row_record['reception'] == "adsl")
 {
  echo "3";
  }
  elseif ($row_record['reception'] == "kablovski")
 {
  echo "4";
  }
 else
 {
  echo "-1";
  }
       ?></internet>
        <lift><?php
          if ($row_record['tax'] == "da")
{
  echo "1";
  }
 elseif ($row_record['tax'] == "ne")
 {
  echo "-1";
  }
  elseif ($row_record['tax'] == "")
 {
  echo "-1";
  }
 else
 {
  echo $row_record['tax'];
  }
       ?></lift>
        <interfon><?php
          if ($row_record['income'] == "da")
{
  echo "1";
  }
 else
 {
  echo "-1";
  }
       ?></interfon>
        <garaza><?php
          if ($row_record['zoning'] == "da")
{
  echo "1";
  }
 elseif ($row_record['zoning'] == "ne")
 {
  echo "-1";
  }
  elseif ($row_record['zoning'] == "")
 {
  echo "-1";
  }
 else
 {
  echo $row_record['zoning'];
  }
       ?></garaza>
        <parking><?php
          if ($row_record['propview'] == "da")
{
  echo "1";
  }
 elseif ($row_record['propview'] == "ne")
 {
  echo "-1";
  }
  elseif ($row_record['propview'] == "")
 {
  echo "-1";
  }
 else
 {
  echo $row_record['propview'];
  }
       ?></parking>
        <opis><?php echo $row_record['short_description']; ?></opis>
        <azuriran><?php echo $row_record['UNIX_TIMESTAMP(jml_iproperty.created)']; ?></azuriran>
        <slike>

<?php

 echo "<slika>"; echo "http://www.antre011.rs"; echo implode ($row_record2['path']); echo implode ($row_record2['fname']); echo implode ($row_record2['type']); echo "</slika>";
 //} while ($row_record2 = mysql_fetch_assoc($record2));  

       
//mysql_free_result($record2);

?>
</slike>
        </oglas>
   <?php
   }
   

echo "</oglasi>";




//mysql_free_result($record);
?>