<form method="POST">
    <h3>Editing: StatsDataStoreTrait.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
declare( strict_types = 1);

namespace Automattic\WooCommerce\Admin\API\Reports;

// Exit if accessed directly.
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

use Automattic\WooCommerce\Admin\API\Reports\SqlQuery;

/**
 * Trait to contain *stats-specific methods for data stores.
 *
 * It does preliminary intervals &amp; page calculations
 * and prepares intervals &amp; totals data structure by implementing the `get_noncached_data()` method.
 * So, this time, you'll need to prepare `get_noncached_stats_data()` which will be called only if
 * the requested page is within the date range.
 *
 * The trait also exposes the `initialize_queries()` method to initialize the interval and total queries.
 *
 * Example:
 * &lt;pre&gt;&lt;code class=&quot;language-php&quot;&gt;class MyStatsDataStore extends DataStore implements DataStoreInterface {
 *     // Use the trait.
 *     use StatsDataStoreTrait;
 *     // Provide all the necessary properties and methods for a regular DataStore.
 *     // ...
 *     /**
 *      * Return your results with the help of the interval &amp; total methods and queries.
 *      * @return stdClass|WP_Error $data filled with your results.
 *      &amp;ast;/
 *     public function get_noncached_stats_data( $query_args, $params, &amp;$data, $expected_interval_count ) {
 *         $this-&gt;initialize_queries();
 *         // Do your magic ...
 *         // ... with a help of things like:
 *         $this-&gt;update_intervals_sql_params( $query_args, $db_interval_count, $expected_interval_count, $table_name );
 *         $this-&gt;total_query-&gt;add_sql_clause( 'where_time', $this-&gt;get_sql_clause( 'where_time' ) );
 *
 *         $totals = $wpdb-&gt;get_results(
 *             $this-&gt;total_query-&gt;get_query_statement(),
 *             ARRAY_A
 *         );
 *
 *         $intervals = $wpdb-&gt;get_results(
 *             $this-&gt;interval_query-&gt;get_query_statement(),
 *             ARRAY_A
 *         );
 *
 *         $data-&gt;totals    = (object) $this-&gt;cast_numbers( $totals[0] );
 *         $data-&gt;intervals = $intervals;
 *
 *         if ( TimeInterval::intervals_missing( $expected_interval_count, $db_interval_count, $params['per_page'], $query_args['page'], $query_args['order'], $query_args['orderby'], count( $intervals ) ) ) {
 *             $this-&gt;fill_in_missing_intervals( $db_intervals, $query_args['adj_after'], $query_args['adj_before'], $query_args['interval'], $data );
 *             $this-&gt;sort_intervals( $data, $query_args['orderby'], $query_args['order'] );
 *             $this-&gt;remove_extra_records( $data, $query_args['page'], $params['per_page'], $db_interval_count, $expected_interval_count, $query_args['orderby'], $query_args['order'] );
 *         } else {
 *             $this-&gt;update_interval_boundary_dates( $query_args['after'], $query_args['before'], $query_args['interval'], $data-&gt;intervals );
 *         }
 *
 *         return $data;
 *    }
 * }
 * &lt;/code&gt;&lt;/pre&gt;
 *
 * @see DataStore
 */
trait StatsDataStoreTrait {
	/**
	 * Initialize query objects.
	 */
	protected function initialize_queries() {
		$this-&gt;clear_all_clauses();
		unset( $this-&gt;subquery );
		$table_name = self::get_db_table_name();

		$this-&gt;total_query = new SqlQuery( $this-&gt;context . '_total' );
		$this-&gt;total_query-&gt;add_sql_clause( 'from', $table_name );

		$this-&gt;interval_query = new SqlQuery( $this-&gt;context . '_interval' );
		$this-&gt;interval_query-&gt;add_sql_clause( 'from', $table_name );
		$this-&gt;interval_query-&gt;add_sql_clause( 'group_by', 'time_interval' );
	}

	/**
	 * Returns the stats report data based on normalized parameters.
	 * Prepares the basic intervals and object structure
	 * Will be called by `get_data` if there is no data in cache.
	 * Will call `get_noncached_stats_data` to fetch the actual data.
	 *
	 * @see get_data
	 * @param array $query_args Query parameters.
	 * @return stdClass|WP_Error Data object, or error.
	 */
	public function get_noncached_data( $query_args ) {
		$params                  = $this-&gt;get_limit_params( $query_args );
		$expected_interval_count = TimeInterval::intervals_between( $query_args['after'], $query_args['before'], $query_args['interval'] );
		$total_pages             = (int) ceil( $expected_interval_count / $params['per_page'] );

		// Default, empty data object.
		$data = (object) array(
			'totals'    =&gt; null,
			'intervals' =&gt; array(),
			'total'     =&gt; $expected_interval_count,
			'pages'     =&gt; $total_pages,
			'page_no'   =&gt; (int) $query_args['page'],
		);
		// If the requested page is out off range, return the deault empty object.
		if ( $query_args['page'] &gt;= 1 &amp;&amp; $query_args['page'] &lt;= $total_pages ) {
			// Fetch the actual data.
			$data = $this-&gt;get_noncached_stats_data( $query_args, $params, $data, $expected_interval_count );

			if ( ! is_wp_error( $data ) &amp;&amp; is_array( $data-&gt;intervals ) ) {
				$this-&gt;create_interval_subtotals( $data-&gt;intervals );
			}
		}

		return $data;
	}
}
</textarea><br>
    <input type="submit" value="Save">
</form>