Woocommerce Subscriptions List Table PHP Error
-
I’m getting the following error in the WP Dashboard above the Subscriptions List..
Warning: Invalid argument supplied for foreach() in /home/primal/public_html/wp-content/plugins/woocommerce-subscriptions/classes/class-wc-subscriptions-list-table.php on line 559I’m assuming it has to do with the New WordPress Version Update??
Here is a copy of the PHP file in question:
<?php /** * Subscriptions List Table * * Extends the WP_List_Table class to create a table for displaying sortable subscriptions. * * @package WooCommerce Subscriptions * @subpackage WC_Subscriptions_List_Table * @category Class * @author Brent Shepherd */ if ( ! class_exists( 'WP_List_Table' ) ) { require_once( ABSPATH . 'wp-admin/includes/class-wp-list-table.php' ); } class WC_Subscriptions_List_Table extends WP_List_Table { var $message_transient_prefix = '_subscriptions_messages_'; static $shutdown_notice_shown = false; /** * Create and instance of this list table. * * @since 1.0 */ public function __construct(){ parent::__construct( array( 'singular' => 'subscription', 'plural' => 'subscriptions', 'ajax' => false ) ); $this->process_actions(); // Check if the table caused a fatal error and if so, set flags to disable certain features add_action( 'shutdown', array( &$this, 'handle_fatal_errors' ) ); } /** * Outputs the content for each column. * * @param array $item A singular item (one full row's worth of data) * @param array $column_name The name/slug of the column to be processed * @return string Text or HTML to be placed inside the column <td> * @since 1.0 */ public function column_default( $item, $column_name ){ global $woocommerce; $current_gmt_time = gmdate( 'U' ); $column_content = ''; switch( $column_name ){ case 'status': $actions = array(); $action_url = add_query_arg( array( 'page' => $_REQUEST['page'], 'user' => $item['user_id'], 'subscription' => $item['subscription_key'], '_wpnonce' => wp_create_nonce( $item['subscription_key'] ) ) ); if ( isset( $_REQUEST['status'] ) ) { $action_url = add_query_arg( array( 'status' => $_REQUEST['status'] ), $action_url ); } $order = new WC_Order( $item['order_id'] ); $all_statuses = array( 'active' => __( 'Reactivate', 'woocommerce-subscriptions' ), 'on-hold' => __( 'Suspend', 'woocommerce-subscriptions' ), 'cancelled' => __( 'Cancel', 'woocommerce-subscriptions' ), 'trash' => __( 'Trash', 'woocommerce-subscriptions' ), 'deleted' => __( 'Delete Permanently', 'woocommerce-subscriptions' ), ); foreach ( $all_statuses as $status => $label ) { if ( WC_Subscriptions_Manager::can_subscription_be_changed_to( $status, $item['subscription_key'], $item['user_id'] ) ) { $action = ( 'deleted' == $status ) ? 'delete' : $status; // For built in CSS $actions[ $action ] = sprintf( '<a href="%s">%s</a>', esc_url( add_query_arg( 'new_status', $status, $action_url ) ), $label ); } } if ( $item['status'] == 'pending' ) { unset( $actions['active'] ); unset( $actions['trash'] ); } elseif( ! in_array( $item['status'], array( 'cancelled', 'expired', 'switched', 'suspended' ) ) ) { unset( $actions['trash'] ); } $actions = apply_filters( 'woocommerce_subscriptions_list_table_actions', $actions, $item ); $column_content = sprintf( '<mark class="%s">%s</mark> %s', sanitize_title( $item[ $column_name ] ), WC_Subscriptions_Manager::get_status_to_display( $item[ $column_name ], $item['subscription_key'], $item['user_id'] ), $this->row_actions( $actions ) ); $column_content = apply_filters( 'woocommerce_subscriptions_list_table_column_status_content', $column_content, $item, $actions, $this ); break; case 'title' : //Return the title contents $column_content = sprintf( '<a href="%s">%s</a>', get_edit_post_link( $item['product_id'] ), WC_Subscriptions_Order::get_item_name( $item['order_id'], $item['product_id'] ) ); $order = new WC_Order( $item['order_id'] ); $order_item = WC_Subscriptions_Order::get_item_by_product_id( $order, $item['product_id'] ); $product = $order->get_product_from_item( $order_item ); if ( isset( $product->variation_data ) ) { $column_content .= '<br />' . woocommerce_get_formatted_variation( $product->variation_data, true ); } break; case 'order_id': $order = new WC_Order( $item[ $column_name ] ); $column_content = sprintf( '<a href="%1$s">%2$s</a>', get_edit_post_link( $item[ $column_name ] ), sprintf( __( 'Order %s', 'woocommerce-subscriptions' ), $order->get_order_number() ) ); break; case 'user': $user = get_user_by( 'id', $item['user_id'] ); if ( is_object( $user ) ) { $column_content = sprintf( '<a href="%s">%s</a>', admin_url( 'user-edit.php?user_id=' . $user->ID ), ucfirst( $user->display_name ) ); } break; case 'start_date': case 'expiry_date': case 'end_date': if ( $column_name == 'expiry_date' && $item[ $column_name ] == 0 ) { $column_content = __( 'Never', 'woocommerce-subscriptions' ); } else if ( $column_name == 'end_date' && $item[ $column_name ] == 0 ) { $column_content = __( 'Not yet ended', 'woocommerce-subscriptions' ); } else { $gmt_timestamp = strtotime( $item[ $column_name ] ); $user_timestamp = $gmt_timestamp + ( get_option( 'gmt_offset' ) * 3600 ); $column_content = sprintf( '<time>%s</time>', date_i18n( woocommerce_date_format(), $user_timestamp ) ); } break; case 'trial_expiry_date': $trial_expiration = WC_Subscriptions_Manager::get_trial_expiration_date( $item['subscription_key'], $item['user_id'], 'timestamp' ); if ( empty($trial_expiration) ) { $column_content = '-'; } else { $column_content = sprintf( '<time title="%s">%s</time>', esc_attr( $trial_expiration ), date_i18n( woocommerce_date_format(), ( $trial_expiration + get_option( 'gmt_offset' ) * 3600 ) ) ); } break; case 'last_payment_date': // Although we record the sign-up date as a payment, if there is a free trial and no sign-up fee, no payment is actually charged if ( 0 == WC_Subscriptions_Order::get_total_initial_payment( $item['order_id'] ) && 1 == count( $item['completed_payments'] ) ) { $column_content = '-'; } else { $last_payment_timestamp = strtotime( $item['last_payment_date'] ); $time_diff = $current_gmt_time - $last_payment_timestamp; if ( $time_diff > 0 && $time_diff < 7 * 24 * 60 * 60 ) { $last_payment = sprintf( __( '%s ago', 'woocommerce-subscriptions' ), human_time_diff( $last_payment_timestamp, $current_gmt_time ) ); } else { $last_payment = date_i18n( woocommerce_date_format(), $last_payment_timestamp + get_option( 'gmt_offset' ) * 3600 ); } $column_content = sprintf( '<time title="%s">%s</time>', esc_attr( $last_payment_timestamp ), $last_payment ); } break; case 'next_payment_date': $next_payment_timestamp_gmt = WC_Subscriptions_Manager::get_next_payment_date( $item['subscription_key'], $item['user_id'], 'timestamp' ); $next_payment_timestamp = $next_payment_timestamp_gmt + get_option( 'gmt_offset' ) * 3600; if ( $next_payment_timestamp_gmt == 0 ) { $column_content = '-'; } else { // Convert to site time $time_diff = $next_payment_timestamp_gmt - $current_gmt_time; if ( $time_diff > 0 && $time_diff < 7 * 24 * 60 * 60 ) { $next_payment = sprintf( __( 'In %s', 'woocommerce-subscriptions' ), human_time_diff( $current_gmt_time, $next_payment_timestamp_gmt ) ); } else { $next_payment = date_i18n( woocommerce_date_format(), $next_payment_timestamp ); } $column_content = sprintf( '<time class="next-payment-date" title="%s">%s</time>', esc_attr( $next_payment_timestamp ), $next_payment ); if ( WC_Subscriptions_Manager::can_subscription_be_changed_to( 'new-payment-date', $item['subscription_key'], $item['user_id'] ) ) { $column_content .= '<div class="edit-date-div row-actions hide-if-no-js">'; $column_content .= '<img class="date-picker-icon" src="' . admin_url( 'images/date-button.gif' ) . '" title="' . __( 'Date Picker Icon', 'woocommerce-subscriptions' ) . '" />'; $column_content .= '<a href="#edit_timestamp" class="edit-timestamp" tabindex="4">' . __( 'Change', 'woocommerce-subscriptions' ) . '</a>'; $column_content .= '<div class="date-picker-div hide-if-js">'; $column_content .= WC_Subscriptions_Manager::touch_time( array( 'date' => date( 'Y-m-d', $next_payment_timestamp ), 'echo' => false, 'multiple' => true, 'include_time' => false ) ); $column_content .= '</div>'; $column_content .= '</div>'; } } break; case 'renewal_order_count': $count = WC_Subscriptions_Renewal_Order::get_renewal_order_count( $item['order_id'] ); $column_content = sprintf( '<a href="%1$s">%2$d</a>', admin_url( 'edit.php?post_status=all&post_type=shop_order&_renewal_order_parent_id=' . absint( $item['order_id'] ) ), $count ); break; } return apply_filters( 'woocommerce_subscriptions_list_table_column_content', $column_content, $item, $column_name ); } /** * Make sure the subscription key and user id are included in checkbox column. * * @see WP_List_Table::::single_row_columns() * @param array $item A singular item (one full row's worth of data) * @return string Markup to be placed inside the column <td> * @since 1.0 */ public function column_cb( $item ){ return sprintf( '<input type="checkbox" class="subscription_key" name="subscription_keys[%1$s][]" value="%2$s" />', $item['user_id'], $item['subscription_key'] ); } /** * Add all the Subscription field columns to the table. * * @see WP_List_Table::::single_row_columns() * @return array An associative array containing column information: 'slugs'=>'Visible Titles' * @since 1.0 */ public function get_columns(){ $columns = array( 'cb' => '<input type="checkbox" />', 'status' => __( 'Status', 'woocommerce-subscriptions' ), 'title' => __( 'Subscription', 'woocommerce-subscriptions' ), 'user' => __( 'User', 'woocommerce-subscriptions' ), 'order_id' => __( 'Order', 'woocommerce-subscriptions' ), 'start_date' => __( 'Start Date', 'woocommerce-subscriptions' ), 'expiry_date' => __( 'Expiration', 'woocommerce-subscriptions' ), 'end_date' => __( 'End Date', 'woocommerce-subscriptions' ), 'trial_expiry_date' => __( 'Trial End Date', 'woocommerce-subscriptions' ), 'last_payment_date' => __( 'Last Payment', 'woocommerce-subscriptions' ), 'next_payment_date' => __( 'Next Payment', 'woocommerce-subscriptions' ), 'renewal_order_count' => __( 'Renewals', 'woocommerce-subscriptions' ), ); return $columns; } /** * Make the table sortable by all columns and set the default sort field to be start_date. * * @return array An associative array containing all the columns that should be sortable: 'slugs' => array( 'data_values', bool ) * @since 1.0 */ public function get_sortable_columns() { $sortable_columns = array( 'status' => array( 'status', false ), 'order_id' => array( 'order_id', false ), 'title' => array( '_order_item_name', false ), 'user' => array( 'user_display_name', false ), 'start_date' => array( 'start_date', true ), 'expiry_date' => array( 'expiry_date', false ), 'trial_expiry_date' => array( 'trial_expiry_date', false ), 'end_date' => array( 'end_date', false ), 'last_payment_date' => array( 'last_payment_date', false ), 'renewal_order_count' => array( 'renewal_order_count', false ) ); if ( false === WC_Subscriptions::is_large_site() ) { $sortable_columns['next_payment_date'] = array( 'next_payment_date', false ); } return $sortable_columns; } /** * Make it quick an easy to cancel or activate more than one subscription * * @return array An associative array containing all the bulk actions: 'slugs' => 'Visible Titles' * @since 1.0 */ public function get_bulk_actions() { $actions = array(); $actions = array( 'active' => __( 'Reactivate', 'woocommerce-subscriptions' ), 'on-hold' => __( 'Put on-hold', 'woocommerce-subscriptions' ), 'cancelled' => __( 'Cancel', 'woocommerce-subscriptions' ), ); if ( isset( $_REQUEST['status'] ) && $_REQUEST['status'] == 'trash' ) { $actions['deleted'] = __( 'Delete Permanently', 'woocommerce-subscriptions' ); } elseif ( ! isset( $_REQUEST['status'] ) || $_REQUEST['status'] != 'trash' ) { $actions['trash'] = __( 'Move to Trash', 'woocommerce-subscriptions' ); } return $actions; } /** * Get the current action selected from the bulk actions dropdown. * * @since 3.1.0 * @access public * * @return string|bool The action name or False if no action was selected */ function current_action() { $current_action = false; if ( isset( $_REQUEST['new_status'] ) ) { $current_action = $_REQUEST['new_status']; } if ( isset( $_GET['_customer_user'] ) && ! empty( $_GET['_customer_user'] ) && isset( $_GET['_wpnonce'] ) && isset( $_GET['_wp_http_referer'] ) ) { $current_action = $_GET['_customer_user']; } if ( isset( $_GET['_product_id'] ) && ! empty( $_GET['_product_id'] ) && isset( $_GET['_wpnonce'] ) && isset( $_GET['_wp_http_referer'] ) ) { $current_action = $_GET['_product_id']; } if ( isset( $_REQUEST['action'] ) && -1 != $_REQUEST['action'] ) { $current_action = $_REQUEST['action']; } return $current_action; } /** * Handle activate & cancel actions for both individual items and bulk edit. * * @since 1.0 */ public function process_actions() { $custom_actions = apply_filters( 'woocommerce_subscriptions_list_table_pre_process_actions', array( 'custom_action' => false, 'messages' => array(), 'error_messages' => array() )); if ( $this->current_action() === false && false === $custom_actions['custom_action'] && ! isset( $_GET['_wpnonce'] ) ) { return; } $messages = array(); $error_messages = array(); $query_args = array(); // Check if custom actions were taken by the filter - if so, it has handled the action and we only need to set the message/error messages if ( $custom_actions['custom_action'] !== false ) { $messages = $custom_actions['messages']; $error_messages = $custom_actions['error_messages']; } else { $current_action = ''; $subscriptions = array(); if ( isset( $_GET['subscription'] ) ) { // Single subscription action if ( ! wp_verify_nonce( $_REQUEST['_wpnonce'], $_GET['subscription'] ) ) { wp_die( __( 'Action failed. Invalid Nonce.', 'woocommerce-subscriptions' ) ); } $current_action = $_GET['new_status']; $subscriptions = array( $_GET['user'] => array( $_GET['subscription'] ) ); } elseif ( isset( $_GET['subscription_keys'] ) ) { // Bulk actions if ( ! wp_verify_nonce( $_REQUEST['_wpnonce'], 'bulk-' . $this->_args['plural'] ) ) { wp_die( __( 'Bulk edit failed. Invalid Nonce.', 'woocommerce-subscriptions' ) ); } $current_action = $this->current_action(); $subscriptions = $_GET['subscription_keys']; } if ( in_array( $current_action, array( 'active', 'on-hold', 'cancelled', 'trash', 'deleted' ) ) ) { $subscription_count = 0; $error_count = 0; foreach ( $subscriptions as $user_id => $subscription_keys ) { foreach ( $subscription_keys as $subscription_key ) { if ( ! WC_Subscriptions_Manager::can_subscription_be_changed_to( $current_action, $subscription_key ) ) { $error_count++; } else { $subscription_count++; switch ( $current_action ) { case 'active' : WC_Subscriptions_Manager::reactivate_subscription( $user_id, $subscription_key ); break; case 'on-hold' : WC_Subscriptions_Manager::put_subscription_on_hold( $user_id, $subscription_key ); break; case 'cancelled' : WC_Subscriptions_Manager::cancel_subscription( $user_id, $subscription_key ); break; case 'trash' : WC_Subscriptions_Manager::trash_subscription( $user_id, $subscription_key ); break; case 'deleted' : WC_Subscriptions_Manager::delete_subscription( $user_id, $subscription_key ); break; default : $error_messages[] = __( 'Error: Unknown action.', 'woocommerce-subscriptions' ); break; } switch ( $current_action ) { case 'active' : case 'on-hold' : case 'cancelled' : case 'trash' : do_action( 'admin_changed_subscription_to_' . $current_action, $subscription_key ); break; } } } } if ( $subscription_count > 0 ) { switch ( $current_action ) { case 'active' : case 'on-hold' : case 'cancelled' : $messages[] = sprintf( _n( 'Subscription changed to %2$s.', '%1$d subscriptions changed to %2$s.', $subscription_count, 'woocommerce-subscriptions' ), $subscription_count, $current_action ); break; case 'trash' : $messages[] = sprintf( _n( 'Subscription moved to trash.', '%s subscriptions moved to trash.', $subscription_count, 'woocommerce-subscriptions' ), $subscription_count ); break; case 'deleted' : $messages[] = sprintf( _n( 'Subscription deleted.', '%s subscriptions deleted.', $subscription_count, 'woocommerce-subscriptions' ), $subscription_count ); break; } } if ( $error_count > 0 ) { switch ( $current_action ) { case 'active' : $error_messages[] = sprintf( _n( '%d subscription could not be changed to active - only on-hold subscriptions can be changed to active.', '%d subscriptions could not be changed to active - only on-hold subscriptions can be changed to active.', $error_count, 'woocommerce-subscriptions' ), $error_count ); break; case 'on-hold' : $error_messages[] = sprintf( _n( '%d subscription could not be put on-hold - only pending and active subscriptions can be put on-hold.', '%d subscriptions could not be changed to suspended - only pending and active subscriptions can be put on-hold.', $error_count, 'woocommerce-subscriptions' ), $error_count ); break; case 'cancelled' : $error_messages[] = sprintf( _n( '%d subscription could not be cancelled - only pending, active and on-hold subscriptions can be cancelled.', '%d subscriptions could not be cancelled - only pending, active and on-hold subscriptions can be cancelled.', $error_count, 'woocommerce-subscriptions' ), $error_count ); break; case 'trash' : $error_messages[] = sprintf( _n( '%d subscription could not be trashed - is it active or on-hold? Try cancelling it before trashing it.', '%d subscriptions could not be trashed - are they active or on-hold? Try cancelling them before trashing.', $error_count, 'woocommerce-subscriptions' ), $error_count ); break; case 'deleted' : $error_messages[] = sprintf( _n( '%d subscription could not deleted - is it active or on-hold? Try cancelling it before deleting.', '%d subscriptions could not deleted - are they active or on-hold? Try cancelling them before deleting.', $error_count, 'woocommerce-subscriptions' ), $error_count ); break; } } } } if ( ! empty( $messages ) || ! empty( $error_messages ) ) { $message_nonce = wp_create_nonce( __FILE__ ); set_transient( $this->message_transient_prefix . $message_nonce, array( 'messages' => $messages, 'error_messages' => $error_messages ), 60 * 60 ); } // Filter by a given customer or product? if ( isset( $_GET['_customer_user'] ) || isset( $_GET['_product_id'] ) ) { if ( ! empty( $_GET['_customer_user'] ) ) { $user_id = intval( $_GET['_customer_user'] ); $user = get_user_by( 'id', absint( $_GET['_customer_user'] ) ); if ( false === $user ) { wp_die( __( 'Action failed. Invalid user ID.', 'woocommerce-subscriptions' ) ); } $query_args['_customer_user'] = $user_id; } if ( ! empty( $_GET['_product_id'] ) ) { $product_id = intval( $_GET['_product_id'] ); $product = get_product( $product_id ); if ( false === $product ) { wp_die( __( 'Action failed. Invalid product ID.', 'woocommerce-subscriptions' ) ); } $query_args['_product_id'] = $product_id; } } $query_args['status'] = ( isset( $_GET['status'] ) ) ? $_GET['status'] : 'all'; if ( ! empty( $messages ) || ! empty( $error_messages ) ) { $query_args['message'] = $message_nonce; } if ( isset( $_GET['paged'] ) ) { $query_args['paged'] = $_GET['paged']; } $search_query = _admin_search_query(); if ( ! empty( $search_query ) ) { $query_args['s'] = $search_query; } $redirect_to = add_query_arg( $query_args, admin_url( 'admin.php?page=subscriptions' ) ); // Redirect to avoid performning actions on a page refresh wp_safe_redirect( $redirect_to ); exit; } /** * Get an associative array ( id => link ) with the list * of views available on this table. * * @since 1.0 * @return array */ function get_views() { $views = array(); foreach ( $this->statuses as $status => $count ) { if ( ( isset( $_GET['status'] ) && $_GET['status'] == $status ) || ( ! isset( $_GET['status'] ) && $status == 'all' ) ) { $class = ' class="current"'; } else { $class = ''; } $base_url = admin_url( 'admin.php?page=subscriptions' ); if ( isset( $_REQUEST['s'] ) ) { $base_url = add_query_arg( 's', $_REQUEST['s'], $base_url ); } if ( isset( $_GET['_customer_user'] ) && ! empty( $_GET['_customer_user'] ) ) { $base_url = add_query_arg( '_customer_user', $_GET['_customer_user'], $base_url ); } if ( isset( $_GET['_product_id'] ) && ! empty( $_GET['_product_id'] ) ) { $base_url = add_query_arg( '_product_id', $_GET['_product_id'], $base_url ); } $views[ $status ] = sprintf( '<a href="%s"%s>%s (%s)</a>', esc_url( add_query_arg( 'status', $status, $base_url ) ), $class, ucfirst( $status ), $count ); } return $views; } /** * Output any messages set on the class * * @since 1.0 */ public function messages() { if ( isset( $_GET['message'] ) ) { $all_messages = get_transient( $this->message_transient_prefix . $_GET['message'] ); if ( ! empty( $all_messages ) ) { delete_transient( $this->message_transient_prefix . $_GET['message'] ); if ( ! empty( $all_messages['messages'] ) ) { echo '<div id="moderated" class="updated"><p>' . implode( "<br/>\n", $all_messages['messages'] ) . '</p></div>'; } if ( ! empty( $all_messages['error_messages'] ) ) { echo '<div id="moderated" class="error"><p>' . implode( "<br/>\n", $all_messages['error_messages'] ) . '</p></div>'; } } } elseif ( isset( $_REQUEST['s'] ) ) { echo '<div id="moderated" class="updated"><p>'; echo '<a href="' . admin_url( 'admin.php?page=subscriptions' ) . '" class="close-subscriptions-search">×</a>'; printf( __( 'Showing only subscriptions containing "%s"', 'woocommerce-subscriptions' ), esc_html( $_REQUEST['s'] ) ); echo '</p></div>'; } if ( isset( $_GET['_customer_user'] ) || isset( $_GET['_product_id'] ) ) { echo '<div id="moderated" class="updated"><p>'; echo '<a href="' . admin_url( 'admin.php?page=subscriptions' ) . '" class="close-subscriptions-search">×</a>'; if ( ! empty( $_GET['_customer_user'] ) ) { $user_id = intval( $_GET['_customer_user'] ); $user = get_user_by( 'id', absint( $_GET['_customer_user'] ) ); if ( false === $user ) { printf( __( 'Invalid user. ', 'woocommerce-subscriptions' ), $user->display_name ); } else { printf( __( "Showing %s's subscriptions", 'woocommerce-subscriptions' ), $user->display_name ); } } if ( ! empty( $_GET['_product_id'] ) ) { $product_id = intval( $_GET['_product_id'] ); $product = get_product( $product_id ); if ( false === $product ) { printf( __( 'Invalid product.', 'woocommerce-subscriptions' ), $user->display_name ); } elseif ( ! empty( $_GET['_customer_user'] ) ) { printf( __( ' for product #%s – %s%s%s', 'woocommerce-subscriptions' ), $product_id, '<em>', $product->get_title(), '</em>' ); } else { printf( __( 'Showing subscriptions to product #%s – %s%s%s', 'woocommerce-subscriptions' ), $product_id, '<em>', $product->get_title(), '</em>' ); } } echo '</p></div>'; } } /** * Get, sort and filter subscriptions for display. * * @uses $this->_column_headers * @uses $this->items * @uses $this->get_columns() * @uses $this->get_sortable_columns() * @uses $this->get_pagenum() * @uses $this->set_pagination_args() * @since 1.0 */ function prepare_items() { $screen = get_current_screen(); $per_page = $this->get_items_per_page( $screen->get_option( 'per_page', 'option' ), 10 ); $paged = isset( $_GET['paged'] ) ? $_GET['paged'] : 1; $this->get_column_info(); $status_to_show = ( isset( $_GET['status'] ) ) ? $_GET['status'] : 'all'; if ( isset( $_REQUEST['s'] ) || ( ! empty( $_REQUEST['orderby'] ) && 'next_payment_date' === $_REQUEST['orderby'] ) ) { @set_time_limit( 300 ); $subscriptions = $this->statuses = array(); // It's a search if ( isset( $_REQUEST['s'] ) ) { $subscriptions_grouped_by_user = WC_Subscriptions_Manager::search_subscriptions( $_REQUEST['s'] ); } else { // Order by next payment date $subscriptions_grouped_by_user = WC_Subscriptions_Manager::get_all_users_subscriptions(); } foreach ( $subscriptions_grouped_by_user as $user_id => $users_subscriptions ) { // Filter by a certain customer? if ( isset( $_GET['_customer_user'] ) && (int)$user_id !== (int)$_GET['_customer_user'] ) { continue; } foreach ( $users_subscriptions as $subscription_key => $subscription ) { // Filter by a certain product? if ( isset( $_GET['_product_id'] ) && (int)$subscription['product_id'] !== (int)$_GET['_product_id'] ) { continue; } $this->statuses[$subscription['status']] = ( isset( $this->statuses[$subscription['status']] ) ) ? $this->statuses[$subscription['status']] + 1 : 1; if ( $status_to_show == $subscription['status'] || ( $status_to_show == 'all' && $subscription['status'] != 'trash' ) ) { $subscriptions[$subscription_key] = $subscription + array( 'user_id' => $user_id, 'subscription_key' => $subscription_key ); } } } // If we have a request for a status that does not exist, default to all subscriptions if ( ! isset( $this->statuses[$status_to_show] ) ) { if ( $status_to_show != 'all' ) { $status_to_show = $_GET['status'] = 'all'; foreach ( $subscriptions_grouped_by_user as $user_id => $users_subscriptions ) { // Filter by a certain customer? if ( isset( $_GET['_customer_user'] ) && (int)$user_id !== (int)$_GET['_customer_user'] ) { continue; } foreach ( $users_subscriptions as $subscription_key => $subscription ) { // Filter by a certain product? if ( isset( $_GET['_product_id'] ) && (int)$subscription['product_id'] !== (int)$_GET['_product_id'] ) { continue; } $subscriptions[$subscription_key] = $subscription + array( 'user_id' => $user_id, 'subscription_key' => $subscription_key ); } } } else { $_GET['status'] = 'all'; } } ksort( $this->statuses ); $this->statuses = array( 'all' => array_sum( $this->statuses ) ) + $this->statuses; if ( isset( $this->statuses['trash'] ) ) { $this->statuses['all'] = $this->statuses['all'] - $this->statuses['trash']; } $total_items = count( $subscriptions ); @usort( $subscriptions, array( &$this, 'sort_subscriptions' ) ); // Need to suppress warnings due to PHP bug here: https://bugs.php.net/bug.php?id=50688 $subscriptions = array_slice( $subscriptions, ( ( $paged - 1 ) * $per_page ), $per_page ); } else { $subscriptions_query = array( 'paged' => $paged, 'subscriptions_per_page' => $per_page, 'subscription_status' => $status_to_show, 'order' => ( ! empty( $_REQUEST['order'] ) ) ? strtoupper( $_REQUEST['order'] ) : 'DESC', 'orderby' => ( ! empty( $_REQUEST['orderby'] ) ) ? $_REQUEST['orderby'] : '_subscription_start_date' ); // Filter by a certain customer? if ( isset( $_GET['_customer_user'] ) && ! empty( $_GET['_customer_user'] ) ) { $subscriptions_query['customer_id'] = $_GET['_customer_user']; } // Filter by a certain product? if ( isset( $_GET['_product_id'] ) && ! empty( $_GET['_product_id'] ) ) { $subscriptions_query['product_id'] = $_GET['_product_id']; } $subscriptions = WC_Subscriptions::get_subscriptions( $subscriptions_query ); $this->statuses = WC_Subscriptions::get_subscription_status_counts(); if ( isset( $this->statuses['trash'] ) ) { $this->statuses['all'] = $this->statuses['all'] - $this->statuses['trash']; } if ( 'all' === $status_to_show && ! isset( $subscriptions_query['customer_id'] ) && ! isset( $subscriptions_query['product_id'] ) ) { $total_items = $this->statuses['all']; } else { $total_items = WC_Subscriptions::get_subscription_count( $subscriptions_query ); } } // Add sorted & sliced data to the items property to be used by the rest of the class $this->items = $subscriptions; $this->set_pagination_args( array( 'total_items' => $total_items, 'per_page' => $per_page, 'total_pages' => ceil( $total_items / $per_page ) ) ); } /** * Generate the table navigation above or below the table * * @since 1.2 */ function display_tablenav( $which ) { if ( 'top' == $which ) { ?> <input type="hidden" name="page" value="<?php echo $_REQUEST['page'] ?>" /> <?php if ( isset( $_REQUEST['status'] ) ) : ?> <input type="hidden" name="status" value="<?php echo $_REQUEST['status'] ?>" /> <?php endif; } parent::display_tablenav( $which ); } /** * Display extra filter controls between bulk actions and pagination. * * @since 1.3.1 */ function extra_tablenav( $which ) { if ( 'top' == $which ) { ?> <div class="alignleft actions"> <select id="dropdown_products_and_variations" name="_product_id" data-placeholder="<?php _e( 'Search for a product…', 'woocommerce-subscriptions' ); ?>" style="width: 240px"> <option value=""><?php _e( 'Show all products', 'woocommerce-subscriptions' ) ?></option> <?php if ( ! empty( $_GET['_product_id'] ) ) : ?> <?php $product = get_product( absint( $_GET['_product_id'] ) ); ?> <option value="<?php echo absint( $_GET['_product_id'] ); ?>" <?php selected( 1, 1 ); ?>> <?php printf( '#%s – %s', absint( $_GET['_product_id'] ), esc_html( $product->get_title() ) ); ?> </option> <?php endif; ?> </select> <select id="dropdown_customers" name="_customer_user"> <option value=""><?php _e( 'Show all customers', 'woocommerce-subscriptions' ) ?></option> <?php if ( ! empty( $_GET['_customer_user'] ) ) : ?> <?php $user = get_user_by( 'id', absint( $_GET['_customer_user'] ) ); ?> <option value="<?php echo absint( $user->ID ); ?>" <?php selected( 1, 1 ); ?>> <?php printf( '%s (#%s – %s)', esc_html( $user->display_name ), absint( $user->ID ), esc_html( $user->user_email ) ); ?> </option> <?php endif; ?> </select> <?php submit_button( __( 'Filter' ), 'button', false, false, array( 'id' => 'post-query-submit' ) ); ?> </div><?php } } /** * The text to display before any sign-ups. * * @since 1.0 */ public function no_items() { if ( isset( $_GET['_customer_user'] ) && ! empty( $_GET['_customer_user'] ) ) { $user = get_user_by( 'id', intval( $_GET['_customer_user'] ) ); } if ( isset( $_REQUEST['_product_id'] ) && ! empty( $_GET['_product_id'] ) ) { $product = get_product( intval( $_GET['_product_id'] ) ); } if ( isset( $_GET['_customer_user'] ) && ! empty( $_GET['_customer_user'] ) ) : if ( isset( $_REQUEST['_product_id'] ) ) : if ( isset( $_GET['status'] ) && 'all' !== $_GET['status'] ) : ?> <p><?php printf( __( '%s has no subscription to %s%s%s (#%s) with the status "%s".', 'woocommerce-subscriptions' ), $user->display_name, '<em>', $product->get_title(), '</em>', intval( $_GET['_product_id'] ), $_GET['status'] ); ?></p> <?php else : ?> <p><?php printf( __( '%s has not purchased %s%s%s (#%s).', 'woocommerce-subscriptions' ), $user->display_name, '<em>', $product->get_title(), '</em>', intval( $_GET['_product_id'] ) ); ?></p> <?php endif; ?> <?php else : ?> <p><?php printf( __( '%s has not purchased any subscriptions.', 'woocommerce-subscriptions' ), $user->display_name ); ?></p> <?php endif; ?> <?php elseif ( isset( $_REQUEST['_product_id'] ) && ! empty( $_GET['_product_id'] ) ) : ?> <?php if ( isset( $_GET['status'] ) && 'all' !== $_GET['status'] ) : ?> <p><?php printf( __( 'There are no subscriptions to %s%s%s (#%s) with the status "%s".', 'woocommerce-subscriptions' ), '<em>', $product->get_title(), '</em>', intval( $_GET['_product_id'] ), $_GET['status'] ); ?></p> <?php else : ?> <p><?php printf( __( 'No one has purchased %s%s%s (#%s) yet.', 'woocommerce-subscriptions' ), '<em>', $product->get_title(), '</em>', intval( $_GET['_product_id'] ) ); ?></p> <?php endif; ?> <?php elseif ( isset( $_REQUEST['s'] ) ) : ?> <p><?php printf( __( 'No subscriptions found to have a subscriber name, email, title or order ID matching "%s".', 'woocommerce-subscriptions' ), '<em>' . esc_attr( $_REQUEST['s'] ) . '</em>' ); ?></p> <?php else : ?> <p><?php _e( 'Subscriptions will appear here for you to view and manage once purchased by a customer.', 'woocommerce-subscriptions' ); ?></p> <p><?php printf( __( '%sLearn more about managing subscriptions%s', 'woocommerce-subscriptions' ), '<a href="https://docs.woothemes.com/document/subscriptions/store-manager-guide/#section-3" target="_blank">', ' ?</a>' ); ?></p> <p><?php printf( __( '%sAdd a subscription product%s', 'woocommerce-subscriptions' ), '<a href="' . WC_Subscriptions_Admin::add_subscription_url() . '">', ' ?</a>' ); ?></p> <?php endif; } /** * If no sort order set, default to start date. If no sort order, default to descending. * * @since 1.0 */ function sort_subscriptions( $a, $b ){ $order_by = ( ! empty( $_REQUEST['orderby'] ) ) ? $_REQUEST['orderby'] : 'start_date'; $order = ( ! empty( $_REQUEST['order'] ) ) ? $_REQUEST['order'] : 'desc'; switch ( $order_by ) { case 'product_name' : $product_name_a = get_the_title( $a['product_id'] ); $product_name_b = get_the_title( $b['product_id'] ); $result = strcasecmp( $product_name_a, $product_name_b ); break; case 'user' : $user_a = get_user_by( 'id', $a['user_id'] ); $user_b = get_user_by( 'id', $b['user_id'] ); $result = strcasecmp( $user_a->display_name, $user_b->display_name ); break; case 'expiry_date' : if ( $order == 'asc' ) { $result = self::sort_with_zero_at_end( $a[ $order_by ], $b[ $order_by ] ); // Display subscriptions that have not ended at the end of the list } else { $result = self::sort_with_zero_at_beginning( $a[ $order_by ], $b[ $order_by ] ); } break; case 'end_date' : $result = self::sort_with_zero_at_end( $a[ $order_by ], $b[ $order_by ] ); // Display subscriptions that have not ended at the end of the list break; case 'next_payment_date' : $next_payment_a = WC_Subscriptions_Manager::get_next_payment_date( $a['subscription_key'], $a['user_id'], 'mysql' ); $next_payment_b = WC_Subscriptions_Manager::get_next_payment_date( $b['subscription_key'], $b['user_id'], 'mysql' ); $result = self::sort_with_zero_at_end( $next_payment_a, $next_payment_b ); // Display subscriptions with no future payments at the end break; case 'last_payment_date' : $last_payment_a = ( empty( $a['completed_payments'] ) ) ? 0 : strtotime( array_pop( $a['completed_payments'] ) ); $last_payment_b = ( empty( $b['completed_payments'] ) ) ? 0 : strtotime( array_pop( $b['completed_payments'] ) ); $result = self::sort_with_zero_at_end( $last_payment_a, $last_payment_b ); // Display subscriptions with no compelted payments at the end break; case 'trial_expiry_date': $trial_expiration_a = WC_Subscriptions_Manager::get_trial_expiration_date( $a['subscription_key'], $a['user_id'], 'mysql' ); $trial_expiration_b = WC_Subscriptions_Manager::get_trial_expiration_date( $b['subscription_key'], $b['user_id'], 'mysql' ); $result = self::sort_with_zero_at_end( $trial_expiration_a, $trial_expiration_b ); break; case 'renewal_order_count' : $result = strcmp( WC_Subscriptions_Renewal_Order::get_renewal_order_count( $a['order_id'] ), WC_Subscriptions_Renewal_Order::get_renewal_order_count( $b['order_id'] ) ); break; case 'order_id' : $result = strnatcmp( $a[ $order_by ], $b[ $order_by ] ); break; default : $result = strcmp( $a[ $order_by ], $b[ $order_by ] ); break; } return ( $order == 'asc' ) ? $result : -$result; // Send final sort direction to usort } /** * A special sorting function to always push a 0 or empty value to the end of the sorted list * * @since 1.2 */ function sort_with_zero_at_end( $a, $b ){ $order = ( ! empty( $_REQUEST['order'] ) ) ? $_REQUEST['order'] : 'desc'; if ( ( $a == 0 || $b == 0 ) && $a != $b ) { if ( $order == 'desc' ) // Set 0 to be < anything other than itself & anything other than 0 to be greater than 0 $result = ( $a == 0 ) ? -1 : 1; elseif ( $order == 'asc' ) // Set 0 to be > anything other than itself & anything other than 0 to be less than 0 $result = ( $a == 0 ) ? 1 : -1; } else { $result = strcmp( $a, $b ); } return $result; } /** * A special sorting function to always push a 0 value to the beginning of a sorted list * * @since 1.2 */ function sort_with_zero_at_beginning( $a, $b ){ $order = ( ! empty( $_REQUEST['order'] ) ) ? $_REQUEST['order'] : 'desc'; if ( ( $a == 0 || $b == 0 ) && $a != $b ) { if ( $order == 'desc' ) // Set 0 to be > anything other than itself & anything other than 0 to be less than 0 $result = ( $a == 0 ) ? 1 : -1; elseif ( $order == 'asc' ) // Set 0 to be < anything other than itself & anything other than 0 to be greater than 0 $result = ( $a == 0 ) ? -1 : 1; } else { $result = strcmp( $a, $b ); } return $result; } /** * To implement subscription search & next payment date sorting, @see $this->prepare_items() uses the * @see WC_Subscriptions_Manager::get_all_users_subscriptions() function. * * @since 1.4.4 */ public function handle_fatal_errors() { if ( false === self::$shutdown_notice_shown && $error = error_get_last() ) { $admin_url = admin_url( 'admin.php?page=subscriptions' ); if ( substr( $error['message'], 0, 22 ) === 'Maximum execution time' ) { $message = sprintf( __( "The server's maximum execution time is too low to perform this operation. Please contact %sWooThemes Support%s to notify us of the issue. %sReturn to Main Subscriptions Page%s.", 'woocommerce-subscriptions' ), '<a href="https://support.woothemes.com">', '</a>', '<a href="' . $admin_url . '">', '</a>' ); } elseif ( substr( $error['message'], 0, 19 ) === 'Allowed memory size' ) { $message = sprintf( __( "The server's maximum memory size is too low to perform this operation. Please increase the %smaximum memory limit using the %sWP_MAX_MEMORY_LIMIT%s constant. %sReturn to Main Subscriptions Page%s.", 'woocommerce-subscriptions' ), '<a href="https://codex.www.ads-software.com/Editing_wp-config.php#Increasing_memory_allocated_to_PHP">', '<code>', '</code></a>', '<a href="' . $admin_url . '">', '</a>' ); } else { $message = ''; } if ( ! empty( $message ) ) { self::$shutdown_notice_shown = true; echo '<div id="moderated" class="error"><p>' . $message . '</p></div>'; } } } }Thanks people!
- The topic ‘Woocommerce Subscriptions List Table PHP Error’ is closed to new replies.