Inventory_Presser_Plugin::change_order_by_for_odometer( string $orderby, object $query )
Removes commas from the meta value used in the ORDER BY of the query so that odometer values can be sorted as numbers instead of strings.
On This Page
Parameters Parameters
- $orderby
-
(string) (Required) The ORDER BY clause of a database query.
- $query
-
(object) (Required) An instance of the WP_Query class.
Return Return
(string) The changed ORDER BY clause
Source Source
File: inventory-presser.php
public function change_order_by_for_odometer( $orderby, $query ) {
/**
* Changes
* ORDER BY {$wpdb->postmeta}.meta_value+0
* to
* ORDER BY REPLACE( {$wpdb->postmeta}.meta_value, ',', '' )+0
*/
global $wpdb;
return str_replace( "{$wpdb->postmeta}.meta_value+0", "REPLACE( {$wpdb->postmeta}.meta_value, ',', '' )+0", $orderby );
}
Expand full source codeCollapse full source codeView on Github