50 lines
1.7 KiB
PHP
50 lines
1.7 KiB
PHP
<?php
|
|
|
|
namespace App\Repository;
|
|
|
|
use App\Entity\Region;
|
|
use App\Form\RegionType;
|
|
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
|
|
use Doctrine\Persistence\ManagerRegistry;
|
|
use Symfony\Component\Form\FormFactoryInterface;
|
|
use Symfony\Component\Form\FormInterface;
|
|
use Symfony\Component\Routing\RouterInterface;
|
|
|
|
/**
|
|
* @method Region|null find($id, $lockMode=null, $lockVersion=null)
|
|
* @method Region|null findOneBy(array $criteria, array $orderBy=null)
|
|
* @method Region[] findAll()
|
|
* @method Region[] findBy(array $criteria, array $orderBy=null, $limit=null, $offset=null)
|
|
*/
|
|
class RegionRepository extends ServiceEntityRepository {
|
|
public function __construct(ManagerRegistry $registry,
|
|
private RouterInterface $router,
|
|
private FormFactoryInterface $formFactory) {
|
|
parent::__construct($registry, Region::class);
|
|
}
|
|
|
|
|
|
public function getRegions() {
|
|
$qb=$this->_em->createQueryBuilder();
|
|
|
|
$qb->addSelect("region")
|
|
->addSelect("subRegions")
|
|
->from(Region::class, "region")
|
|
->leftJoin("region.subRegions", "subRegions")
|
|
->andWhere($qb->expr()->isNull("region.parentRegion"))
|
|
->orderBy("region.sortOrder");
|
|
|
|
return $qb->getQuery()->getResult();
|
|
}
|
|
|
|
public function getForm(string $route, Region $region): FormInterface {
|
|
$params=$region->getId() !== null ? array('id'=>$region->getId()) : array();
|
|
|
|
return $this->formFactory->create(RegionType::class, $region, array(
|
|
'action'=>$this->router->generate($route, $params),
|
|
'method'=>'post',
|
|
'data_route'=>$route,
|
|
));
|
|
}
|
|
}
|