WordImpress / Give

 *

 * @return int $purchase Donation ID.

 */

function give_get_donation_id_by_key( $key ) {

	global $wpdb;

	$purchase = $wpdb->get_var(

		$wpdb->prepare(

			"

				SELECT post_id

				FROM $wpdb->postmeta

				WHERE meta_key = '_give_payment_purchase_key'

				AND meta_value = %s

				ORDER BY post_id DESC

				LIMIT 1

				",

			$key

		)

	);

	if ( $purchase != null ) {

		return $purchase;

	}

	return 0;

}

/**

 *

 * @return int $purchase Donation ID.

 */

function give_get_purchase_id_by_transaction_id( $key ) {

	global $wpdb;

	$purchase = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_give_payment_transaction_id' AND meta_value = %s LIMIT 1", $key ) );

	if ( $purchase != null ) {

		return $purchase;

	}

	return 0;

}

/**

 * Retrieve all notes attached to a donation