src/Service/EntitySortService.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use Doctrine\ORM\QueryBuilder;
  6. use Symfony\Component\HttpFoundation\RequestStack;
  7. use Symfony\Contracts\Translation\TranslatorInterface;
  9. class EntitySortService
  10. {
  11.     public function getCurrentLocale():string
  12.     {
  13.         return $this->requestStack->getCurrentRequest()->getLocale();
  14.     }
  16.     public function __construct(
  17.         private RequestStack $requestStack,
  18.         private TranslatorInterface $translator
  19.     ) {}
  21.     public function sortEntityArrayUsingStringCompareByFieldName(array $array, string $field): array
  22.     {
  23.         $field = 'get' . ucfirst($field);
  24.         uasort($array, function($a, $b) use ($field): int {
  25.             return strcmp($a->{$field}(), $b->{$field}());
  26.         });
  27.         return $array;
  28.     }
  30.     public function sortEntityArrayByTranslatableFieldName(array $array, string $translatableFieldName, ?callable $firstLevelSortFunction = null): array
  31.     {
  32.         $translatableFieldName = 'get' . ucfirst($translatableFieldName);
  33.         uasort($array, function($a, $b) use ($translatableFieldName, $firstLevelSortFunction) {
  34.             $nameCompareResult = strcmp(
  35.                 $this->translator->trans($a->{$translatableFieldName}()),
  36.                 $this->translator->trans($b->{$translatableFieldName}())
  37.             );
  39.             if(null !== $firstLevelSortFunction) {
  40.                 $firstLevelFunctionCompareResult = $firstLevelSortFunction($a, $b);
  41.                 return 0 === $firstLevelFunctionCompareResult ? $nameCompareResult : $firstLevelFunctionCompareResult;
  42.             } else {
  43.                 return $nameCompareResult;
  44.             }
  45. //            return strcmp(
  46. //                $this->translator->trans($a->{$translatableFieldName}()),
  47. //                $this->translator->trans($b->{$translatableFieldName}())
  48. //            );
  49.         });
  50.         return $array;
  51.     }
  53.     public function modifyQueryBuilderToSortByCurrentTranslation(QueryBuilder &$qb, string $dqlAlias, string $fieldName): void
  54.     {
  55.         $qb->orderBy(sprintf('json_unquote(json_extract(%s.%s, :json_path))', $dqlAlias, $fieldName))
  56.             ->setParameter('json_path', sprintf('$.%s', $this->getCurrentLocale()));
  57.     }
  58. }