Hier im Forum findet man eine order_export.php in der ein SQL statement ist, das ich um ein Feld erweitern möchte ...
Wie bekomme ich da nach das Feld Kundennummer rein? (Vorzugsweise zwischen "Bestelldatum" und "Name des Käufers")
SELECT orders.orders_id AS Bestellnummer,
orders.date_purchased AS Bestelldatum,
orders.customers_name AS 'Name des Käufers',
orders.customers_telephone AS Telefonnummer,
orders.customers_email_address AS 'E-Mail-Adresse',
CONCAT(orders.delivery_company,'\r\n',orders.delivery_name,'\r\n',orders.delivery_street_address,'\r\n',orders.delivery_country_iso_code_2,' ',orders.delivery_postcode,' ',orders.delivery_city) AS Versandadresse,
CONCAT(orders.billing_company,'\r\n',orders.billing_name,'\r\n',orders.billing_street_address,'\r\n',orders.billing_country_iso_code_2,' ',orders.billing_postcode,' ',orders.billing_city) AS Rechnungsadresse,
orders_status.orders_status_name AS STATUS,
format(orders_products.products_quantity,0) AS Anzahl,
orders_products.products_id AS 'Artikel-ID',
orders_products.products_model AS Artikelnummer,
orders_products.products_name AS Artikel,
(SELECT GROUP_CONCAT(DISTINCT CONCAT( products_options,' : ', products_options_values) ORDER BY products_options ASC SEPARATOR '\r\n') FROM orders_products_attributes WHERE orders_id=orders.orders_id AND orders_products_id=orders_products.orders_products_id GROUP BY orders_id) AS Attribute,
REPLACE(REPLACE(format(orders_products.products_price ,2),',',''),'.',',') AS Artikelpreis,
REPLACE(REPLACE(format((orders_products.products_quantity * orders_products.products_price),2),',',''),'.',',') AS 'Gesamtpreis',
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(orders.payment_method,'cod','Nachnahme'),'eustandardtransfer','Vorkasse'),'paypal','PayPal'),'pn_sofortueberweisung','SofortÜberweisung'),'billpay','Billpay') AS Zahlungsmethode,
REPLACE(REPLACE(total1.class ,'ot_shipping','Normalversand'),'ot_cod_fee','Nachnahme') AS Versandart,
REPLACE(REPLACE(format(total1.value , 2),',',''),'.',',') AS Versandkosten,
REPLACE(REPLACE(REPLACE(total2.class ,'ot_shipping','Normalversand'),'ot_cod_fee','Nachnahmegebühr'),'','Keine Nachnahme') AS `Nachnahmegebühr`,
REPLACE(REPLACE(format(total2.value,2),',',''),'.',',') AS Nachnahmewert
FROM orders_total total1
LEFT JOIN orders_total total2
ON total1.orders_id = total2.orders_id
AND total2.class = 'ot_cod_fee'
JOIN orders
ON orders.orders_id = total1.orders_id
JOIN orders_products
ON orders_products.orders_id = orders.orders_id
JOIN orders_status
ON orders.orders_status = orders_status.orders_status_id
WHERE total1.class = 'ot_shipping'
AND orders_status.language_id=".$_SESSION['languages_id']."
ORDER BY orders.orders_id ASC
Linkback: https://www.modified-shop.org/forum/index.php?topic=30114.0