Changeset 21937 for branches/version-2_12-dev
- Timestamp:
- 2012/06/21 17:46:01 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/test/createEcCubeData-v25.php
r21867 r21937 143 143 if ($this->delete) { 144 144 $this->objQuery->delete('dtb_category'); 145 $existingMaxRank = 0; 146 } else { 147 $existingMaxRank = $this->objQuery->max('rank','dtb_category'); 145 148 } 146 149 … … 148 151 149 152 // 全カテゴリ共通の値 153 $sqlval = array(); 150 154 $sqlval['creator_id'] = 2; 151 155 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; … … 158 162 $sqlval['parent_category_id'] = (string) '0'; 159 163 $sqlval['level'] = 1; 160 $sqlval['rank'] = $this->lfGetTotalCategoryrank( ) - $count;164 $sqlval['rank'] = $this->lfGetTotalCategoryrank($existingMaxRank) - $count; 161 165 $sqlval['category_id'] = $this->objQuery->nextVal('dtb_category_category_id'); 162 166 … … 166 170 print("."); 167 171 172 $top_category_id = $sqlval['category_id']; 168 173 // 中カテゴリを生成 169 174 for ($j = 0; $j < MIDDLE_CATEGORIES_VOLUME; $j++) { 170 175 $sqlval['category_name'] = sprintf("Category%d%d0", $i, 171 176 $j + MIDDLE_CATEGORIES_VOLUME); 172 $sqlval['parent_category_id'] = (string) $ sqlval['category_id'];177 $sqlval['parent_category_id'] = (string) $top_category_id; 173 178 $sqlval['level'] = 2; 174 $sqlval['rank'] = $this->lfGetTotalCategoryrank( ) - $count;179 $sqlval['rank'] = $this->lfGetTotalCategoryrank($existingMaxRank) - $count; 175 180 $sqlval['category_id'] = $this->objQuery->nextVal('dtb_category_category_id'); 176 181 … … 180 185 print("."); 181 186 187 $middle_category_id = $sqlval['category_id']; 182 188 // 小カテゴリを生成 183 189 for ($k = 0; $k < SMALL_CATEGORIES_VOLUME; $k++) { … … 185 191 $i, $j, 186 192 $k + SMALL_CATEGORIES_VOLUME); 187 $sqlval['parent_category_id'] = (string) $ sqlval['category_id'];193 $sqlval['parent_category_id'] = (string) $middle_category_id; 188 194 $sqlval['level'] = 3; 189 $sqlval['rank'] = $this->lfGetTotalCategoryrank( ) - $count;195 $sqlval['rank'] = $this->lfGetTotalCategoryrank($existingMaxRank) - $count; 190 196 $sqlval['category_id'] = $this->objQuery->nextVal('dtb_category_category_id'); 191 197 … … 272 278 273 279 for ($i = 0; $i < PRODUCTS_VOLUME; $i++) { 280 $sqlval = array(); 274 281 $sqlval['product_id'] = $this->objQuery->nextval('dtb_products_product_id'); 275 282 $sqlval['name'] = sprintf("商品%d", $i); … … 302 309 */ 303 310 function createClass($class_name) { 311 $sqlval = array(); 312 $arrRaw = array(); 304 313 // class_idを取得 305 314 $sqlval['class_id'] = $this->objQuery->nextVal('dtb_class_class_id'); … … 328 337 */ 329 338 function createClassCategory($classcategory_name, $class_id, $class_name) { 339 $sqlval = array(); 340 $arrRaw = array(); 330 341 $sqlval['classcategory_id'] = $this->objQuery->nextVal('dtb_classcategory_classcategory_id'); 331 342 $sqlval['name'] = $classcategory_name; … … 368 379 printf("商品ID %d の商品規格を生成しています...\n", $product_id); 369 380 381 $sqlval = array(); 370 382 $sqlval['product_id'] = $product_id; 371 383 $sqlval['product_type_id'] = 1; … … 656 668 * 総カテゴリ数を計算し、dtb_categoryに代入するrankに使う 657 669 */ 658 function lfGetTotalCategoryrank( ){659 $TotalCategoryrank = (TOP_CATEGORIES_VOLUME * MIDDLE_CATEGORIES_VOLUME * SMALL_CATEGORIES_VOLUME) + (MIDDLE_CATEGORIES_VOLUME * TOP_CATEGORIES_VOLUME) + TOP_CATEGORIES_VOLUME ;660 return $TotalCategoryrank;670 function lfGetTotalCategoryrank($existingMaxRank = 0){ 671 $TotalCategoryrank = (TOP_CATEGORIES_VOLUME * MIDDLE_CATEGORIES_VOLUME * SMALL_CATEGORIES_VOLUME) + (MIDDLE_CATEGORIES_VOLUME * TOP_CATEGORIES_VOLUME) + TOP_CATEGORIES_VOLUME + $existingMaxRank; 672 return $TotalCategoryrank; 661 673 } 662 674
Note: See TracChangeset
for help on using the changeset viewer.