Qpdb\QueryBuilder\Traits\SelectFields

Complexity

Total Complexity

13

Size/Duplication

Total Lines	98
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	fieldsByExpression()	0	6	1
A	prepareArrayFields()	0	19	4
A	fields()	0	32	5
A	getFieldByArray()	0	12	3

<?php
/**
 * Created by PhpStorm.
 * User: Adrian Dumitru
 * Date: 8/15/2017
 * Time: 12:15 PM
 */

namespace Qpdb\QueryBuilder\Traits;


use Qpdb\QueryBuilder\Dependencies\QueryException;
use Qpdb\QueryBuilder\Dependencies\QueryHelper;
use Qpdb\QueryBuilder\Dependencies\QueryStructure;

trait SelectFields
{
	use Objects;


	/**
	 * @param string|array $fields
	 * @return $this
	 * @throws QueryException
	 */
	public function fields( $fields )
	{

		switch ( gettype( $fields ) ) {
			case QueryStructure::ELEMENT_TYPE_ARRAY:

				$fields = $this->prepareArrayFields( $fields );

It seems like $fields can also be of type string; however, parameter $fieldsArray of Qpdb\QueryBuilder\Traits\SelectFields::prepareArrayFields() does only seem to accept array, maybe add an additional type check?

				if ( count( $fields ) )
					$this->queryStructure->setElement( QueryStructure::FIELDS, implode( ', ', $fields ) );
				else
					$this->queryStructure->setElement( QueryStructure::FIELDS, '*' );
				break;

			case QueryStructure::ELEMENT_TYPE_STRING:

				$fields = trim( $fields );

It seems like $fields can also be of type array; however, parameter $str of trim() does only seem to accept string, maybe add an additional type check?

				if ( '' !== $fields ) {
					$fields = explode( ',', $fields );
					$fields = $this->prepareArrayFields( $fields );
					$this->queryStructure->setElement( QueryStructure::FIELDS, implode( ', ', $fields ) );
				}
				else
					$this->queryStructure->setElement( QueryStructure::FIELDS, '*' );
				break;

			default:
				throw new QueryException( 'Invalid fields parameter type', QueryException::QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY );

		}

		return $this;
	}

	public function fieldsByExpression( $expression )
	{
		$expression = trim( $expression );
		$this->queryStructure->setElement( QueryStructure::FIELDS, $expression );

		return $this;
	}



	/**
	 * @param array $fieldsArray
	 * @return array
	 * @throws QueryException
	 */
	private function prepareArrayFields( $fieldsArray = array() )
	{
		$prepareArray = [];

		foreach ( $fieldsArray as $field ) {

			switch ( gettype( $field ) ) {
				case QueryStructure::ELEMENT_TYPE_STRING:
					$prepareArray[] = $this->queryStructure->prepare( $field );
					break;
				case QueryStructure::ELEMENT_TYPE_ARRAY:
					$prepareArray[] = $this->getFieldByArray( $field );
					break;
				default:
					throw new QueryException('Invalid field description');
			}
		}

		return $prepareArray;
	}


	/**
	 * @param array $fieldArray
	 * @return string
	 * @throws QueryException
	 */
	private function getFieldByArray( array $fieldArray )
	{

		if ( !in_array( count( $fieldArray ), [ 1, 2 ] ) ) {
			throw new QueryException( 'Invalid descriptive array from field.' );
		}

		if ( count( $fieldArray ) === 1 ) {
			return $this->queryStructure->prepare( trim( $fieldArray[ 0 ] ) );
		}
		else {
			return $this->queryStructure->prepare( trim( $fieldArray[ 0 ] ) ) . ' ' . $this->queryStructure->prepare( trim( $fieldArray[ 1 ] ) );
		}

	}

}