Tasks assigned to or require input from
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
To fix: When a new Clinic faculty was added to the table, when his/her photo was not available, it was found that program does not display default Unknown photo, instead it display the photo of previous faculty. If photo is not available, it should display the default “Unknown” image.
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
After restricting users to only those who signed up with FBU email account, the login process behave different from regular WordPress login processes. Set up menu option such that Show “Log In” option if a user has not logged. And hide that option once logged in. Hide “Log Out” option befor a user logging in. … Read more
Display Practitioners on both locations San Jose and Santa Cruz both Languages: English and Chinese Only if the Practitioner’s “Active” field in the Clinic Faculty table is set to “Yes”. Ignore the “Suspend” field setting in its corresponding record in Faculty table. Clinic Faculty table Faculty Table Test case: Chen Ping (Joanna) Chao: Faculty ID: … Read more
Currently the Date format is: Day Month, Year It should be: Month Day, Year Just switch the position (or order) of current Day and Month.