Status: Closed; Priority: N/A
Customize from existing Faculty – DTCM/MTCM page
No need to implement “Clinic Schedule” feature
Page layout: Check out the links below
- Faculty – Tablet | Mobile | Reference site (No Reference for popup windows)
New Page – Old Page- Clinic Practitioners – Tablet | Mobile (pop up window & “Show Clinic Schedule” button)
- Clinic Practitioners – Tablet | Mobile (pop up window & “Show Clinic Schedule” button is clicked)
Dropdown list place holder: Faculty / Practitioner List
Same list as defined in this task page
Faculty – DTCM/MTCM
When users click (select) any entry, direct users to the page linked above.
Pull data from the following database tables:
fbu_degree: optional
fbu_faculty
fbu_faculty_category
Shortcode from Old page
[display=”link”; cat1=”Doctorate and PhD”; cat2=”LOCAL TCM PRACTITIONERS”; disp_lang=”en”]
fbu_degree: optional
id = 2 or
degree LIKE ‘%Doctorate and PhD%’
fbu_faculty_category:
categoryid = 4 or
category = LOCAL TCM PRACTITIONERS
fbu_faculty:
display = ‘Y’
language LIKE ‘%en%’
Sort by Last name in Ascending order
Right after this page was first implemented, it was found that new page contained only 9 staff members, but the old page has 11.
By comparing old (341 recs) and new (339 recs) database table “fbu_faculty”, it was found two recs were missing in new site.
Meaning for some reason those two records were missing while converting database from old to new site.
Those two records were then added back on 9/15/2021.
So both tables now contain the same number of records.
And both new and old pages of “DAOM – US Faculty” show 11 staff members.
8 thoughts on “Faculty – DAOM – US Faculty”
Ready for development
Done.
The Inner Menu is not sticky
Hi,
https://nimb.ws/IfY8qa these 2 record was not available, now no more issue because I have imported both
This issue fixed https://nimb.ws/aPrnNc don’t worry
Fix staff member order
Unless otherwise specified, list always sort by Last name in Ascending order
The letter selection does not work.
When A (or other letter) is clicked, the selected staff members are not right.
Hi,
Fixed.
Current query is like that
SELECT * FROM fbu_faculty WHERE `lastname` LIKE ‘Z%’ AND categoryid=4 AND display = ‘Y’ AND language LIKE ‘%en%’ ORDER BY lastname ASC
Closed