Ignore:
Timestamp:
2009/07/25 09:49:37 (17 years ago)
Author:
Seasoft
Message:
  • #516(受注管理の編集画面でお届け日を編集可能に)を実装
  • 語句統一(フロント機能PCサイトを基準とした)
    • お届け日 ← 配達日、配送日
    • お届け時間 ← 配送時間、配達時間
    • お届け先 ← 配送先
  • コメントの誤りを修正
Location:
branches/comu-ver2/html/install
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • branches/comu-ver2/html/install/index.php

    r18234 r18235  
    975975        lfInsertCSVData(4,'order_birth','生年月日',22,'now()','now()', $dsn); 
    976976        lfInsertCSVData(4,'order_job','職種',23,'now()','now()', $dsn); 
    977         lfInsertCSVData(4,'deliv_name01','配送先名前',24,'now()','now()', $dsn); 
    978         lfInsertCSVData(4,'deliv_name02','配送先名前',25,'now()','now()', $dsn); 
    979         lfInsertCSVData(4,'deliv_kana01','配送先カナ',26,'now()','now()', $dsn); 
    980         lfInsertCSVData(4,'deliv_kana02','配送先カナ',27,'now()','now()', $dsn); 
     977        lfInsertCSVData(4,'deliv_name01','お届け先名前',24,'now()','now()', $dsn); 
     978        lfInsertCSVData(4,'deliv_name02','お届け先名前',25,'now()','now()', $dsn); 
     979        lfInsertCSVData(4,'deliv_kana01','お届け先カナ',26,'now()','now()', $dsn); 
     980        lfInsertCSVData(4,'deliv_kana02','お届け先カナ',27,'now()','now()', $dsn); 
    981981        lfInsertCSVData(4,'deliv_tel01','電話番号1',28,'now()','now()', $dsn); 
    982982        lfInsertCSVData(4,'deliv_tel02','電話番号2',29,'now()','now()', $dsn); 

  • branches/comu-ver2/html/install/sql/column_comment.sql

    r17994 r18235  
    6666INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','update_date','更新日時'); 
    6767INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','deliv_id','配送ID'); 
    68 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','配送時間ID'); 
    69 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','配送時間'); 
     68INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','お届け時間ID'); 
     69INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','お届け時間'); 
    7070INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','deliv_id','配送ID'); 
    7171INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee_id','配送料金ID'); 
    … …  
    398398INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_birth','生年月日'); 
    399399INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_job','職種'); 
    400 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','配送先名前'); 
    401 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','配送先名前'); 
    402 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','配送先カナ'); 
    403 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','配送先カナ'); 
     400INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','お届け先名前'); 
     401INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','お届け先名前'); 
     402INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','お届け先カナ'); 
     403INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','お届け先カナ'); 
    404404INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel01','電話番号1'); 
    405405INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel02','電話番号2'); 
    … …  
    426426INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_method','支払い方法'); 
    427427INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_id','配送業者ID'); 
    428 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','配送時間ID'); 
    429 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','配送時間'); 
     428INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','お届け時間ID'); 
     429INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','お届け時間'); 
    430430INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_no','配送伝票番号'); 
    431431INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','note','SHOPメモ'); 
    … …  
    438438INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','commit_date','発送済みステータスに変更した日'); 
    439439INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','del_flg ','0:既定、1:削除'); 
    440 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','配達日'); 
     440INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','お届け日'); 
    441441INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','conveni_data','コンビニ決済情報'); 
    442442INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell01','携帯電話番号1'); 
    … …  
    465465INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_birth','生年月日'); 
    466466INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_job','職種'); 
    467 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','配送先名前'); 
    468 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','配送先名前'); 
    469 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','配送先カナ'); 
    470 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','配送先カナ'); 
     467INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','お届け先名前'); 
     468INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','お届け先名前'); 
     469INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','お届け先カナ'); 
     470INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','お届け先カナ'); 
    471471INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel01','電話番号1'); 
    472472INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel02','電話番号2'); 
    … …  
    493493INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_method','支払い方法（文字列）'); 
    494494INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_id','配送業者ID'); 
    495 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','配送時間ID'); 
    496 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','配送時間（文字列）'); 
     495INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','お届け時間ID'); 
     496INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','お届け時間（文字列）'); 
    497497INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_no','配送伝票番号'); 
    498498INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','note','SHOPメモ'); 
    … …  
    507507INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','update_date','更新日時'); 
    508508INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','del_flg ','0:既定、1:削除'); 
    509 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','配達日'); 
     509INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','お届け日'); 
    510510INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','conveni_data','コンビニ決済情報'); 
    511511INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell01','携帯電話番号1'); 
    … …  
    514514INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','other_deliv_id','別のお届け先ID'); 
    515515INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','customer_id','顧客ID'); 
    516 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','配送先名前'); 
    517 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','配送先名前'); 
    518 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','配送先カナ'); 
    519 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','配送先カナ'); 
     516INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','お届け先名前'); 
     517INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','お届け先名前'); 
     518INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','お届け先カナ'); 
     519INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','お届け先カナ'); 
    520520INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip01','郵便番号1'); 
    521521INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip02','郵便番号2'); 

  • branches/comu-ver2/html/install/sql/insert_data.sql

    r18216 r18235  
    145145INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'order_birth','生年月日',21,now(),now()); 
    146146INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'order_job','職種',22,now(),now()); 
    147 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_name01','配送先名前',23,now(),now()); 
    148 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_name02','配送先名前',24,now(),now()); 
    149 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_kana01','配送先カナ',25,now(),now()); 
    150 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_kana02','配送先カナ',26,now(),now()); 
     147INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_name01','お届け先名前',23,now(),now()); 
     148INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_name02','お届け先名前',24,now(),now()); 
     149INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_kana01','お届け先カナ',25,now(),now()); 
     150INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_kana02','お届け先カナ',26,now(),now()); 
    151151INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_tel01','電話番号1',27,now(),now()); 
    152152INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_tel02','電話番号2',28,now(),now()); 
    … …  
    170170INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'payment_total','お支払い合計',46,now(),now()); 
    171171INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'payment_method','支払い方法',47,now(),now()); 
    172 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_time','配送時間',48,now(),now()); 
     172INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_time','お届け時間',48,now(),now()); 
    173173INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'deliv_no','配送伝票番号',49,now(),now()); 
    174174INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (3,'note','SHOPメモ',50,now(),now()); 
    … …  
    199199INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'order_birth','生年月日',22,now(),now()); 
    200200INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'order_job','職種',23,now(),now()); 
    201 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_name01','配送先名前',24,now(),now()); 
    202 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_name02','配送先名前',25,now(),now()); 
    203 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_kana01','配送先カナ',26,now(),now()); 
    204 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_kana02','配送先カナ',27,now(),now()); 
     201INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_name01','お届け先名前',24,now(),now()); 
     202INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_name02','お届け先名前',25,now(),now()); 
     203INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_kana01','お届け先カナ',26,now(),now()); 
     204INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_kana02','お届け先カナ',27,now(),now()); 
    205205INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_tel01','電話番号1',28,now(),now()); 
    206206INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (4,'deliv_tel02','電話番号2',29,now(),now()); 
    … …  
    943943INSERT INTO mtb_constants VALUES ('NAVI_PMAX','4',184,'ページ番号の最大表示数量'); 
    944944INSERT INTO mtb_constants VALUES ('PRODUCTSUB_MAX','5',185,'商品サブ情報最大数'); 
    945 INSERT INTO mtb_constants VALUES ('DELIVTIME_MAX','16',186,'配送時間の最大表示数'); 
     945INSERT INTO mtb_constants VALUES ('DELIVTIME_MAX','16',186,'お届け時間の最大表示数'); 
    946946INSERT INTO mtb_constants VALUES ('DELIVFEE_MAX','47',187,'配送料金の最大表示数'); 
    947947INSERT INTO mtb_constants VALUES ('STEXT_LEN','50',188,'短い項目の文字数（名前など)'); 
    … …  
    997997INSERT INTO mtb_constants VALUES ('URL_SITE_TOP','URL_DIR . DIR_INDEX_URL',239,'サイトトップ'); 
    998998INSERT INTO mtb_constants VALUES ('URL_CART_TOP','URL_DIR . "cart/" . DIR_INDEX_URL',240,'カートトップ'); 
    999 INSERT INTO mtb_constants VALUES ('URL_DELIV_TOP','URL_DIR . "shopping/deliv.php"',241,'配送時間設定'); 
     999INSERT INTO mtb_constants VALUES ('URL_DELIV_TOP','URL_DIR . "shopping/deliv.php"',241,'お届け先設定'); 
    10001000INSERT INTO mtb_constants VALUES ('URL_MYPAGE_TOP','SSL_URL . "mypage/login.php"',242,'Myページトップ'); 
    10011001INSERT INTO mtb_constants VALUES ('URL_SHOP_CONFIRM','URL_DIR . "shopping/confirm.php"',243,'購入確認ページ'); 
    … …  
    10281028INSERT INTO mtb_constants VALUES ('BEST_MAX','5',270,'ベスト商品の最大登録数'); 
    10291029INSERT INTO mtb_constants VALUES ('BEST_MIN','3',271,'ベスト商品の最小登録数（登録数が満たない場合は表示しない。)'); 
    1030 INSERT INTO mtb_constants VALUES ('DELIV_DATE_END_MAX','21',272,'配達可能な日付以降のプルダウン表示最大日数'); 
     1030INSERT INTO mtb_constants VALUES ('DELIV_DATE_END_MAX','21',272,'お届け可能日以降のプルダウン表示最大日数'); 
    10311031INSERT INTO mtb_constants VALUES ('PURCHASE_CUSTOMER_REGIST','0',273,'購入時強制会員登録(1:有効　0:無効)'); 
    10321032INSERT INTO mtb_constants VALUES ('RELATED_PRODUCTS_MAX','3',274,'この商品を買った人はこんな商品も買っています　表示件数'); 

  • branches/comu-ver2/html/install/sql/table_comment.sql

    r16437 r18235  
    11INSERT INTO dtb_table_comment(table_name,description) values ('dtb_baseinfo','基本情報'); 
    22INSERT INTO dtb_table_comment(table_name,description) values ('dtb_deliv','配送業者'); 
    3 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_delivtime','配送時間'); 
     3INSERT INTO dtb_table_comment(table_name,description) values ('dtb_delivtime','お届け時間'); 
    44INSERT INTO dtb_table_comment(table_name,description) values ('dtb_delivfee','配送料金'); 
    55INSERT INTO dtb_table_comment(table_name,description) values ('dtb_payment','支払方法'); 
Note: See TracChangeset for help on using the changeset viewer.