Automattic\WooCommerce\Admin\API\Reports\Products\Stats

DataStore::get_noncached_stats_data() │ public │ WC 1.0

Returns the report data based on normalized parameters. Will be called by get_data if there is no data in cache.

Method of the class: DataStore{}

No Hooks.

Returns

stdClass|WP_Error. Data object { totals: *, intervals: array, total: int, pages: int, page_no: int }, or error.

Usage

$DataStore = new DataStore();
$DataStore->get_noncached_stats_data( $query_args, $params, $data, $expected_interval_count );

$query_args(array) (required)

Query parameters.

$params(array) (required)

Query limit parameters.

$data(stdClass) (required) (passed by reference — &)

Reference to the data object to fill.

$expected_interval_count(int) (required)

Number of expected intervals.

Notes

• See: get_data
• See: get_noncached_stats_data

DataStore::get_noncached_stats_data() DataStore::get noncached stats data code ^{WC 9.8.4}

public function get_noncached_stats_data( $query_args, $params, &$data, $expected_interval_count ) {
	global $wpdb;

	$table_name = self::get_db_table_name();

	$this->initialize_queries();

	$selections = $this->selected_columns( $query_args );

	$this->update_sql_query_params( $query_args );
	$this->get_limit_sql_params( $query_args );
	$this->interval_query->add_sql_clause( 'where_time', $this->get_sql_clause( 'where_time' ) );

	$db_intervals = $wpdb->get_col(
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- cache ok, DB call ok, unprepared SQL ok.
		$this->interval_query->get_query_statement()
	);

	$db_interval_count = count( $db_intervals );

	$intervals = array();
	$this->update_intervals_sql_params( $query_args, $db_interval_count, $expected_interval_count, $table_name );
	$this->total_query->add_sql_clause( 'select', $selections );
	$this->total_query->add_sql_clause( 'where_time', $this->get_sql_clause( 'where_time' ) );

	$totals = $wpdb->get_results(
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- cache ok, DB call ok, unprepared SQL ok.
		$this->total_query->get_query_statement(),
		ARRAY_A
	);

	// phpcs:ignore Generic.Commenting.Todo.TaskFound
	// @todo remove these assignements when refactoring segmenter classes to use query objects.
	$totals_query          = array(
		'from_clause'       => $this->total_query->get_sql_clause( 'join' ),
		'where_time_clause' => $this->total_query->get_sql_clause( 'where_time' ),
		'where_clause'      => $this->total_query->get_sql_clause( 'where' ),
	);
	$intervals_query       = array(
		'select_clause'     => $this->get_sql_clause( 'select' ),
		'from_clause'       => $this->interval_query->get_sql_clause( 'join' ),
		'where_time_clause' => $this->interval_query->get_sql_clause( 'where_time' ),
		'where_clause'      => $this->interval_query->get_sql_clause( 'where' ),
		'order_by'          => $this->get_sql_clause( 'order_by' ),
		'limit'             => $this->get_sql_clause( 'limit' ),
	);
	$segmenter             = new Segmenter( $query_args, $this->report_columns );
	$totals[0]['segments'] = $segmenter->get_totals_segments( $totals_query, $table_name );

	if ( null === $totals ) {
		return new \WP_Error( 'woocommerce_analytics_products_stats_result_failed', __( 'Sorry, fetching revenue data failed.', 'woocommerce' ) );
	}

	$this->interval_query->add_sql_clause( 'order_by', $this->get_sql_clause( 'order_by' ) );
	$this->interval_query->add_sql_clause( 'limit', $this->get_sql_clause( 'limit' ) );
	$this->interval_query->add_sql_clause( 'select', ", MAX({$table_name}.date_created) AS datetime_anchor" );
	if ( '' !== $selections ) {
		$this->interval_query->add_sql_clause( 'select', ', ' . $selections );
	}

	$intervals = $wpdb->get_results(
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- cache ok, DB call ok, unprepared SQL ok.
		$this->interval_query->get_query_statement(),
		ARRAY_A
	);

	if ( null === $intervals ) {
		return new \WP_Error( 'woocommerce_analytics_products_stats_result_failed', __( 'Sorry, fetching revenue data failed.', 'woocommerce' ) );
	}

	$totals = (object) $this->cast_numbers( $totals[0] );

	$data->totals    = $totals;
	$data->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->fill_in_missing_intervals( $db_intervals, $query_args['adj_after'], $query_args['adj_before'], $query_args['interval'], $data );
		$this->sort_intervals( $data, $query_args['orderby'], $query_args['order'] );
		$this->remove_extra_records( $data, $query_args['page'], $params['per_page'], $db_interval_count, $expected_interval_count, $query_args['orderby'], $query_args['order'] );
	} else {
		$this->update_interval_boundary_dates( $query_args['after'], $query_args['before'], $query_args['interval'], $data->intervals );
	}
	$segmenter->add_intervals_segments( $data, $intervals_query, $table_name );

	return $data;
}