23769685853

Committed 30 Mar 2026 09:56PM UTC coverage: 89.92% (+0.5%) from 89.424%

Build # 23769685853

Build Type

Pull #1003

github

Committed by

web-flow

Commit Message

Merge d180fa72b into 6fb7b226f

Pull Request Pull Request #1003: devops: WC email template tests, COT cursor HPOS fix, checkout account auth

Coverage Stats

79 of 85 new or added lines in 6 files covered. (92.94%)

2 existing lines in 2 files now uncovered.

15959 of 17748 relevant lines covered (89.92%)

143.41 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

98.04

/includes/data/class-db-hooks.php

<?php
/**
 * Register hooks for the filtering DB queries.
 *
 * @package WPGraphQL\WooCommerce\Data
 * @since 0.14.0
 */

namespace WPGraphQL\WooCommerce\Data;

use Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore;

/**
 * Class DB_Hooks
 */
class DB_Hooks {
        /**
         * DB_Hooks constructor.
         */
        public function __construct() {
                add_filter( 'woocommerce_order_query_args', [ $this, 'clean_query_vars' ] );
                add_filter( 'woocommerce_orders_table_query_clauses', [ $this, 'add_cursor' ], 10, 3 );
        }

        /**
         * Meta key to COT column mapping for orderby translation.
         *
         * @var array
         */
        private static $meta_to_column = [
                '_order_total'    => 'total',
                '_order_tax'      => 'tax_amount',
                '_cart_discount'  => 'discount_total_amount',
                '_date_paid'      => 'date_paid',
                '_date_completed' => 'date_completed',
                '_order_key'      => 'payment_method',
        ];

        /**
         * Translate legacy meta_key orderby to COT column orderby in query vars.
         *
         * When HPOS is active, meta keys like _order_total are stored as columns
         * in the orders table, not in the meta table. This replaces meta_value_num
         * orderby with the direct column name so WC's OrdersTableQuery doesn't
         * generate an invalid meta join.
         *
         * @param array $query_vars The query vars.
         *
         * @return array
         */
        public function clean_query_vars( $query_vars ) {
                if ( true !== is_graphql_request() ) {
                        return $query_vars;
                }

                if ( ! \Automattic\WooCommerce\Utilities\OrderUtil::custom_orders_table_usage_is_enabled() ) {
                        return $query_vars;
                }

                // Map post_* orderby fields to COT-compatible equivalents.
                $post_field_map = [
                        'post_date'     => 'date',
                        'post_modified' => 'date_modified',
                        'post_parent'   => 'parent',
                ];

                $orderby = $query_vars['orderby'] ?? [];
                if ( is_array( $orderby ) ) {
                        foreach ( $post_field_map as $post_field => $cot_field ) {
                                if ( isset( $orderby[ $post_field ] ) ) {
                                        $orderby[ $cot_field ] = $orderby[ $post_field ];
                                        unset( $orderby[ $post_field ] );
                                }
                        }
                        $query_vars['orderby'] = $orderby;
                }

                // Map meta_key orderby to COT column orderby.
                $meta_key = $query_vars['meta_key'] ?? '';
                if ( empty( $meta_key ) || ! isset( self::$meta_to_column[ $meta_key ] ) ) {
                        return $query_vars;
                }

                $column        = self::$meta_to_column[ $meta_key ];
                $default_order = isset( $query_vars['graphql_cursor_compare'] ) && '>' === $query_vars['graphql_cursor_compare']
                        ? 'DESC'
                        : 'ASC';

                $orderby = $query_vars['orderby'] ?? [];
                if ( is_array( $orderby ) ) {
                        $order = $orderby['meta_value_num'] ?? ( $orderby['meta_value'] ?? $default_order );
                        unset( $orderby['meta_value_num'], $orderby['meta_value'] );
                        $orderby[ $column ]    = $order;
                        $query_vars['orderby'] = $orderby;
                }

                unset( $query_vars['meta_key'] );

                return $query_vars;
        }

        /**
         * Add the cursor to the WHERE clause of the query.
         *
         * @param string[]                                                            $clauses {
         *                                                        Associative array of the clauses for the query.
         *
         *     @type string $fields  The SELECT clause of the query.
         *     @type string $join    The JOIN clause of the query.
         *     @type string $where   The WHERE clause of the query.
         *     @type string $groupby The GROUP BY clause of the query.
         *     @type string $orderby The ORDER BY clause of the query.
         *     @type string $limits  The LIMIT clause of the query.
         * }
         * @param \Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableQuery $query The OrdersTableQuery instance (passed by reference).
         * @param array                                                               $args  Query args.
         *
         * @return string[]
         */
        public function add_cursor( $clauses, $query, $args ) {
                if ( true !== is_graphql_request() ) {
                        return $clauses;
                }

                /** @var \Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore $order_datastore */
                $order_datastore = wc_get_container()->get( OrdersTableDataStore::class );
                $tables          = $order_datastore::get_all_table_names_with_id();

                // apply the after cursor to the query.
                if ( ! empty( $args['graphql_after_cursor'] ) ) {
                        $after_cursor      = new Cursor\COT_Cursor( $args, $query, 'after' );
                        $clauses['where'] .= $after_cursor->get_where();
                }

                // apply the before cursor to the query.
                if ( ! empty( $args['graphql_before_cursor'] ) ) {
                        $before_cursor     = new Cursor\COT_Cursor( $args, $query, 'before' );
                        $clauses['where'] .= $before_cursor->get_where();
                }

                // If the cursor "graphql_cursor_compare" arg is not in the query,
                // default to using ID DESC as the stabilizer.
                $orderby = ! empty( $clauses['orderby'] ) && is_string( $clauses['orderby'] )
                        ? $clauses['orderby'] . ','
                        : '';

                if ( ! isset( $args['graphql_cursor_compare'] ) ) {
                        $clauses['orderby'] = "{$orderby} {$tables['orders']}.id DESC ";
                } else {
                        // Check the cursor compare order.
                        $order = '>' === $args['graphql_cursor_compare'] ? 'ASC' : 'DESC';

                        $clauses['orderby'] = "{$orderby} {$tables['orders']}.id {$order} ";
                }

                return $clauses;
        }
}

1	<?php
2	/**
3	* Register hooks for the filtering DB queries.
4	*
5	* @package WPGraphQL\WooCommerce\Data
6	* @since 0.14.0
7	*/
8
9	namespace WPGraphQL\WooCommerce\Data;
10
11	use Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore;
12
13	/**
14	* Class DB_Hooks
15	*/
16	class DB_Hooks {
17	/**
18	* DB_Hooks constructor.
19	*/
20	public function __construct() {
21	add_filter( 'woocommerce_order_query_args', [ $this, 'clean_query_vars' ] );	29✔
22	add_filter( 'woocommerce_orders_table_query_clauses', [ $this, 'add_cursor' ], 10, 3 );	29✔
23	}
24
25	/**
26	* Meta key to COT column mapping for orderby translation.
27	*
28	* @var array
29	*/
30	private static $meta_to_column = [
31	'_order_total' => 'total',
32	'_order_tax' => 'tax_amount',
33	'_cart_discount' => 'discount_total_amount',
34	'_date_paid' => 'date_paid',
35	'_date_completed' => 'date_completed',
36	'_order_key' => 'payment_method',
37	];
38
39	/**
40	* Translate legacy meta_key orderby to COT column orderby in query vars.
41	*
42	* When HPOS is active, meta keys like _order_total are stored as columns
43	* in the orders table, not in the meta table. This replaces meta_value_num
44	* orderby with the direct column name so WC's OrdersTableQuery doesn't
45	* generate an invalid meta join.
46	*
47	* @param array $query_vars The query vars.
48	*
49	* @return array
50	*/
51	public function clean_query_vars( $query_vars ) {
52	if ( true !== is_graphql_request() ) {	56✔
53	return $query_vars;	31✔
54	}
55
56	if ( ! \Automattic\WooCommerce\Utilities\OrderUtil::custom_orders_table_usage_is_enabled() ) {	51✔
57	return $query_vars;	6✔
58	}
59
60	// Map post_* orderby fields to COT-compatible equivalents.
61	$post_field_map = [	45✔
62	'post_date' => 'date',	45✔
63	'post_modified' => 'date_modified',	45✔
64	'post_parent' => 'parent',	45✔
65	];	45✔
66
67	$orderby = $query_vars['orderby'] ?? [];	45✔
68	if ( is_array( $orderby ) ) {	45✔
69	foreach ( $post_field_map as $post_field => $cot_field ) {	24✔
70	if ( isset( $orderby[ $post_field ] ) ) {	24✔
71	$orderby[ $cot_field ] = $orderby[ $post_field ];	3✔
72	unset( $orderby[ $post_field ] );	3✔
73	}
74	}
75	$query_vars['orderby'] = $orderby;	24✔
76	}
77
78	// Map meta_key orderby to COT column orderby.
79	$meta_key = $query_vars['meta_key'] ?? '';	45✔
80	if ( empty( $meta_key ) \|\| ! isset( self::$meta_to_column[ $meta_key ] ) ) {	45✔
81	return $query_vars;	42✔
82	}
83
84	$column = self::$meta_to_column[ $meta_key ];	3✔
85	$default_order = isset( $query_vars['graphql_cursor_compare'] ) && '>' === $query_vars['graphql_cursor_compare']	3✔
NEW 86	? 'DESC'	×
87	: 'ASC';	3✔
88
89	$orderby = $query_vars['orderby'] ?? [];	3✔
90	if ( is_array( $orderby ) ) {	3✔
91	$order = $orderby['meta_value_num'] ?? ( $orderby['meta_value'] ?? $default_order );	3✔
92	unset( $orderby['meta_value_num'], $orderby['meta_value'] );	3✔
93	$orderby[ $column ] = $order;	3✔
94	$query_vars['orderby'] = $orderby;	3✔
95	}
96
97	unset( $query_vars['meta_key'] );	3✔
98
99	return $query_vars;	3✔
100	}
101
102	/**
103	* Add the cursor to the WHERE clause of the query.
104	*
105	* @param string[] $clauses {
106	* Associative array of the clauses for the query.
107	*
108	* @type string $fields The SELECT clause of the query.
109	* @type string $join The JOIN clause of the query.
110	* @type string $where The WHERE clause of the query.
111	* @type string $groupby The GROUP BY clause of the query.
112	* @type string $orderby The ORDER BY clause of the query.
113	* @type string $limits The LIMIT clause of the query.
114	* }
115	* @param \Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableQuery $query The OrdersTableQuery instance (passed by reference).
116	* @param array $args Query args.
117	*
118	* @return string[]
119	*/
120	public function add_cursor( $clauses, $query, $args ) {
121	if ( true !== is_graphql_request() ) {	50✔
122	return $clauses;	31✔
123	}
124
125	/** @var \Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore $order_datastore */
126	$order_datastore = wc_get_container()->get( OrdersTableDataStore::class );	45✔
127	$tables = $order_datastore::get_all_table_names_with_id();	45✔
128
129	// apply the after cursor to the query.
130	if ( ! empty( $args['graphql_after_cursor'] ) ) {	45✔
131	$after_cursor = new Cursor\COT_Cursor( $args, $query, 'after' );	8✔
132	$clauses['where'] .= $after_cursor->get_where();	8✔
133	}
134
135	// apply the before cursor to the query.
136	if ( ! empty( $args['graphql_before_cursor'] ) ) {	45✔
137	$before_cursor = new Cursor\COT_Cursor( $args, $query, 'before' );	3✔
138	$clauses['where'] .= $before_cursor->get_where();	3✔
139	}
140
141	// If the cursor "graphql_cursor_compare" arg is not in the query,
142	// default to using ID DESC as the stabilizer.
143	$orderby = ! empty( $clauses['orderby'] ) && is_string( $clauses['orderby'] )	45✔
144	? $clauses['orderby'] . ','	43✔
145	: '';	2✔
146
147	if ( ! isset( $args['graphql_cursor_compare'] ) ) {	45✔
148	$clauses['orderby'] = "{$orderby} {$tables['orders']}.id DESC ";	27✔
149	} else {
150	// Check the cursor compare order.
151	$order = '>' === $args['graphql_cursor_compare'] ? 'ASC' : 'DESC';	24✔
152
153	$clauses['orderby'] = "{$orderby} {$tables['orders']}.id {$order} ";	24✔
154	}
155
156	return $clauses;	45✔
157	}
158	}

wp-graphql / wp-graphql-woocommerce / 23769685853

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous