Konspekt · Biznes jarayonlar
Ikki yoqlama hisob daftari
Muammo
Marketpleys xaridorlar hamyonini yuritadi, sotuvchilarga pul o'tkazadi va komissiya oladi. Joyida yangilanadigan balans ustuni bir vaqtdagi so'rovlarda pulni yo'qotadi va u qayerga ketganini ayta olmaydi. Ikki yoqlama daftar har pul harakatini posting'lari yig'indisi nolga teng yozuv sifatida saqlaydi, balansni shundan hisoblaydi va tarixni hech qachon qayta yozmaydi.
Nimani o'rganasiz
- Nega joyida yangilanadigan balans ustuni yangilanishlarni yo'qotadi va iz qoldirmaydi
- Hisoblar, jurnal yozuvlari va yig'indisi nol bo'lgan posting'lar bitta tranzaksiyada
- Versiyali keshli hisoblangan balans, idempotency kaliti, hold va mavjud balans
- Qaytarish = teskari yozuv, har yig'indida bitta valyuta, har kungi trial balance va ogohlantirish
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_app(["Xaridor ilovasi"])
n_api["Hamyon API"]
n_ledger[("Hisob daftari")]
n_balances[("Balans keshi")]
n_payout("Yechish job")
n_support(("Support xodimi"))
n_rates>"Valyuta kurslari"]
n_checker("Trial balance")
n_pager>"Navbatchi signali"]
n_app --> n_api
n_api --> n_ledger
n_api --> n_balances
n_payout --> n_ledger
n_support --> n_api
n_api --> n_rates
n_checker --> n_ledger
n_checker --x n_pagerMermaid: so'rovlar ketma-ketligi
sequenceDiagram
participant n_api as Hamyon API
participant n_wallets as Hamyonlar jadvali
participant n_ledger as Hisob daftari
participant n_balances as Balans keshi
participant n_app as Xaridor ilovasi
participant n_checker as Trial balance
Note over n_api,n_wallets: Hamyon bitta qatordagi bitta son
n_api->>n_wallets: SELECT balance_minor FROM wallets WHERE user_id = 'u_42'#59;
n_wallets-->>n_api: UPDATE 1
Note over n_api,n_wallets: Bir vaqtda ikki to'lov, bittasi g'oyib bo'ladi
n_api->>n_wallets: 12:00:01.204 tx A read balance_minor=12000 (order 4500)
Note over n_api,n_ledger: Har harakat yozuv, posting'lari yig'indisi nol
n_api->>n_ledger: BEGIN#59;
n_ledger-->>n_api: COMMIT
Note over n_api,n_balances: Balans yig'indi, versiya bilan keshlanadi
n_api->>n_balances: UPDATE account_balances
n_balances-->>n_api: UPDATE 1
Note over n_app,n_api: Takror so'rov bitta to'lovni ikki marta yozadi
n_app->>n_api: 14:02:10 POST /v1/orders/ord_5133/pay -#62; no answer in 5 s
Note over n_app,n_api: Har biznes amaliga bitta kalit
n_app->>n_api: POST /v1/orders/ord_5133/pay HTTP/1.1
n_api-->>n_app: HTTP/1.1 200 OK
Note over n_app,n_api: Hold: daftar balansi va mavjud balans
n_app->>n_api: GET /v1/wallets/u_58/balance HTTP/1.1
n_api-->>n_app: HTTP/1.1 200 OK
Note over n_api,n_ledger: Qaytarish yangi yozuv, hech qachon tahrir emas
n_api->>n_ledger: INSERT INTO journal_entries (id, kind, ref, reverses)
n_ledger-->>n_api: INSERT 0 3
Note over n_api,n_ledger: Har yig'indida bitta valyuta, ayirboshlash hisoblar orqali
n_api->>n_ledger: INSERT INTO postings (entry_id, account, amount_minor, currency)
n_ledger-->>n_api: COMMIT
Note over n_checker,n_ledger: Har tun: hammasi hali ham nolga tengmi?
n_checker->>n_ledger: SELECT currency, SUM(amount_minor) AS total
n_ledger-->>n_checker: trial balance 2026-11-17D2
direction: right
n_app: "Xaridor ilovasi" {
shape: rectangle
}
n_api: "Hamyon API" {
shape: rectangle
}
n_ledger: "Hisob daftari" {
shape: cylinder
}
n_balances: "Balans keshi" {
shape: cylinder
}
n_payout: "Yechish job" {
shape: rectangle
style.multiple: true
}
n_support: "Support xodimi" {
shape: person
}
n_rates: "Valyuta kurslari" {
shape: cloud
}
n_checker: "Trial balance" {
shape: rectangle
style.multiple: true
}
n_pager: "Navbatchi signali" {
shape: cloud
}
n_app -> n_api
n_api -> n_ledger
n_api -> n_balances
n_payout -> n_ledger
n_support -> n_api
n_api -> n_rates
n_checker -> n_ledger
n_checker -> n_pager {
target-arrowhead.shape: cross
}PlantUML: so'rovlar ketma-ketligi
@startuml
participant "Hamyon API" as n_api
database "Hamyonlar jadvali" as n_wallets
database "Hisob daftari" as n_ledger
database "Balans keshi" as n_balances
participant "Xaridor ilovasi" as n_app
participant "Trial balance" as n_checker
note over n_api, n_wallets : Hamyon bitta qatordagi bitta son
n_api -> n_wallets : SELECT balance_minor FROM wallets WHERE user_id = 'u_42';
n_wallets --> n_api : UPDATE 1
note over n_api, n_wallets : Bir vaqtda ikki to'lov, bittasi g'oyib bo'ladi
n_api -> n_wallets : [dublikat] 12:00:01.204 tx A read balance_minor=12000 (order 4500)
note over n_api, n_ledger : Har harakat yozuv, posting'lari yig'indisi nol
n_api -> n_ledger : BEGIN;
n_ledger --> n_api : COMMIT
note over n_api, n_balances : Balans yig'indi, versiya bilan keshlanadi
n_api -> n_balances : UPDATE account_balances
n_balances --> n_api : UPDATE 1
note over n_app, n_api : Takror so'rov bitta to'lovni ikki marta yozadi
n_app -> n_api : [dublikat] 14:02:10 POST /v1/orders/ord_5133/pay -> no answer in 5 s
note over n_app, n_api : Har biznes amaliga bitta kalit
n_app -> n_api : POST /v1/orders/ord_5133/pay HTTP/1.1
n_api --> n_app : HTTP/1.1 200 OK
note over n_app, n_api : Hold: daftar balansi va mavjud balans
n_app -> n_api : GET /v1/wallets/u_58/balance HTTP/1.1
n_api --> n_app : HTTP/1.1 200 OK
note over n_api, n_ledger : Qaytarish yangi yozuv, hech qachon tahrir emas
n_api -> n_ledger : INSERT INTO journal_entries (id, kind, ref, reverses)
n_ledger --> n_api : INSERT 0 3
note over n_api, n_ledger : Har yig'indida bitta valyuta, ayirboshlash hisoblar orqali
n_api -> n_ledger : INSERT INTO postings (entry_id, account, amount_minor, currency)
n_ledger --> n_api : COMMIT
note over n_checker, n_ledger : Har tun: hammasi hali ham nolga tengmi?
n_checker -> n_ledger : SELECT currency, SUM(amount_minor) AS total
n_ledger --> n_checker : trial balance 2026-11-17
@endumlPlantUML: komponentlar
@startuml
left to right direction
agent "Xaridor ilovasi" as n_app
component "Hamyon API" as n_api
database "Hisob daftari" as n_ledger
database "Balans keshi" as n_balances
collections "Yechish job" as n_payout
actor "Support xodimi" as n_support
cloud "Valyuta kurslari" as n_rates
collections "Trial balance" as n_checker
cloud "Navbatchi signali" as n_pager
n_app --> n_api
n_api --> n_ledger
n_api --> n_balances
n_payout --> n_ledger
n_support --> n_api
n_api --> n_rates
n_checker --> n_ledger
n_checker -[#c62828]-> n_pager
@endumlXulosa
Mahsulotdagi pul uchun olti qoida.
1) Pulni hech qachon joyida ustidan yoziladigan son sifatida saqlamang. 2) Har harakat posting'lari yig'indisi nol bo'lgan, bitta tranzaksiyada qo'shiladigan jurnal yozuvi. 3) Balans posting'lar yig'indisi; versiyasi bor va qayta quriladigan kesh bo'lishi mumkin. 4) Har biznes amaliga bitta idempotency kaliti; hold yechilguncha yoki muddati tugaguncha mavjud balansni kamaytiradi. 5) Bekor qilish teskari yozuv bilan, hech qachon UPDATE yoki DELETE emas; har yig'indida bitta valyuta, ayirboshlash hisoblar orqali. 6) Har kuni trial balance yurgizing va u nol bo'lmasa odamni chaqiring.
Ko'rsatkichlar: boshida va oxirida
| Ko'rsatkich | Boshida | Oxirida |
|---|---|---|
| Izohsiz pul | 0 $ | 0 $ |
| Yo'qolgan yangilanish | 0/kun | 0/kun |
| Ikki marta yechish | 0/kun | 0/kun |
| Balansni o'qish | 2 ms | 3 ms |
Qadamlar
- Holat Hamyon bitta qatordagi bitta son
Xaridor buyurtma uchun $45.00 to'laydi.
- Muammo Bir vaqtda ikki to'lov, bittasi g'oyib bo'ladi
Xaridor bir soniyaning o'zida telefonda bir buyurtmani, brauzerda boshqasini to'laydi.
- Yechim Har harakat yozuv, posting'lari yig'indisi nol
Hamyon hisob (account) bo'ladi, sotuvchi va platformaning komissiya daromadi ham.
- Yechim Balans yig'indi, versiya bilan keshlanadi
Haqiqiy balans hisob posting'larining
SUM(amount_minor)i. - Muammo Takror so'rov bitta to'lovni ikki marta yozadi
Sekin tarmoqda to'lov so'rovi timeout bo'ladi.
- Yechim Har biznes amaliga bitta kalit
Ilova kalitni har to'lov uchun bir marta yaratadi,
pay-ord_5133, va har takrorda yuboradi. - Yechim Hold: daftar balansi va mavjud balans
Xaridor keyingi hafta jo'natiladigan $129.00 lik mahsulot buyurtma qiladi.
- Yechim Qaytarish yangi yozuv, hech qachon tahrir emas
Support
ord_5120buyurtma pulini qaytaradi. - Yechim Har yig'indida bitta valyuta, ayirboshlash hisoblar orqali
Xaridor USD hamyonga 100.00 EUR to'laydi.
- Yechim Har tun: hammasi hali ham nolga tengmi?
Tungi job trial balance yurgizadi: har valyuta bo'yicha barcha posting'lar yig'indisi aynan nol bo'lishi kerak.
- Xulosa Xulosa
Mahsulotdagi pul uchun olti qoida.
Atamalar
- Ikki yoqlama yozuv
- Har bir pul harakati posting'lari yig'indisi nolga teng bitta yozuv: debet kreditga teng.
- Trial balance
- Har bir valyuta bo'yicha barcha posting'lar yig'indisi aynan nol ekanini muntazam tekshirish.
- Teskari yozuv
- Avvalgi yozuvni tahrir qilmasdan bekor qiladigan, teskari posting'li yangi yozuv.