Payments

Marks a manual payment (payment_provider = MANUAL, status WAITING_CONFIRMATION) as CONFIRMED. Rolls up order.payment_status = PAID when every payment row on the order is now confirmed.

The Xendit side of the world does not need this — those rows are flipped to CONFIRMED automatically by the webhook.

Idempotent: calling twice on the same payment_id returns 200 both times — the second call is a no-op.

Side-effects, all in a single transaction:

1. Update ecommerce_order_payments → status='CONFIRMED', confirmed_at=NOW, confirmed_by=<your user id>, paid_at=NOW.
2. If every payment row on the order is now CONFIRMED → bump ecommerce_orders.payment_status='PAID'.
3. Insert ecommerce_order_history row with event_type='PAYMENT_CONFIRMED' and metadata {payment_id, payment_provider, amount}.