Difference between revisions of "Residents Room"
From MGH Learn Pathology
Line 19: | Line 19: | ||
|join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev | |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev | ||
− | |where=scheduleCallConference.WeekNumber='{{#expr: {{# | + | |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={{schedule-emptycell|fffff4|-}} |
|format=template|template=schtableconf}} | |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={{schedule-emptycell|fffff4|-}} | ||
+ | |group by=dziOrder.class_type| | ||
+ | |format=template|template=schtableconfOuts}} | ||
<br> | <br> | ||
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''CALL'''||#000000|}}</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''CALL'''||#000000|}}</center></td></tr></table> | ||
− | {{#switch: {{# | + | {{#switch: {{#timel: N|{{Timezone}}}}|6= |
{{#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=scheduleCallConference.WeekNumber='{{#expr: {{# | + | |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 DESC|default={{:schtableempty}} |
|format=template|template=schtableconf}} | |format=template|template=schtableconf}} | ||
|7= | |7= | ||
Line 33: | Line 36: | ||
|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= scheduleCallConference.WeekNumber='{{#expr: {{# | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='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 DESC|default={{:schtableempty}} |
|format=template|template=schtableconf}} | |format=template|template=schtableconf}} | ||
| | | | ||
Line 39: | Line 42: | ||
|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= scheduleCallConference.WeekNumber='{{#expr: {{# | + | |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 DESC|default={{:schtableempty}} |
|format=template|template=schtableconf}} | |format=template|template=schtableconf}} | ||
}} | }} | ||
Line 47: | Line 50: | ||
|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=scheduleRESservice.WeekNumber='{{#expr: {{# | + | |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={{schedule-emptycell|fffff4|-}}|format=template|template=schtable}} |
</td> | </td> | ||
<td style="width: 45%"> | <td style="width: 45%"> |
Revision as of 10:19, August 17, 2021
Today Today is Sunday, Jan 26 |
|
|
Jan 20 Jan 20 |
Jan 21 Jan 21 |
Jan 22 Jan 22 |
Jan 23 Jan 23 |
Jan 24 Jan 24 |
Jan 25 |
Jan 26 |
|||||||||||||||
|
|
|
|
|
|
|
|
|
Friday |
|
Jan 20Monday Jan 20 |
Jan 21Tuesday Jan 21 |
Jan 22Wednesday Jan 22 |
Jan 23Thursday Jan 23 |
Jan 24Friday Jan 24 |
Jan 25 |
Jan 26 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|