simettric/wp-query-builder

A query builder for WordPress WP_Query, inspired by Doctrine Query Builder

WPQueryBuilder

A query builder for WordPress WP_Query, inspired by the Doctrine Query Builder, _(*1)

, _(*2)

, _(*3)

INSTALLATION

composer require simettric/wp-query-builder

USAGE

META QUERIES

Retrieve any post type where post meta color value equals to blue OR size meta value equals to XL, _(*4)

       $builder = new Builder();
       $wp_query = $builder->createMainMetaQuery("OR")
                            ->addMetaQuery(MetaQuery::create('color', 'blue'))
                            ->addMetaQuery(MetaQuery::create('size', 'XL'))
                            ->getWPQuery();

Retrieve any post type where post meta price is equal or greater than 10 OR size meta value equals to XL, _(*5)

       $builder = new Builder();
       $wp_query = $builder->createMainMetaQuery("AND")
                            ->addMetaQuery(MetaQuery::create('price', 10, '>=', 'NUMERIC'))
                            ->addMetaQuery(MetaQuery::create('size', 'XL'))
                            ->getWPQuery();  

Retrieve any post type where post meta price is equal or greater than 10 AND (size meta value equals to XL OR post meta color value equals to blue), _(*6)

       $builder = new Builder();
       $builder->createMainMetaQuery("AND")
               ->addMetaQuery(MetaQuery::create('price', 10, '>=', 'NUMERIC'));

       $condition = new MetaQueryCollection('OR');
       $condition->add(MetaQuery::create('color', 'blue'))
                 ->add(MetaQuery::create('size', 'XL'));


       $wp_query = $builder->addMetaQueryCollection($condition)
                           ->getWPQuery();  

TAXONOMY QUERIES

Retrieve the contents under ("pets" OR "tools") values in the "category" taxonomy AND in under 'sweet' in "custom" taxonomy, _(*7)

       $builder = new Builder();
       $wp_query = $builder->createMainTaxonomyQuery("AND")
                            ->addTaxonomyQuery(TaxonomyQuery::create('category', 'slug', array('pets', 'tools')))
                            ->addTaxonomyQuery(TaxonomyQuery::create('custom', 'slug', array('sweet))
                            ->getWPQuery();

Retrieve the contents under ("pets" OR "tools") values in the "category" taxonomy BUT exclude contents in their children, _(*8)

       $builder = new Builder();
       $wp_query = $builder->createMainTaxonomyQuery("AND")
                            ->addTaxonomyQuery(TaxonomyQuery::create('category', 'slug', array('pets', 'tools'), false))
                            ->getWPQuery();

Retrieve the contents those are NOT under ("pets" OR "tools") values in the "category" taxonomy, _(*9)

       $builder = new Builder();
       $wp_query = $builder->createMainTaxonomyQuery("AND")
                            ->addTaxonomyQuery(TaxonomyQuery::create('category', 'slug', array('pets', 'tools'), true, 'NOT IN'))
                            ->getWPQuery();

You can have nested relations too, _(*10)

      $builder = new Builder();

      $collection = new TaxonomyQueryCollection('OR');
      $collection->add(TaxonomyQuery::create('tag', 'slug', array('cats')));
      $collection->add(TaxonomyQuery::create('custom', 'slug', array('sweet')));

      $wp_query = $builder->createMainTaxonomyQuery("AND")
                           ->addTaxonomyQuery(TaxonomyQuery::create('category', 'slug', array('pets', 'tools')))
                           ->addTaxonomyQueryCollection($collection)
                           ->getWPQuery();     

POST TYPES

Retrieve all PAGES, _(*11)

       $builder = new Builder();
       $wp_query = $builder->addPostType(Builder::POST_TYPE_PAGE)->getWPQuery();

Retrieve all CUSTOM POST TYPE, _(*12)

       $builder = new Builder();
       $wp_query = $builder->addPostType('your_custom')->getWPQuery();

Retrieve all CUSTOM POST TYPE and PAGES, _(*13)

       $builder = new Builder();
       $wp_query = $builder->addPostType('your_custom')
                           ->addPostType(Builder::POST_TYPE_PAGE)
                           ->getWPQuery();

SEARCH

Search contents, _(*14)

        $builder = new Builder();

        $wp_query = $builder->search("search query")->getWPQuery();

IN and NOT IN

Retrieve contents with ID in array of IDS, _(*15)

        $builder = new Builder();

        $wp_query = $builder->inPostIDs(array(1,2,3))->getWPQuery();

Retrieve contents with ID not in array of IDS, _(*16)

        $builder = new Builder();

        $wp_query = $builder->notInPostIDs(array(1,2,3))->getWPQuery();

ORDERBY

Order contents by title descending, _(*17)

        $builder = new Builder();

        $wp_query = $builder->setOrderBy("title")->getWPQuery();

Order contents by date, ascending, _(*18)

        $builder = new Builder();

        $wp_query = $builder->setOrderBy("date")
                            ->setOrderDirection("ASC")
                            ->getWPQuery();

Order contents by title descending and date, ascending, _(*19)

        $builder = new Builder();

        $wp_query = $builder->addOrderBy("title", "DESC")
                            ->addOrderBy("date", "ASC")
                            ->getWPQuery();

Order contents by custom meta, _(*20)

        $builder = new Builder();

        $wp_query = $builder->setOrderByMeta("color", "DESC")->getWPQuery();

Order contents by custom numeric meta, _(*21)

        $builder = new Builder();

        $wp_query = $builder->setOrderByMeta("price", "ASC", true)
                            ->getWPQuery();

LIMITS AND OFFSETS

Retrieve only 10 contents, _(*22)

        $builder = new Builder();

        $wp_query = $builder->setLimit(10)->getWPQuery();

Retrieve 20 contents starting from the 10th position, _(*23)

        $builder = new Builder();

        $wp_query = $builder->setLimit(20)->setOffset(10)->getWPQuery();

RETRIEVING

Get the WPQuery object, _(*24)

        $builder = new Builder();

        $wp_query = $builder->getWPQuery();

Get the Posts array, _(*25)

        $builder = new Builder();

        $posts = $builder->getPosts();

Get the WPQuery parameters array, _(*26)

        $builder = new Builder();

        $params = $builder->getParameters();

        $query = new WP_Query($params);

Get an array containing only the post IDs. This is useful when you want to return all records without pagination from a large recordset in order to avoid memory issues., _(*27)

        $builder = new Builder();

        $ids = $builder->getPostIDsOnly();

        $builder = new Builder();

        $wp_query = $builder->inPostIDs($ids)->getWPQuery();