Changeset 17178

Timestamp:

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

Author:

kishida

Message:

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

Location:

branches/sol/dev02/data/class

Files:

• pages/admin/products/LC_Page_Admin_Products_ProductClass.php (modified) (2 diffs)
• pages/products/LC_Page_Products_List.php (modified) (2 diffs)
• util/SC_Utils.php (modified) (2 diffs)

branches/sol/dev02/data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php

@@ -335 +335 @@
         $where = "product_id = ?";
         $objQuery->delete("dtb_products_class", $where, array($product_id));
-
+        // 在庫の削除
+        $objQuery->delete("dtb_stock", $where, array($product_id));
+        
         $cnt = 1;
         // すべての規格を登録する。
@@ -353 +355 @@
                 // INSERTの実行
                 $objQuery->insert("dtb_products_class", $sqlval);
+                
+                // 在庫テーブルを作成する
+                $where = '';
+                $stock_where = array();
+                $stock_sqlval = array();
+                $where = 'product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?';
+                $tmp_product_class_id = $objQuery->select('product_class_id', 'dtb_products_class', $where, array($product_id, $sqlval['classcategory_id1'], $sqlval['classcategory_id2']));
+                
+                $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);
+                
             }
             $cnt++;

branches/sol/dev02/data/class/pages/products/LC_Page_Products_List.php

@@ -56 +56 @@
         parent::init();
 
-        $masterData = new SC_DB_MasterData_Ex();
-        $this->arrSTATUS = $masterData->getMasterData("mtb_status");
-        $this->arrSTATUS_IMAGE = $masterData->getMasterData("mtb_status_image");
-        $this->arrDELIVERYDATE = $masterData->getMasterData("mtb_delivery_date");
-        $this->arrPRODUCTLISTMAX = $masterData->getMasterData("mtb_product_list_max");
+        $this->masterData = new SC_DB_MasterData_Ex();
+        $this->arrSTATUS = $this->masterData->getMasterData("mtb_status");
+        $this->arrSTATUS_IMAGE = $this->masterData->getMasterData("mtb_status_image");
+        $this->arrDELIVERYDATE = $this->masterData->getMasterData("mtb_delivery_date");
+        $this->arrPRODUCTLISTMAX = $this->masterData->getMasterData("mtb_product_list_max");
 
         $this->tpl_class_name1 = array();
@@ -89 +89 @@
 
         // GETのカテゴリIDを元に正しいカテゴリIDを取得する。
-        $arrCategory_id = $objDb->sfGetCategoryId("", $_GET['category_id']);
-
+        // キャッシュがあればキャッシュから元のカテゴリーIDを取得する
+        $arrCategory_id = $this->masterData->getMasterDataFlg("product_categoryid_".$_GET['category_id']);
+        if($arrCategory_id === false){
+            $arrCategory_id = $objDb->sfGetCategoryId("", $_GET['category_id']);
+            // カテゴリIDをキャッシュする
+            $this->masterData->createCache("product_categoryid_".$_GET['category_id'], $arrCategory_id);
+        }
+        
+        
         if (!isset($_GET['mode'])) $_GET['mode'] = "";
         if (!isset($_GET['name'])) $_GET['name'] = "";

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);
         }
     }