Yaxlitlik joblari — balans reconcile va yetim varaqa skani

pm-agent yangiladi

Yangilandi: estimate_hours

pm-agent yangiladi

Yangilandi: estimate_hours

team-lead-pm yangiladi

Yangilandi: estimate_hours

finalize-ep-11 yangiladi

Yangilandi: pr_url

qa-ep-11-t02-s04 statusni o'zgartirdi Review → Bajarildi

qa-ep-11-t02-s04 izoh qoldirdi

QA 2-raund — QABUL QILINDI (izolyatsiyalangan worktree, HEAD=8ec51aa). TESTLAR: 40/40 yashil (FinanceIntegrityJobTest 7, LedgerEntryServiceTest 10, ExpenseEntryServiceTest 9, CounterpartyAccountServiceTest 7, ExpenseCategoryServiceTest 7), Failures=0 Errors=0. Maven 3.9.16, bloklovchi, flock ostida. MUTATSIYA: 8/8 mutant OLDIRILDI (bytecode javap bilan tasdiqlangan). 1) employee -> suppliers yo naltirish: OLDIRILDI (1-raundda TIRIK edi) — assertHealthyAccountNotFlaggedAsOrphan, FinanceIntegrityJobTest.java:661 2) external_driver -> suppliers: OLDIRILDI (1-raundda TIRIK edi) 3) customer -> employees: OLDIRILDI 4) supplier -> customers: OLDIRILDI 5) yolgon-ijobiy (WHERE true — hamma qator yetim): OLDIRILDI 6) kesh jimgina avtomatik tuzatish (UPDATE current_balance = jurnal yigindisi): OLDIRILDI — reconcileBalances_doesNotAutoCorrectCachedBalance. Bu 1-raunddagi OCHIQ KUZATUV endi YOPILDI. 7) regressiya HAVING <> -> = : OLDIRILDI (3 test) 8) regressiya dedup: ON CONFLICT DO NOTHING olib tashlash + dedupKey ni nodeterministik qilish: ikkalasi ham OLDIRILDI. FIXTURE XILMA-XILLIGI — ildiz sabab TUZATILGAN: EXPLICIT_ROW_ID_SEQ (900_000_00x) customers/employees/external_drivers ga OVERRIDING SYSTEM VALUE bilan sogslom qator qoyadi, FAKE_COUNTERPARTY_ID_SEQ (950_000_00x) hech bir jadvalda yoq. Shu sababli notogri jadvalga yonaltirish endi sezilmay qolmaydi. Balanslar bir xil emas: 125000.75 / -84000.25 / 300000 vs 750000 / 999999 vs 380000 (musbat+manfiy, qoida 5 ikki yonalishi). Har tort tur uchun HAM sogslom HAM yetim qator, har biri ALOHIDA tasdiqlanadi (summary + finance_outbox payload). SPEC MUVOFIQLIGI (08_finance §12a, §5 qoida 4/4b/6, F3, §10): 4 turli polimorf yonaltirish §2.1 enum bilan mos; DB FK ataylab yoq (qoida 3) — deleted_at/active filtri yoq, faqat qator UMUMAN YOQligi tekshiriladi; F3 in/out ishorasi togsri; kesh TUZATILMAYDI (jurnal golib) — test bilan qoplangan; hodisa finance_outbox orqali (AR-3/AR-12, broker yoq); ikkala metod @Transactional; jim otish yoq (WARN log). TOZALIK: 44e7815..HEAD faqat FinanceIntegrityJobTest.java; openapi/ va db/migration/ tegilmagan; MUTANT qoldigi yoq; .orig fayl yoq; asosiy daraxt va worktree rosyxati toza.

qa-ep-11-t02-s04 qabul mezonini belgiladi

✓ Job ikki marta yurgizilganda ikkinchi ogohlantirish hodisasi dublikat bo'lib yozilmaydi

qa-ep-11-t02-s04 qabul mezonini belgiladi

✓ Yetim `counterparty_accounts` qatori (mavjud bo'lmagan `counterparty_id`) skanda topiladi

qa-ep-11-t02-s04 qabul mezonini belgiladi

✓ Kesh qasddan buzilganda job farqni topadi va xabar hodisasini yozadi (test)

coder-ep-11-t02-s04 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-11-t02-s04 statusni o'zgartirdi Tayyor → Ishlanyapti

coder-ep-11-t02-s04 izoh qoldirdi

QA qaytarishi tuzatildi (AC4057). Ildiz sabab: fixture faqat supplier/customer turlarini sinagan, employee/external_driver umuman qamrov qilinmagan edi. Endi to'rtala counterparty_type (supplier/customer/employee/external_driver) uchun HAM sog'lom (real ota qatorga bog'langan), HAM yetim qator bor — har tur alohida tasdiqlanadi. customer/employee/external_driver uchun real qatorlar to'g'ridan-to'g'ri JDBC (OVERRIDING SYSTEM VALUE, baland id oralig'i — suppliers bilan id to'qnashuvining oldini olish uchun) bilan qo'yiladi. Ikkala mutant (employee->suppliers, external_driver->suppliers) qo'lda sinaldi va tasdiqlandi (bytecode javap bilan): endi ikkalasi ham testni sindiradi. Qo'shimcha: reconcileBalances_doesNotAutoCorrectCachedBalance testi qo'shildi (kesh avtomatik tuzatilmasligini alohida tasdiqlaydi, AC4056 mutatsiya kuzatuvi). Test to'plami: 7/7 yashil. Commit 8ec51aa.

coder-ep-11-t02-s04 yangiladi

Yangilandi: commit_sha

coder-ep-11-t02-s04 qabul mezonini belgiladi

✓ Yetim `counterparty_accounts` qatori (mavjud bo'lmagan `counterparty_id`) skanda topiladi

coder-ep-11-t02-s04 fayllarni qayd etdi

1 ta fayl qayd etildi

system statusni o'zgartirdi Ishlanyapti → Tayyor

Avtomatik bo'shatildi: 60 daqiqa signal yo'q

system bo'shatdi

Avtomatik bo'shatildi: 60 daqiqa signal yo'q

qa-ep-11-t02-s04 statusni o'zgartirdi Review → Ishlanyapti

qa-ep-11-t02-s04 izoh qoldirdi

QA (mutatsiya tekshiruvi, izolyatsiyalangan worktree). Testlar YASHIL: FinanceIntegrityJobTest 6, ExpenseEntryServiceTest 9, ExpenseCategoryServiceTest 7, LedgerEntryServiceTest 10, CounterpartyAccountServiceTest 7 = 39 test, 0 failure (Maven 3.9.16). openapi/ va db/migration/ ga tegilmagan (git diff 092960f..HEAD = 3 fayl). application.yml StockReconciliationJob naqshi bilan izchil, `test` profilida enabled:false. AC4056 = TRUE. Ikkala kesh tarafi ham HAQIQATAN qamralgan: mutant `HAVING <> -> =` (counterparty) 3 testni yiqitdi; TAUTOLOGIK mutant (`SUM(le.amount)` o'rniga `ca.current_balance`) 2 testni yiqitdi; money_accounts tarafi uchun alohida mutant (`HAVING <> -> =`) 2 testni, `direction in/out` ishora almashtiruvchi mutant 1 testni yiqitdi. Job hech qanday UPDATE bajarmaydi — kesh tuzatilmaydi (qoida 6 'jurnal g'olib'). AC4058 = TRUE. Dedup haqiqatan test qilingan: `dedup_key` ni nodeterministik qiluvchi mutant 2 testni, `ON CONFLICT ... DO NOTHING` ni olib tashlovchi mutant 4 testni yiqitdi. Testlar `count(*)` ni tekshiradi, 'xato tashlanmadi' emas. `ON CONFLICT ... WHERE status IN ('pending','processing')` — bu coder ixtirosi EMAS, V42 migratsiyasidagi `uq_finance_outbox_dedup_key` qisman indeksi bilan majburiy mos (V28/V31/V34 precedenti), spec §12a 'jim o'tmaydi' bilan zid emas. Nuqson emas. === AC4057 = FALSE — QAYTARILADI === Polimorf yo'naltirish (counterparty_type -> jadval) 4 turdan 2 tasida SINALMAGAN. Uch mutant kiritildi (hammasi javap bilan bytecode'da tasdiqlangan): * supplier -> customers (FinanceIntegrityJob.java:~248) => 1 test yiqildi (OK, qamralgan) * employee -> suppliers (FinanceIntegrityJob.java:~252) => 6/6 test O'TDI (TIRIK QOLDI) * external_driver -> suppliers (FinanceIntegrityJob.java:~254) => 6/6 test O'TDI (TIRIK QOLDI) Sabab — fixture xilma-xilligi yo'q: `employee` turi uchun testda FAQAT yetim (mavjud bo'lmagan, 950_000_00x) id ishlatilgan, `external_driver` turi uchun esa umuman FIXTURE YO'Q. Yetim id hech bir jadvalda yo'q, shuning uchun noto'g'ri jadvalga yo'naltirilgan shoxobcha ham 'yetim' deb qaytaradi va test farqni ko'rmaydi. Haqiqiy xavf: employee/external_driver shoxobchasi noto'g'ri jadvalga ulansa, SOG'LOM hodim/ko'cha shafyori varaqasi 'yetim' deb ogohlantiriladi (yolg'on signal) — hozirgi to'plam buni ushlamaydi. `external_driver` — jonli tur: V38 CHECK (counterparty_type IN (...,'external_driver')) va CounterpartyAccountService.TYPE_EXTERNAL_DRIVER:37. TALAB (FinanceIntegrityJobTest.java, scanOrphanAccounts_detectsOrphanButNotHealthyAccount ichida yoki yangi testda): 1) SOG'LOM `employee` varaqasi — real `employees` qatori yaratilib, uning id'si bilan getOrCreate(TYPE_EMPLOYEE, ...); assert: yetim ro'yxatida YO'Q. 2) SOG'LOM `external_driver` varaqasi — real `external_drivers` qatori (V41) yaratilib, getOrCreate(TYPE_EXTERNAL_DRIVER, ...); assert: yetim ro'yxatida YO'Q. 3) YETIM `external_driver` varaqasi (mavjud bo'lmagan id); assert: yetim ro'yxatida BOR + finance_outbox qatori yozilgan. 4) YETIM `supplier` varaqasi (hozir faqat sog'lom supplier bor); assert: topiladi. Qabul mezoni: yuqoridagi uch yo'naltirish mutanti (employee->suppliers, external_driver->suppliers, customer->suppliers) kiritilganda to'plam YIQILISHI shart. === Qo'shimcha kuzatuv (bloklamaydi, lekin yopilsa yaxshi) === Mutant: reconcileBalances() ichiga `UPDATE counterparty_accounts SET current_balance = <ledger sum>` (jimgina avtomatik tuzatish) qo'shildi => 6/6 test O'TDI. Ya'ni board technical_notes dagi 'kesh tuzatilmaydi — jurnal g'olib' talabini hech bir test qo'riqlamaydi. Yomon tomoni: avtomatik tuzatish bo'lsa AC4058 dedup testi ham NOTO'G'RI sababdan yashil bo'ladi (ikkinchi yurishda farq yo'qoladi, dedup emas). Tavsiya: AC4056 testiga `setCounterpartyAccountBalance` dan keyin job yurgizilib, DB'dagi `current_balance` HAMON buzilgan (300000.00) qolganini tasdiqlovchi assert qo'shilsin. Cross-cutting: @Transactional ikkala metodda bor; tenant_id yo'q (AR-1); broker yo'q, outbox orqali (AR-3/AR-12); fizik DELETE yo'q; soft-delete filtri ATAYLAB yo'q (qoida 3 bilan izchil, javodocda asoslangan); parol/token log'ga chiqmaydi. `pg_advisory_lock` (sessiya darajasi) ISHLATILMAGAN — §10 buzilmagan (advisory lock 'kerak bo'lsa' shartli, bu job o'qish + dedup-himoyalangan insert).

qa-ep-11-t02-s04 qabul mezonini belgiladi

✓ Job ikki marta yurgizilganda ikkinchi ogohlantirish hodisasi dublikat bo'lib yozilmaydi

qa-ep-11-t02-s04 qabul mezonini belgiladi

✗ Yetim `counterparty_accounts` qatori (mavjud bo'lmagan `counterparty_id`) skanda topiladi

qa-ep-11-t02-s04 qabul mezonini belgiladi

✓ Kesh qasddan buzilganda job farqni topadi va xabar hodisasini yozadi (test)

coder-ep-11-t02-s04 yangiladi

Yangilandi: branch, commit_sha

coder-ep-11-t02-s04 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-11-t02-s04 qabul mezonini belgiladi

✓ Job ikki marta yurgizilganda ikkinchi ogohlantirish hodisasi dublikat bo'lib yozilmaydi

coder-ep-11-t02-s04 qabul mezonini belgiladi

✓ Yetim `counterparty_accounts` qatori (mavjud bo'lmagan `counterparty_id`) skanda topiladi

coder-ep-11-t02-s04 qabul mezonini belgiladi

✓ Kesh qasddan buzilganda job farqni topadi va xabar hodisasini yozadi (test)

coder-ep-11-t02-s04 fayllarni qayd etdi

3 ta fayl qayd etildi

coder-ep-11-t02-s04 statusni o'zgartirdi Backlog → Ishlanyapti

Agent ishni boshladi

coder-ep-11-t02-s04 ishga oldi

pm-agent yaratdi

Yaxlitlik joblari — balans reconcile va yetim varaqa skani