Symfony Profiler

<?php
/*
* Plugin Name : SearchPlus
*
* Copyright (C) BraTech Co., Ltd. All Rights Reserved.
* http://www.bratech.co.jp/
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
namespace Plugin\SearchPlus42\Event;
use Doctrine\ORM\EntityManagerInterface;
use Eccube\Event\EccubeEvents;
use Eccube\Event\EventArgs;
use Eccube\Event\TemplateEvent;
use Plugin\SearchPlus42\Service\SearchPlusService;
use Symfony\Component\EventDispatcher\EventSubscriberInterface;
use Symfony\Component\HttpFoundation\RequestStack;
class AdminOrderEvent implements EventSubscriberInterface
{
private $entityManager;
private $searchPlusService;
private $requestStack;
public function __construct(
EntityManagerInterface $entityManager,
SearchPlusService $searchPlusService,
RequestStack $requestStack
)
{
$this->entityManager = $entityManager;
$this->searchPlusService = $searchPlusService;
$this->requestStack = $requestStack;
}
/**
* @return array
*/
public static function getSubscribedEvents()
{
return [
'@admin/Order/edit.twig' => 'onTemplateAdminOrderEdit',
EccubeEvents::ADMIN_ORDER_EDIT_SEARCH_PRODUCT_SEARCH => 'hookAdminOrderEditSearchProductSearch',
];
}
public function onTemplateAdminOrderEdit(TemplateEvent $event)
{
if($this->searchPlusService->checkInstallPlugin('ProductPlus42')){
$productItemRepository = $this->entityManager->getRepository('Plugin\ProductPlus42\Entity\ProductItem');
$ProductItems = $productItemRepository->findAll([],['sort_no' => 'DESC']);
$parameters = $event->getParameters();
$parameters['ProductItems'] = $ProductItems;
$event->setParameters($parameters);
}
$twig = '@SearchPlus42/admin/Order/ext_search.twig';
$event->addSnippet($twig);
$js = '@SearchPlus42/admin/Order/ext_search.js';
$event->addAsset($js);
$source = $event->getSource();
if(preg_match("/admin\_search\_product\_category\_id\'\)\.val/",$source, $result)){
$search = $result[0];
$replace = $search . ",{{ include('@SearchPlus42/admin/Order/ext_js.twig') }}";
$source = str_replace($search, $replace, $source);
}
$event->setSource($source);
}
public function hookAdminOrderEditSearchProductSearch(EventArgs $event)
{
$qb = $event->getArgument('qb');
$request = $this->requestStack->getMasterRequest();
$searchData['tag_ids'] = $request->get('tag_ids');
if (!empty($searchData['tag_ids']) && $searchData['tag_ids']) {
$ids = $searchData['tag_ids'];
if(!is_array($ids))$ids = [$ids];
$qb->innerJoin('p.ProductTag', 'pt');
$qb->andWhere($qb->expr()->in('pt.Tag', $ids));
}
$searchData['pmin'] = $request->get('pmin');
$searchData['pmax'] = $request->get('pmax');
$searchData['instock'] = $request->get('instock');
if(strlen($searchData['pmin']) > 0 || strlen($searchData['pmax'] > 0 || strlen($searchData['instock'] > 0))){
$dql = $qb->getDQL();
if(!preg_match('/INNER\sJOIN\sp\.ProductClasses/',$dql)){
$qb->innerJoin('p.ProductClasses', 'pc')
->andWhere('pc.visible = true');
}
if(isset($searchData['pmin']) && is_numeric($searchData['pmin'])){
$qb
->andWhere('pc.price02 >= :price_min')
->setParameter('price_min', $searchData['pmin']);
}
if(isset($searchData['pmax']) && is_numeric($searchData['pmax'])){
$qb
->andWhere('pc.price02 <= :price_max')
->setParameter('price_max', $searchData['pmax']);
}
if(isset($searchData['instock']) && !empty($searchData['instock'])){
$qb
->andWhere('pc.stock_unlimited = true OR pc.stock > 0');
}
}
if(method_exists('Eccube\Entity\Product','getMaker')){
$searchData['maker_id'] = $request->get('maker_id');
if (!empty($searchData['maker_id']) && $searchData['maker_id']) {
$ids = $searchData['maker_id'];
if(!is_array($ids))$ids = [$ids];
$qb->andWhere($qb->expr()->in('p.Maker', $ids));
}
}
if($this->searchPlusService->checkInstallPlugin('ProductPlus42')){
$productItemRepository = $this->entityManager->getRepository('Plugin\ProductPlus42\Entity\ProductItem');
$ProductItems = $productItemRepository->findAll();
foreach($ProductItems as $ProductItem){
if($ProductItem->getInputType() == \Plugin\ProductPlus42\Entity\ProductItem::DATE_TYPE){
$start = $request->get('productplus_'.$ProductItem->getId().'_date_start');
$end = $request->get('productplus_'.$ProductItem->getId().'_date_end');
if(strlen($start) > 0)$searchData['productplus_'.$ProductItem->getId().'_date_start'] = new \DateTime($start);
if(strlen($end) > 0)$searchData['productplus_'.$ProductItem->getId().'_date_end'] = new \DateTime($end);
}else{
$searchData['productplus_'.$ProductItem->getId()] = $request->get('productplus_'.$ProductItem->getId());
}
}
$qb = $this->searchPlusService->createQueryBuilder($qb, $searchData);
}
$event->setArgument('qb',$qb);
}
}

app/Plugin/SearchPlus42/Event/AdminOrderEvent.php line 79