4,359
edits
Template:QualOUT: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}} | {{#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}}}} | ||
{{#vardefine: year|{{#external_value: year}}}} | |||
{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfout2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: | |||
==Qualifying Waste Leaving Site== | ==Qualifying Waste Leaving Site== | ||
During {{#var:year}} the site received {{formatnum: {{#expr: {{#var: | During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 0}} }}t as qualifying material, as broken down below. | ||
{{#clear_external_data:}} | {{#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}} | {{#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}} | ||