Difference between revisions of "Schedule"

@@ Line 41: / Line 41: @@
 <td style="vertical-align: top;text-align:right;width: 68%">
 {{ColorText|'''{{#timel: F, M j, Y|now}}'''||#018ab2|6}}
+<br>
+<table style="width: 100%">
+<td style="width: 15%">
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''CONFERENCE'''||#000000|}}</center></td></tr></table>
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev
+    |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND scheduleCallConference.Type='Conference' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT TaskAbbrev='HP Journal Club' AND NOT TaskAbbrev='Outs'|default={{schedule-emptycell|fffff4|-}}
+    |format=template|template=schtableconf}}
+{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,scheduleCallConference.Notes,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y/m/d|}}' AND scheduleCallConference.Date='{{#timel: Y/m/d|}}' AND scheduleCallConference.TaskAbbrev='Outs'|default={{schedule-emptycell|fffff4|-}}
+|group by=dziOrder.class_type|
+    |format=template|template=schtableconfOuts}}
+<br>
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''CALL'''||#000000|}}</center></td></tr></table>
+{{#switch: {{#timel: N|{{Timezone}}}}|6=
+{{#cargo_query: tables= scheduleCallConference,residentMGH
+    |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
+    |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP'|order by= scheduleCallConference.Sort DESC|default={{:schtableempty}}
+    |format=template|template=schtableconf}}
+|7=
+{{#cargo_query: tables= scheduleCallConference,residentMGH
+    |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
+    |where=YEAR(Date)='{{#timel: Y|now}}' AND  scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='0' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort DESC|default={{:schtableempty}}
+    |format=template|template=schtableconf}}
+|
+{{#cargo_query: tables= scheduleCallConference,residentMGH
+    |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
+    |where=YEAR(Date)='{{#timel: Y|now}}' AND  scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort DESC|default={{:schtableempty}}
+    |format=template|template=schtableconf}}
+}}
+<br>
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''VACATIONS'''||#000000|}}</center></td></tr></table>
+{{#cargo_query: tables=scheduleRESservice,residentMGH
+|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
+|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
+|where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default={{schedule-emptycell|fffff4|-}}|format=template|template=schtable}}
+</td>
+<td style="width: 4%">
+&nbsp;
+</td>
+<td style="width: 10%">
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
+{{:schtablemobile2}}
+</td>
+<td style="width: 13%">
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
+{{#switch: {{#timel: N|{{Timezone}}}}
+|6
+|7=
+{{:schtablemobile6}}
+|{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GI4,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FS-S,CCECFF;FS-J,CCECFF;GR-S,B8A315;AP CHIEF,B39BE9;CP CHIEF,B39BE9;|;|TaskAbbreviation|
+{{#cargo_query: tables=scheduleRESservice,residentMGH
+|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
+|fields=
+GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev)
+,scheduleRESservice.Color
+,GROUP_CONCAT(DISTINCT residentMGH.full_name)
+,pageid
+|group by=scheduleRESservice.WeekNumber
+|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtableres}}
+|}}
+}}
+</td>
+<td style="width: 13%">
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fellow/Elective|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
+{{#switch: {{#timel: N|{{Timezone}}}}
+|6
+|7=
+{{:schtablemobile6}}
+|{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GI4,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FS-S,CCECFF;FS-J,CCECFF;|;|TaskAbbreviation|
+{{#cargo_query: tables=scheduleFELLservice,residentMGH
+|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
+|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name,residentMGH.pageid
+|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
+|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|template=schtableres}}
+|}}
+}}
+</td>
+<td style="width: 13%">
+{{#switch: {{#timel: N|{{Timezone}}}}
+|6
+|7=
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:On-Call ATT|On-Call Attending}}||#000000|}}'''
+</center></td></tr></table>
+|1
+|2
+|3
+|4
+|5=
+<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<ref>The faculty service schedule is displayed on this page using the QGenda API. To view the full schedule <htmltag tagname="a" href="https://app.qgenda.com/Link/view?linkKey=9a12a547-f1b4-4998-bdca-acf3204a120e&landingPageId=40221bd9-4ac1-4a0b-8a00-da4f05d88f2e" target="_blank">click here.</htmltag> <span class="glyphicon glyphicon-calendar" aria-hidden="true"></span></ref></center></td></tr></table>
+}}
+{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GI4,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FROZEN SECTION,CCECFF;FROZEN SECTION,CCECFF;|;|TaskAbbreviation|
+{{#cargo_query: table=scheduleFACservice
+|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
+|group by=scheduleFACservice.Color
+|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#timel:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
+|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
+|}}
+</td>
+</tr>
+</table>
 </td>
 </table>