|
@@ 316-321 (lines=6) @@
|
| 313 |
|
$sql .= NodeFactory::toSql($this->columns, $dbConnection, $parameters, ',', false, $indent + 2, $conditionsMode); |
| 314 |
|
} |
| 315 |
|
|
| 316 |
|
if (!empty($this->from)) { |
| 317 |
|
$from = NodeFactory::toSql($this->from, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
| 318 |
|
if ($from) { |
| 319 |
|
$sql .= "\nFROM ".$from; |
| 320 |
|
} |
| 321 |
|
} |
| 322 |
|
|
| 323 |
|
if (!empty($this->where)) { |
| 324 |
|
$where = NodeFactory::toSql($this->where, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
|
@@ 323-328 (lines=6) @@
|
| 320 |
|
} |
| 321 |
|
} |
| 322 |
|
|
| 323 |
|
if (!empty($this->where)) { |
| 324 |
|
$where = NodeFactory::toSql($this->where, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
| 325 |
|
if ($where) { |
| 326 |
|
$sql .= "\nWHERE ".$where; |
| 327 |
|
} |
| 328 |
|
} |
| 329 |
|
|
| 330 |
|
if (!empty($this->group)) { |
| 331 |
|
$groupBy = NodeFactory::toSql($this->group, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
|
@@ 330-335 (lines=6) @@
|
| 327 |
|
} |
| 328 |
|
} |
| 329 |
|
|
| 330 |
|
if (!empty($this->group)) { |
| 331 |
|
$groupBy = NodeFactory::toSql($this->group, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
| 332 |
|
if ($groupBy) { |
| 333 |
|
$sql .= "\nGROUP BY ".$groupBy; |
| 334 |
|
} |
| 335 |
|
} |
| 336 |
|
|
| 337 |
|
if (!empty($this->having)) { |
| 338 |
|
$having = NodeFactory::toSql($this->having, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
|
@@ 337-342 (lines=6) @@
|
| 334 |
|
} |
| 335 |
|
} |
| 336 |
|
|
| 337 |
|
if (!empty($this->having)) { |
| 338 |
|
$having = NodeFactory::toSql($this->having, $dbConnection, $parameters, ' ', false, $indent + 2, $conditionsMode); |
| 339 |
|
if ($having) { |
| 340 |
|
$sql .= "\nHAVING ".$having; |
| 341 |
|
} |
| 342 |
|
} |
| 343 |
|
|
| 344 |
|
if (!empty($this->order)) { |
| 345 |
|
$order = NodeFactory::toSql($this->order, $dbConnection, $parameters, ',', false, $indent + 2, $conditionsMode); |
|
@@ 344-349 (lines=6) @@
|
| 341 |
|
} |
| 342 |
|
} |
| 343 |
|
|
| 344 |
|
if (!empty($this->order)) { |
| 345 |
|
$order = NodeFactory::toSql($this->order, $dbConnection, $parameters, ',', false, $indent + 2, $conditionsMode); |
| 346 |
|
if ($order) { |
| 347 |
|
$sql .= "\nORDER BY ".$order; |
| 348 |
|
} |
| 349 |
|
} |
| 350 |
|
|
| 351 |
|
if (!empty($this->limit)) { |
| 352 |
|
$limit = NodeFactory::toSql($this->limit, $dbConnection, $parameters, ',', false, $indent + 2, $conditionsMode); |
|
@@ 351-356 (lines=6) @@
|
| 348 |
|
} |
| 349 |
|
} |
| 350 |
|
|
| 351 |
|
if (!empty($this->limit)) { |
| 352 |
|
$limit = NodeFactory::toSql($this->limit, $dbConnection, $parameters, ',', false, $indent + 2, $conditionsMode); |
| 353 |
|
if ($limit) { |
| 354 |
|
$sql .= "\nLIMIT ".$limit; |
| 355 |
|
} |
| 356 |
|
} |
| 357 |
|
|
| 358 |
|
return $sql; |
| 359 |
|
} |