Difference between revisions of "ScheduleMobile"

@@ Line 48: / Line 48: @@
 }}
 <br>
-<table class='table borderless'>
+{{:scheduleNow}}
-<tr>
-<td style="width: 10%">
-<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
-{{:schtablemobile2}}
-</td>
-<td style="width: 13%">
-<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
-{{#switch: {{#time: N|{{Timezone}}}}
-|6
-|7=
-{{:schtablemobile6}}
-|{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;RP,FFFF8D;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;FS-S,CCECFF;FS-J,CCECFF;GR-S,B8A315;AP CHIEF,B39BE9;CP CHIEF,B39BE9;|;|TaskAbbreviation|
-{{#cargo_query: tables=scheduleRESservice,residentMGH
-|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
-|fields=
-GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev)
-,scheduleRESservice.Color
-,GROUP_CONCAT(DISTINCT residentMGH.full_name)
-,pageid
-|group by=scheduleRESservice.WeekNumber
-|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtableres}}
-|}}
-}}
-</td>
-<td style="width: 13%">
-<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow}}||#000000|}}'''</center></td></tr></table>
-{{#switch: {{#time: N|{{Timezone}}}}
-|6
-|7=
-{{:schtablemobile6}}
-|{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;RP,FFFF8D;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;FS-S,CCECFF;FS-J,CCECFF;|;|TaskAbbreviation|
-{{#cargo_query: tables=scheduleFELLservice,residentMGH
-|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
-|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name,residentMGH.pageid
-|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
-|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|template=schtableres}}
-|}}
-}}
-</td>
-<td style="width: 13%">
-{{#switch: {{#time: N|{{Timezone}}}}
-|6
-|7=
-<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:On-Call|On-Call Attending}}||#000000|}}'''
-</center></td></tr></table>
-|1
-|2
-|3
-|4
-|5=
-<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''</center></td></tr></table>
-}}
-{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;RP,FFFF8D;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;FROZEN SECTION,CCECFF;FROZEN SECTION,CCECFF;|;|TaskAbbreviation|
-{{#cargo_query: table=scheduleFACservice
-|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='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
-|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
-|}}
-</td>
-</tr>
-</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|'''Call - resident'''||#000000|}}</center></td></tr></table>
-<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=
+     |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 ASC|default=
      |format=template|template=schtableconf}}
 |7=
@@ Line 132: / Line 63: @@
      |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=
+     |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 ASC|default=
      |format=template|template=schtableconf}}
 |
@@ Line 138: / Line 69: @@
      |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=
+     |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 ASC|default=
      |format=template|template=schtableconf}}
-}}</center>
+}}
 <br>
-{{:learn:oncallfaculty}}
+<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}}
+</center>
 </div>