Difference between revisions of "learn:oncallAMP"

Latest revision as of 09:10, November 6, 2021

-

@@ Line 1: / Line 1: @@
-{{#vardefine:GIattending|{{#cargo_query:table=scheduleFACservice|fields=StaffAbbrev|where=YEAR(Date)={{#timel: Y|now }} AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|now }} - 0}}' AND scheduleFACservice.DayNumber='7' AND TaskAbbrev='GI1'|format=template|template=text|no html}}}}
+{{onCallAMP}}
-{{#vardefine:GIservice|{{#cargo_query:table=scheduleFACservice|fields=TaskAbbrev|where=YEAR(Date)={{#timel: Y|now }} AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|now }} - 0}}' AND scheduleFACservice.DayNumber='7' AND StaffAbbrev='{{#var:GIattending}}'|format=template|template=text|no html}}}}
-{{#var:GIservice}}
-{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
-|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
-|group by=scheduleFACservice.Color
-|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
-|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}}
-{{#arraymap:
-AUT,Autopsy,859ca0,AUT; BSTalt,Bone and Soft Tissue,c9d8e7,BST; BR1,Breast,ff9a86,BR; BR1,Breast,ff9a86,BR; CV,Cardiovascular,6cad90,CV; RP,Renal,6cad90,RP; CB,Cytology,94c9da,CYT; CB,Cytology,94c9da,CYT; CB,Cytology,94c9da,CYT;
- DPA,Dermatopathology,f8d9e9,DP; DPB,Dermatopathology,f8d9e9,DP; DPB,Dermatopathology,f8d9e9,DP; EYE,Eye,fffbf0,EYE; Frozen Section,Frozen Section,c2e7df,FS;  Frozen Section,Frozen Section,c2e7df,FS; GI1,Gastrointestinal,ffd966,GI; GI2,Gastrointestinal,ffd966,GI; GI3,Gastrointestinal,ffd966,GI; GI4,Gastrointestinal,ffd966,GI; GUL,Genitourinary,5d99c2,GU; GUS,Genitourinary,5d99c2,GU; GYL,Gynecologic,c48fbc,GYN; GYS,Gynecologic,c48fbc,GYN; OB,Obstetrical,c48fbc,OB;HN1,Head and Neck,81cdc4,HN; HN2,Head and Neck,81cdc4,HN; HPA,Hematopathology,d3f6d0,HP; HPB,Hematopathology,d3f6d0,HP; NP,Neuropathology,67ba86,NP; PP,Pulmonary Pathology,dee58a,PP;RLS,RLS,fff2cc,RLS; AP CHIEF,AP Chief,d1d1d1,AP Chief;
-|;|TaskAbbreviation|
-{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
-|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
-|group by=scheduleFACservice.Color
-|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
-|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}}
-|}}