Template:NHLFTable - Revision history

Admin at 16:38, 4 March 2025

2025-03-04T16:38:46Z

← Older revision		Revision as of 16:38, 4 March 2025
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==		==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 }}'''.		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 }}'''.

Northern Chick: /* Waste Tonnage, EWC List */

2023-10-25T10:29:49Z

Waste Tonnage, EWC List

← Older revision		Revision as of 10:29, 25 October 2023
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=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==		==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 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 }}'''.		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 }}'''.

	{\|class="wikitable sortable"		{\|class="wikitable sortable"

Admin at 10:41, 17 October 2023

2023-10-17T10:41:57Z

← Older revision		Revision as of 10:41, 17 October 2023
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=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==		==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 }}'''.		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 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 }}'''.

	{\|class="wikitable sortable"		{\|class="wikitable sortable"

Admin at 10:07, 17 October 2023

2023-10-17T10:07:01Z

← Older revision		Revision as of 10:07, 17 October 2023
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==		==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 }}'''.		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 }}'''.

Admin at 09:23, 17 October 2023

2023-10-17T09:23:05Z

← Older revision		Revision as of 09:23, 17 October 2023
Line 1:		Line 1:
	{{#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~~}}		{{#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}}
	==Waste Tonnage, [[EWC]] List==		==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 }}'''.		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 }}'''.

Admin at 11:49, 8 June 2022

2022-06-08T11:49:46Z

← Older revision		Revision as of 11:49, 8 June 2022
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"		{\|class="wikitable sortable"
Line 19:		Line 15:

	<noinclude>		<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>		</noinclude>

Admin at 10:11, 12 April 2022

2022-04-12T10:11:34Z

← Older revision		Revision as of 10:11, 12 April 2022
Line 3:		Line 3:
	{{#clear_external_data:}}{{#get_db_data: db=engy\|from=ea_ew_in\|where=epr='{{{Permit}}}'\|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}}}}		{{#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~~}}		{{#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==		==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 }}'''.		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 }}'''.
Line 9:		Line 9:
	{\|class="wikitable sortable"		{\|class="wikitable sortable"
	! [[EWC]] Code		! [[EWC]] Code
	! ~~Origin of Waste~~		! Description
	! Tonnes In {{#for_external_table:<nowiki/>		! Tonnes In {{#for_external_table:<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{ewc}}}		{{!}} {{{ewc}}}
	{{!}} ~~[[:Category:~~{{{~~originregion~~}}}~~\|{{{originregion}}}]]~~		{{!}} {{{descr}}}
	{{!}} {{{~~tin~~}}}		{{!}} {{{tonnes}}}
	}}		}}
	\|}		\|}

Admin at 08:38, 12 April 2022

2022-04-12T08:38:07Z

← Older revision		Revision as of 08:38, 12 April 2022
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}}}}		{{#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}}}}		{{#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==		==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"		{\|class="wikitable sortable"

Admin at 08:36, 12 April 2022

2022-04-12T08:36:38Z

@@ Line 1: / Line 1: @@
-{{#clear_external_data:}}
+{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|limit=1|data=updated=updated}}
-{{#get_db_data: db=engy |from=nhlandfill |where=permit='{{{Permit}}}' |data=20_03_01=20_03_01,19_12_09=19_12_09,19_12_12=19_12_12,19_12_05=19_12_05,19_12_04=19_12_04,20_03_07=20_03_07,20_01_08=20_01_08,20_01_38=20_01_38,20_02_01=20_02_01,20_03_03=20_03_03,19_12_11h=19_12_11h,20_02_02=20_02_02,19_12_10=19_12_10}}
+{{#vardefine: update|{{#external_value:updated}}}}
-==Tonnage Handled==
+{|class="wikitable sortable"
-Only Waste Codes receiving over 5,000t are shown.
+! [[EWC]] Code
+! Origin of Waste
-{|class="wikitable"
+! Tonnes In {{#for_external_table:<nowiki/>
-![[EWC|EWC Code]]!!Description!!Tonnage Input
+{{!}}-
-|- {{#if: {{#external_value:19_12_04}} | | style="display:none;" }}
+{{!}} {{{ewc}}}
-| [[EWCChap19|19 12 04]]
+{{!}} [[:Category:{{{originregion}}}|{{{originregion}}}]]
-| plastic and rubber
+{{!}} {{{tin}}}
-| style="text-align:right;"|{{formatnum:{{#external_value:19_12_04}}}}
+}}
 |}

Bin52 at 09:17, 2 March 2022

2022-03-02T09:17:46Z

← Older revision		Revision as of 09:17, 2 March 2022
Line 1:		Line 1:
	{{#clear_external_data:}}		{{#clear_external_data:}}
	{{#get_db_data: db=engy \|from=nhlandfill \|where=permit='{{{Permit}}}' \|data=20_03_01=20_03_01,19_12_09=19_12_09,19_12_12=19_12_12,19_12_05=19_12_05,19_12_04=19_12_04,20_03_07=20_03_07,20_01_08=20_01_08,20_01_38=20_01_38,20_02_01=20_02_01,20_03_03=20_03_03,19_12_11h=19_12_11h,20_02_02=20_02_02,19_12_10=19_12_10}}		{{#get_db_data: db=engy \|from=nhlandfill \|where=permit='{{{Permit}}}' \|data=20_03_01=20_03_01,19_12_09=19_12_09,19_12_12=19_12_12,19_12_05=19_12_05,19_12_04=19_12_04,20_03_07=20_03_07,20_01_08=20_01_08,20_01_38=20_01_38,20_02_01=20_02_01,20_03_03=20_03_03,19_12_11h=19_12_11h,20_02_02=20_02_02,19_12_10=19_12_10}}

			==Tonnage Handled==
			Only Waste Codes receiving over 5,000t are shown.

	{\|class="wikitable"		{\|class="wikitable"