CREATE TABLE [dbo].[tr_wo_picking](
    [wo_id]             VARCHAR(50) NOT NULL,         -- No WO / No PRO (e.g., BASY1234)
    [fg_pn]             VARCHAR(100) NOT NULL,        -- Part Number Finished Goods (e.g., F1AA01045-TO065-E)
    [fg_desc]           NVARCHAR(200) NULL,           -- Deskripsi produk (cache dari master)
    [qty_plan]          INT NOT NULL,                 -- Target qty pesanan dari Infor
    [qty_actual]        INT NULL,                     -- MIN(qty_actual semua bahan), dihitung backend
    [wo_received_at]    DATETIME NULL,                -- Jam pesanan masuk (dari Infor)
    [status]            VARCHAR(20) NOT NULL DEFAULT 'PENDING',  -- PENDING / ON_PROGRESS / COMPLETED
    [start_time]        DATETIME NULL,                -- Timestamp klik Start WO
    [finish_time]       DATETIME NULL,                -- Timestamp semua bahan selesai
    [prod_time]         DATETIME NULL,                -- Timestamp klik tombol PROD
    [transfer_status]   VARCHAR(20) DEFAULT 'PENDING',-- PENDING / TRANSFERRED
    [picker_id]         VARCHAR(50) NULL,             -- User ID gudang yang klik Start WO
    [picker_name]       NVARCHAR(100) NULL,           -- Nama petugas (cache)
    [mode]              VARCHAR(20) DEFAULT 'ESTIMASI', -- ESTIMASI / LABEL
    [created_at]        DATETIME DEFAULT GETDATE(),
    PRIMARY KEY ([wo_id])
);
  

  CREATE TABLE [dbo].[tr_wo_picking_detail](
    [detail_id]         INT IDENTITY(1,1) NOT NULL,
    [wo_id]             VARCHAR(50) NOT NULL,          -- FK ke header
    [child_pn]          VARCHAR(100) NOT NULL,         -- Part Number bahan (e.g., CPIB00337-01080B)
    [child_desc]        NVARCHAR(200) NULL,            -- Deskripsi bahan (cache)
    [bom_multiplier]    DECIMAL(18,4) NOT NULL DEFAULT 1, -- Koefisien BOM (0.5, 1, 1.8, dll)
    [qty_required]      DECIMAL(18,4) NOT NULL,        -- qty_plan × bom_multiplier
    [end_stock]         DECIMAL(18,4) NULL,            -- Stok akhir gudang (dari API END STOCK)
    [qty_actual]        DECIMAL(18,4) NULL,            -- Qty riil yang berhasil dikumpulkan
    [layout_info]       NVARCHAR(500) NULL,            -- Lokasi rak dari API FIFO (e.g. "AB1-2 (1000); AB1-3 (5000)")
    [wh_asal]           VARCHAR(20) NOT NULL DEFAULT 'BWSUP',
    [wh_tujuan]         VARCHAR(20) NOT NULL DEFAULT 'BPASY',
    [picker_id]         VARCHAR(50) NULL,              -- PIC gudang yang klik Start per bahan
    [start_time]        DATETIME NULL,                 -- Timestamp klik Start bahan
    [finish_time]       DATETIME NULL,                 -- Timestamp klik Finish bahan
    [status]            VARCHAR(20) NOT NULL DEFAULT 'PENDING', -- PENDING/ON_PROGRESS/COMPLETED/PROBLEM
    PRIMARY KEY ([detail_id]),
    FOREIGN KEY ([wo_id]) REFERENCES [tr_wo_picking]([wo_id])
);
  

  CREATE TABLE [dbo].[tr_wo_picking_log](
    [log_id]            INT IDENTITY(1,1) NOT NULL,
    [detail_id]         INT NOT NULL,                  -- FK ke detail bahan
    [keterangan]        NVARCHAR(MAX) NOT NULL,        -- Isi masalah (e.g., "TEMPEL STICKER", "Stok kurang 1000")
    [reported_by]       VARCHAR(50) NOT NULL,          -- NPK pelapor
    [reported_at]       DATETIME DEFAULT GETDATE(),
    PRIMARY KEY ([log_id]),
    FOREIGN KEY ([detail_id]) REFERENCES [tr_wo_picking_detail]([detail_id])
);
  

  CREATE VIEW [dbo].[vw_wo_picking_history] AS
SELECT 
    h.wo_id, h.wo_received_at, h.fg_pn, h.fg_desc, h.qty_plan, h.qty_actual,
    h.start_time, h.finish_time,
    DATEDIFF(MINUTE, h.start_time, h.finish_time) AS selisih_menit,
    h.prod_time, h.picker_id, h.picker_name,
    d.child_pn, d.qty_required, d.qty_actual AS detail_qty_actual,
    d.start_time AS detail_start, d.finish_time AS detail_finish
FROM tr_wo_picking h
JOIN tr_wo_picking_detail d ON h.wo_id = d.wo_id
WHERE h.status = 'COMPLETED';
  

  btb_backend/
├── Controllers/
│   └── WOPickingController.cs        ← BARU
├── DTOs/
│   └── WOPicking/                    ← BARU
│       ├── WOHeaderDto.cs
│       ├── WODetailDto.cs
│       ├── StartPickingRequestDto.cs
│       ├── FinishPickingRequestDto.cs
│       └── ReportProblemDto.cs
├── Services/
│   ├── Interfaces/IWOPickingService.cs   ← BARU
│   └── Implementations/WOPickingService.cs ← BARU
├── Repositories/
│   ├── Interfaces/IWOPickingRepository.cs  ← BARU
│   └── Implementations/WOPickingRepository.cs ← BARU
  

  src/component/page/
└── wo-picking/                 ← BARU (folder)
    ├── Index.jsx               ← Dashboard List Estimasi
    ├── Detail.jsx              ← Detail BOM / Bahan per WO
    └── History.jsx             ← Riwayat WO yang sudah selesai
  

  const WOPicking = lazy(() => import("../page/wo-picking/Index"));
const WOPickingDetail = lazy(() => import("../page/wo-picking/Detail"));
const WOPickingHistory = lazy(() => import("../page/wo-picking/History"));

// Tambahkan ke routeList:
{ path: "/wo_picking", element: <WOPicking />, title: "Estimasi Pengumpulan Bahan" },
{ path: "/wo_picking/:woId", element: <WOPickingDetail />, title: "Detail BOM" },
{ path: "/wo_picking_history", element: <WOPickingHistory />, title: "Riwayat Picking" },
  

  INSERT INTO sso_msmenu (app_id, rol_id, men_parent_id, men_nama, men_link, men_urutan, men_status, men_icon)
VALUES 
('APP01', 'ROL03', NULL, 'Estimasi BOM', 'wo_picking', 50, 'AKTIF', 'box'),
('APP01', 'ROL03', (SELECT men_id FROM sso_msmenu WHERE men_link='wo_picking' AND rol_id='ROL03'), 'List Estimasi', 'wo_picking', 1, 'AKTIF', 'list'),
('APP01', 'ROL03', (SELECT men_id FROM sso_msmenu WHERE men_link='wo_picking' AND rol_id='ROL03'), 'Riwayat Picking', 'wo_picking_history', 2, 'AKTIF', 'clock');