Exportmodul preissuchmaschine.php anpassen

[hamotec-online]

Hallo, ich habe meinen Shop bei preissuchmaschine.de angemeldet und Ihnen auch die preissuchmaschine.csv zur Verfügung gestellt.

Nun habe ich eine Mail bekommen, das 2 Spalten fehlen: Vorkasse, Nachnahme.

Wie kann ich diese Spalten ins Modul mit einbauen ?

<?php

/* -----------------------------------------------------------------------------------------

   $Id: preissuchmaschine.php 1188 2005-08-28 14:24:34Z matthias $


   XT-Commerce - community made shopping

   http://www.xt-commerce.com


   Copyright (c) 2003 XT-Commerce

   -----------------------------------------------------------------------------------------

   based on: 

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

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

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


   Released under the GNU General Public License 

   ---------------------------------------------------------------------------------------*/

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


define('MODULE_PREISSUCHMASCHINE_TEXT_DESCRIPTION', 'Export - Preissuchmaschine.de (; getrennt)<br><b>Format:</b><br>Bezeichnung;Artikelnummer;Preis; Produktbeschreibung;Lieferstatus;Produktlink; FotoLink');

define('MODULE_PREISSUCHMASCHINE_TEXT_TITLE', 'Preissuchmaschine.de - CSV');

define('MODULE_PREISSUCHMASCHINE_FILE_TITLE' , '<hr noshade>Dateiname');

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

define('MODULE_PREISSUCHMASCHINE_STATUS_DESC','Modulstatus');

define('MODULE_PREISSUCHMASCHINE_STATUS_TITLE','Status');

define('MODULE_PREISSUCHMASCHINE_CURRENCY_TITLE','Währung');

define('MODULE_PREISSUCHMASCHINE_CURRENCY_DESC','Welche Währung soll exportiert werden?');

define('EXPORT_YES','Nur Herunterladen');

define('EXPORT_NO','Am Server Speichern');

define('CURRENCY','<hr noshade><b>Währung:</b>');

define('CURRENCY_DESC','Währung in der Exportdatei');

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

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

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

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

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

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

// include needed functions



  class preissuchmaschine {

    var $code, $title, $description, $enabled;



    function preissuchmaschine() {

      global $order;


      $this->code = 'preissuchmaschine';

      $this->title = MODULE_PREISSUCHMASCHINE_TEXT_TITLE;

      $this->description = MODULE_PREISSUCHMASCHINE_TEXT_DESCRIPTION;

      $this->sort_order = MODULE_PREISSUCHMASCHINE_SORT_ORDER;

      $this->enabled = ((MODULE_PREISSUCHMASCHINE_STATUS == 'True') ? true : false);


    }



    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 = 'Bezeichnung;Artikelnummer;Preis;Produktbeschreibung;Lieferstatus;Produktlink;FotoLink' . "\n";

        $export_query =xtc_db_query("SELECT

                             p.products_id,

                             pd.products_name,

                             pd.products_description,

                             p.products_model,

                             p.products_shippingtime,

                             p.products_image,

                             p.products_price,

                             p.products_status,

                             p.products_discount_allowed,

                             p.products_tax_class_id,

                             IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price,

                             p.products_date_added,

                             m.manufacturers_name

                         FROM

                             " . TABLE_PRODUCTS . " p LEFT JOIN

                             " . TABLE_MANUFACTURERS . " m

                           ON p.manufacturers_id = m.manufacturers_id LEFT JOIN

                             " . TABLE_PRODUCTS_DESCRIPTION . " pd

                           ON p.products_id = pd.products_id AND

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

                             " . TABLE_SPECIALS . " s

                           ON p.products_id = s.products_id

                         WHERE

                           p.products_status = 1

                         ORDER BY

                            p.products_date_added DESC,

                            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, 197) . '..';

             $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("&quot,"," \"",$products_description);

            $products_description = str_replace("&qout,"," \"",$products_description);


            //create content

            $schema .= $products['products_name'] .'-'. $products['manufacturers_name'] .';' .

                       $products['products_model'] . ';' .

                       number_format($products_price,2,',','.'). ';' .

                       $products_description .';'.

                       xtc_get_shipping_status_name($products['products_shippingtime']). ';' .

                       HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php?'.$_POST['campaign'].xtc_product_link($products['products_id'], $products['products_name']) . ';' .

                       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 display() {


    $customers_statuses_array = xtc_get_customers_statuses();


    // build Currency Select

    $curr='';

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

    while ($currencies_data=xtc_db_fetch_array($currencies)) {

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

    }


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

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

	while ($campaign = xtc_db_fetch_array($campaign_query)) {

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

	}


    return array('text' =>  EXPORT_STATUS_TYPE.'<br>'.

                          	EXPORT_STATUS.'<br>'.

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

                            CURRENCY.'<br>'.

                            CURRENCY_DESC.'<br>'.

                            $curr.

                            CAMPAIGNS.'<br>'.

                            CAMPAIGNS_DESC.'<br>'.

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

                            EXPORT_TYPE.'<br>'.

                            EXPORT.'<br>'.

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

                            xtc_draw_radio_field('export', 'yes',true).EXPORT_YES.'<br><br>' . xtc_button(BUTTON_EXPORT) .

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



    }


    function check() {

      if (!isset($this->_check)) {

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

        $this->_check = xtc_db_num_rows($check_query);

      }

      return $this->_check;

    }


    function install() {

      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_PREISSUCHMASCHINE_FILE', 'preissuchmaschine.csv',  '6', '1', '', now())");

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

}


    function remove() {

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

    }


    function keys() {

      return array('MODULE_PREISSUCHMASCHINE_STATUS','MODULE_PREISSUCHMASCHINE_FILE');

    }


  }

?>[/PHP]