Difference between revisions of "learn:oncallfaculty"
From MGH Learn Pathology
| Line 1: | Line 1: | ||
| − | {{#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="#ed5884"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=253668 {{ColorText|27364||black}}]</center></td></tr> | <tr><td bgcolor="#ed5884"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=253668 {{ColorText|27364||black}}]</center></td></tr> | ||
| Line 12: | Line 12: | ||
<tr><td bgcolor="#b0ced9"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=383378 {{ColorText|25338||black}}]</center></td></tr> | <tr><td bgcolor="#b0ced9"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=383378 {{ColorText|25338||black}}]</center></td></tr> | ||
| − | <tr><td bgcolor="#d3f6d0"><center>[[{{#var:HPA}}|{{ColorText|{{#tip-text: {{#var:HPA}} | {{ | + | <tr><td bgcolor="#d3f6d0"><center>[[{{#var:HPA}}|{{ColorText|{{#tip-text: {{#var:HPA}} | {{#var:HPAname}}}}||#000000|}}]]</center></td></tr> |
| − | <tr><td bgcolor="#d3f6d0"><center>[[{{#var:HPA}}|{{ColorText|{{#tip-text: {{#var:HPA}} | {{ | + | <tr><td bgcolor="#d3f6d0"><center>[[{{#var:HPA}}|{{ColorText|{{#tip-text: {{#var:HPA}} | {{#var:HPAname}}}}||#000000|}}]]</center></td></tr> |
<tr><td bgcolor="#d3f6d0"><center>{{#ifeq:{{#var:HG}}|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:HG}}||black}}]|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID={{#var:HGpager}} {{ColorText|{{#var:HG}}||black}}]}}</center></td></tr> | <tr><td bgcolor="#d3f6d0"><center>{{#ifeq:{{#var:HG}}|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:HG}}||black}}]|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID={{#var:HGpager}} {{ColorText|{{#var:HG}}||black}}]}}</center></td></tr> | ||
