From 519164cb1f7a6a0e571f55ac1ccf2f144635901b Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 26 Apr 2017 13:36:01 -0400 Subject: [PATCH] One more filter to move into brewbakers theme. Pretty cool that we can just move them to the theme though. --- setup/frontHooks.php | 28 ---------------------------- 1 file changed, 28 deletions(-) diff --git a/setup/frontHooks.php b/setup/frontHooks.php index 0327cbb..df651f9 100644 --- a/setup/frontHooks.php +++ b/setup/frontHooks.php @@ -88,34 +88,6 @@ add_filter('glm-member-db-front-search-query', function( $queryParts ) { } return $queryParts; }); -add_filter('glm-member-db-front-search-query-orderby', function($originalOrderBy){ - // Order by clause for Just Arrived. - $orderBy = " ( - SELECT CASE WHEN field_data = 'Yes' THEN 0 ELSE 1 end - FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_field_data - WHERE field_id = (SELECT id - FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_fields - WHERE field_name = 'Just Arrived') - AND ref_dest = T.id) "; - // Order by clause for Red Hot Deal. - $orderBy .= ", ( - SELECT CASE WHEN field_data = 'Yes' THEN 0 ELSE 1 end - FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_field_data - WHERE field_id = (SELECT id - FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_fields - WHERE field_name = 'Red Hot Deal') - AND ref_dest = T.id) "; - // Order by clause for Coming Soon. - $orderBy .= ", ( - SELECT CASE WHEN field_data = 'Yes' THEN 0 ELSE 1 end - FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_field_data - WHERE field_id = (SELECT id - FROM " . GLM_MEMBERS_FIELDS_PLUGIN_DB_PREFIX . "custom_fields - WHERE field_name = 'Coming Soon') - AND ref_dest = T.id) "; - $orderBy .= ", $originalOrderBy DESC "; - return $orderBy; -}); add_filter('glm-member-db-fields-front-list-query-params', function(){ $queryParams = array(); // Get all custom fields -- 2.17.1