Template:NHLFTable: Difference between revisions

No edit summary
mNo edit summary
 
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{#clear_external_data:}}
{{#clear_external_data:}}{{#get_db_data: db=mnk|from=ea_desc_in|where=epr='{{{Permit}}}'|limit=1|data=updated=updated}}{{#vardefine: update|{{#external_value:updated}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=ea_ton_in|where=epr='{{{Permit}}}'|data=opt=tin}}{{#vardefine: total| {{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=ea_desc_in|where=epr='{{{Permit}}}'|data=epr=epr,ewc=ewc,descr=descr,tonnes=tin}}
{{#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}}
==Waste Tonnage, [[EWC]] List==
The table shows a list of the [[Waste]] for the [[WML|Permit]] {{{Permit}}}, 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 last updated in {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''.


 
{|class="wikitable sortable"
{|class="wikitable"  
! [[EWC]] Code
![[EWC Code|EWC]]!!Description!!Tonnage Input
! Description
|- {{#if: {{#external_value:19_12_04}} | | style="display:none;" }}
! Tonnes In {{#for_external_table:<nowiki/>
| [[EWCChap19|19 12 04]]
{{!}}-
| plastic and rubber
{{!}} {{{ewc}}}
| style="text-align:right;"|{{formatnum:{{#external_value:19_12_04}}}}
{{!}} {{{descr}}}
|- {{#if: {{#external_value:19_12_05}} | | style="display:none;" }}
{{!}} {{{tonnes}}}
| [[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}}}}
|}
|}


<noinclude>
<noinclude>
Table to display the waste received by Landfill, if there is no waste of a type received then the row is hidden
Table to display the waste received listed by EWC Code with Description
</noinclude>
</noinclude>