FM / Expression

/var/www/vhosts/ihelp.ro/_OLD/vendor/cakephp/cakephp/src/Database/Expression/

/var/www/vhosts/ihelp.ro/_OLD/vendor/cakephp/cakephp/src/Database/Expression

Name	Size	Mode	Actions
AggregateExpression.php	5840	0644	edit dl rm
BetweenExpression.php	4146	0644	edit dl rm
CaseExpression.php	8146	0644	edit dl rm
CommonTableExpression.php	5660	0644	edit dl rm
Comparison.php	189	0644	edit dl rm
ComparisonExpression.php	9513	0644	edit dl rm
FieldInterface.php	1185	0644	edit dl rm
FieldTrait.php	1384	0644	edit dl rm
FunctionExpression.php	6271	0644	edit dl rm
IdentifierExpression.php	2222	0644	edit dl rm
OrderByExpression.php	3015	0644	edit dl rm
OrderClauseExpression.php	2264	0644	edit dl rm
QueryExpression.php	29949	0644	edit dl rm
TupleComparison.php	6463	0644	edit dl rm
UnaryExpression.php	3049	0644	edit dl rm
ValuesExpression.php	8568	0644	edit dl rm
WindowExpression.php	8050	0644	edit dl rm
WindowInterface.php	4660	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/_OLD/vendor/cakephp/cakephp/src/Database/Expression/OrderByExpression.php (3015B)

<?php
declare(strict_types=1);

/**
 * CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 * @link          https://cakephp.org CakePHP(tm) Project
 * @since         3.0.0
 * @license       https://opensource.org/licenses/mit-license.php MIT License
 */
namespace Cake\Database\Expression;

use Cake\Database\ExpressionInterface;
use Cake\Database\ValueBinder;
use RuntimeException;

/**
 * An expression object for ORDER BY clauses
 */
class OrderByExpression extends QueryExpression
{
    /**
     * Constructor
     *
     * @param string|array|\Cake\Database\ExpressionInterface $conditions The sort columns
     * @param array|\Cake\Database\TypeMap $types The types for each column.
     * @param string $conjunction The glue used to join conditions together.
     */
    public function __construct($conditions = [], $types = [], $conjunction = '')
    {
        parent::__construct($conditions, $types, $conjunction);
    }

/**
     * Convert the expression into a SQL fragment.
     *
     * @param \Cake\Database\ValueBinder $generator Placeholder generator object
     * @return string
     */
    public function sql(ValueBinder $generator): string
    {
        $order = [];
        foreach ($this->_conditions as $k => $direction) {
            if ($direction instanceof ExpressionInterface) {
                $direction = $direction->sql($generator);
            }
            $order[] = is_numeric($k) ? $direction : sprintf('%s %s', $k, $direction);
        }

return sprintf('ORDER BY %s', implode(', ', $order));
    }

/**
     * Auxiliary function used for decomposing a nested array of conditions and
     * building a tree structure inside this object to represent the full SQL expression.
     *
     * New order by expressions are merged to existing ones
     *
     * @param array $orders list of order by expressions
     * @param array $types list of types associated on fields referenced in $conditions
     * @return void
     */
    protected function _addConditions(array $orders, array $types): void
    {
        foreach ($orders as $key => $val) {
            if (
                is_string($key) &&
                is_string($val) &&
                !in_array(strtoupper($val), ['ASC', 'DESC'], true)
            ) {
                throw new RuntimeException(
                    'Passing extra expressions by associative array is not ' .
                    'allowed to avoid potential SQL injection. ' .
                    'Use QueryExpression or numeric array instead.'
                );
            }
        }

$this->_conditions = array_merge($this->_conditions, $orders);
    }
}

_conditions as $k => $direction) { if ($direction instanceof ExpressionInterface) { $direction = $direction->sql($generator); } $order[] = is_numeric($k) ? $direction : sprintf('%s %s', $k, $direction); } return sprintf('ORDER BY %s', implode(', ', $order)); } /** * Auxiliary function used for decomposing a nested array of conditions and * building a tree structure inside this object to represent the full SQL expression. * * New order by expressions are merged to existing ones * * @param array $orders list of order by expressions * @param array $types list of types associated on fields referenced in $conditions * @return void */ protected function _addConditions(array $orders, array $types): void { foreach ($orders as $key => $val) { if ( is_string($key) && is_string($val) && !in_array(strtoupper($val), ['ASC', 'DESC'], true) ) { throw new RuntimeException( 'Passing extra expressions by associative array is not ' . 'allowed to avoid potential SQL injection. ' . 'Use QueryExpression or numeric array instead.' ); } } $this->_conditions = array_merge($this->_conditions, $orders); } }