Difference between revisions of "scheduleNow"
From MGH Learn Pathology
| Line 43: | Line 43: | ||
<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= | + | {{#cargo_query: table=scheduleFACserviceDowntime,facultyMGH|join on=scheduleFACserviceDowntime.StaffAbbrev=facultyMGH.copath_id |
| − | |fields=GROUP_CONCAT( | + | |fields=GROUP_CONCAT(scheduleFACserviceDowntime.StaffAbbrev),scheduleFACserviceDowntime.TaskAbbrev,GROUP_CONCAT(scheduleFACserviceDowntime.StaffFullName),facultyMGH.pageid |
| − | |group by= | + | |group by=scheduleFACserviceDowntime.Color |
| − | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND | + | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACserviceDowntime.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACserviceDowntime.DayNumber='{{#time:N|now}}' AND scheduleFACserviceDowntime.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}' |
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}} | |default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}} | ||
|}} | |}} | ||
| Line 103: | Line 103: | ||
<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:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation| | {{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation| | ||
| − | {{#cargo_query: table= | + | {{#cargo_query: table=scheduleFACserviceDowntime,facultyMGH|join on=scheduleFACserviceDowntime.StaffAbbrev=facultyMGH.copath_id |
| − | |fields=GROUP_CONCAT( | + | |fields=GROUP_CONCAT(scheduleFACserviceDowntime.StaffAbbrev),scheduleFACserviceDowntime.TaskAbbrev,GROUP_CONCAT(scheduleFACserviceDowntime.StaffFullName),facultyMGH.pageid |
| − | |group by= | + | |group by=scheduleFACserviceDowntime.Color |
| − | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND | + | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACserviceDowntime.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACserviceDowntime.DayNumber='{{#time:N|now}}' AND scheduleFACserviceDowntime.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}' |
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}} | |default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}} | ||
|}} | |}} | ||
Revision as of 14:21, December 18, 2021
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[1]Faculty schedule displayed using the QGenda API.
