SelectQueryBuilder.php

<?php


namespace calderawp\CalderaFormsQuery\Select;

use calderawp\CalderaFormsQuery\DoesQueries;
use calderawp\CalderaFormsQuery\MySqlBuilder;
use NilPortugues\Sql\QueryBuilder\Manipulation\Select;

abstract class SelectQueryBuilder implements DoesQueries, DoesSelectQuery
{
	const ASC = 'ASC';
	const DESC = 'DESC';

	/**
	 * @var MySqlBuilder
	 */
	private $builder;

	/**
	 * @var Select
	 */
	private $query;

	/**
	 * @var bool
	 */
	protected $isLike = false;

	/**
	 * @var string
	 */
	private $tableName;


	/**
	 * SelectQueryBuilder constructor.
	 * @param MySqlBuilder $builder Query builder
	 * @param string $tableName Name of table
	 */
	public function __construct(MySqlBuilder $builder, $tableName)
	{
		$this->builder = $builder;
		$this->tableName = $tableName;
	}

	/** @inheritdoc */
	public function getTableName()
	{
		return $this->tableName;
	}

	/** @inheritdoc */
	public function getBuilder()
	{
		return $this->builder;
	}


	/** @inheritdoc */
	public function getSelectQuery()
	{

		if (empty($this->query)) {
			$this->query = new \NilPortugues\Sql\QueryBuilder\Manipulation\Select($this->getTableName());
		}
		return $this->query;
	}

	/** @inheritdoc */
	public function getPreparedSql()
	{
		return $this->substituteValues($this->getBuilder()->write($this->getSelectQuery()));
	}

	/**
	 * @param string $column Column to orderby.
	 * @param bool $ascending Optional. To use ascending order? If false, descending is used. True is the default.
	 * @return $this
	 */
	public function addOrderBy($column, $ascending = true)
	{
		$order = $ascending ? self::ASC : self::DESC;
		$this->getSelectQuery()->orderBy($column, $order);
		return $this;
	}

	/**
	 * Generate query for where column is value
	 *
	 * @param string $column
	 * @param string $value
	 * @return $this
	 */
	protected function is($column, $value)
	{
		$this->getSelectQuery()
			->where()
			->equals($column, $value);
		return $this;
	}


	/**
	 * Replace all substitutions with actual values
	 *
	 * @param string $sql SQL query with substitutions
	 * @return string
	 */
	protected function substituteValues($sql)
	{
		$values = $this->builder->getValues();
		foreach ($values as $identifier => $value) {
			$values[$identifier] = $this->surroundValue($value);
		}
		return str_replace(array_keys($values), array_values($values), $sql);
	}

	/**
	 * @return string
	 */
	protected function getDeliminator()
	{
		return $this->isLike ? '%' : "'";
	}

	/**
	 * Surround one value with quotes or %
	 *
	 * @param string $value Value to surround
	 * @return string
	 */
	protected function surroundValue($value)
	{
		return "{$this->getDeliminator()}$value{$this->getDeliminator()}";
	}
}