API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 5th, 2017
210
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.63 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $url = "http://clareslab.com.br/imobiliariav4";
  3. $site_url = "http://clareslab.com.br/imobiliariav4-demo/detalhes-do-imovel";
  4. $host = 'localhost';
  5. $user = 'root';
  6. $pass = 'root';
  7. $dbname = 'v4';
  8. $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
  9.  
  10. $Headers = $dbh->query('SELECT * FROM config')->fetchAll(\PDO::FETCH_CLASS);
  11. $imobiliaria = $Headers[0];
  12. $imoveis = $dbh->query('SELECT * FROM imovel INNER JOIN tipo ON (imovel_tipo = tipo_id)
  13. INNER JOIN negocio ON (imovel_negocio = negocio_id) INNER JOIN opcao ON (imovel_opcao = opcao_id)
  14. INNER JOIN cidade ON (imovel_cidade = cidade_id) INNER JOIN bairro ON (imovel_bairro = bairro_id)
  15. WHERE imovel_xml = 1
  16. ORDER BY imovel_id DESC ')->fetchAll(\PDO::FETCH_CLASS);
  17.  
  18. $imobiliaria->config_logo = $imobiliaria->config_foto;
  19. $handle = @opendir(".");
  20. $xml = fopen("vivareal.xml", "w+");
  21. fwrite($xml, "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n<ListingDataFeed xmlns=\"http://www.vivareal.com/schemas/1.0/VRSync\"
  22.                 xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
  23.                 xsi:schemaLocation=\"http://www.vivareal.com/schemas/1.0/VRSync  http://xml.vivareal.com/vrsync.xsd\">\n
  24.                 <Header>
  25.        <Provider>{$imobiliaria->config_nome}</Provider>
  26.        <Email>{$imobiliaria->config_email}</Email>
  27.        <ContactName>{$imobiliaria->config_nome}</ContactName>
  28.        <Logo>$url/midias/logo/{$imobiliaria->config_logo}</Logo>
  29.        <Telephone>{$imobiliaria->config_fone1}</Telephone>
  30.  </Header>\n<Listings>\n\n");
  31.  
  32.  
  33. foreach ($imoveis as $imovel) {
  34.     $listdate = date_create("$imovel->imovel_create");
  35.     $lastupdate = date_create("$imovel->imovel_update");
  36.     $featured = ($imovel->imovel_destaque == 0) ? 'false' : 'true';
  37.     $conteudo = '  <Listing>' . "\n";
  38.     $conteudo = '<Title><![CDATA[' . $imovel->tipo_nome . 'em' . $imovel->cidade_nome . ']]></Title>' . "\n";
  39.     $conteudo .= '<ListingID>' . $imovel->imovel_id . '</ListingID>' . "\n";
  40.     switch ($imovel->negocio_nome) {
  41.         case 'Venda':
  42.             $conteudo .= '<TransactionType>For Rent</TransactionType>' . "\n";
  43.             break;
  44.         case 'Locação':
  45.             $conteudo .= '<TransactionType>For Sale</TransactionType>' . "\n";
  46.             break;
  47.     }
  48.  
  49.     $conteudo .= '     <Featured>' . $featured . '</Featured>' . "\n";
  50.     $conteudo .= '     <ListDate>' . date_format($listdate, "Y-m-d") . '</ListDate>' . "\n";
  51.     $conteudo .= '     <LastUpdateDate>' . date_format($lastupdate, "Y-m-d") . '</LastUpdateDate>' . "\n";
  52.     $conteudo .= '     <DetailViewUrl>' . $site_url . '/' . $imovel->cidade_url . '/' . $imovel->bairro_url . '/' . $imovel->imovel_id . '/' . $imovel->tipo_url . '/' . '</DetailViewUrl>' . "\n";
  53.     $fotos = $dbh->query("SELECT * FROM foto WHERE foto_imovel = {$imovel->imovel_id}")->fetchAll(\PDO::FETCH_CLASS);
  54.     $conteudo .= ' <Media>' . "\n";
  55.     $conteudo .= '<Item medium="image" caption="' . $fotos[0]->foto_url . '" primary="true">' . $site_url . '/midias/fotos/' . $fotos[0]->foto_url . '</Item>' . "\n";
  56.     foreach ($fotos as $foto) {
  57.         $conteudo .= '<Item medium="image" caption="' . $foto->foto_url . '">' . $site_url . '/midias/fotos/' . $foto->foto_url . '</Item>' . "\n";
  58.     }
  59.     $conteudo .= '</Media>' . "\n";
  60.     $conteudo .= '<Details>' . "\n";
  61.  
  62.     switch ($imovel->tipo_nome) {
  63.         case 'Apartamento':
  64.             $conteudo .= '<PropertyType>Residential/Apartment</PropertyType>' . "\n";
  65.             break;
  66.         case 'Casa':
  67.             $conteudo .= '<PropertyType>Residential/Home</PropertyType>' . "\n";
  68.             break;
  69.         case 'Chácara':
  70.             $conteudo .= '<PropertyType>Residential/Farm Ranch</PropertyType>' . "\n";
  71.             break;
  72.         case 'Casa de Condomínio':
  73.             $conteudo .= '<PropertyType>Residential/Condo</PropertyType>' . "\n";
  74.             break;
  75.         case 'Flat':
  76.             $conteudo .= '<PropertyType>Residential/Flat</PropertyType>' . "\n";
  77.             break;
  78.         case 'Lote/Terreno Residencial':
  79.             $conteudo .= '<PropertyType>Residential/Land Lot</PropertyType>' . "\n";
  80.             break;
  81.         case 'Sobrado':
  82.             $conteudo .= '<PropertyType>Residential/Sobrado</PropertyType>' . "\n";
  83.             break;
  84.         case 'Cobertura':
  85.             $conteudo .= '<PropertyType>Residential/Penthouse</PropertyType>' . "\n";
  86.             break;
  87.         case 'Kitnet':
  88.             $conteudo .= '<PropertyType>Residential/Kitnet</PropertyType>' . "\n";
  89.             break;
  90.         case 'Consultório':
  91.             $conteudo .= '<PropertyType>Commercial/Consultorio</PropertyType>' . "\n";
  92.             break;
  93.         case 'Sala Comercial':
  94.             $conteudo .= '<PropertyType>Commercial/Office</PropertyType>' . "\n";
  95.             break;
  96.         case 'Fazenda/Sitio':
  97.             $conteudo .= '<PropertyType>Commercial/Agricultural</PropertyType>' . "\n";
  98.             break;
  99.         case 'Galpão/Depósito/Armazém':
  100.             $conteudo .= '<PropertyType>Commercial/Industrial</PropertyType>' . "\n";
  101.             break;
  102.         case 'Imóvel Comercial':
  103.             $conteudo .= '<PropertyType>Commercial/Building</PropertyType>' . "\n";
  104.             break;
  105.         case 'Loja':
  106.             $conteudo .= '<PropertyType>Commercial/Loja</PropertyType>' . "\n";
  107.             break;
  108.         case 'Lote/Terreno Comercial':
  109.             $conteudo .= '<PropertyType>Commercial/Land Lot</PropertyType>' . "\n";
  110.             break;
  111.         case 'Ponto Comercial':
  112.             $conteudo .= '<PropertyType>Commercial/Business</PropertyType>' . "\n";
  113.             break;
  114.         case 'Edifício Residencial':
  115.             $conteudo .= '<PropertyType>Commercial/Residential Income</PropertyType>' . "\n";
  116.             break;
  117.     }
  118.     $conteudo .= '<Description><![CDATA[' . $imovel->imovel_descricao . ']]></Description>' . "\n";
  119.     switch ($imovel->negocio_nome) {
  120.         case 'Venda':
  121.             $conteudo .= '<ListPrice currency="BRL">' . substr($imovel->imovel_preco, 0, -3) . '</ListPrice>' . "\n";
  122.             break;
  123.         case 'Locação':
  124.             $conteudo .= '<RentalPrice currency="BRL" period="Monthly">' . substr($imovel->imovel_preco_locacao, 0, -3) . '</RentalPrice>' . "\n";
  125.             break;
  126.     }
  127.  
  128.     $conteudo .= '<PropertyAdministrationFee currency="BRL">' . $imovel->imovel_preco_condominio . '</PropertyAdministrationFee>' . "\n";
  129.     $conteudo .= '<YearlyTax currency="BRL">' . $imovel->imovel_preco_iptu . '</YearlyTax>' . "\n";
  130.     $conteudo .= '<LivingArea unit="square metres">' . $imovel->imovel_area . '</LivingArea>' . "\n";
  131.     $conteudo .= '<Bedrooms>' . $imovel->imovel_dormitorio . '</Bedrooms>' . "\n";
  132.     $conteudo .= '<Bathrooms>' . $imovel->imovel_banheiro . '</Bathrooms>' . "\n";
  133.     $conteudo .= '<Suites>' . $imovel->imovel_suite . '</Suites>' . "\n";
  134.     $conteudo .= '<Garage type="Parking Space">' . $imovel->imovel_vaga . '</Garage>' . "\n";
  135.     $opcs = $dbh->query("SELECT * FROM opcao WHERE opcao_id IN ($imovel->imovel_opcao)")->fetchAll(\PDO::FETCH_CLASS);
  136.     $conteudo .= '<Features>' . "\n";
  137.     foreach ($opcs as $opc) {
  138.         $conteudo .= '   <Feature>' . $opc->opcao_nome . '</Feature>' . "\n";
  139.     }
  140.     $conteudo .= '</Features>' . "\n";
  141.     $conteudo .= '</Details>' . "\n";
  142.     $conteudo .= '<Location displayAddress="' . $imovel->imovel_mapa == 1 ? 'All' : 'Street' . '">' . "\n";
  143.     $conteudo .= '<Country abbreviation="BR">Brasil</Country>' . "\n";
  144.     $conteudo .= '<State abbreviation="SP">' . "$imovel->config_estado" . '</State>' . "\n";
  145.     $conteudo .= '<City>' . $imovel->cidade_nome . '</City>' . "\n";
  146.     $conteudo .= '<Neighborhood>' . $imovel->bairro_nome . '</Neighborhood>' . "\n";
  147.     $conteudo .= '<Address>' . $imovel->imovel_endereco . '</Address>' . "\n";
  148.     $conteudo .= '<StreetNumber>' . $imovel->imovel_num . '</StreetNumber>' . "\n";
  149.     $conteudo .= '<PostalCode>' . $imovel->imovel_cep . '</PostalCode>' . "\n";
  150.     $conteudo .= '<Latitude>' . $imovel->imovel_lat . '</Latitude>' . "\n";
  151.     $conteudo .= '<Longitude>' . $imovel->imovel_lon . '</Longitude>' . "\n";
  152.     $conteudo .= '</Location>' . "\n";
  153.     $conteudo .= '<ContactInfo>' . "\n";
  154.     $conteudo .= '<Name>' . $imobiliaria->config_nome . '</Name>' . "\n";
  155.     $conteudo .= '<Email>' . $imobiliaria->config_email . '</Email>' . "\n";
  156.     $conteudo .= '<Website>' . $url . '</Website>' . "\n";
  157.     $conteudo .= '<Photo>' . $url . '/midia/' . $imobiliaria->config_logo . '</Photo>' . "\n";
  158.     $conteudo .= '<Logo>' . $url . '/midia/' . $imobiliaria->config_logo . '</Logo>' . "\n";
  159.     $conteudo .= '<OfficeName>' . $imobiliaria->config_nome . '</OfficeName>' . "\n";
  160.     $conteudo .= '<Telephone>' . $imobiliaria->config_fone1 . '</Telephone>' . "\n";
  161.     $conteudo .= '<Location>' . "\n";
  162.     $conteudo .= '<Country abbreviation="BR">Brasil</Country>' . "\n";
  163.     $conteudo .= '<State abbreviation="SP">' . $imobiliaria->config_estado . '</State>' . "\n";
  164.     $conteudo .= '<City>' . $imobiliaria->config_cidade . '</City>' . "\n";
  165.     $conteudo .= '<Neighborhood>' . $imobiliaria->config_bairro . '</Neighborhood>' . "\n";
  166.     $conteudo .= '<Address>' . $imobiliaria->config_end . '</Address>' . "\n";
  167.     $conteudo .= '<PostalCode>' . $imobiliaria->config_cep . '</PostalCode>' . "\n";
  168.     $conteudo .= '<Latitude>' . $imobiliaria->config_lat . '</Latitude>' . "\n";
  169.     $conteudo .= '<Longitude>' . $imobiliaria->config_lon . '</Longitude>' . "\n";
  170.     $conteudo .= '</Location>' . "\n";
  171.     $conteudo .= '</ContactInfo>' . "\n";
  172.     $conteudo .= '</Listing>' . "\n";
  173.     fwrite($xml, $conteudo);
  174. }
  175. closedir($handle);
  176. fwrite($xml, "\n</Listings></ListingDataFeed>");
  177. fclose($xml);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!