0 ? home_url( '/?p=' . $id ) : ''; } } $aieo_bp_branch = static function ( $position, $table ) { return "SELECT '{$position}' AS `cart_position`, CONCAT('{$position}:', `id`) AS `row_uid`, `product_id`, `SKU` AS `sku`, `order_item_name` AS `name`, `Frequency` AS `frequency`, `menu_category`, `head_category`, `sub_category`, `stock` FROM {prefix}{$table}"; }; $aieo_bp_sql = implode( "\nUNION ALL\n", array( $aieo_bp_branch( 'first', 'aieo_order_products_freq_entry' ), $aieo_bp_branch( 'last', 'aieo_order_products_freq_exit' ), $aieo_bp_branch( 'only', 'aieo_order_products_freq_single_item_orders' ), ) ); return array( 'id' => 'insights_basket_position', 'label' => 'Basket position', 'description' => 'Which products open a basket, which are added last before checkout, and which are bought on their own.', 'group' => 'eshop_insights', 'section' => 'sales_reports', 'icon' => 'shopping-cart', 'tier' => 'pro', 'scope' => 'both', 'source' => 'sql', 'sql' => $aieo_bp_sql, 'registry_id' => 'insights_t6.first_in_cart', 'version' => '1', 'per_page' => 50, 'row_key' => 'row_uid', 'default_sort' => array( 'frequency', 'desc' ), 'empty_state' => 'No basket positions have been recorded yet. This report fills once the nightly analytics run has processed its first orders.', 'filter_bar' => array( 'first' => array( 'frequency', 'menu_category', 'head_category', 'sub_category' ) ), 'columns' => array( array( 'key' => 'row_uid', 'label' => 'Row', 'type' => 'code', 'hidden' => true, ), array( 'key' => 'cart_position', 'label' => 'Position', 'type' => 'badge', 'sortable' => true, 'filter' => 'select', 'format' => array( 'map' => array( 'first' => 'info', 'last' => 'warning', 'only' => 'success' ), 'labels' => array( 'first' => 'First in the basket', 'last' => 'Last before checkout', 'only' => 'The only product', ), ), ), array( 'key' => 'name', 'label' => 'Product', 'type' => 'link', 'format' => array( 'href' => 'aieo_basket_position_permalink' ), 'subline' => 'sku', 'sortable' => true, 'searchable' => true, 'filter' => 'text', 'truncate' => 52, 'tooltip' => true, 'empty' => '', ), array( 'key' => 'product_id', 'label' => 'ID', 'type' => 'id', 'sortable' => true, 'searchable' => true, 'filter' => 'number', ), array( 'key' => 'sku', 'label' => 'SKU', 'type' => 'code', 'searchable' => true, 'filter' => 'text', 'hidden' => true, ), array( 'key' => 'frequency', 'label' => 'Orders', 'type' => 'integer', 'sortable' => true, 'filter' => 'number_range', ), array( 'key' => 'product_state', 'label' => 'Product', 'type' => 'badge', 'select' => "CASE WHEN `name` IS NULL THEN 'removed' ELSE 'listed' END", 'sortable' => true, 'filter' => 'select', 'format' => array( 'map' => array( 'listed' => 'muted', 'removed' => 'danger' ), 'labels' => array( 'listed' => 'In the catalogue', 'removed' => 'No longer listed', ), ), ), array( 'key' => 'menu_category', 'label' => 'Menu category', 'type' => 'text', 'sortable' => true, 'filter' => 'multiselect', ), array( 'key' => 'head_category', 'label' => 'Head category', 'type' => 'text', 'sortable' => true, 'filter' => 'multiselect', ), array( 'key' => 'sub_category', 'label' => 'Sub category', 'type' => 'text', 'sortable' => true, 'filter' => 'multiselect', ), array( 'key' => 'stock', 'label' => 'Stock', 'type' => 'integer', 'sortable' => true, 'filter' => 'number_range', 'bands' => array( array( 'max' => -1, 'tone' => 'danger' ), array( 'min' => 0, 'max' => 0, 'tone' => 'muted' ), ), ), ), );