Realize the internationalization of mobile phone numbers based on Ronglian Cloud Communication and cloud chips in UCenter and ShopNC

1. Platform – Settings – Mail Settings – Message template, let the template content support traditional Chinese implementation (mail_msg_temlates: mail template Add template ID field (APP cloud communication SMS template): temp_id_app Add traditional fields (SMS traditional template content (cloud piece SMS template): content_zh_tw), as shown in Figure 1:

Add traditional fields (SMS traditional template content (cloud piece SMS template): content_en_tw

2. Added the function of the email template function, as shown in Figure 2;

Implementation of the function of adding email templates

3. Mail template data, as shown in Figure 3, 4, 5:
(1) Medical management pass mobile phone registration: 96255 (Hydratone communication) 93122 (APP)
[Namanage] You are registering a medical management account, the verification code {1}, please submit the verification code according to the page prompt within {2} minutes. Note: Cloud Communication SMS Template
[Namanty] You are registering a medical management account, the verification code #code#, please submit the verification code according to the page prompt within #minute# minutes. Note: Cloud piece SMS template

【{$site_name}】You are registering a medical account number, the verification code {$verify_code}, please submit the verification code according to the page prompt within {$minute} minutes. Note: The content of the template in the database
【{$site_name}】You are registering a medical account number, the verification code {$verify_code}, please submit the verification code according to the page prompt within {$minute} minutes. Note: The content of SMS traditional template in the database (cloud piece SMS template)

Figure 3: 96255 (Hydthene), cloud communication SMS template

Figure 4: (Hydthene), cloud piece SMS template

4. Platform – Settings – Region Settings, Editing Region, Editable International Regional Code Prefix (Area: Area Table Add Fields International Area Code Prefix: Area_Mobile), as shown in Figure 5:

Mainland China +86 0
Taiwan +886 32

Ali Cloud
ALTER TABLE `TRADE_AREA` add column `area_mobile` VARCHAR(5) Character set UTF8 COLLATE UTF8_GENERAL_CI NOT NULL commentInternational area code prefixafter `area_region`;

Editing area, editable international area code prefix (area: area table add field international area code prefix: area_mobile)

5. Trade.service.ygt.cm

http://trade.service.ygt.cm/area/get-area-mobile

http://trade.service.ygt.cm/area/get-area-mobile?area_id=32

6. Implement editable user mobile and area_id in ucenter, as shown in Figure 6:
(1) Add the international regional ID field in the user table: area_id, mobile and area_id are combined together with uniqueness
alter table `kcuc_members` add `area_id` int(11) unsigned not null default0commentCountry code IDafter `mobile`;
(2)http://kcuc.ygt.cm/Pass background, add and edit user mobile, support the selection of international region name and number prefix list
User Management – Add Users, Edit Users
(3) User management is arranged in reverse order based on user ID
(4) User management – search for users, support the selection of national area codes

Figure 6: Internationalization only supports mainland China and Taiwan for the time being

7. The user interface in the client of UCenter can display and edit the user’s mobile and area_id, as shown in Figure 7:
(1) Check the mobile address (UC_USER_CheckMobile)
(2) User registration (UC_USER_REGISTER), the mobile phone supports the selection of national area codes
(3) Get user data (UC_GET_USER)
(4) Update user information Based on user ID (UC_USER_UIDEdit), the mobile phone supports the selection of national area codes
(5) The API interface updates user information, and the mobile phone supports the national area code
(6) Business system – background – platform – member – member management – member management, new and edit members
alter table `trade_member` add `member_area_mobile` int(11) unsigned not null default0commentCountry code IDafter `member_email_bind`;
(7) Business system – background – mall – member – member management – new and edit members

Figure 7: The user interface in the client of UCenter can display and edit the user’s mobile and area_id

8. Mobile phone registration, the mobile phone supports the selection of national area codes
(1) Add the international regional ID field in the mobile phone SMS record table: log_area_mobile, log_area_mobile and log_phone are unique, as shown in Figure 8:
alter table `trade_sms_log` add `log_area_mobile` int(11) unsigned not null default0commentCountry code IDafter `log_id`;

Figure 8: Add international region ID fields to the mobile phone SMS record table

(2) Send SMS to support mainland China and Taiwan (based on cloud communication and cloud slices), as shown in Figure 9, 10, and 11:

Figure 9: Realize the command space and automatic loading of cloud slices, and call the service layer: get the national area code list

Figure 10: Selection of SMS sending service provider

Figure 11: Send template SMS, Ronglian Cloud; send a single SMS, cloud piece (smart matching)

(3) Realization of mobile phone registration, support internationalization

Figure 12: AJAX verification: whether it is an overseas mobile phone

Figure 13: Ajax verification: whether it is a Taiwanese mobile phone

Figure 14: Ajax verification: whether the phone has been registered

Figure 15: Ronglian Cloud SMS

Figure 16: SMS sent to Taiwan mobile phone number, traditional Chinese

9. The member list in the background of the shopnc, as shown in Figure 17:

Figure 17: Member list of shopnc background