Antwort #34 am: 18. August 2020, 16:37:53
Da fehlt die Relation zur
products_id des betroffenen Artikels.
Mache mal in der
/admin/includes/modules/order/skuOnPackingslip.phpunten in der
function order_data()aus dem
$query = xtc_db_query("
SELECT p.products_lagerort
FROM " . TABLE_ORDERS_PRODUCTS . " op
LEFT JOIN " . TABLE_PRODUCTS . " p ON op.products_id = p.products_id
WHERE op.orders_id = " . (int)$oID . "
");
das
$query = xtc_db_query("
SELECT p.products_lagerort
FROM " . TABLE_ORDERS_PRODUCTS . " op
LEFT JOIN " . TABLE_PRODUCTS . " p ON op.products_id = p.products_id
WHERE op.orders_id = " . (int)$oID . "
AND op.products_id = " . (int)$order_data_values['products_id'] . "
");
oder noch besser und performance-technisch schneller dass
$query = xtc_db_query("
SELECT products_lagerort
FROM " . TABLE_PRODUCTS . "
WHERE products_id = " . (int)$order_data_values['products_id'] . "
");
Gruß,
noRiddle