<?php
$url = "http://clareslab.com.br/imobiliariav4/";
$site_url = "http://clareslab.com.br/imobiliariav4-demo/detalhes-do-imovel/";
$host = 'localhost';
$user = 'root';
$pass = 'root';
$dbname = 'v4';
$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);

$Headers = $dbh->query('SELECT * FROM config')->fetchAll(\PDO::FETCH_CLASS);
$imobiliaria = $Headers[0];
$imoveis = $dbh->query('SELECT * FROM imovel INNER JOIN tipo ON (imovel_tipo = tipo_id)
INNER JOIN negocio ON (imovel_negocio = negocio_id) INNER JOIN opcao ON (imovel_opcao = opcao_id)
INNER JOIN cidade ON (imovel_cidade = cidade_id) INNER JOIN bairro ON (imovel_bairro = bairro_id)
WHERE imovel_xml = 1
ORDER BY imovel_id DESC ')->fetchAll(\PDO::FETCH_CLASS);


$handle = @opendir(".");
$xml = fopen("vivareal.xml", "w+");
fwrite($xml, "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n<ListingDataFeed xmlns=\"http://www.vivareal.com/schemas/1.0/VRSync\"
                 xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
                 xsi:schemaLocation=\"http://www.vivareal.com/schemas/1.0/VRSync  http://xml.vivareal.com/vrsync.xsd\">\n
                 <Header>
        <Provider>{$imobiliaria->config_nome}</Provider>
        <Email>{$imobiliaria->config_email}</Email>
        <ContactName>{$imobiliaria->config_nome}</ContactName>
        <Logo>$url/midias/logo/{$imobiliaria->config_logo}</Logo>
        <Telephone>{$imobiliaria->config_fone1}</Telephone>
  </Header>\n<Listings>\n\n");


foreach ($imoveis as $imovel) {
    $listdate = date_create("$imovel->imovel_create");
    $lastupdate = date_create("$imovel->imovel_update");
    $featured = ($imovel->imovel_destaque == 0) ? false : true;
    $conteudo = '  <Listing>' . "\n";
    $conteudo .= '<ListingID>' . $imovel->imovel_id . '</ListingID>' . "\n";
    $conteudo .= '<TransactionType>' . $imovel->negocio_nome . '</TransactionType>' . "\n";
    $conteudo .= '     <Featured>' . $featured . '</Featured>' . "\n";
    $conteudo .= '     <ListDate>' . date_format($listdate, "Y-m-d") . '</ListDate>' . "\n";
    $conteudo .= '     <LastUpdateDate>' . date_format($lastupdate, "Y-m-d") . '</LastUpdateDate>' . "\n";
    $conteudo .= '     <DetailViewUrl>' . $site_url . $imovel->cidade_url . '/' . $imovel->bairro_url . '/' . $imovel->imovel_id . '/' . $imovel->tipo_url . '/' . '</DetailViewUrl>' . "\n";
    $fotos = $dbh->query("SELECT * FROM foto WHERE foto_imovel = {$imovel->imovel_id}")->fetchAll(\PDO::FETCH_CLASS);
    $conteudo .= '  <Media>' . "\n";
    $conteudo .= '     <Item medium="image" caption="nome imagem" primary="true">' . $site_url . 'midias/fotos/' . $fotos[0]->foto_url . '</Item>' . "\n";
    foreach ($fotos as $foto) {
        $conteudo .= '     <Item medium="image" caption="nome imagem">' . $site_url . 'midias/fotos/' . $foto->foto_url . '</Item>' . "\n";
    }
    $conteudo .= '</Media>' . "\n";
    $conteudo .= '<Details>' . "\n";
    $conteudo .= '<PropertyType>' . $imovel->tipo_nome . '</PropertyType>' . "\n";
    $conteudo .= '<Description><![CDATA[' . $imovel->imovel_descricao . ']]></Description>' . "\n";
    $conteudo .= '<ListPrice currency="BRL">' . $imovel->imovel_preco . '</ListPrice>' . "\n";
    $conteudo .= '<RentalPrice currency="BRL" period="Monthly">' . $imovel->imovel_preco_locacao . '</RentalPrice>' . "\n";
    $conteudo .= '<PropertyAdministrationFee currency="BRL">' . $imovel->imovel_preco_condominio . '</PropertyAdministrationFee>' . "\n";
    $conteudo .= '<YearlyTax currency="BRL">' . $imovel->imovel_preco_iptu . '</YearlyTax>' . "\n";
    $conteudo .= '<LivingArea unit="square metres">' . $imovel->imovel_area . '</LivingArea>' . "\n";
    $conteudo .= '<Bedrooms>' . $imovel->imovel_dormitorio . '</Bedrooms>' . "\n";
    $conteudo .= '<Bathrooms>' . $imovel->imovel_banheiro . '</Bathrooms>' . "\n";
    $conteudo .= '<Suites>' . $imovel->imovel_suite . '</Suites>' . "\n";
    $conteudo .= '<Garage type="Parking Space">' . $imovel->imovel_vaga . '</Garage>' . "\n";
    $opcs = $dbh->query("SELECT * FROM opcao WHERE opcao_id IN ($imovel->imovel_opcao)")->fetchAll(\PDO::FETCH_CLASS);
    $conteudo .= '<Features>' . "\n";
    foreach ($opcs as $opc) {
        $conteudo .= '   <Feature>' . $opc->opcao_nome . '</Feature>' . "\n";
    }
    $conteudo .= '</Features>' . "\n";
    $conteudo .= '</Details>' . "\n";
    $conteudo .= '<Location displayAddress="All">' . "\n";
    $conteudo .= '<Country abbreviation="BR">Brasil</Country>' . "\n";
    $conteudo .= '<State abbreviation="SP">' . "São Paulo" . '</State>' . "\n"; //FICOU FALTANDO
    $conteudo .= '<City>' . $imovel->cidade_nome . '</City>' . "\n";
    $conteudo .= '<Neighborhood>' . $imovel->bairro_nome . '</Neighborhood>' . "\n";
    $conteudo .= '<Address>' . $imovel->imovel_endereco . '</Address>' . "\n";
    $conteudo .= '<StreetNumber>' . $imovel->imovel_num . '</StreetNumber>' . "\n";//FICOU FALTANDO
    $conteudo .= '<PostalCode>' . $imovel->imovel_cep . '</PostalCode>' . "\n";//FICOU FALTANDO
    $conteudo .= '<Latitude>' . $imovel->imovel_lat . '</Latitude>' . "\n";
    $conteudo .= '<Longitude>' . $imovel->imovel_lon . '</Longitude>' . "\n";
    $conteudo .= '</Location>' . "\n";
    $conteudo .= '<ContactInfo>' . "\n";
    $conteudo .= '<Name>' . $imobiliaria->config_nome . '</Name>' . "\n";
    $conteudo .= '<Email>' . $imobiliaria->config_email . '</Email>' . "\n";
    $conteudo .= '<Website>' . $url . '</Website>' . "\n";
    $conteudo .= '<Photo>' . $url . '/midia/' . $imobiliaria->config_foto . '</Photo>' . "\n";
    $conteudo .= '<Logo>' . $url . '/midia/' . $imobiliaria->config_logo . '</Logo>' . "\n";
    $conteudo .= '<OfficeName>' . $imobiliaria->config_nome . '</OfficeName>' . "\n";
    $conteudo .= '<Telephone>' . $imobiliaria->config_fone1 . '</Telephone>' . "\n";
    $conteudo .= '<Location>' . "\n";
    $conteudo .= '<Country abbreviation="BR">Brasil</Country>' . "\n";
    $conteudo .= '<State abbreviation="SP">' . $imobiliaria->config_estado . '</State>' . "\n";
    $conteudo .= '<City>' . $imobiliaria->config_cidade . '</City>' . "\n";
    $conteudo .= '<Neighborhood>' . $imobiliaria->config_bairro . '</Neighborhood>' . "\n";
    $conteudo .= '<Address>' . $imobiliaria->config_end . '</Address>' . "\n";
    $conteudo .= '<PostalCode>' . $imobiliaria->config_cep . '</PostalCode>' . "\n";
    $conteudo .= '<Latitude>' . $imobiliaria->config_lat . '</Latitude>' . "\n";
    $conteudo .= '<Longitude>' . $imobiliaria->config_lon . '</Longitude>' . "\n";
    $conteudo .= '</Location>' . "\n";
    $conteudo .= '</ContactInfo>' . "\n";
    $conteudo .= '</Listing>' . "\n";
    fwrite($xml, $conteudo);
}
closedir($handle);
fwrite($xml, "\n</Listings></ListingDataFeed>");
fclose($xml);