function process($file)
{
@xtc_set_time_limit(0);
require DIR_FS_CATALOG . DIR_WS_CLASSES . 'xtcPrice.php';
$xtPrice = new xtcPrice($_POST['currencies'], $_POST['status']);
//$schema = 'Produktbezeichnung;Beschreibung;Preis;Url;Bild;Währung;Kategorie;Gültig bis;Gültig ab;FSK;Typ;Produkt ID;Hersteller;Bestellnummer;Suchbegriffe;Preistyp' . "\n";
$export_query = xtc_db_query("SELECT\n p.products_id,\n pd.products_name,\n pd.products_description,\n p.products_model,\n p.products_image,\n p.products_price,\n p.products_status,\n p.products_date_available,\n p.products_shippingtime,\n p.products_discount_allowed,\n pd.products_meta_keywords,\n p.products_tax_class_id,\n p.products_date_added,\n m.manufacturers_name\n FROM\n " . TABLE_PRODUCTS . " p LEFT JOIN\n " . TABLE_MANUFACTURERS . " m\n ON p.manufacturers_id = m.manufacturers_id LEFT JOIN\n " . TABLE_PRODUCTS_DESCRIPTION . " pd\n ON p.products_id = pd.products_id AND\n pd.language_id = '" . $_SESSION['languages_id'] . "' LEFT JOIN\n " . TABLE_SPECIALS . " s\n ON p.products_id = s.products_id\n WHERE\n p.products_status = 1\n ORDER BY\n p.products_date_added DESC,\n pd.products_name");
while ($products = xtc_db_fetch_array($export_query)) {
$products_price = $xtPrice->xtcGetPrice($products['products_id'], $format = false, 1, $products['products_tax_class_id'], '');
// remove trash
$products_description = strip_tags($products['products_description']);
$products_description = substr($products_description, 0, 1000) . '..';
$products_description = str_replace(";", ", ", $products_description);
$products_description = str_replace("'", ", ", $products_description);
$products_description = str_replace("\n", " ", $products_description);
$products_description = str_replace("\r", " ", $products_description);
$products_description = str_replace("\t", " ", $products_description);
$products_description = str_replace("\v", " ", $products_description);
$products_description = str_replace("",", " \"", $products_description);
$products_description = str_replace("&qout,", " \"", $products_description);
// get product categorie
$categorie_query = xtc_db_query("SELECT\n categories_id\n FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "\n WHERE products_id='" . $products['products_id'] . "'");
while ($categorie_data = xtc_db_fetch_array($categorie_query)) {
$categories = $categorie_data['categories_id'];
}
$categorie_query = xtc_db_query("SELECT\n categories_name\n FROM " . TABLE_CATEGORIES_DESCRIPTION . "\n WHERE categories_id='" . $categories . "'\n and language_id='" . $_SESSION['languages_id'] . "'");
$categorie_data = xtc_db_fetch_array($categorie_query);
//-- SNAKELAB ----//
//$cat = $this->buildCAT($categories);
require_once DIR_FS_INC . 'xtc_href_link_from_admin.inc.php';
$link = xtc_href_link_from_admin('product_info.php', 'products_id=' . $products['products_id']);
preg_match("/\\?/", $link) ? $link .= '&' : ($link .= '?');
$link .= 'referer=' . $this->code;
!empty($_POST['campaign']) ? $link .= '&' . $_POST['campaign'] : false;
//-- SNAKELAB ----//
//create content
$schema .= $products['products_name'] . ';' . $products_description . ';' . number_format($products_price, 2, '.', '') . ';' . $link . ';' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG_THUMBNAIL_IMAGES . $products['products_image'] . ';' . $_POST['currencies'] . ';' . $categorie_data['categories_name'] . ';' . ';' . xtc_date_short($products['products_date_available']) . ';' . ';' . ';' . $products['products_model'] . ';' . $products['manufacturers_name'] . ';' . $products['products_model'] . ';' . $products['products_meta_keywords'] . ';' . '0' . "\n";
}
// create File
$fp = fopen(DIR_FS_DOCUMENT_ROOT . 'export/' . $file, "w+");
fputs($fp, $schema);
fclose($fp);
switch ($_POST['export']) {
case 'yes':
// send File to Browser
$extension = substr($file, -3);
$fp = fopen(DIR_FS_DOCUMENT_ROOT . 'export/' . $file, "rb");
$buffer = fread($fp, filesize(DIR_FS_DOCUMENT_ROOT . 'export/' . $file));
fclose($fp);
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' . $file);
echo $buffer;
exit;
break;
}
}
function process($file)
{
@xtc_set_time_limit(0);
require DIR_FS_CATALOG . DIR_WS_CLASSES . 'xtcPrice.php';
$xtPrice = new xtcPrice($_POST['currencies'], $_POST['status']);
$schema = 'Artikelnummer|Produktbezeichnung|Produktbeschreibung|Preis inkl. Mwst.|URL|Produktfoto' . "\n";
$export_query = xtc_db_query("SELECT\n p.products_id,\n pd.products_name,\n pd.products_description,\n p.products_model,\n p.products_image,\n p.products_shippingtime,\n p.products_price,\n p.products_status,\n p.products_discount_allowed,\n p.products_tax_class_id,\n p.products_date_added,\n m.manufacturers_name\n FROM\n " . TABLE_PRODUCTS . " p LEFT JOIN\n " . TABLE_MANUFACTURERS . " m\n ON p.manufacturers_id = m.manufacturers_id LEFT JOIN\n " . TABLE_PRODUCTS_DESCRIPTION . " pd\n ON p.products_id = pd.products_id AND\n pd.language_id = '" . $_SESSION['languages_id'] . "' LEFT JOIN\n " . TABLE_SPECIALS . " s\n ON p.products_id = s.products_id\n WHERE\n p.products_status = 1\n ORDER BY\n p.products_date_added DESC,\n pd.products_name");
while ($products = xtc_db_fetch_array($export_query)) {
$products_price = $xtPrice->xtcGetPrice($products['products_id'], $format = false, 1, $products['products_tax_class_id'], '');
// remove trash
$products_description = $products['products_description'];
$products_description = str_replace("\n", " ", $products_description);
$products_description = str_replace("<BR>", " ", $products_description);
$products_description = str_replace("<br>", " ", $products_description);
$products_description = str_replace("<br />", " ", $products_description);
$products_description = str_replace("\r", " ", $products_description);
$products_description = strip_tags($products_description);
$products_description = str_replace('|', ' ', $products_description);
$products_description = substr($products_description, 0, 1000) . " ... ";
//-- SNAKELAB ----//
require_once DIR_FS_INC . 'xtc_href_link_from_admin.inc.php';
$link = xtc_href_link_from_admin('product_info.php', 'products_id=' . $products['products_id']);
preg_match("/\\?/", $link) ? $link .= '&' : ($link .= '?');
$link .= 'referer=' . $this->code;
!empty($_POST['campaign']) ? $link .= '&' . $_POST['campaign'] : false;
//-- SNAKELAB ----//
//create content
$schema .= $products['products_model'] . '|' . $products['products_name'] . '|' . $products_description . '|' . number_format($products_price, 2, '.', '') . '|' . $link . '|' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG_THUMBNAIL_IMAGES . $products['products_image'] . "\n";
}
// create File
$fp = fopen(DIR_FS_DOCUMENT_ROOT . 'export/' . $file, "w+");
fputs($fp, $schema);
fclose($fp);
switch ($_POST['export']) {
case 'yes':
// send File to Browser
$extension = substr($file, -3);
$fp = fopen(DIR_FS_DOCUMENT_ROOT . 'export/' . $file, "rb");
$buffer = fread($fp, filesize(DIR_FS_DOCUMENT_ROOT . 'export/' . $file));
fclose($fp);
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' . $file);
echo $buffer;
exit;
break;
}
}
function process($file)
{
@xtc_set_time_limit(0);
require DIR_FS_CATALOG . DIR_WS_CLASSES . 'xtcPrice.php';
$xtPrice = new xtcPrice($_POST['currencies'], $_POST['status']);
$schema = '#country=de' . "\n" . '#type=basic' . "\n" . '#currency=' . $_POST['currencies'] . "\n";
$schema .= 'url' . "\t" . 'title' . "\t" . 'description' . "\t" . 'price' . "\t" . 'offerid' . "\t" . 'category' . "\t" . 'image' . "\t" . 'availability' . "\t" . 'deliverycost' . "\n";
$export_query = xtc_db_query("SELECT\n p.products_id,\n pd.products_name,\n pd.products_description,\n p.products_model,\n p.products_shippingtime,\n p.products_image,\n p.products_price,\n p.products_status,\n p.products_discount_allowed,\n p.products_tax_class_id,\n p.products_date_added,\n m.manufacturers_name\n FROM\n " . TABLE_PRODUCTS . " p LEFT JOIN\n " . TABLE_MANUFACTURERS . " m\n ON p.manufacturers_id = m.manufacturers_id LEFT JOIN\n " . TABLE_PRODUCTS_DESCRIPTION . " pd\n ON p.products_id = pd.products_id AND\n pd.language_id = '" . $_SESSION['languages_id'] . "' LEFT JOIN\n " . TABLE_SPECIALS . " s\n ON p.products_id = s.products_id\n WHERE\n p.products_status = 1\n ORDER BY\n p.products_date_added DESC,\n pd.products_name");
while ($products = xtc_db_fetch_array($export_query)) {
$products_price = $xtPrice->xtcGetPrice($products['products_id'], $format = false, 1, $products['products_tax_class_id'], '');
// remove trash
$products_description = strip_tags($products['products_description']);
$products_description = str_replace(";", ", ", $products_description);
$products_description = str_replace("'", ", ", $products_description);
$products_description = str_replace("\n", " ", $products_description);
$products_description = str_replace("\r", " ", $products_description);
$products_description = str_replace("\t", " ", $products_description);
$products_description = str_replace("\v", " ", $products_description);
$products_description = str_replace("",", " \"", $products_description);
$products_description = str_replace("&qout,", " \"", $products_description);
$length = 160;
if ($_POST['account'] != 'normal') {
$length = 400;
}
$products_description = substr($products_description, 0, $length - 4) . '...';
// get product categorie
$categorie_query = xtc_db_query("SELECT\n categories_id\n FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "\n WHERE products_id='" . $products['products_id'] . "'");
while ($categorie_data = xtc_db_fetch_array($categorie_query)) {
$categories = $categorie_data['categories_id'];
}
$categorie_query = xtc_db_query("SELECT\n categories_name\n FROM " . TABLE_CATEGORIES_DESCRIPTION . "\n WHERE categories_id='" . $categories . "'\n and language_id='" . $_SESSION['languages_id'] . "'");
$categorie_data = xtc_db_fetch_array($categorie_query);
//create content
//create content
if ($products['products_image'] == '') {
$kelkoo_image = "";
} else {
$kelkoo_image = HTTP_CATALOG_SERVER . DIR_WS_CATALOG_THUMBNAIL_IMAGES . $products['products_image'];
}
//-- SNAKELAB ----//
require_once DIR_FS_INC . 'xtc_href_link_from_admin.inc.php';
$link = xtc_href_link_from_admin('product_info.php', 'products_id=' . $products['products_id']);
preg_match("/\\?/", $link) ? $link .= '&' : ($link .= '?');
$link .= 'referer=' . $this->code;
!empty($_POST['campaign']) ? $link .= '&' . $_POST['campaign'] : false;
//-- SNAKELAB ----//
$schema .= $link . "\t" . $products['products_name'] . "\t" . $products_description . "\t" . number_format($products_price, 2, '.', '') . "\t" . $products['products_id'] . "\t" . $categorie_data['categories_name'] . "\t" . $kelkoo_image . "\t" . '001' . "\t" . 'EUR 4,00' . "\n";
}
// create File
$fp = fopen(DIR_FS_DOCUMENT_ROOT . 'export/' . $file, "w+");
fputs($fp, $schema);
fclose($fp);
switch ($_POST['export']) {
case 'yes':
// send File to Browser
$extension = substr($file, -3);
$fp = fopen(DIR_FS_DOCUMENT_ROOT . 'export/' . $file, "rb");
$buffer = fread($fp, filesize(DIR_FS_DOCUMENT_ROOT . 'export/' . $file));
fclose($fp);
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' . $file);
echo $buffer;
exit;
break;
}
}
