PageRenderTime 59ms CodeModel.GetById 26ms RepoModel.GetById 1ms app.codeStats 0ms

/admin/includes/modules/export/googlebase.php

https://github.com/tisoft/xtcmodified
PHP | 482 lines | 414 code | 32 blank | 36 comment | 122 complexity | 39bebc8b0c5adfaa88e65fba7b0fceee MD5 | raw file
Possible License(s): AGPL-1.0, LGPL-2.1, GPL-2.0 
    

  1. <?php
    2. 

  2. /* -----------------------------------------------------------------------------------------
    3. 

  3.    $Id$
    4. 

    5. 

  5.    xtcModified - community made shopping
    6. 

  6.    http://www.xtc-modified.org
    7. 

    8. 

  8.    Copyright (c) 2010 xtcModified
    9. 

  9.    -----------------------------------------------------------------------------------------
    10. 

  10.    based on:
    11. 

  11.    (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
    12. 

  12.    (c) 2002-2003 osCommerce(cod.php,v 1.28 2003/02/14); www.oscommerce.com
    13. 

  13.    (c) 2003 nextcommerce (invoice.php,v 1.6 2003/08/24); www.nextcommerce.org
    14. 

  14.    (c) 2005 (froogle.php, v 1188 2005/08/28); matthias - www.xt-commerce.com
    15. 

  15.    (c) 2006 xt-commerce; www.xt-commerce.com
    16. 

  16.    -----------------------------------------------------------------------------------------
    17. 

  17.    Erweiterung der googlebase.php (c)2009 by Hetfield - http://www.MerZ-IT-SerVice.de um folgende Funktionen:
    18. 

  18.    - Gewichts- oder preisabhängige Vesandkosten mit Berücksichtigung der Versandkostenfrei-Grenze
    19. 

  19.    - Beachtung des Mindermengenzuschlags
    20. 

  20.    - Zustand 'neu' fest hinterlegt
    21. 

  21.    - Anzeige Zahlungsarten
    22. 

  22.    - Anzeige Gewicht
    23. 

  23.    - Anzeige EAN
    24. 

  24.    - Auswahl der verschiedenen suchmaschinenfreundlichen URL für den Exportlink (Original/keine, Shopstat oder DirectURL)
    25. 

  25.    - Umlautproblematik und str_replace-Wahnsinn beseitigt
    26. 

    27. 

  27.    updated version by franky_n
    28. 

    29. 

  29.    Released under the GNU General Public License
    30. 

  30.    ---------------------------------------------------------------------------------------*/
    31. 

  31. defined( '_VALID_XTC' ) or die( 'Direct Access to this location is not allowed.' );
    32. 

  32. 

  33. define('MODULE_GOOGLEBASE_TEXT_TITLE', 'Google Base - TXT / XML<br/>Exportmodul f&uuml;r Google Base / inkl. Felder "Zustand" und "Versandkosten"');
    34. 

  34. define('MODULE_GOOGLEBASE_TEXT_DESCRIPTION', 'Export - Google Base (Tab getrennt)');
    35. 

  35. define('MODULE_GOOGLEBASE_FILE_TITLE' , '<hr noshade>Dateiname');
    36. 

  36. define('MODULE_GOOGLEBASE_FILE_DESC' , 'Geben Sie einen Dateinamen ein, falls die Exportdatei am Server gespeichert werden soll.<br />(Verzeichnis export/)');
    37. 

  37. define('MODULE_GOOGLEBASE_STATUS_TITLE','Status');
    38. 

  38. define('MODULE_GOOGLEBASE_STATUS_DESC','Modulstatus');
    39. 

  39. define('MODULE_GOOGLEBASE_CURRENCY_TITLE','W&auml;hrung');
    40. 

  40. define('MODULE_GOOGLEBASE_CURRENCY_DESC','Welche W&auml;hrung soll exportiert werden?');
    41. 

  41. define('MODULE_GOOGLEBASE_SHIPPING_COST_TITLE','<hr noshade><b>Versandkosten</b>');
    42. 

  42. define('MODULE_GOOGLEBASE_SHIPPING_COST_DESC','Die Versandkosten basieren auf dem Artikelpreis oder dem Artikelgewicht. Beispiel: 25:4.90,50:9.90,etc.. Bis 25 werden 4.90 verrechnet, dar&uuml;ber bis 50 werden 9.90 verrechnet, etc.');
    43. 

  43. define('MODULE_GOOGLEBASE_SHIPPING_ART_TITLE','<hr noshade><b>Versandkosten-Methode</b>');
    44. 

  44. define('MODULE_GOOGLEBASE_SHIPPING_ART_DESC','Die Versandkosten basieren auf dem Artikelpreis oder dem Artikelgewicht.');
    45. 

  45. define('MODULE_GOOGLEBASE_SUMAURL_TITLE','<hr noshade><b>Suchmaschinenfreundliche URL</b>');
    46. 

  46. define('MODULE_GOOGLEBASE_SUMAURL_DESC','W&auml;hlen Sie aus, ob und welche Erweiterung Sie f&uuml;r suchmaschinenfreundliche URL in Ihrem Shop nutzen');
    47. 

  47. define('MODULE_GOOGLEBASE_FORMAT_TITLE','Exportformat');
    48. 

  48. define('MODULE_GOOGLEBASE_FORMAT_DESC','Welches Format soll exportiert werden?');
    49. 

  49. define('EXPORT_YES','Nur Herunterladen');
    50. 

  50. define('EXPORT_NO','Am Server Speichern');
    51. 

  51. define('CURRENCY','<hr noshade><b>W&auml;hrung:</b>');
    52. 

  52. define('CURRENCY_DESC','W&auml;hrung in der Exportdatei');
    53. 

  53. define('EXPORT','Bitte den Sicherungsprozess AUF KEINEN FALL unterbrechen. Dieser kann einige Minuten in Anspruch nehmen.');
    54. 

  54. define('EXPORT_TYPE','<hr noshade><b>Speicherart:</b>');
    55. 

  55. define('EXPORT_STATUS_TYPE','<hr noshade><b>Kundengruppe:</b>');
    56. 

  56. define('EXPORT_STATUS','Bitte w&auml;hlen Sie die Kundengruppe, die Basis f&uuml;r den Exportierten Preis bildet. (Falls Sie keine Kundengruppenpreise haben, w&auml;hlen Sie <i>Gast</i>):</b>');
    57. 

  57. define('CAMPAIGNS','<hr noshade><b>Kampagnen:</b>');
    58. 

  58. define('CAMPAIGNS_DESC','Mit Kampagne zur Nachverfolgung verbinden.');
    59. 

  59. define('SHIPPING_COUNTRY','<hr noshade><b>Land (optional):</b>');
    60. 

  60. define('SHIPPING_COUNTRY_DESC','Das Land, in das der Artikel geliefert wird. Bitte geben Sie DE als Wert an. Google Base akzeptiert nur Versandkosten f&uuml;r Lieferungen innerhalb Deutschlands.<br />Hinweis: Falls kein Wert angegeben wird, nimmt Google Base an, dass sich die Versandkosten auf das Zielland des Artikels beziehen.');
    61. 

  61. define('DATE_FORMAT_EXPORT', '%d.%m.%Y');  // this is used for strftime()
    62. 

  62. 

  63. // include needed functions
    64. 

  64. 

  65. 

  66. class googlebase {
    67. 

  67.   var $code, $title, $description, $enabled;
    68. 

  68. 

  69.   function googlebase() {
    70. 

  70.     global $order;
    71. 

  71. 

  72.     $this->code = 'googlebase';
    73. 

  73.     $this->title = MODULE_GOOGLEBASE_TEXT_TITLE;
    74. 

  74.     $this->description = MODULE_GOOGLEBASE_TEXT_DESCRIPTION;
    75. 

  75.     $this->sort_order = MODULE_GOOGLEBASE_SORT_ORDER;
    76. 

  76.     $this->enabled = ((MODULE_GOOGLEBASE_STATUS == 'True') ? true : false);
    77. 

  77.     $this->CAT=array();
    78. 

  78.     $this->PARENT=array();
    79. 

  79.   }
    80. 

  80. 

  81.   function process($file = MODULE_GOOGLEBASE_FILE) {
    82. 

  82.     // Read Modules
    83. 

  83.     $module_type = 'payment';
    84. 

  84.     $module_directory = DIR_FS_CATALOG_MODULES . 'payment/';
    85. 

  85.     $module_file_extension = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], '.'));
    86. 

  86.     $directory_array = array();
    87. 

  87.     if ($dir = @dir($module_directory)) {
    88. 

  88.       while ($module_file = $dir->read()) {
    89. 

  89.         if (!is_dir($module_directory . $module_file)) {
    90. 

  90.           if (substr($module_file, strrpos($module_file, '.')) == $module_file_extension) {
    91. 

  91.             $directory_array[] = $module_file;
    92. 

  92.           }
    93. 

  93.         }
    94. 

  94.       }
    95. 

  95.       sort($directory_array);
    96. 

  96.       $dir->close();
    97. 

  97.     }
    98. 

  98. 

  99.     $installed_modules = array();
    100. 

  100.     $module_info = array();
    101. 

  101.     for ($i = 0, $n = sizeof($directory_array); $i < $n; $i++) {
    102. 

  102.       $module_file = $directory_array[$i];
    103. 

  103. 

  104.       include(DIR_FS_LANGUAGES . $_SESSION['language'] . '/modules/' . $module_type . '/' . $module_file);
    105. 

  105.       include($module_directory . $module_file);
    106. 

  106. 

  107.       $class = substr($module_file, 0, strrpos($module_file, '.'));
    108. 

  108.       if (xtc_class_exists($class)) {
    109. 

  109.         $module = new $class();
    110. 

  110.         $module_info[] = array($module->code => $module->title);
    111. 

  111.       }
    112. 

  112.     }
    113. 

  113.     @xtc_set_time_limit(0);
    114. 

  114.     require(DIR_FS_CATALOG.DIR_WS_CLASSES . 'xtcPrice.php');
    115. 

  115.     $xtPrice = new xtcPrice($_POST['currencies'],$_POST['status']);
    116. 

  116. 

  117.     if ($_POST['sumaurl'] == 'directurl') {
    118. 

  118.       require_once(DIR_FS_CATALOG.'inc/bluegate_seo.inc.php');
    119. 

  119.       $bluegateSeo = new BluegateSeo();
    120. 

  120.     }
    121. 

  121. 

  122.     $schema_txt_de = "beschreibung".chr(9)."id".chr(9)."link".chr(9)."preis".chr(9)."w".chr(228)."hrung".chr(9)."titel".chr(9)."zustand".chr(9)."bild_url".chr(9)."ean".chr(9)."gewicht".chr(9)."marke".chr(9)."versand".chr(9)."zahlungsmethode".chr(9)."zahlungsrichtlinien".chr(13);
    123. 

  123.     
    124. 

  124.     $schema_xml_de = '<?xml version="1.0" encoding="UTF-8"?>'."\n".
    125. 

  125.                      '<rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">'."\n".
    126. 

  126.                      "\t".'<channel>'."\n".
    127. 

  127.                      "\t"."\t".'<title>'.htmlspecialchars(TITLE).'</title>'."\n".
    128. 

  128.                      "\t"."\t".'<description>'.META_DESCRIPTION.'</description>'."\n".
    129. 

  129.                      "\t"."\t".'<link>'.HTTP_SERVER.'</link>'."\n";
    130. 

  130. 

  131.     if ($_POST['shippingcosts'] != MODULE_GOOGLEBASE_SHIPPING_COST) {
    132. 

  132.       xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['shippingcosts']) . "' where configuration_key = 'MODULE_GOOGLEBASE_SHIPPING_COST'");
    133. 

  133.     }
    134. 

  134.     $zahlungsmethode = '';
    135. 

  135.     if (defined('MODULE_PAYMENT_INSTALLED') && xtc_not_null(MODULE_PAYMENT_INSTALLED)) {
    136. 

  136.       $other_payments = '';
    137. 

  137.       $creditcard_modules = array('cc', 'moneybookers_cc', 'amoneybookers', 'uos_kreditkarte_modul', 'uos_transfer_modul', 'uos_utdirekt_kk_modul', 'worldpay', 'ipayment', 'iclear', 'paymentpartner_cc', 'wire_card_c3');
    138. 

  138.       $americanexpress_modules = array('cc', 'moneybookers_cc', 'amoneybookers', 'ipayment');
    139. 

  139.       $lastschrift_modules = array('banktransfer', 'uos_lastschrift_modul', 'uos_lastschrift_de_modul', 'uos_lastschrift_at_modul', 'uos_utdirekt_ls_modul', 'ipaymentelv', 'paymentpartner_dd');
    140. 

  140.       $ueberweisung_modules = array('moneyorder', 'sofortueberweisungvorkasse', 'eustandardtransfer', 'uos_vorkasse_modul', 'uos_utdirekt_vk_modul');
    141. 

  141.       $cash_modules = array('cash');
    142. 

  142.       $scheck_modules = array('moneyorder');
    143. 

  143.       $customers_status_query = xtc_db_query("SELECT customers_status_payment_unallowed FROM " . TABLE_CUSTOMERS_STATUS . " WHERE customers_status_id = '" . (int)$_POST['status'] . "' AND language_id = '" . (int)$_SESSION['languages_id'] . "'");
    144. 

  144.       $customers_status_value = xtc_db_fetch_array($customers_status_query);
    145. 

  145.       $installedpayments = explode(';', MODULE_PAYMENT_INSTALLED);
    146. 

  146.       $unallowed_payment_modules = explode(',', $customers_status_value['customers_status_payment_unallowed']);
    147. 

  147.       for ($i = 0, $n = sizeof($installedpayments); $i < $n; $i++) {
    148. 

  148.         $installedpayments[$i] = str_replace('.php','',$installedpayments[$i]);
    149. 

  149.         if (!in_array($installedpayments[$i], $unallowed_payment_modules)) {
    150. 

  150.           if (in_array($installedpayments[$i], $creditcard_modules)) { $cc = true; } else
    151. 

  151.           if (in_array($installedpayments[$i], $americanexpress_modules)) { $ae = true; } else 
    152. 

  152.           if (in_array($installedpayments[$i], $lastschrift_modules)) { $la = true; } else 
    153. 

  153.           if (in_array($installedpayments[$i], $ueberweisung_modules)) { $uw = true; } else 
    154. 

  154.           if (in_array($installedpayments[$i], $cash_modules)) { $ca = true; } else 
    155. 

  155.           if (in_array($installedpayments[$i], $scheck_modules)) { $sc = true; } else { 
    156. 

  156.             $number_module_info = (count($module_info)-1);
    157. 

  157.             foreach ($module_info as $module_key) {
    158. 

  158.               foreach ($module_key as $module_attr => $module_desc) {
    159. 

  159.                 if ($installedpayments[$i] == $module_attr) {
    160. 

  160.                   if ($number_module_info != $module_key) {
    161. 

  161.                     $other_payments .= $module_desc .', '; 
    162. 

  162.                   }
    163. 

  163.                 }
    164. 

  164.               }
    165. 

  165.             }
    166. 

  166.           }
    167. 

  167.         }
    168. 

  168.       }
    169. 

  169.       if ($cc == true) { $creditcard = 'Visa,MasterCard,'; } else { $creditcard = ''; }
    170. 

  170.       if ($ae == true) { $americanexpress = 'AmericanExpress,'; } else { $americanexpress = ''; }
    171. 

  171.       if ($la == true) { $lastschrift = 'Lastschrift,'; } else { $lastschrift = ''; }
    172. 

  172.       if ($uw == true) { $ueberweisung = chr(220).'berweisung,'; } else { $ueberweisung = ''; }
    173. 

  173.       if ($ca == true) { $cash = 'Barzahlung,'; } else { $cash = ''; }
    174. 

  174.       if ($sc == true) { $scheck = 'Scheck'; } else { $scheck = ''; }
    175. 

  175.       $zahlungsmethode = $creditcard.$americanexpress.$lastschrift.$ueberweisung.$cash.$scheck;
    176. 

  176.       if (substr($zahlungsmethode, -1) == ',') { $zahlungsmethode = substr($zahlungsmethode, 0, -1); }
    177. 

  177.       if (substr($other_payments, -2) == ', ') { $other_payments = substr($other_payments, 0, -2); }
    178. 

  178.       $zahlungsrichtlinie = 'Wir unterst&uuml;tzen neben den Zahlungsarten '.$zahlungsmethode.' auch noch folgende Zahlungsarten '.$other_payments;
    179. 

  179.     }
    180. 

  180. 

  181.     $export_query = xtc_db_query("SELECT
    182. 

  182.                                          p.products_id,
    183. 

  183.                                          pd.products_name,
    184. 

  184.                                          pd.products_description,
    185. 

  185.                                          p.products_model,
    186. 

  186.                                          p.products_ean,
    187. 

  187.                                          p.products_image,
    188. 

  188.                                          p.products_price,
    189. 

  189.                                          p.products_weight,
    190. 

  190.                                          p.products_tax_class_id,
    191. 

  191.                                          m.manufacturers_name
    192. 

  192.                                     FROM
    193. 

  193.                                       " . TABLE_PRODUCTS . " p LEFT JOIN
    194. 

  194.                                       " . TABLE_MANUFACTURERS . " m
    195. 

  195.                                     ON p.manufacturers_id = m.manufacturers_id LEFT JOIN
    196. 

  196.                                       " . TABLE_PRODUCTS_DESCRIPTION . " pd
    197. 

  197.                                     ON p.products_id = pd.products_id AND
    198. 

  198.                                       pd.language_id = '".$_SESSION['languages_id']."' LEFT JOIN
    199. 

  199.                                       " . TABLE_SPECIALS . " s
    200. 

  200.                                     ON p.products_id = s.products_id
    201. 

  201.                                     WHERE
    202. 

  202.                                       p.products_status = 1
    203. 

  203.                                     ORDER BY
    204. 

  204.                                       p.products_date_added DESC,
    205. 

  205.                                       pd.products_name");
    206. 

    207. 

  207.     while ($products = xtc_db_fetch_array($export_query)) {
    208. 

  208.       $products_price = $xtPrice->xtcGetPrice($products['products_id'], $format=false, 1, $products['products_tax_class_id'], '');
    209. 

  209.       $categorie_query=xtc_db_query("SELECT
    210. 

  210.                                             categories_id
    211. 

  211.                                             FROM ".TABLE_PRODUCTS_TO_CATEGORIES."
    212. 

  212.                                             WHERE products_id='".$products['products_id']."'");
    213. 

  213.       while ($categorie_data=xtc_db_fetch_array($categorie_query)) {
    214. 

  214.         $categories=$categorie_data['categories_id'];
    215. 

  215.       }
    216. 

  216. 

  217.       // remove trash
    218. 

  218.       $products_description = strip_tags($products['products_description']);         
    219. 

  219.       $products_description = html_entity_decode($products_description);
    220. 

  220.       $products_description = str_replace(";",", ",$products_description);
    221. 

  221.       $products_description = str_replace("'",", ",$products_description);
    222. 

  222.       $products_description = str_replace("\n"," ",$products_description);
    223. 

  223.       $products_description = str_replace("\r"," ",$products_description);
    224. 

  224.       $products_description = str_replace("\t"," ",$products_description);
    225. 

  225.       $products_description = str_replace("\v"," ",$products_description);
    226. 

  226.       $products_description = str_replace(chr(13)," ",$products_description);            
    227. 

  227.       $products_description = substr($products_description, 0, 65536);
    228. 

  228.       $products_name = strip_tags($products['products_name']);         
    229. 

  229.       $products_name = html_entity_decode($products_name);
    230. 

  230.       $products_name = str_replace(";",", ",$products_name);
    231. 

  231.       $products_name = str_replace("'",", ",$products_name);
    232. 

  232.       $products_name = str_replace("\n"," ",$products_name);
    233. 

  233.       $products_name = str_replace("\r"," ",$products_name);
    234. 

  234.       $products_name = str_replace("\t"," ",$products_name);
    235. 

  235.       $products_name = str_replace("\v"," ",$products_name);
    236. 

  236.       $products_name = str_replace(chr(13)," ",$products_name);
    237. 

  237.       $cat = $this->buildCAT($categories);
    238. 

  238. 

  239.       if ($products['products_image'] != ''){
    240. 

  240.         $image = HTTP_CATALOG_SERVER . DIR_WS_CATALOG_ORIGINAL_IMAGES .$products['products_image'];
    241. 

  241.       } else {
    242. 

  242.         $image = '';
    243. 

  243.       }
    244. 

  244.       if ($products['products_weight'] != '0.00'){
    245. 

  245.         $weight = number_format($products['products_weight'],2,'.','');
    246. 

  246.       } else {
    247. 

  247.         $weight = '';
    248. 

  248.       }
    249. 

  249.       $versand = '0.00';
    250. 

  250.       if ($products_price < MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER && MODULE_ORDER_TOTAL_LOWORDERFEE_STATUS == 'true') {
    251. 

  251.         if (MODULE_ORDER_TOTAL_LOWORDERFEE_DESTINATION == 'national' or MODULE_ORDER_TOTAL_LOWORDERFEE_DESTINATION == 'both') {
    252. 

  252.           $customers_tax_query = xtc_db_query("SELECT customers_status_show_price_tax, customers_status_add_tax_ot FROM " . TABLE_CUSTOMERS_STATUS . " WHERE customers_status_id = '" . (int)$_POST['status'] . "' AND language_id = '" . (int)$_SESSION['languages_id'] . "'");
    253. 

  253.           $customers_tax_value = xtc_db_fetch_array($customers_tax_query);
    254. 

  254.           $tax = xtc_get_tax_rate(MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS);
    255. 

  255.           if ($customers_tax_value['customers_status_show_price_tax'] == 1) {
    256. 

  256.             $low_order_fee = xtc_add_tax(MODULE_ORDER_TOTAL_LOWORDERFEE_FEE, $tax);
    257. 

  257.           }
    258. 

  258.           if ($customers_tax_value['customers_status_show_price_tax'] == 0 && $customers_tax_value['customers_status_add_tax_ot'] == 1) {
    259. 

  259.             $low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
    260. 

  260.           }
    261. 

  261.           if ($customers_tax_value['customers_status_show_price_tax'] == 0 && $customers_tax_value['customers_status_add_tax_ot'] != 1) {
    262. 

  262.             $low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
    263. 

  263.           }
    264. 

  264.           $versand = $versand + $low_order_fee;
    265. 

  265.         }
    266. 

  266.       }
    267. 

  267.       if ($products_price > MODULE_SHIPPING_FREEAMOUNT_AMOUNT && MODULE_SHIPPING_FREEAMOUNT_STATUS == 'True') {
    268. 

  268.         $versand = $versand;
    269. 

  269.       } else if ($products_price > MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER && MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING == 'true') {
    270. 

  270.         $versand = $versand;
    271. 

  271.       } else {
    272. 

  272.         $shipping = -1;
    273. 

  273.         $shippinglist = preg_split("/[:,]/" , $_POST['shippingcosts']); // Hetfield - 2009-08-18 - replaced deprecated function split with preg_split to be ready for PHP >= 5.3
    274. 

  274.         for ($i=0; $i<sizeof($shippinglist); $i+=2) {
    275. 

  275.           if ($_POST['shippingart'] == 'weight') {
    276. 

  276.             if ($products['products_weight'] <= $shippinglist[$i]) {
    277. 

  277.               $shipping = $shippinglist[$i+1];
    278. 

  278.               break;
    279. 

  279.             }
    280. 

  280.           } else if ($_POST['shippingart'] == 'price') {
    281. 

  281.             if ($products_price <= $shippinglist[$i]) {
    282. 

  282.               $shipping = $shippinglist[$i+1];
    283. 

  283.               break;
    284. 

  284.             }
    285. 

  285.           }
    286. 

  286.         }  
    287. 

  287.         if ($shipping == -1) {
    288. 

  288.           $shipping_cost = 0;
    289. 

  289.         } else {
    290. 

  290.           $shipping_cost = $shipping;
    291. 

  291.         }
    292. 

  292.         $versand = $versand + $shipping_cost;
    293. 

  293.       }
    294. 

  294.       if ($_POST['sumaurl'] == 'shopstat') {
    295. 

  295.         $cat = strip_tags($this->buildCAT($categories));
    296. 

  296.         require_once(DIR_FS_INC . 'xtc_href_link_from_admin.inc.php');
    297. 

  297.         $productURL = xtc_href_link_from_admin('product_info.php', xtc_product_link($products['products_id'], $products['products_name']), 'NONSSL', false);
    298. 

  298.         if (!empty($_POST['campaign'])) {
    299. 

  299.           $productURL .= '?'.$_POST['campaign'];
    300. 

  300.         }
    301. 

  301.       } else if ($_POST['sumaurl'] == 'directurl') {
    302. 

  302.         $productURL = $bluegateSeo->getProductLink(xtc_product_link($products['products_id'], $products['products_name']),$connection,$_SESSION['languages_id']);
    303. 

  303.         if ($_POST['campaign']<>'') {
    304. 

  304.           $productURL .= '?'.$_POST['campaign'];
    305. 

  305.         }
    306. 

  306.       } else if ($_POST['sumaurl'] == 'original') {
    307. 

  307.         $productURL = HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php?'.xtc_product_link($products['products_id'], $products['products_name']);
    308. 

  308.         if (!empty($_POST['campaign'])) {
    309. 

  309.           $productURL .= '&'.$_POST['campaign'];
    310. 

  310.         }
    311. 

  311.       }
    312. 

  312.       
    313. 

  313.       //create content
    314. 

  314.       $schema_txt_de .= $products_description."\t".
    315. 

  315.                         $products['products_id']."\t".
    316. 

  316.                         $productURL . "\t" .
    317. 

  317.                         number_format($products_price,2,'.','')."\t".
    318. 

  318.                         $_POST['currencies']."\t".
    319. 

  319.                         $products_name."\t".
    320. 

  320.                         "neu\t".
    321. 

  321.                         $image."\t" .
    322. 

  322.                         $products['products_ean']."\t".
    323. 

  323.                         $weight."\t".
    324. 

  324.                         $products['manufacturers_name']."\t".
    325. 

  325.                         $_POST['shipping_country'].":::".number_format($versand,2,'.','')."\t" .
    326. 

  326.                         $zahlungsmethode."\t".
    327. 

  327.                         $zahlungsrichtlinie."\n";
    328. 

  328. 

  329.       $schema_xml_de .= "\t"."\t".'<item>'."\n".
    330. 

  330.                         "\t"."\t"."\t".'<beschreibung>'.$products_description.'</beschreibung>'."\n".
    331. 

  331.                         "\t"."\t"."\t".'<g:id>'.$products['products_id'].'</g:id>'."\n".
    332. 

  332.                         "\t"."\t"."\t".'<link>'.str_replace('&', '&amp;', $productURL).'</link>'."\n".
    333. 

  333.                         "\t"."\t"."\t".'<g:preis>'.number_format($products_price,2,'.','').'</g:preis>'."\n".
    334. 

  334.                         "\t"."\t"."\t".'<g:währung>'.$_POST['currencies'].'</g:währung>'."\n".
    335. 

  335.                         "\t"."\t"."\t".'<titel>'.$products_name.'</titel>'."\n".
    336. 

  336.                         "\t"."\t"."\t".'<g:zustand>'.'neu'.'</g:zustand>'."\n".
    337. 

  337.                         "\t"."\t"."\t".'<g:bild_url>'.$image.'</g:bild_url>'."\n" .
    338. 

  338.                         "\t"."\t"."\t".'<g:ean>'.$products['products_ean'].'</g:ean>'."\n".
    339. 

  339.                         "\t"."\t"."\t".'<g:gewicht>'.$weight.'</g:gewicht>'."\n".
    340. 

  340.                         "\t"."\t"."\t".'<g:marke>'.$products['manufacturers_name'].'</g:marke>'."\n".
    341. 

  341.                         "\t"."\t"."\t".'<g:versand>'.$_POST['shipping_country'].':::'.number_format($versand,2,'.','').'</g:versand>'."\n" .
    342. 

  342.                         "\t"."\t"."\t".'<g:zahlungsmethode>'.$zahlungsmethode.'</g:zahlungsmethode>'."\n" .
    343. 

  343.                         "\t"."\t"."\t".'<g:payment_notes>'.$zahlungsrichtlinie.'</g:payment_notes>'."\n".
    344. 

  344.                         "\t"."\t".'</item>'."\n";
    345. 

  345.     }
    346. 

  346.     $schema_xml_de .= "\t".'</channel>'."\n".
    347. 

  347.                       '</rss>'."\n";
    348. 

  348. 

  349.     // create File
    350. 

  350.     $fp = fopen(DIR_FS_DOCUMENT_ROOT.'export/' . $file, "w+");
    351. 

  351. 

  352.     if (MODULE_GOOGLEBASE_FORMAT == 'TXT') {
    353. 

  353.       fputs($fp,$schema_txt_de);
    354. 

  354.     } else {
    355. 

  355.       fputs($fp,$schema_xml_de);
    356. 

  356.     }
    357. 

  357.     fclose($fp);
    358. 

  358. 

  359.     switch ($_POST['export']) {
    360. 

  360.       case 'yes':
    361. 

  361.         // send File to Browser
    362. 

  362.         $extension = substr($file, -3);
    363. 

  363.         $fp = fopen(DIR_FS_DOCUMENT_ROOT.'export/' . $file,"rb");
    364. 

  364.         $buffer = fread($fp, filesize(DIR_FS_DOCUMENT_ROOT.'export/' . $file));
    365. 

  365.         fclose($fp);
    366. 

  366.         header('Content-type: application/x-octet-stream; charset=iso-8859-15');
    367. 

  367.         header('Content-disposition: attachment; filename=' . $file);
    368. 

  368.         echo $buffer;
    369. 

  369.         exit;
    370. 

  370. 

  371.         break;
    372. 

  372.     }
    373. 

  373. 

  374.   }
    375. 

  375.     
    376. 

  376.   function buildCAT($catID) {
    377. 

  377.     if (isset($this->CAT[$catID])) {
    378. 

  378.       return  $this->CAT[$catID];
    379. 

  379.     } else {
    380. 

  380.       $cat=array();
    381. 

  381.       $tmpID=$catID;
    382. 

  382.       while ($this->getParent($catID)!=0 || $catID!=0) {
    383. 

  383.         $cat_select=xtc_db_query("SELECT categories_name FROM ".TABLE_CATEGORIES_DESCRIPTION." WHERE categories_id='".$catID."' and language_id='".$_SESSION['languages_id']."'");
    384. 

  384.         $cat_data=xtc_db_fetch_array($cat_select);
    385. 

  385.         $catID=$this->getParent($catID);
    386. 

  386.         $cat[]=$cat_data['categories_name'];
    387. 

  387.       }
    388. 

  388.       $catStr='';
    389. 

  389.       for ($i=count($cat);$i>0;$i--) {
    390. 

  390.         $catStr.=$cat[$i-1].' > ';
    391. 

  391.       }
    392. 

  392.       $this->CAT[$tmpID]=$catStr;
    393. 

  393.       return $this->CAT[$tmpID];
    394. 

  394.     }
    395. 

  395.   }
    396. 

  396.     
    397. 

  397.   function getParent($catID) {
    398. 

  398.     if (isset($this->PARENT[$catID])) {
    399. 

  399.       return $this->PARENT[$catID];
    400. 

  400.     } else {
    401. 

  401.       $parent_query=xtc_db_query("SELECT parent_id FROM ".TABLE_CATEGORIES." WHERE categories_id='".$catID."'");
    402. 

  402.       $parent_data=xtc_db_fetch_array($parent_query);
    403. 

  403.       $this->PARENT[$catID]=$parent_data['parent_id'];
    404. 

  404.       return  $parent_data['parent_id'];
    405. 

  405.     }
    406. 

  406.   }
    407. 

  407. 

  408.   function display() {
    409. 

  409.     $customers_statuses_array = xtc_get_customers_statuses();
    410. 

  410.     // build Currency Select
    411. 

  411.     $curr='';
    412. 

  412.     $currencies=xtc_db_query("SELECT code FROM ".TABLE_CURRENCIES);
    413. 

  413.     while ($currencies_data=xtc_db_fetch_array($currencies)) {
    414. 

  414.       $curr.=xtc_draw_radio_field('currencies', $currencies_data['code'],true).$currencies_data['code'].'<br />';
    415. 

  415.     }
    416. 

  416.     $campaign_array = array(array('id' => '', 'text' => TEXT_NONE));
    417. 

  417.     $campaign_query = xtc_db_query("select campaigns_name, campaigns_refID from ".TABLE_CAMPAIGNS." order by campaigns_id");
    418. 

  418.     while ($campaign = xtc_db_fetch_array($campaign_query)) {
    419. 

  419.       $campaign_array[] = array ('id' => 'refID='.$campaign['campaigns_refID'], 'text' => $campaign['campaigns_name'],);
    420. 

  420.     }
    421. 

  421.     $shipping_country_array = array(array('id' => '', 'text' => TEXT_NONE));
    422. 

  422.     $shipping_country_query = xtc_db_query("SELECT countries_iso_code_2 FROM ".TABLE_COUNTRIES." ORDER BY countries_iso_code_2");
    423. 

  423.     while ($shipping_country = xtc_db_fetch_array($shipping_country_query)) {
    424. 

  424.       $shipping_country_array[] = array('id' => strtoupper($shipping_country['countries_iso_code_2']), 'text' => strtoupper($shipping_country['countries_iso_code_2']),);
    425. 

  425.     }
    426. 

  426.     return array('text' =>  EXPORT_STATUS_TYPE.'<br />'.
    427. 

  427.                             EXPORT_STATUS.'<br />'.
    428. 

  428.                             xtc_draw_pull_down_menu('status',$customers_statuses_array, '1').'<br />'.
    429. 

  429.                             CURRENCY.'<br />'.
    430. 

  430.                             CURRENCY_DESC.'<br />'.
    431. 

  431.                             $curr.
    432. 

  432.                             '<b>'.MODULE_GOOGLEBASE_SHIPPING_COST_TITLE.'</b><br />'.
    433. 

  433.                             MODULE_GOOGLEBASE_SHIPPING_COST_DESC.'<br />'.
    434. 

  434.                             xtc_draw_input_field('shippingcosts',MODULE_GOOGLEBASE_SHIPPING_COST).'<br />'.
    435. 

  435.                             '<b>'.MODULE_GOOGLEBASE_SHIPPING_ART_TITLE.'</b><br />'.
    436. 

  436.                             MODULE_GOOGLEBASE_SHIPPING_ART_DESC.'<br />'.
    437. 

  437.                             xtc_draw_radio_field('shippingart', 'weight',true).'Versandksten nach Gewicht<br />'.
    438. 

  438.                             xtc_draw_radio_field('shippingart', 'price',false).'Versandkosten nach Preis<br />'.
    439. 

  439.                             SHIPPING_COUNTRY.'<br />'.
    440. 

  440.                             SHIPPING_COUNTRY_DESC.'<br />'.
    441. 

  441.                             xtc_draw_pull_down_menu('shipping_country',$shipping_country_array,'DE').'<br />'.
    442. 

  442.                             '<b>'.MODULE_GOOGLEBASE_SUMAURL_TITLE.'</b><br />'.
    443. 

  443.                             MODULE_GOOGLEBASE_SUMAURL_DESC.'<br />'.
    444. 

  444.                             xtc_draw_radio_field('sumaurl', 'original',true).'Originale bzw. keine<br />'.
    445. 

  445.                             xtc_draw_radio_field('sumaurl', 'shopstat',false).'Shopstat<br />'.
    446. 

  446.                             xtc_draw_radio_field('sumaurl', 'directurl',false).'DirectURL<br />'.
    447. 

  447.                             CAMPAIGNS.'<br />'.
    448. 

  448.                             CAMPAIGNS_DESC.'<br />'.
    449. 

  449.                             xtc_draw_pull_down_menu('campaign',$campaign_array).'<br />'.
    450. 

  450.                             EXPORT_TYPE.'<br />'.
    451. 

  451.                             EXPORT.'<br />'.
    452. 

  452.                             xtc_draw_radio_field('export', 'no',false).EXPORT_NO.'<br />'.
    453. 

  453.                             xtc_draw_radio_field('export', 'yes',true).EXPORT_YES.'<br />'.
    454. 

  454.                             '<br />' . xtc_button(BUTTON_EXPORT) .
    455. 

  455.                             xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=googlebase')));
    456. 

  456.   }
    457. 

  457. 

  458.   function check() {
    459. 

  459.     if (!isset($this->_check)) {
    460. 

  460.       $check_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_GOOGLEBASE_STATUS'");
    461. 

  461.       $this->_check = xtc_db_num_rows($check_query);
    462. 

  462.     }
    463. 

  463.     return $this->_check;
    464. 

  464.   }
    465. 

  465. 

  466.   function install() {
    467. 

  467.     xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_GOOGLEBASE_FILE', 'googlebase.txt', '6', '1', '', now())");
    468. 

  468.     xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_GOOGLEBASE_STATUS', 'True',  '6', '1', 'xtc_cfg_select_option(array(\'True\', \'False\'), ', now())");
    469. 

  469.     xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_GOOGLEBASE_SHIPPING_COST', '25:6.90,50:9.90,10000:0.00', '6', '1', '', '', now())");
    470. 

  470.     xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_GOOGLEBASE_FORMAT', 'TXT',  '6', '1', 'xtc_cfg_select_option(array(\'TXT\', \'XML\'), ', now())");
    471. 

  471.   }
    472. 

  472. 

  473.   function remove() {
    474. 

  474.     xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    475. 

  475.     xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_GOOGLEBASE_SHIPPING_COST'");
    476. 

  476.   }
    477. 

  477. 

  478.   function keys() {
    479. 

  479.     return array('MODULE_GOOGLEBASE_STATUS','MODULE_GOOGLEBASE_FORMAT','MODULE_GOOGLEBASE_FILE');
    480. 

  480.   }
    481. 

  481. }
    482. 

  482. ?>
    483.