Undefined\Stash\ACF\ACF::advanced_custom_search()

Complexity

Conditions	7
Paths	9

Size

Total Lines	68
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function advanced_custom_search($where, &$wp_query)
    {
        global $wpdb;

        if (empty($where)) {
            return $where;
        }

        // get search expression
        $terms = $wp_query->query_vars['s'];

        // explode search expression to get search terms
        $exploded = explode(' ', $terms);

        if ($exploded === false || count($exploded) == 0) {
            $exploded = array(0 => $terms);
        }

        // reset search in order to rebuilt it as we whish
        $where = '';

        // get searcheable_acf, a list of advanced custom fields you want to search content in
        $list_searcheable_acf = $this->list_searcheable_acf;

        foreach ($exploded as $tag) {
            $where .= "
          AND (
            (wp_posts.post_title LIKE '%$tag%')
            OR (wp_posts.post_content LIKE '%$tag%')
            OR EXISTS (
              SELECT * FROM wp_postmeta
	              WHERE post_id = wp_posts.ID
	                AND (";

            foreach ($list_searcheable_acf as $searcheable_acf) {
                if ($searcheable_acf == $list_searcheable_acf[0]) {
                    $where .= " (meta_key LIKE '%" . $searcheable_acf . "%' AND meta_value LIKE '%$tag%') ";
                } else {
                    $where .= " OR (meta_key LIKE '%" . $searcheable_acf . "%' AND meta_value LIKE '%$tag%') ";
                }

                $where .= ")
            )
            OR EXISTS (
              SELECT * FROM wp_comments
              WHERE comment_post_ID = wp_posts.ID
                AND comment_content LIKE '%$tag%'
            )
            OR EXISTS (
              SELECT * FROM wp_terms
              INNER JOIN wp_term_taxonomy
                ON wp_term_taxonomy.term_id = wp_terms.term_id
              INNER JOIN wp_term_relationships
                ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
              WHERE (
          		taxonomy = 'post_tag'
            		OR taxonomy = 'category'
            		OR taxonomy = 'myCustomTax'
          		)
              	AND object_id = wp_posts.ID
              	AND wp_terms.name LIKE '%$tag%'
            )
        )";
            }

            return $where;
        }
    }
}
});