Difference between revisions of "learn:schedule-nextweek"
From MGH Learn Pathology
Line 1: | Line 1: | ||
− | {{varScheduleYearNW}}{{DISPLAYTITLE:Next Week (Week {{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}} of {{#var:MondayNW}})}} | + | {{varScheduleYearNW}}{{DISPLAYTITLE:Next Week (Week {{formatnum:{{#expr:{{#timel: W|now +1 week}}}}}} of {{#var:MondayNW}})}} |
<center>{{#css: a.glyphicon.glyphicon-arrow-left { font-size: 1.7em; } }}{{#tag: htmltag||tagname="a"|href="https://learn.mghpathology.org/index.php/learn:schedule-currentweek"|class="glyphicon glyphicon-arrow-left" }} </center> | <center>{{#css: a.glyphicon.glyphicon-arrow-left { font-size: 1.7em; } }}{{#tag: htmltag||tagname="a"|href="https://learn.mghpathology.org/index.php/learn:schedule-currentweek"|class="glyphicon glyphicon-arrow-left" }} </center> | ||
Line 106: | Line 106: | ||
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),scheduleRESservice.Color,GROUP_CONCAT(DISTINCT residentMGH.full_name) | |fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),scheduleRESservice.Color,GROUP_CONCAT(DISTINCT residentMGH.full_name) | ||
|group by=scheduleRESservice.WeekNumber | |group by=scheduleRESservice.WeekNumber | ||
− | |where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleRESservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtableres}} | + | |where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleRESservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now +1 week}}}}}}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtableres}} |
|}} | |}} | ||
<br> | <br> | ||
Line 114: | Line 114: | ||
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name | ||
− | |where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleRESservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|format=template|template=schtable}} | + | |where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleRESservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now +1 week}}}}}}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|format=template|template=schtable}} |
</td> | </td> | ||
<td style="width: 10%"> | <td style="width: 10%"> | ||
Line 122: | Line 122: | ||
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ||
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name,residentMGH.pageid | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,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|,|1}}}}|template=schtableres}} | + | |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|,|1}}}}|template=schtableres}} |
|}} | |}} | ||
</td> | </td> |
Latest revision as of 22:01, March 11, 2021
Jan 20 Jan 20 |
Jan 21 Jan 21 |
Jan 22 Jan 22 |
Jan 23 Jan 23 |
Jan 24 Jan 24 |
Jan 25 |
Jan 26 |
|||||||||||||||
|
|
|
|
|
|
|
|
|
Friday |
|
Jan 20Monday Jan 20 |
Jan 21Tuesday Jan 21 |
Jan 22Wednesday Jan 22 |
Jan 23Thursday Jan 23 |
Jan 24Friday Jan 24 |
Jan 25 |
Jan 26 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|