Difference between revisions of "Schedule"

@@ Line 63: / Line 63: @@
 <table class='table borderless' style="width: 100%">
 <td style="width: 20%">
-<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|4}}</center></td></tr></table>{{#cargo_query: tables=scheduleCallConference |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color, scheduleCallConference.Hour, scheduleCallConference.TaskAbbrev, scheduleCallConference.Sort, scheduleCallConference.Notes |where=YEAR(Date)='{{#var:{{{2}}}NW}}' AND scheduleCallConference.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleCallConference.DayNumber='{{{1}}}' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default= |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
+<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Conferences'''||#000000|4}}</center></td></tr></table>{{{#cargo_query: tables=scheduleCallConference |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color, scheduleCallConference.Hour, scheduleCallConference.TaskAbbrev, scheduleCallConference.Sort, scheduleCallConference.Notes |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} - 0 }}' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default= |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
 {{#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}}| }}
 <br>