'preorder_audit_log', 'label' => 'Pre-order audit trail', 'description' => '', 'scope' => 'local', 'source' => 'sql', 'sql' => $aieo_pal_sql, 'registry_id' => 'supplier_orders.preorder_audit', 'version' => '1', 'per_page' => 25, 'row_key' => 'id', 'default_sort' => array( 'id', 'desc' ), 'empty_state' => 'No audit events yet. Rows appear as requests are submitted from the worksheets and moved through the approval queue.', 'columns' => array( array( 'key' => 'id', 'label' => 'ID', 'type' => 'id', 'sortable' => true, 'hidden' => true, ), array( 'key' => 'created_at', 'label' => 'When', 'type' => 'datetime', 'width' => '150px', 'nowrap' => true, 'sortable' => true, 'filter' => 'date_range', 'format' => array( 'tz' => 'utc' ), ), array( 'key' => 'user_name', 'label' => 'User', 'type' => 'text', 'filter' => 'select', ), array( 'key' => 'source', 'label' => 'Source', 'type' => 'badge', 'width' => '100px', 'filter' => 'select', 'format' => array( 'map' => array( 'worksheet' => 'info', 'queue' => 'muted', 'scanner' => 'info', ), ), ), array( 'key' => 'preorder_id', 'label' => 'Request', 'type' => 'id', 'width' => '80px', 'sortable' => true, ), array( 'key' => 'product', 'label' => 'Product', 'type' => 'text', 'searchable' => true, 'truncate' => 42, 'tooltip' => true, 'empty' => '—', ), array( 'key' => 'branch', 'label' => 'Branch', 'type' => 'text', 'filter' => 'select', 'empty' => '—', ), array( 'key' => 'from_status', 'label' => 'From', 'type' => 'badge', 'width' => '95px', 'format' => array( 'labels' => array( 'requested' => 'pending' ), 'map' => array( 'requested' => 'warning', 'approved' => 'info', 'ordered' => 'info', 'received' => 'success', 'rejected' => 'danger', ), ), 'empty' => '—', ), array( 'key' => 'to_status', 'label' => 'To', 'type' => 'badge', 'width' => '95px', 'filter' => 'select', 'format' => array( 'labels' => array( 'requested' => 'pending' ), 'map' => array( 'requested' => 'warning', 'approved' => 'info', 'ordered' => 'info', 'received' => 'success', 'rejected' => 'danger', ), ), 'empty' => '—', ), array( 'key' => 'qty_before', 'label' => 'Qty before', 'type' => 'integer', 'width' => '80px', 'empty' => '—', ), array( 'key' => 'qty_after', 'label' => 'Qty after', 'type' => 'integer', 'width' => '80px', 'empty' => '—', ), array( 'key' => 'note', 'label' => 'Note', 'type' => 'text', 'tone' => 'secondary', 'truncate' => 40, 'tooltip' => true, 'empty' => '', ), ), );