Template:QualIN: Difference between revisions

From Wikiwaste
No edit summary
No edit summary
Line 1: Line 1:
{{#clear_external_data:}}
{{#clear_external_data:}}
{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}{{#clear_external_data:}}
{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}
==Qualifying Waste Entering Site==
==Qualifying Waste Entering Site==
During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 2}} }}t as qualifying material, as broken down below.
During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 2}} }}t as qualifying material, as broken down below.
{{#clear_external_data:}}
{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=quarter=quarter,origdestla=origdestla,ewc=ewc,descript=descript,tonnes=tonnes,supplier=supplier,samples=samples,weight=weight,glass=glass,metal=metal,paper=paper,plastic=plastic,total=total,totalsd=totalsd,nontgt=nontgt,nonrecyle=nonrecyle,country=country,typeofsupply=typeofsupply,eprsupply=eprsupply}}
{|class="wikitable sortable"
! Quarter
! Supplier
! Tonnage
! Number of Samples
! Total Samples Weight
! Glass (%)
! Metal (%)
! Paper (%)
! Plastic (%)
! Overall (%)
! Non Target Material (%)
! Non Recycleable Material (%){{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{quarter}}}
{{!}} {{{supplier}}}
{{!}} {{{tonnes}}}
{{!}} {{{samples}}}
{{!}} {{{weight}}}
{{!}} {{{glass}}}
{{!}} {{{metal}}}
{{!}} {{{paper}}}
{{!}} {{{plastic}}}
{{!}} {{{total}}}
{{!}} {{{nontgt}}}
{{!}} {{{nonrecyle}}}
}}
|}

Revision as of 17:32, 15 December 2021


Qualifying Waste Entering Site

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


Quarter Supplier Tonnage Number of Samples Total Samples Weight Glass (%) Metal (%) Paper (%) Plastic (%) Overall (%) Non Target Material (%) Non Recycleable Material (%)