'supplier_preorders_queue', 'label' => 'Recent staff pre-order signals', 'description' => '', 'scope' => 'local', 'source' => 'sql', 'sql' => $aieo_pq_sql, 'registry_id' => 'supplier_orders.recent_signals', 'version' => '1', 'per_page' => 50, 'row_key' => 'id', 'default_sort' => array( 'created_at', 'desc' ), 'empty_state' => 'No pre-order signals captured yet. Requests arrive from the branch worksheets (Submit requests) and from staff scans that record a requested quantity.', 'bulk_actions' => array( array( 'id' => 'reject', 'label' => 'Reject', 'scope' => 'filter', 'destructive' => true, 'confirm' => 'Reject %1$s pre-order lines? Open lines leave the outstanding totals and record that none were ordered; closed lines are skipped.', ), ), 'actions' => array( array( 'id' => 'approved', 'label' => 'Approve', 'when' => array( 'key' => 'can_approve', 'is' => '1' ), 'bulk' => 'filter', 'bulk_confirm' => 'Approve %1$s pre-order lines? Only lines still pending move; the rest are skipped.', ), array( 'id' => 'ordered', 'label' => 'Ordered', 'when' => array( 'key' => 'can_order', 'is' => '1' ), 'bulk' => 'filter', 'bulk_confirm' => 'Mark %1$s lines ordered? Pending and approved lines are stamped with a per-supplier batch reference for the XLSX and the email; other lines are skipped.', ), array( 'id' => 'received', 'label' => 'Received', 'variant' => 'primary', 'when' => array( 'key' => 'open_line', 'is' => '1' ), 'data' => array( 'preorder-qty' => 'requested_qty' ), 'ask' => array( 'name' => 'qty', 'label' => 'Received qty', 'value' => 'requested_qty', 'min' => 0, ), ), array( 'id' => 'rejected', 'label' => 'Reject', 'variant' => 'ghost', 'hook' => 'aieo-dmm-preorder-reject', 'destructive' => true, 'when' => array( 'key' => 'open_line', 'is' => '1' ), 'confirm_level' => 'off', 'confirm' => 'Reject this pre-order line? It leaves the outstanding totals and records that none were ordered.', ), ), 'columns' => array( array( 'key' => 'id', 'label' => 'ID', 'type' => 'id', 'sortable' => true, 'hidden' => true, ), array( 'key' => 'select', 'label' => '', 'type' => 'selector', 'width' => '28px', 'sortable' => false, 'select' => "''", ), array( 'key' => 'created_at', 'label' => 'When', 'type' => 'datetime', 'width' => '150px', 'nowrap' => true, 'sortable' => true, 'filter' => 'date_range', 'format' => array( 'tz' => 'utc' ), ), array( 'key' => 'branch', 'label' => 'Branch', 'type' => 'text', 'sortable' => true, 'filter' => 'select', ), array( 'key' => 'image_url', 'label' => '', 'sr_label' => 'Product image', 'type' => 'image', 'format' => array( 'size' => 44, 'rehost' => true ), 'width' => '58px', 'sortable' => false, 'empty' => '', ), array( 'key' => 'product', 'label' => 'Product', 'type' => 'text', 'sortable' => true, 'searchable' => true, 'truncate' => 42, 'tooltip' => true, ), array( 'key' => 'sku', 'label' => 'SKU', 'type' => 'code', 'searchable' => true, 'hidden' => true, ), array( 'key' => 'brand', 'label' => 'Brand', 'type' => 'text', 'sortable' => true, 'filter' => 'select', 'empty' => '—', ), array( 'key' => 'supplier', 'label' => 'Supplier', 'type' => 'text', 'sortable' => true, 'filter' => 'select', 'empty' => '— unresolved —', ), array( 'key' => 'prior_existing', 'label' => 'Had', 'type' => 'integer', 'width' => '64px', 'empty' => '—', ), array( 'key' => 'requested_qty', 'label' => 'Want', 'type' => 'integer', 'width' => '64px', 'sortable' => true, ), array( 'key' => 'status', 'label' => 'Status', 'type' => 'badge', 'width' => '100px', 'sortable' => true, 'filter' => 'select', 'format' => array( 'labels' => array( 'requested' => 'pending' ), 'map' => array( 'requested' => 'warning', 'approved' => 'info', 'ordered' => 'info', 'received' => 'success', 'rejected' => 'danger', ), ), ), array( 'key' => 'batch_ref', 'label' => 'Batch', 'type' => 'code', 'width' => '130px', 'sortable' => true, 'filter' => 'text', 'empty' => '—', ), array( 'key' => 'received_qty', 'label' => 'Received qty', 'type' => 'integer', 'hidden' => true, ), array( 'key' => 'approved_at', 'label' => 'Approved', 'type' => 'datetime', 'format' => array( 'tz' => 'utc' ), 'hidden' => true, ), array( 'key' => 'ordered_at', 'label' => 'Ordered at', 'type' => 'datetime', 'format' => array( 'tz' => 'utc' ), 'hidden' => true, ), array( 'key' => 'received_at', 'label' => 'Received at', 'type' => 'datetime', 'format' => array( 'tz' => 'utc' ), 'hidden' => true, ), array( 'key' => 'can_approve', 'label' => 'Can approve', 'type' => 'boolean', 'hidden' => true ), array( 'key' => 'can_order', 'label' => 'Can order', 'type' => 'boolean', 'hidden' => true ), array( 'key' => 'open_line', 'label' => 'Open', 'type' => 'boolean', 'hidden' => true ), array( 'key' => 'product_id', 'label' => 'Product ID', 'type' => 'id', 'hidden' => true ), ), );