app/Customize/Repository/ProductRepositoryCustomize.php line 48

Open in your IDE?
  1. <?php
  3. namespace Customize\Repository;
  5. use Eccube\Entity\Product;
  6. use Eccube\Repository\ProductRepository;
  8. use Doctrine\Persistence\ManagerRegistry as RegistryInterface;
  9. use Eccube\Common\EccubeConfig;
  10. use Eccube\Doctrine\Query\Queries;
  11. use Eccube\Repository\Master\ProductStatusRepository;
  13. class ProductRepositoryCustomize extends ProductRepository{
  15.     /** @var ProductSalesRepository */
  16.     protected $productSalesRepository;
  17.     /** @var ProductStatusRepository */
  18.     protected $productStatusRepository; // 追加
  20.     /**
  21.      * ProductRepository constructor.
  22.      *
  23.      * @param RegistryInterface $registry
  24.      * @param Queries $queries
  25.      * @param EccubeConfig $eccubeConfig
  26.      * @param ProductStatusRepository $productStatusRepository
  27.      */
  28.     public function __construct(
  29.         RegistryInterface $registry,
  30.         Queries $queries,
  31.         EccubeConfig $eccubeConfig,
  32.         ProductSalesRepository $productSalesRepository,
  33.         ProductStatusRepository $productStatusRepository
  34.     ) {
  35.         parent::__construct($registry, $queries,$eccubeConfig);
  36.         $this->productSalesRepository = $productSalesRepository;
  37.         $this->productStatusRepository = $productStatusRepository;
  38.     }
  41.     /**
  42.      * 指定カラムの並び順で全データを取得
  43.      *
  44.      * @param string $column
  45.      * @param string $type
  46.      * @return void
  47.      */
  48.     public function getOrderBy(string $column = 'id',string $type = 'DESC'){
  49.         $status = $this->productStatusRepository->findOneBy(['id' => 1]);
  50.         $qb = $this->createQueryBuilder('p');
  51.         $qb->innerJoin('p.ProductClasses', 'pc');
  52.         $qb->andWhere('p.Status = :Status')->setParameter('Status',$status);
  53.         $qb->andWhere('pc.visible = :visible')->setParameter('visible', 1);
  54.         $qb->orderBy('p.' . $column,$type);
  55.         return $qb->getQuery()->getResult();
  56.     }
  58.     /**
  59.      * 指定の販売IDの商品を取得する
  60.      *
  61.      * @param integer $id
  62.      * @param string $column
  63.      * @param string $type
  64.      * @return void
  65.      */
  66.     public function getProductSales(int $id,string $column = 'id',string $type = 'DESC'){
  67.         $productSales = $this->productSalesRepository->find($id);
  68.         $qb = $this->createQueryBuilder('p');
  69.         $qb->where('p.ProductSales = :sales')->setParameter('sales',$productSales);
  70.         $qb->orderBy('p.' . $column,$type);
  71.         return $qb->getQuery()->getResult();
  72.     }
  73. }