app/Customize/Controller/PageController.php line 450

Open in your IDE?
  1. <?php
  3. namespace Customize\Controller;
  5. use Eccube\Controller\AbstractController;
  6. use Eccube\Form\Type\AddCartType;
  7. use Eccube\Repository\CategoryRepository;
  8. use Eccube\Repository\NewsRepository;
  9. use Eccube\Repository\ProductRepository;
  10. use Knp\Component\Pager\Paginator;
  11. use Plugin\CategoryRecommend4\Repository\CategoryRecommendProductRepository;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  13. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  14. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  15. use Symfony\Component\HttpFoundation\Request;
  17. class PageController extends AbstractController
  18. {
  20.     // 設定
  21.     protected $brandMaxCategoryId = 3;
  22.     protected $shopDialogueId = 100;
  23.     protected $shopEnsembleId = 101;
  24.     protected $shopEnsembledeuxId = 1217;
  25.     protected $shopFlairId = 102;
  26.     protected $shopGatheringId = 413;
  27.     protected $pickupCategoryId = 1095;
  29.     /**
  30.      * @var ProductRepository
  31.      */
  32.     protected $productRepository;
  34.     /**
  35.      * @var NewsRepository
  36.      */
  37.     protected $newsRepository;
  39.     /**
  40.      * @var CategoryRepository
  41.      */
  42.     protected $categoryRepository;
  44.     /**
  45.      * @var CategoryRecommendProductRepository
  46.      */
  47.     protected $categoryRecommendProductRepository;
  49.     protected $brandCategories;
  51.     public function __construct(
  52.         ProductRepository $productRepository,
  53.         CategoryRepository $categoryRepository,
  54.         NewsRepository $newsRepository,
  55.         CategoryRecommendProductRepository $categoryRecommendProductRepository
  56.     ) {
  57.         $this->productRepository = $productRepository;
  58.         $this->categoryRepository = $categoryRepository;
  59.         $this->newsRepository = $newsRepository;
  60.         $brandMaxCategory = $this->categoryRepository->find($this->brandMaxCategoryId);
  61.         $this->brandCategories = $this->categoryRepository->getList($brandMaxCategory);
  62.         $this->categoryRecommendProductRepository = $categoryRecommendProductRepository;
  63.     }
  65.     /**
  66.      * @Method("GET")
  67.      * @Route("/faq", name="faq")
  68.      * @Template("Other/faq.twig")
  69.      */
  70.     public function faq()
  71.     {
  72.         return [];
  73.     }
  75.     /**
  76.      * @Method("GET")
  77.      * @Route("/about", name="about")
  78.      * @Template("Other/about.twig")
  79.      */
  80.     public function about()
  81.     {
  82.         return [];
  83.     }
  85.     /**
  86.      * @Method("GET")
  87.      * @Route("/dialogue", name="shop_dialogue_top")
  88.      * @Template("Shop/dialogue_top.twig")
  89.      */
  90.     public function shop_dialogue()
  91.     {
  92.         $info = $this->getShopInfo($this->shopDialogueId, 'dialogue', 5);
  93.         return $info;
  94.     }
  96.     /**
  97.      * @Method("GET")
  98.      * @Route("/blogs", name="blog_list")
  99.      * @Template("Blog/list.twig")
  100.      */
  101.     public function blog_list(Request $request)
  102.     {
  103.         $shop = $request->query->get('shop');
  104.         $pageno = $request->query->get('pageno', 1);
  105.         $cat_id = '';
  106.         if ($shop == 'dialogue') {
  107.             $cat_id = 5;
  108.         } elseif ($shop == 'ensemble') {
  109.             $cat_id = 2;
  110.         } elseif ($shop == 'ensembledeux') {
  111.             $cat_id = 1521;
  112.         } elseif ($shop == 'flair') {
  113.             $cat_id = 55;
  114.         } elseif ($shop == 'gathering') {
  115.             $cat_id = 397;
  116.         }
  118.         if ($pageno == '1') {
  119.             $count = 17;
  120.             $offset = 0;
  121.         } else {
  122.             $count = 18;
  123.             $offset = 18 * ($pageno - 1) - 1;
  124.         }
  125.         $args = [
  126.             'posts_per_page' => $count,
  127.             'offset' => $offset,
  128.             'orderby' => 'date',
  129.             'order' => 'DESC',
  130.         ];
  131.         if ($cat_id) {
  132.             $args['cat'] = $cat_id;
  133.         }
  134.         $the_query = new \WP_Query($args);
  136.         $blogs = [];
  137.         while ($the_query->have_posts()): $the_query->the_post();
  138.             $categories = get_the_category();
  139.             $cat_name = "";
  140.             if ($categories) {
  141.                 foreach ($categories as $category) {
  142.                     if ($category->term_id === 2 || $category->term_id === 5 || $category->term_id === 55 || $category->term_id === 397 || $category->term_id === 1521) {
  143.                         if ($cat_id) {
  144.                             if ($shop == 'dialogue' && $category->term_id === 5) {
  145.                                 $cat_name = $category->name;
  146.                                 break;
  147.                             } elseif ($shop == 'ensemble' && $category->term_id === 2) {
  148.                             $cat_name = $category->name;
  149.                             break;
  150.                         } elseif ($shop == 'ensembledeux' && $category->term_id === 1521) {
  151.                             $cat_name = $category->name;
  152.                             break;
  153.                         } elseif ($shop == 'flair' && $category->term_id === 55) {
  154.                             $cat_name = $category->name;
  155.                             break;
  156.                         } elseif ($shop == 'gathering' && $category->term_id === 397) {
  157.                             $cat_name = $category->name;
  158.                             break;
  159.                         }
  160.                     } else {
  161.                         // 設定なし
  162.                         $cat_name = $category->name;
  163.                         break;
  165.                     }
  166.                 }
  167.             }
  169.         }
  171.         $blogs[] = [
  172.             'id' => get_the_ID(),
  173.             'title' => get_the_title(),
  174.             'cat_name' => $cat_name,
  175.             'date' => get_the_date('Y.m.d'),
  176.             'thumbnail' => get_the_post_thumbnail_url(),
  177.         ];
  178.         endwhile;
  179.         wp_reset_postdata();
  181.         $max_posts_num = $the_query->found_posts;
  182.         if ($max_posts_num <= 17) {
  183.             $max_page_num = 1;
  184.         } else {
  185.             $max_page_num = 1 + ceil(($max_posts_num - 17) / 18);
  186.         }
  188.         return [
  189.             'shop' => $shop,
  190.             'Blogs' => $blogs,
  191.             'currentPage' => $pageno,
  192.             'max_page_num' => $max_page_num,
  193.         ];
  194.     }
  196.     /**
  197.      * @Method("GET")
  198.      * @Route("/blogs/detail/{id}", name="blog_detail")
  199.      * @Template("Blog/detail.twig")
  200.      */
  201.     public function blog_detail(Request $request, $id)
  202.     {
  203.         $args = [
  204.             'p' => $id,
  205.             'category__in' => [5, 2, 55, 397, 1521],
  206.         ];
  207.         $the_query = new \WP_Query($args);
  208.         $acf = new \ACF();
  210.         $blog = [];
  211.         while ($the_query->have_posts()): $the_query->the_post();
  212.             $prev_post = get_next_post(true);
  213.             $next_post = get_previous_post(true);
  214.             $blog = [
  215.                 'id' => get_the_ID(),
  216.                 'title' => get_the_title(),
  217.                 'date' => get_the_date('Y.m.d'),
  218.                 'content' => do_shortcode(get_the_content()),
  219.                 'thumbnail' => get_the_post_thumbnail_url(),
  220.                 'next_link' => $prev_post ? "/blogs/detail/" . $prev_post->ID : null,
  221.                 'prev_link' => $next_post ? "/blogs/detail/" . $next_post->ID : null,
  222.                 'recommend' => get_field('recommend'),
  223.             ];
  224.             $cate_slugs = [];
  225.             foreach (get_the_category() as $c) {
  226.                 $cate_slugs[$c->cat_ID] = $c->slug;
  227.             }
  229.             if (in_array('dialogue', $cate_slugs)) {
  230.                 $shop = 'dialogue';
  231.                 // $pickup_category_id = 1102;
  232.                 $pickup_category_id = $this->shopDialogueId;
  233.             } elseif (in_array('ensemble', $cate_slugs)) {
  234.             $shop = 'ensemble';
  235.             // $pickup_category_id = 1103;
  236.             $pickup_category_id = $this->shopEnsembleId;
  237.         } elseif (in_array('ensembledeux', $cate_slugs)) {
  238.             $shop = 'ensembledeux';
  239.             // $pickup_category_id = 1104;
  240.             $pickup_category_id = $this->shopEnsembledeuxId;
  241.         } elseif (in_array('flair', $cate_slugs)) {
  242.             $shop = 'flair';
  243.             // $pickup_category_id = 1105;
  244.             $pickup_category_id = $this->shopFlairId;
  245.         } elseif (in_array('gathering', $cate_slugs)) {
  246.             $shop = 'gathering';
  247.             // $pickup_category_id = 1106;
  248.             $pickup_category_id = $this->shopGatheringId;
  249.         }
  251.         endwhile;
  252.         if ($blog['recommend']) {
  253.             log_info("getlog" . $blog['recommend']);
  254.             $recomend = explode(',', $blog['recommend']);
  255.             $category_recommend_products = $this->getProductsInRecommend($recomend, 3);
  257.         } else {
  258.             $category_recommend_products = $this->getProductsInCategory($pickup_category_id, 3);
  260.         }
  261.         // $pickupCategory = $this->categoryRepository->find($pickup_category_id);
  262.         // $category_recommend_products = $this->categoryRecommendProductRepository->getCategoryRecommendProduct($pickupCategory);
  264.         // addCart form
  265.         $forms = [];
  266.         $ids = [];
  267.         foreach ($category_recommend_products as $item) {
  268.             $ids[] = $item->getId();
  269.         }
  270.         $ProductsAndClassCategories = $this->productRepository->findProductsWithSortedClassCategories($ids, 'p.id');
  272.         foreach ($category_recommend_products as $item) {
  273.             /* @var $builder \Symfony\Component\Form\FormBuilderInterface */
  274.             $builder = $this->formFactory->createNamedBuilder(
  275.                 '',
  276.                 AddCartType::class,
  277.                 null,
  278.                 [
  279.                     'product' => $ProductsAndClassCategories[$item->getId()],
  280.                     'allow_extra_fields' => true,
  281.                 ]
  282.             );
  283.             $addCartForm = $builder->getForm();
  285.             $forms[$item->getId()] = $addCartForm->createView();
  286.         }
  288.         return [
  289.             'shop' => $shop,
  290.             'Blog' => $blog,
  291.             'Pickup' => $category_recommend_products,
  292.             'forms' => $forms,
  293.         ];
  294.     }
  296.     /**
  297.      * @Method("GET")
  298.      * @Route("/dialogue/concept", name="shop_dialogue_concept")
  299.      * @Template("Shop/dialogue_concept.twig")
  300.      */
  301.     public function shop_dialogue_concept()
  302.     {
  303.         return [];
  304.     }
  306.     /**
  307.      * @Method("GET")
  308.      * @Route("/ensemble", name="shop_ensemble_top")
  309.      * @Template("Shop/ensemble_top.twig")
  310.      */
  311.     public function shop_ensemble()
  312.     {
  313.         $info = $this->getShopInfo($this->shopEnsembleId, 'ensemble', 2);
  314.         return $info;
  315.     }
  317.     /**
  318.      * @Method("GET")
  319.      * @Route("/ensemble/concept", name="shop_ensemble_concept")
  320.      * @Template("Shop/ensemble_concept.twig")
  321.      */
  322.     public function shop_ensemble_concept()
  323.     {
  324.         return [];
  325.     }
  327.     /**
  328.      * @Method("GET")
  329.      * @Route("/ensembledeux", name="shop_ensembledeux_top")
  330.      * @Template("Shop/ensembledeux_top.twig")
  331.      */
  332.     public function shop_ensembledeux()
  333.     {
  334.         $info = $this->getShopInfo($this->shopEnsembledeuxId, 'ensembledeux', 1521);
  335.         return $info;
  336.     }
  338.     /**
  339.      * @Method("GET")
  340.      * @Route("/ensembledeux/concept", name="shop_ensembledeux_concept")
  341.      * @Template("Shop/ensembledeux_concept.twig")
  342.      */
  343.     public function shop_ensembledeux_concept()
  344.     {
  345.         return [];
  346.     }
  348.     /**
  349.      * @Method("GET")
  350.      * @Route("/flair", name="shop_flair_top")
  351.      * @Template("Shop/flair_top.twig")
  352.      */
  353.     public function shop_flair()
  354.     {
  355.         $info = $this->getShopInfo($this->shopFlairId, 'flair', 55);
  356.         return $info;
  357.     }
  359.     /**
  360.      * @Method("GET")
  361.      * @Route("/flair/concept", name="shop_flair_concept")
  362.      * @Template("Shop/flair_concept.twig")
  363.      */
  364.     public function shop_flair_concept()
  365.     {
  366.         return [];
  367.     }
  369.     /**
  370.      * @Method("GET")
  371.      * @Route("/gathering", name="shop_gathering_top")
  372.      * @Template("Shop/gathering_top.twig")
  373.      */
  374.     public function shop_gathering()
  375.     {
  376.         $info = $this->getShopInfo($this->shopGatheringId, 'gathering', 397);
  377.         return $info;
  378.     }
  380.     /**
  381.      * @Method("GET")
  382.      * @Route("/gathering/concept", name="shop_gathering_concept")
  383.      * @Template("Shop/gathering_concept.twig")
  384.      */
  385.     public function shop_gathering_concept()
  386.     {
  387.         return [];
  388.     }
  390.     /**
  391.      * @Method("GET")
  392.      * @Route("/brand/list", name="brand_list")
  393.      * @Template("Brand/list.twig")
  394.      */
  395.     public function brand_list(Request $request)
  396.     {
  397.         $brandParantCategory = $this->categoryRepository->find('3');
  398.         $qb = $this->categoryRepository->createQueryBuilder('ca');
  399.         $qb->andWhere('ca.Parent = :parent')
  400.             ->setParameter('parent', $brandParantCategory)
  401.             ->orderBy("ca.sort_no", "DESC");
  402.         $shop = $request->query->get('shop');
  403.         if ($shop) {
  404.             if ($shop == 'dialogue') {
  405.                 /*$or = $qb->expr()->orx();
  406.                 $or->add($qb->expr()->eq('ca.shop_dialogue', 1));
  407.                 $or->add($qb->expr()->eq('ca.shop_ensemble', 1));
  408.                 $qb->andWhere($or);*/
  409.                 $qb->andWhere('ca.shop_dialogue = :flg')
  410.                     ->setParameter('flg', '1');
  411.             } else if ($shop == 'ensemble') {
  412.                 $qb->andWhere('ca.shop_ensemble = :flg')
  413.                     ->setParameter('flg', '1');
  414.             } else if ($shop == 'ensembledeux') {
  415.                 $qb->andWhere('ca.shop_ensembledeux = :flg')
  416.                     ->setParameter('flg', '1');
  417.             } else if ($shop == 'flair') {
  418.                 $qb->andWhere('ca.shop_flair = :flg')
  419.                     ->setParameter('flg', '1');
  420.             } else if ($shop == 'gathering') {
  421.                 $qb->andWhere('ca.shop_gathering = :flg')
  422.                     ->setParameter('flg', '1');
  423.             }
  424.         }
  426.         $cat = $request->query->get('cat');
  427.         if ($cat) {
  428.             if ($cat == 'mens') {
  429.                 $qb->andWhere('ca.men = :flg')
  430.                     ->setParameter('flg', '1');
  431.             } else if ($cat == 'womens') {
  432.                 $qb->andWhere('ca.women = :flg')
  433.                     ->setParameter('flg', '1');
  435.             }
  436.         }
  437.         $brandCategories = $qb->getQuery()
  438.             ->getResult();
  439.         return [
  440.             'shop' => $shop,
  441.             'BrandCategories' => $brandCategories,
  442.         ];
  443.     }
  445.     /**
  446.      * @Method("GET")
  447.      * @Route("/brand", name="all_brand_list")
  448.      * @Template("Other/brand.twig")
  449.      */
  450.     public function all_brand_list(Request $request)
  451.     {
  452.         $brandParantCategory = $this->categoryRepository->find('3');
  453.         $qb = $this->categoryRepository->createQueryBuilder('ca');
  454.         $qb->andWhere('ca.Parent = :parent')
  455.             ->andWhere('ca.shop_dialogue = :shopEnable OR ca.shop_ensemble = :shopEnable OR ca.shop_ensembledeux = :shopEnable OR ca.shop_flair = :shopEnable OR ca.shop_gathering = :shopEnable')
  456.             ->setParameter('parent', $brandParantCategory)
  457.             ->setParameter('shopEnable', 1)
  458.             ->orderBy("ca.sort_no", "DESC");
  460.         $cat = $request->query->get('cat');
  461.         if ($cat) {
  462.             if ($cat == 'mens') {
  463.                 $qb->andWhere('ca.men = :flg')
  464.                     ->setParameter('flg', '1');
  465.             } else if ($cat == 'womens') {
  466.                 $qb->andWhere('ca.women = :flg')
  467.                     ->setParameter('flg', '1');
  469.             }
  470.         }
  472.         // $qb->andWhere('ca.name != ?1')
  473.         //     ->setParameter(1, 'Aeta');
  475.         $brandCategories = $qb->getQuery()
  476.             ->getResult();
  477.         return [
  478.             'BrandCategories' => $brandCategories,
  479.         ];
  480.     }
  482.     /**
  483.      * @Method("GET")
  484.      * @Route("/item/list", name="item_list")
  485.      * @Template("Item/list.twig")
  486.      */
  487.     public function item_list(Request $request)
  488.     {
  489.         $brandParantCategory = $this->categoryRepository->find('4');
  490.         $qb = $this->categoryRepository->createQueryBuilder('ca');
  491.         $qb->andWhere('ca.Parent = :parent')
  492.             ->setParameter('parent', $brandParantCategory)
  493.             ->orderBy("ca.sort_no", "DESC");
  494.         $shop = $request->query->get('shop');
  496.         $brandCategories = $qb->getQuery()
  497.             ->getResult();
  498.         return [
  499.             'shop' => $shop,
  500.             'BrandCategories' => $brandCategories,
  501.         ];
  502.     }
  504.     /**
  505.      * @Method("GET")
  506.      * @Route("/item", name="all_item_list")
  507.      * @Template("Other/item.twig")
  508.      */
  509.     public function all_item_list(Request $request)
  510.     {
  511.         $brandParantCategory = $this->categoryRepository->find('4');
  512.         $qb = $this->categoryRepository->createQueryBuilder('ca');
  513.         $qb->andWhere('ca.Parent = :parent')
  514.             ->setParameter('parent', $brandParantCategory)
  515.             ->orderBy("ca.sort_no", "DESC");
  517.         $brandCategories = $qb->getQuery()
  518.             ->getResult();
  519.         return [
  520.             'BrandCategories' => $brandCategories,
  521.         ];
  522.     }
  524.     /**
  525.      * @Method("GET")
  526.      * @Route("/brand/{id}", name="brand_detail", requirements={"id" = "\d+"})
  527.      * @Template("Brand/detail.twig")
  528.      */
  529.     public function brand_detail(Request $request, $id, Paginator $paginator)
  530.     {
  531.         $brand = $this->categoryRepository->find($id);
  532.         $pagination = $paginator->paginate(
  533.             $this->getProductsInCategoryQuery($id),
  534.             $request->query->getInt('pageno', 1),
  535.             12
  536.         );
  538.         // 店舗設定
  539.         if ($brand->getShopDialogue() ===true) {
  540.             $shop = 'dialogue';
  541.         } else if ($brand->getShopEnsemble() ===true) {
  542.             $shop = 'ensemble';
  543.         } else if ($brand->getShopEnsembledeux() ===true) {
  544.             $shop = 'ensembledeux';
  545.         } else if ($brand->getShopFlair() ===true) {
  546.             $shop = 'flair';
  547.         } else if ($brand->getShopGathering() ===true) {
  548.             $shop = 'gathering';
  549.         }else{
  550.             $shop = 'dialogue';
  551.         }
  552.         log_info("brand_detail_log shop:" . $shop);
  554.         return [
  555.             'shop' => $shop,
  556.             'Brand' => $brand,
  557.             'pagination' => $pagination,
  558.         ];
  559.     }
  561.     /**
  562.      * @Method("GET")
  563.      * @Route("/item/{id}", name="item_detail", requirements={"id" = "\d+"})
  564.      * @Template("Item/detail.twig")
  565.      */
  566.     public function item_detail(Request $request, $id, Paginator $paginator)
  567.     {
  568.         $brand = $this->categoryRepository->find($id);
  569.         $pagination = $paginator->paginate(
  570.             $this->getProductsInCategoryQuery($id),
  571.             $request->query->getInt('pageno', 1),
  572.             12
  573.         );
  575.         return [
  576.             'Brand' => $brand,
  577.             'pagination' => $pagination,
  578.         ];
  579.     }
  581.     private function getProductsInCategoryQuery($categry_id)
  582.     {
  583.         $category = $this->categoryRepository->find($categry_id);
  584.         $qb = $this->productRepository->createQueryBuilder('p')
  585.             ->addSelect("(CASE WHEN (CASE WHEN MAX(pc.stock) IS NULL THEN 0 ELSE MAX(pc.stock) END) + (CASE WHEN MAX(pc.stock_unlimited) IS NULL THEN 0 ELSE  MAX(pc.stock_unlimited) END) = 0 THEN '0000-00-00 00:00:00_0000-00-00 00:00:00' ELSE CONCAT(CASE WHEN p.published_at IS NULL THEN '0000-00-00 00:00:00' ELSE p.published_at END, '_', p.create_date) END) AS HIDDEN sort_field")
  586.             ->andWhere('p.Status = 1')
  587.             ->andWhere('p.published_at is NULL OR p.published_at <= :now')
  588.             ->setParameter('now', new \DateTime())
  589.             ->andWhere('pc.visible = :visible')
  590.             ->setParameter('visible', true);
  592.         $qb->innerJoin('p.ProductClasses', 'pc')
  593.             ->innerJoin('p.ProductCategories', 'pct')
  594.             ->innerJoin('pct.Category', 'c')
  595.             ->andWhere($qb->expr()->in('pct.Category', ':Categories'))
  596.             ->setParameter('Categories', [$category])
  597.             ->groupBy('p.id')
  598.             ->addOrderBy('sort_field', 'DESC')
  599.             ->addOrderBy('p.id', 'DESC');
  601.         return $qb;
  602.     }
  604.     private function getProductsInCategory($categry_id, $count)
  605.     {
  606.         $category = $this->categoryRepository->find($categry_id);
  607.         $categories = [$category];
  608.         $qb = $this->productRepository->createQueryBuilder('p')
  609.             ->addSelect("(CASE WHEN (CASE WHEN MAX(pc.stock) IS NULL THEN 0 ELSE MAX(pc.stock) END) + (CASE WHEN MAX(pc.stock_unlimited) IS NULL THEN 0 ELSE  MAX(pc.stock_unlimited) END) = 0 THEN '0000-00-00 00:00:00_0000-00-00 00:00:00' ELSE CONCAT(CASE WHEN p.published_at IS NULL THEN '0000-00-00 00:00:00' ELSE p.published_at END, '_', p.create_date) END) AS HIDDEN sort_field")
  610.             ->andWhere('p.Status = 1')
  611.             ->andWhere('p.published_at is NULL OR p.published_at <= :now')
  612.             ->setParameter('now', new \DateTime())
  613.             ->andWhere('pc.visible = :visible')
  614.             ->setParameter('visible', true);
  615.         $qb->innerJoin('p.ProductClasses', 'pc')
  616.             ->innerJoin('p.ProductCategories', 'pct')
  617.             ->innerJoin('pct.Category', 'c')
  618.             ->andWhere($qb->expr()->in('pct.Category', ':Categories'))
  619.             ->setParameter('Categories', $categories)
  620.             ->groupBy('p.id')
  621.             ->addOrderBy('sort_field', 'DESC')
  622.             ->addOrderBy('p.id', 'DESC');
  623.         $products = $qb
  624.             ->setMaxResults($count)
  625.             ->getQuery()
  626.             ->getResult();
  628.         // print("<pre>".print_r($products,true)."</pre>");die;
  629.         return $products;
  630.     }
  632.     private function getProductsInRecommend($recommend, $count)
  633.     {
  634.         log_info("getlog" . print_r($recommend, true));
  635.         $qb = $this->productRepository->createQueryBuilder('p')
  636.             ->andWhere('p.Status = 1')
  637.             ->andWhere('p.published_at is NULL OR p.published_at <= :now')
  638.             ->setParameter('now', new \DateTime())
  639.         ;
  640.         $qb->andWhere($qb->expr()->in('p.id', $recommend));
  641.         $qb->innerJoin('p.ProductCategories', 'pct')
  642.             ->innerJoin('pct.Category', 'c')
  643.             ->addOrderBy('p.id', 'DESC')
  644.             ->groupBy('p.id');
  645.         $products = $qb
  646.             ->setMaxResults($count)
  647.             ->getQuery()
  648.             ->getResult();
  650.         return $products;
  651.     }
  653.     private function getProductsInCategories($shopCategory, $brandCategory)
  654.     {
  655.         $qb = $this->productRepository->createQueryBuilder('p')
  656.             ->andWhere('p.Status = 1')
  657.             ->andWhere('p.published_at is NULL OR p.published_at <= :now')
  658.             ->setParameter('now', new \DateTime());
  659.         $qb->innerJoin('p.ProductCategories', 'pct')
  660.             ->innerJoin('pct.Category', 'c')
  661.             ->andWhere($qb->expr()->in('pct.Category', ':Categories1'))
  662.             ->setParameter('Categories1', [$shopCategory])
  663.             ->innerJoin('p.ProductCategories', 'pct2')
  664.             ->innerJoin('pct.Category', 'c2')
  665.             ->andWhere($qb->expr()->in('pct2.Category', ':Categories2'))
  666.             ->setParameter('Categories2', [$brandCategory]);
  667.         $products = $qb->getQuery()
  668.             ->getResult();
  670.         if (count($products)) {
  671.             return $brandCategory;
  672.         }
  673.         return false;
  674.     }
  676.     private function getShopInfo($p_cat_id, $s_name, $b_cat_id)
  677.     {
  678.         $brands = [];
  679.         $products = $this->getProductsInCategory($p_cat_id, 20);
  680.         $shopCategory = $this->categoryRepository->find($p_cat_id);
  681.         foreach ($this->brandCategories as $brandCategory) {
  682.             $result = $this->getProductsInCategories($shopCategory, $brandCategory);
  683.             if ($result) {
  684.                 $brands[] = $result;
  685.             }
  686.         }
  687.         $newsList = $this->newsRepository->getListForShop(strtoupper($s_name));
  689.         $blogs = [];
  690.         $args = array(
  691.             'cat' => $b_cat_id,
  692.             'posts_per_page' => 5,
  693.             'orderby' => 'date',
  694.             'order' => 'DESC',
  695.         );
  696.         $the_query = new \WP_Query($args);
  697.         while ($the_query->have_posts()): $the_query->the_post();
  698.             $blogs[] = [
  699.                 'id' => get_the_ID(),
  700.                 'title' => get_the_title(),
  701.                 'content' => get_the_content(),
  702.                 'date' => get_the_date('Y.m.d'),
  703.                 'thumbnail' => get_the_post_thumbnail_url(),
  704.             ];
  705.         endwhile;
  707.         return [
  708.             'shop' => strtolower($s_name),
  709.             'Products' => $products,
  710.             'Brands' => $brands,
  711.             'NewsList' => $newsList,
  712.             'Blogs' => $blogs,
  713.         ];
  714.     }
  715. }