Bp_Search_Posts

bp_search_posts扩展bp_search_type {private $ pt_name;私人$ search_type;/ ** *真正的构造函数。由于我们确实想要这个课程的多个副本。*该想法是为每个可搜索的自定义帖子类型具有一个对象。* * @since buddyboss 1.0.0 * / public function __construct（$ pt_name，$ search_type）{$ this-> pt_name = $ pt_name;$ this-> search_type = $ search_type;add_action（“bp_search_settings_item _ {$ this-> search_type}”，array（$ this，'print_search_options'））;}公共函数sql（$ search_term，$ tonly_totalrow_count = false）{/ *一个示例联盟查询： -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -------------------------（选择wp_posts.id，'post'作为类型，wp_posts.post_title等'％ho％'为相关性，wp_posts．post_date as entry_date FROM wp_posts WHERE 1=1 AND ( ( (wp_posts.post_title LIKE '%ho%') OR (wp_posts.post_content LIKE '%ho%') ) ) AND wp_posts.post_type IN ('post', 'page', 'attachment') AND ( wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private' ) ) ---------------------------------------------------- */ global $wpdb; $bp_prefix = bp_core_get_table_prefix(); $query_placeholder = array(); $sql = " SELECT "; if( $only_totalrow_count ){ $sql .= " COUNT( DISTINCT id ) "; } else { $sql .= " DISTINCT id , %s as type, post_title LIKE %s AS relevance, post_date as entry_date "; $query_placeholder[] = $this->search_type; $query_placeholder[] = '%'. $search_term .'%'; } $sql .= " FROM {$wpdb->posts} p "; /* ++++++++++++++++++++++++++++++++ * wp_posts table fields +++++++++++++++++++++++++++++++ */ $taxonomies = get_object_taxonomies( $this->pt_name ); foreach ( $taxonomies as $taxonomy ) { if ( bp_is_search_post_type_taxonomy_enable( $taxonomy, $this->pt_name ) ) { $tax[] = $taxonomy; } } //Tax query left join if ( ! empty( $tax ) ) { $sql .= " LEFT JOIN {$wpdb->term_relationships} r ON p.ID = r.object_id "; } //WHERE $sql .= " WHERE 1=1 AND ( p.post_title LIKE %s OR {$bp_prefix}bp_strip_tags(p.post_content) LIKE %s "; $query_placeholder[] = '%'. $search_term .'%'; $query_placeholder[] = '%'. $search_term .'%'; //Tax query if ( ! empty( $tax ) ) { $tax_in_arr = array_map( function( $t_name ) { return "'" . $t_name . "'"; }, $tax ); $tax_in = implode( ', ', $tax_in_arr ); $sql .= " OR r.term_taxonomy_id IN (SELECT tt.term_taxonomy_id FROM {$wpdb->term_taxonomy} tt INNER JOIN {$wpdb->terms} t ON t.term_id = tt.term_id WHERE ( t.slug LIKE %s OR t.name LIKE %s ) AND tt.taxonomy IN ({$tax_in}) )"; $query_placeholder[] = '%'. $search_term .'%'; $query_placeholder[] = '%'. $search_term .'%'; } //Meta query if ( bp_is_search_post_type_meta_enable($this->pt_name) ) { $sql .= " OR p.ID IN (SELECT post_id FROM {$wpdb->postmeta} WHERE {$bp_prefix}bp_strip_tags(meta_value) LIKE %s )"; $query_placeholder[] = '%'. $search_term .'%'; } //Post should be publish $sql .= ") AND p.post_type = '{$this->pt_name}' AND p.post_status = 'publish' "; $sql = $wpdb->prepare( $sql, $query_placeholder ); return apply_filters( 'Bp_Search_Posts_sql', $sql, array( 'search_term' => $search_term, 'only_totalrow_count' => $only_totalrow_count, ) ); } protected function generate_html( $template_type='' ){ $post_ids = array(); foreach( $this->search_results['items'] as $item_id=>$item_html ){ $post_ids[] = $item_id; } //now we have all the posts //lets do a wp_query and generate html for all posts $qry = new WP_Query( array( 'post_type' => $this->pt_name, 'post__in'=>$post_ids ) ); if( $qry->have_posts() ){ while( $qry->have_posts() ){ $qry->the_post(); $result = array( 'id' => get_the_ID(), 'type' => $this->search_type, 'title' => get_the_title(), 'html' => bp_search_buffer_template_part( 'loop/post', $template_type, false ), ); $this->search_results['items'][get_the_ID()] = $result; } } wp_reset_postdata(); } /** * What taxonomy should be searched on? * Should search on the Post Meta? * * Prints options to search through all registered taxonomies with give * post type e.g $this->cpt_name * * Print options to search through Post Meta */ function print_search_options( $items_to_search ){ global $wp_taxonomies; echo "
"; /** Post Meta Field **********************************/ $label = sprintf( __('%s Meta', 'buddyboss' ), ucfirst( $this->pt_name ) ); $item = 'post_field_' . $this->pt_name.'_meta'; $checked = ! empty( $items_to_search ) && in_array( $item, $items_to_search ) ? ' checked' : ''; echo "{$label}
"; /** Post Taxonomies Fields *********************************/ $pt_taxonomy = get_object_taxonomies( $this->pt_name ) ; foreach ( $pt_taxonomy as $tax ) { $label = ucwords( str_replace( '_', ' ', $tax ) ); $value = $this->search_type.'-tax-'.$tax; $checked = !empty( $items_to_search ) && in_array( $value, $items_to_search ) ? ' checked' : ''; echo "{$label}
"; } echo "
"; } }