1 | <?php
|
---|
2 | /*
|
---|
3 | * This file is part of EC-CUBE
|
---|
4 | *
|
---|
5 | * Copyright(c) 2000-2013 LOCKON CO.,LTD. All Rights Reserved.
|
---|
6 | *
|
---|
7 | * http://www.lockon.co.jp/
|
---|
8 | *
|
---|
9 | * This program is free software; you can redistribute it and/or
|
---|
10 | * modify it under the terms of the GNU General Public License
|
---|
11 | * as published by the Free Software Foundation; either version 2
|
---|
12 | * of the License, or (at your option) any later version.
|
---|
13 | *
|
---|
14 | * This program is distributed in the hope that it will be useful,
|
---|
15 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
---|
16 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
---|
17 | * GNU General Public License for more details.
|
---|
18 | *
|
---|
19 | * You should have received a copy of the GNU General Public License
|
---|
20 | * along with this program; if not, write to the Free Software
|
---|
21 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
|
---|
22 | */
|
---|
23 |
|
---|
24 | // {{{ requires
|
---|
25 | require_once CLASS_EX_REALDIR . 'page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Ex.php';
|
---|
26 |
|
---|
27 | /**
|
---|
28 | * Recommend のページクラス.
|
---|
29 | *
|
---|
30 | * @package Page
|
---|
31 | * @author LOCKON CO.,LTD.
|
---|
32 | * @version $Id: LC_Page_FrontParts_Bloc_Best5 - Copy.php -1 $
|
---|
33 | */
|
---|
34 | class LC_Page_FrontParts_Bloc_Recommend extends LC_Page_FrontParts_Bloc_Ex {
|
---|
35 |
|
---|
36 | // }}}
|
---|
37 | // {{{ functions
|
---|
38 |
|
---|
39 | /**
|
---|
40 | * Page を初期化する.
|
---|
41 | *
|
---|
42 | * @return void
|
---|
43 | */
|
---|
44 | function init() {
|
---|
45 | parent::init();
|
---|
46 | }
|
---|
47 |
|
---|
48 | /**
|
---|
49 | * Page のプロセス.
|
---|
50 | *
|
---|
51 | * @return void
|
---|
52 | */
|
---|
53 | function process() {
|
---|
54 | $this->action();
|
---|
55 | $this->sendResponse();
|
---|
56 | }
|
---|
57 |
|
---|
58 | /**
|
---|
59 | * Page のアクション.
|
---|
60 | *
|
---|
61 | * @return void
|
---|
62 | */
|
---|
63 | function action() {
|
---|
64 |
|
---|
65 | // 基本情報を渡す
|
---|
66 | $objSiteInfo = SC_Helper_DB_Ex::sfGetBasisData();
|
---|
67 | $this->arrInfo = $objSiteInfo->data;
|
---|
68 |
|
---|
69 | //おすすめ商品表示
|
---|
70 | $this->arrBestProducts = $this->lfGetRanking();
|
---|
71 |
|
---|
72 |
|
---|
73 | }
|
---|
74 |
|
---|
75 | /**
|
---|
76 | * デストラクタ.
|
---|
77 | *
|
---|
78 | * @return void
|
---|
79 | */
|
---|
80 | function destroy() {
|
---|
81 | parent::destroy();
|
---|
82 | }
|
---|
83 |
|
---|
84 | /**
|
---|
85 | * おすすめ商品検索.
|
---|
86 | *
|
---|
87 | * @return array $arrBestProducts 検索結果配列
|
---|
88 | */
|
---|
89 | function lfGetRanking() {
|
---|
90 | $objQuery =& SC_Query_Ex::getSingletonInstance();
|
---|
91 | $objProduct = new SC_Product_Ex();
|
---|
92 |
|
---|
93 | // おすすめ商品取得
|
---|
94 | $col = 'T1.best_id, T1.category_id, T1.rank, T1.product_id, T1.title, T1.comment, T1.create_date, T1.update_date';
|
---|
95 | $table = 'dtb_best_products as T1 INNER JOIN dtb_products as T2 ON T1.product_id = T2.product_id';
|
---|
96 | $where = 'T1.del_flg = 0 and T2.status = 1';
|
---|
97 | if (NOSTOCK_HIDDEN) {
|
---|
98 | $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = T1.product_id AND dtb_products_class.del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';
|
---|
99 | }
|
---|
100 | $objQuery->setOrder('T1.rank');
|
---|
101 | $objQuery->setLimit(RECOMMEND_NUM);
|
---|
102 | $arrBestProducts = $objQuery->select($col, $table, $where);
|
---|
103 |
|
---|
104 | $objQuery =& SC_Query_Ex::getSingletonInstance();
|
---|
105 | if (count($arrBestProducts) > 0) {
|
---|
106 | // 商品一覧を取得
|
---|
107 | // where条件生成&セット
|
---|
108 | $arrProductId = array();
|
---|
109 | $where = 'product_id IN (';
|
---|
110 | foreach ($arrBestProducts as $key => $val) {
|
---|
111 | $arrProductId[] = $val['product_id'];
|
---|
112 | }
|
---|
113 | // 取得
|
---|
114 | $arrProductList = $objProduct->getListByProductIds($objQuery, $arrProductId);
|
---|
115 | // おすすめ商品情報にマージ
|
---|
116 | foreach ($arrBestProducts as $key => $value) {
|
---|
117 | $arrRow =& $arrBestProducts[$key];
|
---|
118 | if (isset($arrProductList[$arrRow['product_id']])) {
|
---|
119 | $arrRow = array_merge($arrRow, $arrProductList[$arrRow['product_id']]);
|
---|
120 | } else {
|
---|
121 | // 削除済み商品は除外
|
---|
122 | unset($arrBestProducts[$key]);
|
---|
123 | }
|
---|
124 | }
|
---|
125 | }
|
---|
126 | return $arrBestProducts;
|
---|
127 | }
|
---|
128 | }
|
---|