Rychlé rozhraní – dobrá služba
sql pro prestashop
Contact id_order email phone firstname lastname city postcode address1 type product_weight psc original_shipping_price dobirka
SELECT
NULL AS Contact,
d.id_order,
g.email,
address.phone,
g.firstname,
g.lastname,
address.city,
address.postcode,
address.address1,
bal.type,
CASE
WHEN d.product_weight IS NULL OR d.product_weight = 0
THEN 0.2
ELSE d.product_weight
END AS product_weight,bal.psc,
cod.original_shipping_price,
CASE
WHEN cod.original_shipping_price IS NOT NULL
THEN o.total_paid
ELSE NULL
END AS dobirkaFROM ps_order_detail d
LEFT JOIN ps_orders o
ON d.id_order = o.id_order
LEFT JOIN ps_customer g
ON o.id_customer = g.id_customer
LEFT JOIN ps_group_lang gl
ON g.id_default_group = gl.id_group
AND gl.name LIKE ‘club%’
LEFT JOIN ps_order_state_lang os
ON o.current_state = os.id_order_state
LEFT JOIN ps_address address
ON o.id_address_delivery = address.id_address
LEFT JOIN ps_carrier carrier
ON o.id_carrier = carrier.id_carrier
LEFT JOIN ps_state statelocation
ON address.id_state = statelocation.id_state
LEFT JOIN ps_product oproduct
ON d.product_id = oproduct.id_product
LEFT JOIN ps_message me
ON o.id_order = me.id_order
LEFT JOIN ps_product_shop sp
ON oproduct.id_product = sp.id_product
LEFT JOIN ps_shaim_balikovna_data bal
ON o.id_cart = bal.id_cart
LEFT JOIN ps_shaim_cashondelivery cod
ON o.id_order = cod.id_order
WHERE os.id_lang = 1
GROUP BY d.id_order
ORDER BY d.id_order DESC
LIMIT 0,1;