'insights_order_patterns', 'label' => 'Order Patterns', 'description' => 'Every order with the customer, the channel it came through and what it was worth.', 'group' => 'eshop_insights', 'section' => 'sales_reports', 'icon' => 'calendar-clock', 'tier' => 'pro', 'scope' => 'both', 'source' => 'table', 'table' => '{prefix}aieo_order_stats', 'registry_id' => 'insights_t3.order_patterns', 'version' => '1', 'per_page' => 50, 'row_key' => 'orderid', 'default_sort' => array( 'orderdatetime', 'desc' ), 'requires_hpos' => true, 'empty_state' => 'No orders have been recorded yet. This report fills once the nightly analytics run has processed its first orders.', 'columns' => array( array( 'key' => 'orderid', 'label' => 'Order', 'type' => 'id', 'sortable' => true, 'searchable' => true, ), array( 'key' => 'orderdatetime', 'label' => 'Placed', 'type' => 'datetime', 'format' => array( 'tz' => 'utc' ), 'sortable' => true, 'filter' => 'date_range', ), array( 'key' => 'customeremail', 'label' => 'Customer', 'type' => 'text', 'subline' => 'customer_name', 'sortable' => true, 'searchable' => true, 'truncate' => 38, 'tooltip' => true, ), array( 'key' => 'customer_name', 'label' => 'Name', 'select' => "TRIM(CONCAT(COALESCE(firstname,''),' ',COALESCE(lastname,'')))", 'hidden' => true, ), array( 'key' => 'city', 'label' => 'City', 'type' => 'text', 'sortable' => true, 'searchable' => true, 'filter' => 'text', ), array( 'key' => 'numberofitemsperorder', 'label' => 'Items', 'type' => 'integer', 'sortable' => true, ), array( 'key' => 'orderspend', 'label' => 'Order total', 'type' => 'money', 'sortable' => true, 'aggregate' => 'SUM', ), array( 'key' => 'netspendonproducts', 'label' => 'Net on products', 'type' => 'money', 'sortable' => true, 'aggregate' => 'SUM', ), array( 'key' => 'totalshipping', 'label' => 'Shipping', 'type' => 'money', 'sortable' => true, 'aggregate' => 'SUM', ), array( 'key' => 'paymenttype', 'label' => 'Payment', 'type' => 'text', 'sortable' => true, 'filter' => 'select', ), array( 'key' => 'ordersource', 'label' => 'Source', 'type' => 'text', 'sortable' => true, 'filter' => 'select', 'truncate' => 24, 'tooltip' => true, ), array( 'key' => 'orderstatus', 'label' => 'Status', 'type' => 'badge', 'sortable' => true, 'filter' => 'select', 'format' => array( 'map' => array( 'wc-completed' => 'success', 'completed' => 'success', 'wc-processing' => 'info', 'processing' => 'info', 'wc-cancelled' => 'danger', 'cancelled' => 'danger', 'wc-refunded' => 'danger', 'refunded' => 'danger', 'wc-on-hold' => 'warning', 'on-hold' => 'warning', ), ), ), ), 'aggregates' => array( 'orderid' => 'COUNT', ), );