Difference between revisions of "CurrentWeekConfCall"

From MGH Learn Pathology
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<table class='table borderless'>
 
<table class='table borderless'>
 
<tr>
 
<tr>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='1'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |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,DATE_FORMAT(conferenceOuts.date, '%Y/%m/%d')
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='2'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='2'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |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}}}} - 0 }}' AND conferenceOuts.daynumber='2'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='3'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='3'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |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}}}} - 0 }}' AND conferenceOuts.daynumber='3'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='4'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='4'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conference,facultyMGH
 +
    |join on=conference.presenter=facultyMGH.copath_id
 +
    |fields=conference.presenter,facultyMGH.fullname,conference.type
 +
    |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.conference='Thursday'|default={{:schtableempty}}
 +
    |format=template|order by = sort ASC|template=schtableconfthursday}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='5'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='5'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |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}}}} - 0 }}' AND conferenceOuts.daynumber='5'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='6'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='6'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='7'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='7'|default={{:schtableempty}}
     |format=template|order by = sort ASC|template=schtableconf}}
+
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>

Latest revision as of 06:06, June 25, 2020

Monday
Jan 27

Monday
Jan 27

Tuesday
Jan 28

Tuesday
Jan 28

Wednesday
Jan 29

Wednesday
Jan 29

Thursday
Jan 30

Thursday
Jan 30

Friday
Jan 31

Friday
Jan 31

Saturday
Feb 01

Sunday
Feb 02

Diane Brackett - DIB
Baris Boyraz - BYB
🥣 - Roll the dice!
Sarah Mueller - MUL
GU: PET @ 12:00 PM
No PDF
ENT: PET @ 12:30 PM
No PDF
Call: Senior - NDA
Jakob Moran - MOR
🥣 - J. Pace's
Jakob Moran - MOR
PP: HNG @ 12:00 PM
No PDF
Andrew Crabbe - CRB
Julian Villalba - VIL
🥣 - India Quality
GI: LRZ @ 12:00 PM
No PDF
BR: SGR @ 12:30 PM
No PDF
Aida Valencia-Guerrero - AID
Cynthia Harris - CYN
🥣 - King and I
ASR - Meningeal based tumors and demyelinating disease
Call: Senior - NDA
Cynthia Harris - CYN
🥣 - Dave's Pasta
Julian Villalba - VIL
CYT: TOR @ 12:00 PM
No PDF
BST: GUN @ 12:30 PM
No PDF
Call: Senior - NDA
Elisabeth Tabb - TAB
Baris Boyraz - BYB
Call: Senior - NDA
Elisabeth Tabb - TAB
Baris Boyraz - BYB