ktools4 — Build Progress

📌 Parked for later — after live testing & a settling-in period

Noted 2026-10-07. Pick these up once live testing is done and the system has been modified/settled for a while:

Rotate secrets — the exposed OpenAI key, DB credentials and GRTC key (move any left in code into env config).
Row-count reconciliation between the legacy DB and KTools 4, and finish the IMPORT_DATA.md coverage table (rows still Waiting/Partial).
Backup restore rehearsal on the live system during a calm period, not in an emergency.
Refresh this tracker — Phase 4 still shows the Game Hub/HUD (L5) as not done and Phase 5 doesn't reflect the 2026-10-04 cutover.

Overall Progress

76%

39 of 51 milestones complete across 6 phases

👉

Next up — Phase 2: Scanner / Public Station
Wire remaining nav pages (Case Pack, Pick List, Supply, Days Off, Labels, Manual, Prep List, Reports, Message)

Plan, Tracker, Mockups Done

Written plan, viewable tracker, and a refined admin mockup — approved.

7/7

Plan document → Refined admin mockup → Dev showcase hub →

✓ Write plan doc (docs/PLAN.md)
✓ Build progress.php v1
✓ Refine admin-panel.html: collapsible sidebar accordion
✓ Add theme switcher scaffold (Slate/Midnight/Ocean/Forest)
✓ Restore Help Guide / Live Help links
✓ Mock up 2-3 more admin subpages (Orders, Warehouse Legends hub, Reports)
✓ Kris reviews and approves Phase 0 deliverables

Schema + Migration Framework Done

29 core tables + 5 seed sets applied cleanly to the local ktools4 database, with 43 real foreign keys.

10/10

Migration framework design → Target schema entities → MigrationRunner source →

✓ Build MigrationRunner + ensureColumn/ensureIndex/ensureForeignKey helpers
✓ Build bin/migrate.php (status | up)
✓ Migrate identity core: skus, sku_identifiers
✓ Migrate order_types + remote_lists
✓ Migrate inventory_events, relabel_events, orders, shipments, problem_types
✓ Migrate templates & supplies cluster
✓ Migrate unified misfits cluster
✓ Migrate preppers, users, permissions cluster
✓ Seed reference data (order_types, permissions_list, problem_types, misfit_categories, supply_types)
✓ php bin/migrate.php status shows everything applied cleanly

Scanner / Public Station In Progress

Scan-to-save cycle now matches legacy functional behavior (case-pack vs individual branching, templates, shrinker defaults, hazmat flagging, prep-time, camera scan), verified live. Remaining 16-item nav pages still to build.

10/11

Live scanner page → public-clean.html mockup → public-futuristic.html mockup →

✓ Build app/domain/Inventory (sku resolution via sku_identifiers)
✓ Wire Save Record + Search + View to real ktools4 data
✓ Wire order_types/remote_lists to the live GRTC API for fba/haz/awd/wfs
✓ Restore legacy functional parity: case-pack vs individual branching, template auto-create, master-case/back-in-box supply tracking
✓ Restore shrinker settings persistence (opt-in SKU/template defaults) + prep-time tracking
✓ Restore hazmat-mismatch flagging + missing-title admin notifications
✓ Restore confirm-before-submit flow, cookie-based prepper name, seasonal freeze checkbox, duplicate-active-box warning
✓ Wire Misfits station (single entry, rapid batch scanner, auto-lookup, audio feedback, warehouse directory)
✓ Wire Damage Out station (barcode lookup, image preview, reason/disposition logging, queue duplicates & live feed)
Wire remaining nav pages (Case Pack, Pick List, Supply, Days Off, Labels, Manual, Prep List, Reports, Message)
✓ A prepper can complete a full scan-to-save cycle for every order type

Admin Panel In Progress

Admin shell and operational pages are built. Hosted acceptance and remaining game work are still required before cutover.

4/6

Refined admin mockup →

✓ Build real admin shell (topbar, accordion sidebar, theme switcher)
✓ Wire Dashboard KPIs + inventory table to real data
✓ Wire Active Orders, Warehouse Legends hub, Prep Time report to real data
✓ Rebuild permissions_list/role_permissions/user_permissions gating
Fill remaining sidebar sections, daily-used ones first
Admin can run day-to-day ops in ktools4 without the legacy app

Gamification (Warehouse Legends) In Progress

Warehouse Legends 3.0: legacy game + Gemini proposal combined (dev/pg/BUILD_PLAN.md). Database-driven; every rule, number and piece of content is managed in Admin → Warehouse Legends.

5/9

Warehouse Legends 3.0 build plan → Game Manual (feature docs) →

✓ Schema: 38 wl_* tables, ledger-centric (schema 0089)
✓ Default content: 466 definitions from the legacy game + Gemini additions, granular permissions (seed 0061)
✓ Admin → Warehouse Legends: 13 pages, editor for every content type, settings, rounds, Power Hours, claims, ledger undo, drafts, import/export
✓ Game Manual: 46 feature docs with live numbers + generated Content Catalog
✓ Legacy import: content + exclusions only (fresh start); Reset keeps game definitions
Scoring engine (outbox, Momentum, roles, rounds, Titan, daily rollups) — L2
Prepper Game Hub, Legends chip, station HUD — L5
Live Help content drafting, notifications — L4/L6
Warehouse Legends fully playable and admin-manageable in ktools4

ETL + Go-Live Cutover In Progress

One-time legacy data import, secrets cleanup, and production cutover.

3/8

ETL design →

✓ Legacy import: admin/import-data.php + bin/import_data.php (read-only legacy snapshot, one-transaction import, reset and repeat; see docs/IMPORT_DATA.md)
✓ GRTC on/off switch (off after every import until cutover)
Every legacy table imported or justified (coverage table in docs/IMPORT_DATA.md shows nothing left under Waiting / Partial)
Row-count reconciliation between onnyfsmy_jon and ktools4
✓ Orphan-check against the new schema (modeled on data_optimization.php)
Decide production DB name / cutover mechanism
Move all secrets to env config and rotate them (DB creds, GRTC key, exposed OpenAI key)
Run production cutover; retire legacy app to read-only archive