mufassall

Konspekt · Biznes jarayonlar

Ikki yoqlama hisob daftari

14 daq · O'rta · mufassall.dtwin.uz/uz/l/double-entry-ledger/

← Darsni ochish

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
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_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_pager

Mermaid: 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-17

D2

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
@enduml

PlantUML: 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
@enduml

Xulosa

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'rsatkichBoshidaOxirida
Izohsiz pul0 $0 $
Yo'qolgan yangilanish0/kun0/kun
Ikki marta yechish0/kun0/kun
Balansni o'qish2 ms3 ms

Qadamlar

  1. Holat Hamyon bitta qatordagi bitta son

    Xaridor buyurtma uchun $45.00 to'laydi.

  2. Muammo Bir vaqtda ikki to'lov, bittasi g'oyib bo'ladi

    Xaridor bir soniyaning o'zida telefonda bir buyurtmani, brauzerda boshqasini to'laydi.

  3. Yechim Har harakat yozuv, posting'lari yig'indisi nol

    Hamyon hisob (account) bo'ladi, sotuvchi va platformaning komissiya daromadi ham.

  4. Yechim Balans yig'indi, versiya bilan keshlanadi

    Haqiqiy balans hisob posting'larining SUM(amount_minor) i.

  5. Muammo Takror so'rov bitta to'lovni ikki marta yozadi

    Sekin tarmoqda to'lov so'rovi timeout bo'ladi.

  6. Yechim Har biznes amaliga bitta kalit

    Ilova kalitni har to'lov uchun bir marta yaratadi, pay-ord_5133, va har takrorda yuboradi.

  7. Yechim Hold: daftar balansi va mavjud balans

    Xaridor keyingi hafta jo'natiladigan $129.00 lik mahsulot buyurtma qiladi.

  8. Yechim Qaytarish yangi yozuv, hech qachon tahrir emas

    Support ord_5120 buyurtma pulini qaytaradi.

  9. Yechim Har yig'indida bitta valyuta, ayirboshlash hisoblar orqali

    Xaridor USD hamyonga 100.00 EUR to'laydi.

  10. 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.

  11. 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.