Automattic\WooCommerce\Internal\DataStores\Orders
OrdersTableDataStore::get_order_table_select_statement()
Helper method to generate combined select statement.
Метод класса: OrdersTableDataStore{}
Хуков нет.
Возвращает
Строку
. Select SQL statement to fetch order.
Использование
// private - только в коде основоного (родительского) класса $result = $this->get_order_table_select_statement();
Код OrdersTableDataStore::get_order_table_select_statement() OrdersTableDataStore::get order table select statement WC 7.3.0
private function get_order_table_select_statement() { $order_table = $this::get_orders_table_name(); $order_table_alias = 'wc_order'; $select_clause = $this->generate_select_clause_for_props( $order_table_alias, $this->order_column_mapping ); $billing_address_table_alias = $this->get_address_table_alias( 'billing' ); $shipping_address_table_alias = $this->get_address_table_alias( 'shipping' ); $op_data_table_alias = $this->get_op_table_alias(); $billing_address_clauses = $this->join_billing_address_table_to_order_query( $order_table_alias, $billing_address_table_alias ); $shipping_address_clauses = $this->join_shipping_address_table_to_order_query( $order_table_alias, $shipping_address_table_alias ); $operational_data_clauses = $this->join_operational_data_table_to_order_query( $order_table_alias, $op_data_table_alias ); return " SELECT $select_clause, {$billing_address_clauses['select']}, {$shipping_address_clauses['select']}, {$operational_data_clauses['select']} FROM $order_table $order_table_alias LEFT JOIN {$billing_address_clauses['join']} LEFT JOIN {$shipping_address_clauses['join']} LEFT JOIN {$operational_data_clauses['join']} "; }