Template:NHLFTable: Difference between revisions

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=engy|from=ea_ew_in|where=epr='{{{Permit}}}'|limit=1|data=updated=updated}}{{#vardefine: update|{{#external_value:updated}}}}{{#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_in_desc|where=epr='{{{Permit}}}'|data=epr=epr,ewc=ewc,descr=descr,tonnes=tonnes}}

{{#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 is pulled from the returns for {{#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_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 }}'''.

{|class="wikitable sortable"

Line 19:

Line 15:

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=engy|from=ea_ew_in|where=epr='{{{Permit}}}'|limit=1|data=updated=updated}}{{#vardefine: update|{{#external_value:updated}}}}{{#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_in_desc|where=epr='{{{Permit}}}'|data=epr=epr,ewc=ewc,descr=descr,tonnes=tonnes}}
-{{#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 is pulled from the returns for {{#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_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 }}'''.
 {|class="wikitable sortable"
@@ Line 19: / Line 15: @@
 <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>