WP_Query clausola OR per tax_query e parole chiave
-
-
[modifica] latua domandae condividi ciò che haigiàfatto.Nessuno desidererà disegnare sultuofoglio di cartabianco,ma deviiniziare.[edit] your Question and share what you've already done. Nobody will eager to draw on your blank sheet of paper, but you have to initiate.
- 0
- 2014-12-31
- Mayeenul Islam
-
@ MayeenulIslam Lamia domanda è abbastanza chiara;ottenerei post che corrispondono al criterio "tax_query" o "s".@MayeenulIslam My question is quite clear; get posts that match either the `tax_query` or the `s` criterion.
- 0
- 2014-12-31
- tyteen4a03
-
1 risposta
- voti
-
- 2015-01-07
Ecco unpiccoloesperimento:
Puoiprovare la seguente configurazione:
$args = array( 'wpse_search_or_tax_query' => true, // <-- New parameter! 's' => 'some search text', 'tax_query' => array( array( 'taxonomy' => 'category', 'field' => 'slug', 'terms' => array( 'some-category-slug' ), 'operator' => 'IN', ), ), ); $query = new WP_Query( $args );
doveintroduciamoilparametropersonalizzato
wpse_search_or_tax_query
per attivare lemodifiche della query.Questo è supportato dal seguenteplug-in demo:
<?php /** * Plugin Name: Modify the WP_Query to use OR between the search and tax query parts. * Description: Activation through the boolean 'wpse_search_or_tax_query' parameter. * Plugin URI: http://wordpress.stackexchange.com/a/174221/26350 * Author: Birgir Erlendsson (birgire) * Version: 0.0.2 */ add_action( 'init', function() { if( ! is_admin() && class_exists( 'WPSE_Modify_Query' ) ) { $o = new WPSE_Modify_Query; $o->activate(); } }); class WPSE_Modify_Query { private $search = ''; public function activate() { add_action( 'pre_get_posts', array( $this, 'pre_get_posts' ) ); } public function pre_get_posts( WP_Query $q ) { if( filter_var( $q->get( 'wpse_search_or_tax_query' ), FILTER_VALIDATE_BOOLEAN ) && $q->get( 'tax_query' ) && $q->get( 's' ) ) { add_filter( 'posts_clauses', array( $this, 'posts_clauses' ), 10, 2 ); add_filter( 'posts_search', array( $this, 'posts_search' ), 10, 2 ); } } public function posts_clauses( $clauses, \WP_Query $q ) { remove_filter( current_filter(), array( $this, __FUNCTION__ ) ); // Generate the tax query: $tq = new WP_Tax_Query( $q->query_vars['tax_query'] ); // Get the generated taxonomy clauses: global $wpdb; $tc = $tq->get_sql( $wpdb->posts, 'ID' ); // Remove the search part: $clauses['where'] = str_ireplace( $this->search, ' ', $clauses['where'] ); // Remove the taxonomy part: $clauses['where'] = str_ireplace( $tc['where'], ' ', $clauses['where'] ); // Add the search OR taxonomy part: $clauses['where'] .= sprintf( " AND ( ( 1=1 %s ) OR ( 1=1 %s ) ) ", $tc['where'], $this->search ); return $clauses; } public function posts_search( $search, \WP_Query $q ) { remove_filter( current_filter(), array( $this, __FUNCTION__ ) ); $this->search = $search; return $search; } } // end class
Si spera chetupossa adattarlo ulteriormente alletueesigenze.
Here's a little experiment:
You can try the following setup:
$args = array( 'wpse_search_or_tax_query' => true, // <-- New parameter! 's' => 'some search text', 'tax_query' => array( array( 'taxonomy' => 'category', 'field' => 'slug', 'terms' => array( 'some-category-slug' ), 'operator' => 'IN', ), ), ); $query = new WP_Query( $args );
where we introduce the custom
wpse_search_or_tax_query
parameter to activate the query modifications.This is supported by the following demo plugin:
<?php /** * Plugin Name: Modify the WP_Query to use OR between the search and tax query parts. * Description: Activation through the boolean 'wpse_search_or_tax_query' parameter. * Plugin URI: http://wordpress.stackexchange.com/a/174221/26350 * Author: Birgir Erlendsson (birgire) * Version: 0.0.2 */ add_action( 'init', function() { if( ! is_admin() && class_exists( 'WPSE_Modify_Query' ) ) { $o = new WPSE_Modify_Query; $o->activate(); } }); class WPSE_Modify_Query { private $search = ''; public function activate() { add_action( 'pre_get_posts', array( $this, 'pre_get_posts' ) ); } public function pre_get_posts( WP_Query $q ) { if( filter_var( $q->get( 'wpse_search_or_tax_query' ), FILTER_VALIDATE_BOOLEAN ) && $q->get( 'tax_query' ) && $q->get( 's' ) ) { add_filter( 'posts_clauses', array( $this, 'posts_clauses' ), 10, 2 ); add_filter( 'posts_search', array( $this, 'posts_search' ), 10, 2 ); } } public function posts_clauses( $clauses, \WP_Query $q ) { remove_filter( current_filter(), array( $this, __FUNCTION__ ) ); // Generate the tax query: $tq = new WP_Tax_Query( $q->query_vars['tax_query'] ); // Get the generated taxonomy clauses: global $wpdb; $tc = $tq->get_sql( $wpdb->posts, 'ID' ); // Remove the search part: $clauses['where'] = str_ireplace( $this->search, ' ', $clauses['where'] ); // Remove the taxonomy part: $clauses['where'] = str_ireplace( $tc['where'], ' ', $clauses['where'] ); // Add the search OR taxonomy part: $clauses['where'] .= sprintf( " AND ( ( 1=1 %s ) OR ( 1=1 %s ) ) ", $tc['where'], $this->search ); return $clauses; } public function posts_search( $search, \WP_Query $q ) { remove_filter( current_filter(), array( $this, __FUNCTION__ ) ); $this->search = $search; return $search; } } // end class
Hopefully you can adjust this further to your needs.
-
Hofinitoper scrivereilmiogeneratore di query,ma spero che questopossa aiutare qualcun altro.I ended up writing my own query builder but hopefully this'll help somebody else.
- 1
- 2015-01-08
- tyteen4a03
-
Ciao,l'haitestato?sembranonfunzionare,lancia la riga dierrore 78 `Erroreirreversibile catchable: l'argomento 2passato a WPSE_Modify_Query ::posts_search () deveessere un'istanza di WP_Query`.Quindi ho rimossoi parametri,ma ancoranonfa la cosa OR ...Hello, did you test it ? it seems not to be working, throw error line 78 `Catchable fatal error: Argument 2 passed to WPSE_Modify_Query::posts_search() must be an instance of WP_Query`. So I removed the params, but it still does not make the OR thing...
- 0
- 2015-10-02
- Vincent Wasteels
-
grazie @VincentWasteels,ho aggiornatoil codice quindi spero che orafunzioni comeprevisto ;-)thanks @VincentWasteels, I updated the code so hopefully it works now as expected ;-)
- 0
- 2015-10-02
- birgire
-
okmale,lo stavo usando con `get_posts`invece di` WP_Query () `.Sonomolto sorpreso cheil comportamento sia unpensiero diverso ...ok my bad, I was using it with `get_posts`instead of `WP_Query()`. I'm very surprised the behaviour is different thought...
- 0
- 2015-10-02
- Vincent Wasteels
-
nonoiltuo codiceerafinalmente ok :)no no your code was ok finally :)
- 0
- 2015-10-02
- Vincent Wasteels
-
felice di sentire che hafunzionatoperte ;-) @VincentWasteelsglad to hear it worked out for you ;-) @VincentWasteels
- 0
- 2015-10-02
- birgire
Èpossibile creare una clausola ORtra
tax_query
e leparole chiave?Vorrei cheWP_Query
restituissei post se c'è una corrispondenza ditax_query
o una corrispondenza diparola chiaves
.