Difference between revisions of "learn:nextweekinap"

From MGH Learn Pathology
(Replaced content with "check back soon")
(Tag: Replaced)
Line 1: Line 1:
{{DISPLAYTITLE:Next Week in AP}}{{varScheduleYear}}{{varScheduleYearNW}}{{#css: @media { .container { width: 95% !important; } }}
+
check back soon
<br>
 
{{ColorText|'''Tweet of the week @MGHPathology'''||#018ab2|6|}}
 
<br>
 
<p><htmltag tagname="a" href="https://twitter.com/MGHPathology?ref_src=twsrc%5Etfw" class="twitter-follow-button" data-show-screen-name="true" data-show-count="true">Follow @MGHPathology</htmltag><htmltag tagname="script" async src="https://platform.twitter.com/widgets.js" charset="utf-8"></htmltag></p>
 
[[Image: IMG_9585.jpeg|500px]]
 
<br>
 
<table class='table borderless' style="width: 100%">
 
<tr>
 
<td colspan="3">
 
<br>
 
{{ColorText|'''Resident weekend call schedule'''||#018ab2|6|}}
 
</td>
 
<td colspan="1">
 
&nbsp;
 
</td>
 
<td colspan="8">
 
<br>
 
{{ColorText|'''Weekday call and conference schedule'''||#018ab2|6|}}
 
</td>
 
</tr>
 
<tr>
 
<td style="width: 11%">
 
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Friday}}' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=}}
 
<br>
 
{{#cargo_query: tables=scheduleCallConference,residentMGH
 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Outs','Thoracic')|default={{:schtableempty}}
 
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
<td style="width: 12%">
 
{{#vardefine:saturdayDate|{{#time: Y-m-d|{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1'|no html|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}}}}}{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
 
<br>
 
{{#cargo_query: tables=scheduleCallConference,residentMGH
 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
    |where=Date='{{#var:saturdayDate}}' AND NOT ResAbbrev='-'|default={{:schtableempty}}
 
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
<td style="width: 11%">
 
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
 
<br>
 
{{#cargo_query: tables=scheduleCallConference,residentMGH
 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
    |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND NOT ResAbbrev='-'|default={{:schtableempty}}
 
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
<td style="width: 2%">
 
&nbsp;
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|1|Monday}}
 
{{#cargo_query: tables= conferenceMPR,residentMGH |join on=conferenceMPR.ResAbbrev=residentMGH.copath_id |fields=conferenceMPR.ResAbbrev,conferenceMPR.Color,residentMGH.full_name,conferenceMPR.TaskAbbrev |where=YEAR(conferenceMPR.Date)='{{#timel: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#timel: W|now}} - 0 }}'|default= |format=template|template=schtableconfcallLeft}}
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|2|Tuesday}}
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|3|Wednesday}}
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|4|Thursday}}
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|5|Friday}}
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|6|Saturday}}
 
</td>
 
<td style="width: 9%">
 
{{scheduleNWinAPcall|7|Sunday}}
 
</td>
 
<td style="width: 1%">
 
&nbsp;
 
</td>
 
</tr>
 
<tr>
 
<tr>
 
<td colspan="12">
 
&nbsp;
 
</td>
 
</tr>
 
</table>
 
 
 
<br>
 
 
 
<table style="width: 100%">
 
<tr>
 
<td colspan="3">
 
<br>
 
{{ColorText|'''Faculty weekend call schedule'''||#018ab2|6|}}
 
</td>
 
<td colspan="1">
 
&nbsp;
 
</td>
 
<td colspan="8">
 
<br>
 
{{ColorText|'''Integrated service schedules'''||#018ab2|6|}}
 
</td>
 
</tr>
 
<tr>
 
<td style="width: 10%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table>
 
{{:scheduleDictionaryAP}}
 
</td>
 
<td style="width: 9%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}</center><br></td></tr></table>
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|}}
 
</td>
 
<td style="width: 9%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}</center><br></td></tr></table>
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|where=YEAR(Date)='2024' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|}}
 
</td>
 
</td>
 
<td style="width: 2%">
 
&nbsp;
 
</td>
 
<td style="width: 5%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table>
 
{{:scheduleDictionaryAP}}
 
</td>
 
<td style="width: 5%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Resident'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table>
 
{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleRESservice_view
 
|fields=
 
ResAbbrev,
 
TaskAbbrev,
 
FullName,
 
Pager
 
|group by=WeekNumber
 
|where=LocationAbbrev='MGH' AND Year='{{#var:MondayNW}}' AND WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
 
|}}
 
</td>
 
<td style="width: 5%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Fellow'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table>
 
{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid
 
|where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleFELLservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}}
 
|}}
 
</td>
 
<td style="width: 10%">
 
{{scheduleNWinAPservice|1|Monday}}
 
</td>
 
<td style="width: 10%">
 
{{scheduleNWinAPservice|2|Tuesday}}
 
</td>
 
<td style="width: 10%">
 
{{scheduleNWinAPservice|3|Wednesday}}
 
</td>
 
<td style="width: 10%">
 
{{scheduleNWinAPservice|4|Thursday}}
 
</td>
 
<td style="width: 10%">
 
{{scheduleNWinAPservice|5|Friday}}
 
</td>
 
</tr>
 
</table>
 

Revision as of 09:41, January 10, 2025

check back soon