File "class-wc-api-reports.php"
Full path: /home/kosmetik/public_html/wp-content/plugins/woocommerce/includes/legacy/api/v1/class-wc-api-reports.php
File
size: 10.1 B
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?php
if (!defined('ABSPATH')) {
exit;
}
class WC_API_Reports extends WC_API_Resource
{
protected $base = '/reports';
private $report;
public function register_routes($routes)
{
$routes[$this->base] = array(array(array($this, 'get_reports'), WC_API_Server::READABLE));
$routes[$this->base . '/sales'] = array(array(array($this, 'get_sales_report'), WC_API_Server::READABLE));
$routes[$this->base . '/sales/top_sellers'] = array(array(array($this, 'get_top_sellers_report'), WC_API_Server::READABLE));
return $routes;
}
public function get_reports()
{
return array('reports' => array('sales', 'sales/top_sellers'));
}
public function get_sales_report($fields = null, $filter = array())
{
$check = $this->validate_request();
if (is_wp_error($check)) {
return $check;
}
$this->setup_report($filter);
$totals = $this->report->get_order_report_data(array('data' => array('_order_total' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'sales'), '_order_tax' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'tax'), '_order_shipping_tax' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'shipping_tax'), '_order_shipping' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'shipping'), 'ID' => array('type' => 'post_data', 'function' => 'COUNT', 'name' => 'order_count')), 'filter_range' => true));
$total_items = absint($this->report->get_order_report_data(array('data' => array('_qty' => array('type' => 'order_item_meta', 'order_item_type' => 'line_item', 'function' => 'SUM', 'name' => 'order_item_qty')), 'query_type' => 'get_var', 'filter_range' => true)));
$total_discount = $this->report->get_order_report_data(array('data' => array('discount_amount' => array('type' => 'order_item_meta', 'order_item_type' => 'coupon', 'function' => 'SUM', 'name' => 'discount_amount')), 'where' => array(array('key' => 'order_item_type', 'value' => 'coupon', 'operator' => '=')), 'query_type' => 'get_var', 'filter_range' => true));
$users_query = new WP_User_Query(array('fields' => array('user_registered'), 'role' => 'customer'));
$customers = $users_query->get_results();
foreach ($customers as $key => $customer) {
if (strtotime($customer->user_registered) < $this->report->start_date || strtotime($customer->user_registered) > $this->report->end_date) {
unset($customers[$key]);
}
}
$total_customers = count($customers);
$orders = $this->report->get_order_report_data(array('data' => array('_order_total' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'total_sales'), '_order_shipping' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'total_shipping'), '_order_tax' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'total_tax'), '_order_shipping_tax' => array('type' => 'meta', 'function' => 'SUM', 'name' => 'total_shipping_tax'), 'ID' => array('type' => 'post_data', 'function' => 'COUNT', 'name' => 'total_orders', 'distinct' => true), 'post_date' => array('type' => 'post_data', 'function' => '', 'name' => 'post_date')), 'group_by' => $this->report->group_by_query, 'order_by' => 'post_date ASC', 'query_type' => 'get_results', 'filter_range' => true));
$order_items = $this->report->get_order_report_data(array('data' => array('_qty' => array('type' => 'order_item_meta', 'order_item_type' => 'line_item', 'function' => 'SUM', 'name' => 'order_item_count'), 'post_date' => array('type' => 'post_data', 'function' => '', 'name' => 'post_date')), 'where' => array(array('key' => 'order_item_type', 'value' => 'line_item', 'operator' => '=')), 'group_by' => $this->report->group_by_query, 'order_by' => 'post_date ASC', 'query_type' => 'get_results', 'filter_range' => true));
$discounts = $this->report->get_order_report_data(array('data' => array('discount_amount' => array('type' => 'order_item_meta', 'order_item_type' => 'coupon', 'function' => 'SUM', 'name' => 'discount_amount'), 'post_date' => array('type' => 'post_data', 'function' => '', 'name' => 'post_date')), 'where' => array(array('key' => 'order_item_type', 'value' => 'coupon', 'operator' => '=')), 'group_by' => $this->report->group_by_query . ', order_item_name', 'order_by' => 'post_date ASC', 'query_type' => 'get_results', 'filter_range' => true));
$period_totals = array();
for ($i = 0; $i <= $this->report->chart_interval; $i++) {
switch ($this->report->chart_groupby) {
case 'day':
$time = date('Y-m-d', strtotime("+{$i} DAY", $this->report->start_date));
break;
case 'month':
$time = date('Y-m', strtotime("+{$i} MONTH", $this->report->start_date));
break;
}
$customer_count = 0;
foreach ($customers as $customer) {
if (date('day' == $this->report->chart_groupby ? 'Y-m-d' : 'Y-m', strtotime($customer->user_registered)) == $time) {
$customer_count++;
}
}
$period_totals[$time] = array('sales' => wc_format_decimal(0.0, 2), 'orders' => 0, 'items' => 0, 'tax' => wc_format_decimal(0.0, 2), 'shipping' => wc_format_decimal(0.0, 2), 'discount' => wc_format_decimal(0.0, 2), 'customers' => $customer_count);
}
foreach ($orders as $order) {
$time = 'day' === $this->report->chart_groupby ? date('Y-m-d', strtotime($order->post_date)) : date('Y-m', strtotime($order->post_date));
if (!isset($period_totals[$time])) {
continue;
}
$period_totals[$time]['sales'] = wc_format_decimal($order->total_sales, 2);
$period_totals[$time]['orders'] = (int) $order->total_orders;
$period_totals[$time]['tax'] = wc_format_decimal($order->total_tax + $order->total_shipping_tax, 2);
$period_totals[$time]['shipping'] = wc_format_decimal($order->total_shipping, 2);
}
foreach ($order_items as $order_item) {
$time = 'day' === $this->report->chart_groupby ? date('Y-m-d', strtotime($order_item->post_date)) : date('Y-m', strtotime($order_item->post_date));
if (!isset($period_totals[$time])) {
continue;
}
$period_totals[$time]['items'] = (int) $order_item->order_item_count;
}
foreach ($discounts as $discount) {
$time = 'day' === $this->report->chart_groupby ? date('Y-m-d', strtotime($discount->post_date)) : date('Y-m', strtotime($discount->post_date));
if (!isset($period_totals[$time])) {
continue;
}
$period_totals[$time]['discount'] = wc_format_decimal($discount->discount_amount, 2);
}
$sales_data = array('total_sales' => wc_format_decimal($totals->sales, 2), 'average_sales' => wc_format_decimal($totals->sales / ($this->report->chart_interval + 1), 2), 'total_orders' => (int) $totals->order_count, 'total_items' => $total_items, 'total_tax' => wc_format_decimal($totals->tax + $totals->shipping_tax, 2), 'total_shipping' => wc_format_decimal($totals->shipping, 2), 'total_discount' => is_null($total_discount) ? wc_format_decimal(0.0, 2) : wc_format_decimal($total_discount, 2), 'totals_grouped_by' => $this->report->chart_groupby, 'totals' => $period_totals, 'total_customers' => $total_customers);
return array('sales' => apply_filters('woocommerce_api_report_response', $sales_data, $this->report, $fields, $this->server));
}
public function get_top_sellers_report($fields = null, $filter = array())
{
$check = $this->validate_request();
if (is_wp_error($check)) {
return $check;
}
$this->setup_report($filter);
$top_sellers = $this->report->get_order_report_data(array('data' => array('_product_id' => array('type' => 'order_item_meta', 'order_item_type' => 'line_item', 'function' => '', 'name' => 'product_id'), '_qty' => array('type' => 'order_item_meta', 'order_item_type' => 'line_item', 'function' => 'SUM', 'name' => 'order_item_qty')), 'order_by' => 'order_item_qty DESC', 'group_by' => 'product_id', 'limit' => isset($filter['limit']) ? absint($filter['limit']) : 12, 'query_type' => 'get_results', 'filter_range' => true));
$top_sellers_data = array();
foreach ($top_sellers as $top_seller) {
$product = wc_get_product($top_seller->product_id);
$top_sellers_data[] = array('title' => $product->get_name(), 'product_id' => $top_seller->product_id, 'quantity' => $top_seller->order_item_qty);
}
return array('top_sellers' => apply_filters('woocommerce_api_report_response', $top_sellers_data, $this->report, $fields, $this->server));
}
private function setup_report($filter)
{
include_once WC()->plugin_path() . '/includes/admin/reports/class-wc-admin-report.php';
$this->report = new WC_Admin_Report();
if (empty($filter['period'])) {
$filter['period'] = 'custom';
if (!empty($filter['date_min']) || !empty($filter['date_max'])) {
$_GET['start_date'] = $this->server->parse_datetime($filter['date_min']);
$_GET['end_date'] = isset($filter['date_max']) ? $this->server->parse_datetime($filter['date_max']) : null;
} else {
$_GET['start_date'] = $_GET['end_date'] = date('Y-m-d', current_time('timestamp'));
}
} else {
if (!in_array($filter['period'], array('week', 'month', 'last_month', 'year'))) {
$filter['period'] = 'week';
}
if ('week' === $filter['period']) {
$filter['period'] = '7day';
}
}
$this->report->calculate_current_range($filter['period']);
}
protected function validate_request($id = null, $type = null, $context = null)
{
if (!current_user_can('view_woocommerce_reports')) {
return new WP_Error('woocommerce_api_user_cannot_read_report', __('You do not have permission to read this report', 'woocommerce'), array('status' => 401));
} else {
return true;
}
}
}