オープンソースの販売サイト構築ソフト EC-CUBE についてのメモ。

2.12.0 から 2.12.1

SQL (mtb_customer_order_status)

CREATE TABLE mtb_customer_order_status (
    id SMALLINT,
    name text,
    rank SMALLINT NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (7, '注文未完了', 0);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (1, '注文受付', 1);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (2, '入金待ち', 2);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (6, '注文受付', 3);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (3, 'キャンセル', 4);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (4, '注文受付', 5);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (5, '発送済み', 6);

SQL (dtb_recommend_products)

-- PostgreSQL 用
ALTER TABLE dtb_recommend_products DROP CONSTRAINT dtb_recommend_products_pkey;
-- MySQL 用
ALTER TABLE dtb_recommend_products DROP PRIMARY KEY;
 
-- 以下共通
DELETE FROM dtb_recommend_products 
WHERE EXISTS(
    SELECT *
    FROM dtb_recommend_products sub
    WHERE sub.product_id = dtb_recommend_products.product_id
        AND sub.recommend_product_id = dtb_recommend_products.recommend_product_id
        AND sub.rank > dtb_recommend_products.rank
)
;
ALTER TABLE dtb_recommend_products ADD PRIMARY KEY (product_id, recommend_product_id);

SQL (他DDL)

該当なし

SQL (他DML)

UPDATE dtb_csv
SET size_const_type = 'LTEXT_LEN'
WHERE no = 70 AND size_const_type = 'STEXT_LEN'
;
UPDATE mtb_constants
SET name = '"LC_Page_preProcess"'
WHERE id = 'HOOK_POINT_PREPROCESS' AND name = 'LC_Page_preProcess'
;
UPDATE mtb_constants
SET name = '"LC_Page_process"'
WHERE id = 'HOOK_POINT_PROCESS' AND name = 'LC_Page_process'
;
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MYPAGE_ORDER_STATUS_DISP_FLAG', 'true', 1412, 'MYページ:ご注文状況表示フラグ');

ファイル

変更:
  data/Smarty/templates/admin/basis/delivery_input.tpl
  data/Smarty/templates/admin/basis/kiyaku.tpl
  data/Smarty/templates/admin/customer/edit_confirm.tpl
  data/Smarty/templates/admin/home.tpl
  data/Smarty/templates/admin/order/product_select.tpl
  data/Smarty/templates/admin/ownersstore/plugin.tpl
  data/Smarty/templates/admin/products/confirm.tpl
  data/Smarty/templates/admin/products/product_select.tpl
  data/Smarty/templates/admin/products/review.tpl
  data/Smarty/templates/admin/products/upload_csv_complete.tpl
  data/Smarty/templates/default/mypage/index.tpl
  data/Smarty/templates/default/products/list.tpl
  data/class/SC_CartSession.php
  data/class/SC_CheckError.php
  data/class/SC_ClassAutoloader.php
  data/class/SC_CustomerList.php
  data/class/SC_Date.php
  data/class/SC_Display.php
  data/class/SC_FormParam.php
  data/class/SC_Fpdf.php
  data/class/SC_Image.php
  data/class/SC_Initial.php
  data/class/SC_MobileEmoji.php
  data/class/SC_MobileImage.php
  data/class/SC_Product.php
  data/class/SC_Query.php
  data/class/SC_SelectSql.php
  data/class/SC_SendMail.php
  data/class/SC_UploadFile.php
  data/class/SC_View.php
  data/class/api/operations/ItemSearch.php
  data/class/db/SC_DB_MasterData.php
  data/class/helper/SC_Helper_CSV.php
  data/class/helper/SC_Helper_DB.php
  data/class/helper/SC_Helper_FPDI.php
  data/class/helper/SC_Helper_FileManager.php
  data/class/helper/SC_Helper_HandleError.php
  data/class/helper/SC_Helper_Mail.php
  data/class/helper/SC_Helper_Mobile.php
  data/class/helper/SC_Helper_PageLayout.php
  data/class/helper/SC_Helper_Plugin.php
  data/class/helper/SC_Helper_Purchase.php
  data/class/helper/SC_Helper_Transform.php
  data/class/pages/LC_Page_ResizeImage.php
  data/class/pages/LC_Page_Sitemap.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_PaymentInput.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_FileManager.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php
  data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Class.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Maker.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Product.php
  data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Review.php
  data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php
  data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php
  data/class/pages/admin/total/LC_Page_Admin_Total.php
  data/class/pages/cart/LC_Page_Cart.php
  data/class/pages/entry/LC_Page_Entry.php
  data/class/pages/entry/LC_Page_Entry_EmailMobile.php
  data/class/pages/forgot/LC_Page_Forgot.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php
  data/class/pages/mypage/LC_Page_Mypage.php
  data/class/pages/mypage/LC_Page_Mypage_Change.php
  data/class/pages/products/LC_Page_Products_Detail.php
  data/class/pages/products/LC_Page_Products_List.php
  data/class/pages/regist/LC_Page_Regist.php
  data/class/pages/rss/LC_Page_Rss.php
  data/class/pages/shopping/LC_Page_Shopping.php
  data/class/pages/shopping/LC_Page_Shopping_Confirm.php
  data/class/pages/shopping/LC_Page_Shopping_Deliv.php
  data/class/pages/shopping/LC_Page_Shopping_Multiple.php
  data/class/pages/shopping/LC_Page_Shopping_Payment.php
  data/class/pages/upgrade/LC_Page_Upgrade_Base.php
  data/class/pages/upgrade/helper/LC_Upgrade_Helper_Json.php
  data/class/plugin/SC_Plugin_Base.php
  data/class/plugin/SC_Plugin_Util.php
  data/class/util/GC_Utils.php
  data/class/util/SC_Utils.php
  data/downloads/KEN_ALL.CSV
  data/mtb_constants_init.php
  data/require_compat.php
  html/admin/require.php
  html/install/index.php
  html/install/sql/create_table_mysql.sql
  html/install/sql/create_table_pgsql.sql
  html/install/sql/drop_table.sql
  html/install/sql/insert_data.sql
  html/js/jquery.facebox/facebox.js
  html/js/products.js
  html/js/site.js
  html/require.php
  test/createEcCubeData-v25.php
アップデート/2.12/2.12.0_2.12.1.txt · 最終更新: 2012/07/25 18:49 by seasoft
© 2008-2024 Seasoft.