- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
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) {
Note: See TracChangeset
for help on using the changeset viewer.