hjælp til følgende..

Hej,

Jeg har følgende jeg har lavet/blandet sammen, og har brug for hjælp.
Den skal danne en csv.output fil til integration med Summa Summarum kunde databasen.

Helt optimalt ville være en mulighed for at afgrænse via datoer, så man undgår dobbelt import af kunder.

Koden:

class obb_packages_test extends obb_packages {

    /**
    * Class constructor
    *
    * @param mixed XML or array
    */
    function obb_packages_test ($data = '<root></root>'){
        $this->_data = $data;
        $this->pckg_key = 'test';
        $this->charset = $this->_get_local('charset') ? $this->_get_local('charset') : 'iso-8859-1';
        $this->httpOutputFormat = 'csv';    // can be name of method in the package or any of the following 'direct', 'csv', 'tsv' or 'xml'
        parent::init();
       
        // Set formatting and standalone on XML output
        $this->_response->formatOutput = true;
        $this->_response->xmlStandalone = true;
        $sql = "SELECT * FROM " . TABLE_LANGUAGES;
        $result = tep_db_query($sql);
        $this->languages['id'] = array();
        while ($row = tep_db_fetch_array($result)) {
            $this->languages[$row['languages_id']] = array('title' => $row['name'], 'code' => $row['code'], 'name' => $row['directory']);
            $this->languages[$row['directory']] = array('title' => $row['name'], 'code' => $row['code'], 'id' => $row['languages_id']);
            $this->languages[$row['code']] = array('title' => $row['name'], 'name' => $row['directory'], 'id' => $row['languages_id']);
            $this->languages['id'][] = $row['languages_id'];
        }
    }

    /**
    * Export data into an array of rows with arrays of data
    */
    function exportDataCSV() {
        $this->httpOutputFormat = 'csv';    // can be name of method in the package or any of the following 'direct', 'csv', 'tsv' or 'xml'
        $result = $this->_sql_query("SELECT * FROM " . TABLE_CUSTOMERS);
        for ($c=0; $c<mysql_num_fields($result); $c++) {
            $fields[] = mysql_field_name($result, $c);
        }
        $this->_result[] = $fields;
        while($row = tep_db_fetch_array($result)){
            $this->_result[] = $row;
        }
    }

    /**
    * Export data into an array of rows with arrays of data
    */
    function exportDataTSV() {
        $this->httpOutputFormat = 'tsv';    // can be name of method in the package or any of the following 'direct', 'csv', 'tsv' or 'xml'
        $result = $this->_sql_query("SELECT * FROM " . TABLE_CUSTOMERS);
        for ($c=0; $c<mysql_num_fields($result); $c++) {
            $fields[] = mysql_field_name($result, $c);
        }
        $this->_result[] = $fields;
        while($row = tep_db_fetch_array($result)){
            $this->_result[] = $row;
        }
    }

    /**
    * XML export from database of customers
    */
    /**
    * Elements added for testing - the 02.03.2009 - KEC
    */
    function exportDataXML (){
        $this->httpOutputFormat = 'xml';    // can be name of method in the package or any of the following 'direct', 'csv', 'tsv' or 'xml'
        $this->_debugNode->appendChild($this->_createElement('function', 'showCustomers'));
        $result = $this->_sql_query("SELECT * FROM " . TABLE_CUSTOMERS);
        $user_query = tep_db_query('select c.*,ab.* from address_book ab, customers c where       
                  c.customers_id=ab.customers_id and c.customers_default_address_id=ab.address_book_id');
            while($row = tep_db_fetch_array($user_query)){
            $customer = $this->_createElementAttrs('customers','',array('id' => $row['customers_id']));
            $customer->appendChild($this->_createElement('firstname', $row['customers_firstname']));
            $customer->appendChild($this->_createElement('lastname', $row['customers_lastname']));
            $customer->appendChild($this->_createElement('street', $row['entry_street_address']));
            $customer->appendChild($this->_createElement('suburb', $row['entry_suburb']));
            $customer->appendChild($this->_createElement('postcode', $row['entry_postcode']));
            $customer->appendChild($this->_createElement('city', $row['entry_city']));
            $customer->appendChild($this->_createElement('company', $row['entry_company']));
            $customer->appendChild($this->_createElement('cvr', $row['entry_vat']));
            $customer->appendChild($this->_createElement('type', $row['entry_country_id']));
            $customer->appendChild($this->_createElement('email_address', $row['customers_email_address']));
            $customer->appendChild($this->_createElement('telephone', $row['customers_telephone']));
            $customer->appendChild($this->_createElement('fax', $row['customers_fax']));
            $this->_responseRoot->appendChild($customer);
        }
    }
   
    function csv_transform () {
        $xsl_file = DIR_FS_PCKG . $this->pckg_key . '/emails.xsl';
        $this->exportDataXML();
        $content = $this->xsl_transform($this->_getResponseXML(), $xsl_file);
        return $content;
    }
   
    function csv_transform2 () {
        $this->_result = $this->csv_transform();
    }
   
    function sendMeResult(){
        $content = $this->csv_transform();
        $to = $this->_get_local('email');
        if ($to){
            if($this->sendbyEmail($to, $content, 'Customers Addresses', 'addresses.csv')){
                return 'Addresses sent to ' . $to;
            }
            else return 'Failes to send email';
        }
        else return 'Please specify email';
    }
   
    function showCustomers() {
        $this->exportDataXML();
        return $this->_getResponseXML();
    }
}
?>