<form method="POST">
    <h3>Editing: SqlQuery.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
/**
 * Admin\API\Reports\SqlQuery class file.
 */

namespace Automattic\WooCommerce\Admin\API\Reports;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/**
 * Admin\API\Reports\SqlQuery: Common parent for manipulating SQL query clauses.
 */
class SqlQuery {
	/**
	 * List of SQL clauses.
	 *
	 * @var array
	 */
	private $sql_clauses = array(
		'select'     =&gt; array(),
		'from'       =&gt; array(),
		'left_join'  =&gt; array(),
		'join'       =&gt; array(),
		'right_join' =&gt; array(),
		'where'      =&gt; array(),
		'where_time' =&gt; array(),
		'group_by'   =&gt; array(),
		'having'     =&gt; array(),
		'limit'      =&gt; array(),
		'order_by'   =&gt; array(),
		'union'      =&gt; array(),
	);
	/**
	 * SQL clause merge filters.
	 *
	 * @var array
	 */
	private $sql_filters = array(
		'where' =&gt; array(
			'where',
			'where_time',
		),
		'join'  =&gt; array(
			'right_join',
			'join',
			'left_join',
		),
	);
	/**
	 * Data store context used to pass to filters.
	 *
	 * @var string
	 */
	protected $context;

	/**
	 * Constructor.
	 *
	 * @param string $context Optional context passed to filters. Default empty string.
	 */
	public function __construct( $context = '' ) {
		$this-&gt;context = $context;
	}

	/**
	 * Add a SQL clause to be included when get_data is called.
	 *
	 * @param string $type   Clause type.
	 * @param string $clause SQL clause.
	 */
	public function add_sql_clause( $type, $clause ) {
		if ( isset( $this-&gt;sql_clauses[ $type ] ) &amp;&amp; ! empty( $clause ) ) {
			$this-&gt;sql_clauses[ $type ][] = $clause;
		}
	}

	/**
	 * Get SQL clause by type.
	 *
	 * @param string $type     Clause type.
	 * @param string $handling Whether to filter the return value (filtered|unfiltered). Default unfiltered.
	 *
	 * @return string SQL clause.
	 */
	protected function get_sql_clause( $type, $handling = 'unfiltered' ) {
		if ( ! isset( $this-&gt;sql_clauses[ $type ] ) ) {
			return '';
		}

		/**
		 * Default to bypassing filters for clause retrieval internal to data stores.
		 * The filters are applied when the full SQL statement is retrieved.
		 */
		if ( 'unfiltered' === $handling ) {
			return implode( ' ', $this-&gt;sql_clauses[ $type ] );
		}

		if ( isset( $this-&gt;sql_filters[ $type ] ) ) {
			$clauses = array();
			foreach ( $this-&gt;sql_filters[ $type ] as $subset ) {
				$clauses = array_merge( $clauses, $this-&gt;sql_clauses[ $subset ] );
			}
		} else {
			$clauses = $this-&gt;sql_clauses[ $type ];
		}

		/**
		 * Filter SQL clauses by type and context.
		 *
		 * @param array  $clauses The original arguments for the request.
		 * @param string $context The data store context.
		 */
		$clauses = apply_filters( &quot;woocommerce_analytics_clauses_{$type}&quot;, $clauses, $this-&gt;context );
		/**
		 * Filter SQL clauses by type and context.
		 *
		 * @param array  $clauses The original arguments for the request.
		 */
		$clauses = apply_filters( &quot;woocommerce_analytics_clauses_{$type}_{$this-&gt;context}&quot;, $clauses );
		return implode( ' ', $clauses );
	}

	/**
	 * Clear SQL clauses by type.
	 *
	 * @param string|array $types Clause type.
	 */
	protected function clear_sql_clause( $types ) {
		foreach ( (array) $types as $type ) {
			if ( isset( $this-&gt;sql_clauses[ $type ] ) ) {
				$this-&gt;sql_clauses[ $type ] = array();
			}
		}
	}

	/**
	 * Replace strings within SQL clauses by type.
	 *
	 * @param string $type    Clause type.
	 * @param string $search  String to search for.
	 * @param string $replace Replacement string.
	 */
	protected function str_replace_clause( $type, $search, $replace ) {
		if ( isset( $this-&gt;sql_clauses[ $type ] ) ) {
			foreach ( $this-&gt;sql_clauses[ $type ] as $key =&gt; $sql ) {
				$this-&gt;sql_clauses[ $type ][ $key ] = str_replace( $search, $replace, $sql );
			}
		}
	}

	/**
	 * Get the full SQL statement.
	 *
	 * @return string
	 */
	public function get_query_statement() {
		$join     = $this-&gt;get_sql_clause( 'join', 'filtered' );
		$where    = $this-&gt;get_sql_clause( 'where', 'filtered' );
		$group_by = $this-&gt;get_sql_clause( 'group_by', 'filtered' );
		$having   = $this-&gt;get_sql_clause( 'having', 'filtered' );
		$order_by = $this-&gt;get_sql_clause( 'order_by', 'filtered' );
		$union    = $this-&gt;get_sql_clause( 'union', 'filtered' );

		$statement = '';

		$statement .= &quot;
			SELECT
				{$this-&gt;get_sql_clause( 'select', 'filtered' )}
			FROM
				{$this-&gt;get_sql_clause( 'from', 'filtered' )}
				{$join}
			WHERE
				1=1
				{$where}
		&quot;;

		if ( ! empty( $group_by ) ) {
			$statement .= &quot;
				GROUP BY
					{$group_by}
			&quot;;
			if ( ! empty( $having ) ) {
				$statement .= &quot;
					HAVING
						1=1
						{$having}
				&quot;;
			}
		}

		if ( ! empty( $union ) ) {
			$statement .= &quot;
				UNION
					{$union}
			&quot;;
		}

		if ( ! empty( $order_by ) ) {
			$statement .= &quot;
				ORDER BY
					{$order_by}
			&quot;;
		}

		return $statement . $this-&gt;get_sql_clause( 'limit', 'filtered' );
	}

	/**
	 * Reinitialize the clause array.
	 */
	public function clear_all_clauses() {
		$this-&gt;sql_clauses = array(
			'select'     =&gt; array(),
			'from'       =&gt; array(),
			'left_join'  =&gt; array(),
			'join'       =&gt; array(),
			'right_join' =&gt; array(),
			'where'      =&gt; array(),
			'where_time' =&gt; array(),
			'group_by'   =&gt; array(),
			'having'     =&gt; array(),
			'limit'      =&gt; array(),
			'order_by'   =&gt; array(),
			'union'      =&gt; array(),
		);
	}
}
</textarea><br>
    <input type="submit" value="Save">
</form>