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:11 [
"mode" => null
"name" => null
"pageno" => "1"
"disp_number" => Eccube\Entity\Master\ProductListMax {#4266
#id: 20
#name: "15件"
#sort_no: 0
}
"orderby" => Eccube\Entity\Master\ProductListOrderBy {#7705
#id: 2
#name: "新着順"
#sort_no: 2
}
"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_.create_date DESC, d0_.id DESC"