Project

General

Profile

Actions
Copy link

Project progress work #6739

open

Parent project #6731: [PJ260035] Traceability system for TOYO ADVANCED

[Coding]

Added by Waraporn Promsopa 4 months ago. Updated about 4 hours ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
20 Apr 2026
Due date:
18 Jun 2026 (1 day late)
% Done:

100%

Estimated time:
(Total: 1000.00 h)
Finish date:
Programming skills:
No development
DB skills:
Not using
OS skills:
Not using

Subtasks 113 (0 open — 113 closed)

Project progress work #7240: [Coding] Explore existing ToyoAdvance DB (12 per-model-per-machine measurement tables)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7241: [Coding] Create isolated dev DB ToyoAdvance_DEV with clone of 12 tester tablesClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7242: [Coding] Write DDL traceability_layer1.sql (rerunnable IF OBJECT_ID DROP pattern)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7243: [Coding] Create master_model table + seed 6 rows (FZ1/FZ2/FZA2/FZAC/FZN2/FZNC)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7244: [Coding] Create master_machine table + seed 2 rows (A=OP440-1, B=OP440-2)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7245: [Coding] Create master_ng table + seed 6 reasons (Marking/Dent/Shrinkage/Sealing/QC/Other)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7246: [Coding] Create cart table (cart_no PK, current_status workflow EMPTY/IN_PROGRESS/HOLD/COMPLETE/SHIPPED)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7247: [Coding] Create production_log table (part_serial UNIQUE, polymorphic tester_lot_id)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7248: [Coding] Create part_switch table (cart_no, old_serial, new_serial, switched_at)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7249: [Coding] Create shipping + shipping_cart tables (1 shipping → N carts)ClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7250: [Coding] Create user_sessions table for Bearer token authClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7251: [Coding] Fix typo bug FZ1 table column "Max_Tourqe" → "Max_Torque" before productionClosedNatthakit Saengrungrat23 Apr 202623 Apr 2026

Actions
Project progress work #7252: [Coding] Android project scaffold (Gradle 8.4, Kotlin 1.9.22, AGP 8.2.2, minSdk 29, arm64-v8a)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7253: [Coding] Build verification — assembleDebug success on BT-A500 firmwareClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7254: [Coding] LoginActivity layout + mock auth (admin/admin) → real bcrypt API integrationClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7255: [Coding] Session.kt utility (in-memory user, cleared on logout/process death)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7256: [Coding] ApiClient.kt — coroutine-based HttpURLConnection, X-API-KEY, response shape standardizeClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7257: [Coding] Config.kt SharedPreferences (server/path/user/pass/plc_host/plc_port)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7258: [Coding] MainMenuActivity (Production/Shipping buttons + back arrow logout, blocks back-to-login)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7259: [Coding] SettingsActivity — 7-tap title trigger from LoginActivity only (INABA pattern)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7260: [Coding] ScannerBaseActivity (keyboard wedge — hidden EditText + TextWatcher dispatch onScan)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7261: [Coding] ConfirmPopup.kt utility (blue popup, HtmlCompat for yellow QTY display)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7262: [Coding] ProductionMenuActivity (5 buttons: Production/Switching Part/QC/Return/NG)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7263: [Coding] ProductionHistoryActivity 3-color cards (HOLD=yellow, IN_PROGRESS=blue, COMPLETE=green) + onResume syncClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7264: [Coding] SelectMachineActivity (A/B picker)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7265: [Coding] SelectPartActivity (6 model picker FZ1-FZNC)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7266: [Coding] ScanCartActivity Start mode (scan cart → confirm popup → PLC + API)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7267: [Coding] ScanCartActivity Hold mode (scan cart → blue popup "Hold the Production?")ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7268: [Coding] ScanCartActivity Resume mode (Un-Hold scan cart match guard + popup)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7269: [Coding] ProductionLiveActivity — polling /production/rows every 5s, OK=green/NG=red row fillClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7270: [Coding] ProductionLiveActivity Finish flow with QTY popup (Yellow QTY + Successfully)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7271: [Coding] SwitchingPartActivity (cart + 2 serials, used by both Production + Shipping menu)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7272: [Coding] QcPartActivity (cart + serial, status=QC, result=OK)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7273: [Coding] ReturnPartActivity (cart + serial, supports cross-cart move QC→N)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7274: [Coding] NgPartActivity (cart + serial + 6-reason dropdown + Other remark, 2-col EN/TH layout)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7275: [Coding] ShippingMenuActivity (Shipping + Switching)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7276: [Coding] ShippingActivity (kanban CSV scan → loop scan N carts → auto-COMPLETE)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7277: [Coding] ShippingSwitchingMenuActivity (Switching Cart + Switching Part)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7278: [Coding] ShippingSwitchCartActivity (kanban + old cart + new cart)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7279: [Coding] ErrorOverlay.kt utility (Red "Shipping not found" + Yellow "Check Part Number")ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7280: [Coding] HostLinkClient.kt — TCP socket + Upper Link ASCII (writeWord/Dword/Ascii, readWord, setBit, resetBit)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7281: [Coding] PlcClient.kt R1 register map (DM block write + LR handshake bit)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7282: [Coding] PlcClient.testConnection() integration into Settings Test buttonClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7283: [Coding] KV-8000 Upper Link syntax fix — bare ST LR1000 (not .0 suffix), unsigned .D writeClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7284: [Coding] Fix fetchProductionRows blocking Main thread → wrap withContext(Dispatchers.IO)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7285: [Coding] Fix Hold/Finish navigating to wrong activity → use FLAG_ACTIVITY_CLEAR_TOP to HistoryClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7286: [Coding] UI touch-up: table header navy → gray (#B8B8B8) per user feedbackClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7287: [Coding] UI touch-up: NG reasons 3-col → 2-col EN/TH stacked (Thai wrap fix)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7288: [Coding] UI touch-up: remove permanent-yellow primary buttons on sub-menusClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7289: [Coding] Update PlcClient.kt to R2 register map (Lot 5w ASCII, Test No+6, OP Name+8, Cart+18, OP ID+19, Part No+20)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7290: [Coding] Add ALWAYS-ON handshake polling (ST LR+0 → poll LR+1 5s timeout → RS LR+0)ClosedNatthakit Saengrungrat24 Apr 202624 Apr 2026

Actions
Project progress work #7291: [Coding] Backend scaffold /toyo-advanced/handy_api.php (isolated from MVC scaffold)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7292: [Coding] .env loading + db.php sqlsrv connection helperClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7293: [Coding] Bearer token auth wrapper + user_sessions integrationClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7294: [Coding] /api/ping + /api/login (bcrypt password_verify) + /api/logoutClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7295: [Coding] /api/production/start (cart MERGE + lot_id DDMMYY-{cart} generate)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7296: [Coding] /api/production/hold + /api/production/resume + /api/production/finishClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7297: [Coding] /api/production/rows (whitelisted table name + LEFT JOIN production_log)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7298: [Coding] /api/cart/active + /api/cart/partsClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7299: [Coding] /api/part/switch + /api/part/qc + /api/part/return + /api/part/ngClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7300: [Coding] /api/master/ng (NG reason dropdown source)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7301: [Coding] /api/shipping/scan-kanban (CSV parse 13 fields + upsert by serial+date)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7302: [Coding] /api/shipping/scan-cart (auto-COMPLETE on full seq + model match guard)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7303: [Coding] /api/shipping/detail + /api/shipping/find-by-kanban + /api/shipping/switch-cartClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7304: [Coding] /api/docs Swagger UI (23 endpoints catalog)ClosedNatthakit Saengrungrat25 Apr 202625 Apr 2026

Actions
Project progress work #7305: [Coding] Scanner architecture rewrite (Keyence SDK, debounce, lock, race-fix)ClosedNatthakit Saengrungrat27 Apr 202627 Apr 2026

Actions
Project progress work #7306: [Coding] UI alignment with spec (3 visual fixes) + BT-A2000 device supportClosedNatthakit Saengrungrat27 Apr 202627 Apr 2026

Actions
Project progress work #7307: [Coding] Real PLC test + W129 root-cause + 16-step playbook re-verificationClosedNatthakit Saengrungrat27 Apr 202627 Apr 2026

Actions
Project progress work #7308: [Coding] Add auto update appClosedNatthakit Saengrungrat28 Apr 202628 Apr 2026

Actions
Project progress work #7373: [Coding] Keyence SDK v1.3.1 upgrade (BT-A2000 lineup) + scanner arch v2 (process-level listener, value-based debounce, race-fix) + device setup scriptClosedNatthakit Saengrungrat05 May 202605 May 2026

Actions
Project progress work #8258: [Coding] Internal TestClosedNattapong Sukcharoen18 May 202618 May 2026

Actions
Project progress work #8285: [Coding] Add R2 menus: Hold/Un-Hold Part, Shipping Hold Cart, Switching NG, Fulfil PartClosedNatthakit Saengrungrat19 May 202619 May 2026

Actions
Project progress work #8286: [Coding] Migrate handy_api business logic to 26 stored procedures with transaction + race-condition handlingClosedNatthakit Saengrungrat19 May 202619 May 2026

Actions
Project progress work #8287: [Coding] Fix part hold duplicate row when part was switched + tag_serial overflow on Switching NGClosedNatthakit Saengrungrat19 May 202619 May 2026

Actions
Project progress work #8288: [Coding] BuildConfig defaults and Login pre-flight to prevent prod to staging data leakClosedNatthakit Saengrungrat20 May 202620 May 2026

Actions
Project progress work #8289: [Coding] Fix qty_ok showing 0 on History by wiring qtyOkSnapshot from cart activeClosedNatthakit Saengrungrat20 May 202620 May 2026

Actions
Project progress work #8290: [Coding] Fix Date showing today by using first_scan_at via parseServerDateClosedNatthakit Saengrungrat20 May 202620 May 2026

Actions
Project progress work #8291: [Coding] Wire Date From and Date To filter on Production HistoryClosedNatthakit Saengrungrat20 May 202620 May 2026

Actions
Project progress work #8292: [Coding] Deep Teal header for Shipping flow and dual flow swap on SwitchingPartClosedNatthakit Saengrungrat20 May 202620 May 2026

Actions
Project progress work #8293: [Coding] Settings Card style redesign with 3 sections and button hierarchyClosedNatthakit Saengrungrat20 May 202620 May 2026

Actions
Project progress work #8294: [Coding] QC Pool architecture N to Q to Return/NG state machine + audit columns (picked_at/by, resolved_at/by, qc_resolution)ClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8295: [Coding] NG menu refactor, submenu (Cart / QC Part) + "Product NG" reason picker screen + QC Operating listClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8296: [Coding] Add hold_source columns (production_log + cart), track PRODUCTION vs SHIPPING origin on all Hold opsClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8297: [Coding] List filter consistency 5 activities (QcPart, ReturnPart, NgCart, HoldUnhold, Fulfil, Switching), hide NG/MOVED/QC rowsClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8298: [Coding] Cross-cart Return Part scan part only, no cart context, SP auto-derives source cartClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8299: [Coding] Fix cart_parts qty_ok authoritative (from cart.qty_ok) + UNION cross-cart rows + MOVED row serial-fallback JOINClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8300: [Coding] Production History card color reflects held_part_count + hide Start Production in Hold modesClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8301: [Coding] Bidirectional Switching Part swap (source cart bookkeeping symmetric, both carts reflect change)ClosedNatthakit Saengrungrat22 May 202622 May 2026

Actions
Project progress work #8302: [Coding] Shipping NG-gate, block cart with qty_ng greater than 0 from shipping scan (safety)ClosedNatthakit Saengrungrat25 May 202625 May 2026

Actions
Project progress work #8303: [Coding] NG Cart qty semantics revision, qty_ok unchanged on N to NG and qty_ng tracks defects (physical count of cart kept)ClosedNatthakit Saengrungrat25 May 202625 May 2026

Actions
Project progress work #8304: [Coding] Switching Part NG transfer, defective part NG flag follows the swapped part to source cart (refinement of bidirectional swap)ClosedNatthakit Saengrungrat25 May 202625 May 2026

Actions
Project progress work #8305: [Coding] Production Live filter NG rows at SP source, system ingests only OK parts from tester / PLCClosedNatthakit Saengrungrat25 May 202625 May 2026

Actions
Project progress work #8306: [Coding] Confirm and Clear bottom bar pattern across 8 activities (QcPart, ReturnPart, HoldUnhold, NgCart, NgFromQc, FulfilPart, SwitchingPart, Shipping, SwitchingCart)ClosedNatthakit Saengrungrat25 May 202625 May 2026

Actions
Project progress work #8307: [Coding] Unify Fulfil Part as Return Part, same SP and same global QC pool UI and same audit columnsClosedNatthakit Saengrungrat25 May 202625 May 2026

Actions
Project progress work #8467: [Coding] Program PLC DevlopmentClosedNattapong Sukcharoen20 Apr 202624 Apr 2026

Actions
Project progress work #8584: [Coding] Success popup after action confirm, all PDA screens + E2E test on demoClosedNatthakit Saengrungrat09 Jun 202609 Jun 2026

Actions
Project progress work #8585: [Coding] Fix 2-PDA status mismatch + live qty on History cardClosedNatthakit Saengrungrat10 Jun 202610 Jun 2026

Actions
Project progress work #8586: [Coding] Day-guard vs tester buffer replay + clean phantom rows from prod DBClosedNatthakit Saengrungrat10 Jun 202610 Jun 2026

Actions
Project progress work #8587: [Coding] SP guard hardening: Finish cap at target + serial dedup + date window + auth active-userClosedNatthakit Saengrungrat11 Jun 202611 Jun 2026

Actions
Project progress work #8588: [Coding] Install APK + prod config both PDAs, DEMO badge + over-target warningClosedNatthakit Saengrungrat11 Jun 202611 Jun 2026

Actions
Project progress work #8596: [Coding] Fix shipping manifest to canonical OK count include cross cart parts block short and double deliveryClosedNatthakit Saengrungrat16 Jun 202616 Jun 2026

Actions
Project progress work #8597: [Coding] Fix missing status guards on Finish Hold Resume and shipping prevent shipped cart resurrectClosedNatthakit Saengrungrat16 Jun 202616 Jun 2026

Actions
Project progress work #8598: [Coding] Fix switching NG and part switch source detection and re pick guards on QC NG return reworkClosedNatthakit Saengrungrat16 Jun 202616 Jun 2026

Actions
Project progress work #8599: [Coding] Fix PDA confirm cancel deadlock hide ghost rows recompile part fulfil and cap device noClosedNatthakit Saengrungrat17 Jun 202617 Jun 2026

Actions
Project progress work #8600: [Coding] Add orphan returned parts support NG QC rework and switchClosedNatthakit Saengrungrat17 Jun 202617 Jun 2026

Actions
Project progress work #8601: [Coding] Fix held part cannot ship as good block switch out donor and NG switchClosedNatthakit Saengrungrat17 Jun 202617 Jun 2026

Actions
Project progress work #8602: [Coding] Fix cart turns green only after Finish at Live NG and QC drop it to in progressClosedNatthakit Saengrungrat17 Jun 202617 Jun 2026

Actions
Project progress work #8603: [Coding] Add Shipping popups teal theme and back from Live returns to HistoryClosedNatthakit Saengrungrat17 Jun 202617 Jun 2026

Actions
Project progress work #8604: [Coding] Test all production and shipping flows ClosedNatthakit Saengrungrat17 Jun 202617 Jun 2026

Actions
Project progress work #8605: [Coding] Add cart overflow carryover to next cart at start same machine and modelClosedNatthakit Saengrungrat18 Jun 202618 Jun 2026

Actions
Project progress work #8606: [Coding] Fix same cart return full guard block over target on refillClosedNatthakit Saengrungrat18 Jun 202618 Jun 2026

Actions
Project progress work #8607: [Coding] Fix last activity timestamp UTC to local for history sort and date filterClosedNatthakit Saengrungrat18 Jun 202618 Jun 2026

Actions
Project progress work #8643: [Coding] Create web developement (wait update code to server)ClosedWorawit Khantamool20 Apr 202627 May 2026

Actions

No data to display

Actions
Copy link

Also available in: Atom PDF