WC_Report_Taxes_By_Code::get_main_chart()publicWC 1.0

Get the main chart.

Метод класса: WC_Report_Taxes_By_Code{}

Возвращает

null. Ничего (null).

Использование

$WC_Report_Taxes_By_Code = new WC_Report_Taxes_By_Code();
$WC_Report_Taxes_By_Code->get_main_chart();

Код WC_Report_Taxes_By_Code::get_main_chart() WC 9.4.2

<?php
public function get_main_chart() {
	global $wpdb;

	$query_data = array(
		'order_item_name'     => array(
			'type'     => 'order_item',
			'function' => '',
			'name'     => 'tax_rate',
		),
		'tax_amount'          => array(
			'type'            => 'order_item_meta',
			'order_item_type' => 'tax',
			'function'        => '',
			'name'            => 'tax_amount',
		),
		'shipping_tax_amount' => array(
			'type'            => 'order_item_meta',
			'order_item_type' => 'tax',
			'function'        => '',
			'name'            => 'shipping_tax_amount',
		),
		'rate_id'             => array(
			'type'            => 'order_item_meta',
			'order_item_type' => 'tax',
			'function'        => '',
			'name'            => 'rate_id',
		),
		'ID'                  => array(
			'type'     => 'post_data',
			'function' => '',
			'name'     => 'post_id',
		),
	);

	$query_where = array(
		array(
			'key'      => 'order_item_type',
			'value'    => 'tax',
			'operator' => '=',
		),
		array(
			'key'      => 'order_item_name',
			'value'    => '',
			'operator' => '!=',
		),
	);

	// We exclude on-hold orders as they are still pending payment.
	$tax_rows_orders = $this->get_order_report_data(
		array(
			'data'         => $query_data,
			'where'        => $query_where,
			'order_by'     => 'posts.post_date ASC',
			'query_type'   => 'get_results',
			'filter_range' => true,
			'order_types'  => wc_get_order_types( 'sales-reports' ),
			'order_status' => array( 'completed', 'processing', 'refunded' ),
		)
	);

	$tax_rows_partial_refunds = $this->get_order_report_data(
		array(
			'data'                => $query_data,
			'where'               => $query_where,
			'order_by'            => 'posts.post_date ASC',
			'query_type'          => 'get_results',
			'filter_range'        => true,
			'order_types'         => array( 'shop_order_refund' ),
			'parent_order_status' => array( 'completed', 'processing' ), // Partial refunds inside refunded orders should be ignored.
		)
	);

	$tax_rows_full_refunds = $this->get_order_report_data(
		array(
			'data'                => $query_data,
			'where'               => $query_where,
			'order_by'            => 'posts.post_date ASC',
			'query_type'          => 'get_results',
			'filter_range'        => true,
			'order_types'         => array( 'shop_order_refund' ),
			'parent_order_status' => array( 'refunded' ),
		)
	);

	// Merge.
	$tax_rows = array();
	// Initialize an associative array to store unique post_ids.
	$unique_post_ids = array();

	foreach ( $tax_rows_orders + $tax_rows_partial_refunds as $tax_row ) {
		$key                                    = $tax_row->tax_rate;
		$tax_rows[ $key ]                       = isset( $tax_rows[ $key ] ) ? $tax_rows[ $key ] : (object) array(
			'tax_amount'          => 0,
			'shipping_tax_amount' => 0,
			'total_orders'        => 0,
		);
		$tax_rows[ $key ]->tax_rate             = $tax_row->tax_rate;
		$tax_rows[ $key ]->tax_amount          += wc_round_tax_total( $tax_row->tax_amount );
		$tax_rows[ $key ]->shipping_tax_amount += wc_round_tax_total( $tax_row->shipping_tax_amount );
		if ( ! isset( $unique_post_ids[ $key ] ) || ! in_array( $tax_row->post_id, $unique_post_ids[ $key ], true ) ) {
			$unique_post_ids[ $key ]         = isset( $unique_post_ids[ $key ] ) ? $unique_post_ids[ $key ] : array();
			$unique_post_ids[ $key ][]       = $tax_row->post_id;
			$tax_rows[ $key ]->total_orders += 1;
		}
	}

	foreach ( $tax_rows_full_refunds as $tax_row ) {
		$key                                    = $tax_row->tax_rate;
		$tax_rows[ $key ]                       = isset( $tax_rows[ $key ] ) ? $tax_rows[ $key ] : (object) array(
			'tax_amount'          => 0,
			'shipping_tax_amount' => 0,
			'total_orders'        => 0,
		);
		$tax_rows[ $key ]->tax_rate             = $tax_row->tax_rate;
		$tax_rows[ $key ]->tax_amount          += wc_round_tax_total( $tax_row->tax_amount );
		$tax_rows[ $key ]->shipping_tax_amount += wc_round_tax_total( $tax_row->shipping_tax_amount );
	}
	?>
	<table class="widefat">
		<thead>
			<tr>
				<th><?php esc_html_e( 'Tax', 'woocommerce' ); ?></th>
				<th><?php esc_html_e( 'Rate', 'woocommerce' ); ?></th>
				<th class="total_row"><?php esc_html_e( 'Number of orders', 'woocommerce' ); ?></th>
				<th class="total_row"><?php esc_html_e( 'Tax amount', 'woocommerce' ); ?> <?php echo wc_help_tip( __( 'This is the sum of the "Tax rows" tax amount within your orders.', 'woocommerce' ) ); ?></th>
				<th class="total_row"><?php esc_html_e( 'Shipping tax amount', 'woocommerce' ); ?> <?php echo wc_help_tip( __( 'This is the sum of the "Tax rows" shipping tax amount within your orders.', 'woocommerce' ) ); ?></th>
				<th class="total_row"><?php esc_html_e( 'Total tax', 'woocommerce' ); ?> <?php echo wc_help_tip( __( 'This is the total tax for the rate (shipping tax + product tax).', 'woocommerce' ) ); ?></th>
			</tr>
		</thead>
		<?php if ( ! empty( $tax_rows ) ) : ?>
			<tbody>
				<?php
				foreach ( $tax_rows as $rate_id => $tax_row ) {
					$rate = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %d;", $rate_id ) );
					?>
					<tr>
						<th scope="row"><?php echo wp_kses_post( apply_filters( 'woocommerce_reports_taxes_tax_rate', $tax_row->tax_rate, $rate_id, $tax_row ) ); ?></th>
						<td><?php echo wp_kses_post( apply_filters( 'woocommerce_reports_taxes_rate', $rate, $rate_id, $tax_row ) ); ?>%</td>
						<td class="total_row"><?php echo esc_html( $tax_row->total_orders ); ?></td>
						<td class="total_row"><?php echo wc_price( $tax_row->tax_amount ); // phpcs:ignore ?></td>
						<td class="total_row"><?php echo wc_price( $tax_row->shipping_tax_amount ); // phpcs:ignore ?></td>
						<td class="total_row"><?php echo wc_price( $tax_row->tax_amount + $tax_row->shipping_tax_amount ); // phpcs:ignore ?></td>
					</tr>
					<?php
				}
				?>
			</tbody>
			<tfoot>
				<tr>
					<th scope="row" colspan="3"><?php esc_html_e( 'Total', 'woocommerce' ); ?></th>
					<th class="total_row"><?php echo wc_price( wc_round_tax_total( array_sum( wp_list_pluck( (array) $tax_rows, 'tax_amount' ) ) ) ); // phpcs:ignore ?></th>
					<th class="total_row"><?php echo wc_price( wc_round_tax_total( array_sum( wp_list_pluck( (array) $tax_rows, 'shipping_tax_amount' ) ) ) ); // phpcs:ignore ?></th>
					<th class="total_row"><strong><?php echo wc_price( wc_round_tax_total( array_sum( wp_list_pluck( (array) $tax_rows, 'tax_amount' ) ) + array_sum( wp_list_pluck( (array) $tax_rows, 'shipping_tax_amount' ) ) ) ); // phpcs:ignore ?></strong></th>
				</tr>
			</tfoot>
		<?php else : ?>
			<tbody>
				<tr>
					<td><?php esc_html_e( 'No taxes found in this period', 'woocommerce' ); ?></td>
				</tr>
			</tbody>
		<?php endif; ?>
	</table>
	<?php
}