Difference between revisions of "mgh:gi-calendar"

Revision as of 15:52, October 4, 2020

GI1, GI2, GI3, GI4

1. Attending 2. Fellow 3. Resident

@@ Line 1: / Line 1: @@
-{{schedule-monthly3|GI1|GI2|GI3}}
+<center>'''{{ColorText|GI1, GI2, GI3, GI4||#30705d|6|}}'''</center>
+{{:learn:schedule-monthlylegend}}
+{{#cargo_compound_query:
+|tables=scheduleFACservice
+;fields=CONCAT(TaskAbbrev,' ATT: ',StaffAbbrev)=name
+,StaffFullName=description
+,Date=Date
+;where=(TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI 4') 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='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI 4') AND NOT ResAbbrev IN ('0', '-', 'TBD');color=#1730b0;text color=#FFFFFF
+|tables=scheduleFELLservice,residentMGH
+;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id
+;fields=CONCAT(TaskAbbrev,' FELL: ',FellAbbrev)=name
+,full_name=description
+,Date=Date
+;where=TaskAbbrev IN ('GI1', 'GI2', 'GI3', 'GI4') AND NOT FellAbbrev IN ('0', '-', 'TBD');color=#000000;text color=#FFFFFF
+|format=calendar|}}