Difference between revisions of "acc-todayha"

From MGH Learn Pathology
 
(14 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
<tr>
 
<tr>
 
<td class='align-bottom' colspan="3">
 
<td class='align-bottom' colspan="3">
−
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} {{{1|}}} {{{2|}}} }}' AND scheduleFACservice.DayNumber='{{#expr: {{#time: N|{{Timezone}}}} {{{3|}}} {{{4|}}}}}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
+
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} {{{1|}}} {{{2|}}} }}' AND scheduleFACservice.DayNumber='{{#expr: {{#time: N|{{Timezone}}}} {{{3|}}} {{{4|}}}}}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent}}<p></p></center>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 8: Line 8:
 
<td colspan="1">
 
<td colspan="1">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
−
{{#arraymap: AUT,BR1,BR2,BST,CV,DPA,DPB,DPC,FZ,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FS-S,CCECFF;FS-J,CCECFF;|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
−
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
+
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),scheduleRESservice.Color,GROUP_CONCAT(DISTINCT residentMGH.full_name)
−
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtable}}
+
|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>
 
<td colspan="1">
 
<td colspan="1">
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fel/Elec|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fel/Elec|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
−
{{#arraymap: AUT,BR1,BR2,BST,CV,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
+
{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FS-S,CCECFF;FS-J,CCECFF;|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
−
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name
+
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name,residentMGH.pageid
−
|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}}
+
|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>
 
<td colspan="1">
 
<td colspan="1">
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A |Attending}}||#000000|}} '''({{#switch: {{#time: N|{{Timezone}}}} | 1|2|3 = {{acc-FACdatetoday|+|0|+|0|}} | 4 = {{acc-FACdatetoday|+|1|-|3|}} | 5 = {{acc-FACdatetoday|+|1|-|3|}} | 6 = {{acc-FACdatetoday|+|0|+|0|}} | 7 = {{acc-FACdatetoday|+|1|-|6|}} | <center>{{ColorText|''Something went wrong!|yellow|red||}}<br>Please check <htmltag tagname="a" href="https://app.qgenda.com/Link/view?linkKey=9a12a547-f1b4-4998-bdca-acf3204a120e&landingPageId=40221bd9-4ac1-4a0b-8a00-da4f05d88f2e" target="_blank">QGenda.</htmltag>''<br><span style="color:red" class="glyphicon glyphicon-warning-sign" aria-hidden="true"></center> }})</center></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''</center></td></tr></table>
−
{{#switch: {{#time: N|{{Timezone}}}}  
+
{{#arraymap: AUT,AEAAAA;BR1,FF7E46;BR2,FF7E46;BST,E2EFDA;CV,7AD062;CA,04AAD1;CB,04AAD1;CC,04AAD1;DPA,EDB1FF;DPB,EDB1FF;DPC,EDB1FF;HN1,04E489;HN2,04E489;GI1,FFC30F;GI2,FFC30F;GI3,FFC30F;GUL,4FA4FF;GUS,4FA4FF;GYL,CD5EB6;GYS,CD5EB6;HPA,92E2AF;HPB,92E2AF;HG,92E2AF;NP,FCE4D6;OB,CD5EB6;PP,7AD062;RP,FFFF8D;FROZEN SECTION,CCECFF;FROZEN SECTION,CCECFF;|;|TaskAbbreviation|
−
| 1|2|3 = {{acc-FACtoday|+|0|+|0|}}  
+
{{#cargo_query: table=scheduleFACservice
−
| 4 = {{acc-FACtoday|+|1|-|3|}}  
+
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.Color,GROUP_CONCAT(scheduleFACservice.StaffFullName)
−
| 5 = {{acc-FACtoday|+|1|-|3|}}  
+
|group by=scheduleFACservice.Color
−
| 6 = {{acc-FACtoday|+|0|+|0|}}
+
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#expr: {{#time: N|{{Timezone}}}} {{{3|}}} {{{4|}}}}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} {{{1|}}} {{{2|}}} }}'
−
| 7 = {{acc-FACtoday|+|1|-|6|}}  
+
|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtable}}
−
| <center>{{ColorText|''Something went wrong!|yellow|red||}}<br>Please check <htmltag tagname="a" href="https://app.qgenda.com/Link/view?linkKey=9a12a547-f1b4-4998-bdca-acf3204a120e&landingPageId=40221bd9-4ac1-4a0b-8a00-da4f05d88f2e" target="_blank">QGenda.</htmltag>''<br><span style="color:red" class="glyphicon glyphicon-warning-sign" aria-hidden="true"></center>
+
|}}
−
}}
 
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>

Latest revision as of 15:29, July 30, 2020

Thursday
Jan 16Thursday
Jan 16
Resident
EAD,NXT
EXE
-
BBK,RSC
RRA,YQG
DSV
-
AKE
BBC,EHA
-
-
-
HUA
-
STO
MDR
-
-
JPB
VZA
-
LHV
-
BKV,JOS
VZA
FXR
RRA,YQG
-
-
Fel/Elec
-
-
SSB
-
-
KWA
-
OHA
-
SJB
-
-
-
-
-
-
-
-
-
VZA
RGJ
YXZ
-
EZR
VZA
-
-
-
-
Attending
REX
GUN
WSB
WSB
AMY
RMN
KMC
WCF
GLK
-
-
OLI
LHL
RPH
JAF
ARA
MPF
LHL
HNG
VER
SGS
SGS
Retrieved from "https://learn.mghpathology.org/index.php?title=acc-todayha&oldid=46592"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital