Automattic\WooCommerce\Admin\Notes

DataStore::get_notes_where_clauses() public WC 1.0

Return where clauses for getting notes by status and type. For use in both the count and listing queries.

@param array $args Array of args to pass.

{} Это метод класса: DataStore{}

Возвращает

Строку. Where clauses for the query.

Использование

$DataStore = new DataStore();
$DataStore->get_notes_where_clauses( $args );

$args **

-
По умолчанию: array()

Код DataStore::get_notes_where_clauses() DataStore::get notes where clauses ^{WC 5.7.0}

public function get_notes_where_clauses( $args = array() ) {
	$allowed_types    = Note::get_allowed_types();
	$where_type_array = $this->get_escaped_arguments_array_by_key( $args, 'type', $allowed_types );

	$allowed_statuses   = Note::get_allowed_statuses();
	$where_status_array = $this->get_escaped_arguments_array_by_key( $args, 'status', $allowed_statuses );

	$escaped_is_deleted = '';
	if ( isset( $args['is_deleted'] ) ) {
		$escaped_is_deleted = esc_sql( $args['is_deleted'] );
	}

	$where_name_array   = $this->get_escaped_arguments_array_by_key( $args, 'name' );
	$where_source_array = $this->get_escaped_arguments_array_by_key( $args, 'source' );

	$escaped_where_types  = implode( ',', $where_type_array );
	$escaped_where_status = implode( ',', $where_status_array );
	$escaped_where_names  = implode( ',', $where_name_array );
	$escaped_where_source = implode( ',', $where_source_array );
	$where_clauses        = '';

	if ( ! empty( $escaped_where_types ) ) {
		$where_clauses .= " AND type IN ($escaped_where_types)";
	}

	if ( ! empty( $escaped_where_status ) ) {
		$where_clauses .= " AND status IN ($escaped_where_status)";
	}

	if ( ! empty( $escaped_where_names ) ) {
		$where_clauses .= " AND name IN ($escaped_where_names)";
	}

	if ( ! empty( $escaped_where_source ) ) {
		$where_clauses .= " AND source IN ($escaped_where_source)";
	}

	$where_clauses .= $escaped_is_deleted ? ' AND is_deleted = 1' : ' AND is_deleted = 0';

	/**
	 * Filter the notes WHERE clause before retrieving the data.
	 *
	 * Allows modification of the notes select criterial.
	 *
	 * @param string $where_clauses The generated WHERE clause.
	 * @param array  $args          The original arguments for the request.
	 */
	return apply_filters( 'woocommerce_note_where_clauses', $where_clauses, $args );
}