Difference between revisions of "learn:schedule-currentweek"

From MGH Learn Pathology
Line 51: Line 51:
 
     |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)='{{#var:Tuesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default={{:schtableempty}}
−
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+
     |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=scheduleCallConference,facultyMGH
 +
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 +
    |fields=
 +
scheduleCallConference.ResAbbrev,
 +
scheduleCallConference.Color,
 +
facultyMGH.fullname,
 +
scheduleCallConference.TaskAbbrev,
 +
scheduleCallConference.Sort,
 +
scheduleCallConference.Notes
 +
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default={{:schtableempty}}
 +
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 58: Line 69:
 
     |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)='{{#var:Wednesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default={{:schtableempty}}
−
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+
     |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=scheduleCallConference,facultyMGH
 +
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 +
    |fields=
 +
scheduleCallConference.ResAbbrev,
 +
scheduleCallConference.Color,
 +
facultyMGH.fullname,
 +
scheduleCallConference.TaskAbbrev,
 +
scheduleCallConference.Sort,
 +
scheduleCallConference.Notes
 +
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default={{:schtableempty}}
 +
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 65: Line 87:
 
     |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)='{{#var:Thursday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='4' AND NOT ResAbbrev='-'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Thursday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='4' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default={{:schtableempty}}
−
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+
     |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=scheduleCallConference,facultyMGH
 +
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 +
    |fields=
 +
scheduleCallConference.ResAbbrev,
 +
scheduleCallConference.Color,
 +
facultyMGH.fullname,
 +
scheduleCallConference.TaskAbbrev,
 +
scheduleCallConference.Sort,
 +
scheduleCallConference.Notes
 +
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='4' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default={{:schtableempty}}
 +
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 187: Line 220:
 
|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)='{{#var:Monday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
+
|where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default={{:schtableempty}}
−
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
+
    |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
−
|}}
+
{{#cargo_query: tables=scheduleCallConference,facultyMGH
 +
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 +
    |fields=
 +
scheduleCallConference.ResAbbrev,
 +
scheduleCallConference.Color,
 +
facultyMGH.fullname,
 +
scheduleCallConference.TaskAbbrev,
 +
scheduleCallConference.Sort,
 +
scheduleCallConference.Notes
 +
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default={{:schtableempty}}
 +
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
 
</td>
 
</td>
 
<td style="width: 10%">
 
<td style="width: 10%">

Revision as of 19:42, September 6, 2021

See other weeks

Call & conference

Monday
Jun 22

Monday
Jun 22
Tuesday
Jun 23

Tuesday
Jun 23
Wednesday
Jun 24

Wednesday
Jun 24
Thursday
Jun 25

Thursday
Jun 25
Friday
Jun 26

Friday
Jun 26
Saturday
Jun 27
Sunday
Jun 28
Busem Binboga Kurt - BBK
Gina Bortoletto - ANT
Stephen Babcock - BBC
Jeanne Dsouza - JMD
-
Alexis Musick - MUS
Frances Li - FNS
-
Stephen Babcock - BBC
Khatcher Margossian - KMA
-
Busem Binboga Kurt - BBK
Victoria Rodriguez Castellanos - VRC
-
Busem Binboga Kurt - BBK
Marc Benoit - MAB
Busem Binboga Kurt - BBK
Marc Benoit - MAB

Service schedule

 

 

Monday to
Friday

 

Monday
Jun 22Monday
Jun 22
Tuesday
Jun 23Tuesday
Jun 23
Wednesday
Jun 24Wednesday
Jun 24
Thursday
Jun 25Thursday
Jun 25
Friday
Jun 26Friday
Jun 26
Saturday
Jun 27
Sunday
Jun 28
Service
AUT
BR1
BR2
BST
CV
CA
CB
CC
DPA
DPB
DPC
HN1
HN2
GI1
GI2
GI3
GI4
GUL
GUS
GYL
GYS
HPA
HPB
HG
NP
OB
PP
RP
FS-S
FS-J
GR-S
AP Chief
CP Chief

 

Resident
ANT,BBK
FNS
LAU
ATE
KSH
KMA
-
-
JMD
-
-
LHV
VRC
RSC
-
AUO
-
-
-
-
-
-
-
-
PHI
JSO,MAB
-
KSH
-
-
-
EKP,RAK
AJH,MSS


VAC
ELY
JSE
PCH
SRH
WEM
Fellow
-
-
-
-
-
-
-
NR117
-
MSU
-
-
-
-
-
-
-
-
-
-
-
MCH
-
-
AKE
-
-
-
-
-

 

A

{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GI4,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FROZEN SECTION,CCECFF;FROZEN SECTION,CCECFF;|;|TaskAbbreviation|

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT GROUP_CONCAT(`cargo__scheduleFACservice`.`StaffAbbrev`) AS `StaffAbbrev)`,`cargo__scheduleFACservice`.`Color` AS `Color`,GROUP_CONCAT(`cargo__scheduleFACservice`.`StaffFullName`) AS `StaffFullName)` FROM `cargo__scheduleFACservice` WHERE YEAR(Date)='2026' AND `cargo__scheduleFACservice`.`TaskAbbrev`='TaskAbbreviation' AND `cargo__scheduleFACservice`.`DayNumber`='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs' GROUP BY `cargo__scheduleFACservice`.`Color` ORDER BY `Sort` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'ResAbbrev' in 'where clause' (172.27.81.126:30004)

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