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
|
Dec 15 Dec 15 |
Dec 16 Dec 16 |
Dec 17 Dec 17 |
Dec 18 Dec 18 |
Dec 19 Dec 19 |
Dec 20 |
Dec 21 |
||||||||||||||
|
|
|
|
|
|
|
|
|
|
Friday |
|
Dec 15Monday Dec 15 |
Dec 16Tuesday Dec 16 |
Dec 17Wednesday Dec 17 |
Dec 18Thursday Dec 18 |
Dec 19Friday Dec 19 |
Dec 20 |
Dec 21 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||