Template:NHLFTable: Difference between revisions

Line 1:

{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{~~EPR~~}}}'|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='{{{~~EPR~~}}}'|data=opt=sum(tin)}}

{{#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='{{{~~EPR~~}}}'|data=ewc=ewc,originregion=originregion,tin=tin}}

{{#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]] {{{~~EPR~~}}}, 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 }}'''.

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 1: / Line 1: @@
-{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|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='{{{EPR}}}'|data=opt=sum(tin)}}
+{{#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='{{{EPR}}}'|data=ewc=ewc,originregion=originregion,tin=tin}}
+{{#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]] {{{EPR}}}, 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 }}'''.
+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"