Tasks

Resource	MO #	MO deadline	Del. deadline	Product	Planned qty	Operation	Type	Planned time	Assigned to
Resource	MO #	MO deadline	Product	Planned/Actual qty	Operation	Type	Planned/actual time	Completed at	Completed by
—					pcs			—	Unassigned
—				/ pcs			... / ...		Unassigned
					124,338 pcs	Total planned qty (Sum summarizer — task-level, repeats MO qty per operation)
				65,163 / 68,640 pcs	Total actual / planned qty (dual Sum summarizer over all 36 done tasks in range)

Showing 1–17 of 17 open tasks Showing 1–19 of 36 done tasks (first 19 rows captured)

Per page

Project Gaia — static mockup in Filament v3 table idiom. No backend. Sample data: Katana tenant snapshot 2026-04-12, location 11, Balakong Jaya. Done view rows: New2 capture 2026-07-07 ('Completed at: Last 7 days' — 19 of 36 rows captured; totals are the full-range summarizer).

Tasks — field manifest

Field	Filament component	Type	Source	FK target
Checkbox / ⓘ	automatic with BulkActions (export / print)	ui	UI-only bulk select; header ⓘ tooltip slot dropped	—
Resource	TextColumn::placeholder('—') + SelectFilter	string, nullable	stored: task assignment to a production resource/workstation; unset on every captured row	resources.id
MO #	TextColumn::searchable(isIndividual: true)->url()	string	stored: FK parent MO; format 'SO # / line #' — NVMSB-0309 / 2 and / 3 are sibling MOs of one SO	manufacturing_orders.id
MO deadline	TextColumn::date()->sortable() (default sort asc) + Filter (date range)	date	derived: parent MO production deadline, repeated on every operation row	manufacturing_orders.id
Del. deadline	TextColumn::date() + Filter (date range)	date	derived: linked sales-order delivery deadline; same value across all rows of one MO — Open view only	sales_orders.id
Product	TextColumn::searchable(isIndividual: true)	string	derived: parent MO → product variant, 'name / variant'	variants.id
Planned qty	TextColumn::numeric()->summarize(Sum)	qty + UoM	derived: MO planned quantity repeated per operation row (total double-counts by design)	—
Operation	TextColumn::searchable(isIndividual: true)	string	stored: operation step from the product's routing (BOM recipe)	operations.id
Type	TextColumn::badge()->color(Process: blue, Setup: gray) + SelectFilter	enum	stored: operation cost type (Katana: Process vs Setup); every visible row = 'Process'	—
Planned time	TextColumn::placeholder('—')	duration, nullable	stored: planned duration from the operation definition; unset in this dataset	—
Assigned to	TextColumn::placeholder('Unassigned') + SelectFilter	string, nullable	stored: FK operator/team member; 'Unassigned' on every row	users.id
Status	IconColumn (hollow circle = Not started) + SelectFilter	enum	stored: task status; Open/Done view tabs partition on it — all 17 open tasks 'Not started'; Open view only	—
Planned/Actual qty (Done)	TextColumn::formatStateUsing('{actual} / {planned} pcs')->summarize(Sum ×2)	qty pair + UoM	stored: tasks.actual_qty captured at completion; planned derived from parent MO — dual Total 65,163 / 68,640 pcs	—
Planned/actual time (Done)	TextColumn::placeholder('... / ...')	duration pair, nullable	stored: tasks.actual_time vs planned duration from the operation; both unset on every captured row	—
Completed at (Done)	TextColumn::date()->sortable() (default sort desc) + Filter::make('completed_at') date range, default 'Last 7 days'	datetime	stored: tasks.completed_at — set when the task is marked done; the header range control scopes the whole view	—
Completed by (Done)	TextColumn::placeholder('Unassigned')	FK, nullable	stored: tasks.completed_by — user who marked the task done; nullable: every captured done row completed unassigned	users.id

Engine notes

Task explosion: each MO generates one task row per operation in the product's routing — NVMSB-0309 / 2 (Double Root Coffee) yields 5 rows, NVMSB-0309 / 3 (JuicyPop) 6, YGMSB-260401 / 7 (Yes Global Sunrise) 6 = 17 tasks.
MO # encodes provenance: 'SO number / SO row number' — MOs auto-created per sales-order line share the SO prefix.
Total 124338 pcs = Σ Planned qty over task rows (16800×5 + 5917×6 + 806×6) — it sums the same MO qty once per operation, i.e. a task-level not MO-level total.
MO deadline, Del. deadline, Product and Planned qty are denormalized from the parent MO / linked SO onto every operation row.
Default sort is MO deadline ascending, keeping each MO's operations contiguous and in routing order (Prepare → Packing → … → Cartoning).
List is scoped to the selected location (11, Balakong Jaya); switching location swaps the dataset.
Operation names and Type come from the product's production operations (recipe/BOM routing); Planned time would flow from operation duration but is unset here.
Done view swaps the column set: Del. deadline, Assigned to and Status drop; Planned/Actual qty, Planned/actual time, Completed at and Completed by appear. Default sort flips to Completed at descending and the 'Completed at' date-range control (default Last 7 days) scopes the list — 36 tasks in range.
Dual-sum Total 65,163 / 68,640 pcs = Σ actual / Σ planned over all 36 done tasks in the range; actual short of planned = yield loss (e.g. 2,947 / 3,000 on NVMSB-260629 / 1, 1,860 / 2,600 on YGMSB-260624 / 4).
A task can complete while unassigned — completed_by is nullable and every captured done row shows 'Unassigned'; completion is recorded on the task, not an operator assignment.
Katana allows Del. deadline earlier than MO deadline with no warning (open capture: NVMSB-260623 / 1 delivers 2026-07-07, production deadline 2026-07-14) — candidate Gaia late-risk badge.