In openemr database Table ‘openemr_postcalendar_events’ store appointment details .
For a single appointment, we can able to see data is there in the column ‘Pc_eventDate’.
But for recurrence appointment it stores data in column ‘pc_recurrtype’,‘pc_recurrspec’ and ‘pc_recurrfreq’.
column pc_recurrfreq its store some json like format given below
1.on recurrence Mon/Tue/wed/Thurs/friday/saturday:
a:6:{s:17:“event_repeat_freq”;s:11:“2,3,4,5,6,7”;s:22:“event_repeat_freq_type”;s:1:“6”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;s:6:“exdate”;s:0:"";}
2. on recurrence each day form select dropdown:
a:6:{s:17:“event_repeat_freq”;s:1:“1”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;s:6:“exdate”;s:0:"";}
can anyone tell exactly how this recurrence data can fetch from the query .
also refer some git openemr code for the same module, but didn’t able to figure it out.
Thanks in advanced.