Boston tech events calendar<\/a>, and the event prices ended up being a pretty large range. From meetups with $5 pizza costs to conferences with $5000+ registration fees. I wasn’t liking that my only options for the cost filter were a range slider that wasn’t really convenient for the distribution of the costs or a checklist of price-ranges that ended up being pretty arbitrary (and didn’t cover the ranges I actually wanted).<\/p>\nSo I added a new filter, following the process I’d seen on these forums (where the category filter was used as an example to add a custom taxonomy filter). Basically I copied the code for the Cost filter class, modified it, and added it to my functions.php with a line to initialize it:<\/p>\n
class BSG__Cost__Tribe__Events__Filterbar__Filters__Cost extends Tribe__Events__Filterbar__Filter {\n\tconst EXPLICITLY_FREE = 'set_to_0';\n\tconst IMPLICITLY_FREE = 'unset_or_0';\n\n\tpublic $type = 'range';\n\tpublic $free = self::IMPLICITLY_FREE;\n\tprivate $min_cost = null;\n\tprivate $max_cost = null;\n\n\tprotected function settings() {\n\t\tparent::settings();\n\t\t$this->free_logic();\n\t}\n\n\tprotected function free_logic() {\n\t\t$settings = Tribe__Events__Filterbar__View::instance()->get_filter_settings();\n\t\t$this->free = isset( $settings[ $this->slug ]['free'] ) && self::EXPLICITLY_FREE === $settings[ $this->slug ]['free']\n\t\t\t? self::EXPLICITLY_FREE : self::IMPLICITLY_FREE;\n\t}\n\n\tprotected function get_submitted_value() {\n\t\tif ( ! empty( $_REQUEST[ 'tribe_' . $this->slug ] ) ) {\n\t\t\t$value = (array) $_REQUEST[ 'tribe_' . $this->slug ];\n\n\t\t\tif ( isset( $value['min'] ) && isset( $value['max'] ) ) {\n\t\t\t\treturn array( $value );\n\t\t\t} else {\n\t\t\t\tforeach ( $value as &$v ) {\n\t\t\t\t\t$range = explode( '-', $v );\n\t\t\t\t\tif ( ! preg_match( '\/[0-9]+\\-[0-9]+\/', $v ) ) {\n\t\t\t\t\t\tcontinue;\n\t\t\t\t\t}\n\t\t\t\t\t$v = array( 'min' => $range[0], 'max' => $range[1] );\n\t\t\t\t}\n\t\t\t\treturn $value;\n\t\t\t}\n\t\t}\n\t\treturn array();\n\t}\n\n\tpublic function get_admin_form() {\n\t\t$title = $this->get_title_field();\n\t\t$type = $this->get_type_field();\n\t\treturn $title.$type;\n\t}\n\n\tprotected function get_type_field() {\n\t\t$name = $this->get_admin_field_name( 'type' );\n\t\t$type_field = sprintf( __( 'Type: %s %s', 'tribe-events-filter-view' ),\n\t\t\tsprintf( '<label><input type="radio" name="%s" value="range" %s \/> %s<\/label>',\n\t\t\t\t$name,\n\t\t\t\tchecked( $this->type, 'range', false ),\n\t\t\t\t__( 'Range Slider', 'tribe-events-filter-view' )\n\t\t\t),\n\t\t\tsprintf( '<label><input type="radio" name="%s" value="checkbox" %s \/> %s<\/label>',\n\t\t\t\t$name,\n\t\t\t\tchecked( $this->type, 'checkbox', false ),\n\t\t\t\t__( 'Checkboxes', 'tribe-events-filter-view' )\n\t\t\t)\n\t\t);\n\n\t\t$name = $this->get_admin_field_name( 'free' );\n\t\t$cost_field = sprintf( __( 'Events are considered free when cost field is: %s %s', 'tribe-events-filter-view' ),\n\t\t\tsprintf( '<label><input type="radio" name="%s" value="unset_or_0" %s \/> %s<\/label>',\n\t\t\t\t$name,\n\t\t\t\tchecked( $this->free, 'unset_or_0', false ),\n\t\t\t\tsprintf(\n\t\t\t\t\t__( '"%s" or empty or set to zero', 'tribe-events-filter-view' ),\n\t\t\t\t\t'<strong><abbr title="' . __( 'Used as the identifier for free Events', 'tribe-events-filter-view' ) . '">' . $this->get_free_string() . '<\/abbr><\/strong>'\n\t\t\t\t)\n\t\t\t),\n\t\t\tsprintf( '<label><input type="radio" name="%s" value="set_to_0" %s \/> %s<\/label>',\n\t\t\t\t$name,\n\t\t\t\tchecked( $this->free, 'set_to_0', false ),\n\t\t\t\t__( 'Only when set to zero', 'tribe-events-filter-view' )\n\t\t\t)\n\t\t);\n\n\t\treturn '<div class="tribe_events_active_filter_type_options">' . $type_field . $cost_field . '<\/div>';\n\t}\n\n\tprotected function get_free_string() {\n\t\treturn _x( 'Free', 'Used as the identifier for free Events', 'tribe-events-filter-view' );\n\t}\n\n\tprotected function get_values() {\n\t\t$this->set_min_and_max();\n\n\t\tif ( $this->type == 'range' ) {\n\t\t\treturn array( 'min' => $this->min_cost, 'max' => $this->max_cost );\n\t\t}\n\n\t\t$cost_range = array();\n\t\tif ( $this->has_non_numeric_costs() ) {\n\t\t\t$cost_range['other'] = __( 'Other', 'tribe-events-filter-view' );\n\t\t}\n\n\t\tif ( $this->min_cost == 0 ) {\n\t\t\t$cost_range['0-0'] = __( 'Free', 'tribe-events-filter-view' );\n\t\t}\n\t\tif ( $this->max_cost == $this->min_cost ) {\n\t\t\tif ( $this->max_cost != 0 ) {\n\t\t\t\t$cost_range[ $this->min_cost . '-' . $this->max_cost ] = $this->min_cost . '-' . $this->max_cost;\n\t\t\t}\n\t\t} else { \/\/hard-coding my desired price ranges\n\n\t\t\t$cost_range['1-49'] = 'Inexpensive (\\$1 - \\$49)';\n\t\t\t$cost_range['50-249'] = 'Moderate (\\$50 - \\$249)';\n\t\t\t$cost_range['250-' . $this->max_cost] = 'Professional (\\$250+)';\n\t\t}\n\t\t$values = array();\n\t\tforeach ( $cost_range as $key => $cost ) {\n\t\t\t$values[] = array(\n\t\t\t\t'name' => $cost,\n\t\t\t\t'value' => $key,\n\t\t\t);\n\t\t}\n\t\treturn $values;\n\t}\n\n\tprivate function partition_range( $min, $max, $count ) {\n\t\t$range_size = $max - $min + 1;\n\t\t$partition_size = floor( $range_size \/ $count );\n\t\t$partition_remainder = $range_size % $count;\n\t\t$partitioned = array();\n\t\t$mark = $min;\n\t\tfor ( $i = 0; $i < $count; $i++ ) {\n\t\t\t$incr = ( $i < $partition_remainder ) ? $partition_size : $partition_size - 1;\n\t\t\t$partitioned[ $i ] = array(\n\t\t\t\t'min' => $mark,\n\t\t\t\t'max' => $mark + $incr,\n\t\t\t);\n\t\t\t$mark += $incr + 1;\n\t\t}\n\t\treturn $partitioned;\n\t}\n\n\tprotected function is_selected( $option ) {\n\t\tif ( preg_match( '\/[0-9]*\\-[0-9]*\/', $option ) ) {\n\t\t\t$option = explode( '-', $option );\n\t\t\t$option = array(\n\t\t\t\t'min' => $option[0],\n\t\t\t\t'max' => $option[1],\n\t\t\t);\n\t\t} elseif ( in_array( 'other', $this->currentValue ) ) {\n\t\t\treturn true;\n\t\t}\n\n\t\treturn in_array( (array) $option, $this->currentValue );\n\t}\n\n\tprotected function setup_query_filters() {\n\t\tif ( $this->currentValue ) {\n\t\t\t$this->set_min_and_max();\n\t\t}\n\t\tparent::setup_query_filters();\n\t}\n\n\tprotected function setup_join_clause() {\n\t\tglobal $wpdb;\n\t\t$this->joinClause = " LEFT JOIN {$wpdb->postmeta} AS cost_filter ON ({$wpdb->posts}.ID = cost_filter.post_id)";\n\t}\n\n\tprotected function setup_where_clause() {\n\t\tglobal $wpdb;\n\t\t$clauses = array();\n\n\t\tforeach ( $this->currentValue as $value ) {\n\t\t\t$free_clause = '';\n\t\t\tif ( isset( $value['min'] ) ) {\n\t\t\t\t\/\/ Should we exclude events where a cost has not been provided?\n\t\t\t\t$free_clause = $this->free_clause( $value['min'] );\n\t\t\t}\n\n\t\t\tif ( 'other' === $value ) {\n\t\t\t\t$length_clause = null;\n\t\t\t\tif ( self::IMPLICITLY_FREE === $this->free ) {\n\t\t\t\t\t$length_clause = 'AND LENGTH( TRIM( cost_filter.meta_value ) ) > 0';\n\t\t\t\t}\n\n\t\t\t\t$clause = "\n\t\t\t\t\t( cost_filter.meta_key = '_EventCost'\n\t\t\t\t\t$length_clause\n\t\t\t\t\tAND CAST( cost_filter.meta_value AS SIGNED ) = 0\n\t\t\t\t\tAND cost_filter.meta_value != '0'\n\t\t\t\t";\n\n\t\t\t\tif ( self::EXPLICITLY_FREE !== $this->free ) {\n\t\t\t\t\t$clause .= $wpdb->prepare( ' AND LOWER(cost_filter.meta_value) != %s', strtolower( $this->get_free_string() ) );\n\t\t\t\t}\n\n\t\t\t\t\/\/ Close the Conditional\n\t\t\t\t$clause .= ')';\n\n\t\t\t\t$clauses[] = $clause;\n\t\t\t} elseif ( isset( $value['min'], $value['max'] ) && $value['min'] == 0 && $value['max'] == 0 ) {\n\n\t\t\t\t$blank_clause = null;\n\t\t\t\tif ( self::IMPLICITLY_FREE === $this->free ) {\n\t\t\t\t\t$blank_clause = "\n\t\t\t\t\t\tOR cost_filter.meta_value = ''\n\t\t\t\t\t\tOR cost_filter.meta_value IS NULL\n\t\t\t\t\t\tOR $free_clause\n\t\t\t\t\t";\n\t\t\t\t}\n\n\t\t\t\t$clauses[] = "\n\t\t\t\t\t(\n\t\t\t\t\t\tcost_filter.meta_key = '_EventCost'\n\t\t\t\t\t\tAND (\n\t\t\t\t\t\t\tcost_filter.meta_value = '0'\n\t\t\t\t\t\t\t$blank_clause\n\t\t\t\t\t\t)\n\t\t\t\t\t)\n\t\t\t\t";\n\t\t\t} else {\n\t\t\t\t$clauses[] = $wpdb->prepare(\n\t\t\t\t\t"(\n\t\t\t\t\t\tcost_filter.meta_key = '_EventCost'\n\t\t\t\t\t\tAND cost_filter.meta_value >= %d\n\t\t\t\t\t\tAND cost_filter.meta_value IS NOT NULL\n\t\t\t\t\t\tAND CAST(cost_filter.meta_value AS SIGNED) BETWEEN %d AND %d\n\t\t\t\t\t) ",\n\t\t\t\t\t$value['min'],\n\t\t\t\t\t$value['min'],\n\t\t\t\t\t$value['max']\n\t\t\t\t);\n\t\t\t}\n\t\t}\n\n\t\t$this->whereClause = ' AND (' . implode( ' OR ', $clauses ) . ') ';\n\t}\n\n\tprotected function free_clause( $min ) {\n\t\tglobal $wpdb;\n\n\t\tif ( 0 !== (int) $min ) {\n\t\t\treturn 'LENGTH( TRIM( cost_filter.meta_value ) ) > 0 AND CAST( cost_filter.meta_value AS SIGNED ) > 0';\n\t\t}\n\n\t\treturn $wpdb->prepare(\n\t\t\t'(\n\t\t\t\tLENGTH( TRIM( cost_filter.meta_value ) ) > 0\n\t\t\t\tAND CAST( cost_filter.meta_value AS SIGNED ) = 0\n\t\t\t\tAND LOWER( cost_filter.meta_value ) = %s\n\t\t\t)',\n\t\t\tstrtolower( $this->get_free_string() )\n\t\t);\n\t}\n\n\tprivate function set_min_and_max() {\n\t\tif ( ! isset( $this->max_cost ) || ! isset( $this->min_cost ) ) {\n\t\t\t$this->max_cost = tribe_get_maximum_cost();\n\t\t\t$this->min_cost = tribe_has_uncosted_events() ? 0 : tribe_get_minimum_cost();\n\t\t}\n\t}\n\n\tprivate function has_non_numeric_costs() {\n\t\t$costs = Tribe__Events__Cost_Utils::instance()->get_all_costs();\n\t\tforeach ( $costs as $index => $cost ) {\n\t\t\tif ( is_numeric( $index ) ) {\n\t\t\t\tunset( $costs[ $index ] );\n\t\t\t}\n\t\t}\n\t\treturn ! empty( $costs );\n\t}\n}\n$cost_filter_alternative = new BSG__Cost__Tribe__Events__Filterbar__Filters__Cost('Price', 'price');\n<\/code><\/pre>\nThe key bit is here, where I’ve removed Tribe’s chunking code and hard-coded my own ranges:<\/p>\n
$cost_range = array();\n\t\tif ( $this->has_non_numeric_costs() ) {\n\t\t\t$cost_range['other'] = __( 'Other', 'tribe-events-filter-view' );\n\t\t}\n\n\t\tif ( $this->min_cost == 0 ) {\n\t\t\t$cost_range['0-0'] = __( 'Free', 'tribe-events-filter-view' );\n\t\t}\n\t\tif ( $this->max_cost == $this->min_cost ) {\n\t\t\tif ( $this->max_cost != 0 ) {\n\t\t\t\t$cost_range[ $this->min_cost . '-' . $this->max_cost ] = $this->min_cost . '-' . $this->max_cost;\n\t\t\t}\n\t\t} else { \/\/hard-coding my desired price ranges\n\n\t\t\t$cost_range['1-49'] = 'Inexpensive (\\$1 - \\$49)';\n\t\t\t$cost_range['50-249'] = 'Moderate (\\$50 - \\$249)';\n\t\t\t$cost_range['250-' . $this->max_cost] = 'Professional (\\$250+)';\n\t\t}\n\t\t$values = array();\n\t\tforeach ( $cost_range as $key => $cost ) {\n\t\t\t$values[] = array(\n\t\t\t\t'name' => $cost,\n\t\t\t\t'value' => $key,\n\t\t\t);\n\t\t}\n\t\treturn $values;\n<\/code><\/pre>\nNow, this works. I have the filter available within my settings, I’ve added it, and it filters correctly. The only thing that’s weird about it is the parameter that gets added to the URL has some extra percent-encoding in it: ?tribe_paged=1&tribe_event_display=list&tribe_price%5B%5D=1-49<\/strong> – not a big deal, but would be great if I could fix it.<\/p>\nWhat I’m really asking for is anyone with more development experience than me (I’m a non-CS-background, copy-and-paste backend developer) to tell me if I’m doing anything wrong with this implementation? I feel like I’m repeating a lot of code, most of which I don’t know what it does, and even though it seems to be working, stuff like the URL having unexplained extra characters in it makes me wonder if there are other unintended consequences I’m missing. Have I missed any steps anywhere? Is there a better way to do what I’m doing?<\/p>\n","protected":false},"template":"","class_list":["post-1164093","topic","type-topic","status-closed","hentry"],"yoast_head":"\n
Created an alternative cost filter, looking for second opinions. -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Created an alternative cost filter, looking for second opinions. -\" \/>\n<meta property=\"og:description\" content=\"Hey everyone, I’ve created a Boston tech events calendar, and the event prices ended up being a pretty large range. From meetups with $5 pizza costs to conferences with $5000+ registration fees. I wasn’t liking that my only options for the cost filter were a range slider that wasn’t really convenient for the distribution of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/\",\"name\":\"Created an alternative cost filter, looking for second opinions. -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-09-14T18:15:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Filter Bar\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/filter-bar\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Created an alternative cost filter, looking for second opinions.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Created an alternative cost filter, looking for second opinions. -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/","og_locale":"en_US","og_type":"article","og_title":"Created an alternative cost filter, looking for second opinions. -","og_description":"Hey everyone, I’ve created a Boston tech events calendar, and the event prices ended up being a pretty large range. From meetups with $5 pizza costs to conferences with $5000+ registration fees. I wasn’t liking that my only options for the cost filter were a range slider that wasn’t really convenient for the distribution of […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/","name":"Created an alternative cost filter, looking for second opinions. -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-09-14T18:15:03+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/created-an-alternative-cost-filter-looking-for-second-opinions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Filter Bar","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/filter-bar\/"},{"@type":"ListItem","position":5,"name":"Created an alternative cost filter, looking for second opinions."}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1164093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1164093\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1164093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}