Switch factory
CYTO-11 — Balakong Jaya CTSB CYTO-29 CTSB CYTOWELL-54 — Taming Jaya PIC/S CTWSB CYTOCNGZ-602 — Guangzhou CTCNGZOnly factories you are granted appear here (Filament tenant menu).
Project Gaia — static mockup in Filament v3 table idiom. No backend. Sample data: Katana tenant snapshot 2026-04-12, all locations.
| Field | Filament component | Type | Source | FK target |
|---|---|---|---|---|
| (checkbox) | Table selection + DeleteBulkAction | selection | — (bulk delete of selected POs) | — |
| Created date | TextColumn::date()->sortable() + Filter (date range) | date | stored: purchase_orders.created_date; list sorted ascending by it | — |
| Order # | TextColumn::searchable(isIndividual)->url() | string | stored: purchase_orders.order_no (editable; NOT unique — PK is internal id) | — |
| Supplier | TextColumn::searchable(isIndividual) | string (display name) | stored: purchase_orders.supplier_id | suppliers.id |
| Currency · Payment | TextColumn::badge() (currency) + TextColumn (payment method) | enum + enum | stored: purchase_orders.currency + purchase_orders.payment_method — default from supplier; domestic MYR / bank_transfer, the China source CNY / Alipay. Lets purchasing scan channel at a glance | — |
| Total order value | TextColumn::numeric()->summarize(Sum) | money — order currency, MYR-consolidated | derived: Σ po_lines.qty × unit_price in order currency; foreign POs show the ¥ order amount with the MYR equivalent (order value × exchange_rate); the Sum summarizer and all totals stay in the entity base MYR. 0 MYR rows exist | po_lines |
| Expected arrival | TextColumn::date()->color(fn) red when overdue + Filter (date range) | date, editable | stored: purchase_orders.expected_arrival_date; red when past and not fully received | — |
| Billing status | TextColumn::badge() + SelectFilter (inline bill action in Katana) | enum: Billed / Partially billed (n) / Not billed | derived: netting attached supplier bills against order value; n = bill count | supplier_bills |
| Delivery | TextColumn::badge() + SelectFilter (inline receive action in Katana) | enum: Not received / Partially received | derived: received qty vs ordered qty across PO lines; fully received moves PO to Done tab | po_line_receipts |
| Location scope | SelectFilter (header "All locations" dropdown) | FK filter | stored: purchase_orders.location_id | locations.id |
| Draft tab | — (dropped: Draft view not captured) | lifecycle tab | Open/Draft/Done partition POs by lifecycle state | — |
Total: 458917.50 MYR under Total order value — sum across the 24 filtered Open rows, foreign POs converted to the MYR base at their PO exchange rate (Katana pins it above the data; Filament renders it as a tfoot summarizer).