source: branches/dev/html/mypage/history.php @ 8

<?php
/*
 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */

require_once("../require.php");

class LC_Page {
    function LC_Page() {
        $this->tpl_mainpage = USER_PATH . 'templates/mypage/history.tpl';
        $this->tpl_title = "MY¥Ú¡¼¥¸/¹ØÆþÍúÎò¾ÜºÙ";
        $this->tpl_navi = USER_PATH . 'templates/mypage/navi.tpl';
        $this->tpl_mainno = 'mypage';
        $this->tpl_mypageno = 'index';
        session_cache_limiter('private-no-expire');
    }
}

$objPage = new LC_Page();
$objView = new SC_SiteView();
$objQuery = new SC_Query();
$objCustomer = new SC_Customer();

// ¥ì¥¤¥¢¥¦¥È¥Ç¥¶¥¤¥ó¤ò¼èÆÀ
$objPage = sfGetPageLayout($objPage, false, "mypage/index.php");

//ÉÔÀµ¥¢¥¯¥»¥¹È½Äê
$from = "dtb_order";
$where = "del_flg = 0 AND customer_id = ? AND order_id = ? ";
$arrval = array($objCustomer->getValue('customer_id'), $_POST['order_id']);
//DB¤Ë¾ðÊ󤬤¢¤ë¤«È½Äê
$cnt = $objQuery->count($from, $where, $arrval);
//¥í¥°¥¤¥ó¤·¤Æ¤¤¤Ê¤¤¡¢¤Þ¤¿¤ÏDB¤Ë¾ðÊó¤¬Ìµ¤¤¾ì¹ç
if (!$objCustomer->isLoginSuccess() || $cnt == 0){
    sfDispSiteError(CUSTOMER_ERROR);
} else {
    //¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
    $objPage->arrDisp = lfGetOrderData($_POST['order_id']);
    // »Ùʧ¤¤ÊýË¡¤Î¼èÆÀ
    $objPage->arrPayment = sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
    // ÇÛÁ÷»þ´Ö¤Î¼èÆÀ
    $arrRet = sfGetDelivTime($objPage->arrDisp['payment_id']);
    $objPage->arrDelivTime = sfArrKeyValue($arrRet, 'time_id', 'deliv_time');

    //¥Þ¥¤¥Ú¡¼¥¸¥È¥Ã¥×¸ÜµÒ¾ðÊóɽ¼¨ÍÑ
    $objPage->CustomerName1 = $objCustomer->getvalue('name01');
    $objPage->CustomerName2 = $objCustomer->getvalue('name02');
    $objPage->CustomerPoint = $objCustomer->getvalue('point');
}

$objView->assignobj($objPage);
$objView->display(SITE_FRAME);
//-----------------------------------------------------------------------------------------------------------------------------------

//¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
function lfGetOrderData($order_id) {
    //¼õÃíÈֹ椬¿ô»ú¤Ç¤¢¤ì¤Ð
    if(sfIsInt($order_id)) {
        // DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
        $objQuery = new SC_Query();
        $col = "order_id, create_date, payment_id, subtotal, tax, use_point, add_point, discount, ";
        $col .= "deliv_fee, charge, payment_total, deliv_name01, deliv_name02, deliv_kana01, deliv_kana02, ";
        $col .= "deliv_zip01, deliv_zip02, deliv_pref, deliv_addr01, deliv_addr02, deliv_tel01, deliv_tel02, deliv_tel03, deliv_time_id, deliv_date ";
        $from = "dtb_order";
        $where = "order_id = ?";
        $arrRet = $objQuery->select($col, $from, $where, array($order_id));
        $arrOrder = $arrRet[0];
        // ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
        $arrRet = lfGetOrderDetail($order_id);
        $arrOrderDetail = sfSwapArray($arrRet);
        $arrData = array_merge($arrOrder, $arrOrderDetail);
    }
    return $arrData;
}

// ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
function lfGetOrderDetail($order_id) {
    $objQuery = new SC_Query();
    $col = "product_id, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate";
    $where = "order_id = ?";
    $objQuery->setorder("classcategory_id1, classcategory_id2");
    $arrRet = $objQuery->select($col, "dtb_order_detail", $where, array($order_id));
    return $arrRet;
}

?>