Difference between revisions of "CurrentWeekConfCall"

From MGH Learn Pathology
 
(4 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|{{Timezone}}}} - 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|{{Timezone}}}} - 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|{{Timezone}}}} - 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|{{Timezone}}}} - 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|{{Timezone}}}} - 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|{{Timezone}}}} - 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|{{Timezone}}}} - 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}}}} - 0 }}' 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}}
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%">

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

Monday
Jan 13

Monday
Jan 13
Tuesday
Jan 14

Tuesday
Jan 14
Wednesday
Jan 15

Wednesday
Jan 15
Thursday
Jan 16

Thursday
Jan 16
Friday
Jan 17

Friday
Jan 17
Saturday
Jan 18
Sunday
Jan 19
Ying-Hsia Chu - YHC
Daniel Shepherd - DAN
🥣 - Roll the dice!
GPR - WGB
-
Call: Senior - KRT
Caroline Hilburn - CFH
🥣 - J. Pace's
Julian Villalba - VIL
Cynthia Harris - CYN
OB: DRU @ 12:00 PM
No PDF
Zehra Ordulu Sahin - ZRA
Julian Villalba - VIL
🥣 - India Quality
GI: JOE @ 12:00 PM
No PDF
BR: TVS @ 12:30 PM
No PDF
Andrew Crabbe - CRB
Elisabeth Tabb - TAB
🥣 - King and I
DNL - CNS tumors gliomas and other non-glial tumors
Melissa Krystel-Whittemore - MKW
Michael Marshall - MIC
🥣 - Dave's Pasta
Daniel Shepherd - DAN
CYT: MBP @ 12:00 PM
No PDF
GYN: OLI @ 12:30 PM
No PDF
Melissa Krystel-Whittemore - MKW
Michael Astudillo - AST
Cynthia Harris - CYN
Michael Astudillo - AST
Cynthia Harris - CYN
Melissa Krystel-Whittemore - MKW
Michael Astudillo - AST
Cynthia Harris - CYN
Michael Astudillo - AST
Cynthia Harris - CYN
Retrieved from "https://learn.mghpathology.org/index.php?title=CurrentWeekConfCall&oldid=38666"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital