Template:EfWTemplate: Difference between revisions

Revision as of 11:30, 27 January 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}}}' ).

[[File:output_{{{id}}}.png\|400px\|center\|Site Location]]
Site Name	Error: no local variable "site" has been set.
Waste Licence	Error: no local variable "epr" has been set.
Operator	[[Error: no local variable "operator" has been set.]]
Operational Capacity	Error: no local variable "cap" has been set.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 Capcity
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.%

@@ Line 15: / Line 15: @@
 |-
 |Operational Capacity
-|{{formatnum:{{#external_value:cap}}}}tpa
+|{{formatnum:{{#external_value:cap}}}}ktpa
-|-
-|colspan="2"|
-{|class="wikitable"
-| ||2017 || 2018
-|-
-|Tonnage In||{{formatnum:{{#external_value:tin17}}}}||{{formatnum:{{#external_value:tin18}}}}
-|-
-|Percent of Capacity||{{#external_value:cappct17}}%||{{#external_value:cappc18}}%
-|}
 |-
 |Is site [[R1]]?
 |{{#external_value:r1}}
 |-
-|When was R1 Granted?
+|When was [[R1]] Granted?
 |{{#external_value:r1_date}}
 |-
-|What was the R1 value
+|What was the [[R1]] value
 |{{#external_value:r1_value}}
 |-
@@ Line 46: / Line 37: @@
 |Funding Type
 |[[{{#external_value:funding}}]]
+|}
+===Historical Tonnage Taken===
+{|class="wikitable"
+! Year !! Tonnage In !! Percent of Capcity
+|-
+|2017||{{formatnum:{{#external_value:tin17}}}}||{{#external_value:cappct17}}%
+|-
+|2018||{{formatnum:{{#external_value:tin18}}}}||{{#external_value:cappc18}}%
 |}