source: branches/feature-module-update/html/mypage/history.php @ 15079

Revision 15079, 3.2 KB checked in by nanasess, 17 years ago (diff)

svn:mime-type application/x-httpd-php; charset=UTF-8 設定

  • Property svn:mime-type set to application/x-httpd-php; charset=UTF-8
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7
8require_once("../require.php");
9
10class LC_Page {
11    function LC_Page() {
12        $this->tpl_mainpage = USER_PATH . 'templates/mypage/history.tpl';
13        $this->tpl_title = "MYページ/購入履歴詳細";
14        $this->tpl_navi = USER_PATH . 'templates/mypage/navi.tpl';
15        $this->tpl_mainno = 'mypage';
16        $this->tpl_mypageno = 'index';
17        session_cache_limiter('private-no-expire');
18    }
19}
20
21$objPage = new LC_Page();
22$objView = new SC_SiteView();
23$objQuery = new SC_Query();
24$objCustomer = new SC_Customer();
25
26// レイアウトデザインを取得
27$objPage = sfGetPageLayout($objPage, false, "mypage/index.php");
28
29//不正アクセス判定
30$from = "dtb_order";
31$where = "del_flg = 0 AND customer_id = ? AND order_id = ? ";
32$arrval = array($objCustomer->getValue('customer_id'), $_POST['order_id']);
33//DBに情報があるか判定
34$cnt = $objQuery->count($from, $where, $arrval);
35//ログインしていない、またはDBに情報が無い場合
36if (!$objCustomer->isLoginSuccess() || $cnt == 0){
37    sfDispSiteError(CUSTOMER_ERROR);
38} else {
39    //受注詳細データの取得
40    $objPage->arrDisp = lfGetOrderData($_POST['order_id']);
41    // 支払い方法の取得
42    $objPage->arrPayment = sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
43    // 配送時間の取得
44    $arrRet = sfGetDelivTime($objPage->arrDisp['payment_id']);
45    $objPage->arrDelivTime = sfArrKeyValue($arrRet, 'time_id', 'deliv_time');
46
47    //マイページトップ顧客情報表示用
48    $objPage->CustomerName1 = $objCustomer->getvalue('name01');
49    $objPage->CustomerName2 = $objCustomer->getvalue('name02');
50    $objPage->CustomerPoint = $objCustomer->getvalue('point');
51}
52
53$objPage->arrPref = $arrPref;
54
55$objView->assignobj($objPage);
56$objView->display(SITE_FRAME);
57//-----------------------------------------------------------------------------------------------------------------------------------
58
59//受注詳細データの取得
60function lfGetOrderData($order_id) {
61    //受注番号が数字であれば
62    if(sfIsInt($order_id)) {
63        // DBから受注情報を読み込む
64        $objQuery = new SC_Query();
65        $col = "order_id, create_date, payment_id, subtotal, tax, use_point, add_point, discount, ";
66        $col .= "deliv_fee, charge, payment_total, deliv_name01, deliv_name02, deliv_kana01, deliv_kana02, ";
67        $col .= "deliv_zip01, deliv_zip02, deliv_pref, deliv_addr01, deliv_addr02, deliv_tel01, deliv_tel02, deliv_tel03, deliv_time_id, deliv_date ";
68        $from = "dtb_order";
69        $where = "order_id = ?";
70        $arrRet = $objQuery->select($col, $from, $where, array($order_id));
71        $arrOrder = $arrRet[0];
72        // 受注詳細データの取得
73        $arrRet = lfGetOrderDetail($order_id);
74        $arrOrderDetail = sfSwapArray($arrRet);
75        $arrData = array_merge($arrOrder, $arrOrderDetail);
76    }
77    return $arrData;
78}
79
80// 受注詳細データの取得
81function lfGetOrderDetail($order_id) {
82    $objQuery = new SC_Query();
83    $col = "product_id, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate";
84    $where = "order_id = ?";
85    $objQuery->setorder("classcategory_id1, classcategory_id2");
86    $arrRet = $objQuery->select($col, "dtb_order_detail", $where, array($order_id));
87    return $arrRet;
88}
89
90?>
Note: See TracBrowser for help on using the repository browser.