src/Network/Controller/NetworkAuctionhouseController.php line 25

Open in your IDE?
  1. <?php
  3. namespace App\Network\Controller;
  5. use App\Profile\Model\Profile;
  6. use Doctrine\DBAL\Query\QueryBuilder;
  7. use Knp\Component\Pager\PaginatorInterface;
  8. use Pimcore\Controller\FrontendController;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\Annotation\Route;
  13. #[Route([
  14.   'name' => 'network_auctionhouse_',
  15.   'localizedPaths' => [
  16.     'en' => '/{_locale}/network/auctionhouse',
  17.     'de' => '/{_locale}/netzwerk/auktionshaus',
  18.     'fr' => '/{_locale}/reseau/hoteldesventes',
  19.   ],
  20. ])]
  21. class NetworkAuctionhouseController extends FrontendController
  22. {
  23.   #[Route('/', name: 'index')]
  24.   // Auktionshäuser-Übersicht
  25.   public function index(Request $request, PaginatorInterface $paginator): Response
  26.   {
  27.     $auctionhouses = Profile::getList();
  29.     $auctionhouses->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) {
  30.       $queryBuilder->innerJoin('object_profile', 'object_brick_query_AuctionhouseProfile_profile', 'auctionhouse', 'object_profile.oo_id = auctionhouse.o_id');
  31.     });
  33.     $auctionhouses->setOrderKey('company');
  34.     $auctionhouses->setOrder('asc');
  36.     $paginator = $paginator->paginate(
  37.       $auctionhouses,
  38.       $request->get('page', 1),
  39.       10
  40.     );
  42.     return $this->render('network/profile/auctionhouse/listing.html.twig', [
  43.       'auctionhouses' => $paginator,
  44.     ]);
  45.   }
  46. }