{

private $limit = null;

private $selects = null;

private $groupby = null;

private $havings = null;

private $indices = null;

private $distinct = false;

/**

public function __construct($tables)

{

parent::__construct($tables);

$this->setSelect(array(new AllFields()));

}

/**

public function setSelect($_selects, $distinct = false)

{

if (!is_array($_selects)) {

$_selects = array($_selects);

}

if (count($_selects) == 0) {

throw new InvalidArgumentException('Nothing to select');

}

if (!is_bool($distinct)) {

throw new InvalidArgumentException('"distinct" parameter should be boolean');

}

foreach ($_selects as $s) {

if (!($s instanceof MQB_Field) and !($s instanceof AllFields))

throw new RangeException('Allowed values are objects of the following classes: Field, AllFields, sqlFunction and Aggregate');

}

$this->selects = $_selects;

$this->distinct = $distinct;

$this->reset();

}

/**

public function setIndices($indices)

{

if (!is_array($indices)) {

$indices = array($indices);

}

$this->indices = $indices;

}

/**

public function setGroupby($orderlist)

{

if (!is_array($orderlist))

$orderlist = array($orderlist);

foreach ($orderlist as $field)

if (!($field instanceof MQB_Field))

throw new InvalidArgumentException('setGroupBy takes only [array of] MQB_Fields as parameter');

$this->groupby = $orderlist;

$this->reset();

}

/**

public function setLimit($limit, $offset=0)

{

if (!is_numeric($limit) or !is_numeric($offset))

throw new InvalidArgumentException('Limit should be specified using numerics');

$this->limit = array($limit, $offset);

}

/**

public function showGroupBy()

{

return $this->groupby;

}

protected function getSql(array &$parameters)

{

return $this->getSelect($parameters).

$this->getFrom($parameters).

// $this->getIndices().

$this->getWhere($parameters).

$this->getGroupby($parameters).

$this->getHaving($parameters).

$this->getOrderby($parameters).

$this->getLimit($parameters);

}

/**

protected function getLimit(array &$parameters)

{

if (null === $this->limit)

return "";

return " LIMIT ".$this->limit[0].' OFFSET '.$this->limit[1];

}

/**

public function countSelects()

{

return count($this->selects);

}

private function getSelect(&$parameters)

{

$res = 'SELECT ';

if (true === $this->distinct) {

$res .= 'DISTINCT ';

}

$sqls = array();

foreach ($this->selects as $s) {

$sqls[] = $s->getSql($parameters, true);

}

return $res.implode(", ", $sqls);

}

protected function getFrom(array &$parameters)

{

$froms = array();

for ($i = 0; $i < count($this->from); $i++) {

$_str = $this->from[$i]->__toString().' AS `t'.$i.'`';

if (0 == $i)

$_str .= $this->getIndices();

$froms[] = $_str;

}

$sql = ' FROM '.implode(", ", $froms);

return $sql;

}

private function getGroupby(&$parameters)

{

if ($this->groupby === null)

return "";

foreach ($this->groupby as $groupby) {

if (null !== $alias = $groupby->getAlias())

$sqls[] = $alias;

else

$sqls[] = $groupby->getSql($parameters);

}

return " GROUP BY ".implode(", ", $sqls);

}

/**

public function setHaving(MQB_Condition $conditions = null)

{

if (null === $conditions) {

$this->havings = null;

} elseif ($conditions instanceof MQB_Condition) {

$this->havings = clone $conditions;

}

$this->reset();

}

protected function getHaving(&$parameters)

{

if (null == $this->havings)

return "";

return " HAVING ".$this->havings->getSql($parameters);

}

protected function getIndices()

{

if (null === $this->indices)

return '';

$res = ' USE INDEX (';

$first = true;

foreach ($this->indices as $idx) {

if (true === $first)

$first = false;

else

$res .= ', ';

$res .= '`'.$idx.'`';

}

$res .= ')';

return $res;

}