CampaignRequestController.php
306 lines
| 1 | <?php |
| 2 | |
| 3 | namespace Give\Campaigns\Controllers; |
| 4 | |
| 5 | use Exception; |
| 6 | use Give\Campaigns\Models\Campaign; |
| 7 | use Give\Campaigns\Models\CampaignPage; |
| 8 | use Give\Campaigns\Repositories\CampaignRepository; |
| 9 | use Give\Campaigns\Repositories\CampaignsDataRepository; |
| 10 | use Give\Campaigns\ValueObjects\CampaignGoalType; |
| 11 | use Give\Campaigns\ValueObjects\CampaignPageStatus; |
| 12 | use Give\Campaigns\ValueObjects\CampaignRoute; |
| 13 | use Give\Campaigns\ValueObjects\CampaignStatus; |
| 14 | use Give\Campaigns\ValueObjects\CampaignType; |
| 15 | use Give\Campaigns\ViewModels\CampaignViewModel; |
| 16 | use Give\Donations\ValueObjects\DonationMetaKeys; |
| 17 | use Give\Framework\Database\DB; |
| 18 | use Give\Framework\Models\ModelQueryBuilder; |
| 19 | use WP_Error; |
| 20 | use WP_REST_Request; |
| 21 | use WP_REST_Response; |
| 22 | |
| 23 | /** |
| 24 | * @since 4.0.0 |
| 25 | */ |
| 26 | class CampaignRequestController |
| 27 | { |
| 28 | /** |
| 29 | * @since 4.0.0 |
| 30 | * |
| 31 | * @return WP_Error | WP_REST_Response |
| 32 | */ |
| 33 | public function getCampaign(WP_REST_Request $request) |
| 34 | { |
| 35 | $campaign = Campaign::find($request->get_param('id')); |
| 36 | |
| 37 | if (!$campaign) { |
| 38 | return new WP_Error('campaign_not_found', __('Campaign not found', 'give'), ['status' => 404]); |
| 39 | } |
| 40 | |
| 41 | return new WP_REST_Response((new CampaignViewModel($campaign))->exports()); |
| 42 | } |
| 43 | |
| 44 | /** |
| 45 | * @since 4.0.0 |
| 46 | */ |
| 47 | public function getCampaigns(WP_REST_Request $request): WP_REST_Response |
| 48 | { |
| 49 | $ids = $request->get_param('ids'); |
| 50 | $page = $request->get_param('page'); |
| 51 | $perPage = $request->get_param('per_page'); |
| 52 | $status = $request->get_param('status'); |
| 53 | $sortBy = $request->get_param('sortBy'); |
| 54 | $orderBy = $request->get_param('orderBy'); |
| 55 | |
| 56 | $query = Campaign::query(); |
| 57 | |
| 58 | $query->whereIn('status', $status); |
| 59 | |
| 60 | if (!empty($ids)) { |
| 61 | $query->whereIn('id', $ids); |
| 62 | } |
| 63 | |
| 64 | $totalQuery = clone $query; |
| 65 | |
| 66 | $query |
| 67 | ->limit($perPage) |
| 68 | ->offset(($page - 1) * $perPage); |
| 69 | |
| 70 | $this->orderCampaigns($query, $sortBy, $orderBy); |
| 71 | |
| 72 | $campaigns = $query->getAll() ?? []; |
| 73 | $totalCampaigns = empty($campaigns) ? 0 : $totalQuery->count(); |
| 74 | $totalPages = $totalCampaigns === 0 ? 0 : (int)ceil($totalCampaigns / $perPage); |
| 75 | |
| 76 | $ids = array_map(function ($campaign) { |
| 77 | return $campaign->id; |
| 78 | }, $campaigns); |
| 79 | |
| 80 | // We don't have to optimize if the number of campaigns is less than 3 |
| 81 | $campaignsData = count($ids) >= 3 |
| 82 | ? CampaignsDataRepository::campaigns($ids) |
| 83 | : null; |
| 84 | |
| 85 | $campaigns = array_map(function ($campaign) use ($campaignsData) { |
| 86 | $view = new CampaignViewModel($campaign); |
| 87 | |
| 88 | if ($campaignsData) { |
| 89 | $view->setData($campaignsData); |
| 90 | } |
| 91 | |
| 92 | return $view->exports(); |
| 93 | }, $campaigns); |
| 94 | |
| 95 | $response = rest_ensure_response($campaigns); |
| 96 | $response->header('X-WP-Total', $totalCampaigns); |
| 97 | $response->header('X-WP-TotalPages', $totalPages); |
| 98 | |
| 99 | $base = add_query_arg( |
| 100 | map_deep($request->get_query_params(), function ($value) { |
| 101 | if (is_bool($value)) { |
| 102 | $value = $value ? 'true' : 'false'; |
| 103 | } |
| 104 | |
| 105 | return urlencode($value); |
| 106 | }), |
| 107 | rest_url(CampaignRoute::CAMPAIGNS) |
| 108 | ); |
| 109 | |
| 110 | if ($page > 1) { |
| 111 | $prevPage = $page - 1; |
| 112 | |
| 113 | if ($prevPage > $totalPages) { |
| 114 | $prevPage = $totalPages; |
| 115 | } |
| 116 | |
| 117 | $response->link_header('prev', add_query_arg('page', $prevPage, $base)); |
| 118 | } |
| 119 | |
| 120 | if ($totalPages > $page) { |
| 121 | $nextPage = $page + 1; |
| 122 | $response->link_header('next', add_query_arg('page', $nextPage, $base)); |
| 123 | } |
| 124 | |
| 125 | return $response; |
| 126 | } |
| 127 | |
| 128 | /** |
| 129 | * @since 4.0.0 |
| 130 | * |
| 131 | * @return WP_Error | WP_REST_Response |
| 132 | * |
| 133 | * @throws Exception |
| 134 | */ |
| 135 | public function updateCampaign(WP_REST_Request $request) |
| 136 | { |
| 137 | $campaign = Campaign::find($request->get_param('id')); |
| 138 | |
| 139 | if (!$campaign) { |
| 140 | return new WP_Error('campaign_not_found', __('Campaign not found', 'give'), ['status' => 404]); |
| 141 | } |
| 142 | |
| 143 | $statusMap = [ |
| 144 | 'archived' => CampaignStatus::ARCHIVED(), |
| 145 | 'draft' => CampaignStatus::DRAFT(), |
| 146 | 'active' => CampaignStatus::ACTIVE(), |
| 147 | ]; |
| 148 | |
| 149 | foreach ($request->get_params() as $key => $value) { |
| 150 | switch ($key) { |
| 151 | case 'id': |
| 152 | break; |
| 153 | case 'status': |
| 154 | $status = array_key_exists($value, $statusMap) |
| 155 | ? $statusMap[$value] |
| 156 | : CampaignStatus::DRAFT(); |
| 157 | |
| 158 | $campaign->status = $status; |
| 159 | |
| 160 | break; |
| 161 | case 'goal': |
| 162 | $campaign->goal = (int)$value; |
| 163 | break; |
| 164 | case 'goalType': |
| 165 | $campaign->goalType = new CampaignGoalType($value); |
| 166 | break; |
| 167 | case 'defaultFormId': |
| 168 | give(CampaignRepository::class)->updateDefaultCampaignForm( |
| 169 | $campaign, |
| 170 | $request->get_param('defaultFormId') |
| 171 | ); |
| 172 | break; |
| 173 | case 'pageId': |
| 174 | $campaign->pageId = (int)$value; |
| 175 | break; |
| 176 | default: |
| 177 | if ($campaign->hasProperty($key)) { |
| 178 | $campaign->$key = $value; |
| 179 | } |
| 180 | } |
| 181 | } |
| 182 | |
| 183 | if ($campaign->isDirty()) { |
| 184 | $campaign->save(); |
| 185 | } |
| 186 | |
| 187 | return new WP_REST_Response((new CampaignViewModel($campaign))->exports()); |
| 188 | } |
| 189 | |
| 190 | /** |
| 191 | * @since 4.0.0 |
| 192 | * |
| 193 | * @throws Exception |
| 194 | * @return WP_Error | WP_REST_Response |
| 195 | */ |
| 196 | public function mergeCampaigns(WP_REST_Request $request) |
| 197 | { |
| 198 | $destinationCampaign = Campaign::find($request->get_param('id')); |
| 199 | |
| 200 | if (!$destinationCampaign) { |
| 201 | return new WP_Error('campaign_not_found', __('Campaign not found', 'give'), ['status' => 404]); |
| 202 | } |
| 203 | |
| 204 | $campaignsToMerge = Campaign::query()->whereIn('id', $request->get_param('campaignsToMergeIds'))->getAll(); |
| 205 | |
| 206 | $campaignsMerged = $destinationCampaign->merge(...$campaignsToMerge); |
| 207 | |
| 208 | return new WP_REST_Response($campaignsMerged); |
| 209 | } |
| 210 | |
| 211 | |
| 212 | /** |
| 213 | * @since 4.0.0 |
| 214 | * |
| 215 | * @throws Exception |
| 216 | */ |
| 217 | public function createCampaign(WP_REST_Request $request): WP_REST_Response |
| 218 | { |
| 219 | $campaign = Campaign::create([ |
| 220 | 'type' => CampaignType::CORE(), |
| 221 | 'title' => $request->get_param('title'), |
| 222 | 'shortDescription' => $request->get_param('shortDescription') ?? '', |
| 223 | 'longDescription' => '', |
| 224 | 'logo' => '', |
| 225 | 'image' => $request->get_param('image') ?? '', |
| 226 | 'primaryColor' => '#0b72d9', |
| 227 | 'secondaryColor' => '#27ae60', |
| 228 | 'goal' => (int)$request->get_param('goal'), |
| 229 | 'goalType' => new CampaignGoalType($request->get_param('goalType')), |
| 230 | 'status' => CampaignStatus::ACTIVE(), |
| 231 | 'startDate' => $request->get_param('startDateTime'), |
| 232 | 'endDate' => $request->get_param('endDateTime'), |
| 233 | ]); |
| 234 | |
| 235 | return new WP_REST_Response((new CampaignViewModel($campaign))->exports(), 201); |
| 236 | } |
| 237 | |
| 238 | /** |
| 239 | * @since 4.0.0 |
| 240 | * |
| 241 | * @throws Exception |
| 242 | */ |
| 243 | public function createCampaignPage(WP_REST_Request $request): WP_REST_Response |
| 244 | { |
| 245 | $campaignPage = CampaignPage::create([ |
| 246 | 'campaignId' => (int)$request->get_param('id'), |
| 247 | 'status' => CampaignPageStatus::DRAFT(), |
| 248 | ]); |
| 249 | |
| 250 | return new WP_REST_Response($campaignPage->toArray(), 201); |
| 251 | } |
| 252 | |
| 253 | /** |
| 254 | * @since 4.0.0 |
| 255 | */ |
| 256 | private function orderCampaigns(ModelQueryBuilder $query, $sortBy, $orderBy) |
| 257 | { |
| 258 | switch ($sortBy) { |
| 259 | case 'date': |
| 260 | $query->orderBy('date_created', $orderBy); |
| 261 | |
| 262 | break; |
| 263 | case 'amount': |
| 264 | $query |
| 265 | ->selectRaw( |
| 266 | '(SELECT SUM(amount) FROM %1s WHERE campaign_id = campaigns.id) AS amount', |
| 267 | DB::prefix('give_revenue') |
| 268 | ) |
| 269 | ->orderBy('amount', $orderBy); |
| 270 | |
| 271 | break; |
| 272 | case 'donations': |
| 273 | $query |
| 274 | ->selectRaw( |
| 275 | '(SELECT COUNT(donation_id) FROM %1s WHERE campaign_id = campaigns.id) AS donationsCount', |
| 276 | DB::prefix('give_revenue') |
| 277 | ) |
| 278 | ->orderBy('donationsCount', $orderBy); |
| 279 | |
| 280 | break; |
| 281 | case 'donors': |
| 282 | |
| 283 | $postsTable = DB::prefix('posts'); |
| 284 | $metaTable = DB::prefix('give_donationmeta'); |
| 285 | $campaignIdKey = DonationMetaKeys::CAMPAIGN_ID; |
| 286 | $donorIdKey = DonationMetaKeys::DONOR_ID; |
| 287 | |
| 288 | $query |
| 289 | ->selectRaw( |
| 290 | "( |
| 291 | SELECT COUNT(DISTINCT donorId.meta_value) |
| 292 | FROM {$postsTable} AS donation |
| 293 | LEFT JOIN {$metaTable} campaignId ON donation.ID = campaignId.donation_id AND campaignId.meta_key = '{$campaignIdKey}' |
| 294 | LEFT JOIN {$metaTable} donorId ON donation.ID = donorId.donation_id AND donorId.meta_key = '{$donorIdKey}' |
| 295 | WHERE post_type = 'give_payment' |
| 296 | AND donation.post_status IN ('publish', 'give_subscription') |
| 297 | AND campaignId.meta_value = campaigns.id |
| 298 | ) AS donorsCount" |
| 299 | ) |
| 300 | ->orderBy('donorsCount', $orderBy); |
| 301 | |
| 302 | break; |
| 303 | } |
| 304 | } |
| 305 | } |
| 306 |