Template:QualOUT: Difference between revisions

Template:QualOUT (view source)

Revision as of 12:49, 15 December 2021

606 bytes added , 15 December 2021

no edit summary

VisualWikitext

Admin

Bureaucrats, Interface administrators, Administrators

4,359

edits

@@ Line 1: / Line 1: @@
-{{#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}}}}{{#clear_external_data:}}
+{{#clear_external_data:}}
-==Qualifying Waste Leaving Site==
+{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: yr|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: tot|{{#external_value:ton}}}}
-During {{#var:year}} the site removed {{formatnum: {{#expr: {{#var:total}} round 2}} }}t as qualifying material, as broken down below.
+==Qualifying Waste Entering Site==
+During {{#var:yr}} the site received {{formatnum: {{#expr: {{#var:tot}} round 2}} }}t as 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}}}
+}}
+|}