Template:NHLFTable: Difference between revisions

Revision as of 10:07, 17 October 2023

The query SELECT updated FROM `db_ea`.`ea_desc_in` WHERE epr='{{{Permit}}}' LIMIT 1 is invalid (Error 1049: Unknown database 'db_ea' Function: EDConnectorRdbms::fetch Query: SELECT updated FROM `db_ea`.`ea_desc_in` WHERE epr='{{{Permit}}}' LIMIT 1 ).The query SELECT tin FROM `db_ea`.`ea_ton_in` WHERE epr='{{{Permit}}}' is invalid (Error 1049: Unknown database 'db_ea' Function: EDConnectorRdbms::fetch Query: SELECT tin FROM `db_ea`.`ea_ton_in` WHERE epr='{{{Permit}}}' ).The query SELECT epr,ewc,descr,tin FROM `db_ea`.`ea_desc_in` WHERE epr='{{{Permit}}}' is invalid (Error 1049: Unknown database 'db_ea' Function: EDConnectorRdbms::fetch Query: SELECT epr,ewc,descr,tin FROM `db_ea`.`ea_desc_in` WHERE epr='{{{Permit}}}' ).

Waste Tonnage, EWC List

The table shows a list of the Waste for the Permit {{{Permit}}}, that has arrived into sites as reported to the Regulator and then publicised in their reported statistics. The Data used is the most current. The total reported tonnage arriving at the site was: Expression error: Unexpected < operator.t.

EWC Code	Description	Tonnes In

Table to display the waste received listed by EWC Code with Description

@@ 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_desc_in|where=epr='{{{Permit}}}'|data=opt=sum(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=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}}
 ==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 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 }}'''.