Symfony Profiler

<?php
/*
* This file is part of EC-CUBE
*
* Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
*
* http://www.ec-cube.co.jp/
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
namespace Customize\Controller;
use Eccube\Controller\AbstractController;
use Eccube\Entity\BaseInfo;
use Eccube\Entity\Master\ProductStatus;
use Eccube\Entity\Product;
use Eccube\Event\EccubeEvents;
use Eccube\Event\EventArgs;
use Eccube\Form\Type\AddCartType;
use Eccube\Form\Type\Master\ProductListMaxType;
use Eccube\Form\Type\Master\ProductListOrderByType;
use Eccube\Form\Type\SearchProductType;
use Eccube\Repository\BaseInfoRepository;
use Eccube\Repository\CustomerFavoriteProductRepository;
use Eccube\Repository\Master\ProductListMaxRepository;
use Eccube\Repository\ProductRepository;
use Eccube\Repository\ProductClassRepository;
use Eccube\Repository\OrderItemRepository;
use Customize\Service\CartService;
use Eccube\Service\PurchaseFlow\PurchaseContext;
use Eccube\Service\PurchaseFlow\PurchaseFlow;
use Knp\Bundle\PaginatorBundle\Pagination\SlidingPagination;
use Knp\Component\Pager\Paginator;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Response;
use Doctrine\ORM\Query;
class ProductController extends AbstractController
{
/**
* @var PurchaseFlow
*/
protected $purchaseFlow;
/**
* @var CustomerFavoriteProductRepository
*/
protected $customerFavoriteProductRepository;
/**
* @var CartService
*/
protected $cartService;
/**
* @var ProductRepository
*/
protected $productRepository;
/**
* @var ProductClassRepository
*/
protected $productClassRepository;
/**
* @var OrderItemRepository
*/
protected $orderItemRepository;
/**
* @var BaseInfo
*/
protected $BaseInfo;
/**
* @var AuthenticationUtils
*/
protected $helper;
/**
* @var ProductListMaxRepository
*/
protected $productListMaxRepository;
private $title = '';
/**
* ProductController constructor.
*
* @param PurchaseFlow $cartPurchaseFlow
* @param CustomerFavoriteProductRepository $customerFavoriteProductRepository
* @param CartService $cartService
* @param ProductRepository $productRepository
* @param ProductClassRepository $productClassRepository
* @param OrderItemRepository $orderItemRepository
* @param BaseInfoRepository $baseInfoRepository
* @param AuthenticationUtils $helper
* @param ProductListMaxRepository $productListMaxRepository
*/
public function __construct(
PurchaseFlow $cartPurchaseFlow,
CustomerFavoriteProductRepository $customerFavoriteProductRepository,
CartService $cartService,
ProductRepository $productRepository,
ProductClassRepository $productClassRepository,
OrderItemRepository $orderItemRepository,
BaseInfoRepository $baseInfoRepository,
AuthenticationUtils $helper,
ProductListMaxRepository $productListMaxRepository
) {
$this->purchaseFlow = $cartPurchaseFlow;
$this->customerFavoriteProductRepository = $customerFavoriteProductRepository;
$this->cartService = $cartService;
$this->productRepository = $productRepository;
$this->productClassRepository = $productClassRepository;
$this->orderItemRepository = $orderItemRepository;
$this->BaseInfo = $baseInfoRepository->get();
$this->helper = $helper;
$this->productListMaxRepository = $productListMaxRepository;
}
/**
* 商品一覧画面.
*
* @Route("/products/list", name="product_list")
* @Template("Product/list.twig")
*/
public function index(Request $request, Paginator $paginator)
{
// Doctrine SQLFilter
if ($this->BaseInfo->isOptionNostockHidden()) {
$this->entityManager->getFilters()->enable('option_nostock_hidden');
}
// handleRequestは空のqueryの場合は無視するため
if ($request->getMethod() === 'GET') {
$request->query->set('pageno', $request->query->get('pageno', ''));
}
// searchForm
/* @var $builder \Symfony\Component\Form\FormBuilderInterface */
$builder = $this->formFactory->createNamedBuilder('', SearchProductType::class);
if ($request->getMethod() === 'GET') {
$builder->setMethod('GET');
}
$event = new EventArgs(
[
'builder' => $builder,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_INDEX_INITIALIZE, $event);
/* @var $searchForm \Symfony\Component\Form\FormInterface */
$searchForm = $builder->getForm();
$searchForm->handleRequest($request);
// paginator
$searchData = $searchForm->getData();
$qb = $this->productRepository->getQueryBuilderBySearchData($searchData);
$event = new EventArgs(
[
'searchData' => $searchData,
'qb' => $qb,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_INDEX_SEARCH, $event);
$searchData = $event->getArgument('searchData');
$query = $qb->getQuery()
->useResultCache(true, $this->eccubeConfig['eccube_result_cache_lifetime_short']);
/** @var SlidingPagination $pagination */
$pagination = $paginator->paginate(
$query,
!empty($searchData['pageno']) ? $searchData['pageno'] : 1,
!empty($searchData['disp_number']) ? $searchData['disp_number']->getId() : $this->productListMaxRepository->findOneBy([], ['sort_no' => 'ASC'])->getId()
);
$ids = [];
foreach ($pagination as $Product) {
$ids[] = $Product->getId();
}
$ProductsAndClassCategories = $this->productRepository->findProductsWithSortedClassCategories($ids, 'p.id');
// addCart form
$forms = [];
foreach ($pagination as $Product) {
/* @var $builder \Symfony\Component\Form\FormBuilderInterface */
$builder = $this->formFactory->createNamedBuilder(
'',
AddCartType::class,
null,
[
'product' => $ProductsAndClassCategories[$Product->getId()],
'allow_extra_fields' => true,
]
);
$addCartForm = $builder->getForm();
$forms[$Product->getId()] = $addCartForm->createView();
}
// 表示件数
$builder = $this->formFactory->createNamedBuilder(
'disp_number',
ProductListMaxType::class,
null,
[
'required' => false,
'allow_extra_fields' => true,
]
);
if ($request->getMethod() === 'GET') {
$builder->setMethod('GET');
}
$event = new EventArgs(
[
'builder' => $builder,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_INDEX_DISP, $event);
$dispNumberForm = $builder->getForm();
$dispNumberForm->handleRequest($request);
// ソート順
$builder = $this->formFactory->createNamedBuilder(
'orderby',
ProductListOrderByType::class,
null,
[
'required' => false,
'allow_extra_fields' => true,
]
);
if ($request->getMethod() === 'GET') {
$builder->setMethod('GET');
}
$event = new EventArgs(
[
'builder' => $builder,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_INDEX_ORDER, $event);
$orderByForm = $builder->getForm();
$orderByForm->handleRequest($request);
$Category = $searchForm->get('category_id')->getData();
return [
'subtitle' => $this->getPageTitle($searchData),
'pagination' => $pagination,
'search_form' => $searchForm->createView(),
'disp_number_form' => $dispNumberForm->createView(),
'order_by_form' => $orderByForm->createView(),
'forms' => $forms,
'Category' => $Category,
];
}
/**
* 商品詳細画面.
*
* @Route("/products/detail/{id}", name="product_detail", methods={"GET"}, requirements={"id" = "\d+"})
* @Template("Product/detail.twig")
* @ParamConverter("Product", options={"repository_method" = "findWithSortedClassCategories"})
*
* @param Request $request
* @param Product $Product
*
* @return array
*/
public function detail(Request $request, Product $Product)
{
if (!$this->checkVisibility($Product)) {
throw new NotFoundHttpException();
}
$builder = $this->formFactory->createNamedBuilder(
'',
AddCartType::class,
null,
[
'product' => $Product,
'id_add_product_id' => false,
]
);
$event = new EventArgs(
[
'builder' => $builder,
'Product' => $Product,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_DETAIL_INITIALIZE, $event);
$is_favorite = false;
if ($this->isGranted('ROLE_USER')) {
$Customer = $this->getUser();
$is_favorite = $this->customerFavoriteProductRepository->isFavorite($Customer, $Product);
}
return [
'title' => $this->title,
'subtitle' => $Product->getName(),
'form' => $builder->getForm()->createView(),
'Product' => $Product,
'is_favorite' => $is_favorite,
];
}
/**
* お気に入り追加.
*
* @Route("/products/add_favorite/{id}", name="product_add_favorite", requirements={"id" = "\d+"})
*/
public function addFavorite(Request $request, Product $Product)
{
$this->checkVisibility($Product);
$event = new EventArgs(
[
'Product' => $Product,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_FAVORITE_ADD_INITIALIZE, $event);
if ($this->isGranted('ROLE_USER')) {
$Customer = $this->getUser();
$this->customerFavoriteProductRepository->addFavorite($Customer, $Product);
$this->session->getFlashBag()->set('product_detail.just_added_favorite', $Product->getId());
$event = new EventArgs(
[
'Product' => $Product,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_FAVORITE_ADD_COMPLETE, $event);
return $this->redirectToRoute('product_detail', ['id' => $Product->getId()]);
} else {
// 非会員の場合、ログイン画面を表示
// ログイン後の画面遷移先を設定
$this->setLoginTargetPath($this->generateUrl('product_add_favorite', ['id' => $Product->getId()], UrlGeneratorInterface::ABSOLUTE_URL));
$this->session->getFlashBag()->set('eccube.add.favorite', true);
$event = new EventArgs(
[
'Product' => $Product,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_FAVORITE_ADD_COMPLETE, $event);
return $this->redirectToRoute('mypage_login');
}
}
/**
* カートに追加.
*
* @Route("/products/add_cart/{id}", name="product_add_cart", methods={"POST"}, requirements={"id" = "\d+"})
*/
public function addCart(Request $request, Product $Product)
{
// エラーメッセージの配列
$errorMessages = [];
if (!$this->checkVisibility($Product)) {
throw new NotFoundHttpException();
}
$builder = $this->formFactory->createNamedBuilder(
'',
AddCartType::class,
null,
[
'product' => $Product,
'id_add_product_id' => false,
]
);
$event = new EventArgs(
[
'builder' => $builder,
'Product' => $Product,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_CART_ADD_INITIALIZE, $event);
/* @var $form \Symfony\Component\Form\FormInterface */
$form = $builder->getForm();
$form->handleRequest($request);
if (!$form->isValid()) {
throw new NotFoundHttpException();
}
$addCartData = $form->getData();
log_info(
'カート追加処理開始',
[
'product_id' => $Product->getId(),
'product_class_id' => $addCartData['product_class_id'],
'quantity' => $addCartData['quantity'],
]
);
// $support_plan = $addCartData['support_plan'];
$rental_start = $addCartData['rental_start'];
$period = $request->request->get('rental_period');
$rental_end = clone $rental_start;
$ProductClass = $this->productClassRepository->find($addCartData['product_class_id']);
// $rental_end->add(new DateInterval('P2D'));
// $rental_end = date("Y-m-d", strtotime($rental_end. ' + 2 days'));
switch($period) {
case '2泊3日':
$rental_end->add(new \DateInterval('P2D'));
$ProductClass->setPrice02($Product->getPrice2d());
$ProductClass->setPrice02IncTax($Product->getPrice2d() * 1.1);
break;
case '3泊4日':
$rental_end->add(new \DateInterval('P3D'));
$ProductClass->setPrice02($Product->getPrice3d());
$ProductClass->setPrice02IncTax($Product->getPrice3d() * 1.1);
break;
case '7泊８日':
$rental_end->add(new \DateInterval('P7D'));
$ProductClass->setPrice02($Product->getPrice7d());
$ProductClass->setPrice02IncTax($Product->getPrice7d() * 1.1);
break;
case '14泊15日':
$rental_end->add(new \DateInterval('P14D'));
$ProductClass->setPrice02($Product->getPrice14d());
$ProductClass->setPrice02IncTax($Product->getPrice14d() * 1.1);
break;
case '30日':
$rental_end->add(new \DateInterval('P30D'));
$ProductClass->setPrice02($Product->getPrice30d());
$ProductClass->setPrice02IncTax($Product->getPrice30d() * 1.1);
break;
}
// カートへ追加
$this->cartService->addProduct($ProductClass, $addCartData['quantity'], $rental_start, $rental_end, 1);
// $this->cartService->addProduct($addCartData['product_class_id'], $addCartData['quantity'], $rental_start, $rental_end, 1);
// 明細の正規化
$Carts = $this->cartService->getCarts();
foreach ($Carts as $Cart) {
$result = $this->purchaseFlow->validate($Cart, new PurchaseContext($Cart, $this->getUser()));
// 復旧不可のエラーが発生した場合は追加した明細を削除.
if ($result->hasError()) {
$this->cartService->removeProduct($addCartData['product_class_id']);
foreach ($result->getErrors() as $error) {
$errorMessages[] = $error->getMessage();
}
}
if ($result->hasWarning()) {
$stockWarningPrototype = '在庫が不足しております。一度に在庫数を超える購入はできません。';
foreach ($result->getWarning() as $warning) {
if (strpos($warning->getMessage(), $stockWarningPrototype) !== false) {
$errorMessages[] = $warning->getMessage();
try {
$this->cartService->removeProduct($addCartData['product_class_id']);
} catch(\Exception $e) {}
break;
}
}
}
}
$this->cartService->save();
log_info(
'カート追加処理完了',
[
'product_id' => $Product->getId(),
'product_class_id' => $addCartData['product_class_id'],
'quantity' => $addCartData['quantity'],
]
);
$event = new EventArgs(
[
'form' => $form,
'Product' => $Product,
],
$request
);
$this->eventDispatcher->dispatch(EccubeEvents::FRONT_PRODUCT_CART_ADD_COMPLETE, $event);
if ($event->getResponse() !== null) {
return $event->getResponse();
}
if ($request->isXmlHttpRequest()) {
// ajaxでのリクエストの場合は結果をjson形式で返す。
// 初期化
$done = null;
$messages = [];
if (empty($errorMessages)) {
// エラーが発生していない場合
$done = true;
array_push($messages, trans('front.product.add_cart_complete'));
} else {
// エラーが発生している場合
$done = false;
$messages = $errorMessages;
}
return $this->json(['done' => $done, 'messages' => $messages]);
} else {
// ajax以外でのリクエストの場合はカート画面へリダイレクト
foreach ($errorMessages as $errorMessage) {
$this->addRequestError($errorMessage);
}
return $this->redirectToRoute('cart');
}
}
/**
* ページタイトルの設定
*
* @param null|array $searchData
*
* @return str
*/
protected function getPageTitle($searchData)
{
if (isset($searchData['name']) && !empty($searchData['name'])) {
return trans('front.product.search_result');
} elseif (isset($searchData['category_id']) && $searchData['category_id']) {
return $searchData['category_id']->getName();
} else {
return trans('front.product.all_products');
}
}
/**
* 閲覧可能な商品かどうかを判定
*
* @param Product $Product
*
* @return boolean 閲覧可能な場合はtrue
*/
protected function checkVisibility(Product $Product)
{
$is_admin = $this->session->has('_security_admin');
// 管理ユーザの場合はステータスやオプションにかかわらず閲覧可能.
if (!$is_admin) {
// 在庫なし商品の非表示オプションが有効な場合.
// if ($this->BaseInfo->isOptionNostockHidden()) {
// if (!$Product->getStockFind()) {
// return false;
// }
// }
// 公開ステータスでない商品は表示しない.
if ($Product->getStatus()->getId() !== ProductStatus::DISPLAY_SHOW) {
return false;
}
}
return true;
}
/**
* check stock
*
* @Route("/products/check-stock", name="check_stock")
*
*/
public function checkStock(Request $request)
{
// $product_id = $request->request->get('product_id');
// $product_class_id = $request->request->get('product_class_id');
// $today = date("Y-m-d");
// $start0 = $request->request->get('start0');
// $period = $request->request->get('rental_period');
// $Product = $this->productRepository->find($product_id);
// $ProductClass = $this->productClassRepository->find($product_class_id);
// switch($period) {
// case '2泊3日':
// $end0 = date("Y-m-d", strtotime($start0. ' + 2 days'));
// break;
// case '3泊4日':
// $end0 = date("Y-m-d", strtotime($start0. ' + 3 days'));
// break;
// case '7泊８日':
// $end0 = date("Y-m-d", strtotime($start0. ' + 7 days'));
// break;
// case '14泊15日':
// $end0 = date("Y-m-d", strtotime($start0. ' + 14 days'));
// break;
// case '30日':
// $end0 = date("Y-m-d", strtotime($start0. ' + 30 days'));
// break;
// }
// $qb = $this->orderItemRepository
// ->createQueryBuilder('oi');
// $qb
// ->where('oi.rental_end > :today')
// ->andWhere('oi.ProductClass = :id')
// ->setParameter('today', $today)
// ->setParameter('id', $ProductClass->getId());
// $OrderItems = $qb->getQuery()->getResult();
// $ProductStock = $ProductClass->getProductStock()->getStock();
// $start0 = new \DateTime( date("Y-m-d", strtotime($start0. ' - 3 days')) );
// $end0 = new \DateTime( $end0 );
// foreach($OrderItems as $Item) {
// if ($Item->getRentalEnd() < $start0) {
// $ProductStock += $Item->getQuantity();
// }
// if ($Item->getRentalStart() > $end0) {
// $ProductStock += $Item->getQuantity();
// }
// }
// return new Response(
// $ProductStock
// );
$product_id = $request->request->get('product_id');
$product_class_id = $request->request->get('product_class_id');
$today = date("Y-m-d");
$start0 = $request->request->get('start0');
$period = $request->request->get('rental_period');
$Product = $this->productRepository->find($product_id);
$ProductClass = $this->productClassRepository->find($product_class_id);
switch($period) {
case '2泊3日':
$end0 = date("Y-m-d", strtotime($start0. ' + 2 days'));
break;
case '3泊4日':
$end0 = date("Y-m-d", strtotime($start0. ' + 3 days'));
break;
case '7泊８日':
$end0 = date("Y-m-d", strtotime($start0. ' + 7 days'));
break;
case '14泊15日':
$end0 = date("Y-m-d", strtotime($start0. ' + 14 days'));
break;
case '30日':
$end0 = date("Y-m-d", strtotime($start0. ' + 30 days'));
break;
}
$qb = $this->orderItemRepository
->createQueryBuilder('oi');
$qb
->where('oi.rental_end >= :today')
->andWhere('oi.ProductClass = :id')
->setParameter('today', $today)
->setParameter('id', $ProductClass->getId());
$OrderItems = $qb->getQuery()->getResult();
$ProductStock = $ProductClass->getProductStock()->getStock();
$start = new \DateTime( date("Y-m-d", strtotime($start0. ' - 3 days')) );
$today = new \DateTime($today);
foreach($OrderItems as $Item) {
if ($Item->getRentalEnd() < new \DateTime($start0))
$ProductStock += $Item->getQuantity();
if ( $Item->getRentalStart() >= $today && $Item->getRentalStart() <= new \DateTime($end0) )
$ProductStock -= $Item->getQuantity();
}
return new Response(
$ProductStock
);
}
/**
* check stock
*
* @Route("/products/check-stock-by-date", name="check_stock_by_date")
*
* @return array
*/
public function checkStockByDate(Request $request)
{
// $product_id = $request->request->get('product_id');
// $product_class_id = $request->request->get('product_class_id');
// $period = $request->request->get('rental_period');
// $today = date("Y-m-d");
// // $enable_rental_start = date("Y-m-d", strtotime($today. ' + 3 days'));
// $enable_rental_start = $today;
// $temp = strtotime($today);
// $lastdate = date("Y-m-t", $temp );
// $begin = new \DateTime( $enable_rental_start );
// $end = new \DateTime( $lastdate );
// $Product = $this->productRepository->find($product_id);
// $ProductClass = $this->productClassRepository->find($product_class_id);
// $qb = $this->orderItemRepository
// ->createQueryBuilder('oi');
// $qb
// ->where('oi.rental_end > :today')
// ->andWhere('oi.ProductClass = :id')
// ->setParameter('today', $today)
// ->setParameter('id', $ProductClass->getId());
// $OrderItems = $qb->getQuery()->getResult();
// $ProductStock = $ProductClass->getProductStock()->getStock();
// $result = [];
// switch($period) {
// case '2泊3日':
// $diff = 2;
// break;
// case '3泊4日':
// $diff = 3;
// break;
// case '7泊８日':
// $diff = 7;
// break;
// case '14泊15日':
// $diff = 14;
// break;
// case '30日':
// $diff = 30;
// break;
// }
// for($i = $begin; $i <= $end; $i->modify('+1 day')){
// $temp = $ProductStock;
// $end0 = date("Y-m-d", strtotime($i->format("Y-m-d"). ' + '.$diff.' days'));
// $start0 = new \DateTime(date("Y-m-d", strtotime($i->format("Y-m-d"). ' - 3 days')));
// $end0 = new \DateTime($end0);
// foreach($OrderItems as $Item) {
// if ($Item->getRentalEnd() < $start0) {
// $temp += $Item->getQuantity();
// }
// if ($Item->getRentalStart() > $end0)
// $temp += $Item->getQuantity();
// }
// if ($temp == 0) $result[] = $i->format("Y-m-d");
// }
// return new JsonResponse(
// $result
// );
$product_id = $request->request->get('product_id');
$product_class_id = $request->request->get('product_class_id');
$period = $request->request->get('rental_period');
$today = date("Y-m-d");
// $enable_rental_start = date("Y-m-d", strtotime($today. ' + 1 days'));
$temp = strtotime($today);
$lastdate = date("Y-m-t", $temp );
$begin = new \DateTime( $today );
$end = new \DateTime( $lastdate );
$Product = $this->productRepository->find($product_id);
$ProductClass = $this->productClassRepository->find($product_class_id);
$qb = $this->orderItemRepository
->createQueryBuilder('oi');
$qb
->where('oi.rental_end >= :today')
->andWhere('oi.ProductClass = :id')
->setParameter('today', $today)
->setParameter('id', $ProductClass->getId());
$OrderItems = $qb->getQuery()->getResult();
$ProductStock = $ProductClass->getProductStock()->getStock();
$result = [];
switch($period) {
case '2泊3日':
$diff = 2;
break;
case '3泊4日':
$diff = 3;
break;
case '7泊８日':
$diff = 7;
break;
case '14泊15日':
$diff = 14;
break;
case '30日':
$diff = 30;
break;
}
for($i = $begin; $i <= $end; $i->modify('+1 day')){
$temp = $ProductStock;
$start0 = new \DateTime( date("Y-m-d", strtotime($i->format("Y-m-d"). ' - 3 days')) );
$today = new \DateTime( date("Y-m-d") );
$end0 = date("Y-m-d", strtotime($i->format("Y-m-d"). ' + '.$diff.' days'));
$end0 = new \DateTime($end0);
foreach($OrderItems as $Item) {
if ($Item->getRentalEnd() < $i) {
$temp += $Item->getQuantity();
}
if ($Item->getRentalStart() >= $today && $Item->getRentalStart() <= $end0)
$temp -= $Item->getQuantity();
}
if ($temp <= 0) $result[] = $i->format("Y-m-d");
}
return new JsonResponse(
$result
);
}
}

app/Customize/Controller/ProductController.php line 299