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="#f787c8"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=253668 {{ColorText|27364||black}}]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <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="# | + | <tr><td bgcolor="#fbd9af"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=253668 {{ColorText|27364||black}}]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#fbd9af"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=86278 {{ColorText|32443||black}}]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#dce8ed"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=383378 {{ColorText|25338||black}}]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#dce8ed"><center>[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=383378 {{ColorText|25338||black}}]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#ebfbea"><center>[[{{#var:HPA}}|{{ColorText|{{#tip-text: {{#var:HPA}} | {{#var:HPAname}}}}||#000000|}}]]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#ebfbea"><center>[[{{#var:HPA}}|{{ColorText|{{#tip-text: {{#var:HPA}} | {{#var:HPAname}}}}||#000000|}}]]</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#ebfbea"><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="# | + | <tr><td bgcolor="#bdd7e5"><center>{{#ifeq:{{#time:w|now}}|2|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=143571 {{ColorText|MFL12||black}}]|[https://ppd.partners.org/scripts/phsweb.mwl?APP=PDPERS&ACTION=PAGE&ID=67464 {{ColorText|MM408||black}}]}}</center></td></tr> |
| − | <tr><td bgcolor="# | + | <tr><td bgcolor="#eaeaea"><center>-</center></td></tr> |
</table> | </table> | ||
