Difference between revisions of "scheduleNow"
From MGH Learn Pathology
| Line 12: | Line 12: | ||
|7= | |7= | ||
{{:scheduleDictionaryAPempty}} | {{:scheduleDictionaryAPempty}} | ||
| − | |{{#arraymap: | + | |{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation| |
{{#cargo_query: tables=scheduleRESservice,residentMGH | {{#cargo_query: tables=scheduleRESservice,residentMGH | ||
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
|fields= | |fields= | ||
GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev) | GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev) | ||
| − | ,scheduleRESservice. | + | ,scheduleRESservice.TaskAbbrev |
,GROUP_CONCAT(DISTINCT residentMGH.full_name) | ,GROUP_CONCAT(DISTINCT residentMGH.full_name) | ||
,pageid | ,pageid | ||
| Line 31: | Line 31: | ||
|7= | |7= | ||
{{:scheduleDictionaryAPempty}} | {{:scheduleDictionaryAPempty}} | ||
| − | |{{#arraymap: | + | |{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation| |
{{#cargo_query: tables=scheduleFELLservice,residentMGH | {{#cargo_query: tables=scheduleFELLservice,residentMGH | ||
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ||
| − | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice. | + | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid |
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template | ||
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|template=schtableres}} | |group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|template=schtableres}} | ||
| Line 53: | Line 53: | ||
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table> | ||
}} | }} | ||
| − | {{#arraymap: {{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation| | + | {{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation| |
{{#cargo_query: table=scheduleFACservice | {{#cargo_query: table=scheduleFACservice | ||
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName) | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName) | ||
Revision as of 23:15, September 5, 2021
|
|
|
|
[1]Faculty schedule displayed using the QGenda API. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||