--- 20200211
=========================================================================================================================
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
=========================================================================================================================

增加新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-enabled
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(全站用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

設定首頁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
(20200208 不用改)
->改首頁Theme:
Custom Design Update->New Theme->Venustheme - 8pm(只有首頁用8pm)

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

目錄頁設定:
Theme->Magento Blank
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

//--- 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背景圖:bg_brc.jpg
menu背景圖:
Add class “menu-bg” to insert background in dropdown, change background in the path: app/design/frontend/Venustheme/8pm/web/images/menu-bg.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
=========================================================================================================================
Marketing->Cart Price Rule->滿$50包郵->Conditions
->Subtotal  equals or greater than  50

借用屬性 Eco Collect 成為 Free Shipping(false:可以排除不包郵的item)
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
=========================================================================================================================

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
=========================================================================================================================

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)

/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