Konspekt · Biznes jarayonlar
Obuna to'lovlari
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
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_apiMermaid: 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 312D2
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
@endumlPlantUML: 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
@endumlXulosa
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'rsatkich | Boshida | Oxirida |
|---|---|---|
| Ikki marta yechish | 0/kun | 0/kun |
| To'lanmagan fakturalar | 0 $ | 4 700 $ |
| Raddan keyin tiklangan | 0% | 71% |
| Majburiy ketish | 0% | 1% |
Qadamlar
- Holat Obuna = tarif + hisob davri
Mijoz oyiga $20.00 lik Basic tarifni tanlaydi.
- Holat Har tun job muddati kelganini yangilaydi
Soat 02:00 UTC da billing job davri tugagan har faol obunani tanlaydi.
- Muammo Job'ning ikki nusxasi o'sha mijozlardan pul yechadi
Deploy eski nusxa hali ishlayotganda billing xizmatining yangi nusxasini ishga tushirdi.
- Yechim Har fakturaga lease, har yechishga idempotency kaliti
Worker muddati kelgan fakturalar to'plamini
FOR UPDATE SKIP LOCKEDbilan egallaydi valease_until = now() + 10 minyozadi. - Muammo Karta rad etildi
Har tun yangilanishlarning taxminan 4% i o'tmaydi.
- 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.
- Holat Davr o'rtasida yangilash: ishlatilmaganini qaytarish, yangisini yechish
16 noyabrda mijoz Basic ($20) dan Pro ($50) ga o'tadi.
- Holat Oy oxiri va vaqt mintaqalari
UTC+5 dagi mijoz 31 yanvarda o'z vaqti bilan yarim tunda obuna bo'ldi.
- 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.
- 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.
- 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.