Changing info displayed on the calender

foolishkoala wrote on Wednesday, March 14, 2012:

Hello, I am looking to make some fairly simple modifications to the way the calender displays. Primarily, I would like to modify the information displayed by each appointment to include an additional field I have created for appointment reminders. If someone could point me in the right direction as to the location of the script that generates the appointment descriptions on the calender it would be greatly appreciated. Thank you.

mike-h30 wrote on Wednesday, March 14, 2012:

The file is:

/interface/main/calendar/modules/PostCalendar/pnuserapi.php

I modified the 2nd SQL statement in “function &postcalendar_userapi_pcQueryEvents($args)”

Change SQL
from: “concat(pd.lname,’, ‘,pd.fname) as patient_name, "
to: "concat(pd.lname,’, ',pd.fname, ’ ') as patient_name,”

My modification above displays the patient name with the “pubpid” (not always same as PID in my case) and the custom field (“genericname1”) on the calendar like so:

“White, Walter   (New Patient)”

You can add any fields that you like from the table patient_data  but “pubpid” and “genericname1” were my choice.

Hope that helps.

Mike

foolishkoala wrote on Wednesday, March 14, 2012:

Thank you very much, that’s exactly what I was looking for.