<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Class for parameter-based Revenue Reports querying

[2] Fix | Delete

*

[3] Fix | Delete

* Example usage:

[4] Fix | Delete

* $args = array(

[5] Fix | Delete

* 'before' => '2018-07-19 00:00:00',

[6] Fix | Delete

* 'after' => '2018-07-05 00:00:00',

[7] Fix | Delete

* 'interval' => 'week',

[8] Fix | Delete

* );

[9] Fix | Delete

* $report = new \Automattic\WooCommerce\Admin\API\Reports\Revenue\Query( $args );

[10] Fix | Delete

* $mydata = $report->get_data();

[11] Fix | Delete

*/

[12] Fix | Delete

[13] Fix | Delete

namespace Automattic\WooCommerce\Admin\API\Reports\Revenue;

[14] Fix | Delete

[15] Fix | Delete

defined( 'ABSPATH' ) || exit;

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* API\Reports\Revenue\Query

[19] Fix | Delete

*

[20] Fix | Delete

* This query uses inconsistent names:

[21] Fix | Delete

* - `report-revenue-stats` data store

[22] Fix | Delete

* - `woocommerce_analytics_revenue_*` filters

[23] Fix | Delete

* So, for backward compatibility, we cannot use GenericQuery.

[24] Fix | Delete

*/

[25] Fix | Delete

class Query extends \WC_Object_Query {

[26] Fix | Delete

[27] Fix | Delete

/**

[28] Fix | Delete

* Valid fields for Revenue report.

[29] Fix | Delete

*

[30] Fix | Delete

* @return array

[31] Fix | Delete

*/

[32] Fix | Delete

protected function get_default_query_vars() {

[33] Fix | Delete

return array(

[34] Fix | Delete

'per_page' => get_option( 'posts_per_page' ), // not sure if this should be the default.

[35] Fix | Delete

'page' => 1,

[36] Fix | Delete

'order' => 'DESC',

[37] Fix | Delete

'orderby' => 'date',

[38] Fix | Delete

'before' => '',

[39] Fix | Delete

'after' => '',

[40] Fix | Delete

'interval' => 'week',

[41] Fix | Delete

'fields' => array(

[42] Fix | Delete

'orders_count',

[43] Fix | Delete

'num_items_sold',

[44] Fix | Delete

'total_sales',

[45] Fix | Delete

'coupons',

[46] Fix | Delete

'coupons_count',

[47] Fix | Delete

'refunds',

[48] Fix | Delete

'taxes',

[49] Fix | Delete

'shipping',

[50] Fix | Delete

'net_revenue',

[51] Fix | Delete

'gross_sales',

[52] Fix | Delete

),

[53] Fix | Delete

);

[54] Fix | Delete

}

[55] Fix | Delete

[56] Fix | Delete

/**

[57] Fix | Delete

* Get revenue data based on the current query vars.

[58] Fix | Delete

*

[59] Fix | Delete

* @return array

[60] Fix | Delete

*/

[61] Fix | Delete

public function get_data() {

[62] Fix | Delete

$args = apply_filters( 'woocommerce_analytics_revenue_query_args', $this->get_query_vars() );

[63] Fix | Delete

[64] Fix | Delete

$data_store = \WC_Data_Store::load( 'report-revenue-stats' );

[65] Fix | Delete

$results = $data_store->get_data( $args );

[66] Fix | Delete

return apply_filters( 'woocommerce_analytics_revenue_select_query', $results, $args );

[67] Fix | Delete

}

[68] Fix | Delete

}

[69] Fix | Delete

[70] Fix | Delete