Template:NHLFTable: Difference between revisions

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:

{|class="wikitable sortable"

! [[EWC]] Code

! ~~Origin of Waste~~

! Description

! Tonnes In {{#for_external_table:<nowiki/>

{{!}}-

{{!}} {{{ewc}}}

{{!}} ~~[[:Category:~~{{{~~originregion~~}}}~~|{{{originregion}}}]]~~

{{!}} {{{descr}}}

{{!}} {{{~~tin~~}}}

{{!}} {{{tonnes}}}

}}

|}

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