ravinderk / Give

 *

 * @return int $purchase Donation ID.

 */

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