File Source for LC_Page_Rss

<?php
/*
* This file is part of EC-CUBE
*
* Copyright(c) 2000-2011 LOCKON CO.,LTD. All Rights Reserved.
*
* http://www.lockon.co.jp/
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/
// {{{ requires
require_once CLASS_EX_REALDIR . 'page_extends/LC_Page_Ex.php';
/**
* RSS(商品) のページクラス.
*
* @package Page
* @author LOCKON CO.,LTD.
* @version $Id: LC_Page_Rss_Products.php 21256 2011-09-25 04:15:51Z Seasoft $
*/
class LC_Page_Rss_Products extends LC_Page_Ex {
// }}}
// {{{ functions
/**
* Page を初期化する.
*
* @return void
*/
function init() {
parent::init();
$this->tpl_mainpage = "rss/products.tpl";
$this->encode = "UTF-8";
$this->title = "商品一覧情報";
}
/**
* Page のプロセス.
*
* @return void
*/
function process() {
$this->action();
}
/**
* Page のアクション.
*
* @return void
*/
function action() {
$objView = new SC_SiteView_Ex();
//店舗情報をセット
$this->arrSiteInfo = SC_Helper_DB_Ex::sfGetBasisData();
//商品IDを取得
if ( isset($_GET['product_id']) && $_GET['product_id'] != '' && is_numeric($_GET['product_id']) ) {
$product_id = $_GET['product_id'];
} else {
$product_id = '';
}
// モードによって分岐
$mode = $this->getMode();
switch ($mode) {
case 'all':
$arrProduct = $this->lfGetProductsDetailData($mode, $product_id);
break;
case 'list':
if ( $product_id != '' && is_numeric($product_id) ) {
$arrProduct = $this->lfGetProductsDetailData($mode, $product_id);
} else {
$arrProduct = $this->lfGetProductsListData();
}
break;
default:
if ( $product_id != '' && is_numeric($product_id) ) {
$arrProduct = $this->lfGetProductsDetailData($mode, $product_id);
} else {
$arrProduct = $this->lfGetProductsAllData();
}
break;
}
// 商品情報をセット
$this->arrProduct = $arrProduct;
$this->arrProductKeys = $this->lfGetProductKeys($arrProduct);
//セットしたデータをテンプレートファイルに出力
$objView->assignobj($this);
//キャッシュしない(念のため)
header("Pragma: no-cache");
//XMLテキスト(これがないと正常にRSSとして認識してくれないツールがあるため)
header("Content-type: application/xml");
P_DETAIL_URLPATH;
//画面表示
$objView->display($this->tpl_mainpage, true);
}
/**
* デストラクタ.
*
* @return void
*/
function destroy() {
parent::destroy();
}
/**
* lfGetProductsDetailData.
*
* @param str $mode モード
* @param str $product_id 商品ID
* @return array $arrProduct 商品情報の配列を返す
*/
function lfGetProductsDetailData($mode, $product_id) {
$objQuery = SC_Query_Ex::getSingletonInstance();
//商品詳細を取得
if ( $mode == 'all' ) {
$arrProduct = $this->lfGetProductsDetail($objQuery, $mode);
} else {
$arrProduct = $this->lfGetProductsDetail($objQuery, $product_id);
}
// 値の整形
foreach ($arrProduct as $key => $val) {
//販売価格を税込みに編集
$arrProduct[$key]['price02'] = SC_Helper_DB_Ex::sfCalcIncTax($arrProduct[$key]['price02']);
// 画像ファイルのURLセット
if ( file_exists(IMAGE_SAVE_REALDIR . $arrProduct[$key]['main_list_image']) ) {
$dir = IMAGE_SAVE_RSS_URL;
} else {
$dir = IMAGE_TEMP_RSS_URL;
}
$arrProduct[$key]['main_list_image'] = $dir . $arrProduct[$key]['main_list_image'];
if ( file_exists(IMAGE_SAVE_REALDIR . $arrProduct[$key]['main_image']) ){
$dir = IMAGE_SAVE_RSS_URL;
} else {
$dir = IMAGE_TEMP_RSS_URL;
}
$arrProduct[$key]['main_image'] = $dir . $arrProduct[$key]['main_image'];
if ( file_exists(IMAGE_SAVE_REALDIR . $arrProduct[$key]['main_large_image']) ) {
$dir = IMAGE_SAVE_RSS_URL;
} else {
$dir = IMAGE_TEMP_RSS_URL;
}
$arrProduct[$key]['main_large_image'] = $dir . $arrProduct[$key]['main_large_image'];
// ポイント計算
$arrProduct[$key]['point'] = SC_Utils_Ex::sfPrePoint(
$arrProduct[$key]['price02'],
$arrProduct[$key]['point_rate']
);
// 在庫無制限
if ( $arrProduct[$key]['stock_unlimited'] == 1 ) {
$arrProduct[$key]['stock_unlimited'] = '在庫無制限';
} else {
$arrProduct[$key]['stock_unlimited'] = NULL;
}
}
return $arrProduct;
}
/**
* lfGetProductsListData.
*
* @return array $arrProduct 商品情報の配列を返す
*/
function lfGetProductsListData() {
$objQuery = SC_Query_Ex::getSingletonInstance();
//商品一覧を取得
$arrProduct = $objQuery->getAll('SELECT product_id, name AS product_name FROM dtb_products');
return $arrProduct;
}
/**
* lfGetProductsAllData.
*
* @return array $arrProduct 商品情報の配列を返す
*/
function lfGetProductsAllData() {
$objQuery = SC_Query_Ex::getSingletonInstance();
//商品情報を取得
$arrProduct = $this->lfGetProductsAllclass($objQuery);
// 値の整形
foreach ($arrProduct as $key => $val) {
//販売価格を税込みに編集
$arrProduct[$key]['price02_max'] = SC_Helper_DB_Ex::sfCalcIncTax($arrProduct[$key]['price02_max']);
$arrProduct[$key]['price02_min'] = SC_Helper_DB_Ex::sfCalcIncTax($arrProduct[$key]['price02_min']);
// 画像ファイルのURLセット
if ( file_exists(IMAGE_SAVE_REALDIR . $arrProduct[$key]['main_list_image']) ) {
$dir = IMAGE_SAVE_RSS_URL;
} else {
$dir = IMAGE_TEMP_RSS_URL;
}
$arrProduct[$key]['main_list_image'] = $dir . $arrProduct[$key]['main_list_image'];
if ( file_exists(IMAGE_SAVE_REALDIR . $arrProduct[$key]['main_image']) ) {
$dir = IMAGE_SAVE_RSS_URL;
} else {
$dir = IMAGE_TEMP_RSS_URL;
}
$arrProduct[$key]['main_image'] = $dir . $arrProduct[$key]['main_image'];
if ( file_exists(IMAGE_SAVE_REALDIR . $arrProduct[$key]['main_large_image']) ) {
$dir = IMAGE_SAVE_RSS_URL;
} else {
$dir = IMAGE_TEMP_RSS_URL;
}
$arrProduct[$key]['main_large_image'] = $dir . $arrProduct[$key]['main_large_image'];
// ポイント計算
$arrProduct[$key]['point_max'] = SC_Utils_Ex::sfPrePoint(
$arrProduct[$key]['price02_max'],
$arrProduct[$key]['point_rate']
);
$arrProduct[$key]['point_min'] = SC_Utils_Ex::sfPrePoint(
$arrProduct[$key]['price02_min'],
$arrProduct[$key]['point_rate']
);
}
return $arrProduct;
}
/**
* 商品情報を取得する
*
* @param SC_Query $objQuery DB操作クラス
* @param integer $product_id 商品ID
* @return array $arrProduct 取得結果を配列で返す
*/
function lfGetProductsDetail(&$objQuery, $product_id = 'all'){
$objProduct = new SC_Product_Ex();
// --- 商品詳細の取得
if ($product_id == 'all') {
$objQuery->setOrder('product_id');
$arrProductLsit = $objProduct->lists($objQuery);
} else {
$arrProductLsit = $objProduct->getListByProductIds($objQuery, $product_id);
}
// 各商品のカテゴリIDとランクの取得
$arrProduct = array();
foreach( $arrProductLsit as $key => $val ) {
$sql = '';
$sql .= ' SELECT';
$sql .= ' T1.category_id,';
$sql .= ' T1.rank AS product_rank,';
$sql .= ' T2.rank AS category_rank';
$sql .= ' FROM';
$sql .= ' dtb_product_categories AS T1';
$sql .= ' LEFT JOIN';
$sql .= ' dtb_category AS T2';
$sql .= ' ON';
$sql .= ' T1.category_id = T2.category_id';
$sql .= ' WHERE';
$sql .= ' product_id = ?';
$arrCategory = $objQuery->getAll($sql, array($val['product_id']));
if ( !empty($arrCategory) ) {
$arrProduct[$key] = array_merge($val, $arrCategory[0]);
}
}
return $arrProduct;
}
/**
* 商品情報を取得する(vw_products_allclass使用)
*
* @param SC_Query $objQuery DB操作クラス
* @return array $arrProduct 取得結果を配列で返す
*/
function lfGetProductsAllclass(&$objQuery){
// --- 商品一覧の取得
$objQuery->setOrder('product_id');
$objProduct = new SC_Product_Ex();
$arrProductLsit = $objProduct->lists($objQuery);
// 各商品のカテゴリIDとランクの取得
$arrProduct = array();
foreach( $arrProductLsit as $key => $val ) {
$sql = '';
$sql .= ' SELECT';
$sql .= ' T1.category_id,';
$sql .= ' T1.rank AS product_rank,';
$sql .= ' T2.rank AS category_rank';
$sql .= ' FROM';
$sql .= ' dtb_product_categories AS T1';
$sql .= ' LEFT JOIN';
$sql .= ' dtb_category AS T2';
$sql .= ' ON';
$sql .= ' T1.category_id = T2.category_id';
$sql .= ' WHERE';
$sql .= ' product_id = ?';
$arrCategory = $objQuery->getAll($sql, array($val['product_id']));
if ( !empty($arrCategory) ) {
$arrProduct[$key] = array_merge($val, $arrCategory[0]);
}
}
return $arrProduct;
}
/**
* lfGetProductKeys.
*
* @param array $arrProduct 商品データ配列
* @return array $arrProductKeys 商品情報のkey配列を返す
*/
function lfGetProductKeys($arrProduct) {
$arrProductKeys = array();
$arrProduct = SC_Utils_Ex::sfSwapArray($arrProduct);
if ( is_array($arrProduct) ) {
$arrProductKeys = array_keys($arrProduct);
}
return $arrProductKeys;
}
}
?>

Source for file LC_Page_Rss_Products.php