Changeset 21396
- Timestamp:
- 2012/01/14 18:30:45 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_Product.php
r21386 r21396 836 836 return $sql; 837 837 } 838 839 /**840 * 商品規格ID1、2に紐づいた,product_class_idを取得する.841 *842 * @param int $productId 商品ID843 * @param int $classcategory_id1 商品規格ID1844 * @param int $classcategory_id2 商品規格ID2845 * @return string product_class_id846 */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 (SELECT852 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_id2858 FROM859 dtb_products_class pc LEFT JOIN dtb_class_combination cc1 ON pc.class_combination_id = cc1.class_combination_id860 LEFT JOIN dtb_class_combination cc2 ON cc1.parent_class_combination_id = cc2.class_combination_id) T1861 __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 868 838 } 869 839 ?>
Note: See TracChangeset
for help on using the changeset viewer.