Automattic\WooCommerce\Admin\API\Reports

SqlQuery::get_sql_clause │ protected │ WC 1.0

Get SQL clause by type.

Method of the class: SqlQuery{}

Returns

String. SQL clause.

Usage

// protected - for code of main (parent) or child class
$result = $this->get_sql_clause( $type, $handling );

$type(string) (required)

Clause type.

$handling(string)

Whether to filter the return value (filtered|unfiltered).
Default: unfiltered

SqlQuery::get_sql_clause() SqlQuery::get sql clause code ^{WC 10.3.6}

protected function get_sql_clause( $type, $handling = 'unfiltered' ) {
	if ( ! isset( $this->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->sql_clauses[ $type ] );
	}

	if ( isset( $this->sql_filters[ $type ] ) ) {
		$clauses = array();
		foreach ( $this->sql_filters[ $type ] as $subset ) {
			$clauses = array_merge( $clauses, $this->sql_clauses[ $subset ] );
		}
	} else {
		$clauses = $this->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( "woocommerce_analytics_clauses_{$type}", $clauses, $this->context );
	/**
	 * Filter SQL clauses by type and context.
	 *
	 * @param array  $clauses The original arguments for the request.
	 */
	$clauses = apply_filters( "woocommerce_analytics_clauses_{$type}_{$this->context}", $clauses );
	return implode( ' ', $clauses );
}