OrderRenderer.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. /**
  3. * Copyright © Magento, Inc. All rights reserved.
  4. * See COPYING.txt for license details.
  5. */
  6. namespace Magento\Framework\DB\Select;
  7. use Magento\Framework\DB\Select;
  8. use Magento\Framework\DB\Platform\Quote;
  9. /**
  10. * Class OrderRenderer
  11. */
  12. class OrderRenderer implements RendererInterface
  13. {
  14. /**
  15. * @var Quote
  16. */
  17. protected $quote;
  18. /**
  19. * @param Quote $quote
  20. */
  21. public function __construct(
  22. Quote $quote
  23. ) {
  24. $this->quote = $quote;
  25. }
  26. /**
  27. * Render ORDER BY section
  28. *
  29. * @param Select $select
  30. * @param string $sql
  31. * @return string
  32. */
  33. public function render(Select $select, $sql = '')
  34. {
  35. if ($select->getPart(Select::ORDER)) {
  36. $order = [];
  37. foreach ($select->getPart(Select::ORDER) as $term) {
  38. if (is_array($term)) {
  39. if (is_numeric($term[0]) && (string)(int)$term[0] == $term[0]) {
  40. $order[] = (int)trim($term[0]) . ' ' . $term[1];
  41. } else {
  42. $order[] = $this->quote->quoteIdentifier($term[0]) . ' ' . $term[1];
  43. }
  44. } elseif (is_numeric($term) && (string)(int)$term == $term) {
  45. $order[] = (int)trim($term);
  46. } else {
  47. $order[] = $this->quote->quoteIdentifier($term);
  48. }
  49. }
  50. $sql .= ' ' . Select::SQL_ORDER_BY . ' ' . implode(', ', $order) . PHP_EOL;
  51. }
  52. return $sql;
  53. }
  54. }