| @@ -494,23 +494,9 @@ | ||
| 494 | 494 | * @return array{entries: int, revenue: float} Form stats. |
| 495 | 495 | * @since 1.0.0 |
| 496 | 496 | */ |
| 497 | 497 | private function get_form_stats( $form_id ) { |
| 498 | - global $wpdb; | |
| 499 | - $table = $wpdb->prefix . 'suredonation_donations'; | |
| 500 | - | |
| 501 | - $result = $wpdb->get_row( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching | |
| 502 | - $wpdb->prepare( | |
| 503 | - 'SELECT COUNT(*) as entries, COALESCE(SUM(amount - refunded_amount), 0) as revenue FROM %i WHERE form_id = %d AND payment_status = %s', | |
| 504 | - $table, | |
| 505 | - absint( $form_id ), | |
| 506 | - 'completed' | |
| 507 | - ), | |
| 508 | - ARRAY_A | |
| 509 | - ); | |
| 510 | - | |
| 511 | - return [ | |
| 512 | - 'entries' => is_array( $result ) ? (int) ( $result['entries'] ?? 0 ) : 0, | |
| 513 | - 'revenue' => is_array( $result ) ? (float) ( $result['revenue'] ?? 0 ) : 0, | |
| 514 | - ]; | |
| 498 | + // Delegates to the donations table so this surface and the abilities | |
| 499 | + // report the same figures from one query. | |
| 500 | + return \SureDonation\Inc\Database\Tables\Donations::get_form_stats( $form_id ); | |
| 515 | 501 | } |
| 516 | 502 | } |
