source: branches/version-2_13-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php @ 23120

Revision 23120, 6.1 KB checked in by undertree, 7 years ago (diff)

#2017 定数NOSTOCK_HIDDENがtrue時の不具合修正

  • Property svn:eol-style set to LF
  • Property svn:keywords set to Id
  • Property svn:mime-type set to text/x-httpd-php; charset=UTF-8
Line 
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
24require_once CLASS_EX_REALDIR . 'page_extends/mypage/LC_Page_AbstractMypage_Ex.php';
25
26/**
27 * MyPage のページクラス.
28 *
29 * @package Page
30 * @author LOCKON CO.,LTD.
31 * @version $Id$
32 */
33class LC_Page_Mypage_Favorite extends LC_Page_AbstractMypage_Ex
34{
35    /** ページナンバー */
36    var $tpl_pageno;
37
38    /**
39     * Page を初期化する.
40     *
41     * @return void
42     */
43    function init()
44    {
45        parent::init();
46        $this->tpl_subtitle = 'お気に入り一覧';
47        $this->tpl_mypageno = 'favorite';
48    }
49
50    /**
51     * Page のプロセス.
52     *
53     * @return void
54     */
55    function process()
56    {
57        parent::process();
58    }
59
60    /**
61     * Page のAction.
62     *
63     * @return void
64     */
65    function action()
66    {
67        $objCustomer = new SC_Customer_Ex();
68
69        $customer_id = $objCustomer->getValue('customer_id');
70
71        switch ($this->getMode()) {
72            case 'delete_favorite':
73                // お気に入り削除
74                $this->lfDeleteFavoriteProduct($customer_id, intval($_POST['product_id']));
75                break;
76
77            case 'getList':
78                // スマートフォン版のもっと見るボタン用
79                // ページ送り用
80                if (isset($_POST['pageno'])) {
81                    $this->tpl_pageno = intval($_POST['pageno']);
82                }
83                $this->arrFavorite = $this->lfGetFavoriteProduct($customer_id, $this);
84                SC_Product_Ex::setPriceTaxTo($this->arrFavorite);
85
86                echo SC_Utils_Ex::jsonEncode($this->arrFavorite);
87                SC_Response_Ex::actionExit();
88                break;
89
90            default:
91                break;
92        }
93
94        // ページ送り用
95        if (isset($_POST['pageno'])) {
96            $this->tpl_pageno = intval($_POST['pageno']);
97        }
98        $this->arrFavorite = $this->lfGetFavoriteProduct($customer_id, $this);
99        // 1ページあたりの件数
100        $this->dispNumber = SEARCH_PMAX;
101    }
102
103    /**
104     * お気に入りを取得する
105     *
106     * @param mixed $customer_id
107     * @param mixed $objPage
108     * @access private
109     * @return array お気に入り商品一覧
110     */
111    function lfGetFavoriteProduct($customer_id, &$objPage)
112    {
113        $objQuery       = SC_Query_Ex::getSingletonInstance();
114        $objProduct     = new SC_Product_Ex();
115
116        $objQuery->setOrder('f.create_date DESC');
117        $where = 'f.customer_id = ? and p.status = 1';
118        if (NOSTOCK_HIDDEN) {
119            $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = f.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';
120        }
121        $arrProductId  = $objQuery->getCol('f.product_id', 'dtb_customer_favorite_products f inner join dtb_products p using (product_id)', $where, array($customer_id));
122
123        $objQuery       =& SC_Query_Ex::getSingletonInstance();
124        $objQuery->setWhere($this->lfMakeWhere('alldtl.', $arrProductId));
125        $linemax        = $objProduct->findProductCount($objQuery);
126
127        $objPage->tpl_linemax = $linemax;   // 何件が該当しました。表示用
128
129        // ページ送りの取得
130        $objNavi        = new SC_PageNavi_Ex($objPage->tpl_pageno, $linemax, SEARCH_PMAX, 'eccube.movePage', NAVI_PMAX);
131        $this->tpl_strnavi = $objNavi->strnavi; // 表示文字列
132        $startno        = $objNavi->start_row;
133
134        $objQuery       =& SC_Query_Ex::getSingletonInstance();
135        //$objQuery->setLimitOffset(SEARCH_PMAX, $startno);
136        // 取得範囲の指定(開始行番号、行数のセット)
137        $arrProductId  = array_slice($arrProductId, $startno, SEARCH_PMAX);
138
139        $where = $this->lfMakeWhere('', $arrProductId);
140        $where .= ' AND del_flg = 0';
141        $objQuery->setWhere($where, $arrProductId);
142        $arrProducts = $objProduct->lists($objQuery);
143
144        //取得している並び順で並び替え
145        $arrProducts2 = array();
146        foreach ($arrProducts as $item) {
147            $arrProducts2[$item['product_id']] = $item;
148        }
149        $arrProductsList = array();
150        foreach ($arrProductId as $product_id) {
151            $arrProductsList[] = $arrProducts2[$product_id];
152        }
153
154        // 税込金額を設定する
155        SC_Product_Ex::setIncTaxToProducts($arrProductsList);
156
157        return $arrProductsList;
158    }
159
160    /* 仕方がない処理。。 */
161    function lfMakeWhere($tablename, $arrProductId)
162    {
163        // 取得した表示すべきIDだけを指定して情報を取得。
164        $where = '';
165        if (is_array($arrProductId) && !empty($arrProductId)) {
166            $where = $tablename . 'product_id IN (' . implode(',', $arrProductId) . ')';
167        } else {
168            // 一致させない
169            $where = '0<>0';
170        }
171
172        return $where;
173    }
174
175    // お気に入り商品削除
176    function lfDeleteFavoriteProduct($customer_id, $product_id)
177    {
178        $objQuery =& SC_Query_Ex::getSingletonInstance();
179
180        $exists = $objQuery->exists('dtb_customer_favorite_products', 'customer_id = ? AND product_id = ?', array($customer_id, $product_id));
181
182        if ($exists) {
183            $objQuery->delete('dtb_customer_favorite_products', 'customer_id = ? AND product_id = ?', array($customer_id, $product_id));
184        }
185    }
186}
Note: See TracBrowser for help on using the repository browser.