Template:NHLFTable: Difference between revisions

Revision as of 10:11, 12 April 2022

Waste Tonnage, Permit Returns

The table shows a list of the Waste for the Permit {{{Permit}}}, 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	Description	Tonnes In

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

@@ Line 3: / Line 3: @@
 {{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{Permit}}}'|data=opt=sum(tin)}}
 {{#vardefine: total| {{#external_value:opt}}}}
-{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{Permit}}}'|data=ewc=ewc,originregion=originregion,tin=tin}}
+{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_in_desc|where=epr='{{{Permit}}}'|data=epr=epr,ewc=ewc,descr=descr,tonnes=tonnes}}
 ==Waste Tonnage, Permit Returns==
 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 updated on {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''.
@@ Line 9: / Line 9: @@
 {|class="wikitable sortable"
 ! [[EWC]] Code
-! Origin of Waste
+! Description
 ! Tonnes In {{#for_external_table:<nowiki/>
 {{!}}-
 {{!}} {{{ewc}}}
-{{!}} [[:Category:{{{originregion}}}|{{{originregion}}}]]
+{{!}} {{{descr}}}
-{{!}} {{{tin}}}
+{{!}} {{{tonnes}}}
 }}
 |}