Clinic Faculty: Add “level” data field to and display accordingly from this table

Add “level” data field to Clinic Faculty table so that that data will be available to display on the Helath Center pages without referring to the Faculty table. The SQL statements of the Helath Center pages should not involve Faculty table. Practitioners WITHOUT “Professor / Instructor / …” Practitioners WITH “Professor / Instructor / …”

Clinic Faculty: Add “language” field to the table

The “language” field is needed to indicate which (or both) language pages to display on Health Center pages. Clinic Faculty table is now a complete, self-contained table for Health Center pages. “language” field used in Faculty table. “language” field used in Clinic Faculty table. “language” field Editing UI is ready.

Display frontend Health Center pages with photos from Clinic Faculty table

To decouple “Clinic Faculty” table from “Faculty” table, photos to be displayed on the frontend Health Center pages, from now on, should be retrieved from “photo” field in the “Clinic Faculty” table. Photos are stored under /portrait folder with naming convention as follows: cfxxx.png or cfxxx.png ( cf1.png, cf22.jpg, cf345.png) xxx: the facultyID from 1 … Read more

Fix: Faculty & Clinic Faculty display sorting order on last name + first name

For Faculty & Practitioners with the same last name, the sorting criteria should also apply to the first name. To get around the issue caused by the trilingual data fields, an extra step to create a temporary array for sorting purpose is implemented to resolve the issue. Clinic Practitioners – San Jose All Teaching Faculty … Read more