Changeset 14921


Ignore:
Timestamp:
2007/06/26 12:04:18 (13 years ago)
Author:
uehara
Message:

商品登録CSV改修
MySQLのauto_incrementバグに対応

Location:
branches/rel
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • branches/rel/data/class/SC_Query.php

    r12157 r14921  
    419419    } 
    420420     
    421     // auto_increment¤ò¼èÆÀ¤¹¤ë 
    422     function get_auto_increment($table_name){ 
    423         // ¥í¥Ã¥¯¤¹¤ë 
    424         $this->BEGIN(); 
    425          
    426         // ¼¡¤ÎIncrement¤ò¼èÆÀ 
    427         $arrRet = $this->getAll("SHOW TABLE STATUS LIKE ?", array($table_name)); 
    428         $auto_inc_no = $arrRet[0]["Auto_increment"]; 
    429          
    430         // Ãͤò¥«¥¦¥ó¥È¥¢¥Ã¥×¤·¤Æ¤ª¤¯ 
    431         $this->conn->query("ALTER TABLE $table_name AUTO_INCREMENT=?" , $auto_inc_no + 1); 
    432          
    433         // ²ò½ü¤¹¤ë 
    434         $this->COMMIT(); 
    435          
    436         return $auto_inc_no; 
    437     } 
     421    // auto_increment¤ò¼èÆÀ¤¹¤ë 
     422    function get_auto_increment($table_name){ 
     423        // ¥í¥Ã¥¯¤¹¤ë 
     424        $this->query("LOCK TABLES $table_name WRITE"); 
     425         
     426        // ¼¡¤ÎIncrement¤ò¼èÆÀ 
     427        $arrRet = $this->getAll("SHOW TABLE STATUS LIKE ?", array($table_name)); 
     428        $auto_inc_no = $arrRet[0]["Auto_increment"]; 
     429         
     430        // Ãͤò¥«¥¦¥ó¥È¥¢¥Ã¥×¤·¤Æ¤ª¤¯ 
     431        $this->conn->query("ALTER TABLE $table_name AUTO_INCREMENT=?" , $auto_inc_no + 1); 
     432         
     433        // ²ò½ü¤¹¤ë 
     434        $this->query('UNLOCK TABLES'); 
     435         
     436        return $auto_inc_no; 
     437    } 
    438438} 
    439439 
  • branches/rel/data/conf/conf.php

    r14900 r14921  
    172172define("DEFAULT_PASSWORD", "UAhgGR3L"); 
    173173//¤ª¤¹¤¹¤á¾¦ÉÊ¿ô 
    174 define ("RECOMMEND_PRODUCT_MAX", 5); 
     174define ("RECOMMEND_PRODUCT_MAX", 6); 
    175175 
    176176//Ê̤ΤªÆϤ±ÀèºÇÂçÅÐÏ¿¿ô 
  • branches/rel/html/admin/products/upload_csv.php

    r13497 r14921  
    255255        case 'recommend_product_id2': 
    256256        case 'recommend_product_id3': 
    257         case 'recommend_product_id4': 
     257        case 'recommend_product_id4': 
     258        case 'recommend_product_id5': 
     259        case 'recommend_product_id6': 
    258260        case 'recommend_comment1': 
    259261        case 'recommend_comment2': 
    260262        case 'recommend_comment3': 
    261263        case 'recommend_comment4': 
     264        case 'recommend_comment5': 
     265        case 'recommend_comment6': 
    262266            break; 
    263267        default: 
  • branches/rel/html/install/sql/insert_data.sql

    r12157 r14921  
    9797insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4','¤ª¤¹¤¹¤á¾¦ÉÊ(4)',51,now(),now()); 
    9898insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(4)',52,now(),now()); 
    99 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'category_id','¥«¥Æ¥´¥êID',53,now(),now()); 
     99insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5','¤ª¤¹¤¹¤á¾¦ÉÊ(5)',53,now(),now()); 
     100insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(5)',54,now(),now()); 
     101insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6','¤ª¤¹¤¹¤á¾¦ÉÊ(6)',55,now(),now()); 
     102insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(6)',56,now(),now()); 
     103insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'category_id','¥«¥Æ¥´¥êID',57,now(),now()); 
    100104insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'customer_id','¸ÜµÒID',1,now(),now()); 
    101105insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'name01','̾Á°1',2,now(),now()); 
Note: See TracChangeset for help on using the changeset viewer.