mirror of
https://github.com/elyby/accounts.git
synced 2025-05-31 14:11:46 +05:30
* start updating to PHP 8.3 * taking off! Co-authored-by: ErickSkrauch <erickskrauch@yandex.ru> Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * dropped this Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * migrate to symfonymailer Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * this is so stupid 😭 Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * ah, free, at last. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * oh, Gabriel. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * now dawns thy reckoning. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * and thy gore shall GLISTEN before the temples of man. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * creature of steel. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * my gratitude upon thee for my freedom. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * but the crimes thy kind has committed against humanity Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * Upgrade PHP-CS-Fixer and do fix the codebase * First review round (maybe I have broken something) * are NOT forgotten. Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> * Enable parallel PHP-CS-Fixer runner * PHPStan level 1 * PHPStan level 2 * PHPStan level 3 * PHPStan level 4 * PHPStan level 5 * Levels 6 and 7 takes too much effort. Generate a baseline and fix them eventually * Resolve TODO's related to the php-mock * Drastically reduce baseline size with the Rector * More code modernization with help of the Rector * Update GitLab CI --------- Signed-off-by: Octol1ttle <l1ttleofficial@outlook.com> Co-authored-by: ErickSkrauch <erickskrauch@yandex.ru>
41 lines
1.2 KiB
PHP
41 lines
1.2 KiB
PHP
<?php
|
|
declare(strict_types=1);
|
|
|
|
namespace common\db\mysql;
|
|
|
|
use SamIT\Yii2\MariaDb\QueryBuilder as MariaDbQueryBuilder;
|
|
use yii\db\Expression;
|
|
|
|
class QueryBuilder extends MariaDbQueryBuilder {
|
|
|
|
public function buildOrderBy($columns) {
|
|
if (empty($columns)) {
|
|
return '';
|
|
}
|
|
|
|
$orders = [];
|
|
foreach ($columns as $name => $direction) {
|
|
if ($direction instanceof Expression) {
|
|
$orders[] = $direction->expression;
|
|
} elseif (is_array($direction)) {
|
|
// This condition branch is our custom solution
|
|
if (empty($direction)) {
|
|
continue;
|
|
}
|
|
|
|
$fieldValues = [];
|
|
foreach ($direction as $fieldValue) {
|
|
$fieldValues[] = $this->db->quoteValue($fieldValue);
|
|
}
|
|
|
|
$orders[] = 'FIELD(' . $this->db->quoteColumnName($name) . ',' . implode(',', $fieldValues) . ')';
|
|
} else {
|
|
$orders[] = $this->db->quoteColumnName($name) . ($direction === SORT_DESC ? ' DESC' : '');
|
|
}
|
|
}
|
|
|
|
return 'ORDER BY ' . implode(', ', $orders);
|
|
}
|
|
|
|
}
|