Difference between revisions of "learn:schedule-nextweek"
From MGH Learn Pathology
| 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)={{# | + | |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)={{# | + | |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)={{# | + | |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> | ||
Revision as of 15:45, December 28, 2020
|
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 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
