Difference between revisions of "oneday"
From MGH Learn Pathology
(Created page with "<table class='table borderless'> <tr> <td colspan="1"> Β </td> <td class='align-bottom' colspan="2"> <center><p>{{ColorText|Mon-Fri||#000000|}}</p></center> </td> <td cla...") |
|||
(21 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | <center><div class=calendarbg> | ||
+ | {{#cargo_compound_query: | ||
+ | tables=conference,residentMGH | ||
+ | ;join on=conference.presenter=residentMGH.copath_id | ||
+ | ;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date | ||
+ | ;where=conference='Call: Junior' | ||
+ | ;color=#e0ffef | ||
+ | ;text color=black | ||
+ | |tables=conference,residentMGH | ||
+ | ;join on=conference.presenter=residentMGH.copath_id | ||
+ | ;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date | ||
+ | ;where=conference='Call: Autopsy' | ||
+ | ;color=#e0ffef | ||
+ | ;text color=black | ||
+ | |tables=conference,residentMGH | ||
+ | ;join on=conference.presenter=residentMGH.copath_id | ||
+ | ;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date | ||
+ | ;where=conference='Call: Senior' | ||
+ | ;color=#f2e6ff | ||
+ | ;text color=black | ||
+ | |tables=scheduleFood | ||
+ | ;fields=CONCAT('π₯£ - ',presenter)=name,date=Date | ||
+ | ;color=#f5f5f5 | ||
+ | ;text color=black | ||
+ | |tables=conference,residentMGH | ||
+ | ;join on=conference.presenter=residentMGH.copath_id | ||
+ | ;fields=CONCAT('08:25 AM - ' ,conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date | ||
+ | ;where=conference='GPR' | ||
+ | ;color=#ffb973 | ||
+ | ;text color=black | ||
+ | |tables=conferenceOuts, facultyMGH;join on=conferenceOuts.StaffAbbrev = facultyMGH.copath_id;fields=CONCAT(conferenceOuts.time, ' - ', conferenceOuts.TaskAbbrev, ' - ', conferenceOuts.StaffAbbrev)=name,facultyMGH.name_last=description,conferenceOuts.date=Date;color=#fff673;text color=black | ||
+ | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT('08:00 AM - ' ,conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='MPR';color=#7dc4ff;text color=black | ||
+ | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Thoracic';color=#c2c2c2;text color=black | ||
+ | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='RadPath';color=#66ff96;text color=black | ||
+ | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Autopsy';color=#faff69;text color=black | ||
+ | |format=calendar|view=day|height=165}} | ||
+ | </div></center> | ||
+ | <p> | ||
<table class='table borderless'> | <table class='table borderless'> | ||
<tr> | <tr> | ||
β | + | <td style="width: 6%"> | |
β | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''S'''||#000000|}}</center></td></tr></table> | |
β | + | {{:schtablemobileoneday1}} | |
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | <td style="width: | ||
β | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|''' | ||
β | {{: | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table> | ||
β | {{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA | + | {{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA|,|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 | ||
Line 51: | Line 52: | ||
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table> | ||
β | {{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA | + | {{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA|,|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 | ||
Line 60: | Line 61: | ||
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
β | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}''' | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table> |
β | {{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA | + | {{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA|,|TaskAbbreviation| |
{{#cargo_query: table=scheduleFACservice | {{#cargo_query: table=scheduleFACservice | ||
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName | |fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName | ||
β | |where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber=' | + | |where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' |
|default={{:schtableempty}}|format=template|template=schtable}} | |default={{:schtableempty}}|format=template|template=schtable}} | ||
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | |
β | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text: | + | <td style="width: 7%"> |
β | {{#arraymap: | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''S'''||#000000|}}</center></td></tr></table> |
β | {{#cargo_query: | + | {{:schtablemobileoneday2}} |
β | |fields= | + | </td> |
β | |where= | + | <td style="width: 9%"> |
β | |default={{:schtableempty}}|format=template|template=schtable}} | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table> |
+ | {{#arraymap: DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL|,|TaskAbbreviation| | ||
+ | {{#cargo_query: tables=scheduleRESservice,residentMGH | ||
+ | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
+ | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name | ||
+ | |where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtable}} | ||
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
β | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text: | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table> |
β | {{#arraymap: | + | {{#arraymap: DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL|,|TaskAbbreviation| |
β | {{#cargo_query: | + | {{#cargo_query: tables=scheduleFELLservice,residentMGH |
β | |fields= | + | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id |
β | |where= | + | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name |
β | + | |where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}} | |
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table> | ||
β | {{#arraymap: | + | {{#arraymap: DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL|,|TaskAbbreviation| |
{{#cargo_query: table=scheduleFACservice | {{#cargo_query: table=scheduleFACservice | ||
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName | |fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName | ||
β | |where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber=' | + | |where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' |
|default={{:schtableempty}}|format=template|template=schtable}} | |default={{:schtableempty}}|format=template|template=schtable}} | ||
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | |
β | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text: | + | |
β | {{#arraymap: | + | <td style="width: 6%"> |
β | {{#cargo_query: | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''S'''||#000000|}}</center></td></tr></table> |
β | |fields= | + | {{:schtablemobileoneday3}} |
β | |where= | + | </td> |
β | |default={{:schtableempty}}|format=template|template=schtable}} | + | <td style="width: 9%"> |
+ | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table> | ||
+ | {{#arraymap: GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation| | ||
+ | {{#cargo_query: tables=scheduleRESservice,residentMGH | ||
+ | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
+ | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name | ||
+ | |where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtable}} | ||
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
β | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text: | + | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table> |
β | {{#arraymap: | + | {{#arraymap: GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation| |
β | {{#cargo_query: | + | {{#cargo_query: tables=scheduleFELLservice,residentMGH |
β | |fields= | + | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id |
β | |where= | + | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name |
β | + | |where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}} | |
|}} | |}} | ||
</td> | </td> | ||
β | <td style="width: | + | <td style="width: 9%"> |
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table> | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table> | ||
β | {{#arraymap: | + | {{#arraymap: GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation| |
{{#cargo_query: table=scheduleFACservice | {{#cargo_query: table=scheduleFACservice | ||
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName | |fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName | ||
β | |where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber=' | + | |where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' |
|default={{:schtableempty}}|format=template|template=schtable}} | |default={{:schtableempty}}|format=template|template=schtable}} | ||
|}} | |}} | ||
</td> | </td> | ||
β | + | ||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
β | |||
</tr> | </tr> | ||
</table> | </table> | ||
+ | </p> |
Latest revision as of 22:01, August 30, 2019