Difference between revisions of "Schedule"
From MGH Learn Pathology
| Line 62: | Line 62: | ||
<td style="width: 20%"> | <td style="width: 20%"> | ||
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|4}}</center></td></tr></table>{{#if:{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,dziOrder.collection_name,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y-m-d|now}}' AND scheduleCallConference.TaskAbbrev='Outs'|default=|group by=dziOrder.class_type|format=template|template=schtableconfOuts|limit=1|more results text=}}|{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,dziOrder.collection_name,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y-m-d|now}}' AND scheduleCallConference.TaskAbbrev='Outs'|default=|group by=dziOrder.class_type|format=template|template=schtableconfOuts|limit=1|more results text=}}|}} {{#vardefine:date|{{#cargo_query: tables= conferenceMPR|fields=Date|where=YEAR(conferenceMPR.Date)='{{#time: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#time: W|now}} - 1}}'|default= |format=template|template=text}}}} {{#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}}|<center>''No conferences today''</center>}} {{#ifeq:{{#time: Y-m-d|today}}|{{#var:date}}|{{#cargo_query: tables= conferenceMPR,residentMGH |join on=conferenceMPR.ResAbbrev=residentMGH.copath_id |fields=conferenceMPR.ResAbbrev,conferenceMPR.Color,residentMGH.full_name,conferenceMPR.TaskAbbrev |where=YEAR(conferenceMPR.Date)='{{#time: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#time: W|now}} - 1 }}'|default= |format=template|template=schtableconf}}|}} | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|4}}</center></td></tr></table>{{#if:{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,dziOrder.collection_name,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y-m-d|now}}' AND scheduleCallConference.TaskAbbrev='Outs'|default=|group by=dziOrder.class_type|format=template|template=schtableconfOuts|limit=1|more results text=}}|{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,dziOrder.collection_name,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y-m-d|now}}' AND scheduleCallConference.TaskAbbrev='Outs'|default=|group by=dziOrder.class_type|format=template|template=schtableconfOuts|limit=1|more results text=}}|}} {{#vardefine:date|{{#cargo_query: tables= conferenceMPR|fields=Date|where=YEAR(conferenceMPR.Date)='{{#time: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#time: W|now}} - 1}}'|default= |format=template|template=text}}}} {{#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}}|<center>''No conferences today''</center>}} {{#ifeq:{{#time: Y-m-d|today}}|{{#var:date}}|{{#cargo_query: tables= conferenceMPR,residentMGH |join on=conferenceMPR.ResAbbrev=residentMGH.copath_id |fields=conferenceMPR.ResAbbrev,conferenceMPR.Color,residentMGH.full_name,conferenceMPR.TaskAbbrev |where=YEAR(conferenceMPR.Date)='{{#time: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#time: W|now}} - 1 }}'|default= |format=template|template=schtableconf}}|}} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<br> | <br> | ||
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''On call - resident'''||#000000|4}}</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''On call - resident'''||#000000|4}}</center></td></tr></table> | ||
| Line 75: | Line 68: | ||
|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.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP'|order by= scheduleCallConference.Sort | + | |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='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP'|order by= scheduleCallConference.Sort ASC|default= |
|format=template|template=schtableconf}} | |format=template|template=schtableconf}} | ||
|7= | |7= | ||
| Line 81: | Line 74: | ||
|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.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort ASC|default= |
|format=template|template=schtableconf}} | |format=template|template=schtableconf}} | ||
| | | | ||
| Line 87: | Line 80: | ||
|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.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort | + | |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='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort ASC|default= |
|format=template|template=schtableconf}} | |format=template|template=schtableconf}} | ||
}}</center> | }}</center> | ||
| + | <br> | ||
| + | <p></p> | ||
| + | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Vacations'''||#000000|4}}</center></td></tr></table> | ||
| + | {{#cargo_query: tables=scheduleRESservice,residentMGH | ||
| + | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
| + | |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'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=schtable}} | ||
</td> | </td> | ||
<td style="width: 2%"> | <td style="width: 2%"> | ||