File Source for LC_Page_Products

<?php
/*
* This file is part of EC-CUBE
*
* Copyright(c) 2000-2010 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_PATH . "pages/LC_Page.php");
/**
* お客様の声投稿のページクラス.
*
* @package Page
* @author LOCKON CO.,LTD.
* @version $Id:LC_Page_Products_Review.php 15532 2007-08-31 14:39:46Z nanasess $
*/
class LC_Page_Products_Review extends LC_Page {
// {{{ properties
/** おすすめレベル */
var $arrRECOMMEND;
/** 性別 */
var $arrSex;
/** 入力禁止URL */
var $arrReviewDenyURL;
// }}}
// {{{ functions
/**
* Page を初期化する.
*
* @return void
*/
function init() {
parent::init();
$this->tpl_mainpage = 'products/review.tpl';
$masterData = new SC_DB_MasterData_Ex();
$this->arrRECOMMEND = $masterData->getMasterData("mtb_recommend");
$this->arrSex = $masterData->getMasterData("mtb_sex");
$this->arrReviewDenyURL = $masterData->getMasterData("mtb_review_deny_url");
}
/**
* Page のプロセス.
*
* @return void
*/
function process() {
$objView = new SC_SiteView();
$objQuery = new SC_Query();
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (!$this->isValidToken()) {
SC_Utils_Ex::sfDispSiteError(PAGE_ERROR, "", true);
}
}
//---- 登録用カラム配列
$arrRegistColumn = array(
array( "column" => "review_id", "convert" => "aKV" ),
array( "column" => "product_id", "convert" => "aKV" ),
array( "column" => "reviewer_name", "convert" => "aKV" ),
array( "column" => "reviewer_url", "convert" => "a"),
array( "column" => "sex", "convert" => "n" ),
array( "column" => "email", "convert" => "a" ),
array( "column" => "recommend_level", "convert" => "n" ),
array( "column" => "title", "convert" => "aKV" ),
array( "column" => "comment", "convert" => "aKV" ),
);
if (!isset($_POST['mode'])) $_POST['mode'] = "";
switch ($_POST['mode']){
case 'confirm':
$arrForm = $this->lfConvertParam($_POST, $arrRegistColumn);
$this->arrErr = $this->lfErrorCheck($arrForm);
//重複メッセージの判定
$flag = $objQuery->count("dtb_review","product_id = ? AND title = ? ", array($arrForm['product_id'], $arrForm['title']));
if ($flag > 0){
$this->arrErr['title'] .= "重複したタイトルは登録できません。";
}
//エラーチェック
if($this->arrErr == ""){
//重複タイトルでない
if($flag == 0){
//商品名の取得
$arrForm['name'] = $objQuery->get("dtb_products", "name", "product_id = ? ", array($arrForm['product_id']));
$this->arrForm = $arrForm;
$this->tpl_mainpage = 'products/review_confirm.tpl';
}
} else {
//商品名の取得
$arrForm['name'] = $objQuery->get("dtb_products", "name", "product_id = ? ", array($arrForm['product_id']));
$this->arrForm = $arrForm;
}
break;
case 'return':
foreach($_POST as $key => $val){
$this->arrForm[ $key ] = $val;
}
//商品名の取得
$this->arrForm['name'] = $objQuery->get("dtb_products", "name", "product_id = ? ", array($this->arrForm['product_id']));
if(empty($this->arrForm['name'])) {
SC_Utils_Ex::sfDispSiteError(PAGE_ERROR);
}
break;
case 'complete':
$arrForm = $this->lfConvertParam($_POST, $arrRegistColumn);
$arrErr = $this->lfErrorCheck($arrForm);
//重複メッセージの判定
$flag = $objQuery->count("dtb_review","product_id = ? AND title = ? ", array($arrForm['product_id'], $arrForm['title']));
//エラーチェック
if ($arrErr == ""){
//重複タイトルでない
if($flag == 0) {
//登録実行
$this->lfRegistRecommendData($arrForm, $arrRegistColumn);
//レビュー書き込み完了ページへ
$this->sendRedirect($this->getLocation("./review_complete.php", array(), true));
exit;
}
} else {
if($flag > 0) {
SC_Utils_Ex::sfDispSiteError(PAGE_ERROR);
}
}
break;
default:
if(SC_Utils_Ex::sfIsInt($_GET['product_id'])) {
//商品情報の取得
$arrForm = $objQuery->select("product_id, name", "dtb_products", "del_flg = 0 AND status = 1 AND product_id=?", array($_GET['product_id']));
if(empty($arrForm)) {
SC_Utils_Ex::sfDispSiteError(PAGE_ERROR);
}
$this->arrForm = $arrForm[0];
}
break;
}
$this->transactionid = $this->getToken();
$objView->assignobj($this);
$objView->display($this->tpl_mainpage);
}
/**
* デストラクタ.
*
* @return void
*/
function destroy() {
parent::destroy();
}
//エラーチェック
function lfErrorCheck() {
$objErr = new SC_CheckError();
$objErr->doFunc(array("商品ID", "product_id", INT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
$objErr->doFunc(array("投稿者名", "reviewer_name", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
$objErr->doFunc(array("URL", "reviewer_url", MTEXT_LEN), array("NO_SPTAB", "SPTAB_CHECK", "MAX_LENGTH_CHECK", "URL_CHECK"));
$objErr->doFunc(array("おすすめレベル", "recommend_level"), array("SELECT_CHECK"));
$objErr->doFunc(array("タイトル", "title", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
$objErr->doFunc(array("コメント", "comment", LTEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
if (REVIEW_ALLOW_URL == false) {
// コメント欄へのURLの入力を禁止
$objErr->doFunc(array("URL", "comment", $this->arrReviewDenyURL), array("PROHIBITED_STR_CHECK"));
}
return $objErr->arrErr;
}
//----　取得文字列の変換
function lfConvertParam($array, $arrRegistColumn) {
/*
* 文字列の変換
* K : 「半角(ﾊﾝｶｸ)片仮名」を「全角片仮名」に変換
* C : 「全角ひら仮名」を「全角かた仮名」に変換
* V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します
* n : 「全角」数字を「半角(ﾊﾝｶｸ)」に変換
* a : 全角英数字を半角英数字に変換する
*/
// カラム名とコンバート情報
foreach ($arrRegistColumn as $data) {
$arrConvList[ $data["column"] ] = $data["convert"];
}
// 文字変換
foreach ($arrConvList as $key => $val) {
// POSTされてきた値のみ変換する。
if(!empty($array[$key])) {
$array[$key] = mb_convert_kana($array[$key] ,$val);
}
}
return $array;
}
//登録実行
function lfRegistRecommendData ($array, $arrRegistColumn) {
// 仮登録
foreach ($arrRegistColumn as $data) {
if (strlen($array[ $data["column"] ]) > 0 ) {
$arrRegist[ $data["column"] ] = $array[ $data["column"] ];
}
}
$arrRegist['create_date'] = 'now()';
$arrRegist['update_date'] = 'now()';
$arrRegist['creator_id'] = '0';
//-- 登録実行
$objQuery = new SC_Query();
$objQuery->begin();
$objQuery->insert("dtb_review", $arrRegist);
$objQuery->commit();
}
}
?>

Source for file LC_Page_Products_Review.php