source: branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_History.php @ 18276

Revision 18276, 8.0 KB checked in by Seasoft, 11 years ago (diff)

不要パラメータの削除

  • SC_Utils#sfDispSiteError 第5パラメータ
  • SC_Utils#sfIsPrePage 第2パラメータ
  • Property svn:eol-style set to LF
  • Property svn:keywords set to Id Revision Date
  • 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-2007 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
25require_once(CLASS_PATH . "pages/LC_Page.php");
26
27/**
28 * 購入履歴 のページクラス.
29 *
30 * @package Page
31 * @author LOCKON CO.,LTD.
32 * @version $Id$
33 */
34class LC_Page_Mypage_History extends LC_Page {
35
36    // }}}
37    // {{{ functions
38
39    /**
40     * Page を初期化する.
41     *
42     * @return void
43     */
44    function init() {
45        parent::init();
46        $this->tpl_mainpage = TEMPLATE_DIR . 'mypage/history.tpl';
47        $this->tpl_title = 'MYページ';
48        $this->tpl_subtitle = '購入履歴詳細';
49        $this->tpl_navi = TEMPLATE_DIR . 'mypage/navi.tpl';
50        $this->tpl_column_num = 1;
51        $this->tpl_mainno = 'mypage';
52        $this->tpl_mypageno = 'index';
53        $this->httpCacheControl('nocache');
54        $masterData = new SC_DB_MasterData_Ex();
55        $this->arrMAILTEMPLATE = $masterData->getMasterData("mtb_mail_template");
56   }
57
58    /**
59     * Page のプロセス.
60     *
61     * @return void
62     */
63    function process() {
64        $objView = new SC_SiteView();
65        $objQuery = new SC_Query();
66        $objCustomer = new SC_Customer();
67        $objDb = new SC_Helper_DB_Ex();
68
69        // レイアウトデザインを取得
70        $objLayout = new SC_Helper_PageLayout_Ex();
71        $objLayout->sfGetPageLayout($this, false, "mypage/index.php");
72
73        //不正アクセス判定
74        $from = "dtb_order";
75        $where = "del_flg = 0 AND customer_id = ? AND order_id = ? ";
76        $arrval = array($objCustomer->getValue('customer_id'), $_GET['order_id']);
77        //DBに情報があるか判定
78        $cnt = $objQuery->count($from, $where, $arrval);
79        //ログインしていない、またはDBに情報が無い場合
80        if (!$objCustomer->isLoginSuccess() || $cnt == 0){
81            SC_Utils_Ex::sfDispSiteError(CUSTOMER_ERROR);
82        } else {
83            //受注詳細データの取得
84            $this->arrDisp = $this->lfGetOrderData($_GET['order_id']);
85            // 支払い方法の取得
86            $this->arrPayment = $objDb->sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
87            // お届け時間の取得
88            $arrRet = $objDb->sfGetDelivTime($this->arrDisp['payment_id']);
89            $this->arrDelivTime = SC_Utils_Ex::sfArrKeyValue($arrRet, 'time_id', 'deliv_time');
90
91            //マイページトップ顧客情報表示用
92            $this->CustomerName1 = $objCustomer->getvalue('name01');
93            $this->CustomerName2 = $objCustomer->getvalue('name02');
94            $this->CustomerPoint = $objCustomer->getvalue('point');
95        }
96
97        if(SC_Utils_Ex::sfIsInt($_GET['order_id'])) {
98            $col = "send_date, subject, template_id, send_id";
99            $where = "order_id = ?";
100            $objQuery->setorder("send_date DESC");
101            $this->arrMailHistory = $objQuery->select($col, "dtb_mail_history", $where, array($_GET['order_id']));
102        }
103
104        $masterData = new SC_DB_MasterData_Ex();
105        $this->arrPref = $masterData->getMasterData("mtb_pref",
106                                 array("pref_id", "pref_name", "rank"));
107        $objView->assignobj($this);
108        $objView->display(SITE_FRAME);
109    }
110
111    /**
112     * デストラクタ.
113     *
114     * @return void
115     */
116    function destroy() {
117        parent::destroy();
118    }
119
120    /**
121     * モバイルページを初期化する.
122     *
123     * @return void
124     */
125    function mobileInit() {
126        $this->tpl_mainpage = MOBILE_TEMPLATE_DIR . 'mypage/history.tpl';
127        $this->tpl_title = 'MYページ/購入履歴一覧';
128        $this->httpCacheControl('nocache');
129    }
130
131    /**
132     * Page のプロセス(モバイル).
133     *
134     * @return void
135     */
136    function mobileProcess() {
137        define ("HISTORY_NUM", 5);
138
139        $objView = new SC_MobileView();
140        $objQuery = new SC_Query();
141        $objCustomer = new SC_Customer();
142        $pageNo = isset($_GET['pageno']) ? (int) $_GET['pageno'] : 0; // TODO
143
144        // ログインチェック
145        if(!isset($_SESSION['customer'])) {
146            SC_Utils_Ex::sfDispSiteError(CUSTOMER_ERROR);
147        }
148
149        $col = "order_id, create_date, payment_id, payment_total";
150        $from = "dtb_order";
151        $where = "del_flg = 0 AND customer_id=?";
152        $arrval = array($objCustomer->getvalue('customer_id'));
153        $order = "order_id DESC";
154
155        $linemax = $objQuery->count($from, $where, $arrval);
156        $this->tpl_linemax = $linemax;
157
158        // 取得範囲の指定(開始行番号、行数のセット)
159        $objQuery->setlimitoffset(HISTORY_NUM, $pageNo);
160        // 表示順序
161        $objQuery->setorder($order);
162
163        //購入履歴の取得
164        $this->arrOrder = $objQuery->select($col, $from, $where, $arrval);
165
166        // next
167        if ($pageNo + HISTORY_NUM < $linemax) {
168            $next = "<a href='history.php?pageno=" . ($pageNo + HISTORY_NUM) . "'>次へ→</a>";
169        } else {
170            $next = "";
171        }
172
173        // previous
174        if ($pageNo - HISTORY_NUM > 0) {
175            $previous = "<a href='history.php?pageno=" . ($pageNo - HISTORY_NUM) . "'>←前へ</a>";
176        } elseif ($pageNo == 0) {
177            $previous = "";
178        } else {
179            $previous = "<a href='history.php?pageno=0'>←前へ</a>";
180        }
181
182        // bar
183        if ($next != '' && $previous != '') {
184            $bar = " | ";
185        } else {
186            $bar = "";
187        }
188
189        $this->tpl_strnavi = $previous . $bar . $next;
190        $objView->assignobj($this);             //$objpage内の全てのテンプレート変数をsmartyに格納
191        $objView->display(SITE_FRAME);              //パスとテンプレート変数の呼び出し、実行
192    }
193
194    //受注詳細データの取得
195    function lfGetOrderData($order_id) {
196        //注文番号が数字であれば
197        if(SC_Utils_Ex::sfIsInt($order_id)) {
198            // DBから受注情報を読み込む
199            $objQuery = new SC_Query();
200            $col = "order_id, create_date, payment_id, subtotal, tax, use_point, add_point, discount, ";
201            $col .= "deliv_fee, charge, payment_total, deliv_name01, deliv_name02, deliv_kana01, deliv_kana02, ";
202            $col .= "deliv_zip01, deliv_zip02, deliv_pref, deliv_addr01, deliv_addr02, deliv_tel01, deliv_tel02, deliv_tel03, deliv_time_id, deliv_date ";
203            $from = "dtb_order";
204            $where = "order_id = ?";
205            $arrRet = $objQuery->select($col, $from, $where, array($order_id));
206            $arrOrder = $arrRet[0];
207            // 受注詳細データの取得
208            $arrRet = $this->lfGetOrderDetail($order_id);
209            $arrOrderDetail = SC_Utils_Ex::sfSwapArray($arrRet);
210            $arrData = array_merge($arrOrder, $arrOrderDetail);
211        }
212        return $arrData;
213    }
214
215    // 受注詳細データの取得
216    function lfGetOrderDetail($order_id) {
217        $objQuery = new SC_Query();
218        $col = "product_id, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate";
219        $where = "order_id = ?";
220        $objQuery->setorder("classcategory_id1, classcategory_id2");
221        $arrRet = $objQuery->select($col, "dtb_order_detail", $where, array($order_id));
222        return $arrRet;
223    }
224}
225?>
Note: See TracBrowser for help on using the repository browser.