Difference between revisions of "EvaluationResAtt"

Revision as of 09:02, September 26, 2020

Anatomic Pathology		Clinical Pathology		External/Elective Evaluations

You're signed in as '. Need help?'

@@ Line 19: / Line 19: @@
 </tr>
 <tr>
-<td style="vertical-align:top; width:43%">
+<td style="vertical-align:top; width:38%">
 {{#cargo_query:tables=scheduleRFA,evaluationResAtt
 |join on=scheduleRFA.UID=evaluationResAtt.UID
@@ Line 35: / Line 35: @@
 &nbsp;&nbsp;&nbsp;
 </td>
-<td style="vertical-align:top; width:33%">
+<td style="vertical-align:top; width:38%">
-{{#cargo_query:tables=scheduleRESservice,evaluationResAtt
+{{#arraymap: COAG;Micro;BTS;HG;HPA;HPB;|;|TaskLMM|
-|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID
+{{#cargo_query:tables=scheduleRFA,evaluationResAtt
+|join on=scheduleRFA.UID=evaluationResAtt.UID
 |fields=
-DATE_FORMAT(scheduleRESservice.Date, '%b %e, %Y')=Week Of
+DATE_FORMAT(scheduleRFA.Date, '%b %e, %Y')=Date
-,scheduleRESservice.TaskAbbrev=Rotation
+,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service
-,CONCAT('{{evaluationResAtt-attendingLMP{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.UID,'}}')=Attending
+,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending
-|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND scheduleRESservice.ResAbbrev='NAS' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev='BB' OR scheduleRESservice.TaskAbbrev='COAG' OR scheduleRESservice.TaskAbbrev='C/M')
+|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='MOR' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND scheduleRFA.TaskAbbrev='TaskLMM'
-|order by=scheduleRESservice.Date DESC
+|group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
+|order by=scheduleRFA.Date DESC
 |rows per page=50
-|group by=Week Of
 |format=dynamic table|default=}}
+}}
 </td>
 <td style="width:1%">