Changes between Version 2 and Version 3 of テストデータ生成スクリプト(v2.0)

Timestamp:

2008/06/08 23:12:18 (16 years ago)

Author:

kishida

Comment:

カテゴリーのrankへの代入する値を修正する

テストデータ生成スクリプト(v2.0)

@@ -180 +180 @@
             $sqlval['parent_category_id'] = (string) "0";
             $sqlval['level'] = 1;
-            $sqlval['rank'] = $count;
+            $sqlval['rank'] = $this->lfGetTotalCategoryrank() - $count;
 
             $this->objQuery->insert("dtb_category", $sqlval);
@@ -195 +195 @@
                 $sqlval['parent_category_id'] = (string) $category_id1;
                 $sqlval['level'] = 2;
-                $sqlval['rank'] = $count;
+                $sqlval['rank'] = $this->lfGetTotalCategoryrank() - $count;
 
                 $this->objQuery->insert("dtb_category", $sqlval);
@@ -211 +211 @@
                     $sqlval['parent_category_id'] = (string) $category_id2;
                     $sqlval['level'] = 3;
-                    $sqlval['rank'] = $count;
+                    $sqlval['rank'] = $this->lfGetTotalCategoryrank() - $count;
 
                     $this->objQuery->insert("dtb_category", $sqlval);
@@ -649 +649 @@
                      );
 
+    /**
+    * 総カテゴリー数を計算し、dtb_categoryに代入するrankに使う
+    */
+    function lfGetTotalCategoryrank(){
+                $TotalCategoryrank = (TOP_CATEGORIES_VOLUME * MIDDLE_CATEGORIES_VOLUME * SMALL_CATEGORIES_VOLUME) + (MIDDLE_CATEGORIES_VOLUME * TOP_CATEGORIES_VOLUME) + TOP_CATEGORIES_VOLUME;
+    return $TotalCategoryrank;
+    }
+
 }