Changeset 19669


Ignore:
Timestamp:
2010/11/12 16:18:52 (11 years ago)
Author:
nanasess
bzr:base-revision:
ohkouchi@loop-az.jp-20101111085634-wy7ecrejoq4yb89k
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

data/class/pages/products/LC_Page_Products_Detail.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Detail.php
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
bzr:mapping-version:
v4
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20101112071848-7nudza7bba9i207l
bzr:revno:
2399
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:timestamp:
2010-11-12 16:18:48.940000057 +0900
bzr:user-agent:
bzr2.2.1+bzr-svn1.0.4
svn:original-date:
2010-11-12T07:18:48.940000Z
Message:

#628(未使用処理・定義などの削除)

  • dtb_products_class, dtb_class, dtb_classcategory の status を削除
  • dtb_customer_reading を削除
  • dtb_customer の cell01, cell02, cell03 を削除
Location:
branches/version-2_5-dev
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/data/class/pages/products/LC_Page_Products_Detail.php

    r19664 r19669  
    320320            //お気に入りボタン表示 
    321321            $this->tpl_login = true; 
    322  
    323             /* 閲覧ログ機能は現在未使用 
    324  
    325                $table = "dtb_customer_reading"; 
    326                $where = "customer_id = ? "; 
    327                $arrval[] = $objCustomer->getValue('customer_id'); 
    328                //顧客の閲覧商品数 
    329                $rpcnt = $objQuery->count($table, $where, $arrval); 
    330  
    331                //閲覧数が設定数以下 
    332                if ($rpcnt < CUSTOMER_READING_MAX){ 
    333                //閲覧履歴に新規追加 
    334                lfRegistReadingData($product_id, $objCustomer->getValue('customer_id')); 
    335                } else { 
    336                //閲覧履歴の中で一番古いものを削除して新規追加 
    337                $oldsql = "SELECT MIN(update_date) FROM ".$table." WHERE customer_id = ?"; 
    338                $old = $objQuery->getOne($oldsql, array($objCustomer->getValue("customer_id"))); 
    339                $where = "customer_id = ? AND update_date = ? "; 
    340                $arrval = array($objCustomer->getValue("customer_id"), $old); 
    341                //削除 
    342                $objQuery->delete($table, $where, $arrval); 
    343                //追加 
    344                lfRegistReadingData($product_id, $objCustomer->getValue('customer_id')); 
    345                } 
    346             */ 
    347         } 
    348  
     322        } 
    349323 
    350324        // 規格選択セレクトボックスの作成 
  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r19662 r19669  
    317317    deliv_fee numeric, 
    318318    point_rate numeric, 
    319     status smallint, 
    320319    creator_id int NOT NULL, 
    321320    create_date datetime NOT NULL, 
     
    330329    class_id int  NOT NULL, 
    331330    name text, 
    332     status smallint, 
    333331    rank int, 
    334332    creator_id int NOT NULL, 
     
    343341    name text, 
    344342    class_id int NOT NULL, 
    345     status smallint, 
    346343    rank int, 
    347344    creator_id int NOT NULL, 
     
    458455    del_flg smallint NOT NULL DEFAULT 0, 
    459456    PRIMARY KEY (review_id) 
    460 ) TYPE=InnoDB; 
    461  
    462 CREATE TABLE dtb_customer_reading ( 
    463     reading_product_id int NOT NULL, 
    464     customer_id int NOT NULL, 
    465     create_date datetime NOT NULL, 
    466     update_date datetime NOT NULL 
    467457) TYPE=InnoDB; 
    468458 
     
    563553    update_date datetime, 
    564554    del_flg smallint NOT NULL DEFAULT 0, 
    565     cell01 text, 
    566     cell02 text, 
    567     cell03 text, 
    568555    mobile_phone_id text, 
    569556    mailmaga_flg smallint, 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r19662 r19669  
    317317    deliv_fee numeric, 
    318318    point_rate numeric, 
    319     status smallint, 
    320319    creator_id int NOT NULL, 
    321320    create_date timestamp NOT NULL DEFAULT now(), 
     
    330329    class_id int NOT NULL, 
    331330    name text, 
    332     status smallint, 
    333331    rank int, 
    334332    creator_id int NOT NULL, 
     
    343341    name text, 
    344342    class_id int NOT NULL, 
    345     status smallint, 
    346343    rank int, 
    347344    creator_id int NOT NULL, 
     
    459456    del_flg smallint NOT NULL DEFAULT 0, 
    460457    PRIMARY KEY (review_id) 
    461 ); 
    462  
    463 CREATE TABLE dtb_customer_reading ( 
    464     reading_product_id int NOT NULL, 
    465     customer_id int NOT NULL, 
    466     create_date timestamp NOT NULL, 
    467     update_date timestamp NOT NULL DEFAULT NOW() 
    468458); 
    469459 
     
    565555    update_date timestamp DEFAULT now(), 
    566556    del_flg smallint NOT NULL DEFAULT 0, 
    567     cell01 text, 
    568     cell02 text, 
    569     cell03 text, 
    570557    mobile_phone_id text, 
    571558    mailmaga_flg smallint, 
  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r19665 r19669  
    3737INSERT INTO dtb_category_total_count (category_id, product_count, create_date) VALUES (4, 1, CURRENT_TIMESTAMP); 
    3838 
    39 INSERT INTO dtb_class (class_id, name, status, rank, creator_id, create_date, update_date, del_flg) VALUES (1, '味', NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    40 INSERT INTO dtb_class (class_id, name, status, rank, creator_id, create_date, update_date, del_flg) VALUES (2, '大きさ', NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    41  
    42 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (1, 'バニラ', 1, NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    43 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (2, 'チョコ', 1, NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    44 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (3, '抹茶', 1, NULL, 3, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    45 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (4, 'L', 2, NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    46 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (5, 'M', 2, NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    47 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (6, 'S', 2, NULL, 3, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    48 INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (0, NULL, 0, NULL, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     39INSERT INTO dtb_class (class_id, name, rank, creator_id, create_date, update_date, del_flg) VALUES (1, '味', 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     40INSERT INTO dtb_class (class_id, name, rank, creator_id, create_date, update_date, del_flg) VALUES (2, '大きさ', 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     41INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (1, 'バニラ', 1, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     42INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (2, 'チョコ', 1, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     43INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (3, '抹茶', 1, 3, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     44INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (4, 'L', 2, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     45INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (5, 'M', 2, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     46INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (6, 'S', 2, 3, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     47INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (0, NULL, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    4948 
    5049INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (1, 1, 'product_id', '商品ID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     
    393392INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (2, 'おなべ', NULL, 1, 1, NULL, NULL, '鍋,なべ,ナベ', NULL, NULL, NULL, NULL, '一人用からあります。', '08311311_44f661811fec0.jpg', 'たまには鍋でもどうでしょう。', '08311313_44f661dc649fb.jpg', '08311313_44f661e5698a6.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 3); 
    394393 
    395 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(1, 1, 10, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    396 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(2, 1, 11, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    397 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(3, 1, 12, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    398 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(4, 1, 13, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    399 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(5, 1, 14, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    400 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(6, 1, 15, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    401 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(7, 1, 16, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    402 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(8, 1, 17, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    403 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(9, 1, 18, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    404 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(10, 2, NULL, 'nabe-01', 100, 0, 5, 1700, 1650, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     394INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(1, 1, 10, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     395INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(2, 1, 11, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     396INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(3, 1, 12, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     397INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(4, 1, 13, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     398INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(5, 1, 14, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     399INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(6, 1, 15, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     400INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(7, 1, 16, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     401INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(8, 1, 17, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     402INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(9, 1, 18, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     403INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, creator_id, create_date, update_date, del_flg, product_type_id, down_filename, down_realfilename) VALUES(10, 2, NULL, 'nabe-01', 100, 0, 5, 1700, 1650, NULL, 10, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    405404 
    406405INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(1, NULL, 3, 1); 
Note: See TracChangeset for help on using the changeset viewer.