Template:NHLFTable: Difference between revisions

From Wikiwaste
Bin52 (talk | contribs)
No edit summary
No edit summary
Line 1: Line 1:
{{#clear_external_data:}}
{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|limit=1|data=updated=updated}}
{{#get_db_data: db=engy |from=nhlandfill |where=permit='{{{Permit}}}' |data=20_03_01=20_03_01,19_12_09=19_12_09,19_12_12=19_12_12,19_12_05=19_12_05,19_12_04=19_12_04,20_03_07=20_03_07,20_01_08=20_01_08,20_01_38=20_01_38,20_02_01=20_02_01,20_03_03=20_03_03,19_12_11h=19_12_11h,20_02_02=20_02_02,19_12_10=19_12_10}}
{{#vardefine: update|{{#external_value:updated}}}}
{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}
{{#vardefine: total| {{#external_value:opt}}}}
{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=ewc=ewc,originregion=originregion,tin=tin}}
==Waste Tonnage, Permit Returns==
The table shows a list of the [[Waste]] for the [[WML|Permit]] {{{EPR}}}, that has arrived into sites as reported to the [[Regulator]] and then publicised in their reported statistics. {{#iferror: {{#var:update}}| The Data used is the most current | The Data was updated on {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''.


==Tonnage Handled==
{|class="wikitable sortable"
Only Waste Codes receiving over 5,000t are shown.
! [[EWC]] Code
 
! Origin of Waste
{|class="wikitable"  
! Tonnes In {{#for_external_table:<nowiki/>
![[EWC|EWC Code]]!!Description!!Tonnage Input
{{!}}-
|- {{#if: {{#external_value:19_12_04}} | | style="display:none;" }}
{{!}} {{{ewc}}}
| [[EWCChap19|19 12 04]]
{{!}} [[:Category:{{{originregion}}}|{{{originregion}}}]]
| plastic and rubber
{{!}} {{{tin}}}
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_04}}}}
}}
|- {{#if: {{#external_value:19_12_05}} | | style="display:none;" }}
| [[EWCChap19|19 12 05]]
| glass
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_05}}}}
|- {{#if: {{#external_value:19_12_09}} | | style="display:none;" }}
| [[EWCChap19|19 12 09]]
| minerals (for example sand, stones)
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_09}}}}
|- {{#if: {{#external_value:19_12_10}} | | style="display:none;" }}
| [[EWCChap19|19 12 10]]
| combustible waste (refuse derived fuel)
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_10}}}}
|- {{#if: {{#external_value: 19_12_11h}} | | style="display:none;" }}
| [[EWCChap19|19 12 11*]]
| other wastes (including mixtures of materials) from mechanical treatment of waste containing hazardous substances
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_11h}}}}
|- {{#if: {{#external_value:19_12_12}} | | style="display:none;" }}
| [[EWCChap19|19 12 12]]
| other wastes (including mixtures of materials) from mechanical treatment of wastes other than those mentioned in 19 12 11
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_12}}}}
|- {{#if: {{#external_value:20_01_08}} | | style="display:none;" }}
| [[EWCChap20|20 01 08]]
| biodegradable kitchen and canteen waste
| style="text-align:right;"|{{formatnum:{{#external_value:20_01_08}}}}
|- {{#if: {{#external_value:20_01_38}} | | style="display:none;" }}
| [[EWCChap20|20 01 38]]
| wood other than that mentioned in 20 01 37
| style="text-align:right;"|{{formatnum:{{#external_value:20_01_38}}}}
|- {{#if: {{#external_value:20_02_01}} | | style="display:none;" }}
| [[EWCChap20|20 02 01]]
| biodegradable waste
| style="text-align:right;"|{{formatnum:{{#external_value:20_02_01}}}}
|- {{#if: {{#external_value:20_02_02}} | | style="display:none;" }}
| [[EWCChap20|20 02 02]]
| soil and stones
| style="text-align:right;"|{{formatnum:{{#external_value:20_02_02}}}}
|- {{#if: {{#external_value:20_03_01}} | | style="display:none;" }}
| [[EWCChap20|20 03 01]]
| mixed municipal waste
| style="text-align:right;"|{{formatnum:{{#external_value:20_03_01}}}}
|- {{#if: {{#external_value:20_03_03}} | | style="display:none;" }}
| [[EWCChap20|20 03 03]]
| street-cleaning residues
| style="text-align:right;"|{{formatnum:{{#external_value:20_03_03}}}}
|- {{#if: {{#external_value:20_03_07}} | | style="display:none;" }}
| [[EWCChap20|20 03 07]]
| bulky waste
| style="text-align:right;"|{{formatnum:{{#external_value:20_03_07}}}}
|}
|}



Revision as of 08:36, 12 April 2022



Waste Tonnage, Permit Returns

The table shows a list of the Waste for the Permit {{{EPR}}}, that has arrived into sites as reported to the Regulator and then publicised in their reported statistics. The Data used is the most current. The total reported tonnage arriving at the site was: 0t.

EWC Code Origin of Waste Tonnes In


Table to display the waste received by Landfill, if there is no waste of a type received then the row is hidden