<?php
#define o encoding do cabeçalho para utf-8
@header("Content-Type: text/html; charset=utf-8");
#carrega o arquivo XML e retornando um Array
/*$xml = simplexml_load_file("http://www.sp-lancamentos.com/parceiros/trovit_feed.xml");
# se o xml for um link e nao um arquivo como livros.xml, troque -o pelo link ex.
# $xml = simplexml_load_file("http://endereco/link/mesmoQueNaoTenhaExtensaoXML/");
#para cada nó LIVRO  atribui à variavel $livro (obj simplexml)


foreach($xml->ad as $ad)
{
echo $ad->id;
#usando o utf8_decode para exibir com acentos
echo $ad->cod;
echo $ad->url;
echo $ad->title;
echo $ad->type;
echo "<br>";
}*/
require_once("verifica.php");

include_once('js/configurations.php');

// create doctype
$dom = new DOMDocument("1.0","utf-8");
// create root element
$root = $dom->createElement("trovit");
$dom->appendChild($root);
$dom->formatOutput=true;

//$link[0]="http://buscadoimovel.com.br";
//$link[1]="http://sp-lancamentos.com";

$contador_links = 0;
$contador_while = 0;

$sql2 = mysql_query("SELECT * FROM integracao ORDER BY id_integracao DESC");
//$linha2 = mysql_fetch_array($sql2);

while($contador_links!="-1"){
	
	$linha2 = mysql_fetch_array($sql2);
	$link[$contador_links]=$linha2["nome"];
	
	if($link[$contador_links]!=""){
	
		$contador_while = $contador_links + 1;
		$contador_links++;
		
	}else{
		
		$contador_links = "-1";
		
	}
	
}

$contador_total_imoveis=0;
$contador=0;

while($contador_links!="-1"){
	
	$link[$contador_links]=$salvar_imovel[$contador_links];
	
	if($link[$contador_links]){
		echo $link[$contador_links]."  -  ";
		$contador_links++;
		
	}else{
		$contador_while = $contador_links;
		$contador_links = "-1";
		echo $contador_while."  -  ";
	}
}
/*
$contador=0;
$contador_total_clientes=0;
$contador_total_imoveis=0;
*/



$contador_total_imoveis=0;
$contador=0;

while($contador != $contador_while){
$xml = simplexml_load_file($link[$contador]."/parceiros/trovit_feed.xml");
# se o xml for um link e nao um arquivo como livros.xml, troque -o pelo link ex.
# $xml = simplexml_load_file("http://endereco/link/mesmoQueNaoTenhaExtensaoXML/");
#para cada nó LIVRO  atribui à variavel $livro (obj simplexml)

/*
foreach($xml->ad as $ad)
{
echo $ad->id;
#usando o utf8_decode para exibir com acentos
echo $ad->cod;
echo $ad->url;
echo $ad->title;
echo $ad->type;
echo "<br>";
}
*/

foreach($xml->ad as $ad){



$ad_id = $ad->id;
$ad_url = $ad->url;
$ad_type = $ad->type;
$ad_title = $ad->title;
$ad_content = $ad->content;
$ad_price = $ad->price;
$ad_property_type = $ad->property_type;
$ad_floor_area = $ad->floor_area;
$ad_plot_area = $ad->plot_area;
$ad_rooms = $ad->rooms;
$ad_bathrooms = $ad->bathrooms;
$ad_condition = $ad->condition;
$ad_parking = $ad->parking;
$ad_floor_number = $ad->floor_number;
$ad_orientation = $ad->orientation;
$ad_is_new = $ad->is_new;
$ad_year = $ad->year;
$ad_region = $ad->region;
$ad_city = $ad->city;
$ad_city_area = $ad->city_area;
$ad_address = $ad->address;
$ad_postcode = $ad->postcode;
$ad_by_owner = $ad->by_owner;
$ad_agency = $ad->agency;
$ad_latitude = $ad->latitude;
$ad_longitude = $ad->longitude;
$ad_date = $ad->date;
$ad_pictures = $ad->pictures;
$ad_picture = $ad->picture;
$ad_picture_url = $ad->picture_url;
$ad_picture_title = $ad->picture_title;

$ano = substr($ad_year,0,4);

// create child element
$ad = $dom->createElement("ad");
$root->appendChild($ad);

// create text node
$id = $dom->createElement("id");
$ad->appendChild($id);
$url = $dom->createElement("url");
$ad->appendChild($url);
$title = $dom->createElement("title");
$ad->appendChild($title);
$type = $dom->createElement("type");
$ad->appendChild($type);
$content = $dom->createElement("content");
$ad->appendChild($content);
$price = $dom->createElement("price");
$ad->appendChild($price);
$property_type = $dom->createElement("property_type");
$ad->appendChild($property_type);
$floor_area = $dom->createElement("floor_area");
$ad->appendChild($floor_area);
$plot_area = $dom->createElement("plot_area");
$ad->appendChild($plot_area);

//if (!$campo['is_lancamento']) {
$bedrooms = $dom->createElement("rooms");
$ad->appendChild($bedrooms);
$bathrooms = $dom->createElement("bathrooms");
$ad->appendChild($bathrooms);
$condition = $dom->createElement("condition");
$ad->appendChild($condition);

$parking = $dom->createElement("parking");
$ad->appendChild($parking);
$floor_number = $dom->createElement("floor_number");
$ad->appendChild($floor_number);
$orientation = $dom->createElement("orientation");
$ad->appendChild($orientation);
//}

//if ($campo['is_lancamento']) {
$is_new = $dom->createElement("is_new");
$ad->appendChild($is_new);
$year = $dom->createElement("year");
$ad->appendChild($year);
//}

$region = $dom->createElement("region");
$ad->appendChild($region);
$city = $dom->createElement("city");
$ad->appendChild($city);
$city_area = $dom->createElement("city_area");
$ad->appendChild($city_area);
$address = $dom->createElement("address");
$ad->appendChild($address);
$postcode = $dom->createElement("postcode");
$ad->appendChild($postcode);
$by_owner = $dom->createElement("by_owner");
$ad->appendChild($by_owner);
$agency = $dom->createElement("agency");
$ad->appendChild($agency);

$lat = $dom->createElement("latitude");
$ad->appendChild($lat);
$lon = $dom->createElement("longitude");
$ad->appendChild($lon);
$date = $dom->createElement("date");
$ad->appendChild($date);

$pictures = $dom->createElement("pictures");
$ad->appendChild($pictures);


//criando subelementos

$picture = $dom->createElement("picture");
$pictures->appendChild($picture);


$picture_url = $dom->createElement("picture_url");
$picture->appendChild($picture_url);
$picture_title = $dom->createElement("picture_title");
$picture->appendChild($picture_title);

/*
//criando atributos
if ($tparea!="msup2") {

$unit_fa = $dom->createAttribute("unit");
$floor_area->appendChild($unit_fa);

$unit_pa = $dom->createAttribute("unit");
$plot_area->appendChild($unit_pa);

}

//criando valor do atributo


if (!$campo['is_lancamento']) {
$unidade_t=retTipoAreaTR($campo['tipo_util']);

$unit_faValue = $dom->createTextNode($unidade_t);
$unit_fa->appendChild($unit_faValue);

$unidade_p=retTipoAreaTR($campo['tipo_total']);
$unit_paValue = $dom->createTextNode($unidade_p);
$unit_pa->appendChild($unit_paValue);
}else
{
$unit_faValue = $dom->createTextNode("");
$unit_fa->appendChild($unit_faValue);

$unit_paValue = $dom->createTextNode($unidade_at);
$unit_pa->appendChild($unit_paValue);

}



$thumb = substr($campo['icone'], 0, 3);  // returns "abcde"
	if ($thumb =="tn_")
	$imgnome = substr($campo['icone'], 3);
	else 
	$imgnome = $campo['icone'];

	$sqlfoto = mysql_query("SELECT * FROM fotos WHERE foto='$imgnome'") or die(mysql_error()); 
    $resfotos = mysql_fetch_array($sqlfoto);
						
	if ($campo['icone']!="sem_icone.gif"){
	$fotonomebase = $resfotos['id_foto'].'/s3/'.$imgnome;
	}
	else{
	$fotonomebase="sem_icone_capa.gif";
	} 

*/
// create CDATA section


$cdata = $dom->createCDATASection($ad_id);
$id->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_url);
$url->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_title);
$title->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_type);
$type->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_content);
$content->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_price);
$price->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_property_type);
$property_type->appendChild($cdata);

//if (!$campo['is_lancamento']) {
$cdata = $dom->createCDATASection($ad_floor_area);
$floor_area->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_plot_area);
$plot_area->appendChild($cdata);

//} else{
//$cdata = $dom->createCDATASection("");
//$floor_area->appendChild($cdata);

//$cdata = $dom->createCDATASection($ad->plot_area);
//$plot_area->appendChild($cdata);	
	//}

//if (!$campo['is_lancamento']) {
$cdata = $dom->createCDATASection($ad_rooms);
$bedrooms->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_bathrooms);
$bathrooms->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_condition);
$condition->appendChild($cdata);

//if ($garagem){
//$cdata = $dom->createCDATASection(1);
//$parking->appendChild($cdata);
//} else{
//$cdata = $dom->createCDATASection(0);
//$parking->appendChild($cdata);	
	//}
$cdata = $dom->createCDATASection($ad_floor_number);
$floor_number->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_orientation);
$orientation->appendChild($cdata);
//}
//if ($campo['is_lancamento']) {
$cdata = $dom->createCDATASection($ad_is_new);
$is_new->appendChild($cdata);

$cdata = $dom->createCDATASection($ano);
$year->appendChild($cdata);
//}

$cdata = $dom->createCDATASection($ad_region);
$region->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_city);
$city->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_city_area);
$city_area->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_address);
$address->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_postcode);
$postcode->appendChild($cdata);

//if ($campo["id_cliente"]){
$cdata = $dom->createCDATASection($ad_by_owner);
$by_owner->appendChild($cdata);
//}
//else{
//$cdata = $dom->createCDATASection(0);
//$by_owner->appendChild($cdata);
	
//}
$cdata = $dom->createCDATASection($ad_agency);
$agency->appendChild($cdata);


$cdata = $dom->createCDATASection($ad_latitude);
$lat->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_longitude);
$lon->appendChild($cdata);



$cdata = $dom->createCDATASection($ad_date);
$date->appendChild($cdata);


$cdata = $dom->createCDATASection($ad_picture_url);
$picture_url->appendChild($cdata);

$cdata = $dom->createCDATASection($ad_picture_title);
$picture_title->appendChild($cdata);

$contador_total_imoveis++;

}

$contador++;
}




$caminho = "trovit_unico/";

if ($file_number > 0){

// save tree to file
$dom->save($caminho."_".$file_number."trovit_feed_unico.xml");

// save tree to string
$order = $dom->save($caminho."_".$file_number."trovit_feed_unico.xml");

}
else{
// save tree to file
$dom->save($caminho."trovit_feed_unico.xml");

// save tree to string
$order = $dom->save($caminho."trovit_feed_unico.xml");

}



$file_number = $file_number + 1;
$limit = $limit + 1000;


echo "Quantidade de Clientes: ".$contador_while."   |   ";
echo "Quantidade de Imóveis: ".$contador_total_imoveis;



?>