give / src / Donors / DonorsQuery.php

DonorsQuery.php in GiveWP – Donation Plugin and Fundraising Platform 4.16.8.1, at src/Donors/DonorsQuery.php

156 lines 4.2 KB

Raw Download Zip

1	<?php
2
3	namespace Give\Donors;
4
5	use Give\Donations\ValueObjects\DonationMetaKeys;
6	use Give\Donors\Models\Donor;
7	use Give\Framework\Models\ModelQueryBuilder;
8	use Give\Framework\QueryBuilder\JoinQueryBuilder;
9	use Give\Framework\QueryBuilder\QueryBuilder;
10
11	/**
12	* @since 4.4.0
13	*/
14	class DonorsQuery
15	{
16	/**
17	* @var ModelQueryBuilder<Donor>
18	*/
19	protected $query;
20
21	/**
22	* @since 4.4.0
23	*/
24	public function __construct()
25	{
26	$this->query = Donor::query();
27	}
28
29	/**
30	* Delegates methods not defined locally to the underlying query.
31	*
32	* @since 4.4.0
33	*
34	* @return mixed
35	*/
36	public function __call(string $method, array $args)
37	{
38	if (method_exists($this, $method)) {
39	return $this->$method(...$args);
40	}
41
42	return $this->query->$method(...$args);
43	}
44
45	/**
46	* @since 4.8.0 Fix subqueries to not return duplicate donors
47	* @since 4.4.0
48	*/
49	public function whereDonorsHaveDonations(
50	string $mode = '',
51	int $campaignId = 0,
52	bool $excludeAnonymousDonors = true
53	): self {
54	if (empty($mode)) {
55	$mode = give_is_test_mode() ? 'test' : 'live';
56	}
57
58	$this->query->whereExists(function (QueryBuilder $builder) use ($mode, $campaignId, $excludeAnonymousDonors) {
59	$builder
60	->select('1')
61	->from('give_donationmeta', 'dm1')
62	->join(function (JoinQueryBuilder $joinBuilder) use ($mode) {
63	$joinBuilder
64	->innerJoin('give_donationmeta', 'dm2')
65	->on('dm2.donation_id', 'dm1.donation_id')
66	->andOn('dm2.meta_key', DonationMetaKeys::MODE, true)
67	->andOn('dm2.meta_value', $mode, true);
68	})
69	->join(function (JoinQueryBuilder $joinBuilder) {
70	$joinBuilder
71	->innerJoin('posts', 'p')
72	->on('p.ID', 'dm1.donation_id')
73	->andOn('p.post_type', 'give_payment', true);
74	})
75	->whereIn('p.post_status', ['publish', 'give_subscription'])
76	->where('dm1.meta_key', DonationMetaKeys::DONOR_ID)
77	->whereRaw(sprintf('AND dm1.meta_value = %s', $this->query->prefixTable('give_donors.id')));
78
79	if ($campaignId) {
80	$builder->join(function (JoinQueryBuilder $joinBuilder) use ($campaignId) {
81	$joinBuilder
82	->innerJoin('give_donationmeta', 'dm3')
83	->on('dm3.donation_id', 'dm1.donation_id')
84	->andOn('dm3.meta_key', DonationMetaKeys::CAMPAIGN_ID, true)
85	->andOn('dm3.meta_value', $campaignId, true);
86	});
87	}
88
89	if ($excludeAnonymousDonors) {
90	$builder->join(function (JoinQueryBuilder $joinBuilder) {
91	$joinBuilder
92	->innerJoin('give_donationmeta', 'dm4')
93	->on('dm4.donation_id', 'dm1.donation_id')
94	->andOn('dm4.meta_key', DonationMetaKeys::ANONYMOUS, true)
95	->andOn('dm4.meta_value', '0', true);
96	});
97	}
98	});
99
100	return $this;
101	}
102
103	/**
104	* @since 4.4.0
105	*/
106	public function limit(int $limit): self
107	{
108	$this->query->limit($limit);
109
110	return $this;
111	}
112
113	/**
114	* @since 4.4.0
115	*/
116	public function offset(int $offset): self
117	{
118	$this->query->offset($offset);
119
120	return $this;
121	}
122
123	/**
124	* @since 4.4.0
125	*/
126	public function orderBy(string $column, string $direction = 'ASC'): self
127	{
128	$this->query->orderBy($column, $direction);
129
130	return $this;
131	}
132
133	/**
134	* @since 4.4.0
135	*/
136	public function getAll(): array
137	{
138	return $this->query->getAll() ?? [];
139	}
140
141	/**
142	* Clone the query builder.
143	*
144	* @since 4.14.0
145	*
146	* @return self
147	*/
148	public function clone(): self
149	{
150	$cloned = new self();
151	$cloned->query = clone $this->query;
152
153	return $cloned;
154	}
155	}
156