Qpdb\QueryBuilder\Traits\Where

Complexity

Total Complexity

32

Size/Duplication

Total Lines	348
Duplicated Lines	0 %

Importance

Changes	4
Bugs	1	Features	0

32 Methods

Rating	Name	Duplication	Size	Complexity
A	orWhereGreaterThan()	0	3	1
A	orWhereIn()	0	3	1
A	orWhereNotIn()	0	3	1
A	orWhereLike()	0	3	1
A	whereNotLike()	0	3	1
A	whereNotIn()	0	3	1
A	orWhereLessThanOrEqual()	0	3	1
A	whereBetween()	0	3	1
A	whereIn()	0	3	1
A	whereEqual()	0	3	1
A	whereGreaterThan()	0	3	1
A	whereLike()	0	3	1
A	orWhereBetween()	0	3	1
A	orWhereNotBetween()	0	3	1
A	whereLessThan()	0	3	1
A	whereGreaterThanOrEqual()	0	3	1
A	orWhereEqual()	0	3	1
A	whereNotBetween()	0	3	1
A	whereNotEqual()	0	3	1
A	orWhereNotEqual()	0	3	1
A	whereLessThanOrEqual()	0	3	1
A	orWhereGreaterThanOrEqual()	0	3	1
A	orWhereExpression()	0	5	1
A	orWhereLessThan()	0	3	1
A	orWhereNotLike()	0	3	1
A	orWhereGroup()	0	3	1
A	whereInvertResult()	0	5	1
A	whereGroup()	0	5	1
A	whereGroupEnd()	0	5	1
A	where()	0	4	1
A	ignoreWhereTrigger()	0	5	1
A	whereExpression()	0	5	1

<?php
/**
 * Created by PhpStorm.
 * Author: Adrian Dumitru
 * Date: 4/25/2017 1:13 AM
 */

namespace Qpdb\QueryBuilder\Traits;


use Qpdb\QueryBuilder\Dependencies\QueryStructure;

/**
 * Trait Where
 * @package Qpdb\QueryBuilder\Traits
 * @property QueryStructure $queryStructure
 */
trait Where
{

	/**
	 * @param $field
	 * @param $value
	 * @param $glue
	 * @return $this
	 */
	public function whereEqual( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, '=' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereEqual( $field, $value )
	{
		return $this->where( array( $field, $value, '=' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereNotEqual( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, '<>' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereNotEqual( $field, $value )
	{
		return $this->where( array( $field, $value, '<>' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereLessThan( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, '<' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereLessThan( $field, $value )
	{
		return $this->where( array( $field, $value, '<' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereLessThanOrEqual( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, '<=' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereLessThanOrEqual( $field, $value )
	{
		return $this->where( array( $field, $value, '<=' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereGreaterThan( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, '>' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereGreaterThan( $field, $value )
	{
		return $this->where( array( $field, $value, '>' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereGreaterThanOrEqual( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, '>=' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereGreaterThanOrEqual( $field, $value )
	{
		return $this->where( array( $field, $value, '>=' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereLike( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, 'LIKE' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereLike( $field, $value )
	{
		return $this->where( array( $field, $value, 'LIKE' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereNotLike( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, 'NOT LIKE' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereNotLike( $field, $value )
	{
		return $this->where( array( $field, $value, 'NOT LIKE' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $min
	 * @param $max
	 * @param string $glue
	 * @return $this
	 */
	public function whereBetween( $field, $min, $max, $glue = 'AND' )
	{
		return $this->where( array( $field, array( $min, $max ), 'BETWEEN' ), $glue );
	}

	/**
	 * @param $field
	 * @param $min
	 * @param $max
	 * @return $this
	 */
	public function orWhereBetween( $field, $min, $max )
	{
		return $this->where( array( $field, array( $min, $max ), 'BETWEEN' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $min
	 * @param $max
	 * @param string $glue
	 * @return $this
	 */
	public function whereNotBetween( $field, $min, $max, $glue = 'AND' )
	{
		return $this->where( array( $field, array( $min, $max ), 'NOT BETWEEN' ), $glue );
	}

	/**
	 * @param $field
	 * @param $min
	 * @param $max
	 * @return $this
	 */
	public function orWhereNotBetween( $field, $min, $max )
	{
		return $this->where( array( $field, array( $min, $max ), 'NOT BETWEEN' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereIn( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, 'IN' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereIn( $field, $value )
	{
		return $this->where( array( $field, $value, 'IN' ), 'OR' );
	}

	/**
	 * @param $field
	 * @param $value
	 * @param string $glue
	 * @return $this
	 */
	public function whereNotIn( $field, $value, $glue = 'AND' )
	{
		return $this->where( array( $field, $value, 'NOT IN' ), $glue );
	}

	/**
	 * @param $field
	 * @param $value
	 * @return $this
	 */
	public function orWhereNotIn( $field, $value )
	{
		return $this->where( array( $field, $value, 'NOT IN' ), 'OR' );
	}

	/**
	 * @param $whereString
	 * @param array $bindParams
	 * @param string $glue
	 * @return $this
	 */
	public function whereExpression( $whereString, array $bindParams = [], $glue = 'AND' )
	{
		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );

		return $this->where( $whereString, $glue );
	}

	/**
	 * @param $whereString
	 * @param array $bindParams
	 * @return $this
	 */
	public function orWhereExpression( $whereString, array $bindParams = [] )
	{
		$whereString = $this->queryStructure->bindParamsExpression( $whereString, $bindParams );

		return $this->where( $whereString, 'OR' );
	}

	/**
	 * @return $this
	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
	 */
	public function whereInvertResult()
	{
		$this->queryStructure->setElement( QueryStructure::WHERE_INVERT, 1 );

		return $this;
	}

	/**
	 * @param string $glue
	 * @return $this
	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
	 */
	public function whereGroup( $glue = 'AND' )
	{
		$this->queryStructure->setElement( QueryStructure::WHERE, array( 'glue' => $glue, 'body' => '(', 'type' => 'start_where_group' ) );

		return $this;
	}

	/**
	 * @return $this
	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
	 */
	public function orWhereGroup()
	{
		return $this->whereGroup( 'OR' );
	}

	/**
	 * @return $this
	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
	 */
	public function whereGroupEnd()
	{
		$this->queryStructure->setElement( QueryStructure::WHERE, array( 'glue' => '', 'body' => ')', 'type' => 'end_where_group' ) );

		return $this;
	}

	/**
	 * @return $this
	 * @throws \Qpdb\QueryBuilder\Dependencies\QueryException
	 */
	public function ignoreWhereTrigger()
	{
		$this->queryStructure->setElement( QueryStructure::WHERE_TRIGGER, 0 );

		return $this;
	}


	/**
	 * @param string|array $param
	 * @param string $glue
	 * @return $this
	 */
	private function where( $param, $glue = 'AND' )
	{
		return $this->/** @scrutinizer ignore-call */
		createCondition( $param, $glue, QueryStructure::WHERE );
	}

}