Ignore:
Timestamp:
2012/02/14 15:10:54 (12 years ago)
Author:
Seasoft
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/test/createEcCubeData-v25.php

    r21481 r21502  
    243243 
    244244        if ($this->delete) { 
    245             $this->objQuery->delete('dtb_class_combination'); 
    246245            $this->objQuery->delete('dtb_products_class'); 
    247246        } 
     
    272271            $sqlval['comment3'] = "コメント"; 
    273272            $sqlval['main_list_comment'] = "コメント"; 
    274             $sqlval['main_list_image'] = "08311201_44f65122ee5fe.jpg"; 
     273            $sqlval['main_list_image'] = "nabe130.jpg"; 
    275274            $sqlval['main_comment'] = "コメント"; 
    276             $sqlval['main_image'] = "08311202_44f6515906a41.jpg"; 
    277             $sqlval['main_large_image'] = "08311203_44f651959bcb5.jpg"; 
     275            $sqlval['main_image'] = "nabe260.jpg"; 
     276            $sqlval['main_large_image'] = "nabe500.jpg"; 
    278277            $sqlval['sub_comment1'] = "コメント"; 
    279278            $sqlval['del_flg'] = (string) '0'; 
     
    374373        $sqlval['del_flg'] = 0; 
    375374 
    376         $count = 0; 
    377         foreach ($this->arrClassCategory_id1 as $classCategory_id1) { 
    378             foreach ($this->arrClassCategory_id2 as $classCategory_id2) { 
    379                 $c1['classcategory_id'] = $classCategory_id1; 
    380                 $c1['class_combination_id'] = $this->objQuery->nextVal('dtb_class_combination_class_combination_id'); 
    381                 $c1['level'] = 1; 
    382                 $this->objQuery->insert('dtb_class_combination', $c1); 
    383  
    384                 $c2['classcategory_id'] = $classCategory_id2; 
    385                 $c2['class_combination_id'] = $this->objQuery->nextVal('dtb_class_combination_class_combination_id'); 
    386                 $c2['parent_class_combination_id'] = $c1['class_combination_id']; 
    387                 $c2['level'] = 2; 
    388                 $this->objQuery->insert('dtb_class_combination', $c2); 
    389  
    390                 $sqlval['product_class_id'] = 
    391                     $this->objQuery->nextVal('dtb_products_class_product_class_id'); 
    392                 $sqlval['product_code'] = sprintf("商品コード%d", $count); 
    393  
    394                 $sqlval['class_combination_id'] = $c2['class_combination_id']; 
     375        foreach ($this->arrClassCategory_id1 as $classcategory_id1) { 
     376            foreach ($this->arrClassCategory_id2 as $classcategory_id2) { 
     377                $sqlval['product_class_id'] = $this->objQuery->nextVal('dtb_products_class_product_class_id'); 
     378                $sqlval['classcategory_id1'] = $classcategory_id1; 
     379                $sqlval['classcategory_id2'] = $classcategory_id2; 
     380                $sqlval['product_code'] = 'CODE_' . $product_id . '_' . $classcategory_id1 . '_' . $classcategory_id2; 
    395381                $this->objQuery->insert('dtb_products_class', $sqlval); 
    396382 
    397                 $count++; 
    398383                print("#"); 
    399384            } 
     
    402387        // 規格無し用 
    403388        $sqlval['product_class_id'] = $this->objQuery->nextVal('dtb_products_class_product_class_id'); 
    404         $sqlval['class_combination_id'] = null; 
     389        $sqlval['classcategory_id1'] = 0; 
     390        $sqlval['classcategory_id2'] = 0; 
     391        $sqlval['product_code'] = 'CODE_' . $product_id; 
    405392        $sqlval['del_flg'] = 1; 
    406393        $this->objQuery->insert('dtb_products_class', $sqlval); 
     
    463450                         ,'42' 
    464451                         ,'41' 
    465                          ,"43(27.0cm?27.5cm)" 
    466                          ,"42(26.5cm?27.0cm)" 
    467                          ,"37(ladies 23.5?24cm)" 
     452                         ,"43(27.0cm27.5cm)" 
     453                         ,"42(26.5cm27.0cm)" 
     454                         ,"37(ladies 23.524cm)" 
    468455                         ,"42(約27.5cm)" 
    469456                         ,"41(約26.5cm)" 
Note: See TracChangeset for help on using the changeset viewer.