Skip to content

Instantly share code, notes, and snippets.

@jchristopher
Last active April 22, 2021 20:28
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jchristopher/7fe0117f98318e71fcdcd9de116def62 to your computer and use it in GitHub Desktop.
Save jchristopher/7fe0117f98318e71fcdcd9de116def62 to your computer and use it in GitHub Desktop.
Give Products extraordinary weight boost to ensure Products show up first.
<?php
// Give Products extraordinary weight boost to ensure Products show up first.
// @link https://searchwp.com/documentation/knowledge-base/post-type-first-top/
add_filter( 'searchwp\query\mods', function( $mods ) {
$post_type = 'product'; // Post type name.
$source = \SearchWP\Utils::get_post_type_source_name( $post_type );
$mod = new \SearchWP\Mod( $source );
$mod->relevance( function( $runtime ) use ( $source ) {
global $wpdb;
return $wpdb->prepare(
"IF( {$runtime->get_foreign_alias()}.source = %s, '999999999999', '0' )",
$source
);
} );
$mods[] = $mod;
return $mods;
} );
@petertwise
Copy link

oh, cool - so this already is additive, not a replacement? So if you plugged in a smaller number there it would work the same, but just be less of a sledge hammer? If you wanted to nudge a CPT towards the top, but not force them there?

@jchristopher
Copy link
Author

Correct 👍

@petertwise
Copy link

petertwise commented Apr 16, 2021

Ok, I have this working great now with the code below. However, I'm getting this notice using debug mode. Is this expected because of an unusual use case of wpdb or is there some way I can fix it?

Notice: wpdb::prepare was called incorrectly. Unsupported value type (object). (This message was added in version 4.8.2.) in /wp-includes/functions.php on line 5313

// Give some post types extra weight boost to ensure they show up first.
// @link https://searchwp.com/documentation/knowledge-base/post-type-first-top/
// @link https://gist.github.com/jchristopher/7fe0117f98318e71fcdcd9de116def62
add_filter( 'searchwp\query\mods', 'redpoppy_searchwp_boosts' );
function redpoppy_searchwp_boosts( $mods ) {

	// how much to boost each post type
	$boosts = array(
		'works'      => 200,
		'recordings' => 50,
		'events'     => -50,
	);

	foreach ( $boosts as $post_type => $boost ) {

		$source = \SearchWP\Utils::get_post_type_source_name( $post_type );

		$mod = new \SearchWP\Mod( $source );
		$mod->relevance(
			function( $runtime ) use ( $source, $boost ) {
				global $wpdb;
				return $wpdb->prepare(
					"IF( {$runtime->get_foreign_alias()}.source = %s, %s, '0' )",
					array(
						$source,
						$boost,
					)
				);
			}
		);

		$mods[] = $mod;
	}
	return $mods;
}

@petertwise
Copy link

I found that sometimes $mods is not an array, so to avoid fatal errors, I had to implement this at the start of the function:

if ( ! is_array( $mods ) ) {
	$mods = array( $mods );
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment