source: temp/trunk/html/rss/product.php @ 6536

<?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 = "rss/product.tpl";
        $this->encode = "UTF-8";
        ($_GET['product_id'] == "") ? $this->title = "¾¦ÉÊ°ìÍ÷¾ðÊó" : $this->title = "¾¦ÉʾܺپðÊó";
    }
}

$objQuery = new SC_Query();
$objPage = new LC_Page();
$objView = new SC_SiteView();
$objSiteInfo = new SC_SiteInfo();

//¾¦ÉÊID¤ò¼èÆÀ
$product_id = $_GET['product_id'];

if($product_id != ""){
    //¾¦Éʾܺ٤ò¼èÆÀ
    $arrProduct = lfGetProductsDetail($objQuery, $product_id);
    
    // ÃͤΥ»¥Ã¥È¤·Ä¾¤·
    foreach($arrProduct as $key => $val){
        
        // ²èÁü¥Õ¥¡¥¤¥ë¤ÎURL¥»¥Ã¥È
        (file_exists(IMAGE_SAVE_URL . $arrProduct[$key]["main_list_image"])) ? $dir = IMAGE_TEMP_DIR : $dir = IMAGE_TEMP_URL;
        $arrProduct[$key]["main_list_image"] = $dir . $arrProduct[$key]["main_list_image"];
        (file_exists(IMAGE_SAVE_URL . $arrProduct[$key]["main_image"])) ? $dir = IMAGE_SAVE_URL : $dir = IMAGE_TEMP_URL;
        $arrProduct[$key]["main_image"] = IMAGE_SAVE_URL . $arrProduct[$key]["main_image"];
        (file_exists(IMAGE_SAVE_URL . $arrProduct[$key]["main_large_image"])) ? $dir = IMAGE_SAVE_URL : $dir = IMAGE_TEMP_URL;
        $arrProduct[$key]["main_large_image"] = IMAGE_SAVE_URL . $arrProduct[$key]["main_large_image"];
    }
    
    sfprintr($arrProduct);exit();
}else{
    //¾¦ÉÊ°ìÍ÷¤ò¼èÆÀ
    $arrProduct = $objQuery->getall("SELECT product_id, name AS product_name FROM dtb_products");
}

//ŹÊÞ¾ðÊó¤ò¥»¥Ã¥È
$objPage->arrSiteInfo = $objSiteInfo->data;

//¾¦ÉʾðÊó¤ò¥»¥Ã¥È
$objPage->arrProduct = $arrProduct;
$objPage->arrProductKeys = array_keys(sfswaparray($arrProduct));

//¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ
$objView->assignobj($objPage);

//¥­¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á)
header("Paragrama: no-cache");

//XML¥Æ¥­¥¹¥È(¤³¤ì¤¬¤Ê¤¤¤ÈÀµ¾ï¤ËRSS¤È¤·¤Æǧ¼±¤·¤Æ¤¯¤ì¤Ê¤¤¥Ä¡¼¥ë¤¬¤¢¤ë¤¿¤á)
header("Content-type: application/xml");
DETAIL_P_HTML;

//²èÌÌɽ¼¨
$objView->display($objPage->tpl_mainpage, true);

//---------------------------------------------------------------------------------------------------------------------
/**************************************************************************************************************
 * ´Ø¿ô̾:lfGetProducts
 * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë
 * °ú¿ô£±:$objQuery     DBÁàºî¥¯¥é¥¹
 * °ú¿ô£²:$product_id   ¾¦ÉÊID
 * Ìá¤êÃÍ:$arrProduct   ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹
 **************************************************************************************************************/
function lfGetProductsDetail($objQuery, $product_id){
    $sql = "";
    $sql .= "SELECT ";
    $sql .= "   prod.product_id ";
    $sql .= "   ,prod.name AS product_name ";
    $sql .= "   ,prod.category_id ";
    $sql .= "   ,prod.point_rate ";
    $sql .= "   ,prod.comment3 ";
    $sql .= "   ,prod.main_list_comment ";
    $sql .= "   ,prod.main_list_image ";
    $sql .= "   ,prod.main_comment ";
    $sql .= "   ,prod.main_image ";
    $sql .= "   ,prod.main_large_image ";
    $sql .= "   ,cls.price01 ";
    $sql .= "   ,cls.price02 ";
    $sql .= "   ,cls.classcategory_id1 ";
    $sql .= "   ,cls.classcategory_id2 ";
    $sql .= "   ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id1) AS classcategory_name1 ";
    $sql .= "   ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id2) AS classcategory_name2 ";
    $sql .= "   ,(SELECT category_name FROM dtb_category AS cat WHERE cat.category_id = prod.category_id) AS category_name";
    $sql .= " FROM dtb_products AS prod, dtb_products_class AS cls";
    $sql .= " WHERE prod.product_id = cls.product_id AND prod.del_flg = 0 AND prod.status = 1";
    
    if($product_id != "ALL"){
        $sql .= " AND prod.product_id = ?";
        $arrval = array($product_id);
    }
    $sql .= " ORDER BY prod.product_id, cls.classcategory_id1, cls.classcategory_id2";
    $arrProduct = $objQuery->getall($sql, $arrval);
    return $arrProduct;
}

?>