Difference between revisions of "learn:currentweek"

@@ Line 1: / Line 1: @@
 {{DISPLAYTITLE:Current Week (Week {{#time: W|{{Timezone}}}} of {{#time: Y|{{Timezone}}}})}}<center>{{ColorText|Call & Conferences||#30705d|5|}}</center><p></p>
-{{:CurrentWeekConfCall}}
+<table class='table borderless'>
+<tr>
+<td style="width: 14%">
+{{#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 style="width: 14%">
+{{#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 style="width: 14%">
+{{#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 style="width: 14%">
+{{#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 style="width: 14%">
+{{#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 style="width: 14%">
+{{#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 style="width: 14%">
+{{#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>
+</tr>
+<tr>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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='4'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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='5'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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='6'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+<td style="width: 14%">
+{{#cargo_query: tables=scheduleCallConference,residentMGH
+    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
+    |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='0'|default={{:schtableempty}}
+    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
+</td>
+</tr>
+</table>
 <hr>
 <center>{{ColorText|Service Schedule||#30705d|5|}}</center>
@@ Line 61: / Line 139: @@
 |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
-|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtable}}
+|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtable}}
 </td>
 <td style="width: 10%">