db = $db ?? $GLOBALS['wpdb']; } private function table(): string { return $this->db->prefix . 'sg_donations'; } /** @return int|null new id, or null on failure (e.g. duplicate capture id). */ public function insert( array $d ): ?int { $allowed = array( 'goal_id', 'paypal_order_id', 'paypal_capture_id', 'base_minor', 'fee_minor', 'total_minor', 'currency', 'donor_name', 'is_anonymous', 'message', 'status', 'moderation' ); $row = array_intersect_key( $d, array_flip( $allowed ) ); $row += array( 'status' => 'pending', 'moderation' => 'approved', 'fee_minor' => 0 ); $row['created_at'] = gmdate( 'Y-m-d H:i:s' ); $ok = $this->db->insert( $this->table(), $row ); return $ok ? (int) $this->db->insert_id : null; } public function find( int $id ): ?array { return $this->one( $this->db->prepare( "SELECT * FROM {$this->table()} WHERE id = %d", $id ) ); } public function findByCaptureId( string $captureId ): ?array { return $this->one( $this->db->prepare( "SELECT * FROM {$this->table()} WHERE paypal_capture_id = %s", $captureId ) ); } public function findByOrderId( string $orderId ): ?array { return $this->one( $this->db->prepare( "SELECT * FROM {$this->table()} WHERE paypal_order_id = %s ORDER BY id DESC LIMIT 1", $orderId ) ); } public function updateStatus( int $id, string $status, ?string $captureId = null ): bool { if ( ! in_array( $status, self::STATUSES, true ) ) { return false; } $data = array( 'status' => $status ); if ( null !== $captureId ) { $data['paypal_capture_id'] = $captureId; } return false !== $this->db->update( $this->table(), $data, array( 'id' => $id ) ); } /** * Public-safe feed of completed + approved donations. Real name is never returned for * anonymous donors. * * @return array */ public function recentApproved( ?int $goalId = null, int $limit = 10 ): array { $limit = max( 1, min( 100, $limit ) ); $where = "status = 'completed' AND moderation = 'approved'"; $args = array(); if ( null !== $goalId ) { $where .= ' AND goal_id = %d'; $args[] = $goalId; } $args[] = $limit; $rows = $this->db->get_results( $this->db->prepare( "SELECT id, base_minor, currency, donor_name, is_anonymous, message, created_at FROM {$this->table()} WHERE {$where} ORDER BY id DESC LIMIT %d", ...$args ), ARRAY_A ); $out = array(); foreach ( (array) $rows as $r ) { $anon = ! empty( $r['is_anonymous'] ) || '' === trim( (string) $r['donor_name'] ); $out[] = array( 'id' => (int) $r['id'], 'name' => $anon ? 'Anonymous' : (string) $r['donor_name'], 'amount_minor' => (int) $r['base_minor'], 'currency' => (string) $r['currency'], 'message' => (string) $r['message'], 'created_at' => (string) $r['created_at'], ); } return $out; } /** Convert a DB row to the rules engine value object. */ public static function toDonation( array $r ): Donation { return new Donation( (int) $r['id'], (int) $r['goal_id'], (int) $r['base_minor'], (int) $r['fee_minor'], (int) $r['total_minor'], (string) $r['currency'], (string) $r['status'] ); } private function one( string $sql ): ?array { $row = $this->db->get_row( $sql, ARRAY_A ); return $row ?: null; } }