Template:EfWTemplate: Difference between revisions
Arctellion (talk | contribs) No edit summary |
Arctellion (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{#clear_external_data:}} | {{#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}} | {{#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}} | ||
{|class="wikitable" | {|class="wikitable" | ||
| Line 15: | Line 15: | ||
|- | |- | ||
|Operational Capacity | |Operational Capacity | ||
|{{#external_value:cap}}tpa | |{{formatnum:{{#external_value:cap}}}}tpa | ||
|- | |- | ||
|colspan="2"| | |colspan="2"| | ||
| Line 21: | Line 21: | ||
| ||2017 || 2018 | | ||2017 || 2018 | ||
|- | |- | ||
|Tonnage In||{{#external_value:tin17}}||{{#external_value:tin18}} | |Tonnage In||{{formatnum:{{#external_value:tin17}}}}||{{formatnum:{{#external_value:tin18}}}} | ||
|- | |- | ||
|Percent of Capacity||{{#external_value:cappct17}}||{{#external_value:cappc18}} | |Percent of Capacity||{{#external_value:cappct17}}%||{{#external_value:cappc18}}% | ||
|} | |} | ||
|- | |- | ||
| Line 31: | Line 31: | ||
|When was R1 Granted? | |When was R1 Granted? | ||
|{{#external_value:r1_date}} | |{{#external_value:r1_date}} | ||
|- | |||
|What was the R1 value | |||
|{{#external_value:r1_value}} | |||
|- | |- | ||
|Electrical Capacity | |Electrical Capacity | ||
|{{#external_value:mwe}} | |{{#external_value:mwe}} | ||
|- | |||
|[[CHP]] | |||
|{{#external_value:chp}} | |||
|- | |||
|Technology Approach | |||
|{{#external_value:techtype}} | |||
|- | |||
|Funding Type | |||
|[[{{#external_value:funding}}]] | |||
|} | |} | ||
Revision as of 11:22, 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.tpa | |||||||||
| ||||||||||
| 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. | |||||||||
| 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.]] | |||||||||