Tiny File Manager

Back Back Up Advanced Editor

<?php

if (!defined('ABSPATH')) {
    exit;
}
class WC_Report_Taxes_By_Code extends WC_Admin_Report
{
    public function get_chart_legend()
    {
        return array();
    }
    public function get_export_button()
    {
        $current_range = !empty($_GET['range']) ? sanitize_text_field(wp_unslash($_GET['range'])) : 'last_month';
        ?>
		<a
			href="#"
			download="report-<?php 
        echo esc_attr($current_range);
        ?>-<?php 
        echo esc_attr(date_i18n('Y-m-d', current_time('timestamp')));
        ?>.csv"
			class="export_csv"
			data-export="table"
		>
			<?php 
        esc_html_e('Export CSV', 'woocommerce');
        ?>
		</a>
		<?php 
    }
    public function output_report()
    {
        $ranges = array('year' => __('Year', 'woocommerce'), 'last_month' => __('Last month', 'woocommerce'), 'month' => __('This month', 'woocommerce'));
        $current_range = !empty($_GET['range']) ? sanitize_text_field(wp_unslash($_GET['range'])) : 'last_month';
        if (!in_array($current_range, array('custom', 'year', 'last_month', 'month', '7day'))) {
            $current_range = 'last_month';
        }
        $this->check_current_range_nonce($current_range);
        $this->calculate_current_range($current_range);
        $hide_sidebar = true;
        include WC()->plugin_path() . '/includes/admin/views/html-report-by-date.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' => '!='));
        $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')));
        $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')));
        $tax_rows = array();
        foreach ($tax_rows_orders + $tax_rows_partial_refunds as $tax_row) {
            $key = $tax_row->rate_id;
            $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]->total_orders += 1;
            $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);
        }
        foreach ($tax_rows_full_refunds as $tax_row) {
            $key = $tax_row->rate_id;
            $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);
                ?></td>
							<td class="total_row"><?php 
                echo wc_price($tax_row->shipping_tax_amount);
                ?></td>
							<td class="total_row"><?php 
                echo wc_price($tax_row->tax_amount + $tax_row->shipping_tax_amount);
                ?></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'))));
            ?></th>
						<th class="total_row"><?php 
            echo wc_price(wc_round_tax_total(array_sum(wp_list_pluck((array) $tax_rows, 'shipping_tax_amount'))));
            ?></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'))));
            ?></strong></th>
					</tr>
				</tfoot>
			<?php 
        } else {
            ?>
				<tbody>
					<tr>
						<td><?php 
            esc_html_e('No taxes found in this period', 'woocommerce');
            ?></td>
					</tr>
				</tbody>
			<?php 
        }
        ?>
		</table>
		<?php 
    }
}