WordImpress / Give

 *

 * @return int $purchase Donation ID.

 */

function give_get_purchase_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 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