Difference between revisions of "learn:oncallfaculty"

From MGH Learn Pathology
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>
  
{{#arraymap:HPA,Hematopathology,d3f6d0,HP; HPA,Hematopathology,d3f6d0,HP;|;|TaskAbbreviation|
+
<tr><td bgcolor="#d3f6d0"><center>[[{{{1|}}}|{{ColorText|{{#tip-text: {{{1|}}} | {{{3|}}}}}||#000000|}}]]</center></td></tr>
{{#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}}
 
|}}
 
  
 
<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>
Line 25: Line 19:
 
<tr><td bgcolor="#d1d1d1"><center>-</center></td></tr>
 
<tr><td bgcolor="#d1d1d1"><center>-</center></td></tr>
 
</table>
 
</table>
 +
 +
 +
 +
<hr>
 +
 +
{{#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}}}} {{#var:HPA}}

Revision as of 12:50, September 9, 2021