They “type” database field was added while setting up two new Faculty groups:“Honorable” and “Former” Faculty All existing facutly are considered “Active” faculty. To prevent “Honorable” and “Former” Faculty being retrieved as Active faculty, the existing Faculty group retrieval SQLs should include “type” as part of searching criteria. Update the following Faculty lists to include … Read more
Need to set up two Faculty groups pages on the frontend – Honorable Faculty and Former Faculty. A new data field has been added in the Faculty table. A new data field has been added in the Faculty table (fbu_faculty). Select Faculty from the table where1. “display” is set at “Y” and 2. “type” be … Read more
It was found that the existing backend IntraApps would wipe out new data fields that were added to make Clinic Faculty tablle self-contained to build frontend Health Center pages. The database updating method used by existing codes, being not knowing the newly added data fields, will update only existing data fields, and wipe out (set … Read more
To fix: No mixing in languages Display the corresponding part of the Bio on different language page. Fixed on Health Cener pages
Create a UI for setting Title (= level field in the Table) in the Clinic Faculty table. Added new Title – Adjunct Faculty Title (=level) Editing UI
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 / …”
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.
To further decouple “Faculty” and “Clinic Faculty” tables, the expand link used in current Health Center pages need to be replaced with Clinic Faculty ID instead of Faculty ID.
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
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