|
|
Line 1: |
Line 1: |
β | <center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='{{#time: N |now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayoneday}}</center> | + | <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> | | <p> |
| <table class='table borderless'> | | <table class='table borderless'> |
| <tr> | | <tr> |
β | <td style="width: 7%"> | + | <td style="width: 23%"> |
| <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''SERVICE'''||#000000|}}</center></td></tr></table> | | <table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''SERVICE'''||#000000|}}</center></td></tr></table> |
| {{:schtablemobileoneday1}} | | {{:schtablemobileoneday1}} |
Line 98: |
Line 134: |
| |default={{:schtableempty}}|format=template|template=schtable}} | | |default={{:schtableempty}}|format=template|template=schtable}} |
| |}} | | |}} |
β | </td>
| |
β |
| |
β | <td style="width: 16%">
| |
β | <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>
| |
| </td> | | </td> |
| | | |
Line 143: |
Line 139: |
| </table> | | </table> |
| </p> | | </p> |
β | <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>
| |