maksimru / eloquent-subquery-magic

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addLeftJoinSubquery($builder)

    {

        $builder->macro('leftJoinSubquery', function ($builder, $subquery, $alias, \Closure $on) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->leftJoin(DB::raw('('.$subquery->toSql().') '.$builder->getQuery()->getGrammar()->wrap($alias)), $on);

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'join');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addRightJoinSubquery($builder)

    {

        $builder->macro('rightJoinSubquery', function ($builder, $subquery, $alias, \Closure $on) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->rightJoin(DB::raw('('.$subquery->toSql().') '.$builder->getQuery()->getGrammar()->wrap($alias)), $on);

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'join');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addJoinSubquery($builder)

    {

        $builder->macro('joinSubquery', function ($builder, $subquery, $alias, \Closure $on) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->join(DB::raw('('.$subquery->toSql().') '.$builder->getQuery()->getGrammar()->wrap($alias)), $on);

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'join');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addWhereInSubquery($builder)

    {

        $builder->macro('whereInSubquery', function ($builder, $field, $subquery) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->whereRaw($builder->getQuery()->getGrammar()->wrap($field).' IN ('.$subquery->toSql().')');

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'where');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addWhereNotInSubquery($builder)

    {

        $builder->macro('whereNotInSubquery', function ($builder, $field, $subquery) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->whereRaw($builder->getQuery()->getGrammar()->wrap($field).' NOT IN ('.$subquery->toSql().')');

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'where');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addOrWhereInSubquery($builder)

    {

        $builder->macro('orWhereInSubquery', function ($builder, $field, $subquery) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->orWhereRaw($builder->getQuery()->getGrammar()->wrap($field).' IN ('.$subquery->toSql().')');

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'where');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addOrWhereNotInSubquery($builder)

    {

        $builder->macro('orWhereNotInSubquery', function ($builder, $field, $subquery) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->orWhereRaw($builder->getQuery()->getGrammar()->wrap($field).' NOT IN ('.$subquery->toSql().')');

            //merge bindings from subquery

            $this->addBindings($builder, $subquery->getBindings(), 'where');

            return $builder;

        });

    }

    /**

     * Add extension to the builder.

     *

     * @param \Illuminate\Database\Eloquent\Builder|Relation $builder

     */

    protected function addFromSubquery($builder)

    {

        $builder->macro('fromSubquery', function ($builder, $subquery, $alias) {

            /*

             * @var $builder \Illuminate\Database\Eloquent\Builder|Relation

             * @var $subquery \Illuminate\Database\Eloquent\Builder|Relation

             */

            $builder->from(DB::raw('('.$subquery->toSql().') '.$builder->getQuery()->getGrammar()->wrap($alias)));

            //merge bindings from subquery

            $builder->setBindings(array_merge($subquery->getBindings(), $builder->getBindings()));

            return $builder;

        });

    }

}