Difference between revisions of "learn:schedule-currentweek"

From MGH Learn Pathology
Line 33: Line 33:
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
−
     |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Call: Autopsy', 'Call: Junior CP', 'Call: BB/CP', 'HP Journal Club')|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Monday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Call: Autopsy', 'Call: Junior CP', 'Call: BB/CP', 'HP Journal Club')|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
Line 40: Line 40:
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
−
     |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
Line 47: Line 47:
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
−
     |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
Line 96: Line 96:
 
</td>
 
</td>
 
<td class='align-bottom' colspan="1">
 
<td class='align-bottom' colspan="1">
−
<center>{{#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=datedisplaycurrent}}<p></p></center>
+
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
</td>
 
</td>
 
<td class='align-bottom' colspan="1">
 
<td class='align-bottom' colspan="1">
−
<center>{{#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=datedisplaycurrent}}<p></p></center>
+
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
</td>
 
</td>
 
<td class='align-bottom' colspan="1">
 
<td class='align-bottom' colspan="1">
−
<center>{{#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=datedisplaycurrent}}<p></p></center>
+
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
</td>
 
</td>
 
<td class='align-bottom' colspan="1">
 
<td class='align-bottom' colspan="1">
Line 160: Line 160:
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
 
|group by=scheduleFACservice.Color
 
|group by=scheduleFACservice.Color
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
+
|where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
 
|}}
 
|}}
Line 169: Line 169:
 
{{#cargo_query: table=scheduleFACservice  
 
{{#cargo_query: table=scheduleFACservice  
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
−
|group by=scheduleFACservice.Color|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
+
|group by=scheduleFACservice.Color|where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
 
|}}
 
|}}
Line 179: Line 179:
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
 
|group by=scheduleFACservice.Color
 
|group by=scheduleFACservice.Color
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
+
|where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
 
|}}
 
|}}

Revision as of 10:34, December 28, 2020

Call & Conference

No results

No results

No results

No results

Friday
Jan 31

Friday
Jan 31
Saturday
Feb 01
Sunday
Feb 02
Lisa Yuen - LYU
Kaitlin Ross - RAK
Maxwell Roth - MAX
Negar Taheri - NXT
Anh Huynh - AHU
Joshua Sciurba - HUA
Maria Chen - MCH
Alexis Musick - MUS
Maria Cristina Riascos Morillo - RSC
Khatcher Margossian - KMA
Maria Cristina Riascos Morillo - RSC
Busem Binboga Kurt - BBK
-
Service Schedule

 

 

Monday to
Friday

 

No results
No results
No results
Thursday
Jan 29Thursday
Jan 29
Friday
Jan 30Friday
Jan 30
Saturday
Jan 31
Sunday
Feb 01
Service
AUT
BR1
BR2
BST
CV
RP
CA
CB
CC
DPA
DPB
DPC
HN1
HN2
GI1
GI2
GI3
GI4
GUL
GUS
GYL
GYS
HPA
HPB
HG
NP
OB
PP
FS-S
FS-J
GR-S
AP Chief
CP Chief

 

Resident
KOA,MUS,OPA,PHI
BRC,SFA
NEA
AUO,KSH,RXN
-
MCH
-
-
-
-
-
-
JPB
-
RRA
KMA
-
-
-
-
-
JSW
FXR
-
BBK,DEM,EKP,REN
LCC
TYY
-
-
-
-
BBC,LHV
JSE,SMT


VAC
ATE
FNS
RNS
VRC
Fellow
-
-
-
-
-
DZ1016
-
HH579
-
EHA
-
-
-
-
-
-
-
-
-
-
-
HUK
-
-
-
-
-
-
-
-

 

A
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
A
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
A
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
A
-
Ly
-
-
A
-
Ly
-
-
A
Ly
Ly
-
Ly
Ly
Ly
-
-
-
-
-
A
Ly
Ly
-
Ly
Ly
Ly
-
-
-
-
-
Retrieved from "https://learn.mghpathology.org/index.php?title=learn:schedule-currentweek&oldid=55126"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital