Status: Closed; Priority: N/A
Added a new data field (ch_names) to hold combined Chinese names (Last name + First name) and sort on this new column by the stroke number of its Chinese names.
- Create a new data field (ch_names) in the Faculty table (fbu_faculty)
- Set up the Faculty table properly for Chinese character sorting
- Build the column content from existing last_name and first_name columns
- Implement the Chinese Faculty pages (listed below) with this new settings
Chinese Faculty pages:
- All Teaching Faculty:https://www.fivebranches.edu/?page_id=26004&lang=zh-hant
- DTCM/MTCM Faculty:https://www.fivebranches.edu/?page_id=27879&lang=zh-hant
- DTCM/DAc Bridge Faculty:https://www.fivebranches.edu/?page_id=27884&lang=zh-hant
- DAOM Faculty:https://www.fivebranches.edu/?page_id=26306&lang=zh-hant
- Clinic Practitioners – San Jose:https://www.fivebranches.edu/?page_id=27894&lang=zh-hant
- Clinic Practitioners – Santa Cruz:https://www.fivebranches.edu/?page_id=56074&lang=zh-hant
- Retired Faculty:https://www.fivebranches.edu/?page_id=27897&lang=zh-hant
3 thoughts on “Faculty: Sort Chinese name by stroke number”
Hello,
I have added the ch_names column and update that column using PHP script
some record had not chines name exist so right now its blank https://prnt.sc/25slv36
so you need to go database table and add the chines ‘ch_names’ https://prnt.sc/25sljiz
right now I have implemented only this page https://www.fivebranches.edu/?page_id=27879&lang=zh-hant please check and let me know order is correct or not, if correct then we will implement the method in other short-code too.
query is printed here https://prnt.sc/25slnku
following page sorting done with ch_names please check and let me know if any issue.
All Teaching Faculty:https://www.fivebranches.edu/?page_id=26004&lang=zh-hant
DTCM/MTCM Faculty:https://www.fivebranches.edu/?page_id=27879&lang=zh-hant
DTCM/DAc Bridge Faculty:https://www.fivebranches.edu/?page_id=27884&lang=zh-hant
DAOM Faculty:https://www.fivebranches.edu/?page_id=26306&lang=zh-hant
Retired Faculty:https://www.fivebranches.edu/?page_id=27897&lang=zh-hant
Closed