Aantallen

Test1: we zijn er

SELECT location_id, location_name AS 'Locatie', SUM(Aantal_pakketten_gereserveerd) AS 'Aantal pakketten gereserveerd', SUM(Aantal_pakketten_opgehaald) AS 'Aantal pakketten opgehaald', datum, reservation_item_id FROM (SELECT ospos_stock_locations.location_id, ospos_stock_locations.location_name, TRIM(SUM(ospos_lekkernassuh_reservations.quantity_reserved))+0 AS 'Aantal_pakketten_gereserveerd', '' AS 'Aantal_pakketten_opgehaald', ospos_lekkernassuh_reservations.delivery_date AS 'datum', ospos_lekkernassuh_reservations.reservation_item_id AS 'reservation_item_id' FROM ospos_stock_locations JOIN ospos_lekkernassuh_reservations ON ospos_lekkernassuh_reservations.location_id = ospos_stock_locations.location_id WHERE ospos_lekkernassuh_reservations.reservation_item_id = 12345 AND ospos_lekkernassuh_reservations.delivery_date = :var_datum_aantal_bestellingen GROUP BY ospos_stock_locations.location_id UNION SELECT ospos_stock_locations.location_id, ospos_stock_locations.location_name, '' AS 'Aantal pakketten gereserveerd', TRIM(SUM(ospos_sales_items.quantity_purchased))+0 AS 'Aantal pakketten afgehaald', DATE(ospos_sales.sale_time) AS 'datum', '' AS 'reservation_item_id' FROM ospos_stock_locations JOIN ospos_sales_items ON ospos_sales_items.item_location = ospos_stock_locations.location_id JOIN ospos_lekkernassuh_reservation_options ON ospos_lekkernassuh_reservation_options.purchased_id = ospos_sales_items.item_id JOIN ospos_sales ON ospos_sales_items.sale_id = ospos_sales.sale_id WHERE ospos_lekkernassuh_reservation_options.reservation_id = '1' AND DATE(ospos_sales.sale_time) = :var_datum_aantal_bestellingen GROUP BY ospos_stock_locations.location_id) AS pakketten_besteld_en_afgehaald GROUP BY pakketten_besteld_en_afgehaald.location_id ORDER BY pakketten_besteld_en_afgehaald.location_id

DatumXXX: 2025-04-23