mirror of
https://gh.wpcy.net/https://github.com/pronamic/woocommerce-eu-vat-number.git
synced 2026-04-24 18:02:15 +08:00
424 lines
14 KiB
PHP
424 lines
14 KiB
PHP
<?php
|
|
/**
|
|
* EU VAT Sales Report
|
|
*
|
|
* @package woocommerce-eu-vat-number
|
|
* @phpcs:disable WordPress.DateTime.RestrictedFunctions.date_date
|
|
* @phpcs:disable WordPress.DateTime.CurrentTimeTimestamp.Requested
|
|
*/
|
|
|
|
if ( ! defined( 'ABSPATH' ) ) {
|
|
exit;
|
|
}
|
|
|
|
/**
|
|
* WC_Non_EU_Sales_Report class
|
|
*/
|
|
class WC_Non_EU_Sales_Report extends WC_Admin_Report {
|
|
|
|
/**
|
|
* Get the legend for the main chart sidebar
|
|
*
|
|
* @return array
|
|
*/
|
|
public function get_chart_legend() {
|
|
return array();
|
|
}
|
|
|
|
/**
|
|
* Output an export link
|
|
*/
|
|
public function get_export_button() {
|
|
$current_range = ! empty( $_GET['range'] ) ? sanitize_text_field( wp_unslash( $_GET['range'] ) ) : 'last_month'; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
|
|
|
|
?><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-eu-vat-number' ); ?>
|
|
</a>
|
|
<?php
|
|
}
|
|
|
|
/**
|
|
* Output the report
|
|
*/
|
|
public function output_report() {
|
|
$ranges = array(
|
|
'prev_quarter' => __( 'Previous Quarter', 'woocommerce-eu-vat-number' ),
|
|
'last_quarter' => __( 'Last Quarter', 'woocommerce-eu-vat-number' ),
|
|
'quarter' => __( 'This Quarter', 'woocommerce-eu-vat-number' ),
|
|
);
|
|
|
|
$current_range = ! empty( $_GET['range'] ) ? sanitize_text_field( wp_unslash( $_GET['range'] ) ) : 'quarter'; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
|
|
|
|
if ( ! in_array( $current_range, array( 'custom', 'prev_quarter', 'last_quarter', 'quarter' ), true ) ) {
|
|
$current_range = 'quarter';
|
|
}
|
|
|
|
$this->calculate_current_range( $current_range );
|
|
|
|
$hide_sidebar = true;
|
|
|
|
include WC()->plugin_path() . '/includes/admin/views/html-report-by-date.php';
|
|
}
|
|
|
|
/**
|
|
* Get the current range and calculate the start and end dates
|
|
*
|
|
* @param string $current_range Report Range.
|
|
*/
|
|
public function calculate_current_range( $current_range ) {
|
|
$this->chart_groupby = 'month';
|
|
$quarter = absint( ceil( date( 'm', current_time( 'timestamp' ) ) / 3 ) );
|
|
$year = absint( date( 'Y', current_time( 'timestamp' ) ) );
|
|
|
|
switch ( $current_range ) {
|
|
case 'prev_quarter':
|
|
$quarter = $quarter - 2;
|
|
if ( 0 === $quarter ) {
|
|
$quarter = 4;
|
|
$year --;
|
|
} elseif ( -1 === $quarter ) {
|
|
$quarter = 3;
|
|
$year --;
|
|
}
|
|
break;
|
|
case 'last_quarter':
|
|
--$quarter;
|
|
if ( 0 === $quarter ) {
|
|
$quarter = 4;
|
|
$year --;
|
|
}
|
|
break;
|
|
case 'custom':
|
|
parent::calculate_current_range( $current_range );
|
|
return;
|
|
}
|
|
|
|
if ( 1 === $quarter ) {
|
|
$this->start_date = strtotime( $year . '-01-01' );
|
|
$this->end_date = strtotime( date( 'Y-m-t', strtotime( $year . '-03-01' ) ) );
|
|
} elseif ( 2 === $quarter ) {
|
|
$this->start_date = strtotime( $year . '-04-01' );
|
|
$this->end_date = strtotime( date( 'Y-m-t', strtotime( $year . '-06-01' ) ) );
|
|
} elseif ( 3 === $quarter ) {
|
|
$this->start_date = strtotime( $year . '-07-01' );
|
|
$this->end_date = strtotime( date( 'Y-m-t', strtotime( $year . '-09-01' ) ) );
|
|
} elseif ( 4 === $quarter ) {
|
|
$this->start_date = strtotime( $year . '-10-01' );
|
|
$this->end_date = strtotime( date( 'Y-m-t', strtotime( $year . '-12-01' ) ) );
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Get the main chart
|
|
*
|
|
* @return void
|
|
*/
|
|
public function get_main_chart() {
|
|
global $wpdb;
|
|
$use_shipping_country = wc_eu_vat_use_shipping_country();
|
|
|
|
$line_data = $this->get_order_report_data(
|
|
array(
|
|
'data' => array(
|
|
'_line_total' => array(
|
|
'type' => 'order_item_meta',
|
|
'order_item_type' => '',
|
|
'function' => '',
|
|
'name' => '_line_total',
|
|
),
|
|
'_line_tax_data' => array(
|
|
'type' => 'order_item_meta',
|
|
'order_item_type' => '',
|
|
'function' => '',
|
|
'name' => '_line_tax_data',
|
|
),
|
|
'ID' => array(
|
|
'type' => 'post_data',
|
|
'function' => '',
|
|
'name' => 'ID',
|
|
),
|
|
),
|
|
'filter_range' => true,
|
|
'query_type' => 'get_results',
|
|
'group_by' => '',
|
|
'order_types' => array( 'shop_order', 'shop_order_refund' ),
|
|
'order_status' => array( 'completed' ),
|
|
)
|
|
);
|
|
|
|
$grouped_tax_rows = array();
|
|
|
|
foreach ( $line_data as $data ) {
|
|
$line_total = $data->_line_total;
|
|
$line_tax_data = maybe_unserialize( $data->_line_tax_data );
|
|
|
|
if ( $line_tax_data['total'] ) {
|
|
foreach ( $line_tax_data['total'] as $tax_id => $tax_value ) {
|
|
if ( ! isset( $grouped_tax_rows[ $tax_id ] ) ) {
|
|
$grouped_tax_rows[ $tax_id ] = (object) array(
|
|
'amount' => 0,
|
|
'refunded_amount' => 0,
|
|
'tax_amount' => 0,
|
|
'refunded_tax_amount' => 0,
|
|
);
|
|
}
|
|
|
|
if ( $line_total < 0 ) {
|
|
$grouped_tax_rows[ $tax_id ]->refunded_amount += $line_total;
|
|
} else {
|
|
$grouped_tax_rows[ $tax_id ]->amount += $line_total;
|
|
}
|
|
|
|
if ( $tax_value < 0 ) {
|
|
$grouped_tax_rows[ $tax_id ]->refunded_tax_amount += wc_round_tax_total( $tax_value );
|
|
} else {
|
|
$grouped_tax_rows[ $tax_id ]->tax_amount += wc_round_tax_total( $tax_value );
|
|
}
|
|
}
|
|
} else {
|
|
$order = wc_get_order( $data->ID );
|
|
$country = $order->get_meta( '_billing_country', true );
|
|
$vat_number = $order->get_meta( '_billing_vat_number', true );
|
|
if ( $use_shipping_country && ! empty( $vat_number ) ) {
|
|
$shipping_country = $order->get_meta( '_shipping_country', true );
|
|
if ( ! empty( $shipping_country ) ) {
|
|
$country = $shipping_country;
|
|
}
|
|
}
|
|
|
|
if ( $country ) {
|
|
if ( ! isset( $grouped_tax_rows[ $country ] ) ) {
|
|
$grouped_tax_rows[ $country ] = (object) array(
|
|
'amount' => 0,
|
|
'refunded_amount' => 0,
|
|
'tax_amount' => 0,
|
|
'refunded_tax_amount' => 0,
|
|
);
|
|
}
|
|
|
|
if ( $line_total < 0 ) {
|
|
$grouped_tax_rows[ $country ]->refunded_amount += $line_total;
|
|
} else {
|
|
$grouped_tax_rows[ $country ]->amount += $line_total;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
$refunded_line_data = $this->get_order_report_data(
|
|
array(
|
|
'data' => array(
|
|
'_line_total' => array(
|
|
'type' => 'order_item_meta',
|
|
'order_item_type' => '',
|
|
'function' => '',
|
|
'name' => '_line_total',
|
|
),
|
|
'_line_tax_data' => array(
|
|
'type' => 'order_item_meta',
|
|
'order_item_type' => '',
|
|
'function' => '',
|
|
'name' => '_line_tax_data',
|
|
),
|
|
'ID' => array(
|
|
'type' => 'post_data',
|
|
'function' => '',
|
|
'name' => 'ID',
|
|
),
|
|
),
|
|
'filter_range' => true,
|
|
'query_type' => 'get_results',
|
|
'group_by' => '',
|
|
'order_types' => array( 'shop_order', 'shop_order_refund' ),
|
|
'order_status' => array( 'refunded' ),
|
|
)
|
|
);
|
|
|
|
foreach ( $refunded_line_data as $data ) {
|
|
$line_total = $data->_line_total;
|
|
$line_tax_data = maybe_unserialize( $data->_line_tax_data );
|
|
|
|
if ( $line_tax_data['total'] ) {
|
|
foreach ( $line_tax_data['total'] as $tax_id => $tax_value ) {
|
|
if ( ! isset( $grouped_tax_rows[ $tax_id ] ) ) {
|
|
$grouped_tax_rows[ $tax_id ] = (object) array(
|
|
'amount' => 0,
|
|
'refunded_amount' => 0,
|
|
'tax_amount' => 0,
|
|
'refunded_tax_amount' => 0,
|
|
);
|
|
}
|
|
$grouped_tax_rows[ $tax_id ]->refunded_amount += ( $line_total * -1 );
|
|
$grouped_tax_rows[ $tax_id ]->refunded_tax_amount += ( wc_round_tax_total( $tax_value ) * -1 );
|
|
}
|
|
} else {
|
|
$order = wc_get_order( $data->ID );
|
|
$country = $order->get_meta( '_billing_country', true );
|
|
$vat_number = $order->get_meta( '_billing_vat_number', true );
|
|
if ( $use_shipping_country && ! empty( $vat_number ) ) {
|
|
$shipping_country = $order->get_meta( '_shipping_country', true );
|
|
if ( ! empty( $shipping_country ) ) {
|
|
$country = $shipping_country;
|
|
}
|
|
}
|
|
|
|
if ( $country ) {
|
|
if ( ! isset( $grouped_tax_rows[ $country ] ) ) {
|
|
$grouped_tax_rows[ $country ] = (object) array(
|
|
'amount' => 0,
|
|
'refunded_amount' => 0,
|
|
'tax_amount' => 0,
|
|
'refunded_tax_amount' => 0,
|
|
);
|
|
}
|
|
$grouped_tax_rows[ $country ]->refunded_amount += ( $line_total * -1 );
|
|
}
|
|
}
|
|
}
|
|
|
|
$shipping_tax_amount = $this->get_order_report_data(
|
|
array(
|
|
'data' => array(
|
|
'rate_id' => array(
|
|
'type' => 'order_item_meta',
|
|
'order_item_type' => '',
|
|
'function' => '',
|
|
'name' => 'rate_id',
|
|
),
|
|
'shipping_tax_amount' => array(
|
|
'type' => 'order_item_meta',
|
|
'order_item_type' => 'tax',
|
|
'function' => '',
|
|
'name' => 'shipping_tax_amount',
|
|
),
|
|
),
|
|
'filter_range' => true,
|
|
'query_type' => 'get_results',
|
|
'group_by' => '',
|
|
'order_types' => array( 'shop_order', 'shop_order_refund' ),
|
|
'order_status' => array( 'completed' ),
|
|
)
|
|
);
|
|
|
|
foreach ( $shipping_tax_amount as $data ) {
|
|
$tax_value = $data->shipping_tax_amount;
|
|
$tax_id = $data->rate_id;
|
|
|
|
if ( ! isset( $grouped_tax_rows[ $tax_id ] ) ) {
|
|
$grouped_tax_rows[ $tax_id ] = (object) array(
|
|
'amount' => 0,
|
|
'refunded_amount' => 0,
|
|
'tax_amount' => 0,
|
|
'refunded_tax_amount' => 0,
|
|
);
|
|
}
|
|
|
|
$grouped_tax_rows[ $tax_id ]->tax_amount += wc_round_tax_total( $tax_value );
|
|
}
|
|
?>
|
|
<table class="widefat">
|
|
<thead>
|
|
<tr>
|
|
<th><?php esc_html_e( 'Country', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th><?php esc_html_e( 'Code', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th><?php esc_html_e( 'Tax Rate', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th class="total_row"><?php esc_html_e( 'Amount', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th class="total_row"><?php esc_html_e( 'Refunded Amount', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th class="total_row"><?php esc_html_e( 'Final Amount', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th class="total_row"><?php esc_html_e( 'Tax Amount', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th class="total_row"><?php esc_html_e( 'Tax Refunded Amount', 'woocommerce-eu-vat-number' ); ?></th>
|
|
<th class="total_row"><?php esc_html_e( 'Final Tax Amount ', 'woocommerce-eu-vat-number' ); ?></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$found = false;
|
|
$total_amount = 0;
|
|
$total_refunded_amount = 0;
|
|
$total_final_amount = 0;
|
|
$total_tax_amount = 0;
|
|
$total_refunded_tax_amount = 0;
|
|
$total_final_tax_amount = 0;
|
|
|
|
foreach ( $grouped_tax_rows as $rate_id => $tax_row ) {
|
|
if ( is_numeric( $rate_id ) ) {
|
|
$rate = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %d;", $rate_id ) );
|
|
|
|
if ( ! is_object( $rate ) ) {
|
|
continue;
|
|
}
|
|
|
|
$country = $rate->tax_rate_country;
|
|
|
|
/**
|
|
* Filters tax rate for the reports
|
|
*
|
|
* @since 2.1.7
|
|
*
|
|
* @param string $rate->tax_rate Tax Rate.
|
|
* @param int $rate_id Rate Id.
|
|
* @param object $tax_row Tax Row.
|
|
*/
|
|
$tax_rate = apply_filters( 'woocommerce_reports_taxes_rate', $rate->tax_rate, $rate_id, $tax_row ) . '%';
|
|
} else {
|
|
$country = $rate_id;
|
|
$tax_rate = '-';
|
|
}
|
|
|
|
if ( in_array( $country, WC_EU_VAT_Number::get_eu_countries(), true ) || empty( WC()->countries->countries[ $country ] ) ) {
|
|
continue;
|
|
}
|
|
|
|
$found = true;
|
|
$total_amount += $tax_row->amount;
|
|
$total_refunded_amount += $tax_row->refunded_amount;
|
|
$total_final_amount += $tax_row->amount + $tax_row->refunded_amount;
|
|
$total_tax_amount += $tax_row->tax_amount;
|
|
$total_refunded_tax_amount += $tax_row->refunded_tax_amount;
|
|
$total_final_tax_amount += $tax_row->tax_amount + $tax_row->refunded_tax_amount;
|
|
// phpcs:disable WordPress.Security.EscapeOutput.OutputNotEscaped
|
|
?>
|
|
<tr>
|
|
<th scope="row"><?php echo esc_html( WC()->countries->countries[ $country ] ); ?></th>
|
|
<th scope="row"><?php echo esc_html( $country ); ?></th>
|
|
<td><?php echo esc_html( $tax_rate ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $tax_row->amount ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $tax_row->refunded_amount * -1 ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $tax_row->amount + $tax_row->refunded_amount ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $tax_row->tax_amount ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $tax_row->refunded_tax_amount * -1 ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $tax_row->tax_amount + $tax_row->refunded_tax_amount ); ?></td>
|
|
</tr>
|
|
<?php
|
|
// phpcs:enable
|
|
}
|
|
|
|
if ( $found ) {
|
|
// phpcs:disable WordPress.Security.EscapeOutput.OutputNotEscaped
|
|
?>
|
|
<tr>
|
|
<th><strong><?php esc_html_e( 'Totals', 'woocommerce-eu-vat-number' ); ?></strong></th>
|
|
<th></th>
|
|
<th></th>
|
|
<td class="total_row"><?php echo wc_price( $total_amount ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $total_refunded_amount * -1 ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $total_final_amount ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $total_tax_amount ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $total_refunded_tax_amount * -1 ); ?></td>
|
|
<td class="total_row"><?php echo wc_price( $total_final_tax_amount ); ?></td>
|
|
</tr>
|
|
<?php
|
|
// phpcs:enable
|
|
} else {
|
|
?>
|
|
<tr>
|
|
<td colspan="9"><?php esc_html_e( 'No non-eu sales found in this period', 'woocommerce-eu-vat-number' ); ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
<?php
|
|
}
|
|
}
|
