Automattic\WooCommerce\Admin\API\Reports
SqlQuery::get_sql_clause()
Get SQL clause by type.
Method of the class: SqlQuery{}
Hooks from the method
Return
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 9.6.1
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 ); }