Difference between revisions of "NextWeekConfCall"

From MGH Learn Pathology
 
(7 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
<tr>
 
<tr>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=conference,residentMGH
 
    |join on=conference.presenter=residentMGH.copath_id
 
    |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
    |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}<br>
 
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
Line 35: Line 30:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time,facultyMGH.copath_id,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}}
 +
    |format=template|order by = conferenceOuts.time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 42: Line 42:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='2'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='2'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='2'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 49: Line 54:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='3'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='3'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='3'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 63: Line 73:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='5'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='5'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='5'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">

Latest revision as of 23:34, September 15, 2019

Monday
Jun 23

Monday
Jun 23

Monday
Jun 22

Monday
Jun 22

Tuesday
Jun 24

Tuesday
Jun 24

Tuesday
Jun 23

Tuesday
Jun 23

Wednesday
Jun 25

Wednesday
Jun 25

Wednesday
Jun 24

Wednesday
Jun 24

Thursday
Jun 26

Thursday
Jun 26

Thursday
Jun 25

Thursday
Jun 25

Friday
Jun 27

Friday
Jun 27

Friday
Jun 26

Friday
Jun 26

Saturday
Jun 28

Saturday
Jun 27

Sunday
Jun 29

Sunday
Jun 28

Adam Fisch - ADM
Baris Boyraz - BYB
🥣 - Roll the dice!
GU: LEE @ 12:00 PM
No PDF
ENT: PET @ 12:30 PM
No PDF
Kristine Chaudet - ALB
Call: Junior - MEG
🥣 - J. Pace's
Caroline Hilburn - CFH
PP: HNG @ 12:00 PM
No PDF
Call: Senior - MEG
Caroline Hilburn - CFH
🥣 - India Quality
HP: NDI @ 12:00 PM
No PDF
HP: ABL @ 12:30 PM
No PDF
Adam Fisch - ADM
Leif Helland - TLH
🥣 - King and I
Kristine Chaudet - ALB
Caroline Hilburn - CFH
🥣 - Piperi
Thoracic - MEG
GI: ROR @ 12:00 PM
No PDF
Kristine Chaudet - ALB
Julian Villalba - VIL
Leif Helland - TLH
Kristine Chaudet - ALB
Julian Villalba - VIL
Leif Helland - TLH