<?php

////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Generador Feed Google Merchant realizado por Ruben Divall
// Contacto yo@rubendivall.es
// Inclusión de ofertas
// El valor MPN se tomará del valor Modelo (products_model) de tu base de datos
////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Si deseas alguna personalización, para generar otros o más datos contactame en yo@rubendivall.es
////////////////////////////////////////////////////////////////////////////////////////////////////////////

  require('includes/application_top.php');
$products_query_raw = "select p.products_id, p.products_model, p.products_weight, pd.products_description, p.products_tax_class_id, pd.products_name, p.products_image, p.manufacturers_id, p.products_quantity, p.products_price from products p, products_description pd where p.products_status=1 and p.products_id = pd.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_id ASC"; 
  $products_query = tep_db_query($products_query_raw);
  while ($products = tep_db_fetch_array($products_query))
 
	{
		
		
		
		if ($new_price = tep_get_products_special_price($products['products_id'])) {
      $precio = limpiar_precio($currencies->display_price($new_price, tep_get_tax_rate($products['products_tax_class_id'])));
    } else {
      $precio = tep_add_tax($products['products_price'], tep_get_tax_rate($products['products_tax_class_id']));
    }
		
		$products_id = $products['products_id'];
		$peso=$products['products_weight'];
		$cat=tep_db_fetch_array(tep_db_query("select manufacturers_name from manufacturers where manufacturers_id=".$products['products_id'].""));
		$qmarca= tep_db_fetch_array(tep_db_query("select manufacturers_name, manufacturers_image from manufacturers where manufacturers_id=".$products['manufacturers_id'].""));
		$qcategoria= tep_db_fetch_array(tep_db_query("select categories_id FROM products_to_categories WHERE products_id =".$products['products_id']." order by categories_id ASC LIMIT 1")); 
		$ncategoria = tep_db_fetch_array(tep_db_query("select categories_name FROM categories_description WHERE categories_id =".$qcategoria['categories_id']." and language_id='" . (int)$languages_id . "'")); 
		$categoria=$ncategoria['categories_name'];
		$marca=$qmarca['manufacturers_name'];

		if ($products['products_quantity']>0) {$disponibilidad='in stock';} else {$disponibilidad='out of stock';}
	  
	  $link=tep_href_link(FILENAME_PRODUCT_INFO,'products_id='.$products['products_id'], 'NONSSL', false); 
	  $img=tep_href_link(DIR_WS_IMAGES.$products['products_image']);
	  
	  $descripcion= eregi_replace("[ \t\n\r]+", ' ', substr(strip_tags(html_entity_decode($products['products_description'])),0,500) .'...');  
	  $lineafeed.=
	  $products['products_id']."\t".
	  $products['products_model']."\t".
	  ucwords(strtolower(limpiar($products['products_name'])))."\t".
	  $descripcion."\t".
	  $link."\t".
	  $precio."\t".
	  ucwords(strtolower($marca))."\t".
	  ucwords(strtolower($marca))."\t".
	  'new'."\t".
	  $img."\t".
	  $peso.' kg'."\t".
	  $categoria."\t".
	  $products['products_quantity']."\t".
	  $disponibilidad."\n";
	}
			
echo 'id'."\t".'mpn'."\t".'title'."\t".'description'."\t".'link'."\t".'price'."\t".'manufacturer'."\t".'brand'."\t".'condition'."\t".'image link'."\t".'weight'."\t".'product type'."\t".'quantity'."\t".'availability'."\n".$lineafeed; ?>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); 
function limpiar($s) {
$s = ereg_replace("\*","",$s); 
$s = ereg_replace("\"","",$s);
return $s;
}
function limpiar_precio($s) {
$s = ereg_replace(",",".",$s);
$s = ereg_replace("€","",$s);
$s = ereg_replace("&euro;","",$s);
return $s;
}
?>