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 2 months ago. Updated 6 days ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
23 Apr 2026
Due date:
28 Apr 2026 (7 days late)
% Done:

100%

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

Subtasks 69 (0 open — 69 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

No data to display

Actions
Copy link

Also available in: Atom PDF