WUI CHUN TONG is a clinic offering comprehensive Traditional Chinese Medicine (TCM) diagnosis, treatment, and wellness services. ROLLLL DESIGN assisted in planning and designing their website, with the core objective of integrating the professional trust associated with traditional TCM with the convenience of modern online services. We created an integrated platform combining "online booking, membership management, health e-commerce, and content promotion" to digitally enhance their service efficiency and customer experience.
Main Highlights
Integrated Online Booking System: This is a core function of the website. Patients can book multiple services in one place, including: 1. In-person clinic appointments. 2. Online video consultations for remote health advice. 3. Specific treatment bookings: direct scheduling for therapies like cupping, acupuncture, or medicinal moxibustion. This system centralizes all booking requests, allowing for unified backend management, which significantly streamlines the clinic's scheduling workflow.
Membership Center & CRM SYSTEM: The website features a comprehensive membership system. After registering and logging in, patients can centrally manage the following on their personal page: 1. Booking History: View all past and upcoming appointments. 2. Purchase Records: Check the history of orders for soup ingredients and other products purchased on the site. 3. Member Profile: Update personal contact information. This functionality helps the clinic collect client data for long-term health follow-up and relationship maintenance.
E-commerce Function: In addition to treatment services, the website directly incorporates a "Premium Soup Ingredient" showcase and sales channel, complete with a "Shopping Cart" and checkout functionality. This seamlessly integrates content promotion (e.g., TCM articles) with product sales, opening up new revenue streams.
Content Marketing & Customer Retention Platform: The "TCM Column" provides a space for publishing professional wellness articles, helping to establish authority. Simultaneously, the website incorporates a "Newsletter Subscription" feature, enabling regular distribution of the latest information and offers to potential and existing clients for effective customer nurturing and remarketing.
Result
The new website has successfully deeply digitized WUI CHUN TONG's physical services. The online booking system effectively offloads pressure from the clinic's phone inquiries and enhances scheduling efficiency. The membership system and e-commerce features extend the service scope and strengthen customer loyalty. The website has transformed from a one-way information display page into a comprehensive platform that drives business growth and improves management effectiveness.
Free Consultation
Get Free Consultation Now
Our professional team has rich technical experience and advanced development capabilities, and can tailor IT technical solutions for you according to your needs.
We will reply to you within one day
基本文件流程错误SQL调试
请求信息 : 2026-06-15 12:51:38 HTTP/2.0 GET : https://rolllldesign.com/en/portfolio/wuichuntong.html
SHOW FULL COLUMNS FROM `dlm_user` [ RunTime:0.001453s ]
SELECT * FROM `dlm_user` WHERE `status` = 1 AND `token` = 'NBMlfHqTZAOxhANpffdWUvmQI' LIMIT 1 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `dlm_site` [ RunTime:0.000930s ]
SELECT * FROM `dlm_site` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `dlm_nav` [ RunTime:0.000861s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `tpl` = 'wuichuntong' AND `catid` = -1 ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%wuichuntong.html%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000309s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%wuichuntong%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000271s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000295s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 14 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000261s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000212s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000246s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000225s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000208s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 27 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `dlm_article` [ RunTime:0.000794s ]
SELECT `id`,title_en as name,url_en as linkurl,`thumb_url`,thumb_alt_en as thumb_alt FROM `dlm_article` WHERE `status` = 1 ORDER BY `is_rec` DESC,`sort` ASC LIMIT 3 [ RunTime:0.000306s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 30 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000217s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000267s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 14 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000238s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000259s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000247s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000227s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000246s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 27 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000232s ]
SELECT `id`,title_en as name,url_en as linkurl,`thumb_url`,thumb_alt_en as thumb_alt FROM `dlm_article` WHERE `status` = 1 ORDER BY `is_rec` DESC,`sort` ASC LIMIT 3 [ RunTime:0.000310s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 30 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `dlm_weblink` [ RunTime:0.000724s ]
SELECT * FROM `dlm_weblink` ORDER BY `sort` ASC [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `dlm_ai_stats` [ RunTime:0.000653s ]
SHOW FULL COLUMNS FROM `dlm_goods` [ RunTime:0.000890s ]
SELECT g_result_en as result,g_cdate as create_time,b.thumb as cat_thumb,g_link as link,seo_title_en as seo_title,seo_keywords_en as seo_keywords,seo_description_en as seo_description,b.catname_en as catname_en,b.catname as catname_cn,`b`.`catid`,g_imgs as imgs,g_tag_en as tag,g_thumb as thumb,g_thumb_alt_en as thumb_alt,g_description_en as description,g_content_en as content,g_param as param,g_ad_en as ad,g_sub_en as sub,g_ids as ids,g_extra as extra,g_name_en as name FROM `dlm_goods` `a` LEFT JOIN `dlm_goods_cat` `b` ON `b`.`catid`=`a`.`g_cat2` WHERE `a`.`g_state` = '2' AND `a`.`g_seo_en` = 'wuichuntong' LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,name_en as name,`catid`,sub_en as sub,`thumb_url`,thumb_alt_en as thumb_alt,parent_id as parentid,`linkurl`,title_en as title,keywords_en as keywords,description_en as description FROM `dlm_nav` WHERE `tpl` = 'portfolio' AND `catid` = 1 ORDER BY `parent_id` ASC,`id` ASC LIMIT 1 [ RunTime:0.000260s ]
SHOW FULL COLUMNS FROM `dlm_web` [ RunTime:0.001313s ]
SELECT id as w_id,`page_code`,`mp4`,name_en as name,link_name_en as link_name,`link_url`,sub_en as sub,description_en as description,`k`,`image_url`,image_url_alt_en as image_url_alt,`tpl`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data1_image_url`,data1_image_alt_en as data1_image_alt,`data1_out_mp4`,`data1_type`,`data1_show`,`data2_image_url`,data2_image_alt_en as data2_image_alt,`data2_out_mp4`,`data2_type`,`data2_show`,`data3_image_url`,data3_image_alt_en as data3_image_alt,`data3_out_mp4`,`data3_type`,`data3_show`,`data4_image_url`,data4_image_alt_en as data4_image_alt,`data4_out_mp4`,`data4_type`,`data4_show`,`data5_image_url`,data5_image_alt_en as data5_image_alt,`data5_out_mp4`,`data5_type`,`data5_show`,`data6_image_url`,data6_image_alt_en as data6_image_alt,`data6_out_mp4`,`data6_type`,`data6_show`,`data7_image_url`,data7_image_alt_en as data7_image_alt,`data7_out_mp4`,`data7_type`,`data7_show`,`data8_image_url`,data8_image_alt_en as data8_image_alt,`data8_out_mp4`,`data8_type`,`data8_show`,`data9_image_url`,data9_image_alt_en as data9_image_alt,`data9_out_mp4`,`data9_type`,`data9_show`,`data10_image_url`,data10_image_alt_en as data10_image_alt,`data10_out_mp4`,`data10_type`,`data10_show`,`data11_image_url`,data11_image_alt_en as data11_image_alt,`data11_out_mp4`,`data11_type`,`data11_show`,`data12_image_url`,data12_image_alt_en as data12_image_alt,`data12_out_mp4`,`data12_type`,`data12_show`,`data13_image_url`,data13_image_alt_en as data13_image_alt,`data13_out_mp4`,`data13_type`,`data13_show`,`data14_image_url`,data14_image_alt_en as data14_image_alt,`data14_out_mp4`,`data14_type`,`data14_show` FROM `dlm_web` WHERE `catdir` = 'home' LIMIT 1 [ RunTime:0.000487s ]
