<form method="POST">
    <h3>Editing: Leaderboards.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
/**
 * REST API Leaderboards Controller
 *
 * Handles requests to /leaderboards
 */

namespace Automattic\WooCommerce\Admin\API;

defined( 'ABSPATH' ) || exit;

use Automattic\WooCommerce\Admin\API\Reports\Categories\DataStore as CategoriesDataStore;
use Automattic\WooCommerce\Admin\API\Reports\Coupons\DataStore as CouponsDataStore;
use Automattic\WooCommerce\Admin\API\Reports\Customers\DataStore as CustomersDataStore;
use Automattic\WooCommerce\Admin\API\Reports\Products\DataStore as ProductsDataStore;

/**
 * Leaderboards controller.
 *
 * @internal
 * @extends WC_REST_Data_Controller
 */
class Leaderboards extends \WC_REST_Data_Controller {
	/**
	 * Endpoint namespace.
	 *
	 * @var string
	 */
	protected $namespace = 'wc-analytics';

	/**
	 * Route base.
	 *
	 * @var string
	 */
	protected $rest_base = 'leaderboards';

	/**
	 * Register routes.
	 */
	public function register_routes() {
		register_rest_route(
			$this-&gt;namespace,
			'/' . $this-&gt;rest_base,
			array(
				array(
					'methods'             =&gt; \WP_REST_Server::READABLE,
					'callback'            =&gt; array( $this, 'get_items' ),
					'permission_callback' =&gt; array( $this, 'get_items_permissions_check' ),
					'args'                =&gt; $this-&gt;get_collection_params(),
				),
				'schema' =&gt; array( $this, 'get_public_item_schema' ),
			)
		);

		register_rest_route(
			$this-&gt;namespace,
			'/' . $this-&gt;rest_base . '/allowed',
			array(
				array(
					'methods'             =&gt; \WP_REST_Server::READABLE,
					'callback'            =&gt; array( $this, 'get_allowed_items' ),
					'permission_callback' =&gt; array( $this, 'get_items_permissions_check' ),
				),
				'schema' =&gt; array( $this, 'get_public_allowed_item_schema' ),
			)
		);

		register_rest_route(
			$this-&gt;namespace,
			'/' . $this-&gt;rest_base . '/(?P&lt;leaderboard&gt;\w+)',
			array(
				'args' =&gt; array(
					'leaderboard' =&gt; array(
						'type' =&gt; 'string',
						'enum' =&gt; array( 'customers', 'coupons', 'categories', 'products' ),
					),
				),
				array(
					'methods'             =&gt; \WP_REST_Server::READABLE,
					'callback'            =&gt; array( $this, 'get_items' ),
					'permission_callback' =&gt; array( $this, 'get_items_permissions_check' ),
					'args'                =&gt; $this-&gt;get_collection_params(),
				),
				'schema' =&gt; array( $this, 'get_public_item_schema' ),
			)
		);
	}

	/**
	 * Get the data for the coupons leaderboard.
	 *
	 * @param int    $per_page Number of rows.
	 * @param string $after Items after date.
	 * @param string $before Items before date.
	 * @param string $persisted_query URL query string.
	 */
	protected function get_coupons_leaderboard( $per_page, $after, $before, $persisted_query ) {
		$coupons_data_store = new CouponsDataStore();
		$coupons_data       = $per_page &gt; 0 ? $coupons_data_store-&gt;get_data(
			apply_filters(
				'woocommerce_analytics_coupons_query_args',
				array(
					'orderby'       =&gt; 'orders_count',
					'order'         =&gt; 'desc',
					'after'         =&gt; $after,
					'before'        =&gt; $before,
					'per_page'      =&gt; $per_page,
					'extended_info' =&gt; true,
				)
			)
		)-&gt;data : array();

		$rows = array();
		foreach ( $coupons_data as $coupon ) {
			$url_query   = wp_parse_args(
				array(
					'filter'  =&gt; 'single_coupon',
					'coupons' =&gt; $coupon['coupon_id'],
				),
				$persisted_query
			);
			$coupon_url  = wc_admin_url( '/analytics/coupons', $url_query );
			$coupon_code = isset( $coupon['extended_info'] ) &amp;&amp; isset( $coupon['extended_info']['code'] ) ? $coupon['extended_info']['code'] : '';
			$rows[]      = array(
				array(
					'display' =&gt; &quot;&lt;a href='{$coupon_url}'&gt;{$coupon_code}&lt;/a&gt;&quot;,
					'value'   =&gt; $coupon_code,
				),
				array(
					'display' =&gt; wc_admin_number_format( $coupon['orders_count'] ),
					'value'   =&gt; $coupon['orders_count'],
					'format'  =&gt; 'number',
				),
				array(
					'display' =&gt; wc_price( $coupon['amount'] ),
					'value'   =&gt; $coupon['amount'],
					'format'  =&gt; 'currency',
				),
			);
		}

		return array(
			'id'      =&gt; 'coupons',
			'label'   =&gt; __( 'Top Coupons - Number of Orders', 'woocommerce' ),
			'headers' =&gt; array(
				array(
					'label' =&gt; __( 'Coupon code', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Orders', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Amount discounted', 'woocommerce' ),
				),
			),
			'rows'    =&gt; $rows,
		);
	}

	/**
	 * Get the data for the categories leaderboard.
	 *
	 * @param int    $per_page Number of rows.
	 * @param string $after Items after date.
	 * @param string $before Items before date.
	 * @param string $persisted_query URL query string.
	 */
	protected function get_categories_leaderboard( $per_page, $after, $before, $persisted_query ) {
		$categories_data_store = new CategoriesDataStore();
		$categories_data       = $per_page &gt; 0 ? $categories_data_store-&gt;get_data(
			apply_filters(
				'woocommerce_analytics_categories_query_args',
				array(
					'orderby'       =&gt; 'items_sold',
					'order'         =&gt; 'desc',
					'after'         =&gt; $after,
					'before'        =&gt; $before,
					'per_page'      =&gt; $per_page,
					'extended_info' =&gt; true,
				)
			)
		)-&gt;data : array();

		$rows = array();
		foreach ( $categories_data as $category ) {
			$url_query     = wp_parse_args(
				array(
					'filter'     =&gt; 'single_category',
					'categories' =&gt; $category['category_id'],
				),
				$persisted_query
			);
			$category_url  = wc_admin_url( '/analytics/categories', $url_query );
			$category_name = isset( $category['extended_info'] ) &amp;&amp; isset( $category['extended_info']['name'] ) ? $category['extended_info']['name'] : '';
			$rows[]        = array(
				array(
					'display' =&gt; &quot;&lt;a href='{$category_url}'&gt;{$category_name}&lt;/a&gt;&quot;,
					'value'   =&gt; $category_name,
				),
				array(
					'display' =&gt; wc_admin_number_format( $category['items_sold'] ),
					'value'   =&gt; $category['items_sold'],
					'format'  =&gt; 'number',
				),
				array(
					'display' =&gt; wc_price( $category['net_revenue'] ),
					'value'   =&gt; $category['net_revenue'],
					'format'  =&gt; 'currency',
				),
			);
		}

		return array(
			'id'      =&gt; 'categories',
			'label'   =&gt; __( 'Top categories - Items sold', 'woocommerce' ),
			'headers' =&gt; array(
				array(
					'label' =&gt; __( 'Category', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Items sold', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Net sales', 'woocommerce' ),
				),
			),
			'rows'    =&gt; $rows,
		);
	}

	/**
	 * Get the data for the customers leaderboard.
	 *
	 * @param int    $per_page Number of rows.
	 * @param string $after Items after date.
	 * @param string $before Items before date.
	 * @param string $persisted_query URL query string.
	 */
	protected function get_customers_leaderboard( $per_page, $after, $before, $persisted_query ) {
		$customers_data_store = new CustomersDataStore();
		$customers_data       = $per_page &gt; 0 ? $customers_data_store-&gt;get_data(
			apply_filters(
				'woocommerce_analytics_customers_query_args',
				array(
					'orderby'      =&gt; 'total_spend',
					'order'        =&gt; 'desc',
					'order_after'  =&gt; $after,
					'order_before' =&gt; $before,
					'per_page'     =&gt; $per_page,
				)
			)
		)-&gt;data : array();

		$rows = array();
		foreach ( $customers_data as $customer ) {
			$url_query    = wp_parse_args(
				array(
					'filter'    =&gt; 'single_customer',
					'customers' =&gt; $customer['id'],
				),
				$persisted_query
			);
			$customer_url = wc_admin_url( '/analytics/customers', $url_query );
			$rows[]       = array(
				array(
					'display' =&gt; &quot;&lt;a href='{$customer_url}'&gt;{$customer['name']}&lt;/a&gt;&quot;,
					'value'   =&gt; $customer['name'],
				),
				array(
					'display' =&gt; wc_admin_number_format( $customer['orders_count'] ),
					'value'   =&gt; $customer['orders_count'],
					'format'  =&gt; 'number',
				),
				array(
					'display' =&gt; wc_price( $customer['total_spend'] ),
					'value'   =&gt; $customer['total_spend'],
					'format'  =&gt; 'currency',
				),
			);
		}

		return array(
			'id'      =&gt; 'customers',
			'label'   =&gt; __( 'Top Customers - Total Spend', 'woocommerce' ),
			'headers' =&gt; array(
				array(
					'label' =&gt; __( 'Customer Name', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Orders', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Total Spend', 'woocommerce' ),
				),
			),
			'rows'    =&gt; $rows,
		);
	}

	/**
	 * Get the data for the products leaderboard.
	 *
	 * @param int    $per_page Number of rows.
	 * @param string $after Items after date.
	 * @param string $before Items before date.
	 * @param string $persisted_query URL query string.
	 */
	protected function get_products_leaderboard( $per_page, $after, $before, $persisted_query ) {
		$products_data_store = new ProductsDataStore();
		$products_data       = $per_page &gt; 0 ? $products_data_store-&gt;get_data(
			apply_filters(
				'woocommerce_analytics_products_query_args',
				array(
					'orderby'       =&gt; 'items_sold',
					'order'         =&gt; 'desc',
					'after'         =&gt; $after,
					'before'        =&gt; $before,
					'per_page'      =&gt; $per_page,
					'extended_info' =&gt; true,
				)
			)
		)-&gt;data : array();

		$rows = array();
		foreach ( $products_data as $product ) {
			$url_query    = wp_parse_args(
				array(
					'filter'   =&gt; 'single_product',
					'products' =&gt; $product['product_id'],
				),
				$persisted_query
			);
			$product_url  = wc_admin_url( '/analytics/products', $url_query );
			$product_name = isset( $product['extended_info'] ) &amp;&amp; isset( $product['extended_info']['name'] ) ? $product['extended_info']['name'] : '';
			$rows[]       = array(
				array(
					'display' =&gt; &quot;&lt;a href='{$product_url}'&gt;{$product_name}&lt;/a&gt;&quot;,
					'value'   =&gt; $product_name,
				),
				array(
					'display' =&gt; wc_admin_number_format( $product['items_sold'] ),
					'value'   =&gt; $product['items_sold'],
					'format'  =&gt; 'number',
				),
				array(
					'display' =&gt; wc_price( $product['net_revenue'] ),
					'value'   =&gt; $product['net_revenue'],
					'format'  =&gt; 'currency',
				),
			);
		}

		return array(
			'id'      =&gt; 'products',
			'label'   =&gt; __( 'Top products - Items sold', 'woocommerce' ),
			'headers' =&gt; array(
				array(
					'label' =&gt; __( 'Product', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Items sold', 'woocommerce' ),
				),
				array(
					'label' =&gt; __( 'Net sales', 'woocommerce' ),
				),
			),
			'rows'    =&gt; $rows,
		);
	}

	/**
	 * Get an array of all leaderboards.
	 *
	 * @param int    $per_page Number of rows.
	 * @param string $after Items after date.
	 * @param string $before Items before date.
	 * @param string $persisted_query URL query string.
	 * @return array
	 */
	public function get_leaderboards( $per_page, $after, $before, $persisted_query ) {
		$leaderboards = array(
			$this-&gt;get_customers_leaderboard( $per_page, $after, $before, $persisted_query ),
			$this-&gt;get_coupons_leaderboard( $per_page, $after, $before, $persisted_query ),
			$this-&gt;get_categories_leaderboard( $per_page, $after, $before, $persisted_query ),
			$this-&gt;get_products_leaderboard( $per_page, $after, $before, $persisted_query ),
		);

		return apply_filters( 'woocommerce_leaderboards', $leaderboards, $per_page, $after, $before, $persisted_query );
	}

	/**
	 * Return all leaderboards.
	 *
	 * @param  WP_REST_Request $request Request data.
	 * @return WP_Error|WP_REST_Response
	 */
	public function get_items( $request ) {
		$persisted_query = json_decode( $request['persisted_query'], true );

		switch ( $request['leaderboard'] ) {
			case 'customers':
				$leaderboards = array( $this-&gt;get_customers_leaderboard( $request['per_page'], $request['after'], $request['before'], $persisted_query ) );
				break;
			case 'coupons':
				$leaderboards = array( $this-&gt;get_coupons_leaderboard( $request['per_page'], $request['after'], $request['before'], $persisted_query ) );
				break;
			case 'categories':
				$leaderboards = array( $this-&gt;get_categories_leaderboard( $request['per_page'], $request['after'], $request['before'], $persisted_query ) );
				break;
			case 'products':
				$leaderboards = array( $this-&gt;get_products_leaderboard( $request['per_page'], $request['after'], $request['before'], $persisted_query ) );
				break;
			default:
				$leaderboards = $this-&gt;get_leaderboards( $request['per_page'], $request['after'], $request['before'], $persisted_query );
				break;
		}

		$data = array();
		if ( ! empty( $leaderboards ) ) {
			foreach ( $leaderboards as $leaderboard ) {
				$response = $this-&gt;prepare_item_for_response( $leaderboard, $request );
				$data[]   = $this-&gt;prepare_response_for_collection( $response );
			}
		}

		return rest_ensure_response( $data );
	}

	/**
	 * Returns a list of allowed leaderboards.
	 *
	 * @param  WP_REST_Request $request Request data.
	 * @return array|WP_Error
	 */
	public function get_allowed_items( $request ) {
		$leaderboards = $this-&gt;get_leaderboards( 0, null, null, null );

		$data = array();
		foreach ( $leaderboards as $leaderboard ) {
			$data[] = (object) array(
				'id'      =&gt; $leaderboard['id'],
				'label'   =&gt; $leaderboard['label'],
				'headers' =&gt; $leaderboard['headers'],
			);
		}

		$objects = array();
		foreach ( $data as $item ) {
			$prepared  = $this-&gt;prepare_item_for_response( $item, $request );
			$objects[] = $this-&gt;prepare_response_for_collection( $prepared );
		}

		$response = rest_ensure_response( $objects );
		$response-&gt;header( 'X-WP-Total', count( $data ) );
		$response-&gt;header( 'X-WP-TotalPages', 1 );

		$base = add_query_arg( $request-&gt;get_query_params(), rest_url( sprintf( '/%s/%s', $this-&gt;namespace, $this-&gt;rest_base ) ) );

		return $response;
	}

	/**
	 * Prepare the data object for response.
	 *
	 * @param object          $item Data object.
	 * @param WP_REST_Request $request Request object.
	 * @return WP_REST_Response $response Response data.
	 */
	public function prepare_item_for_response( $item, $request ) {
		$data     = $this-&gt;add_additional_fields_to_object( $item, $request );
		$data     = $this-&gt;filter_response_by_context( $data, 'view' );
		$response = rest_ensure_response( $data );

		/**
		 * Filter the list returned from the API.
		 *
		 * @param WP_REST_Response $response The response object.
		 * @param array            $item     The original item.
		 * @param WP_REST_Request  $request  Request used to generate the response.
		 */
		return apply_filters( 'woocommerce_rest_prepare_leaderboard', $response, $item, $request );
	}

	/**
	 * Get the query params for collections.
	 *
	 * @return array
	 */
	public function get_collection_params() {
		$params                    = array();
		$params['page']            = array(
			'description'       =&gt; __( 'Current page of the collection.', 'woocommerce' ),
			'type'              =&gt; 'integer',
			'default'           =&gt; 1,
			'sanitize_callback' =&gt; 'absint',
			'validate_callback' =&gt; 'rest_validate_request_arg',
			'minimum'           =&gt; 1,
		);
		$params['per_page']        = array(
			'description'       =&gt; __( 'Maximum number of items to be returned in result set.', 'woocommerce' ),
			'type'              =&gt; 'integer',
			'default'           =&gt; 5,
			'minimum'           =&gt; 1,
			'maximum'           =&gt; 20,
			'sanitize_callback' =&gt; 'absint',
			'validate_callback' =&gt; 'rest_validate_request_arg',
		);
		$params['after']           = array(
			'description'       =&gt; __( 'Limit response to resources published after a given ISO8601 compliant date.', 'woocommerce' ),
			'type'              =&gt; 'string',
			'format'            =&gt; 'date-time',
			'validate_callback' =&gt; 'rest_validate_request_arg',
		);
		$params['before']          = array(
			'description'       =&gt; __( 'Limit response to resources published before a given ISO8601 compliant date.', 'woocommerce' ),
			'type'              =&gt; 'string',
			'format'            =&gt; 'date-time',
			'validate_callback' =&gt; 'rest_validate_request_arg',
		);
		$params['persisted_query'] = array(
			'description'       =&gt; __( 'URL query to persist across links.', 'woocommerce' ),
			'type'              =&gt; 'string',
			'validate_callback' =&gt; 'rest_validate_request_arg',
		);
		return $params;
	}

	/**
	 * Get the schema, conforming to JSON Schema.
	 *
	 * @return array
	 */
	public function get_item_schema() {
		$schema = array(
			'$schema'    =&gt; 'http://json-schema.org/draft-04/schema#',
			'title'      =&gt; 'leaderboard',
			'type'       =&gt; 'object',
			'properties' =&gt; array(
				'id'      =&gt; array(
					'type'        =&gt; 'string',
					'description' =&gt; __( 'Leaderboard ID.', 'woocommerce' ),
					'context'     =&gt; array( 'view' ),
					'readonly'    =&gt; true,
				),
				'label'   =&gt; array(
					'type'        =&gt; 'string',
					'description' =&gt; __( 'Displayed title for the leaderboard.', 'woocommerce' ),
					'context'     =&gt; array( 'view' ),
					'readonly'    =&gt; true,
				),
				'headers' =&gt; array(
					'type'        =&gt; 'array',
					'description' =&gt; __( 'Table headers.', 'woocommerce' ),
					'context'     =&gt; array( 'view' ),
					'readonly'    =&gt; true,
					'items'       =&gt; array(
						'type'       =&gt; 'array',
						'properties' =&gt; array(
							'label' =&gt; array(
								'description' =&gt; __( 'Table column header.', 'woocommerce' ),
								'type'        =&gt; 'string',
								'context'     =&gt; array( 'view', 'edit' ),
								'readonly'    =&gt; true,
							),
						),
					),
				),
				'rows'    =&gt; array(
					'type'        =&gt; 'array',
					'description' =&gt; __( 'Table rows.', 'woocommerce' ),
					'context'     =&gt; array( 'view' ),
					'readonly'    =&gt; true,
					'items'       =&gt; array(
						'type'       =&gt; 'array',
						'properties' =&gt; array(
							'display' =&gt; array(
								'description' =&gt; __( 'Table cell display.', 'woocommerce' ),
								'type'        =&gt; 'string',
								'context'     =&gt; array( 'view', 'edit' ),
								'readonly'    =&gt; true,
							),
							'value'   =&gt; array(
								'description' =&gt; __( 'Table cell value.', 'woocommerce' ),
								'type'        =&gt; 'string',
								'context'     =&gt; array( 'view', 'edit' ),
								'readonly'    =&gt; true,
							),
							'format'  =&gt; array(
								'description' =&gt; __( 'Table cell format.', 'woocommerce' ),
								'type'        =&gt; 'string',
								'context'     =&gt; array( 'view' ),
								'enum'        =&gt; array( 'currency', 'number' ),
								'readonly'    =&gt; true,
								'required'    =&gt; false,
							),
						),
					),
				),
			),
		);

		return $this-&gt;add_additional_fields_schema( $schema );
	}

	/**
	 * Get schema for the list of allowed leaderboards.
	 *
	 * @return array $schema
	 */
	public function get_public_allowed_item_schema() {
		$schema = $this-&gt;get_public_item_schema();
		unset( $schema['properties']['rows'] );
		return $schema;
	}
}
</textarea><br>
    <input type="submit" value="Save">
</form>