- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php
r21480 r21481 72 72 73 73 $masterData = new SC_DB_MasterData_Ex(); 74 $this->arrSTATUS = $masterData->getMasterData( "mtb_status");75 $this->arrSTATUS_IMAGE = $masterData->getMasterData( "mtb_status_image");76 $this->arrDELIVERYDATE = $masterData->getMasterData( "mtb_delivery_date");77 $this->arrPRODUCTLISTMAX = $masterData->getMasterData( "mtb_product_list_max");74 $this->arrSTATUS = $masterData->getMasterData('mtb_status'); 75 $this->arrSTATUS_IMAGE = $masterData->getMasterData('mtb_status_image'); 76 $this->arrDELIVERYDATE = $masterData->getMasterData('mtb_delivery_date'); 77 $this->arrPRODUCTLISTMAX = $masterData->getMasterData('mtb_product_list_max'); 78 78 } 79 79 … … 129 129 switch ($this->getMode()) { 130 130 131 case "json":131 case 'json': 132 132 $this->arrProducts = $this->setStatusDataTo($this->arrProducts, $this->arrSTATUS, $this->arrSTATUS_IMAGE); 133 133 $this->arrProducts = $objProduct->setPriceTaxTo($this->arrProducts); … … 183 183 // 商品IDの正当性チェック 184 184 if (!SC_Utils_Ex::sfIsInt($this->arrForm['product_id']) 185 || !SC_Helper_DB_Ex::sfIsRecord( "dtb_products", "product_id", $this->arrForm['product_id'], "del_flg = 0 AND status = 1")) {185 || !SC_Helper_DB_Ex::sfIsRecord('dtb_products', 'product_id', $this->arrForm['product_id'], "del_flg = 0 AND status = 1")) { 186 186 SC_Utils_Ex::sfDispSiteError(PRODUCT_NOT_FOUND); 187 187 } … … 270 270 271 271 default: 272 if (strlen($searchCondition[ "where_category"]) >= 1) {273 $dtb_product_categories = "(SELECT * FROM dtb_product_categories WHERE ".$searchCondition[ "where_category"].")";272 if (strlen($searchCondition['where_category']) >= 1) { 273 $dtb_product_categories = "(SELECT * FROM dtb_product_categories WHERE ".$searchCondition['where_category'].")"; 274 274 $arrval_order = $searchCondition['arrvalCategory']; 275 275 } else { … … 404 404 'where' => "", 405 405 'arrval' => array(), 406 "where_category"=> "",406 'where_category' => "", 407 407 'arrvalCategory' => array() 408 408 ); 409 409 410 410 // カテゴリからのWHERE文字列取得 411 if ($arrSearchData[ "category_id"] != 0) {412 list($searchCondition[ "where_category"], $searchCondition['arrvalCategory']) = SC_Helper_DB_Ex::sfGetCatWhere($arrSearchData["category_id"]);411 if ($arrSearchData['category_id'] != 0) { 412 list($searchCondition['where_category'], $searchCondition['arrvalCategory']) = SC_Helper_DB_Ex::sfGetCatWhere($arrSearchData['category_id']); 413 413 } 414 414 // ▼対象商品IDの抽出 … … 416 416 $searchCondition['where'] = "alldtl.del_flg = 0 AND alldtl.status = 1 "; 417 417 418 if (strlen($searchCondition[ "where_category"]) >= 1) {419 $searchCondition['where'] .= ' AND EXISTS (SELECT * FROM dtb_product_categories WHERE ' . $searchCondition[ "where_category"] . ' AND product_id = alldtl.product_id)';418 if (strlen($searchCondition['where_category']) >= 1) { 419 $searchCondition['where'] .= ' AND EXISTS (SELECT * FROM dtb_product_categories WHERE ' . $searchCondition['where_category'] . ' AND product_id = alldtl.product_id)'; 420 420 $searchCondition['arrval'] = array_merge($searchCondition['arrval'], $searchCondition['arrvalCategory']); 421 421 }
Note: See TracChangeset
for help on using the changeset viewer.