Difference between revisions of "mgh:frozen-calendar"

Latest revision as of 07:23, July 31, 2024

Frozen Section

1. Attending 2. Fellow 3. Resident

@@ Line 1: / Line 1: @@
-{{schedule-monthly1|FS|}}
+<center>'''{{ColorText|Frozen Section||#30705d|6|}}'''</center>
+{{:learn:schedule-monthlylegend}}
+{{#cargo_compound_query:
+|tables=scheduleFACservice
+;fields=CONCAT(TaskAbbrev,' ATT: ',StaffAbbrev)=name
+,StaffFullName=description
+,Date=Date
+;where=TaskAbbrev='Frozen Section' AND NOT StaffAbbrev='OPEN';color=#d1d1d1;text color=#000000
+|tables=scheduleRESservice,residentMGH
+;join on= scheduleRESservice.ResAbbrev=residentMGH.copath_id
+;fields=CONCAT(TaskAbbrev,' RES: ',ResAbbrev)=name
+,full_name=description
+,Date=Date
+;where=TaskAbbrev='FSJ' AND NOT ResAbbrev IN ('0', '-', 'TBD');color=#1730b0;text color=#FFFFFF
+|tables=scheduleRESservice,residentMGH
+;join on= scheduleRESservice.ResAbbrev=residentMGH.copath_id
+;fields=CONCAT(TaskAbbrev,' RES: ',ResAbbrev)=name
+,full_name=description
+,Date=Date
+;where=TaskAbbrev='FSS' AND NOT ResAbbrev IN ('0', '-', 'TBD');color=#1730b0;text color=#FFFFFF
+|tables=scheduleCallConference, facultyMGH;join on=scheduleCallConference.ResAbbrev = facultyMGH._pageName;fields=CONCAT('一',scheduleCallConference.Hour,' ',scheduleCallConference.TaskAbbrev,': ',scheduleCallConference.Notes,' - ', scheduleCallConference.ResAbbrev)=name,facultyMGH.fullname=description,scheduleCallConference.Date=Date;where=TaskAbbrev='Outs' AND NOT ResAbbrev='-';color=#fff673;text color=black;where=scheduleCallConference.Notes='FS'
+|format=calendar|}}