Changeset 21502 for branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php

Timestamp:

2012/02/14 15:10:54 (12 years ago)

Author:

Seasoft

Message:

#1641 (商品規格における木構造の廃止)

File:

• branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php (modified) (7 diffs)

branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php

@@ -237 +237 @@
         $arrDefault = $this->getProductsClass($product_id);
 
-        $objQuery->delete('dtb_products_class', 'product_id = ? AND class_combination_id IS NOT NULL', array($product_id));
+        $objQuery->delete('dtb_products_class', 'product_id = ? AND (classcategory_id1 <> 0 OR classcategory_id2 <> 0)', array($product_id));
 
         for ($i = 0; $i < $total; $i++) {
@@ -244 +244 @@
             $price02 = SC_Utils_Ex::isBlank($arrList['price02'][$i]) ? 0 : $arrList['price02'][$i];
             // dtb_products_class 登録/更新用
-            $registerKeys = array('product_code', 'stock',
-                                  'price01', 'product_type_id',
-                                  'down_filename', 'down_realfilename');
+            $registerKeys = array(
+                'classcategory_id1', 'classcategory_id2',
+                'product_code', 'stock', 'price01', 'product_type_id',
+                'down_filename', 'down_realfilename',
+            );
 
             $arrPC = array();
@@ -264 +266 @@
             $arrPC['del_flg'] = $del_flg;
 
-            $class_combination_id = $arrExists[$arrList['product_class_id'][$i]]['class_combination_id'];
-            $existsCombi = $objQuery->getRow('*', 'dtb_class_combination',
-                                             'class_combination_id = ?',
-                                             array($class_combination_id));
-
-            $objQuery->delete('dtb_class_combination',
-                              'class_combination_id IN (?, ?)',
-                              array($existsCombi['class_combination_id'],
-                                    $existsCombi['parent_class_combination_id']));
-
-            // 規格組み合わせを登録
-            $arrComb1['class_combination_id'] = $objQuery->nextVal('dtb_class_combination_class_combination_id');
-            $arrComb1['classcategory_id'] = $arrList['classcategory_id1'][$i];
-            $arrComb1['level'] = 1;
-            $objQuery->insert('dtb_class_combination', $arrComb1);
-
-            // 規格2も登録する場合
-            if (!SC_Utils_Ex::isBlank($arrList['classcategory_id2'][$i])) {
-                $arrComb2['class_combination_id'] = $objQuery->nextVal('dtb_class_combination_class_combination_id');
-                $arrComb2['classcategory_id'] = $arrList['classcategory_id2'][$i];
-                $arrComb2['parent_class_combination_id'] = $arrComb1['class_combination_id'];
-                $arrComb2['level'] = 2;
-                $objQuery->insert('dtb_class_combination', $arrComb2);
-
-                $arrPC['class_combination_id'] = $arrComb2['class_combination_id'];
-            } else {
-                $arrPC['class_combination_id'] = $arrComb1['class_combination_id'];
-            }
-
             $arrPC['create_date'] = 'CURRENT_TIMESTAMP';
             // 更新の場合は, product_class_id を使い回す
@@ -313 +286 @@
         $arrBlank['update_date'] = 'CURRENT_TIMESTAMP';
         $objQuery->update('dtb_products_class', $arrBlank,
-                          "product_id = ? AND class_combination_id IS NULL",
+                          "product_id = ? AND classcategory_id1 = 0 AND classcategory_id2 = 0",
                           array($product_id));
 
@@ -479 +452 @@
         $product_id = $objFormParam->getValue('product_id');
         $objProduct = new SC_Product_Ex();
-        $existsProductsClass = $objProduct->getProductsClassFullByProductId($product_id, true);
+        $existsProductsClass = $objProduct->getProductsClassFullByProductId($product_id);
 
         // 規格のデフォルト値(すべての組み合わせ)を取得し, フォームに反映
@@ -557 +530 @@
 
         $objQuery->begin();
-        $arrClassCombi = $objQuery->getCol('class_combination_id',
-                                           'dtb_products_class',
-                                           'product_id = ?', array($product_id));
-
-        foreach ($arrClassCombi as $class_combination_id) {
-            if (SC_Utils_Ex::isBlank($class_combination_id)) {
-                continue;
-            }
-            $existsCombi = $objQuery->getRow('*', 'dtb_class_combination',
-                                             'class_combination_id = ?',
-                                             array($class_combination_id));
-
-            $objQuery->delete('dtb_class_combination',
-                              'class_combination_id IN (?, ?)',
-                              array($existsCombi['class_combination_id'],
-                                    $existsCombi['parent_class_combination_id']));
-        }
-        $objQuery->update('dtb_products_class', array('del_flg' => 0),
-                          "product_id = ? AND class_combination_id IS NULL",
-                          array($product_id));
-        $objQuery->delete('dtb_products_class',
-                          "product_id = ? AND class_combination_id IS NOT NULL",
-                          array($product_id));
+
+        // 商品規格なしデータの復元
+        $where = 'product_id = ? AND classcategory_id1 = 0 AND classcategory_id2 = 0';
+        $objQuery->update("dtb_products_class", array('del_flg' => 0), $where, array($product_id));
+
+        // 商品規格データの削除
+        $where = 'product_id = ? AND (classcategory_id1 <> 0 OR classcategory_id2 <> 0)';
+        $objQuery->delete("dtb_products_class", $where, array($product_id));
+
         $objQuery->commit();
 
@@ -780 +739 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $col = "product_code, price01, price02, stock, stock_unlimited, sale_limit, deliv_fee, point_rate";
-        return $objQuery->getRow($col, 'dtb_products_class', "product_id = ? AND class_combination_id IS NULL", array($product_id));
+        $where = 'product_id = ? AND classcategory_id1 = 0 AND classcategory_id2 = 0';
+        return $objQuery->getRow($col, 'dtb_products_class', $where, array($product_id));
     }