WordImpress / Give

 *

 * @return int $purchase Donation ID.

 */

function give_get_donation_id_by_key( $key ) {

	global $wpdb;

	$meta_table = __give_v20_bc_table_details( 'payment' );

	$purchase = $wpdb->get_var(

		$wpdb->prepare(

			"

				SELECT {$meta_table['column']['id']}

				FROM {$meta_table['name']}

				WHERE meta_key = '_give_payment_purchase_key'

				AND meta_value = %s

				ORDER BY {$meta_table['column']['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;

	$meta_table = __give_v20_bc_table_details( 'payment' );

	$purchase = $wpdb->get_var( $wpdb->prepare( "SELECT {$meta_table['column']['id']} FROM {$meta_table['name']} 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