app/Customize/Controller/Block/ZenTop003Controller.php line 45

Open in your IDE?
  1. <?php
  2. namespace Customize\Controller\Block;
  4. use Eccube\Controller\AbstractController;
  5. use Symfony\Component\HttpFoundation\Request;
  6. use Symfony\Component\Routing\Annotation\Route;
  7. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  8. use Eccube\Repository\ProductRepository;
  10. class ZenTop003Controller extends AbstractController
  11. {
  12.     /**
  13.      * @var ProductRepository
  14.      */
  15.     private $productRepository;
  16.     
  17.     public function __construct(
  18.         ProductRepository $productRepository
  19.     ) {
  20.         $this->productRepository = $productRepository;
  21.     }
  24.     /**
  25.      * @Route("/block/zen_top003", name="block_zen_top003")
  26.      * @Template("Block/zen_top003.twig")
  27.      */
  28.     public function index(Request $request)
  29.     {
  30.         /*
  31.         =========
  32.         $limit = 10; //取得する商品数
  34.         $qb = $this->productRepository->getQueryBuilderBySearchData([]);
  35.         $qb
  36.             ->orderBy('p.create_date', 'desc')
  37.             ->setMaxResults($limit);
  39.         $Products = $qb->getQuery()->getResult();
  40.         */
  41.         $Products = array();
  43.         for ($i = 1; $i < 11; $i++) {
  44.             $criteria = ['add_item2'=>'Lanking' . $i];
  45.             $temp = $this->productRepository->findBy($criteria); 
  46.             foreach ($temp as $t) {
  47.                 $Products[] = $t;
  48.             }
  49.             /*
  50.             if (count($temp)) {
  51.                 $Products[] = $temp[0];
  52.             }
  53.             */
  54.         }
  56.         $connection = $this->entityManager->getConnection();
  57.         $sql = 'SELECT * FROM `blb_features` WHERE `view`=1 ORDER BY `order` LIMIT 5';
  58.         $stmt = $connection->prepare($sql);
  59.         $result = $stmt->executeQuery();
  60.         $Features = $result->fetchAllAssociative();
  61.         /*
  62.         $news = array();
  63.         if (count($newsList)) {
  64.             $newsList[0]['text1'] = nl2br(url2link($newsList[0]['text1']));
  65.             if (file_exists('up_images/news/' . $newsList[0]['id'] . '/1.jpg')) {
  66.                 $newsList[0]['image'] = '../up_images/news/' . $newsList[0]['id'] . '/1.jpg';
  67.             } else {
  68.                 $newsList[0]['image'] = '';
  69.             }
  70.             $news = $newsList[0];
  71.             $category = $news['category'];
  72.         }
  73.         */
  75.         return [
  76.             'Products' => $Products,
  77.             'Features' => $Features
  78.         ];
  79.     }
  80. }