give / src / Tracking / TrackingData / DonationFormsData.php

DonationFormsData.php in GiveWP – Donation Plugin and Fundraising Platform 2.16.0, at src/Tracking/TrackingData/DonationFormsData.php

231 lines 5.5 KB

Raw Download Zip

1	<?php
2	namespace Give\Tracking\TrackingData;
3
4	use Give\Framework\Database\DB;
5	use Give\Helpers\ArrayDataSet;
6	use Give\Helpers\Form\Template;
7	use Give\Tracking\Contracts\TrackData;
8	use Give\Tracking\Helpers\DonationStatuses;
9	use Give\Tracking\Repositories\TrackEvents;
10
11	/**
12	* Class DonationFormsData
13	*
14	* Represents donation forms data
15	*
16	* @since 2.10.0
17	* @package Give\Tracking\TrackingData
18	*/
19	class DonationFormsData implements TrackData {
20	protected $formIds = [];
21	protected $formRevenues = [];
22	protected $formDonorCounts = [];
23
24	/**
25	* @var TrackEvents
26	*/
27	protected $trackEvents;
28
29	/**
30	* DonationFormsData constructor.
31	*
32	* @param TrackEvents $trackEvents
33	*/
34	public function __construct( TrackEvents $trackEvents ) {
35	$this->trackEvents = $trackEvents;
36	}
37
38	/**
39	* @inheritdoc
40	*/
41	public function get() {
42	$this->setFormIds();
43
44	if ( ! $this->formIds ) {
45	return [];
46	}
47
48	$this->setRevenues()
49	->setDonorCounts();
50
51	return $this->getData();
52	}
53
54	/**
55	* Get forms data.
56	*
57	* @since 2.10.0
58	* @return array
59	*/
60	protected function getData() {
61	if ( ! $this->formIds ) {
62	return [];
63	}
64
65	$data = [];
66
67	foreach ( $this->formIds as $formId ) {
68	$formTemplate = Template::getActiveID( $formId );
69
70	$temp = [
71	'form_id' => (int) $formId,
72	'form_url' => untrailingslashit( get_permalink( $formId ) ),
73	'form_name' => get_post_field( 'post_name', $formId, 'db' ),
74	'form_type' => give()->form_meta->get_meta( $formId, '_give_price_option', true ),
75	'form_template' => ! $formTemplate \|\| 'legacy' === $formTemplate ? 'legacy' : $formTemplate,
76	'donor_count' => $this->formDonorCounts[ $formId ],
77	'revenue' => $this->formRevenues[ $formId ],
78	];
79
80	$this->addAddonsInformation( $temp, $formId );
81	$data[] = $temp;
82	}
83
84	return $data;
85	}
86
87	/**
88	* Set form ids.
89	*
90	* @since 2.10.0
91	* @return self
92	*/
93	protected function setFormIds() {
94	global $wpdb;
95
96	$statues = DonationStatuses::getCompletedDonationsStatues( true );
97	$time = $this->trackEvents->getRequestTime();
98
99	$this->formIds = DB::get_col(
100	"
101	SELECT DISTINCT dm.meta_value
102	FROM {$wpdb->donationmeta} as dm
103	INNER JOIN {$wpdb->posts} as p ON dm.donation_id = p.ID
104	INNER JOIN {$wpdb->donationmeta} as dm2 ON dm.donation_id = dm2.donation_id
105	WHERE p.post_status IN ({$statues})
106	AND p.post_date>='{$time}'
107	AND p.post_type='give_payment'
108	AND dm2.meta_key='_give_payment_mode'
109	AND dm2.meta_value='live'
110	AND dm.meta_key='_give_payment_form_id'
111	"
112	);
113
114	return $this;
115	}
116
117	/**
118	* Set forms revenues.
119	*
120	* @since 2.10.0
121	* @return self
122	*/
123	protected function setRevenues() {
124	global $wpdb;
125
126	$formIds = ArrayDataSet::getStringSeparatedByCommaEnclosedWithSingleQuote( $this->formIds );
127	$defaultResult = array_combine(
128	$this->formIds,
129	array_fill( 0, count( $this->formIds ), 0 ) // Set default revenue to 0
130	);
131
132	$result = DB::get_results(
133	"
134	SELECT SUM(r.amount) as amount, r.form_id
135	FROM {$wpdb->give_revenue} as r
136	INNER JOIN {$wpdb->donationmeta} as dm ON r.donation_id = dm.donation_id
137	WHERE dm.meta_key='_give_payment_mode'
138	AND dm.meta_value='live'
139	AND r.form_id IN ({$formIds})
140	GROUP BY form_id
141	",
142	ARRAY_A
143	);
144
145	if ( $result ) {
146	$result = array_map(
147	'absint',
148	array_combine(
149	wp_list_pluck( $result, 'form_id' ),
150	wp_list_pluck( $result, 'amount' )
151	)
152	);
153	}
154
155	$this->formRevenues = array_replace( $defaultResult, $result );
156
157	return $this;
158	}
159
160	/**
161	* Set forms revenues till current date.
162	*
163	* @since 2.10.0
164	*
165	* @return self
166	*/
167	protected function setDonorCounts() {
168	global $wpdb;
169
170	$formIds = ArrayDataSet::getStringSeparatedByCommaEnclosedWithSingleQuote( $this->formIds );
171	$statues = DonationStatuses::getCompletedDonationsStatues( true );
172	$defaultResult = array_combine(
173	$this->formIds,
174	array_fill( 0, count( $this->formIds ), 0 ) // Set default donor count to 0
175	);
176
177	$result = DB::get_results(
178	"
179	SELECT COUNT(DISTINCT dm2.meta_value) as donor_count, dm.meta_value as form_id
180	FROM {$wpdb->donationmeta} as dm
181	INNER JOIN {$wpdb->posts} as p ON donation_id = p.ID
182	INNER JOIN {$wpdb->donationmeta} as dm2 ON dm.donation_id = dm2.donation_id
183	INNER JOIN {$wpdb->donors} as donor ON dm2.meta_value = donor.id
184	INNER JOIN {$wpdb->donationmeta} as dm3 ON dm.donation_id = dm3.donation_id
185	WHERE p.post_status IN ({$statues})
186	AND dm3.meta_key='_give_payment_mode'
187	AND dm3.meta_value='live'
188	AND dm.meta_key='_give_payment_form_id'
189	AND dm.meta_value IN ({$formIds})
190	AND dm2.meta_key='_give_payment_donor_id'
191	AND donor.purchase_value > 0
192	GROUP BY dm.meta_value
193	",
194	ARRAY_A
195	);
196
197	if ( $result ) {
198	$result = array_map(
199	'absint',
200	array_combine(
201	wp_list_pluck( $result, 'form_id' ),
202	wp_list_pluck( $result, 'donor_count' )
203	)
204	);
205	}
206
207	$this->formDonorCounts = array_replace( $defaultResult, $result );
208
209	return $this;
210	}
211
212	/**
213	* Add addon information whether or not they active for donation form.
214	*
215	* @since 2.10.0
216	*
217	* @param array $array
218	* @param int $formId
219	*/
220	private function addAddonsInformation( &$array, $formId ) {
221	$array = array_merge(
222	$array,
223	[
224	'recurring_donations' => (int) apply_filters( 'give_telemetry_form_uses_addon_recurring', false, $formId ),
225	'fee_recovery' => (int) apply_filters( 'give_telemetry_form_uses_addon_fee_recovery', false, $formId ),
226	'form_field_manager' => (int) apply_filters( 'give_telemetry_form_uses_addon_form_field_manager', false, $formId ),
227	]
228	);
229	}
230	}
231