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
2 weeks ago
create-variable-product.php
2 weeks 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-top-sellers-report.php
139 lines
| 1 | <?php |
| 2 | /** |
| 3 | * RetrieveTopSellersReport. |
| 4 | * php version 5.6 |
| 5 | * |
| 6 | * @category RetrieveTopSellersReport |
| 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\Products\Query; |
| 20 | |
| 21 | /** |
| 22 | * RetrieveTopSellersReport |
| 23 | * |
| 24 | * @category RetrieveTopSellersReport |
| 25 | * @package SureTriggers |
| 26 | * @author BSF <username@example.com> |
| 27 | * @license https://www.gnu.org/licenses/gpl-3.0.html GPLv3 |
| 28 | * @link https://www.brainstormforce.com/ |
| 29 | * @since 1.0.0 |
| 30 | */ |
| 31 | class RetrieveTopSellersReport extends AutomateAction { |
| 32 | |
| 33 | /** |
| 34 | * Integration type. |
| 35 | * |
| 36 | * @var string |
| 37 | */ |
| 38 | public $integration = 'WooCommerce'; |
| 39 | |
| 40 | /** |
| 41 | * Action name. |
| 42 | * |
| 43 | * @var string |
| 44 | */ |
| 45 | public $action = 'wc_retrieve_top_sellers_report'; |
| 46 | |
| 47 | use SingletonLoader; |
| 48 | |
| 49 | /** |
| 50 | * Register a action. |
| 51 | * |
| 52 | * @param array $actions actions. |
| 53 | * @return array |
| 54 | */ |
| 55 | public function register( $actions ) { |
| 56 | $actions[ $this->integration ][ $this->action ] = [ |
| 57 | 'label' => __( 'Retrieve Top Sellers Report', 'suretriggers' ), |
| 58 | 'action' => 'wc_retrieve_top_sellers_report', |
| 59 | 'function' => [ $this, 'action_listener' ], |
| 60 | ]; |
| 61 | return $actions; |
| 62 | } |
| 63 | |
| 64 | /** |
| 65 | * Action listener. |
| 66 | * |
| 67 | * @param int $user_id user_id. |
| 68 | * @param int $automation_id automation_id. |
| 69 | * @param array $fields fields. |
| 70 | * @param array $selected_options selectedOptions. |
| 71 | * |
| 72 | * @return array|null |
| 73 | * @throws Exception Exception. |
| 74 | */ |
| 75 | public function _action_listener( $user_id, $automation_id, $fields, $selected_options ) { |
| 76 | if ( ! class_exists( 'WooCommerce' ) ) { |
| 77 | return [ |
| 78 | 'status' => 'error', |
| 79 | 'message' => __( 'WooCommerce is not installed or activated.', 'suretriggers' ), |
| 80 | |
| 81 | ]; |
| 82 | } |
| 83 | |
| 84 | $date_after = isset( $selected_options['date_after'] ) ? $selected_options['date_after'] : ''; |
| 85 | $date_before = isset( $selected_options['date_before'] ) ? $selected_options['date_before'] : ''; |
| 86 | |
| 87 | $args = [ |
| 88 | 'limit' => 50, |
| 89 | ]; |
| 90 | |
| 91 | if ( ! empty( $date_after ) ) { |
| 92 | $args['after'] = $date_after . ' 00:00:00'; |
| 93 | } |
| 94 | |
| 95 | if ( ! empty( $date_before ) ) { |
| 96 | $args['before'] = $date_before . ' 23:59:59'; |
| 97 | } |
| 98 | |
| 99 | if ( ! class_exists( 'Automattic\\WooCommerce\\Admin\\API\\Reports\\Products\\Query' ) ) { |
| 100 | return [ |
| 101 | 'status' => 'error', |
| 102 | 'message' => __( 'WooCommerce Admin Reports API not available.', 'suretriggers' ), |
| 103 | |
| 104 | ]; |
| 105 | } |
| 106 | |
| 107 | $report = new Query( $args ); |
| 108 | $results = $report->get_data(); |
| 109 | |
| 110 | $data = is_object( $results ) && isset( $results->data ) ? $results->data : ( isset( $results['data'] ) ? $results['data'] : [] ); |
| 111 | |
| 112 | if ( empty( $data ) ) { |
| 113 | return []; |
| 114 | } |
| 115 | |
| 116 | $top_sellers = []; |
| 117 | foreach ( $data as $product_data ) { |
| 118 | if ( is_array( $product_data ) ) { |
| 119 | $product_data = (object) $product_data; |
| 120 | } |
| 121 | |
| 122 | $product = wc_get_product( $product_data->product_id ); |
| 123 | if ( $product ) { |
| 124 | $top_sellers[] = [ |
| 125 | 'title' => $product->get_name(), |
| 126 | 'product_id' => (int) $product_data->product_id, |
| 127 | 'quantity' => (int) $product_data->items_sold, |
| 128 | 'net_revenue' => (int) $product_data->net_revenue, |
| 129 | 'orders_count' => (int) $product_data->orders_count, |
| 130 | ]; |
| 131 | } |
| 132 | } |
| 133 | |
| 134 | return $top_sellers; |
| 135 | } |
| 136 | } |
| 137 | |
| 138 | RetrieveTopSellersReport::get_instance(); |
| 139 |