Template:NHLFTable: Difference between revisions

Line 1:

{{#clear_external_data:}}{{#get_db_data: db=mnk|from=~~db_ea.~~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=~~db_ea.~~ea_ton_in|where=epr='{{{Permit}}}'|data=opt=tin}}{{#vardefine: total| {{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=~~db_ea.~~ea_desc_in|where=epr='{{{Permit}}}'|data=epr=epr,ewc=ewc,descr=descr,tonnes=tin}}

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

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

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

@@ Line 1: / Line 1: @@
-{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.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=db_ea.ea_ton_in|where=epr='{{{Permit}}}'|data=opt=tin}}{{#vardefine: total| {{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_desc_in|where=epr='{{{Permit}}}'|data=epr=epr,ewc=ewc,descr=descr,tonnes=tin}}
+{{#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}}
 ==Waste Tonnage, [[EWC]] List==
 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 }}'''.