تحلیل کارمزد درگاه‌های پرداخت

منطق فنی و پایگاه داده View: v_real_getway_commission

ویوی دیتابیس بر روی سرور اصلی PostgreSQL اکیپا با شرط رزروهای موفق (status = 2):

SELECT reservations.id,
    rooms.name,
    payments.terminal_id,
    payments.amount,
    CASE
        WHEN payments.terminal_id::text = 'ewano'::text THEN (payments.amount::numeric * 0.05)::bigint
        WHEN payments.terminal_id::text = 'snapp_pay'::text THEN (payments.amount::numeric * 0.08)::bigint
        WHEN payments.terminal_id::text = 'digipay'::text THEN (payments.amount::numeric * 0.14)::bigint
        ELSE NULL::bigint
    END AS gateway_commission
FROM reservations
LEFT JOIN payments ON reservations.id = payments.reservation_id
LEFT JOIN rooms ON reservations.room_id = rooms.id
WHERE reservations.status = 2 
  AND payments.terminal_id::text = ANY (ARRAY['ewano', 'snapp_pay', 'digipay']);