Difference between revisions of "testserviceschedule"

From MGH Learn Pathology
(Replaced content with "Cytoloy {{#css: .fc-unthemed td.fc-today { background: #baffdd; } }} {{#cargo_compound_query: |tables=scheduleFACservice ;fields=CONCAT('πŸ”˜ ',TaskAbbrev)=name ,Date=Dat...")
(Tag: Replaced)
Line 1: Line 1:
βˆ’
<table class='table borderless'>
+
Cytoloy
βˆ’
<tr>
 
βˆ’
<td colspan="1">
 
βˆ’
&nbsp;
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
&nbsp;
 
βˆ’
</td>
 
βˆ’
<td colspan="2">
 
βˆ’
<center>'''Monday to<br>Friday'''</center>
 
βˆ’
<td colspan="1">
 
βˆ’
&nbsp;
 
βˆ’
</td>
 
βˆ’
<td class='align-bottom' colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
<td class='align-bottom' colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
<td class='align-bottom' colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
<td class='align-bottom' colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
<td colspan="1">
 
βˆ’
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
βˆ’
</td>
 
βˆ’
</tr>
 
βˆ’
<tr>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
 
βˆ’
{{:schtablemobile}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 5%">
 
βˆ’
&nbsp;
 
βˆ’
</td>     
 
βˆ’
<td style="width: 10%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
 
βˆ’
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FZ,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP,AP CHIEF,FZ-S,FZ-J,GR-S|,|TaskAbbreviation|
 
βˆ’
{{#cargo_query: tables=scheduleRESservice,residentMGH
 
βˆ’
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
βˆ’
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name,residentMGH.pageid
 
βˆ’
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtableres}}
 
βˆ’
|}}
 
βˆ’
<br>
 
βˆ’
{{#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|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtableres}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-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,FZ-S,FZ-J|,|TaskAbbreviation|
 
βˆ’
{{#cargo_query: tables=scheduleFELLservice,residentMGH
 
βˆ’
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
βˆ’
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name
 
βˆ’
|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 5%">
 
βˆ’
&nbsp;
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#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|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#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|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
<td style="width: 10%">
 
βˆ’
<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|
 
βˆ’
{{#cargo_query: table=scheduleFACservice
 
βˆ’
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 
βˆ’
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0}}'
 
βˆ’
|default={{:schtableempty}}|format=template|template=schtable}}
 
βˆ’
|}}
 
βˆ’
</td>
 
βˆ’
</tr>
 
βˆ’
</table>
 
βˆ’
 
 
βˆ’
<hr>
 
βˆ’
 
 
 
{{#css: .fc-unthemed td.fc-today { background: #baffdd; } }}
 
{{#css: .fc-unthemed td.fc-today { background: #baffdd; } }}
 
{{#cargo_compound_query:
 
{{#cargo_compound_query:
Line 141: Line 5:
 
;fields=CONCAT('πŸ”˜ ',TaskAbbrev)=name
 
;fields=CONCAT('πŸ”˜ ',TaskAbbrev)=name
 
,Date=Date
 
,Date=Date
βˆ’
;where=StaffAbbrev='GUN';color=#c4acfa;text color=black
+
;where=TaskAbbrev='CA' AND TaskAbbrev='CB' AND TaskAbbrev='CC';color=#c4acfa;text color=black
 
|tables=scheduleRFAview
 
|tables=scheduleRFAview
 
;fields=CONCAT('Resident: ',ResAbbrev)=name
 
;fields=CONCAT('Resident: ',ResAbbrev)=name
 
,Date=Date
 
,Date=Date
βˆ’
;where=StaffAbbrev='GUN' AND NOT ResAbbrev='0' AND NOT ResAbbrev='-';color=#fff88f;text color=black
+
;where=TaskAbbrev='CA' AND TaskAbbrev='CB' AND TaskAbbrev='CC' AND NOT ResAbbrev='0' AND NOT ResAbbrev='-';color=#fff88f;text color=black
 
|tables=scheduleRFAview
 
|tables=scheduleRFAview
 
;fields=CONCAT('Fellow: ',FellAbbrev)=name
 
;fields=CONCAT('Fellow: ',FellAbbrev)=name
 
,Date=Date
 
,Date=Date
βˆ’
;where=StaffAbbrev='GUN' AND NOT FellAbbrev='0' AND NOT FellAbbrev='-';color=#99b1ff;text color=black
+
;where=TaskAbbrev='CA' AND TaskAbbrev='CB' AND TaskAbbrev='CC' AND NOT FellAbbrev='0' AND NOT FellAbbrev='-';color=#99b1ff;text color=black
 
|format=calendar|height=500}}
 
|format=calendar|height=500}}

Revision as of 08:22, October 10, 2019

Cytoloy

Error: Table scheduleRFAview not found.