Konspekt · Biznes jarayonlar
To'lovlarni solishtirish
Muammo
Do'kon karta to'lovlarini provayderning javoblari va callback'laridan yozib boradi. Ularning bir qismi yo'qoladi, timeout bo'ladi yoki ikki marta keladi, shuning uchun hisob daftari va haqiqiy pul ajralib ketadi. Har tong bir job daftarni provayderning hisob-kitob hisoboti bilan solishtiradi, xavfsizini o'zi tuzatadi, qolganini odamga beradi.
Nimani o'rganasiz
- Nega callback'lardan yig'ilgan daftar puldan ajralib ketadi va nega summa butun sonda, eng kichik birlikda saqlanadi
- Hisob-kitob hisobotini provayder tranzaksiya ID'si, valyuta va sana oynasi bo'yicha moslash
- To'rt xil nomuvofiqlik: qaysi birini job o'zi tuzatadi, qaysilari qo'lda tekshiruv navbatiga ketadi
- Kun oxiridagi valyuta bo'yicha jami summa, ogohlantirish va bir narsani ikki marta tuzatmaydigan qayta ishga tushirish
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_api["To'lovlar API"]
n_provider>"Provayder"]
n_ledger[("Hisob daftari")]
n_files[("Hisobot fayllari")]
n_recon("Solishtirish job")
n_review[["Tekshiruv navbati"]]
n_analyst(("Moliya xodimi"))
n_pager>"Navbatchi signali"]
n_api --> n_provider
n_provider -.-> n_api
n_api --> n_ledger
n_provider --> n_files
n_files --> n_recon
n_recon --> n_ledger
n_recon --> n_provider
n_recon --> n_review
n_review --> n_analyst
n_recon --x n_pagerMermaid: so'rovlar ketma-ketligi
sequenceDiagram
participant n_provider as Provayder
participant n_api as To'lovlar API
participant n_files as Hisobot fayllari
participant n_recon as Solishtirish job
participant n_ledger as Hisob daftari
participant n_review as Tekshiruv navbati
participant n_pager as Navbatchi signali
Note over n_provider,n_api: Daftar javoblar va callback'lardan yoziladi
n_provider->>n_api: POST /payments/callback HTTP/1.1
n_api-->>n_provider: HTTP/1.1 200 OK
Note over n_api,n_provider: Daftar va pul ajralib ketadi
n_api->>n_provider: 10:20:31 POST /v1/charges ord_3307 amount_minor=4500
Note over n_provider,n_files: Provayderning hisob-kitob hisoboti
n_provider->>n_files: settlement_2026-11-17.csv (T+1, ready at 06:00 UTC)
Note over n_recon,n_ledger: Solishtirish job hisobotni daftar bilan birlashtiradi
n_recon->>n_ledger: SELECT s.provider_txn_id, s.amount_minor AS theirs,
n_ledger-->>n_recon: 48 202 rows
Note over n_recon,n_ledger: Har farq to'rt turdan biriga tushadi
n_recon->>n_ledger: recon 2026-11-17: 48 198 provider lines, 48 183 ledger rows
Note over n_recon,n_provider: Xavfsiz turni avtomatik tuzatish, audit yozuvi bilan
n_recon->>n_provider: GET /v1/payments/ptx_8813 HTTP/1.1
n_provider-->>n_recon: HTTP/1.1 200 OK
Note over n_recon,n_review: Qolgan hammasi SLA'li qo'lda tekshiruv navbatiga
n_recon->>n_review: review_case (new)
Note over n_recon,n_pager: Kun oxiri: valyuta bo'yicha jami summa
n_recon->>n_pager: ALERT recon.totals day=2026-11-17
Note over n_recon,n_ledger: Qayta ishga tushirish bir narsani ikki marta tuzatadi
n_recon->>n_ledger: 06:40 provider re-sent settlement_2026-11-17.csv (v2)
Note over n_recon,n_ledger: Har tuzatishning kaliti bor, qayta ishga tushirish hech narsani o'zgartirmaydi
n_recon->>n_ledger: INSERT INTO recon_fixes (report_date, provider_txn_id, action)
n_ledger-->>n_recon: INSERT 0 0D2
direction: right
n_api: "To'lovlar API" {
shape: rectangle
}
n_provider: "Provayder" {
shape: cloud
}
n_ledger: "Hisob daftari" {
shape: cylinder
}
n_files: "Hisobot fayllari" {
shape: stored_data
}
n_recon: "Solishtirish job" {
shape: rectangle
style.multiple: true
}
n_review: "Tekshiruv navbati" {
shape: queue
}
n_analyst: "Moliya xodimi" {
shape: person
}
n_pager: "Navbatchi signali" {
shape: cloud
}
n_api -> n_provider
n_provider -> n_api {
style.stroke-dash: 3
}
n_api -> n_ledger
n_provider -> n_files
n_files -> n_recon
n_recon -> n_ledger
n_recon -> n_provider
n_recon -> n_review
n_review -> n_analyst
n_recon -> n_pager {
target-arrowhead.shape: cross
}PlantUML: so'rovlar ketma-ketligi
@startuml
boundary "Provayder" as n_provider
participant "To'lovlar API" as n_api
database "Hisobot fayllari" as n_files
participant "Solishtirish job" as n_recon
database "Hisob daftari" as n_ledger
queue "Tekshiruv navbati" as n_review
boundary "Navbatchi signali" as n_pager
note over n_provider, n_api : Daftar javoblar va callback'lardan yoziladi
n_provider -> n_api : POST /payments/callback HTTP/1.1
n_api --> n_provider : HTTP/1.1 200 OK
note over n_api, n_provider : Daftar va pul ajralib ketadi
n_api -> n_provider : 10:20:31 POST /v1/charges ord_3307 amount_minor=4500
note over n_provider, n_files : Provayderning hisob-kitob hisoboti
n_provider -> n_files : settlement_2026-11-17.csv (T+1, ready at 06:00 UTC)
note over n_recon, n_ledger : Solishtirish job hisobotni daftar bilan birlashtiradi
n_recon -> n_ledger : SELECT s.provider_txn_id, s.amount_minor AS theirs,
n_ledger --> n_recon : 48 202 rows
note over n_recon, n_ledger : Har farq to'rt turdan biriga tushadi
n_recon -> n_ledger : recon 2026-11-17: 48 198 provider lines, 48 183 ledger rows
note over n_recon, n_provider : Xavfsiz turni avtomatik tuzatish, audit yozuvi bilan
n_recon -> n_provider : GET /v1/payments/ptx_8813 HTTP/1.1
n_provider --> n_recon : HTTP/1.1 200 OK
note over n_recon, n_review : Qolgan hammasi SLA'li qo'lda tekshiruv navbatiga
n_recon -> n_review : review_case (new)
note over n_recon, n_pager : Kun oxiri: valyuta bo'yicha jami summa
n_recon -> n_pager : ALERT recon.totals day=2026-11-17
note over n_recon, n_ledger : Qayta ishga tushirish bir narsani ikki marta tuzatadi
n_recon -> n_ledger : [dublikat] 06:40 provider re-sent settlement_2026-11-17.csv (v2)
note over n_recon, n_ledger : Har tuzatishning kaliti bor, qayta ishga tushirish hech narsani o'zgartirmaydi
n_recon -> n_ledger : INSERT INTO recon_fixes (report_date, provider_txn_id, action)
n_ledger --> n_recon : INSERT 0 0
@endumlPlantUML: komponentlar
@startuml
left to right direction
component "To'lovlar API" as n_api
cloud "Provayder" as n_provider
database "Hisob daftari" as n_ledger
storage "Hisobot fayllari" as n_files
collections "Solishtirish job" as n_recon
queue "Tekshiruv navbati" as n_review
actor "Moliya xodimi" as n_analyst
cloud "Navbatchi signali" as n_pager
n_api --> n_provider
n_provider ..> n_api
n_api --> n_ledger
n_provider --> n_files
n_files --> n_recon
n_recon --> n_ledger
n_recon --> n_provider
n_recon --> n_review
n_review --> n_analyst
n_recon -[#c62828]-> n_pager
@endumlXulosa
Solishtirishning besh qoidasi.
1) Summani valyutasi bilan, butun son va eng kichik birlikda saqlang. 2) Har kuni provayder hisobotini daftaringiz bilan ularning tranzaksiya ID'si, valyuta va kengaytirilgan sana oynasi bo'yicha moslang. 3) Har farqni turga ajrating; faqat provayder tasdiqlagan qatorlarni, faqat oldinga va audit yozuvi bilan avtomatik tuzating. 4) Qolganini ikkala tomon ma'lumoti va SLA bilan tekshiruv navbatiga yuboring, valyuta bo'yicha jami summani tekshiring, toki tushuntirilmagan pul yashirinib qolmasin. 5) Har tuzatish va ishga kalit bering, qayta ishga tushirish hech narsani o'zgartirmasin.
Ko'rsatkichlar: boshida va oxirida
| Ko'rsatkich | Boshida | Oxirida |
|---|---|---|
| Nomuvofiqliklar | 0/kun | 35/kun |
| Mos kelmagan summa | 0 $ | 1 950 $ |
| Avtomatik tuzatilgan | 0% | 68% |
| Ochiq ishlar | 0 | 11 |
Qadamlar
- Holat Daftar javoblar va callback'lardan yoziladi
Xaridor to'lov sahifasida to'laydi.
- Muammo Daftar va pul ajralib ketadi
Pul yechish chaqiruvi 10 s da timeout bo'ladi va API buyurtmani
faileddeb belgilaydi. - Yechim Provayderning hisob-kitob hisoboti
Provayder har tong kechagi hisobotni fayl sifatida (yoki sahifalab o'qiladigan API orqali) chiqaradi: o'tkazgan har yechish, qaytarish va komissiya uchun bitta qator.
- Yechim Solishtirish job hisobotni daftar bilan birlashtiradi
Job faylni oraliq jadvalga yuklaydi va uni daftar bilan provayder tranzaksiya ID'si va valyuta bo'yicha birlashtiradi.
- Holat Har farq to'rt turdan biriga tushadi
Job toza mos kelmagan har qatorni belgilaydi.
- Yechim Xavfsiz turni avtomatik tuzatish, audit yozuvi bilan
Har
missing_oursqatori uchun job provayderning holat API'sidan yana bir marta so'raydi. - Yechim Qolgan hammasi SLA'li qo'lda tekshiruv navbatiga
Qolgan 11 ta holat tekshiruv ishiga aylanadi.
- Yechim Kun oxiri: valyuta bo'yicha jami summa
Qatorma-qator moslash jami summa ushlaydigan narsani o'tkazib yuborishi mumkin: o'zgargan komissiya qoidasi, parser tashlab ketgan qator.
- Muammo Qayta ishga tushirish bir narsani ikki marta tuzatadi
Provayder xato topdi va kechagi hisobotni qayta yubordi.
- Yechim Har tuzatishning kaliti bor, qayta ishga tushirish hech narsani o'zgartirmaydi
Daftarni o'zgartirishdan oldin job tuzatishni unique kalit bilan
recon_fixesga yozadi. - Xulosa Xulosa
Solishtirishning besh qoidasi.
Atamalar
- Solishtirish (reconciliation)
- O'z hisob daftaringizni o'sha pulning tashqi yozuvi bilan solishtirib, har bir farqni hal qilish.
- Hisob-kitob hisoboti
- To'lov provayderining haqiqatan o'tkazgan har bir yechish, qaytarish va komissiyasi bo'yicha kunlik (T+1) ro'yxati.
- Eng kichik birlik (tiyin)
- Pulni eng kichik birlikda (tiyin, sent) butun son sifatida saqlash, shunda yig'indilar aniq chiqadi.