Difference between revisions of "Schedule"
From MGH Learn Pathology
| Line 47: | Line 47: | ||
<td style="width: 25%"> | <td style="width: 25%"> | ||
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conference'''||#000000|}}</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conference'''||#000000|}}</center></td></tr></table> | ||
| − | {{#cargo_query: tables= conferenceMPR,residentMGH | + | {{#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)='{{#timel: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#timel: W|now}} - 0 }}' AND conferenceMPR.DayNumber='{{#expr: {{#timel: N|now}} - 1 }}'|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=''No scheduled conferences'' |format=template|template=schtableconf}} | |
| − | + | {{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,scheduleCallConference.Notes,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y/m/d|}}' AND scheduleCallConference.Date='{{#timel: Y/m/d|}}' AND scheduleCallConference.TaskAbbrev='Outs'|default= |group by=dziOrder.class_type| |format=template|template=schtableconfOuts}} | |
| − | |||
| − | |||
| − | {{#cargo_query: tables=scheduleCallConference,residentMGH | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | {{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,scheduleCallConference.Notes,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y/m/d|}}' AND scheduleCallConference.Date='{{#timel: Y/m/d|}}' AND scheduleCallConference.TaskAbbrev='Outs'|default= | ||
| − | |group by=dziOrder.class_type| | ||
| − | |||
<br> | <br> | ||
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Call'''||#000000|}}</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Call'''||#000000|}}</center></td></tr></table> | ||
| Line 86: | Line 76: | ||
|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'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default= | + | |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=''No scheduled vacations''|format=template|template=schtable}} |
</td> | </td> | ||
<td style="width: 10%"> | <td style="width: 10%"> | ||
Revision as of 23:18, August 19, 2021
|
Welcome!
Hello, ! |
|
August, Aug 4, 2026
|
Hello, !
Today is Tuesday, Aug 4
Day number 215 of 2026!
Quick links
|
|
|
|
|
- ↑ The faculty service schedule is displayed on this page using the QGenda API. To view the full schedule click here.
