How to order by entity property in symfony?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

// src/Repository/YourEntityRepository.php

namespace AppRepository;

use AppEntityYourEntity;
use DoctrineBundleDoctrineBundleRepositoryServiceEntityRepository;
use DoctrineCommonPersistenceManagerRegistry;

class YourEntityRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, YourEntity::class);
    }

    public function findAllOrderedByProperty()
    {
        return $this->createQueryBuilder('e')
            ->orderBy('e.propertyName', 'ASC') // Replace 'propertyName' with the property you want to order by
            ->getQuery()
            ->getResult();
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

// src/Controller/YourController.php

namespace AppController;

use AppRepositoryYourEntityRepository;
use SymfonyBundleFrameworkBundleControllerAbstractController;
use SymfonyComponentRoutingAnnotationRoute;

class YourController extends AbstractController
{
    /**
     * @Route("/your-route", name="your_route")
     */
    public function index(YourEntityRepository $repository)
    {
        $orderedEntities = $repository->findAllOrderedByProperty();

        // Do something with your ordered entities

        return $this->render('your_template.html.twig', [
            'entities' => $orderedEntities,
        ]);
    }
}