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; } }} | |
| + | <br> | ||
| + | <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> | ||
| + | <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%"> | ||
| + | | ||
| + | </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%"> | ||
| + | | ||
| + | </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> | ||
| + | </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%"> | ||
| + | | ||
| + | </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 10:43, January 10, 2025
|
|
|
|
|||||||||||||||
|
Jun 12
|
Jun 13
|
Jun 14
|
|
Jun 16
|
Jun 17
|
Jun 18
|
Jun 19
|
Jun 20
|
Jun 21
|
Jun 22
|
|
||||||
|
|
|||||||||||||||||
