Difference between revisions of "learn:conferencecallvac"
From MGH Learn Pathology
(Created page with "<td style="width: 20%"> <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|4}}</center></td></tr></table>{{#cargo_query: tab...") |
|||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<td style="width: 20%"> | <td style="width: 20%"> | ||
| − | |||
| − | |||
| − | |||
<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 8: | Line 5: | ||
|join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | ||
| − | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference. | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH')|order by= scheduleCallConference.Sort ASC|default= |
| − | |format=template|template= | + | |format=template|template=scheduleResidentCall}} |
|7= | |7= | ||
{{#cargo_query: tables= scheduleCallConference,residentMGH | {{#cargo_query: tables= scheduleCallConference,residentMGH | ||
|join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | ||
| − | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference. | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH') AND NOT scheduleCallConference.ResAbbrev='-'|order by= scheduleCallConference.Sort ASC|default= |
| − | |format=template|template= | + | |format=template|template=scheduleResidentCall}} |
| | | | ||
{{#cargo_query: tables= scheduleCallConference,residentMGH | {{#cargo_query: tables= scheduleCallConference,residentMGH | ||
|join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
| − | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference. | + | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.TaskAbbrev,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf |
| − | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference. | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH')AND NOT scheduleCallConference.ResAbbrev='-'|order by= scheduleCallConference.Sort ASC|default= |
| − | |format=template|template= | + | |format=template|template=scheduleResidentCall}} |
}}</center> | }}</center> | ||
<br> | <br> | ||
| Line 28: | Line 25: | ||
{{#cargo_query: tables=scheduleRESservice,residentMGH | {{#cargo_query: tables=scheduleRESservice,residentMGH | ||
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
| − | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice. | + | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.TaskAbbrev,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= | + | |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=scheduleResident}} |
</td> | </td> | ||
Latest revision as of 13:57, August 4, 2026
