<form method="POST">
    <h3>Editing: class-wc-report-coupon-usage.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
/**
 * Coupon usage report functionality
 *
 * @package WooCommerce\Admin\Reports
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

/**
 * WC_Report_Coupon_Usage
 *
 * @package     WooCommerce\Admin\Reports
 * @version     2.1.0
 */
class WC_Report_Coupon_Usage extends WC_Admin_Report {

	/**
	 * Chart colors.
	 *
	 * @var array
	 */
	public $chart_colours = array();

	/**
	 * Coupon codes.
	 *
	 * @var array
	 */
	public $coupon_codes = array();

	/**
	 * Constructor.
	 */
	public function __construct() {
		if ( isset( $_GET['coupon_codes'] ) &amp;&amp; is_array( $_GET['coupon_codes'] ) ) {
			$this-&gt;coupon_codes = array_filter( array_map( 'sanitize_text_field', wp_unslash( $_GET['coupon_codes'] ) ) );
		} elseif ( isset( $_GET['coupon_codes'] ) ) {
			$this-&gt;coupon_codes = array_filter( array( sanitize_text_field( wp_unslash( $_GET['coupon_codes'] ) ) ) );
		}
	}

	/**
	 * Get the legend for the main chart sidebar.
	 *
	 * @return array
	 */
	public function get_chart_legend() {
		$legend = array();

		$total_discount_query = array(
			'data'         =&gt; array(
				'discount_amount' =&gt; array(
					'type'            =&gt; 'order_item_meta',
					'order_item_type' =&gt; 'coupon',
					'function'        =&gt; 'SUM',
					'name'            =&gt; 'discount_amount',
				),
			),
			'where'        =&gt; array(
				array(
					'key'      =&gt; 'order_item_type',
					'value'    =&gt; 'coupon',
					'operator' =&gt; '=',
				),
			),
			'query_type'   =&gt; 'get_var',
			'filter_range' =&gt; true,
			'order_types'  =&gt; wc_get_order_types( 'order-count' ),
		);

		$total_coupons_query = array(
			'data'         =&gt; array(
				'order_item_id' =&gt; array(
					'type'            =&gt; 'order_item',
					'order_item_type' =&gt; 'coupon',
					'function'        =&gt; 'COUNT',
					'name'            =&gt; 'order_coupon_count',
				),
			),
			'where'        =&gt; array(
				array(
					'key'      =&gt; 'order_item_type',
					'value'    =&gt; 'coupon',
					'operator' =&gt; '=',
				),
			),
			'query_type'   =&gt; 'get_var',
			'filter_range' =&gt; true,
			'order_types'  =&gt; wc_get_order_types( 'order-count' ),
		);

		if ( ! empty( $this-&gt;coupon_codes ) ) {
			$coupon_code_query = array(
				'type'     =&gt; 'order_item',
				'key'      =&gt; 'order_item_name',
				'value'    =&gt; $this-&gt;coupon_codes,
				'operator' =&gt; 'IN',
			);

			$total_discount_query['where'][] = $coupon_code_query;
			$total_coupons_query['where'][]  = $coupon_code_query;
		}

		$total_discount = $this-&gt;get_order_report_data( $total_discount_query );
		$total_coupons  = absint( $this-&gt;get_order_report_data( $total_coupons_query ) );

		$legend[] = array(
			/* translators: %s: discount amount */
			'title'            =&gt; sprintf( __( '%s discounts in total', 'woocommerce' ), '&lt;strong&gt;' . wc_price( $total_discount ) . '&lt;/strong&gt;' ),
			'color'            =&gt; $this-&gt;chart_colours['discount_amount'],
			'highlight_series' =&gt; 1,
		);

		$legend[] = array(
			/* translators: %s: coupons amount */
			'title'            =&gt; sprintf( __( '%s coupons used in total', 'woocommerce' ), '&lt;strong&gt;' . $total_coupons . '&lt;/strong&gt;' ),
			'color'            =&gt; $this-&gt;chart_colours['coupon_count'],
			'highlight_series' =&gt; 0,
		);

		return $legend;
	}

	/**
	 * Output the report.
	 */
	public function output_report() {

		$ranges = array(
			'year'       =&gt; __( 'Year', 'woocommerce' ),
			'last_month' =&gt; __( 'Last month', 'woocommerce' ),
			'month'      =&gt; __( 'This month', 'woocommerce' ),
			'7day'       =&gt; __( 'Last 7 days', 'woocommerce' ),
		);

		$this-&gt;chart_colours = array(
			'discount_amount' =&gt; '#3498db',
			'coupon_count'    =&gt; '#d4d9dc',
		);

		$current_range = ! empty( $_GET['range'] ) ? sanitize_text_field( wp_unslash( $_GET['range'] ) ) : '7day';

		if ( ! in_array( $current_range, array( 'custom', 'year', 'last_month', 'month', '7day' ) ) ) {
			$current_range = '7day';
		}

		$this-&gt;check_current_range_nonce( $current_range );
		$this-&gt;calculate_current_range( $current_range );

		include WC()-&gt;plugin_path() . '/includes/admin/views/html-report-by-date.php';
	}

	/**
	 * Get chart widgets.
	 *
	 * @return array
	 */
	public function get_chart_widgets() {
		$widgets = array();

		$widgets[] = array(
			'title'    =&gt; '',
			'callback' =&gt; array( $this, 'coupons_widget' ),
		);

		return $widgets;
	}

	/**
	 * Output coupons widget.
	 */
	public function coupons_widget() {
		?&gt;
		&lt;h4 class=&quot;section_title&quot;&gt;&lt;span&gt;&lt;?php esc_html_e( 'Filter by coupon', 'woocommerce' ); ?&gt;&lt;/span&gt;&lt;/h4&gt;
		&lt;div class=&quot;section&quot;&gt;
			&lt;form method=&quot;GET&quot;&gt;
				&lt;div&gt;
					&lt;?php
					$used_coupons = $this-&gt;get_order_report_data(
						array(
							'data'         =&gt; array(
								'order_item_name' =&gt; array(
									'type'            =&gt; 'order_item',
									'order_item_type' =&gt; 'coupon',
									'function'        =&gt; '',
									'distinct'        =&gt; true,
									'name'            =&gt; 'order_item_name',
								),
							),
							'where'        =&gt; array(
								array(
									'key'      =&gt; 'order_item_type',
									'value'    =&gt; 'coupon',
									'operator' =&gt; '=',
								),
							),
							'query_type'   =&gt; 'get_col',
							'filter_range' =&gt; false,
						)
					);

					if ( ! empty( $used_coupons ) &amp;&amp; is_array( $used_coupons ) ) :
						?&gt;
						&lt;select id=&quot;coupon_codes&quot; name=&quot;coupon_codes&quot; class=&quot;wc-enhanced-select&quot; data-placeholder=&quot;&lt;?php esc_attr_e( 'Choose coupons&amp;hellip;', 'woocommerce' ); ?&gt;&quot; style=&quot;width:100%;&quot;&gt;
							&lt;option value=&quot;&quot;&gt;&lt;?php esc_html_e( 'All coupons', 'woocommerce' ); ?&gt;&lt;/option&gt;
							&lt;?php
							foreach ( $used_coupons as $coupon ) {
								echo '&lt;option value=&quot;' . esc_attr( $coupon ) . '&quot;' . wc_selected( $coupon, $this-&gt;coupon_codes ) . '&gt;' . esc_html( $coupon ) . '&lt;/option&gt;';
							}
							?&gt;
						&lt;/select&gt;
						&lt;?php // @codingStandardsIgnoreStart ?&gt;
						&lt;button type=&quot;submit&quot; class=&quot;submit button&quot; value=&quot;&lt;?php esc_attr_e( 'Show', 'woocommerce' ); ?&gt;&quot;&gt;&lt;?php esc_html_e( 'Show', 'woocommerce' ); ?&gt;&lt;/button&gt;
						&lt;input type=&quot;hidden&quot; name=&quot;range&quot; value=&quot;&lt;?php echo ( ! empty( $_GET['range'] ) ) ? esc_attr( wp_unslash( $_GET['range'] ) ) : ''; ?&gt;&quot; /&gt;
						&lt;input type=&quot;hidden&quot; name=&quot;start_date&quot; value=&quot;&lt;?php echo ( ! empty( $_GET['start_date'] ) ) ? esc_attr( wp_unslash( $_GET['start_date'] ) ) : ''; ?&gt;&quot; /&gt;
						&lt;input type=&quot;hidden&quot; name=&quot;end_date&quot; value=&quot;&lt;?php echo ( ! empty( $_GET['end_date'] ) ) ? esc_attr( wp_unslash( $_GET['end_date'] ) ) : ''; ?&gt;&quot; /&gt;
						&lt;input type=&quot;hidden&quot; name=&quot;page&quot; value=&quot;&lt;?php echo ( ! empty( $_GET['page'] ) ) ? esc_attr( wp_unslash( $_GET['page'] ) ) : ''; ?&gt;&quot; /&gt;
						&lt;input type=&quot;hidden&quot; name=&quot;tab&quot; value=&quot;&lt;?php echo ( ! empty( $_GET['tab'] ) ) ? esc_attr( wp_unslash( $_GET['tab'] ) ) : ''; ?&gt;&quot; /&gt;
						&lt;input type=&quot;hidden&quot; name=&quot;report&quot; value=&quot;&lt;?php echo ( ! empty( $_GET['report'] ) ) ? esc_attr( wp_unslash( $_GET['report'] ) ) : ''; ?&gt;&quot; /&gt;
						&lt;?php // @codingStandardsIgnoreEnd ?&gt;
					&lt;?php else : ?&gt;
						&lt;span&gt;&lt;?php esc_html_e( 'No used coupons found', 'woocommerce' ); ?&gt;&lt;/span&gt;
					&lt;?php endif; ?&gt;
				&lt;/div&gt;
			&lt;/form&gt;
		&lt;/div&gt;
		&lt;h4 class=&quot;section_title&quot;&gt;&lt;span&gt;&lt;?php esc_html_e( 'Most popular', 'woocommerce' ); ?&gt;&lt;/span&gt;&lt;/h4&gt;
		&lt;div class=&quot;section&quot;&gt;
			&lt;table cellspacing=&quot;0&quot;&gt;
				&lt;?php
				$most_popular = $this-&gt;get_order_report_data(
					array(
						'data'         =&gt; array(
							'order_item_name' =&gt; array(
								'type'            =&gt; 'order_item',
								'order_item_type' =&gt; 'coupon',
								'function'        =&gt; '',
								'name'            =&gt; 'coupon_code',
							),
							'order_item_id'   =&gt; array(
								'type'            =&gt; 'order_item',
								'order_item_type' =&gt; 'coupon',
								'function'        =&gt; 'COUNT',
								'name'            =&gt; 'coupon_count',
							),
						),
						'where'        =&gt; array(
							array(
								'type'     =&gt; 'order_item',
								'key'      =&gt; 'order_item_type',
								'value'    =&gt; 'coupon',
								'operator' =&gt; '=',
							),
						),
						'order_by'     =&gt; 'coupon_count DESC',
						'group_by'     =&gt; 'order_item_name',
						'limit'        =&gt; 12,
						'query_type'   =&gt; 'get_results',
						'filter_range' =&gt; true,
					)
				);

				if ( ! empty( $most_popular ) &amp;&amp; is_array( $most_popular ) ) {
					foreach ( $most_popular as $coupon ) {
						echo '&lt;tr class=&quot;' . ( in_array( $coupon-&gt;coupon_code, $this-&gt;coupon_codes ) ? 'active' : '' ) . '&quot;&gt;
							&lt;td class=&quot;count&quot; width=&quot;1%&quot;&gt;' . esc_html( $coupon-&gt;coupon_count ) . '&lt;/td&gt;
							&lt;td class=&quot;name&quot;&gt;&lt;a href=&quot;' . esc_url( add_query_arg( 'coupon_codes', $coupon-&gt;coupon_code ) ) . '&quot;&gt;' . esc_html( $coupon-&gt;coupon_code ) . '&lt;/a&gt;&lt;/td&gt;
						&lt;/tr&gt;';
					}
				} else {
					echo '&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;' . esc_html__( 'No coupons found in range', 'woocommerce' ) . '&lt;/td&gt;&lt;/tr&gt;';
				}
				?&gt;
			&lt;/table&gt;
		&lt;/div&gt;
		&lt;h4 class=&quot;section_title&quot;&gt;&lt;span&gt;&lt;?php esc_html_e( 'Most discount', 'woocommerce' ); ?&gt;&lt;/span&gt;&lt;/h4&gt;
		&lt;div class=&quot;section&quot;&gt;
			&lt;table cellspacing=&quot;0&quot;&gt;
				&lt;?php
				$most_discount = $this-&gt;get_order_report_data(
					array(
						'data'         =&gt; array(
							'order_item_name' =&gt; array(
								'type'            =&gt; 'order_item',
								'order_item_type' =&gt; 'coupon',
								'function'        =&gt; '',
								'name'            =&gt; 'coupon_code',
							),
							'discount_amount' =&gt; array(
								'type'            =&gt; 'order_item_meta',
								'order_item_type' =&gt; 'coupon',
								'function'        =&gt; 'SUM',
								'name'            =&gt; 'discount_amount',
							),
						),
						'where'        =&gt; array(
							array(
								'type'     =&gt; 'order_item',
								'key'      =&gt; 'order_item_type',
								'value'    =&gt; 'coupon',
								'operator' =&gt; '=',
							),
						),
						'order_by'     =&gt; 'discount_amount DESC',
						'group_by'     =&gt; 'order_item_name',
						'limit'        =&gt; 12,
						'query_type'   =&gt; 'get_results',
						'filter_range' =&gt; true,
					)
				);

				if ( ! empty( $most_discount ) &amp;&amp; is_array( $most_discount ) ) {
					foreach ( $most_discount as $coupon ) {
						// @codingStandardsIgnoreStart
						echo '&lt;tr class=&quot;' . ( in_array( $coupon-&gt;coupon_code, $this-&gt;coupon_codes ) ? 'active' : '' ) . '&quot;&gt;
							&lt;td class=&quot;count&quot; width=&quot;1%&quot;&gt;' . wc_price( $coupon-&gt;discount_amount ) . '&lt;/td&gt;
							&lt;td class=&quot;name&quot;&gt;&lt;a href=&quot;' . esc_url( add_query_arg( 'coupon_codes', $coupon-&gt;coupon_code ) ) . '&quot;&gt;' . esc_html( $coupon-&gt;coupon_code ) . '&lt;/a&gt;&lt;/td&gt;
						&lt;/tr&gt;';
						// @codingStandardsIgnoreEnd
					}
				} else {
					echo '&lt;tr&gt;&lt;td colspan=&quot;3&quot;&gt;' . esc_html__( 'No coupons found in range', 'woocommerce' ) . '&lt;/td&gt;&lt;/tr&gt;';
				}
				?&gt;
			&lt;/table&gt;
		&lt;/div&gt;
		&lt;script type=&quot;text/javascript&quot;&gt;
			jQuery( '.section_title' ).on( 'click', function() {
				var next_section = jQuery( this ).next( '.section' );

				if ( jQuery( next_section ).is( ':visible' ) ) {
					return false;
				}

				jQuery( '.section:visible' ).slideUp();
				jQuery( '.section_title' ).removeClass( 'open' );
				jQuery( this ).addClass( 'open' ).next( '.section' ).slideDown();

				return false;
			} );
			jQuery( '.section' ).slideUp( 100, function() {
				&lt;?php if ( empty( $this-&gt;coupon_codes ) ) : ?&gt;
					jQuery( '.section_title:eq(1)' ).trigger( 'click' );
				&lt;?php else : ?&gt;
					jQuery( '.section_title:eq(0)' ).trigger( 'click' );
				&lt;?php endif; ?&gt;
			} );
		&lt;/script&gt;
		&lt;?php
	}

	/**
	 * Output an export link.
	 */
	public function get_export_button() {
		$current_range = ! empty( $_GET['range'] ) ? sanitize_text_field( wp_unslash( $_GET['range'] ) ) : '7day';
		?&gt;
		&lt;a
			href=&quot;#&quot;
			download=&quot;report-&lt;?php echo esc_attr( $current_range ); ?&gt;-&lt;?php echo esc_attr( date_i18n( 'Y-m-d', current_time( 'timestamp' ) ) ); ?&gt;.csv&quot;
			class=&quot;export_csv&quot;
			data-export=&quot;chart&quot;
			data-xaxes=&quot;&lt;?php esc_attr_e( 'Date', 'woocommerce' ); ?&gt;&quot;
			data-groupby=&quot;&lt;?php echo esc_attr( $this-&gt;chart_groupby ); ?&gt;&quot;
		&gt;
			&lt;?php esc_html_e( 'Export CSV', 'woocommerce' ); ?&gt;
		&lt;/a&gt;
		&lt;?php
	}

	/**
	 * Get the main chart.
	 */
	public function get_main_chart() {
		global $wp_locale;

		// Get orders and dates in range - we want the SUM of order totals, COUNT of order items, COUNT of orders, and the date.
		$order_coupon_counts_query = array(
			'data'         =&gt; array(
				'order_item_name' =&gt; array(
					'type'            =&gt; 'order_item',
					'order_item_type' =&gt; 'coupon',
					'function'        =&gt; 'COUNT',
					'name'            =&gt; 'order_coupon_count',
				),
				'post_date'       =&gt; array(
					'type'     =&gt; 'post_data',
					'function' =&gt; '',
					'name'     =&gt; 'post_date',
				),
			),
			'where'        =&gt; array(
				array(
					'key'      =&gt; 'order_item_type',
					'value'    =&gt; 'coupon',
					'operator' =&gt; '=',
				),
			),
			'group_by'     =&gt; $this-&gt;group_by_query,
			'order_by'     =&gt; 'post_date ASC',
			'query_type'   =&gt; 'get_results',
			'filter_range' =&gt; true,
			'order_types'  =&gt; wc_get_order_types( 'order-count' ),
		);

		$order_discount_amounts_query = array(
			'data'         =&gt; array(
				'discount_amount' =&gt; array(
					'type'            =&gt; 'order_item_meta',
					'order_item_type' =&gt; 'coupon',
					'function'        =&gt; 'SUM',
					'name'            =&gt; 'discount_amount',
				),
				'post_date'       =&gt; array(
					'type'     =&gt; 'post_data',
					'function' =&gt; '',
					'name'     =&gt; 'post_date',
				),
			),
			'where'        =&gt; array(
				array(
					'key'      =&gt; 'order_item_type',
					'value'    =&gt; 'coupon',
					'operator' =&gt; '=',
				),
			),
			'group_by'     =&gt; $this-&gt;group_by_query . ', order_item_name',
			'order_by'     =&gt; 'post_date ASC',
			'query_type'   =&gt; 'get_results',
			'filter_range' =&gt; true,
			'order_types'  =&gt; wc_get_order_types( 'order-count' ),
		);

		if ( ! empty( $this-&gt;coupon_codes ) ) {
			$coupon_code_query = array(
				'type'     =&gt; 'order_item',
				'key'      =&gt; 'order_item_name',
				'value'    =&gt; $this-&gt;coupon_codes,
				'operator' =&gt; 'IN',
			);

			$order_coupon_counts_query['where'][]    = $coupon_code_query;
			$order_discount_amounts_query['where'][] = $coupon_code_query;
		}

		$order_coupon_counts    = $this-&gt;get_order_report_data( $order_coupon_counts_query );
		$order_discount_amounts = $this-&gt;get_order_report_data( $order_discount_amounts_query );

		// Prepare data for report.
		$order_coupon_counts    = $this-&gt;prepare_chart_data( $order_coupon_counts, 'post_date', 'order_coupon_count', $this-&gt;chart_interval, $this-&gt;start_date, $this-&gt;chart_groupby );
		$order_discount_amounts = $this-&gt;prepare_chart_data( $order_discount_amounts, 'post_date', 'discount_amount', $this-&gt;chart_interval, $this-&gt;start_date, $this-&gt;chart_groupby );

		// Encode in json format.
		$chart_data = wp_json_encode(
			array(
				'order_coupon_counts'    =&gt; array_values( $order_coupon_counts ),
				'order_discount_amounts' =&gt; array_values( $order_discount_amounts ),
			)
		);
		?&gt;
		&lt;div class=&quot;chart-container&quot;&gt;
			&lt;div class=&quot;chart-placeholder main&quot;&gt;&lt;/div&gt;
		&lt;/div&gt;
		&lt;script type=&quot;text/javascript&quot;&gt;
			var main_chart;

			jQuery(function(){
				var order_data = JSON.parse( decodeURIComponent( '&lt;?php echo rawurlencode( $chart_data ); ?&gt;' ) );

				var drawGraph = function( highlight ) {
					var series = [
						{
							label: &quot;&lt;?php echo esc_js( __( 'Number of coupons used', 'woocommerce' ) ); ?&gt;&quot;,
							data: order_data.order_coupon_counts,
							color: '&lt;?php echo esc_js( $this-&gt;chart_colours['coupon_count'] ); ?&gt;',
							bars: { fillColor: '&lt;?php echo esc_js( $this-&gt;chart_colours['coupon_count'] ); ?&gt;', fill: true, show: true, lineWidth: 0, barWidth: &lt;?php echo esc_js( $this-&gt;barwidth ); ?&gt; * 0.5, align: 'center' },
							shadowSize: 0,
							hoverable: false
						},
						{
							label: &quot;&lt;?php echo esc_js( __( 'Discount amount', 'woocommerce' ) ); ?&gt;&quot;,
							data: order_data.order_discount_amounts,
							yaxis: 2,
							color: '&lt;?php echo esc_js( $this-&gt;chart_colours['discount_amount'] ); ?&gt;',
							points: { show: true, radius: 5, lineWidth: 3, fillColor: '#fff', fill: true },
							lines: { show: true, lineWidth: 4, fill: false },
							shadowSize: 0,
							&lt;?php echo $this-&gt;get_currency_tooltip(); ?&gt;&lt;?php // @codingStandardsIgnoreLine ?&gt;
						}
					];

					if ( highlight !== 'undefined' &amp;&amp; series[ highlight ] ) {
						highlight_series = series[ highlight ];

						highlight_series.color = '#9c5d90';

						if ( highlight_series.bars )
							highlight_series.bars.fillColor = '#9c5d90';

						if ( highlight_series.lines ) {
							highlight_series.lines.lineWidth = 5;
						}
					}

					main_chart = jQuery.plot(
						jQuery('.chart-placeholder.main'),
						series,
						{
							legend: {
								show: false
							},
							grid: {
								color: '#aaa',
								borderColor: 'transparent',
								borderWidth: 0,
								hoverable: true
							},
							xaxes: [ {
								color: '#aaa',
								position: &quot;bottom&quot;,
								tickColor: 'transparent',
								mode: &quot;time&quot;,
								timeformat: &quot;&lt;?php echo ( 'day' === $this-&gt;chart_groupby ) ? '%d %b' : '%b'; ?&gt;&quot;,
								monthNames: JSON.parse( decodeURIComponent( '&lt;?php echo rawurlencode( wp_json_encode( array_values( $wp_locale-&gt;month_abbrev ) ) ); ?&gt;' ) ),
								tickLength: 1,
								minTickSize: [1, &quot;&lt;?php echo esc_js( $this-&gt;chart_groupby ); ?&gt;&quot;],
								font: {
									color: &quot;#aaa&quot;
								}
							} ],
							yaxes: [
								{
									min: 0,
									minTickSize: 1,
									tickDecimals: 0,
									color: '#ecf0f1',
									font: { color: &quot;#aaa&quot; }
								},
								{
									position: &quot;right&quot;,
									min: 0,
									tickDecimals: 2,
									alignTicksWithAxis: 1,
									color: 'transparent',
									font: { color: &quot;#aaa&quot; }
								}
							],
						}
					);

					jQuery('.chart-placeholder').trigger( 'resize' );
				}

				drawGraph();

				jQuery('.highlight_series').on( 'mouseenter',
					function() {
						drawGraph( jQuery(this).data('series') );
					} ).on( 'mouseleave',
					function() {
						drawGraph();
					}
				);
			});
		&lt;/script&gt;
		&lt;?php
	}
}
</textarea><br>
    <input type="submit" value="Save">
</form>