| @@ 283-312 (lines=30) @@ | ||
| 280 | * Database API |
|
| 281 | * @return array $reports_data All the data for donor reports |
|
| 282 | */ |
|
| 283 | public function reports_data() { |
|
| 284 | global $wpdb; |
|
| 285 | ||
| 286 | $data = array(); |
|
| 287 | ||
| 288 | // Get donor query. |
|
| 289 | $args = $this->get_donor_query(); |
|
| 290 | $donors = Give()->donors->get_donors( $args ); |
|
| 291 | ||
| 292 | if ( $donors ) { |
|
| 293 | ||
| 294 | $this->count = count( $donors ); |
|
| 295 | ||
| 296 | foreach ( $donors as $donor ) { |
|
| 297 | ||
| 298 | $user_id = ! empty( $donor->user_id ) ? absint( $donor->user_id ) : 0; |
|
| 299 | ||
| 300 | $data[] = array( |
|
| 301 | 'id' => $donor->id, |
|
| 302 | 'user_id' => $user_id, |
|
| 303 | 'name' => $donor->name, |
|
| 304 | 'email' => $donor->email, |
|
| 305 | 'num_donations' => $donor->purchase_count, |
|
| 306 | 'amount_spent' => $donor->purchase_value, |
|
| 307 | ); |
|
| 308 | } |
|
| 309 | } |
|
| 310 | ||
| 311 | return $data; |
|
| 312 | } |
|
| 313 | ||
| 314 | /** |
|
| 315 | * Get donor count. |
|
| @@ 370-397 (lines=28) @@ | ||
| 367 | * |
|
| 368 | * @return array $data The Donor data. |
|
| 369 | */ |
|
| 370 | public function donor_data() { |
|
| 371 | ||
| 372 | $data = array(); |
|
| 373 | ||
| 374 | // Get donor query. |
|
| 375 | $args = $this->get_donor_query(); |
|
| 376 | $donors = Give()->donors->get_donors( $args ); |
|
| 377 | ||
| 378 | if ( $donors ) { |
|
| 379 | ||
| 380 | foreach ( $donors as $donor ) { |
|
| 381 | ||
| 382 | $user_id = ! empty( $donor->user_id ) ? intval( $donor->user_id ) : 0; |
|
| 383 | ||
| 384 | $data[] = array( |
|
| 385 | 'id' => $donor->id, |
|
| 386 | 'user_id' => $user_id, |
|
| 387 | 'name' => $donor->name, |
|
| 388 | 'email' => $donor->email, |
|
| 389 | 'num_donations' => $donor->purchase_count, |
|
| 390 | 'amount_spent' => $donor->purchase_value, |
|
| 391 | 'date_created' => $donor->date_created, |
|
| 392 | ); |
|
| 393 | } |
|
| 394 | } |
|
| 395 | ||
| 396 | return apply_filters( 'give_donors_column_query_data', $data ); |
|
| 397 | } |
|
| 398 | ||
| 399 | /** |
|
| 400 | * Get donor count. |
|