Symfony Profiler

<?php
namespace Bidcoz\Bundle\FrontendBundle\Controller\Auction;
use Bidcoz\Bundle\CoreBundle\Controller\CoreController;
use Bidcoz\Bundle\CoreBundle\Entity\Auction\Auction;
use Bidcoz\Bundle\CoreBundle\Entity\Auction\Bid;
use Bidcoz\Bundle\CoreBundle\Entity\Auction\ItemSaleType;
use Bidcoz\Bundle\CoreBundle\Entity\Auction\WatchListItem;
use Bidcoz\Bundle\CoreBundle\Entity\Campaign;
use Bidcoz\Bundle\CoreBundle\Entity\Organization;
use Bidcoz\Bundle\FrontendBundle\Filter\ItemFilterType;
use Bidcoz\Bundle\FrontendBundle\Filter\Order\ItemOrderType;
use Doctrine\ORM\QueryBuilder;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
use Symfony\Component\Form\Form;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\Routing\Annotation\Route;
/**
* @Route("/{orgSlug}/{campaignSlug}/auction")
* @IsGranted("VIEW", subject="organization")
* @IsGranted("FRONT_END", subject="campaign")
*/
class AuctionController extends CoreController
{
/**
* @Route("/list", name="auction_catalog")
*/
public function catalogAction(Request $request, Organization $organization, Campaign $campaign, Auction $auction)
{
$qb = $this->getRepository('Auction\Item')->getAuctionQueryBuilder($auction, true, false);
$filterForm = $this->getItemFilterForm($auction);
$hasFilter = $this->applyFilters($request, $filterForm, $qb);
$orderForm = $this->getItemOrderForm($auction);
$hasOrder = $this->applyOrder($request, $orderForm, $qb);
$activeTab = $this->applyTabFilter($request, $qb);
$items = $this->getPagination($qb);
return $this->render('@BidcozFrontend/Auction/catalog.html.twig', [
'type' => 'auction',
'title' => 'Auction Catalog',
'organization' => $organization,
'campaign' => $campaign,
'auction' => $auction,
'filterForm' => $filterForm->createView(),
'orderForm' => $orderForm->createView(),
'items' => $items,
'activeTab' => $activeTab,
'hasFilter' => $hasFilter || $hasOrder || 'all' !== $activeTab,
'requireCC' => !$this->isGranted('WITH_CC', $campaign),
]);
}
/**
* Applies the catalog pill-tab filter (All Items / Auction / Fixed Price /
* Active Bids / No Bids Yet) to the query. Returns the resolved active tab.
*/
protected function applyTabFilter(Request $request, QueryBuilder $qb): string
{
$tab = $request->query->get('tab', 'all');
$activeBidsExists = 'SELECT tb.id FROM '.Bid::class.' tb WHERE tb.item = i AND tb.active = true';
switch ($tab) {
case 'auction':
$qb->andWhere('i.saleType = :tab_sale_type')
->setParameter('tab_sale_type', ItemSaleType::AUCTION);
break;
case 'fixed':
$qb->andWhere('i.saleType = :tab_sale_type')
->setParameter('tab_sale_type', ItemSaleType::FIXED_PRICE);
break;
case 'active-bids':
$qb->andWhere($qb->expr()->exists($activeBidsExists));
break;
case 'no-bids':
$qb->andWhere('i.saleType = :tab_sale_type')
->setParameter('tab_sale_type', ItemSaleType::AUCTION)
->andWhere($qb->expr()->not($qb->expr()->exists($activeBidsExists)));
break;
case 'watchlist':
$user = $this->getUser();
if ($user) {
$qb->andWhere($qb->expr()->exists(
'SELECT tw.id FROM '.WatchListItem::class.' tw WHERE tw.item = i AND tw.user = :tab_wl_user'
))->setParameter('tab_wl_user', $user);
} else {
$tab = 'all';
}
break;
default:
$tab = 'all';
break;
}
return $tab;
}
protected function getItemFilterForm(Auction $auction)
{
return $this->createForm(ItemFilterType::class, null, [
'auction' => $auction,
'permission_manager' => $this->getAuctionPermissionManager(),
]);
}
protected function getItemOrderForm(Auction $auction)
{
return $this->createForm(ItemOrderType::class);
}
protected function applyOrder(Request $request, Form $orderForm, QueryBuilder $qb)
{
try {
if ($request->query->has($orderForm->getName())) {
$orderForm->submit($request->query->get($orderForm->getName()));
$sortKey = $orderForm->get('order')->getData();
$orderQuery = ItemOrderType::getMap()[$sortKey];
$fieldsAndOrder = explode(',', $orderQuery);
foreach ($fieldsAndOrder as $idx => $fieldAndOrder) {
[$field, $order] = explode(':', $fieldAndOrder);
// If sorting by bid count, remove fixed priced items
if ('bidCount' === $field) {
$qb->andWhere($qb->expr()->neq('i.saleType', ':fixed_price_sale_type'));
}
if (0 === $idx) {
$qb->orderBy($field, $order);
} else {
$qb->addorderBy($field, $order);
}
}
return true;
}
} catch (\Exception $e) {
}
return false;
}
}

src/Bidcoz/Bundle/FrontendBundle/Controller/Auction/AuctionController.php line 30