追加功能 #501
Updated by Zhongbao Ye 2 months ago
*Background*
# 国内的AWS迁移到海外（新加坡），主要分3个Web资源。
## OTS3.0
## Easydingzhi
## Redmine
# 国内其他云服务（阿里云： 域名， DNS， SSL等）不在迁移计划内。
*Task Details*
* 1. OTS3.0
** 1.1 数据库数据迁移（主要是订单数据，产品+文件等除外）到OTS4.0
问题1：OTS3.0老订单数字5位，比如 EASY00001 - EASY99999，OTS4.0新订单数字6位，比如 EASY100001
问题2：OTS4.0新订单数字6位，既存数据需要保留嘛？如果保留可能需要统一【id + 100000】，否者删除即可。另外UI6位数字是否换行等，需要排查
** 1.2 具体数据迁移明细：
***
|_. No. |_. v4 fields |_. v3 fields |_. Note |
|\3=. *======================== v4.ots_order VS v3.t_order ========================*| |
| 1 | order_id | ca_index | |
| 2 | order_name | order_name | |
| 3 | urgency | urgency | |
| 4 | remake | remake | |
| 5 | is_retailer | is_retailer | |
| 6~8 | retailer_company_id
retailer_abbreviation_name
retailer_company_name | 1. v3.retailer_id 对应的 company_abbreviation = RBSH/LVOT RBSH
v4.retailer_company_id = 1
v4.retailer_abbreviation_name = 'RBSH'
v4.retailer_company_name = 'Redblue'
2. v3.retailer_id 对应的 company_abbreviation = EASY
v4.retailer_company_id = 2
v4.retailer_abbreviation_name = 'EASY'
v4.retailer_company_name = 'EASY Online Stores AB'
3. v3.retailer_id 对应的 company_abbreviation = ABLV
v4.retailer_company_id = 3
v4.retailer_abbreviation_name = 'ABLV'
v4.retailer_company_name = 'Aust banners'
4. v3.retailer_id 对应的 company_abbreviation = 其他内容，暂无对应关系 | |
| 9 | retailer_shipping_time | FROM_UNIXTIME(retailer_ship_time) | |
| 10~20 | retailer_shipping_address_id
retailer_shipping_country_id
retailer_shipping_zone_id
retailer_shipping_city
retailer_shipping_postcode
retailer_shipping_address_1
retailer_shipping_address_2
retailer_shipping_recipient_name
retailer_shipping_recipient_email
retailer_shipping_recipient_telephone
retailer_shipping_recipient_comment |1. v3.retailer_ship_to = 1 (STO Office):
v4.retailer_shipping_address_id = 151
v4.retailer_shipping_country_id = 203
v4.retailer_shipping_zone_id = 3088
v4.retailer_shipping_city = 'Stockholm'
v4.retailer_shipping_postcode = '113 50'
v4.retailer_shipping_address_1 = 'Sveavägen 83'
v4.retailer_shipping_address_2 =
v4.retailer_shipping_recipient_name = 'Ivar Hassler'
v4.retailer_shipping_recipient_email = 'logistics@easytryck.se'
v4.retailer_shipping_recipient_telephone = '08 - 12 00 11 28'
v4.retailer_shipping_recipient_comment = ''
2. v3.retailer_ship_to = 2 (Same Retailer):
v4.retailer_shipping_address_id = 0
v4.retailer_shipping_country_id = 0
v4.retailer_shipping_zone_id = 0
v4.retailer_shipping_city = ''
v4.retailer_shipping_postcode = ''
v4.retailer_shipping_address_1 = ''
v4.retailer_shipping_address_2 = ''
v4.retailer_shipping_recipient_name = ''
v4.retailer_shipping_recipient_email = ''
v4.retailer_shipping_recipient_telephone = ''
v4.retailer_shipping_recipient_comment = v3.retailer_ship_address
3. v3.retailer_ship_to = 3 (Customer):
同上（Same Retailer） | |
| 21 | customer_shipping_time | FROM_UNIXTIME(customer_ship_time) | |
| 22 | customer_shipping_service | CASE v3.customer_ship_to
WHEN 10 THEN 1
WHEN 11 THEN 10
WHEN 12 THEN 11
WHEN 13 THEN 12
WHEN 14 THEN 13
WHEN 15 THEN 14
WHEN 60 THEN 15
WHEN 70 THEN 16
WHEN 99 THEN '' | 99 在v3中表示‘Other’, v4中没有对应的字段，暂时不做映射。|
| 23 | customer_shipping_country_id |0 | |
| 24 |customer_shipping_zone_id |0 | |
| 25 |customer_shipping_city |'' | |
| 26 |customer_shipping_postcode |'' | |
| 27 |customer_shipping_address_1 |'' | |
| 28 |customer_shipping_address_2 |'' | |
| 29 |customer_shipping_recipient_name |'' | |
| 30 |customer_shipping_recipient_email |'' | |
| 31 |customer_shipping_recipient_telephone |'' | |
| 32 |customer_shipping_recipient_comment | customer_ship_address | |
| 33 | is_delete | is_delete | |
| 34 | create_customer_id | | 通过v3的o.retailer_id找v4中的用户，找不到设置为其领导 |
| 35 | update_customer_id | | 通过v3的o.update_user找v4中的用户，找不到设置为其领导 |
| 36 | date_added | FROM_UNIXTIME(create_time) | |
| 37 | date_modified | FROM_UNIXTIME(update_time) | |
|\3=. *======================== v4.ots_order_product VS v3.t_order_product ========================*| |
| 1 | order_product_id | id | |
| 2 | order_id | order_id | |
| 3 | product_id | 0 | |
| 4 | model | '' | |
| 5 | manufacturer_id | 0 | |
| 6 | manufacturer_name | '' | |
| 7 | manufacturer_origin | '' | |
| 8 | extra_info | extra_info ||
| 9 | quantity | quantity | |
| 10 | unit_price | 0 | |
| 11 | total | 0 | |
| 12 | weight | 0 | |
| 13 | weight_class_id | 0 | |
| 14 | tax_class_id | 0 | |
| 15 | status | status | |
| 16 | expected_finishing_time | FROM_UNIXTIME(expected_finishing_time) | |
| 17 | customer_shipper | CASE v3.customer_ship_type
WHEN 10 THEN 1
WHEN 11 THEN 10
WHEN 12 THEN 11
WHEN 13 THEN 12
WHEN 14 THEN 13
WHEN 15 THEN 14
WHEN 60 THEN 15
WHEN 70 THEN 16
WHEN 99 THEN '' | |
| 18 | customer_shipper_code | customer_ship_code | |
| 19 | brand | '' | |
| 20 | declaration_required | 0 | |
| 21 | declaration_unit_price | '' | |
| 22 | declaration_g_w_g | '' | |
| 23 | declaration_w_v | '' | |
| 24 | declaration_product_unit | '' | |
| 25 | declaration_cn_product_name | '' | |
| 26 | declaration_en_product_name | '' | |
| 27 | declaration_cn_hs_code | '' | |
| 28 | declaration_se_hs_code | '' | |
| 29 | declaration_base_info | 0 | |
| 30 | sales_info_incoterm | 0 | |
| 31 | sales_info_currency | 0 | |
| 32 | sales_info_real_unit_price | '' | |
| 33 | sales_info_declare_unit_price | '' | |
| 34 | manual_review | 0 | |
| 35 | manual_reviewed | 0 | |
| 36 | transferred | 0 | |
| 37 | key | '' | |
| 38 | legacy_info | | v4新增字段：v3产品与v4产品不兼容，使用一个字段：legacy_info，存json储序列化的 product信息,格式如下
{
"order_product_id":76482,
"order_id":47554,
"is_need_sample":0,
"company_abbreviation":"EASY",
"retailer_ship_type_name":"FedEx",
"retailer_ship_code":"771974168979",
"product_type":"Promotion products",
"product_name":"",
"product_color":"",
"product_size":"",
"product_material":"" {"order_product_id":21763,"order_id":10274,"company_abbreviation":"EASY",
} | "retailer_ship_type":"10","retailer_ship_code":"5813050272",
"product_type":"Softwall","product_name":"Straight","product_color":"","product_size":"Softwall 600","product_material":""}|
| 39 | is_delete | is_delete | |
| 40 | create_customer_id | | 通过v3的o.retailer_id找v4中的用户，找不到设置为其领导 v3找v4中的用户，找不到设置为其领导 |
| 41 | update_customer_id | | v3找v4中的用户，找不到设置为其领导 |
| 42 | date_added | FROM_UNIXTIME(create_time) | |
| 43 | date_modified | FROM_UNIXTIME(update_time) | |
|\3=. *======================== v4.ots_order_product_file VS v3.t_order_file ========================*| |
| 1 | order_product_file_id | id | |
| 2 | order_id | order_id | |
| 3 | order_product_id | order_product_id | |
| 4 | original_name | file_original_name | |
| 5 | save_path | file_save_path | |
| 6 | is_delete | is_delete | |
| 7 | create_customer_id | | v3找v4中的用户，找不到设置为其领导 |
| 8 | update_customer_id | | v3找v4中的用户，找不到设置为其领导 |
| 9 | date_added | FROM_UNIXTIME(create_time) | |
| 10 | date_modified | FROM_UNIXTIME(update_time) | |
** 1.2 SSL域名迁移
OTS3.0 = order3.easydingzhi.com (现域名：order.easydingzhi.com)
OTS4.0 = order.easydingzhi.com
** 1.3 OTS3.0备份 所有DB， Uploaded files数据全部迁移（1月内完成）
Uploaded files数据半年前的数据备份onedrive。
* 2. Easydingzhi
所有DB， 图片，Uploaded files数据全部迁移（1月内完成）
* 3. Redmine (IT团队使用)
所有DB， Uploaded files数据全部迁移（1月内完成）
* 4. 其他：等1-3全部完成，将全部关闭AWS China，并注销【网站备注】。
*v4 coding standard:*
# Git提交
#xxx(redmine number): xxx(redmine title) - xxx(任意：补充内容)
# 代码规范
2.1: 结构：Public -> Protected -> Private
2.2: 其他代码规范同SBX
# MVCL的v3/v4物理分割
3.1: v3/v4的代码分为两个文件，比如： order.php, order_v3.php
3.2: system也分为两个文件，暂时只有一个user_v3
- Note: front的$this->user在v4中会替换为$this->customer, 即v4中需要清除$this->user
3.3: 代码中，区分v3/v4的调用，比如：new User_V3
# 前台代码
twig, js, css (js, css尽量写在单独的css文件中)
# 后台代码
MVCL (L：en，cn)
# 注释
## 类名：
<pre>
/**
* xxx
*
* @copyright RedBlue-OTS 2024
* @version v4
*
*/
</pre>
## 函数名：参数类型 + 返回值类型
<pre>
/**
* xxx
*
* @param xxx $xxx
* @param xxx $xxx
* @return xxx
*/
</pre>
*Output*
* Report and Solution
*Others*