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:10 [▼
"mode" => null
"name" => null
"pageno" => "3"
"disp_number" => Eccube\Entity\Master\ProductListMax {#4266 ▶
#id: 20
#name: "15件"
#sort_no: 0
}
"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, d0_.discriminator_type AS discriminator_type_12, d0_.creator_id AS creator_id_13, d0_.product_status_id AS product_status_id_14 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.id DESC ◀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_.s ▶"