Changeset 21514 for branches/version-2_12-dev/data/class/pages/products
- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- Location:
- branches/version-2_12-dev/data/class/pages/products
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_CategoryList.php
r21481 r21514 155 155 function lfInitParam($arrRequest) { 156 156 $objFormParam = new SC_FormParam_Ex(); 157 $objFormParam->addParam( "カテゴリID", 'category_id', INT_LEN, 'n', array('NUM_CHECK','MAX_LENGTH_CHECK'));157 $objFormParam->addParam('カテゴリID', 'category_id', INT_LEN, 'n', array('NUM_CHECK','MAX_LENGTH_CHECK')); 158 158 // 値の取得 159 159 $objFormParam->setParam($arrRequest); -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_Detail.php
r21481 r21514 25 25 require_once CLASS_EX_REALDIR . 'page_extends/LC_Page_Ex.php'; 26 26 27 if (file_exists(MODULE_REALDIR . "mdl_gmopg/inc/function.php")) {27 if (file_exists(MODULE_REALDIR . 'mdl_gmopg/inc/function.php')) { 28 28 require_once MODULE_REALDIR . 'mdl_gmopg/inc/function.php'; 29 29 } … … 213 213 if ($this->tpl_classcat_find1) { 214 214 // templateの変更 215 $this->tpl_mainpage = "products/select_find1.tpl";215 $this->tpl_mainpage = 'products/select_find1.tpl'; 216 216 break; 217 217 } 218 218 219 219 // 数量の入力を行う 220 $this->tpl_mainpage = "products/select_item.tpl";220 $this->tpl_mainpage = 'products/select_item.tpl'; 221 221 break; 222 222 … … 227 227 if ($this->tpl_classcat_find1 and $this->arrErr['classcategory_id1']) { 228 228 // templateの変更 229 $this->tpl_mainpage = "products/select_find1.tpl";229 $this->tpl_mainpage = 'products/select_find1.tpl'; 230 230 break; 231 231 } … … 235 235 $this->arrErr = array(); 236 236 237 $this->tpl_mainpage = "products/select_find2.tpl";237 $this->tpl_mainpage = 'products/select_find2.tpl'; 238 238 break; 239 239 } … … 245 245 if ($this->tpl_classcat_find2 and $this->arrErr['classcategory_id2']) { 246 246 // templateの変更 247 $this->tpl_mainpage = "products/select_find2.tpl";247 $this->tpl_mainpage = 'products/select_find2.tpl'; 248 248 break; 249 249 } … … 262 262 263 263 // 数量の入力を行う 264 $this->tpl_mainpage = "products/select_item.tpl";264 $this->tpl_mainpage = 'products/select_item.tpl'; 265 265 break; 266 266 … … 269 269 if (count($this->arrErr)) { 270 270 // 数量の入力を行う 271 $this->tpl_mainpage = "products/select_item.tpl";271 $this->tpl_mainpage = 'products/select_item.tpl'; 272 272 } 273 273 break; 274 274 275 275 default: 276 $this->tpl_mainpage = "products/detail.tpl";276 $this->tpl_mainpage = 'products/detail.tpl'; 277 277 break; 278 278 } … … 341 341 /* ファイル情報の初期化 */ 342 342 function lfInitFile($objUpFile) { 343 $objUpFile->addFile( "詳細-メイン画像", 'main_image', array('jpg'), IMAGE_SIZE);343 $objUpFile->addFile('詳細-メイン画像', 'main_image', array('jpg'), IMAGE_SIZE); 344 344 for ($cnt = 1; $cnt <= PRODUCTSUB_MAX; $cnt++) { 345 345 $objUpFile->addFile("詳細-サブ画像$cnt", "sub_image$cnt", array('jpg'), IMAGE_SIZE); … … 377 377 $count = count($arrProductsClass); 378 378 379 $classcat_id1 = "";379 $classcat_id1 = ''; 380 380 381 381 $arrSele1 = array(); … … 421 421 /* パラメーター情報の初期化 */ 422 422 function lfInitParam(&$objFormParam) { 423 $objFormParam->addParam( "規格1", 'classcategory_id1', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));424 $objFormParam->addParam( "規格2", 'classcategory_id2', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));425 $objFormParam->addParam( "数量", 'quantity', INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));426 $objFormParam->addParam( "管理者ログイン", 'admin', INT_LEN, 'a', array('ALNUM_CHECK','MAX_LENGTH_CHECK'));427 $objFormParam->addParam( "商品ID", 'product_id', INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));428 $objFormParam->addParam( "お気に入り商品ID", 'favorite_product_id', INT_LEN, 'n', array('ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));429 $objFormParam->addParam( "商品規格ID", 'product_class_id', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));423 $objFormParam->addParam('規格1', 'classcategory_id1', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 424 $objFormParam->addParam('規格2', 'classcategory_id2', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 425 $objFormParam->addParam('数量', 'quantity', INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 426 $objFormParam->addParam('管理者ログイン', 'admin', INT_LEN, 'a', array('ALNUM_CHECK','MAX_LENGTH_CHECK')); 427 $objFormParam->addParam('商品ID', 'product_id', INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 428 $objFormParam->addParam('お気に入り商品ID', 'favorite_product_id', INT_LEN, 'n', array('ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 429 $objFormParam->addParam('商品規格ID', 'product_class_id', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 430 430 // 値の取得 431 431 $objFormParam->setParam($_REQUEST); … … 447 447 $objQuery =& SC_Query_Ex::getSingletonInstance(); 448 448 449 $objQuery->setOrder( "rank DESC");450 $arrRecommendData = $objQuery->select( "recommend_product_id, comment", 'dtb_recommend_products', "product_id = ?", array($product_id));449 $objQuery->setOrder('rank DESC'); 450 $arrRecommendData = $objQuery->select('recommend_product_id, comment', 'dtb_recommend_products', "product_id = ?", array($product_id)); 451 451 452 452 $arrRecommendProductId = array(); … … 476 476 $customer_id = $objCustomer->getValue('customer_id'); 477 477 if (SC_Helper_DB_Ex::sfDataExists('dtb_customer_favorite_products', 'customer_id = ? AND product_id = ?', array($customer_id, $favorite_product_id))) { 478 $objErr->arrErr['add_favorite'.$favorite_product_id] = "※ この商品は既にお気に入りに追加されています。<br />";478 $objErr->arrErr['add_favorite'.$favorite_product_id] = '※ この商品は既にお気に入りに追加されています。<br />'; 479 479 } 480 480 break; … … 487 487 // 複数項目チェック 488 488 if ($tpl_classcat_find1) { 489 $objErr->doFunc(array( "規格1", 'classcategory_id1'), array('EXIST_CHECK'));489 $objErr->doFunc(array('規格1', 'classcategory_id1'), array('EXIST_CHECK')); 490 490 } 491 491 if ($tpl_classcat_find2) { 492 $objErr->doFunc(array( "規格2", 'classcategory_id2'), array('EXIST_CHECK'));492 $objErr->doFunc(array('規格2', 'classcategory_id2'), array('EXIST_CHECK')); 493 493 } 494 494 break; … … 502 502 $objQuery =& SC_Query_Ex::getSingletonInstance(); 503 503 //商品ごとのレビュー情報を取得する 504 $col = "create_date, reviewer_url, reviewer_name, recommend_level, title, comment";504 $col = 'create_date, reviewer_url, reviewer_name, recommend_level, title, comment'; 505 505 $from = 'dtb_review'; 506 $where = "del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT ". REVIEW_REGIST_MAX;506 $where = 'del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT ' . REVIEW_REGIST_MAX; 507 507 $arrval[] = $id; 508 508 $arrReview = $objQuery->select($col, $from, $where, $arrval); … … 541 541 } else { 542 542 $objQuery =& SC_Query_Ex::getSingletonInstance(); 543 $exists = $objQuery->exists('dtb_customer_favorite_products', "customer_id = ? AND product_id = ?", array($customer_id, $favorite_product_id));543 $exists = $objQuery->exists('dtb_customer_favorite_products', 'customer_id = ? AND product_id = ?', array($customer_id, $favorite_product_id)); 544 544 545 545 if (!$exists) { -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php
r21481 r21514 147 147 $strnavi = $this->objNavi->strnavi; 148 148 // 表示文字列 149 $this->tpl_strnavi = empty($strnavi) ? " ": $strnavi;149 $this->tpl_strnavi = empty($strnavi) ? ' ' : $strnavi; 150 150 151 151 // 規格1クラス名 … … 271 271 default: 272 272 if (strlen($searchCondition['where_category']) >= 1) { 273 $dtb_product_categories = "(SELECT * FROM dtb_product_categories WHERE ".$searchCondition['where_category'].")";273 $dtb_product_categories = '(SELECT * FROM dtb_product_categories WHERE '.$searchCondition['where_category'].")"; 274 274 $arrval_order = $searchCondition['arrvalCategory']; 275 275 } else { … … 317 317 // 複数項目チェック 318 318 if ($tpl_classcat_find1[$product_id]) { 319 $objErr->doFunc(array( "規格1", 'classcategory_id1', INT_LEN), array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));319 $objErr->doFunc(array('規格1', 'classcategory_id1', INT_LEN), array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 320 320 } 321 321 if ($tpl_classcat_find2[$product_id]) { 322 $objErr->doFunc(array( "規格2", 'classcategory_id2', INT_LEN), array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));323 } 324 325 $objErr->doFunc(array( "商品規格ID", 'product_class_id', INT_LEN), array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));326 $objErr->doFunc(array( "数量", 'quantity', INT_LEN), array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));322 $objErr->doFunc(array('規格2', 'classcategory_id2', INT_LEN), array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 323 } 324 325 $objErr->doFunc(array('商品規格ID', 'product_class_id', INT_LEN), array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 326 $objErr->doFunc(array('数量', 'quantity', INT_LEN), array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 327 327 328 328 return $objErr->arrErr; … … 348 348 function lfGetPageTitle($mode, $category_id = 0) { 349 349 if ($mode == 'search') { 350 return "検索結果";350 return '検索結果'; 351 351 } elseif ($category_id == 0) { 352 return "全商品";352 return '全商品'; 353 353 } else { 354 354 $arrCat = SC_Helper_DB_Ex::sfGetCat($category_id); … … 402 402 function lfGetSearchCondition($arrSearchData) { 403 403 $searchCondition = array( 404 'where' => "",404 'where' => '', 405 405 'arrval' => array(), 406 'where_category' => "",406 'where_category' => '', 407 407 'arrvalCategory' => array() 408 408 ); … … 414 414 // ▼対象商品IDの抽出 415 415 // 商品検索条件の作成(未削除、表示) 416 $searchCondition['where'] = "alldtl.del_flg = 0 AND alldtl.status = 1 ";416 $searchCondition['where'] = 'alldtl.del_flg = 0 AND alldtl.status = 1 '; 417 417 418 418 if (strlen($searchCondition['where_category']) >= 1) { … … 423 423 // 商品名をwhere文に 424 424 $name = $arrSearchData['name']; 425 $name = str_replace( ",", "", $name);425 $name = str_replace(',', '', $name); 426 426 // 全角スペースを半角スペースに変換 427 427 $name = str_replace(' ', ' ', $name); 428 428 // スペースでキーワードを分割 429 $names = preg_split( "/ +/", $name);429 $names = preg_split('/ +/', $name); 430 430 // 分割したキーワードを一つずつwhere文に追加 431 431 foreach ($names as $val) { 432 432 if (strlen($val) > 0) { 433 $searchCondition['where'] .= " AND ( alldtl.name ILIKE ? OR alldtl.comment3 ILIKE ?) ";433 $searchCondition['where'] .= ' AND ( alldtl.name ILIKE ? OR alldtl.comment3 ILIKE ?) '; 434 434 $searchCondition['arrval'][] = "%$val%"; 435 435 $searchCondition['arrval'][] = "%$val%"; … … 439 439 // メーカーらのWHERE文字列取得 440 440 if ($arrSearchData['maker_id']) { 441 $searchCondition['where'] .= " AND alldtl.maker_id = ? ";441 $searchCondition['where'] .= ' AND alldtl.maker_id = ? '; 442 442 $searchCondition['arrval'][] = $arrSearchData['maker_id']; 443 443 } … … 460 460 */ 461 461 function lfSetSelectedData(&$arrProducts, $arrForm, $arrErr, $product_id) { 462 $js_fnOnLoad = "";462 $js_fnOnLoad = ''; 463 463 foreach (array_keys($arrProducts) as $key) { 464 464 if ($arrProducts[$key]['product_id'] == $product_id) { -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_Review.php
r21481 r21514 143 143 */ 144 144 function lfInitParam(&$objFormParam) { 145 $objFormParam->addParam( "レビューID", 'review_id', INT_LEN, 'aKV');146 $objFormParam->addParam( "商品ID", 'product_id', INT_LEN, 'n', array('NUM_CHECK','EXIST_CHECK', 'MAX_LENGTH_CHECK'));147 $objFormParam->addParam( "投稿者名", 'reviewer_name', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));148 $objFormParam->addParam( "投稿者URL", 'reviewer_url', MTEXT_LEN, 'a', array('NO_SPTAB', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK', 'URL_CHECK'));149 $objFormParam->addParam( "性別", 'sex', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));150 $objFormParam->addParam( "おすすめレベル", 'recommend_level', INT_LEN, 'n', array('EXIST_CHECK', 'SELECT_CHECK'));151 $objFormParam->addParam( "タイトル", 'title', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));152 $objFormParam->addParam( "コメント", 'comment', LTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));145 $objFormParam->addParam('レビューID', 'review_id', INT_LEN, 'aKV'); 146 $objFormParam->addParam('商品ID', 'product_id', INT_LEN, 'n', array('NUM_CHECK','EXIST_CHECK', 'MAX_LENGTH_CHECK')); 147 $objFormParam->addParam('投稿者名', 'reviewer_name', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 148 $objFormParam->addParam('投稿者URL', 'reviewer_url', MTEXT_LEN, 'a', array('NO_SPTAB', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK', 'URL_CHECK')); 149 $objFormParam->addParam('性別', 'sex', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 150 $objFormParam->addParam('おすすめレベル', 'recommend_level', INT_LEN, 'n', array('EXIST_CHECK', 'SELECT_CHECK')); 151 $objFormParam->addParam('タイトル', 'title', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 152 $objFormParam->addParam('コメント', 'comment', LTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 153 153 } 154 154 … … 166 166 // 重複メッセージの判定 167 167 $objQuery =& SC_Query_Ex::getSingletonInstance(); 168 $exists = $objQuery->exists('dtb_review', "product_id = ? AND title = ? ", array($arrForm['product_id'], $arrForm['title']));168 $exists = $objQuery->exists('dtb_review','product_id = ? AND title = ? ', array($arrForm['product_id'], $arrForm['title'])); 169 169 if ($exists) { 170 $arrErr['title'] .= "重複したタイトルは登録できません。";170 $arrErr['title'] .= '重複したタイトルは登録できません。'; 171 171 } 172 172
Note: See TracChangeset
for help on using the changeset viewer.