- Timestamp:
- 2009/11/08 23:05:44 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/pages/products/LC_Page_Products_Detail.php
r18325 r18374 267 267 //関連商品情報表示 268 268 $this->arrRecommend = $this->lfPreGetRecommendProducts($product_id); 269 //この商品を買った人はこんな商品も買っています270 $this->arrRelateProducts = $this->lfGetRelateProducts($product_id);271 269 272 270 $this->lfConvertParam(); … … 461 459 //関連商品情報表示 462 460 $this->arrRecommend = $this->lfPreGetRecommendProducts($product_id); 463 //この商品を買った人はこんな商品も買っています464 $this->arrRelateProducts = $this->lfGetRelateProducts($product_id);465 461 466 462 $objView->assignobj($this); … … 693 689 } 694 690 695 //この商品を買った人はこんな商品も買っています FIXME696 function lfGetRelateProducts($product_id) {697 $objQuery = new SC_Query;698 //自動抽出699 $objQuery->setorder("random()");700 //表示件数の制限701 $objQuery->setlimit(RELATED_PRODUCTS_MAX);702 //検索条件703 $col = "name, main_list_image, price01_min, price02_min, price01_max, price02_max, point_rate";704 $from = "vw_products_allclass AS allcls ";705 $where = "del_flg = 0 AND status = 1 AND (stock_max <> 0 OR stock_max IS NULL) AND product_id = ? ";706 $arrval[] = $product_id;707 //結果の取得708 $arrProducts = $objQuery->select($col, $from, $where, $arrval);709 710 return $arrProducts;711 }712 713 691 //商品ごとのレビュー情報を取得する 714 692 function lfGetReviewData($id) {
Note: See TracChangeset
for help on using the changeset viewer.