Difference between revisions of "learn:nextweekinap"
From MGH Learn Pathology
| (194 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{DISPLAYTITLE:Next Week in AP}} | + | {{DISPLAYTITLE:Next Week in AP}}{{varScheduleYear}}{{varScheduleYearNW}}{{#css: @media { .container { width: 95% !important; } }} |
| − | + | <br> | |
| − | <table class='table borderless'> | + | <table class='table borderless' style="width: 100%"> |
| + | <tr> | ||
| + | <td colspan="3"> | ||
| + | <br> | ||
| + | {{ColorText|'''Resident weekend call schedule'''||#018ab2|6|}} | ||
| + | </td> | ||
| + | <td colspan="1"> | ||
| + | | ||
| + | </td> | ||
| + | <td colspan="8"> | ||
| + | <br> | ||
| + | {{ColorText|'''Weekday call and conference schedule'''||#018ab2|6|}} | ||
| + | </td> | ||
| + | </tr> | ||
<tr> | <tr> | ||
| − | <td style="width: | + | <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 | {{#cargo_query: tables=scheduleCallConference,residentMGH | ||
|join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | ||
| − | |where=YEAR(Date)={{# | + | |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}} | |format=template|order by = sort ASC|template=schtableconfcallLeft}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <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 | {{#cargo_query: tables=scheduleCallConference,residentMGH | ||
|join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | ||
| − | |where= | + | |where=Date='{{#var:saturdayDate}}' AND NOT ResAbbrev='-'|default={{:schtableempty}} |
|format=template|order by = sort ASC|template=schtableconfcallLeft}} | |format=template|order by = sort ASC|template=schtableconfcallLeft}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <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 | {{#cargo_query: tables=scheduleCallConference,residentMGH | ||
|join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | ||
| − | |where=YEAR(Date)={{# | + | |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}} | |format=template|order by = sort ASC|template=schtableconfcallLeft}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 2%"> |
| | ||
</td> | </td> | ||
<td style="width: 9%"> | <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}} | |
| − | {{#cargo_query: tables= | ||
| − | |||
| − | |||
| − | |||
| − | |||
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | {{ | + | {{scheduleNWinAPcall|2|Tuesday}} |
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | {{ | + | {{scheduleNWinAPcall|3|Wednesday}} |
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | {{ | + | {{scheduleNWinAPcall|4|Thursday}} |
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | {{ | + | {{scheduleNWinAPcall|5|Friday}} |
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | {{ | + | {{scheduleNWinAPcall|6|Saturday}} |
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | {{ | + | {{scheduleNWinAPcall|7|Sunday}} |
| + | </td> | ||
| + | <td style="width: 1%"> | ||
| + | | ||
| + | </td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <tr> | ||
| + | <td colspan="12"> | ||
| + | | ||
| + | </td> | ||
| + | </tr> | ||
| + | </table> | ||
| + | |||
| + | <br> | ||
| + | |||
| + | <table style="width: 100%"> | ||
| + | <tr> | ||
| + | <td colspan="3"> | ||
| + | <br> | ||
| + | {{ColorText|'''Faculty weekend call schedule'''||#018ab2|6|}} | ||
| + | </td> | ||
| + | <td colspan="1"> | ||
| + | | ||
| + | </td> | ||
| + | <td colspan="8"> | ||
| + | <br> | ||
| + | {{ColorText|'''Integrated service schedules'''||#018ab2|6|}} | ||
</td> | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td style="width: | + | <td style="width: 10%"> |
| − | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}<br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table> | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table> |
| − | {{: | + | {{:scheduleDictionaryAP}} |
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{# | + | <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: | + | {{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation| |
| − | {{#cargo_query: table=scheduleFACservice | + | {{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id |
| − | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice. | + | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid |
|group by=scheduleFACservice.Color | |group by=scheduleFACservice.Color | ||
| − | |where= | + | |where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |
| − | |default={{schtableempty|{{#explode:TaskAbbreviation|,| | + | |default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}} |
|}} | |}} | ||
</td> | </td> | ||
<td style="width: 9%"> | <td style="width: 9%"> | ||
| − | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{# | + | <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: | + | {{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation| |
| − | {{#cargo_query: table=scheduleFACservice | + | {{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id |
| − | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice. | + | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid |
|group by=scheduleFACservice.Color | |group by=scheduleFACservice.Color | ||
| − | |where=YEAR(Date)= | + | |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|,| | + | |default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}} |
|}} | |}} | ||
</td> | </td> | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 2%"> |
| | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 5%"> |
| − | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}<br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table> | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table> |
| − | {{: | + | {{:scheduleDictionaryAP}} |
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 5%"> |
| − | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Resident'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table> |
| − | {{#arraymap: | + | {{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation| |
| − | {{#cargo_query: | + | {{#cargo_query: tables=scheduleRESservice_view |
| − | |fields= | + | |fields= |
| − | |group by= | + | ResAbbrev, |
| − | |where= | + | TaskAbbrev, |
| − | |default={{schtableempty|{{#explode:TaskAbbreviation|,| | + | 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> | ||
| − | <td style="width: | + | <td style="width: 5%"> |
| − | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Fellow'''||#000000|}}<br><br>{{ColorText|'''Service'''||#FFFFFF|}}</center></td></tr></table> |
| − | {{#arraymap: | + | {{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation| |
| − | {{#cargo_query: | + | {{#cargo_query: tables=scheduleFELLservice,residentMGH |
| − | |fields= | + | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id |
| − | + | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid | |
| − | |where=YEAR(Date)={{# | + | |where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleFELLservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template |
| − | |default={{schtableempty|{{#explode:TaskAbbreviation|,| | + | |group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}} |
|}} | |}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 10%"> |
| − | + | {{scheduleNWinAPservice|1|Monday}} | |
| − | {{ | + | </td> |
| − | + | <td style="width: 10%"> | |
| − | + | {{scheduleNWinAPservice|2|Tuesday}} | |
| − | |||
| − | |||
| − | |||
| − | |}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 10%"> |
| − | + | {{scheduleNWinAPservice|3|Wednesday}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 10%"> |
| − | + | {{scheduleNWinAPservice|4|Thursday}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |}} | ||
</td> | </td> | ||
| − | <td style="width: | + | <td style="width: 10%"> |
| − | + | {{scheduleNWinAPservice|5|Friday}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |}} | ||
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
Latest revision as of 09:43, January 10, 2025
|
|
|
|
|||||||||||||||||||||||||||||
|
Jan 31
|
Feb 01
|
Feb 02
|
|
Feb 03
|
Feb 04
|
Feb 05
|
Feb 06
|
Feb 07
|
Feb 08
|
Feb 09
|
|
||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||
