Template:EfWTemplate: Difference between revisions

Revision as of 11:17, 4 February 2020

The query SELECT site,epr,operator,cap,tin17,tin18,cappct17,cappc18,r1,r1_date,r1_value,mwe,chp,techtype,funding FROM `efwdb` WHERE epr='{{{EPR}}}' is invalid (Error 1054: Unknown column 'tin17' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT site,epr,operator,cap,tin17,tin18,cappct17,cappc18,r1,r1_date,r1_value,mwe,chp,techtype,funding FROM `efwdb` WHERE epr='{{{EPR}}}' ).

Error: no local variable "site" has been set.
[[File:output_{{{id}}}.png\|400px\|center\|Site Location]]
Waste Licence	Error: no local variable "epr" has been set.
Operator	[[Error: no local variable "operator" has been set.]]
Operational Capacity	{{#external_style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;value:cap}}ktpa
Is site R1?	Error: no local variable "r1" has been set.
When was R1 Granted?	Error: no local variable "r1_date" has been set.
What was the R1 value	Error: no local variable "r1_value" has been set.
Electrical Capacity	Error: no local variable "mwe" has been set.MWe
CHP	Error: no local variable "chp" has been set.
Technology Approach	Error: no local variable "techtype" has been set.
Funding Type	[[Error: no local variable "funding" has been set.]]

Historical Tonnage Taken

Year	Tonnage In	Percent of Capacity
2017	Error: no local variable "tin17" has been set.	Error: no local variable "cappct17" has been set.%
2018	Error: no local variable "tin18" has been set.	Error: no local variable "cappc18" has been set.%

Summary site information collated from a variety of sources including, Monksleigh, Tolvik, EA, SEPA, NRW, DEFRA, BEIS and owner and developer websites

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
 {{#get_db_data: db=engy |from=efwdb |where=epr='{{{EPR}}}' |data=site=site,epr=epr,operator=operator,cap=cap,tin17=tin17,tin18=tin18,cappct17=cappct17,cappc18=cappc18,r1=r1,r1_date=r1_date,r1_value=r1_value,mwe=mwe,chp=chp,techtype=techtype,funding=funding}}
+<div style="float:right;">
-{|class="wikitable" class="float:right; margin-left:10px;"
+{|class="wikitable"
 |colspan="2" |<big>'''{{#external_value:site}}'''</big>
 |-
@@ Line 14: / Line 14: @@
 |-
 |Operational Capacity
-|{{formatnum:{{#external_value:cap}}}}ktpa
+|{{formatnum:{{#external_style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;style="caption-side:bottom;value:cap}}}}ktpa
 |-
 |Is site [[R1]]?
@@ Line 45: / Line 45: @@
 |2018||{{formatnum:{{#external_value:tin18}}}}||{{#external_value:cappc18}}%
 |}
 <small>Summary site information collated from a variety of sources including, Monksleigh, Tolvik, [[EA]], [[SEPA]], [[NRW]], [[DEFRA]], [[BEIS]] and owner and developer websites</small>
+</div>