DonorsExport.php
185 lines
| 1 | <?php |
| 2 | |
| 3 | namespace Give\Exports; |
| 4 | |
| 5 | use Give\Framework\Database\DB; |
| 6 | use Give\Framework\QueryBuilder\JoinQueryBuilder; |
| 7 | use Give_Batch_Export; |
| 8 | |
| 9 | /** |
| 10 | * @since 2.21.2 |
| 11 | */ |
| 12 | class DonorsExport extends Give_Batch_Export |
| 13 | { |
| 14 | /** @inheritdoc */ |
| 15 | public $export_type = 'donors'; |
| 16 | |
| 17 | /** @var array */ |
| 18 | protected $postedData; |
| 19 | |
| 20 | /** @var String */ |
| 21 | protected $startDate; |
| 22 | |
| 23 | /** @var String */ |
| 24 | protected $endDate; |
| 25 | |
| 26 | /** @var String */ |
| 27 | protected $searchBy; |
| 28 | |
| 29 | /** |
| 30 | * @inheritdoc |
| 31 | */ |
| 32 | public function set_properties($request) |
| 33 | { |
| 34 | $this->postedData = $request; |
| 35 | |
| 36 | if ($this->postedData['giveDonorExport-startDate']) { |
| 37 | $this->startDate = date('Y-m-d', strtotime($this->postedData['giveDonorExport-startDate'])); |
| 38 | } |
| 39 | |
| 40 | if ($this->postedData['giveDonorExport-endDate']) { |
| 41 | $this->endDate = date('Y-m-d', strtotime($this->postedData['giveDonorExport-endDate'])); |
| 42 | } |
| 43 | |
| 44 | if ($this->postedData['searchBy']) { |
| 45 | $this->searchBy = $this->postedData['searchBy']; |
| 46 | } |
| 47 | } |
| 48 | |
| 49 | /** |
| 50 | * @since 2.29.0 Include donor created date |
| 51 | * @since 2.21.2 |
| 52 | */ |
| 53 | public function get_data(): array |
| 54 | { |
| 55 | $donorQuery = DB::table('give_donors', 'donors') |
| 56 | ->distinct() |
| 57 | ->select( |
| 58 | ['donors.name', 'full_name'], |
| 59 | ['donors.email', 'email'], |
| 60 | ['donors.user_id', 'userid'], |
| 61 | ['donors.date_created', 'donor_created_date'], |
| 62 | ['donors.purchase_count', 'donations'], |
| 63 | ['donors.purchase_value', 'donation_sum'] |
| 64 | ); |
| 65 | |
| 66 | $donationQuery = DB::table('posts', 'donations') |
| 67 | ->select('donations.ID', ['meta.meta_value', 'donorId']) |
| 68 | ->join(function (JoinQueryBuilder $builder) { |
| 69 | $builder |
| 70 | ->leftJoin('give_donationmeta', 'meta') |
| 71 | ->on('donations.ID', 'meta.donation_id') |
| 72 | ->andOn('meta.meta_key', '_give_payment_donor_id', true); |
| 73 | }) |
| 74 | ->where('donations.post_type', 'give_payment'); |
| 75 | |
| 76 | if ($this->searchBy === 'donor') { |
| 77 | if ($this->startDate && $this->endDate) { |
| 78 | $donorQuery->whereBetween('DATE(donors.date_created)', $this->startDate, $this->endDate); |
| 79 | } elseif ($this->startDate) { |
| 80 | $donorQuery->where('DATE(donors.date_created)', $this->startDate, '>='); |
| 81 | } elseif ($this->endDate) { |
| 82 | $donorQuery->where('DATE(donors.date_created)', $this->endDate, '<='); |
| 83 | } |
| 84 | } else { |
| 85 | if ($this->startDate && $this->endDate) { |
| 86 | $donationQuery->whereBetween('DATE(donations.post_date)', $this->startDate, $this->endDate); |
| 87 | } elseif ($this->startDate) { |
| 88 | $donationQuery->where('DATE(donations.post_date)', $this->startDate, '>='); |
| 89 | } elseif ($this->endDate) { |
| 90 | $donationQuery->where('DATE(donations.post_date)', $this->endDate, '<='); |
| 91 | } |
| 92 | } |
| 93 | |
| 94 | $donorQuery->joinRaw("JOIN ({$donationQuery->getSQL()}) AS sub ON donors.id = sub.donorId"); |
| 95 | |
| 96 | if ($this->shouldIncludeAddress()) { |
| 97 | $donorQuery->attachMeta( |
| 98 | 'give_donormeta', |
| 99 | 'donors.ID', |
| 100 | 'donor_id', |
| 101 | ['_give_donor_address_billing_line1_0', 'address_line1'], |
| 102 | ['_give_donor_address_billing_line2_0', 'address_line2'], |
| 103 | ['_give_donor_address_billing_city_0', 'address_city'], |
| 104 | ['_give_donor_address_billing_state_0', 'address_state'], |
| 105 | ['_give_donor_address_billing_zip_0', 'address_zip'], |
| 106 | ['_give_donor_address_billing_country_0', 'address_country'] |
| 107 | ); |
| 108 | } |
| 109 | |
| 110 | return $this->filterExportData( |
| 111 | array_map(function ($row) { |
| 112 | return array_intersect_key($row, $this->csv_cols()); |
| 113 | }, $donorQuery->getAll(ARRAY_A)) |
| 114 | ); |
| 115 | } |
| 116 | |
| 117 | /** |
| 118 | * @since 2.21.2 |
| 119 | */ |
| 120 | protected function shouldIncludeAddress(): bool |
| 121 | { |
| 122 | return isset($this->postedData['give_export_columns']['address']); |
| 123 | } |
| 124 | |
| 125 | /** |
| 126 | * @since 2.21.2 |
| 127 | */ |
| 128 | protected function filterExportData(array $exportData): array |
| 129 | { |
| 130 | /** |
| 131 | * @since 2.21.2 |
| 132 | * |
| 133 | * @param array $exportData |
| 134 | */ |
| 135 | return apply_filters("give_export_get_data_{$this->export_type}", $exportData); |
| 136 | } |
| 137 | |
| 138 | /** |
| 139 | * @since 2.29.0 Include donor created col |
| 140 | * @since 2.21.2 |
| 141 | */ |
| 142 | public function csv_cols(): array |
| 143 | { |
| 144 | return $this->flattenAddressColumn( |
| 145 | array_intersect_key([ |
| 146 | 'full_name' => __('Name', 'give'), |
| 147 | 'email' => __('Email', 'give'), |
| 148 | 'address' => [ |
| 149 | 'address_line1' => __('Address', 'give'), |
| 150 | 'address_line2' => __('Address 2', 'give'), |
| 151 | 'address_city' => __('City', 'give'), |
| 152 | 'address_state' => __('State', 'give'), |
| 153 | 'address_zip' => __('Zip', 'give'), |
| 154 | 'address_country' => __('Country', 'give'), |
| 155 | ], |
| 156 | 'userid' => __('User ID', 'give'), |
| 157 | 'donor_created_date' => __('Donor Created', 'give'), |
| 158 | 'donations' => __('Number of donations', 'give'), |
| 159 | 'donation_sum' => __('Total Donated', 'give'), |
| 160 | ], $this->postedData['give_export_columns']) |
| 161 | ); |
| 162 | } |
| 163 | |
| 164 | /** |
| 165 | * @since 2.21.2 |
| 166 | */ |
| 167 | protected function flattenAddressColumn(array $columnarData): array |
| 168 | { |
| 169 | return $this->flattenColumn($columnarData, 'address'); |
| 170 | } |
| 171 | |
| 172 | /** |
| 173 | * @since 2.21.2 |
| 174 | */ |
| 175 | protected function flattenColumn(array $columnarData, string $columnName): array |
| 176 | { |
| 177 | if (isset($columnarData[$columnName])) { |
| 178 | $columnarData = array_merge($columnarData, $columnarData[$columnName]); |
| 179 | unset($columnarData[$columnName]); |
| 180 | } |
| 181 | |
| 182 | return $columnarData; |
| 183 | } |
| 184 | } |
| 185 |