Changeset 17178 for branches/sol/dev02/data/class/util/SC_Utils.php

Timestamp:

2008/03/24 00:28:34 (18 years ago)

Author:

kishida

Message:

商品詳細、商品コードをキャッシュするようにする

File:

• branches/sol/dev02/data/class/util/SC_Utils.php (modified) (2 diffs)

branches/sol/dev02/data/class/util/SC_Utils.php

@@ -763 +763 @@
             $where = "product_id = ?";
             $objQuery->delete("dtb_products_class", $where, array($product_id));
-
+            // 在庫テーブルの削除
+            $objQuery->delete("dtb_stock", $where, array($product_id));
+            
             // 配列の添字を定義
             $checkArray = array("product_code", "stock", "stock_unlimited", "price01", "price02");
@@ -782 +784 @@
                 $sqlval['creator_id'] = '0';
             }
-
+            
             // INSERTの実行
             $objQuery->insert("dtb_products_class", $sqlval);
+            
+            
+            // 在庫テーブルを作成する
+            $where = '';
+            $stock_where = array();
+            $stock_sqlval = array();
+            $where = 'product_id = ? AND classcategory_id1 = 0 AND classcategory_id2 = 0';
+            $tmp_product_class_id = $objQuery->select('product_class_id', 'dtb_products_class', $where, array($product_id));
+            
+            $stock_sqlval['product_class_id'] = $tmp_product_class_id[0]['product_class_id'];
+            $stock_sqlval['product_id'] = $product_id;
+            $stock_sqlval['stock'] = $arrList["stock"];
+            $objQuery->insert("dtb_stock", $stock_sqlval);
         }
     }