/**
* @param string $table
* @return int
*/
public function count($table = '')
{
$sql = sprintf('SELECT COUNT(*) FROM %s', $table !== '' ? $this->db->quoteIdentifier($table) : $this->from);
if ($this->where !== '') {
$sql .= ' WHERE ' . $this->where;
}
if ($this->groupBy !== '') {
$sql .= ' GROUP BY ' . $this->groupBy;
}
if ($this->having !== '') {
$sql .= ' HAVING ' . $this->having;
}
if ($this->orderBy !== '') {
$sql .= ' ORDER BY ' . $this->orderBy;
}
$sql .= ';';
$this->reset();
return $sql;
}
