?HAMA

Navigation

Breadcrumbs

/ / home / nshryvcy / himaltourism.com / wp-content / plugins / woocommerce / src / Admin / API / Reports

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 5.15 KB

/home/nshryvcy/himaltourism.com/wp-content/plugins/woocommerce/src/Admin/API/Reports/SqlQuery.php

Text Base64

<?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'     => array(),
		'from'       => array(),
		'left_join'  => array(),
		'join'       => array(),
		'right_join' => array(),
		'where'      => array(),
		'where_time' => array(),
		'group_by'   => array(),
		'having'     => array(),
		'limit'      => array(),
		'order_by'   => array(),
		'union'      => array(),
	);
	/**
	 * SQL clause merge filters.
	 *
	 * @var array
	 */
	private $sql_filters = array(
		'where' => array(
			'where',
			'where_time',
		),
		'join'  => 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->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->sql_clauses[ $type ] ) && ! empty( $clause ) ) {
			$this->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->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 );
	}

/**
	 * 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->sql_clauses[ $type ] ) ) {
				$this->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->sql_clauses[ $type ] ) ) {
			foreach ( $this->sql_clauses[ $type ] as $key => $sql ) {
				$this->sql_clauses[ $type ][ $key ] = str_replace( $search, $replace, $sql );
			}
		}
	}

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

$statement = '';

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

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

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

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

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

/**
	 * Reinitialize the clause array.
	 */
	public function clear_all_clauses() {
		$this->sql_clauses = array(
			'select'     => array(),
			'from'       => array(),
			'left_join'  => array(),
			'join'       => array(),
			'right_join' => array(),
			'where'      => array(),
			'where_time' => array(),
			'group_by'   => array(),
			'having'     => array(),
			'limit'      => array(),
			'order_by'   => array(),
			'union'      => array(),
		);
	}
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 13 × Files: 11

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
Categories DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Coupons DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Customers DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Downloads DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Export DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Import DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Orders DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
PerformanceIndicators DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Products DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Revenue DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Stock DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Taxes DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Variations DIR	-	drwxr-xr-x	2026-03-03 06:10:19	Edit Download recursive recursive
Cache.php	1.48 KB	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
Controller.php	10.14 KB	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
DataStore.php	49.29 KB	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
DataStoreInterface.php	401 B	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
ExportableInterface.php	624 B	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
ExportableTraits.php	624 B	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
ParameterException.php	326 B	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
Query.php	593 B	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
Segmenter.php	21.21 KB	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
SqlQuery.php	5.15 KB	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive
TimeInterval.php	23.42 KB	lrw-r--r--	2026-03-03 06:10:19	Edit Download recursive recursive