woothemes / woocommerce

	 * @since 2.2

	 * @return string

	 */

	public function get_total_refunded() {

		global $wpdb;

		$total = $wpdb->get_var( $wpdb->prepare( "

			SELECT SUM( postmeta.meta_value )

			FROM $wpdb->postmeta AS postmeta

			INNER JOIN $wpdb->posts AS posts ON ( posts.post_type = 'shop_order_refund' AND posts.post_parent = %d )

			WHERE postmeta.meta_key = '_refund_amount'

			AND postmeta.post_id = posts.ID

		", $this->get_id() ) );

		return $total;

	}

	/**

	 * Get the total tax refunded.

	 * @since  2.3

	 * @return float

	 */

	public function get_total_tax_refunded() {

		global $wpdb;

		$total = $wpdb->get_var( $wpdb->prepare( "

			SELECT SUM( order_itemmeta.meta_value )

			FROM {$wpdb->prefix}woocommerce_order_itemmeta AS order_itemmeta

			INNER JOIN $wpdb->posts AS posts ON ( posts.post_type = 'shop_order_refund' AND posts.post_parent = %d )

			INNER JOIN {$wpdb->prefix}woocommerce_order_items AS order_items ON ( order_items.order_id = posts.ID AND order_items.order_item_type = 'tax' )

			WHERE order_itemmeta.order_item_id = order_items.order_item_id

			AND order_itemmeta.meta_key IN ('tax_amount', 'shipping_tax_amount')

		", $this->get_id() ) );

		return abs( $total );

	}

	/**

	 * Get the total shipping refunded.

	 * @since  2.4

	 * @return float

	 */

	public function get_total_shipping_refunded() {

		global $wpdb;

		$total = $wpdb->get_var( $wpdb->prepare( "

			SELECT SUM( order_itemmeta.meta_value )

			FROM {$wpdb->prefix}woocommerce_order_itemmeta AS order_itemmeta

			INNER JOIN $wpdb->posts AS posts ON ( posts.post_type = 'shop_order_refund' AND posts.post_parent = %d )

			INNER JOIN {$wpdb->prefix}woocommerce_order_items AS order_items ON ( order_items.order_id = posts.ID AND order_items.order_item_type = 'shipping' )

			WHERE order_itemmeta.order_item_id = order_items.order_item_id

			AND order_itemmeta.meta_key IN ('cost')

		", $this->get_id() ) );

		return abs( $total );

	}

	/**

	 * Gets the count of order items of a certain type that have been refunded.