Changeset 21396


Ignore:
Timestamp:
2012/01/14 18:30:45 (12 years ago)
Author:
Seasoft
Message:

#1607 (未使用定義の削除)

  • 未使用メソッド削除
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/SC_Product.php

    r21386 r21396  
    836836        return $sql; 
    837837    } 
    838  
    839     /** 
    840      * 商品規格ID1、2に紐づいた,product_class_idを取得する. 
    841      * 
    842      * @param int $productId 商品ID 
    843      * @param int $classcategory_id1 商品規格ID1 
    844      * @param int $classcategory_id2 商品規格ID2 
    845      * @return string product_class_id 
    846      */ 
    847     function getClasscategoryIdsByProductClassId($productId, $classcategory_id1, $classcategory_id2) { 
    848         $objQuery = new SC_Query_Ex(); 
    849         $col = "T1.product_id AS product_id,T1.product_class_id AS product_class_id,T1.classcategory_id1 AS classcategory_id1,T1.classcategory_id2 AS classcategory_id2"; 
    850         $table = <<< __EOS__ 
    851             (SELECT 
    852                 pc.product_code AS product_code, 
    853                 pc.product_id AS product_id, 
    854                 pc.product_class_id AS product_class_id, 
    855                 pc.class_combination_id AS class_combination_id, 
    856                 COALESCE(cc2.classcategory_id,0) AS classcategory_id1, 
    857                 COALESCE(cc1.classcategory_id,0) AS classcategory_id2 
    858             FROM 
    859                 dtb_products_class pc LEFT JOIN dtb_class_combination cc1 ON pc.class_combination_id = cc1.class_combination_id 
    860                 LEFT JOIN dtb_class_combination cc2 ON cc1.parent_class_combination_id = cc2.class_combination_id) T1 
    861 __EOS__; 
    862         $where = "T1.product_id = ? AND T1.classcategory_id1 = ? AND T1.classcategory_id2 = ?"; 
    863         $arrRet = $objQuery->select($col, $table, $where, 
    864                                     array($productId, $classcategory_id1, $classcategory_id2)); 
    865         return $arrRet[0]['product_class_id']; 
    866     } 
    867  
    868838} 
    869839?> 
Note: See TracChangeset for help on using the changeset viewer.