supersam/docs/sql
root a879ad01c3 fix: get_delivery_invitation_by_token returns full order composition with items
RPC was returning only top-level invoice numbers (nom) without the nested
product items inside orderList[].items[]. Now returns {name, quantity, items}
structure matching flattenOrderProducts() expectations in OrderCompositionPanel.

Before: orderItems = [{name: 'ТП-008590', quantity: '1'}]
After:  orderItems = [{name: 'ТП-008590', items: [{name: 'СФ Т\ЕА-28944', items: [{product_name, product_quantity, product_ed}]}]}]

Also includes stop words, delivery type, pickup code, payed_ship fields.
2026-06-23 05:12:00 +00:00
..
add-source-orders-to-order-items.sql feat: delivery page improvements and driver shipment workflow 2026-05-22 12:53:43 +03:00
order-groups-anon-n8n-insert-policy.sql feat(delivery): auto-create invitation links 2026-05-13 18:59:30 +03:00
order-groups-auto-delivery-link.sql fix(delivery): load links and schedule SMS 2026-05-13 18:59:30 +03:00
order-groups-driver-update-policy.sql fix: RLS-политика для водителя + SQL-миграция 2026-06-15 16:08:00 +00:00
order-groups-manual-delivery-choice.sql feat(delivery): auto-create invitation links 2026-05-13 18:59:30 +03:00
order-groups-n8n-insert-access.sql feat(delivery): auto-create invitation links 2026-05-13 18:59:30 +03:00
public-delivery-choice-rpc.sql fix: get_delivery_invitation_by_token returns full order composition with items 2026-06-23 05:12:00 +00:00
restore-rpc-original.sql feat: show order composition collapsed with product list from source_orders 2026-05-21 14:18:10 +03:00