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,chp=chp,techtype=techtype,funding=funding}} | {{#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="wikitable" | |||
|colspan="2"|[[File:output_{{{id}}}.png|400px|center|Site Location]] | |colspan="2"|[[File:output_{{{id}}}.png|400px|center|Site Location]] | ||
|- | |- | ||
| Line 46: | Line 45: | ||
|2018||{{formatnum:{{#external_value:tin18}}}}||{{#external_value:cappc18}}% | |2018||{{formatnum:{{#external_value:tin18}}}}||{{#external_value:cappc18}}% | ||
|} | |} | ||
</div> | |||
Revision as of 10:41, 30 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}}}' ).
|colspan="2"|[[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.% |