Difference between revisions of "oneday"

From MGH Learn Pathology
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>
 

Revision as of 18:38, August 30, 2019