【EC-CUBE 4】 商品一覧ページの並び順（ソート順）を新規追加（カスタマイズ）する方法

<?php

namespace Customize\Repository;

use Eccube\Repository\ProductRepository;
use Eccube\Util\StringUtil;
use Eccube\Repository\QueryKey;

class CustomProductRepository extends ProductRepository
{
    /**
     * get query builder.
     *
     * @param array{
     *         category_id?:Category,
     *         name?:string,
     *         pageno?:string,
     *         disp_number?:ProductListMax,
     *         orderby?:ProductListOrderBy
     *     } $searchData
     *
     * @return \Doctrine\ORM\QueryBuilder
     */
    public function customGetQueryBuilderBySearchData($searchData)
    {
        $qb = $this->createQueryBuilder('p')
            ->andWhere('p.Status = 1');

        // 略

        // Order By
        // 価格低い順
        $config = $this->eccubeConfig;
        if (!empty($searchData['orderby']) && $searchData['orderby']->getId() == $config['eccube_product_order_price_lower']) {

        // 略

        // 価格高い順
        } elseif (!empty($searchData['orderby']) && $searchData['orderby']->getId() == $config['eccube_product_order_price_higher']) {

        // 略

        // 新着順
        } elseif (!empty($searchData['orderby']) && $searchData['orderby']->getId() == $config['eccube_product_order_newer']) {

        // 略

        // 更新順
        } elseif (!empty($searchData['orderby']) && $searchData['orderby']->getId() == 4) {
            if ($this->getEntityManager()->getFilters()->isEnabled('option_nostock_hidden') == true) {
                $qb->innerJoin('p.ProductClasses', 'pc');
                $qb->andWhere('pc.visible = true');
            }
            $qb->orderBy('p.update_date', 'DESC');
            $qb->addOrderBy('p.id', 'DESC');
        } else {

        // 略

        }

        return $this->queries->customize(QueryKey::PRODUCT_SEARCH, $qb, $searchData);
    }
}

<?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\Entity\BaseInfo;

// 略

use Eccube\Controller\AbstractController;
use Customize\Repository\CustomProductRepository;

class CustomProductController extends AbstractController
{
    /**
     * @var PurchaseFlow
     */
    protected $purchaseFlow;

    // 略

    /**
     * @var CustomProductRepository
     */
    protected $customProductRepository;

    private $title = '';

    /**
     * ProductController constructor.
     *
     * @param PurchaseFlow $cartPurchaseFlow

    // 略

     * @param CustomProductRepository $customProductRepository
     */
    public function __construct(
        PurchaseFlow $cartPurchaseFlow,

        // 略

        CustomProductRepository $customProductRepository
    ) {
        $this->purchaseFlow = $cartPurchaseFlow;

        // 略

        $this->customProductRepository = $customProductRepository;
    }

    /**
     * 商品一覧画面.
     *
     * @Route("/products/list", name="product_list", methods={"GET"})
     * @Template("Product/list.twig")
     */
    public function index(Request $request, PaginatorInterface $paginator)
    {
        // 略

        // paginator
        $searchData = $searchForm->getData();
        $qb = $this->customProductRepository->customGetQueryBuilderBySearchData($searchData);

        // 略
    }

  // 略

}