Template:MRFSidebar: Difference between revisions

Latest revision as of 07:07, 25 April 2022

Error: no local variable "site" has been set.
Error: no local variable "operator" has been set.
[[File:Mrf{{{id}}}.png\|400px\|center\|Site Location]] See Qualifying MRF → page for a larger UK Wide map.

Data	2020
Tonnage Summary
EA Tonnage IN	Expression error: Unexpected round operator.
EA Tonnage OUT	Expression error: Unexpected round operator.
Qualifying IN	Expression error: Unexpected < operator.
Qualifying OUT	Expression error: Unexpected < operator.

@@ Line 7: / Line 7: @@
 |Operator|{{#external_value:operator}}
 |-
-|}
+|colspan="2"|[[File:Mrf{{{id}}}.png|400px|center|Site Location]]
-{{#clear_external_data:}}
+See [[Qualifying Material Recovery Facilities|Qualifying MRF →]] page for a larger UK Wide map.
-{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=inq1=inq1,inq2=inq2,inq3=inq3,inq4=inq4,outq1=outq1,outq2=outq2, outq3=outq3,outq4=outq4}}
+|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=inq1=inq1,inq2=inq2,inq3=inq3,inq4=inq4,totin=(inq1+inq2+inq3+inq4)}}{{#vardefine:qualin|{{#external_value:totin}}}}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=outq1=outq1,outq2=outq2,outq3=outq3,outq4=outq4,totout=(outq1+outq2+outq3+outq4)}}{{#vardefine:qualout|{{#external_value:totout}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eain|{{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_out|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eaout|{{#external_value:opt}}}}<small>
-{{#vardefine: totin| {{#external_value:inq1}}+{{#external_value:inq2}}+{{#external_value:inq3}}+{{#external_value:inq4}} }}
-{{#vardefine: totout|{{#expr: {{#external_value:outq1}}+{{#external_value:outq1}}+{{#external_value:outq1}}+{{#external_value:outq1}} }}}}
 {|class="wikitable"
-|colspan="2"|Tonnage IN
+|colspan="2"|'''Tonnage Summary'''
 |-
-|Quarter 1 || {{#external_value:inq1}}
+!Data !! 2020
 |-
-|Quarter 2 || {{#external_value:inq2}}
+|EA Tonnage IN||style="text-align:right;"| {{formatnum: {{#expr: {{#var:eain}} round 2 }} }}
 |-
-|Quarter 3 || {{#external_value:inq3}}
+|EA Tonnage OUT ||style="text-align:right;"| {{formatnum: {{#expr: {{#var:eaout}} round 2}} }}
 |-
-|Quarter 4 || {{#external_value:inq4}}
+|Qualifying IN ||style="text-align:right;"| {{formatnum: {{#expr: {{#var:qualin}} round 2 }} }}
 |-
-|Total || {{#var: totin}}
+|Qualifying OUT ||style="text-align:right;"| {{formatnum: {{#expr: {{#var:qualout}} round 2 }} }}
 |-
-|}
+|}</small>
 </div>