IntraApps: Fix clinic faculty update issue that wipe out new data fields

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

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.

Clinic Faculty: Access names directly from its table instead of from faculty table

To decouple the relation between “Faculty” (fbu_faculty)  and “Clinic Faculty” (fbu_clinic_faculty) tables, instead of retriving Names from mapped Faculty record (fbu_faculty), retrieve directly from Names of its own (fbu_clinic_faculty) table, to display on the frontend Health Center pages. If the name is not available, leave it blank. NOT to retrieve it from the corresponing record … Read more