Difference between revisions of "ScheduleMobile"

From MGH Learn Pathology
Line 111: Line 111:
 
</tr>
 
</tr>
 
</table>
 
</table>
 +
<br>
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|}}</center></td></tr></table>{{#if:{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,dziOrder.collection_name,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y-m-d|now}}' AND scheduleCallConference.TaskAbbrev='Outs'|default=|group by=dziOrder.class_type|format=template|template=schtableconfOuts|limit=1|more results text=}}|{{#cargo_query: tables=dziOrder,scheduleCallConference,facultyMGH|join on=scheduleCallConference.ResAbbrev=dziOrder.requested_by,dziOrder.requested_by=facultyMGH._pageName|fields=scheduleCallConference.TaskAbbrev,scheduleCallConference.Hour,dziOrder.collection_name,scheduleCallConference.ResAbbrev,scheduleCallConference.Color,dziOrder._pageTitle,facultyMGH.fullname|where=dziOrder.presentation_date='{{#timel: Y-m-d|now}}' AND scheduleCallConference.TaskAbbrev='Outs'|default=|group by=dziOrder.class_type|format=template|template=schtableconfOuts|limit=1|more results text=}}|}} {{#vardefine:date|{{#cargo_query: tables= conferenceMPR|fields=Date|where=YEAR(conferenceMPR.Date)='{{#time: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#time: W|now}} - 1}}'|default= |format=template|template=text}}}} {{#if:{{#cargo_query: tables=scheduleCallConference,residentMGH |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND scheduleCallConference.Type='Conference' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT TaskAbbrev='HP Journal Club' AND NOT TaskAbbrev='Outs'|default=|format=template|template=schtableconf}}|{{#cargo_query: tables=scheduleCallConference,residentMGH |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND scheduleCallConference.Type='Conference' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT TaskAbbrev='HP Journal Club' AND NOT TaskAbbrev='Outs'|default=|format=template|template=schtableconf}}|<center>''No conferences today''</center>}} {{#ifeq:{{#time: Y-m-d|today}}|{{#var:date}}|{{#cargo_query: tables= conferenceMPR,residentMGH |join on=conferenceMPR.ResAbbrev=residentMGH.copath_id |fields=conferenceMPR.ResAbbrev,conferenceMPR.Color,residentMGH.full_name,conferenceMPR.TaskAbbrev |where=YEAR(conferenceMPR.Date)='{{#time: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#time: W|now}} - 1 }}'|default= |format=template|template=schtableconf}}|}}
 +
<br>
 +
<p></p>
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Vacations'''||#000000|}}</center></td></tr></table>
 +
{{#cargo_query: tables=scheduleRESservice,residentMGH
 +
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 +
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
 +
|where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=schtable}}
 +
<br>
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''On call - resident'''||#000000|}}</center></td></tr></table>
 +
{{#switch: {{#timel: N|{{Timezone}}}}|6=
 +
{{#cargo_query: tables= scheduleCallConference,residentMGH
 +
    |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
 +
    |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
 +
    |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP'|order by= scheduleCallConference.Sort DESC|default=
 +
    |format=template|template=schtableconf}}
 +
|7=
 +
{{#cargo_query: tables= scheduleCallConference,residentMGH
 +
    |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
 +
    |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
 +
    |where=YEAR(Date)='{{#timel: Y|now}}' AND  scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort DESC|default=
 +
    |format=template|template=schtableconf}}
 +
|
 +
{{#cargo_query: tables= scheduleCallConference,residentMGH
 +
    |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
 +
    |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
 +
    |where=YEAR(Date)='{{#timel: Y|now}}' AND  scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort DESC|default=
 +
    |format=template|template=schtableconf}}
 +
}}</center>
 +
<br>
 +
{{:learn:oncallfaculty}}
 
</div>
 
</div>

Revision as of 19:12, September 2, 2021

Welcome
Hello, !
You last logged in on Thursday, January 16, 2025 at 3:10 PM.

Quick links

About us

AP & CP services

Contact list

Distribution lists

Digital slides (WSI)

Resident portal

Schedules

See other weeks


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
EAD,NXT
EXE
-
BBK,RSC
RRA,YQG
RRA,YQG
DSV
-
AKE
BBC,EHA
-
-
-
HUA
-
STO
MDR
-
-
-
JPB
VZA
-
LHV
-
BKV,JOS
VZA
FXR
-
-
-
LYU
DCG,SRH
Fellow
-
-
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`Color` AS `Color`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2025 AND `cargo__scheduleFELLservice`.`WeekNumber`='3' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='BR2' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`Color`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1146 Table 'cargo.cargo__scheduleFELLservice' doesn't exist (172.27.81.126:30004)

Error: No database table exists named "scheduleFELLservice".
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending
REX
GUN
VER
WSB
WSB
AMY
RMN
KMC
WCF
GLK
HMA
-
-
OLI
LHL
RPH
JAF
ARA
MPF
LHL
HNG
SGS
SGS


Conferences
No conferences today


Vacations
RLD


On call - resident
Call: Junior - SAN
Call: Senior - SYA


27364
No results EMB31
15433
32443
25338
25338
RPH
RPH
ARA
-
-
-
-
-
-
-
MM408
-
Retrieved from "https://learn.mghpathology.org/index.php?title=ScheduleMobile&oldid=69214"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital