add-attribute-terms.php
9 months ago
add-customer.php
10 months ago
add-emails-to-coupon.php
9 months ago
add-order-note.php
11 months ago
add-product-attributes.php
9 months ago
add-product-to-cart.php
9 months ago
add-update-order-custom-fields.php
11 months ago
apply-coupon.php
9 months ago
check-cart-status.php
9 months ago
check-if-order-is-renewal.php
5 months ago
create-attribute.php
9 months ago
create-bundle-product-order.php
7 months ago
create-coupon-code.php
11 months ago
create-multi-product-order.php
8 months ago
create-new-order.php
11 months ago
create-product-variation.php
1 year ago
create-product.php
1 year ago
create-variable-product.php
9 months ago
delete-coupon.php
1 year ago
delete-customer.php
9 months ago
fetch-coupon-details.php
11 months ago
find-orders-by-user-id.php
11 months ago
get-all-customers.php
9 months ago
get-all-products.php
9 months ago
get-customer-by-email.php
9 months ago
get-customer-by-id.php
9 months ago
get-order-details-by-order-id.php
11 months ago
get-order-type-by-order-id.php
5 months ago
get-orders-by-email.php
9 months ago
get-product-by-id.php
1 year ago
list-all-order-notes.php
9 months ago
list-all-orders.php
9 months ago
remove-product-from-cart.php
9 months ago
retrieve-coupons-totals.php
11 months ago
retrieve-customers-totals.php
11 months ago
retrieve-orders-totals.php
11 months ago
retrieve-products-totals.php
11 months ago
retrieve-refunds-list.php
11 months ago
retrieve-reviews-totals.php
11 months ago
retrieve-sales-report.php
11 months ago
retrieve-top-sellers-report.php
11 months ago
update-product-price.php
9 months ago
update-product-stock-quantity.php
9 months ago
update-status-of-order.php
11 months ago
retrieve-sales-report.php
150 lines
| 1 | <?php |
| 2 | /** |
| 3 | * RetrieveSalesReport. |
| 4 | * php version 5.6 |
| 5 | * |
| 6 | * @category RetrieveSalesReport |
| 7 | * @package SureTriggers |
| 8 | * @author BSF <username@example.com> |
| 9 | * @license https://www.gnu.org/licenses/gpl-3.0.html GPLv3 |
| 10 | * @link https://www.brainstormforce.com/ |
| 11 | * @since 1.0.0 |
| 12 | */ |
| 13 | |
| 14 | namespace SureTriggers\Integrations\WooCommerce\Actions; |
| 15 | |
| 16 | use Exception; |
| 17 | use SureTriggers\Integrations\AutomateAction; |
| 18 | use SureTriggers\Traits\SingletonLoader; |
| 19 | use Automattic\WooCommerce\Admin\API\Reports\Revenue\Query; |
| 20 | |
| 21 | |
| 22 | /** |
| 23 | * RetrieveSalesReport |
| 24 | * |
| 25 | * @category RetrieveSalesReport |
| 26 | * @package SureTriggers |
| 27 | * @author BSF <username@example.com> |
| 28 | * @license https://www.gnu.org/licenses/gpl-3.0.html GPLv3 |
| 29 | * @link https://www.brainstormforce.com/ |
| 30 | * @since 1.0.0 |
| 31 | */ |
| 32 | class RetrieveSalesReport extends AutomateAction { |
| 33 | |
| 34 | /** |
| 35 | * Integration type. |
| 36 | * |
| 37 | * @var string |
| 38 | */ |
| 39 | public $integration = 'WooCommerce'; |
| 40 | |
| 41 | /** |
| 42 | * Action name. |
| 43 | * |
| 44 | * @var string |
| 45 | */ |
| 46 | public $action = 'wc_retrieve_sales_report'; |
| 47 | |
| 48 | use SingletonLoader; |
| 49 | |
| 50 | /** |
| 51 | * Register an action. |
| 52 | * |
| 53 | * @param array $actions actions. |
| 54 | * @return array |
| 55 | */ |
| 56 | public function register( $actions ) { |
| 57 | $actions[ $this->integration ][ $this->action ] = [ |
| 58 | 'label' => __( 'Retrieve Sales Report', 'suretriggers' ), |
| 59 | 'action' => $this->action, |
| 60 | 'function' => [ $this, '_action_listener' ], |
| 61 | ]; |
| 62 | return $actions; |
| 63 | } |
| 64 | |
| 65 | /** |
| 66 | * Action listener. |
| 67 | * |
| 68 | * @param int $user_id user_id. |
| 69 | * @param int $automation_id automation_id. |
| 70 | * @param array $fields fields. |
| 71 | * @param array $selected_options selectedOptions. |
| 72 | * |
| 73 | * @return array|null |
| 74 | * @throws Exception Exception. |
| 75 | */ |
| 76 | public function _action_listener( $user_id, $automation_id, $fields, $selected_options ) { |
| 77 | if ( ! class_exists( 'WooCommerce' ) ) { |
| 78 | return [ |
| 79 | 'status' => 'error', |
| 80 | 'message' => __( 'WooCommerce is not installed or activated.', 'suretriggers' ), |
| 81 | |
| 82 | ]; |
| 83 | } |
| 84 | |
| 85 | $start_date = isset( $selected_options['start_date'] ) ? $selected_options['start_date'] : gmdate( 'Y-m-d', strtotime( '-7 days' ) ); |
| 86 | $end_date = isset( $selected_options['end_date'] ) ? $selected_options['end_date'] : gmdate( 'Y-m-d' ); |
| 87 | $interval = isset( $selected_options['interval'] ) ? $selected_options['interval'] : 'week'; |
| 88 | |
| 89 | $args = [ |
| 90 | 'interval' => $interval, |
| 91 | 'after' => $start_date . ' 00:00:00', |
| 92 | 'before' => $end_date . ' 23:59:59', |
| 93 | ]; |
| 94 | |
| 95 | if ( ! class_exists( 'Automattic\\WooCommerce\\Admin\\API\\Reports\\Revenue\\Query' ) ) { |
| 96 | return [ |
| 97 | 'status' => 'error', |
| 98 | 'message' => __( 'WooCommerce Admin Reports API not available.', 'suretriggers' ), |
| 99 | |
| 100 | ]; |
| 101 | } |
| 102 | |
| 103 | $report = new Query( $args ); |
| 104 | $results = $report->get_data(); |
| 105 | |
| 106 | $totals = is_object( $results ) && isset( $results->totals ) ? $results->totals : ( isset( $results['totals'] ) ? $results['totals'] : [] ); |
| 107 | $summary = (array) $totals; |
| 108 | |
| 109 | $response = [ |
| 110 | 'orders_count' => intval( $summary['orders_count'] ), |
| 111 | 'num_items_sold' => intval( $summary['num_items_sold'] ), |
| 112 | 'gross_sales' => floatval( $summary['gross_sales'] ), |
| 113 | 'total_sales' => floatval( $summary['total_sales'] ), |
| 114 | 'net_revenue' => floatval( $summary['net_revenue'] ), |
| 115 | 'coupons' => floatval( $summary['coupons'] ), |
| 116 | 'coupons_count' => intval( $summary['coupons_count'] ), |
| 117 | 'refunds' => floatval( $summary['refunds'] ), |
| 118 | 'taxes' => floatval( $summary['taxes'] ), |
| 119 | 'shipping' => floatval( $summary['shipping'] ), |
| 120 | 'avg_items_per_order' => floatval( $summary['avg_items_per_order'] ), |
| 121 | 'avg_order_value' => floatval( $summary['avg_order_value'] ), |
| 122 | 'total_customers' => isset( $summary['total_customers'] ) ? intval( $summary['total_customers'] ) : 0, |
| 123 | 'intervals' => [], |
| 124 | ]; |
| 125 | |
| 126 | $intervals = is_object( $results ) && isset( $results->intervals ) ? $results->intervals : ( isset( $results['intervals'] ) ? $results['intervals'] : [] ); |
| 127 | |
| 128 | if ( ! empty( $intervals ) ) { |
| 129 | foreach ( $intervals as $interval ) { |
| 130 | $interval_data = is_array( $interval ) ? $interval : (array) $interval; |
| 131 | $subtotals = isset( $interval_data['subtotals'] ) ? (array) $interval_data['subtotals'] : []; |
| 132 | |
| 133 | $response['intervals'][] = [ |
| 134 | 'interval' => $interval_data['interval'], |
| 135 | 'date_start' => $interval_data['date_start'], |
| 136 | 'date_end' => $interval_data['date_end'], |
| 137 | 'orders_count' => isset( $subtotals['orders_count'] ) ? intval( $subtotals['orders_count'] ) : 0, |
| 138 | 'num_items_sold' => isset( $subtotals['num_items_sold'] ) ? intval( $subtotals['num_items_sold'] ) : 0, |
| 139 | 'total_sales' => isset( $subtotals['total_sales'] ) ? floatval( $subtotals['total_sales'] ) : 0, |
| 140 | 'net_revenue' => isset( $subtotals['net_revenue'] ) ? floatval( $subtotals['net_revenue'] ) : 0, |
| 141 | ]; |
| 142 | } |
| 143 | } |
| 144 | |
| 145 | return $response; |
| 146 | } |
| 147 | } |
| 148 | |
| 149 | RetrieveSalesReport::get_instance(); |
| 150 |