Difference between revisions of "CurrentWeekConfCall"

From MGH Learn Pathology
 
(8 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|}} - 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 style="width: 14%">
 
<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 style="width: 14%">
 
<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 style="width: 14%">
 
<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 style="width: 14%">
 
<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 style="width: 14%">
 
<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 style="width: 14%">
 
<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>
Line 32: Line 32:
 
{{#cargo_query: tables=conferenceOuts,facultyMGH  
 
{{#cargo_query: tables=conferenceOuts,facultyMGH  
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
−
     |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
+
     |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}}}} + 1 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}}
+
     |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
Line 45: Line 45:
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 
     |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}}
+
     |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='2'|default={{:schtableempty}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
Line 57: Line 57:
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 
     |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}}
+
     |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='3'|default={{:schtableempty}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
Line 66: Line 66:
 
     |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=schtableconfcallLeft}}
 
     |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 style="width: 14%">
 
<td style="width: 14%">
Line 76: Line 81:
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 
     |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 
     |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}}
+
     |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='5'|default={{:schtableempty}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
     |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>

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

Monday
Jan 26

Monday
Jan 26
Tuesday
Jan 27

Tuesday
Jan 27
Wednesday
Jan 28

Wednesday
Jan 28
Thursday
Jan 29

Thursday
Jan 29
Friday
Jan 30

Friday
Jan 30
Saturday
Jan 31
Sunday
Feb 01
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
Call: Junior - MOR
🥣 - J. Pace's
Autopsy - 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
Retrieved from "https://learn.mghpathology.org/index.php?title=CurrentWeekConfCall&oldid=38666"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital