|
|
| Line 1: |
Line 1: |
| | <td style="width: 20%"> | | <td style="width: 20%"> |
| − | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|4}}</center></td></tr></table>{{#cargo_query: tables=scheduleCallConference |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color, scheduleCallConference.Hour, scheduleCallConference.TaskAbbrev, scheduleCallConference.Sort, scheduleCallConference.Notes |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default= |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
| |
| − | {{#if:{{#cargo_query: tables=scheduleCallConference,residentMGH |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND scheduleCallConference.Type='Conference' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT TaskAbbrev='HP Journal Club' AND NOT TaskAbbrev='Outs'|default=|format=template|template=schtableconf}}|{{#cargo_query: tables=scheduleCallConference,residentMGH |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND scheduleCallConference.Type='Conference' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT TaskAbbrev='HP Journal Club' AND NOT TaskAbbrev='Outs'|default=|format=template|template=schtableconf}}| }}
| |
| − | <br>
| |
| | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Call - resident'''||#000000|4}}</center></td></tr></table> | | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Call - resident'''||#000000|4}}</center></td></tr></table> |
| | {{#switch: {{#timel: N|{{Timezone}}}}|6= | | {{#switch: {{#timel: N|{{Timezone}}}}|6= |
| Line 29: |
Line 26: |
| | |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)='{{#timel: Y|now}}' AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC' AND scheduleRESservice.Date > '2025-02-02'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=schtable}} | + | |where=scheduleRESservice.TaskAbbrev='VAC' AND scheduleRESservice.Date > '2026-08-02'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=schtable}} |
| | </td> | | </td> |
