0.)因為刷卡功能報錯,還原系統恢復功能
20200309 ADA 11:52:57
弄回去 0121版本, 前台可刷上但後台掛掉, 把後台重REINDEX, 後台好了, 前台只有 buck4u 可以, buck4all 和 mag2 都掛掉, 
而且 buck4u 不能刷卡, 換來換去, 最後又弄回今天的版本

1.)還原mag2目錄改用magento8pm-20200121
rm -Rf magento8pm
mv magento8pm-20200121 magento8pm
->Required parameter 'theme_dir' was not passed
添加新theme 6pm
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/
cp 8pm 6pm -r
cd 6pm
joe registration.php
joe theme.xml
cd /var/www/html/magento8pm/app/design/frontend/
chown -R www-data:www-data .
chown www-data:www-data 7pm
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/web/
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Themesettings/web/
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Themesettings/web/
chown www-data:www-data css

->前台可刷卡但後台掛掉, 把後台重REINDEX->我reindex 後台仍上不了
cd /var/www/html/magento8pm
/usr/bin/php bin/magento indexer:reindex
/usr/bin/php bin/magento cache:flush

2.)還原資料庫改用magento8pm-20200215-ok
->前後台都會直接跳到buck4all.com
先改conf為demo2,進後台後再改為b4u_home
cd /etc/apache2/sites-available
joe buck4u.conf ->
joe buck4u-ssl.conf ->
SetEnv MAGE_RUN_CODE "b4u_home" -> 原為 "demo2"
service apache2 restart
->關閉wysiwyg editer
STORES->Configuration->General->Content Management->WYSIWYG Options->Enable WYSIWYG Editor->Disabled Completely
->去掉產品頁Short Description,Share,加SKU
STORES->Configuration->VES THEMESETTINGS->Product View Page->Other Elements
->去掉產品頁Paypal+Paypal credit icon
STORES->Configuration->SALES->Payment Methods->PayPal Express Checkout->Configure->Basic Setting->Display on Product Details Page->No

3.)修改Store View的code,theme(Head,Header,Footer),Base URL,Default page
b4u_home->b4u_home + 7pm(buck4u.com) + www.buck4u.com + buck4u.com
pwc_ro->pwc_ro + 6pm(purewaterclub.com) + mag2.purewaterclub.com + purewaterclub.com
3-1.)修改Home Page
b4u_home->Page:buck4u.com->Ves-Page:buck4u-home-page
pwc_ro->Page:purewaterclub.com->Ves-Page:pwc-home-page
3-2.)修改Mega Menu
共用目錄頁->blank:menu-top(不存在,不會出現)
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top</argument>
b4u_home->7pm:menu-top-b4u
/var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top-b4u</argument>
pwc_ro->6pm:menu-top-pwc
/var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top-pwc</argument>
					改goto old site -> http://last.pureaterclub.com/

4.)重新建立圖片根位置連結
cd /var/www/html/magento8pm/pub/media/
mv catalog catalog-0
ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/
mv wysiwyg wysiwyg-0
ln -s /var/www/html/pwpic/wysiwyg/ /var/www/html/magento8pm/pub/media/

mv /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images-0
mv /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images-0
mv /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/web/images /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/web/images-0
ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/
ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/
ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/web/

5.)修改自建目錄頁連結
改pwc-dir-47->Design
http://www.buck4all.com/index.php/ro/replacement.html -> ro/replacement.html
改pwc-dir-50->Design
改pwc-dir-65->Design
改pwc-dir-68->Design
http://www.buck4all.com/index.php/ro/combo-set.html -> combo-set.html

6.)重新導入Old RO 客戶資料
->手工刪除Old RO 黑客注冊垃圾帳號
DELETE FROM address_book WHERE entry_country_id='50' -> 1 record (CK Cook Islands)
DELETE FROM address_book WHERE entry_country_id='17' -> 2 record (BH Bahrain)
DELETE FROM address_book WHERE entry_country_id='88' -> 1 record (GU Guam)
DELETE FROM address_book WHERE entry_country_id='232' -> 1 record (VI Virgin Islands (U.S.)
UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 5 record
DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 5 record
->http://www.purewaterclub.com/gen-customer-csv.php
Checked rows: 9126, checked entities: 18252, invalid rows: 0, total errors: 0
->手工刪除mag2 客戶資料無用帳號
ID=2066->lake757@yahoo.com->VI
ID=6462->mm@mm.com
ID=6515->mmm@mm.com
ID=7536->ugamnut56@hotmail.com->GU
Customers 9129 records found

7.)清Catalog + Attribute Set + Product Attributes
刪Catalog 
A total of 71(disable)+19(qq%)+(Arcadio Gym Short-33-Red) have been deleted.
362 records found + (ADA-TEST-Metal aerator faucet adapter SP-aerator-M->ADA-TEST)
->更新產品出錯Required parameter 'theme_dir' was not passed
刪除theme Zou,6pm,7pm 重新添加新theme 6pm,7pm
刪除表theme中的x-Venustheme - 8pm,Zou/demo

刪Attribute Set
Bag,Bottom,Downloadable,Gear,ro-qq-003,Sprite Stasis Ball,Sprite Yoga Strap,Top
The attribute set has been removed.(8 record)
增加Product Attributes
free_shipping,b4_free_shipping
修改Attribute Set:default

刪Product Attributes 舊的8pm + ro-qq
activity,Category Gear,Climate,Collar,eco_collection,erin_recommends,features_bags,format,gender,pattern,performance_fabric,size,
sleeve,strap_bags,style_bags,style_bottom,style_general
ro_qq_003_size
You deleted the product attribute.
53 records found

改目錄頁footer
改buck4u shipping
install extension disable compare
上新item mailer

--- 20200309-10 恢復刷卡功能->還原目錄magento8pm-20200121+資料庫magento8pm-20200215-ok + 重新補作所有修改
=========================================================================================================================
改short description tilte為shipping
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Magento_Catalog/templates/product/view
joe product_info_main.phtml
<span class="label label-sdesc"><?php /* @escapeNotVerified */ echo __('Product Description') ?></span> ->
<span class="label label-sdesc"><?php /* @escapeNotVerified */ echo __('Shipping Handling') ?></span>

FREE SHIPPING ON ORDERS OVER $35
Shipping and handling

Free shipping on orders over $35.00 when you buy ellielantern's other eligible items, and use the cart to make your purchase.
$0.25 shipping for each additional eligible item you buy from ellielantern, when you use the cart to make your purchase.

Shipping discount will be applied when you add qualifying items from ellielantern to your cart
All promotional offers from ellielantern

cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/web/
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Themesettings/web/
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Themesettings/web/
chown www-data:www-data css

The system has an issue when create css file
Message: The path "design/frontend/Venustheme/7pm/Ves_Themesettings/web/css:///var/www/html/magento8pm/app/var/www/html/magento8pm/app/" is not writable
The system has an issue when create css file
Message: The path "design/frontend/Venustheme/7pm/Ves_Themesettings/web/css:///var/www/html/magento8pm/app/var/www/html/magento8pm/app/" is not writable
The system has an issue when create css file
Message: The path "design/frontend/Venustheme/6pm/Ves_Themesettings/web/css:///var/www/html/magento8pm/app/var/www/html/magento8pm/app/" is not writable

tar -czf pwpic-20200223.tar.gz *
-rw-r--r--  1 root     root     274210605 Feb 24 01:25 pwpic-20200223.tar.gz
zip -r pwpic-20200223.zip ./
-rw-r--r--  1 root     root     285427566 Feb 24 01:29 pwpic-20200223.zip

DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 2 record
DELETE FROM address_book WHERE entry_lastname LIKE 'dhfh' -> 3 record
DELETE FROM address_book WHERE entry_country_id='121' -> 1 record (LY Libyan)
UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 5 record
DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 5 record
Checked rows: 9, checked entities: 18, invalid rows: 0, total errors: 0
Customers 9117 records found

去掉產品頁Paypal+Paypal credit icon
STORES->Configuration->SALES->Payment Methods->PayPal Express Checkout->Configure->Basic Setting->Display on Product Details Page->No

--- 20200224 打包下載所有圖片 + 建mag2.purewaterclub.com取代www.buck4all.com + 補上傳新增9客戶資料
=========================================================================================================================
添加新theme 6pm
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/
cp 8pm 6pm -r
cd 6pm
joe registration.php
joe theme.xml
直接改不同的default.xml可改變Ves header使用MegaMenu的名稱
blank的menu一定要用,被設為default(menu-top),無法在目錄頁針對不同Theme對應不同menu
1.)blank(關閉menu給pwc+b4共用目錄頁Theme)
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top</argument>
2.)b4u
/var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top-b4u</argument>
3.)pwc
/var/www/html/magento8pm/app/design/frontend/Venustheme/6pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top-pwc</argument>

--- 20200223 增加新Theme
=========================================================================================================================
1.)合併所有圖片pwpic + /var/www/html/magento8pm/pub/media/
cd /var/www/html/pwpic/catalog/
mkdir category
cd category
cp -r /var/www/html/magento8pm/pub/media/catalog/category/* ./
mkdir product
cd product
cp -r /var/www/html/magento8pm/pub/media/catalog/product/* ./
重新安排圖片位置
mv /var/www/html/pwpic/items /var/www/html/pwpic/webimg/items
mv /var/www/html/pwpic/catalog/images/* /var/www/html/pwpic/import/*
圖片根位置:
/var/www/html/pwpic/ ->
/catalog/category/ (系統目錄圖片位置)  -> ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/
/catalog/product/  (系統產品圖片位置)  -> ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/
/wysiwyg/          (自建目錄頁圖片位置url media)-> ln -s /var/www/html/pwpic/wysiwyg/ /var/www/html/magento8pm/pub/media/
/themeimg/         (Theme使用logo-背景圖片位置)-> ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/
/import/					 (後台import上傳產品csv圖片位置)
/webimg/					 (pwc產品說明頁img src圖片位置) 

修改aws.wg-1.com 指向+對應 AWS /var/www/html/pwpic/webimg
cd /etc/apache2/sites-available
joe aws-wg-1.conf ->
DocumentRoot /var/www/html/pwpic ->  DocumentRoot /var/www/html/pwpic/webimg
service apache2 restart

測試上傳產品csv圖片成功
sku,store_view_code,attribute_set_code,product_type,categories,product_websites,name,description,short_description,weight,product_online,tax_class_name,visibility,price,special_price,special_price_from_date,special_price_to_date,url_key,meta_title,meta_keywords,meta_description,base_image,base_image_label,small_image,small_image_label,thumbnail_image,thumbnail_image_label,swatch_image,swatch_image_label,created_at,updated_at,new_from_date,new_to_date,display_product_options_in,map_price,msrp_price,map_enabled,gift_message_available,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,product_options_container,msrp_display_actual_price_type,country_of_manufacture,additional_attributes,qty,out_of_stock_qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,related_skus,related_position,crosssell_skus,crosssell_position,upsell_skus,upsell_position,additional_images,additional_image_labels,hide_from_product_page,bundle_price_type,bundle_sku_type,bundle_price_view,bundle_weight_type,bundle_values,bundle_shipment_type,associated_skus
ADA-TEST,,b4_bag,simple,"Default Category/PWC,Default Category/PWC/Parts & Tools,Default Category/PWC/Parts & Tools/Feeders,Default Category/PWC/Parts & Tools/Fittings",base,ADA-TEST,,,1,1,0,"Catalog, Search",0.1,,,,ada-test,,,,"/import/22-103.jpg",,"/import/22-08.jpg",,"/import/22-08.jpg",,"/import/22-08.jpg",,"2/3/20, 5:23 PM","2/18/20, 8:08 PM",,,Block after Info Column,,,,No,,,,,,,Use config,,"b4_free_shipping=Yes,featured=Yes,free_shipping=Yes,new=No",999,0,1,0,0,1,1,1,10000,1,1,1,1,1,1,1,1,1,0,0,0,,,,,,,,,,,,,,,,

2.)改原系統位置名稱 + 搬離至pwpic-0
mv /var/www/html/magento8pm/pub/media/catalog /var/www/html/magento8pm/pub/media/catalog-0
mv /var/www/html/magento8pm/pub/media/wysiwyg /var/www/html/magento8pm/pub/media/wysiwyg-0
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/
mv images/ images-0
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/
mv images/ images-0
mv /var/www/html/magento8pm/pub/media/catalog-0 /var/www/html/pwpic-0/
mv /var/www/html/magento8pm/pub/media/wysiwyg-0 /var/www/html/pwpic-0/

3.)建catalog,wysiwyg連結
ln -s /var/www/html/pwpic/catalog/ /var/www/html/magento8pm/pub/media/(產品圖片)
ln -s /var/www/html/pwpic/wysiwyg/ /var/www/html/magento8pm/pub/media/(系統使用圖片路徑 url media)
ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/(Theme使用logo-背景圖片位置)
ln -s /var/www/html/pwpic/themeimg/images/ /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/(Theme使用logo-背景圖片位置)

--- 20200222-23 整理aws所有圖片 + 新位置連結 -> /var/www/html/pwpic/
=========================================================================================================================
1.) shipping: 現在新RO站(包括將來的1元店)的shipping有3種
  a.) 原本舊RO站的free-shipping->只要是同一order有買正常單價的item,就可以整單都free
  b.) 新增1元站(b4_free_shippint)->只要買了1元店站b4_free_shipping的item加起來滿$25(金額可隨時修改),就整單都free
  c.) 如果以上2個條件都沒有,就收$5(金額可隨時修改,也可以改成按zone,重量計算)

2.) ebay: 因為QT2進了很多包裝材料,所以請先從包裝材料開始上架ebay和1元站的銷售
  a.) 請把ebay的cutiepetinc帳號改成 buck4u*com
  b.) 請先參考以下1元站我已經上架的poly bubble mailers(珠光膜氣泡信封), 
http://www.buck4all.com/index.php/poly-bubble-mailer.html

其中表上的Qty/Set是我用成本價小於等於US$0.3(人民幣2元)倒算出來的1元的數量,是按之前計劃好的(產品成本30%,locat運費30%,利潤30%,其他10%計算),
實際應該出的數量,要請你仔細估算成本運費後,再通知我要如何修正,另外你也可以不用賣1元的方式,直接上架ebay,請你自己決定,以下是ebay的熱門seller和ULINE的參考
https://www.uline.com/BL_1255/Uline-Bubble-Lined-Poly-Mailers
https://www.ebay.com/itm/100-50-Poly-Mailer-Bubble-Mailers-Padded-Envelopes-6x9-8-5x11-9x12-5x7-3x5-4x6/272820340492
(這一家在wulnat,可以好好參考一下)
https://www.ebay.com/itm/50-000-4x8-Poly-Bubble-Padded-Envelopes-Mailer/321898703486
https://www.ebay.com/itm/Wholesale-10Pcs-Poly-Bubble-Mailers-Padded-Envelopes-Shipping-Bags-Self-Seal/232374230866
https://www.ebay.com/itm/25-0-Glamour-Metallic-Pink-Poly-Bubble-Mailers-Envelopes-Bags-6x10-DVD-Wide-CD/292602069600?epid=5020360655

  c.) 請先在試一下在ebay用cutiepetinc和purewaterclub*com帳號分別上架poly bubble mailers(珠光膜氣泡信封),
附件有name(101.c.txt) + 說明(101.c.html) + 產品主圖組 (101.c.jpg.zip) + 原始圖片(101-0.jpg.zip) + 標示文字圖片(101.jpg.zip) + photoshop工作檔案(101.c.psd)請SC教你如何操作
  d.) 101.c->代表(101.01-101.11)的configute product (讓客人用來挑選不同尺寸規格的虛擬產品,將來1元站會大量使用), 客人挑選後下單的是(101.01x16~101.11x3)共11種產品組合中的一種

--- 20200221 交接 poly bubble mailer to ebay
=========================================================================================================================
修改Store View buck4u.com home page->b4u_home
cd /etc/apache2/sites-available
joe buck4u.conf ->
joe buck4u-ssl.conf ->
SetEnv MAGE_RUN_CODE "b4u_home" -> 原為 "demo2"
service apache2 restart

find . -name "101.c*"
目錄圖片的位置
/var/www/html/magento8pm/pub/media/catalog/category/100-GDP.png
(20200222)改連結到/var/www/html/pwpic/catalog/category/100-GDP.png
產品圖片的位置
/var/www/html/magento8pm/pub/media/catalog/product/1/0/101.c-5.jpg
(20200222)改連結到/var/www/html/pwpic/catalog/product/1/0/101.c-5.jpg
/1/0/->取圖片名的前2字母
/cache/->分5子目錄->image,small_image,swatch_image,swatch_thumb,thumbnail->其下再分不同尺寸圖片目錄,為cache的圖片最後位置
導入產品圖片的位置
/var/www/html/pwpic/
/catalog/images/->產品主圖
/items/->產品說明插圖片
/wysiwyg/pwc/->子目錄連結用圖片->ln -s /var/www/html/pwpic/wysiwyg/pwc/ /var/www/html/magento8pm/pub/media/wysiwyg/(系統使用圖片路徑)
(20200222)刪除pwc連結,改直接連結上一層到/var/www/html/pwpic/wysiwyg
/pwpic/->link to /var/www/html/pwpic/(為了導入產品時填Images File Directory用?)
(20200222)刪除pwpic連結

成功->(20200222)改連結到/var/www/html/pwpic/
放棄->改產品圖片的位置->b4pic:
cd /var/www/html/b4pic/
mkdir catalog/product
cd catalog/product 
cp -r /var/www/html/magento8pm/pub/media/catalog/product/* ./
apt-get install zip
apt-get install unzip
zip -r b4pic.zip ./
http://aws.wg-1.com/ -> 指向 /var/www/html/pwpic/
cd /var/www/html/pwpic/
mv /var/www/html/b4pic/catalog/product/b4pic.zip ./
zip -r pwpic.zip ./(x->無限遁環立即占滿所有空間)
----------------------------

--- 20200220 修改 buck4u.com home page + 整理圖片位置 + 下載備份圖片
=========================================================================================================================
1.)RO free_shipping->如果單內有一件free_shipping item->整單free shipping
2.)B4 free_shipping $25+ ->如果單內所有b4_free_shipping合計金額大於等於$25->整單free shipping
3.)Configued product在Cart Price Rules判斷中會以Configure product的attribute為主,而不是以各別的simple product

改PWC->dollar sale->b4_free_shipping
$1->SP-CRT,SP-6044Q,SP-Y,SP-7044Q,SP-7042Q,SP-6044Q,SP-0404Q,SP-4041Q,SP-1044,SP-C clip,SP-aerator-M,SP-aerator-p
$1+->SP-132Q,SP-Q34A,SP-FV

--- 20200218-20 buck4u shipping
=========================================================================================================================
刪Catalog 
A total of 72(disable)+19(qq%) have been deleted.
362 records found + ADA-TEST-Metal aerator faucet adapter SP-aerator-M

刪Attribute Set
Bag,Bottom,Downloadable,Gear,ro-qq-003,Sprite Stasis Ball,Sprite Yoga Strap,Top
The attribute set has been removed.(8 record)
修改Attribute Set:default
增加Product Attributes
free_shipping,b4_free_shipping

刪Product Attributes 舊的8pm() + ro-qq
activity,Category Gear,Climate,Collar,eco_collection,erin_recommends,features_bags,format,gender,pattern,performance_fabric,size,
sleeve,strap_bags,style_bags,style_bottom,style_general
ro_qq_003_size
You deleted the product attribute.
53 records found
140e8587c46ea4afc679cb70bae56341:70:0->aa223344-osc-v.1
$P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0->aa223344-osc-v.2

關閉wysiwyg editer
STORES->Configuration->General->Content Management->WYSIWYG Options->Enable WYSIWYG Editor->Disabled Completely

--- 20200216 清Catalog + Attribute Set + Product Attributes + 關閉wysiwyg editer
=========================================================================================================================
extension disable compare
Access Keys
Public Key: 0c2e51e0297016e62e864f5effe625c7
Private Key: 38410b35ec042696d687ee7c90436d88
Click install extension
Once you redirected to Keys page copy private and public access key
Login to your store admin panel
Go to System > Configurations
Add your public and private key
Save & refresh your page
Web Setup Wizard->404

registration.php
\Magento\Framework\Component\ComponentRegistrar::register(    
    \Magento\Framework\Component\ComponentRegistrar::MODULE,
    'Bss_DisableCompare',
    __DIR__ 
    
aws: cd /var/www/html/magento8pm/app/code/
mkdir Bss/DisableCompare
cd Bss/DisableCompare
wget http://www.purewaterclub.com/aws-ext-20200215.zip ->  unzip aws-ext-20200215.zip
cd /var/www/html/magento8pm
/usr/bin/php bin/magento module:status
-->
List of enabled modules:
Magento_Store
Magento_AdvancedPricingImportExport
Magento_Directory
Magento_Theme
Magento_Backend
Magento_Backup
Magento_Eav
Magento_Customer
Magento_BundleImportExport
Magento_CacheInvalidate
Magento_AdminNotification
Magento_Indexer
Magento_CatalogImportExport
Magento_Cms
Magento_Rule
Magento_Catalog
Magento_Search
Magento_CatalogUrlRewrite
Magento_Widget
Magento_Quote
Magento_CheckoutAgreements
Magento_SalesSequence
Magento_CmsUrlRewrite
Magento_Config
Magento_ConfigurableImportExport
Magento_Msrp
Magento_Contact
Magento_Cookie
Magento_Cron
Magento_CurrencySymbol
Magento_Bundle
Magento_CustomerImportExport
Magento_Deploy
Magento_Developer
Magento_Dhl
Magento_Authorization
Magento_Downloadable
Magento_ImportExport
Magento_Payment
Magento_Email
Magento_User
Magento_Fedex
Magento_Sales
Magento_CatalogInventory
Magento_GoogleAnalytics
Magento_Ui
Magento_GroupedImportExport
Magento_GroupedProduct
Magento_DownloadableImportExport
Magento_Checkout
Magento_Security
Magento_LayeredNavigation
Magento_Marketplace
Magento_MediaStorage
Magento_CatalogRule
Magento_Multishipping
Magento_ConfigurableProduct
Magento_Newsletter
Magento_OfflinePayments
Magento_SalesRule
Magento_PageCache
Magento_Captcha
Magento_Vault
Magento_Persistent
Magento_ProductAlert
Magento_ProductVideo
Magento_Authorizenet
Magento_Reports
Magento_RequireJs
Magento_Review
Magento_Rss
Magento_CatalogRuleConfigurable
Magento_Paypal
Magento_SalesInventory
Magento_OfflineShipping
Magento_GoogleAdwords
Magento_SampleData
Magento_CatalogSearch
Magento_Integration
Magento_SendFriend
Magento_Shipping
Magento_Sitemap
Magento_NewRelicReporting
Magento_Swagger
Magento_Swatches
Magento_SwatchesLayeredNavigation
Magento_Tax
Magento_TaxImportExport
Magento_GiftMessage
Magento_Translation
Magento_GoogleOptimizer
Magento_Ups
Magento_UrlRewrite
Magento_EncryptionKey
Magento_Usps
Magento_Variable
Magento_Braintree
Magento_Version
Magento_Webapi
Magento_WebapiSecurity
Magento_Weee
Magento_CatalogWidget
Magento_Wishlist
Ves_All
Ves_BaseWidget
Ves_Blog
Ves_Brand
Ves_Megamenu
Ves_PageBuilder
Ves_Productlist
Ves_Setup
Ves_Testimonial
Ves_Themesettings

List of disabled modules:
Bss_DisableCompare

/usr/bin/php bin/magento module:enable --clear-static-content Bss_DisableCompare
/usr/bin/php bin/magento setup:upgrade
/usr/bin/php bin/magento setup:di:compile

/usr/bin/php bin/magento setup:upgrade->出現error
[Exception]
  Notice: Use of undefined constant MCRYPT_RIJNDAEL_256 - assumed 'MCRYPT_RIJ
  NDAEL_256' in /var/www/html/magento8pm/vendor/magento/framework/Encryption/
  Encryptor.php on line 454

x->裝mcrypt->沒用(而且mcrypt版本錯誤導致舊RO-account login失敗)
sudo apt-get install mcrypt php7.0-mcrypt
sudo service apache2 restart
---------------
重新安裝mcrypt新版本+改用舊SQL-magento8pm-20200210才解決舊RO-account login成功
sudo apt-get install mcrypt php7.1-mcrypt
sudo service apache2 restart
---------------
加直接改Encryptor.php->return null;->不會出現報錯
joe /var/www/html/magento8pm/vendor/magento/framework/Encryption/Encryptor.php
    protected function getCrypt($key = null, $cipherVersion = null, $initVector = true)
    {
return null;
/*
        return new Crypt($key, $cipher, $mode, $initVector);
*/
    }
-----------------
後台設disable compare
STORES->Configuration->BSS COMMERCE->Disable Compare Configuration->YES
cd /var/www/html/magento8pm
/usr/bin/php bin/magento indexer:reindex
-----------------
禁用Ves_Brand
/usr/bin/php bin/magento module:disable --clear-static-content Ves_Brand
The following modules have been disabled:
- Ves_Brand
Cache cleared successfully.
Generated classes cleared successfully. Please run the 'setup:di:compile' command to generate classes.
Generated static view files cleared successfully.
-----------------

496ccbf39792a0aa94cbec4840bee1c526c1c53cbb18445df8692135624fc9cf:ABN45WVliJG7OXcRboPpHhH01usqfRdd:1
df7cde40bc6922f8a885a21ebe8fd4b0:70:0->??+alberto.jany@woodgroup.com
140e8587c46ea4afc679cb70bae56341:70:0->aa223344-osc-v.1
$P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0->aa223344-osc-v.2
08ed410c41d46dff63fc73c41aa8df1c3025e0397ece2ae59ebcaaed191c0ae3:kJ17CNzHgKZsKbbmWakPvzEFzFCaWCzw:1->??

--- 20200215 install extension disable compare + 禁用Ves_Brand
=========================================================================================================================
改8pm media url->pwpic:
cd /var/www/html/pwpic/
mkdir wysiwyg/pwc
cd wysiwyg/pwc
cp /var/www/html/magento8pm/pub/media/wysiwyg/pwc/*.jpg ./
ln -s /var/www/html/pwpic/wysiwyg/pwc/ /var/www/html/magento8pm/pub/media/wysiwyg/

pwpic圖片目錄:
aws: cd /var/www/html/pwpic/
ls -l
drwxr-xr-x 3 root root 4096 Dec  4 13:00 catalog -> /images/ -> 放RO站主圖
drwxr-xr-x 5 root root 4096 Dec  4 13:00 items -> /Driver  /PW-Pic  /Pic -> 放RO站產品說明連結圖
lrwxrwxrwx 1 root root   19 Jan 30 10:12 pwpic -> /var/www/html/pwpic -> import product csv,填 Images File Directory -> pwpic link指向/var/www/html/pwpic
drwxr-xr-x 4 root root 4096 Dec 13 04:23 simplehtmldom -> 分析html結構的PHP Lib
drwxr-xr-x 3 root root 4096 Feb 14 04:37 wysiwyg -> /wysiwyg/pwc/ -> 8pm media url -> 子目錄圖片

aws: cd /var/www/html/pwpic/catalog/images/
wget http://www.purewaterclub.com/aws-20200127.zip ->  unzip aws-20200127.zip

attribute_set_code

configurable_variations
sku=RO-QQ-003-2cmx100M-Black,ro_qq_003_size=2cmx100M,color=Black|
sku=RO-QQ-003-2cmx100M-Blue,ro_qq_003_size=2cmx100M,color=Blue|
sku=RO-QQ-003-2cmx100M-Brown,ro_qq_003_size=2cmx100M,color=Brown|
sku=RO-QQ-003-2.5cmx100M-Black,ro_qq_003_size=2.5cmx100M,color=Black|
sku=RO-QQ-003-2.5cmx100M-Blue,ro_qq_003_size=2.5cmx100M,color=Blue|
sku=RO-QQ-003-2.5cmx100M-Brown,ro_qq_003_size=2.5cmx100M,color=Brown|
sku=RO-QQ-003-3cmx200M-Black,ro_qq_003_size=3cmx200M,color=Black|
sku=RO-QQ-003-3cmx200M-Blue,ro_qq_003_size=3cmx200M,color=Blue|
sku=RO-QQ-003-3cmx200M-Brown,ro_qq_003_size=3cmx200M,color=Brown

|sku=RO-QQ-003-Brown,ro_qq_003_size=3cmx2000M,color=Brown

新增attribute要加manage tile才會出現在configure product的Select Attributes
BUG->新增attribute-option-text swatch(dropdown只能改一次,就改不回去)-要重新copy-paste-否則default空白不會出現
VENUSTHEME->General,Header點進去空白已不可考,除非選pws-xxx page-OK

--- 20200214-15 configure product
=========================================================================================================================
ADMIN dv4mlmag ; $ML5477ml dv4ml@dacomputing.com

改目錄背景圖:bg_brc.jpg
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/
mv bg_brc.jpg bg_brc-8pm.jpg
wget http://www.purewaterclub.com/bg_brc.jpg

Everything's $1. What will you find?
Sign In or Create an Account
Track Orders
0
Home  Shop By Business 
Shop By Business
Florists & Gift Shops
Weddings, Catering & Events
Restaurants, Bars & Hospitality
Care Facilities
Religious & Nonprofit Organizations
Cleaning Services

--- 20200212 mag2 開帳號給ML + 改目錄背景圖
=========================================================================================================================
手工刪除黑客注冊垃圾帳號
DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 29 record
DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address LIKE '%?%' -> 1 record
DELETE FROM address_book WHERE entry_country_id='147' -> 2 record (NA Navibia)
DELETE FROM address_book WHERE entry_country_id='17' -> 4 record (BH Bahrain)
DELETE FROM address_book WHERE entry_country_id='1' -> 141 record (AF Afghanistan)
DELETE FROM address_book WHERE entry_country_id='14' -> 1 record (AT Austria)
DELETE FROM address_book WHERE entry_country_id='193' -> 3 record (ZA South Africa)
DELETE FROM address_book WHERE entry_country_id='229' -> 2 record (VE Venezuela)
DELETE FROM address_book WHERE entry_country_id='220' -> 3 record (UA Ukiain)
DELETE FROM address_book WHERE entry_country_id='184' -> 3 record (SA Saudi Arabia)
DELETE FROM address_book WHERE entry_country_id='166' -> 1 record (PY Paraguay)
DELETE FROM address_book WHERE entry_country_id='168' -> 4 record (PH Philippines)
DELETE FROM address_book WHERE entry_country_id='167' -> 7 record (PE Peru)
DELETE FROM address_book WHERE entry_country_id='44' -> 1 record (CN China)
DELETE FROM address_book WHERE entry_country_id='21' -> 1 record (BE Belgium)
DELETE FROM address_book WHERE entry_country_id='24' -> 1 record (BM Bermuda)
DELETE FROM address_book WHERE entry_country_id='32' -> 1 record (BN Brunei Darussalam)
DELETE FROM address_book WHERE entry_country_id='83' -> 1 record (GI Gibraltar)
DELETE FROM address_book WHERE entry_country_id='84' -> 7 record (GR Greece)
DELETE FROM address_book WHERE entry_country_id='96' -> 3 record (HK Hong Kong)
DELETE FROM address_book WHERE entry_country_id='53' -> 3 record (HR Croatia)
DELETE FROM address_book WHERE entry_country_id='97' -> 5 record (HU Hungary)
DELETE FROM address_book WHERE entry_country_id='100' -> 2 record (ID Indonesia)
DELETE FROM address_book WHERE entry_country_id='103' -> 3 record (IE Ireland)
DELETE FROM address_book WHERE entry_country_id='104' -> 9 record (IL Israel)
DELETE FROM address_book WHERE entry_country_id='99' -> 10 record (IN India)
DELETE FROM address_book WHERE entry_country_id='101' -> 2 record (IR Iran)
DELETE FROM address_book WHERE entry_country_id='105' -> 5 record (IT Italy)
DELETE FROM address_book WHERE entry_country_id='113' -> 1 record (KR Korea)
DELETE FROM address_book WHERE entry_country_id='114' -> 1 record (KW kuwait)
DELETE FROM address_book WHERE entry_country_id='118' -> 1 record (LB Lebanon)
DELETE FROM address_book WHERE entry_country_id='126' -> 1 record (MK Macedonia)
DELETE FROM address_book WHERE entry_country_id='132' -> 1 record (MT Malta)
DELETE FROM address_book WHERE entry_country_id='136' -> 1 record (MU Mauritius)
DELETE FROM address_book WHERE entry_country_id='130' -> 1 record (MV Maldives)
DELETE FROM address_book WHERE entry_country_id='129' -> 6 record (MY Malaysia)
DELETE FROM address_book WHERE entry_country_id='150' -> 1 record (NL Netherlands)
DELETE FROM address_book WHERE entry_country_id='55' -> 2 record (CY Cyprus)
DELETE FROM address_book WHERE entry_country_id='60' -> 1 record (DO Dominica)
DELETE FROM address_book WHERE entry_country_id='195' -> 2 record (ES Spain)
DELETE FROM address_book WHERE entry_country_id='203' -> 4 record (SE Sweden)
DELETE FROM address_book WHERE entry_country_id='188' -> 9 record (SG Singapore)
DELETE FROM address_book WHERE entry_country_id='209' -> 2 record (TH Thailand)
DELETE FROM address_book WHERE entry_country_id='215' -> 2 record (TR Turkey)
DELETE FROM address_book WHERE customers_id=9100 -> 1 record ->亂填
Last->手工刪除表:customers->無地址address_book
UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 129 record
DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 129 record

_address_fax -> 1-2 -> {fax} -> 放舊RO站"付款" - "未付款"次數 
Checked rows: 9108, checked entities: 18216, invalid rows: 0, total errors: 0

COPY SQL magento8pm -> magento8pm20200210: ERROR
ALTER TABLE `catalog_eav_attribute` ADD CONSTRAINT `CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE;

cd /var/www/html/magento8pm
/usr/bin/php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:01
Customer Grid index has been rebuilt successfully in 00:00:09
Category Products index has been rebuilt successfully in 00:00:02
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:01
Product EAV index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:00:01
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:11
->9110 records found
last->customers_id9958(Joshua-Peterson)+address_book_id=12859

--- 20200211 old-RO customer 資料 -> mag2
=========================================================================================================================
1.）請你先檢查一下新的RO站的所有細節, 目前只剩老客人的資料還沒有轉過去, 其他都轉好了, 看看還有有什麼問題或建議, 尤其是手機請多試一下
http://www.buck4all.com/

2.) 附件的excel表有QT2的裝箱明細和產品編號表, QT2到貨後,因為這一批貨有1千多款,而且都是新貨又非常複雜,所以請一定要按表上的明細拆箱,一一對照後把貨先歸好,不然萬一混在一起後,將來很難分辨

3.) QT2的貨目前發現有以下4個失誤,請你幫忙修改
    3-a.)第116箱的地毯膠帶(209.01-209.10)漏了秤單品重量,請幫忙秤
    3-b.)第134箱的10,000個(100小包)10絲白邊PE自封袋3cm*4cm編號錯記為107.02,請修改為正確107.20
    3-c.)第134箱的500個(5小包) 10絲白邊PE自封袋13cm*18cm編號錯記為107.10,請修改為正確107.19
    3-d.)第129箱的5個(1小袋) RJ45接頭-母轉2母編號錯記為322.06,請合併到同一箱的另一小袋相同款式的322.05

4.) QT2和將來一元站的貨號規則如下:

1.)	BSKU - Basic SKU: 單品最小實際庫存, 依不同尺寸, 顏色, 款式編不同貨號 
編碼規則為 aaa.bb -> aaa為分類編號, bb為分類下的產品號 
Ex1: 101為珠光膜氣泡信封, 101.01為11cm*11cm+4cm, 101.09為20cm*25cm+4cm
Ex2: 212為美紋紙手撕膠帶, 202.01為6mm*12m-黑色, 212.30為12mm*12m-淺藍色

1-a.) 數量直接可數的->例如: 1個, 1條, 1捲, 1片
1-b.) 需要裁剪長度的->例如: 大捲的魔術貼1米, 大捲熱縮管1米, 大捲反光織帶1米
1-c.) 低單價需要配對使用的合併編號->例如: , 迷你鰐魚夾測試線5色套, 汽車電源端子公母1對, 小鱷魚夾正負1對, 雙絞線傳輸器左右1對, POE分離器左右1對, 香蕉頭插座黑紅1對
1-d.) 高單價需要配對使用的分開編號->例如: 大鱷魚夾正極黑色, 大鱷魚夾負極紅色, 香蕉頭純銅鍍金直針型黑色, 香蕉頭純銅鍍金直針型紅色
1-e.) 超低單價不容易數的預包裝好的整包編號->例如: 金屬紮絲400pcs, 紙紮絲100pcs, 蝴蝶結紮絲20pcs, 尼龍紮帶*100pcs, 背膠圓點魔術貼15mm*30對
1-f.) 客戶不可挑選顏色的編相同貨號->例如: 彩色帶透明蓋彈簧U型剪刀, 彩色長柄洗杯刷, 彩色轉換插座, 彩色RJ45直通接頭, 彩色殼鍍金頭音頻線

2.)	SKU - Stock Keeping Unit: 實際銷售單位, 由同一種BSKU數量一個以上或數個BSKU組成
編碼規則為 BSKU + qqq -> aaa.bb + qqq-> aaa.bb 為BSKU+ qqq為數量或附加碼
2-a.) 數量為100個的倍數直接加h,200個加h2->例如: 100個自粘OPP袋為105.01h, 200個水晶頭為321.02h2
2-b.) 數量為不是100個整數先加(x) 再加數量->例如: 10個珠光膜氣泡信封為101.07x10, 25個白快遞袋為104.01x25
2-c.) 不同bsku組成挑主要產品的bsku先加附加碼(s) 再加不重覆流水號(1~99)->例如: 100個水晶頭配100個護套321.01s1
2-d.) 數量為1000個的倍數直接加k,2000個加k2->例如: 目前沒有

--- 20200210 QT2 packing detail + BSKU + SKU 規則
=========================================================================================================================
增加新Store View
1.)STORES->All Stores->Create Store View->pwc:pwc_buck4aqua
2.)STORES->Configuration->選Store View(pwc:pwc_buck4aqua)->GENERAL:Web->Base URLs + Secure Base URL + CMS Home Page
3.)DNS A buck4aqua.buck4all.com -> 18.218.158.219
4.)cd /etc/apache2/sites-available
cp buck4u.conf pwc_buck4aqua.conf ->
joe pwc_buck4aqua.conf ->
ServerName buck4aqua.buck4all.com
SetEnv MAGE_RUN_CODE "pwc_buck4aqua"
SetEnv MAGE_RUN_TYPE "store"
cd /etc/apache2/sites-available
ln -s /etc/apache2/sites-available/pwc_buck4aqua.conf /etc/apache2/sites-enabled/pwc_buck4aqua.conf
service apache2 restart

(20200209)修改
joe buck4all.conf 
SetEnv MAGE_RUN_CODE "demo3" -> SetEnv MAGE_RUN_CODE "pwc_ro"

--- 20200209 增加 Store View + New Arrival + Feature Product + Our Service
=========================================================================================================================
Manage Elements->pwc-footer

/var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layout/default.xml
wget http://www.purewaterclub.com/default.xml

<!-- 20200208 dv add -->
<referenceBlock name="report.bugs" remove="true"/>
<referenceBlock name="store_switcher" remove="true"/>
<referenceBlock name="form.subscribe" remove="true"/>

<referenceBlock name="privacy-policy-link" remove="true"/>
<referenceBlock name="search-term-popular-link" remove="true"/>
<referenceBlock name="contact-us-link" remove="true"/>
<referenceBlock name="sales-guest-form-link" remove="true"/>
<referenceBlock name="catalog-search-advanced-link" remove="true"/>

<referenceBlock name="footer_links">
    <block class="Magento\Framework\View\Element\Html\Link\Current" name="pwc-shipping-returns">
        <arguments>
            <argument name="label" xsi:type="string">Shipping and Returns</argument>
            <argument name="path" xsi:type="string">pwc-shipping-returns</argument>
        </arguments>
    </block>
    <block class="Magento\Framework\View\Element\Html\Link\Current" name="pwc-privacy-notice">
        <arguments>
            <argument name="label" xsi:type="string">Privacy Notice</argument>
            <argument name="path" xsi:type="string">pwc-privacy-notice</argument>
        </arguments>
    </block>
    <block class="Magento\Framework\View\Element\Html\Link\Current" name="pwc-faq">
        <arguments>
            <argument name="label" xsi:type="string">RO FAQ</argument>
            <argument name="path" xsi:type="string">pwc-faq</argument>
        </arguments>
    </block>

    <block class="Magento\Framework\View\Element\Html\Link\Current" name="pwc-account">
        <arguments>
            <argument name="label" xsi:type="string">My Account</argument>
            <argument name="path" xsi:type="string">customer/account</argument>
        </arguments>
    </block>
    <block class="Magento\Framework\View\Element\Html\Link\Current" name="membrane-rejection-chart">
        <arguments>
            <argument name="label" xsi:type="string">Membrane Rejection Chart</argument>
            <argument name="path" xsi:type="string">membrane-rejection-chart</argument>
        </arguments>
    </block>
    <block class="Magento\Framework\View\Element\Html\Link\Current" name="pwc-contact">
        <arguments>
            <argument name="label" xsi:type="string">Contact Us</argument>
            <argument name="path" xsi:type="string">pwc-contact-us</argument>
        </arguments>
    </block>
</referenceBlock>

<referenceBlock name="form.subscribe" remove="true"/>
/var/www/html/magento8pm/vendor/magento/module-newsletter/view/frontend/layout/default.xml
<referenceBlock name="footer_links">
/var/www/html/magento8pm/vendor/magento/module-cms/view/frontend/layout/default.xml
/var/www/html/magento8pm/vendor/magento/module-search/view/frontend/layout/default.xml
/var/www/html/magento8pm/vendor/magento/module-contact/view/frontend/layout/default.xml
/var/www/html/magento8pm/vendor/magento/module-sales/view/frontend/layout/default.xml
/var/www/html/magento8pm/vendor/magento/module-catalog-search/view/frontend/layout/default.xml

Contact表:
/var/www/html/magento8pm/vendor/magento/module-contact/view/frontend/layout/contact_index_index.xml
/var/www/html/magento8pm/vendor/magento/module-contact/view/frontend/templates/form.phtml

--- 20200206-08 Footer + Link + Contact
=========================================================================================================================
設定全站Theme:
CONTENT->Design Configuration->選Store Views(pwc English)->Edit->Default Theme->Applied Theme->Magento Blank(x-全站用Blank)
(20200208 改用Venustheme - 8pm,因為contact,my account,cart的form 字白色看不到 label:color #000)
CONTENT->Design Configuration->選Store Views(pwc English)->Edit->Default Theme->Applied Theme->Venustheme - 8pm(全站用8pm)
->設定首頁Logo:
Other Settings->Header->Logo Image
Logo Image Width->495
->設定首頁Footer:
Other Settings->Footer->Copyright
Copyright (C) 2020 all rights reserved.
加另外改manage element->PWC Footer->Design Elemment

設定首頁Page:
1.)STORES->Configuration->Store Views:選(pwc English)->Web->Default Pages->CMS Home Page->purewaterclub.com
2.)CONTENS->Pages->purewaterclub.com->Content->Widget Type->Ves Page Builder : Generate a page builder profile->Page Id->purewaterclub.com
->改首頁Theme:
Custom Design Update->New Theme->Venustheme - 8pm(x-只有首頁用8pm)
(20200208 不用改了)

首頁Page加子目錄圖片:
VENUSTHEME->Manage Page Profile->挑選page(purewaterclub.com)->Desgin Block->加(pwc-dir-47)

目錄頁設定:
PRODUCTS->Categories->Default Category->Design->Theme->Magento Blank(blank手機版可維持2排產品)
PRODUCTS->Catagories->挑選目錄(Filtration System)->Content->Add CMS Block->Block(dir_50)
CONTENS->Blocks->挑選Block(dir_50)->Widget Type->Ves Page Builder: Generate Element Profile->Element Id->(pwc-dir-50)
VENUSTHEME->Manage Element->挑選element(pwc-dir-50)->Design->widget->6 x (single image + heading tag)

子目錄圖片+連結:
VENUSTHEME->Manage Element->挑選element(pwc-dir-47)->Design widget->加4 x (single image + heading tag)
1.)Filtration System
Image File->wysiwyg/pwc/dir_50.jpg
Link->http://www.buck4all.com/index.php/ro/filtration-system.html
2.)Replacement
wysiwyg/pwc/dir_65.jpg
http://www.buck4all.com/index.php/ro/replacement.html
3.)Parts & Tools
wysiwyg/pwc/dir_68.jpg
http://www.buck4all.com/index.php/ro/parts-tool.html
4.)Buck4RO
wysiwyg/pwc/b4ro.jpg
http://www.buck4u.com

1.)Revese Osmosis
wysiwyg/pwc/dir_51.jpg
http://www.buck4all.com/index.php/ro/filtration-system/revese-osmosis.html
2.)Portable RO
wysiwyg/pwc/dir_55.jpg
http://www.buck4all.com/index.php/ro/filtration-system/portable-ro.html
3.)Whole House
wysiwyg/pwc/dir_59.jpg
http://www.buck4all.com/index.php/ro/filtration-system/whole-house.html
4.)Drinking Water
wysiwyg/pwc/dir_62.jpg
http://www.buck4all.com/index.php/ro/filtration-system/drinking-water.html
5.)Aquarium
wysiwyg/pwc/dir_63.jpg
http://www.buck4all.com/index.php/ro/filtration-system/aquarium.html
6.)Ultra Violet
wysiwyg/pwc/dir_64.jpg
http://www.buck4all.com/index.php/ro/filtration-system/ultra-violet.html

1.)Housing
wysiwyg/pwc/dir_66.jpg
http://www.buck4all.com/index.php/ro/parts-tools/housing.html
2.)Feeders
wysiwyg/pwc/dir_67.jpg
http://www.buck4all.com/index.php/ro/parts-tools/feeders.html
3.)Fittings
wysiwyg/pwc/dir_79.jpg
http://www.buck4all.com/index.php/ro/parts-tools/fittings.html
4.)Valves
wysiwyg/pwc/dir_80.jpg
http://www.buck4all.com/index.php/ro/parts-tools/valves.html
5.)Faucet-Tank-Tubes
wysiwyg/pwc/dir_81.jpg
http://www.buck4all.com/index.php/ro/parts-tools/faucet-tank-tubes.html
6.)Utilityes
wysiwyg/pwc/dir_82jpg
http://www.buck4all.com/index.php/ro/parts-tools/utilityes.html

cd /var/www/html/magento8pm/pub/media/wysiwyg/pwc/
wget http://www.purewaterclub.com/aws-20200209.zip ->  unzip aws-20200209.zip
1.)Combo Set
wysiwyg/pwc/dir_70.jpg
http://www.buck4all.com/index.php/ro/replacement/combo-set.html
2.)Filters
wysiwyg/pwc/dir_71.jpg
http://www.buck4all.com/index.php/ro/replacement/filters.html
3.)Menbranes
wysiwyg/pwc/dir_72.jpg
http://www.buck4all.com/index.php/ro/replacement/menbranes.html
4.)Resin
wysiwyg/pwc/dir_73.jpg
http://www.buck4all.com/index.php/ro/replacement/resin.html
5.)Ultra Violet
wysiwyg/pwc/dir_74.jpg
http://www.buck4all.com/index.php/ro/replacement/ultra-violet.html

目錄頁子目錄圖片:dir 47,50,65,68
Catagory->block(dir_50)->element(pwc-dir-50)->widget(6 x pic + 6 x text)
調整圖片為(2x3,3x2,6x1行)
Widget:image collect->phone尺寸圖片位置為4+2
<div><a href="{{store url="ro/filtration-system/revese-osmosis.html"}}"><img src="{{media url="wysiwyg/pwc/dir_51.jpg"}}" alt="" /></a></div>

Bug->第3-Text如果打Fittings會一直亂碼->改Connecters Fittings

Ves Generate->Page Builder Profile->Ves Element->Widget
CONTENS->Pages->Ves Generate Page Builder Profile->Ves Element->Widget
Ves Generate Page Builder Profile->Ves Element->Widget

--- 20200203,05 首頁+目錄頁
=========================================================================================================================
設定首頁+目錄頁Theme->
CONTENT->Design Configuration->Edit->Default Theme->Applied Theme->
Magento Blank: 首頁第一行自動出現Ves Brand(可全部disable後消失) + Ves Menu在header下方整行 + 手機Ves Menu不會縮小左上角 + 產品列表自動適應成2~4行
Magento Luma: 首頁第一行自動出現Ves Brand(可全部disable後消失) + Ves Menu在header下方整行 + 手機Ves Menu不會縮小左上角 + 中間所有內容消失
Venustheme - 8pm/7pm: 首頁Ves Menu在header 正上方logo右側 + 產品列表PC 3行-手機 1行 
關閉首頁(Blank/Luma)的Ves Brand:
1.)將brand中全部都disable or
2.)STORES->Configuration->VENUS - VENUSTHEME.COM->Brand->General Settings->Disabled

設定首頁的Page->STORES->Configuration->Store View:pwc English->GENERAL->Default Pages->CMS Home Page->Home Page(in CONTENTS->Pages)

Page Title->Home Page
Content->Content Heading->Home Page-dv
<div class="hidden">Homepage Pencil</div>

Design->Layout Update XML
<!-- Slideshow and banner Top-right -->
<referenceContainer name="ves-slideshow">
    <block class="Magento\Cms\Block\Block" name="block-slideshow-bannertop">
        <arguments>
            <argument name="block_id" xsi:type="string">block-slideshow-bannertop</argument>
        </arguments>
    </block>
</referenceContainer>

<!-- 2 banner center -->
<referenceContainer name="ves-showcase">
    <block class="Magento\Cms\Block\Block" name="block-banner-center">
        <arguments>
            <argument name="block_id" xsi:type="string">block-banner-center</argument>
        </arguments>
    </block>
</referenceContainer>

<!-- New products carousel -->
<referenceContainer name="ves-masstop">
    <block class="Magento\Cms\Block\Block" name="new-products-carousel">
        <arguments>
            <argument name="block_id" xsi:type="string">new-products-carousel</argument>
        </arguments>
    </block>
</referenceContainer>

<!-- Banner Massbottom -->
<referenceContainer name="ves-massbottom">
    <block class="Magento\Cms\Block\Block" name="banner-mass-bottom">
        <arguments>
            <argument name="block_id" xsi:type="string">banner-mass-bottom</argument>
        </arguments>
    </block>
</referenceContainer>

<!-- Product tabs -->
<referenceContainer name="ves-massbottom1">
    <block class="Magento\Cms\Block\Block" name="product-tabs">
        <arguments>
            <argument name="block_id" xsi:type="string">product-tabs</argument>
        </arguments>
    </block>
</referenceContainer>

<referenceContainer name="ves-massbottom2">
    <block class="Magento\Cms\Block\Block" name="banner-mass-bottom2">
        <arguments>
            <argument name="block_id" xsi:type="string">banner-mass-bottom2</argument>
        </arguments>
    </block>
</referenceContainer>

--- 20200202 product-list
=========================================================================================================================
Base URL for User Media Files:/var/www/html/magento8pm/pub/media/

8pm Slider dv
<div><a href="{{store url="ro.html"}}"><img src="{{media url="wysiwyg/ves_8pm/store1/1.jpg"}}" alt="" /></a></div>
<div class="slider-content">
<h5>Look Book</h5>
<h3>Autums <br>Collection <br>For</h3>
<a class="button btn-border" href="{{store url='ro.html'}}">Shop Now</a>
</div>

<div><a href="{{store url="ro.html"}}"><img src="{{media url="wysiwyg/ves_8pm/store1/1.jpg"}}" alt="" /></a></div>
Product2->New Arrival2
Product1->Product
Product->Product
Product3->Feature Items3
8pm image collection->Collection 2017

--- 20200201 slider
=========================================================================================================================

www.buck4all.com->pwc 
Stores->All Stores->pwc English
Stores->Configuration->Store View:>pwc English->Web->Default Pages->CMS Home Page->purewaterclub.com
VenusTheme->Page Builder->Block:purewaterclub.com->PAGE INFORMATION->Desgin Block->Elemment:8pm categories->Design Elemment->Widget:Show Categories information and subcategories
目錄頁加子目錄跑馬燈icon:
Products->Catagories->目錄->Content->Add CMS Block->dv-block
目錄頁左半列出子目錄
Display Settings->Anchor->No
目錄頁不要出現目錄圖
Configuration->VES THEMESETTINGS->General Settings->Category Image->No
目錄頁下方出現翻頁功能
Configuration->VES THEMESETTINGS->General Settings->Bottom Toolbar->Yes


產品對應目錄list表:catagory-list-20200129-1.csv
產生產品目錄csv->http://www.purewaterclub.com/gen-product-catagory-csv.php
->product-catagory-20200131-4.csv
->Import->Behavior:Add/Update
轉檔URL不可以有+ -> -pl-
strtolower(str_replace("+","%20",$tmpurl))
General system exception happened
Additional data: URL key for specified store already exists.

Checked rows: 362, checked entities: 362, invalid rows: 0, total errors: 0 -> Import successfully done
同步產品說明+名稱->http://aws.wg-1.com/gen-product-desc-name.php->
cd /var/www/html/magento8pm
/usr/bin/php bin/magento indexer:reindex
/usr/bin/php bin/magento cache:flush

//--- bug picture (圖片怪,不能用,需要重新抓圖上傳?)---------------
1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 37, 39
FS-5BM150 /catalog/images/FS-5BM150.JPG
FS-4M100  /catalog/images/4PM100.jpg
1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 25
PT-TANK02UG /catalog/images/tank.jpg
1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 69, 72, 75, 98
POQ-5BB-50 /catalog/images/POQ-5BB.JPG
POQ-5BB-150 /catalog/images/POQ-5BB.JPG
SP-Y /catalog/images/SP-Y.JPG
UG-50G No Pic1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 19, 35, 89, 91, 93
General system exception happened
Additional data: URL key for specified store already exists.
RQ-5-100+4 UG-100-200 SO-002 FT-M200 RQ5-5T-50
1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 260, 281, 297, 351, 353, 355
-----------------//

手工添加主圖表:products->products_image
576>>>UG-50G->no pic -> UG-50G.jpg
629>>>UG-100-200->no pic -> UG-100-200.jpg
606>>>RQ-5-100+4->no pic -> RQ-5-100-pl-4.jpg
699>>>SO-002->no pic -> SO-002.jpg
手工上傳 jpg -> aws (DV已上傳-20200131)
cd /var/www/html/pwpic/catalog/images/
576>>>UG-50G->no pic -> wget http://www.purewaterclub.com/UG-50G.jpg 
629>>>UG-100-200->no pic -> wget http://www.purewaterclub.com/UG-100-200.jpg
606>>>RQ-5-100+4->no pic -> wget http://www.purewaterclub.com/RQ-5-100-pl-4.jpg
699>>>SO-002->no pic -> wget http://www.purewaterclub.com/SO-002.jpg
701>>>FT-M200->no pic -> wget http://www.purewaterclub.com/FT-M200.jpg
704>>>RQ5-5T-50->no pic -> wget http://www.purewaterclub.com/RQ5-5T-50.jpg
wget http://www.purewaterclub.com/4PM100.jpg
wget http://www.purewaterclub.com/tank.jpg
wget http://www.purewaterclub.com/POQ-5BB.JPG
wget http://www.purewaterclub.com/SP-Y.JPG

osc 舊RO站後台:(一定要用IE)
https://www.purewaterclub.com/catalog/admin/index.php -> admin + admin1234!

更新產品基本資料必要欄位
sku,store_view_code,attribute_set_code,product_type,categories,product_websites,name,description,short_description,weight,product_online,tax_class_name,visibility,price,special_price,special_price_from_date,special_price_to_date,url_key,meta_title,meta_keywords,meta_description,base_image,base_image_label,small_image,small_image_label,thumbnail_image,thumbnail_image_label,swatch_image,swatch_image_label,created_at,updated_at,new_from_date,new_to_date,display_product_options_in,map_price,msrp_price,map_enabled,gift_message_available,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,product_options_container,msrp_display_actual_price_type,country_of_manufacture,additional_attributes,qty,out_of_stock_qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,related_skus,crosssell_skus,upsell_skus,additional_images,additional_image_labels,hide_from_product_page,bundle_price_type,bundle_sku_type,bundle_price_view,bundle_weight_type,bundle_values,configurable_variations,configurable_variation_labels,associated_skus
PT-12-1,,,,,,PT-12-1,,,,,,,1.1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,304,0,1,0,0,1,1,0,0,1,1,,1,0,1,1,0,1,0,0,1,,,,,,,,,,,,,,

--- 20200130-0201 目錄頁 + import product-catagory
=========================================================================================================================
目錄名稱表:catalog_category_entity_varchar->
attribute_id=42
entity_id=50
value=Filtration System
目錄結構表:catalog_category_entity->
entity_id=50
path=1/2/47/50
level=3
children_count=14
產品查目錄表:catalog_category_product_index->
目錄查產品表:catalog_category_product->category_id +	product_id + position(default 1)
手工修改表:products->
products_id=616 (PT-Qfaucet)->products_status=0 (與617重覆)
products_id=592 (PT-3W2)->products_status=0 (與594重覆)

目錄List
$catidx=array(0,0,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,70,71,72,73,74,75,76,77,79,80,81,82,84);
目錄名稱不可以有, /
$d[50]="Filtration System";
$d[51]="Filtration System/Revese Osmosis";
$d[52]="Filtration System/Revese Osmosis/Standard Flow 100 GPD";
$d[53]="Filtration System/Revese Osmosis/High Flow 150+ GPD";
$d[54]="Filtration System/Revese Osmosis/Low Flow 50 GPD";
$d[55]="Filtration System/Portable RO";
$d[56]="Filtration System/Portable RO/Standard Flow 100 GPD";
$d[57]="Filtration System/Portable RO/High Flow 150+ GPD";
$d[58]="Filtration System/Portable RO/Low Flow 50 GPD";
$d[59]="Filtration System/Whole House";
$d[60]="Filtration System/Whole House/Standard";
$d[61]="Filtration System/Whole House/Ecnomical";
$d[62]="Filtration System/Drinking Water";
$d[63]="Filtration System/Aquarium";
$d[64]="Filtration System/Ultra Violet";
$d[68]="Replacement";
$d[70]="Replacement/Combo Set";
$d[71]="Replacement/Filters";
$d[72]="Replacement/Menbranes";
$d[73]="Replacement/Resin";
$d[74]="Replacement/Ultra Violet";
$d[65]="Parts & Tools";
$d[66]="Parts & Tools/Housing";
$d[75]="Parts & Tools/Housing/0.25~0.375 inch";
$d[76]="Parts & Tools/Housing/0.75 inch";
$d[77]="Parts & Tools/Housing/0.5 inch";
$d[67]="Parts & Tools/Feeders";
$d[79]="Parts & Tools/Fittings";
$d[80]="Parts & Tools/Valves";
$d[81]="Parts & Tools/Faucet-Tank-Tubes";
$d[82]="Parts & Tools/Utilityes";
$d[84]="Parts & Tools/Shipping";

--- 20200127-29 整理 old-RO product目錄
=========================================================================================================================
gen-product-csv.php
	$tmppic=$row["products_image"];
	$tmppic=str_replace(" ","-sp-",$tmppic,$i);
	$tmppic=str_replace("+","-pl-",$tmppic,$i2);
	$tmppic=str_replace("[1]","-1-",$tmppic,$i3);

收集+改產品主圖片名稱(含空格,+,[1]) -> copy to ./tmp/ -> ftp下載整理 -> 手工zip為aws-20200127.zip -> ftp上傳ro站
aws: cd /var/www/html/pwpic/catalog/images/
wget http://www.purewaterclub.com/aws-20200127.zip ->  unzip aws-20200127.zip
缺主圖
576>>>UG-50G->no pic
606>>>RQ-5-100+4->no pic
629>>>UG-100-200->no pic
699>>>SO-002->no pic
701>>>FT-M200->no pic
704>>>RQ5-5T-50->no pic
mag2->import->product+pwpic->w
Checked rows: 364, checked entities: 364, invalid rows: 0, total errors: 0

--- 20200127 整理 old-RO product special file name pic -> mag2
=========================================================================================================================
53dfeff4e5225395344f4e917893e8ff3762a0e12080f11da0d57b21fdbc97f8:aFtZhhXDAihazGkpXyPFbBWEf32oxHsL:1
dv4ml@dacomputing.com + aa223344
osc 表customers -> customers_id=9660 + 1@aa.com + $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/
alberto.jany@woodgroup.com + (aa223344) $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0

SELECT * FROM customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id LIMIT 100

SELECT countries_id,countries_name,countries_iso_code_3 FROM (customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id) LEFT JOIN countries ON address_book.entry_country_id=countries.countries_id LIMIT 100
SELECT * FROM (customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id) LEFT JOIN countries ON address_book.entry_country_id=countries.countries_id LIMIT 100

手工刪除黑客注冊垃圾帳號
DELETE FROM address_book WHERE entry_street_address LIKE '%minsk%' AND entry_city LIKE '%minsk%' -> 627 record
DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address LIKE '%?%' -> 20 record
DELETE FROM address_book WHERE entry_country_id<>'223' AND entry_street_address=entry_city -> 23 record
DELETE FROM address_book WHERE entry_state like '%?%' -> 1 record
DELETE FROM address_book WHERE customers_id=3953 -> 2 record (YU)->南斯拉夫已不存在
DELETE FROM address_book WHERE customers_id=5505 -> 1 record (YU)->南斯拉夫已不存在
DELETE FROM address_book WHERE customers_id=776 -> 1 record (dd@dd.com)->亂碼
?? if osc的state空白->mag2自動根據地址判斷
手工刪除表:address_book->不常國家 + state/region 錯誤(無法上傳mag2) + 未成交帳號
DELETE FROM address_book WHERE entry_country_id='123' (LT Lithuania) -> 7 record
DELETE FROM address_book WHERE entry_country_id='175' (RO Romania) -> 2 record
DELETE FROM address_book WHERE entry_country_id='117' (LV Latvia) -> 2 record (含customers_id=2073 -> mike.pelletier@wanadoo.fr)
DELETE FROM address_book WHERE entry_country_id='73'  (FR France) -> 3 record (含customers_id=3123 -> asd@jp.co.jp)
DELETE FROM address_book WHERE entry_country_id='107' AND customers_id<>6476(JP Japan) -> 7 record
手工刪除表:address_book->(BR Brazil)+ 未成交帳號
UPDATE address_book LEFT JOIN orders ON address_book.customers_id=orders.customers_id SET entry_suburb='xxxxx' WHERE orders_id IS NULL AND entry_country_id='30' (BR Brazil) -> 44 record
DELETE FROM address_book WHERE entry_suburb='xxxxx' -> 44 record
Last->手工刪除表:customers->無地址address_book
UPDATE customers LEFT JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id SET customers_email_memo='xxxxx' WHERE address_book_id IS NULL -> 730 record
DELETE FROM customers WHERE customers_email_memo='xxxxx' -> 730 record
手工修改表:address_book->state
UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='san juan' (US PR)-> 7 record
UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='Comerio' (US PR)-> 2 record
UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='aguadilla' (US PR)-> 1 record
UPDATE address_book SET entry_state='Puerto Rico' WHERE entry_state='P.R.' (US PR)-> 3 record
UPDATE address_book SET entry_state='Paraíba' WHERE entry_state='paraiba' (BR)-> 3 record
UPDATE address_book SET entry_state='S?o Paulo' WHERE entry_state='SAO PAULO' (BR)-> 5 record
UPDATE address_book SET entry_state='Goiás' WHERE entry_state='Goias' (BR)-> 3 record
手工修改表:customers->customers_id=8277 (978)?412-6426->去掉中間亂碼
手工修改表:address_book->customers_id=603  2314\->23140
手工修改表:address_book->customers_id=1470  cahoon77@yahoo.com->
手工修改表:customers->root@localhost->root@localhost.com
手工修改表:customers->richter@ccs.fau.du->richter@ccs.fau.du.com

http://www.purewaterclub.com/gen-customer-csv.php
各種拉丁文亂碼Bogotá(例表:customerscustomers_id=1420(alberto.jany@woodgroup.com)
	$tmps=str_replace("{fname}",iconv("ISO-8859-1","UTF-8",$row["customers_firstname"]),$tmps);
	$tmps=str_replace("{lname}",iconv("ISO-8859-1","UTF-8",$row["customers_lastname"]),$tmps);
	$tmps=str_replace("{city}",iconv("ISO-8859-1","UTF-8",$row["entry_city"]),$tmps);
	$tmps=str_replace("{fname2}",iconv("ISO-8859-1","UTF-8",$row["entry_firstname"]),$tmps);
	$tmps=str_replace("{lname2}",iconv("ISO-8859-1","UTF-8",$row["entry_lastname"]),$tmps);
	$tmps=str_replace("{state}",iconv("ISO-8859-1","UTF-8",$row["entry_state"]),$tmps);
	$tmps=str_replace("{street}",iconv("ISO-8859-1","UTF-8",$row["entry_street_address"]),$tmps);

migrate osc to mag2
v.1 -> osc + : + 0
df7cde40bc6922f8a885a21ebe8fd4b0:70 -> df7cde40bc6922f8a885a21ebe8fd4b0:70:0
v.2 -> osc + : + osc去掉首位$ + : + 0
利用mag2的salt位置傳遞存檔hash,新增程式判斷若為osc v.2,則字首加上$後依v.2規則產生hash,比對若正確後回送hash (aa223344)
$P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/ -> $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0
$P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf. -> $P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:0

--- 20200124-25-26 整理 old-RO customer 資料 -> mag2
=========================================================================================================================
添加新theme 7pm
cd /var/www/html/magento8pm/app/design/frontend/Venustheme/
cp 8pm 7pm -r
joe registration.php
joe theme.xml
直接改不同的default.xml可改變Ves header使用MegaMenu的名稱
1.)pwc
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top</argument>
2.)b4u
/var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml
					<argument name="value" xsi:type="string">menu-top-b4u</argument>

失敗->添加新theme zou-被Ves Extend搶走header
cd /var/www/html/magento8pm/app/design/frontend/Zou/demo/
wget http://www.purewaterclub.com/zou-20200121.zip ->  unzip zou-20200121.zip
DNS A zou.wg-1.com -> 18.218.158.219
cd /etc/apache2/sites-available
cp buck4u.conf zou-wg-1.conf
joe zou-wg-1.conf ->
ServerName zou.wg-1.com
SetEnv MAGE_RUN_CODE "zou"
cd /etc/apache2/sites-enabled
ln -s /etc/apache2/sites-available/zou-wg-1.conf /etc/apache2/sites-enabled/zou-wg-1.conf
service apache2 restart

失敗->增加Ves header的layout: copy default.phtml default-b4u.phtml
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml
<!-- 20200121 dv change -->
						<!--?php echo $this->getChildHtml('catalog.topnav') ?-->
						<?php echo $this->getChildHtml('catalog.topnav_b4u') ?>
<!-- 20200121 dv change -->

/var/www/html/magento8pm/app/code/Ves/Megamenu/view/frontend/layout/default.xml
原始默認Ves header使用MegaMenu的名稱
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Megamenu/layout/default.xml
/var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/Ves_Megamenu/layout/default.xml
可改變Ves header使用MegaMenu的名稱
<!-- 20200121 dv add -->
		<referenceBlock name="catalog.topnav_b4u" remove="true"/>
		<referenceBlock name="navigation.sections_b4u">
			<block class="Ves/Megamenu/Block/Menu" name="menu.top" as="menu_top" template="Ves_Megamenu::menu_top.phtml">
				<action method="setData">
					<argument name="name" xsi:type="string">alias</argument>
					<argument name="value" xsi:type="string">menu-top-b4u</argument>
				</action>
				<action method="setData">
					<argument name="name" xsi:type="string">layout</argument>
					<argument name="value" xsi:type="string">horizontal</argument>
				</action>
			</block>
		</referenceBlock>
<!-- 20200121 dv add -->

/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml
<!-- 20200121 dv add -->
                <block class="Magento\Framework\View\Element\Template" name="navigation.sections_b4u" as="ves_navigation" before="-" template="Magento_Theme::html/navigation.phtml">
                    <block class="Magento\Framework\View\Element\Template" name="account.store.links" as="store_links" template="Magento_Theme::html/store_links.phtml" ifconfig="ves_themesettings_header/toplinks_settings/enable"/>
                    <block class="Magento\Directory\Block\Currency" name="store.settings.currency" as="store_currency" before="store_language" template="currency.phtml" ifconfig="ves_themesettings_header/currency_switcher_settings/currency_switcher"/>
                    <block class="Magento\Store\Block\Switcher" name="store.settings.language" as="store_language" template="switch/languages.phtml" ifconfig="ves_themesettings_header/language_switcher_settings/language_switcher"/>
                </block>
<!-- 20200121 dv add -->
<!-- 20200121 dv add -->
        <move element="navigation.sections_b4u" destination="ves_header" as="catalog.topnav_b4u"/>
<!-- 20200121 dv add -->

--- 20200121 mag2 設定不同 store 配不同 Mega Menu
=========================================================================================================================
Bug->Ves ->同一頁只會出現第一種MegaMenu
MegaMenu從正上方下移至Top Bar下方:
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml
<move element="navigation.sections" destination="header.container" as="catalog.topnav" after="ves_header"/>

Bug->Ves MegaMenu management->必須改第一個 or 只移動位置,只要按了select就save無效 

x-SELECT * FROM address_book LEFT JOIN customers ON address_book.customers_id=customers.customers_id WHERE 1
SELECT * FROM customers INNER JOIN address_book ON customers.customers_default_address_id=address_book.address_book_id WHERE customers.customers_id<>address_book.customers_id

改ves megamenu alias
cd /var/www/html/magento8pm
app/code/Ves/Megamenu/view/frontend/layout/default.xml
<argument name="value" xsi:type="string">menu-top</argument>
catagary背景圖:
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/bg_brc.jpg
/var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images/bg_brc.jpg
menu背景圖:
Add class “menu-bg” to insert background in dropdown, change background in the path: /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/menu-bg.jpg
cp /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/web/images/bg_brc.jpg /var/www/html/magento8pm/app/design/frontend/Venustheme/7pm/web/images/bg_brc.jpg
--- 20200119-20 增刪修 Mega Menu
=========================================================================================================================
缺主圖片
x318>>>6BT-150->no pic
x332>>>USPS-20->no pic
x444>>>SO-003->no pic
x477>>>SP-004->no pic
576>>>UG-50G->no pic
606>>>RQ-5-100+4->no pic
629>>>UG-100-200->no pic
x681>>>UG-50-150->no pic
699>>>SO-002->no pic
x717>>>SO-003->no pic
圖片不存在
701>>>FT-M200.jpg
704>>>RQ5-5T-50.jpg

!BkJeFJQB2k~$(KGrHqUH-CkEs+T,q!(EBLWTm-zWz!~~_12.JPG->FT-PP-25.jpg

q-2.csv
Images File Directory -> pwpic

copy sale:desc+name -> magento8pm
上傳 gen-product-desc-name.php -> pwc gen-product-desc-name.phpx
cd /var/www/html/pwpic
wget http://www.purewaterclub.com/gen-product-desc-name.phpx -O /var/www/html/pwpic/gen-product-desc-name.php
http://aws.wg-1.com/gen-product-desc-name.php

產品基本資料->表:catalog_product_entity
entity_id=1824
sku='RO-QQ-101'
產品說明->表:catalog_product_entity_text
attribute_id=72(Desc)
attribute_id=73(short Desc)
entity_id=1824
value=Desc-331(原sale product_id)
產品名稱->表:catalog_product_entity_varchar
attribute_id=70
entity_id=1824
value=Name-331(原sale product_id)
產品圖片->表:catalog_product_entity_varchar
attribute_id=84(base_image)
attribute_id=85(small_image)
attribute_id=86(thumbnail_image)
attribute_id=150(swatch_image)
entity_id=1824
value=/2/2/22-28.jpg
產品庫存->表:cataloginventory_stock_item(各種數量max,min..)
product_id=1824
qty=919818.0000
->表:cataloginventory_stock_status
product_id=1824
qty=919818.0000
stock_status=1
產品價格->表:catalog_product_entity_decimal
entity_id=1824
attribute_id=74
value=123.4500
->?表:catalog_product_index_price
entity_id=1824

gen-product-csv.php
收集產品主圖片->../aws/catalog/images/->ftp下載整理->手工zip aws-20200118.zip->ftp上傳ro站
aws:
cd /var/www/html/pwpic/catalog/images/
wget http://www.purewaterclub.com/aws-20200118.zip ->  unzip aws-20200118.zip

--- 20200118 mag2 product 產品主圖 + 補缺圖
=========================================================================================================================
Marketing->Cart Price Rule->滿$50包郵->Conditions
->Subtotal  equals or greater than  50

x->借用屬性 Eco_Collect 成為 Free Shipping(false:可以排除不包郵的item)
(20200216 改不借用Eco_Collect,新增Free Shipping屬性 + Attribute Code->free_shipping + Attribute Properties->Scope->Global + Storefront Properties->Use for Promo Rule Conditions->YES)
Actions->Apply the rule only to cart items matching the following conditions (leave blank for all items).
->Free Shipping  is  Yes
cart rule->if Free Shipping is TRUE

--- 20191225 mag2 shipping rule
=========================================================================================================================

Configuration->VES THEMESETTINGS->Product View Page->Tab By Product Attribute Code->Add Attribute Code 
Configuration->VES THEMESETTINGS->Product View Page->Tab By CMS Block->Add Attribute Code 
不可以Add 空白否則產品頁500錯誤

koofficecn 2019/12/20 14:40:25
http://18.218.158.219/magento8pm/ada.php
koofficecn 2019/12/20 14:40:33
openssl
OpenSSL support	enabled
OpenSSL Library Version	OpenSSL 1.1.1c 28 May 2019
OpenSSL Header Version	OpenSSL 1.1.1c 28 May 2019
Openssl default config	/usr/lib/ssl/openssl.cnf

ADA 22:26:13
root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:clean
Cleaned cache types:
config
layout
block_html
collections
reflection
db_ddl
eav
customer_notification
full_page
config_integration
config_integration_api
translate
config_webservice

要用 /usr/bin/php 不能只用 php
root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:01
Customer Grid index has been rebuilt successfully in 00:00:01
Category Products index has been rebuilt successfully in 00:00:00
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:00
Product EAV index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:03

不過 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:clean 可以, 
但 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:flush 會出錯, 
所以我是回後台, 用後台 admin 作 cache management , 然後才去用命令列, 
執行 root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento indexer:reindex

cd /var/www/html/magento8pm
/usr/bin/php bin/magento indexer:reindex

--- 20191222 mag2 import product + reindex
=========================================================================================================================

root@ip-172-31-32-158:/var/www/html/magento8pm# /usr/bin/php bin/magento cache:clean
Cleaned cache types:
config
layout
block_html
collections
reflection
db_ddl
eav
customer_notification
full_page
config_integration
config_integration_api
translate
config_webservi


cd /var/www/html/magento8pm
find . -type f -exec chmod 644 {} /; && find . -type d -exec chmod 755 {} /; && chmod 777 var/ -R && find pub/media -type d -exec chmod 777 {} /; && find pub/static -type d -exec chmod 777 {} /; && chmod 777 app/etc && chmod 644 app/etc/*.xml && chmod u+x bin/magento

adduser zou
passwd zou
joe /etc/sudoers -> zou  ALL=(ALL:ALL) ALL
usermod -a -G www-data zou
groups www-data

cd /var/www/html/magento8pm
chown -R www-data:www-data .

cd /var/www/html/magento8pm
find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} /;
find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} /;
find . -type f -exec chmod 644 {} /;
find . -type d -exec chmod 755 {} /;
find ./var -type d -exec chmod 777 {} /;
chmod 777 var/ -R
find ./pub/media -type d -exec chmod 777 {} /;
find ./pub/static -type d -exec chmod 777 {} /;
chmod 777 ./app/etc
chmod 644 ./app/etc/*.xml
xxxx-> chown zou:zou . -hR <--- xxx
chmod u+x bin/magento
chmod -R g+rwxs .
ls -la

joe /etc/php/7.0/fpm/pool.d/www.conf
chmod u+x qq

cd /var/www/html/magento8pm
sudo php bin/magento indexer:reindex
php /var/www/html/magento8pm/bin/magento indexer:reindex
The openssl extension is required for SSL/TLS protection but is not available. 
If you can not enable the openssl extension, you can disable this error, at your own risk, 
by setting the 'disable-tls' option to true.
#0 /var/www/html/magento8pm/vendor/composer/composer/src/Composer/Factory.php(306): Composer/Factory::createRemoteFilesystem(Object(Composer/IO/BufferIO), Object(Composer/Config))
#1 /var/www/html/magento8pm/vendor/composer/composer/src/Composer/Factory.php(532): Composer/Factory->createComposer(Object(Composer/IO/BufferIO), Array, false)
#2 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerFactory.php(47): Composer/Factory::create(Object(Composer/IO/BufferIO), '/var/www/html/m...')
#3 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerInformation.php(362): Magento/Framework/Composer/ComposerFactory->create()
#4 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerInformation.php(375): Magento/Framework/Composer/ComposerInformation->getComposer()
#5 /var/www/html/magento8pm/vendor/magento/framework/Composer/ComposerInformation.php(242): Magento/Framework/Composer/ComposerInformation->getLocker()
#6 /var/www/html/magento8pm/vendor/magento/framework/App/ProductMetadata.php(104): Magento/Framework/Composer/ComposerInformation->getSystemPackages()
#7 /var/www/html/magento8pm/vendor/magento/framework/App/ProductMetadata.php(65): Magento/Framework/App/ProductMetadata->getSystemPackageVersion()
#8 /var/www/html/magento8pm/vendor/magento/framework/Console/Cli.php(81): Magento/Framework/App/ProductMetadata->getVersion()
#9 /var/www/html/magento8pm/bin/magento(22): Magento/Framework/Console/Cli->__construct('Magento CLI')
#10 {main}


Fatal error: Uncaught Error: Class 'Cli' not found in /var/www/html/magento8pm/bin/magento:31
Stack trace:
#0 {main}
  thrown in /var/www/html/magento8pm/bin/magento on line 31

不可用sudo
composer config -g -- disable-tls true
service apache2 restart

ln -s /var/www/html/pwpic /var/www/html/magento8pm/pwpic
Images File Directory -> pwpic
catalog_product_20191216_044905
/catalog/images/22-28.jpg
url -> atomic-endurance-running-tee-v-neck-s-blue 
35138564
cd /var/www/html/magento8pm
php bin/magento indexer:reindex
php bin/magento cache:clean && php bin/magento cache:flush

Table eav_entity_type.entity_type_id=4(catalog_product)
->Table eav_attribute.attribute_id=72(catalog_product-description-text)
->Table catalog_product_entity.entity_id=1792(sku=RQ-6B2W-100)
->Table catalog_product_entity_text.attribute_id=72 + .entity_id=1792(value=description html)

sale.products.products_model->sku

--- 20191213 AWS mySQL Table
=========================================================================================================================
cd /var/www/html/pwpic
wget http://www.purewaterclub.com/pid.phpx -O /var/www/html/pwpic/pid.php
http://www.purewaterclub.com/pid.php?p=264 -> http://aws.wg-1.com/pid.php?p=264

2434
72
0
1792

<img style="WIDTH: 535px; HEIGHT: 551px" height=1450 src="http://aws.wg-1.com/items/Pic/RQ/RQ-5-100.JPG" width=954>
->去掉height
UPDATE catalog_product_entity_text SET value='$tmphtm' WHERE value_id='2434' AND attribute_id='72' AND entity_id='1792' 
STORES->Configuration->VES THEMESETTINGS->Profuct View Page->Tab

--- 20191213 AWS PHP + mySQL
=========================================================================================================================
cd /var/www/html/pwpic
wget http://www.purewaterclub.com/aws-20191205.zip -> 解壓zip
ro.wg-1.com 指向+對應 59.124.16.10 /home/httpd/www/aws
aws.wg-1.com 指向+對應 AWS /var/www/html/pwpic
更新所有連結<img src..> 
59.124.16.10 -> aws.wg-1.com
www.purewaterclub.com -> aws.wg-1.com
products_description_wk copy to products_description

%20 -> / 
http://aws.wg-1.com/items/Pic/PO/2way%20switch.jpg -> 2way/ switch.jpg
http://aws.wg-1.com/items/Pic/SP/Collet%20release%20tool.JPG -> Collet/ release/ tool.JPG
http://aws.wg-1.com/items/Pic/SP/Collet%20release%20tool-1.JPG -> Collet/ release/ tool-1.JPG
http://aws.wg-1.com/items/Pic/SP/SP-Collet%20release%20tool.JPG -> SP-Collet/ release/ tool.JPG
http://aws.wg-1.com/items/Pic/SP/SP-Collet%20release%20tool-1.JPG -> SP-Collet/ release/ tool-1.JPG
http://aws.wg-1.com/items/Pic/000/install/tube%20remove.jpg -> tube/ remove.jpg
http://aws.wg-1.com/items/Pic/000/First-Class%20Mail.jpg -> First-Class/ Mail.jpg
http://aws.wg-1.com/items/Pic/PT/bracket%20-size.JPG -> bracket -size.JPG
http://aws.wg-1.com/items/Pic/000/FS/FS20-PPx25-2.JPG ->換圖

wget http://www.purewaterclub.com/items/Pic/000/parts/B38.jpg -O /var/www/html/pwpic/items/Pic/000/parts/B38.jpg
wget http://www.purewaterclub.com/items/Pic/000/parts/B38-1.JPG -O /var/www/html/pwpic/items/Pic/000/parts/B38-1.JPG
wget http://www.purewaterclub.com/items/Pic/000/parts/B38-2.JPG -O /var/www/html/pwpic/items/Pic/000/parts/B38-2.JPG
wget http://www.purewaterclub.com/items/Pic/000/parts/B38-3.jpg -O /var/www/html/pwpic/items/Pic/000/parts/B38-3.jpg

--- 20191205 舊RO站所有pic -> AWS
=========================================================================================================================
www.purewaterclub.com -> /home/httpd/www/sale copy -> /home/httpd/www/aws
59.124.16.10 -> /home/httpd/www/ksoffice copy -> /home/httpd/www/aws
通知 ML
http://www.purewaterclub.com/catalog/product_info.php?products_id=709 -> 5破圖
取消所有超連結
未來新產品儘量使用全圖片

--- 20191204 集中舊RO站所有產品說明的pic
=========================================================================================================================
1.) copy products_description-20191128 -> products_description_20191203_0
2.) products_description_20191203_0 新增 products_description_0
3.) UPDATE products_description_20191203_0 SET products_description_0=products_description
4.) copy products_description_20191203_0 -> products_description_wk
5.) php 去除所有 href + 修正所有 img 後同時寫回 mySQL language_id=1,2
6.) 手工改/加圖檔

--- 20191203 修改舊RO站產品說明 去除所有href + 修正 img
=========================================================================================================================
www.purewaterclub.com -> /home/httpd/www/sale , 59.124.16.10 -> /home/httpd/www/ksoffice

1.) 去除 <a name="RO-F1"> <a name="RO-F2"> <a name="RO-F3"> <a name="RO-F4"> <a name="RO-F5"> <a name="RO-F6"> (112 + 128 + 104 + 130 + 46 + 44 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-F1">','') WHERE products_description LIKE '%<a name="RO-F1">%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-F2">','') WHERE products_description LIKE '%<a name="RO-F2">%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-F3">','') WHERE products_description LIKE '%<a name="RO-F3">%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-F4">','') WHERE products_description LIKE '%<a name="RO-F4">%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-F5">','') WHERE products_description LIKE '%<a name="RO-F5">%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-F6">','') WHERE products_description LIKE '%<a name="RO-F6">%';
2.) 去除 <A name=RO-F1></A>..<A name=RO-F6></A> (92 + 90 + 86 + 76 + 22 + 42 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-F1></A>','') WHERE products_description LIKE '%<A name=RO-F1></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-F2></A>','') WHERE products_description LIKE '%<A name=RO-F2></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-F3></A>','') WHERE products_description LIKE '%<A name=RO-F3></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-F4></A>','') WHERE products_description LIKE '%<A name=RO-F4></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-F5></A>','') WHERE products_description LIKE '%<A name=RO-F5></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-F6></A>','') WHERE products_description LIKE '%<A name=RO-F6></A>%';
3.) 去除 <A name=RO-P1></A>..<A name=RO-P6></A> (18 + 60 + 60 + 56 + 20 + 20 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-P1></A>','') WHERE products_description LIKE '%<A name=RO-P1></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-P2></A>','') WHERE products_description LIKE '%<A name=RO-P2></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-P3></A>','') WHERE products_description LIKE '%<A name=RO-P3></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-P4></A>','') WHERE products_description LIKE '%<A name=RO-P4></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-P5></A>','') WHERE products_description LIKE '%<A name=RO-P5></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=RO-P6></A>','') WHERE products_description LIKE '%<A name=RO-P6></A>%';
4.) 去除 <a name="RO-P1"></a>..<a name="RO-P6"></a> (4 + 98 + 58 + 46 + 10 + 8 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-P1"></a>','') WHERE products_description LIKE '%<a name="RO-P1"></a>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-P2"></a>','') WHERE products_description LIKE '%<a name="RO-P2"></a>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-P3"></a>','') WHERE products_description LIKE '%<a name="RO-P3"></a>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-P4"></a>','') WHERE products_description LIKE '%<a name="RO-P4"></a>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-P5"></a>','') WHERE products_description LIKE '%<a name="RO-P5"></a>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="RO-P6"></a>','') WHERE products_description LIKE '%<a name="RO-P6"></a>%';
5.) 去除 <A name=T1><FONT color=red></FONT></A> <A name=T1></A> <a name="T1"><font color="red"></font></a> <A name=T1><FONT color=red></A>(4 + 2 + 8 + 4 + 20 + 20 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=T1><FONT color=red></FONT></A>','') WHERE products_description LIKE '%<A name=T1><FONT color=red></FONT></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=T1></A>','') WHERE products_description LIKE '%<A name=T1></A>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<a name="T1"><font color="red"></font></a>','') WHERE products_description LIKE '%<a name="T1"><font color="red"></font></a>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<A name=T1><FONT color=red></A>','') WHERE products_description LIKE '%<A name=T1><FONT color=red></A>%';

6.) 去除 <span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-209/Content1.jpg" target=_blank><font color=#ffffff>Instructions menu</font></a></span> (6 records)
SELECT * FROM products_description WHERE products_description LIKE '%<span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-209/Content1.jpg" target=_blank><font color=#ffffff>Instructions menu</font></a></span>%'
UPDATE products_description SET products_description=REPLACE(products_description,'<span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-209/Content1.jpg" target=_blank><font color=#ffffff>Instructions menu</font></a></span>','') WHERE products_description LIKE '%<span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-209/Content1.jpg" target=_blank><font color=#ffffff>Instructions menu</font></a></span>%';
7.) 去除 <span style="background-color: rgb(0, 0, 255);"><a target="_blank" href="http://59.124.16.10/items/Pic/22-209/Content1.jpg"><font color="#ffffff">Instructions   									menu</font></a></span> (2 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<span style="background-color: rgb(0, 0, 255);"><a target="_blank" href="http://59.124.16.10/items/Pic/22-209/Content1.jpg"><font color="#ffffff">Instructions   									menu</font></a></span>','') WHERE products_description LIKE '%<span style="background-color: rgb(0, 0, 255);"><a target="_blank" href="http://59.124.16.10/items/Pic/22-209/Content1.jpg"><font color="#ffffff">Instructions   									menu</font></a></span>%';
8.) 去除 <span style="background-color: rgb(0, 0, 255);"><a target="_blank" href="http://59.124.16.10/items/Pic/22-28/22-28-2.jpg"><font color="#ffffff">Instructions   									menu</font></a></span> (2 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<span style="background-color: rgb(0, 0, 255);"><a target="_blank" href="http://59.124.16.10/items/Pic/22-28/22-28-2.jpg"><font color="#ffffff">Instructions   									menu</font></a></span>','') WHERE products_description LIKE '%<span style="background-color: rgb(0, 0, 255);"><a target="_blank" href="http://59.124.16.10/items/Pic/22-28/22-28-2.jpg"><font color="#ffffff">Instructions   									menu</font></a></span>%';
9.) 去除 <span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-28/22-28-2.jpg" target=_blank><font color=#ffffff>nstructions menu</font></a></span> (2 records)
UPDATE products_description SET products_description=REPLACE(products_description,'<span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-28/22-28-2.jpg" target=_blank><font color=#ffffff>nstructions menu</font></a></span>','') WHERE products_description LIKE '%<span style="BACKGROUND-COLOR: #0000ff"><a href="http://59.124.16.10/items/Pic/22-28/22-28-2.jpg" target=_blank><font color=#ffffff>nstructions menu</font></a></span>%';

11.) 手工去除 <a href="http://59.124.16.10/items/Pic/22-4176/ph.gif"></a> 增加 <img src="http://59.124.16.10/items/Pic/22-4176/ph.gif"> (products_id=305,307,308,312,355)
12.) 手工去除 <a name=RO-F1></a>..<a name=RO-F5></a>
13.) <a href= .pdf or .doc -> remove whole

--- 20191202 修改舊RO站產品說明 去除href
=========================================================================================================================

1.) 去除 ?�� ?�� (76 records)
SELECT * FROM products_description WHERE products_description LIKE '%?��%'
UPDATE products_description SET products_description=REPLACE(products_description,'?��','') WHERE products_description LIKE '%?��%'
2.) 去除 (Please Click Picture to enlarge the picture) (324 + 94 + 52 records)
SELECT * FROM products_description WHERE products_description LIKE '%(Please Click Picture to enlarge the picture)%'
UPDATE products_description SET products_description=REPLACE(products_description,'(Please Click Picture to enlarge the picture)','') WHERE products_description LIKE '%(Please Click Picture to enlarge the picture)%'
UPDATE products_description SET products_description=REPLACE(products_description,'(Please Click ','') WHERE products_description LIKE '%(Please Click %'
UPDATE products_description SET products_description=REPLACE(products_description,'Picture to enlarge the','') WHERE products_description LIKE '%Picture to enlarge the%'
UPDATE products_description SET products_description=REPLACE(products_description,'picture)','') WHERE products_description LIKE '%picture)%'
UPDATE products_description SET products_description=REPLACE(products_description,'Picture to','') WHERE products_description LIKE '%Picture to%'
UPDATE products_description SET products_description=REPLACE(products_description,'enlarge the picture)','') WHERE products_description LIKE '%enlarge the picture)%'
UPDATE products_description SET products_description=REPLACE(products_description,'the picture)','') WHERE products_description LIKE '%the picture)%'
UPDATE products_description SET products_description=REPLACE(products_description,'enlarge','') WHERE products_description LIKE '%enlarge%'
UPDATE products_description SET products_description=REPLACE(products_description,'PW- PW-Picture)','') WHERE products_description LIKE '%PW- PW-Picture)%'
UPDATE products_description SET products_description=REPLACE(products_description,'Picture)','') WHERE products_description LIKE '%Picture)%'

10.) 去除 <p>&nbsp;</p> (82 + 128 records)
SELECT * FROM products_description WHERE products_description LIKE '%<p>&nbsp;</p>%'
UPDATE products_description SET products_description=REPLACE(products_description,'<p>&nbsp;</p>','') WHERE products_description LIKE '%<p>&nbsp;</p>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<P>&nbsp;</P>','') WHERE products_description LIKE '%<p>&nbsp;</p>%';
11.) 去除 <p><br>&nbsp;</p> (38 + 48 records)
SELECT * FROM products_description WHERE products_description LIKE '%<p><br>&nbsp;</p>%'
UPDATE products_description SET products_description=REPLACE(products_description,'<p><br>&nbsp;</p>','') WHERE products_description LIKE '%<p><br>&nbsp;</p>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<P><BR>&nbsp;</P>','') WHERE products_description LIKE '%<p><br>&nbsp;</p>%';
12.) 去除 <strong></strong> (102 + 98 records)
SELECT * FROM products_description WHERE products_description LIKE '%<strong></strong>%'
UPDATE products_description SET products_description=REPLACE(products_description,'<strong></strong>','') WHERE products_description LIKE '%<strong></strong>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<STRONG></STRONG>','') WHERE products_description LIKE '%<strong></strong>%';
13.) 去除 <p></p> (180 + 102 records)
SELECT * FROM products_description WHERE products_description LIKE '%<p></p>%'
UPDATE products_description SET products_description=REPLACE(products_description,'<p></p>','') WHERE products_description LIKE '%<p></p>%';
UPDATE products_description SET products_description=REPLACE(products_description,'<P></P>','') WHERE products_description LIKE '%<p></p>%';
14.) 去除 <font color=red>  </font> (150 records)
SELECT * FROM products_description WHERE products_description LIKE '%<font color=red>  </font>%'
UPDATE products_description SET products_description=REPLACE(products_description,'<FONT color=red>  </FONT>','') WHERE products_description LIKE '%<font color=red>  </font>%';


<font color=red><strong>
SELECT * FROM products_description WHERE products_description LIKE '%<p><font color=blue><br><br></P></font>%'
<FONT color=red><STRONG> <BR>


--- 20191201 修改舊RO站產品說明內容 + href
=========================================================================================================================

1.) http://61.220.188.82/items/Pic/Public/US-I.bmp -> http://59.124.16.10/items/Pic/Public/US-I.jpg
SELECT * FROM products_description WHERE products_description LIKE '%http://61.220.188.82/items/Pic/Public/US-I.bmp%'
UPDATE products_description SET products_description=REPLACE(products_description,'http://61.220.188.82/items/Pic/Public/US-I.bmp','http://59.124.16.10/items/Pic/Public/US-I.jpg') WHERE products_description LIKE '%http://61.220.188.82/items/Pic/Public/US-I.bmp%'

2.) http://59.124.16.10/items/Pic/FT/DIQ-1.JPG -> http://59.124.16.10/items/Pic/FT/DIQ-2.JPG
SELECT * FROM products_description WHERE products_description LIKE '%http://59.124.16.10/items/Pic/FT/DIQ-1.JPG%'
UPDATE products_description SET products_description=REPLACE(products_description,'http://59.124.16.10/items/Pic/FT/DIQ-1.JPG','http://59.124.16.10/items/Pic/FT/DIQ-2.JPG') WHERE products_description LIKE '%http://59.124.16.10/items/Pic/FT/DIQ-1.JPG%'

3.) http://59.124.16.10/items/Pic/22-4114/22-4 /r 114.jpg -> http://59.124.16.10/items/Pic/22-4114/22-4114.jpg (products_id=191)

4.) hhttp://59.124.16.10/items/Pic/000/FT/FT-PH.jpg -> hhttp://59.124.16.10/items/Pic/000/FT/FT-PH.jpg (products_id=308)

5.) http://59.124.16.10/items/Pic/000/1042Q-1.jpg -> IMG rmoved (products_id=340)

6.) http://sm7.sitemeter.com/meter.asp?site=sm7purewaterclub -> IMG rmoved (products_id=414)

7.) (products_id=490)
http://59.124.16.10/items/Pic/22-10/22-10- /r F5-I-1.jpg -> http://59.124.16.10/items/Pic/22-10/22-10-F5-I-1.jpg 
http://59.124.16.10/items/PW-Pic/PW-22- /r 82/PW-22-82-F5-I.jpg -> http://59.124.16.10/items/PW-Pic/PW-22-82/PW-22-82-F5-I.jpg
http://59.124.16.10/items/PW- /r Pic/PW-22-82/PW-22-82-F1.jpg -> http://59.124.16.10/items/PW-Pic/PW-22-82/PW-22-82- F6.jpg
http://59.124.16.10/items/PW-Pic/PW-22- 82/PW-22-82- /r F6.jpg -> http://59.124.16.10/items/PW-Pic/PW-22-82/PW-22-82- F6.jpg

8.) <img width="1" height="1" id="_x0000_i1025" src=""> -> IMG rmoved (products_id=542)
SELECT * FROM `products_description` WHERE `products_description` like '%<img width="1" height="1" id="_x0000_i1025" src="">%'
UPDATE products_description SET products_description=REPLACE(products_description,'<img width="1" height="1" id="_x0000_i1025" src="">','') WHERE products_description LIKE '%<img width="1" height="1" id="_x0000_i1025" src="">%'

9.) &#10;&#10;http://59.124.16.10/items/Pic/000/FT/FT-PP05_2.JPG -> http://59.124.16.10/items/Pic/000/FT/FT-PP05_2.JPG (products_id=595,597,637)
SELECT * FROM `products_description` WHERE products_description LIKE '%&#10;%' AND (products_id='595' OR products_id='597' OR products_id='637')
UPDATE products_description SET products_description=REPLACE(products_description,'&#10;','') WHERE products_description LIKE '%&#10;%' AND (products_id='595' OR products_id='597' OR products_id='637')

10.) (products_id=632,633,658,661)
&#10;http://59.124.16.10/items/Pic/22-309/22-115-F1.jpg -> http://59.124.16.10/items/Pic/22-309/22-115-F1.jpg
&#10;http://59.124.16.10/items/Pic/22-309/22-115-F3.jpg -> http://59.124.16.10/items/Pic/22-309/22-115-F3.jpg
&#10;http://59.124.16.10/items/Pic/FT/T33.JPG -> http://59.124.16.10/items/Pic/FT/T33.JPG
&#10;&#10;http://59.124.16.10/items/Pic/22-36/22-36-F3.jpg -> http://59.124.16.10/items/Pic/22-36/22-36-F3.jpg
&#10;http://59.124.16.10/items/Pic/22-36/22-36-P4.jpg -> http://59.124.16.10/items/Pic/22-36/22-36-P4.jpg
&#10;&#10;http://59.124.16.10/items/Pic/22-36/22-36-P6.jpg -> http://59.124.16.10/items/Pic/22-36/22-36-P6.jpg
SELECT * FROM `products_description` WHERE products_description LIKE '%&#10;%' AND (products_id='632' OR products_id='633' OR products_id='658' OR products_id='661')
UPDATE products_description SET products_description=REPLACE(products_description,'&#10;','') WHERE products_description LIKE '%&#10;%' AND (products_id='632' OR products_id='633' OR products_id='658' OR products_id='661')

11.) http://59.124.16.10/items/Pic/000/FS/FS20-PPx25-1.JPG -> http://59.124.16.10/items/Pic/000/FS/FS20-PPx24-1.JPG (products_id=675)

12.) https: -> http: (products_id=709,716)
SELECT * FROM `products_description` WHERE products_description LIKE '%https:%' AND (products_id='709' OR products_id='716')
UPDATE products_description SET products_description=REPLACE(products_description,'https:','http:') WHERE products_description LIKE '%https:%' AND (products_id='709' OR products_id='716')

?? http://www.purewaterclub.com/catalog/images/Psi-1.jpg -> http://59.124.16.10/catalog/images/Psi-1.jpg 不顯現 30 pic
?? http://i.ebayimg.com/00/s/NDgwWDY0MA==/z/29MAAMXQ3kNTiBiu/$_12.JPG -> href ? 15 pic
http://www.purewaterclub.com/catalog/product_info.php?products_id=709 -> Miss 5 Pic
http://www.purewaterclub.com/catalog/product_info.php?products_id=711 -> Miss 1 Pic
http://www.purewaterclub.com/catalog/product_info.php?products_id=712 -> Miss 1 Pic 
----------------> total 52 pic

--- 20191130 修改舊RO站產品圖片連結
=========================================================================================================================

UPDATE products_description SET products_description_0=REPLACE(products_description_0,'?��','') WHERE products_id='169' AND language_id='1'
http://www.purewaterclub.com/catalog/product_info.php?cPath=88_87&products_id=158

舊RO站table products_description->products_description 1114 records
Logo Max 218 x 70

1.)改圖片 IP->?? AWS domain + 去掉目錄?
http://59.124.16.10/items/Pic/22-57/22-57-F5-2.jpg
2.)改file:// 244 records
file:///E:/Documents%20and%20Settings/Administrator/Local%20Settings/Temporary%20Internet%20Files/FrontPageTempDir/pvwA.htm#RO-P1
3.)去掉亂碼 76 records
?��
4.)去掉ebay hyper link 656 records
<a href="http://cgi5.ebay.com/ws/eBayISAPI.dll#RO-F1"><img src="http://59.124.16.10/items/Pic/22-15/22-15-F1-1-I.jpg" border="2" width="64"></a>
http://cgi5.ebay.com/ws/eBayISAPI.dll?SimilarListing&itemid=110389038550#RO-P1
http://stores.ebay.com/purewaterclub_Water-Filter-System_W0QQcolZ4QQdirZ1QQfclZ4QQfsubZ231976010QQftidZ2QQtZkmQQ_trksidZp1742.m154.l1264
5.)去掉無效說明
  a.) (Please Click Picture to enlarge the picture) -> 324 records
  b.)Great Gift!
      We Could Ship This Item To Your Friend Within US Continatal!
      Good For Your Family And Friends! -> 328 records
6.)去掉破圖 ??
http://59.124.16.10/items/Driver/driver.jpg
7.)去掉下載Download Manual hyper link 32 records
http://59.124.16.10/items/Driver/Protable%20RO%20instruction.doc
8.)去掉Buy It Now價格 194 records
Buy It Now is Just US$108.99 and 2-7 days* you will GET IT at HOME within US!!
9.)去掉Retail Price價格 256 records
(Retail Price:US$320)

SELECT * FROM `products_description` WHERE `products_description` LIKE '%file:%'
--- 20191110 修改舊RO站產品說明
=========================================================================================================================
magento2 table customer_entity->password_hash: 
format -> hash(md5/sha256) : salt (max 32digit) : version (0/1) (md5/sha256) ?->: convet to version (1/2?)
b7de469740dc4f7edf08fe26c4e3ee5a53bf03c5467ff2f02a831c94b707d455:mCIgmxGBoZBGKgL6vkc7xIcZcKUwYQvd:1
v.0登入成功後將主動升級v.1用sha256重寫password_hash

osCommerce 2.4.3.1 table customers->customers_password:
format v.1 -> hash(md5) : salt (2digit)
df7cde40bc6922f8a885a21ebe8fd4b0:70
format v.2 -> $P$ + D(重複作md5次數 D=2^13=8192次) + salt (64進位 8digit) + hash (64進位 21+1digit 最後1位2bit=21*6+2=128=32*4=16進位 32digit)
$P$ D NVAIbn8k ZQQop6d3QAg2lFVkSG2o2 /
./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz (64進位) -> 0123456789abcdef (16進位)

migrate osc to mag2
v.1 -> osc + : + 0
df7cde40bc6922f8a885a21ebe8fd4b0:70 -> df7cde40bc6922f8a885a21ebe8fd4b0:70:0
v.2 -> osc + : + osc去掉首位$ + : + 0
利用mag2的salt位置傳遞存檔hash,新增程式判斷若為osc v.2,則字首加上$後依v.2規則產生hash,比對若正確後回送hash
$P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/ -> $P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:P$DNVAIbn8kZQQop6d3QAg2lFVkSG2o2/:0
$P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf. -> $P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:P$DYd3TBSaZT6C85hm5amzC8RwGcu3Pf.:0

joe /var/www/html/magento8pm/vendor/magento/framework/Encryption/Encryptor.php
1.)新增產生osc v.2的password hash
public function GenPasswordHash($password,$setting){
	$itoa64='./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
	$count_log2 = strpos($itoa64,$setting[3]);
	if ($count_log2 < 7 || $count_log2 > 30)return $output;

	$count = 1 << $count_log2;
	$salt = substr($setting, 4, 8);
	if (strlen($salt) != 8)return $output;

	if (PHP_VERSION >= '5') {
		$hash = md5($salt . $password, TRUE);
		do {
			$hash = md5($hash . $password, TRUE);
		} while (--$count);
	} 
	else {
		$hash = pack('H*', md5($salt . $password));
		do {
			$hash = pack('H*', md5($hash . $password));
		} while (--$count);
	}

	$output = substr($setting, 0, 12);
	$tmpout = '';
	$count=16;
	$i = 0;
	do {
		$value = ord($hash[$i++]);
		$tmpout .= $itoa64[$value & 0x3f];
		if ($i < $count)$value |= ord($hash[$i]) << 8;
		$tmpout .= $itoa64[($value >> 6) & 0x3f];
		if ($i++ >= $count)break;
		if ($i < $count)$value |= ord($hash[$i]) << 16;
		$tmpout .= $itoa64[($value >> 12) & 0x3f];
		if ($i++ >= $count)break;
		$tmpout .= $itoa64[($value >> 18) & 0x3f];
	}while ($i < $count);
	$output .= $tmpout;

	return $output;
}

2.)修改原有的isValidHash(),加入判斷利用salt位置傳遞的hash值是否為osc v.2,並比對由GenPasswordHash()產生的v.2 hash是否正確
    public function isValidHash($password, $hash)
    {
        $this->explodePasswordHash($hash);

        foreach ($this->getPasswordVersion() as $hashVersion) {

//            $password = $this->hash($this->getPasswordSalt() . $password, $hashVersion);

//----- 20191109 DV -------
//--- check if RO Site 2nd password hash ($P$D... 33 digit)->(P$D... 32 digit)
$tmpsalt=$this->getPasswordSalt();
if($hashVersion==0 && substr($tmpsalt,0,3)=='P$D'){
	//--- make hash by salt
	$tmpsalt="$".$tmpsalt;
	//--- check if password OK with SQL hash($ + P$D..)
	if($this->GenPasswordHash($password,$tmpsalt)==$tmpsalt){
		//--- set password -> generated hash
		$password=$tmpsalt;
	}
}
else{
  $password=$this->hash($tmpsalt.$password,$hashVersion);
}
//-----
				}
        return Security::compareStrings(
            $password,
            $this->getPasswordHash()
        );
    }

magento2 核心密碼比對程式
01.)D:/Temp-Downloads/AWS/8pm-zip/vendor/zendframework/zend-crypt/src/Utils.php -> public static function compareStrings($expected, $actual) -> 逐ord()比對產生Hash vs SQLHash -> return true
02.)D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/Helper/Security.php -> public static function compareStrings($expected, $actual) -> by pass call (01) -> return true
03.)D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/Encryptor.php -> public function isValidHash($password, $hash) ->展開SQLHash成passwordHashMap array,根據不同$hashVersion()+getPasswordSalt()+password產生Hash -> 比對SQLHash+getPasswordHash() call (02) -> return true
03-1.)D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/zendframework1/library/Zend/Crypt.php -> public static function hash($algorithm, $data, $binaryOutput = false)實際產生Hash for (03)

研究用only
/var/www/html/magento8pm/vendor/magento/module-customer/Model/AccountManagement.php
cd /var/www/html/magento8pm/vendor/magento/module-customer/Model/
mv AccountManagement.php-x AccountManagement.php
wget http://61.220.188.84/dv-2019-tmp/AccountManagement.php
wget http://61.220.188.84/dv-2019-tmp/PasswordHash.x
----------------

https://blog.csdn.net/chengfei112233/article/details/6939144/
密码生成方式
> 随机产生一个salt 并将salt和password相加
> 进行了count次md5 然后和encode64的hash数值累加
> 最后得到一个以$P$开头的密码，这个密码每次产生的结果都不一样C:/Users/dv-10/Desktop/catalog/includes/classes/passwordhash.php
系统：MD5(WordPress)
例子：$P$B123456780BhGFYSlUqGyE6ErKErL01
说明：WordPress使用的md5
长度：34个字符
描述：$P$表示加密类型，然后跟着一位字符，经常是字符‘B’，后面是8位salt，后面是就是hash
加密算法：8192次md5循环加密 -> 2的(8+5=13)次方=8192


--- 20191107 遷移舊RO站客戶資料 -> 一元站
=========================================================================================================================

/var/www/html/magento8pm/app/design/frontend/Zou/demo/
x->joe /usr/local/apache/conf/httpd.conf
x->joe /etc/apache2/apache2.conf

<VirtualHost *:80>
    ServerName          www.buck4u.com
    DocumentRoot        /var/www/html/magento8pm/pub/
    SetEnv MAGE_MODE "developer"
 </VirtualHost>

 <VirtualHost *:80>
    ServerName          www.buck4all.com
    DocumentRoot        /var/www/html/magento8pm/pub/
    SetEnv MAGE_MODE "developer"
    SetEnv MAGE_RUN_CODE "demo3"
    SetEnv MAGE_RUN_TYPE "website"
 </VirtualHost>

service apache2 restart

/etc/apache2/sites-enabled/mag-wg-1.conf /etc/apache2/sites-available/mag-wg-1.conf
/etc/apache2/sites-enabled/000-default.conf
/etc/apache2/sites-available/000-default.conf
/etc/apache2/sites-available/buck4u.conf
/etc/apache2/sites-enabled/buck4u.conf

ls -al /etc/apache2/sites-enabled/
是 /etc/apache2/sites-available / buck4u.conf 這個, documentroot 對應 magento8pm/pub , 那個 setenv 才有效
在 magneto8pm 和 magneto8pm/pub 下 都各有一個 .htaccess 裡面有指定 index.php 

RO站後台入口
https://www.purewaterclub.com/catalog/admin/
admin + admin1234!


D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-downloadable/view/frontend/layout/downloadable_customer_products.xml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Model/Customer/Attribute/Backend/Password.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Exception/InvalidEmailOrPasswordException.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Model/AuthenticationInterface.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-captcha/Observer/CheckUserLoginObserver.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-captcha/Test/Unit/Observer/CheckUserEditObserverTest.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-captcha/Test/Unit/Observer/CheckUserLoginObserverTest.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Controller/Account/EditPost.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Model/Authentication.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/Observer/CustomerLoginSuccessObserver.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/Encryptor.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/PasswordHash.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/Encryption/CheckOscPswHash.php
----------------------------------------------------------------------------------------------------------
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend/layout/default.xml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend/page_layout/1column.xml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/base/page_layout/empty.xml
D:/Temp-Downloads/AWS/8pm-zip/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml
D:/Temp-Downloads/AWS/8pm-zip/app/code/Ves/Themesettings/Block/Html/Header.php
D:/Temp-Downloads/AWS/8pm-zip/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml
D:/Temp-Downloads/AWS/8pm-zip/app/code/Ves/Themesettings/Block/Html/Links.php
D:/Temp-Downloads/AWS/8pm-zip/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/View/Element/Html/Links.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/View/Element/Template.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/framework/View/Element/AbstractBlock.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/layout/default.xml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/templates/product/compare/link.phtml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/Block/Html/Header.php
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend/templates/html/header.phtml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-customer/view/frontend/layout/default.xml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/layout/default.xml
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/templates/link.phtml

table: catalog_product_entity_text
entity_id: item id -> attribute_id, value
table: eav_attribute
attribute_id: 72 -> attribute_code: description
attribute_id: 73 -> attribute_code: short_description
attribute_id: 82 -> attribute_code: meta_keyword

Atomic Endurance Running Tee (V-neck)-S-Blue

修改footer2 背景顏色:
8pm Footer 2 -> Design Elemment -> Prefix Class -> 去掉footer2(黑變白)
修改shipping:
STORES -> Configuration -> SALES -> Shipping Methods
修改payment:
STORES -> Configuration -> SALES -> Payment Methods

修改注冊設定:
Configuration -> CUSTOMERS -> Customer Configuration -> Password Options -> Number of Required Character Classes: 3 -> 2 

(20191026)
Element Builder -> 8pm categories -> Design -> (Widget) Categories Info And Subcategories -> Edit
首頁目錄element改長寬: 
(Toggle Code) limit_subcategory=/"3/" limit=/"3/" columns=/"3/" 

首頁目錄element改目錄類別: 
(Toggle Code) catsid=/"20,11,13,3/"


/var/www/html/magento8pm/pub/media/catalog/category/cat6.jpg
-----------------------  Ref -----------------------------------------------
<Magento_Xxx_module_dir>
app/code/Magento/Xxx/
vendor/magento/module-xxx/
<theme_dir>
app/design/frontend/Venustheme/8pm/
vendor/magento/theme-frontend-blank/

Base layouts:
<Magento_Xxx_module_dir>/view/frontend/layout
<Magento_Xxx_module_dir>/view/frontend/page_layout
Theme layouts:
<theme_dir>/<Namespace>_<Module>/layout
<theme_dir>/<Namespace>_<Module>/page_layout

All layouts:
/var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layouts.xml
-----------------------  OK Used -----------------------------------------
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/theme.xml


A.)	Base Page configuration:
/var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/layout/default.xml
A-1.) <page layout="3columns" -> Base Page layout: -> container page-header
/var/www/html/magento8pm/vendor/magento/module-theme/view/frontend/page_layout/3columns.xml
A-2.) <update handle="2columns-left"/> -> 2columns-right -> 1column -> <updatehandle="empty"/> -> container page-wrapper
/var/www/html/magento8pm/vendor/magento/module-
theme/view/base/page_layout/empty.xml

B.)	Main Customer (Ves) Theme Page configuration:
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/layout/default.xml
B-1.) <block class="Ves/Themesettings/Block/Html/Header" name="ves_header"> -> header.container :: block ves_header ->
/var/www/html/magento8pm/app/code/Ves/Themesettings/Block/Html/ Header.php
  B-1-1.) protected $_template = 'header/default.phtml' ->  /var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml
B-2.) <block class="Ves/Themesettings/Block/Html/Links" name="top.links"> -> header.container -> block ves_header -> block top.links ->
/var/www/html/magento8pm/app/code/Ves/Themesettings/Block/Html/Links.php
    B-2-1.) $this->setTemplate("Ves_Themesettings::html/links.phtml"); ->
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml
B-2-2.) class Links extends /Magento/Framework/View/Element/Html/Links -> class Links extends /Magento/Framework/View/Element/Template -> class Template extends AbstractBlock
C.) Sub Customer (Ves) Theme Page configuration: -> 自動搜vendor/magento下的所有module-XXX/view/frontend/layout/default.xml -> module-catalog , module-customer, module-wishlist

C-1.) module-catalog -> <blocklass="Magento/Framework/View/Element/Template" name="catalog.compare.link" before="-" template="Magento_Catalog::product/compare/link.phtml"> ->
/var/www/html/magento8pm/vendor/magento/module-catalog/view/frontend/layout/default.xml
C-2.) module-theme (原本為"-",被C-1 也是"-",插隊變第二) -> <block class="Magento/Theme/Block/Html/Header" name="header" as="header" before="-"> -> 
/var/www/html/magento8pm/vendor/magento/module-customer/view/frontend/layout/default.xml
C-3.) module-customer -> <block class="Magento/Customer/Block/Account/Link" name="my-account-link"> -> 
/var/www/html/magento8pm/vendor/magento/module-customer/view/frontend/layout/default.xml
C-4.) module- wishlist -> <block class="Magento/Wishlist/Block/Link" name="wish-list-link" after="my-account-link"/> -> 
/var/www/html/magento8pm/vendor/magento/module-wishlist/view/frontend/layout/default.xml
C-5.) register-link -> module- wishlist -> <block class="Magento/Customer/Block/Account/RegisterLink" name="register-link"/>
C-6.) authorization-link -> module- wishlist -> <block class="Magento/Customer/Block/Account/AuthorizationLink" name="authorization-link" template="account/link/authorization.phtml"/>



<block class="Magento/Framework/View/Element/Html/Links" name="top.links"> ->
/var/www/html/magento8pm/vendor/magento/framework/View/Element/Html/Links.php

/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml

------------------------- X-- No Used  ---------------------------------------------------
/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Magento_Theme/page_layout/1column.xml
<update handle="empty"/> ->
/var/www/html/magento8pm/vendor/magento/module-theme/view/base/page_layout/empty.xml
-----------------------------------------------------




(20190914)
社区
https://magento.stackexchange.com
https://stackoverflow.com/
https://community.magento.com/

cd /var/www/html/magento8pm/
home page 
->
app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/html/links.phtml
->
vendor/magento/framework/View/Element/Html/Links.php

index.php -> app/bootstrap.php -> app/autoload.php -> vender/autoload.php -> vender/composer/autoloadreal.php

首頁:

class Links extends /Magento/Framework/View/Element/Html/Links ->
/var/www/html/magento8pm/vendor/magento/framework/View/Element/Html/Links.php
class Links extends /Magento/Framework/View/Element/Template ->
class Template extends AbstractBlock ->
abstract class AbstractBlock extends /Magento/Framework/DataObject implements BlockInterface ->





/var/www/html/magento8pm/vendor/magento/module-catalog/view/frontend/layout/default.xml


/var/www/html/magento8pm/app/design/frontend/Venustheme/8pm/Ves_Themesettings/templates/header/default.phtml
<?php echo $this->getChildHtml('top_links') ?>  -->


D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-theme/view/frontend




首頁右上角人頭下拉選單:
選項 catalog.compare.link
定義頁 -> 
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/layout/default.xml ->
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-catalog/view/frontend/templates/product/compare/link.phtml
去掉 Compare Products -> 
mv /var/www/html/magento8pm/vendor/magento/module-catalog/view/frontend/templates/product/compare/link.phtml

選項 wish-list-link
定義頁 -> 
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/layout/default.xml ->
D:/Temp-Downloads/AWS/8pm-zip/vendor/magento/module-wishlist/view/frontend/templates/link.phtml
去掉My Wish List -> 
mv /var/www/html/magento8pm/vendor/magento/module-wishlist/view/frontend/templates/link.phtml 

改LOGO:
http://www.buck4u.com/magento8pm/pub/media/logo/default/logo.png
ls /var/www/html/magento8pm/pub/media/logo/default/logo.png
cd /var/www/html/magento8pm/pub/media/logo/default/
wget http://61.220.188.84/dv-2019-tmp/logo.png

去掉首頁 panel tool:
VES THEMESETTINGS -> General Settings -> Panel Tool -> Enable -> No

去掉 element->8pm-product 彈出 compare, review, price, addtocart:
show_compare=/"1/" -> show_compare=/"0/"
show_review=/"1/" -> show_review=/"0/"
show_price=/"1/" -> show_price=/"0/"
show_addtocart=/"1/" -> show_addtocart=/"0/"


/Magento/Framework/Exception/LocalizedException

cd /var/www/html/magento8pm/


(20191026)
AWS 啟動實例
IP-> 3.17.62.14 -> 18.218.158.219
phpmyadmin: http://18.218.158.219/awsadmin/ root + revres88

(20190909)
puttygen.exe + dv-1.pem -> dv-1.ppk
ssh: putty + IP + dv-1.ppk -> sudo su
phpmyadmin: http://3.17.62.14/awsadmin/ root + revres88
手工改mysql data base: magento8pm
megamenu -> table ves_megamenu_item 
首頁header -> Main Website -> Search Box, Language, Currency(取消)



/etc/apache2/sites-enabled/mag-wg-1.conf <- 網址 mag.wg-1.com 的設定檔, 實際設定檔在 /etc/apache2/sites-abvilable/mag-wg-1.conf
/etc/apache2/sites-enabled/000-default.conf <- 預設網址 www.buck4u.com 的設定檔, 指向到 /var/www/html 目錄

之前給的STORE網址, 直接連就已經是錯誤, mag.wg-1.com 我改指向到 /var/www/html/mag-wg-1/ 目錄, 再由 index.html 去指向到 測試網址

/etc/apache2/apache2.conf 和 /var/www/html/magento8pm/.htaccess 都已經復原

apache 的 conf
/etc/apache2/apache2.conf
<VirtualHost *:80>
 DocumentRoot /home/httpd/www/magento8pm
 ServerName www.buck4u.com
 <directory /home/httpd/www/magento8pm>
 AllowOverride all
 Order allow,deny
 Allow from all
 </directory>
 ErrorLog /var/log/httpd/error_log
 CustomLog /var/log/httpd/access_log common
</VirtualHost>

<VirtualHost *:80>
 DocumentRoot /home/httpd/www/magento8pm
 ServerName mag.wg-1.com
 <directory /home/httpd/www/magento8pm>
 AllowOverride all
 Order allow,deny
 Allow from all
 </directory>
 ErrorLog /var/log/httpd/error_log
 CustomLog /var/log/httpd/access_log common
</VirtualHost>
兩個網址都對應到同一個目錄
joe /var/www/html/magento8pm/.htaccess
RewriteEngine On
RewriteCond %{HTTP_HOST} ^www/.buck4u/.com$
RewriteRule ^(.*)$ dn1.html [L]
RewriteCond %{HTTP_HOST} ^mag/.wg-1/.com$
RewriteRule ^(.*)$ dn2.html [L]
dn1.html 改 www.buck4u.com 要對應的PHP網頁
dn2.html 改 mag.wg-1.com 要對應的PHP網頁, 或直接整個完整網址, 例 http://www.buck4u.com/magento8pm/stores/store/switch/___store/demo2