WC_Admin_Log_Table_List::get_items_query_order │ protected │ WC 1.0

Get prepared ORDER BY clause for items query

Method of the class: WC_Admin_Log_Table_List{}

No Hooks.

Returns

String. Prepared ORDER BY clause for items query.

Usage

// protected - for code of main (parent) or child class
$result = $this->get_items_query_order();

WC_Admin_Log_Table_List::get_items_query_order() WC Admin Log Table List::get items query order code ^{WC 10.5.0}

protected function get_items_query_order() {
	$valid_orders = array( 'level', 'source', 'timestamp' );
	if ( ! empty( $_REQUEST['orderby'] ) && in_array( $_REQUEST['orderby'], $valid_orders ) ) {
		$by = wc_clean( $_REQUEST['orderby'] );
	} else {
		$by = 'log_id';
	}
	$by = esc_sql( $by );

	if ( ! empty( $_REQUEST['order'] ) && 'asc' === strtolower( $_REQUEST['order'] ) ) {
		$order = 'ASC';
	} else {
		$order = 'DESC';
	}

	$orderby = "ORDER BY {$by} {$order}";
	if ( 'log_id' !== $by ) {
		$orderby .= ", log_id {$order}";
	}

	return $orderby;
}