Difference between revisions of "learn:oncallfaculty"
From MGH Learn Pathology
| Line 1: | Line 1: | ||
{{#vardefine:HPAname|{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id |fields=GROUP_CONCAT(scheduleFACservice.StaffFullName)|group by=scheduleFACservice.Color |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='HPA' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'|format=template|template=text}}}}{{#vardefine:HPA|{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev)|group by=scheduleFACservice.Color |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='HPA' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'|format=template|template=text}}}}{{#vardefine:HG|{{#cargo_query:tables=scheduleFACservice|fields=StaffAbbrev|where=TaskAbbrev='HG' AND Date='{{#time: Y-m-d|today}}'|format=template|template=text|no html|default=none}}}}{{#vardefine:HGpager|{{#cargo_query:tables=facultyMGH|fields=pageid|where=copath_id='{{#var:HG}}'|fotmat=template|template=text|no html|default=none}}}}{{#vardefine:COAG|{{#cargo_query:tables=scheduleFACservice|fields=StaffAbbrev|where=TaskAbbrev='COAG' AND Date='{{#time: Y-m-d|today}}'|format=template|template=text|no html}}}}{{#vardefine:COAGpager|{{#cargo_query:tables=facultyMGH|fields=pageid|where=copath_id='{{#var:COAG}}'|fotmat=template|template=text|no html|no html}}}}<table class='scheduletable'> | {{#vardefine:HPAname|{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id |fields=GROUP_CONCAT(scheduleFACservice.StaffFullName)|group by=scheduleFACservice.Color |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='HPA' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'|format=template|template=text}}}}{{#vardefine:HPA|{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev)|group by=scheduleFACservice.Color |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='HPA' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'|format=template|template=text}}}}{{#vardefine:HG|{{#cargo_query:tables=scheduleFACservice|fields=StaffAbbrev|where=TaskAbbrev='HG' AND Date='{{#time: Y-m-d|today}}'|format=template|template=text|no html|default=none}}}}{{#vardefine:HGpager|{{#cargo_query:tables=facultyMGH|fields=pageid|where=copath_id='{{#var:HG}}'|fotmat=template|template=text|no html|default=none}}}}{{#vardefine:COAG|{{#cargo_query:tables=scheduleFACservice|fields=StaffAbbrev|where=TaskAbbrev='COAG' AND Date='{{#time: Y-m-d|today}}'|format=template|template=text|no html}}}}{{#vardefine:COAGpager|{{#cargo_query:tables=facultyMGH|fields=pageid|where=copath_id='{{#var:COAG}}'|fotmat=template|template=text|no html|no html}}}}<table class='scheduletable'> | ||
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#f7b3c8"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=253668 {{ColorText|27364||black}}]</center></td></tr> |
<tr><td bgcolor="#f8dfe3"><center>{{#ifeq:{{#var:COAG}}|JMH|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=ONEDISP&ID=149652&SRCHNM=Higgins&UseSearchVer=1&NOBACK=0&BEGIN=11&END=20#top {{ColorText|{{#var:COAG}}||black}}]|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID={{#var:COAGpager}} {{ColorText|{{#var:COAG}}||black}}]}}</center></td></tr> | <tr><td bgcolor="#f8dfe3"><center>{{#ifeq:{{#var:COAG}}|JMH|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=ONEDISP&ID=149652&SRCHNM=Higgins&UseSearchVer=1&NOBACK=0&BEGIN=11&END=20#top {{ColorText|{{#var:COAG}}||black}}]|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID={{#var:COAGpager}} {{ColorText|{{#var:COAG}}||black}}]}}</center></td></tr> | ||
