Template:NHLFTable: Difference between revisions

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}}}}
|}
|}