Template:NHLFTable: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 1:

{{#clear_external_data:}}{{#get_db_data: db=~~engy~~|from=~~ea_ew_in~~|where=epr='{{{Permit}}}'|limit=1|data=updated=updated}}

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

{{#vardefine: update|{{#external_value:updated}}}}

==Waste Tonnage, [[EWC]] List==

{{#clear_external_data:}}{{#get_db_data: db=~~engy~~|from=~~ea_ew_in~~|where=epr='{{{Permit}}}'|data=opt=~~sum(~~tin)}}

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

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

==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 }}'''.

{|class="wikitable sortable"

! [[EWC]] Code

! ~~Origin of Waste~~

! Description

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

{{!}}-

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

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

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

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

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

}}

|}

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>

@@ Line 1: / Line 1: @@
-{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{Permit}}}'|limit=1|data=updated=updated}}
+{{#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}}
-{{#vardefine: update|{{#external_value:updated}}}}
+==Waste Tonnage, [[EWC]] List==
-{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{Permit}}}'|data=opt=sum(tin)}}
+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 }}'''.
-{{#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}}
-==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 }}'''.
 {|class="wikitable sortable"
 ! [[EWC]] Code
-! Origin of Waste
+! Description
 ! Tonnes In {{#for_external_table:<nowiki/>
 {{!}}-
 {{!}} {{{ewc}}}
-{{!}} [[:Category:{{{originregion}}}|{{{originregion}}}]]
+{{!}} {{{descr}}}
-{{!}} {{{tin}}}
+{{!}} {{{tonnes}}}
 }}
 |}
 <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>