mufassall

Konspekt · Biznes jarayonlar

Obuna to'lovlari

14 daq · O'rta · mufassall.dtwin.uz/uz/l/subscription-billing/

← Darsni ochish

Muammo

SaaS mahsulot oylik tariflar sotadi va har tun kartalardan pul yechadi. Job'ning ikki nusxasi bitta mijozdan ikki marta yechadi, kartalar rad etiladi, mijozlar oy o'rtasida tarifni almashtiradi, oylar uzunligi har xil, provayder esa natijani keyinroq webhook bilan aytadi. Har muammoning pulni to'g'ri va mijozni saqlab qoladigan aniq yechimi bor.

Nimani o'rganasiz

  • Obuna, tarif, hisob davri va har yechish ortidagi hisob-faktura qatori
  • Bir-birining ustiga tushgan billing yurishlari: hisob-faktura uchun idempotency kaliti va har qatorga lease
  • Rad etishdan keyingi dunning va davr o'rtasida tarif almashganda proratsiya
  • Oy oxiri va vaqt mintaqalari, provayder webhook'lari va davr oxirida bekor qilish
Yakuniy sahna

Diagramma kod sifatida

Darsdagi yakuniy sxemani matn ko'rinishida oling va Jira, GitLab, GitHub, Notion yoki hujjatga qo'ying: Mermaid u yerlarda o'zi chiziladi. D2 va PlantUML (Confluence, IntelliJ) uchun alohida variantlar bor.

Mermaid: sxema

flowchart LR
  n_customer(["Mijoz"])
  n_api["Billing API"]
  n_invoices[("Hisob-fakturalar")]
  n_job("Billing job")
  n_provider>"To'lov provayderi"]
  n_job2("Billing job #35;2")
  n_mailer>"Email xizmati"]
  n_customer --> n_api
  n_api --> n_invoices
  n_job --> n_invoices
  n_job -->|"chaqiruv"| n_provider
  n_job2 --> n_invoices
  n_job --> n_mailer
  n_provider -.->|"asinxron"| n_api

Mermaid: so'rovlar ketma-ketligi

sequenceDiagram
  participant n_api as Billing API
  participant n_invoices as Hisob-fakturalar
  participant n_job as Billing job
  participant n_job2 as Billing job #35;2
  participant n_provider as To'lov provayderi
  Note over n_api,n_invoices: Obuna = tarif + hisob davri
  n_api->>n_invoices: invoices: new row
  Note over n_job,n_invoices: Har tun job muddati kelganini yangilaydi
  n_job->>n_invoices: SELECT s.id, s.plan, s.current_period_end
  n_invoices-->>n_job: 18 412 rows
  Note over n_job2,n_provider: Job'ning ikki nusxasi o'sha mijozlardan pul yechadi
  n_job2->>n_provider: 02:00 cron billing-run started on node-a
  Note over n_job,n_provider: Har fakturaga lease, har yechishga idempotency kaliti
  n_job->>n_provider: POST /v1/charges HTTP/1.1
  n_provider-->>n_job: HTTP/1.1 200 OK
  Note over n_job,n_provider: Karta rad etildi
  n_job->>n_provider: POST /v1/charges HTTP/1.1
  n_provider-->>n_job: HTTP/1.1 402 Payment Required
  Note over n_job,n_invoices: Dunning: kunlar davomida urinish, imtiyozli davr, keyin to'xtatish
  n_job->>n_invoices: dunning: row for in_7188
  Note over n_api,n_invoices: Davr o'rtasida yangilash: ishlatilmaganini qaytarish, yangisini yechish
  n_api->>n_invoices: upgrade sub_42 basic -#62; pro at 2026-11-16T00:00Z
  Note over n_job,n_invoices: Oy oxiri va vaqt mintaqalari
  n_job->>n_invoices: sub_77 anchor 2026-01-31T00:00 +05:00, anchor_day 31
  Note over n_provider,n_api: Provayder to'lovni keyinroq webhook bilan tasdiqlaydi
  n_provider->>n_api: POST /billing/webhooks HTTP/1.1
  n_api-->>n_provider: HTTP/1.1 200 OK
  Note over n_job,n_invoices: Davr oxirida bekor qilish yoki hozir, pul qaytarib
  n_job->>n_invoices: UPDATE subscriptions SET status = 'canceled'
  n_invoices-->>n_job: UPDATE 312

D2

direction: right

n_customer: "Mijoz" {
  shape: rectangle
}
n_api: "Billing API" {
  shape: rectangle
}
n_invoices: "Hisob-fakturalar" {
  shape: cylinder
}
n_job: "Billing job" {
  shape: rectangle
  style.multiple: true
}
n_provider: "To'lov provayderi" {
  shape: cloud
}
n_job2: "Billing job #2" {
  shape: rectangle
  style.multiple: true
}
n_mailer: "Email xizmati" {
  shape: cloud
}

n_customer -> n_api
n_api -> n_invoices
n_job -> n_invoices
n_job -> n_provider: "chaqiruv"
n_job2 -> n_invoices
n_job -> n_mailer
n_provider -> n_api: "asinxron" {
  style.stroke-dash: 3
}

PlantUML: so'rovlar ketma-ketligi

@startuml
participant "Billing API" as n_api
database "Hisob-fakturalar" as n_invoices
participant "Billing job" as n_job
participant "Billing job #2" as n_job2
boundary "To'lov provayderi" as n_provider
note over n_api, n_invoices : Obuna = tarif + hisob davri
n_api -> n_invoices : invoices: new row
note over n_job, n_invoices : Har tun job muddati kelganini yangilaydi
n_job -> n_invoices : SELECT s.id, s.plan, s.current_period_end
n_invoices --> n_job : 18 412 rows
note over n_job2, n_provider : Job'ning ikki nusxasi o'sha mijozlardan pul yechadi
n_job2 -> n_provider : [dublikat] 02:00 cron billing-run started on node-a
note over n_job, n_provider : Har fakturaga lease, har yechishga idempotency kaliti
n_job -> n_provider : POST /v1/charges HTTP/1.1
n_provider --> n_job : HTTP/1.1 200 OK
note over n_job, n_provider : Karta rad etildi
n_job -> n_provider : POST /v1/charges HTTP/1.1
n_provider --> n_job : HTTP/1.1 402 Payment Required
note over n_job, n_invoices : Dunning: kunlar davomida urinish, imtiyozli davr, keyin to'xtatish
n_job -> n_invoices : dunning: row for in_7188
note over n_api, n_invoices : Davr o'rtasida yangilash: ishlatilmaganini qaytarish, yangisini yechish
n_api -> n_invoices : upgrade sub_42 basic -> pro at 2026-11-16T00:00Z
note over n_job, n_invoices : Oy oxiri va vaqt mintaqalari
n_job -> n_invoices : sub_77 anchor 2026-01-31T00:00 +05:00, anchor_day 31
note over n_provider, n_api : Provayder to'lovni keyinroq webhook bilan tasdiqlaydi
n_provider ->> n_api : POST /billing/webhooks HTTP/1.1
n_api -->> n_provider : HTTP/1.1 200 OK
note over n_job, n_invoices : Davr oxirida bekor qilish yoki hozir, pul qaytarib
n_job -> n_invoices : UPDATE subscriptions SET status = 'canceled'
n_invoices --> n_job : UPDATE 312
@enduml

PlantUML: komponentlar

@startuml
left to right direction
agent "Mijoz" as n_customer
component "Billing API" as n_api
database "Hisob-fakturalar" as n_invoices
collections "Billing job" as n_job
cloud "To'lov provayderi" as n_provider
collections "Billing job #2" as n_job2
cloud "Email xizmati" as n_mailer
n_customer --> n_api
n_api --> n_invoices
n_job --> n_invoices
n_job --> n_provider : chaqiruv
n_job2 --> n_invoices
n_job --> n_mailer
n_provider ..> n_api : asinxron
@enduml

Xulosa

Takroriy to'lovlar uchun olti qoida.

1) Har yechish bitta yarim ochiq davr uchun bitta fakturaga tegishli. 2) Billing job ikki marta ishlaydi deb hisoblang: har fakturaga lease, har yechishga faktura va urinishdan tuzilgan idempotency kaliti. 3) Yumshoq raddan keyin dunning: kunlar davomida urinish, email, imtiyozli davr, keyin to'xtatish. 4) Tarif almashishini bitta yaxlitlash qoidasi bilan faktura qatorlari sifatida proratsiya qiling. 5) Tayanch kun va mijoz vaqt mintaqasini saqlang; vaqt nuqtalarini UTC da saqlang. 6) To'lovni imzolangan, dublikatsiz webhook'lar yakunlasin, osilib qolgan fakturalarni provayderdan so'rang va mijoz hozir demasa, davr oxirida bekor qiling.

Ko'rsatkichlar: boshida va oxirida

Ko'rsatkichBoshidaOxirida
Ikki marta yechish0/kun0/kun
To'lanmagan fakturalar0 $4 700 $
Raddan keyin tiklangan0%71%
Majburiy ketish0%1%

Qadamlar

  1. Holat Obuna = tarif + hisob davri

    Mijoz oyiga $20.00 lik Basic tarifni tanlaydi.

  2. Holat Har tun job muddati kelganini yangilaydi

    Soat 02:00 UTC da billing job davri tugagan har faol obunani tanlaydi.

  3. Muammo Job'ning ikki nusxasi o'sha mijozlardan pul yechadi

    Deploy eski nusxa hali ishlayotganda billing xizmatining yangi nusxasini ishga tushirdi.

  4. Yechim Har fakturaga lease, har yechishga idempotency kaliti

    Worker muddati kelgan fakturalar to'plamini FOR UPDATE SKIP LOCKED bilan egallaydi va lease_until = now() + 10 min yozadi.

  5. Muammo Karta rad etildi

    Har tun yangilanishlarning taxminan 4% i o'tmaydi.

  6. Yechim Dunning: kunlar davomida urinish, imtiyozli davr, keyin to'xtatish

    Har o'tmagan faktura dunning yozuvini oladi: 1, 3, 5 va 7-kunlarda qayta urinish, 02:00 da emas, maosh tushgan tushdan oldingi paytda.

  7. Holat Davr o'rtasida yangilash: ishlatilmaganini qaytarish, yangisini yechish

    16 noyabrda mijoz Basic ($20) dan Pro ($50) ga o'tadi.

  8. Holat Oy oxiri va vaqt mintaqalari

    UTC+5 dagi mijoz 31 yanvarda o'z vaqti bilan yarim tunda obuna bo'ldi.

  9. Yechim Provayder to'lovni keyinroq webhook bilan tasdiqlaydi

    Ba'zi yechishlar chaqiruv ichida tugamaydi: bank qo'shimcha tasdiq so'raydi yoki to'lovni keyinroq o'tkazadi.

  10. Yechim Davr oxirida bekor qilish yoki hozir, pul qaytarib

    Bekor qilgan mijozlarning ko'pi shu oy uchun allaqachon to'lagan, shuning uchun davr tugaguncha kirish saqlanadi.

  11. Xulosa Xulosa

    Takroriy to'lovlar uchun olti qoida.

Atamalar

Dunning
O'tmagan obuna to'lovini bir necha kun qayta urinish, mijozga xabar berish va imtiyozli davrdan keyin obunani to'xtatish.
Proratsiya
Davr o'rtasida tarif almashganda eski tarifning ishlatilmagan qismini qaytarish va yangisining qolgan qismini yechish.