retrieve-customers-totals.php — OttoKit: All-in-One Automation Platform 1.1.36

suretriggers / src / Integrations / woocommerce / actions / retrieve-customers-totals.php

suretriggers / src / Integrations / woocommerce / actions Last commit date

retrieve-customers-totals.php

150 lines

1	<?php
2	/**
3	* RetrieveCustomersTotals.
4	* php version 5.6
5	*
6	* @category RetrieveCustomersTotals
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
20	/**
21	* RetrieveCustomersTotals
22	*
23	* @category RetrieveCustomersTotals
24	* @package SureTriggers
25	* @author BSF <username@example.com>
26	* @license https://www.gnu.org/licenses/gpl-3.0.html GPLv3
27	* @link https://www.brainstormforce.com/
28	* @since 1.0.0
29	*/
30	class RetrieveCustomersTotals extends AutomateAction {
31
32	/**
33	* Integration type.
34	*
35	* @var string
36	*/
37	public $integration = 'WooCommerce';
38
39	/**
40	* Action name.
41	*
42	* @var string
43	*/
44	public $action = 'wc_retrieve_customers_totals';
45
46	use SingletonLoader;
47
48	/**
49	* Register a action.
50	*
51	* @param array $actions actions.
52	* @return array
53	*/
54	public function register( $actions ) {
55	$actions[ $this->integration ][ $this->action ] = [
56	'label' => __( 'Retrieve Customers Totals', 'suretriggers' ),
57	'action' => 'wc_retrieve_customers_totals',
58	'function' => [ $this, 'action_listener' ],
59	];
60	return $actions;
61	}
62
63	/**
64	* Action listener.
65	*
66	* @param int $user_id user_id.
67	* @param int $automation_id automation_id.
68	* @param array $fields fields.
69	* @param array $selected_options selectedOptions.
70	*
71	* @return array\|null
72	* @throws Exception Exception.
73	*/
74	public function _action_listener( $user_id, $automation_id, $fields, $selected_options ) {
75	if ( ! class_exists( 'WooCommerce' ) ) {
76	return [
77	'status' => 'error',
78	'message' => __( 'WooCommerce is not installed or activated.', 'suretriggers' ),
79
80	];
81	}
82
83	global $wpdb;
84
85	$customer_table = $wpdb->prefix . 'wc_customer_lookup';
86	$order_stats_table = $wpdb->prefix . 'wc_order_stats';
87
88	// Validate tables exist.
89	$tables_exist = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $customer_table ) ) === $customer_table
90	&& $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $order_stats_table ) ) === $order_stats_table;
91
92	if ( ! $tables_exist ) {
93	return [
94	'status' => 'error',
95	'message' => __( 'Required WooCommerce tables not found.', 'suretriggers' ),
96
97	];
98	}
99
100	$order_stats = $wpdb->prefix . 'wc_order_stats';
101
102	// Paying customers: at least one completed order.
103	$paying = (int) $wpdb->get_var(
104	$wpdb->prepare(
105	"SELECT COUNT(DISTINCT customer_id) FROM {$wpdb->prefix}wc_order_stats WHERE status = %s",
106	'wc-completed'
107	)
108	);
109
110	// Non-paying customers: have orders but none completed.
111	$non_paying = (int) $wpdb->get_var(
112	$wpdb->prepare(
113	"SELECT COUNT(DISTINCT os.customer_id)
114	FROM {$wpdb->prefix}wc_order_stats os
115	LEFT JOIN (
116	SELECT DISTINCT customer_id
117	FROM {$wpdb->prefix}wc_order_stats
118	WHERE status = %s
119	) completed_customers ON os.customer_id = completed_customers.customer_id
120	WHERE completed_customers.customer_id IS NULL",
121	'wc-completed'
122	)
123	);
124
125	if ( 0 === $paying && 0 === $non_paying ) {
126	return [
127	'status' => 'error',
128	'message' => __( 'No customers found.', 'suretriggers' ),
129
130	];
131	}
132
133	return [
134	[
135	'slug' => 'paying',
136	'name' => 'Paying Customers',
137	'total' => $paying,
138	],
139	[
140	'slug' => 'non_paying',
141	'name' => 'Non-paying Customers',
142	'total' => $non_paying,
143	],
144	];
145
146	}
147	}
148
149	RetrieveCustomersTotals::get_instance();
150