Difference between revisions of "oneday"

From MGH Learn Pathology
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
βˆ’
{{#time: N |now}}
+
<center><div class=calendarbg>
βˆ’
 
+
{{#cargo_compound_query:
 +
tables=conference,residentMGH
 +
;join on=conference.presenter=residentMGH.copath_id
 +
;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date
 +
;where=conference='Call: Junior'
 +
;color=#e0ffef
 +
;text color=black
 +
|tables=conference,residentMGH
 +
;join on=conference.presenter=residentMGH.copath_id
 +
;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date
 +
;where=conference='Call: Autopsy'
 +
;color=#e0ffef
 +
;text color=black
 +
|tables=conference,residentMGH
 +
;join on=conference.presenter=residentMGH.copath_id
 +
;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date
 +
;where=conference='Call: Senior'
 +
;color=#f2e6ff
 +
;text color=black
 +
|tables=scheduleFood
 +
;fields=CONCAT('πŸ₯£ - ',presenter)=name,date=Date
 +
;color=#f5f5f5
 +
;text color=black
 +
|tables=conference,residentMGH
 +
;join on=conference.presenter=residentMGH.copath_id
 +
;fields=CONCAT('08:25 AM - ' ,conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date
 +
;where=conference='GPR'
 +
;color=#ffb973
 +
;text color=black
 +
|tables=conferenceOuts, facultyMGH;join on=conferenceOuts.StaffAbbrev = facultyMGH.copath_id;fields=CONCAT(conferenceOuts.time, ' - ', conferenceOuts.TaskAbbrev, ' - ', conferenceOuts.StaffAbbrev)=name,facultyMGH.name_last=description,conferenceOuts.date=Date;color=#fff673;text color=black
 +
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT('08:00 AM - ' ,conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='MPR';color=#7dc4ff;text color=black
 +
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Thoracic';color=#c2c2c2;text color=black
 +
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='RadPath';color=#66ff96;text color=black
 +
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Autopsy';color=#faff69;text color=black
 +
|format=calendar|view=day|height=165}}
 +
</div></center>
 +
<p>
 
<table class='table borderless'>
 
<table class='table borderless'>
 
<tr>
 
<tr>
βˆ’
<td colspan="1">
+
<td style="width: 6%">
βˆ’
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''S'''||#000000|}}</center></td></tr></table>
βˆ’
</td>
+
{{:schtablemobileoneday1}}
βˆ’
<td class='align-bottom' colspan="2">
 
βˆ’
<center><p>{{ColorText|Mon-Fri||#000000|}}</p></center>
 
βˆ’
</td>
 
βˆ’
<td class='align-bottom' colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
βˆ’
</td>
 
βˆ’
<td class='align-bottom' colspan="2">
 
βˆ’
<center><p>{{ColorText|Mon-Fri||#636363|}}</p></center>
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaynextweekfac}}
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaynextweekfac}}
 
βˆ’
</td>
 
βˆ’
</tr><tr>
 
βˆ’
<td style="width: 8%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''SERVICE'''||#000000|}}</center></td></tr></table>
 
βˆ’
{{:schtablemobile}}
 
 
</td>       
 
</td>       
βˆ’
<td style="width: 5%">
+
<td style="width: 9%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP,AP CHIEF,FS-S,FS-J,GR-S|,|TaskAbbreviation|
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA|,|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
Line 53: Line 52:
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 5%">
+
<td style="width: 9%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA|,|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
Line 62: Line 61:
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
<td style="width: 9%">
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''<ref>The faculty service schedule is displayed on this page using the QGenda API. To view the full schedule <htmltag tagname="a" href="https://app.qgenda.com/Link/view?linkKey=9a12a547-f1b4-4998-bdca-acf3204a120e&landingPageId=40221bd9-4ac1-4a0b-8a00-da4f05d88f2e" target="_blank">click here.</htmltag> <span class="glyphicon glyphicon-calendar" aria-hidden="true"></span></ref></center></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA|,|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice  
 
{{#cargo_query: table=scheduleFACservice  
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
 
|default={{:schtableempty}}|format=template|template=schtable}}
 
|default={{:schtableempty}}|format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
+
<td style="width: 7%">
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''S'''||#000000|}}</center></td></tr></table>
βˆ’
{{#cargo_query: table=scheduleFACservice
+
{{:schtablemobileoneday2}}
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
+
</td>     
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
<td style="width: 9%">
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table>
 +
{{#arraymap: DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL|,|TaskAbbreviation|
 +
{{#cargo_query: tables=scheduleRESservice,residentMGH
 +
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 +
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
 +
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
<td style="width: 9%">
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL|,|TaskAbbreviation|
βˆ’
{{#cargo_query: table=scheduleFACservice
+
{{#cargo_query: tables=scheduleFELLservice,residentMGH
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
+
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
+
|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
<td style="width: 9%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL|,|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice  
 
{{#cargo_query: table=scheduleFACservice  
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
 
|default={{:schtableempty}}|format=template|template=schtable}}
 
|default={{:schtableempty}}|format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
+
 
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
<td style="width: 6%">
βˆ’
{{#cargo_query: table=scheduleFACservice
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''S'''||#000000|}}</center></td></tr></table>
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
+
{{:schtablemobileoneday3}}
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
</td>     
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
+
<td style="width: 9%">
 +
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table>
 +
{{#arraymap: GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 +
{{#cargo_query: tables=scheduleRESservice,residentMGH
 +
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 +
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
 +
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
<td style="width: 9%">
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
βˆ’
{{#cargo_query: table=scheduleFACservice
+
{{#cargo_query: tables=scheduleFELLservice,residentMGH
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
+
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
+
|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 8%">
+
<td style="width: 9%">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice  
 
{{#cargo_query: table=scheduleFACservice  
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
 
|default={{:schtableempty}}|format=template|template=schtable}}
 
|default={{:schtableempty}}|format=template|template=schtable}}
 
|}}
 
|}}
 
</td>
 
</td>
βˆ’
<td style="width: 5%">
+
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#636363|}}'''</center></td></tr></table>
 
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP,AP CHIEF,FS-S,FS-J,GR-S|,|TaskAbbreviation|
 
βˆ’
{{#cargo_query: tables=scheduleRESservicenextweek,residentMGH
 
βˆ’
|join on=scheduleRESservicenextweek.ResAbbrev=residentMGH.copath_id
 
βˆ’
|fields=scheduleRESservicenextweek.ResAbbrev,scheduleRESservicenextweek.Color,residentMGH.full_name
 
βˆ’
|where=scheduleRESservicenextweek.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleRESservicenextweek.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtablenextweek}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 5%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#636363|}}'''</center></td></tr></table>
 
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 
βˆ’
{{#cargo_query: tables=scheduleFELLservicenextweek,residentMGH
 
βˆ’
|join on=scheduleFELLservicenextweek.FellAbbrev=residentMGH.copath_id
 
βˆ’
|fields=scheduleFELLservicenextweek.FellAbbrev,scheduleFELLservicenextweek.Color,residentMGH.full_name
 
βˆ’
|where=scheduleFELLservicenextweek.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFELLservicenextweek.TaskAbbrev='TaskAbbreviation' |format=template|template=schtablenextweek}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 8%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#636363|}}'''</center></td></tr></table>
 
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtablenextweek}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 8%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#636363|}}'''</center></td></tr></table>
 
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtablenextweek}}
 
βˆ’
|}}
 
βˆ’
</td>
 
 
</tr>
 
</tr>
 
</table>
 
</table>
 +
</p>

Latest revision as of 22:01, August 30, 2019