Template:QualIN - Revision history

Bin52 at 15:36, 20 April 2022

2022-04-20T15:36:34Z

← Older revision		Revision as of 15:36, 20 April 2022
Line 1:		Line 1:
	{{#clear_external_data:}}		{{#clear_external_data:}}
	{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}		{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}
	==Qualifying ~~Waste Entering Site~~==		==[[Qualifying MRF]] Tonnage Received==
	During {{#var:year}} the site received '''{{formatnum: {{#expr: {{#var:total}} round 0}} }}t''' as qualifying material, as broken down below.		During {{#var:year}} the site received '''{{formatnum: {{#expr: {{#var:total}} round 0}} }}t''' as qualifying material, as broken down below.
	{{#clear_external_data:}}		{{#clear_external_data:}}

Admin at 11:36, 24 January 2022

2022-01-24T11:36:01Z

← Older revision		Revision as of 11:36, 24 January 2022
Line 11:		Line 11:
	! Tonnage		! Tonnage
	! Number of Samples		! Number of Samples
	! Total Samples Weight		! Total Samples Weight (kg)
	! Glass (%)		! Glass (%)
	! Metal (%)		! Metal (%)

Admin at 19:35, 15 December 2021

2021-12-15T19:35:11Z

← Older revision		Revision as of 19:35, 15 December 2021
Line 2:		Line 2:
	{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}		{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}
	==Qualifying Waste Entering Site==		==Qualifying Waste Entering Site==
	During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 0}} }}t as qualifying material, as broken down below.		During {{#var:year}} the site received '''{{formatnum: {{#expr: {{#var:total}} round 0}} }}t''' as qualifying material, as broken down below.
	{{#clear_external_data:}}		{{#clear_external_data:}}
	{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=quarter=quarter,origdestla=origdestla,ewc=ewc,descript=descript,tonnes=tonnes,supplier=supplier,samples=samples,weight=weight,glass=glass,metal=metal,paper=paper,plastic=plastic,total=total,totalsd=totalsd,nontgt=nontgt,nonrecyle=nonrecyle,country=country,typeofsupply=typeofsupply,eprsupply=eprsupply}}		{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=quarter=quarter,origdestla=origdestla,ewc=ewc,descript=descript,tonnes=tonnes,supplier=supplier,samples=samples,weight=weight,glass=glass,metal=metal,paper=paper,plastic=plastic,total=total,totalsd=totalsd,nontgt=nontgt,nonrecyle=nonrecyle,country=country,typeofsupply=typeofsupply,eprsupply=eprsupply}}

Admin at 19:24, 15 December 2021

2021-12-15T19:24:43Z

← Older revision		Revision as of 19:24, 15 December 2021
Line 22:		Line 22:
	{{!}} {{{quarter}}}		{{!}} {{{quarter}}}
	{{!}} {{{supplier}}}		{{!}} {{{supplier}}}
	{{!}} ~~{{formatnum: {{#expr:~~ {{{tonnes}}} ~~round 0}} }}t~~		{{!}} {{{tonnes}}}
	{{!}} {{{samples}}}		{{!}} {{{samples}}}
	{{!}} {{{weight}}}		{{!}} {{{weight}}}

Admin at 19:20, 15 December 2021

2021-12-15T19:20:09Z

← Older revision		Revision as of 19:20, 15 December 2021
Line 22:		Line 22:
	{{!}} {{{quarter}}}		{{!}} {{{quarter}}}
	{{!}} {{{supplier}}}		{{!}} {{{supplier}}}
	{{!}} {{{tonnes}}}		{{!}} {{formatnum: {{#expr: {{{tonnes}}} round 0}} }}t
	{{!}} {{{samples}}}		{{!}} {{{samples}}}
	{{!}} {{{weight}}}		{{!}} {{{weight}}}

Admin at 18:52, 15 December 2021

2021-12-15T18:52:18Z

← Older revision		Revision as of 18:52, 15 December 2021
Line 2:		Line 2:
	{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}		{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}
	==Qualifying Waste Entering Site==		==Qualifying Waste Entering Site==
	During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 2}} }}t as qualifying material, as broken down below.		During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 0}} }}t as qualifying material, as broken down below.
	{{#clear_external_data:}}		{{#clear_external_data:}}
	{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=quarter=quarter,origdestla=origdestla,ewc=ewc,descript=descript,tonnes=tonnes,supplier=supplier,samples=samples,weight=weight,glass=glass,metal=metal,paper=paper,plastic=plastic,total=total,totalsd=totalsd,nontgt=nontgt,nonrecyle=nonrecyle,country=country,typeofsupply=typeofsupply,eprsupply=eprsupply}}		{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=quarter=quarter,origdestla=origdestla,ewc=ewc,descript=descript,tonnes=tonnes,supplier=supplier,samples=samples,weight=weight,glass=glass,metal=metal,paper=paper,plastic=plastic,total=total,totalsd=totalsd,nontgt=nontgt,nonrecyle=nonrecyle,country=country,typeofsupply=typeofsupply,eprsupply=eprsupply}}

Admin at 17:32, 15 December 2021

2021-12-15T17:32:37Z

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}{{#clear_external_data:}}
+{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}
 ==Qualifying Waste Entering Site==
 During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 2}} }}t as qualifying material, as broken down below.

Admin at 08:41, 15 December 2021

2021-12-15T08:41:51Z

← Older revision		Revision as of 08:41, 15 December 2021
Line 2:		Line 2:
	{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}{{#clear_external_data:}}		{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|limit=1\|data=year=year}}{{#vardefine: year\|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy\|from=mrfin2020\|where=epr='{{{EPR}}}'\|data=ton=sum(tonnes)}}{{#vardefine: total\|{{#external_value:ton}}}}{{#clear_external_data:}}
	==Qualifying Waste Entering Site==		==Qualifying Waste Entering Site==
	During {{#var:year}} the site received {{#var:total}} ~~tonnes~~ as qualifying material, as broken down below.		During {{#var:year}} the site received {{formatnum: {{#expr: {{#var:total}} round 2}} }}t as qualifying material, as broken down below.

Admin at 08:41, 15 December 2021

2021-12-15T08:41:00Z

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy
+{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}{{#clear_external_data:}}
 ==Qualifying Waste Entering Site==
 During {{#var:year}} the site received {{#var:total}} tonnes as qualifying material, as broken down below.

Admin: /* Qualifying Waste Entering Site */

2021-12-15T08:38:42Z

Qualifying Waste Entering Site

← Older revision		Revision as of 08:38, 15 December 2021
Line 1:		Line 1:
			{{#clear_external_data:}}
			{{#get_db_data: db=engy
			\|from=mrfin2020
			\|where=epr='{{{EPR}}}'
			\|limit=1
			\|data=year=year
			}}{{#vardefine: year\|{{#externa_value: year}}}}
			{{#clear_external_data:}}
			{{#get_db_data: db=engy
			\|from=mrfin2020
			\|where=epr='{{{EPR}}}'
			\|data=ton=sum(tonnes)
			}}{{#vardefine: total\|{{#external_value:ton}}}}
			{{#clear_external_data:}}
	==Qualifying Waste Entering Site==		==Qualifying Waste Entering Site==
	~~data to follow~~		During {{#var:year}} the site received {{#var:total}} tonnes as qualifying material, as broken down below.