Dumped Contents
In
ProductController.php
line 147:
/* @var $searchForm \Symfony\Component\Form\FormInterface */ $searchForm = $builder->getForm(); dump($searchForm->getData()); $searchForm->handleRequest($request);
null
In
ProductController.php
line 151:
$searchForm->handleRequest($request); dump($searchForm->getData()); // paginatorの前に全商品の取得 $searchData = $searchForm->getData();
array:12 [
"mode" => null
"category_id" => null
"name" => null
"pageno" => "73"
"disp_number" => Eccube\Entity\Master\ProductListMax {#4266
#id: 20
#name: "15件"
#sort_no: 0
}
"orderby" => Eccube\Entity\Master\ProductListOrderBy {#4260
#id: 3
#name: "価格が高い順"
#sort_no: 1
}
"tag_id" => null
"tag_id2" => null
"category_id2" => null
"category_id3" => null
"category_id4" => null
"category_id5" => null
]
In
ProductController.php
line 156:
// paginatorの前に全商品の取得 $searchData = $searchForm->getData(); $qb = $this->productRepository->getQueryBuilderBySearchData($searchData); dump($qb->getQuery()->getSQL()); //exit; $event = new EventArgs( [
"SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.free_description_about_quantity AS free_description_about_quantity_9, d0_.free_description_about_selling_price AS free_description_about_selling_price_10, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_11, MAX(d1_.price02) AS sclr_12, d0_.discriminator_type AS discriminator_type_13, d0_.creator_id AS creator_id_14, d0_.product_status_id AS product_status_id_15 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d1_.visible = 1) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_12 DESC, d0_.id DESC"