Template:QualOUT: Difference between revisions

Latest revision as of 09:37, 20 April 2022

Qualifying MRF Tonnage Sent Out

During Error: no local variable "year" has been set. the site removedExpression error: Unexpected round operator.t of qualifying material, as broken down below.

Quarter	Material	Tonnage	Number of Samples	Total Samples Weight	Target Material (%)	Non Target Material (%)	Non Recycleable Material (%)

@@ Line 1: / Line 1: @@
-==Qualifying Waste Leaving Site==
+{{#clear_external_data:}}
+{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}
+==[[Qualifying MRF]] Tonnage Sent Out==
+During {{#var:year}} the site removed'''{{formatnum: {{#expr: {{#var:total}} round 0}} }}t''' of qualifying material, as broken down below.
+{{#clear_external_data:}}
+{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|data=quarter=quarter,tonnes=tonnes,material=material,samples=samples,samplewt=samplewt,target=target,totalnontgt=totalnontgt,totalnonrecy=totalnonrecy}}
+{|class="wikitable sortable"
+! Quarter
+! Material
+! Tonnage
+! Number of Samples
+! Total Samples Weight
+! Target Material (%)
+! Non Target Material (%)
+! Non Recycleable Material (%){{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} {{{quarter}}}
+{{!}} {{{material}}}
+{{!}} {{{tonnes}}}
+{{!}} {{{samples}}}
+{{!}} {{{samplewt}}}
+{{!}} {{{target}}}
+{{!}} {{{totalnontgt}}}
+{{!}} {{{totalnonrecy}}}
+}}
+|}