Ignore:
Timestamp:
2010/09/20 20:40:27 (16 years ago)
Author:
nanasess
bzr:base-revision:
svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18814
bzr:committer:
Kentaro Ohkouchi <[email protected]>
bzr:file-ids:

data/Smarty/templates/default/admin/products/product_class.tpl 15732@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fadmin%2Fproducts%2Fproduct_class.tpl
data/class/SC_Initial.php 16506@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Initial.php
data/class/SC_Product.php 18277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2FSC_Product.php
data/class/SC_Query.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Query.php
data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php 15123@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fdb%2Fdbfactory%2FSC_DB_DBFactory_MYSQL.php
data/class/helper/SC_Helper_CSV.php 15535@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_CSV.php
data/class/helper/SC_Helper_DB.php 15176@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_DB.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php 15661@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_RecommendSearch.php
data/class/pages/admin/customer/LC_Page_Admin_Customer.php 15568@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcustomer%2FLC_Page_Admin_Customer.php
data/class/pages/admin/mail/LC_Page_Admin_Mail.php 15640@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail.php
data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php 15654@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail_Preview.php
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php 17293@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fadmin%2Forder%2FLC_Page_Admin_Order_ProductSelect.php
data/class/pages/admin/products/LC_Page_Admin_Products.php 15342@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products.php
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php 15342@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_Product.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 15559@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductClass.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 15526@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductRank.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php 15557@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductSelect.php
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php 15367@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Ffrontparts%2Fbloc%2FLC_Page_FrontParts_Bloc_Best5.php
data/class/pages/mypage/LC_Page_Mypage_Favorite.php 17162@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Favorite.php
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
data/class/pages/products/LC_Page_Products_List.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_List.php
data/class/pages/rss/LC_Page_Rss_Products.php 16193@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Frss%2FLC_Page_Rss_Products.php
data/class/pages/shopping/LC_Page_Shopping_Complete.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Complete.php
data/class/util/SC_Utils.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Futil%2FSC_Utils.php
data/install.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Finstall.php
data/require_classes.php 18500@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_4-dev%2Fdata%2Frequire_classes.php
html/admin/require.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Fadmin%2Frequire.php
html/handle_error.php 18500@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_4-dev%2Fhtml%2Fhandle_error.php
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.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/create_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_view.sql
html/install/sql/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.sql
html/install/sql/drop_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_view.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
html/require.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Frequire.php
test/class/page/LC_Page_Admin_Products_ProductClass_Test.php lc_page_admin_produc-20100910101923-ux7d8xbbsd4inq1c-1
bzr:mapping-version:
v4
bzr:merge:

[email protected]
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
[email protected]
bzr:revno:
2298
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:text-parents:

data/Smarty/templates/default/admin/products/product_class.tpl [email protected]
data/class/SC_Initial.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18795 [email protected]
data/class/SC_Product.php [email protected]
data/class/SC_Query.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18813 [email protected]
data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php [email protected]
data/class/helper/SC_Helper_CSV.php [email protected]
data/class/helper/SC_Helper_DB.php [email protected]
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php [email protected]
data/class/pages/admin/customer/LC_Page_Admin_Customer.php [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18798 [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php [email protected]
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php [email protected]
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Favorite.php [email protected]
data/class/pages/products/LC_Page_Products_Detail.php [email protected]
data/class/pages/products/LC_Page_Products_List.php [email protected]
data/class/pages/rss/LC_Page_Rss_Products.php [email protected]
data/class/pages/shopping/LC_Page_Shopping_Complete.php [email protected]
data/class/util/SC_Utils.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18812 [email protected]
data/install.php [email protected]
data/require_classes.php [email protected]
html/admin/require.php [email protected] [email protected]
html/handle_error.php [email protected] [email protected]
html/install/index.php [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/create_view.sql [email protected]
html/install/sql/drop_table.sql [email protected]
html/install/sql/drop_view.sql [email protected]
html/install/sql/insert_data.sql [email protected]
html/require.php [email protected] [email protected]
bzr:text-revisions:

data/Smarty/templates/default/admin/products/product_class.tpl [email protected]
data/class/SC_Product.php [email protected]
data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php [email protected]
data/class/helper/SC_Helper_CSV.php [email protected]
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php [email protected]
data/class/pages/admin/customer/LC_Page_Admin_Customer.php [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php [email protected]
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php [email protected]
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Favorite.php [email protected]
data/class/pages/products/LC_Page_Products_Detail.php [email protected]
data/class/pages/products/LC_Page_Products_List.php [email protected]
data/class/pages/rss/LC_Page_Rss_Products.php [email protected]
data/class/pages/shopping/LC_Page_Shopping_Complete.php [email protected]
data/require_classes.php [email protected]
html/install/index.php [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/create_view.sql [email protected]
html/install/sql/drop_table.sql [email protected]
html/install/sql/drop_view.sql [email protected]
html/install/sql/insert_data.sql [email protected]
test/class/page/LC_Page_Admin_Products_ProductClass_Test.php [email protected]
bzr:timestamp:
2010-09-20 20:39:58.994999886 +0900
bzr:user-agent:
bzr2.1.1+bzr-svn1.0.2
svn:original-date:
2010-09-20T11:39:58.995000Z
Message:

規格まわりの内部構成変更に伴う修正(#781)

  • 規格のデータ構造を木構造へ変更
  • 商品検索ロジックを SC_Product クラスへできるだけ集約
  • 以下の VIEW を削除
    • vw_category_count;
    • vw_product_class;
    • vw_products_nonclass;
    • vw_cross_products_class;
    • vw_cross_class;
    • vw_download_class;
File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

    r18793 r18815  
    307307        if (empty($sql)) { 
    308308 
    309             $sql['vw_cross_class'] = <<< __EOS__ 
    310                 ( 
    311                     SELECT 
    312                         T1.class_id AS class_id1, 
    313                         T2.class_id AS class_id2, 
    314                         T1.classcategory_id AS classcategory_id1, 
    315                         T2.classcategory_id AS classcategory_id2, 
    316                         T1.name AS name1, 
    317                         T2.name AS name2, 
    318                         T1.rank AS rank1, 
    319                         T2.rank AS rank2 
    320                     FROM 
    321                         dtb_classcategory AS T1, 
    322                         dtb_classcategory AS T2 
    323                 ) 
    324 __EOS__; 
    325  
    326             $sql['vw_cross_products_class'] = <<< __EOS__ 
    327                 ( 
    328                     SELECT 
    329                         T1.class_id1, 
    330                         T1.class_id2, 
    331                         T1.classcategory_id1, 
    332                         T1.classcategory_id2, 
    333                         T2.product_id, 
    334                         T1.name1, 
    335                         T1.name2, 
    336                         T2.product_code, 
    337                         T2.stock, 
    338                         T2.price01, 
    339                         T2.price02, 
    340                         T1.rank1, 
    341                         T1.rank2 
    342                     FROM 
    343                         {$sql['vw_cross_class']} AS T1 
    344                         LEFT JOIN dtb_products_class AS T2 
    345                             ON T1.classcategory_id1 = T2.classcategory_id1 
    346                             AND T1.classcategory_id2 = T2.classcategory_id2 
    347                 ) 
    348 __EOS__; 
    349  
    350             $sql['vw_products_nonclass'] = <<< __EOS__ 
    351                 ( 
    352                     SELECT * 
    353                     FROM 
    354                         dtb_products AS T1 
    355                         LEFT JOIN 
    356                         ( 
    357                             SELECT 
    358                                 product_id AS product_id_sub, 
    359                                 product_code, 
    360                                 price01, 
    361                                 price02, 
    362                                 stock, 
    363                                 stock_unlimited, 
    364                                 classcategory_id1, 
    365                                 classcategory_id2 
    366                             FROM dtb_products_class 
    367                             WHERE 
    368                                 classcategory_id1 = 0 
    369                                 AND classcategory_id2 = 0 
    370                         ) AS T2 
    371                         ON T1.product_id = T2.product_id_sub 
    372                 ) 
    373 __EOS__; 
    374309 
    375310            $sql['vw_products_allclass_detail'] = <<< __EOS__ 
    … …  
    378313                        dtb_products.product_id, 
    379314                        dtb_products.name, 
    380                         dtb_products.deliv_fee, 
    381                         dtb_products.sale_limit, 
    382315                        dtb_products.maker_id, 
    383316                        dtb_products.rank, 
    384317                        dtb_products.status, 
    385                         dtb_products.product_flag, 
    386                         dtb_products.point_rate, 
    387318                        dtb_products.comment1, 
    388319                        dtb_products.comment2, 
    … …  
    448379                    FROM 
    449380                        dtb_products 
    450                         LEFT JOIN 
     381                    JOIN 
    451382                            ( 
    452383                                SELECT 
    … …  
    488419__EOS__; 
    489420 
    490             $sql['vw_product_class'] = <<< __EOS__ 
    491                 (SELECT * FROM 
    492                 (SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, 
    493                 T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2, 
    494                 stock, price01, price02, stock_unlimited, product_code 
    495                 FROM ( SELECT 
    496                         T1.product_class_id, 
    497                         T1.product_id, 
    498                         classcategory_id1, 
    499                         classcategory_id2, 
    500                         T2.rank, 
    501                         T2.class_id, 
    502                         stock, 
    503                         price01, 
    504                         price02, 
    505                         stock_unlimited, 
    506                         product_code 
    507                  FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2 
    508                 ON T1.classcategory_id1 = T2.classcategory_id)) 
    509                 AS T3 LEFT JOIN dtb_classcategory AS T4 
    510                 ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6 
    511                 ON product_id_sub = T6.product_id) 
    512 __EOS__; 
    513  
    514             $sql['vw_category_count'] = <<< __EOS__ 
    515                 (SELECT T1.category_id, T1.category_name, T1.parent_category_id, T1.level, T1.rank, T2.product_count 
    516                 FROM dtb_category AS T1 LEFT JOIN dtb_category_total_count AS T2 
    517                 ON T1.category_id = T2.category_id) 
    518 __EOS__; 
    519  
    520             $sql['vw_download_class'] = <<< __EOS__ 
    521                 (SELECT p.product_id AS product_id, p.down_realfilename AS down_realfilename , p.down_filename AS down_filename, od.order_id AS order_id, o.customer_id AS customer_id, o.commit_date AS commit_date, o.status AS status FROM 
    522                     dtb_products p, dtb_order_detail od, dtb_order o 
    523                 WHERE p.product_id = od.product_id AND od.order_id = o.order_id) 
    524 __EOS__; 
    525421        } 
    526422 
Note: See TracChangeset for help on using the changeset viewer.