V26 — `works` (hodim ish bo'lagi, snapshotlar bilan)

finalize-ep-07 yangiladi

Yangilandi: pr_url

qa-ep-07-t01-s03 statusni o'zgartirdi Review → Bajarildi

qa-ep-07-t01-s03 izoh qoldirdi

QA 2-o'tish (mustaqil mutatsiya tekshiruvi). V26__works.sql ad3f95f dan BAYT-BA-BAYT o'zgarmagan (md5 fcbc421e...). Baseline: 26/26 yashil. 3175 teshigi YOPILDI — yangi test insertWorkWithoutStatusOrBrakColumns() INSERT ustunlar ro'yxatiga status/is_brak ni UMUMAN kiritmaydi (INSERT INTO works (task_id, employee_id, profession_id, claimed_qty) ... RETURNING status, is_brak), assert DB dan qaytgan qiymat ustida — tautologiya yo'q. Uchala mutatsiya O'LDIRILDI: (a) status DEFAULT claimed->void => statusAndIsBrakColumnDefaultsAreEnforcedByDatabase yiqildi (expected claimed but was void, :126); (b) is_brak DEFAULT false->true => o'sha test ERROR (chk_works_reject_reason_required_for_brak, :481) + workWithUnknownReviewedByUserIsRejected; (c) chk_works_status dan void olib tashlandi => validStatusesAreAcceptedWithRequiredCompanions va claimedAndVoidAllowNullProductionDate ERROR (chk_works_status). Har mutatsiyadan keyin migratsiya tiklandi; yakuniy run 26/26 yashil, V26 diff bo'sh. Barcha 6 mezon o'tdi.

qa-ep-07-t01-s03 qabul mezonini belgiladi

✓ `status` CHECK: `claimed` | `submitted` | `confirmed` | `rejected` | `void`, default `claimed`

coder-ep-07-t01-s03 yangiladi

Yangilandi: commit_sha

coder-ep-07-t01-s03 fayllarni qayd etdi

1 ta fayl qayd etildi

coder-ep-07-t01-s03 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ `status` CHECK: `claimed` | `submitted` | `confirmed` | `rejected` | `void`, default `claimed`

qa-ep-07-t01-s03 statusni o'zgartirdi Review → Ishlanyapti

qa-ep-07-t01-s03 izoh qoldirdi

QA (qa-EP-07-T01-S03) — V26 QAYTARILDI: 1 ta QAMROV defekti (SQL to'g'ri, test yetarli emas). IMPLEMENTATSIYA — 6/6 mezon jonli PostgreSQL 16 ustida information_schema / pg_constraint / pg_indexes orqali MUSTAQIL tasdiqlandi. Migratsiyani tuzatish SHART EMAS: - 3175 chk_works_status = claimed|submitted|confirmed|rejected|void, column_default = 'claimed'::character varying — openapi/v1/tasks.yaml:1332 WorkStatus enum bilan AYNAN mos; - 3176/3177/3178 CHECK'lar spec #2.2 ga mos; 3179 brak_qty YO'Q, organization_id YO'Q (tenant_id ham yo'q, AR-1); - 3180 idx_works_task_id / idx_works_employee_id / idx_works_status + kompozit idx_works_employee_profession_status (employee_id, profession_id, status) — ustunlar TARTIBI to'g'ri; - precision: claimed_qty/confirmed_qty numeric(18,4), material/labor/brak_loss_snapshot numeric(18,2); FK -> tasks, employees, professions, users. TEST — baseline 25/25 yashil. Mutatsiya tekshiruvi: (a) DEFAULT 'claimed' -> DEFAULT 'void' => OMON QOLDI, 25/25 yashil [DEFEKT] (b) chk_works_confirmed_qty_range dan `confirmed_qty <= claimed_qty` olib tashlandi => O'LDI (confirmedQtyGreaterThanClaimedQtyIsRejected) (c) chk_works_reject_reason_required_for_brak butunlay o'chirildi => O'LDI (brakWithoutReasonIsRejected) SABAB — 3175 is_met=false. Bu S02/V25 dagi AYNI defektning takrori. Fayl: src/test/java/uz/erpbom/tasks/WorksTableMigrationTest.java - 491-512 insertWorkRawWithAllFks — INSERT ustunlar ro'yxatida `status` HAR DOIM bor (statement.setString(6, status)), shuning uchun DEFAULT hech qachon ishga tushmaydi; - 457-460 insertClaimedWork — status sifatida "claimed" ni o'zi uzatadi; - 90-110 workCanBeInsertedWithDefaults — "claimed" yozib, o'sha "claimed" ni o'qiydi => TAUTOLOGIK. Nomida "WithDefaults" bo'lsa-da, DEFAULT 'claimed' tekshirilmagan. Kutilgan: `status` ustuni INSERT'ga UMUMAN qo'shilmagan qator kiritilsin va o'qilganda 'claimed' chiqsin (yoki information_schema.columns.column_default tasdiqlansin). Olingan: DEFAULT 'void' bo'lganda ham 25/25 yashil. QO'SHIMCHA (bloklamaydi, ayni tautologiya): `is_brak` DEFAULT false ham shu sababdan qamralmagan — helper 8-parametrni har doim yozadi. Bir xil tuzatish bilan yopilsin. 3176 QAMROVI TO'LIQ: submitted/confirmed/rejected uchun production_date NULL rad etilishi 3 ta alohida test bilan (qator 153/166/179, chk_works_production_date_required nomi tekshirilgan), claimed/void da NULL o'tishi qator 192 (claimedAndVoidAllowNullProductionDate). Bu yerda tuzatish kerak emas. ESLATMA: mutatsiyalar ad3f95f ning izolyatsiya qilingan nusxasida yurgizildi — ish paytida jamoadoshning TasksTableMigrationTest.java (S02) tahriri test kompilyatsiyasini buzib turgan edi (cannot find symbol: insertTaskWithDefaultTypeAndStatus). V26__works.sql va S03 testi repo'da TEGILMAGAN (git diff toza).

qa-ep-07-t01-s03 qabul mezonini belgiladi

✗ `status` CHECK: `claimed` | `submitted` | `confirmed` | `rejected` | `void`, default `claimed`

qa-ep-07-t01-s03 qabul mezonini belgiladi

✓ Indekslar: `task_id`, `employee_id`, `status`, (`employee_id`,`profession_id`,`status`) — band-task gate uchun

qa-ep-07-t01-s03 qabul mezonini belgiladi

✓ `brak_qty` ustuni YO'Q (hosila); `organization_id` ustuni YO'Q (task orqali meros)

qa-ep-07-t01-s03 qabul mezonini belgiladi

✓ CHECK: `is_brak = true` -> `reject_reason IS NOT NULL` (izoh majburiy)

qa-ep-07-t01-s03 qabul mezonini belgiladi

✓ CHECK: `confirmed_qty` NULL yoki `0 <= confirmed_qty <= claimed_qty`; `claimed_qty > 0`

qa-ep-07-t01-s03 qabul mezonini belgiladi

✓ CHECK: `status IN ('submitted','confirmed','rejected')` -> `production_date IS NOT NULL`

coder-ep-07-t01-s03 statusni o'zgartirdi Ishlanyapti → Review

coder-ep-07-t01-s03 yangiladi

Yangilandi: branch, commit_sha

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ Indekslar: `task_id`, `employee_id`, `status`, (`employee_id`,`profession_id`,`status`) — band-task gate uchun

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ `brak_qty` ustuni YO'Q (hosila); `organization_id` ustuni YO'Q (task orqali meros)

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ CHECK: `is_brak = true` -> `reject_reason IS NOT NULL` (izoh majburiy)

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ CHECK: `confirmed_qty` NULL yoki `0 <= confirmed_qty <= claimed_qty`; `claimed_qty > 0`

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ CHECK: `status IN ('submitted','confirmed','rejected')` -> `production_date IS NOT NULL`

coder-ep-07-t01-s03 qabul mezonini belgiladi

✓ `status` CHECK: `claimed` | `submitted` | `confirmed` | `rejected` | `void`, default `claimed`

coder-ep-07-t01-s03 fayllarni qayd etdi

2 ta fayl qayd etildi

coder-ep-07-t01-s03 statusni o'zgartirdi Backlog → Ishlanyapti

Agent ishni boshladi

coder-ep-07-t01-s03 ishga oldi

pm-agent yaratdi

V26 — `works` (hodim ish bo'lagi, snapshotlar bilan)