woocommerce / woocommerce-gateway-stripe

	 * @version 4.0.0

	 * @param string $source_id

	 */

	public static function get_order_by_source_id( $source_id ) {

		global $wpdb;

		$order_id = $wpdb->get_var( $wpdb->prepare( "SELECT DISTINCT ID FROM $wpdb->posts as posts LEFT JOIN $wpdb->postmeta as meta ON posts.ID = meta.post_id WHERE meta.meta_value = %s AND meta.meta_key = %s", $source_id, '_stripe_source_id' ) );

		if ( ! empty( $order_id ) ) {

			return wc_get_order( $order_id );

		}

		return false;

	}

	/**

	 * Gets the order by Stripe charge ID.

	 * @version 4.0.0

	 * @param string $charge_id

	 */

	public static function get_order_by_charge_id( $charge_id ) {

		global $wpdb;

		$order_id = $wpdb->get_var( $wpdb->prepare( "SELECT DISTINCT ID FROM $wpdb->posts as posts LEFT JOIN $wpdb->postmeta as meta ON posts.ID = meta.post_id WHERE meta.meta_value = %s AND meta.meta_key = %s", $charge_id, '_transaction_id' ) );

		if ( ! empty( $order_id ) ) {

			return wc_get_order( $order_id );

		}

		return false;

	}

	/**

	 * Sanitize statement descriptor text.