Экспорт данных в Yandex Market (Яндекс Маркет). Проверено на Joomla 2.5 + JoomShopping 3.6.1 - страница 5 - Импорт-экспорт данных

$pdo->exec('SET NAMES utf8');

$pdo_attr = new PDO("mysql:host={$hostname};dbname={$dbName}", $username, $password);
	// Исправьте, если у вас другая кодировка в БД
	$pdo_attr->exec('SET NAMES utf8');

if (!in_array($row['product_id'],$product_log) && ($row['product_price']) && $row['product_price'] > 0) {

//attr
			$iattr=0;
			$query = "
			SELECT `value`.`name_ru-RU` as attr_name FROM `alrs_jshopping_attr_values` AS value, `alrs_jshopping_products_attr2` AS xref
            WHERE `xref`.`attr_id`=`value`.`attr_id` AND `xref`.`attr_value_id`=`value`.`value_id` AND `xref`.`product_id`=".$row['product_id'];
			$attr=' Размер ';
			$res_attr = $pdo_attr->query($query); 
			while ($row_attr= $res_attr->fetch(PDO::FETCH_ASSOC)) {
				if($iattr>0) $attr.=', ';
				$attr.=$row_attr['attr_name'];
				$iattr++;
			}
			if ($attr==' Размер ') $attr='';
			//attr

echo "<name>".$row['product_name']."</name>\n";

echo "<name>".$row['product_name'].$attr."</name>\n";

 for($i = 1; $i <= $extra_cnt; $i++) {
         $extra_select .= "{$tb_product}.extra_field_{$i},";
      }

foreach($extra_info as $key=>$value){
			$extra_select .= "{$tb_product}.extra_field_{$key},";	
		}

<?php
header ("Content-Type:text/xml");
// Пропишите относительный путь к 'configuration.php' (он находится в корне Joomla)
// Например: include '../configuration.php';
include '/home/s5928/public_html/site.ru/public_html/configuration.php';
$cfg = new JConfig();
 
//NAME - Короткое название магазина (название, которое выводится в списке найденных на Яндекс.Маркете товаров.
//Не должно содержать более 20 символов). Нельзя использовать слова, не имеющие отношения к
//наименованию магазина ("лучший", "дешевый"), указывать номер телефона и т.п. Название магазина,
//должно совпадать с фактическим названием магазина, которое публикуется на сайте. При несоблюдении
//данного требования наименование может быть изменено Яндексом самостоятельно без уведомления Клиента.
//ВНИМАНИЕ! Обязательно укажите в переменную, по какому пути у Вас расположена главная страница каталога JoomShopping, 
//точнее то что идет после адреса самого сайта http://mysite.ru/katalog, в данном случае, нужно указать переменной $js_main_page = "katalog";
$cfg_name = $cfg->fromname;
$js_main_page = "katalog";

$cfg_company = $cfg->sitename; //Полное наименование компании, владеющей магазином. Не публикуется, используется для внутренней идентификации.
$cfg_url = 'site.ru'; //URL-адрес главной страницы магазина без http://
$bid = '10'; // Ставка за клик (в центах)
$currency = 'RUR';
  
$hostname 				= $cfg->host;
$username 				= $cfg->user;
$password 				= $cfg->password;
$dbName 				= $cfg->db;

$category 				= $cfg->dbprefix."jshopping_categories";
$tb_product 				= $cfg->dbprefix."jshopping_products";
$tb_manufacturer			= $cfg->dbprefix."jshopping_manufacturers";
$tb_product_category_xref	= $cfg->dbprefix."jshopping_products_to_categories";

try { 
    $pdo = new PDO("mysql:host={$hostname};dbname={$dbName}", $username, $password);
	// Исправьте, если у вас другая кодировка в БД
	$pdo->exec('SET NAMES utf8');
	
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
	echo "<!DOCTYPE yml_catalog SYSTEM \"shops.dtd\">\n";
	echo "<yml_catalog date=\"";
	echo date('Y-m-d H:i');
	echo "\">\n";
	echo "<shop>\n";
	echo "<name>$cfg_name</name>\n";
	echo "<company>$cfg_company</company>\n";
	echo "<url>$cfg_url</url>\n";
	 
	// курсы валют, приравнены к курсу ЦБРФ
	echo "<currencies>\n";
	echo "<currency  id=\"RUR\" rate=\"1\"/>\n";
	echo "<currency  id=\"USD\" rate=\"CBRF\"/>\n";
	echo "<currency  id=\"EUR\" rate=\"CBRF\"/>\n";
	echo "</currencies>\n";
	 
	// Секция категорий
	echo "<categories>\n";
		$res = $pdo->query("SELECT * FROM $category"); 
		while ($row_cat= $res->fetch(PDO::FETCH_ASSOC)) {
			$cat_parent_id=$row_cat['category_parent_id'];
			$parent = ($cat_parent_id != 0)? " parentId=\"{$cat_parent_id}\"" : "";
			echo "<category id=\"{$row_cat['category_id']}\"{$parent}>{$row_cat['name_ru-RU']}</category>\n";
		}
		unset($res);
	echo"</categories>\n";
	 
	// Секция описания товаров
	echo"<offers>\n";
	
	$res = $pdo->query("SELECT id, `name_ru-RU` as name FROM {$cfg->dbprefix}jshopping_products_extra_fields"); 
	$extra_info = $res->fetchAll(PDO::FETCH_ASSOC);
	$extra_info = nomalizeArray($extra_info, 'name');
	

	$res = $pdo->query("SELECT `id`, `name_ru-RU` as exv_name FROM {$cfg->dbprefix}jshopping_products_extra_field_values");
	$extra_info_val = $res->fetchAll(PDO::FETCH_ASSOC);
	$extra_info_val = nomalizeArray($extra_info_val, 'exv_name');
	
	$extra_select = '';
	$extra_cnt = count($extra_info);
	if($extra_cnt != 0) {
		for($i = 1; $i <= $extra_cnt; $i++) {
			$extra_select .= "{$tb_product}.extra_field_{$i},";
		}
	}
	$query = "
SELECT
			{$extra_select}
			{$tb_product}.product_id,
			{$tb_product}.`name_ru-RU` as product_name,
			{$tb_manufacturer}.`name_ru-RU` as mf_name,
			{$tb_manufacturer}.`manufacturer_id`,
			{$tb_product_category_xref}.`category_id`,
			{$tb_product}.`product_price`, 
			{$tb_product}.`product_id` as product_sku,
			{$tb_product}.`product_quantity`,
			{$tb_product}.`product_full_image` as product_full_image,
			{$tb_product}.`short_description_ru-RU` as product_s_desc
		FROM
			{$tb_product}	
		LEFT JOIN {$tb_product_category_xref}
			ON {$tb_product}.product_id = {$tb_product_category_xref}.product_id
		LEFT JOIN {$tb_manufacturer}
			ON {$tb_product}.product_manufacturer_id = {$tb_manufacturer}.manufacturer_id

		WHERE {$tb_product}.product_publish='1'
		GROUP BY {$tb_product}.product_id
		";

	$product_log = Array();
	$res = $pdo->query($query); 
	while ($row= $res->fetch(PDO::FETCH_ASSOC)) {
		if (!in_array($row['product_id'],$product_log) && ($row['product_price']) && $row['product_price'] > 0) {	
			$product_log[] = $row['product_id'];
			$product_price = substr($row['product_price'], 0, -3);
			echo "\n<offer id=\"".$row['product_id']."\" available=\"true\" bid=\"$bid\">\n";
			echo "<url>http://$cfg_url/{$js_main_page}/{$row['cat_name']}/{$row['product_alias']}</url>\n";
			echo "<price>$product_price</price>\n";
			// Валюта в которой указаны Ваши цены
			echo "<currencyId>".$currency."</currencyId>\n";
			echo "<categoryId>".$row['category_id']."</categoryId>\n";
			if(!empty($row['product_full_image'])) {
				echo "<picture>http://$cfg_url/components/com_jshopping/files/img_products/{$row['product_full_image']}</picture>\n";
			}
			
			// Возможность доставки
			echo "<delivery>true</delivery> \n";
			echo "<name>".htmlspecialchars(strip_tags($row['product_name']))."</name>\n";
			echo "<description>".htmlspecialchars(strip_tags($row['product_s_desc']))."</description>\n";
			for($i = 1; $i <= $extra_cnt; $i++) {
				if(!empty($row['extra_field_'.$i])) {
				
				//var_dump($row['extra_field_'.$i]);
				echo "<param name=\"{$extra_info[$i]}\">".htmlspecialchars($extra_info_val[(int)$row['extra_field_'.$i]])."</param>\n";
				}
			}
			echo "</offer>\n";
		}
	}

	
	echo"</offers>\n";
	echo"</shop>\n";
	echo"</yml_catalog>\n";

} catch (Exception $e) { 
    echo $e->getMessage(); 
}


function nomalizeArray($arr, $val, $key = 'id') {
	$newArr = Array();
	foreach($arr as $k => $v) {
		$newArr[$v[$key]] = $v[$val];
	}
	return $newArr;
}
 
?>

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<yml_catalog date="2013-08-08 19:42">
<shop>
<name>apple-land.ru</name>
<company>Apple-land.ru</company>
<url>lisap-shop.ru</url>
<currencies>
<currency id="RUR" rate="1"/>
<currency id="USD" rate="CBRF"/>
<currency id="EUR" rate="CBRF"/>
</currencies>
<categories>
<category id="1" parentId="174">Товары раз/category>
<category id="2" parentId="171">Товары два</category>
<category id="3">Товары три</category>
<category id="4" parentId="172">Товары тетыре</category>
</categories>
<offers></offers>
</shop>
</yml_catalog>

$product_log = Array();
	$res = $pdo->query($query);

echo $query;

SELECT khc51_jshopping_products.product_id, khc51_jshopping_products.`name_ru-RU` as product_name, khc51_jshopping_manufacturers.`name_ru-RU` as mf_name, khc51_jshopping_manufacturers.`manufacturer_id`, khc51_jshopping_products_to_categories.`category_id`, khc51_jshopping_products.`product_price`, khc51_jshopping_products.`product_id` as product_sku, khc51_jshopping_products.`product_quantity`, khc51_jshopping_products.`product_full_image` as product_full_image, khc51_jshopping_products.`short_description_ru-RU` as product_s_desc FROM khc51_jshopping_products	 LEFT JOIN khc51_jshopping_products_to_categories ON khc51_jshopping_products.product_id = khc51_jshopping_products_to_categories.product_id LEFT JOIN khc51_jshopping_manufacturers ON khc51_jshopping_products.product_manufacturer_id = khc51_jshopping_manufacturers.manufacturer_id WHERE khc51_jshopping_products.product_publish='1' GROUP BY khc51_jshopping_products.product_id

if (!in_array($row['product_id'],$product_log) && ($row['product_price']) && $row['product_price'] > 0) {

echo "</offer>\n";

SELECT 
da8mz_jshopping_products.extra_field_1,
da8mz_jshopping_products.extra_field_2,
da8mz_jshopping_products.extra_field_3,
da8mz_jshopping_products.extra_field_4,
da8mz_jshopping_products.extra_field_5,
da8mz_jshopping_products.product_id,
da8mz_jshopping_products.`name_ru-RU` as product_name, 
da8mz_jshopping_products.`alias_ru-RU` as product_alias, 
da8mz_jshopping_manufacturers.`name_ru-RU` as mf_name, 
da8mz_jshopping_manufacturers.`manufacturer_id`, 
da8mz_jshopping_products.`product_price`,
da8mz_jshopping_products.`product_id` as product_sku, 
da8mz_jshopping_products.`product_quantity`, 
da8mz_jshopping_products.`product_full_image` as product_full_image,
da8mz_jshopping_products.`short_description_ru-RU` as product_s_desc, 
da8mz_jshopping_products_to_categories.`category_id`, 
da8mz_jshopping_categories.`alias_ru-RU` as cat_name FROM da8mz_jshopping_products LEFT JOIN da8mz_jshopping_products_to_categories ON da8mz_jshopping_products.product_id = da8mz_jshopping_products_to_categories.product_id LEFT JOIN da8mz_jshopping_categories ON da8mz_jshopping_products_to_categories.`category_id` = da8mz_jshopping_categories.category_id LEFT JOIN da8mz_jshopping_manufacturers ON da8mz_jshopping_products.product_manufacturer_id = da8mz_jshopping_manufacturers.manufacturer_id WHERE da8mz_jshopping_products.product_publish='1' GROUP BY da8mz_jshopping_products.product_id 

da8mz_jshopping_products.extra_field_1,da8mz_jshopping_products.extra_field_2

$js_main_page = "shop";

			$name = str_replace("&", "&", $row_cat['name_ru-RU']);
			echo "<category id=\"{$row_cat['category_id']}\"{$parent}>{$name}</category>\n";

$bid = '10'; // Ставка за клик (в центах)