| @@ 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. |
|
| @@ 321-348 (lines=28) @@ | ||
| 318 | * |
|
| 319 | * @return array $data The Donor data. |
|
| 320 | */ |
|
| 321 | public function donor_data() { |
|
| 322 | ||
| 323 | $data = array(); |
|
| 324 | ||
| 325 | // Get donor query. |
|
| 326 | $args = $this->get_donor_query(); |
|
| 327 | $donors = Give()->donors->get_donors( $args ); |
|
| 328 | ||
| 329 | if ( $donors ) { |
|
| 330 | ||
| 331 | foreach ( $donors as $donor ) { |
|
| 332 | ||
| 333 | $user_id = ! empty( $donor->user_id ) ? intval( $donor->user_id ) : 0; |
|
| 334 | ||
| 335 | $data[] = array( |
|
| 336 | 'id' => $donor->id, |
|
| 337 | 'user_id' => $user_id, |
|
| 338 | 'name' => $donor->name, |
|
| 339 | 'email' => $donor->email, |
|
| 340 | 'num_donations' => $donor->purchase_count, |
|
| 341 | 'amount_spent' => $donor->purchase_value, |
|
| 342 | 'date_created' => $donor->date_created, |
|
| 343 | ); |
|
| 344 | } |
|
| 345 | } |
|
| 346 | ||
| 347 | return apply_filters( 'give_donors_column_query_data', $data ); |
|
| 348 | } |
|
| 349 | ||
| 350 | /** |
|
| 351 | * Get donor count. |
|